/* 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 <http://www.gnu.org/licenses/>.
 */
package net.sf.l2j.gameserver.model.actor.instance;

import java.sql.PreparedStatement;
import java.sql.ResultSet;

import javolution.text.TextBuilder;

import net.sf.l2j.L2DatabaseFactory;
import net.sf.l2j.gameserver.network.serverpackets.NpcHtmlMessage;
import net.sf.l2j.gameserver.templates.chars.L2NpcTemplate;


/**
 * Stat Manager
 * 
 * @author Intrepid
 */

public class L2StatManagerInstance extends L2FolkInstance
{

	public L2StatManagerInstance(int objectId, L2NpcTemplate template)
	{
		super(objectId, template);
	}
	
	@Override
	public void onBypassFeedback(L2PcInstance player, String command)
	{
		if (command.startsWith("TopPvp"))
		{
		      java.sql.Connection con = null;
		      try
		      {
		      	con = L2DatabaseFactory.getInstance().getConnection();
		        PreparedStatement statement;
		        statement = con.prepareStatement("SELECT char_name,pvpkills FROM characters where accesslevel = 0 order by pvpkills DESC LIMIT 10;");
		        ResultSet rset = statement.executeQuery();        
		        while(rset.next())
		        {
		        	NpcHtmlMessage html = new NpcHtmlMessage(getObjectId());
		        	TextBuilder sb = new TextBuilder();
		        	sb.append ("Character: "+rset.getString("char_name")+" ("+rset.getInt("pvpkills")+" kills");
		        	html.setHtml(sb.toString());
                    player.sendPacket(html);
	    	    }
	    	    rset.close();
	          statement.close();
	          con.close();
	    	  }
	    	  catch (Exception e)
	    	  {
	    	  	e.printStackTrace();
	    	  }
		}
		if (command.startsWith("TopPk"))
		{
		      java.sql.Connection con = null;
		      try
		      {
		      	con = L2DatabaseFactory.getInstance().getConnection();
		        PreparedStatement statement;
		        statement = con.prepareStatement("SELECT char_name,pkkills FROM characters where accesslevel = 0 order by pkkills DESC LIMIT 10;");
		        ResultSet rset = statement.executeQuery();
		        while(rset.next())
		        {
		        	NpcHtmlMessage html = new NpcHtmlMessage(getObjectId());
		        	TextBuilder sb = new TextBuilder();
		        	sb.append ("Character: "+rset.getString("char_name")+" ("+rset.getInt("pkkills")+" kills");
		        	html.setHtml(sb.toString());
                    player.sendPacket(html);
	    	    }
	    	    rset.close();
	          statement.close();
	          con.close();
	    	  }
	    	  catch (Exception e)
	    	  {
	    	  	e.printStackTrace();
	    	  }
		}
		if (command.startsWith("TopLvl"))
		{
		      java.sql.Connection con = null;
		      try
		      {
		      	con = L2DatabaseFactory.getInstance().getConnection();
		        PreparedStatement statement;
		        statement = con.prepareStatement("SELECT char_name,level FROM characters where accesslevel = 0 order by level DESC LIMIT 10;");
		        ResultSet rset = statement.executeQuery();
		        while(rset.next())
		        {
		        	NpcHtmlMessage html = new NpcHtmlMessage(getObjectId());
		        	TextBuilder sb = new TextBuilder();
		        	sb.append ("Character: "+rset.getString("char_name")+" ("+rset.getInt("level")+" level");
		        	html.setHtml(sb.toString());
                    player.sendPacket(html);
	    	    }
	    	    rset.close();
	          statement.close();
	          con.close();
	    	  }
	    	  catch (Exception e)
	    	  {
	    	  	e.printStackTrace();
	    	  }
		}
	}
}