Database cleanup problem...

[babyjason]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:
L2JDP Revision Number:

I was told that if you delete a character in the characters.sql table, the gameserver cleans the items.sql database at next server startup.

well, today i wanted to verify if it truly does, but it does not. a character owner id, that doesent exist, still had items in items.sql as owner...

is there any script to clean up items.sql database, from items belonging to characters that dont exist anymore?

ty.

[_DS_]

Worksforme.
http://trac.l2jserver.com/browser/trunk ... ctory.java
line 212

[babyjason]

well, wich command string is the one that deletes orphaned character items ?

o only see 2 commands wich delete items from db...

Code: Select all

 "DELETE FROM character_instance_time WHERE time <= ?",100                         "DELETE FROM character_skills_save WHERE restore_type = 1 AND systime <= ?"     };

this, i see updates only items...

Code: Select all

  "UPDATE items                 SET owner_id = ?    WHERE owner_id = ?",39                  "UPDATE items                 SET object_id = ?   WHERE object_id = ?",

[_DS_]

line 212

[babyjason]

thank you ,
if it doesent work i ll try to manually use the line in sql database to clean up...

[babyjason]

confirmed again today, deleted few characters, started game server after, but in items.sql the owner id corresponds to deleted characters id...

[achilless]

viewtopic.php?f=81&t=14812&start=30