[DiscordArchive] Can you show me the SQL?
[DiscordArchive] Can you show me the SQL?
Archived author: DioHun • Posted: 2022-12-24T11:41:48.004000+00:00
Original source
-.-
Archived author: MaxtorCoder • Posted: 2022-12-24T11:41:48.392000+00:00
Original source
I mean just grab it from sniff
Archived author: ogarvey • Posted: 2022-12-24T11:42:04.329000+00:00
Original source
2570 I believe, but not 100%
Archived author: DioHun • Posted: 2022-12-24T11:42:04.778000+00:00
Original source
this is sniff coords
Archived author: DioHun • Posted: 2022-12-24T11:42:18.551000+00:00
Original source
just the mapid not
Archived author: MaxtorCoder • Posted: 2022-12-24T11:43:45.957000+00:00
Original source
MapID is 2570
Archived author: DioHun • Posted: 2022-12-24T11:43:48.838000+00:00
Original source
yeah 2570
Archived author: DioHun • Posted: 2022-12-24T11:43:56.542000+00:00
Original source
idk why i write 2150 -.-
Archived 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);
```
Archived 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