SHOW:
|
|
- or go back to the newest paste.
| 1 | /********************* | |
| 2 | Push Them Out | |
| 3 | *********************/ | |
| 4 | ||
| 5 | /********* | |
| 6 | Assign | |
| 7 | *********/ | |
| 8 | ||
| 9 | - | UPDATE `creature_questrelation` SET `id`=37686, `quest`=24676 WHERE `id`=3768 AND `quest`=2467 LIMIT 1; |
| 9 | + | UPDATE `creature_questrelation` SET `id`=37686, `quest`=24676 WHERE LIMIT 1; |
| 10 | ||
| 11 | /********** | |
| 12 | Script | |
| 13 | **********/ | |
| 14 | ||
| 15 | DELETE FROM `creature` WHERE `guid`=1000041 LIMIT 1; | |
| 16 | INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, | |
| 17 | `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, | |
| 18 | `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, | |
| 19 | `unit_flags`, `dynamicflags`) VALUES | |
| 20 | (1000041, 37686, 654, 1, 1, 30714, 0, -1118.205322, 1138.254761, 25.299967, 5.056787, 120, 0, 0, | |
| 21 | 198, 0, 1 , 0, 0, 0); |
