API tools faq
paste
Advertisement
IcariumQA

Critical Block talents and RE

IcariumQA
Feb 3rd, 2021 (edited)
122
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 16.92 KB | None | 0 0
raw download clone embed print report
  1. #SLS core aura crit block
  2. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=47294 AND `spell_effect`=47297 AND `type`=2;
  3. INSERT INTO `spell_linked_spell` VALUES (47294, 47297, 2, 'Critical Block - core aura r1');
  4. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=47295 AND `spell_effect`=47297 AND `type`=2;
  5. INSERT INTO `spell_linked_spell` VALUES (47295, 47297, 2, 'Critical Block - core aura r2');
  6. DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=47296 AND `spell_effect`=47297 AND `type`=2;
  7. INSERT INTO `spell_linked_spell` VALUES (47296, 47297, 2, 'Critical Block - core aura r3');
  8.  
  9.  
  10. DELETE FROM `spell_proc` WHERE `SpellId`=47294;
  11. #INSERT INTO `spell_proc` VALUES (47294, 0, 0, 0, 0, 0, 1048576, 0, 8, 0, 0, 0, 100, 0, 0, 'Critical Block');
  12. DELETE FROM `spell_proc` WHERE `SpellId`=47295;
  13. #INSERT INTO `spell_proc` VALUES (47295, 0, 0, 0, 0, 0, 1048576, 0, 0, 67, 0, 0, 100, 0, 0, 'Critical Block');
  14. DELETE FROM `spell_proc` WHERE `SpellId`=47296;
  15. #INSERT INTO `spell_proc` VALUES (47296, 0, 0, 0, 0, 0, 1048576, 0, 0, 67, 0, 0, 100, 0, 0, 'Critical Block');
  16.  
  17. DELETE FROM `spell` WHERE `ID`=47294;
  18. INSERT INTO `spell` VALUES (47294, 0, 0, 0, 464, 0, 0, 524288, 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, 100, 0, 0, 0, 1, 0, 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, -1, 0, 0, 6, 6, 6, 1, 1, 1, 0, 0, 0, 99, 3, -9, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 253, 107, 107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 65536, 0, 0, 2778, 0, 50, 'Critical Block', 'Critical Block', 'Blocage critique', 'Kritisches Blocken', '致命格擋', '致命格擋', 'Bloqueo crítico', 'Bloqueo crítico', 'Критический блок', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Rank 1', 'Rank 1', 'Rang 1', 'Rang 1', '等級 1', '等級 1', 'Rango 1', 'Rango 1', 'Уровень 1', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Your successful blocks now further reduce the damage you take from the blocked hit by $s3%. This effect does not work against players. In addition, your chance to critically hit with your Shield Slam ability by an additional $s2%.', 'Your successful blocks have a $s1% chance to block double the normal amount and increases your chance to critically hit with your Shield Slam ability by an additional $s2%.', 'Vos blocages réussis ont $s1% de chances de bloquer le double du montant normal. Augmente vos chances d\'infliger un coup critique avec votre technique Heurt de bouclier de $s2% supplémentaires.', 'Jedes erfolgreiche Blocken hat eine Chance von $s1%, das Doppelte der normalen Menge zu blocken und erhöht Eure Chance, mit Eurer Fähigkeit \'Schildschlag\' einen kritischen Treffer zu erzielen, um zusätzliche $s2%.', '你每次格擋成功時有$s1%的機率格擋兩倍的傷害，並且使你的盾牌猛擊造成致命一擊的機率提高$s2%。', '你每次格擋成功時有$s1%的機率格擋兩倍的傷害，並且使你的盾牌猛擊造成致命一擊的機率提高$s2%。', 'Tus bloqueos realizados tienen un $s1% de probabilidad de bloquear el doble de daño de la cantidad normal y aumentan tu probabilidad de asestar un golpe crítico con tu facultad Embate con escudo un $s2% extra.', 'Tus bloqueos realizados tienen un $s1% de probabilidad de bloquear el doble de daño de la cantidad normal y aumentan tu probabilidad de asestar un golpe crítico con tu facultad Embate con escudo un $s2% extra.', 'При успешном блокировании атаки вы с вероятностью $s1% заблокируете в два раза больше урона. Вероятность нанести критический удар при применении способности "Мощный удар щитом" повышается на $s2%.', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 4, 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);
  19. DELETE FROM `spell` WHERE `ID`=47295;
  20. INSERT INTO `spell` VALUES (47295, 0, 0, 0, 464, 0, 0, 524288, 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, 100, 0, 0, 0, 1, 0, 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, -1, 0, 0, 6, 6, 6, 1, 1, 1, 0, 0, 0, 99, 6, -17, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 253, 107, 107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 65536, 0, 0, 2778, 0, 50, 'Critical Block', 'Critical Block', 'Blocage critique', 'Kritisches Blocken', '致命格擋', '致命格擋', 'Bloqueo crítico', 'Bloqueo crítico', 'Критический блок', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Rank 2', 'Rank 2', 'Rang 2', 'Rang 2', '等級 2', '等級 2', 'Rango 2', 'Rango 2', 'Уровень 2', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Your successful blocks now further reduce the damage you take from the blocked hit by $s3%. This effect does not work against players. In addition, your chance to critically hit with your Shield Slam ability by an additional $s2%.', 'Your successful blocks have a $s1% chance to block double the normal amount and increases your chance to critically hit with your Shield Slam ability by an additional $s2%.', 'Vos blocages réussis ont $s1% de chances de bloquer le double du montant normal. Augmente vos chances d\'infliger un coup critique avec votre technique Heurt de bouclier de $s2% supplémentaires.', 'Jedes erfolgreiche Blocken hat eine Chance von $s1%, das Doppelte der normalen Menge zu blocken und erhöht Eure Chance, mit Eurer Fähigkeit \'Schildschlag\' einen kritischen Treffer zu erzielen, um zusätzliche $s2%.', '你每次格擋成功時有$s1%的機率格擋兩倍的傷害，並且使你的盾牌猛擊造成致命一擊的機率提高$s2%。', '你每次格擋成功時有$s1%的機率格擋兩倍的傷害，並且使你的盾牌猛擊造成致命一擊的機率提高$s2%。', 'Tus bloqueos realizados tienen un $s1% de probabilidad de bloquear el doble de daño de la cantidad normal y aumentan tu probabilidad de asestar un golpe crítico con tu facultad Embate con escudo un $s2% extra.', 'Tus bloqueos realizados tienen un $s1% de probabilidad de bloquear el doble de daño de la cantidad normal y aumentan tu probabilidad de asestar un golpe crítico con tu facultad Embate con escudo un $s2% extra.', 'При успешном блокировании атаки вы с вероятностью $s1% заблокируете в два раза больше урона. Вероятность нанести критический удар при применении способности "Мощный удар щитом" повышается на $s2%.', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 4, 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);
  21. DELETE FROM `spell` WHERE `ID`=47296;
  22. INSERT INTO `spell` VALUES (47296, 0, 0, 0, 464, 0, 0, 524288, 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, 100, 0, 0, 0, 1, 0, 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, -1, 0, 0, 6, 6, 6, 1, 1, 1, 0, 0, 0, 99, 9, -26, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 253, 107, 107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 65536, 0, 0, 2778, 0, 50, 'Critical Block', 'Critical Block', 'Blocage critique', 'Kritisches Blocken', '致命格擋', '致命格擋', 'Bloqueo crítico', 'Bloqueo crítico', 'Критический блок', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Rank 3', 'Rank 3', 'Rang 3', 'Rang 3', '等級 3', '等級 3', 'Rango 3', 'Rango 3', 'Уровень 3', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Your successful blocks now further reduce the damage you take from the blocked hit by $s3%. This effect does not work against players. In addition, your chance to critically hit with your Shield Slam ability by an additional $s2%.', 'Your successful blocks have a $s1% chance to block double the normal amount and increases your chance to critically hit with your Shield Slam ability by an additional $s2%.', 'Vos blocages réussis ont $s1% de chances de bloquer le double du montant normal. Augmente vos chances d\'infliger un coup critique avec votre technique Heurt de bouclier de $s2% supplémentaires.', 'Jedes erfolgreiche Blocken hat eine Chance von $s1%, das Doppelte der normalen Menge zu blocken und erhöht Eure Chance, mit Eurer Fähigkeit \'Schildschlag\' einen kritischen Treffer zu erzielen, um zusätzliche $s2%.', '你每次格擋成功時有$s1%的機率格擋兩倍的傷害，並且使你的盾牌猛擊造成致命一擊的機率提高$s2%。', '你每次格擋成功時有$s1%的機率格擋兩倍的傷害，並且使你的盾牌猛擊造成致命一擊的機率提高$s2%。', 'Tus bloqueos realizados tienen un $s1% de probabilidad de bloquear el doble de daño de la cantidad normal y aumentan tu probabilidad de asestar un golpe crítico con tu facultad Embate con escudo un $s2% extra.', 'Tus bloqueos realizados tienen un $s1% de probabilidad de bloquear el doble de daño de la cantidad normal y aumentan tu probabilidad de asestar un golpe crítico con tu facultad Embate con escudo un $s2% extra.', 'При успешном блокировании атаки вы с вероятностью $s1% заблокируете в два раза больше урона. Вероятность нанести критический удар при применении способности "Мощный удар щитом" повышается на $s2%.', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 4, 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);
  23.  
  24. DELETE FROM `spell` WHERE `ID`=47297;
  25. INSERT INTO `spell` VALUES (47297, 0, 0, 0, 64, 0, 0, 0, 0, 0, 0, 0, 131072, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 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, -1, 0, 0, 6, 0, 0, 1, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 4, 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, 1, 0, 0, 'Critical Block', 'Critical Block', 'Critical Block', 'Critical Block', 'Critical Block', 'Critical Block', 'Critical Block', 'Critical Block', 'Critical Block', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 4, 0, 0, 65536, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  26.  
  27.  
  28. #Crit block RE
  29. DELETE FROM `db_spellitemenchantment_12340` WHERE `ID`=4726;
  30. INSERT INTO `db_spellitemenchantment_12340` VALUES (4726, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 947294, 0, 0, 'Equip: Critical Block - Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', 'Equip: Critical Block - Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', 'Equip: Critical Block - Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', 'Equip: Critical Block - Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', 'Equip: Critical Block - Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', 'Equip: Critical Block - Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', 'Equip: Critical Block - Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', 'Equip: Critical Block - Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', 'Equip: Critical Block - Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', 'Equip: Critical Block - Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', 'Equip: Critical Block - Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', 'Equip: Critical Block - Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', 'Equip: Critical Block - Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', 'Equip: Critical Block - Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', 'Equip: Critical Block - Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', '', 16712190, 0, 0, 0, 0, 0, 0, 0);
  31.  
  32. DELETE FROM `item_enchantment_random_tiers` WHERE `enchantID`=4726;
  33. INSERT INTO `item_enchantment_random_tiers` VALUES (4726, 1, 'ANY', NULL, 947294, 'Critical Block', 0, 100, 3);
  34.  
  35. DELETE FROM `spell` WHERE `ID`=947294;
  36. INSERT INTO `spell` VALUES (947294, 0, 0, 0, 464, 2048, 0, 524288, 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, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 3, 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, -2, 4, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 107, 107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 65536, 0, 512, 0, 0, 0, 0, 0, 0, 2778, 0, 50, 'Critical Block', 'Critical Block', 'Critical Block', 'Critical Block', 'Critical Block', 'Critical Block', 'Bloqueo crítico', 'Bloqueo crítico', 'Критический блок', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Rank 3', 'Rank 2', 'Rank 1', 'Rank 1', 'Rank 1', 'Rank 1', 'Rank 1', 'Rank 1', 'Уровень 1', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', 'Your successful blocks have a $s1% chance to block double the normal amount and increases your chance to critically hit with your Shield Slam ability by an additional $s2%.', 'Your successful blocks have a $s1% chance to block double the normal amount and increases your chance to critically hit with your Shield Slam ability by an additional $s2%.', 'Your successful blocks have a $s1% chance to block double the normal amount and increases your chance to critically hit with your Shield Slam ability by an additional $s2%.', 'Your successful blocks have a $s1% chance to block double the normal amount and increases your chance to critically hit with your Shield Slam ability by an additional $s2%.', 'Your successful blocks have a $s1% chance to block double the normal amount and increases your chance to critically hit with your Shield Slam ability by an additional $s2%.', 'Your successful blocks have a $s1% chance to block double the normal amount and increases your chance to critically hit with your Shield Slam ability by an additional $s2%.', 'Your successful blocks have a $s1% chance to block double the normal amount and increases your chance to critically hit with your Shield Slam ability by an additional $s2%.', 'При успешном блокировании атаки вы с вероятностью $s1% заблокируете в два раза больше урона. Вероятность нанести критический удар при применении способности "Мощный удар щитом" повышается на $s2%.', 0, 0, 0, 0, 0, 0, 0, 16712190, 'Increases the damage reduction of your Critical Block talent by 1%. In addition, your chance to critically hit with your Shield Slam ability is increased by an additional 5%.', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 4, 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);
  37.  
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!