[Ascent] Quick question!

[KuroSan]

Where in the DB do i add my vendors? Do i just do it in the DB, or a table in the DB? Thanks!

 

[gmaze]

All depends..sounds like you created your own, so you need to save into creature_proto, creature_names, and creature_spawns. That puts the actual npc into DB.
Also need to add them into vendors table so DB knows they are 1, plus this lists items they sell.

Plus, if you want them to have text or speech, you must add into appropriate npc_ table.

 

[KuroSan]

Wow, all of that? The maker only supplied with this ... How do i get all the other stuff? o.o''

This is just an example.

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, money)
VALUES (88888, 77, 12, 99999999, 99999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0);

INSERT INTO creature_names (entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader)
VALUES (88888,"ydgf","dgdg",0,7,1,0,0,NULL,103,1,1,1,NULL);

INSERT INTO vendors (vendorGuid, itemGuid, amount)
VALUES (88888,90001,w);

 

[gmaze]

well, that will work, but they aren't spawned in the world.
suppose you can do that in game.
don't need the npc stuff, thats to enhance game play.

 

[KuroSan]

Alright so if that can work, i just add them to the Vendor Table? Also if i would like to make it so they spawn on their own.. How would i go about getting the other information?

Thanks by the way!

 

[gmaze]

go into the world and type .gps where you want the vendor to be.Try to face the way you want your vendor facing. Write down the info, then insert coordinates into creature_spawns.

 

[KuroSan]

thanks If this forum had rep, id rep you! ^_^

 

[gmaze]

yw