ArcEmu: Modified Arcscripts_full.sql - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Modified Arcscripts_full.sql Changes for 3464

#1 User is offline   nftbu 

  • Member
  • Pip
  • Group: Members
  • Posts: 58
  • Joined: 13-March 09
  • Location:Germany

Posted 02 July 2010 - 06:57 PM

Because death_state column was moved to creature_spawns from creature_proto in update 3464 I spent some time to make the needed changes to the arcscripts_full.sql file.

The .patch file is in the last post.

Changelog:
1. Updated the SQL statements - removed the death_state column in the statement
2. changed INSERT INTO to REPLACE INTO
0

#2 User is offline   suchASunthan 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 246
  • Joined: 29-November 08
  • Gender:Male
  • Location:Frankfurt
  • Interests:Vcpp, vb, sql, all programmlanguages
    more informations >:-]

Posted 03 July 2010 - 05:06 AM

also you could add a patch, so its in the right section. can you make a diff of your file towards the original file?
Koninzidenz begründet keine Korrelation und ist kein Beweis für Kausalität!

coincidence causes no correlation and in´t a argument for causality!

Posted Image
Posted Image
0

#3 User is offline   nftbu 

  • Member
  • Pip
  • Group: Members
  • Posts: 58
  • Joined: 13-March 09
  • Location:Germany

Posted 03 July 2010 - 05:26 AM

View PostsuchASunthan, on 03 July 2010 - 05:06 AM, said:

also you could add a patch, so its in the right section. can you make a diff of your file towards the original file?


After opening both in "TortoiseMerge" I clicked "create unified diff file" in the "Edit" menue. Is this correct?

Edit:
I am not sure about the last change. I don't know if it is the correct column.
UPDATE `creature_spawns` SET `death_state` = '1' WHERE `entry` = '11834';

Attached File(s)


0

#4 User is offline   Sadikum 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 367
  • Joined: 16-June 08
  • Gender:Male

Posted 03 July 2010 - 06:33 AM

I am not sure about the last change. I don't know if it is the correct column.
 UPDATE `creature_spawns` SET `death_state` = '1' WHERE `entry` = '11834';


It's correct, thanks you for updating this SQL.
Sorry for my english, I'm french.
0

#5 User is offline   nftbu 

  • Member
  • Pip
  • Group: Members
  • Posts: 58
  • Joined: 13-March 09
  • Location:Germany

Posted 03 July 2010 - 07:51 AM

Ah, I just saw an "mistake".

Wouldn't it be better to change the last INSERTS INTO to REPLACE INTO? Just to avoid mistakes when the script is executed twice.
0

#6 User is offline   suchASunthan 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 246
  • Joined: 29-November 08
  • Gender:Male
  • Location:Frankfurt
  • Interests:Vcpp, vb, sql, all programmlanguages
    more informations >:-]

Posted 03 July 2010 - 08:20 AM

View Postnftbu, on 03 July 2010 - 07:51 AM, said:

Ah, I just saw an "mistake".

Wouldn't it be better to change the last INSERTS INTO to REPLACE INTO? Just to avoid mistakes when the script is executed twice.



it would be better. if you've done, a mod can take this topic as "patch" and no more as "workshop". ty for contributing!
Koninzidenz begründet keine Korrelation und ist kein Beweis für Kausalität!

coincidence causes no correlation and in´t a argument for causality!

Posted Image
Posted Image
0

#7 User is offline   nftbu 

  • Member
  • Pip
  • Group: Members
  • Posts: 58
  • Joined: 13-March 09
  • Location:Germany

Posted 03 July 2010 - 08:34 AM

Allright. I am finished now.
I can not see any further problems.

Attached File(s)


0

#8 User is offline   jackpoz 

  • ArcEmu Lemon Priest
  • PipPipPipPipPipPipPipPip
  • Group: Developers
  • Posts: 2,153
  • Joined: 19-June 08
  • Gender:Male
  • Location:Italy
  • Server OS:Windows

Posted 03 July 2010 - 10:12 AM

http://arcemu.info/t...AIInterface.cpp

as you may know, PostgreSQL doesn't support REPLACE.
Posted Image We develop dreams. Your dreams ;)
Posted ImagePosted Image
0

#9 User is offline   nftbu 

  • Member
  • Pip
  • Group: Members
  • Posts: 58
  • Joined: 13-March 09
  • Location:Germany

Posted 03 July 2010 - 11:04 AM

hmm thats not nice
0

#10 User is offline   iEzri 

  • < Ace of spades >
  • Group: Contributor
  • Posts: 1,692
  • Joined: 22-December 08
  • Gender:Female
  • Interests:I'm likely to cause mischief
  • Server OS:Linux

Posted 03 July 2010 - 12:41 PM

View Postnftbu, on 03 July 2010 - 11:04 AM, said:

hmm thats not nice


I'll not remove myself from aesthetic responsibility by saying "Oh, my gosh this indeed is not very nice isn't it?...", so i'll say: If you find it ugly, it's not arcemu fault.
Posted Image I do not join. I lead.
0

#11 User is offline   nftbu 

  • Member
  • Pip
  • Group: Members
  • Posts: 58
  • Joined: 13-March 09
  • Location:Germany

Posted 03 July 2010 - 01:06 PM

View PostiEzri, on 03 July 2010 - 12:41 PM, said:

I'll not remove myself from aesthetic responsibility by saying "Oh, my gosh this indeed is not very nice isn't it?...", so i'll say: If you find it ugly, it's not arcemu fault.


What ever, I really don't care.

REPLACE INTO was in the script after Postgres support was added.
Bad luck for postgres.

Anyways. I will change the code later.
0

#12 User is offline   suchASunthan 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 246
  • Joined: 29-November 08
  • Gender:Male
  • Location:Frankfurt
  • Interests:Vcpp, vb, sql, all programmlanguages
    more informations >:-]

Posted 07 July 2010 - 04:37 AM

what the hell?
i downloaded and take a look over the code
the patch doesn't work, there are too much mistakes. have you created it with as a right patch? i dont think so. i take a look.

EDIT:

