[DiscordArchive] Can you show me the SQL?
[DiscordArchive] Can you show me the SQL?
Original source
-.-
rektbyfaith
12-24-2022, 11:41 AM #11Archived author: DioHun • Posted: 2022-12-24T11:41:48.004000+00:00
Original source
-.-
Original source
I mean just grab it from sniff
rektbyfaith
12-24-2022, 11:41 AM #12Archived author: MaxtorCoder • Posted: 2022-12-24T11:41:48.392000+00:00
Original source
I mean just grab it from sniff
Original source
2570 I believe, but not 100%
rektbyfaith
12-24-2022, 11:42 AM #13Archived author: ogarvey • Posted: 2022-12-24T11:42:04.329000+00:00
Original source
2570 I believe, but not 100%
Original source
this is sniff coords
rektbyfaith
12-24-2022, 11:42 AM #14Archived author: DioHun • Posted: 2022-12-24T11:42:04.778000+00:00
Original source
this is sniff coords
Original source
just the mapid not
rektbyfaith
12-24-2022, 11:42 AM #15Archived author: DioHun • Posted: 2022-12-24T11:42:18.551000+00:00
Original source
just the mapid not
Original source
MapID is 2570
rektbyfaith
12-24-2022, 11:43 AM #16Archived author: MaxtorCoder • Posted: 2022-12-24T11:43:45.957000+00:00
Original source
MapID is 2570
Original source
yeah 2570
rektbyfaith
12-24-2022, 11:43 AM #17Archived author: DioHun • Posted: 2022-12-24T11:43:48.838000+00:00
Original source
yeah 2570
Original source
idk why i write 2150 -.-
rektbyfaith
12-24-2022, 11:43 AM #18Archived author: DioHun • Posted: 2022-12-24T11:43:56.542000+00:00
Original source
idk why i write 2150 -.-
Original source
```sql
DELETE FROM `playercreateinfo` WHERE (`race`=70 AND `class`=13) OR (`race`=52 AND `class`=13);
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`, `intro_scene_id`, `VerifiedBuild`) VALUES
(70, 13, 2570, 0, 5827.53, -2982.55, 251.047, 3.9500465, 3730, 46619),
(52, 13, 2570, 0, 5827.53, -2982.55, 251.047, 3.9500465, 3730, 46619);
```
rektbyfaith
12-24-2022, 11:43 AM #19Archived author: MaxtorCoder • Posted: 2022-12-24T11:43:56.665000+00:00
Original source
```sql
DELETE FROM `playercreateinfo` WHERE (`race`=70 AND `class`=13) OR (`race`=52 AND `class`=13);
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`, `intro_scene_id`, `VerifiedBuild`) VALUES
(70, 13, 2570, 0, 5827.53, -2982.55, 251.047, 3.9500465, 3730, 46619),
(52, 13, 2570, 0, 5827.53, -2982.55, 251.047, 3.9500465, 3730, 46619);
```
Original source
Out of interest how is the playercreateinfo data sniffed? I did a bit last night but didn't see anything in the generated SQL for that table after I ran it through WPP
rektbyfaith
12-24-2022, 11:44 AM #20Archived author: ogarvey • Posted: 2022-12-24T11:44:11.407000+00:00
Original source
Out of interest how is the playercreateinfo data sniffed? I did a bit last night but didn't see anything in the generated SQL for that table after I ran it through WPP