[DiscordArchive] Did you add the weapon to them?
[DiscordArchive] Did you add the weapon to them?
Original source
Did you add the weapon to them?
rektbyfaith
02-09-2025, 01:19 PM #1Archived author: Ryan Turner • Posted: 2025-02-09T13:19:45.105000+00:00
Original source
Did you add the weapon to them?
Original source
![[Image: Image_1739107293629.png?ex=690bf869&is=6...faa98e2e2&]](https://cdn.discordapp.com/attachments/689803159086170250/1338138037195903036/Image_1739107293629.png?ex=690bf869&is=690aa6e9&hm=d5bcfd1e24d4d5e04ba8cf9d145f284f661371fa7d01a582ce7bdb3faa98e2e2&)
![[Image: Image_1739107299065.png?ex=690bf869&is=6...78b5ba19e&]](https://cdn.discordapp.com/attachments/689803159086170250/1338138037909061632/Image_1739107299065.png?ex=690bf869&is=690aa6e9&hm=2435430e935a88e6cb35057ca9028d96bc8cd4d959a07571aa7a6b178b5ba19e&)
![[Image: Image_1739107303747.png?ex=690bf869&is=6...cd177b9ff&]](https://cdn.discordapp.com/attachments/689803159086170250/1338138038366113857/Image_1739107303747.png?ex=690bf869&is=690aa6e9&hm=fc79109d98a70356092ac9e155995a95117bf13550cac5b5f3be7adcd177b9ff&)
![[Image: Image_1739107287813.png?ex=690bf869&is=6...0db30f8a3&]](https://cdn.discordapp.com/attachments/689803159086170250/1338138038923952193/Image_1739107287813.png?ex=690bf869&is=690aa6e9&hm=d7adb8d81d6caa9997a950971aa71063af8846ee24e65d4d6a1ea460db30f8a3&)
rektbyfaith
02-09-2025, 01:22 PM #2Archived author: 老爷爷 • Posted: 2025-02-09T13:22:49.938000+00:00
Original source
Original source
`-- add creature
SET @CGUID := 452;
DELETE FROM `creature` WHERE `id1` = 26280 AND `guid` = @CGUID;
INSERT INTO `creature` (`guid`, `id1`, `id2`, `id3`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`, `CreateObject`, `Comment`) VALUES
(@CGUID, 26280, 0, 0, 571, 65, 4157, 1, 1, 0, 3373.642822265625, 2584.31494140625, 42.15882492065429687, 1.623156189918518066, 120, 0, 0, 9291, 3231, 0, 0, 0, 0, '', 58629, 0, NULL);
DELETE FROM `creature_addon` WHERE (`guid` IN (@CGUID));
INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(@CGUID, 0, 0, 0, 1, 0, 0, '');`
rektbyfaith
02-09-2025, 01:25 PM #3Archived author: 老爷爷 • Posted: 2025-02-09T13:25:55.234000+00:00
Original source
`-- add creature
SET @CGUID := 452;
DELETE FROM `creature` WHERE `id1` = 26280 AND `guid` = @CGUID;
INSERT INTO `creature` (`guid`, `id1`, `id2`, `id3`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`, `CreateObject`, `Comment`) VALUES
(@CGUID, 26280, 0, 0, 571, 65, 4157, 1, 1, 0, 3373.642822265625, 2584.31494140625, 42.15882492065429687, 1.623156189918518066, 120, 0, 0, 9291, 3231, 0, 0, 0, 0, '', 58629, 0, NULL);
DELETE FROM `creature_addon` WHERE (`guid` IN (@CGUID));
INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(@CGUID, 0, 0, 0, 1, 0, 0, '');`
Original source
WTS code blocks, $0
rektbyfaith
02-09-2025, 01:28 PM #4Archived author: Revision • Posted: 2025-02-09T13:28:13.108000+00:00
Original source
WTS code blocks, $0
Original source
You also don't have equipment_id set to 1
rektbyfaith
02-09-2025, 01:28 PM #5Archived author: Revision • Posted: 2025-02-09T13:28:23.185000+00:00
Original source
You also don't have equipment_id set to 1
Original source
in the creatures table
rektbyfaith
02-09-2025, 01:28 PM #6Archived author: Revision • Posted: 2025-02-09T13:28:28.197000+00:00
Original source
in the creatures table
Original source
Grandpa when you share codeblock please use gist or pastebin otherwise makes it hard to see but as revision said you have no id set for the equipment (in the creature)
rektbyfaith
02-09-2025, 01:29 PM #7Archived author: Ryan Turner • Posted: 2025-02-09T13:29:53.932000+00:00
Original source
Grandpa when you share codeblock please use gist or pastebin otherwise makes it hard to see but as revision said you have no id set for the equipment (in the creature)
Original source
Thank you
rektbyfaith
02-09-2025, 01:34 PM #8Archived author: 老爷爷 • Posted: 2025-02-09T13:34:57.555000+00:00
Original source
Thank you
Original source
Or as revision suggested use code block in discord when pasting more than one line
rektbyfaith
02-09-2025, 02:32 PM #9Archived author: sudlud • Posted: 2025-02-09T14:32:36.871000+00:00
Original source
Or as revision suggested use code block in discord when pasting more than one line