help plzz ty

[ShotGun®]

kalispera sas ... ixa ksana kanei auto to topic alla d me help kaneis..mipws exei kapoios n m dosei ena arxio i programa i oti dipote..na svinonte char ana 1 mina otan d kanoun login??gt exei gemisei to navicat me botakia k paratimenous char..delete dld accounts k characters plzzz ty

[maximilion2]

spera :) nmz yparxei enas kwdikas p ton vazeis mesw eclipse kai automata an kapios gia panw apo ena sygkekrimeno orio p 8a valeis paramenei level 1 ginete automata delete...

8a to googlaro kai 8a s pw an vrw kati :P

[ShotGun®]

d exw eclipse file m...plzzz koitakse to mia..m edosan ena arxio n ta delete n to pernao sto navicat..ala d vlepo n svinete tpt..plzzz kante kati

[maximilion2]

ti pack xrhsimopoieis?

[ShotGun®]

l2frozen..:)

[Dulens.]

Υπάρχει sql code. Περίμενε να τον βρω και να στον στείλω.

 

DELETE FROM characters WHERE lastAccess < 155520000;
DELETE FROM character_quests WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM items WHERE owner_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_shortcuts WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills_save WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_subclasses WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);

Eίναι για 1 μήνα inactive.

[ShotGun®]

demy auto ine filos pou estiles molis??elpizo n katalaves ti ennow e??na min ginei kamia trela :) to ksana lew an enas char exei n mpei ena mina n delete apo pantou...demy ena pm na sou po poios ime :)

[thepsolartek]

bsk ayto mporei na ginei apo navicat kiolas an pas sto accounts table nmz ( oxi kai 100% sigouros leei last

time) kai sbineis apo ekei

[Fanky]

bsk ayto mporei na ginei apo navicat kiolas an pas sto accounts table nmz ( oxi kai 100% sigouros leei last

time) kai sbineis apo ekei

και άμα είναι 100 θα σβήνει ένα ένα;

Το sql ειναι η καλύτερη λύση.