[DiscordArchive] Why is the SQL output different, there are a few data missing?
[DiscordArchive] Why is the SQL output different, there are a few data missing?
Original source
Why is the SQL output different, there are a few data missing?
![[Image: 1707649979404.png?ex=690c831d&is=690b319...15a96ce57&]](https://cdn.discordapp.com/attachments/974733680192913478/1206196591128485918/1707649979404.png?ex=690c831d&is=690b319d&hm=5c76e374b751958bf3b83132d67240d9b9f757c76788dab837f86ca15a96ce57&)
![[Image: 1707650013540.jpg?ex=690c831d&is=690b319...01558878a&]](https://cdn.discordapp.com/attachments/974733680192913478/1206196591426404393/1707650013540.jpg?ex=690c831d&is=690b319d&hm=4ffd282cbd1b785a86de9b2e72b873cf748d3ad68b00fc71be18a7701558878a&)
rektbyfaith
02-11-2024, 11:14 AM #1Archived author: magicwang • Posted: 2024-02-11T11:14:37.519000+00:00
Original source
Why is the SQL output different, there are a few data missing?
Original source
WowPacketParser？
rektbyfaith
02-11-2024, 11:15 AM #2Archived author: magicwang • Posted: 2024-02-11T11:15:35.407000+00:00
Original source
WowPacketParser？
Original source
Set TargetedDatabase in wpp config. Also not all fields have to be filled, as they have default values. E.g. ScriptName or AIName
rektbyfaith
02-11-2024, 11:22 AM #3Archived author: ModoX • Posted: 2024-02-11T11:22:38.556000+00:00
Original source
Set TargetedDatabase in wpp config. Also not all fields have to be filled, as they have default values. E.g. ScriptName or AIName
Original source
npcflag and unit flags in the creature table are null by default
rektbyfaith
02-11-2024, 11:23 AM #4Archived author: Northstrider • Posted: 2024-02-11T11:23:08.104000+00:00
Original source
npcflag and unit flags in the creature table are null by default
Original source
these four flag fields exist only for manual changes
rektbyfaith
02-11-2024, 11:23 AM #5Archived author: Northstrider • Posted: 2024-02-11T11:23:23.165000+00:00
Original source
these four flag fields exist only for manual changes
Original source
SET @CGUID :=0
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+310;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES
(@CGUID+0, 299, 0, 12, 9, '0', '0', 0, 0, 0, -8832.0048828125, -106.063735961914062, 83.1515350341796875, 2.263534069061279296, 120, 10, 0, 42, 0, 1, NULL, NULL, NULL, NULL, 52237),
![[Image: image.png?ex=690c8800&is=690b3680&hm=46a...da5c96fbf&]](https://cdn.discordapp.com/attachments/974733680192913478/1206201839859671121/image.png?ex=690c8800&is=690b3680&hm=46af4ead6e5d3d4fb54bc73204e936c408eac5f22d31d3508dcac8eda5c96fbf&)
rektbyfaith
02-11-2024, 11:35 AM #6Archived author: magicwang • Posted: 2024-02-11T11:35:28.827000+00:00
Original source
SET @CGUID :=0
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+310;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES
(@CGUID+0, 299, 0, 12, 9, '0', '0', 0, 0, 0, -8832.0048828125, -106.063735961914062, 83.1515350341796875, 2.263534069061279296, 120, 10, 0, 42, 0, 1, NULL, NULL, NULL, NULL, 52237),
Original source
But it doesn't seem to be able to be imported
rektbyfaith
02-11-2024, 11:35 AM #7Archived author: magicwang • Posted: 2024-02-11T11:35:44.376000+00:00
Original source
But it doesn't seem to be able to be imported
1 Guest(s)
1 Guest(s)