Jump to content

criticalrio

VIP Member
  • Posts

    8
  • Credits

  • Joined

  • Last visited

  • Feedback

    0%

About criticalrio

Profile Information

  • Gender
    Male
  • Country
    Afghanistan

criticalrio's Achievements

Newbie

Newbie (1/16)

0

Reputation

  1. No.. I gave up.. It was banning but not kicking from server once it was only handling the ban on db level.
  2. The Rev I using doesn't not have this protection yet.. I am using a old l2j Freya version and the server owner don't want to change it... Can you guys send me the solution we have on marker now? I didn't find anything... That's the reason I am "reinvent the wheel".. Btw I tested several others versions and it is pretty easy to hack and dupe..
  3. Tessa: The code is working... The char get banned but he needs logoff to feel it.. I would like to implement a command to kick or logoff after run the statement2. I verified that the class L2pcintance.Java call this inventory restore. I created a new sql statement to check if they char is banned then player.logoff() but this logoff didn't happens.. That's the point here.. How can I logoff the account in matter?
  4. I'm complete stupid in java.. I just did this dupe protection just analyzing part of code and copying and pasting. I tried to follow your suggestion but the eclipse says: player cannot be resolved . :-/
  5. Hi guys, I created a dupe protection that is working quite well but I need some helo to improve it. As you can see below, I modified the gameserver.model.itemcontainer.inventory.java to remove all item from character bag if a dupe session is identified and also ban all accounts that have the same IP as the duping account. I need to know is how can I implement a kick process after ban the user. I copy and past all restore() class from iventory.java below public void restore() { Connection con = null; int BanStatus = 0; int char_id; try { con = L2DatabaseFactory.getInstance().getConnection(); PreparedStatement statement = con.prepareStatement("SELECT object_id, item_id, count, enchant_level, loc, loc_data, custom_type1, custom_type2, mana_left, time FROM items WHERE owner_id=? AND (loc=? OR loc=?) ORDER BY loc_data"); statement.setInt(1, getOwnerId()); statement.setString(2, getBaseLocation().name()); statement.setString(3, getEquipLocation().name()); ResultSet inv = statement.executeQuery(); L2ItemInstance item; while (inv.next()) { item = L2ItemInstance.restoreFromDb(getOwnerId(), inv); if (item == null) { continue; } // Bug get empty items when double session is created if (L2World.getInstance().findObject(inv.getInt("object_id")) != null) { _log.log(Level.WARNING, "Item: " + item.getObjectId() + " Has Duplied on World And Cannot be Load"); L2World.getInstance().removeObject(item); BanStatus = 1; continue; } if (getOwner() instanceof L2PcInstance) { L2PcInstance player = (L2PcInstance) getOwner(); if (!player.isGM() && !player.isHero() && item.isHeroItem()) { item.setLocation(ItemLocation.INVENTORY); } } L2World.getInstance().storeObject(item); // If stackable item is found in inventory just add to current quantity if (item.isStackable() && (getItemByItemId(item.getItemId()) != null)) { addItem("Restore", item, getOwner().getActingPlayer(), null); } else { addItem(item); } } inv.close(); statement.close(); refreshWeight(); /* ---------------------- Ban account --------------------------- */ if (BanStatus == 1) { Connection BanCon = null; try { BanCon = L2DatabaseFactory.getInstance().getConnection(); // PreparedStatement statement2 = BanCon.prepareStatement("update accounts set accesslevel =-100 where login in (select account_name from characters where charid = ? )"); PreparedStatement statement2 = BanCon.prepareStatement("update accounts acc , characters ch, accounts ac2 set ac2.accesslevel = -100 where acc.login = ch.account_name and ch.charid = ? and acc.lastIP = ac2.lastIP "); statement2.setInt(1, getOwnerId()); int BanSQL = statement2.executeUpdate(); char_id = getOwnerId(); _log.log(Level.WARNING, "BANNED MAIN ACCOUNT THAT IS USING THE CHAR_ID : " + char_id); } catch (Exception e) { _log.log(Level.WARNING, "Falha ao banir usuario: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(BanCon); } } /* ---------------------- end Ban account --------------------------- */ } catch (Exception e) { _log.log(Level.WARNING, "Could not restore inventory: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } }
  6. Anyone have the latest rev from the old l2jserver github? I'm looking for it.. I need the source code
  7. Hi Guys, How much will you guys charge me to fix a bug in on specific C25 rev which after you use a skill and restart the game 3 time you will be able to reuse the skill. I don't know how to fix it. Brgds critical
  8. Hi Guys, I'm looking for the source project for L2J Freaya 4.4 latest version since the github from l2jserver.com is not available anymore. Can someone provide me it ? Brgds, critical
×
×
  • Create New...