From 7d754c3f7f0046ae432028ba8745256bbcbaeb39 Mon Sep 17 00:00:00 2001 From: Brian Date: Thu, 26 Nov 2009 12:23:33 -0700 Subject: * Added support for questItem5 and questItem6 in creature and gameobject * templates. * * Thanks to Malcrom for doing the research. --HG-- branch : trunk --- sql/updates/6374_world.sql | 4 ++++ sql/world.sql | 4 ++++ 2 files changed, 8 insertions(+) create mode 100644 sql/updates/6374_world.sql (limited to 'sql') diff --git a/sql/updates/6374_world.sql b/sql/updates/6374_world.sql new file mode 100644 index 00000000000..a1a8fdf5278 --- /dev/null +++ b/sql/updates/6374_world.sql @@ -0,0 +1,4 @@ +ALTER TABLE `creature_template` ADD `questItem5` int(11) UNSIGNED NOT NULL DEFAULT 0 AFTER `questItem4`; +ALTER TABLE `creature_template` ADD `questItem6` int(11) UNSIGNED NOT NULL DEFAULT 0 AFTER `questItem5`; +ALTER TABLE `gameobject_template` ADD `questItem5` int(11) UNSIGNED NOT NULL DEFAULT 0 AFTER `questItem4`; +ALTER TABLE `gameobject_template` ADD `questItem6` int(11) UNSIGNED NOT NULL DEFAULT 0 AFTER `questItem5`; diff --git a/sql/world.sql b/sql/world.sql index 1c24a339b95..1b9e3d41296 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -565,6 +565,8 @@ CREATE TABLE `creature_template` ( `questItem2` int(11) unsigned NOT NULL default '0', `questItem3` int(11) unsigned NOT NULL default '0', `questItem4` int(11) unsigned NOT NULL default '0', + `questItem5` int(11) unsigned NOT NULL default '0', + `questItem6` int(11) unsigned NOT NULL default '0', `movementId` int(11) unsigned NOT NULL default '0', `RegenHealth` tinyint(3) unsigned NOT NULL default '1', `equipment_id` mediumint(8) unsigned NOT NULL default '0', @@ -1134,6 +1136,8 @@ CREATE TABLE `gameobject_template` ( `questItem2` int(11) unsigned NOT NULL default '0', `questItem3` int(11) unsigned NOT NULL default '0', `questItem4` int(11) unsigned NOT NULL default '0', + `questItem5` int(11) unsigned NOT NULL default '0', + `questItem6` int(11) unsigned NOT NULL default '0', `data0` int(10) unsigned NOT NULL default '0', `data1` int(10) unsigned NOT NULL default '0', `data2` int(10) unsigned NOT NULL default '0', -- cgit v1.2.3