medercosmin

Acis server * * This program is free software: you can redistribute it and/or modify it under * the terms of the GNU General Public License as published by the Free Software * Foundation, either version 3 of the License, or (at your option) any later * version. * * This program is distributed in the hope that it will be useful, but WITHOUT * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more * details. * * You should have received a copy of the GNU General Public License along with * this program. If not, see <[Hidden Content];. */ package net.sf.l2j.gameserver.communitybbs.customs; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.HashMap; import java.util.Map; import net.sf.l2j.Config; import net.sf.l2j.L2DatabaseFactory; import net.sf.l2j.gameserver.cache.HtmCache; import net.sf.l2j.gameserver.communitybbs.Manager.BaseBBSManager; import net.sf.l2j.gameserver.model.L2World; import net.sf.l2j.gameserver.model.actor.instance.L2PcInstance; /** * @author Leki * */ public class OnlinePlayers extends BaseBBSManager { int pos = 0; public static OnlinePlayers getInstance() { return SingletonHolder._instance; } @Override public void parseCmd(String command, L2PcInstance activeChar) { if (command.equals("_bbshome")) { showPlayers(activeChar); } else { super.parseCmd(command, activeChar); } } private static void showPlayers(L2PcInstance player) { StringBuilder _players = new StringBuilder(); String content = HtmCache.getInstance().getHtm("data/html/CommunityBoard/OnlinePlayers.htm"); int pos = 0; Connection con = null; try { pos = 0; con = L2DatabaseFactory.getInstance().getConnection(); PreparedStatement statement = con.prepareStatement("SELECT characters.char_name, characters.`level`, characters.pvpkills, characters.pkkills, characters.classid, characters.`online`, characters.onlinetime FROM characters WHERE characters.`online` = 1 ORDER BY characters.onlinetime ASC LIMIT " + Config.TOP_PLAYER_RESULTS); ResultSet result = statement.executeQuery(); while (result.next()) { pos++; _players.append("<table border=0 cellspacing=0 cellpadding=2 height=" + Config.TOP_PLAYER_ROW_HEIGHT + " width=440><tr>"); _players.append("<td FIXWIDTH=25>" + pos + "</td>"); _players.append("<td FIXWIDTH=160>" + result.getString("characters.char_name") + "</td>"); _players.append("<td FIXWIDTH=145 align=center>" + className(result.getInt("characters.classid")) + "</td>"); _players.append("<td FIXWIDTH=100 align=center>" + result.getInt("characters.onlinetime") + "</td>"); _players.append("</tr></table><img src=\"L2UI.Squaregray\" width=\"440\" height=\"1\">"); } result.close(); statement.close(); } catch (Exception e) { e.printStackTrace(); } finally { try { con.close(); } catch (Exception e) { } } content = content.replaceAll("%showList%", _players.toString()); content = content.replaceAll("%online%", String.valueOf(L2World.getInstance().getPlayers().size())); separateAndSend(content, player); } public final static String className(int classid) { Map<Integer, String> classList; classList = new HashMap<>(); classList.put(0, "Fighter"); classList.put(1, "Warrior"); classList.put(2, "Gladiator"); classList.put(3, "Warlord"); classList.put(4, "Knight"); classList.put(5, "Paladin"); classList.put(6, "Dark Avenger"); classList.put(7, "Rogue"); classList.put(8, "Treasure Hunter"); classList.put(9, "Hawkeye"); classList.put(10, "Mage"); classList.put(11, "Wizard"); classList.put(12, "Sorcerer"); classList.put(13, "Necromancer"); classList.put(14, "Warlock"); classList.put(15, "Cleric"); classList.put(16, "Bishop"); classList.put(17, "Prophet"); classList.put(18, "Elven Fighter"); classList.put(19, "Elven Knight"); classList.put(20, "Temple Knight"); classList.put(21, "Swordsinger"); classList.put(22, "Elven Scout"); classList.put(23, "Plains Walker"); classList.put(24, "Silver Ranger"); classList.put(25, "Elven Mage"); classList.put(26, "Elven Wizard"); classList.put(27, "Spellsinger"); classList.put(28, "Elemental Summoner"); classList.put(29, "Oracle"); classList.put(30, "Elder"); classList.put(31, "Dark Fighter"); classList.put(32, "Palus Knightr"); classList.put(33, "Shillien Knight"); classList.put(34, "Bladedancer"); classList.put(35, "Assasin"); classList.put(36, "Abyss Walker"); classList.put(37, "Phantom Ranger"); classList.put(38, "Dark Mage"); classList.put(39, "Dark Wizard"); classList.put(40, "Spellhowler"); classList.put(41, "Phantom Summoner"); classList.put(42, "Shillien Oracle"); classList.put(43, "Shilien Elder"); classList.put(44, "Orc Fighter"); classList.put(45, "Orc Raider"); classList.put(46, "Destroyer"); classList.put(47, "Orc Monk"); classList.put(48, "Tyrant"); classList.put(49, "Orc Mage"); classList.put(50, "Orc Shaman"); classList.put(51, "Overlord"); classList.put(52, "Warcryer"); classList.put(53, "Dwarven Fighter"); classList.put(54, "Scavenger"); classList.put(55, "Bounty Hunter"); classList.put(56, "Artisan"); classList.put(57, "Warsmith"); classList.put(88, "Duelist"); classList.put(89, "Dreadnought"); classList.put(90, "Phoenix Knight"); classList.put(91, "Hell Knight"); classList.put(92, "Sagittarius"); classList.put(93, "Adventurer"); classList.put(94, "Archmage"); classList.put(95, "Soultaker"); classList.put(96, "Arcana Lord"); classList.put(97, "Cardinal"); classList.put(98, "Hierophant"); classList.put(99, "Evas Templar"); classList.put(100, "Sword Muse"); classList.put(101, "Wind Rider"); classList.put(102, "Moonlight Sentinel"); classList.put(103, "Mystic Muse"); classList.put(104, "Elemental Master"); classList.put(105, "Evas Saint"); classList.put(106, "Shillien Templar"); classList.put(107, "Spectral Dancer"); classList.put(108, "Ghost Hunter"); classList.put(109, "Ghost Sentinel"); classList.put(110, "Storm Screamer"); classList.put(111, "Spectral Master"); classList.put(112, "Shillien Saint"); classList.put(113, "Titan"); classList.put(114, "Grand Khavatari"); classList.put(115, "Dominator"); classList.put(116, "Doomcryer"); classList.put(117, "Fortune Seeker"); classList.put(118, "Maestro"); return classList.get(classid); } private static class SingletonHolder { protected static final OnlinePlayers _instance = new OnlinePlayers(); } } pls edit files for work, show top players online no all pleyers

change language port. for eng?