[DiscordArchive] Where will that show up if it's a mail sent from the server, such as an auction expiring or leaching
[DiscordArchive] Where will that show up if it's a mail sent from the server, such as an auction expiring or leaching
Original source
there are a lot of tables relying on item_instance as well
rektbyfaith
02-23-2025, 10:25 AM #21Archived author: Kitzunu • Posted: 2025-02-23T10:25:33.569000+00:00
Original source
there are a lot of tables relying on item_instance as well
Original source
```uState == ITEM_NEW ? CHAR_REP_ITEM_INSTANCE : CHAR_UPD_ITEM_INSTANCE```
rektbyfaith
02-23-2025, 10:25 AM #22Archived author: Takenbacon • Posted: 2025-02-23T10:25:35.480000+00:00
Original source
```uState == ITEM_NEW ? CHAR_REP_ITEM_INSTANCE : CHAR_UPD_ITEM_INSTANCE```
Original source
a new item is using a replace statement, it's just overwriting whatever you had in the databse without erroring.
rektbyfaith
02-23-2025, 10:25 AM #23Archived author: Takenbacon • Posted: 2025-02-23T10:25:48.711000+00:00
Original source
a new item is using a replace statement, it's just overwriting whatever you had in the databse without erroring.
Original source
there are very few, if any tables in char_ you should honestly be manually touching outside of the core runtime
rektbyfaith
02-23-2025, 10:26 AM #24Archived author: Takenbacon • Posted: 2025-02-23T10:26:57.456000+00:00
Original source
there are very few, if any tables in char_ you should honestly be manually touching outside of the core runtime
Original source
*Should* is a nice operative key word
rektbyfaith
02-23-2025, 10:29 AM #25Archived author: metallinos • Posted: 2025-02-23T10:29:28.125000+00:00
Original source
*Should* is a nice operative key word
Original source
it's subjective but the bottom line is if you aren't 100% sure what the server is doing to these tables probably best to never manually modify data while the server is running lol
rektbyfaith
02-23-2025, 10:30 AM #26Archived author: Takenbacon • Posted: 2025-02-23T10:30:22.403000+00:00
Original source
it's subjective but the bottom line is if you aren't 100% sure what the server is doing to these tables probably best to never manually modify data while the server is running lol
Original source
Exceeding the limit of 100 works just fine, looks to me that the mails just stay in the db and the 100 with the highest id get sent to client on login it, so if you clear those and relog you get the preceding batch of 100 and so on
rektbyfaith
02-23-2025, 11:02 AM #27Archived author: metallinos • Posted: 2025-02-23T11:02:32.921000+00:00
Original source
Exceeding the limit of 100 works just fine, looks to me that the mails just stay in the db and the 100 with the highest id get sent to client on login it, so if you clear those and relog you get the preceding batch of 100 and so on
Original source
client is shown 50 at once
rektbyfaith
02-23-2025, 11:03 AM #28Archived author: Tereneckla • Posted: 2025-02-23T11:03:12.135000+00:00
Original source
client is shown 50 at once
Original source
255 is max though due to uint8
rektbyfaith
02-23-2025, 11:03 AM #29Archived author: Kitzunu • Posted: 2025-02-23T11:03:37.585000+00:00
Original source
255 is max though due to uint8
Original source
Yea it shows 50 at once but on clearing and reopening the mailbox it shows the rest until 100, then it wouldn't load more during my very rudimentary test, until a relog anyway
rektbyfaith
02-23-2025, 11:03 AM #30Archived author: metallinos • Posted: 2025-02-23T11:03:46.853000+00:00
Original source
Yea it shows 50 at once but on clearing and reopening the mailbox it shows the rest until 100, then it wouldn't load more during my very rudimentary test, until a relog anyway