API tools faq
paste
Advertisement
sorvani

PoTimeB Updates.sql

sorvani
Oct 4th, 2013
286
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 32.27 KB | None | 0 0
raw download clone embed print report
  1. -- change shutdowndelay for testing do not make this line live
  2. -- UPDATE `zone` SET `shutdowndelay` = 5000 WHERE `short_name` = 'potimeb';
  3. -- delete spawns that are no longer used
  4. DELETE FROM `spawnentry` WHERE `spawngroupID` IN (SELECT `spawngroupID` FROM `spawn2` WHERE `zone` = 'potimeb' AND `_condition` = 0);
  5. DELETE FROM `spawngroup` WHERE `id` IN (SELECT `spawngroupID` FROM `spawn2` WHERE `zone` = 'potimeb' AND `_condition` = 0);
  6. DELETE FROM `spawn2` WHERE `zone` = 'potimeb' AND `_condition` = 0;
  7. -- update the clock doors to have lockpick -1 and keyitem 0
  8. UPDATE `doors` SET `keyitem` = 0, `lockpick` = -1 WHERE `zone` = 'potimeb' AND `name` LIKE 'TMDOOR50%';
  9. -- move a few doorid values in order to make exluding them in player.lua easier
  10. UPDATE `doors` SET `doorid` = `doorid` + 59 WHERE `zone` = 'potimeb' AND `doorid` BETWEEN 17 AND 24;
  11. -- move the phase 1 air doors from 46-49 to 1-4
  12. UPDATE `doors` SET `doorid` = `doorid` - 45 WHERE `zone` = 'potimeb' AND `doorid` BETWEEN 46 AND 49;
  13. -- move the phase 1 earth doors from 42-45 to 9-12
  14. UPDATE `doors` SET `doorid` = `doorid` - 33 WHERE `zone` = 'potimeb' AND `doorid` BETWEEN 42 AND 45;
  15. -- move the phase 2 water/fire doors from 13-16 to 42-45
  16. UPDATE `doors` SET `doorid` = `doorid` + 29 WHERE `zone` = 'potimeb' AND `doorid` BETWEEN 13 AND 16;
  17. -- update the portal door from phase 3 to phase 4
  18. UPDATE `doors` SET `opentype` = 58, `keyitem` = 0, `lockpick` = -1, `dest_zone` = 'potimeb', `dest_x` = -400, `dest_y` = 0, `dest_z` = 348, `dest_heading` = 128 WHERE `zone` = 'potimeb' AND `doorid` = 62;
  19. -- update the portal stone from phase 4 to phase 5
  20. UPDATE `doors` SET `opentype` = 58, `keyitem` = 0, `lockpick` = -1, `dest_zone` = 'potimeb', `dest_x` = -400, `dest_y` = 0, `dest_z` = 0, `dest_heading` = 128 WHERE `zone` = 'potimeb' AND `doorid` = 83;
  21. -- update the portal stone from phase 5 to phase 6
  22. UPDATE `doors` SET `opentype` = 58, `keyitem` = 0, `lockpick` = -1, `dest_zone` = 'potimeb', `dest_x` = 251, `dest_y` = -1124, `dest_z` = -2, `dest_heading` = 196 WHERE `zone` = 'potimeb' AND `doorid` = 51;
  23. -- delete a bunch of NPC's that are no longer used.
  24. DELETE FROM `npc_types` WHERE `id` IN (223111,223211,223188,223187,223163,223186,223190,223189,223177,223191,223157);
  25. DELETE FROM `npc_types` WHERE `id` IN (223206,223201,223207,223202,223205,223162,223204,223161,223203,223160,223163);
  26. DELETE FROM `npc_types` WHERE `id` IN (223179,223178,223182,223180,223181,223183,223210,223209,223184,223208,223185);
  27. DELETE FROM `npc_types` WHERE `id` IN (223991,223996,223997,223998,223999,223174,223176,223154,223158,223175,223130);
  28. DELETE FROM `npc_types` WHERE `id` IN (223145,223159,223215,223193,223225,223192);
  29. DELETE FROM `npc_types` WHERE `id` BETWEEN 223217 AND 223224;
  30. -- rename NPCID 223170
  31. UPDATE `npc_types` SET `name` = 'phase_one_air' WHERE `id` = 223170;
  32. -- rename NPCID 223169
  33. UPDATE `npc_types` SET `name` = 'phase_one_earth' WHERE `id` = 223169;
  34. -- rename NPCID 223173
  35. UPDATE `npc_types` SET `name` = 'phase_one_fire' WHERE `id` = 223173;
  36. -- rename NPCID 223172
  37. UPDATE `npc_types` SET `name` = 'phase_one_water' WHERE `id` = 223172;
  38. -- rename NPCID 223171
  39. UPDATE `npc_types` SET `name` = 'phase_one_undead' WHERE `id` = 223171;
  40. -- create zone_status
  41. INSERT INTO `npc_types` (`id`,`name`,`lastname`,`level`,`race`,`class`,`bodytype`,`hp`,`mana`,`gender`,`texture`,
  42.         `helmtexture`,`size`,`hp_regen_rate`,`mana_regen_rate`,`loottable_id`,`merchant_id`,`alt_currency_id`,
  43.         `npc_spells_id`,`npc_faction_id`,`adventure_template_id`,`trap_template`,`mindmg`,`maxdmg`,`attack_count`,
  44.         `special_abilities`,`aggroradius`,`face`,`luclin_hairstyle`,`luclin_haircolor`,`luclin_eyecolor`,`luclin_eyecolor2`,
  45.         `luclin_beardcolor`,`luclin_beard`,`drakkin_heritage`,`drakkin_tattoo`,`drakkin_details`,`armortint_id`,
  46.         `armortint_red`,`armortint_green`,`armortint_blue`,`d_meele_texture1`,`d_meele_texture2`,`prim_melee_type`,
  47.         `sec_melee_type`,`runspeed`,`MR`,`CR`,`DR`,`FR`,`PR`,`Corrup`,`see_invis`,`see_invis_undead`,`qglobal`,`AC`,
  48.         `npc_aggro`,`spawn_limit`,`attack_speed`,`findable`,`STR`,`STA`,`DEX`,`AGI`,`_INT`,`WIS`,`CHA`,`see_hide`,
  49.         `see_improved_hide`,`trackable`,`isbot`,`exclude`,`ATK`,`Accuracy`,`slow_mitigation`,`version`,`maxlevel`,
  50.         `scalerate`,`private_corpse`,`unique_spawn_by_name`,`underwater`,`isquest`,`emoteid`,`spellscale`,`healscale`)
  51.     SELECT 223097 AS `id`,'zone_status' AS `name`,`lastname`,`level`,`race`,`class`,`bodytype`,`hp`,`mana`,`gender`,
  52.         `texture`,`helmtexture`,`size`,`hp_regen_rate`,`mana_regen_rate`,`loottable_id`,`merchant_id`,`alt_currency_id`,
  53.         `npc_spells_id`,`npc_faction_id`,`adventure_template_id`,`trap_template`,`mindmg`,`maxdmg`,`attack_count`,
  54.         `special_abilities`,`aggroradius`,`face`,`luclin_hairstyle`,`luclin_haircolor`,`luclin_eyecolor`,`luclin_eyecolor2`,
  55.         `luclin_beardcolor`,`luclin_beard`,`drakkin_heritage`,`drakkin_tattoo`,`drakkin_details`,`armortint_id`,`armortint_red`,
  56.         `armortint_green`,`armortint_blue`,`d_meele_texture1`,`d_meele_texture2`,`prim_melee_type`,`sec_melee_type`,
  57.         `runspeed`,`MR`,`CR`,`DR`,`FR`,`PR`,`Corrup`,`see_invis`,`see_invis_undead`,`qglobal`,`AC`,`npc_aggro`,`spawn_limit`,
  58.         `attack_speed`,`findable`,`STR`,`STA`,`DEX`,`AGI`,`_INT`,`WIS`,`CHA`,`see_hide`,`see_improved_hide`,`trackable`,
  59.         `isbot`,`exclude`,`ATK`,`Accuracy`,`slow_mitigation`,`version`,`maxlevel`,`scalerate`,`private_corpse`,`unique_spawn_by_name`,
  60.         `underwater`,`isquest`,`emoteid`,`spellscale`,`healscale`
  61.     FROM `npc_types` WHERE `id` = 223171;
  62. -- create zone_emoter
  63. INSERT INTO `npc_types` (`id`,`name`,`lastname`,`level`,`race`,`class`,`bodytype`,`hp`,`mana`,`gender`,`texture`,
  64.         `helmtexture`,`size`,`hp_regen_rate`,`mana_regen_rate`,`loottable_id`,`merchant_id`,`alt_currency_id`,
  65.         `npc_spells_id`,`npc_faction_id`,`adventure_template_id`,`trap_template`,`mindmg`,`maxdmg`,`attack_count`,
  66.         `special_abilities`,`aggroradius`,`face`,`luclin_hairstyle`,`luclin_haircolor`,`luclin_eyecolor`,`luclin_eyecolor2`,
  67.         `luclin_beardcolor`,`luclin_beard`,`drakkin_heritage`,`drakkin_tattoo`,`drakkin_details`,`armortint_id`,
  68.         `armortint_red`,`armortint_green`,`armortint_blue`,`d_meele_texture1`,`d_meele_texture2`,`prim_melee_type`,
  69.         `sec_melee_type`,`runspeed`,`MR`,`CR`,`DR`,`FR`,`PR`,`Corrup`,`see_invis`,`see_invis_undead`,`qglobal`,`AC`,
  70.         `npc_aggro`,`spawn_limit`,`attack_speed`,`findable`,`STR`,`STA`,`DEX`,`AGI`,`_INT`,`WIS`,`CHA`,`see_hide`,
  71.         `see_improved_hide`,`trackable`,`isbot`,`exclude`,`ATK`,`Accuracy`,`slow_mitigation`,`version`,`maxlevel`,
  72.         `scalerate`,`private_corpse`,`unique_spawn_by_name`,`underwater`,`isquest`,`emoteid`,`spellscale`,`healscale`)
  73.     SELECT 223227 AS `id`,'zone_emoter' AS `name`,`lastname`,`level`,`race`,`class`,`bodytype`,`hp`,`mana`,`gender`,
  74.         `texture`,`helmtexture`,`size`,`hp_regen_rate`,`mana_regen_rate`,`loottable_id`,`merchant_id`,`alt_currency_id`,
  75.         `npc_spells_id`,`npc_faction_id`,`adventure_template_id`,`trap_template`,`mindmg`,`maxdmg`,`attack_count`,
  76.         `special_abilities`,`aggroradius`,`face`,`luclin_hairstyle`,`luclin_haircolor`,`luclin_eyecolor`,`luclin_eyecolor2`,
  77.         `luclin_beardcolor`,`luclin_beard`,`drakkin_heritage`,`drakkin_tattoo`,`drakkin_details`,`armortint_id`,`armortint_red`,
  78.         `armortint_green`,`armortint_blue`,`d_meele_texture1`,`d_meele_texture2`,`prim_melee_type`,`sec_melee_type`,
  79.         `runspeed`,`MR`,`CR`,`DR`,`FR`,`PR`,`Corrup`,`see_invis`,`see_invis_undead`,`qglobal`,`AC`,`npc_aggro`,`spawn_limit`,
  80.         `attack_speed`,`findable`,`STR`,`STA`,`DEX`,`AGI`,`_INT`,`WIS`,`CHA`,`see_hide`,`see_improved_hide`,`trackable`,
  81.         `isbot`,`exclude`,`ATK`,`Accuracy`,`slow_mitigation`,`version`,`maxlevel`,`scalerate`,`private_corpse`,`unique_spawn_by_name`,
  82.         `underwater`,`isquest`,`emoteid`,`spellscale`,`healscale`
  83.     FROM `npc_types` WHERE `id` = 223171;
  84. -- create spawn for the zone status
  85. SET @spawngroup_id = (SELECT MAX(`id`)+1 FROM `spawngroup`);
  86. INSERT INTO `spawngroup` (`id`,`name`,`spawn_limit`,`dist`,`max_x`,`min_x`,`max_y`,`min_y`,`delay`,`despawn`,`despawn_timer`)
  87.     VALUES (@spawngroup_id,'potimeb_zone_status',0,0,0,0,0,0,0,0,0);
  88. INSERT INTO `spawnentry` (`spawngroupID`,`npcID`,`chance`)
  89.     VALUES (@spawngroup_id,223097,100);
  90. SET @spawn2_id = (SELECT MAX(`id`)+1 FROM `spawn2`);
  91. INSERT INTO `spawn2` (`id`,`spawngroupID`,`zone`,`version`,`x`,`y`,`z`,`heading`,`respawntime`,`variance`,`pathgrid`,`_condition`,`cond_value`,`enabled`,`animation`)
  92.     VALUES (@spawn2_id,@spawngroup_id,'potimeb',0,0,0,0,0,1200,0,0,0,1,1,0);
  93. -- create spawn for the zone emoter
  94. SET @spawngroup_id = (SELECT MAX(`id`)+1 FROM `spawngroup`);
  95. INSERT INTO `spawngroup` (`id`,`name`,`spawn_limit`,`dist`,`max_x`,`min_x`,`max_y`,`min_y`,`delay`,`despawn`,`despawn_timer`)
  96.     VALUES (@spawngroup_id,'potimeb_zone_emoter',0,0,0,0,0,0,0,0,0);
  97. INSERT INTO `spawnentry` (`spawngroupID`,`npcID`,`chance`)
  98.     VALUES (@spawngroup_id,223227,100);
  99. SET @spawn2_id = (SELECT MAX(`id`)+1 FROM `spawn2`);
  100. INSERT INTO `spawn2` (`id`,`spawngroupID`,`zone`,`version`,`x`,`y`,`z`,`heading`,`respawntime`,`variance`,`pathgrid`,`_condition`,`cond_value`,`enabled`,`animation`)
  101.     VALUES (@spawn2_id,@spawngroup_id,'potimeb',0,0,0,0,0,1200,0,0,0,1,1,0);
  102. -- change the ID of Servitor_of_Xegony 223995 to 223111
  103. UPDATE `npc_types` SET `id` = 223111 WHERE `id` = 223995;
  104. -- change the ID of Quarm 223994 to 223201
  105. UPDATE `npc_types` SET `id` = 223201 WHERE `id` = 223994;
  106. -- give NPCID 223120 Neimon_of_Air an ondeath emote
  107. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  108. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,0,'What madness is this? How could I have been defeated? I beg of you Xegony, please forgive my weakness.');
  109. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223120;
  110. -- give NPCID 223104 Anar_of_Water an ondeath emote
  111. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  112. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,0,'Your efforts are commendable, but you will not get far. By Coirnav, you are doomed to failure.');
  113. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223104;
  114. -- rename NPCID 223094 a_flame_mephit_
  115. UPDATE `npc_types` SET `name` = 'a_flame_mephit_' WHERE `id` = 223094;
  116. -- create an_inferno_mephit_
  117. INSERT INTO `npc_types` (`id`,`name`,`lastname`,`level`,`race`,`class`,`bodytype`,`hp`,`mana`,`gender`,`texture`,
  118.         `helmtexture`,`size`,`hp_regen_rate`,`mana_regen_rate`,`loottable_id`,`merchant_id`,`alt_currency_id`,
  119.         `npc_spells_id`,`npc_faction_id`,`adventure_template_id`,`trap_template`,`mindmg`,`maxdmg`,`attack_count`,
  120.         `special_abilities`,`aggroradius`,`face`,`luclin_hairstyle`,`luclin_haircolor`,`luclin_eyecolor`,`luclin_eyecolor2`,
  121.         `luclin_beardcolor`,`luclin_beard`,`drakkin_heritage`,`drakkin_tattoo`,`drakkin_details`,`armortint_id`,
  122.         `armortint_red`,`armortint_green`,`armortint_blue`,`d_meele_texture1`,`d_meele_texture2`,`prim_melee_type`,
  123.         `sec_melee_type`,`runspeed`,`MR`,`CR`,`DR`,`FR`,`PR`,`Corrup`,`see_invis`,`see_invis_undead`,`qglobal`,`AC`,
  124.         `npc_aggro`,`spawn_limit`,`attack_speed`,`findable`,`STR`,`STA`,`DEX`,`AGI`,`_INT`,`WIS`,`CHA`,`see_hide`,
  125.         `see_improved_hide`,`trackable`,`isbot`,`exclude`,`ATK`,`Accuracy`,`slow_mitigation`,`version`,`maxlevel`,
  126.         `scalerate`,`private_corpse`,`unique_spawn_by_name`,`underwater`,`isquest`,`emoteid`,`spellscale`,`healscale`)
  127.     SELECT 223163 AS `id`,'an_inferno_mephit_' AS `name`,`lastname`,`level`,`race`,`class`,`bodytype`,`hp`,`mana`,`gender`,
  128.         `texture`,`helmtexture`,`size`,`hp_regen_rate`,`mana_regen_rate`,`loottable_id`,`merchant_id`,`alt_currency_id`,
  129.         `npc_spells_id`,`npc_faction_id`,`adventure_template_id`,`trap_template`,`mindmg`,`maxdmg`,`attack_count`,
  130.         `special_abilities`,`aggroradius`,`face`,`luclin_hairstyle`,`luclin_haircolor`,`luclin_eyecolor`,`luclin_eyecolor2`,
  131.         `luclin_beardcolor`,`luclin_beard`,`drakkin_heritage`,`drakkin_tattoo`,`drakkin_details`,`armortint_id`,`armortint_red`,
  132.         `armortint_green`,`armortint_blue`,`d_meele_texture1`,`d_meele_texture2`,`prim_melee_type`,`sec_melee_type`,
  133.         `runspeed`,`MR`,`CR`,`DR`,`FR`,`PR`,`Corrup`,`see_invis`,`see_invis_undead`,`qglobal`,`AC`,`npc_aggro`,`spawn_limit`,
  134.         `attack_speed`,`findable`,`STR`,`STA`,`DEX`,`AGI`,`_INT`,`WIS`,`CHA`,`see_hide`,`see_improved_hide`,`trackable`,
  135.         `isbot`,`exclude`,`ATK`,`Accuracy`,`slow_mitigation`,`version`,`maxlevel`,`scalerate`,`private_corpse`,`unique_spawn_by_name`,
  136.         `underwater`,`isquest`,`emoteid`,`spellscale`,`healscale`
  137.     FROM `npc_types` WHERE `id` = 223095;
  138. -- give NPCID 223090 Kazrok_of_Fire an entercombat emote
  139. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  140. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,1,1,'roars, ''Mortals, here? I will torch you alive for this atrocity!''');
  141. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223090;
  142. -- give NPCID 223090 Kazrok_of_Fire an ondeath say
  143. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,0,'You can extinguish the flame of my existence, but you are nothing compared to the might of Fennin Ro!');
  144. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223090;
  145. -- create An_Air_Phoenix_Noble_
  146. INSERT INTO `npc_types` (`id`,`name`,`lastname`,`level`,`race`,`class`,`bodytype`,`hp`,`mana`,`gender`,`texture`,
  147.         `helmtexture`,`size`,`hp_regen_rate`,`mana_regen_rate`,`loottable_id`,`merchant_id`,`alt_currency_id`,
  148.         `npc_spells_id`,`npc_faction_id`,`adventure_template_id`,`trap_template`,`mindmg`,`maxdmg`,`attack_count`,
  149.         `special_abilities`,`aggroradius`,`face`,`luclin_hairstyle`,`luclin_haircolor`,`luclin_eyecolor`,`luclin_eyecolor2`,
  150.         `luclin_beardcolor`,`luclin_beard`,`drakkin_heritage`,`drakkin_tattoo`,`drakkin_details`,`armortint_id`,
  151.         `armortint_red`,`armortint_green`,`armortint_blue`,`d_meele_texture1`,`d_meele_texture2`,`prim_melee_type`,
  152.         `sec_melee_type`,`runspeed`,`MR`,`CR`,`DR`,`FR`,`PR`,`Corrup`,`see_invis`,`see_invis_undead`,`qglobal`,`AC`,
  153.         `npc_aggro`,`spawn_limit`,`attack_speed`,`findable`,`STR`,`STA`,`DEX`,`AGI`,`_INT`,`WIS`,`CHA`,`see_hide`,
  154.         `see_improved_hide`,`trackable`,`isbot`,`exclude`,`ATK`,`Accuracy`,`slow_mitigation`,`version`,`maxlevel`,
  155.         `scalerate`,`private_corpse`,`unique_spawn_by_name`,`underwater`,`isquest`,`emoteid`,`spellscale`,`healscale`)
  156.     SELECT 223187 AS `id`,'An_Air_Phoenix_Noble_' AS `name`,`lastname`,`level`,`race`,`class`,`bodytype`,`hp`,`mana`,`gender`,
  157.         `texture`,`helmtexture`,`size`,`hp_regen_rate`,`mana_regen_rate`,`loottable_id`,`merchant_id`,`alt_currency_id`,
  158.         `npc_spells_id`,`npc_faction_id`,`adventure_template_id`,`trap_template`,`mindmg`,`maxdmg`,`attack_count`,
  159.         `special_abilities`,`aggroradius`,`face`,`luclin_hairstyle`,`luclin_haircolor`,`luclin_eyecolor`,`luclin_eyecolor2`,
  160.         `luclin_beardcolor`,`luclin_beard`,`drakkin_heritage`,`drakkin_tattoo`,`drakkin_details`,`armortint_id`,`armortint_red`,
  161.         `armortint_green`,`armortint_blue`,`d_meele_texture1`,`d_meele_texture2`,`prim_melee_type`,`sec_melee_type`,
  162.         `runspeed`,`MR`,`CR`,`DR`,`FR`,`PR`,`Corrup`,`see_invis`,`see_invis_undead`,`qglobal`,`AC`,`npc_aggro`,`spawn_limit`,
  163.         `attack_speed`,`findable`,`STR`,`STA`,`DEX`,`AGI`,`_INT`,`WIS`,`CHA`,`see_hide`,`see_improved_hide`,`trackable`,
  164.         `isbot`,`exclude`,`ATK`,`Accuracy`,`slow_mitigation`,`version`,`maxlevel`,`scalerate`,`private_corpse`,`unique_spawn_by_name`,
  165.         `underwater`,`isquest`,`emoteid`,`spellscale`,`healscale`
  166.     FROM `npc_types` WHERE `id` = 223087;
  167. -- create An_Air_Phoenix_Noble_
  168. INSERT INTO `npc_types` (`id`,`name`,`lastname`,`level`,`race`,`class`,`bodytype`,`hp`,`mana`,`gender`,`texture`,
  169.         `helmtexture`,`size`,`hp_regen_rate`,`mana_regen_rate`,`loottable_id`,`merchant_id`,`alt_currency_id`,
  170.         `npc_spells_id`,`npc_faction_id`,`adventure_template_id`,`trap_template`,`mindmg`,`maxdmg`,`attack_count`,
  171.         `special_abilities`,`aggroradius`,`face`,`luclin_hairstyle`,`luclin_haircolor`,`luclin_eyecolor`,`luclin_eyecolor2`,
  172.         `luclin_beardcolor`,`luclin_beard`,`drakkin_heritage`,`drakkin_tattoo`,`drakkin_details`,`armortint_id`,
  173.         `armortint_red`,`armortint_green`,`armortint_blue`,`d_meele_texture1`,`d_meele_texture2`,`prim_melee_type`,
  174.         `sec_melee_type`,`runspeed`,`MR`,`CR`,`DR`,`FR`,`PR`,`Corrup`,`see_invis`,`see_invis_undead`,`qglobal`,`AC`,
  175.         `npc_aggro`,`spawn_limit`,`attack_speed`,`findable`,`STR`,`STA`,`DEX`,`AGI`,`_INT`,`WIS`,`CHA`,`see_hide`,
  176.         `see_improved_hide`,`trackable`,`isbot`,`exclude`,`ATK`,`Accuracy`,`slow_mitigation`,`version`,`maxlevel`,
  177.         `scalerate`,`private_corpse`,`unique_spawn_by_name`,`underwater`,`isquest`,`emoteid`,`spellscale`,`healscale`)
  178.     SELECT 223188 AS `id`,'An_Air_Phoenix_Noble_' AS `name`,`lastname`,`level`,`race`,`class`,`bodytype`,`hp`,`mana`,`gender`,
  179.         `texture`,`helmtexture`,`size`,`hp_regen_rate`,`mana_regen_rate`,`loottable_id`,`merchant_id`,`alt_currency_id`,
  180.         `npc_spells_id`,`npc_faction_id`,`adventure_template_id`,`trap_template`,`mindmg`,`maxdmg`,`attack_count`,
  181.         `special_abilities`,`aggroradius`,`face`,`luclin_hairstyle`,`luclin_haircolor`,`luclin_eyecolor`,`luclin_eyecolor2`,
  182.         `luclin_beardcolor`,`luclin_beard`,`drakkin_heritage`,`drakkin_tattoo`,`drakkin_details`,`armortint_id`,`armortint_red`,
  183.         `armortint_green`,`armortint_blue`,`d_meele_texture1`,`d_meele_texture2`,`prim_melee_type`,`sec_melee_type`,
  184.         `runspeed`,`MR`,`CR`,`DR`,`FR`,`PR`,`Corrup`,`see_invis`,`see_invis_undead`,`qglobal`,`AC`,`npc_aggro`,`spawn_limit`,
  185.         `attack_speed`,`findable`,`STR`,`STA`,`DEX`,`AGI`,`_INT`,`WIS`,`CHA`,`see_hide`,`see_improved_hide`,`trackable`,
  186.         `isbot`,`exclude`,`ATK`,`Accuracy`,`slow_mitigation`,`version`,`maxlevel`,`scalerate`,`private_corpse`,`unique_spawn_by_name`,
  187.         `underwater`,`isquest`,`emoteid`,`spellscale`,`healscale`
  188.     FROM `npc_types` WHERE `id` = 223226;
  189. -- update spawnentry
  190. UPDATE `spawnentry` SET `npcID` = 223187 WHERE `npcID` = 223087;
  191. UPDATE `spawnentry` SET `npcID` = 223188 WHERE `npcID` = 223226;
  192. -- update name for phase 2 mob Servitor_of_Xegony
  193. UPDATE `npc_types` SET `name` = 'Servitor_of_Xegony_' WHERE `id` = 223216;
  194. -- give NPCID 223031 Deathbringer_Skullsmash an ondeath emote
  195. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  196. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,1,'coughs, ''Not bad, for mere amateurs. A commendable exertion on your part.''');
  197. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223031;
  198. -- give NPCID 223038 Sinrunal_Gorgedreal an ondeath emote
  199. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  200. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,1,'topples, his shelled cranium splitting with a sickening crunch as it strikes the ground.');
  201. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223038;
  202. -- give NPCID 223037 Herlsoakian an ondeath emote
  203. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  204. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,1,'loses its semi-rigid consistency and deflates. The burbling noise and fetid scent are nauseating.');
  205. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223037;
  206. -- give NPCID 223047 A_Needletusk_Warboar an entercombat emote
  207. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  208. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,1,1,'snarls with determined fury, then rushes directly at you!');
  209. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223047;
  210. -- give NPCID 223047 A_Needletusk_Warboar an ondeath emote
  211. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,1,'stumbles and lies prone, taking breaths in punctuated gasping snorts. Its eyes slowly close as it ceases breathing.');
  212. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223047;
  213. -- give NPCID 223046 Deathbringer_Rianit an entercombat say
  214. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  215. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,1,0,'If you were looking to play war, mortals, you will get all that and more. Prepare to soak my battlefield in your blood!');
  216. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223046;
  217. -- give NPCID 223046 Deathbringer_Rianit an ondeath emote
  218. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,1,'coughs, ''Not bad, for mere amateurs. A commendable exertion on your part.''');
  219. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223046;
  220. -- give NPCID 223050 Dersool_Fal`Giersnaol an ondeath emote
  221. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  222. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,1,'produces a bloodcurdling scream as she is cut down. Prone and dying, she sighs her final words, ''This cannot be. . .It is not yet my time to pass. An unlife as glorious as mine deserves continuance.''');
  223. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223050;
  224. -- give NPCID 223051 Xerskel_Gerodnsal an ondeath emote
  225. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  226. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,1,'stares at his hands, a look of disbelief and horror on his countenance. ''Innoruuk, I have failed you!''');
  227. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223051;
  228. -- give NPCID 223057 Undead_Squad_Leader an entercombat say
  229. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  230. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,1,0,'Can you even fathom the infinite torture and suffering in store for you? I thought not.');
  231. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223057;
  232. -- give NPCID 223057 Undead_Squad_Leader an ondeath say
  233. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,0,'This is not the first time I have been ''killed'', and it will certainly not be the last. Be always on your guard, mortals.');
  234. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223057;
  235. -- give NPCID 223058 Dark_Knight_of_Terris an entercombat say
  236. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  237. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,1,0,'What twisted reasoning would possess you to travel here and challenge the gods themselves? Your madness knows no bounds! The only sensible course of action is to end your miserable existence.');
  238. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223058;
  239. -- give NPCID 223058 Dark_Knight_of_Terris an ondeath say
  240. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,0,'This is not over, fools. My death here is merely the beginning. I will return to you in your most horrible nightmares!');
  241. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223058;
  242. -- give NPCID 223065 Champion_of_Torment an ondeath emote
  243. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  244. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,1,'whines pitifully as it stumbles and topples over.');
  245. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223065;
  246. -- give NPCID 223066 Dreamwarp an entercombat emote
  247. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,1,1,'senses your presence and ventures closer, the many mouths nipping at the air.');
  248. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223066;
  249. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  250. -- give NPCID 223066 Dreamwarp an ondeath emote
  251. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,1,'can support itself no longer and crashes to the ground in a writhing mass of flesh.');
  252. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223066;
  253. -- give NPCID 223073 Avatar_of_the_Elements an ondeath emote
  254. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  255. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,1,'teeters, then comes crashing down. The force of impact is tremendous, shaking what you imagine to be the entire plane.');
  256. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223073;
  257. -- give NPCID 223036 a_deceiver_of_zek an afterdeath say
  258. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  259. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,3,0,'Squeeeeeeee!  Squeeee. . .');
  260. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223036;
  261. -- give NPCID 223024 Kraksmaal_Fir`Dethsin an afterdeath say
  262. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  263. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,3,0,'This is no victory for you, only a delay of your inevitable demise');
  264. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223024;
  265. -- give NPCID 223075 an entercombat say
  266. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  267. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,1,0,'Now is the chance to prove my power reigns supreme. Prepare to feel the power of nightmares shatter your soul!');
  268. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223075;
  269. -- give NPCID 223075 Terris_Thule an ondeath say
  270. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,0,'My armies have failed. . . how could this have happened?');
  271. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223075;
  272. -- add a 200 unit tether to NPCID 223075 Terris_Thule
  273. UPDATE `npc_types` SET `special_abilities` = CONCAT(`special_abilities`,'^33,200') WHERE `id` = 223075;
  274. -- give NPCID 223076 Saryrn an entercombat say
  275. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  276. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,1,0,'No! That''s impossible! Be gone from this place, mortals!');
  277. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223076;
  278. -- give NPCID 223076 Saryrn an ondeath say
  279. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,0,'My minions. . . my power. . . lost. Impossible. . .');
  280. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223076;
  281. -- add a 200 unit tether to NPCID 223076 Saryrn
  282. UPDATE `npc_types` SET `special_abilities` = CONCAT(`special_abilities`,'^33,200') WHERE `id` = 223076;
  283. -- give NPCID 223077 Tallon_Zek an entercombat say
  284. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  285. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,1,0,'I hope you have lived your life with no regrets, for now it shall come to an end!');
  286. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223077;
  287. -- give NPCID 223077 Tallon_Zek an ondeath say
  288. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,0,'Foolish mortals, you know not what you do. Continue on this path and you shall lead us all to destruction!');
  289. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223077;
  290. -- add a 200 unit tether to NPCID 223077 Tallon_Zek
  291. UPDATE `npc_types` SET `special_abilities` = CONCAT(`special_abilities`,'^33,200') WHERE `id` = 223077;
  292. -- give NPCID 223078 an entercombat say
  293. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  294. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,1,0,'Welcome to your final stand, mortals. You shall progress no farther!');
  295. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223078;
  296. -- give NPCID 223078 Vallon_Zek an ondeath say
  297. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,0,'You stand to gain no honor in my death. May the wrath of Rallos Zek strike you down with great vengeance.');
  298. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223078;
  299. -- add a 200 unit tether to NPCID 223078 Vallon_Zek
  300. UPDATE `npc_types` SET `special_abilities` = CONCAT(`special_abilities`,'^33,200') WHERE `id` = 223078;
  301. -- give NPCID 223168 #Rallos_Zek an entercombat say
  302. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  303. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,1,0,'Defeating my sons in battle is impressive, but your legacy ends now. If no one else can stop these mortals, then the power of War shall!');
  304. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223168;
  305. -- give NPCID 223168 #Rallos_Zek an ondeath say
  306. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,0,'My mantle shall never be passed on. . .');
  307. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223168;
  308. -- add a 200 unit tether to NPCID 223168 #Rallos_Zek
  309. UPDATE `npc_types` SET `special_abilities` = CONCAT(`special_abilities`,'^33,200') WHERE `id` = 223168;
  310. -- give NPCID 223003 a_summoned_boar an onspawn emote
  311. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  312. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,7,1,'paws at the soil in anticipation, then charges full-bore directly at you!');
  313. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223003;
  314. -- give NPCID 223167 #Innoruuk an entercombat say
  315. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  316. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,1,0,'Your kind have invaded my home for long enough. If you thought you knew what hate was before, I have one last lesson to teach you!');
  317. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223167;
  318. -- give NPCID 223167 #Innoruuk an ondeath say
  319. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,0,'This cannot be. . . I will return. . . somehow, in some way. . .');
  320. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223167;
  321. -- add a 200 unit tether to NPCID 223167 #Innoruuk
  322. UPDATE `npc_types` SET `special_abilities` = CONCAT(`special_abilities`,'^33,200') WHERE `id` = 223167;
  323. -- give NPCID 223166 #Cazic_Thule an entercombat say
  324. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  325. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,1,0,'For the defeat of my daughter, I shall make sure you know fear as none have ever experienced it before!');
  326. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223166;
  327. -- give NPCID 223166 #Cazic_Thule an ondeath say
  328. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,0,'Noooo. . . fear. . . shall never die. . .');
  329. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223166;
  330. -- give NPCID 223142 #Bertoxxulous an entercombat say
  331. SET @next_emoteid = (SELECT MAX(`emoteid`)+1 FROM `npc_emotes`);
  332. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,1,0,'Imagine every debilitating disease in the world stripping away your body and mind. Now prepare to experience that feeling by a hundred fold!');
  333. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223142;
  334. -- give NPCID 223142 #Bertoxxulous an ondeath say
  335. INSERT INTO `npc_emotes` (`emoteid`,`event_`,`type`,`text`) VALUES (@next_emoteid,2,0,'Defeat by mortals. . . impossible. The power of decay still beckons for you. . . someday. . .');
  336. UPDATE `npc_types` SET `emoteid` = @next_emoteid WHERE `id` = 223142;
  337. -- do not equip the loot Quarm has
  338. UPDATE `lootdrop_entries` SET `equip_item` = 0 WHERE `lootdrop_id` = 22678;
  339. -- fix Quarm's spell sets
  340. UPDATE `npc_spells_entries` SET `npc_spells_id` = 547, `recast_delay` = -1, `minlevel` = 0, `maxlevel` = 255 WHERE `npc_spells_id` IN (547,548,549,550,551);
  341. UPDATE `npc_spells_entries` SET `type` = 512 WHERE `npc_spells_id` = 547 AND `spellid` = 3230;
  342. UPDATE `npc_spells_entries` SET `type` = 256 WHERE `npc_spells_id` = 547 AND `spellid` = 3769;
  343. UPDATE `npc_spells_entries` SET `type` = 256 WHERE `npc_spells_id` = 547 AND `spellid` = 3770;
  344. UPDATE `npc_spells_entries` SET `type` = 256 WHERE `npc_spells_id` = 547 AND `spellid` = 3771;
  345. INSERT INTO `npc_spells_entries` (`npc_spells_id`,`spellid`,`type`,`minlevel`,`maxlevel`,`manacost`,`recast_delay`,`priority`) VALUES (547,3772,256,0,255,-1,60,10);
  346. INSERT INTO `npc_spells_entries` (`npc_spells_id`,`spellid`,`type`,`minlevel`,`maxlevel`,`manacost`,`recast_delay`,`priority`) VALUES (547,3768,1,0,255,-1,60,10);
  347. DELETE FROM `npc_spells` WHERE `id` IN (548,549,550,551);
  348. UPDATE `npc_spells` SET `name` = 'Quarm', `parent_list` = 0 WHERE `id` = 547;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!