Page 1 of 1

Check DB for certain move on a Bug Report

Posted: 12 June 2020, 17:16
by somiryu
Hi! I'm trying to debug an error on table 94225424 of XanadĂș, but I find some weird behavior for which I would require to be able to see the DB for that particular game state (a cards is being autosold with only three workers, even thought it requires 4 workers for that to happen, an later on one card is no being autosold and it should). My code seem to be ok, for example, for the first scenario my query is:

$toAutoSell = self::getCollectionFromDB( "SELECT card_id, card_type, used_slots, card_location_arg FROM card WHERE used_slots=4" );

So I can only think there is something weird on the db and would like to check it out to try to find what happened, but I can't find a way to access that info. Is there a way?

Thanks!

Re: Check DB for certain move on a Bug Report

Posted: 12 June 2020, 17:25
by somiryu
As a clarification, I know I can load the game table to a game studio table, but I understand this takes me to the game state where the bug was reported, but I found a bug by watching the replay before that momento so I need to go back to other move.

Re: Check DB for certain move on a Bug Report

Posted: 12 June 2020, 18:59
by Een
Are you asking to go back to a past state of the database that hasn't been saved? Unfortunately that's not possible. This state doesn't exist anymore.
(replays rely on replaying notifications and do not involve any database; the database exists only during the game, and a state doesn't exist anymore once the next move is played, unless there has been a bug report at this precise moment saving it)

Re: Check DB for certain move on a Bug Report

Posted: 12 June 2020, 20:19
by somiryu
Ok, bad news for me, but will see how I can replicate the bug then! Thanks!

Re: Check DB for certain move on a Bug Report

Posted: 19 June 2020, 17:18
by Lymon Flowers
Perhaps you can find interesting data in the replay, Just load the game and replay it. Look at the source code for g_gamelogs and you will find interesting json data that can be pretty-printed and will give you much context. It helped me fix a pair of bugs already.