Katie
06-09-2007, 06:14 PM
This is a cut and Paste from HS i take no credit.
This guide is part of:
Astrup's guide
----------------------------------------------------------
How to make costom vendors?
Step 1:
Open notepad and then insert this code in the notepad
INSERT INTO creature_template(entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, ScriptName)VALUES (2000866, 17175, 0, "Epic vendor", "Epic vendor", 255, 255, 100000, 100000, 100, 100, 100000000000, 474, 6, 0.96, 0, 9, 14, 100, 1910, 2101, 0, 0, 1, 0, 0, 0, 0, 0, 0, 16.808, 23.111, 100, 2.31, 7, 1, 138936390, 0, 0, 0, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 126, "combat_reach");
Step 2:
Now save like this: (filename).sql
I have saved it like vendor.sql
Step 3:
Now open and connect to your navicat and then right click on the tabel mangos.
Then you see 'Execute Batch file...' click that then you need to search your sql file that
you have saved.
Step 4:
Then restart your server and then go in-game.
Then go to the place where you want to insert your vendor.
Type .addspw 2000866 and there is your vendor!
Step 5:
Now you can add some items to your vendor type .addvendoritem (item id)
You can get some item id's from thotbott if you are in the site search for your weapon you want to insert to your vendor then open it and look at the url then you see the item id in the url!
Modify your vendor:
If you want to change something or if you want more vendors then read this!
How to add more vendors:
On row 1 you can see (2000866, 17175, 0, "Epic
Change 2000866 to another unique id. (like 2000867)
Then save it and then execute batch the file you have saved and restart your server.
Now login to your server and then type .addspw 2000867 or something else if you have changed to another code then 2000867.
How to change name and subname:
On row 1 you see: (2000866, 17175, 0, "Name here", "Subname here",
Change the first one to the name and the other to the subname!
And save the file and then execute batch the file!
and then type .addspw 2000866
How to delete your vendor:
If you have added to some place you don't like then click on the server,
and then type .del and then the vendor is gone!
This guide is part of:
Astrup's guide
----------------------------------------------------------
How to make costom vendors?
Step 1:
Open notepad and then insert this code in the notepad
INSERT INTO creature_template(entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, ScriptName)VALUES (2000866, 17175, 0, "Epic vendor", "Epic vendor", 255, 255, 100000, 100000, 100, 100, 100000000000, 474, 6, 0.96, 0, 9, 14, 100, 1910, 2101, 0, 0, 1, 0, 0, 0, 0, 0, 0, 16.808, 23.111, 100, 2.31, 7, 1, 138936390, 0, 0, 0, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 126, "combat_reach");
Step 2:
Now save like this: (filename).sql
I have saved it like vendor.sql
Step 3:
Now open and connect to your navicat and then right click on the tabel mangos.
Then you see 'Execute Batch file...' click that then you need to search your sql file that
you have saved.
Step 4:
Then restart your server and then go in-game.
Then go to the place where you want to insert your vendor.
Type .addspw 2000866 and there is your vendor!
Step 5:
Now you can add some items to your vendor type .addvendoritem (item id)
You can get some item id's from thotbott if you are in the site search for your weapon you want to insert to your vendor then open it and look at the url then you see the item id in the url!
Modify your vendor:
If you want to change something or if you want more vendors then read this!
How to add more vendors:
On row 1 you can see (2000866, 17175, 0, "Epic
Change 2000866 to another unique id. (like 2000867)
Then save it and then execute batch the file you have saved and restart your server.
Now login to your server and then type .addspw 2000867 or something else if you have changed to another code then 2000867.
How to change name and subname:
On row 1 you see: (2000866, 17175, 0, "Name here", "Subname here",
Change the first one to the name and the other to the subname!
And save the file and then execute batch the file!
and then type .addspw 2000866
How to delete your vendor:
If you have added to some place you don't like then click on the server,
and then type .del and then the vendor is gone!