Index: arcscripts_full.sql
===================================================================
--- arcscripts_full.sql	(Revision 1327)
+++ arcscripts_full.sql	(Arbeitskopie)
@@ -8,7 +8,7 @@
 UPDATE `creature_proto` SET `npcflags` = `npcflags`|'1' WHERE (`entry`='3052');
 
 -- Trenton Lighthammer Gossip
-DELETE FROM npc_gossip_textid WHERE (`creatureid`='7804');
+DELETE FROM `npc_gossip_textid` WHERE (`creatureid`='7804');
 REPLACE INTO `npc_gossip_textid` (`creatureid`,`textid`) VALUES ('7804','1758');
 UPDATE `creature_proto` SET `npcflags` = `npcflags`|'1' WHERE (`entry`='7804');
 
@@ -28,28 +28,31 @@
 /* Karazhan */
 
 -- Opera Stage Right Door should be closed by default, whoever sniffed NCDB GO's in kara, did it after the instance was fully cleared.
-UPDATE `gameobject_spawns` set `State`='1' WHERE `entry`='184279';
+UPDATE `gameobject_spawns` SET `State`='1' WHERE `entry`='184279';
 -- Berthold Flag Fix
-UPDATE `creature_proto` set `npcflags`=`npcflags`|1 WHERE `entry`= 16153;
+UPDATE `creature_proto` SET `npcflags`=`npcflags`|1 WHERE `entry`= 16153;
 -- Nether Infernal faction fix
-UPDATE `creature_proto` SET faction=103 WHERE entry=17646;
+UPDATE `creature_proto` SET `faction` = 103 WHERE `entry` = 17646;
 
 
 /* The Eye */
 
 -- remove void reaver agent
-DELETE FROM ai_agents WHERE entry=19516;
+DELETE FROM `ai_agents` WHERE `entry` = 19516;
 
 /* Dark Portal event */
 
-DELETE FROM `creature_spawns` WHERE entry = 18625;
-DELETE FROM `creature_proto` WHERE entry = 18625;
-DELETE FROM `creature_names` WHERE entry = 18625;
-REPLACE INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`) VALUES ('18625','Dark Portal Event Trigger',' ','','0','10','0','0','0','0',169,0,0,0,'1','1',0);
+DELETE FROM `creature_spawns` WHERE `entry` = 18625;
+DELETE FROM `creature_proto` WHERE `entry` = 18625;
+DELETE FROM `creature_names` WHERE `entry` = 18625;
+REPLACE INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`) VALUES 
+('18625','Dark Portal Event Trigger',' ','','0','10','0','0','0','0',169,0,0,0,'1','1',0);
 
-replace into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`,`respawntime`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('18625','70','70','35','1000000','1000000','0','0','1758','1000','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
+REPLACE into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`,`respawntime`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values
+('18625','70','70','35','1000000','1000000','0','0','1758','1000','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','2.5','8','14','0');
 
-REPLACE INTO `creature_spawns` (`entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes2`, `emote_state`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`) VALUES (18625,530,'-263.719','1101.18','73.7167','4.64415',0,'169',35,33554432,0,0,0,0,0,0);
+REPLACE INTO `creature_spawns` (`entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes2`, `emote_state`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`) VALUES 
+(18625,530,'-263.719','1101.18','73.7167','4.64415',0,'169',35,33554432,0,0,0,0,0,0);
 
 
 /* The Deadmines */
@@ -79,16 +82,16 @@
 (30000, 'Trigger', ' ', '', 0, 0, 0, 0, 0, 0, 15294, 0, 0, 0, 1, 1, 0),
 (30001, 'Door Event Trigger', ' ', '', 0, 0, 0, 0, 0, 0, 15294, 0, 0, 0, 1, 1, 0);
 
-REPLACE INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) VALUES 
-(30000, 70, 70, 1825, 100000, 100000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, '0', 0, 0, 0, 0, 2.5, 8, 14, 0),
-(30001, 70, 70, 35, 100000, 100000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, '0', 0, 0, 0, 0, 2.5, 8, 14, 0);
+REPLACE INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) VALUES 
+(30000, 70, 70, 1825, 100000, 100000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, '0', 0, 0, 0, 2.5, 8, 14, 0),
+(30001, 70, 70, 35, 100000, 100000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, '0', 0, 0, 0, 2.5, 8, 14, 0);
 
