Tier 6 vendor

[disnu]

download tier 6 from this forum and make a sql with this:

insert into `creature_names` (`entry`, `creature_name`, `Subname`, `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader`) values('100002','Vending Machine','Tier 6','0','4','0','0','0','0','17072','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('100002','70','120','1000','0','1','4','200 0','500','500','0','0','0','0','0','0','0','0','0' ,'0','0','0','0','360000','0','0','0','0','0','0', '0','1.5','0.306','','0');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31030','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31029','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31028','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31027','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31026','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31006','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31005','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31004','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31003','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31001','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31054','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31053','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31052','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31051','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31050','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31059','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31058','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31057','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31056','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31059','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31070','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31067','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31065','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31064','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31061','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31069','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31068','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31066','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31063','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31060','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30980','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30978','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30976','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30974','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30970','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30979','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30977','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30975','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30972','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30969','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31048','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31044','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30975','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31039','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31034','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31049','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31046','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31043','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31040','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31035','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31047','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31045','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31041','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31037','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31032','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31023','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31020','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31017','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31014','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31008','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31024','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31021','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31018','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31015','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31011','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31022','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31019','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31016','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31012','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','31007','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30996','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30994','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30992','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30988','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30983','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30998','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30995','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30991','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30987','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30985','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30997','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30993','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30990','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30998','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30989','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100002','30982','-1');


To make a sql open notepad than when u go save dont save as txt save as all formats then XXXX.sql

Go to navicat and execute batch file

Go in game and write .npc spawn 100002

and there is ur vendor

UPDATE
if u r hvin the
"[Err] 1062 - Duplicate entry '100002' for key 1
[Err] 1062 - Duplicate entry '100002' for key 1" error
change all the 100002 to 100001

[voskar]

i got [Err] 1582 - Duplicate entry '100002' for key 'entry' :(

[disnu]

o.O
omg.... thats weird... try changin all those 100002 to 100001 and the problem will b solved... the thing is ull hv to take ur time... srry

[unclemo]

Tier 6 vendor
--------------------------------------------------------------------------------
download tier 6 from this forum and make a sql with this:

thanks mate, after replace 100002 with 100001 and Import,
the vendor-T6 work like charm

[disnu]

good to hear it worked :D

[krazyone432]

Yeah... can you do it for me i tryed a bunch didnt work for me =/

[Mystikal]

Really nice...gonna try it now..btw is anyone of u good with making weapons and adding them in navicat?

and btw i get this error:

[Err] 1062 - Duplicate entry '100002' for key 1
[Err] 1062 - Duplicate entry '100002' for key 1

[Katie]

[Err] 1062 - Duplicate entry '30991' for key 1
[Msg] Finished - Unsuccessfully

What should i do to fix this?

[disnu]

[Err] 1062 - Duplicate entry '30991' for key 1
[Msg] Finished - Unsuccessfully

What should i do to fix this?


i hv no idea... never saw that one... but i think u may already hv a t6 shop with that item

[dale]

1. I do not know how to open a batch file!
2. I cannot save a document as .sql!

[Nebels]

[Err] 1265 - Data truncated for column 'attacktime' at row 1
[Msg] Finished - Unsuccessfully

How do i fix that?!?!

[KaiserJoe]

[Err] 1062 - Duplicate entry '100001' for key 1
[Msg] Finished - Unsuccessfully

I switched every single 100002 to 100001 because I had the previous error with the 100002 thing.. now what?

Also here is the .sql for the 100001's

insert into `creature_names` (`entry`, `creature_name`, `Subname`, `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader`) values('100001','Vending Machine','Tier 6','0','4','0','0','0','0','17072','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('100001','70','120','1000','0','1','4','200 0','500','500','0','0','0','0','0','0','0','0','0' ,'0','0','0','0','360000','0','0','0','0','0','0', '0','1.5','0.306','','0');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31030','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31029','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31028','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31027','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31026','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31006','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31005','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31004','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31003','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31001','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31054','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31053','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31052','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31051','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31050','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31059','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31058','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31057','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31056','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31059','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31070','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31067','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31065','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31064','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31061','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31069','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31068','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31066','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31063','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31060','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30980','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30978','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30976','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30974','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30970','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30979','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30977','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30975','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30972','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30969','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31048','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31044','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30975','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31039','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31034','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31049','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31046','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31043','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31040','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31035','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31047','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31045','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31041','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31037','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31032','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31023','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31020','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31017','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31014','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31008','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31024','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31021','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31018','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31015','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31011','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31022','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31019','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31016','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31012','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','31007','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30996','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30994','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30992','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30988','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30983','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30998','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30995','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30991','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30987','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30985','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30997','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30993','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30990','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30998','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30989','-1');
insert into `vendors` (`vendorGuid`, `itemGuid`, `amount`) values('100001','30982','-1');

[Jacksparrow]

heres a faster way and better copy and open console and paste everything in there i wont stop if there is an error

[dale]

How Do I Open A Batch File