Q3 stats
Results 1 to 13 of 13

Thread: Q3 stats

  1. #1
    Registered User
    Join Date
    Aug 2000
    Location
    PA
    Posts
    761

    Post 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.

  2. #2
    Registered User Stalemate's Avatar
    Join Date
    May 2001
    Location
    d4-e5
    Posts
    15,120

    Post

    I like this "custom" page better.

    I'm in the top 50 on that one.

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

  3. #3
    Registered User
    Join Date
    Aug 2000
    Location
    PA
    Posts
    761

    Post

    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

  4. #4
    Registered User MacGyver's Avatar
    Join Date
    Oct 2000
    Location
    Ottawa
    Posts
    4,232

    Post

    V Cool Milenko! I'm #6!

    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.

  5. #5
    Registered User Poseidon's Avatar
    Join Date
    Jan 2001
    Location
    Knoxville, TN USA
    Posts
    1,762

    Post

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

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

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

    Great job Milenko!

  6. #6
    Registered User MacGyver's Avatar
    Join Date
    Oct 2000
    Location
    Ottawa
    Posts
    4,232

    Post

    [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...


  7. #7
    Registered User Draggar's Avatar
    Join Date
    Oct 2000
    Location
    Wolfeboro, NH
    Posts
    2,679

    Post

    Woohoo! I'm #23!

    Looks good, Milenko!

  8. #8
    Registered User
    Join Date
    Aug 2000
    Location
    PA
    Posts
    761

    Post

    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.

  9. #9
    Registered User MacGyver's Avatar
    Join Date
    Oct 2000
    Location
    Ottawa
    Posts
    4,232

    Cool

    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... </strong><hr></blockquote>I was close - I'm #4 in deaths!

  10. #10
    Registered User Poseidon's Avatar
    Join Date
    Jan 2001
    Location
    Knoxville, TN USA
    Posts
    1,762

    Post

    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.
    The early bird may get the worm; but the second mouse gets the cheese!

  11. #11
    Registered User
    Join Date
    Aug 2000
    Location
    PA
    Posts
    761

    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.

  12. #12
    Registered User Poseidon's Avatar
    Join Date
    Jan 2001
    Location
    Knoxville, TN USA
    Posts
    1,762

    Post

    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:



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



    Which appears to be non-existent:




    Hopefully this weekend I will have some time to get in a few frags on your server. Again, great work on your stats.
    The early bird may get the worm; but the second mouse gets the cheese!

  13. #13
    Registered User
    Join Date
    Aug 2000
    Location
    PA
    Posts
    761

    Post

    I hadn't checked the page with Opera

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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •