API tools faq
paste
Advertisement
nimzo_asc

itemtemplate pvpgems

nimzo_asc
May 11th, 2021
115
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.33 KB | None | 0 0
raw download clone embed print report
  1. #Blue gems
  2. DELETE FROM `item_template` WHERE `entry`=205062;
  3. INSERT INTO `item_template` VALUES (205062, 3, 5, -1, 'Resplendent Fire Agate', 254641, 3, 0, 0, 1, 0, 0, 0, -1, -1, 70, 65, 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, 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, -1, 0, 0, 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, 'Matches a Red or Yellow Socket.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 1062, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0, 0, 0, 0);
  4. DELETE FROM `item_template` WHERE `entry`=205063;
  5. INSERT INTO `item_template` VALUES (205063, 3, 5, -1, 'Resplendent Sardonyx', 254644, 4, 0, 0, 1, 0, 0, 0, -1, -1, 70, 65, 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, 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, -1, 0, 0, 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, 'Matches a Red or Yellow Socket.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 1063, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0, 0, 0, 0);
  6. DELETE FROM `item_template` WHERE `entry`=205064;
  7. INSERT INTO `item_template` VALUES (205064, 3, 5, -1, 'Lucent Fire Agate', 254641, 3, 0, 0, 1, 0, 0, 0, -1, -1, 70, 65, 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, 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, -1, 0, 0, 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, 'Matches a Red or Yellow Socket.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 1064, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0, 0, 0, 0);
  8. DELETE FROM `item_template` WHERE `entry`=205065;
  9. INSERT INTO `item_template` VALUES (205065, 3, 5, -1, 'Lucent Sardonyx', 254644, 4, 0, 0, 1, 0, 0, 0, -1, -1, 70, 65, 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, 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, -1, 0, 0, 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, 'Matches a Red or Yellow Socket.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 1065, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0, 0, 0, 0);
  10. DELETE FROM `item_template` WHERE `entry`=205066;
  11. INSERT INTO `item_template` VALUES (205066, 3, 5, -1, 'Empowered Fire Agate', 254641, 3, 0, 0, 1, 0, 0, 0, -1, -1, 70, 65, 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, 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, -1, 0, 0, 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, 'Matches a Red or Yellow Socket.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 1066, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0, 0, 0, 0);
  12. DELETE FROM `item_template` WHERE `entry`=205067;
  13. INSERT INTO `item_template` VALUES (205067, 3, 5, -1, 'Empowered Sardonyx', 254644, 4, 0, 0, 1, 0, 0, 0, -1, -1, 70, 65, 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, 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, -1, 0, 0, 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, 'Matches a Red or Yellow Socket.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 1067, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0, 0, 0, 0);
  14. DELETE FROM `item_template` WHERE `entry`=205068;
  15. INSERT INTO `item_template` VALUES (205068, 3, 5, -1, 'Durable Fire Agate', 254641, 3, 0, 0, 1, 0, 0, 0, -1, -1, 70, 65, 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, 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, -1, 0, 0, 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, 'Matches a Red or Yellow Socket.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 1068, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0, 0, 0, 0);
  16. DELETE FROM `item_template` WHERE `entry`=205069;
  17. INSERT INTO `item_template` VALUES (205069, 3, 5, -1, 'Durable Sardonyx', 254644, 4, 0, 0, 1, 0, 0, 0, -1, -1, 70, 65, 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, 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, -1, 0, 0, 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, 'Matches a Red or Yellow Socket.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 1069, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0, 0, 0, 0);
  18. DELETE FROM `item_template` WHERE `entry`=205070;
  19. INSERT INTO `item_template` VALUES (205070, 3, 5, -1, 'Piercing Idocrase', 254640, 3, 0, 0, 1, 0, 0, 0, -1, -1, 70, 65, 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, 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, -1, 0, 0, 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, 'Matches a Yellow or Blue Socket.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 1070, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0, 0, 0, 0);
  20. DELETE FROM `item_template` WHERE `entry`=205071;
  21. INSERT INTO `item_template` VALUES (205071, 3, 5, -1, 'Piercing Diposide', 254643, 4, 0, 0, 1, 0, 0, 0, -1, -1, 70, 65, 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, 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, -1, 0, 0, 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, 'Matches a Yellow or Blue Socket.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 1071, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0, 0, 0, 0);
  22. DELETE FROM `item_template` WHERE `entry`=205072;
  23. INSERT INTO `item_template` VALUES (205072, 3, 5, -1, 'Tense Idocrase', 254640, 3, 0, 0, 1, 0, 0, 0, -1, -1, 70, 65, 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, 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, -1, 0, 0, 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, 'Matches a Yellow or Blue Socket.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 1072, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0, 0, 0, 0);
  24. DELETE FROM `item_template` WHERE `entry`=205073;
  25. INSERT INTO `item_template` VALUES (205073, 3, 5, -1, 'Tense Diposide', 254643, 4, 0, 0, 1, 0, 0, 0, -1, -1, 70, 65, 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, 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, -1, 0, 0, 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, 'Matches a Yellow or Blue Socket.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 1073, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0, 0, 0, 0);
  26. DELETE FROM `item_template` WHERE `entry`=205074;
  27. INSERT INTO `item_template` VALUES (205074, 3, 5, -1, 'Mysterious Heliotrope', 254642, 3, 0, 0, 1, 0, 0, 0, -1, -1, 70, 65, 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, 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, -1, 0, 0, 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, 'Matches a Red or Blue Socket.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 1074, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0, 0, 0, 0);
  28. DELETE FROM `item_template` WHERE `entry`=205075;
  29. INSERT INTO `item_template` VALUES (205075, 3, 5, -1, 'Mysterious Corundum', 254645, 4, 0, 0, 1, 0, 0, 0, -1, -1, 70, 65, 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, 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, -1, 0, 0, 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, 'Matches a Red or Blue Socket.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 1075, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 12340, 0, 0, 0, 0, 0);
  30.  
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!