From acb2a35fcb35d9f59e51d27f2693ac0aa7a1b691 Mon Sep 17 00:00:00 2001 From: Kinzcool Date: Sat, 27 Sep 2014 23:23:15 -0400 Subject: DB/BroadcastText: Assigned BroadcastTextIDs to some texts --- .../world/2014_09_28_00_world_conversion.sql | 24 ++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 sql/updates/world/2014_09_28_00_world_conversion.sql (limited to 'sql') diff --git a/sql/updates/world/2014_09_28_00_world_conversion.sql b/sql/updates/world/2014_09_28_00_world_conversion.sql new file mode 100644 index 00000000000..5f145f903f2 --- /dev/null +++ b/sql/updates/world/2014_09_28_00_world_conversion.sql @@ -0,0 +1,24 @@ +UPDATE `creature_text` SET `BroadcastTextId`=28844 WHERE `entry`=29 AND `groupid`=1; +UPDATE `creature_text` SET `BroadcastTextId`=12223 WHERE `entry`=16329 AND `groupid`=0; +UPDATE `creature_text` SET `BroadcastTextId`=29304 WHERE `entry`=22515 AND `groupid`=6; +UPDATE `creature_text` SET `BroadcastTextId`=29305 WHERE `entry`=22515 AND `groupid`=7; +UPDATE `creature_text` SET `BroadcastTextId`=29306 WHERE `entry`=22515 AND `groupid`=8; +UPDATE `creature_text` SET `BroadcastTextId`=29307 WHERE `entry`=22515 AND `groupid`=9; +UPDATE `creature_text` SET `BroadcastTextId`=29308 WHERE `entry`=22515 AND `groupid`=10; +UPDATE `creature_text` SET `BroadcastTextId`=24747 WHERE `entry`=25504 AND `groupid`=0; +UPDATE `creature_text` SET `BroadcastTextId`=27243 WHERE `entry`=25504 AND `groupid`=1; +UPDATE `creature_text` SET `BroadcastTextId`=27245 WHERE `entry`=25504 AND `groupid`=2; +UPDATE `creature_text` SET `BroadcastTextId`=24748 WHERE `entry`=25504 AND `groupid`=3; +UPDATE `creature_text` SET `BroadcastTextId`=24749 WHERE `entry`=25504 AND `groupid`=4; +UPDATE `creature_text` SET `BroadcastTextId`=28396 WHERE `entry`=28122 AND `groupid`=3; +UPDATE `creature_text` SET `BroadcastTextId`=28382 WHERE `entry`=28122 AND `groupid`=4; +UPDATE `creature_text` SET `BroadcastTextId`=28507 WHERE `entry`=28511 AND `groupid`=0; +UPDATE `creature_text` SET `BroadcastTextId`=28465 WHERE `entry`=28511 AND `groupid`=1; +UPDATE `creature_text` SET `BroadcastTextId`=28899 WHERE `entry`=28841 AND `groupid`=1; + +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12663 WHERE `menu_id`=6341 AND `id`=0; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12674 WHERE `menu_id`=21265 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12657 WHERE `menu_id`=21270 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12659 WHERE `menu_id`=21271 AND `id`=0; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12660 WHERE `menu_id`=21271 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12658 WHERE `menu_id`=21271 AND `id`=2; -- cgit v1.2.3 From 653641e6794e378e5ff37e99f01bd2a398c73b53 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sun, 28 Sep 2014 11:00:46 +0200 Subject: DB/Misc: Fix startup errors --- sql/updates/world/2014_09_28_01_world.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2014_09_28_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/2014_09_28_01_world.sql b/sql/updates/world/2014_09_28_01_world.sql new file mode 100644 index 00000000000..4be9507af2d --- /dev/null +++ b/sql/updates/world/2014_09_28_01_world.sql @@ -0,0 +1,7 @@ +-- +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=29 AND `groupid`=1; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=22515 AND `groupid`=6; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=22515 AND `groupid`=7; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=22515 AND `groupid`=8; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=22515 AND `groupid`=9; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=22515 AND `groupid`=10; -- cgit v1.2.3 From 9657d1879ade6bae876b5503dd20edb0327558c1 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sun, 28 Sep 2014 11:02:49 +0200 Subject: Rename 2014_09_28_00_world_conversion.sql to 2014_09_28_00_world.sql --- sql/updates/world/2014_09_28_00_world.sql | 24 ++++++++++++++++++++++ .../world/2014_09_28_00_world_conversion.sql | 24 ---------------------- 2 files changed, 24 insertions(+), 24 deletions(-) create mode 100644 sql/updates/world/2014_09_28_00_world.sql delete mode 100644 sql/updates/world/2014_09_28_00_world_conversion.sql (limited to 'sql') diff --git a/sql/updates/world/2014_09_28_00_world.sql b/sql/updates/world/2014_09_28_00_world.sql new file mode 100644 index 00000000000..5f145f903f2 --- /dev/null +++ b/sql/updates/world/2014_09_28_00_world.sql @@ -0,0 +1,24 @@ +UPDATE `creature_text` SET `BroadcastTextId`=28844 WHERE `entry`=29 AND `groupid`=1; +UPDATE `creature_text` SET `BroadcastTextId`=12223 WHERE `entry`=16329 AND `groupid`=0; +UPDATE `creature_text` SET `BroadcastTextId`=29304 WHERE `entry`=22515 AND `groupid`=6; +UPDATE `creature_text` SET `BroadcastTextId`=29305 WHERE `entry`=22515 AND `groupid`=7; +UPDATE `creature_text` SET `BroadcastTextId`=29306 WHERE `entry`=22515 AND `groupid`=8; +UPDATE `creature_text` SET `BroadcastTextId`=29307 WHERE `entry`=22515 AND `groupid`=9; +UPDATE `creature_text` SET `BroadcastTextId`=29308 WHERE `entry`=22515 AND `groupid`=10; +UPDATE `creature_text` SET `BroadcastTextId`=24747 WHERE `entry`=25504 AND `groupid`=0; +UPDATE `creature_text` SET `BroadcastTextId`=27243 WHERE `entry`=25504 AND `groupid`=1; +UPDATE `creature_text` SET `BroadcastTextId`=27245 WHERE `entry`=25504 AND `groupid`=2; +UPDATE `creature_text` SET `BroadcastTextId`=24748 WHERE `entry`=25504 AND `groupid`=3; +UPDATE `creature_text` SET `BroadcastTextId`=24749 WHERE `entry`=25504 AND `groupid`=4; +UPDATE `creature_text` SET `BroadcastTextId`=28396 WHERE `entry`=28122 AND `groupid`=3; +UPDATE `creature_text` SET `BroadcastTextId`=28382 WHERE `entry`=28122 AND `groupid`=4; +UPDATE `creature_text` SET `BroadcastTextId`=28507 WHERE `entry`=28511 AND `groupid`=0; +UPDATE `creature_text` SET `BroadcastTextId`=28465 WHERE `entry`=28511 AND `groupid`=1; +UPDATE `creature_text` SET `BroadcastTextId`=28899 WHERE `entry`=28841 AND `groupid`=1; + +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12663 WHERE `menu_id`=6341 AND `id`=0; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12674 WHERE `menu_id`=21265 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12657 WHERE `menu_id`=21270 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12659 WHERE `menu_id`=21271 AND `id`=0; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12660 WHERE `menu_id`=21271 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12658 WHERE `menu_id`=21271 AND `id`=2; diff --git a/sql/updates/world/2014_09_28_00_world_conversion.sql b/sql/updates/world/2014_09_28_00_world_conversion.sql deleted file mode 100644 index 5f145f903f2..00000000000 --- a/sql/updates/world/2014_09_28_00_world_conversion.sql +++ /dev/null @@ -1,24 +0,0 @@ -UPDATE `creature_text` SET `BroadcastTextId`=28844 WHERE `entry`=29 AND `groupid`=1; -UPDATE `creature_text` SET `BroadcastTextId`=12223 WHERE `entry`=16329 AND `groupid`=0; -UPDATE `creature_text` SET `BroadcastTextId`=29304 WHERE `entry`=22515 AND `groupid`=6; -UPDATE `creature_text` SET `BroadcastTextId`=29305 WHERE `entry`=22515 AND `groupid`=7; -UPDATE `creature_text` SET `BroadcastTextId`=29306 WHERE `entry`=22515 AND `groupid`=8; -UPDATE `creature_text` SET `BroadcastTextId`=29307 WHERE `entry`=22515 AND `groupid`=9; -UPDATE `creature_text` SET `BroadcastTextId`=29308 WHERE `entry`=22515 AND `groupid`=10; -UPDATE `creature_text` SET `BroadcastTextId`=24747 WHERE `entry`=25504 AND `groupid`=0; -UPDATE `creature_text` SET `BroadcastTextId`=27243 WHERE `entry`=25504 AND `groupid`=1; -UPDATE `creature_text` SET `BroadcastTextId`=27245 WHERE `entry`=25504 AND `groupid`=2; -UPDATE `creature_text` SET `BroadcastTextId`=24748 WHERE `entry`=25504 AND `groupid`=3; -UPDATE `creature_text` SET `BroadcastTextId`=24749 WHERE `entry`=25504 AND `groupid`=4; -UPDATE `creature_text` SET `BroadcastTextId`=28396 WHERE `entry`=28122 AND `groupid`=3; -UPDATE `creature_text` SET `BroadcastTextId`=28382 WHERE `entry`=28122 AND `groupid`=4; -UPDATE `creature_text` SET `BroadcastTextId`=28507 WHERE `entry`=28511 AND `groupid`=0; -UPDATE `creature_text` SET `BroadcastTextId`=28465 WHERE `entry`=28511 AND `groupid`=1; -UPDATE `creature_text` SET `BroadcastTextId`=28899 WHERE `entry`=28841 AND `groupid`=1; - -UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12663 WHERE `menu_id`=6341 AND `id`=0; -UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12674 WHERE `menu_id`=21265 AND `id`=1; -UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12657 WHERE `menu_id`=21270 AND `id`=1; -UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12659 WHERE `menu_id`=21271 AND `id`=0; -UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12660 WHERE `menu_id`=21271 AND `id`=1; -UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12658 WHERE `menu_id`=21271 AND `id`=2; -- cgit v1.2.3 From 8983fbba531ac732ca48b9b78d85b2858eee67fd Mon Sep 17 00:00:00 2001 From: Kinzcool Date: Sun, 28 Sep 2014 21:54:51 -0400 Subject: DB/Gossips: Localized talents gossips by assigning them to their BroadcastTextID * Closes #12546 --- sql/updates/world/2014_09_29_00_world.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/2014_09_29_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/2014_09_29_00_world.sql b/sql/updates/world/2014_09_29_00_world.sql new file mode 100644 index 00000000000..d7f01676123 --- /dev/null +++ b/sql/updates/world/2014_09_29_00_world.sql @@ -0,0 +1,2 @@ +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33765 WHERE `menu_id`=10371; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33762 WHERE `option_text` LIKE 'I wish to know about Dual Talent Specialization.'; -- cgit v1.2.3 From 70bf81ad1b108131c1cc39b4d1777a129ce80145 Mon Sep 17 00:00:00 2001 From: Kinzcool Date: Sun, 28 Sep 2014 22:32:53 -0400 Subject: DB/Gossips: Added a missing one from 8983fbba531ac732ca48b9b78d85b2858eee67fd --- sql/updates/world/2014_09_29_01_world.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/world/2014_09_29_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/2014_09_29_01_world.sql b/sql/updates/world/2014_09_29_01_world.sql new file mode 100644 index 00000000000..922ee231461 --- /dev/null +++ b/sql/updates/world/2014_09_29_01_world.sql @@ -0,0 +1 @@ +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33762 WHERE `option_text` LIKE 'Learn about Dual Talent Specialization.'; -- cgit v1.2.3 From b705e7093c42a11cdf04e895b88dfcca2adf1c01 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Mon, 29 Sep 2014 04:50:20 +0200 Subject: DB/Quest: Fix more locales on 3.3.5a --- sql/updates/world/2014_09_29_02_world_335.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/2014_09_29_02_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/2014_09_29_02_world_335.sql b/sql/updates/world/2014_09_29_02_world_335.sql new file mode 100644 index 00000000000..f2bc535b8b7 --- /dev/null +++ b/sql/updates/world/2014_09_29_02_world_335.sql @@ -0,0 +1,9 @@ +-- +UPDATE `locales_quest` SET `Title_loc2` = REPLACE(`Title_loc2`, "[PÉRIMÉ] ", ""); +UPDATE `locales_quest` SET `Title_loc2` = REPLACE(`Title_loc2`, "[PÉRIMÉ]", ""); +UPDATE `locales_quest` SET `Title_loc6` = REPLACE(`Title_loc6`, "[DEPRECATED] ", ""); +UPDATE `locales_quest` SET `Title_loc6` = REPLACE(`Title_loc6`, "[DEPRECATED]", ""); +UPDATE `locales_quest` SET `Title_loc7` = REPLACE(`Title_loc7`, "[DEPRECATED] ", ""); +UPDATE `locales_quest` SET `Title_loc7` = REPLACE(`Title_loc7`, "[DEPRECATED]", ""); +UPDATE `locales_quest` SET `Title_loc8` = REPLACE(`Title_loc8`, "[DEPRECATED] ", ""); +UPDATE `locales_quest` SET `Title_loc8` = REPLACE(`Title_loc8`, "[DEPRECATED]", ""); -- cgit v1.2.3 From 35b267e7f7811ca62b587837a53c0c48a73efbd7 Mon Sep 17 00:00:00 2001 From: Kinzcool Date: Mon, 29 Sep 2014 06:54:04 -0400 Subject: DB/Gossips: Added some more assignation to their proper BroadcastTextID --- sql/updates/world/2014_09_29_03_world.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 sql/updates/world/2014_09_29_03_world.sql (limited to 'sql') diff --git a/sql/updates/world/2014_09_29_03_world.sql b/sql/updates/world/2014_09_29_03_world.sql new file mode 100644 index 00000000000..a52a5f9cc76 --- /dev/null +++ b/sql/updates/world/2014_09_29_03_world.sql @@ -0,0 +1,16 @@ +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=11325 WHERE `option_text` LIKE 'May I have your report?'; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3370 WHERE `option_text` LIKE 'I want to browse your goods.'; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33765 WHERE `menu_id`=0 AND `id`=16; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=4384 WHERE `menu_id`=21 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=4261 WHERE `menu_id`=1186 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=9672 WHERE `menu_id`=5848 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=9672 WHERE `menu_id`=5849 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33765 WHERE `menu_id`=6647 AND `id`=2; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=20452 WHERE `menu_id`=8568 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=20453 WHERE `menu_id`=8568 AND `id`=2; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=34567 WHERE `menu_id`=10502 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=35446 WHERE `menu_id`=10502 AND `id`=2; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=51468 WHERE `menu_id`=10502 AND `id`=3; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=36760 WHERE `menu_id`=10854 AND `id`=0; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=37552 WHERE `menu_id`=10854 AND `id`=1; +UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=21522 WHERE `menu_id`=21335 AND `id`=0; -- cgit v1.2.3