Small Patch Post Explain: How To Post Creature Or Gameobject Spawns: Example:
-- NAME <SUBNAME>
SET @NAMEGUID=XXX;
DELETE FROM creature WHERE id=49748;
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType, npcflag, unit_flags, dynamicflags) VALUES
(@NAMEGUID, 49748, 0, 1, 1, 0, 4981, -8847.35, 569.835, 94.6879, 2.86978, 300, 0, 0, 713, 0, 0, 0, 0, 0, 0),
(@NAMEGUID+1, 49748, 0, 1, 1, 36597, 49748, -4938.35, -917.995, 501.743, 5.3058, 300, 0, 0, 232470, 0, 0, 0, 0, 0, 0),
(@NAMEGUID+2, 49748, 0, 1, 1, 0, 49748, -8826.54, 631.48, 94.4498, 4.05418, 300, 0, 0, 3, 0, 0, 0, 0, 0, 0);How To Post Npc Vendor Data Example:
-- NAME <SUBNAME>
SET @NAMEVENDOR=xxx;
DELETE FROM npc_vendor WHERE entry=@NAMEVENDOR;
INSERT INTO npc_vendor VALUES
(@NAMEVENDOR, 0, 2325, 0, 0, 0),
(@NAMEVENDOR, 0, 6260, 0, 0, 0),
(@NAMEVENDOR, 0, 2320, 0, 0, 0);The XXX Is Always ID From SkyFire DB TEAM, Also U Can Add There XXX
More Will Comming