Skip to content

Instantly share code, notes, and snippets.

@FALL1N1
Created October 25, 2012 14:28
Show Gist options
  • Select an option

  • Save FALL1N1/3952851 to your computer and use it in GitHub Desktop.

Select an option

Save FALL1N1/3952851 to your computer and use it in GitHub Desktop.
Missing Quartermaster @ The Argent Crusade
SET @GUID :=124442;
DELETE FROM `creature` WHERE `guid` = @GUID;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@GUID, 30431, 571, 1, 1, 27020, 0, 6266.74, -44.569, 421.498, 3.83972, 300, 0, 0, 23310, 11982, 0, 0, 0, 0);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment