public void doGlobalDrop(L2Character lastAttacker) { L2PcInstance player = null; if (lastAttacker instanceof L2PcInstance) player = (L2PcInstance)lastAttacker; else if (lastAttacker instanceof L2Summon) player = ((L2Summon)lastAttacker).getOwner(); if (player == null) return; // Don't drop anything if the last attacker or ownere isn't L2PcInstance // aus der Tabelle Drop Werte auslesen try { java.sql.Connection con = L2DatabaseFactory.getInstance().getConnection(); PreparedStatement statement = con.prepareStatement("SELECT item_id,maxdrop,chance,minlvl,maxlvl FROM global_drops"); ResultSet rs = statement.executeQuery(); while (rs.next()) { if (getLevel() > (rs.getInt("minlvl")) && getLevel()< (rs.getInt("maxlvl"))) { // level unterschied zwischen player/mob max 9 if(player.getLevel()-getLevel() >9) return; else { if (Rnd.get(1000000) < (rs.getInt("chance"))) { RewardItem item = new RewardItem((rs.getInt("item_id")), Rnd.get(1, (rs.getInt("maxdrop")))); player.doAutoLoot(this, item); } else return; } } else return; } } catch (Exception e) { _log.warning("Globales Drop System: Irgendwas ist da am Arsch: " + e); } }