Aokromes

missing items on 4.3.4

May 17th, 2013
271
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.33 KB | None | 0 0
  1. mysql> select entry,name from trinity.item_template where entry NOT in (select id from tempworld.dbc_Item);
  2. +-------+-----------------------------------+
  3. | entry | name |
  4. +-------+-----------------------------------+
  5. | 2719 | Small Brass Key |
  6. | 3467 | Dull Iron Key |
  7. | 3499 | Burnished Gold Key |
  8. | 3704 | Rusted Iron Key |
  9. | 3930 | Maury's Key |
  10. | 4882 | Benedict's Key |
  11. | 5396 | Key to Searing Gorge |
  12. | 5397 | Defias Gunpowder |
  13. | 7681 | Obsidian Golem Shard |
  14. | 7716 | Shattered Necklace |
  15. | 7923 | Defias Tower Key |
  16. | 8072 | Silixiz's Tower Key |
  17. | 9299 | Thermaplugg's Safe Combination |
  18. | 10460 | Hakkari Blood |
  19. | 10757 | Ward of the Defiler |
  20. | 11000 | Shadowforge Key |
  21. | 11079 | Gor'tesh's Lopped Off Head |
  22. | 12144 | Eggscilloscope |
  23. | 12301 | Bamboo Cage Key |
  24. | 13302 | Market Row Postbox Key |
  25. | 13303 | Crusaders' Square Postbox Key |
  26. | 13304 | Festival Lane Postbox Key |
  27. | 13305 | Elders' Square Postbox Key |
  28. | 13306 | King's Square Postbox Key |
  29. | 13307 | Fras Siabi's Postbox Key |
  30. | 13704 | Skeleton Key |
  31. | 13873 | Viewing Room Key |
  32. | 16315 | Sergeant Major's Cape |
  33. | 16334 | Sergeant's Insignia |
  34. | 16336 | Sergeant Major's Cape |
  35. | 16337 | Sergeant Major's Cape |
  36. | 16340 | First Sergeant's Cloak |
  37. | 17242 | Key to Salem's Chest |
  38. | 17262 | James' Key |
  39. | 18266 | Gordok Courtyard Key |
  40. | 18268 | Gordok Inner Door Key |
  41. | 21761 | Scarab Coffer Key |
  42. | 21762 | Greater Scarab Coffer Key |
  43. | 24490 | The Master's Key |
  44. | 27808 | Jump-a-tron 4000 Key |
  45. | 30438 | Cache of the Legion Key |
  46. | 30622 | Flamewrought Key |
  47. | 30623 | Reservoir Key |
  48. | 30633 | Auchenai Key |
  49. | 30634 | Warpforged Key |
  50. | 30635 | Key of Time |
  51. | 30637 | Flamewrought Key |
  52. | 31704 | The Tempest Key |
  53. | 10580 | Goblin "Boom" Box |
  54. | 40232 | Test Dazzling Talasite |
  55. | 42482 | The Violet Hold Key |
  56. | 43650 | Rusty Prison Key |
  57. | 44581 | Heroic Key to the Focusing Iris |
  58. | 44582 | Key to the Focusing Iris |
  59. | 44852 | Cornmeal |
  60. | 45796 | Celestial Planetarium Key |
  61. | 34117 | Rusty Iron Key |
  62. | 20591 | Sturdy Male Dwarf Mask |
  63. | 20596 | Sturdy Male Tauren Mask |
  64. | 20880 | Golden Token |
  65. | 23683 | Crystal Flake Throat Lozenge |
  66. | 32911 | Empty Brewfest Stein |
  67. | 32972 | Beer Goggles |
  68. | 33063 | Really Tough Brewfest Bread |
  69. | 33147 | Formula: Enchant Cloak - Subtlety |
  70. | 34835 | Omar's Gem of POWAH |
  71. | 41750 | Brunnhildar Harpoon |
  72. | 41753 | Brunnhildar Great Axe |
  73. | 41900 | LK Honor 5 Caster DPS Belt |
  74. | 41911 | LK Honor 5 Caster DPS Bracers |
  75. | 41995 | LK Arena 6 Warlock Helm |
  76. | 42000 | LK Arena 6 Warlock Chest |
  77. | 42007 | LK Arena 6 Warlock Legs |
  78. | 42013 | LK Arena 6 Warlock Shoulders |
  79. | 42019 | LK Arena 6 Warlock Gloves |
  80. | 42083 | LK Honor 5 Caster DPS Crit Cloak |
  81. | 42474 | Glyph of Arcane Explosion |
  82. | 43517 | Penguin Egg |
  83. | 45049 | Jousting Lance [PH] |
  84. | 45728 | Thalassian Lance [PH] |
  85. | 45729 | Raider's Lance [PH] |
  86. | 45730 | Forsaken Lance [PH] |
  87. | 45748 | Darkspear Lance [PH] |
  88. | 45749 | Brave's Lance [PH] |
  89. | 45750 | Elekk Lance [PH] |
  90. | 45751 | Spring-Loaded Mechano-Lance [PH] |
  91. | 45752 | Mountaineer's Lance [PH] |
  92. | 45754 | Darnassian Lance [PH] |
  93. | 45759 | Cavalry Lance [PH] |
Advertisement
Add Comment
Please, Sign In to add comment