GetAccountItemInfo Query Error

[ghost]

AccountItem dont exists in the sqlite db, when the server make a request give an throw error
i love ur project :)
#off
do u think in put the tooltip in items ? like the gunz 1.5, make the ui more clean removing the fixed ui to item desc.

[matheusot]

I tried adding the table manually, but, the server closes automatically. I'm trying logging the server to see where it breaks.

Have you found something since you opened this issue?

[matheusot]

I have solved it. Just create the table:

CREATE TABLE "AccountItem" ( AIIDINTEGER PRIMARY KEY AUTOINCREMENT,AIDINTEGER NOT NULL,ItemIDINTEGER NOT NULL,RentDateINTEGER DEFAULT NULL,RentHourPeriodINTEGER DEFAULT NULL,Cnt INTEGER DEFAULT NULL )

and in MatchServer/SQLiteDatabase.cpp add "outItemNode[NodeCount].nItemID = 0;" before outItemNode[NodeCount].nItemID = itemid;.

The errors and crashes stopped. Unfortunately, the game dont show the items loaded, so, I think there is some modification in the GunZ files causing it to not show.

[matheusot]

So, some testing later and it is not stable, some times the server crashes even with the corrections I made, it feels like loading when clicking on the tab make things a little buggy and unpredictable.