Number of posts : 23 Registration date : 2006-12-24
Subject: which tables can be empty on start Mon Apr 30, 2007 12:26 am
what tables can be empty on server start? i know char_state. is there anyone else? thx
Yamachi
Number of posts : 24 Registration date : 2007-01-28
Subject: Re: which tables can be empty on start Wed May 02, 2007 5:32 am
`trainers` and and any creature or item-related tables can, not sure about the others... I'll have to muck about with that later.
egel
Number of posts : 23 Registration date : 2006-12-24
Subject: Re: which tables can be empty on start Thu May 10, 2007 8:49 am
so as it seems i can execute this sql before each server start...
delete from char_state; delete from char_auras; delete from corpses;
Iceman Developer
Number of posts : 462 Registration date : 2006-11-28
Subject: Re: which tables can be empty on start Thu May 10, 2007 8:59 am
dont delete corpses unless character is deleted and corpse left
ForumTroll
Number of posts : 71 Registration date : 2006-12-20
Subject: Re: which tables can be empty on start Thu May 10, 2007 4:48 pm
one q why should you empty tables?
Iceman Developer
Number of posts : 462 Registration date : 2006-11-28
Subject: Re: which tables can be empty on start Thu May 10, 2007 8:30 pm
char state is needed soem time not necesary but if u see player missing from online list then u need to clear it it hapens some times not sure why char auras is safely to clean on every restart