Top Players Online no work HELP !

[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 <

O conteúdo está oculto, favor efetuar login ou se cadastrar!

• Entre
• ou
• Cadastre-se

*/

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

Editado Julho 23, 2016 por medercosmin