[DiscordArchive] Did you Set a Guid on top of your SQL?
[DiscordArchive] Did you Set a Guid on top of your SQL?
Original source
Did you Set a Guid on top of your SQL?
rektbyfaith
11-06-2021, 08:32 AM #1Archived author: Naddley • Posted: 2021-11-06T08:32:25.423000+00:00
Original source
Did you Set a Guid on top of your SQL?
Original source
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
(@CGUID+0, 175525, 2222, 10565, 10565, '0', '16363 - 16927 - 16100 - 16389 - 16669 - 16117 - 16118 - 14179 - 14180 - 16397 - 16120 - 14181 - 16121 - 14182 - 16122 - 16418 - 17549 - 17550 - 17551 - 17552 - 17553 - 17028 - 17029 - 16765 - 15380 - 16766 - 16489 - 16767 - 16768 - 17338 - 17339 - 16508 - 16787 - 16789 - 16790 - 15961 - 16524 - 17079 - 16802 - 17081 - 16811 - 16812 - 16813 - 16814 - 15986 - 16860 - 16873 - 16877 - 15494', 0, 0, 0, -1856.576416015625, 1533.65283203125, 5274.5048828125, 2.29030156135559082, 7200, 0, 0, 12735, 5751, 0, 0, 0, 0, 40906), -- 175525 (Area: 10565 - Difficulty: 0) (Auras: 339689 - 339689)
rektbyfaith
11-06-2021, 08:32 AM #2Archived author: [̲̲̲̅̅̅̅ • Posted: 2021-11-06T08:32:35.860000+00:00
Original source
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
(@CGUID+0, 175525, 2222, 10565, 10565, '0', '16363 - 16927 - 16100 - 16389 - 16669 - 16117 - 16118 - 14179 - 14180 - 16397 - 16120 - 14181 - 16121 - 14182 - 16122 - 16418 - 17549 - 17550 - 17551 - 17552 - 17553 - 17028 - 17029 - 16765 - 15380 - 16766 - 16489 - 16767 - 16768 - 17338 - 17339 - 16508 - 16787 - 16789 - 16790 - 15961 - 16524 - 17079 - 16802 - 17081 - 16811 - 16812 - 16813 - 16814 - 15986 - 16860 - 16873 - 16877 - 15494', 0, 0, 0, -1856.576416015625, 1533.65283203125, 5274.5048828125, 2.29030156135559082, 7200, 0, 0, 12735, 5751, 0, 0, 0, 0, 40906), -- 175525 (Area: 10565 - Difficulty: 0) (Auras: 339689 - 339689)
Original source
You need to tell the SQL which Guid it have to insert like SET @CGUID := 100;
rektbyfaith
11-06-2021, 08:33 AM #3Archived author: Naddley • Posted: 2021-11-06T08:33:22.718000+00:00
Original source
You need to tell the SQL which Guid it have to insert like SET @CGUID := 100;
Original source
So it will set the Guid to 100, and will replace CGUID+01 with Guid 101 and so on
rektbyfaith
11-06-2021, 08:34 AM #4Archived author: Naddley • Posted: 2021-11-06T08:34:36.034000+00:00
Original source
So it will set the Guid to 100, and will replace CGUID+01 with Guid 101 and so on
1 Guest(s)
1 Guest(s)