Thread: 3.3.5 vendors with all new items Arcemu/Mangos

This is not made by me or mmotop.org team !!!

Credits: frathir

The Sql includes:

Code:

800000 - Jewelry 
800001 - Cloth & Leather Armor
800002 - Plate & Mail Armor
800003 - Cloaks
800004 - Misc & Quest items

Download:
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ] (open the Text file and copy everything into heidiSQL or Navicat query).
How to:
1. download
2. open with heidi sql / navicat
3. execute
4. enjoy!

EDIT: Thanks to shadowl00t, a error with arcemu was revealed
If you are runing on arcemu and it says "[Err] 1054 - Unknown column 'unk4' in 'field list'" when you are trying to execute it, try executing the SQL below instead, thanks.

Code:

Insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`,  `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`) 
values ('800001', "Cloth & Leather Armor Vendor", "", '', '0', '7', '0', '1','31962', '0', '0', '0', '1', '1', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `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 ('800001', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');


insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`,  `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`) 
values ('800000', "Jewelry Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1',  '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `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 ('800000', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');


insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`,  `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`) 
values ('800004', "Misc & Quest items Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `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 ('800004', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');


insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`,  `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`) 
values ('800002', "Plate & Mail Armor Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `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 ('800002', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');


insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`,  `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`) 
values ('800003', "Cloaks Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `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 ('800003', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES 
('800004','54653','0'), 
('800004','54651','0'), 
('800004','53510','0'), 
('800004','52563','0'), 
('800004','52706','0'), 
('800004','54215','0'), 
('800004','52276','0'), 
('800004','53637','0'), 
('800004','52541','0'), 
('800004','52566','0'), 
('800004','52731','0'), 
('800004','52709','0'), 
('800004','52565','0'), 
('800004','52562','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES 
('800003','53115','0'), 
('800003','54556','0'), 
('800003','53489','0'), 
('800003','54583','0'), 
('800003','54617','0'), 
('800003','53097','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES 
('800002','53129','0'), 
('800002','54579','0'), 
('800002','53121','0'), 
('800002','54565','0'), 
('800002','53111','0'), 
('800002','54564','0'), 
('800002','53487','0'), 
('800002','54586','0'), 
('800002','53112','0'), 
('800002','54559','0'), 
('800002','53125','0'), 
('800002','54578','0'), 
('800002','53113','0'), 
('800002','54566','0'), 
('800002','53488','0'), 
('800002','54587','0'), 
('800002','53127','0'), 
('800002','54577','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES 
('800001','53118','0'), 
('800001','54562','0'), 
('800001','53117','0'), 
('800001','54560','0'), 
('800001','53114','0'), 
('800001','54561','0'), 
('800001','53134','0'), 
('800001','54584','0'), 
('800001','53126','0'), 
('800001','54580','0'), 
('800001','53486','0'), 
('800001','54582','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES 
('800000','53103','0'), 
('800000','54557','0'), 
('800000','53132','0'), 
('800000','54581','0'), 
('800000','53116','0'), 
('800000','54563','0'), 
('800000','53110','0'), 
('800000','54567','0'), 
('800000','53490','0'), 
('800000','54585','0'), 
('800000','53133','0'), 
('800000','54576','0'), 
('800000','54572','0'), 
('800000','54588','0'), 
('800000','54573','0'), 
('800000','54589','0'), 
('800000','54571','0'), 
('800000','54591','0'), 
('800000','54569','0'), 
('800000','54590','0');

what is the problem for arcemu? hasn't any "unk4" field :S please help

I try to add one of the venors and can`t ... when I lookup for ID for Cloth & Leather Armor I see 800001 ... and can`t add it

did you receive an error on execution?

Nice Share! :)
Thanks.

Thanks for the share (:

Eh sorry im a n00b but how to install? i go into my database using navicat then where should i put it? :P help asap