Undercity magic quarter scripts

bulle7proof

New Member
Joined
Feb 10, 2009
Messages
344
Reaction score
68
Code:
-- insert creature summon location
DELETE FROM `creature_ai_summons` WHERE (`id`='286569');
INSERT IGNORE INTO `creature_ai_summons` (`id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `comment`) VALUES ('286569', '1793.26', '128.034', '-63.8432', '3.14159', '30000', '5702');
-- insert event gossip texts
DELETE FROM `creature_ai_texts` WHERE `entry` IN ('-286566','-286567','-286568','-286569','-286570','-286571','-286572','-286573','-286574','-286575','-286576','-286577') AND (`comment`='5702');
INSERT IGNORE INTO `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-286566', 'If you\'re here, then it means you are prepared to begin the study of summoning demonic cohorts to do your bidding. We will start with the lowliest creatures you will be able to call and continue from there. Let us begin.', '0', '0', '33', '0', '5702');
INSERT IGNORE INTO `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-286567', 'The easiest creature for you to summon is the imp. You should already be able to bring forth this minion but for completeness\' sake I will start with him.', '0', '0', '33', '0', '5702');
INSERT IGNORE INTO `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-286568', 'This foul little beast is the imp. It is small and weak, making it almost useless as a meatshield, and its damage output is mediocre at best. This creature is best used for support of a larger group.', '0', '0', '33', '0', '5702');
INSERT IGNORE INTO `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-286569', 'Now that you have had a chance to study imp, let us move on the next minion you will be able to summon, the voidwalker.', '0', '0', '33', '0', '5702');
INSERT IGNORE INTO `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-286570', 'This demonic entity is known as the Voidwalker. Its strength and endurance are significant, making it ideal for defence. Send it to attack your enemy, then use it as a shield while you use your spells and abilities to drain away your opponent\'s life.', '0', '0', '33', '0', '5702');
INSERT IGNORE INTO `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-286571', 'If you\'ve never seen one, it is a sight to behold. A very impressive creature both on and off the field of battle. Next let us take a look at what I am sure all you male students have been waiting for. The succubus.', '0', '0', '33', '0', '5702');
INSERT IGNORE INTO `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-286572', 'All right now. Asside from the obvious distractions a minion like this will provide against your more masculine foes, she is also capable of dealing out impressive amounts of damage. However, her fragile endurance makes her almost useless as a shield.', '0', '0', '33', '0', '5702');
INSERT IGNORE INTO `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-286573', 'Study hard and you might one day be able to summon one on your own, but for now it\'s time to move on to the felhunter.', '0', '0', '33', '0', '5702');
INSERT IGNORE INTO `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-286574', 'What you see before you is a felhunter. This creature\'s natural talents include spell lock and other abilities which make it unequalled when facing a magically attuned opponent.', '0', '0', '33', '0', '5702');
INSERT IGNORE INTO `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-286575', 'When facing a spellcaster of any kind, this feral beast will be your best friend. Now, let us take a look at something a bit different. This next creature will aid your travels and make your future journeys much easier. Let\'s take a look at a felsteed.', '0', '0', '33', '0', '5702');
INSERT IGNORE INTO `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-286576', 'I doubt you have had much occasion to see such a creature. These demonic equines will make your travels much faster by acting as your mount as long as you control them. However, they are difficult to control, so be sure you are ready before attempting it.', '0', '0', '33', '0', '5702');
INSERT IGNORE INTO `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `emote`, `comment`) VALUES ('-286577', 'There you have it. Our lesson on summoning has come to an end. A new class will begin shortly, so if you wish to brush up, feel free to stay around.', '0', '0', '33', '0', '5702');
-- insert Jezelle Pruitt EventAI script
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`='5702');
INSERT INTO `creature_ai_scripts` VALUES 
( 570201, 5702, 1, 0, 100, 1, 0, 0, 235000, 235000, 1, -286566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - event start gossip'),
( 570202, 5702, 1, 0, 100, 1, 10000, 10000, 235000, 235000, 1, -286567, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - imp gossip 1'),
( 570203, 5702, 1, 0, 100, 1, 18000, 18000, 235000, 235000, 32, 5730, 0, 286569, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - summon imp'),
( 570204, 5702, 1, 0, 100, 1, 20000, 20000, 235000, 235000, 1, -286568, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - imp goosip 2'),
( 570205, 5702, 1, 0, 100, 1, 50000, 50000, 235000, 235000, 1, -286569, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - voidwalker gossip 1'),
( 570206, 5702, 1, 0, 100, 1, 58000, 58000, 235000, 235000, 32, 5729, 0, 286569, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - summon voidwalker'),
( 570207, 5702, 1, 0, 100, 1, 60000, 60000, 235000, 235000, 1, -286570, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - voidwalker gossip 2'),
( 570208, 5702, 1, 0, 100, 1, 90000, 90000, 235000, 235000, 1, -286571, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - succubus gossip 1'),
( 570209, 5702, 1, 0, 100, 1, 98000, 98000, 235000, 235000, 32, 5728, 0, 286569, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - summon succubus'),
( 570210, 5702, 1, 0, 100, 1, 100000, 100000, 235000, 235000, 1, -286572, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - succubus gossip 2'),
( 570211, 5702, 1, 0, 100, 1, 130000, 130000, 235000, 235000, 1, -286573, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - felhunter gossip 1'),
( 570212, 5702, 1, 0, 100, 1, 138000, 138000, 235000, 235000, 32, 5726, 0, 286569, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - summon felhunter'),
( 570213, 5702, 1, 0, 100, 1, 140000, 140000, 235000, 235000, 1, -286574, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - felhunter gossip 2'),
( 570214, 5702, 1, 0, 100, 1, 170000, 170000, 235000, 235000, 1, -286575, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - felsteed gossip 1'),
( 570215, 5702, 1, 0, 100, 1, 178000, 178000, 235000, 235000, 32, 5727, 0, 286569, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - summon felsteed'),
( 570216, 5702, 1, 0, 100, 1, 180000, 180000, 230000, 235000, 1, -286576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - felsteed gossip 2'),
( 570217, 5702, 1, 0, 100, 1, 210000, 210000, 235000, 235000, 1, -286577, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Jezelle Pruitt - event end gossip');
-- update Jezelle Pruitt creature_template
UPDATE `creature_template` SET `AIName`='EventAI' WHERE (`entry`='5702');
-- delete existing spawned creatures from DB
DELETE FROM `creature` WHERE `id` IN ('5726', '5729', '5730');

It is very close to blizzlike, but i dont know how good or bad this script is from developers perspective, so i posted script here. gossips is 100% correct, timers ~90% correct. Nothing much, but adds piece of life to city. :)