@Override
public void execute(final L1PcInstance pc, final String cmdName, final String arg) {
try {
final Collection<L1PcInstance> players = L1World.getInstance().getAllPlayers();
final String amount = String.valueOf(players.size());
final S_WhoAmount s_whoamount = new S_WhoAmount(amount);
pc.sendPackets(s_whoamount);
// オンラインのプレイヤーリストを表示
if (arg.equalsIgnoreCase("all")) {
pc.sendPackets(new S_SystemMessage("-- 线上玩家 --"));
final StringBuffer buf = new StringBuffer();
for (final L1PcInstance each : players) {
buf.append(each.getName());
buf.append(" / ");
if (buf.length() > 50) {
pc.sendPackets(new S_SystemMessage(buf.toString()));
buf.delete(0, buf.length() - 1);
}
}
if (buf.length() > 0) {
pc.sendPackets(new S_SystemMessage(buf.toString()));
}
}
} catch (final Exception e) {
pc.sendPackets(new S_SystemMessage("请输入: .who [all] 。"));
}
}
/**
* 储存聊天
*
* @param pc
* @param target
* @param text
* @param type
*/
public void storeChat(
final L1PcInstance pc, final L1PcInstance target, final String text, final int type) {
if (!this.isLoggingTarget(type)) {
return;
}
// type
// 0:一般频道
// 1:Whisper(密语频道)
// 2:大喊频道
// 3:广播频道
// 4:血盟频道
// 11:组队频道
// 13:联盟频道
// 14:聊天队伍频道
Connection con = null;
PreparedStatement pstm = null;
try {
con = L1DatabaseFactory.getInstance().getConnection();
if (target != null) {
pstm =
con.prepareStatement(
"INSERT INTO log_chat (account_name, char_id, name, clan_id, clan_name, locx, locy, mapid, type, target_account_name, target_id, target_name, target_clan_id, target_clan_name, target_locx, target_locy, target_mapid, content, datetime) VALUE (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, SYSDATE())");
pstm.setString(1, pc.getAccountName());
pstm.setInt(2, pc.getId());
pstm.setString(3, pc.isGm() ? "******" : pc.getName());
pstm.setInt(4, pc.getClanid());
pstm.setString(5, pc.getClanname());
pstm.setInt(6, pc.getX());
pstm.setInt(7, pc.getY());
pstm.setInt(8, pc.getMapId());
pstm.setInt(9, type);
pstm.setString(10, target.getAccountName());
pstm.setInt(11, target.getId());
pstm.setString(12, target.getName());
pstm.setInt(13, target.getClanid());
pstm.setString(14, target.getClanname());
pstm.setInt(15, target.getX());
pstm.setInt(16, target.getY());
pstm.setInt(17, target.getMapId());
pstm.setString(18, text);
} else {
pstm =
con.prepareStatement(
"INSERT INTO log_chat (account_name, char_id, name, clan_id, clan_name, locx, locy, mapid, type, content, datetime) VALUE (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, SYSDATE())");
pstm.setString(1, pc.getAccountName());
pstm.setInt(2, pc.getId());
pstm.setString(3, pc.isGm() ? "******" : pc.getName());
pstm.setInt(4, pc.getClanid());
pstm.setString(5, pc.getClanname());
pstm.setInt(6, pc.getX());
pstm.setInt(7, pc.getY());
pstm.setInt(8, pc.getMapId());
pstm.setInt(9, type);
pstm.setString(10, text);
}
pstm.execute();
} catch (final SQLException e) {
_log.log(Level.SEVERE, e.getLocalizedMessage(), e);
} finally {
SQLUtil.close(pstm);
SQLUtil.close(con);
}
}
