[Release] PaikProductions Wrath of the Lich King Vendors

[PaikProductions]

Hello guys ,

I made some vendors, soon coming more!
These are very usefull for a mall.
If you want some screenshots just ask me and i gonna work on it!
The tier 7 is the REAL blizzard tier!
All classes are added at vendors.
The download file includes Readme!!!

Vendors at the moment:

900005 - Tier 7
900006 - Tier 7
900007 - Weapons 200+ [Frostmourne include]
900008 - Trinkets
900009 - Rings
900010 - Necklace
900011 - Shield
900012 - Tabard
900013 - Season 5
900014 - Relics
900015 - Cloak
900016 - Container
900017 - Glyph I
900018 - Glyph II
900019 - Wrist
900020 - Book A-Z
900021 - Leather A-Z
900022 - Jewelcrafting A-Z
900023 - Engineering/Enchanting A-Z
900024 - Alchemy/Blacksmithing/Tailoring
900025 - Waist
900026 - Feet
900027 - Heirloom
900028 - Ground Mounts
900029 - Flying Mounts
900030 - Item Enhancement (Permanent)
900031 - Item Enhancement (Temporary)
900032 - Reagent [ Enchanting ]
900033 - Reagent [ Leatherworking ]
900034 - Reagent [ Blacksmithing ]
900035 - Reagent [ Inscription ]
900036 - Reagent [ Engineering ]
900037 - Reagent [ Alchemy ]
900038 - Reagent [ Tailoring ]
900039 - General Goods
900040 - Shirt
900041 - Quiver, AmmoPouch, Projectile
900042 - Offhand
900043 - Currency
900044 - Gemstone I
900045 - Gemstone II
900046 - Gemstone III
900047 - Armor Tokens
900048 - Keys

Filebeam:
Download Vendors <-- Updated: Keys - ArcEmu

INSERT INTO "creature_names" ("entry", "name", "subname", "info_str", "Flags1", "type", "family", "rank", "unk4", "spelldataid", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "civilian", "leader") VALUES
	('900005','Tier 7',' PaikProductions 1','','4096','7','0','0','0','0',28000,0,0,0,'1','1',NULL,NULL);
INSERT INTO "creature_names" ("entry", "name", "subname", "info_str", "Flags1", "type", "family", "rank", "unk4", "spelldataid", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "civilian", "leader") VALUES
	('900006','Tier 7',' PaikProductions 2','','4096','7','0','1','0','0',28000,0,0,0,'1','1',NULL,NULL);
INSERT INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "mountdisplayid", "equipmodel1", "equipinfo1", "equipslot1", "equipmodel2", "equipinfo2", "equipslot2", "equipmodel3", "equipinfo3", "equipslot3", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities") VALUES
	('900005','80','80','1741','200000000','200000000','50000000','1','130','2000',0,'450','1000','68','426','0','0','0','0','0','0','0','0','0','0','0','0','20000','0','0','0','0','0','0','1.5','0.347','0','0',5000,'0','0','4','8','14',0,0,0,0,0,0,'0');
INSERT INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "mountdisplayid", "equipmodel1", "equipinfo1", "equipslot1", "equipmodel2", "equipinfo2", "equipslot2", "equipmodel3", "equipinfo3", "equipslot3", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities") VALUES
	('900006','80','80','1741','200000000','200000000','50000000','1','130','2000',0,'450','1000','68','426','0','0','0','0','0','0','0','0','0','0','0','0','20000','0','0','0','0','0','0','1.5','0.347','','0',5000,'0','0','4','8','14',0,0,0,0,0,0,'0');
INSERT INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate") VALUES
	('900005',11365,309,'11535.4','1620.98','61.5083','1.30558',0,'633',28,9,16908544,0,0,0,0,0,0,0,0);
INSERT INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate") VALUES
	('900006',11365,309,'11535.4','1620.98','62.5083','1.30558',0,'633',28,9,16908544,0,0,0,0,0,0,0,0);

