diff options
author | Nay <dnpd.dd@gmail.com> | 2012-02-05 15:51:32 +0000 |
---|---|---|
committer | Nay <dnpd.dd@gmail.com> | 2012-02-05 15:52:03 +0000 |
commit | 5019e9d353793691d0684f249d04cce511e85e84 (patch) | |
tree | d2f13c1457bfa1cbd96db327d161247484000dd3 | |
parent | 5378ea7babe2ab0d8bbe547150071a944c1f34a5 (diff) |
DB/Misc: Fix startup errors
Closes #4850
-rw-r--r-- | sql/updates/world/2011_02_05_04_world_misc.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2011_02_05_04_world_misc.sql b/sql/updates/world/2011_02_05_04_world_misc.sql new file mode 100644 index 00000000000..0d72b08167e --- /dev/null +++ b/sql/updates/world/2011_02_05_04_world_misc.sql @@ -0,0 +1,11 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=56278; + +DELETE FROM `db_script_string` WHERE `entry`=2000000077; +INSERT INTO `db_script_string` (`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`)VALUES +(2000000077,'%s gestures to the pitcher of water sitting on the edge of the well.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); + +SET @GOSSIP := 4535; +SET @OLD := 663; +SET @NEW := 563; +UPDATE `conditions` SET `SourceEntry`=@NEW WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=@GOSSIP AND `SourceEntry`=@OLD; +UPDATE `gossip_menu` SET `text_id`=@NEW WHERE `entry`=@GOSSIP AND `text_id`=@OLD; |