need help for ranking

[germania]

I posted it a few time ago, but cant find it :/:

I need help to make a Ranking
Can somebody make a script? or make an tutorial how to do?

Thanks
Your Germania

 

[vinicius.edson]

Yes. You need to have a regular knowledge in php. ^^ If you already have it, go to do it!

 

[germania]

Yes. You need to have a regular knowledge in php. ^^ If you already have it, go to do it!

hmmm not funnytt1:tt1:

Can you or any other person help me with it? because i think im not the only want to have an Ranking

 

[vixio_dv]

no 1 want share this script. lol
thread already posted.

 

[vinicius.edson]

no 1 want share this script. lol
thread already posted.

Yes. Pay any php programmer to do it for you.

 

[rbb138]

there is many different types of ways you can do this, and its not all php.

problem is you cant really package up something this all over the place, or i would release mine...

 

[Hemer]

As i remember you said, that you first readout the logfiles and save that data to mysql. Could you please share that script? The rest I could build and share later.

 

[Romulan]

I found some old files on my backups... I'll release them soon.

Maybe it will help some guys here to make and SHARE a fully working script + a little php page for viewing ranking table... :mellow:

---------- Post added at 11:23 PM ---------- Previous post was at 11:08 PM ----------

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

---------- Post added at 11:27 PM ---------- Previous post was at 11:23 PM ----------

Credits for guys that have shared/made this files in the past...

MarHazK, Thevisad and so on...

---------- Post added at 11:28 PM ---------- Previous post was at 11:27 PM ----------

Instructions added inside the archive for further informations about the files inside the archive...

 

[rbb138]

looked at your script, remember you will need to install lynx if you dont already have it. Also using lynx will break the names of any characters with stars or chineese in them.

it is much more efficient to use the log files for kills and not the red name amount. you can then even block out the kills that caused the people get red name, stopping people farming newbs.

This is the basic linux script i used to create my ranking (

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

)

cd /PWServer/logservice/logs
grep -e ':type=2:' world2.formatlog > kills.formatlog
chmod 777 kills.formatlog
sed -i 's/ /,/g' kills.formatlog
sed -i 's/=/,/g' kills.formatlog
sed -i 's/:/,/g' kills.formatlog
sed -i 's/,,,/,/g' kills.formatlog
sed -i 's/,,/,/g' kills.formatlog
mysqlimport -u root --local --force --columns=date,hour,minute,@x,@x,@x,@x,@x,@x,@x,corpseid,@x,@x,@x,killerid --fields-terminated-by=, pwlogs kills.formatlog
rm kills.formatlog

using this you can then import things like GM logs, trade logs, mail logs, login ip logs... etc

which allows you to create all sorts of control panels for your GMs, such as the one i made for my GM team, built into our forums:

once you have this system you can then make search features to see which player has killed and died to somebody. Which helps bring more fun to pvp.

i wish i could share the scripts that query and present this infomation but its too built into our website for me to release it without infomation from the website or breaking something in it.

 

[Romulan]

omagad 0_0 i'm not a such pro as you >__<

but it would be cool if you can share some scripts...

my friend is gone in holiday so i can't ask to him for his PHP/MySQL skills lol

 

[germania]

okay...

firstly thank you.

We now try to build a ranking.
If it work, i will make an tutorial for it

Because i think im not the only who want this and you all gave me so much so i can give you a little back

greetings
Germania-Hazard perfect World TEAM

---------- Post added at 01:36 PM ---------- Previous post was at 12:18 PM ----------

okay guys...

My Explorer now shows me:
/bla/bla/roledb.jsp

--100% stored RoleDB: Name:xxx Roleid:xx Level:xxx
--100% stored RoleDB: Name:xxx Roleid:xx Level:xxx

x= edited myside

how can i show it now in a html page and sort by lvl?

now it is sorted by roleid

an the next: I need only show Name and Lvl in the table.

 

[Romulan]

Here is two example and it would be cool if you can do this or something that looks like:

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

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

---------- Post added at 01:53 PM ---------- Previous post was at 01:52 PM ----------

And btw, how did you get the chardb.jsp working for you?? 0_0

When i try to run it, it throws me error and don't work...

 

[germania]

Here is two example and it would be cool if you can do this or something that looks like:

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

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

---------- Post added at 01:53 PM ---------- Previous post was at 01:52 PM ----------

And btw, how did you get the chardb.jsp working for you?? 0_0

When i try to run it, it throws me error and don't work...

I make tuto when finish:tongue:
but you can also add my at MSN: [email protected]
and ICQ: 499160075

 

[germania]

so ...

does anybody know how i can make a html side from the jsp?

like the france side from romulan?

 

[Romulan]

Maybe with an "output" string with the JSP script that can be visible...

But i don't have enought of knowledges for help you.. sorry..

----------------------------------------------------------------

If i try to access to the CharDB.jsp:

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

This is what i get:

 

[germania]

be sure the files can find JAVA!!!

follow the instructions inside the readme

i do it

or wait till i post the tutorial together with hemer =)

 

[Romulan]

Fixed path ! (

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

) hehe

But new error...

I think there is a missing java class...

The first one. Because the second one exists but gives the same error anyway <_<

 

[germania]

Fixed path ! (

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

) hehe

But new error...

I think there is a missing java class...

The first one. Because the second one exists but gives the same error anyway <_<

LOOK:

Adress to your Mysql
and i think your Name an Password iss not "Root"

Have you invite the *.sql data to your dbo database?

have you edit the userdb.sh (without it cant import your chars to Mysql)

 

[Romulan]

Yes they are because it's a test server local only tt1: So i don't care about mysql root. More easy for developping.

But of course my good server has a more complex security xDD

I have imported the uwebplayers table and edited userdb.sh

But the userdb.sh requires "lynx" to work well...

 

[germania]

try:
wget install lynx

than start you *.sh script
it says blablabla lynx failed
but dont look ....
than open your adress: /bl/bla/bla/*.jsp in your explorer
and wait a little

so i have done it. Hemer iss writing in this moment a basic ranking script

:8:

if i have a little time.. i posting my .sh and .jsp file for you