[DiscordArchive] morning, when sniff and parse by "packet parser " it generates sql files but i dont understand yet h
[DiscordArchive] morning, when sniff and parse by "packet parser " it generates sql files but i dont understand yet h
Original source
morning, when sniff and parse by "packet parser " it generates sql files but i dont understand yet how to use this; for example
SET @CGUID := SET_VALUE_MANUALLY_HERE;
SET @OGUID := SET_VALUE_MANUALLY_HERE;
SET @ATSPAWNID := SET_VALUE_MANUALLY_HERE;
SET @ATPROPERTIESID := SET_VALUE_MANUALLY_HERE;
DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+776;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
(@OGUID+0, 280800, 1865, 9415, 9415, '0', '23605', 0, 2102.62841796875, 3285.803955078125, 57.57932662963867187, 0, 0, 0, 0, 1, 120, 255, 1, 56162), -- 280800 (Area: Fenditura di Telogrus - Difficulty: 0) CreateObject1
(@OGUID+1, 280794, 1865, 9415, 9415, '0', '23605', 0, 1908.1129150390625, 3298.9306640625, 96.37477874755859375, 0, 0, 0, 0, 1, 120, 255, 1, 56162), -- 280794 (Area: Fenditura di Telogrus - Difficulty: 0) CreateObject1
(@OGUID+2, 280945, 1865, 9415, 9415, '0', '23605', 0, 2110.407958984375, 3366.880126953125, 59.72437286376953125, 0, 0, 0, 0, 1, 120, 255, 1, 56162), -- 280945 (Area: Fenditura di Telogrus - Difficulty: 0) CreateObject1
(@OGUID+3, 280944, 1865, 9415, 9415, '0', '23605', 0, 2110.416748046875, 3366.8837890625, 58.48517608642578125, 0, 0, 0, 0, 1, 120, 255, 1, 56162), -- 280944 (Area: Fenditura di Telogrus - Difficulty: 0) CreateObject1
etc etc etc
which initial value should i use for @OGUID ?
rektbyfaith
08-21-2024, 09:10 AM #1Archived author: Ryzen • Posted: 2024-08-21T09:10:39.521000+00:00
Original source
morning, when sniff and parse by "packet parser " it generates sql files but i dont understand yet how to use this; for example
SET @CGUID := SET_VALUE_MANUALLY_HERE;
SET @OGUID := SET_VALUE_MANUALLY_HERE;
SET @ATSPAWNID := SET_VALUE_MANUALLY_HERE;
SET @ATPROPERTIESID := SET_VALUE_MANUALLY_HERE;
DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+776;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
(@OGUID+0, 280800, 1865, 9415, 9415, '0', '23605', 0, 2102.62841796875, 3285.803955078125, 57.57932662963867187, 0, 0, 0, 0, 1, 120, 255, 1, 56162), -- 280800 (Area: Fenditura di Telogrus - Difficulty: 0) CreateObject1
(@OGUID+1, 280794, 1865, 9415, 9415, '0', '23605', 0, 1908.1129150390625, 3298.9306640625, 96.37477874755859375, 0, 0, 0, 0, 1, 120, 255, 1, 56162), -- 280794 (Area: Fenditura di Telogrus - Difficulty: 0) CreateObject1
(@OGUID+2, 280945, 1865, 9415, 9415, '0', '23605', 0, 2110.407958984375, 3366.880126953125, 59.72437286376953125, 0, 0, 0, 0, 1, 120, 255, 1, 56162), -- 280945 (Area: Fenditura di Telogrus - Difficulty: 0) CreateObject1
(@OGUID+3, 280944, 1865, 9415, 9415, '0', '23605', 0, 2110.416748046875, 3366.8837890625, 58.48517608642578125, 0, 0, 0, 0, 1, 120, 255, 1, 56162), -- 280944 (Area: Fenditura di Telogrus - Difficulty: 0) CreateObject1
etc etc etc
which initial value should i use for @OGUID ?
Original source
you should use higher number like 100000000 to not interfere with spawned stuff
rektbyfaith
08-21-2024, 09:22 AM #2Archived author: edea • Posted: 2024-08-21T09:22:31.743000+00:00
Original source
you should use higher number like 100000000 to not interfere with spawned stuff
Original source
all gameobject GUID are sequential, at now in master world database, so someone will change later? just to known how to do good work
EDIT: ah not really in sequential, some groups
rektbyfaith
08-21-2024, 09:34 AM #3Archived author: Ryzen • Posted: 2024-08-21T09:34:44.969000+00:00
Original source
all gameobject GUID are sequential, at now in master world database, so someone will change later? just to known how to do good work
EDIT: ah not really in sequential, some groups
Original source
the merger will change it to fit it with existing spawns
rektbyfaith
08-21-2024, 09:41 AM #4Archived author: edea • Posted: 2024-08-21T09:41:57.738000+00:00
Original source
the merger will change it to fit it with existing spawns
Original source
great!
rektbyfaith
08-21-2024, 09:43 AM #5Archived author: Ryzen • Posted: 2024-08-21T09:43:23.569000+00:00
Original source
great!
1 Guest(s)
1 Guest(s)