Assistant Admin AriDEV Posted June 18, 2011 Assistant Admin Posted June 18, 2011 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 DataExample: -- 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 UnknownDev 1
Recommended Posts