Jump to content

Recommended Posts

  • Assistant Admin
Posted

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 :)

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.