public void restore() {
_contacts.clear();
try (Connection con = ConnectionFactory.getInstance().getConnection();
PreparedStatement ps = con.prepareStatement(QUERY_LOAD)) {
ps.setInt(1, activeChar.getObjectId());
try (ResultSet rs = ps.executeQuery()) {
int contactId;
String contactName;
while (rs.next()) {
contactId = rs.getInt(1);
contactName = CharNameTable.getInstance().getNameById(contactId);
if ((contactName == null)
|| contactName.equals(activeChar.getName())
|| (contactId == activeChar.getObjectId())) {
continue;
}
_contacts.add(contactName);
}
}
} catch (Exception e) {
_log.log(
Level.WARNING,
"Error found in " + activeChar.getName() + "'s ContactsList: " + e.getMessage(),
e);
}
}
public void remove(String name) {
int contactId = CharNameTable.getInstance().getIdByName(name);
if (!_contacts.contains(name)) {
activeChar.sendPacket(SystemMessageId.NAME_NOT_REGISTERED_ON_CONTACT_LIST);
return;
} else if (contactId < 1) {
// TODO: Message?
return;
}
_contacts.remove(name);
try (Connection con = ConnectionFactory.getInstance().getConnection();
PreparedStatement ps = con.prepareStatement(QUERY_REMOVE)) {
ps.setInt(1, activeChar.getObjectId());
ps.setInt(2, contactId);
ps.execute();
SystemMessage sm =
SystemMessage.getSystemMessage(SystemMessageId.S1_SUCCESFULLY_DELETED_FROM_CONTACT_LIST);
sm.addString(name);
activeChar.sendPacket(sm);
} catch (Exception e) {
_log.log(
Level.WARNING,
"Error found in " + activeChar.getName() + "'s ContactsList: " + e.getMessage(),
e);
}
}
public boolean add(String name) {
SystemMessage sm;
int contactId = CharNameTable.getInstance().getIdByName(name);
if (_contacts.contains(name)) {
activeChar.sendPacket(SystemMessageId.NAME_ALREADY_EXIST_ON_CONTACT_LIST);
return false;
} else if (activeChar.getName().equals(name)) {
activeChar.sendPacket(SystemMessageId.CANNOT_ADD_YOUR_NAME_ON_CONTACT_LIST);
return false;
} else if (_contacts.size() >= 100) {
activeChar.sendPacket(SystemMessageId.CONTACT_LIST_LIMIT_REACHED);
return false;
} else if (contactId < 1) {
sm = SystemMessage.getSystemMessage(SystemMessageId.NAME_S1_NOT_EXIST_TRY_ANOTHER_NAME);
sm.addString(name);
activeChar.sendPacket(sm);
return false;
} else {
for (String contactName : _contacts) {
if (contactName.equalsIgnoreCase(name)) {
activeChar.sendPacket(SystemMessageId.NAME_ALREADY_EXIST_ON_CONTACT_LIST);
return false;
}
}
}
try (Connection con = ConnectionFactory.getInstance().getConnection();
PreparedStatement ps = con.prepareStatement(QUERY_ADD)) {
ps.setInt(1, activeChar.getObjectId());
ps.setInt(2, contactId);
ps.execute();
_contacts.add(name);
sm = SystemMessage.getSystemMessage(SystemMessageId.S1_SUCCESSFULLY_ADDED_TO_CONTACT_LIST);
sm.addString(name);
activeChar.sendPacket(sm);
} catch (Exception e) {
_log.log(
Level.WARNING,
"Error found in " + activeChar.getName() + "'s ContactsList: " + e.getMessage(),
e);
}
return true;
}