API tools faq
paste
Guest User

Untitled

a guest
Feb 21st, 2018
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 6.51 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM `smart_scripts` WHERE `entryorguid`=13217 AND `id`=0 AND `source_type`=0 LIMIT 1;
  2. INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (13217,0,0,0,19,0,100,0,13217,0,0,0,12,31271,1,255000,0,0,0,8,0,0,0,8164.46,3474.56,626.634,0.61,"Spawn npc - Icecrown arena 1");
  3. DELETE FROM `smart_scripts` WHERE `entryorguid`=13218 AND `id`=0 AND `source_type`=0 LIMIT 1;
  4. INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (13218,0,0,0,19,0,100,0,13214,0,0,0,12,31195,1,255000,0,0,0,8,0,0,0,8164.46,3474.56,626.634,0.61,"Spawn npc - Icecrown arena 2");
  5. DELETE FROM `smart_scripts` WHERE `entryorguid`=13219 AND `id`=0 AND `source_type`=0 LIMIT 1;
  6. INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (13219,0,0,0,19,0,100,0,13214,0,0,0,12,31193,1,255000,0,0,0,8,0,0,0,8164.46,3474.56,626.634,0.61,"Spawn npc - Icecrown arena 3");
  7. DELETE FROM `smart_scripts` WHERE `entryorguid`=13220 AND `id`=0 AND `source_type`=0 LIMIT 1;
  8. INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (13220,0,0,0,19,0,100,0,13214,0,0,0,12,31191,1,255000,0,0,0,8,0,0,0,8164.46,3474.56,626.634,0.61,"Spawn npc - Icecrown arena 4");
  9. DELETE FROM `smart_scripts` WHERE `entryorguid`=13221 AND `id`=0 AND `source_type`=0 LIMIT 1;
  10. INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (13221,0,0,0,19,0,100,0,13214,0,0,0,12,31192,1,255000,0,0,0,8,0,0,0,8164.46,3474.56,626.634,0.61,"Spawn npc - Icecrown arena 5");
  11. DELETE FROM `smart_scripts` WHERE `entryorguid`=13222 AND `id`=0 AND `source_type`=0 LIMIT 1;
  12. INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (13222,0,0,0,19,0,100,0,13219,0,0,0,12,14688,1,255000,0,0,0,8,0,0,0,8164.46,3474.56,626.634,0.61,"Spawn npc - Icecrown arena 6");
  13. DELETE FROM `smart_scripts` WHERE `entryorguid`=13223 AND `id`=0 AND `source_type`=0 LIMIT 1;
  14. INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (13223,0,0,0,19,0,100,0,13215,0,0,0,12,31222,1,255000,0,0,0,8,0,0,0,8164.46,3474.56,626.634,0.61,"Spawn npc - Icecrown arena 7");
  15. DELETE FROM `smart_scripts` WHERE `entryorguid`=13224 AND `id`=0 AND `source_type`=0 LIMIT 1;
  16. INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (13224,0,0,0,19,0,100,0,13218,0,0,0,12,31277,1,255000,0,0,0,8,0,0,0,8164.46,3474.56,626.634,0.61,"Spawn npc - Icecrown arena 8");
  17. DELETE FROM `smart_scripts` WHERE `entryorguid`=13225 AND `id`=0 AND `source_type`=0 LIMIT 1;
  18. INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (13225,0,0,0,19,0,100,0,13216,0,0,0,12,31242,1,255000,0,0,0,8,0,0,0,8164.46,3474.56,626.634,0.61,"Spawn npc - Icecrown arena 9");
  19.  
  20.  
  21.  
  22.  
  23.  
  24.  
  25.  
  26.  
  27.  
  28.  
  29. UPDATE `quest_template` SET `ReqCreatureOrGOId1`=31271, `ReqCreatureOrGOCount1`=1 WHERE  `entry`=13217;
  30. UPDATE `quest_template` SET `ReqCreatureOrGOId1`=31195, `ReqCreatureOrGOId2`=31193, `ReqCreatureOrGOId3`=31191, `ReqCreatureOrGOId4`=31192, `ReqCreatureOrGOCount1`=1, `ReqCreatureOrGOCount2`=1, `ReqCreatureOrGOCount3`=1, `ReqCreatureOrGOCount4`=1 WHERE  `entry`=13214;
  31. UPDATE `quest_template` SET `ReqCreatureOrGOId1`=14688, `ReqCreatureOrGOCount1`=1 WHERE  `entry`=13219;
  32. UPDATE `quest_template` SET `ReqCreatureOrGOId1`=31222, `ReqCreatureOrGOCount1`=1 WHERE  `entry`=13215;
  33. UPDATE `quest_template` SET `ReqCreatureOrGOId1`=31277, `ReqCreatureOrGOCount1`=1 WHERE  `entry`=13218;
  34. UPDATE `quest_template` SET `ReqCreatureOrGOId1`=31242, `ReqCreatureOrGOCount1`=1 WHERE  `entry`=13216;
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!