[SHARE] Ingame Top players manager!

[Intrepid]

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.

 

Ohh i forgot that :D

Credits to me:)

 

Now its show you:

top 10pvp

top 10pk

top 10Level

If its working properly i will add more stuff to it

 

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

[Lupanu]

nice share.. testing

[CriticalError]

ofc intrepid always maked exelent code congrataulations man you are good in java :P

[Chandy]

Nice Intrepid,but i have a question...

How to add this in the server interlude ???

Can i to use only the java decompiler and it's works ???

Thx in advanced.

[Intrepid]

Nice Intrepid,but i have a question...

How to add this in the server interlude ???

Can i to use only the java decompiler and it's works ???

Thx in advanced.

never use java decompiler use eclipse than insert the file change the imports if you need and thats all spawn the npc ingame and you see

[Chandy]

never use java decompiler use eclipse than insert the file change the imports if you need and thats all spawn the npc ingame and you see

Thx for reply man,but any ideia for to insert this modification in the interlude pack already compiled ???

In the gameserver have this files in .jar :

But i don't know how to insert >.< .

Help-me plz =\.

[Frank]

I am going to test it. If it works you will have +1 from me. Thanks

[Intrepid]

Thx for reply man,but any ideia for to insert this modification in the interlude pack already compiled ???

In the gameserver have this files in .jar :

But i don't know how to insert >.< .

Help-me plz =\.

 

You need the source code not the jar files:)

[Chandy]

I am going to test it. If it works you will have +1 from me. Thanks

No problem man,i just want to use this great mod in my server Interlude  =\.

[StarChild]

Any instructions how to port this for L2JFree? :)

 

Thank you.

[Dimis4]

I made the code compatible with l2j interlude . Compiled the source with no problem but ingame npc says: 'i have nothing to tell you.'

Now checking on l2jct2.2

[Intrepid]

I made the code compatible with l2j interlude . Compiled the source with no problem but ingame npc says: 'i have nothing to tell you.'

Now checking on l2jct2.2

 

Thanks for test i make some test too and i find out whats the error.

[Chandy]

Thx fakoykas for tests =\ .

[Intrepid]

working for me working for dimis...also working for my friends...

 

and WTF i NEVER post non working code...that code needs only a html file thats true i forget that...

[Lupanu]

tested on l2jfree Ct2.2.. and it works.. +1 intrepid..