-DELETE FROM `creature_spawns` WHERE entry IN (22990, 22996, 22997, 23336, 30001);
+DELETE FROM `creature_spawns` WHERE `entry` IN (22990, 22996, 22997, 23336, 30001);
 REPLACE INTO `creature_spawns` (`entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes2`, `emote_state`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`) VALUES 
 (22990, 564, 661.563, 305.711, 271.689, 0.00628138, 4, 20681, 1858, 256, 0, 1, 0, 0, 0, 0),
 (30001, 564, 771.5, 304.7, 319, 3.10568, 0, 15294, 35, 0, 0, 0, 0, 0, 0, 0);
 
-REPLACE INTO `gameobject_names` (entry, Type, DisplayID, Name, Category, CastBarText, UnkStr, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14) VALUES 
+REPLACE INTO `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `Category`, `CastBarText`, UnkStr, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14) VALUES 
 (185905, 0, 7388, "Gate", '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
 (200000, 0, 7421, 'BT_ILLIDAN_DOOR_RIGHT', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
 (200001, 0, 7422, 'BT_ILLIDAN_DOOR_LEFT', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
@@ -110,7 +113,8 @@
 
 REPLACE INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`) VALUES  (16980, 'The Lich King', ' ', '', 0, 0, 0, 0, 0, 0, 15294, 0, 0, 0, 1, 1, 0);
 
-REPLACE INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) VALUES  (16980, 70, 70, 14, 100000, 100000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, '0', 0, 0, 0, 0, 2.5, 8, 14, 0);
+REPLACE INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) VALUES 
+(16980, 70, 70, 14, 100000, 100000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, '0', 0, 0, 0, 2.5, 8, 14, 0);
 
 REPLACE INTO `creature_spawns` (`entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes2`, `emote_state`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`) VALUES (16980, 533, 3767.58, -5117.15, 174.49, 2.95544, 0, 15294, 14, 33554432, 0, 0, 0, 0, 0, 0);
 
@@ -119,7 +123,7 @@
 (181640, 7, 6690, 'Doodad_kelthuzad_throne02', '', '', '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
 (200002, 0, 6770, 'KELTHUZAD_WINDOW_PORTAL', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
 
-DELETE FROM `gameobject_spawns` WHERE Entry IN (181640, 181228, 200002);
+DELETE FROM `gameobject_spawns` WHERE `Entry` IN (181640, 181228, 200002);
 REPLACE INTO `gameobject_spawns` (`Entry`, `map`, `position_x`, `position_y`, `position_z`, `Facing`, `orientation1`, `orientation2`, `orientation3`, `orientation4`, `State`, `Flags`, `Faction`, `Scale`) VALUES 
 (181640, 533, 3762.47, -5116.29, 143.861, 2.95281, 0, 0, 0.995549, 0.0942488, 1, 1, 0, 1),
 (181228, 533, 3635.44, -5090.33, 143.205, 1.38302, 0, 0, 0.637702, 0.770283, 0, 1, 0, 1),
@@ -130,18 +134,18 @@
 
 -- Sapphiron Encounter
 
-DELETE FROM `gameobject_spawns` WHERE entry = 181225;
+DELETE FROM `gameobject_spawns` WHERE `entry` = 181225;
 REPLACE INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`) VALUES
 ('50011','Sapphiron',' ','0','0','0','0','0','0','0',13069,0,0,0,'1','1','0'),
 ('50010','Sapphiron Frost Breath Trigger',' ','0','0','0','0','0','0','0',13069,0,0,0,'1','1','0'),
 ('50012','Sapphiron',' ','0','0','0','0','0','0','0',13069,0,0,0,'1','1','0'),
 ('50013','Sapphiron',' ','0','0','0','0','0','0','0',13069,0,0,0,'1','1','0');
 
-REPLACE INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) VALUES
-('50010','70','70','21','100000','100000','0','1','0','10000','0','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0',0,'0','0','1.5','1.5','1.5',0),
-('50011','70','70','21','100000','100000','0','1','0','10000','0','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0',0,'0','0','0','0','0',0),
-('50012','70','70','21','100000','100000','0','3','0','10000','0','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0',0,'0','0','0','0','0',0),
-('50013','70','70','21','100000','100000','0','1','0','10000','0','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0',0,'0','0','0','0','0',0);
+REPLACE INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) VALUES
+('50010','70','70','21','100000','100000','0','1','0','10000','0','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0',0,'0','1.5','1.5','1.5',0),
+('50011','70','70','21','100000','100000','0','1','0','10000','0','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0',0,'0','0','0','0',0),
+('50012','70','70','21','100000','100000','0','3','0','10000','0','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0',0,'0','0','0','0',0),
+('50013','70','70','21','100000','100000','0','1','0','10000','0','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0',0,'0','0','0','0',0);
 REPLACE INTO `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `Category`, `CastBarText`, `UnkStr`, `spellfocus`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) VALUES
 ('181225','0','6695','Frostwyrm Waterfall Door', '', '', '' ,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
 REPLACE INTO `gameobject_spawns` (`Entry`, `map`, `position_x`, `position_y`, `position_z`, `Facing`, `orientation1`, `orientation2`, `orientation3`, `orientation4`, `State`, `Flags`, `Faction`, `Scale`) VALUES
@@ -156,12 +160,12 @@
 ('17474','Target Trigger',' ','','0','10','0','0','0','0',169,15435,0,0,'1.35','1','0'),
 ('133338','Magtheridon Encounter Trigger',' ','','0','10','0','0','0','0',169,0,0,0,'1','1','0');
 
-REPLACE INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) VALUES
-('17376','1','1','35','1','1','0','1','0','1500',0,'3','3.87','0','0','0','0','0','0','0','0','0','0','2','1','0','0',0,'0','0','2.5','8','14',0),
-('17474','1','1','35','1','1','0','1','0','1400',0,'3','3.87','0','0','0','0','0','0','0','0','0','0','1','1','0','0',0,'0','0','2.5','8','14',0),
-('133338','70','70','35','1000000','1000000','0','0','1758','1000','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0',0,'0',0,'0','2.5','8','14',0);
+REPLACE INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) VALUES
+('17376','1','1','35','1','1','0','1','0','1500',0,'3','3.87','0','0','0','0','0','0','0','0','0','0','2','1','0','0',0,'0','2.5','8','14',0),
+('17474','1','1','35','1','1','0','1','0','1400',0,'3','3.87','0','0','0','0','0','0','0','0','0','0','1','1','0','0',0,'0','2.5','8','14',0),
+('133338','70','70','35','1000000','1000000','0','0','1758','1000','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0',0,'0',0,'2.5','8','14',0);
 
-DELETE FROM `creature_spawns` WHERE entry IN (17376, 17474, 133338) AND map = 544;
+DELETE FROM `creature_spawns` WHERE `entry` IN (17376, 17474, 133338) AND `map` = 544;
 REPLACE INTO `creature_spawns` (`entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes2`, `emote_state`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`) VALUES
 (17376,544,'8.79722','-19.4801','2.53646','3.07178',12,'13069',114,0,16777472,4097,0,0,0,0,0),
 (17474,544,'13.1331','2.75793','-0.312492','0.264242',12,'15435',35,0,16777472,4097,0,0,0,0,0),
@@ -188,7 +192,7 @@
 ('184639','0','7206','Magtheridon Column 001', '', '', '', '0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0'),
 ('184653','0','7208','Doodad_Hellfire_Raid_FX01', '', '', '', '0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
 
-DELETE FROM `gameobject_spawns` WHERE entry IN (181713, 183847, 184634, 184635, 184636, 184637, 184638, 184639, 184653) AND map = 544;
+DELETE FROM `gameobject_spawns` WHERE `entry` IN (181713, 183847, 184634, 184635, 184636, 184637, 184638, 184639, 184653) AND `map` = 544;
 REPLACE INTO `gameobject_spawns` (`Entry`, `map`, `position_x`, `position_y`, `position_z`, `Facing`, `orientation1`, `orientation2`, `orientation3`, `orientation4`, `State`, `Flags`, `Faction`, `Scale`) VALUES
 ('184635','544','19.0966','-29.2772','0.133036','-1.26399','0','0','-0.590754','0.806852','1','32','1375','1'),
 ('184638','544','-60.8202','-21.9269','-0.03026','3.08278','0','0','0.999568','0.029401','1','32','1375','1'),
@@ -204,15 +208,15 @@
 ('181713','544','-54.2302','2.32818','0.630945','0.0174533','0','0','0.00872654','0.999962','1','0','0','1.5'),
 ('181713','544','-31.7948','38.3964','0.630919','-1.20428','0','0','0.566406','-0.824126','1','0','0','1.5');
 
-UPDATE `gameobject_spawns` SET Flags = 0 WHERE Entry = 181713 AND map = 544;
+UPDATE `gameobject_spawns` SET `Flags` = 0 WHERE `Entry` = 181713 AND `map` = 544;
 
 
 /* The Mechanar */
 
 REPLACE INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`) VALUES
 ('50000','Nether Bomb',' ','','0','0','0','0','0','0',13069,0,0,0,'1','1','0');
-REPLACE INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) VALUES
-('50000','70','70','168','100000','100000','100000','1','0','20000',0,'0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0',0,'0','0','2.5','8','14',0);
+REPLACE INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) VALUES
+('50000','70','70','168','100000','100000','100000','1','0','20000',0,'0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0',0,'0','2.5','8','14',0);
 
 
 /* Shadowfang Keep */
