aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authormegamage <none@none>2009-07-20 12:30:37 +0800
committermegamage <none@none>2009-07-20 12:30:37 +0800
commitffcbd11b2c4f72f9390486081d813bcf54a41179 (patch)
tree1897f9b0984d421a7ed269859f540c065b32a79c /sql/updates
parent80b7b3c1fc2186d6e4c3f2105fea3928681625d6 (diff)
[8190] Update killing quest objectives base at creature_template KillCredit fields. Author: GriffonHeart
Note: for avoid double counting must be removed C++ scripts and EventAI scripts that do same thing in old way. Signed-off-by: VladimirMangos <vladimir@getmangos.com> Also implement KillCreditN field check at loading. --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/4520_8190_world_creature_template.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/4520_8190_world_creature_template.sql b/sql/updates/4520_8190_world_creature_template.sql
new file mode 100644
index 00000000000..7be3a6e49fa
--- /dev/null
+++ b/sql/updates/4520_8190_world_creature_template.sql
@@ -0,0 +1,5 @@
+-- ALTER TABLE db_version CHANGE COLUMN required_8158_01_mangos_playercreateinfo_action required_8190_01_mangos_creature_template bit;
+
+ALTER TABLE `creature_template`
+ CHANGE COLUMN `unk1` `KillCredit1` int(11) unsigned NOT NULL default '0',
+ CHANGE COLUMN `unk2` `KillCredit2` int(11) unsigned NOT NULL default '0';