/** 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 saveData.
*
* @param cw CursedWeapon
*/
private void saveData(CursedWeapon cw) {
Connection con = null;
PreparedStatement statement = null;
try {
con = DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement("DELETE FROM cursed_weapons WHERE item_id = ?");
statement.setInt(1, cw.getItemId());
statement.executeUpdate();
if (cw.isActive()) {
DbUtils.close(statement);
statement =
con.prepareStatement(
"REPLACE INTO cursed_weapons (item_id, player_id, player_karma, player_pkkills, nb_kills, x, y, z, end_time) VALUES (?,?,?,?,?,?,?,?,?)");
statement.setInt(1, cw.getItemId());
statement.setInt(2, cw.getPlayerId());
statement.setInt(3, cw.getPlayerKarma());
statement.setInt(4, cw.getPlayerPkKills());
statement.setInt(5, cw.getNbKills());
statement.setInt(6, cw.getLoc().getX());
statement.setInt(7, cw.getLoc().getY());
statement.setInt(8, cw.getLoc().getZ());
statement.setLong(9, cw.getEndTime() / 1000);
statement.executeUpdate();
}
} catch (SQLException e) {
_log.error("CursedWeapon: Failed to save data: " + e);
} finally {
DbUtils.closeQuietly(con, statement);
}
}
/**
* Method emptyPlayerCursedWeapon.
*
* @param playerId int
* @param itemId int
* @param cw CursedWeapon
*/
private void emptyPlayerCursedWeapon(int playerId, int itemId, CursedWeapon cw) {
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, playerId);
statement.setInt(2, itemId);
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, playerId);
if (statement.executeUpdate() != 1) {
_log.warn("Error while updating karma & pkkills for userId " + cw.getPlayerId());
}
removeFromDb(itemId);
} catch (SQLException e) {
_log.error("", e);
} finally {
DbUtils.closeQuietly(con, statement);
}
}
/**
* Method checkPlayer.
*
* @param player Player
* @param item ItemInstance
*/
public void checkPlayer(Player player, ItemInstance item) {
if ((player == null) || (item == null) || player.isInOlympiadMode()) {
return;
}
CursedWeapon cw = _cursedWeaponsMap.get(item.getId());
if (cw == null) {
return;
}
if ((player.getObjectId() == cw.getPlayerId()) || (cw.getPlayerId() == 0) || cw.isDropped()) {
activate(player, item);
showUsageTime(player, cw);
} else {
_log.warn("CursedWeaponsManager: " + player + " tried to obtain " + item + " in wrong way");
player.getInventory().destroyItem(item, item.getCount());
}
}
/**
* 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()));
}