@@ -228,8 +232,8 @@
 DELETE FROM `creature_spawns` WHERE `entry`= 8996 AND `map`= 389;
 REPLACE INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`) VALUES
 (500000, 'Voidwalker', 'Searing Blade Warlock Minion', ' ', 0, 3, 16, 0, 0, 0, 1132, 0, 0, 0, 1.4, 0.77, 0);
-REPLACE INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) VALUES 
-(500000, 17, 17, 554, 460, 460, 4439, 1, 0, 1870, 0, 14, 20, 0, 0, 0, 0, 0, 0,0, 0, 0, 0, 7, 0.8, 0, 0, 0, 0, 0, 2.5, 8, 14, 0);
+REPLACE INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) VALUES 
+(500000, 17, 17, 554, 460, 460, 4439, 1, 0, 1870, 0, 14, 20, 0, 0, 0, 0, 0, 0,0, 0, 0, 0, 7, 0.8, 0, 0, 0, 0, 2.5, 8, 14, 0);
 
 
 /* Blackrock Spire */
@@ -243,12 +247,12 @@
 /* Serpentshrine Caverns */
 
 -- Leotheras the Blind event
-DELETE FROM `creature_spawns` WHERE entry IN (21875, 21812);
+DELETE FROM `creature_spawns` WHERE `entry` IN (21875, 21812);
 
 -- Lady Vashj event
 REPLACE INTO `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `Category`, `CastBarText`, `UnkStr`, `spellfocus`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) VALUES
 (185051, 0, 7265, 'Shield Generator', '', '', '', 0, 1718, 131072, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
-DELETE FROM `gameobject_spawns` WHERE entry=185051;
+DELETE FROM `gameobject_spawns` WHERE `entry` = 185051;
 REPLACE INTO `gameobject_spawns` (`Entry`, `map`, `position_x`, `position_y`, `position_z`, `Facing`, `orientation1`, `orientation2`, `orientation3`, `orientation4`, `State`, `Flags`, `Faction`, `Scale`) VALUES
 (185051, 548, 49.256, -902.354, 42.9769, 3.93902, 0, 0, 0.929729, -0.368245, 1, 0, 0, 1.5),
 (185051, 548, 49.687, -944.406, 42.7324, 2.31089, 0, 0, 0.914975, 0.403512, 1, 0, 0, 1.5),
@@ -256,19 +260,19 @@
 (185051, 548, 9.78695, -902.882, 42.9, 5.4399, 0, 0, 0.382205, -0.924078, 1, 0, 0, 1.5);
 
 -- Karathress event
-DELETE FROM `creature_spawns` WHERE Entry=22820;
+DELETE FROM `creature_spawns` WHERE `Entry` = 22820;
 
 /* QUEST SCRIPTS */
 
 /*They're Alive! Maybe... */
 REPLACE INTO `quests` (`entry`, `ZoneId`, `sort`, `flags`, `MinLevel`, `questlevel`, `Type`, `RequiredRaces`, `RequiredClass`, `RequiredTradeskill`, `RequiredTradeskillValue`, `RequiredRepFaction`, `RequiredRepValue`, `LimitTime`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `srcItem`, `SrcItemCount`, `Title`, `Details`, `Objectives`, `CompletionText`, `IncompleteText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqKillMobOrGOId1`, `ReqKillMobOrGOId2`, `ReqKillMobOrGOId3`, `ReqKillMobOrGOId4`, `ReqKillMobOrGOCount1`, `ReqKillMobOrGOCount2`, `ReqKillMobOrGOCount3`, `ReqKillMobOrGOCount4`, `ReqCastSpellId1`, `ReqCastSpellId2`, `ReqCastSpellId3`, `ReqCastSpellId4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepValue1`, `RewRepValue2`, `RewRepLimit`, `RewMoney`, `RewXP`, `RewSpell`, `CastSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `ExploreTrigger1`, `ExploreTrigger2`, `ExploreTrigger3`, `ExploreTrigger4`, `RequiredQuest1`, `RequiredQuest2`, `RequiredQuest3`, `RequiredQuest4`, `ReceiveItemId1`, `ReceiveItemId2`, `ReceiveItemId3`, `ReceiveItemId4`, `ReceiveItemCount1`, `ReceiveItemCount2`, `ReceiveItemCount3`, `ReceiveItemCount4`, `IsRepeatable`, `RequiredOneOfQuest`, `RemoveQuests` ) VALUES
 (9670, 3525, 0, 136, 16, 19, 0, 1101, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 'They''re Alive! Maybe...', 'It was a bloody mess, $N;. We were ambushed by a large pack of these spiders. Their progenitor descended upon us with incredible speed and wrapped us up in cocoons.$B$BAfter we were webbed, she began to lay eggs near us. We were to be food for her young! FOOD!$B$BI managed to cut my way out and escape but I will not leave the others behind. So far I''ve been unsuccessful in nearing the pass. Would you lend a hand?$B$BDestroy those cocoons! Hopefully some of our team is still alive!', 'Researcher Cornelius has asked that you free 5 Expedition Researchers.', 'You rescued over half the team! Word of your deed will definitely get back to Blood Watch and the exarch. Thanks again, $N;.', '', '', 'Expedition Researcher Freed', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 17681, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 26017, 0, 0, 0, 1, 0, 0, 0, 930, 0, 250, 0, 0, 0, 1450, 0, 0, 0, 0, 0, 0, 900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '');/* Great Bear Spirit  5929,5930*/
-UPDATE quests SET flags=8, Type=0, SpecialFlags=64, EndText="Seek out the Great Bear Spirit and learn what it has to share with you about the nature of the bear.", ObjectiveText1="Talk to the Great Bear Spirit", ReqKillMobOrGOId1=11956, ReqKillMobOrGOCount1=1 WHERE entry=5929;
-UPDATE quests SET flags=8, Type=0, SpecialFlags=64, EndText="Seek out the Great Bear Spirit and learn what it has to share with you about the nature of the bear.", ObjectiveText1="Talk to the Great Bear Spirit", ReqKillMobOrGOId1=11956, ReqKillMobOrGOCount1=1 WHERE entry=5930;
+UPDATE `quests` SET `flags` = 8, `Type` = 0, `SpecialFlags` = 64, `EndText` = "Seek out the Great Bear Spirit and learn what it has to share with you about the nature of the bear.", `ObjectiveText1` = "Talk to the Great Bear Spirit", `ReqKillMobOrGOId1` = 11956, `ReqKillMobOrGOCount1` = 1 WHERE `entry` = 5929;
+UPDATE `quests` SET `flags` = 8, `Type` = 0, `SpecialFlags` = 64, `EndText` = "Seek out the Great Bear Spirit and learn what it has to share with you about the nature of the bear.", `ObjectiveText1` = "Talk to the Great Bear Spirit", `ReqKillMobOrGOId1` = 11956, `ReqKillMobOrGOCount1` = 1 WHERE `entry` = 5930;
 
 /* Body and Heart 6001,6002 */
-UPDATE quests SET flags=8, Type=0, SpecialFlags=64, EndText="Face Lunaclaw and earn the strength of body and heart it possesses.", ObjectiveText1="Face Lunaclaw and earn the strength of body and heart it possesses.", ReqKillMobOrGOId1=12144, ReqKillMobOrGOCount1=1 WHERE entry=6001;
-UPDATE quests SET flags=8, Type=0, SpecialFlags=64, EndText="Face Lunaclaw and earn the strength of body and heart it possesses.", ObjectiveText1="Face Lunaclaw and earn the strength of body and heart it possesses.", ReqKillMobOrGOId1=12144, ReqKillMobOrGOCount1=1 WHERE entry=6002;
+UPDATE `quests` SET `flags` = 8, `Type` = 0, `SpecialFlags` = 64, `EndText` = "Face Lunaclaw and earn the strength of body and heart it possesses.", `ObjectiveText1` = "Face Lunaclaw and earn the strength of body and heart it possesses.", `ReqKillMobOrGOId1` = 12144, `ReqKillMobOrGOCount1` = 1 WHERE `entry` = 6001;
+UPDATE `quests` SET `flags` = 8, `Type` = 0, `SpecialFlags` = 64, `EndText` = "Face Lunaclaw and earn the strength of body and heart it possesses.", `ObjectiveText1` = "Face Lunaclaw and earn the strength of body and heart it possesses.", `ReqKillMobOrGOId1` = 12144, `ReqKillMobOrGOCount1` = 1 WHERE `entry` = 6002;
 
 
 /* Arcane Disturbances */
@@ -361,8 +365,9 @@
 DELETE FROM `gameobject_names` WHERE `entry`='185554';
 DELETE FROM `gameobject_names` WHERE `entry`='300154';
 
-REPLACE INTO `gameobject_names` (entry, Type, DisplayID, Name, Category, CastBarText, UnkStr, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14) VALUES('185554', '10', '7363', 'The Raven\'s Claw', '', '', '', '1732', '196608', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
-REPLACE INTO `gameobject_names` (entry, Type, DisplayID, Name, Category, CastBarText, UnkStr, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14) VALUES ('300154', '10', '4891', 'The Raven\'s Claw', '', '', '', '1732', '196608', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
+REPLACE INTO `gameobject_names` (entry, Type, DisplayID, Name, Category, CastBarText, UnkStr, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14) VALUES
+('185554', '10', '7363', 'The Raven\'s Claw', '', '', '', '1732', '196608', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
+('300154', '10', '4891', 'The Raven\'s Claw', '', '', '', '1732', '196608', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
 
 DELETE FROM `gameobject_spawns` WHERE `Entry`='185554';
 DELETE FROM `gameobject_spawns` WHERE `Entry`='300154';
@@ -407,15 +412,16 @@
    (300112, 530, -3300.61, 2927.43, 173.612, 5.35918, 0, 0, 0.44574, -0.895162, 1, 0, 0, 1);
 
 -- Ayren Cloudbreaker and Unrestrained Dragonhawk Gossip
-DELETE FROM `npc_text` WHERE `entry` in (12252, 12371);
+DELETE FROM `npc_text` WHERE `entry` IN (12252, 12371);
 REPLACE INTO `npc_text`
    (`entry`, `prob0`, `text0_0`, `text0_1`, `lang0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `prob1`, `text1_0`, `text1_1`, `lang1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `prob2`, `text2_0`, `text2_1`, `lang2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `prob3`, `text3_0`, `text3_1`, `lang3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `prob4`, `text4_0`, `text4_1`, `lang4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `prob5`, `text5_0`, `text5_1`, `lang5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `prob6`, `text6_0`, `text6_1`, `lang6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `prob7`, `text7_0`, `text7_1`, `lang7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`)
 VALUES
    (12252, 1, 'You don\'t get to see much action in my line of work. Serving this close to the front lines in a combat zone is a nice change of pace.', 'You don\'t get to see much action in my line of work. Serving this close to the front lines in a combat zone is a nice change of pace.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0),
    (12371, 1, 'The dragonhawk appears to be unsettled by the commotion in the surrounding area.', 'The dragonhawk appears to be unsettled by the commotion in the surrounding area.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0);
-UPDATE `creature_proto` SET `npcflags` = '1' WHERE `entry` in (25236, 25059);
-UPDATE `creature_spawns` SET `flags` = '1' WHERE `entry` in (25236, 25059);
 
+UPDATE `creature_proto` SET `npcflags` = '1' WHERE `entry` IN (25236, 25059);
+UPDATE `creature_spawns` SET `flags` = '1' WHERE `entry` IN (25236, 25059);
+
 -- Bloodmaul Brutebane Stout Trigger
 UPDATE `creature_names` SET `male_displayid`='0',`male_displayid2`='0',`female_displayid`='0',`female_displayid2`='0' WHERE `entry` = '21241';
 
@@ -432,8 +438,10 @@
 
 DELETE FROM `creature_names` WHERE `entry` = '51000';
 DELETE FROM `creature_proto` WHERE `entry` = '51000';
-REPLACE INTO `creature_names` (`entry`,`name`,`subname`,`info_str`,`male_displayid`,`female_displayid`,`male_displayid2`,`leader`) VALUES ('51000','The Tale of Neltharaku Credit','','','0','0','0','0');
-REPLACE INTO `creature_proto` (`entry`,`minlevel`,`maxlevel`,`faction`,`minhealth`,`maxhealth`,`auras`,`invisibility_type`,`death_state`) VALUES ('51000','1','1','35','1','1','','0','0');
+REPLACE INTO `creature_names` (`entry`,`name`,`subname`,`info_str`,`male_displayid`,`female_displayid`,`male_displayid2`,`leader`) VALUES 
+('51000','The Tale of Neltharaku Credit','','','0','0','0','0');
+REPLACE INTO `creature_proto` (`entry`,`minlevel`,`maxlevel`,`faction`,`minhealth`,`maxhealth`,`auras`,`invisibility_type`) 
+VALUES ('51000','1','1','35','1','1','','0');
 UPDATE `quests` SET `ObjectiveText1`='The Tale of Neltharaku',`ReqKillMobOrGOId1`='51000',`ReqKillMobOrGOCount1`='1' WHERE `entry`='10814';
 -- Eliza related
 UPDATE `quests` SET `IsRepeatable`='1' WHERE `entry`='254';
@@ -460,13 +468,14 @@
 
 /* Maur Grimtotem SQL */
 UPDATE `creature_spawns` SET `position_x` = '-148.594', `position_y` = '25.012', `position_z` = '-38.7162', `standstate` = '7' WHERE `entry` = '11834';
-UPDATE `creature_proto` SET `death_state` = '1' WHERE `entry` = '11834';
+UPDATE `creature_spawns` SET `death_state` = '1' WHERE `entry` = '11834';
 
 -- Death Knight quests and Zone
 UPDATE `creature_proto` SET `npcflags` = `npcflags`|'8192' WHERE (`entry`='29488');
 
 -- Teleport to Amber Ledge coords thx to Bartus
-REPLACE INTO teleport_coords VALUES (50135,'Teleport: Amber Ledge',571,3605.14,6018.22,138.615,4.215); 
+REPLACE INTO teleport_coords VALUES 
+(50135,'Teleport: Amber Ledge',571,3605.14,6018.22,138.615,4.215); 
 
 -- Quest: Runeforging: Preparation For Battle (workaround)
 UPDATE `quests` SET `flags` = '8', `SpecialFlags` = '8', `ReqCastSpellId1`='0', `EndText` = '', `ObjectiveText1` = 'Weapon Emblazoned', `ReqKillMobOrGOId1` = '1', `ReqKillMobOrGOCount1` = '1' WHERE `entry` = '12842';
@@ -478,109 +487,62 @@
 UPDATE `quests` SET `ObjectiveText1` = 'Nestlewood Owlkin inoculated', `ReqKillMobOrGOId1` = '16518', `ReqKillMobOrGOCount1` = '6', `ReqCastSpellId1` = '29528' WHERE `entry` = '9303';
 
 -- Sartharion Encounter(The Obsidian Sanctum)
-UPDATE creature_proto SET faction=103, scale=0.5 WHERE entry=30616;
-UPDATE creature_proto SET faction=103 WHERE entry=30648;
+UPDATE `creature_proto` SET `faction` = 103, `scale` = 0.5 WHERE `entry` = 30616;
+UPDATE `creature_proto` SET `faction` = 103 WHERE `entry` = 30648;
 
 -- Nexus
 -- UPDATE `creature_proto` SET CanMove=0 WHERE entry=26763;
-UPDATE `creature_proto` SET faction=103 WHERE entry=27099;
+UPDATE `creature_proto` SET `faction` = 103 WHERE `entry` = 27099;
 
 -- Jajcer stuff
-DELETE FROM gameobject_spawns WHERE Entry = 182175 AND Map = 530;
-DELETE FROM gameobject_spawns WHERE Entry = 182174 AND Map = 530;
-DELETE FROM gameobject_spawns WHERE Entry = 182173 AND Map = 530;
-DELETE FROM gameobject_spawns WHERE Entry = 183515 AND Map = 530;
-DELETE FROM gameobject_spawns WHERE Entry = 182525 AND Map = 530;
-DELETE FROM gameobject_spawns WHERE Entry = 183514 AND Map = 530;
+DELETE FROM `gameobject_spawns` WHERE `Entry` = 182175 AND `Map` = 530;
+DELETE FROM `gameobject_spawns` WHERE `Entry` = 182174 AND `Map` = 530;
+DELETE FROM `gameobject_spawns` WHERE `Entry` = 182173 AND `Map` = 530;
+DELETE FROM `gameobject_spawns` WHERE `Entry` = 183515 AND `Map` = 530;
+DELETE FROM `gameobject_spawns` WHERE `Entry` = 182525 AND `Map` = 530;
+DELETE FROM `gameobject_spawns` WHERE `Entry` = 183514 AND `Map` = 530;
 
-REPLACE INTO `areatriggers` VALUES ('4162', '0', '1', '0', 'Silithus, Hive\'Zora, Alliance Camp', '-7142.04', '1397.92', '4.32689', '0', '0', '1');
-REPLACE INTO `areatriggers` VALUES ('4168', '0', '1', '0', 'Silithus, Hive Regal, Horde Camp', '-7588.48', '756.806', '-16.4248', '0', '0', '1');
+REPLACE INTO `areatriggers` VALUES 
+('4162', '0', '1', '0', 'Silithus, Hive\'Zora, Alliance Camp', '-7142.04', '1397.92', '4.32689', '0', '0', '1'),
+('4168', '0', '1', '0', 'Silithus, Hive Regal, Horde Camp', '-7588.48', '756.806', '-16.4248', '0', '0', '1');
 
-UPDATE `creature_proto` SET `npcflags`='129' WHERE `entry` in ('18564', '18581');
+UPDATE `creature_proto` SET `npcflags` = '129' WHERE `entry` IN ('18564', '18581');
 
-DELETE FROM gameobject_spawns WHERE `Map` = 530 AND `entry` in (182529, 182527, 182528);
-DELETE FROM gameobject_spawns WHERE `Map` = 530 AND `entry` in (182523, 182522);
-REPLACE INTO `gameobject_names` (entry, Type, DisplayID, Name, Category, CastBarText, UnkStr, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14) VALUES ('182522', '29', '6834', 'Zangarmarsh Banner', '', '', '', '60', '11515', '2527', '2528', '0', '0', '11813', '11812', '11805', '11804', '11808', '11809', '80', '2529', '1', '5', '300', '600', '1', '0', '0', '0', '0', '0');
-REPLACE INTO `gameobject_names` (entry, Type, DisplayID, Name, Category, CastBarText, UnkStr, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14) VALUES ('182523', '29', '6834', 'Zangarmarsh Banner', '', '', '', '60', '11515', '2533', '2534', '0', '0', '11816', '11817', '11807', '11806', '11814', '11815', '80', '2535', '1', '5', '300', '600', '1', '0', '0', '0', '0', '0');
+DELETE FROM gameobject_spawns WHERE `Map` = 530 AND `entry` IN (182529, 182527, 182528);
+DELETE FROM gameobject_spawns WHERE `Map` = 530 AND `entry` IN (182523, 182522);
+REPLACE INTO `gameobject_names` (entry, Type, DisplayID, Name, Category, CastBarText, UnkStr, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14) VALUES 
+('182522', '29', '6834', 'Zangarmarsh Banner', '', '', '', '60', '11515', '2527', '2528', '0', '0', '11813', '11812', '11805', '11804', '11808', '11809', '80', '2529', '1', '5', '300', '600', '1', '0', '0', '0', '0', '0'),
+('182523', '29', '6834', 'Zangarmarsh Banner', '', '', '', '60', '11515', '2533', '2534', '0', '0', '11816', '11817', '11807', '11806', '11814', '11815', '80', '2535', '1', '5', '300', '600', '1', '0', '0', '0', '0', '0');
 UPDATE `gameobject_names` SET `Type`='1' WHERE (`entry`='182527');
 UPDATE `gameobject_names` SET `Type`='1' WHERE (`entry`='182529');
 UPDATE `gameobject_names` SET `Type`='1' WHERE (`entry`='182528');
 
-delete from gameobject_spawns where entry = 181597;
+DELETE FROM `gameobject_spawns` WHERE `entry` = 181597;
 
 REPLACE INTO `graveyards` VALUES ('142', '248.339', '7084.93', '36.6211', '0', '3521', '0', '530', '4', 'Twin Spire Ruins');
 
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2647','1','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2648','0','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2649','0','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2652','1','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2560','1','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2646','1','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2557','1','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2650','0','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2558','0','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2644','0','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2555','0','');
 
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2651','0','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2559','0','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2645','0','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2556','0','');
+DELETE FROM `gameobject_spawns` WHERE `Map` = 530 AND `entry` IN (183104, 183411, 182301, 183412, 183413, 183414);
 
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2527','0','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2528','0','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2533','0','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2534','0','');
 
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2655','0','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2658','0','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2656','1','');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3521','-1','2657','1','');
-
-DELETE FROM gameobject_spawns WHERE `Map` = 530 AND `entry` in (183104, 183411, 182301, 183412, 183413, 183414);
-
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2621','0','WORLDSTATE_TEROKKAR_ALLIANCE_TOWERS_CONTROLLED');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2622','0','WORLDSTATE_TEROKKAR_HORDE_TOWERS_CONTROLLED');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2620','1','WORLDSTATE_TEROKKAR_TOWER_DISPLAY');
-
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2623','0','WORLDSTATE_TEROKKAR_PVP_CAPTURE_BAR_DISPLAY');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2625','0','WORLDSTATE_TEROKKAR_PVP_CAPTURE_BAR_VALUE');
-
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2681','1','WORLDSTATE_TEROKKAR_TOWER1_NEUTRAL');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2686','1','WORLDSTATE_TEROKKAR_TOWER2_NEUTRAL');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2690','1','WORLDSTATE_TEROKKAR_TOWER3_NEUTRAL');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2696','1','WORLDSTATE_TEROKKAR_TOWER4_NEUTRAL');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2693','1','WORLDSTATE_TEROKKAR_TOWER5_NEUTRAL');
-
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2683','0','WORLDSTATE_TEROKKAR_TOWER1_ALLIANCE');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2684','0','WORLDSTATE_TEROKKAR_TOWER2_ALLIANCE');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2688','0','WORLDSTATE_TEROKKAR_TOWER3_ALLIANCE');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2694','0','WORLDSTATE_TEROKKAR_TOWER4_ALLIANCE');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2691','0','WORLDSTATE_TEROKKAR_TOWER5_ALLIANCE');
-
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2682','0','WORLDSTATE_TEROKKAR_TOWER1_HORDE');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2685','0','WORLDSTATE_TEROKKAR_TOWER2_HORDE');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2689','0','WORLDSTATE_TEROKKAR_TOWER3_HORDE');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2695','0','WORLDSTATE_TEROKKAR_TOWER4_HORDE');
--- REPLACE INTO `worldstate_template` (`mapid`,`zone_mask`,`faction_mask`,`field_number`,`initial_value`,`comment`) VALUES ('530','3519','-1','2692','0','WORLDSTATE_TEROKKAR_TOWER5_HORDE');
-
 -- Tariolstrasz Torastrasza and Lord Afrasastrasz  For Wyrmrest Temple Gossip
 UPDATE `creature_proto` SET `npcflags`='3' WHERE `entry` IN (26443,26949,27575);
 
 -- Halls of lightning doors
