erotisi: pos na diagrafounte ta char..

[L2KingWorld]

geia stous mxc

pedes i erotisi einai> otan mpeni enas new char apo kapio kero vgeni leave ap to server.

pos na kano na min ton psaxno sto navicat ke na ton (delete) apoki ?

ke na diagrafete aftommata..

[Justice]

Απ' ότι κατάλαβα θες να διαγράψεις accounts/char που έχουν να μπουν στον server πολύ καιρό.

 

DELETE FROM characters WHERE lastAccess < 466560000; 
DELETE FROM accounts WHERE lastactive < 466560000;

 

Αυτό το sql διαγράφει accounts/chars που έχουν να μπουν 3ς μήνες στον server.

[L2KingWorld]

nai an mporis pio analitika.

na ftiakso ena sql characters_set me tis xaraktires pou mou dixnis ?

i na simpliroso sto navicat (characters) (accounts) ?

[BlackKiss]

lipon pare afta ta dio

DELETE FROM characters WHERE lastAccess < 466560000;

DELETE FROM accounts WHERE lastactive < 466560000;

kai balto mesa se ena sql.file meta apla kanis execute kai afto einai an o alos exi na mpi 3 mines tha ton kani delete apla kai grigora

[nexυs]

to poio aplo einai na pas stin database tou server sou sto navicat kai ekei pou exei last active px 1 xrono kaneis delete k eisai comple... Sugkekrimena sto account table ths navicat ;)

[BlackKiss]

den pezi afto pou les min kanis akira post gia na aneboune ta 29 post sou katarxas den zitise xirokinita zitese na to kani auto tespa otan kanis post na eisai mesa sto thema

[L2KingWorld]

nai.. ke se periptosi pou 8elo na alakso px: < 466560000 > se <9999999> pou to vrisko afto ???

[BlackKiss]

lipon edo sou exo to kalitero http://www.convertworld.com/el/time/%CE%9B%CE%B5%CF%80%CF%84%CE%AC.html site file bazis tous mines kai sou bgenoun kai ta defterolepta kitato an exis kapia aporia pos to kanis kane post edo an kai einai efkolo xerome pou boithisa

[L2KingWorld]

sto navicat pou fortoni gia na alakso tin ora

[BlackKiss]

tha paris ta sec pou tha sou bgali kai tha ta balis edw

DELETE FROM characters WHERE lastAccess < edw;

DELETE FROM accounts WHERE lastactive < edw;

[L2KingWorld]

dld ka8e fora 8a otan 8eliso na alazo tin ora 8a prepi na to fortono sto navicat ?

[L2KingWorld]

ole ekana test gia dio mere einai oti prepi pedes

ty...

lock plz :)

[Justice]

ole ekana test gia dio mere einai oti prepi pedes

ty...

lock plz :)

 

Locked.