Jump to content
  • 0

help plzz ty


ShotGun®

Question

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

Link to comment
Share on other sites

8 answers to this question

Recommended Posts

  • 0

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

Link to comment
Share on other sites

  • 0

Υπάρχει 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.

Link to comment
Share on other sites

  • 0

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 :)

Link to comment
Share on other sites

  • 0

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 ειναι η καλύτερη λύση.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...