Okay! Here you got it... a very fast way for noobs AND skilled peoples to create a shopping mall that other1 can use and extract to their db.
How to use:
Its very simple, just put this in a .sql file
Code:
/* Gameobject_spawns */
/* Gameobject_spawns */
INSERT INTO creature_spawns VALUES(SPAWNID HERE,NPCID HERE,MAPID HERE,X-COORDS HERE,Y-COORDS HERE,Z-COORDS HERE,"orientation here","movetype" here,displayid here,"faction" here,"flags" here,"bytes" here,"bytes2" here,"emote_state" here,"npc_respawn_link" here);
SPAWNID: this is the id of the spawn, not so importan just put a high number here (9000812233) or whatever you choose, just watch is not used before.
NPCID: the entryid of your npc.
COORDS/MAPID: You can find this by typing .gps in game on the place you want the npc to be.
The rest I dont know how to explain, but you can find it by type .npc info at the npc you want the info about.
and if you want to have more then just one vendor just copy when paste under.
And now you have created a mall. The vendors you have to create yourself.