Merge git://github.com/TrinityCore/TrinityCore into mmaps

Conflicts:
	src/server/game/Movement/MovementGenerators/TargetedMovementGenerator.cpp
	src/server/game/Movement/MovementGenerators/WaypointMovementGenerator.cpp
	src/server/game/Movement/Spline/MoveSplineInit.cpp

17 files changed, 767 insertions, 53 deletions

diff --git a/sql/updates/characters/2012_11_02_00_character_misc.sql b/sql/updates/characters/2012_11_02_00_character_misc.sql
new file mode 100644
index 00000000000..a7613944dc4
--- /dev/null
+++ b/sql/updates/characters/2012_11_02_00_character_misc.sql
@@ -0,0 +1,30 @@
+CREATE TABLE IF NOT EXISTS `guild_member_withdraw` (
+  `guid` int(10) unsigned NOT NULL,
+  `tab0` int(10) unsigned NOT NULL DEFAULT '0',
+  `tab1` int(10) unsigned NOT NULL DEFAULT '0',
+  `tab2` int(10) unsigned NOT NULL DEFAULT '0',
+  `tab3` int(10) unsigned NOT NULL DEFAULT '0',
+  `tab4` int(10) unsigned NOT NULL DEFAULT '0',
+  `tab5` int(10) unsigned NOT NULL DEFAULT '0',
+  `money` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`guid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild Member Daily Withdraws';
+
+ALTER TABLE `guild_member` DROP COLUMN `BankRemMoney`;
+ALTER TABLE `guild_member` DROP COLUMN `BankRemSlotsTab0`;
+ALTER TABLE `guild_member` DROP COLUMN `BankRemSlotsTab1`;
+ALTER TABLE `guild_member` DROP COLUMN `BankRemSlotsTab2`;
+ALTER TABLE `guild_member` DROP COLUMN `BankRemSlotsTab3`;
+ALTER TABLE `guild_member` DROP COLUMN `BankRemSlotsTab4`;
+ALTER TABLE `guild_member` DROP COLUMN `BankRemSlotsTab5`;
+ALTER TABLE `guild_member` DROP COLUMN `BankResetTimeMoney`;
+ALTER TABLE `guild_member` DROP COLUMN `BankResetTimeTab0`;
+ALTER TABLE `guild_member` DROP COLUMN `BankResetTimeTab1`;
+ALTER TABLE `guild_member` DROP COLUMN `BankResetTimeTab2`;
+ALTER TABLE `guild_member` DROP COLUMN `BankResetTimeTab3`;
+ALTER TABLE `guild_member` DROP COLUMN `BankResetTimeTab4`;
+ALTER TABLE `guild_member` DROP COLUMN `BankResetTimeTab5`;
+
+DELETE FROM `worldstates` WHERE `entry`=20006;
+INSERT INTO `worldstates` (`entry`,`value`,`comment`) VALUES (20006,0, 'Guild daily reset');
+
diff --git a/sql/updates/world/2012_10_14_00_world_creature.sql b/sql/updates/world/2012_10_14_00_world_creature.sql
new file mode 100644
index 00000000000..dd650f37aef
--- /dev/null
+++ b/sql/updates/world/2012_10_14_00_world_creature.sql
@@ -0,0 +1,10 @@
+-- Spawnmask updates
+UPDATE `creature` SET `spawnMask`=15 WHERE `id` IN(40091, 40081);
+
+-- Auras updates (Now in script, can't be used in creature_addon because dynamically spawned)
+DELETE FROM `creature_template_addon` WHERE `entry` IN(39863, 40142);
+
+-- Blazing Aura
+-- NOTE: This still does not work, no clue why. Probably a core-side bug ?
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13,2,75886,0,0,31,0,3,40683,0,0,0, '', 'Blazing Aura can only target Living Embers');
diff --git a/sql/updates/world/2012_10_18_00_world_trinity_string.sql b/sql/updates/world/2012_10_18_00_world_trinity_string.sql
deleted file mode 100644
index a12b20388eb..00000000000
--- a/sql/updates/world/2012_10_18_00_world_trinity_string.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-DELETE FROM `trinity_string` WHERE `entry` IN (9986, 9987, 9989, 9990, 9991, 9992, 9993, 9994, 9995, 9996, 9997, 9998, 9999);
-INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`)
-VALUES
-  (9986, 'Error', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-  (9987, 'None', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-  (9988, 'Leader', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-  (9989, 'Dps', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-  (9990, 'Healer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-  (9991, 'Tank', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-  (9992, 'Raid browser', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-  (9993, 'Finished dungeon', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-  (9994, 'In dungeon', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-  (9995, 'Vote kick', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-  (9996, 'Proposal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-  (9997, 'Queued', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-  (9998, 'Role check', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
-  (9999, 'None', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
diff --git a/sql/updates/world/2012_10_19_00_world_creature_text.sql b/sql/updates/world/2012_10_19_00_world_creature_text.sql
deleted file mode 100644
index aad3627a26a..00000000000
--- a/sql/updates/world/2012_10_19_00_world_creature_text.sql
+++ /dev/null
@@ -1,36 +0,0 @@
--- Gnomeregan/Blastmaster Emi Shortfuse's event
-DELETE FROM `script_texts` WHERE `entry` BETWEEN -1090028 AND -1090000;
-DELETE FROM `creature_text` WHERE `entry` IN (7361,7998);
-INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
--- Emi Shortfuse
-(7998,0,0, 'With your help, I can evaluate these tunnels.',12,0,100,0,0,0, 'SAY_BLASTMASTER_0'),
-(7998,1,0, 'Let''s see if we can find out where these Troggs are coming from... and put a stop to the invasion!',12,0,100,0,0,0, 'SAY_BLASTMASTER_1'),
-(7998,2,0, 'Such devastation... what horrible mess...',12,0,100,0,0,0, 'SAY_BLASTMASTER_2'),
-(7998,3,0, 'It''s quiet here...',12,0,100,0,0,0, 'SAY_BLASTMASTER_3'),
-(7998,4,0, '...too quiet.',12,0,100,0,0,0, 'SAY_BLASTMASTER_4'),
-(7998,5,0, 'Look! Over there at the tunnel wall!',12,0,100,0,0,0, 'SAY_BLASTMASTER_5'),
-(7998,6,0, 'Trogg incrusion! Defend me while I blast the hole closed!',12,0,100,0,0,0, 'SAY_BLASTMASTER_6'),
-(7998,7,0, 'The charges are set. Get back before they blow!',12,0,100,0,0,0, 'SAY_BLASTMASTER_7'),
-(7998,8,0, 'Incoming blast in 10 seconds!',14,0,100,0,0,0, 'SAY_BLASTMASTER_8'),
-(7998,9,0, 'Incoming blast in 5 seconds. Clear the tunnel!',14,0,100,0,0,0, 'SAY_BLASTMASTER_9'),
-(7998,10,0, 'FIRE IN THE HOLE!',14,0,100,0,0,0, 'SAY_BLASTMASTER_10'),
-(7998,11,0, 'Well done! Without your help I would have never been able to thwart that wave of troggs.',12,0,100,0,0,0, 'SAY_BLASTMASTER_11'),
-(7998,12,0, 'Did you hear something?',12,0,100,0,0,0, 'SAY_BLASTMASTER_12'),
-(7998,13,0, 'I heard something over there.',12,0,100,0,0,0, 'SAY_BLASTMASTER_13'),
-(7998,14,0, 'More troggs! Ward them off as I prepare the explosives!',12,0,100,0,0,0, 'SAY_BLASTMASTER_14'),
-(7998,15,0, 'The final charge is set. Stand back!',12,0,100,0,0,0, 'SAY_BLASTMASTER_15'),
-(7998,16,0, 'The final charge is set. Stand back!',12,0,100,0,0,0, 'SAY_BLASTMASTER_16'),
-(7998,17,0, 'Incoming blast in 10 seconds!',14,0,100,0,0,0, 'SAY_BLASTMASTER_17'),
-(7998,18,0, 'Incoming blast in 5 seconds. Clear the tunnel!',14,0,100,0,0,0, 'SAY_BLASTMASTER_18'),
-(7998,19,0, 'I don''t think one charge is going to cut it. Keep fending them off!',12,0,100,0,0,0, 'SAY_BLASTMASTER_19'),
-(7998,20,0, 'FIRE IN THE HOLE!',14,0,100,0,0,0, 'SAY_BLASTMASTER_20'),
-(7998,21,0, 'Well done! Without your help I would have never been able to thwart that wave of troggs.',12,0,100,0,0,0, 'SAY_BLASTMASTER_21'),
-(7998,22,0, 'Did you hear something?',12,0,100,0,0,0, 'SAY_BLASTMASTER_22'),
-(7998,23,0, 'I heard something over there.',12,0,100,0,0,0, 'SAY_BLASTMASTER_23'),
-(7998,24,0, 'More troggs! Ward them off as I prepare the explosives!',12,0,100,0,0,0, 'SAY_BLASTMASTER_24'),
-(7998,25,0, 'The final charge is set. Stand back!',12,0,100,0,0,0, 'SAY_BLASTMASTER_25'),
-(7998,26,0, '10 seconds to blast! Stand back!!!',14,0,100,0,0,0, 'SAY_BLASTMASTER_26'),
-(7998,27,0, '5 seconds until detonation!!',14,0,100,0,0,0, 'SAY_BLASTMASTER_27'),
-(7998,28,0, 'Superb! Because of your help, my people stand a chance of re-taking our belowed city. Three cheers to you!',12,0,100,0,0,0, 'SAY_BLASTMASTER_28'),
--- Grubbis
-(7361,0,0, 'We come from below! You can never stop us!',14,0,100,0,0,0, 'SAY_GRUBBIS');
diff --git a/sql/updates/world/2012_10_20_00_world_transports.sql b/sql/updates/world/2012_10_20_00_world_transports.sql
new file mode 100644
index 00000000000..8cc2bae4b47
--- /dev/null
+++ b/sql/updates/world/2012_10_20_00_world_transports.sql
@@ -0,0 +1,6 @@
+-- Update position for Koltira Deathweaver
+UPDATE `creature_transport` SET `TransOffsetX`=45.50927,`TransOffsetY`=6.679555,`TransOffsetZ`=30.17881,`TransOffsetO`=5.445427 WHERE `guid`=36;
+
+-- Set proper name and period timers for icecrown ships
+UPDATE `transports` SET `name`= 'Alliance gunship patrolling above Icecrown (\"The Skybreaker\")',`period`=1051388 WHERE `entry`=192242;
+UPDATE `transports` SET `name`= 'Horde gunship patrolling above Icecrown (\"Orgrim''s Hammer\")',`period`=1431158 WHERE `entry`=192241;
diff --git a/sql/updates/world/2012_10_20_01_world_spell_script_names.sql b/sql/updates/world/2012_10_20_01_world_spell_script_names.sql
new file mode 100644
index 00000000000..814f1b40e65
--- /dev/null
+++ b/sql/updates/world/2012_10_20_01_world_spell_script_names.sql
@@ -0,0 +1,8 @@
+-- Spellscript and conditions for spells of quest Gordunni Cobalt
+DELETE FROM `spell_script_names` WHERE `spell_id`=19395;
+INSERT INTO `spell_script_names`(`spell_id`,`ScriptName`) VALUES
+(19395,'spell_gordunni_trap');
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=11757;
+INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`Comment`) VALUES
+(13,1,11757,31,5,144050,'Digging for Cobalt targets Gordunni Trap');
diff --git a/sql/updates/world/2012_10_20_02_world_creature_text.sql b/sql/updates/world/2012_10_20_02_world_creature_text.sql
new file mode 100644
index 00000000000..bb153c6b2f6
--- /dev/null
+++ b/sql/updates/world/2012_10_20_02_world_creature_text.sql
@@ -0,0 +1,27 @@
+-- Gnomeregan/Blastmaster Emi Shortfuse's event
+DELETE FROM `script_texts` WHERE `entry` BETWEEN -1090028 AND -1090000;
+DELETE FROM `creature_text` WHERE `entry` IN (7361,7998);
+INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
+-- Emi Shortfuse
+(7998,0,0, 'With your help, I can evaluate these tunnels.',12,0,100,0,0,0, 'SAY_BLASTMASTER_0'),
+(7998,1,0, 'Let''s see if we can find out where these Troggs are coming from... and put a stop to the invasion!',12,0,100,0,0,0, 'SAY_BLASTMASTER_1'),
+(7998,2,0, 'Such devastation... what horrible mess...',12,0,100,0,0,0, 'SAY_BLASTMASTER_2'),
+(7998,3,0, 'It''s quiet here...',12,0,100,0,0,0, 'SAY_BLASTMASTER_3'),
+(7998,4,0, '...too quiet.',12,0,100,0,0,0, 'SAY_BLASTMASTER_4'),
+(7998,5,0, 'Look! Over there at the tunnel wall!',12,0,100,0,0,0, 'SAY_BLASTMASTER_5'),
+(7998,6,0, 'Trogg incrusion! Defend me while I blast the hole closed!',12,0,100,0,0,0, 'SAY_BLASTMASTER_6'),
+(7998,7,0, 'I don''t think one charge is going to cut it. Keep fending them off!',12,0,100,0,0,0, 'SAY_BLASTMASTER_7'),
+(7998,8,0, 'The charges are set. Get back before they blow!',12,0,100,0,0,0, 'SAY_BLASTMASTER_8'),
+(7998,9,0, 'Incoming blast in 10 seconds!',14,0,100,0,0,0, 'SAY_BLASTMASTER_9'),
+(7998,10,0, 'Incoming blast in 5 seconds. Clear the tunnel!',14,0,100,0,0,0, 'SAY_BLASTMASTER_10'),
+(7998,11,0, 'FIRE IN THE HOLE!',14,0,100,0,0,0, 'SAY_BLASTMASTER_11'),
+(7998,12,0, 'Well done! Without your help I would have never been able to thwart that wave of troggs.',12,0,100,0,0,0, 'SAY_BLASTMASTER_12'),
+(7998,13,0, 'Did you hear something?',12,0,100,0,0,0, 'SAY_BLASTMASTER_13'),
+(7998,14,0, 'I heard something over there.',12,0,100,0,0,0, 'SAY_BLASTMASTER_14'),
+(7998,15,0, 'More troggs! Ward them off as I prepare the explosives!',12,0,100,0,0,0, 'SAY_BLASTMASTER_15'),
+(7998,16,0, 'The final charge is set. Stand back!',12,0,100,0,0,0, 'SAY_BLASTMASTER_16'),
+(7998,17,0, '10 seconds to blast! Stand back!!!',14,0,100,0,0,0, 'SAY_BLASTMASTER_17'),
+(7998,18,0, '5 seconds until detonation!!',14,0,100,0,0,0, 'SAY_BLASTMASTER_18'),
+(7998,19,0, 'Superb! Because of your help, my people stand a chance of re-taking our belowed city. Three cheers to you!',12,0,100,0,0,0, 'SAY_BLASTMASTER_19'),
+-- Grubbis
+(7361,0,0, 'We come from below! You can never stop us!',14,0,100,0,0,0, 'SAY_GRUBBIS');
diff --git a/sql/updates/world/2012_10_21_00_world_conditions.sql b/sql/updates/world/2012_10_21_00_world_conditions.sql
new file mode 100644
index 00000000000..62161a932f9
--- /dev/null
+++ b/sql/updates/world/2012_10_21_00_world_conditions.sql
@@ -0,0 +1 @@
+ALTER TABLE `conditions` CHANGE COLUMN `SourceEntry` `SourceEntry` MEDIUMINT(8) NOT NULL DEFAULT 0;
diff --git a/sql/updates/world/2012_10_21_01_world_misc.sql b/sql/updates/world/2012_10_21_01_world_misc.sql
new file mode 100644
index 00000000000..fe74f8a7a80
--- /dev/null
+++ b/sql/updates/world/2012_10_21_01_world_misc.sql
@@ -0,0 +1,37 @@
+-- Area conditions for Plant Chieftains Totem
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=56765;
+INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ErrorTextId`,`Comment`) VALUES
+(17,56765,29,30446,15,64,'Plant Chieftains Totem only useable next to Rift');
+
+-- Apply Close Rift to The Chieftain's Totem
+DELETE FROM `creature_template_addon` WHERE `entry`=30444;
+INSERT INTO `creature_template_addon`(`entry`,`auras`) VALUES
+(30444,'56763');
+
+-- Assign aura script to Close Rift
+DELETE FROM `spell_script_names` WHERE `spell_id`=56763;
+INSERT INTO `spell_script_names`(`spell_id`,`ScriptName`) VALUES
+(56763,'spell_close_rift');
+
+-- Target conditions for spell triggered by Close Rift Periodic
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (56764,61665);
+INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`Comment`) VALUES
+(13,1,56764,31,3,30446,'Close Rift Periodic targets Frostfloe Rift'),
+(13,1,61665,31,3,30446,'Despawn Rift targets Frostfloe Rift');
+
+-- Assign SmartAI to Frostfloe Rift
+UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=30446;
+
+-- Create SAI for Frostfloe Rift
+DELETE FROM `smart_scripts` WHERE `entryorguid`=30446 AND `source_type`=0;
+INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`action_type`,`action_param1`,`action_param2`,`target_type`,`comment`) VALUES
+(30446,1,2,8,61665,45,1,1,7,'Frostfloe Rift - On spell hit - Set data of invoker'),
+(30446,2,0,61,0,41,0,0,1,'Frostfloe Rift - On spell hit - Despawn');
+
+-- Assign SmartAI to Chieftain's Totem
+UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=30444;
+
+-- Create SAI for Chieftain's Totem
+DELETE FROM `smart_scripts` WHERE `entryorguid`=30444 AND `source_type`=0;
+INSERT INTO `smart_scripts`(`entryorguid`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES
+(30444,38,1,1,33,30444,23,'Chieftains Totem - On data set - Give quest credit');
diff --git a/sql/updates/world/2012_10_23_00_world_trinity_string.sql b/sql/updates/world/2012_10_23_00_world_trinity_string.sql
new file mode 100644
index 00000000000..60318667fbc
--- /dev/null
+++ b/sql/updates/world/2012_10_23_00_world_trinity_string.sql
@@ -0,0 +1,22 @@
+DELETE FROM `trinity_string` WHERE `entry` IN (9980, 9981, 9982, 9983, 9984, 9985, 9986, 9987, 9988, 9989, 9990, 9991, 9992, 9993, 9994, 9995, 9996, 9997, 9998, 9999);
+INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES
+  (9980, 'Player name: %s, State: %s, Dungeons: %u (%s), Roles: %s, Comment: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9981, 'LfgGroup?: %u, State: %s, Dungeon: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9982, 'Not in group', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9983, 'Queues cleared', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9984, 'Lfg options: %u', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9985, 'Lfg options changed', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9986, 'None', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9987, 'Role check', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9988, 'Queued', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9989, 'Proposal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9990, 'Vote kick', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9991, 'In dungeon', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9992, 'Finished dungeon', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9993, 'Raid browser', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9994, 'Tank', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9995, 'Healer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9996, 'Dps', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9997, 'Leader', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9998, 'None', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+  (9999, 'Error', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
diff --git a/sql/updates/world/2012_10_23_01_world_command.sql b/sql/updates/world/2012_10_23_01_world_command.sql
new file mode 100644
index 00000000000..b46882c5949
--- /dev/null
+++ b/sql/updates/world/2012_10_23_01_world_command.sql
@@ -0,0 +1,8 @@
+DELETE FROM `command` WHERE `name` LIKE 'lfg%';
+
+INSERT INTO `command` (`name`, `security`, `help`) VALUES
+('lfg player', 2, 'Syntax: .lfg player\n Shows information about player (state, roles, comment, dungeons selected).'),
+('lfg group', 2, 'Syntax: .lfg group\n Shows information about all players in the group  (state, roles, comment, dungeons selected).'),
+('lfg queue', 2, 'Syntax: .lfg queue\n Shows info about current lfg queues.'),
+('lfg clean', 3, 'Syntax: .flg clean\n Cleans current queue, only for debugging purposes.'),
+('lfg options', 3, 'Syntax: .lfg options [new value]\n Shows current lfg options. New value is set if extra param is present.');
diff --git a/sql/updates/world/2012_10_25_00_world_childrens_week.sql b/sql/updates/world/2012_10_25_00_world_childrens_week.sql
new file mode 100644
index 00000000000..e2d6eec4dd2
--- /dev/null
+++ b/sql/updates/world/2012_10_25_00_world_childrens_week.sql
@@ -0,0 +1,574 @@
+-- Orphan Matron Aria
+UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=34365;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=34365 AND `source_type`=0;
+INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES
+(34365,1,4,62,10502,1,33,34365,7,'Orphan Matron Aria - On gossip select - Give quest credit'),
+(34365,2,4,62,10502,2,11,65359,7,'Orphan Matron Aria - On gossip select - Create oracle orphan whistle'),
+(34365,3,4,62,10502,3,11,65360,7,'Orphan Matron Aria - On gossip select - Create wolvar orphan whistle'),
+(34365,4,0,61,0,0,72,0,7,'Orphan Matron Aria - On gossip select - Close gossip');
+
+DELETE FROM `gossip_menu_option` WHERE `menu_id`=10502;
+INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES
+(10502,1,0,'Tell me about the orphans.',1,1),
+(10502,2,0,'I need a new Oracle Orphan Whistle.',1,1),
+(10502,3,0,'I need a new Wolvar Orphan Whistle.',1,1);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10502;
+INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES
+(15,10502,1,1,12,10,0,0,'Childrens Week must be active'),
+(15,10502,1,1,1,58818,0,0,'Needs aura 58818'),
+(15,10502,1,1,9,13927,0,0,'Quest 13927 must be active'),
+(15,10502,1,2,12,10,0,0,'Childrens Week must be active'),
+(15,10502,1,2,1,58818,0,0,'Needs aura 58818'),
+(15,10502,1,2,9,13926,0,0,'Quest 13926 must be active'),
+(15,10502,2,0,12,10,0,0,'Childrens Week must be active'),
+(15,10502,2,0,8,13926,0,0,'Quest 13926 must be rewarded'),
+(15,10502,2,0,2,46397,1,1,'Must not have item 46397'),
+(15,10502,3,0,12,10,0,0,'Childrens Week must be active'),
+(15,10502,3,0,8,13927,0,0,'Quest 13926 must be rewarded'),
+(15,10502,3,0,2,46396,1,1,'Must not have item 46397');
+
+-- Orphan Matron Battlewail
+UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=14451;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=14451 AND `source_type`=0;
+INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES
+(14451,1,2,62,5848,1,11,23125,7,'Orphan Matron Battlewail - On gossip select - Create orc orphan whistle'),
+(14451,2,0,61,0,0,72,0,7,'Orphan Matron Battlewail - On gossip select - Close gossip');
+
+DELETE FROM `gossip_menu_option` WHERE `menu_id`=5848;
+INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES
+(5848,1,0,'I need a new Orc Orphan Whistle.',1,1);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=5848;
+INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES
+(15,5848,1,0,12,10,0,0,'Childrens Week must be active'),
+(15,5848,1,0,8,172,0,0,'Quest 172 must be rewarded'),
+(15,5848,1,0,2,18597,1,1,'Must not have item 18597');
+
+-- Orphan Matron Mercy
+UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=22819;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=22819 AND `source_type`=0;
+INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES
+(22819,1,3,62,8568,1,11,39512,7,'Orphan Matron Mercy - On gossip select - Create blood elf orphan whistle'),
+(22819,2,3,62,8568,2,11,39513,7,'Orphan Matron Mercy - On gossip select - Create draenei orphan whistle'),
+(22819,3,0,61,0,0,72,0,7,'Orphan Matron Mercy - On gossip select - Close gossip');
+
+DELETE FROM `gossip_menu_option` WHERE `menu_id`=8568;
+INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES
+(8568,1,0,'I need a new Blood Elf Orphan Whistle.',1,1),
+(8568,2,0,'I need a new Draenei Orphan Whistle.',1,1);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=8568;
+INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES
+(15,8568,1,0,12,10,0,0,'Childrens Week must be active'),
+(15,8568,1,0,8,10942,0,0,'Quest 10942 must be rewarded'),
+(15,8568,1,0,2,31880,1,1,'Must not have item 31880'),
+(15,8568,2,0,12,10,0,0,'Childrens Week must be active'),
+(15,8568,2,0,8,10943,0,0,'Quest 10943 must be rewarded'),
+(15,8568,2,0,2,31881,1,1,'Must not have item 31881');
+
+-- Orphan Matron Nightingale
+UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=14450;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=14450 AND `source_type`=0;
+INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_param1`,`event_param2`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES
+(14450,1,2,62,5849,1,11,23124,7,'Orphan Matron Nightingale - On gossip select - Create human orphan whistle'),
+(14450,2,0,61,0,0,72,0,7,'Orphan Matron Nightingale - On gossip select - Close gossip');
+
+DELETE FROM `gossip_menu_option` WHERE `menu_id`=5849;
+INSERT INTO `gossip_menu_option`(`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`) VALUES
+(5849,1,0,'I need a new Human Orphan Whistle.',1,1);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=5849;
+INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`NegativeCondition`,`Comment`) VALUES
+(15,5849,1,0,12,10,0,0,'Childrens Week must be active'),
+(15,5849,1,0,8,1468,0,0,'Quest 1468 must be rewarded'),
+(15,5849,1,0,2,18598,1,1,'Must not have item 18598');
+
+-- Oracle Orphan
+SET @TEXT_ORACLE_ORPHAN_1 = 1;
+SET @TEXT_ORACLE_ORPHAN_2 = 2;
+SET @TEXT_ORACLE_ORPHAN_3 = 3;
+SET @TEXT_ORACLE_ORPHAN_4 = 4;
+SET @TEXT_ORACLE_ORPHAN_5 = 5;
+SET @TEXT_ORACLE_ORPHAN_6 = 6;
+SET @TEXT_ORACLE_ORPHAN_7 = 7;
+SET @TEXT_ORACLE_ORPHAN_8 = 8;
+SET @TEXT_ORACLE_ORPHAN_9 = 9;
+SET @TEXT_ORACLE_ORPHAN_10 = 10;
+SET @TEXT_ORACLE_ORPHAN_11 = 11;
+SET @TEXT_ORACLE_ORPHAN_12 = 12;
+SET @TEXT_ORACLE_ORPHAN_13 = 13;
+SET @TEXT_ORACLE_ORPHAN_14 = 14;
+
+UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=33533;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=33533 AND `source_type`=0;
+INSERT INTO `smart_scripts`(`entryorguid`,`event_type`,`event_param1`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES
+(33533,8,65357,33,36209,7,'Oracle Orphan - On spellhit - Give quest credit');
+
+DELETE FROM `creature_text` WHERE `entry`=33533;
+INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE
+(33533,@TEXT_ORACLE_ORPHAN_1,"Look!",12,0),
+(33533,@TEXT_ORACLE_ORPHAN_2,"We can dance too!",12,0),
+(33533,@TEXT_ORACLE_ORPHAN_3,"We made a new friend!",12,0),
+(33533,@TEXT_ORACLE_ORPHAN_4,"We here! Only, if this is world tree, how come it broke when they tried to put whole world in?",12,0),
+(33533,@TEXT_ORACLE_ORPHAN_5,"Look! Is that us? We think it's us. A bit older, maybe?",12,0),
+(33533,@TEXT_ORACLE_ORPHAN_6,"Looks like we blessed by Great Ones! Shrines give magic, make us high-oracle someday? Maybe?",12,0),
+(33533,@TEXT_ORACLE_ORPHAN_7,"Wow! A real Great One? We don't even think Soo-say has met a real Great One!",12,0),
+(33533,@TEXT_ORACLE_ORPHAN_8,"Um, hello, Mr. Great One. We are honored to meet you.",12,0),
+(33533,@TEXT_ORACLE_ORPHAN_9,"Maybe you're asleep, Mr. Great One? We stand. Must be hard working being Great One, collecting all the shinies we leave for you.",12,0),
+(33533,@TEXT_ORACLE_ORPHAN_10,"We brought you a gift, Great One. Maybe you see it when you wake up. Maybe you remember we came to see you, oki?",12,0),
+(33533,@TEXT_ORACLE_ORPHAN_11,"So that's the queen of the dragons? Hmm... we thought she'd be bigger. Yes, we did.",12,0),
+(33533,@TEXT_ORACLE_ORPHAN_12,"How come she doesn't look like the other dragons? could she turn into a big ol' dragon if she wanted to?",12,0),
+(33533,@TEXT_ORACLE_ORPHAN_13,"Um... Your Majesty, would you turn into a dragon for us?",12,0),
+(33533,@TEXT_ORACLE_ORPHAN_14,"Oki... How about now?",12,0);
+
+DELETE FROM `creature_questrelation` WHERE `id`=33533;
+
+DELETE FROM `game_event_creature_quest` WHERE `id`=33533;
+INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES
+(10,33533,13929),
+(10,33533,13933),
+(10,33533,13950),
+(10,33533,13954),
+(10,33533,13956),
+(10,33533,13937),
+(10,33533,13959);
+
+DELETE FROM `creature_involvedrelation` WHERE `id`=33533;
+INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES
+(33533,13929),
+(33533,13933),
+(33533,13950),
+(33533,13954),
+(33533,13956),
+(33533,13937),
+(33533,13926);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13954,13956,13937);
+INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES
+(19,13954,8,13929,'Accept quest 13954 - Quest 13929 needs to be rewarded'),
+(19,13954,8,13933,'Accept quest 13954 - Quest 13933 needs to be rewarded'),
+(19,13954,8,13950,'Accept quest 13954 - Quest 13950 needs to be rewarded'),
+(19,13956,8,13929,'Accept quest 13956 - Quest 13929 needs to be rewarded'),
+(19,13956,8,13933,'Accept quest 13956 - Quest 13933 needs to be rewarded'),
+(19,13956,8,13950,'Accept quest 13956 - Quest 13950 needs to be rewarded'),
+(19,13937,8,13956,'Accept quest 13937 - Quest 13956 needs to be rewarded'),
+(20,13954,8,13929,'Show quest mark 13954 - Quest 13929 needs to be rewarded'),
+(20,13954,8,13933,'Show quest mark 13954 - Quest 13933 needs to be rewarded'),
+(20,13954,8,13950,'Show quest mark 13954 - Quest 13950 needs to be rewarded'),
+(20,13956,8,13929,'Show quest mark 13956 - Quest 13929 needs to be rewarded'),
+(20,13956,8,13933,'Show quest mark 13956 - Quest 13933 needs to be rewarded'),
+(20,13956,8,13950,'Show quest mark 13956 - Quest 13950 needs to be rewarded'),
+(20,13937,8,13956,'Show quest mark 13937 - Quest 13956 needs to be rewarded');
+
+-- Wolvar Orphan
+SET @TEXT_WOLVAR_ORPHAN_1 = 1;
+SET @TEXT_WOLVAR_ORPHAN_2 = 2;
+SET @TEXT_WOLVAR_ORPHAN_3 = 3;
+SET @TEXT_WOLVAR_ORPHAN_4 = 4;
+SET @TEXT_WOLVAR_ORPHAN_5 = 5;
+SET @TEXT_WOLVAR_ORPHAN_6 = 6;
+SET @TEXT_WOLVAR_ORPHAN_7 = 7;
+SET @TEXT_WOLVAR_ORPHAN_8 = 8;
+SET @TEXT_WOLVAR_ORPHAN_9 = 9;
+SET @TEXT_WOLVAR_ORPHAN_10 = 10;
+SET @TEXT_WOLVAR_ORPHAN_11 = 11;
+SET @TEXT_WOLVAR_ORPHAN_12 = 12;
+SET @TEXT_WOLVAR_ORPHAN_13 = 13;
+
+UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=33532;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=33532 AND `source_type`=0;
+INSERT INTO `smart_scripts`(`entryorguid`,`event_type`,`event_param1`,`action_type`,`action_param1`,`target_type`,`comment`) VALUES
+(33532,8,65357,33,36209,7,'Wolvar Orphan - On spellhit - Give quest credit');
+
+DELETE FROM `creature_text` WHERE `entry`=33532;
+INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE
+(33532,@TEXT_WOLVAR_ORPHAN_1,"Look!",12,0),
+(33532,@TEXT_WOLVAR_ORPHAN_2,"Got you back!",12,0),
+(33532,@TEXT_WOLVAR_ORPHAN_3,"Good snowball fight!",12,0),
+(33532,@TEXT_WOLVAR_ORPHAN_4,"Look! That must be Kekek as a mighty warrior! See? What Kekek tell you?",12,0),
+(33532,@TEXT_WOLVAR_ORPHAN_5,"Hmm... that Kekek very old. Must be elder, leader of Frenzyheart. This good. Kekek have good future as warrior and leader. Kekek very happy you bring him here. Orphan-lady never do that for Kekek.",12,0),
+(33532,@TEXT_WOLVAR_ORPHAN_6,"Wow. At last, Kekek get to meet Hemet Nesingwary!",12,0),
+(33532,@TEXT_WOLVAR_ORPHAN_7,"Even Frenzyheart know all about you after you come to Sholazar. Maybe you teach Kekek your tricks?",12,0),
+(33532,@TEXT_WOLVAR_ORPHAN_8,"Not sure how reading helps. Kekek can't read anyway, but if Hemet Nesingwary say, Kekek try.",12,0),
+(33532,@TEXT_WOLVAR_ORPHAN_9,"Maybe give up and throw book at animals, but try.",12,0),
+(33532,@TEXT_WOLVAR_ORPHAN_10,"You think maybe one day, Kekek lead Frenzyheart home, like bear-men fight to get tree-city back? Kekek want own home, not city with purple men, not jungle with big-tongues.",12,0),
+(33532,@TEXT_WOLVAR_ORPHAN_11,"Kekek thought we go see dragon queen. This just some elf-lady with funny horns.",12,0),
+(33532,@TEXT_WOLVAR_ORPHAN_12,"But why? Dragons big and powerful. Elf-lady weak. Kekek want to see dragon queen's real form.",12,0),
+(33532,@TEXT_WOLVAR_ORPHAN_13,"Oh! Now Kekek understand. Not want to be crushed by big dragon-lady. Maybe come back sometime when not so crowded. Nice to meet you, dragon-lady.",12,0);
+
+DELETE FROM `game_event_creature_quest` WHERE `id`=33532;
+INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES
+(10,33532,13938),
+(10,33532,13960),
+(10,33532,13930),
+(10,33532,13951),
+(10,33532,13934),
+(10,33532,13955),
+(10,33532,13957);
+
+DELETE FROM `creature_involvedrelation` WHERE `id`=33532;
+INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES
+(33532,13938),
+(33532,13930),
+(33532,13927),
+(33532,13951),
+(33532,13934),
+(33532,13955),
+(33532,13957);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (13955,13957,13938);
+INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES
+(19,13955,8,13930,'Accept quest 13955 - Quest 13930 needs to be rewarded'),
+(19,13955,8,13934,'Accept quest 13955 - Quest 13934 needs to be rewarded'),
+(19,13955,8,13951,'Accept quest 13955 - Quest 13951 needs to be rewarded'),
+(19,13957,8,13930,'Accept quest 13957 - Quest 13930 needs to be rewarded'),
+(19,13957,8,13934,'Accept quest 13957 - Quest 13934 needs to be rewarded'),
+(19,13957,8,13951,'Accept quest 13957 - Quest 13951 needs to be rewarded'),
+(19,13938,8,13957,'Accept quest 13938 - Quest 13957 needs to be rewarded'),
+(20,13955,8,13930,'Show quest mark 13955 - Quest 13930 needs to be rewarded'),
+(20,13955,8,13934,'Show quest mark 13955 - Quest 13934 needs to be rewarded'),
+(20,13955,8,13951,'Show quest mark 13955 - Quest 13951 needs to be rewarded'),
+(20,13957,8,13930,'Show quest mark 13957 - Quest 13930 needs to be rewarded'),
+(20,13957,8,13934,'Show quest mark 13957 - Quest 13934 needs to be rewarded'),
+(20,13957,8,13951,'Show quest mark 13957 - Quest 13951 needs to be rewarded'),
+(20,13938,8,13957,'Show quest mark 13938 - Quest 13957 needs to be rewarded');
+
+-- Blood Elf Orphan
+UPDATE `quest_template` SET `SpecialFlags`=`SpecialFlags`|2 WHERE `Id` IN (10945,10953,10951,10963);
+
+DELETE FROM `game_event_creature_quest` WHERE `id`=22817;
+INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES
+(10,22817,10945),
+(10,22817,10953),
+(10,22817,10951),
+(10,22817,10963),
+(10,22817,11975),
+(10,22817,10967);
+
+DELETE FROM `creature_involvedrelation` WHERE `id`=22817;
+INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES
+(22817,10942),
+(22817,10951),
+(22817,11975),
+(22817,10963);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (11975,10963,10967);
+INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES
+(19,11975,8,10945,'Accept quest 11975 - Quest 10945 needs to be rewarded'),
+(19,11975,8,10953,'Accept quest 11975 - Quest 10953 needs to be rewarded'),
+(19,11975,8,10951,'Accept quest 11975 - Quest 10951 needs to be rewarded'),
+(19,10963,8,10945,'Accept quest 10963 - Quest 10945 needs to be rewarded'),
+(19,10963,8,10953,'Accept quest 10963 - Quest 10953 needs to be rewarded'),
+(19,10963,8,10951,'Accept quest 10963 - Quest 10951 needs to be rewarded'),
+(19,10967,8,10963,'Accept quest 10967 - Quest 10963 needs to be rewarded'),
+(20,11975,8,10945,'Show quest mark 11975 - Quest 10945 needs to be rewarded'),
+(20,11975,8,10953,'Show quest mark 11975 - Quest 10953 needs to be rewarded'),
+(20,11975,8,10951,'Show quest mark 11975 - Quest 10951 needs to be rewarded'),
+(20,10963,8,10945,'Show quest mark 10963 - Quest 10945 needs to be rewarded'),
+(20,10963,8,10953,'Show quest mark 10963 - Quest 10953 needs to be rewarded'),
+(20,10963,8,10951,'Show quest mark 10963 - Quest 10951 needs to be rewarded'),
+(20,10967,8,10963,'Show quest mark 10967 - Quest 10963 needs to be rewarded');
+
+-- Draenei Orphan
+UPDATE `quest_template` SET `SpecialFlags`=`SpecialFlags`|2 WHERE `Id` IN (10956,10968,10950,10952,10954,10962);
+
+DELETE FROM `game_event_creature_quest` WHERE `id`=22818;
+INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES
+(10,22818,10952),
+(10,22818,10950),
+(10,22818,10966),
+(10,22818,10954),
+(10,22818,10956),
+(10,22818,10962);
+
+DELETE FROM `creature_involvedrelation` WHERE `id`=22818;
+INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES
+(22818,10950),
+(22818,10952),
+(22818,10943),
+(22818,10962);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (10956,10962,10966);
+INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES
+(19,10956,8,10950,'Accept quest 10956 - Quest 10950 needs to be rewarded'),
+(19,10956,8,10954,'Accept quest 10956 - Quest 10954 needs to be rewarded'),
+(19,10956,8,10952,'Accept quest 10956 - Quest 10952 needs to be rewarded'),
+(19,10962,8,10950,'Accept quest 10962 - Quest 10950 needs to be rewarded'),
+(19,10962,8,10954,'Accept quest 10962 - Quest 10954 needs to be rewarded'),
+(19,10962,8,10952,'Accept quest 10962 - Quest 10952 needs to be rewarded'),
+(19,10966,8,10962,'Accept quest 10966 - Quest 10962 needs to be rewarded'),
+(20,10956,8,10950,'Show quest mark 10956 - Quest 10950 needs to be rewarded'),
+(20,10956,8,10954,'Show quest mark 10956 - Quest 10954 needs to be rewarded'),
+(20,10956,8,10952,'Show quest mark 10956 - Quest 10952 needs to be rewarded'),
+(20,10962,8,10950,'Show quest mark 10962 - Quest 10950 needs to be rewarded'),
+(20,10962,8,10954,'Show quest mark 10962 - Quest 10954 needs to be rewarded'),
+(20,10962,8,10952,'Show quest mark 10962 - Quest 10952 needs to be rewarded'),
+(20,10966,8,10962,'Show quest mark 10966 - Quest 10962 needs to be rewarded');
+
+-- Human Orphan
+DELETE FROM `creature_questrelation` WHERE `id`=14305;
+
+DELETE FROM `game_event_creature_quest` WHERE `id`=14305;
+INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES
+(10,14305,171),
+(10,14305,558),
+(10,14305,1687),
+(10,14305,1479),
+(10,14305,1558),
+(10,14305,4822);
+
+DELETE FROM `creature_involvedrelation` WHERE `id`=14305;
+INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES
+(14305,1468),
+(14305,558),
+(14305,1687),
+(14305,1479),
+(14305,1558),
+(14305,4822);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (558,4822,171);
+INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES
+(19,558,8,1687,'Accept quest 558 - Quest 1687 needs to be rewarded'),
+(19,558,8,1558,'Accept quest 558 - Quest 1558 needs to be rewarded'),
+(19,558,8,1479,'Accept quest 558 - Quest 1479 needs to be rewarded'),
+(19,558,16,1101,'Accept quest 558 - Needs to be in race mask 1101'),
+(19,4822,8,1687,'Accept quest 4822 - Quest 1687 needs to be rewarded'),
+(19,4822,8,1558,'Accept quest 4822 - Quest 1558 needs to be rewarded'),
+(19,4822,8,1479,'Accept quest 4822 - Quest 1479 needs to be rewarded'),
+(19,171,8,4822,'Accept quest 171 - Quest 4822 needs to be rewarded'),
+(20,558,8,1687,'Show quest mark 558 - Quest 1687 needs to be rewarded'),
+(20,558,8,1558,'Show quest mark 558 - Quest 1558 needs to be rewarded'),
+(20,558,8,1479,'Show quest mark 558 - Quest 1479 needs to be rewarded'),
+(20,558,16,1101,'Show quest mark 558 - Needs to be in race mask 1101'),
+(20,4822,8,1687,'Show quest mark 4822 - Quest 1687 needs to be rewarded'),
+(20,4822,8,1558,'Show quest mark 4822 - Quest 1558 needs to be rewarded'),
+(20,4822,8,1479,'Show quest mark 4822 - Quest 1479 needs to be rewarded'),
+(20,171,8,4822,'Show quest mark 171 - Quest 4822 needs to be rewarded');
+
+-- Orcish Orphan
+DELETE FROM `creature_questrelation` WHERE `id`=14444;
+
+DELETE FROM `game_event_creature_quest` WHERE `id`=14444;
+INSERT INTO `game_event_creature_quest`(`eventEntry`,`id`,`quest`) VALUES
+(10,14444,910),
+(10,14444,911),
+(10,14444,1800),
+(10,14444,925),
+(10,14444,915),
+(10,14444,5502);
+
+DELETE FROM `creature_involvedrelation` WHERE `id`=14444;
+INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES
+(14444,925),
+(14444,172),
+(14444,910),
+(14444,911),
+(14444,1800),
+(14444,915);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (915,925,5502);
+INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`comment`) VALUES
+(19,925,8,910,'Accept quest 925 - Quest 910 needs to be rewarded'),
+(19,925,8,911,'Accept quest 925 - Quest 911 needs to be rewarded'),
+(19,925,8,1800,'Accept quest 925 - Quest 1800 needs to be rewarded'),
+(19,915,8,910,'Accept quest 915 - Quest 910 needs to be rewarded'),
+(19,915,8,911,'Accept quest 915 - Quest 911 needs to be rewarded'),
+(19,915,8,1800,'Accept quest 915 - Quest 1800 needs to be rewarded'),
+(19,5502,8,925,'Accept quest 5502 - Quest 925 needs to be rewarded'),
+(20,925,8,910,'Show quest mark 925 - Quest 910 needs to be rewarded'),
+(20,925,8,911,'Show quest mark 925 - Quest 911 needs to be rewarded'),
+(20,925,8,1800,'Show quest mark 925 - Quest 1800 needs to be rewarded'),
+(20,915,8,910,'Show quest mark 915 - Quest 910 needs to be rewarded'),
+(20,915,8,911,'Show quest mark 915 - Quest 911 needs to be rewarded'),
+(20,915,8,1800,'Show quest mark 915 - Quest 1800 needs to be rewarded'),
+(20,5502,8,925,'Show quest mark 5502 - Quest 925 needs to be rewarded');
+
+-- Home of the bear-men
+SET @GUIDS = 85179;
+SET @GUID_GRIZZLEMAW_TRIGGER_1 = @GUIDS + 0;
+SET @GUID_GRIZZLEMAW_TRIGGER_2 = @GUIDS + 1;
+SET @GUID_GRIZZLEMAW_TRIGGER_3 = @GUIDS + 2;
+
+UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_grizzlemaw_cw_trigger',`flags_extra`=0 WHERE `entry`=36209;
+
+DELETE FROM `creature` WHERE `guid` IN (@GUID_GRIZZLEMAW_TRIGGER_1,@GUID_GRIZZLEMAW_TRIGGER_2,@GUID_GRIZZLEMAW_TRIGGER_3);
+INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`) VALUES
+(@GUID_GRIZZLEMAW_TRIGGER_1,36209,571,4068.82,-3811,223.4),
+(@GUID_GRIZZLEMAW_TRIGGER_2,36209,571,4073.2,-3734.354,222.6634),
+(@GUID_GRIZZLEMAW_TRIGGER_3,36209,571,3923.109,-3763.967,165.362);
+
+-- Elder Kekek
+SET @GUID_KEKEK = @GUIDS + 3;
+SET @TEXT_ELDER_KEKEK_1 = 1;
+
+UPDATE `creature_template` SET `ScriptName`='npc_elder_kekek' WHERE `entry`=34387;
+
+DELETE FROM `creature` WHERE `guid`=@GUID_KEKEK OR `id`=34387;
+INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES
+(@GUID_KEKEK,34387,571,4181.482,-461.453,120.728,1.398097);
+
+DELETE FROM `creature_text` WHERE `entry`=34387;
+INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE
+(34387,@TEXT_ELDER_KEKEK_1,"No worry, Kekek. You grow up, be strong for Frenzyheart. You lead people back to old home, where there no big-tongue babies.",12,0);
+
+-- Alexstraza
+SET @TEXT_ALEXSTRASZA_2 = 2;
+SET @TEXT_KRASUS_8 = 8;
+
+UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_alexstraza_the_lifebinder' WHERE `entry`=26917;
+
+DELETE FROM `creature_text` WHERE (`entry`=26917 AND `groupid`=@TEXT_ALEXSTRASZA_2) OR (`entry`=27990 AND `groupid`=@TEXT_KRASUS_8);
+INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE
+(26917,@TEXT_ALEXSTRASZA_2,"If I was in my dragon form, there wouldn't be any room for anyone else, little one.",12,0),
+(27990,@TEXT_KRASUS_8,"Rest assured, Kekek, she is the queen of the dragons. We often take the forms of smaller beings when we work with them.",12,0);
+
+-- High Oracle Soo Roo
+SET @GUID_SOO_ROO = @GUIDS + 4;
+SET @TEXT_SOO_ROO_1 = 1;
+
+UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_high_oracle_soo_roo' WHERE `entry`=34386;
+
+DELETE FROM `creature_text` WHERE `entry`=34386;
+INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE
+(34386,@TEXT_SOO_ROO_1,"We remember this visit, yes we do. Never forget what you learn from your new friend, little Roo. You got great future ahead.",12,0);
+
+DELETE FROM `creature` WHERE `guid`=@GUID_SOO_ROO OR `id`=34386;
+INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES
+(@GUID_SOO_ROO,34386,571,4120.996,-329.486,121.443817,0.299253);
+
+-- Nesingwary
+SET @TEXT_NESINGWARY_1 = 1;
+
+DELETE FROM `creature_text` WHERE `entry`=27986;
+INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE
+(27986,@TEXT_NESINGWARY_1,"Well, lad, you can start by readin' The Green Hills of Stranglethorn. Then, maybe you can join me on one of my safaris. What do you say?",12,0);
+
+-- Snowfall Glade Playmate
+SET @GUID_SNOWFALL_GLADE_PLAYMATE = @GUIDS + 5;
+SET @TEXT_SNOWFALL_GLADE_PLAYMATE_1 = 1;
+SET @TEXT_SNOWFALL_GLADE_PLAYMATE_2 = 2;
+
+UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_snowfall_glade_playmate' WHERE `entry`=34490;
+
+DELETE FROM `creature_text` WHERE `entry`=34490;
+INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE
+(34490,@TEXT_SNOWFALL_GLADE_PLAYMATE_1,"Better watch out!",12,0),
+(34490,@TEXT_SNOWFALL_GLADE_PLAYMATE_2,"Got you good!",12,0);
+
+DELETE FROM `creature` WHERE `guid`=@GUID_SNOWFALL_GLADE_PLAYMATE OR `id`=34490;
+INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES
+(@GUID_SNOWFALL_GLADE_PLAYMATE,34490,571,3325.193,1026.451,138.1712,2.062184);
+
+-- Winterfin Playmate
+SET @GUID_WINTERFIN_PLAYMATE = @GUIDS + 6;
+SET @TEXT_WINTERFIN_PLAYMATE_1 = 1;
+SET @TEXT_WINTERFIN_PLAYMATE_2 = 2;
+
+UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_winterfin_playmate' WHERE `entry`=34489;
+
+DELETE FROM `creature_text` WHERE `entry`=34489;
+INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`emote`) VALUE
+(34489,@TEXT_WINTERFIN_PLAYMATE_1,"Wanna see what I can do?",12,0),
+(34489,@TEXT_WINTERFIN_PLAYMATE_2,"Now dance together!",12,0);
+
+DELETE FROM `creature` WHERE `guid`=@GUID_WINTERFIN_PLAYMATE OR `id`=34489;
+INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES
+(@GUID_WINTERFIN_PLAYMATE,34489,571,4382.502,6066.199,0.724562,3.571894);
+
+-- Biggest Tree Ever
+SET @GUID_BIGGEST_TREE_TRIGGER = @GUIDS + 7;
+
+UPDATE `creature_template` SET `AIName`='',`ScriptName`='npc_the_biggest_tree',`flags_extra`=0 WHERE `entry`=34381;
+
+DELETE FROM `creature` WHERE `guid`=@GUID_BIGGEST_TREE_TRIGGER OR `id`=34381;
+INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES
+(@GUID_BIGGEST_TREE_TRIGGER,34381,571,4022.666,-3777.682,115.443588,4.857019);
+
+-- Meeting A Great One
+UPDATE `creature_template` SET `ScriptName`='npc_the_etymidian' WHERE `entry`=28092;
+
+-- POIs
+DELETE FROM `quest_poi` WHERE `questId` IN (13956,13929,13950,13951,13957,13933,13934,13930,13954,13955);
+INSERT INTO `quest_poi`(`questId`,`objIndex`,`mapid`,`WorldMapAreaId`,`unk4`) VALUES
+(13956,16,1,201,3),
+(13929,16,571,490,3),
+(13950,16,571,486,3),
+(13951,16,571,488,3),
+(13957,16,571,493,3),
+(13933,16,571,488,3),
+(13934,16,571,488,3),
+(13930,16,571,490,3),
+(13954,16,571,488,3),
+(13955,16,571,488,3);
+
+DELETE FROM `quest_poi_points` WHERE `questid` IN (13956,13929,13950,13951,13957,13933,13934,13930,13954,13955);
+INSERT INTO `quest_poi_points`(`questId`,`x`,`y`) VALUES
+(13956,-6193,-1223),
+(13929,4022,-3777),
+(13950,4382,6066),
+(13951,3325,1026),
+(13957,5584,5748),
+(13933,4121,-329),
+(13934,4181,-461),
+(13930,4071,-3773),
+(13954,3530,271),
+(13955,3530,271);
+
+-- NPC areatriggers
+SET @GUID_AERIS_LANDING_TRIGGER = @GUIDS + 8;
+SET @GUID_SILVERMOON_TRIGGER_01 = @GUIDS + 9;
+SET @GUID_AUCHINDOUN_TRIGGER = @GUIDS + 10;
+SET @GUID_SPOREGGAR_TRIGGER = @GUIDS + 11;
+SET @GUID_THRONE_OF_ELEMENTS_TRIGGER = @GUIDS + 12;
+
+UPDATE `creature_template` SET `InhabitType`=7,`flags_extra`=0,`unit_flags`=33554432,`ScriptName`='npc_cw_area_trigger',`AIName`='' WHERE `entry` IN (22905,22851,22838,22866,22831,22829,22872,22839);
+
+DELETE FROM `creature` WHERE `guid` IN (@GUID_SILVERMOON_TRIGGER_01,@GUID_AERIS_LANDING_TRIGGER,@GUID_AUCHINDOUN_TRIGGER,@GUID_SPOREGGAR_TRIGGER,@GUID_THRONE_OF_ELEMENTS_TRIGGER);
+INSERT INTO `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`) VALUES
+(@GUID_AERIS_LANDING_TRIGGER,22838,530,-2075.759,8559.336,23.027,4.857019),
+(@GUID_SILVERMOON_TRIGGER_01,22866,530,9506.086,-7329.313,14.397272,0),
+(@GUID_AUCHINDOUN_TRIGGER,22831,530,-3320.860,4925.095,-101.1,0),
+(@GUID_SPOREGGAR_TRIGGER,22829,530,203.587,8550.11,22.3256,0),
+(@GUID_THRONE_OF_ELEMENTS_TRIGGER,22839,530,-781.294,6943.52,33.3344,0);
+
+-- Misc
+DELETE `game_event_creature` FROM `game_event_creature` INNER JOIN `creature` ON `creature`.`guid`=`game_event_creature`.`guid` 
+WHERE `id` IN (22905,22851,22838,22866,22831,22829,22872,22839,14450,22819,14451,34365,34387,34386,34490,34489,34381,36209);
+INSERT INTO `game_event_creature`(`eventEntry`,`guid`) SELECT 10,`guid` FROM `creature` 
+WHERE `id` IN (22905,22851,22838,22866,22831,22829,22872,22839,14450,22819,14451,34365,34387,34386,34490,34489,34381,36209);
+
+DELETE FROM `game_event_npc_vendor` WHERE `eventEntry`=10 AND `item`=46693;
+INSERT INTO `game_event_npc_vendor` (`eventEntry`, `guid`, `item`) VALUES 
+(10,99369,46693),
+(10,97984,46693);
+
+UPDATE `item_template` SET `minMoneyLoot`=50000,`maxMoneyLoot`=50000 WHERE `entry`=23022;
+UPDATE `item_template` SET `HolidayId`=201 WHERE `entry` IN (46396,46397,31880,31881,18598,18597);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry` IN (23012,23013,39478,39479,65352,65353);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ErrorTextId`,`Comment`) VALUES 
+(17,0,23012,0,12,10,0,"Orphan Whistle only while children's week"),
+(17,0,23013,0,12,10,0,"Orphan Whistle only while children's week"),
+(17,0,39478,0,12,10,0,"Orphan Whistle only while children's week"),
+(17,0,39479,0,12,10,0,"Orphan Whistle only while children's week"),
+(17,0,65352,0,12,10,0,"Orphan Whistle only while children's week"),
+(17,0,65353,0,12,10,0,"Orphan Whistle only while children's week");
+
+UPDATE `quest_poi_points` SET `x`=1642,`y`=239 WHERE `questId`=1800 AND `id`=0 AND `idx`=0;
+UPDATE `quest_poi_points` SET `x`=-248,`y`=956 WHERE `questId`=10952 AND `id`=0 AND `idx`=0;
+UPDATE `quest_poi_points` SET `x`=-11400.211,`y`=1944.599 WHERE `questId`=1687 AND `id`=0 AND `idx`=0;
+UPDATE `quest_poi_points` SET `x`=-998.183,`y`=-3822.07 WHERE `questId`=910 AND `id`=0 AND `idx`=0;
+UPDATE `quest_poi_points` SET `x`=1260.812,`y`=-2223.765 WHERE `questId`=911 AND `id`=0 AND `idx`=0;
+UPDATE `quest_poi_points` SET `x`=9933,`y`=2500 WHERE `questId`=1479 AND `id`=0 AND `idx`=0;
+UPDATE `quest_poi_points` SET `x`=-2075.759,`y`=8559.336 WHERE `questId`=10954 AND `id`=0 AND `idx`=0;
+UPDATE `quest_poi_points` SET `x`=9506,`y`=-7329 WHERE `questId`=11975 AND `id`=0 AND `idx`=0;
+UPDATE `quest_poi_points` SET `x`=-3320.860,`y`=4925.095 WHERE `questId`=10950 AND `id`=0 AND `idx`=0;
+UPDATE `quest_poi_points` SET `x`=203.587,`y`=8550.11 WHERE `questId`=10945 AND `id`=0 AND `idx`=0;
+UPDATE `quest_poi_points` SET `x`=-781.294,`y`=6943.52 WHERE `questId`=10953 AND `id`=0 AND `idx`=0;
diff --git a/sql/updates/world/2012_10_26_00_world_sai.sql b/sql/updates/world/2012_10_26_00_world_sai.sql
new file mode 100644
index 00000000000..8e4c2fa0922
--- /dev/null
+++ b/sql/updates/world/2012_10_26_00_world_sai.sql
@@ -0,0 +1 @@
+UPDATE `smart_scripts` SET `action_param3`=3500,`action_param4`=6000 WHERE `entryorguid`=9458 AND `source_type`=0 AND `id`=0;
diff --git a/sql/updates/world/2012_10_27_00_world_creature.sql b/sql/updates/world/2012_10_27_00_world_creature.sql
new file mode 100644
index 00000000000..c00c450aeca
--- /dev/null
+++ b/sql/updates/world/2012_10_27_00_world_creature.sql
@@ -0,0 +1,13 @@
+-- Dragonbone Condor
+UPDATE `creature` SET `spawndist`=0, `MovementType`=0 WHERE `guid` IN (106595,106596,106597,106598,106603,106604,106605,106607,106608,106626,106629,106631,106643,106646,106658,106663,106665,106668,106669,106675,106676,106679,106680,106681,106682,106683,106684,106685,106686,106687,106688,106692,106693,106696,106702,106703,106706,106722,106723,106724,106726,106727,106728,106733,106737,106741,106749,106755,106757,131072);
+UPDATE `creature` SET `position_z`=72.130 WHERE `guid`=106631;
+UPDATE `creature` SET `position_z`=72.902 WHERE `guid`=106675;
+UPDATE `creature` SET `position_z`=69.505 WHERE `guid`=131072;
+/* Carrion Condor
+ * All these have unitfieldbyte1=1 which means sitting. Obviously that makes no sense when they are moving randomly within their spawndist. They should be sitting on the pillars in Borean Tundra.
+ * There are some that are spawned very close to dead Taunka. From retail I know they should be flying directly on top of them not moving so I changed them, too. */
+UPDATE `creature` SET `spawndist`=0, `MovementType`=0 WHERE `guid` IN (101804,101805,101806,101807,101808,101809,101810,101814,101815,101818,101819,101820,101823,101824,101825,101832,101834,101836,101837,101838,101839,101842,101845,101849,101850,101856,101859,101860,101862,101866,101872,101876,101877,101890,101921,101923);
+-- Courier Lanson: The npc should be sleeping on the bed instead of just standing there.
+DELETE FROM `creature_template_addon` WHERE `entry`=27060;
+INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
+(27060,0,0,3,0,0,'');
diff --git a/sql/updates/world/2012_10_27_01_world_creature_loot_template.sql b/sql/updates/world/2012_10_27_01_world_creature_loot_template.sql
new file mode 100644
index 00000000000..3367dbf0fa8
--- /dev/null
+++ b/sql/updates/world/2012_10_27_01_world_creature_loot_template.sql
@@ -0,0 +1,22 @@
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceEntry`=51315;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`Scriptname`,`Comment`) VALUES
+-- Lich King 10N
+(1,36597,51315,0,1,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),
+(1,36597,51315,0,1,3,0,49623,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),
+(1,36597,51315,0,1,9,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has "The Lich King''s Last Stand" in their quest log'),
+(1,36597,51315,0,1,14,0,24914,0,0,0,0,'' , 'Sealed Chest will drop only if the player has not completed the quest Personal Property'),
+-- Lich King 25N
+(1,39166,51315,0,1,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),
+(1,39166,51315,0,1,3,0,49623,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),
+(1,39166,51315,0,1,9,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has "The Lich King''s Last Stand" in their quest log'),
+(1,39166,51315,0,1,14,0,24914,0,0,0,0,'' , 'Sealed Chest will drop only if the player has not completed the quest Personal Property'),
+-- Lich King 10H
+(1,39167,51315,0,1,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),
+(1,39167,51315,0,1,3,0,49623,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),
+(1,39167,51315,0,1,9,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has "The Lich King''s Last Stand" in their quest log'),
+(1,39167,51315,0,1,14,0,24914,0,0,0,0,'' , 'Sealed Chest will drop only if the player has not completed the quest Personal Property'),
+-- Lich King 25H
+(1,39168,51315,0,1,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),
+(1,39168,51315,0,1,3,0,49623,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),
+(1,39168,51315,0,1,9,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has "The Lich King''s Last Stand" in their quest log'),
+(1,39168,51315,0,1,14,0,24914,0,0,0,0,'' , 'Sealed Chest will drop only if the player has not completed the quest Personal Property');
diff --git a/sql/updates/world/2012_10_29_00_world_conditions.sql b/sql/updates/world/2012_10_29_00_world_conditions.sql
new file mode 100644
index 00000000000..d1fac5361fb
--- /dev/null
+++ b/sql/updates/world/2012_10_29_00_world_conditions.sql
@@ -0,0 +1,2 @@
+-- fix bad condition2/3 values on ItemEquip Conditions
+UPDATE `conditions` SET `ConditionValue2`=0,`ConditionValue3`=0 WHERE `ConditionTypeOrReference`=3;
diff --git a/sql/updates/world/2012_11_03_00_world_creature_loot_template.sql b/sql/updates/world/2012_11_03_00_world_creature_loot_template.sql
new file mode 100644
index 00000000000..0e5c39b796d
--- /dev/null
+++ b/sql/updates/world/2012_11_03_00_world_creature_loot_template.sql
@@ -0,0 +1,6 @@
+-- Readd loot to Stinky
+DELETE FROM `creature_loot_template` WHERE `entry` IN(37025,38064);
+INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`)
+VALUES
+(37025,1,100,1,0,-35069,2),
+(38064,1,100,1,0,-35069,2);