Jump to content
  • 0

help plzz ty


ShotGun®
 Share

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.

 Share



  • Posts

    • Hi, can you give a discord? 
    • We are glad to announce our GRAND OPENING will be in 6 days (05/10/22) - 19:00 GMT +3 Website: www.l2interpride.com Discord: discord.gg/l2interpride   General Information ・Client: Interlude ・Type: Custom PvP server ・Rates: High rates ・Starting Level: 56 ・Unique PvP Enchant system ・New PvP Synergy System ・Balanced PvP environment   Events ・Team vs Team, Capture the Flag, Death Match ・Castle Siege Event, Tournament Event   Rates ・Experience: x5000 ・Skill Points: x5000 ・Drop Rate: x1 ・Adena: x500   Enchants ・Safe Enchant: 7 ・Max Enchant: 25 ・Enchant Rate Weapon: Custom (Higher enchant = lower rate) ・Enchant Rate Armor: Custom (Higher enchant = lower rate) ・Enchant Rate Jewel: Custom (Higher enchant = lower rate)   Custom PvP Skills ・With your pvps your color name & title gonna change. ・Moreover it will be a list of pvp skills that are going tto be added on your char related to your pvps.   NPC ・Item Store: Up to S grade items, Consumables, Potions & more. ・Mysterious Merchant: Cusom Armors, Weapons, Accessories & more. ・Npc Buffer: All buffs, Scheme Buffer. ・Class Master: Free Class upgrade.   Custom Items ・Armors: (Tier 1: Titanium, Dread) (Tier 2: Pride) (Tier 3: Rykros) ・Weapons: (Tier 1: Unique) (Tier 2: Pride) (Tier 3: Relic) ・Accessories: Up to 30 Accessories with unique stats. ・Dyes-Tattoos: Custom Dyes-Tattoos with special stats.       Npc Donate ・Divine Tome of Level : Full 85 ・PvP Increaser : +500 pvp ・Elixier of CP ・Rune Drop EXP/SP Boost +50% ・Ancient Scroll of Name Change ・Body Reconstruction ・Pk Reset ・Secret scroll of Class Remastery ・Nobless   Wondrous Cubic as Teleport Gatekeeper   Farm Areas ・Our farm areas are Cave Of Trials and Forbbiden Gateway (editado)     New Augment System Status We added a New Augment System method on our server, which already exists in Pride. How it work: Status like pDef/mDef/maxHp/maxMp/maxCp/pAtk/mAtk will be multiplied from x4 to x10 compared to the descriptions of the Augment informed in the selected item. Image example where it shows Augment of maxHp, maxMp and pDef, these values are multiplied randomly, making all augments more interesting.  
    • Tyrant 78+ noblesse with subs BD 76+, Cat 76+, Destro 55+ with mail   If you are interesting drop private msg. Best Regards!
    • WTB acc on reborn x1  with equip only trusted seller, dont try to scamm me anymore.   
  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock