[DiscordArchive] Or not?
[DiscordArchive] Or not?
Original source
Or not?
rektbyfaith
03-07-2022, 06:58 PM #1Archived author: Bogir • Posted: 2022-03-07T18:58:42.869000+00:00
Original source
Or not?
Original source
In the Core we have check for refundable flag 4069 (if I'm not mistaken) for item listed in `item_instance` . So, Item must be in both tables, or only in `item_instance`, but not only in `item_refund_instance`. Am I right?
rektbyfaith
03-07-2022, 07:01 PM #2Archived author: Bogir • Posted: 2022-03-07T19:01:01.015000+00:00
Original source
In the Core we have check for refundable flag 4069 (if I'm not mistaken) for item listed in `item_instance` . So, Item must be in both tables, or only in `item_instance`, but not only in `item_refund_instance`. Am I right?
Original source
That should be right
rektbyfaith
03-07-2022, 07:01 PM #3Archived author: Revision • Posted: 2022-03-07T19:01:12.096000+00:00
Original source
That should be right
Original source
the `item_guid` in `item_refued_instance` does link to the guid of `item_instance` so if there is no guid in `item_instance`, `item_refund_instance` points to nothing.
rektbyfaith
03-07-2022, 07:01 PM #4Archived author: Revision • Posted: 2022-03-07T19:01:39.431000+00:00
Original source
the `item_guid` in `item_refued_instance` does link to the guid of `item_instance` so if there is no guid in `item_instance`, `item_refund_instance` points to nothing.
Original source
It seems we must to add new method to cleanup such items in DB at every server start.
`item_instance` table also contains items which belongs to nobody and not stored into GuildBank. GB is the single table which may store items which not listed in `item_instance` table ?
rektbyfaith
03-07-2022, 07:05 PM #5Archived author: Bogir • Posted: 2022-03-07T19:05:42.378000+00:00
Original source
It seems we must to add new method to cleanup such items in DB at every server start.
`item_instance` table also contains items which belongs to nobody and not stored into GuildBank. GB is the single table which may store items which not listed in `item_instance` table ?
Original source
I don't know about guild banks, unfortunately.
rektbyfaith
03-07-2022, 07:06 PM #6Archived author: Revision • Posted: 2022-03-07T19:06:06.553000+00:00
Original source
I don't know about guild banks, unfortunately.
Original source
It does exist in item_instance, it seems
rektbyfaith
03-07-2022, 07:06 PM #7Archived author: Revision • Posted: 2022-03-07T19:06:42.157000+00:00
Original source
It does exist in item_instance, it seems
Original source
if an item is in the guild bank, it does still exist in item_instance. Only the owner becomes (i think) 0
rektbyfaith
03-07-2022, 07:06 PM #8Archived author: Honey • Posted: 2022-03-07T19:06:48.005000+00:00
Original source
if an item is in the guild bank, it does still exist in item_instance. Only the owner becomes (i think) 0
Original source
yes
rektbyfaith
03-07-2022, 07:06 PM #9Archived author: Bogir • Posted: 2022-03-07T19:06:58.109000+00:00
Original source
yes
Original source
`guild_bank_item`.`item_guid` -> `item_instance`
rektbyfaith
03-07-2022, 07:06 PM #10Archived author: Revision • Posted: 2022-03-07T19:06:58.694000+00:00
Original source
`guild_bank_item`.`item_guid` -> `item_instance`
1 Guest(s)
1 Guest(s)