Announcement

Collapse
No announcement yet.

Public Statistics

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Public Statistics

    I'm proud to announce that the Public Statistics project is finished and released!

    Public Statistics
    The Public Statistics project (shortly named pubstats) is a project to make our own scores website.

    The old scores website, as we all know, has been gone for some time now. I figured that our bots can gather scores from the public arenas and publish it to a website. As a bonus it would be possible to generate all kinds of other statistics (like a graph on how many players are from a specific country).
    To make things complex I also added the ability of keeping scores per ship. This way someone can be elite in the warbird while his overall score doesn't reflect it.

    The project started with a database schema and a rough bot design. Alinea (<ER>) took on the job of creating the website while I worked on the bot(s). Unfortunately I underestimated the bot work. It took me a while to get the work done on the bots. Meanwhile Alinea <ER> did a great job and completed the website part.
    I thought I had the bot(s) done but it didn't perform and work properly. I had to redesign the bots which unfortunately took quite a while.

    Once I was done with the bots, I couldn't restrain myself and improved the website to what I wanted it to be. A number of graphs were added and a page to display the top rankings on a scorereset.


    Go take a look and let me know what you think!
    (Click link above)

    If you have any ideas for improvements, bugs or other comments, let me know.

    Note: The statistics on the website are updated every 15 minutes (the bots save every 15 minutes).


    Special thanks to alinea <ER> for creating the initial web pages and design ^-^
    Last edited by Maverick; 11-22-2008, 09:06 AM.
    Maverick
    Retired SSCU Trench Wars Super Moderator
    Retired SSCU Trench Wars Bot Coordinator
    Retired Trench Wars Core Administrator
    Subspace Statistics Administrator
    Former Mervbot plugin developer

  • #2
    A bit of information about the calculation of Rating and Average (if you didn't know yet):

    Rating
    Rating is calculated as follows:
    Rating = (kill points * 10 + (wins - losses) * 100) / (wins + 100)


    Averge
    Average is calculated as follows:
    Average = (kill points) / kills

    Average is basically the average number of points you get from a kill.
    Last edited by Maverick; 11-27-2008, 03:33 AM.
    Maverick
    Retired SSCU Trench Wars Super Moderator
    Retired SSCU Trench Wars Bot Coordinator
    Retired Trench Wars Core Administrator
    Subspace Statistics Administrator
    Former Mervbot plugin developer

    Comment


    • #3
      wow amazing
      the player search feature is pretty neat
      good job on this guys :wub:

      Comment


      • #4
        wow fucking amazing
        Devest.proboards.com

        2:Lance> OMG
        2:Lance> BCG is afking in my arena
        2:Master of Dragons> you got steve'd


        Creator/Co-Creator of:

        ?go Prisonbreak, Twcountry, Hathunt, Treehunt, Birthday, Divbase, Defense, Devest, Trifecta, CSDOM, Brickbase, Sharkball, HateBase, Hatetf, Assassin, JavTerror, JavHunt, XmasZombies.

        New Maps are in production...

        Comment


        • #5
          That's pretty damn sexy
          DELETED

          Comment


          • #6
            Awesome job guys.
            (ZaBuZa)>sigh.. i been playing this game since i was 8... i am more mature then ull ever be...

            Comment


            • #7
              awesome
              the palyer search feature is great and there are screenshots of us all gj
              Making your mark on the world is hard. If it were easy, everybody would do it. But it's not. It takes patience, it takes commitment, and it comes with plenty of failure along the way. The real test is not whether you avoid this failure, because you won't. it's whether you let it harden or shame you into inaction, or whether you learn from it; whether you choose to persevere.:fear:

              Comment


              • #8
                This reminds me of when i had canned bread for the first time...


                It's sooo good
                6:Screamo> this sub is making my leg twitch
                6:LMAO> subway is kinda shady nowdays
                6:Screamo> err
                6:Screamo> subwoofer*

                1:Krazie <ER>> crap
                1:Krazie <ER>> i get one less hour of sleep
                1:Krazie <ER>> freaking DST
                1:bioture> at least my car clock will finally be correct

                (ignite)>There is a new currency on the market, the IGNITE

                Comment


                • #9
                  looks good, glad to see the return of published pub stats! can you display stats by squads, like the old site did? also, can you add a column for W:L ratio?

                  Comment


                  • #10
                    ratio ftw
                    The above text is a personal opinion of an individual and is not representative of the statements or opinions of Trench Wars or Trench Wars staff.

                    SSCJ Distension Owner
                    SSCU Trench Wars Developer


                    Last edited by Shaddowknight; Today at 05:49 AM. Reason: Much racism. So hate. Such ban. Wow.

                    Comment


                    • #11
                      OMG it even shows your friggin USAGE and the date the name was created. THAT'S F'ING SCARY. BIG BROTHER IS WATCHING YOU.

                      Btw. When sorting stats by certain things like by kill points or average, it throws the table off the boundaries. Just cosmetics. Other than that it's damn sexy.
                      Last edited by MaGi kOz; 11-22-2008, 02:28 AM.

                      Comment


                      • #12
                        would it be possible to add a #13 or whatever to the usage page?

                        USAGE RANKINGS FTW $$$$$$$$$$$$$
                        The above text is a personal opinion of an individual and is not representative of the statements or opinions of Trench Wars or Trench Wars staff.

                        SSCJ Distension Owner
                        SSCU Trench Wars Developer


                        Last edited by Shaddowknight; Today at 05:49 AM. Reason: Much racism. So hate. Such ban. Wow.

                        Comment


                        • #13
                          The site is amazing.

                          I want to take two weeks off just to be #1! B)
                          Less QQ More pew pew

                          Comment


                          • #14
                            gotta say, been poking around the new stuff, and its pretty fucking amazing...


                            i noticed sometimes someone wanted the graphs to be horizontal, and that sucks, especially with the banner and resolution ones, make those vertical, if not all...

                            usage rankings are cool, and i guess im #54 in usage X_x

                            and my dead squad is still pretty huge, if im halfway on that list...



                            THIS IS EPIC WIN OF MASSIVE PROPORTIONS
                            The above text is a personal opinion of an individual and is not representative of the statements or opinions of Trench Wars or Trench Wars staff.

                            SSCJ Distension Owner
                            SSCU Trench Wars Developer


                            Last edited by Shaddowknight; Today at 05:49 AM. Reason: Much racism. So hate. Such ban. Wow.

                            Comment


                            • #15
                              These are so well done, All the stats are so interesting, LIke countries Graph and usage, banners . Nicely done
                              https://soundcloud.com/annux-1/annux-relief

                              1:Wah!!>THE WAY I FEEL FOR YOUUU HOHOHOHOOH OHOHO
                              1:Wah!!>OH OH OH OH OH OH OOOHH
                              1:Wah!!>I dont worry cause
                              1:soild <ZH>>EVERYHTINGS GONNA BE ARLIGFHT
                              1:Wah!!>people keep on talking
                              1:soild>they can say what they like
                              1:Wah!!>ALL I know is:
                              1:soild>EVERYTHINGS GONNA BE ALRIGHT

                              Comment

                              Working...
                              X