private void updateOwnerInDB() {
L2Clan clan = getOwnerClan();
int clanId = 0;
if (clan != null) {
clanId = clan.getClanId();
_lastOwnedTime = System.currentTimeMillis();
} else _lastOwnedTime = 0;
Connection con = null;
try {
con = L2DatabaseFactory.getInstance().getConnection(con);
PreparedStatement statement;
statement =
con.prepareStatement(
"UPDATE fort SET owner=?, lastOwnedTime=?, state=?, castleId=? WHERE id = ?");
statement.setInt(1, clanId);
statement.setLong(2, _lastOwnedTime);
statement.setInt(3, 0);
statement.setInt(4, 0);
statement.setInt(5, getFortId());
statement.execute();
statement.close();
// ============================================================================
// Announce to clan memebers
if (clan != null) {
clan.setHasFort(getFortId()); // Set has fort flag for new owner
SystemMessage sm;
sm = new SystemMessage(SystemMessageId.S1);
sm.addString(clan.getName() + " победил в битве за форт " + getName());
Collection<L2PcInstance> pls = L2World.getInstance().getAllPlayers();
for (L2PcInstance player : pls) player.sendPacket(sm);
clan.broadcastToOnlineMembers(new PledgeShowInfoUpdate(clan));
clan.broadcastToOnlineMembers(new PlaySound(1, "Siege_Victory", 0, 0, 0, 0, 0));
ThreadPoolManager.getInstance()
.scheduleGeneral(
new FortUpdater(clan, 1), 3600000); // Schedule owner tasks to start running
}
} catch (Exception e) {
_log.warn("Exception: updateOwnerInDB(L2Clan clan): " + e.getMessage());
e.printStackTrace();
} finally {
try {
con.close();
} catch (Exception e) {
_log.warn("" + e.getMessage());
e.printStackTrace();
}
}
}
private void adminAtmosphere(String type, String state, L2PcInstance admin) {
L2GameServerPacket packet = null;
if (type.equals("signsky")) {
if (state.equals("dawn")) packet = new SSQInfo(2);
else if (state.equals("dusk")) packet = new SSQInfo(1);
} else if (type.equals("sky")) {
if (state.equals("night")) packet = SunSet.STATIC_PACKET;
else if (state.equals("day")) packet = SunRise.STATIC_PACKET;
else if (state.equals("red")) packet = new ExRedSky(10);
} else admin.sendMessage("Используйте: //atmosphere <signsky dawn|dusk>|<sky day|night|red>");
if (packet != null)
for (L2PcInstance player : L2World.getInstance().getAllPlayers()) player.sendPacket(packet);
}
public void run() {
int currentOnline =
(int) (L2World.getInstance().getAllPlayers().size() * Config.ONLINE_PLAYERS_MULTIPLIER);
if (currentOnline == 1) {
Announcements.getInstance().announceToAll("Сейчас 1 игрок в игре.");
} else {
Announcements.getInstance()
.announceToAll("Сейчас " + currentOnline + " игрока(ов) в игре.");
}
if (Config.ONLINE_PLAYERS_ANNOUNCE_INTERVAL > 0)
ThreadPoolManager.getInstance()
.scheduleGeneral(new AnnounceOnline(), Config.ONLINE_PLAYERS_ANNOUNCE_INTERVAL);
}
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) {
}
}
}