API tools faq
paste
Pelf

blackwing descent trash sql

Pelf
Feb 26th, 2012
157
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 10.15 KB | None | 0 0
raw download clone embed print report
  1. #база
  2. UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `faction_A`=16, `faction_H`=16, `flags_extra`=128 WHERE `entry`=43361;
  3. UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `faction_A`=16, `faction_H`=16, `flags_extra`=128 WHERE `entry`=43362;
  4.  
  5. #скрипты
  6. UPDATE `creature_template` SET `ScriptName`='npc_golem_sentry' WHERE `entry`=42800;
  7. UPDATE `creature_template` SET `ScriptName`='npc_flash_bomb' WHERE `entry`=43361;
  8. UPDATE `creature_template` SET `ScriptName`='npc_laser_strike' WHERE `entry`=43362;  
  9. UPDATE `creature_template` SET `ScriptName`='npc_drakonid_drudge' WHERE `entry`=42362;
  10. UPDATE `creature_template` SET `ScriptName`='npc_drakonid_chainwielder' WHERE `entry`=42649;
  11. UPDATE `creature_template` SET `ScriptName`='npc_maimgor' WHERE `entry`=42768;
  12. UPDATE `creature_template` SET `ScriptName`='npc_ivoroc' WHERE `entry`=42767;
  13. UPDATE `creature_template` SET `ScriptName`='npc_pyreclaw' WHERE `entry`=42764;
  14. UPDATE `creature_template` SET `ScriptName`='npc_drakonid_slayer' WHERE `entry`=42802;
  15. UPDATE `creature_template` SET `ScriptName`='npc_drakeadon_mongrel' WHERE `entry`=42803;
  16. UPDATE `creature_template` SET `ScriptName`='npc_drakeadon_mongrel' WHERE `entry`=46083;
  17. UPDATE `creature_template` SET `ScriptName`='npc_bd_spirit_of_dwarf' WHERE `entry`=43119;
  18. UPDATE `creature_template` SET `ScriptName`='npc_bd_spirit_of_dwarf' WHERE `entry`=43126;
  19. UPDATE `creature_template` SET `ScriptName`='npc_bd_spirit_of_dwarf' WHERE `entry`=43127;
  20. UPDATE `creature_template` SET `ScriptName`='npc_bd_spirit_of_dwarf' WHERE `entry`=43130;
  21. UPDATE `creature_template` SET `ScriptName`='npc_bd_spirit_of_dwarf' WHERE `entry`=43122;
  22. UPDATE `creature_template` SET `ScriptName`='npc_bd_spirit_of_dwarf' WHERE `entry`=43128;
  23. UPDATE `creature_template` SET `ScriptName`='npc_bd_spirit_of_dwarf' WHERE `entry`=43125;
  24. UPDATE `creature_template` SET `ScriptName`='npc_bd_spirit_of_dwarf' WHERE `entry`=43129;
  25.  
  26. #спеллы
  27. DELETE FROM `spell_script_names` WHERE `spell_id` = 80051;
  28. DELETE FROM `spell_script_names` WHERE `spell_id` = 91910;
  29. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (80051, 'spell_drakonid_chainwielder_grievous_wound');
  30. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (91910, 'spell_drakonid_chainwielder_grievous_wound');
  31. DELETE FROM `conditions` WHERE `SourceEntry`=80875;
  32. DELETE FROM `conditions` WHERE `SourceEntry`=80878;
  33. DELETE FROM `conditions` WHERE `SourceEntry`=80871;
  34. DELETE FROM `conditions` WHERE `SourceEntry`=80872;
  35. DELETE FROM `conditions` WHERE `SourceEntry`=80877;
  36. DELETE FROM `conditions` WHERE `SourceEntry`=80874;
  37. DELETE FROM `conditions` WHERE `SourceEntry`=80876;
  38. DELETE FROM `conditions` WHERE `SourceEntry`=80873;
  39. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  40. VALUES ('13', '0', '80875', '0', '18', '1', '43119', '0', '0', '', 'bestowal of ironstar');
  41. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  42. VALUES ('13', '0', '80875', '0', '18', '1', '43126', '0', '0', '', 'bestowal of ironstar');
  43. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  44. VALUES ('13', '0', '80875', '0', '18', '1', '43130', '0', '0', '', 'bestowal of ironstar');
  45. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  46. VALUES ('13', '0', '80878', '0', '18', '1', '43126', '0', '0', '', 'bestowal of angerforge');
  47. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  48. VALUES ('13', '0', '80878', '0', '18', '1', '43127', '0', '0', '', 'bestowal of angerforge');
  49. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  50. VALUES ('13', '0', '80878', '0', '18', '1', '43130', '0', '0', '', 'bestowal of angerforge');
  51. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  52. VALUES ('13', '0', '80871', '0', '18', '1', '43119', '0', '0', '', 'bestowal of thaurissan');
  53. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  54. VALUES ('13', '0', '80871', '0', '18', '1', '43127', '0', '0', '', 'bestowal of thaurissan');
  55. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  56. VALUES ('13', '0', '80871', '0', '18', '1', '43130', '0', '0', '', 'bestowal of thaurissan');
  57. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  58. VALUES ('13', '0', '80872', '0', '18', '1', '43119', '0', '0', '', 'bestowal of burningeye');
  59. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  60. VALUES ('13', '0', '80872', '0', '18', '1', '43126', '0', '0', '', 'bestowal of burningeye');
  61. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  62. VALUES ('13', '0', '80872', '0', '18', '1', '43127', '0', '0', '', 'bestowal of burningeye');
  63. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  64. VALUES ('13', '0', '80877', '0', '18', '1', '43128', '0', '0', '', 'bestowal of corehammer');
  65. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  66. VALUES ('13', '0', '80877', '0', '18', '1', '43125', '0', '0', '', 'bestowal of corehammer');
  67. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  68. VALUES ('13', '0', '80877', '0', '18', '1', '43129', '0', '0', '', 'bestowal of corehammer');
  69. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  70. VALUES ('13', '0', '80874', '0', '18', '1', '43122', '0', '0', '', 'bestowal of anvilrage');
  71. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  72. VALUES ('13', '0', '80874', '0', '18', '1', '43125', '0', '0', '', 'bestowal of anvilrage');
  73. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  74. VALUES ('13', '0', '80874', '0', '18', '1', '43129', '0', '0', '', 'bestowal of anvilrage');
  75. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  76. VALUES ('13', '0', '80876', '0', '18', '1', '43122', '0', '0', '', 'bestowal of moltenfist');
  77. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  78. VALUES ('13', '0', '80876', '0', '18', '1', '43128', '0', '0', '', 'bestowal of moltenfist');
  79. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  80. VALUES ('13', '0', '80876', '0', '18', '1', '43129', '0', '0', '', 'bestowal of moltenfist');
  81. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  82. VALUES ('13', '0', '80873', '0', '18', '1', '43122', '0', '0', '', 'bestowal of shadowforge');
  83. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  84. VALUES ('13', '0', '80873', '0', '18', '1', '43128', '0', '0', '', 'bestowal of shadowforge');
  85. INSERT INTO `conditions` (`SourceTypeOrReferenceId` ,`SourceGroup` ,`SourceEntry` ,`ElseGroup` ,`ConditionTypeOrReference` ,`ConditionValue1` ,`ConditionValue2` ,`ConditionValue3` ,`ErrorTextId` ,`ScriptName` ,`Comment`)
  86. VALUES ('13', '0', '80873', '0', '18', '1', '43125', '0', '0', '', 'bestowal of shadowforge');
Advertisement
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!