Character saved multiple times on Database

[Mad]

Hi guys, yesterday i upgraded my server with 1.0.4 patch (i also installed Sauerland map) and i was installing some script when i found this over my database charcter_data table

 

 

seems that every time a character connect/disconnect he is saved in a new field..

 

i made something wrong or  should work so now Oo ?

[RipSaw]

Everytime they die it creates a new field.

[Mad]

Ah Okay then also if it's a little weird system so

 

I remember there was only a single row for an account, now we'll have an huge amount of data sheet in few weeks :\

[RipSaw]

It creates a new entry for every death, this way, if someone died to a hacker, you can simply revive their old charachter. (By changing the isAlive to 1 on the one that died to a hacker, and to 0 on the one they respawned with)

[Mad]

Ahhhh , ok understood now

 

Thaks for clarification :)

[RipSaw]

No problem :)

[Darth_Rogue]

You can also clean up your character data table up by using this SQL query:  'DELETE from CHARACTER_DATA where ALIVE=0'  That will remove all "dead" characters from the record and make things easier to manage.  I have mine setup to do it automatically every 48 hours at the same time as a 4AM restart.  I don't think its an issue in this version of the database, but if you get an error when using that query, try adding 'SET FOREIGN_KEY_CHECKS=0' into the query on a separate line before the other line I mentioned above.