L2J Server

Posted: **Sun Sep 19, 2010 10:44 am**

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.

Posted: **Sun Sep 19, 2010 10:50 am**

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

Posted: **Sun Sep 19, 2010 11:03 am**

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 = ?",

Posted: **Sun Sep 19, 2010 12:12 pm**

_DS_ wrote:line 212

Posted: **Mon Sep 20, 2010 10:27 am**

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

Posted: **Sat Sep 25, 2010 5:39 am**

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

Posted: **Sat Sep 25, 2010 1:15 pm**

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

L2J Server

Database cleanup problem...

Database cleanup problem...

Re: Database cleanup problem...

Re: Database cleanup problem...

Re: Database cleanup problem...

Re: Database cleanup problem...

Re: Database cleanup problem...

Re: Database cleanup problem...