Ingame Top players manager! L2J

[Lupu]

This share is hmm how can i say basic website php scripts but ingame!
Its untested so plz give me some feedback

Insert the code into net.sf.l2j.gameserver.model.actor.instance and name it as L2StatManagerInstance.java

Then make a new npc with the type L2StatManager.

Now its show you:
top 10pvp
top 10pk
top 10Level

All credits to Intrepid

/* 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();
	    	  }
		}
	}
}

 

[pRomeo]

Nice, very usefull.

 

[Rin4a]

good work, but it can be done in a more simple way - python
no need to compile anything or so, just make changes and reload the quest without restarting the server

 

[DaRkAnGeL]

good work, but it can be done in a more simple way - python
no need to compile anything or so, just make changes and reload the quest without restarting the server

it is better when you do not want to reload - check your database

 

[Viruzzz]

i need one example for database
thx

 

[DF08Said]

very good and is there an HTML one aswell =O?

 

[theone_l2j]

it is better when you do not want to reload - check your database

datapack-side is better most times for custom things like that bacause core changes can prevent your patches from applying.

 

[theone_l2j]

i need one example for database
thx

Take a look at the high level quests, there are tons of examples
If you cant find there there are a few tutorials on

To view the content, you need to sign in or register

 

[H1tm4nLT]

hello im new to this, and i have a few questions:

where is the " net.sf.l2j.gameserver.model.actor.instance"?
what do i need to rename to "L2StatManagerInstance.java"?
will i need a html file for my NPC?

thats all

please answer

P.S im using L2j Free CT2-2

 

[FreeSpells]

good thing, but i need it for l2emu and in "quest" format

 

[ownagekilla666]

I have compiled my sources and I have an NPC spawned ingame with type L2StatManager. But how to have that npc display the stats? It needs some html? Or there is some link someone has that i need to make a button for to show top players?

 

[vBandiTv]

ty very much! very usefull thing!

 

[ownagekilla666]

How do you get the HTML on the npc to show?