[RELEASE] Tier 8

[LJN]

This is the tier 8 from knaurs newest DB, He never added the items to vendors or drops. I put together for you thos items.

I have no credit for making them only credit for puting them into a SQL file

--=Filebeam - Free Fast File Hosting--=

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)
VALUES (7538224, 100, 100, 814,  777,  777,  777,  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);
INSERT INTO creature_names (entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, unknown_float1, unknown_float2, Civilian, Leader)
VALUES (7538224,"Tier 8","Forgotten Realms Vendor",0,7,1,0,0,0,21359,1,1,1,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538224,2000200,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538224,2000201,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538224,2000202,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538224,2000203,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538224,2000204,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538224,2000205,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538224,2000206,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538224,2000207,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538224,2000208,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538224,2000209,0);


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)
VALUES (7538223, 100, 100, 814,  777,  777,  777,  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);
INSERT INTO creature_names (entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, unknown_float1, unknown_float2, Civilian, Leader)
VALUES (7538223,"Tier 8","Forgotten Realms Vendor",0,7,1,0,0,0,6198,1,1,1,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538223,2000209,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538223,2000210,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538223,2000211,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538223,2000212,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538223,2000213,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538223,2000214,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538223,2000215,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538223,2000216,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538223,2000217,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538223,2000218,0);

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)
VALUES (7538222, 100, 100, 814,  777,  777,  777,  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);
INSERT INTO creature_names (entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, unknown_float1, unknown_float2, Civilian, Leader)
VALUES (7538222,"Tier 8","Forgotten Realms Vendor",0,7,1,0,0,0,10090,1,1,1,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538222,2000218,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538222,2000219,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538222,2000220,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538222,2000221,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538222,2000222,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538222,2000223,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538222,2000224,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538222,2000225,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538223,2000217,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538223,2000218,0);

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)
VALUES (7538221, 100, 100, 814,  777,  777,  777,  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);
INSERT INTO creature_names (entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, unknown_float1, unknown_float2, Civilian, Leader)
VALUES (7538221,"Tier 8","Forgotten Realms Vendor",0,7,1,0,0,0,25074,1,1,1,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000225,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000226,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000227,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000228,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000229,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000230,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000231,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000232,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000233,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000234,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000235,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000236,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000237,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000238,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000239,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538221,2000240,0);


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)
VALUES (7538220, 100, 100, 814,  777,  777,  777,  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);
INSERT INTO creature_names (entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, unknown_float1, unknown_float2, Civilian, Leader)
VALUES (7538220,"Tier 8","Forgotten Realms Vendor",0,7,1,0,0,0,16091,1,1,1,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000241,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000242,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000243,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000244,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000245,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000246,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000247,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000248,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000249,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000250,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000251,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000252,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000253,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000254,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000255,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538220,2000256,0);


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)
VALUES (7538219, 100, 100, 814,  777,  777,  777,  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);
INSERT INTO creature_names (entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, unknown_float1, unknown_float2, Civilian, Leader)
VALUES (7538219,"Tier 8","Forgotten Realms Vendor",0,7,1,0,0,0,7941,1,1,1,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000257,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000258,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000259,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000260,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000261,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000262,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000263,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000264,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000265,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000266,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000267,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000268,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000269,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000254,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000270,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000271,0);
INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (7538219,2000272,0);

[Tom_2001]

Awsome +rep for contributing

[fonillius]

Wow, dude i really searched this for a lil bit time but still, you rock 1!!!!! i would +Rep if i wouldnt be a leecher (

Love ya, and thank you !!!