diff options
author | megamage <none@none> | 2008-11-30 22:19:25 -0600 |
---|---|---|
committer | megamage <none@none> | 2008-11-30 22:19:25 -0600 |
commit | 77228c0abbfa0d799be28a35805b46de2e4f92ab (patch) | |
tree | caa871dddb78b4a0f0d3e114a7ecb5f5ae2339fb | |
parent | 1b163e51eaed7c441aa8c79f7d495059999b124c (diff) |
*Change arena_team_member field names.
--HG--
branch : trunk
-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(); |