need help for ranking

ranking

sry, had not that much time, but here it is.
It's only a basic ranking, so you have to take aminute to customise it.

screenshot:

germania - need help for ranking - RaGEZONE Forums


download link:


when got some more time, I'll release a guildranking too.


Hendrik
 
Last edited:
Re: ranking

sry, had not that much time, but here it is.
It's only a basic ranking, so you have to take aminute to customise it.

screenshot:

germania - need help for ranking - RaGEZONE Forums


download link:


when got some more time, I'll release a guildranking too.


Hendrik

please, what is the password to extract?
 
Hey plz, share how did you got it working for you :glare:

It's not fair to say "wooooot i sucess!!!" without share your experience...

What's your problem romu?

Does this only display a certain number of 'top players' (ie... 50) or will it rank all server characters ?

This ranking displays all players from rank 1 to ---.

But I'll can give u a little fix to make a top-- rank.
Just tell me if you need it.



Hendrik
 
And how to retrieve char info from PHP? Log file only give char ID, and based on pwAdmin source the only way to get it is using Java RPC (it's defined on PW protocol files stored on /PWServer/authd/protocol/)

If somebody can lead the way to retrieve char info using PHP, i'll release it along with log retriever that works without lynx (so far i can only display the char ID taken from logs, got nowhere to get the char name, level, etc)
 
My only problem is that I cannot remember exactly what I did to get it working (to be honest). So now I am going to have to start fresh so I can make a tut, and/or I am going to 'pack' it into a 'release' for everyone ;)

I also plan on making some minor modifications, such as making the list 'auto-refresh'. For some reason (at least in my version) the 'website' refreshes every 30 seconds, but the list itself does not; so I think I am going to work on a way for the list to 'auto-refresh' as well.

Either way gave me a little time, and I will have a tutorial and or a release ;)

---------- Post added at 11:22 AM ---------- Previous post was at 11:17 AM ----------

What's your problem romu?



This ranking displays all players from rank 1 to ---.

But I'll can give u a little fix to make a top-- rank.
Just tell me if you need it.



Hendrik

(I apologize I am a novice when it comes to PHP, but) Is there maybe any way possible we could work that into a configuration line, so people can chose the exact number of top players displayed ?
 
I also plan on making some minor modifications, such as making the list 'auto-refresh'. For some reason (at least in my version) the 'website' refreshes every 30 seconds, but the list itself does not; so I think I am going to work on a way for the list to 'auto-refresh' as well.

The userdb.sh must be refreshed before the ranking.php is refreshed...

Because this script gets data from roles logs... Then "dump" it with the chardb.jsp into the uwebplayer table...

After it's dumped, the ranking.php can be refreshed to get new data from the table...

Becareful if you have too many roles on your server!! It will takes a lot of cpu usage at every refresh...

For auto refreshing the userdb.sh script, it can be done with /etc/crontab on your linux OS...
 
Nice release! Can you release a tutorial how to setup the 'chardb.jsp' and 'userdb.sh' plz? ^^'


Romulan... once again...

INSTRUCTIONS:

1. Import the 'uwebplayers.sql' into your 'dbo' database...
2. Configure the database password and user to make the 'chardb.jsp' connecting to the database correctly.
3. Edit the 'userdb.sh' for set your java path. (ex: /usr/share/java -> /usr/java/jdk1.5/jre)
3a. Edit the 'userdb.sh' for set your server IP to connect to tomcat...
(ex: -> )
4. Put the 'chardb.jsp' in this folder -> apache-tomcat-5.5.28/webapps/iweb/role/
4a. Make folders if needed or doesn't exist...

ISSUE:
I can't find anywhere the "lynx" class... It seems to be important for dumping the roles database into the uwebplayers table.

type: wget install lynx
give all your files 777

i think you have only the java problem... you can also type :
/usr/java/jdk1.6.2-45/jre or anything else, but it have to be there!!!!

please write whats up, when you done

greetings
Hemer&Germania
 
./userdb.sh
Code:
Exception in thread "main" java.lang.NoClassDefFoundError: lynx
Caused by: java.lang.ClassNotFoundException: lynx
        at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:303)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:316)
Could not find the main class: lynx.  Program will exit.

This is what i get... :glare:

See my previous posts about the second issue with my :sleep:

JDK 1.6 = Installed!
All PW needed libraries = OK!
Lynx = Installed!
Tomcat = Installed!
XAMPP = Installed!
 
./userdb.sh
Code:
Exception in thread "main" java.lang.NoClassDefFoundError: lynx
Caused by: java.lang.ClassNotFoundException: lynx
        at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:303)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:316)
Could not find the main class: lynx.  Program will exit.

This is what i get... :glare:

See my previous posts about the second issue with my :sleep:

JDK 1.6 = Installed!
All PW needed libraries = OK!
Lynx = Installed!
Tomcat = Installed!
XAMPP = Installed!


Do not focus on userdb.sh, or lynx right now, trust me when I say they're not important. We Do need to figure out why your chardb.jsp is not working, as that is vital to this whole package working!

I plan on releasing a package when I receive an update from Hemer that includes a config line for being able to set exactly how many lines / top players that it will display. Unfortunately I cannot make a tutorial as there are too many little tedious changes that I have made, that it would certainly be much easier to just release as a package.

However if your chardb.jsp isn't working now, I do not think that my package (or any tutorial) will change that; so we must find out why your chardb.jsp is not functioning!

---------- Post added at 03:52 AM ---------- Previous post was at 03:19 AM ----------

is your database called "dbo" ??? (first thing that popped into my mind)

{you said you properly imported the "uwebplayers.sql", and your MySQL UN & PW are both root as it's only your test server}

if it's not called "dbo" you would have to change that in the following line within chardb.jsp:

("jdbc:mysql://localhost:3306/dbo?useUnicode=true&characterEncoding=utf8", "root", "root");

---------- Post added at 03:58 AM ---------- Previous post was at 03:52 AM ----------

If that's not it, keep looking at possible issues with the .jsp (not) connecting to the MySQL database, as I really think and feel that's where the problem lies. (ie... make sure user root is allowed access permissions from any host)
 
Back