-UPDATE `gameobject_spawns` SET State=1 WHERE entry IN ( 191416, 191325, 191324, 191326, 191328);
+UPDATE `gameobject_spawns` SET `State` = 1 WHERE `entry` IN ( 191416, 191325, 191324, 191326, 191328);
 
 -- Old hilsbrad foothills related sql queries
-DELETE FROM gameobject_spawns WHERE entry=183816;
-DELETE FROM gameobject_spawns WHERE entry=182592;
+DELETE FROM `gameobject_spawns` WHERE `entry` = 183816;
+DELETE FROM `gameobject_spawns` WHERE `entry` = 182592;
 
-delete from `npc_text` where entry=10475;
-delete from `npc_text` where entry=10474;
-delete from `npc_text` where entry=9779;
-delete from `npc_text` where entry=9780;
-delete from `npc_text` where entry=9568;
-insert into `npc_text` (`entry`, `prob0`, `text0_0`, `text0_1`, `lang0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `prob1`, `text1_0`, `text1_1`, `lang1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `prob2`, `text2_0`, `text2_1`, `lang2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `prob3`, `text3_0`, `text3_1`, `lang3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `prob4`, `text4_0`, `text4_1`, `lang4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `prob5`, `text5_0`, `text5_1`, `lang5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `prob6`, `text6_0`, `text6_1`, `lang6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `prob7`, `text7_0`, `text7_1`, `lang7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`) values('9568','1','','Hi!  Do you think you might help me to get out of here?','0','0','6','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0');
-insert into `npc_text` (`entry`, `prob0`, `text0_0`, `text0_1`, `lang0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `prob1`, `text1_0`, `text1_1`, `lang1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `prob2`, `text2_0`, `text2_1`, `lang2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `prob3`, `text3_0`, `text3_1`, `lang3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `prob4`, `text4_0`, `text4_1`, `lang4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `prob5`, `text5_0`, `text5_1`, `lang5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `prob6`, `text6_0`, `text6_1`, `lang6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `prob7`, `text7_0`, `text7_1`, `lang7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`) values('9779','1','I can take you to Durnholde directly, if that is your wish.','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0');
-insert into `npc_text` (`entry`, `prob0`, `text0_0`, `text0_1`, `lang0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `prob1`, `text1_0`, `text1_1`, `lang1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `prob2`, `text2_0`, `text2_1`, `lang2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `prob3`, `text3_0`, `text3_1`, `lang3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `prob4`, `text4_0`, `text4_1`, `lang4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `prob5`, `text5_0`, `text5_1`, `lang5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `prob6`, `text6_0`, `text6_1`, `lang6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `prob7`, `text7_0`, `text7_1`, `lang7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`) values('9780','1','You should recieve a pack of incendiary bombs from Erozion before I fly you to Durnholde. You wouldn\'t want to waste time, after all.','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0');
-insert into `npc_text` (`entry`, `prob0`, `text0_0`, `text0_1`, `lang0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `prob1`, `text1_0`, `text1_1`, `lang1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `prob2`, `text2_0`, `text2_1`, `lang2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `prob3`, `text3_0`, `text3_1`, `lang3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `prob4`, `text4_0`, `text4_1`, `lang4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `prob5`, `text5_0`, `text5_1`, `lang5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `prob6`, `text6_0`, `text6_1`, `lang6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `prob7`, `text7_0`, `text7_1`, `lang7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`) values('10474','1','If you are ready and wish to quickly return to the normal time stream, I can transport you to Andormu in the Caverns of Time.','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0');
-insert into `npc_text` (`entry`, `prob0`, `text0_0`, `text0_1`, `lang0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `prob1`, `text1_0`, `text1_1`, `lang1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `prob2`, `text2_0`, `text2_1`, `lang2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `prob3`, `text3_0`, `text3_1`, `lang3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `prob4`, `text4_0`, `text4_1`, `lang4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `prob5`, `text5_0`, `text5_1`, `lang5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `prob6`, `text6_0`, `text6_1`, `lang6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `prob7`, `text7_0`, `text7_1`, `lang7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`) values('10475','1','Shaping the flow of time is a very difficult and quite delicate task, but you have performed admirably today.','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0');
+DELETE FROM `npc_text` WHERE `entry` = 10475;
+DELETE FROM `npc_text` WHERE `entry` = 10474;
+DELETE FROM `npc_text` WHERE `entry` = 9779;
+DELETE FROM `npc_text` WHERE `entry` = 9780;
+DELETE FROM `npc_text` WHERE `entry` = 9568;
+INSERT INTO `npc_text` (`entry`, `prob0`, `text0_0`, `text0_1`, `lang0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `prob1`, `text1_0`, `text1_1`, `lang1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `prob2`, `text2_0`, `text2_1`, `lang2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `prob3`, `text3_0`, `text3_1`, `lang3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `prob4`, `text4_0`, `text4_1`, `lang4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `prob5`, `text5_0`, `text5_1`, `lang5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `prob6`, `text6_0`, `text6_1`, `lang6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `prob7`, `text7_0`, `text7_1`, `lang7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`) values
+('9568','1','','Hi!  Do you think you might help me to get out of here?','0','0','6','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0'),
+('9779','1','I can take you to Durnholde directly, if that is your wish.','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0'),
+('9780','1','You should recieve a pack of incendiary bombs from Erozion before I fly you to Durnholde. You wouldn\'t want to waste time, after all.','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0'),
+('10474','1','If you are ready and wish to quickly return to the normal time stream, I can transport you to Andormu in the Caverns of Time.','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0'),
+('10475','1','Shaping the flow of time is a very difficult and quite delicate task, but you have performed admirably today.','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0');


fully working but could not upload the *.patch file because it's too great.

This post has been edited by suchASunthan: 07 July 2010 - 05:10 AM

Koninzidenz begründet keine Korrelation und ist kein Beweis für Kausalität!

coincidence causes no correlation and in´t a argument for causality!

Posted Image
Posted Image
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users