Hello guys, everytime I make a new server.. With a Blizzlike DB, I need to make a vendor.. You guys also have the same problem? Or even don't know how to make one? Than look here. If you don't know how to import them than follow the guide below.
DON'T FLAME ON ME LIKE THINGS: "Omfg every ****ing freak know how to make one"
Just think, there many people even don't know how to create an Account on there server.. So this is may nicer for them and quicker!
For the beginners guide, scroll down.
MySQL IMPORT QUERY:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
VALUES (777799, 82, 82, 814, 67756, 67756, 5345, 1, 128, 1800, 150, 250, 1800, 500, 650, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0, 0, 0);
INSERT INTO creature_names (entry, `name`, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, female_displayid, unknown_float1, unknown_float2, Civilian, Leader, info_str)
VALUES (777799,"Achmed the Dead Terrorist","Totem Vendor",0,7,0,0,0,NULL,24191,24191,1, 1,1,NULL, '');
INSERT INTO vendors (entry, item, amount)
VALUES (777799,5177,0);
INSERT INTO vendors (entry, item, amount)
VALUES (777799,5176,0);
INSERT INTO vendors (entry, item, amount)
VALUES (777799,5178,0);
INSERT INTO vendors (entry, item, amount)
VALUES (777799,5175,0);
Beginners Guide if you use HeidiSQL:
1.-) Start "HeidiSQL.exe" a window will appear, Hit- "Connect".
2.-) Double click on you World Database (Default = "World")
3.-) Near the top you'll see: "Host", "Database" and "Query" click on "Query"
4.-) Copy the Query above ("MySQL IMPORT QUERY") and paste it there.
5.-) Now you have to find a Blue ">" and click on it at the right top. or just hit "F9".
6.-) If it's done, close HeidiSQL and (Re)start your server.
7.-) Log-in and do this: /s .npc spawn 777799 Now your done!
Beginners Guide if you use Navicat:
1.-) Start "Navicat", Double click on your Database.
2.-) Double click on your World database (Default = "World")
3.-) Below the World DB name you have to find "Queries".
4.-) Right click on "Queries" and hit "New Query".
5.-) Copy the Query at the very top of the thread (MySQL IMPORT QUERY) and paste it in the Box at your Navicat.
6.-) Hit "Run" and wait till it's done.
7.-) Close Navicat and (Re)start Navicat.
8.-) Log-in and do this: /s .npc spawn 777799 Now your done!
Cya.