aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorNay <dnpd.dd@gmail.com>2012-02-05 15:51:32 +0000
committerNay <dnpd.dd@gmail.com>2012-02-05 15:52:03 +0000
commit5019e9d353793691d0684f249d04cce511e85e84 (patch)
treed2f13c1457bfa1cbd96db327d161247484000dd3
parent5378ea7babe2ab0d8bbe547150071a944c1f34a5 (diff)
DB/Misc: Fix startup errors
Closes #4850
-rw-r--r--sql/updates/world/2011_02_05_04_world_misc.sql11
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;