/** 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()));
}
