Jump to content

Playon

Members
  • Posts

    4
  • Joined

  • Last visited

    Never
  • Donations

    0.00 GBP 

Posts posted by Playon

  1. For trinity core patch ( wowarmory_arena_chart.patch ) after changeset 9871:

               /** World of Warcraft Armory **/
               uint32 maxChartID;
    [color=red]-           QueryResult_AutoPtr result = CharacterDatabase.PQuery("SELECT MAX(gameid) FROM armory_game_chart");[/color]
    [color=seagreen]+           QueryResult result = CharacterDatabase.PQuery("SELECT MAX(gameid) FROM armory_game_chart");[/color]
               if(!result)
                   maxChartID = 0;

    For wowarmory_patch.patch :

       if (type == 3)    // Do not write same bosses many times - just update counter.
       {
           uint8 Difficulty = GetMap()->GetDifficulty();
    [color="red"]-        QueryResult_AutoPtr result = CharacterDatabase.PQuery("SELECT counter FROM character_feed_log WHERE guid='%u' AND type=3 AND data='%u' AND difficulty='%u' LIMIT 1", pGuid, data, Difficulty);[/color]
    [color="seagreen"]+        QueryResult result = CharacterDatabase.PQuery("SELECT counter FROM character_feed_log WHERE guid='%u' AND type=3 AND data='%u' AND difficulty='%u' LIMIT 1", pGuid, data, Difficulty);[/color]
           if (result)
           {
               CharacterDatabase.PExecute("UPDATE character_feed_log SET counter=counter+1, date=UNIX_TIMESTAMP(NOW()) WHERE guid='%u' AND type=3 AND data='%u' AND difficulty='%u' LIMIT 1", pGuid, data, Difficulty);
           }
           else
           {
               CharacterDatabase.PExecute("INSERT INTO character_feed_log (guid, type, data, date, counter, difficulty) VALUES('%u', '%d', '%u', UNIX_TIMESTAMP(NOW()), 1, '%u')", pGuid, type, data, Difficulty);
           }
       }
    

  2. It looks like most everything is working! Looks great, although I did find a few things: the Statistics tab on the character view screen doesn't contain any info, I get the XML parsing error, which tells me that there is no info to display. I get this error in debug log.

     Characters::BuildCharacter : player 1 (Burrfoot) does not have any data in `armory_character_stats` table (SQL update to characters DB not applied?)
    

    The thing is, the update WAS applied...when looking through the update provided in the Tools folder for trinity, I found no reference to the table mentioned in the error.

    Don`t forget to apply the tools/trinity_core/characters_patch.sql to characters DB.

    This did the trick, compiled fine on single and mutli core, thank you!

    Your welcome!

  3. Complied fine TC2 rev. 9709 with these changes:

    +            else
    +            {
    +                maxChartID = (*result)[0].GetUInt32();
    [color=Red]-                delete result;[/color]
    [color=SeaGreen]+                result.release();[/color]
    +            }
    
    
    
    +                if (plTeamID == winner_arena_team->GetId())
    +                {
    +                    changeType = 1; //win
    [color=Red]-                    [/color][color=Red]resultRating = winner_rating;[/color]
    [color=SeaGreen]+                    resultRating = winner_team_rating;[/color]
    +                    resultTeamID = plTeamID;
    +                    ratingChange = winner_change;
    +                }
    +                else
    +                {
    +                    changeType = 2; //lose
    [color=Red]-                    resultRating = loser_rating;[/color]
    [color=SeaGreen]+                    resultRating = loser_team_rating;[/color]
    +                    resultTeamID = loser_arena_team->GetId();
    +                    ratingChange = loser_change;
    +                }

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use