API tools faq
paste
midoking

[New Wrath]Hunter & Mage Gear SQL

midoking
Jul 24th, 2014
387
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 10.62 KB | None | 0 0
raw download clone embed print report
  1.  INSERT INTO `item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `flagsCustom`, `VerifiedBuild`)
  2. VALUES  (80093, 4, 1, -1, 'New Wrath Mage Boots', 34044, 2, 0, 0, 1, 0, 0, 8, 128, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 346, 7, 164, 5, 354, 35, 42, 30, 57, 27, 53, 45, 318, 18, 102, 6, 399, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1689, 5, 5, 5, 5, 5, 5, 0, 0, 0, 35898, 1, 0, 0, 0, 0, 0, 20258, 1, 0, 0, 0, 0, 0, 14901, 1, 0, 0, 0, 0, 0, 15349, 1, 0, 0, 0, 0, 0, 31837, 1, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0),
  3.         (80078, 4, 2, -1, 'New Wrath Hunter Helm', 34367, 2, 0, 0, 1, 0, 0, 1, 4, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 413, 3, 271, 5, 301, 7, 436, 39, 581, 17, 112, 20, 207, 29, 311, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2013, 5, 5, 5, 5, 5, 5, 0, 0, 0, 71485, 0, 0, 0, 120000, 1141, 120000, 68251, 1, 0, 0, 0, 0, 0, 19168, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0),
  4.         (80079, 4, 2, -1, 'New Wrath Hunter Spaulders', 34091, 2, 0, 0, 1, 0, 0, 3, 4, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 467, 3, 316, 5, 299, 7, 491, 39, 596, 17, 199, 20, 263, 29, 326, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1987, 5, 5, 5, 5, 5, 5, 0, 0, 0, 65005, 0, 0, 0, 120000, 1141, 120000, 0, 0, 0, 0, 0, 0, 0, 19168, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0),
  5.         (80080, 4, 2, -1, 'New Wrath Hunter Breastplate', 33667, 2, 0, 0, 1, 0, 0, 5, 4, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 451, 3, 319, 5, 263, 7, 456, 39, 593, 17, 241, 20, 248, 29, 331, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2163, 5, 5, 5, 5, 5, 5, 0, 0, 0, 44797, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19168, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0),
  6.         (80081, 4, 2, -1, 'New Wrath Hunter Wrist', 33666, 2, 0, 0, 1, 0, 0, 9, 4, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 329, 3, 326, 5, 239, 7, 431, 39, 542, 17, 239, 20, 236, 29, 366, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1837, 5, 5, 5, 5, 5, 5, 0, 0, 0, 28497, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19168, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0),
  7.         (80082, 4, 2, -1, 'New Wrath Hunter Gauntlets', 33668, 2, 0, 0, 1, 0, 0, 10, 4, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 361, 3, 341, 5, 271, 7, 466, 39, 533, 17, 211, 20, 241, 29, 369, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1963, 5, 5, 5, 5, 5, 5, 0, 0, 0, 60346, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19168, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0),
  8.         (80083, 4, 2, -1, 'New Wrath Hunter Waist', 33665, 2, 0, 0, 1, 0, 0, 6, 4, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 351, 3, 376, 5, 213, 7, 467, 39, 561, 17, 216, 20, 262, 29, 361, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2037, 5, 5, 5, 5, 5, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19168, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0),
  9.         (80084, 4, 2, -1, 'New Wrath Hunter Legguards', 33672, 2, 0, 0, 1, 0, 0, 7, 4, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 412, 3, 371, 5, 216, 7, 491, 39, 541, 17, 225, 20, 243, 29, 376, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2633, 5, 5, 5, 5, 5, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19168, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0),
  10.         (80085, 4, 2, -1, 'New Wrath Hunter Boots', 34269, 2, 0, 0, 1, 0, 0, 8, 4, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 305, 3, 401, 5, 310, 7, 516, 39, 602, 17, 271, 20, 293, 29, 346, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1367, 5, 5, 5, 5, 5, 5, 0, 0, 0, 67243, 0, 0, 0, 120000, 1141, 120000, 0, 0, 0, 0, 0, 0, 0, 19168, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0),
  11.         (80086, 4, 1, -1, 'New Wrath Mage Crown', 34218, 2, 0, 0, 1, 0, 0, 1, 128, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 317, 7, 216, 5, 386, 35, 65, 43, 101, 27, 88, 45, 399, 18, 119, 6, 219, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1963, 5, 5, 5, 5, 5, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14901, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0),
  12.         (80087, 4, 1, -1, 'New Wrath Mage Mantle', 34254, 2, 0, 0, 1, 0, 0, 3, 128, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 341, 7, 259, 5, 413, 35, 63, 43, 173, 27, 99, 45, 417, 18, 159, 6, 288, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2037, 5, 5, 5, 5, 5, 5, 0, 0, 0, 67752, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14901, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0),
  13.         (80088, 4, 1, -1, 'New Wrath Mage Robes', 34038, 2, 0, 0, 1, 0, 0, 5, 128, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 356, 7, 281, 5, 425, 35, 48, 41, 356, 27, 99, 45, 433, 18, 116, 6, 304, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2190, 5, 5, 5, 5, 5, 5, 0, 0, 0, 67752, 1, 0, 0, 0, 0, 0, 35827, 1, 0, 0, 0, 0, 0, 14901, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0),
  14.         (80089, 4, 1, -1, 'New Wrath Mage Bindings', 34045, 2, 0, 0, 1, 0, 0, 9, 128, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 249, 7, 210, 5, 364, 35, 44, 30, 111, 27, 55, 45, 334, 18, 96, 6, 257, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1810, 5, 5, 5, 5, 5, 5, 0, 0, 0, 36067, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14901, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0),
  15.         (80090, 4, 1, -1, 'New Wrath Mage Hands', 34041, 2, 0, 0, 1, 0, 0, 10, 128, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 371, 7, 213, 5, 387, 35, 52, 30, 127, 27, 62, 45, 360, 18, 119, 6, 257, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2693, 5, 5, 5, 5, 5, 5, 0, 0, 0, 35896, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14901, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0),
  16.         (80091, 4, 1, -1, 'New Wrath Mage Belt', 34046, 2, 0, 0, 1, 0, 0, 6, 128, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 321, 7, 231, 5, 362, 35, 42, 30, 107, 27, 53, 45, 388, 18, 96, 6, 318, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1307, 5, 5, 5, 5, 5, 5, 0, 0, 0, 35896, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14901, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0),
  17.         (80092, 4, 1, -1, 'New Wrath Mage Pants', 34039, 2, 0, 0, 1, 0, 0, 7, 128, -1, 85, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1, 376, 7, 204, 5, 393, 35, 51, 0, 0, 27, 67, 45, 419, 18, 122, 6, 415, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2311, 5, 5, 5, 5, 5, 5, 0, 0, 0, 35896, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14901, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '|cff00FF00New Wrath|r"\r\n"Hrr, go straight!', 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0);
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!