Jump to content

MaxPowerz

Members
  • Posts

    155
  • Joined

  • Last visited

  • Feedback

    0%

Everything posted by MaxPowerz

  1. ti o 8eos na ta kani an dn 3eris na to pezis mn pezis apla omfg. tragoudia - paratragouda
  2. xaxa dude i ma scammer for what? you are so funny plus your are pantso 13-14 years old boy. go to your mommy
  3. pf hellbound ? i think is dead :/
  4. reworked l2jarchid he said . download before you speak. this is old arhicd rev 1200 . check svn and then check the pack and come then answer me.!
  5. omg idiot ppl devil shared a free old archid rev xaxaxaxa .
  6. more updates. balanced mage rage.!
  7. xaxa u lie they are not his files. if you want to check his files log here: http://l2funland.com this is a free l2jarchid rev so stop lying .
  8. http://www.maxcheaters.com/forum/index.php?topic=147264.0 he shared l2archid rev 1200 and he lie interlude pack premium source lol :D
  9. xaxaxaxax you release l2archid rev 1200 :D
  10. xaaxxaaxax dude this pack l2jarchid rev 1200 omfg someone ban that noob lol anyway another fail fro another noob plus wannabe . you made my day :D
  11. wow. im gonna test it dude and tell you the results . thnx again!
  12. KKnD is the dev of white eagle?
  13. oreo npc man tha to testarw k tha s pw~
  14. oreo collection. pistevw na voithisi arketa tous new sto forum!
  15. omg this is l2jarchid rev 1200 . what is premium? //owned
  16. xaxax dude you dont have this pack . iozo sell this pack you are justa f@cking scammer !
  17. ok i will put some pk killers on farm zones. + now the pick up is automatic !
  18. SET @dias = 1; DELETE FROM accounts WHERE DATEDIFF( CURRENT_DATE( ) , FROM_UNIXTIME( `lastactive` /1000 ) ) > @dias; DELETE FROM accounts WHERE login NOT IN (SELECT account_name FROM characters); DELETE FROM account_data WHERE account_name NOT IN (SELECT login FROM accounts); DELETE FROM characters WHERE account_name NOT IN (SELECT login FROM accounts); DELETE FROM character_friends WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM character_hennas WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM character_macroses WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM character_quest_global_data WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM character_quests WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM character_raid_points WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM character_recipebook WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM character_recommends WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM character_shortcuts WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM character_skills WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM character_skills_save WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM character_subclasses WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM character_tpbookmark WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM clan_data WHERE leader_id NOT IN (SELECT charId FROM characters); DELETE FROM clan_notices WHERE clan_id NOT IN (SELECT clan_id FROM clan_data); DELETE FROM clan_privs WHERE clan_id NOT IN (SELECT clan_id FROM clan_data); DELETE FROM clan_skills WHERE clan_id NOT IN (SELECT clan_id FROM clan_data); DELETE FROM items WHERE owner_id NOT IN (SELECT charId FROM characters) AND owner_id NOT IN (SELECT clan_id FROM clan_data); DELETE FROM pets WHERE item_obj_id NOT IN (SELECT object_id FROM items); DELETE FROM seven_signs WHERE charId NOT IN (SELECT charId FROM characters); UPDATE characters SET clanid=0,title="",clan_privs=0,lvl_joined_academy=0,apprentice=0,sponsor=0 where clanid NOT IN (SELECT clan_id FROM clan_data); UPDATE clanhall SET ownerID=0,paidUntil=0,paid=0 where ownerID NOT IN (SELECT clan_id FROM clan_data); DELETE FROM clanhall_functions WHERE hall_id NOT IN (SELECT id FROM clanhall WHERE ownerId=0); DELETE FROM clan_subpledges WHERE clan_id NOT IN (SELECT clan_id FROM clan_data); DELETE FROM clan_wars WHERE clan1 NOT IN (SELECT clan_id FROM clan_data) OR clan2 NOT IN (SELECT clan_id FROM clan_data); UPDATE castle SET taxPercent="0",treasury="0" WHERE id NOT IN (SELECT hasCastle FROM clan_data where hasCastle>0); DELETE FROM castle_doorupgrade WHERE doorId IN (SELECT id FROM castle_door where castleId NOT IN (SELECT hasCastle FROM clan_data where hasCastle>0)); DELETE FROM castle_functions WHERE castle_id NOT IN (SELECT hasCastle FROM clan_data WHERE hasCastle>0); DELETE FROM castle_manor_procure WHERE castle_id NOT IN (SELECT hasCastle FROM clan_data WHERE hasCastle>0); DELETE FROM castle_manor_production WHERE castle_id NOT IN (SELECT hasCastle FROM clan_data WHERE hasCastle>0); DELETE FROM siege_clans WHERE clan_id NOT IN (SELECT clan_id FROM clan_data); UPDATE siege_clans SET castle_owner="" WHERE castle_owner NOT IN (SELECT clan_id FROM clan_data); UPDATE fort SET owner=0,castleId=0 WHERE owner NOT IN (SELECT clan_id FROM clan_data); DELETE FROM fort_doorupgrade WHERE fortId IN (SELECT id FROM fort WHERE owner=0); DELETE FROM fort_functions WHERE fort_Id IN (SELECT id FROM fort WHERE owner=0); UPDATE fort_spawnlist SET castleId=0 WHERE castleId NOT IN (SELECT hasCastle FROM clan_data where hasCastle>0); DELETE FROM fortsiege_clans WHERE clan_id NOT IN (SELECT clan_id FROM clan_data); DELETE FROM heroes WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM olympiad_nobles WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM olympiad_nobles_eom WHERE charId NOT IN (SELECT charId FROM characters); DELETE FROM mods_wedding WHERE player1Id NOT IN (SELECT charId FROM characters) OR player2Id NOT IN (SELECT charId FROM characters);
  19. finally i made updates. dynasty armors coming too. very soon!
  20. MaxPowerz

    [GR]Xena

    egw exw kani k to exw gia 1,5 mina twra k einai akoma kirile.
  21. i never joined the server but when i wrote on youtube l2java i saw 1k videos with bugs on your server. so i guess your skills are not so good. anyway gl and keep working!
  22. http://www.maxcheaters.com/forum/index.php?topic=147198.msg1050028#new
×
×
  • 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