diff options
-rw-r--r-- | sql/updates/741_world.sql | 10 | ||||
-rw-r--r-- | sql/updates/747_world.sql | 2 | ||||
-rw-r--r-- | sql/updates/748_world_scripts.sql | 5 | ||||
-rw-r--r-- | sql/updates/758_world_scripts.sql | 9 | ||||
-rw-r--r-- | sql/updates/762_world.sql | 2 | ||||
-rw-r--r-- | sql/updates/764_world_scripts.sql | 230 | ||||
-rw-r--r-- | sql/updates/765_world_scripts.sql | 2 | ||||
-rw-r--r-- | sql/updates/773_world_scripts.sql | 6 | ||||
-rw-r--r-- | sql/updates/783_world.sql | 4 | ||||
-rw-r--r-- | sql/updates/785_world.sql | 4 | ||||
-rw-r--r-- | sql/updates/789_world.sql | 2 | ||||
-rw-r--r-- | sql/updates/807_world_scripts.sql | 2 | ||||
-rw-r--r-- | sql/world_scripts_full.sql | 3 |
13 files changed, 137 insertions, 144 deletions
diff --git a/sql/updates/741_world.sql b/sql/updates/741_world.sql deleted file mode 100644 index a93d4e2bd01..00000000000 --- a/sql/updates/741_world.sql +++ /dev/null @@ -1,10 +0,0 @@ -REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket list','1','Displays a list of open GM tickets.'); -REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket onlinelist','1','Displays a list of open GM tickets whose owner is online.'); -REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket viewname','1','Usage: .ticket viewname $creatorname. \r\nReturns details about specified ticket. Ticket must be open and not deleted.'); -REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket viewid','1','Usage: .ticket viewid $ticketid.\r\nReturns details about specified ticket. Ticket must be open and not deleted.'); -REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket close','2','Usage: .ticket close $ticketid.\r\nCloses the specified ticket. Does not delete permanently.'); -REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket delete','3','Usage: .ticket delete $ticketid.\r\nDeletes the specified ticket permanently. Ticket must be closed first.'); -REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket assign','3','Usage: .ticket assign $ticketid $gmname.\r\nAssigns the specified ticket to the specified Game Master.'); -REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket unassign','3','Usage: .ticket unassign $ticketid.\r\nUnassigns the specified ticket from the current assigned Game Master.'); -REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket comment','2','Usage: .ticket comment $ticketid $comment.\r\nAllows the adding or modifying of a comment to the specified ticket.'); -REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('reload tickets','4','Usage: .reload tickets.\r\nReloads GM Tickets from the database and re-caches them into memory.'); diff --git a/sql/updates/747_world.sql b/sql/updates/747_world.sql index b526781b141..0fd9c3552e4 100644 --- a/sql/updates/747_world.sql +++ b/sql/updates/747_world.sql @@ -1 +1 @@ -UPDATE `trinity_string` SET `content_default`='Ticket %d is already assigned.' WHERE (`entry`='2008');
\ No newline at end of file +UPDATE `trinity_string` SET `content_default`='Ticket %d is already assigned.' WHERE `entry`=2008;
\ No newline at end of file diff --git a/sql/updates/748_world_scripts.sql b/sql/updates/748_world_scripts.sql index eb5b7c94992..2c1f692056d 100644 --- a/sql/updates/748_world_scripts.sql +++ b/sql/updates/748_world_scripts.sql @@ -1,2 +1,3 @@ -update creature_template set scriptname='npc_infused_crystal', flags_extra=0 where entry=16364; -delete from creature where id=17086;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_infused_crystal' WHERE `entry`=16364; +UPDATE `creature_template` SET `flags_extra`=0 WHERE `entry`=16364; +DELETE FROM `creature` WHERE `id`=17086;
\ No newline at end of file diff --git a/sql/updates/758_world_scripts.sql b/sql/updates/758_world_scripts.sql index a988a426df7..3e8ca0f38b9 100644 --- a/sql/updates/758_world_scripts.sql +++ b/sql/updates/758_world_scripts.sql @@ -1,5 +1,6 @@ -delete from creature_template_addon where entry = 17225; -update creature_template set scriptname = 'boss_nightbane', unit_flags=0 where entry = 17225; -delete from event_scripts where id = 10951; -insert into event_scripts values +DELETE FROM `creature_template_addon` WHERE `entry`=17225; +UPDATE `creature_template` SET `ScriptName`='boss_nightbane' WHERE `entry`=17225; +UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=17225; +DELETE FROM `event_scripts` WHERE `id`=10951; +INSERT INTO `event_scripts` VALUES (10951,0,10,17651,180000,0,-11159,-1907.22,91.48,0);
\ No newline at end of file diff --git a/sql/updates/762_world.sql b/sql/updates/762_world.sql index 4f32617b0ee..6e69f078743 100644 --- a/sql/updates/762_world.sql +++ b/sql/updates/762_world.sql @@ -2,5 +2,5 @@ DROP TABLE IF EXISTS `transport_events`; CREATE TABLE `transport_events` ( `entry` int(11) unsigned NOT NULL default '0', `waypoint_id` int(11) unsigned NOT NULL default '0', - `event_id` int(11) unsigned NOT NULL default '0' + `event_id` int(11) unsigned NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\ No newline at end of file diff --git a/sql/updates/764_world_scripts.sql b/sql/updates/764_world_scripts.sql index d071d870233..2a8e7b23b12 100644 --- a/sql/updates/764_world_scripts.sql +++ b/sql/updates/764_world_scripts.sql @@ -1,123 +1,123 @@ +UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=16062; +UPDATE `creature_template` SET `ScriptName`='boss_rivendare_naxx' WHERE `entry`=30549; + DELETE FROM `script_texts` WHERE `entry` BETWEEN -1533039 AND -1533000; INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`) VALUES (-1533000,'Ahh... welcome to my parlor.',8788,1,0,'anubrekhan SAY_GREET'), - (-1533001,'Just a little taste...',8785,1,0,'anubrekhan SAY_AGGRO1'), - (-1533002,'There is no way out.',8786,1,0,'anubrekhan SAY_AGGRO2'), - (-1533003,'Yes, Run! It makes the blood pump faster!',8787,1,0,'anubrekhan SAY_AGGRO3'), - (-1533004,'I hear little hearts beating. Yesss... beating faster now. Soon the beating will stop.',8790,1,0,'anubrekhan SAY_TAUNT1'), - (-1533005,'Where to go? What to do? So many choices that all end in pain, end in death.',8791,1,0,'anubrekhan SAY_TAUNT2'), - (-1533006,'Which one shall I eat first? So difficult to choose... the all smell so delicious.',8792,1,0,'anubrekhan SAY_TAUNT3'), - (-1533007,'Closer now... tasty morsels. I\'ve been too long without food. Without blood to drink.',8793,1,0,'anubrekhan SAY_TAUNT4'), - (-1533008,'Shh... it will all be over soon.',8789,1,0,'anubrekhan SAY_SLAY'), - (-1533009,'Your old lives, your mortal desires, mean nothing. You are acolytes of the master now, and you will serve the cause without question! The greatest glory is to die in the master\'s service!',8799,1,0,'faerlina SAY_GREET'), - (-1533010,'Slay them in the master\'s name!',8794,1,0,'faerlina SAY_AGGRO1'), - (-1533011,'You cannot hide from me!',8795,1,0,'faerlina SAY_AGGRO2'), - (-1533012,'Kneel before me, worm!',8796,1,0,'faerlina SAY_AGGRO3'), - (-1533013,'Run while you still can!',8797,1,0,'faerlina SAY_AGGRO4'), - (-1533014,'You have failed!',8800,1,0,'faerlina SAY_SLAY1'), - (-1533015,'Pathetic wretch!',8801,1,0,'faerlina SAY_SLAY2'), - (-1533016,'The master... will avenge me!',8798,1,0,'faerlina SAY_DEATH'), - (-1533017,'Patchwerk want to play!',8909,1,0,'patchwerk SAY_AGGRO1'), - (-1533018,'Kel\'Thuzad make Patchwerk his Avatar of War!',8910,1,0,'patchwerk SAY_AGGRO2'), - (-1533019,'No more play?',8912,1,0,'patchwerk SAY_SLAY'), - (-1533020,'What happened to... Patch...',8911,1,0,'patchwerk SAY_DEATH'), - (-1533021,'goes into a berserker rage!',0,2,0,'patchwerk EMOTE_BERSERK'), - (-1533022,'becomes enraged!',0,2,0,'patchwerk EMOTE_ENRAGE'), - (-1533023,'Stalagg crush you!',8864,1,0,'stalagg SAY_STAL_AGGRO'), - (-1533024,'Stalagg kill!',8866,1,0,'stalagg SAY_STAL_SLAY'), - (-1533025,'Master save me...',8865,1,0,'stalagg SAY_STAL_DEATH'), - (-1533026,'Feed you to master!',8802,1,0,'feugen SAY_FEUG_AGGRO'), - (-1533027,'Feugen make master happy!',8804,1,0,'feugen SAY_FEUG_SLAY'), - (-1533028,'No... more... Feugen...',8803,1,0,'feugen SAY_FEUG_DEATH'), - (-1533029,'You are too late... I... must... OBEY!',8872,1,0,'thaddius SAY_GREET'), - (-1533030,'KILL!',8867,1,0,'thaddius SAY_AGGRO1'), - (-1533031,'EAT YOUR BONES!',8868,1,0,'thaddius SAY_AGGRO2'), - (-1533032,'BREAK YOU!',8869,1,0,'thaddius SAY_AGGRO3'), - (-1533033,'You die now!',8877,1,0,'thaddius SAY_SLAY'), - (-1533034,'Now YOU feel pain!',8871,1,0,'thaddius SAY_ELECT'), - (-1533035,'Thank... you...',8870,1,0,'thaddius SAY_DEATH'), - (-1533036,'Pleeease!',8873,1,0,'thaddius SAY_SCREAM1'), - (-1533037,'Stop, make it stop!',8874,1,0,'thaddius SAY_SCREAM2'), - (-1533038,'Help me! Save me!',8875,1,0,'thaddius SAY_SCREAM3'), - (-1533039,'Please, nooo!',8876,1,0,'thaddius SAY_SCREAM4'); +(-1533001,'Just a little taste...',8785,1,0,'anubrekhan SAY_AGGRO1'), +(-1533002,'There is no way out.',8786,1,0,'anubrekhan SAY_AGGRO2'), +(-1533003,'Yes, Run! It makes the blood pump faster!',8787,1,0,'anubrekhan SAY_AGGRO3'), +(-1533004,'I hear little hearts beating. Yesss... beating faster now. Soon the beating will stop.',8790,1,0,'anubrekhan SAY_TAUNT1'), +(-1533005,'Where to go? What to do? So many choices that all end in pain, end in death.',8791,1,0,'anubrekhan SAY_TAUNT2'), +(-1533006,'Which one shall I eat first? So difficult to choose... the all smell so delicious.',8792,1,0,'anubrekhan SAY_TAUNT3'), +(-1533007,'Closer now... tasty morsels. I\'ve been too long without food. Without blood to drink.',8793,1,0,'anubrekhan SAY_TAUNT4'), +(-1533008,'Shh... it will all be over soon.',8789,1,0,'anubrekhan SAY_SLAY'), +(-1533009,'Your old lives, your mortal desires, mean nothing. You are acolytes of the master now, and you will serve the cause without question! The greatest glory is to die in the master\'s service!',8799,1,0,'faerlina SAY_GREET'), +(-1533010,'Slay them in the master\'s name!',8794,1,0,'faerlina SAY_AGGRO1'), +(-1533011,'You cannot hide from me!',8795,1,0,'faerlina SAY_AGGRO2'), +(-1533012,'Kneel before me, worm!',8796,1,0,'faerlina SAY_AGGRO3'), +(-1533013,'Run while you still can!',8797,1,0,'faerlina SAY_AGGRO4'), +(-1533014,'You have failed!',8800,1,0,'faerlina SAY_SLAY1'), +(-1533015,'Pathetic wretch!',8801,1,0,'faerlina SAY_SLAY2'), +(-1533016,'The master... will avenge me!',8798,1,0,'faerlina SAY_DEATH'), +(-1533017,'Patchwerk want to play!',8909,1,0,'patchwerk SAY_AGGRO1'), +(-1533018,'Kel\'Thuzad make Patchwerk his Avatar of War!',8910,1,0,'patchwerk SAY_AGGRO2'), +(-1533019,'No more play?',8912,1,0,'patchwerk SAY_SLAY'), +(-1533020,'What happened to... Patch...',8911,1,0,'patchwerk SAY_DEATH'), +(-1533021,'goes into a berserker rage!',0,2,0,'patchwerk EMOTE_BERSERK'), +(-1533022,'becomes enraged!',0,2,0,'patchwerk EMOTE_ENRAGE'), +(-1533023,'Stalagg crush you!',8864,1,0,'stalagg SAY_STAL_AGGRO'), +(-1533024,'Stalagg kill!',8866,1,0,'stalagg SAY_STAL_SLAY'), +(-1533025,'Master save me...',8865,1,0,'stalagg SAY_STAL_DEATH'), +(-1533026,'Feed you to master!',8802,1,0,'feugen SAY_FEUG_AGGRO'), +(-1533027,'Feugen make master happy!',8804,1,0,'feugen SAY_FEUG_SLAY'), +(-1533028,'No... more... Feugen...',8803,1,0,'feugen SAY_FEUG_DEATH'), +(-1533029,'You are too late... I... must... OBEY!',8872,1,0,'thaddius SAY_GREET'), +(-1533030,'KILL!',8867,1,0,'thaddius SAY_AGGRO1'), +(-1533031,'EAT YOUR BONES!',8868,1,0,'thaddius SAY_AGGRO2'), +(-1533032,'BREAK YOU!',8869,1,0,'thaddius SAY_AGGRO3'), +(-1533033,'You die now!',8877,1,0,'thaddius SAY_SLAY'), +(-1533034,'Now YOU feel pain!',8871,1,0,'thaddius SAY_ELECT'), +(-1533035,'Thank... you...',8870,1,0,'thaddius SAY_DEATH'), +(-1533036,'Pleeease!',8873,1,0,'thaddius SAY_SCREAM1'), +(-1533037,'Stop, make it stop!',8874,1,0,'thaddius SAY_SCREAM2'), +(-1533038,'Help me! Save me!',8875,1,0,'thaddius SAY_SCREAM3'), +(-1533039,'Please, nooo!',8876,1,0,'thaddius SAY_SCREAM4'); DELETE FROM `script_texts` WHERE `entry` BETWEEN -1533074 AND -1533040; - INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`) VALUES - (-1533040,'Foolishly you have sought your own demise. Brazenly you have disregarded powers beyond your understanding. You have fought hard to invade the realm of the harvester. Now there is only one way out - to walk the lonely path of the damned.',8807,1,0,'gothik SAY_SPEECH'), - (-1533041,'Death is the only escape.',8806,1,0,'gothik SAY_KILL'), - (-1533042,'I... am... undone!',8805,1,0,'gothik SAY_DEATH'), - (-1533043,'I have waited long enough! Now, you face the harvester of souls!',8808,1,0,'gothik SAY_TELEPORT'), - (-1533044,'Defend youself!',8892,1,0,'blaumeux SAY_BLAU_AGGRO'), - (-1533045,'Come, Zeliek, do not drive them out. Not before we\'ve had our fun.',8896,1,0,'blaumeux SAY_BLAU_TAUNT1'), - (-1533046,'I do hope they stay alive long enough for me to... introduce myself.',8897,1,0,'blaumeux SAY_BLAU_TAUNT2'), - (-1533047,'The first kill goes to me! Anyone care to wager?',8898,1,0,'blaumeux SAY_BLAU_TAUNT3'), - (-1533048,'Your life is mine!',8895,1,0,'blaumeux SAY_BLAU_SPECIAL'), - (-1533049,'Who\'s next?',8894,1,0,'blaumeux SAY_BLAU_SLAY'), - (-1533050,'Tou... che!',8893,1,0,'blaumeux SAY_BLAU_DEATH'), - (-1533051,'Come out and fight, ye wee ninny!',8899,1,0,'korthazz SAY_KORT_AGGRO'), - (-1533052,'To arms, ye roustabouts! We\'ve got company!',8903,1,0,'korthazz SAY_KORT_TAUNT1'), - (-1533053,'I heard about enough of yer sniveling. Shut yer fly trap \'afore I shut it for ye!',8904,1,0,'korthazz SAY_KORT_TAUNT2'), - (-1533054,'I\'m gonna enjoy killin\' these slack-jawed daffodils!',8905,1,0,'korthazz SAY_KORT_TAUNT3'), - (-1533055,'I like my meat extra crispy!',8901,1,0,'korthazz SAY_KORT_SPECIAl'), - (-1533056,'Next time, bring more friends!',8902,1,0,'korthazz SAY_KORT_SLAY'), - (-1533057,'What a bloody waste this is!',8900,1,0,'korthazz SAY_KORT_DEATH'), - (-1533058,'Flee, before it\'s too late!',8913,1,0,'zeliek SAY_ZELI_AGGRO'), - (-1533059,'Invaders, cease this foolish venture at once! Turn away while you still can!',8917,1,0,'zeliek SAY_ZELI_TAUNT1'), - (-1533060,'Perhaps they will come to their senses, and run away as fast as they can!',8918,1,0,'zeliek SAY_ZELI_TAUNT2'), - (-1533061,'Do not continue! Turn back while there\'s still time!',8919,1,0,'zeliek SAY_ZELI_TAUNT3'), - (-1533062,'I- I have no choice but to obey!',8916,1,0,'zeliek SAY_ZELI_SPECIAL'), - (-1533063,'Forgive me!',8915,1,0,'zeliek SAY_ZELI_SLAY'), - (-1533064,'It is... as it should be.',8914,1,0,'zeliek SAY_ZELI_DEATH'), - (-1533065,'You seek death?',14571,1,0,'rivendare_naxx SAY_RIVE_AGGRO1'), - (-1533066,'None shall pass!',14572,1,0,'rivendare_naxx SAY_RIVE_AGGRO2'), - (-1533067,'Be still!',14573,1,0,'rivendare_naxx SAY_RIVE_AGGRO3'), - (-1533068,'You will find no peace in death.',14574,1,0,'rivendare_naxx SAY_RIVE_SLAY1'), - (-1533069,'The master\'s will is done.',14575,1,0,'rivendare_naxx SAY_RIVE_SLAY2'), - (-1533070,'Bow to the might of the scourge!',14576,1,0,'rivendare_naxx SAY_RIVE_SPECIAL'), - (-1533071,'Enough prattling. Let them come! We shall grind their bones to dust.',14577,1,0,'rivendare_naxx SAY_RIVE_TAUNT1'), - (-1533072,'Conserve your anger! Harness your rage! You will all have outlets for your frustration soon enough.',14578,1,0,'rivendare_naxx SAY_RIVE_TAUNT2'), - (-1533073,'Life is meaningless. It is in death that we are truly tested.',14579,1,0,'rivendare_naxx SAY_RIVE_TAUNT3'), - (-1533074,'Death... will not stop me...',14580,1,0,'rivendare_naxx SAY_RIVE_DEATH'); - -UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=16062; -UPDATE `creature_template` SET `ScriptName`='boss_rivendare_naxx' WHERE `entry`=30549; +INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`) VALUES +(-1533040,'Foolishly you have sought your own demise. Brazenly you have disregarded powers beyond your understanding. You have fought hard to invade the realm of the harvester. Now there is only one way out - to walk the lonely path of the damned.',8807,1,0,'gothik SAY_SPEECH'), +(-1533041,'Death is the only escape.',8806,1,0,'gothik SAY_KILL'), +(-1533042,'I... am... undone!',8805,1,0,'gothik SAY_DEATH'), +(-1533043,'I have waited long enough! Now, you face the harvester of souls!',8808,1,0,'gothik SAY_TELEPORT'), +(-1533044,'Defend youself!',8892,1,0,'blaumeux SAY_BLAU_AGGRO'), +(-1533045,'Come, Zeliek, do not drive them out. Not before we\'ve had our fun.',8896,1,0,'blaumeux SAY_BLAU_TAUNT1'), +(-1533046,'I do hope they stay alive long enough for me to... introduce myself.',8897,1,0,'blaumeux SAY_BLAU_TAUNT2'), +(-1533047,'The first kill goes to me! Anyone care to wager?',8898,1,0,'blaumeux SAY_BLAU_TAUNT3'), +(-1533048,'Your life is mine!',8895,1,0,'blaumeux SAY_BLAU_SPECIAL'), +(-1533049,'Who\'s next?',8894,1,0,'blaumeux SAY_BLAU_SLAY'), +(-1533050,'Tou... che!',8893,1,0,'blaumeux SAY_BLAU_DEATH'), +(-1533051,'Come out and fight, ye wee ninny!',8899,1,0,'korthazz SAY_KORT_AGGRO'), +(-1533052,'To arms, ye roustabouts! We\'ve got company!',8903,1,0,'korthazz SAY_KORT_TAUNT1'), +(-1533053,'I heard about enough of yer sniveling. Shut yer fly trap \'afore I shut it for ye!',8904,1,0,'korthazz SAY_KORT_TAUNT2'), +(-1533054,'I\'m gonna enjoy killin\' these slack-jawed daffodils!',8905,1,0,'korthazz SAY_KORT_TAUNT3'), +(-1533055,'I like my meat extra crispy!',8901,1,0,'korthazz SAY_KORT_SPECIAl'), +(-1533056,'Next time, bring more friends!',8902,1,0,'korthazz SAY_KORT_SLAY'), +(-1533057,'What a bloody waste this is!',8900,1,0,'korthazz SAY_KORT_DEATH'), +(-1533058,'Flee, before it\'s too late!',8913,1,0,'zeliek SAY_ZELI_AGGRO'), +(-1533059,'Invaders, cease this foolish venture at once! Turn away while you still can!',8917,1,0,'zeliek SAY_ZELI_TAUNT1'), +(-1533060,'Perhaps they will come to their senses, and run away as fast as they can!',8918,1,0,'zeliek SAY_ZELI_TAUNT2'), +(-1533061,'Do not continue! Turn back while there\'s still time!',8919,1,0,'zeliek SAY_ZELI_TAUNT3'), +(-1533062,'I- I have no choice but to obey!',8916,1,0,'zeliek SAY_ZELI_SPECIAL'), +(-1533063,'Forgive me!',8915,1,0,'zeliek SAY_ZELI_SLAY'), +(-1533064,'It is... as it should be.',8914,1,0,'zeliek SAY_ZELI_DEATH'), +(-1533065,'You seek death?',14571,1,0,'rivendare_naxx SAY_RIVE_AGGRO1'), +(-1533066,'None shall pass!',14572,1,0,'rivendare_naxx SAY_RIVE_AGGRO2'), +(-1533067,'Be still!',14573,1,0,'rivendare_naxx SAY_RIVE_AGGRO3'), +(-1533068,'You will find no peace in death.',14574,1,0,'rivendare_naxx SAY_RIVE_SLAY1'), +(-1533069,'The master\'s will is done.',14575,1,0,'rivendare_naxx SAY_RIVE_SLAY2'), +(-1533070,'Bow to the might of the scourge!',14576,1,0,'rivendare_naxx SAY_RIVE_SPECIAL'), +(-1533071,'Enough prattling. Let them come! We shall grind their bones to dust.',14577,1,0,'rivendare_naxx SAY_RIVE_TAUNT1'), +(-1533072,'Conserve your anger! Harness your rage! You will all have outlets for your frustration soon enough.',14578,1,0,'rivendare_naxx SAY_RIVE_TAUNT2'), +(-1533073,'Life is meaningless. It is in death that we are truly tested.',14579,1,0,'rivendare_naxx SAY_RIVE_TAUNT3'), +(-1533074,'Death... will not stop me...',14580,1,0,'rivendare_naxx SAY_RIVE_DEATH'); DELETE FROM `script_texts` WHERE `entry` BETWEEN -1533108 AND -1533075; - INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`) VALUES - (-1533075,'Glory to the master!',8845,1,0,'noth SAY_AGGRO1'), - (-1533076,'Your life is forfeit!',8846,1,0,'noth SAY_AGGRO2'), - (-1533077,'Die, trespasser!',8847,1,0,'noth SAY_AGGRO3'), - (-1533078,'Rise, my soldiers! Rise and fight once more!',8851,1,0,'noth SAY_SUMMON'), - (-1533079,'My task is done!',8849,1,0,'noth SAY_SLAY1'), - (-1533080,'Breathe no more!',8850,1,0,'noth SAY_SLAY2'), - (-1533081,'I will serve the master... in... death!',8848,1,0,'noth SAY_DEATH'), - (-1533082,'takes in a deep breath...',0,2,0,'sapphiron EMOTE_BREATH'), - (-1533083,'enrages!',0,2,0,'sapphiron EMOTE_ENRAGE'), - (-1533084,'Our preparations continue as planned, master.',14467,1,0,'kelthuzad SAY_SAPP_DIALOG1'), - (-1533085,'It is good that you serve me so faithfully. Soon, all will serve the Lich King and in the end, you shall be rewarded...so long as you do not falter.',8881,1,0,'kelthuzad SAY_SAPP_DIALOG2_LICH'), - (-1533086,'I see no complications... Wait... What is this?',14468,1,0,'kelthuzad SAY_SAPP_DIALOG3'), - (-1533087,'Your security measures have failed! See to this interruption immediately!',8882,1,0,'kelthuzad SAY_SAPP_DIALOG4_LICH'), - (-1533088,'Yes, master!',14469,1,0,'kelthuzad SAY_SAPP_DIALOG5'), - (-1533089,'No!!! A curse upon you, interlopers! The armies of the Lich King will hunt you down. You will not escape your fate...',14484,1,0,'kelthuzad SAY_CAT_DIED'), - (-1533090,'Who dares violate the sanctity of my domain? Be warned, all who trespass here are doomed.',14463,1,0,'kelthuzad SAY_TAUNT1'), - (-1533091,'Fools, you think yourselves triumphant? You have only taken one step closer to the abyss! ',14464,1,0,'kelthuzad SAY_TAUNT2'), - (-1533092,'I grow tired of these games. Proceed, and I will banish your souls to oblivion!',14465,1,0,'kelthuzad SAY_TAUNT3'), - (-1533093,'You have no idea what horrors lie ahead. You have seen nothing! The frozen heart of Naxxramas awaits you!',14466,1,0,'kelthuzad SAY_TAUNT4'), - (-1533094,'Pray for mercy!',14475,1,0,'kelthuzad SAY_AGGRO1'), - (-1533095,'Scream your dying breath!',14476,1,0,'kelthuzad SAY_AGGRO2'), - (-1533096,'The end is upon you!',14477,1,0,'kelthuzad SAY_AGGRO3'), - (-1533097,'The dark void awaits you!',14478,1,0,'kelthuzad SAY_SLAY1'), - (-1533098,'<Kel\'Thuzad cackles maniacally!>',14479,1,0,'kelthuzad SAY_SLAY2'), - (-1533099,'AAAAGHHH!... Do not rejoice... your victory is a hollow one... for I shall return with powers beyond your imagining!',14480,1,0,'kelthuzad SAY_DEATH'), - (-1533100,'Your soul, is bound to me now!',14472,1,0,'kelthuzad SAY_CHAIN1'), - (-1533101,'There will be no escape!',14473,1,0,'kelthuzad SAY_CHAIN2'), - (-1533102,'I will freeze the blood in your veins!',14474,1,0,'kelthuzad SAY_FROST_BLAST'), - (-1533103,'Master! I require aid! ',14470,1,0,'kelthuzad SAY_REQUEST_AID'), - (-1533104,'Very well... warriors of the frozen wastes, rise up! I command you to fight, kill, and die for your master. Let none survive...',0,1,0,'kelthuzad SAY_ANSWER_REQUEST'), - (-1533105,'Minions, servants, soldiers of the cold dark, obey the call of Kel\'Thuzad!',14471,1,0,'kelthuzad SAY_SUMMON_MINIONS'), - (-1533106,'Your petty magics are no challenge to the might of the Scourge! ',14481,1,0,'kelthuzad SAY_SPECIAL1_MANA_DET'), - (-1533107,'Enough! I grow tired of these distractions! ',14483,1,0,'kelthuzad SAY_SPECIAL3_MANA_DET'), - (-1533108,'Fools, you have spread your powers too thin. Be free, my minions!',14482,1,0,'kelthuzad SAY_SPECIAL2_DISPELL'); +INSERT INTO `script_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`comment`) VALUES +(-1533075,'Glory to the master!',8845,1,0,'noth SAY_AGGRO1'), +(-1533076,'Your life is forfeit!',8846,1,0,'noth SAY_AGGRO2'), +(-1533077,'Die, trespasser!',8847,1,0,'noth SAY_AGGRO3'), +(-1533078,'Rise, my soldiers! Rise and fight once more!',8851,1,0,'noth SAY_SUMMON'), +(-1533079,'My task is done!',8849,1,0,'noth SAY_SLAY1'), +(-1533080,'Breathe no more!',8850,1,0,'noth SAY_SLAY2'), +(-1533081,'I will serve the master... in... death!',8848,1,0,'noth SAY_DEATH'), +(-1533082,'takes in a deep breath...',0,2,0,'sapphiron EMOTE_BREATH'), +(-1533083,'enrages!',0,2,0,'sapphiron EMOTE_ENRAGE'), +(-1533084,'Our preparations continue as planned, master.',14467,1,0,'kelthuzad SAY_SAPP_DIALOG1'), +(-1533085,'It is good that you serve me so faithfully. Soon, all will serve the Lich King and in the end, you shall be rewarded...so long as you do not falter.',8881,1,0,'kelthuzad SAY_SAPP_DIALOG2_LICH'), +(-1533086,'I see no complications... Wait... What is this?',14468,1,0,'kelthuzad SAY_SAPP_DIALOG3'), +(-1533087,'Your security measures have failed! See to this interruption immediately!',8882,1,0,'kelthuzad SAY_SAPP_DIALOG4_LICH'), +(-1533088,'Yes, master!',14469,1,0,'kelthuzad SAY_SAPP_DIALOG5'), +(-1533089,'No!!! A curse upon you, interlopers! The armies of the Lich King will hunt you down. You will not escape your fate...',14484,1,0,'kelthuzad SAY_CAT_DIED'), +(-1533090,'Who dares violate the sanctity of my domain? Be warned, all who trespass here are doomed.',14463,1,0,'kelthuzad SAY_TAUNT1'), +(-1533091,'Fools, you think yourselves triumphant? You have only taken one step closer to the abyss! ',14464,1,0,'kelthuzad SAY_TAUNT2'), +(-1533092,'I grow tired of these games. Proceed, and I will banish your souls to oblivion!',14465,1,0,'kelthuzad SAY_TAUNT3'), +(-1533093,'You have no idea what horrors lie ahead. You have seen nothing! The frozen heart of Naxxramas awaits you!',14466,1,0,'kelthuzad SAY_TAUNT4'), +(-1533094,'Pray for mercy!',14475,1,0,'kelthuzad SAY_AGGRO1'), +(-1533095,'Scream your dying breath!',14476,1,0,'kelthuzad SAY_AGGRO2'), +(-1533096,'The end is upon you!',14477,1,0,'kelthuzad SAY_AGGRO3'), +(-1533097,'The dark void awaits you!',14478,1,0,'kelthuzad SAY_SLAY1'), +(-1533098,'<Kel\'Thuzad cackles maniacally!>',14479,1,0,'kelthuzad SAY_SLAY2'), +(-1533099,'AAAAGHHH!... Do not rejoice... your victory is a hollow one... for I shall return with powers beyond your imagining!',14480,1,0,'kelthuzad SAY_DEATH'), +(-1533100,'Your soul, is bound to me now!',14472,1,0,'kelthuzad SAY_CHAIN1'), +(-1533101,'There will be no escape!',14473,1,0,'kelthuzad SAY_CHAIN2'), +(-1533102,'I will freeze the blood in your veins!',14474,1,0,'kelthuzad SAY_FROST_BLAST'), +(-1533103,'Master! I require aid! ',14470,1,0,'kelthuzad SAY_REQUEST_AID'), +(-1533104,'Very well... warriors of the frozen wastes, rise up! I command you to fight, kill, and die for your master. Let none survive...',0,1,0,'kelthuzad SAY_ANSWER_REQUEST'), +(-1533105,'Minions, servants, soldiers of the cold dark, obey the call of Kel\'Thuzad!',14471,1,0,'kelthuzad SAY_SUMMON_MINIONS'), +(-1533106,'Your petty magics are no challenge to the might of the Scourge! ',14481,1,0,'kelthuzad SAY_SPECIAL1_MANA_DET'), +(-1533107,'Enough! I grow tired of these distractions! ',14483,1,0,'kelthuzad SAY_SPECIAL3_MANA_DET'), +(-1533108,'Fools, you have spread your powers too thin. Be free, my minions!',14482,1,0,'kelthuzad SAY_SPECIAL2_DISPELL'); - UPDATE `script_texts` SET `sound`=8902 WHERE `entry`=-1533055; - UPDATE `script_texts` SET `sound`=8901 WHERE `entry`=-1533056;
\ No newline at end of file +UPDATE `script_texts` SET `sound`=8902 WHERE `entry`=-1533055; +UPDATE `script_texts` SET `sound`=8901 WHERE `entry`=-1533056;
\ No newline at end of file diff --git a/sql/updates/765_world_scripts.sql b/sql/updates/765_world_scripts.sql index 908a31d404f..1283e75f66c 100644 --- a/sql/updates/765_world_scripts.sql +++ b/sql/updates/765_world_scripts.sql @@ -1,4 +1,4 @@ -UPDATE `creature_template` SET `flags_extra` = 0 WHERE `entry` = 20129; +UPDATE `creature_template` SET `flags_extra`=0 WHERE `entry`=20129; -- Insert English and French dialogs in database DELETE FROM `script_texts` WHERE entry BETWEEN -1000150 and -1000163; diff --git a/sql/updates/773_world_scripts.sql b/sql/updates/773_world_scripts.sql index e07beb784a4..adfb24e945c 100644 --- a/sql/updates/773_world_scripts.sql +++ b/sql/updates/773_world_scripts.sql @@ -1,7 +1,7 @@ -Update quest_template set SpecialFlags=2 where entry=4770; -UPDATE `creature_template` SET `ScriptName` = 'npc_swiftmountain' WHERE `entry` = 10427; +UPDATE `quest_template` SET `SpecialFlags`=2 WHERE `entry`=4770; +UPDATE `creature_template` SET `ScriptName`='npc_swiftmountain' WHERE `entry`=10427; DELETE FROM `script_texts` WHERE `entry` BETWEEN -1000149 AND -1000147; -INSERT INTO script_texts +INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `comment`) VALUES (-1000147, 'Lets go $N. I am ready to start to Whitereach Post.', NULL, NULL, 'Gehen wir $N.Ich bin bereit,mich zum Weissgipfelposten aufzumachen.', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL), diff --git a/sql/updates/783_world.sql b/sql/updates/783_world.sql index 24a8481e24e..7076956dd24 100644 --- a/sql/updates/783_world.sql +++ b/sql/updates/783_world.sql @@ -1,4 +1,4 @@ -DELETE FROM trinity_string where entry IN (10056, 10057); -INSERT INTO trinity_string (entry, content_default) VALUES +DELETE FROM `trinity_string` WHERE `entry` IN (10056, 10057); +INSERT INTO `trinity_string` (entry, content_default) VALUES (10056, 'You must be a member of the Horde to enter the Hall of Legends.'), (10057, 'You must be a member of the Alliance to enter the Champion\'s Hall.');
\ No newline at end of file diff --git a/sql/updates/785_world.sql b/sql/updates/785_world.sql index 747b179f02b..44552de0e53 100644 --- a/sql/updates/785_world.sql +++ b/sql/updates/785_world.sql @@ -1,4 +1,4 @@ -delete from command where name in ('gobject addtemp', 'npc addtemp'); -insert into command (name, security, help) values +DELETE FROM `command` WHERE `name` IN ('gobject addtemp', 'npc addtemp'); +INSERT INTO `command` (name, security, help) values ('gobject addtemp','2','Adds a temporary gameobject that is not saved to DB.'), ('npc addtemp','2','Adds temporary NPC, not saved to database.'); diff --git a/sql/updates/789_world.sql b/sql/updates/789_world.sql index 0c51d1b3fac..475e16538d1 100644 --- a/sql/updates/789_world.sql +++ b/sql/updates/789_world.sql @@ -1 +1 @@ -ALTER TABLE eventai_texts DROP COLUMN emote;
\ No newline at end of file +ALTER TABLE `eventai_texts` DROP COLUMN `emote`;
\ No newline at end of file diff --git a/sql/updates/807_world_scripts.sql b/sql/updates/807_world_scripts.sql index b3729d12f6b..ee2cbee4fee 100644 --- a/sql/updates/807_world_scripts.sql +++ b/sql/updates/807_world_scripts.sql @@ -1 +1 @@ -update creature_template set scriptname='npc_isla_starmane' where entry=18760;
\ No newline at end of file +UPDATE `creature_template` SET `ScriptName`='npc_isla_starmane' WHERE `entry`=18760;
\ No newline at end of file diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql index 80f2fb3a5d1..cb59973d5e2 100644 --- a/sql/world_scripts_full.sql +++ b/sql/world_scripts_full.sql @@ -617,7 +617,6 @@ UPDATE `creature_template` SET `ScriptName`='boss_heigan' WHERE `entry`=15936; UPDATE `creature_template` SET `ScriptName`='boss_loatheb' WHERE `entry`=16011; UPDATE `creature_template` SET `ScriptName`='boss_razuvious' WHERE `entry`=16061; UPDATE `creature_template` SET `ScriptName`='boss_gothik' WHERE `entry`=16060; -UPDATE `creature_template` SET `ScriptName`='boss_highlord_mograine' WHERE `entry`=16062; UPDATE `creature_template` SET `ScriptName`='boss_thane_korthazz' WHERE `entry`=16064; UPDATE `creature_template` SET `ScriptName`='boss_sir_zeliek' WHERE `entry`=16063; UPDATE `creature_template` SET `ScriptName`='boss_lady_blaumeux' WHERE `entry`=16065; @@ -629,6 +628,8 @@ UPDATE `creature_template` SET `ScriptName`='boss_stalagg' WHERE `entry`=15929; UPDATE `creature_template` SET `ScriptName`='boss_fugen' WHERE `entry`=15930; UPDATE `creature_template` SET `ScriptName`='boss_sapphiron' WHERE `entry`=15989; UPDATE `creature_template` SET `ScriptName`='boss_kelthuzad' WHERE `entry`=15990; +UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=16062; +UPDATE `creature_template` SET `ScriptName`='boss_rivendare_naxx' WHERE `entry`=30549; /* NETHERSTORM */ UPDATE `gameobject_template` SET `ScriptName`='go_manaforge_control_console' WHERE `entry` IN (183770,183956,184311,184312); |