/** Method checkConditions. */ private void checkConditions() { Connection con = null; PreparedStatement statement1 = null, statement2 = null; ResultSet rset = null; try { con = DatabaseFactory.getInstance().getConnection(); statement1 = con.prepareStatement("DELETE FROM character_skills WHERE skill_id=?"); statement2 = con.prepareStatement("SELECT owner_id FROM items WHERE item_id=?"); for (CursedWeapon cw : _cursedWeapons) { int itemId = cw.getItemId(); int skillId = cw.getSkillId(); boolean foundedInItems = false; statement1.setInt(1, skillId); statement1.executeUpdate(); statement2.setInt(1, itemId); rset = statement2.executeQuery(); while (rset.next()) { int playerId = rset.getInt("owner_id"); if (!foundedInItems) { if ((playerId != cw.getPlayerId()) || (cw.getPlayerId() == 0)) { emptyPlayerCursedWeapon(playerId, itemId, cw); _log.info( "CursedWeaponsManager[254]: Player " + playerId + " owns the cursed weapon " + itemId + " but he shouldn't."); } else { foundedInItems = true; } } else { emptyPlayerCursedWeapon(playerId, itemId, cw); _log.info( "CursedWeaponsManager[262]: Player " + playerId + " owns the cursed weapon " + itemId + " but he shouldn't."); } } if (!foundedInItems && (cw.getPlayerId() != 0)) { removeFromDb(cw.getItemId()); _log.info("CursedWeaponsManager: Unownered weapon, removing from table..."); } } } catch (Exception e) { _log.warn("CursedWeaponsManager: Could not check cursed_weapons data: " + e); } finally { DbUtils.closeQuietly(statement1); DbUtils.closeQuietly(con, statement2, rset); } }
/** * Method endOfLife. * * @param cw CursedWeapon */ public void endOfLife(CursedWeapon cw) { if (cw.isActivated()) { Player player = cw.getOnlineOwner(); if (player != null) { _log.info( "CursedWeaponsManager: " + cw.getName() + " being removed online from " + player + "."); player.abortAttack(true, true); player.setKarma(cw.getPlayerKarma()); player.setPkKills(cw.getPlayerPkKills()); player.setCursedWeaponEquippedId(0); player.setTransformation(0); player.setTransformationName(null); player.removeSkill( SkillTable.getInstance() .getInfo(cw.getSkillId(), player.getSkillLevel(cw.getSkillId())), false); player.getInventory().destroyItemByItemId(cw.getItemId(), 1L); player.broadcastCharInfo(); } else { _log.info("CursedWeaponsManager: " + cw.getName() + " being removed offline."); Connection con = null; PreparedStatement statement = null; try { con = DatabaseFactory.getInstance().getConnection(); statement = con.prepareStatement("DELETE FROM items WHERE owner_id=? AND item_id=?"); statement.setInt(1, cw.getPlayerId()); statement.setInt(2, cw.getItemId()); statement.executeUpdate(); DbUtils.close(statement); statement = con.prepareStatement( "DELETE FROM character_skills WHERE char_obj_id=? AND skill_id=?"); statement.setInt(1, cw.getPlayerId()); statement.setInt(2, cw.getSkillId()); statement.executeUpdate(); DbUtils.close(statement); statement = con.prepareStatement("UPDATE characters SET karma=?, pkkills=? WHERE obj_Id=?"); statement.setInt(1, cw.getPlayerKarma()); statement.setInt(2, cw.getPlayerPkKills()); statement.setInt(3, cw.getPlayerId()); statement.executeUpdate(); } catch (SQLException e) { _log.warn("CursedWeaponsManager: Could not delete : " + e); } finally { DbUtils.closeQuietly(con, statement); } } } else if ((cw.getPlayer() != null) && (cw.getPlayer().getInventory().getItemByItemId(cw.getItemId()) != null)) { Player player = cw.getPlayer(); if (!cw.getPlayer().getInventory().destroyItemByItemId(cw.getItemId(), 1)) { _log.info("CursedWeaponsManager[453]: Error! Cursed weapon not found!!!"); } player.sendChanges(); player.broadcastUserInfo(); } else if (cw.getItem() != null) { cw.getItem().deleteMe(); cw.getItem().delete(); _log.info("CursedWeaponsManager: " + cw.getName() + " item has been removed from World."); } cw.initWeapon(); removeFromDb(cw.getItemId()); announce(new SystemMessage(SystemMessage.S1_HAS_DISAPPEARED_CW).addString(cw.getName())); }