From a71fcee27d1d69dd46cdc31e6267325deb98e22a Mon Sep 17 00:00:00 2001 From: Nay Date: Tue, 6 Aug 2013 00:04:29 +0100 Subject: DB/Schema: Rename _questrelation tables to _queststarter and _involvedrelation to _questender, for creature and gameobject --- .../2013_08_05_02_world_quest_relation_tables.sql | 28 ++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 sql/updates/world/2013_08_05_02_world_quest_relation_tables.sql (limited to 'sql') diff --git a/sql/updates/world/2013_08_05_02_world_quest_relation_tables.sql b/sql/updates/world/2013_08_05_02_world_quest_relation_tables.sql new file mode 100644 index 00000000000..a7d2af1725a --- /dev/null +++ b/sql/updates/world/2013_08_05_02_world_quest_relation_tables.sql @@ -0,0 +1,28 @@ +ALTER TABLE `creature_questrelation` RENAME `creature_queststarter`; +ALTER TABLE `creature_involvedrelation` RENAME `creature_questender`; +ALTER TABLE `gameobject_questrelation` RENAME `gameobject_queststarter`; +ALTER TABLE `gameobject_involvedrelation` RENAME `gameobject_questender`; + +UPDATE `command` SET + `name` = 'reload gameobject_queststarter', + `help` = 'Syntax: .reload gameobject_queststarter\nReload gameobject_queststarter table.' +WHERE + `name` = 'reload gameobject_questrelation'; + +UPDATE `command` SET + `name` = 'reload gameobject_questender', + `help` = 'Syntax: .reload gameobject_questender\nReload gameobject_questender table.' +WHERE + `name` = 'reload gameobject_questrelation'; + +UPDATE `command` SET + `name` = 'reload creature_queststarter', + `help` = 'Syntax: .reload creature_queststarter\nReload creature_queststarter table.' +WHERE + `name` = 'reload creature_questrelation'; + +UPDATE `command` SET + `name` = 'reload creature_questender', + `help` = 'Syntax: .reload creature_questender\nReload creature_questender table.' +WHERE + `name` = 'reload creature_involvedrelation'; -- cgit v1.2.3 From dc8385f4c0e192e037924e1d2c29be200fffc0d7 Mon Sep 17 00:00:00 2001 From: Nay Date: Tue, 6 Aug 2013 00:16:26 +0100 Subject: DB/Items: Remove unlimited charges from Jillian's Tonic of Stoneblood Closes #10444 --- sql/updates/world/2013_08_06_00_world_item_template.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/world/2013_08_06_00_world_item_template.sql (limited to 'sql') diff --git a/sql/updates/world/2013_08_06_00_world_item_template.sql b/sql/updates/world/2013_08_06_00_world_item_template.sql new file mode 100644 index 00000000000..15cc7ddfa5a --- /dev/null +++ b/sql/updates/world/2013_08_06_00_world_item_template.sql @@ -0,0 +1 @@ +UPDATE `item_template` SET `spellcharges_1`=-1 WHERE `entry`=45008; -- confirmed in 4.x itemsparse -- cgit v1.2.3