Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

My game not save.

Status
Not open for further replies.
Newbie Spellweaver
Joined
Mar 31, 2022
Messages
80
Reaction score
9
Yesterday I try to modding flyff as usual [Edit resource > merge, Edit source > compile .exe] a while later I notice that my character is not save. every time that I close world server and other 6 .exe and re-open them the game will roll back to the point before I drop my weapon in to trash can.

I don't know what causing it because I never mess with SQL server Management of flyff since first time setup.[I run "2. Account (Optional).sql" sometime to create new account]

How can I fix this problem? I have no clue about it.


error_20220429.log

2022/ 4/29 17:04:14
SavePlayer(Master) - Exec RETURN FALSE, ThreadID : 21000
2022/ 4/29 17:05:11
SavePlayer(Master) - Exec RETURN FALSE, ThreadID : 1268
2022/ 4/29 17:16:51
SavePlayer(Master) - Exec RETURN FALSE, ThreadID : 11880
2022/ 4/29 17:17:33
SavePlayer(Master) - Exec RETURN FALSE, ThreadID : 21064


CQuery-LogFile_20220429.txt
2022/04/29 17:04:14
query:{call CHARACTER_STR('U1','0000001','01','',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, 0, 0, 0,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
SQLSTATE:22001 error:[Microsoft][SQL Server Native Client 11.0]String data, right truncation
//================================================================================================================
2022/04/29 17:05:11
query:{call CHARACTER_STR('U1','0000001','01','',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, 0, 0, 0,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
SQLSTATE:22001 error:[Microsoft][SQL Server Native Client 11.0]String data, right truncation
//================================================================================================================
2022/04/29 17:16:51
query:{call CHARACTER_STR('U1','0000001','01','',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, 0, 0, 0,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
SQLSTATE:22001 error:[Microsoft][SQL Server Native Client 11.0]String data, right truncation
//================================================================================================================
2022/04/29 17:17:33
query:{call CHARACTER_STR('U1','0000001','01','',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, 0, 0, 0,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
SQLSTATE:22001 error:[Microsoft][SQL Server Native Client 11.0]String data, right truncation
//================================================================================================================
 
Inactive
Joined
Jan 20, 2009
Messages
1,015
Reaction score
1,830
Whatever you decided to mod/add had some effect on the database.

So I'd revert w/e it is you did or tell us what you added?
 
Upvote 0
Newbie Spellweaver
Joined
Mar 31, 2022
Messages
80
Reaction score
9
Whatever you decided to mod/add had some effect on the database.

So I'd revert w/e it is you did or tell us what you added?

I change ProjectCmn.h

#define MAX_GUILDBANK 42
#define MAX_BANK 42

to

#define MAX_GUILDBANK 168
#define MAX_BANK 168


it work guild bank and deposit have 168 slot but it make my game not save.

Now I revert it back to fix problem but lost 168 slot.
 
Upvote 0
Inactive
Joined
Jan 20, 2009
Messages
1,015
Reaction score
1,830
I change ProjectCmn.h

#define MAX_GUILDBANK 42
#define MAX_BANK 42

to

#define MAX_GUILDBANK 168
#define MAX_BANK 168


it work guild bank and deposit have 168 slot but it make my game not save.

Now I revert it back to fix problem but lost 168 slot.

You would need to make source changes and even SQL changes to make those allow 168 slots.

It's not as easy as just changing the define.
 
Upvote 0
Newbie Spellweaver
Joined
Dec 17, 2018
Messages
33
Reaction score
25
Quickly summarized, inventories are saved in the database as several strings, stored in specific columns of specific tables.
These columns have a maximum length that these strings cannot exceed.

"String data, right truncation" is your SQL error, which means that by increasing the amount of slots to 168, the length of the strings has increased as well, now exceeding the columns limit.
To fix this specific issue, you would need to edit the structure of affected tables to increase the size limit of the affected columns, as well as edit the involved procedure (here "CHARACTER_STR") to handle this new limit.
I also assume the same problem would occur was the server to try and save the content of a guild bank.

And as Ketchup pointed out, there might also be some source changes required to properly handle that new slot limit.
 
Upvote 0
Status
Not open for further replies.
Back
Top