diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/762_world.sql | 6 | ||||
| -rw-r--r-- | sql/updates/764_world_scripts.sql | 123 | ||||
| -rw-r--r-- | sql/updates/765_world_scripts.sql | 19 |
3 files changed, 148 insertions, 0 deletions
diff --git a/sql/updates/762_world.sql b/sql/updates/762_world.sql new file mode 100644 index 00000000000..4f32617b0ee --- /dev/null +++ b/sql/updates/762_world.sql @@ -0,0 +1,6 @@ +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' +) 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 new file mode 100644 index 00000000000..d071d870233 --- /dev/null +++ b/sql/updates/764_world_scripts.sql @@ -0,0 +1,123 @@ +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'); + +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; + +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'); + + 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 new file mode 100644 index 00000000000..908a31d404f --- /dev/null +++ b/sql/updates/765_world_scripts.sql @@ -0,0 +1,19 @@ +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; +INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc2`, `type`, `language`, `comment`) VALUES +(-1000150, 'Greetings, $N. I will guide you through the cavern. Please try and keep up.', 'Salutations, $N. Je vais vous guider à travers cette grotte. Veuillez me suivre.', 4, 0, 'WHISPER_CUSTODIAN_1'), +(-1000151, 'We do not know if the Caverns of Time have always been accessible to mortals. Truly, it is impossible to tell as the Timeless One is in perpetual motion, changing our timeways as he sees fit. What you see now may very well not exist tomorrow. You may wake up and have no memory of this place.', 'Nous ne savons pas si les Grottes du Temps ont toujours été accessibles aux mortels. Vraiment, c\'est impossible à dire étant donné que l\'Intemporel est en mouvement perpétuel, changeant nos spirales temporelles comme bon lui semble. Ce que vous voyez aujourd\'hui peut très bien ne plus exister demain. Vous pourriez vous réveiller sans aucun souvenir de cet endroit.', 4, 0, 'WHISPER_CUSTODIAN_2'), +(-1000152, 'It is strange, I know... Most mortals cannot actually comprehend what they see here, as often, what they see is not anchored within their own perception of reality.', 'C\'est étrange, je sais... La plupart des mortels ne peuvent pas réellement comprendre ce qu\ils voient ici, comme souvent, ce qu\'ils voient n\'est pas ancré dans leur propre perception de la réalité.', 4, 0, 'WHISPER_CUSTODIAN_3'), +(-1000153, 'Follow me, please.', 'Veuillez me suivre.', 4, 0, 'WHISPER_CUSTODIAN_4'), +(-1000154, 'There are only two truths to be found here: First, that time is chaotic, always in flux, and completely malleable and second, perception does not dictate reality.', 'Il n\'y a que deux vérités qui peuvent être trouvées ici : premièrement, ce temps est chaotique, toujours en mouvement, et complètement malléable, et ensuite, la perception ne détermine pas la réalité.', 4, 0, 'WHISPER_CUSTODIAN_5'), +(-1000155, 'As custodians of time, we watch over and care for Nozdormu\'s realm. The master is away at the moment, which means that attempts are being made to dramatically alter time. The master never meddles in the affairs of mortals but instead corrects the alterations made to time by others. He is reactionary in this regard.', 'En tant que protecteurs du temps, nous observons et veillons sur le royaume de Nozdormu. Le maître est absent en ce moment, ce qui signifie que des tentatives sont faites pour altérer fortement le temps. Le maître ne se mêle jamais des affaires des mortels mais il corrige les altérations faites au temps par d\'autres. Il est réactionnaire à cet égard.', 4, 0, 'WHISPER_CUSTODIAN_6'), +(-1000156, 'For normal maintenance of time, the Keepers of Time are sufficient caretakers. We are able to deal with most ordinary disturbances. I speak of little things, such as rogue mages changing something in the past to elevate their status or wealth in the present.', 'Pour le maintien normal du temps, les Gardiens du temps suffisent à la tâche. Nous sommes capables de gérer les perturbations les plus ordinaires. Je parle de petites choses, comme des mages voleurs qui changent quelque chose dans le passé pour élever leur statut ou leur richesse dans le présent.', 4, 0, 'WHISPER_CUSTODIAN_7'), +(-1000157, 'These tunnels that you see are called timeways. They are infinite in number. The ones that currently exist in your reality are what the master has deemed as \'trouble spots.\' These trouble spots may differ completely in theme but they always share a cause. That is, their existence is a result of the same temporal disturbance. Remember that should you venture inside one...', 'Ces tunnels que vous voyez sont appelés Voies Temporelles. Leur nombre est infini. Ceux qui existent actuellement dans votre réalité sont ceux que le maître a considérés comme \'points sensibles\'. Ces points sensibles peuvent différer complètement de part leur thème, mais partagent toujours une cause. C\'est-à-dire, leur existence est le résultat des mêmes perturbations temporelles. Rappelez-vous en si vous osez vous aventurer dans l\'un d\'eux...', 4, 0, 'WHISPER_CUSTODIAN_8'), +(-1000158, 'This timeway is in great disarray! We have agents inside right now attempting to restore order. What information I have indicates that Thrall\'s freedom is in jeopardy. A malevolent organization known as the Infinite Dragonflight is trying to prevent his escape. I fear without outside assistance, all will be lost.', 'Cette voie temporelle est en grand désarroi ! Nous avons actuellement des agents à l\intérieur qui tentent de restaurer l\'ordre. Les informations que j\'ai indiquent que la liberté de Thrall est en péril. Une organisation malveillante connue sous le nom de Vol du Dragon Infini essaye d\'empêcher son évasion. J\'ai peur que sans assistance extérieure, tout soit perdu.', 4, 0, 'WHISPER_CUSTODIAN_9'), +(-1000159, 'We have very little information on this timeway. Sa\'at has been dispatched and is currently inside. The data we have gathered from his correspondence is that the Infinite Dragonflight are once again attempting to alter time. Could it be that the opening of the Dark Portal is being targeted for sabotage? Let us hope not...', 'Nous avons très peu d\'informations sur cette voie. Sa\'at a été envoyé et est actuellement sur place. Les données que nous avons recueillies de sa correspondance est que le Vol du Dragon Infini tente une fois de plus d\'altérer le temps. Se pourrait-il que l\'ouverture de la Porte des Ténèbres soit la cible d\'un sabotage. Espérons que non...', 4, 0, 'WHISPER_CUSTODIAN_10'), +(-1000160, 'This timeway is currently collapsing. What that may hold for the past, present and future is currently unknown...', 'Cette voie est en train de s\'effondrer. Ce qu\'elle peut avoir contenu dans le passé, le présent et le futur nous est actuellement inconnu...', 4, 0, 'WHISPER_CUSTODIAN_11'), +(-1000161, 'The timeways are currently ranked in order from least catastrophic to most catastrophic. Note that they are all classified as catastrophic, meaning that any single one of these timeways collapsing would mean that your world would end. We only classify them in such a way so that the heroes and adventurers that are sent here know which timeway best suits their abilities.', 'Les voies sont pour le moment classées de la moins catastrophique à la plus catastrophique, ce qui veut dire que la moindre de celles-ci qui s\'effondre signifierait la fin de votre monde. Nous les classons seulement de cette façon pour que les héros et aventuriers qui y sont envoyés sachent quelle voie est la plus adaptée à leurs compétences.', 4, 0, 'WHISPER_CUSTODIAN_12'), +(-1000162, 'All we know of this timeway is that it leads to Mount Hyjal. The Infinite Dragonflight have gone to great lengths to prevent our involvement. We know next to nothing, mortal. Soridormi is currently attempting to break through the timeway\'s defenses but has thus far been unsuccessful. You might be our only hope of breaking through and resolving the conflict.', 'Tout ce que nous savons sur cette voie temporelle est qu\'elle mène au Mont Hyjal. Le Vol du Dragon Infini s\'est donné beaucoup de peine pour empêcher notre participation. Soridormi est actuellement en train de tenter de briser les défenses de cette voie, mais ses efforts ont été vain jusqu\'ici. Vous pourriez être notre seul espoir de les briser et de résoudre le conflit.', 4, 0, 'WHISPER_CUSTODIAN_13'), +(-1000163, 'Our time is at an end $N. I would wish you luck, if such a thing existed.', 'Notre entretien touche à sa fin, $N. Je vous souhaite bonne chance, si tant est qu\'une telle chose a jamais existé.', 4, 0, 'WHISPER_CUSTODIAN_14');
\ No newline at end of file |