Advertisement
Guest User

Untitled

a guest
Sep 24th, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 2.50 KB | None | 0 0
  1. -- zjistit jestli se nachazi v DB creatura s ID 68690
  2. DELETE FROM `creature_template` WHERE entry = 68690;
  3. REPLACE INTO `creature_template` VALUES
  4. (68690,0,0,0,0,0,10045,0,0,0,'Event Cosik','Visual',NULL,0,80,80,0,35,35,0,0.91,1.14286,1,0,1,1,0,1,1,2000,2200,1,0,0,0,0,0,0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'SmartAI',0,7,0.0125,1,1,0,0,0,0,0,0,0,0,1,0,0,0,'',12340);
  5.  
  6. DELETE FROM `gossip_menu` WHERE `entry` = '25000';
  7. INSERT INTO `gossip_menu` VALUES
  8. ('25000', '68690');
  9.  
  10. DELETE FROM `gossip_menu_option` WHERE `menu_id` = '25000';
  11. INSERT INTO `gossip_menu_option` VALUES
  12. ('25000', '0', '0', 'Levny horni sroub', '1', '1', '25001', '0', '0', '0', '0', NULL), -- good odpoved
  13. ('25000', '1', '0', 'Levy spodni sroub', '1', '1', '0', '0', '0', '0', '0', NULL), -- dead
  14. ('25000', '2', '0', 'Pravy horni sroub', '1', '1', '0', '0', '0', '0', '0', NULL), -- dead
  15. ('25000', '3', '0', 'Pravy spodni sroub', '1', '1', '0', '0', '0', '0', '0', NULL); -- dead
  16.  
  17.  
  18. DELETE FROM `gossip_menu_option` WHERE `menu_id` = '25001';
  19. INSERT INTO `gossip_menu_option` VALUES
  20. ('25001', '0', '0', 'Kryt 1', '1', '1', '0', '0', '0', '0', '0', NULL),
  21. ('25001', '1', '0', 'Kryt 2', '1', '1', '0', '0', '0', '0', '0', NULL),
  22. ('25001', '2', '0', 'Kryt 3', '1', '1', '0', '0', '0', '0', '0', NULL),
  23. ('25001', '3', '0', 'Kryt 4', '1', '1', '0', '0', '0', '0', '0', NULL);
  24.  
  25. UPDATE `creature_template` SET AIName = 'SmartAI', `gossip_menu_id` = '25000', `npcflag` = '1' WHERE `entry`='68690';
  26. DELETE FROM `smart_scripts` WHERE (`entryorguid`=68690);
  27. INSERT INTO `smart_scripts` VALUES
  28. (68690, 0, 0, 0, 1, 0, 100, 0, 0, 0, 20000, 20000, 1, 0, 3000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'casovac'),
  29. (68690, 0, 1, 0, 62 , 0, 100, 0, 25000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'message 1'), -- dobra odpoved
  30. (68690, 0, 2, 0, 62 , 0, 100, 0, 25000, 1, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'message 2'), -- spatna odpoved
  31. (68690, 0, 3, 0, 62 , 0, 100, 0, 25000, 2, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'message 3'), -- spatna odpoved
  32. (68690, 0, 4, 0, 62 , 0, 100, 0, 25000, 3, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'message 4'); -- spatna odpoved
  33.  
  34.  
  35. DELETE FROM creature_text WHERE entry = 68690;
  36. INSERT INTO creature_text VALUES
  37. (68690, 0, 0, 'Tik Tak', 14, 0, 100, 0,0, 0, 'clock'),
  38. (68690, 1, 0, 'Good', 14, 0, 100, 0,0, 0, 'text 1'),
  39. (68690, 2, 0, 'Boom', 14, 0, 100, 0,0, 0, 'text 2'),
  40. (68690, 3, 0, 'Cas vyprsel', 14, 0, 100, 0,0, 0, 'text 3'); -- zatim nikde nenahozene jen text
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement