diff options
| author | Brian <runningnak3d@gmail.com> | 2009-11-26 12:23:33 -0700 |
|---|---|---|
| committer | Brian <runningnak3d@gmail.com> | 2009-11-26 12:23:33 -0700 |
| commit | 7d754c3f7f0046ae432028ba8745256bbcbaeb39 (patch) | |
| tree | 2784fd860d23ad230e3d88318e8ccf82cf46c2d3 /sql | |
| parent | d792107835b10f2018f497ada1e9efe92bae3d67 (diff) | |
* Added support for questItem5 and questItem6 in creature and gameobject
* templates.
*
* Thanks to Malcrom for doing the research.
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/6374_world.sql | 4 | ||||
| -rw-r--r-- | sql/world.sql | 4 |
2 files changed, 8 insertions, 0 deletions
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', |