API tools faq
paste
Advertisement
IcariumQA

PVP season 1 items missing stats v2

IcariumQA
Sep 28th, 2020 (edited)
120
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 10.53 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM `item_template` WHERE `entry`=32973;
  2. INSERT INTO `item_template` VALUES (32973, 4, 1, -1, 'General\'s Mooncloth Cuffs', 41255, 4, 36864, 0, 1, 0, 0, 9, -1, -1, 113, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 10, 7, 25, 5, 14, 0, 0, 45, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35, 11, 0, 0, 0, 0, 0, 0, 0, 0, 328, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101710, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 35, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 15595, 10, 0);
  3. DELETE FROM `item_template` WHERE `entry`=32974;
  4. INSERT INTO `item_template` VALUES (32974, 4, 1, -1, 'General\'s Mooncloth Belt', 41475, 4, 36864, 0, 1, 0, 0, 6, -1, -1, 123, 70, 0, 0, 0, 0, 0, 0, 5, 0, 1, 0, 10, 7, 39, 5, 27, 0, 0, 45, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35, 14, 0, 0, 0, 0, 0, 0, 0, 0, 458, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101712, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 15595, 12, 0);
  5. DELETE FROM `item_template` WHERE `entry`=32975;
  6. INSERT INTO `item_template` VALUES (32975, 4, 1, -1, 'General\'s Mooncloth Slippers', 41164, 4, 36864, 0, 1, 0, 0, 8, -1, -1, 123, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 10, 7, 40, 5, 27, 0, 0, 45, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35, 14, 0, 0, 0, 0, 0, 0, 0, 0, 554, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101712, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 15595, 12, 0);
  7. DELETE FROM `item_template` WHERE `entry`=32982;
  8. INSERT INTO `item_template` VALUES (32982, 4, 4, -1, 'General\'s Ornamented Belt', 41165, 4, 36864, 0, 1, 0, 0, 6, -1, -1, 123, 70, 0, 0, 0, 0, 0, 0, 5, 0, 1, 0, 10, 7, 34, 32, 23, 5, 23, 0, 0, 45, 28, 0, 0, 0, 0, 0, 0, 0, 0, 35, 10, 0, 0, 0, 0, 0, 0, 0, 0, 653, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101712, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 55, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 15595, 12, 0);
  9. DELETE FROM `item_template` WHERE `entry`=32983;
  10. INSERT INTO `item_template` VALUES (32983, 4, 4, -1, 'General\'s Ornamented Bracers', 41257, 4, 36864, 0, 1, 0, 0, 9, -1, -1, 113, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 10, 7, 22, 32, 14, 5, 12, 0, 0, 45, 20, 0, 0, 0, 0, 0, 0, 0, 0, 35, 7, 0, 0, 0, 0, 0, 0, 0, 0, 468, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101710, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 55, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 15595, 10, 0);
  11. DELETE FROM `item_template` WHERE `entry`=32984;
  12. INSERT INTO `item_template` VALUES (32984, 4, 4, -1, 'General\'s Ornamented Greaves', 41167, 4, 36864, 0, 1, 0, 0, 8, -1, -1, 123, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 10, 7, 34, 32, 23, 5, 23, 0, 0, 45, 28, 0, 0, 0, 0, 0, 0, 0, 0, 35, 10, 0, 0, 0, 0, 0, 0, 0, 0, 797, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101712, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 75, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 15595, 12, 0);
  13. DELETE FROM `item_template` WHERE `entry`=32991;
  14. INSERT INTO `item_template` VALUES (32991, 4, 3, -1, 'General\'s Ringmail Bracers', 41259, 4, 36864, 0, 1, 0, 0, 9, -1, -1, 113, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 10, 7, 22, 5, 12, 0, 0, 32, 14, 45, 20, 0, 0, 0, 0, 0, 0, 0, 0, 35, 8, 0, 0, 0, 0, 0, 0, 0, 0, 419, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101710, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 50, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 15595, 10, 0);
  15. DELETE FROM `item_template` WHERE `entry`=32992;
  16. INSERT INTO `item_template` VALUES (32992, 4, 3, -1, 'General\'s Ringmail Girdle', 41477, 4, 36864, 0, 1, 0, 0, 6, -1, -1, 123, 70, 0, 0, 0, 0, 0, 0, 5, 0, 1, 0, 10, 7, 34, 5, 23, 0, 0, 32, 24, 45, 28, 0, 0, 0, 0, 0, 0, 0, 0, 35, 11, 0, 0, 0, 0, 0, 0, 0, 0, 584, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101712, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 15595, 12, 0);
  17. DELETE FROM `item_template` WHERE `entry`=32993;
  18. INSERT INTO `item_template` VALUES (32993, 4, 3, -1, 'General\'s Ringmail Sabatons', 41481, 4, 36864, 0, 1, 0, 0, 8, -1, -1, 123, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 10, 7, 34, 5, 23, 0, 0, 32, 24, 45, 28, 0, 0, 0, 0, 0, 0, 0, 0, 35, 11, 0, 0, 0, 0, 0, 0, 0, 0, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101712, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 15595, 12, 0);
  19. DELETE FROM `item_template` WHERE `entry`=6032973;
  20. INSERT INTO `item_template` VALUES (6032973, 4, 1, -1, 'Bloodforged General\'s Mooncloth Cuffs', 41255, 4, 36864, 0, 1, 0, 0, 9, -1, -1, 113, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 10, 7, 25, 5, 11, 0, 0, 45, 17, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 328, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101704, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, '', 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 35, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 50, 0, 0, 0, 0, 15595, 4, 0);
  21. DELETE FROM `item_template` WHERE `entry`=6032974;
  22. INSERT INTO `item_template` VALUES (6032974, 4, 1, -1, 'Bloodforged General\'s Mooncloth Belt', 41475, 4, 36864, 0, 1, 0, 0, 6, -1, -1, 123, 70, 0, 0, 0, 0, 0, 0, 5, 0, 1, 0, 10, 7, 39, 5, 21, 0, 0, 45, 24, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 458, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101705, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, '', 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 50, 0, 0, 0, 0, 15595, 5, 0);
  23. DELETE FROM `item_template` WHERE `entry`=6032975;
  24. INSERT INTO `item_template` VALUES (6032975, 4, 1, -1, 'Bloodforged General\'s Mooncloth Slippers', 41164, 4, 36864, 0, 1, 0, 0, 8, -1, -1, 123, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 10, 7, 40, 5, 21, 0, 0, 45, 24, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 554, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101705, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, '', 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 50, 0, 0, 0, 0, 15595, 5, 0);
  25. DELETE FROM `item_template` WHERE `entry`=6032982;
  26. INSERT INTO `item_template` VALUES (6032982, 4, 4, -1, 'Bloodforged General\'s Ornamented Belt', 41165, 4, 36864, 0, 1, 0, 0, 6, -1, -1, 123, 70, 0, 0, 0, 0, 0, 0, 5, 0, 1, 0, 10, 7, 34, 32, 17, 5, 18, 0, 0, 45, 21, 0, 0, 0, 0, 0, 0, 0, 0, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 653, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101705, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, '', 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 55, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 50, 0, 0, 0, 0, 15595, 5, 0);
  27. DELETE FROM `item_template` WHERE `entry`=6032983;
  28. INSERT INTO `item_template` VALUES (6032983, 4, 4, -1, 'Bloodforged General\'s Ornamented Bracers', 41257, 4, 36864, 0, 1, 0, 0, 9, -1, -1, 113, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 10, 7, 22, 32, 10, 5, 9, 0, 0, 45, 15, 0, 0, 0, 0, 0, 0, 0, 0, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 468, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101704, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, '', 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 55, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 50, 0, 0, 0, 0, 15595, 4, 0);
  29. DELETE FROM `item_template` WHERE `entry`=6032984;
  30. INSERT INTO `item_template` VALUES (6032984, 4, 4, -1, 'Bloodforged General\'s Ornamented Greaves', 41167, 4, 36864, 0, 1, 0, 0, 8, -1, -1, 123, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 10, 7, 34, 32, 17, 5, 18, 0, 0, 45, 21, 0, 0, 0, 0, 0, 0, 0, 0, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 797, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101705, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, '', 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 75, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 50, 0, 0, 0, 0, 15595, 5, 0);
  31. DELETE FROM `item_template` WHERE `entry`=6032991;
  32. INSERT INTO `item_template` VALUES (6032991, 4, 3, -1, 'Bloodforged General\'s Ringmail Bracers', 41259, 4, 36864, 0, 1, 0, 0, 9, -1, -1, 113, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 10, 7, 22, 5, 9, 0, 0, 32, 10, 45, 15, 0, 0, 0, 0, 0, 0, 0, 0, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 419, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101704, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, '', 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 50, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 50, 0, 0, 0, 0, 15595, 4, 0);
  33. DELETE FROM `item_template` WHERE `entry`=6032992;
  34. INSERT INTO `item_template` VALUES (6032992, 4, 3, -1, 'Bloodforged General\'s Ringmail Girdle', 41477, 4, 36864, 0, 1, 0, 0, 6, -1, -1, 123, 70, 0, 0, 0, 0, 0, 0, 5, 0, 1, 0, 10, 7, 34, 5, 18, 0, 0, 32, 17, 45, 21, 0, 0, 0, 0, 0, 0, 0, 0, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 584, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101705, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, '', 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 50, 0, 0, 0, 0, 15595, 5, 0);
  35. DELETE FROM `item_template` WHERE `entry`=6032993;
  36. INSERT INTO `item_template` VALUES (6032993, 4, 3, -1, 'Bloodforged General\'s Ringmail Sabatons', 41481, 4, 36864, 0, 1, 0, 0, 8, -1, -1, 123, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 10, 7, 34, 5, 18, 0, 0, 32, 17, 45, 21, 0, 0, 0, 0, 0, 0, 0, 0, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 101705, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, '', 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 50, 0, 0, 0, 0, 15595, 5, 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!