Jacksparrow
06-13-2007, 12:55 AM
if you want i cold show you whats in the file...
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 (20000000,2,7,-1,"Azzinoths Revenge","Azzinoths Revenge","Azzinoths Revenge","Azzinoths Revenge",32837,6,0,0000,0000,13,-1,-1,80,70,0,0,0,0,0,0,0,99,1,0,1,9999,4,9999,5,9999, 12,9999,14,9999,19,9999,18,9999,36,9999,28,9999,5, 9999,9999,9999999,0,9999,999999,1,9999,9999999,2,9 999,9999999,3,9999,99999999,4,0,9999,9999,9999,999 9,9999,9999,30000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"This will consume anybody who wields it.",0,0,0,0,0,1,1,0,0,0,0,99999999,0,0,0,0,2,0,8,0,4, 0,2888,0,0,0,0);
INSERT INTO creature_names
(entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader)
VALUES
(4000000, "Illidan Stormweaver", "Azzinoths Revenge", 0, 4, 0, 3, 0, NULL, 17870, 1, 1, 1, 0);
INSERT INTO creature_proto
(entry, level, faction, health, 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)
VALUES
(4000000, 100, 120, 10000, 5000, 5, 4, 1000, 300, 400, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0);
INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("4000000", "18582", -1);
INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("4000000", "18584", -1);
INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("4000000", "18583", -1);
INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("4000000", "32837", -1);
INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("4000000", "32838", -1);
INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("40000000", "32375", -1);
INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("40000000", "20000000", -1);
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.