Q3 stats

I've started coding my own stats page in php and mysql. It can be viewed at <a href="http://inv.king-nerd.com" target="_blank">inv.king-nerd.com</a>. Right now all you get is a big list sorted by kills, but most of the hard work is done now and I'll be adding features whenever I have time.

Right now page reloads take about 10 seconds because it's actually reloading the list for every request. Very soon I'll be setting it up to reload for only unique request every 10 minutes to keep people from abusing my server :) .

Hopefully this all goes well since sql is much faster than the old stats program and we'll be able to view stats almost realtime.

I like this "custom" page better.

I'm in the top 50 on that one. :D

That's really nice of you, Milenko, to take the time to compile these stats!

OK - page only actually refreshes data on the first request after 15 minutes. So, if no one has been to the page for 15 minutes since the last refresh, then it does it quick before it shows you the results. This takes about 10 extra seconds. This should keep people from abusing the server by refreshing really fast.

Just a note, this page is straight kills only, it does not take deaths into consideration yet. I'm still working on that part :D

V Cool Milenko! I'm #6! :D

This is much simpler than the other stats engine and gets right to the point. The more frequent players go right to the top of the list where they belong. NICE!

If you could also compile deaths, that would be perfect. Then have one page for top fraggers, top fragees, and best differential. But looks great so far, you DA MAN

One other note, when you connect to the Quake3 server, it tells you to go to inv.king-nerd.com for the stats - but that page doesn't redirect to the stats page.

[quote]Originally posted by MacGyver:
<strong>V Cool Milenko! I'm #6! :D

. . ..</strong><hr></blockquote>

Looks like you are no longer running around with a bull's eye painted on your back!

Great job Milenko!

[quote]Originally posted by Poseidon:
<strong>Looks like you are no longer running around with a bull's eye painted on your back</strong><hr></blockquote>

Hee Hee, wait until you see the stats for most deaths. I'll probably be in the top three...

:D

Woohoo! I'm #23!

Looks good, Milenko!

You can now view deaths and well as kills. There is a link on the top of the page to switch between the two. Right now it doesn't see any difference between a death and a suicide, but I'll be working on that next.

I put a redirect in at inv.king-nerd.com, so you can just go there and it will send you over to the stats page.

Excellent job Milenko, looks good! [quote]Originally posted by MacGyver:<strong>Hee Hee, wait until you see the stats for most deaths. I'll probably be in the top three... :D </strong><hr></blockquote>I was close - I'm #4 in deaths!

Great stats page Milenko.

However, it appeard to contain a bad link pointing to deaths from the kills page.

The link points to: <a href="http://inv.king-nerd.com/deaths.php" target="_blank">http://inv.king-nerd.com/deaths.php</a> Instead of <a href="http://inv.king-nerd.com/stats/deaths.php" target="_blank">http://inv.king-nerd.com/stats/deaths.php</a>


Just noticed. . . the link is only bad on the <a href="http://inv.king-nerd.com/stats\kills.php" target="_blank">http://inv.king-nerd.com/stats\kills.php</a>

page {note the backslash after stats} The Redirect from the link in your original post.

[quote]Originally posted by Poseidon:
<strong>Great stats page Milenko.

However, it appeard to contain a bad link pointing to deaths from the kills page.

The link points to: <a href="http://inv.king-nerd.com/deaths.php" target="_blank">http://inv.king-nerd.com/deaths.php</a> Instead of <a href="http://inv.king-nerd.com/stats/deaths.php" target="_blank">http://inv.king-nerd.com/stats/deaths.php</a>


Just noticed. . . the link is only bad on the <a href="http://inv.king-nerd.com/stats\kills.php" target="_blank">http://inv.king-nerd.com/stats\kills.php</a>

page {note the backslash after stats} The Redirect from the link in your original post.</strong><hr></blockquote>


Can you explain a little further on what is happening? I can follow all of the links without a problem. Redirect works fine for me too.

I’ll try. Sorry for the confusion.

I just tried with IE 5.5 and all the links work correctly.

But with <a href="http://www.opera.com/download/" target="_blank">Opera 6.01</a> the following happens starting with your main page: inv.king-nerd.com redirects to inv.king-nerd.com/stats\kills.php

Here’s a screenshot:

http://members.directvinternet.com/~...donx/stat1.jpg

From that page, when you click on the Sort by kill-deaths link it directs you to inv.king-nerd.com/deaths.php

http://members.directvinternet.com/~...donx/stat2.jpg

Which appears to be non-existent:

http://members.directvinternet.com/~...donx/stat3.jpg


Hopefully this weekend I will have some time to get in a few frags on your server. Again, great work on your stats.

I hadn't checked the page with Opera ;)

It's fixed now, apparently Opera doesn't like preceding slashes in a link.