diff options
| -rw-r--r-- | sql/updates/360_characters.sql | 4 | ||||
| -rw-r--r-- | src/game/BattleGroundMgr.cpp | 2 |
2 files changed, 5 insertions, 1 deletions
diff --git a/sql/updates/360_characters.sql b/sql/updates/360_characters.sql new file mode 100644 index 00000000000..40662c380ce --- /dev/null +++ b/sql/updates/360_characters.sql @@ -0,0 +1,4 @@ +ALTER TABLE arena_team_member CHANGE played_week games_week int(10) unsigned NOT NULL default '0'; +ALTER TABLE arena_team_member CHANGE wons_week wins_week int(10) unsigned NOT NULL default '0'; +ALTER TABLE arena_team_member CHANGE played_season games_season int(10) unsigned NOT NULL default '0'; +ALTER TABLE arena_team_member CHANGE wons_season wins_season int(10) unsigned NOT NULL default '0';
\ No newline at end of file diff --git a/src/game/BattleGroundMgr.cpp b/src/game/BattleGroundMgr.cpp index 6249967bf4c..87a652f23c2 100644 --- a/src/game/BattleGroundMgr.cpp +++ b/src/game/BattleGroundMgr.cpp @@ -1587,7 +1587,7 @@ void BattleGroundMgr::DistributeArenaPoints() uint32 position = PLAYER_FIELD_ARENA_TEAM_INFO_1_1 + 6 * i + 2; CharacterDatabase.DirectPExecute("UPDATE characters SET data = CONCAT( SUBSTRING_INDEX(data,' ','%u'),' ','0',' ',SUBSTRING(data FROM (CHAR_LENGTH(SUBSTRING_INDEX(data,' ','%u')) + 2)))",position, position + 1); } - CharacterDatabase.DirectExecute("UPDATE arena_team_member SET points_to_add = '0', played_week = '0', wons_week = '0'"); + CharacterDatabase.DirectExecute("UPDATE arena_team_member SET points_to_add = '0', games_week = '0', wins_week = '0'"); CharacterDatabase.DirectExecute("UPDATE arena_team_stats SET games = '0', wins = '0'"); CharacterDatabase.CommitTransaction(); |