3 Custom Vendors For Ascent menu

User Tag List

Results 1 to 8 of 8
  1. #1
    hafastr's Avatar Member
    Reputation
    3
    Join Date
    Jul 2007
    Posts
    34
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    3 Custom Vendors For Ascent

    I use Chrispee's repack (Rawks BTW) and me and my twink guild go on private servers and make twinks to test out builds for live.

    This is my twink vendor set so we don't gotta look up id's for the gear we use.

    Gear Vendor .npc spawn 60000
    Code:
    INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
    VALUES (60000, 70, 70, 814,  8000,  8000,  7500,  1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0, 0, 0);
    INSERT INTO creature_names (entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader) 
    VALUES (60000,"Ornery Kid","Twink Vendor",0,7,1,0,0,NULL,11655,1,1,1,NULL);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,10399,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,2041,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,3202,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,19972,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,19969,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,4385,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,2059,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,6335,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,80000,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,80001,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,80002,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,80003,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,80004,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,80005,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,80006,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,80007,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,80008,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,80009,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,80010,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,80011,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,80012,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,6449,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,6468,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,10410,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,5961,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,1121,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,6335,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,10653,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,6414,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,2933,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,4998,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,20429,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,20439,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,4381,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18845,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18834,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18846,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18849,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18850,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18851,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18852,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18853,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,29592,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18863,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18854,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18856,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18857,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18858,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18859,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18862,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,18864,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,29593,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,3324,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,19024,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,1486,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,12977,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,2911,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,12987,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,1974,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,6667,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,17374,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,4373,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,20429,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,10657,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,20442,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,20444,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,21933,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,16768,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,7003,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,4534,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,12994,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,12982,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,7189,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,15313,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,6579,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,22990,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,6460,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,4800,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,12978,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,14567,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60000,16987,0);
    Weapon Vendor .npc spawn 60001
    Code:
    INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
    VALUES (60001, 70, 70, 814,  8000,  8000,  7500,  1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0, 0, 0);
    INSERT INTO creature_names (entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader) 
    VALUES (60001,"Ornery Kid","Twink Vendor",0,7,1,0,0,NULL,11655,1,1,1,NULL);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,890,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,1482,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,1935,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,20440,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,20430,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,20441,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,20443,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,22984,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,5815,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,7001,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,7230,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,20425,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,3415,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,1484,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,5183,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,5201,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,2271,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,12997,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,7002,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,3761,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,6504,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,5191,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,2567,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,6472,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,29584,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,29201,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,13136,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,6469,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,2256,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,3822,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,1218,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60001,22995,0);
    Kit Vendor .npc Spawn 60002
    Code:
    INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
    VALUES (60002, 70, 70, 814,  8000,  8000,  7500,  1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0, 0, 0);
    INSERT INTO creature_names (entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader) 
    VALUES (60002,"Ornery Kid","Twink Vendor",0,7,1,0,0,NULL,11655,1,1,1,NULL);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60002,29533,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60002,29534,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60002,29535,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60002,29536,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60002,24275,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60002,24273,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60002,24276,0);
    INSERT INTO vendors (vendorGuid, itemGuid, amount)
    VALUES (60002,24274,0);
    And this is for all the of the monkey, bear, and eagle gear we use. (manditory for the gear vendor to work properly)
    Code:
    INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, 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, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
    VALUES (80000,4,2,-1,"Scouting Gloves of the Monkey","Scouting Gloves of the Monkey","Scouting Gloves of the Monkey","Scouting Gloves of the Monkey",14755,2,0,10000,0000,10,-1,-1,0,19,0,0,0,0,0,0,0,0,1,0,7,4,3,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,51,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"",0,0,0,0,0,8,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
    
    INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, 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, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
    VALUES (80001,4,2,-1,"Scouting Gloves of the Eagle","Scouting Gloves of the Eagle","Scouting Gloves of the Eagle","Scouting Gloves of the Eagle",14755,2,0,10000,0000,10,-1,-1,0,19,0,0,0,0,0,0,0,0,1,0,7,4,5,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,51,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"",0,0,0,0,0,8,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
    
    INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, 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, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
    VALUES (80002,4,2,-1,"Scouting Gloves of the Eagle","Scouting Gloves of the Eagle","Scouting Gloves of the Eagle","Scouting Gloves of the Eagle",14755,2,0,10000,0000,10,-1,-1,0,19,0,0,0,0,0,0,0,0,1,0,7,4,5,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,51,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"",0,0,0,0,0,8,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
    
    INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, 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, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
    VALUES (80003,4,2,-1,"Scouting Trousers of the Monkey","Scouting Trousers of the Monkey","Scouting Trousers of the Monkey","Scouting Trousers of the Monkey",14757,2,0,10000,0000,7,-1,-1,0,19,0,0,0,0,0,0,0,0,1,0,7,5,3,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,53,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"",0,0,0,0,0,8,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
    
    INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, 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, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
    VALUES (80005,4,2,-1,"Scouting Trousers of the Eagle","Scouting Trousers of the Eagle","Scouting Trousers of the Eagle","Scouting Trousers of the Eagle",14757,2,0,10000,0000,7,-1,-1,0,19,0,0,0,0,0,0,0,0,1,0,7,5,5,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,53,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"",0,0,0,0,0,8,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
    
    INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, 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, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
    VALUES (80006,4,2,-1,"Scouting Trousers of the Bear","Scouting Trousers of the Bear","Scouting Trousers of the Bear","Scouting Trousers of the Bear",14757,2,0,10000,0000,7,-1,-1,0,19,0,0,0,0,0,0,0,0,1,0,7,5,4,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,53,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"",0,0,0,0,0,8,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
    
    INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, 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, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
    VALUES (80007,4,2,-1,"Scouting Bracers of the Monkey","Scouting Bracers of the Monkey","Scouting Bracers of the Monkey","Scouting Bracers of the Monkey",3657,2,0,10000,0000,9,-1,-1,0,19,0,0,0,0,0,0,0,0,1,0,7,3,3,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,35,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"",0,0,0,0,0,8,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
    
    INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, 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, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
    VALUES (80008,4,2,-1,"Scouting Bracers of the Eagle","Scouting Bracers of the Eagle","Scouting Bracers of the Eagle","Scouting Bracers of the Eagle",3657,2,0,10000,0000,9,-1,-1,0,19,0,0,0,0,0,0,0,0,1,0,7,3,5,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,35,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"",0,0,0,0,0,8,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
    
    INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, 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, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
    VALUES (80009,4,2,-1,"Scouting Bracers of the Bear","Scouting Bracers of the Bear","Scouting Bracers of the Bear","Scouting Bracers of the Bear",3657,2,0,10000,0000,9,-1,-1,0,19,0,0,0,0,0,0,0,0,1,0,7,3,4,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,35,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"",0,0,0,0,0,8,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
    
    INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, 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, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
    VALUES (80010,4,3,-1,"Outrunner's Legguards of the Bear","Outrunner's Legguards of the Bear","Outrunner's Legguards of the Bear","Outrunner's Legguards of the Bear",26995,2,0,10000,0000,7,-1,-1,0,19,0,0,0,0,0,0,0,0,1,0,7,5,4,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,155,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"",0,0,0,0,0,5,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
    
    INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, 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, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
    VALUES (80011,4,3,-1,"Outrunner's Legguards of the Eagle","Outrunner's Legguards of the Eagle","Outrunner's Legguards of the Eagle","Outrunner's Legguards of the Eagle",26995,2,0,10000,0000,7,-1,-1,0,19,0,0,0,0,0,0,0,0,1,0,7,5,5,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,155,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"",0,0,0,0,0,5,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
    
    INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, 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, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
    VALUES (80012,4,1,-1,"Pagan Bands of the Eagle","Pagan Bands of the Eagle","Pagan Bands of the Eagle","Pagan Bands of the Eagle",16907,2,0,10000,0000,9,-1,-1,0,19,0,0,0,0,0,0,0,0,1,0,7,3,5,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"",0,0,0,0,0,7,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
    Enjoy, it makes Twink Testing so much easier.

    Remember it wont work if you have custom vendors on these id's or custom items using these id's if you need you can change the id's to open npc or item id's by just changing all the 80000's to say any 5 digit number not in use by your database.
    Last edited by hafastr; 11-04-2007 at 03:23 PM.

    3 Custom Vendors For Ascent
  2. #2
    morica's Avatar Member
    Reputation
    16
    Join Date
    Mar 2007
    Posts
    63
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: 3 Custom Vendors For Ascent

    pshhh take me and soularis's idea much?

  3. #3
    [Shon3m]'s Avatar Banned
    Reputation
    128
    Join Date
    Apr 2007
    Posts
    669
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: 3 Custom Vendors For Ascent

    ya.....but our server is going to be one of a kinda Server

  4. #4
    hafastr's Avatar Member
    Reputation
    3
    Join Date
    Jul 2007
    Posts
    34
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: 3 Custom Vendors For Ascent

    I apologize if this has been posted already, I hope you don't assume that I pilfered this from you.

    For all I know its an original idea, I spent 6 hours getting this right.

  5. #5
    hafastr's Avatar Member
    Reputation
    3
    Join Date
    Jul 2007
    Posts
    34
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: 3 Custom Vendors For Ascent

    Use them if you wish, i didn't see your post about twink gear I'm sorry.

    I didnt see anyone else post their SQL's for you so this could help you save alot of time.

  6. #6
    attackruby's Avatar Banned
    Reputation
    20
    Join Date
    Sep 2007
    Posts
    158
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: 3 Custom Vendors For Ascent

    How do i add these?

  7. #7
    hafastr's Avatar Member
    Reputation
    3
    Join Date
    Jul 2007
    Posts
    34
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: 3 Custom Vendors For Ascent

    Copy and paste them into a notepad.....
    save it with a .sql at the end (makes it easier IMO)

    IE Vendorgear.sql

    fire up navicat/sqlyog whatever you use use the "Execute Batch File" find the file and execute it, the vendors will be added to your DB, don't forget to add the gear or else you will get 12 ? pieces of gear in the vendor.

    Then in game type .npc spawn 60000 then 60001 then 60002 and all three vendors will pop up (make sure you space em out so they look right)

    WATCH OUT they be ornery kids though. LOL

  8. #8
    morica's Avatar Member
    Reputation
    16
    Join Date
    Mar 2007
    Posts
    63
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: 3 Custom Vendors For Ascent

    oh ok well illidan made my vendors and i got pissed because i was gonna make them and then i see this post above mine when you search for twink vendor

Similar Threads

  1. How to make custom items / vendors for your private server (edited name)
    By renitharis in forum WoW EMU Guides & Tutorials
    Replies: 67
    Last Post: 06-16-2016, 05:08 AM
  2. [Guide] Making a Working Premade Enchant vendor for Ascent
    By Jackie Moon in forum WoW EMU Guides & Tutorials
    Replies: 60
    Last Post: 05-05-2009, 11:36 AM
  3. Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
    By [Shon3m] in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 12-10-2007, 05:04 PM
  4. Looking for T5-T7 vendors / cool custom items for MaNgOs server 2.1.3 (Help posts?)
    By phc_chaos in forum World of Warcraft Emulator Servers
    Replies: 4
    Last Post: 09-28-2007, 08:57 PM
  5. [Ascent] Custom Vendors
    By KantTouchThis in forum World of Warcraft Emulator Servers
    Replies: 7
    Last Post: 09-04-2007, 03:22 PM
All times are GMT -5. The time now is 09:30 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search