From 8dc9140e1cd7baa0fc082494b4920b9b2dcfbf32 Mon Sep 17 00:00:00 2001 From: teacher Date: Mon, 18 Jan 2010 17:28:48 +0100 Subject: FIx sql naming and some small sql cosmetics. --HG-- branch : trunk --- sql/updates/7033_world_script_waypoints.sql | 1 - sql/updates/7053_world_script_texts.sql | 1 - sql/updates/7054_world_script_texts.sql | 1 - sql/updates/7062_gossip_menu_option.sql | 17 ----------------- sql/updates/7062_world_gossip_menu_option.sql | 17 +++++++++++++++++ 5 files changed, 17 insertions(+), 20 deletions(-) delete mode 100644 sql/updates/7062_gossip_menu_option.sql create mode 100644 sql/updates/7062_world_gossip_menu_option.sql (limited to 'sql/updates') diff --git a/sql/updates/7033_world_script_waypoints.sql b/sql/updates/7033_world_script_waypoints.sql index 5da669458cf..3c9f6e79149 100644 --- a/sql/updates/7033_world_script_waypoints.sql +++ b/sql/updates/7033_world_script_waypoints.sql @@ -15,4 +15,3 @@ INSERT INTO `script_waypoint` VALUES (7998,13,-512.396,-86.3113,-151.642,30000,''), (7998,14,-520.928,-117.679,-156.119,0,''), (7998,15,-521.717,-119.564,-156.114,0,''); - diff --git a/sql/updates/7053_world_script_texts.sql b/sql/updates/7053_world_script_texts.sql index 5b20f6907a6..10556df821e 100644 --- a/sql/updates/7053_world_script_texts.sql +++ b/sql/updates/7053_world_script_texts.sql @@ -3,4 +3,3 @@ INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1` (23861,-1000469,'It is too late for us, living one. Take yourself and your friend away from here before you both are... claimed...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''), (23861,-1000470,'Go away, whoever you are! Witch Hill is mine... mine!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''), (23861,-1000471,'It was... terrible... the demon...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''); - diff --git a/sql/updates/7054_world_script_texts.sql b/sql/updates/7054_world_script_texts.sql index 82b9ad12c2a..5e6364a1b31 100644 --- a/sql/updates/7054_world_script_texts.sql +++ b/sql/updates/7054_world_script_texts.sql @@ -2,4 +2,3 @@ DELETE FROM `script_texts` WHERE `entry` IN (-1000472,-1000473); INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES (23864,-1000472,'This land was mine long before your wretched kind set foot here.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,''), (23864,-1000473,'All who venture here belong to me, including you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,''); - diff --git a/sql/updates/7062_gossip_menu_option.sql b/sql/updates/7062_gossip_menu_option.sql deleted file mode 100644 index 9b68d962e3a..00000000000 --- a/sql/updates/7062_gossip_menu_option.sql +++ /dev/null @@ -1,17 +0,0 @@ --- Converts GOSSIP_OPTION display text from Generic to English --- Fixes some problems with GOSSIP_OPTION_OUTDOORPVP, the columns were shifted over one for some reason, seems to have been a typo. -UPDATE `gossip_menu_option` SET `option_text`= 'I want to travel fast' WHERE `option_text`= 'GOSSIP_OPTION_TAXIVENDOR'; -UPDATE `gossip_menu_option` SET `option_text`= 'I want to join the Battle Ground' WHERE `option_text`= 'GOSSIP_OPTION_BATTLEFIELD'; -UPDATE `gossip_menu_option` SET `option_text`= 'Bring me back to life' WHERE `option_text`= 'GOSSIP_OPTION_SPIRITGUIDE' OR `option_text`= 'GOSSIP_OPTION_SPIRITHEALER'; -UPDATE `gossip_menu_option` SET `option_text`= 'Make this inn my home' WHERE `option_text`= 'GOSSIP_OPTION_INNKEEPER'; -UPDATE `gossip_menu_option` SET `option_text`= 'Show me my bank' WHERE `option_text`= 'GOSSIP_OPTION_BANKER'; -UPDATE `gossip_menu_option` SET `option_text`= 'I''d like to stable my pet here' WHERE `option_text`= 'GOSSIP_OPTION_STABLEPET'; -UPDATE `gossip_menu_option` SET `option_text`= 'I want to create a guild crest' WHERE `option_text`= 'GOSSIP_OPTION_TABARDDESIGNER'; -UPDATE `gossip_menu_option` SET `option_text`= 'Auction!' WHERE `option_text`= 'GOSSIP_OPTION_AUCTIONEER'; -UPDATE `gossip_menu_option` SET `option_text`= 'Purchase a Dual Talent Specialization' WHERE `option_text`= 'GOSSIP_OPTION_LEARNDUALSPEC'; -UPDATE `gossip_menu_option` SET `option_text`= 'I wish to unlearn my pet''s skills' WHERE `option_text`= 'GOSSIP_OPTION_UNLEARNPETSKILLS'; -UPDATE `gossip_menu_option` SET `option_text`= 'I wish to unlearn my talents' WHERE `option_text`= 'GOSSIP_OPTION_UNLEARNTALENTS'; -UPDATE `gossip_menu_option` SET `option_text`= 'Train me!' WHERE `option_text`= 'GOSSIP_OPTION_TRAINER'; -UPDATE `gossip_menu_option` SET `option_text`= 'I want to browse your goods' WHERE `option_text`= 'GOSSIP_OPTION_VENDOR' OR `option_text`= 'GOSSIP_OPTION_ARMORER'; -UPDATE `gossip_menu_option` SET `option_text`= 'How do I form a guild?' WHERE `option_text`= 'GOSSIP_OPTION_PETITIONER'; -UPDATE `gossip_menu_option` SET `option_id`=19,`npc_option_npcflag`=536870912,`action_menu_id`=0 WHERE `option_text`= 'GOSSIP_OPTION_OUTDOORPVP'; diff --git a/sql/updates/7062_world_gossip_menu_option.sql b/sql/updates/7062_world_gossip_menu_option.sql new file mode 100644 index 00000000000..9b68d962e3a --- /dev/null +++ b/sql/updates/7062_world_gossip_menu_option.sql @@ -0,0 +1,17 @@ +-- Converts GOSSIP_OPTION display text from Generic to English +-- Fixes some problems with GOSSIP_OPTION_OUTDOORPVP, the columns were shifted over one for some reason, seems to have been a typo. +UPDATE `gossip_menu_option` SET `option_text`= 'I want to travel fast' WHERE `option_text`= 'GOSSIP_OPTION_TAXIVENDOR'; +UPDATE `gossip_menu_option` SET `option_text`= 'I want to join the Battle Ground' WHERE `option_text`= 'GOSSIP_OPTION_BATTLEFIELD'; +UPDATE `gossip_menu_option` SET `option_text`= 'Bring me back to life' WHERE `option_text`= 'GOSSIP_OPTION_SPIRITGUIDE' OR `option_text`= 'GOSSIP_OPTION_SPIRITHEALER'; +UPDATE `gossip_menu_option` SET `option_text`= 'Make this inn my home' WHERE `option_text`= 'GOSSIP_OPTION_INNKEEPER'; +UPDATE `gossip_menu_option` SET `option_text`= 'Show me my bank' WHERE `option_text`= 'GOSSIP_OPTION_BANKER'; +UPDATE `gossip_menu_option` SET `option_text`= 'I''d like to stable my pet here' WHERE `option_text`= 'GOSSIP_OPTION_STABLEPET'; +UPDATE `gossip_menu_option` SET `option_text`= 'I want to create a guild crest' WHERE `option_text`= 'GOSSIP_OPTION_TABARDDESIGNER'; +UPDATE `gossip_menu_option` SET `option_text`= 'Auction!' WHERE `option_text`= 'GOSSIP_OPTION_AUCTIONEER'; +UPDATE `gossip_menu_option` SET `option_text`= 'Purchase a Dual Talent Specialization' WHERE `option_text`= 'GOSSIP_OPTION_LEARNDUALSPEC'; +UPDATE `gossip_menu_option` SET `option_text`= 'I wish to unlearn my pet''s skills' WHERE `option_text`= 'GOSSIP_OPTION_UNLEARNPETSKILLS'; +UPDATE `gossip_menu_option` SET `option_text`= 'I wish to unlearn my talents' WHERE `option_text`= 'GOSSIP_OPTION_UNLEARNTALENTS'; +UPDATE `gossip_menu_option` SET `option_text`= 'Train me!' WHERE `option_text`= 'GOSSIP_OPTION_TRAINER'; +UPDATE `gossip_menu_option` SET `option_text`= 'I want to browse your goods' WHERE `option_text`= 'GOSSIP_OPTION_VENDOR' OR `option_text`= 'GOSSIP_OPTION_ARMORER'; +UPDATE `gossip_menu_option` SET `option_text`= 'How do I form a guild?' WHERE `option_text`= 'GOSSIP_OPTION_PETITIONER'; +UPDATE `gossip_menu_option` SET `option_id`=19,`npc_option_npcflag`=536870912,`action_menu_id`=0 WHERE `option_text`= 'GOSSIP_OPTION_OUTDOORPVP'; -- cgit v1.2.3