making a ranking

[germania]

how i can make a ranking of my server?

i need a player Ranking with:

Position | Name | LvL | Guild

und a Guild Ranking


iss it posibble?

[MentaL]

[Romulan]

Idk really, nobody have released a script for this...

I know it uses both PHP and JSP.

The PHP script shows the results and JSP script gets infos in the roles database.


Maybe someone can share to us the two scripts? It would be very nice

[hrace009]

how i can make a ranking of my server?

i need a player Ranking with:

Position | Name | LvL | Guild

und a Guild Ranking


iss it posibble?

i think it posible, as long you have basic PHP or Java

[nofxpunkerbrian]

Try instead of java use your logs files theres alot of pk stuff in there i believe robb from devastation done this its very good job.

[germania]

i dont know anything about it

pls post the two things with tutorial

[nofxpunkerbrian]

Just break down your log files and have a script that adds the ifnormation into sql db simple as that.

[rbb138]

i made one using mysqlimport from log files.
then also import character names etc from the server database using the list characters script in pwadmin

http://mmodevastation.com/3/top.html

[germania]

can u post the scripts pls?

[Romulan]

i made one using mysqlimport from log files.
then also import character names etc from the server database using the list characters script in pwadmin

http://mmodevastation.com/3/top.html

Others examples here:
http://www.pwfrance.com/menu/top_genova#main (top player)
http://www.pwfrance.com/menu/top_pvp_genova#main (top PK)

Auto refresh every night at 4:00am

But idk how make this xDD n_n

[germania]

dont need exemples

need the scripts

[rbb138]

im not giving you the direct script becuase its in so many different places it would be difficult to package a working version.

but ill tell you how to do it.

get used to the grep and seh bash commands, then write a mysqlimport command to import your logs into mysql, logs contain infomation about kills.

then you will need some sort of way to count up these logs into ammounts of kills for a top pk table.

then you will need to use pwadmins character viewing feature to export your character list and import it into mysql.

once you have all of this you can design a website to view and query the mysql kills database.

or atleast, this is the way i did it, and it works nicely.
players can view who killed them with timestamp and who they killed.
also using the logs you can make it so that if they get red name from the kill (killing a low level 1) they dont get a count in the logs, becuase it will turn to type=258 instead of the normal type=2

anybody with google and a little bit of php knowlage could make this.

[loko9988]

My top without guild.
Tell me how get name of guild from database?
And i wrote and shared script.

[rbb138]

you will need to play with the .jsp gdelivery commands in iweb/pwadmin

maybe theres one for guild i dunno.

[Romulan]

/pwAdmin/role.jsp

...
spouse = "";
faction = "";
...

I found this somewhere around line 522 .... (i'm using notepad++)
---------------------------------------

...
//out.println("<tr><td colspan=\"2\"><b>Spouse:</b></td><td colspan=\"2\">" + spouse + "</td></tr>");
//out.println("<tr><td colspan=\"2\"><b>Faction:</b></td><td colspan=\"2\">" + faction + "</td></tr>");
...

And this around line 867 ...

Maybe it can help you...
---------------------------------------

And you should take a look at the GameDB java class in the /pwAdmin/WEB-INF/classes/protocol/ folder !