L2KingWorld Posted October 21, 2011 Share Posted October 21, 2011 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.. Link to comment Share on other sites More sharing options...
0 Justice Posted October 22, 2011 Share Posted October 22, 2011 Απ' ότι κατάλαβα θες να διαγράψεις accounts/char που έχουν να μπουν στον server πολύ καιρό. DELETE FROM characters WHERE lastAccess < 466560000; DELETE FROM accounts WHERE lastactive < 466560000; Αυτό το sql διαγράφει accounts/chars που έχουν να μπουν 3ς μήνες στον server. Link to comment Share on other sites More sharing options...
0 L2KingWorld Posted October 22, 2011 Author Share Posted October 22, 2011 nai an mporis pio analitika. na ftiakso ena sql characters_set me tis xaraktires pou mou dixnis ? i na simpliroso sto navicat (characters) (accounts) ? Link to comment Share on other sites More sharing options...
0 BlackKiss Posted October 22, 2011 Share Posted October 22, 2011 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 Link to comment Share on other sites More sharing options...
0 nexυs Posted October 22, 2011 Share Posted October 22, 2011 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 ;) Link to comment Share on other sites More sharing options...
0 BlackKiss Posted October 22, 2011 Share Posted October 22, 2011 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 Link to comment Share on other sites More sharing options...
0 L2KingWorld Posted October 23, 2011 Author Share Posted October 23, 2011 nai.. ke se periptosi pou 8elo na alakso px: < 466560000 > se <9999999> pou to vrisko afto ??? Link to comment Share on other sites More sharing options...
0 BlackKiss Posted October 23, 2011 Share Posted October 23, 2011 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 Link to comment Share on other sites More sharing options...
0 L2KingWorld Posted October 23, 2011 Author Share Posted October 23, 2011 sto navicat pou fortoni gia na alakso tin ora Link to comment Share on other sites More sharing options...
0 BlackKiss Posted October 24, 2011 Share Posted October 24, 2011 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; Link to comment Share on other sites More sharing options...
0 L2KingWorld Posted October 24, 2011 Author Share Posted October 24, 2011 dld ka8e fora 8a otan 8eliso na alazo tin ora 8a prepi na to fortono sto navicat ? Link to comment Share on other sites More sharing options...
0 L2KingWorld Posted October 28, 2011 Author Share Posted October 28, 2011 ole ekana test gia dio mere einai oti prepi pedes ty... lock plz :) Link to comment Share on other sites More sharing options...
0 Justice Posted October 28, 2011 Share Posted October 28, 2011 ole ekana test gia dio mere einai oti prepi pedes ty... lock plz :) Locked. Link to comment Share on other sites More sharing options...
Question
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..
Link to comment
Share on other sites
12 answers to this question
Recommended Posts