API tools faq
paste
Advertisement
IcariumQA

Updated SQL from PM 16oct 22:15ST

IcariumQA
Oct 16th, 2020
132
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 8.14 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM `item_template` WHERE `entry`=816252;
  2. INSERT INTO `item_template` VALUES (816252, 9, 8, -1, 'Formula: Enchant Weapon - Undaunted Might', 7798, 3, 64, 0, 1, 30000, 7500, 0, -1, -1, 75, 58, 333, 375, 0, 0, 0, 0, 0, 0, 1, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 483, 0, -1, -1, -1, 0, -1, 820034, 6, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 'Permanently enchant a melee weapon to have a chance when attacking in melee range to increase Strength by 120 and increase critical strike rating by 30 for 15 seconds. Requires a level 35 or higher item.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 64, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0);
  3.  
  4. DELETE FROM `spell` WHERE `ID`=414022;
  5. INSERT INTO `spell` VALUES (414022, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 101, 0, 0, 63, 0, 8, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 6, 6, 0, 1, 1, 0, 0, 0, 0, 119, 29, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 29, 189, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1792, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4345, 0, 27422, 0, 50, 'Undaunted Might', 'Holy Strength', 'Force sacrée', 'Heilige Stärke', '神聖力量', '神聖力量', 'Fuerza Sagrada', 'Fuerza Sagrada', 'Священная сила', 0, 0, 0, 0, 0, 0, 0, 16712190, '', 'Rank 1', '', '', '', '', '', '', 'Уровень 1', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Chance to increase Strength by $s1 and Critical Strike Rating by $s2.', 'chance to heal self for 75 to 125 and increase Strength by 100 for 15 sec.', 'chance to heal self for 75 to 125 and increase Strength by 100 for 15 sec.', 'chance to heal self for 75 to 125 and increase Strength by 100 for 15 sec.', 'chance to heal self for 75 to 125 and increase Strength by 100 for 15 sec.', 'chance to heal self for 75 to 125 and increase Strength by 100 for 15 sec.', 'chance to heal self for 75 to 125 and increase Strength by 100 for 15 sec.', 'chance to heal self for 75 to 125 and increase Strength by 100 for 15 sec.', 'chance to heal self for 75 to 125 and increase Strength by 100 for 15 sec.', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Strength Increased by $s1. Critical Strike Rating increased by $s2.', 'Strength Increased by $s1.', 'Force augmentée de $s1.', 'Stärke um $s1 erhöht.', '提高$s1點力量。', '提高$s1點力量。', 'Fuerza aumentada $s1 p.', 'Fuerza aumentada $s1 p.', 'Сила повышена на $s1.', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0);
  6.  
  7. DELETE FROM `spell` WHERE `ID`=820034;
  8. INSERT INTO `spell` VALUES (820034, 0, 0, 0, 65568, 1024, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 15, 0, 0, 0, 101, 0, 0, 35, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 22450, 22449, 22446, 22445, 0, 0, 0, 0, 6, 10, 4, 60, 0, 0, 0, 0, 2, 189939, 0, 53, 0, 0, 1, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 838873, 0, 0, 414022, 0, 0, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3182, 0, 241, 0, 0, 'Enchant Weapon - Undaunted Might', 'Enchant Weapon - Crusader', 'Ench. d\'arme (Croisé)', 'Waffe - Kreuzfahrer', '附魔武器 - 十字軍', '附魔武器 - 十字軍', 'Encantar arma: cruzado', 'Encantar arma: cruzado', 'Чары для оружия - рыцарь', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Permanently enchant a melee weapon to have a chance when attacking in melee range to increase Strength by 120 and increase critical strike rating by 30 for 15 seconds. Requires a level 35 or higher item.', 'Permanently enchant a melee weapon to often heal for 75 to 125 and increase Strength by 100 for 15 sec. when attacking in melee. Has a reduced effect for players above level 60.', 'Enchante de manière permanente une arme de mêlée. Elle vous rend régulièrement de 75 à 125 points de vie et augmente la Force de 100 pendant 15 sec. quand vous attaquez en mêlée. A un effet réduit sur les personnages de niveau supérieur à 60.', 'Eine Nahkampfwaffe dauerhaft verzaubern, sodass sie ihren Träger oft um 75 bis 125 heilt und die Stärke 15 Sek. lang um 100 erhöht, wenn ein Nahkampfangriff durchgeführt wird. Verringerter Effekt bei Charakteren über Stufe 60.', '永久性地為一把近戰武器附魔，使其近戰攻擊能經常性地為你恢復75到125點生命力，並使你的力量提高100點，持續15秒。60級以上的玩家發動此效果的機率將會降低。', '永久性地為一把近戰武器附魔，使其近戰攻擊能經常性地為你恢復75到125點生命力，並使你的力量提高100點，持續15秒。60級以上的玩家發動此效果的機率將會降低。', 'Encanta de forma permanente un arma de combate cuerpo a cuerpo para que, cuando se golpee en cuerpo a cuerpo, sane a menudo de 75 a 125 p. y aumente la fuerza 100 p. durante 15 s. El efecto se reduce con los jugadores de nivel superior a 60.', 'Encanta de forma permanente un arma de combate cuerpo a cuerpo para que, cuando se golpee en cuerpo a cuerpo, sane a menudo de 75 a 125 p. y aumente la fuerza 100 p. durante 15 s. El efecto se reduce con los jugadores de nivel superior a 60.', 'Наложение на оружие ближнего боя чар, периодически восполняющих от 75 до 125 единиц здоровья и повышающих силу на 100 на 15 секунд при нанесении ударов в ближнем бою. Эффект снижен для игроков выше 60-го уровня.', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 63, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0);
  9.  
  10. DELETE FROM `creature_loot_template` WHERE `Entry`=17257 AND `Item`=816252;
  11. INSERT INTO `creature_loot_template` VALUES (17257, 816252, 0, 2.5, 0, 1, 3, 1, 1, 'Undaunted Might Recipe');
  12. DELETE FROM `creature_loot_template` WHERE `Entry`=19044 AND `Item`=816252;
  13. INSERT INTO `creature_loot_template` VALUES (19044, 816252, 0, 2.5, 0, 1, 2, 1, 1, 'Undaunted Might');
  14. DELETE FROM `creature_loot_template` WHERE `Entry`=117257 AND `Item`=816252;
  15. INSERT INTO `creature_loot_template` VALUES (117257, 816252, 0, 2.5, 0, 1, 3, 1, 1, 'Undaunted Might Recipe');
  16. DELETE FROM `creature_loot_template` WHERE `Entry`=119044 AND `Item`=816252;
  17. INSERT INTO `creature_loot_template` VALUES (119044, 816252, 0, 2.5, 0, 1, 2, 1, 1, 'Undaunted Might');
  18. DELETE FROM `creature_loot_template` WHERE `Entry`=217257 AND `Item`=816252;
  19. INSERT INTO `creature_loot_template` VALUES (217257, 816252, 0, 5, 0, 1, 3, 1, 1, 'Undaunted Might Recipe');
  20. DELETE FROM `creature_loot_template` WHERE `Entry`=219044 AND `Item`=816252;
  21. INSERT INTO `creature_loot_template` VALUES (219044, 816252, 0, 5, 0, 1, 2, 1, 1, 'Undaunted Might');
  22. DELETE FROM `creature_loot_template` WHERE `Entry`=317257 AND `Item`=816252;
  23. INSERT INTO `creature_loot_template` VALUES (317257, 816252, 0, 5, 0, 1, 3, 1, 1, 'Undaunted Might Recipe');
  24. DELETE FROM `creature_loot_template` WHERE `Entry`=319044 AND `Item`=816252;
  25. INSERT INTO `creature_loot_template` VALUES (319044, 816252, 0, 5, 0, 1, 2, 1, 1, 'Undaunted Might');
  26.  
  27. DELETE FROM `item_template` WHERE `entry`=816252;
  28. INSERT INTO `item_template` VALUES (816252, 9, 8, -1, 'Formula: Enchant Weapon - Undaunted Might', 7798, 3, 64, 0, 1, 30000, 7500, 0, -1, -1, 75, 58, 333, 375, 0, 0, 0, 0, 0, 0, 1, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 483, 0, -1, -1, -1, 0, -1, 820034, 6, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 'Permanently enchant a melee weapon to have a chance when attacking in melee range to increase Strength by 120 and increase critical strike rating by 30 for 15 seconds. Requires a level 35 or higher item.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 64, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0);
  29.  
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!