Put these in your DB!
For additing of other Vendors, please change ID to vendor ID

Soon:


Finished:

Recipe A-Z (100%)
Reagent A-Z (100%)
Item Enhancements (100%)
Season 5 (100%)
Weapon 200+ (100%)
Trinket (100%)
Tier 7 (100%)
Rings (100%)
Shield (100%)
Necklace (100%)
Tabard (100%)
General Goods (100%)
Relics (100%)
Keys (100%)
Cloak (100%)
Currency (100%)
Container (100%)
Wrist (100%)
Feet (100%)
Gemstone I (100%)
Gemstone II (100%)
Gemstone III (100%) Waist (100%)
Heirloom (100%)
Glyph (100%)
Armor Tokens (100%)
Offhand (100%)
Shirt (100%)
Mount (100%)
Flying Mount (100%)
Quiver, AmmoPouch, Projectile (100%)


If you don't got frostmourne then put this in your DB:

INSERT INTO items  VALUES
	('46609',2,8,-1,'Frostmourne','Frostmourne','Frostmourne','Frostmourne','46609',6,0,0,0,17,-1,-1,189,80,0,0,0,0,0,0,0,2,1,0,4,100,7,200,5,150,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0','597','896',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,4000,0,'0',7600,1,0,0,0,0,34696,2,0,0,0,0,35844,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'You will become the new lich king!',0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,0,2,0,1585,0,0,0,'0');

Gemstone II UPDATED! Reason, item got wrong vendor ID!

INSERT INTO vendors VALUES	('900045','41335',0,0,'0',0);

Instance Vendors:

Finished:

Instance Vendor - The Nexus (100%) ***NEW***


__________________________________________________

Download Instance Vendors <-- Updated: Instance Vendors - The Nexus

__________________________________________________

Instance Vendors At the Moment:

900049 - Instance Vendor - The Nexus

Please leave a comment

Credits:

-PaikProductions
-faddix for making them ArcEmu

[volitle]

what are these vendors for both or just arcemu?

[PaikProductions]

ArcEmu for arcemu and other 2 are based on this repack: ArcEmu Repacks - AC Web

[FinnZor]

This is great , have not tried it doe but will do it anyway +rep x1

[PaikProductions]

This is great , have not tried it doe but will do it anyway +rep x1

Thanks

UPDATED: Glyph vendor added!

[y2kss66]

cannot wait for the rest good work! +Rep

[PaikProductions]

cannot wait for the rest good work! +Rep

Thanks

UPDATED: Wrist vendor now added

[Appled]

Great! +Rep
EDIT: Does this work on revision 1798?

[PaikProductions]

Great! +Rep
EDIT: Does this work on revision 1798?

Yes, its also tested with ArcEmu_rev1850

[PaikProductions]

UPDATED: Recipe

[Proxes]

can i get some help i get this when i try yo add using navicat [Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO creature_proto VALUES ('900005','80','80','1741','200000000','200000000','50000000','1','130','2000',0 ,'450','1000','68','0','426','0','0','20000','0','0','0','0','0','0','1.5','0.34 7','0','0',5000,'0','0','4','8','14','0','0','0','0','0','0','0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Flake0207]

Hello guys ,

I made some vendors, soon coming more!
These are very usefull for a mall.
If you want some screenshots just ask me and i gonna work on it!
The tier 7 is the REAL blizzard tier!
All classes are added at vendors.
The download file includes Readme!!!

Vendors at the moment:

900005 - Tier 7
900006 - Tier 7
900007 - Weapons 200+ [Frostmourne include]
900008 - Trinkets
900009 - Rings
900010 - Necklace
900011 - Shield
900012 - Tabard
900013 - Season 5
900014 - Relics
900015 - Cloak
900016 - Container
900017 - Glyph I
900018 - Glyph II
900019 - Wrist
900020 - Book A-Z
900021 - Leather A-Z
900022 - Jewelcrafting A-Z
900023 - Engineering/Enchanting A-Z
900024 - Alchemy/Blacksmithing/Tailoring

Rapidshare:
Download Vendors <-- Updated: Recipe

Mediafire:
Download Vendors <-- Updated: Recipe

ArcEmu:
Download Vendors <-- Updated: Glyph

INSERT INTO "creature_names" ("entry", "name", "subname", "info_str", "Flags1", "type", "family", "rank", "unk4", "spelldataid", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "civilian", "leader") VALUES
	('900005','Tier 7',' PaikProductions 1','','4096','7','0','0','0','0',28000,0,0,0,'1','1',NULL,NULL);
INSERT INTO "creature_names" ("entry", "name", "subname", "info_str", "Flags1", "type", "family", "rank", "unk4", "spelldataid", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "civilian", "leader") VALUES
	('900006','Tier 7',' PaikProductions 2','','4096','7','0','1','0','0',28000,0,0,0,'1','1',NULL,NULL);
INSERT INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "mountdisplayid", "equipmodel1", "equipinfo1", "equipslot1", "equipmodel2", "equipinfo2", "equipslot2", "equipmodel3", "equipinfo3", "equipslot3", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities") VALUES
	('900005','80','80','1741','200000000','200000000','50000000','1','130','2000',0,'450','1000','68','426','0','0','0','0','0','0','0','0','0','0','0','0','20000','0','0','0','0','0','0','1.5','0.347','0','0',5000,'0','0','4','8','14',0,0,0,0,0,0,'0');
INSERT INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "mountdisplayid", "equipmodel1", "equipinfo1", "equipslot1", "equipmodel2", "equipinfo2", "equipslot2", "equipmodel3", "equipinfo3", "equipslot3", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities") VALUES
	('900006','80','80','1741','200000000','200000000','50000000','1','130','2000',0,'450','1000','68','426','0','0','0','0','0','0','0','0','0','0','0','0','20000','0','0','0','0','0','0','1.5','0.347','','0',5000,'0','0','4','8','14',0,0,0,0,0,0,'0');
INSERT INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate") VALUES
	('900005',11365,309,'11535.4','1620.98','61.5083','1.30558',0,'633',28,9,16908544,0,0,0,0,0,0,0,0);
INSERT INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate") VALUES
	('900006',11365,309,'11535.4','1620.98','62.5083','1.30558',0,'633',28,9,16908544,0,0,0,0,0,0,0,0);

Put these in your DB!
For additing of other Vendors, please change ID to vendor ID

Soon:

Recipe A-Z (100%)
Reagent A-Z (0%)
Season 5 (100%)
Weapon 200+ (100%)
Trinket (100%)
Tier 7 (100%)
Rings (100%)
Shield (100%)
Necklace (100%)
Tabard (100%)
Relics (100%)
Cloak (100%)
Container (100%)
Wrist (100%)
Gemstone I (0%)
Gemstone II (0%)
Glyph (100%)
Shirt (2%)
Mount (21%)
Pre made Enchants! (74%)

If you don't got frostmourne then put this in your DB:

INSERT INTO "items" ("entry", "class", "subclass", "field4", "name1", "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", "ScaledStatsDistributionId", "ScaledStatsDistributionFlags", "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", "ReqDisenchantSkill", "unk2", "ItemLimitCategoryId") VALUES
	('46609',2,8,-1,'Frostmourne','Frostmourne','Frostmourne','Frostmourne','46609',6,0,0,0,17,-1,-1,189,80,0,0,0,0,0,0,0,2,1,0,4,100,7,200,5,150,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0','597','896',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,4000,0,'0',7600,1,0,0,0,0,34696,2,0,0,0,0,35844,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'You will become the new lich king!',0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,0,2,0,1585,0,0,0,'0');

Credits:

-PaikProductions
-faddix for making them ArcEmu
-Ontox for the season 5

PATHETIC LEECHER!
there from theos repack:yuck:
get out of here rofl

[jse,pm2]

why is that all the vendor packs lack waist vendors?

[heaven23]

these are great It is some items that doesn't work but overall great!!

[Flake0207]

fail>.> GTFO!