aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authormegamage <none@none>2008-11-30 22:19:25 -0600
committermegamage <none@none>2008-11-30 22:19:25 -0600
commit77228c0abbfa0d799be28a35805b46de2e4f92ab (patch)
treecaa871dddb78b4a0f0d3e114a7ecb5f5ae2339fb
parent1b163e51eaed7c441aa8c79f7d495059999b124c (diff)
*Change arena_team_member field names.
--HG-- branch : trunk
-rw-r--r--sql/updates/360_characters.sql4
-rw-r--r--src/game/BattleGroundMgr.cpp2
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();