[DiscordArchive] What would be the cleanest way to update character's start location and make it so they all start at
[DiscordArchive] What would be the cleanest way to update character's start location and make it so they all start at
Original source
What would be the cleanest way to update character's start location and make it so they all start at the same place? A module that clears and rewrites `playercreateinfo`?
rektbyfaith
10-15-2022, 08:57 PM #1Archived author: Mat • Posted: 2022-10-15T20:57:31.067000+00:00
Original source
What would be the cleanest way to update character's start location and make it so they all start at the same place? A module that clears and rewrites `playercreateinfo`?
Original source
I mean just a SQL query would do it
rektbyfaith
10-15-2022, 08:58 PM #2Archived author: Bench • Posted: 2022-10-15T20:58:27.635000+00:00
Original source
I mean just a SQL query would do it
Original source
right but where do you put it / how does it get executed?
rektbyfaith
10-15-2022, 08:58 PM #3Archived author: Mat • Posted: 2022-10-15T20:58:50.340000+00:00
Original source
right but where do you put it / how does it get executed?
Original source
You'd run it through a SQL client like HeidiSQL on your world DB
rektbyfaith
10-15-2022, 09:00 PM #4Archived author: Bench • Posted: 2022-10-15T21:00:06.269000+00:00
Original source
You'd run it through a SQL client like HeidiSQL on your world DB
Original source
yeah that makes sense, I'm looking to do it in a way that's portable and would be persisted next time I install the server on a brand new machine though, hence why I thought about the module approach and have a sql file part of the module but that might not be right approach
rektbyfaith
10-15-2022, 09:00 PM #5Archived author: Mat • Posted: 2022-10-15T21:00:58.194000+00:00
Original source
yeah that makes sense, I'm looking to do it in a way that's portable and would be persisted next time I install the server on a brand new machine though, hence why I thought about the module approach and have a sql file part of the module but that might not be right approach
Original source
I think the worldserver will run it if it's placed in /data/sql/custom
rektbyfaith
10-15-2022, 09:02 PM #6Archived author: Bench • Posted: 2022-10-15T21:02:05.110000+00:00
Original source
I think the worldserver will run it if it's placed in /data/sql/custom
Original source
sounds good, thank you
rektbyfaith
10-15-2022, 09:02 PM #7Archived author: Mat • Posted: 2022-10-15T21:02:16.517000+00:00
Original source
sounds good, thank you
Original source
Something like this would work
```UPDATE `playercreateinfo` SET `map`='number', `zone`='number', `position_x`='number', `position_y`='number', `position_z`='number', `orientation`='number';```
rektbyfaith
10-15-2022, 09:02 PM #8Archived author: Bench • Posted: 2022-10-15T21:02:36.251000+00:00
Original source
Something like this would work
```UPDATE `playercreateinfo` SET `map`='number', `zone`='number', `position_x`='number', `position_y`='number', `position_z`='number', `orientation`='number';```
Original source
there's still an uh
rektbyfaith
10-15-2022, 09:17 PM #9Archived author: Dreadmaster • Posted: 2022-10-15T21:17:10.013000+00:00
Original source
there's still an uh
Original source
![[Image: unknown.png?ex=690c6797&is=690b1617&hm=3...3978d3457&]](https://cdn.discordapp.com/attachments/284406375495368704/1030952504097263676/unknown.png?ex=690c6797&is=690b1617&hm=3801c4fae311303f0e2006f5b460a87dcc9dc33fa779abc471a2bf23978d3457&)
rektbyfaith
10-15-2022, 09:17 PM #10Archived author: Dreadmaster • Posted: 2022-10-15T21:17:11.222000+00:00
Original source
1 Guest(s)
1 Guest(s)