[DiscordArchive] hello how to do i set the auth db 's realmlist table with my lan ip ?
[DiscordArchive] hello how to do i set the auth db 's realmlist table with my lan ip ?
Original source
hello how to do i set the auth db 's realmlist table with my lan ip ?
rektbyfaith
04-12-2022, 08:49 PM #1Archived author: cow monster • Posted: 2022-04-12T20:49:16.959000+00:00
Original source
hello how to do i set the auth db 's realmlist table with my lan ip ?
Original source
dont have sql client so doing through command line
rektbyfaith
04-12-2022, 08:49 PM #2Archived author: cow monster • Posted: 2022-04-12T20:49:31.365000+00:00
Original source
dont have sql client so doing through command line
Original source
```
mysql -u <user> -p
<enter password>
USE auth;
UPDATE realmlist SET address='<ip>';
```
rektbyfaith
04-12-2022, 08:50 PM #3Archived author: ModoX • Posted: 2022-04-12T20:50:43.300000+00:00
Original source
```
mysql -u <user> -p
<enter password>
USE auth;
UPDATE realmlist SET address='<ip>';
```
Original source
oh nice i think thats what i needed!
rektbyfaith
04-12-2022, 08:51 PM #4Archived author: cow monster • Posted: 2022-04-12T20:51:33.544000+00:00
Original source
oh nice i think thats what i needed!
Original source
technically you'd wanted to use `WHERE` aswell in the UPDATE statement, but i guess you only have one entry, so it doesnt matter
rektbyfaith
04-12-2022, 08:52 PM #5Archived author: ModoX • Posted: 2022-04-12T20:52:46.961000+00:00
Original source
technically you'd wanted to use `WHERE` aswell in the UPDATE statement, but i guess you only have one entry, so it doesnt matter
Original source
well what would the WHERE part be
rektbyfaith
04-12-2022, 08:53 PM #6Archived author: cow monster • Posted: 2022-04-12T20:53:41.061000+00:00
Original source
well what would the WHERE part be
Original source
`UPDATE realmlist SET address='<ip>' WHERE id=<realmid>;`
rektbyfaith
04-12-2022, 08:54 PM #7Archived author: ModoX • Posted: 2022-04-12T20:54:13.527000+00:00
Original source
`UPDATE realmlist SET address='<ip>' WHERE id=<realmid>;`
Original source
that did it thanks !
rektbyfaith
04-12-2022, 09:10 PM #8Archived author: cow monster • Posted: 2022-04-12T21:10:43.604000+00:00
Original source
that did it thanks !
1 Guest(s)
1 Guest(s)