Legacy Development Community Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Legacy Development Community Forum

World of Warcraft Development Forums
 
HomeHome  PortalPortal  GalleryGallery  SearchSearch  Latest imagesLatest images  RegisterRegister  Log in  

 

 which tables can be empty on start

Go down 
4 posters
AuthorMessage
egel

egel


Number of posts : 23
Registration date : 2006-12-24

which tables can be empty on start Empty
PostSubject: which tables can be empty on start   which tables can be empty on start EmptyMon Apr 30, 2007 12:26 am

what tables can be empty on server start? i know char_state. is there anyone else?
thx Wink
Back to top Go down
Yamachi

Yamachi


Number of posts : 24
Registration date : 2007-01-28

which tables can be empty on start Empty
PostSubject: Re: which tables can be empty on start   which tables can be empty on start EmptyWed 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.
Back to top Go down
egel

egel


Number of posts : 23
Registration date : 2006-12-24

which tables can be empty on start Empty
PostSubject: Re: which tables can be empty on start   which tables can be empty on start EmptyThu 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;

Smile
Back to top Go down
Iceman
Developer
Iceman


Number of posts : 462
Registration date : 2006-11-28

which tables can be empty on start Empty
PostSubject: Re: which tables can be empty on start   which tables can be empty on start EmptyThu May 10, 2007 8:59 am

dont delete corpses
unless character is deleted and corpse left
Back to top Go down
ForumTroll

ForumTroll


Number of posts : 71
Registration date : 2006-12-20

which tables can be empty on start Empty
PostSubject: Re: which tables can be empty on start   which tables can be empty on start EmptyThu May 10, 2007 4:48 pm

one q why should you empty tables?
Back to top Go down
Iceman
Developer
Iceman


Number of posts : 462
Registration date : 2006-11-28

which tables can be empty on start Empty
PostSubject: Re: which tables can be empty on start   which tables can be empty on start EmptyThu 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
Back to top Go down
Sponsored content





which tables can be empty on start Empty
PostSubject: Re: which tables can be empty on start   which tables can be empty on start Empty

Back to top Go down
 
which tables can be empty on start
Back to top 
Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
Legacy Development Community Forum :: Kobold Legacy-
Jump to: