Why is this not working...

[henhouse]

So I'm trying to do a force-reset of all titles on current characters on 2.4.3 with the following SQL:

UPDATE `characters` SET `data`=CONCAT(CAST(SUBSTRING_INDEX(`data`, ' ', 924) AS CHAR), ' ', 0, ' ', CAST(SUBSTRING_INDEX(`data`, ' ', -587)AS CHAR));

And it works, all the values change to "0" however when you then go into load the character you get "Player#xxx has broken data and cannot be loaded".

Does anyone know why this is happening?

If anyone wants to check the 2.4.3 values for this: http://udbwiki.webhop.net/index.php/Character_data.

PLAYER__FIELD_KNOWN_TITLES is 924.

[freghar]

So I'm trying to do a force-reset of all titles on current characters on 2.4.3 with the following SQL:

UPDATE `characters` SET `data`=CONCAT(CAST(SUBSTRING_INDEX(`data`, ' ', 924) AS CHAR), ' ', 0, ' ', CAST(SUBSTRING_INDEX(`data`, ' ', -587)AS CHAR));

And it works, all the values change to "0" however when you then go into load the character you get "Player#xxx has broken data and cannot be loaded".

Does anyone know why this is happening?

If anyone wants to check the 2.4.3 values for this: http://udbwiki.webhop.net/index.php/Character_data.

PLAYER__FIELD_KNOWN_TITLES is 924.

Actually, I believe it's one byte off.

I've written a small C prog for this long time ago and AFAIK it's value always worked with this SUBSTRING_INDEX thing.

#include <stdio.h>
#include "UpdateFields.h"

#define TARGET PLAYER__FIELD_KNOWN_TITLES

int main(void)
{
       printf("%#lx (%lu)\\n", TARGET+1, TARGET+1);

       return 0;
}

(edit the TARGET to your needs + put 0.12 UpdateFields.h into the *current* directory)

The key thing here is probably TARGET+1, which returns 925 for me, so try that one.

[Patman128]

When you are selecting the data from the character blob, you use value + 1. When you are updating, it should be value.