*Fix script of quest trees company. By totoro

--HG--
branch : trunk

2 files changed, 22 insertions, 0 deletions

diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql
index 262cd31ddd6..44a2e1142da 100644
--- a/sql/FULL/world_scripts_full.sql
+++ b/sql/FULL/world_scripts_full.sql
@@ -1294,3 +1294,11 @@ INSERT INTO `creature_ai_scripts` VALUES ('2918102', '29181', '14', '0', '100',
 INSERT INTO `creature_ai_scripts` VALUES ('2918103', '29181', '0', '0', '100', '3', '10000', '20000', '10000', '20000', '11', '20678', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Rayne - SPELL_STARFALL');
 INSERT INTO `creature_ai_scripts` VALUES ('2918104', '29181', '0', '0', '100', '3', '10000', '20000', '10000', '20000', '11', '21807', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Rayne - SPELL_WRATH');
 
+
+-- spell 30298 tries to start event script 10675 but it doesn't exist. create it & make it spawn Geezle
+delete from event_scripts where id = 10675;
+insert into `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) values 
+(10675, 0, 10, 17318, 90000, '-5139.79','-11248.27','5.23', '6.27609');
+
+-- geezle should not spawn by default
+update creature set spawnMask=0 where guid = 85587;
\ No newline at end of file
diff --git a/sql/updates/5472_world_scripts.sql b/sql/updates/5472_world_scripts.sql
new file mode 100644
index 00000000000..65f15ddb387
--- /dev/null
+++ b/sql/updates/5472_world_scripts.sql
@@ -0,0 +1,14 @@
+-- spell 30298 tries to start event script 10675 but it doesn't exist. create it & make it spawn Geezle
+delete from event_scripts where id = 10675;
+insert into `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) values 
+(10675, 0, 10, 17318, 90000, '-5139.79','-11248.27','5.23', '6.27609');
+
+-- geezle should not spawn by default
+update creature set spawnMask=0 where guid = 85587;
+
+-- add missing sentence to Geezle's text & Overgrind's name to flag pickup emote
+# delete from `script_texts` where `entry` in (-1000266,-1000259);
+# insert into `script_texts` (`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
+('-1000266','%s picks up the naga flag.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','2','0','0','geezle - EMOTE_SPARK'),
+('-1000259','What\'s the big idea, Spark? Why\'d you call for this meeting?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','geezle - GEEZLE_SAY_1');
+