private void getFriendList() {
Connection con = null;
try {
String sqlQuery =
"SELECT friendId, friend_name FROM character_friends WHERE "
+ "charId="
+ _activeChar.getObjectId()
+ " ORDER BY friend_name ASC";
con = L2DatabaseFactory.getInstance().getConnection(con);
PreparedStatement statement = con.prepareStatement(sqlQuery);
ResultSet rset = statement.executeQuery(sqlQuery);
int friendId;
String friendName;
FriendStatus fs;
while (rset.next()) {
friendId = rset.getInt("friendId");
friendName = rset.getString("friend_name");
if (friendId == _activeChar.getObjectId()) continue;
L2PcInstance friend = L2World.getInstance().getPlayer(friendName);
fs = new FriendStatus(0x00030b7a, friendId, friendName, friend != null);
_friends.add(fs);
}
rset.close();
statement.close();
} catch (Exception e) {
_log.warn("Error found in " + _activeChar.getName() + "'s FriendList: " + e);
} finally {
try {
con.close();
} catch (Exception e) {
}
}
}
