It is currently Sun Jan 20, 2019 7:39 am



Post new topic Reply to topic  [ 8 posts ] 
Author Message
 Post subject: Republic Commando Stats Application
PostPosted: Fri May 02, 2014 1:06 am 
Offline
RepCom Mapper
RepCom Mapper
User avatar

Joined: Thu Aug 14, 2008 12:09 am
Posts: 7194
I assume most of you already noticed the website Storm and Vash have put online to display player stats from our Republic Commando matches. If you havent seen it yet, here's the link: http://tx-gaming.net/server/1337/

I thought a while about the ranking system there and ended up having an own idea how to calculate the rankings properly, so I recently wrote a small tool to retrieve data from the website and re-order/calculate it.

Once I had done that, I thought it would be a nice idea to save the data once a day in a database so a detailed player development and other stats can be shown too.

While every time you change your name a little bit (or completely) you are getting a new profile on the stats website, you only get one main account in my server application which is then linking your alternative names to that account. All your data is going to be saved in just one account/name.

I kept having more ideas for the application, so when I felt a little bored and had time left I continued to improve the app and add more features to it. Now I got a working first version which you guys can use too, if you want.

Before you start the "the game is dead why do you even bother" posts, I havent really done this "for RepCom" but as practice, and why not do something with the stats. :)

Here are some screenshots and further information, a download link will follow later, I have to create a small setup first.

When you see the screenshot you will notice two categories in the beginning, "Top Players" and "All Players".

Top Players are "ranked" players who have played at least the average amount of matches from all players together. This prevents inactive players who win 1-2 matches from being on top of the list.

All players is simply a full list, regardless how many matches someone played (except for a small amount that goes in the stats calculation, more details later).

Here is an explanation what the stats mean:
Rank: Obvious, no explanation needed.
Name: Same.
Clan: My app is able to link players to a clan, so the category "Clans" which I will show later is the same as players, but with clans.
W/L: Win/Loss Ratio
Scores: Total flags captured
OppScores: Total flag captures of the opponent team
S/Match: Flags per match
OppS/Match: Opponent flags per match
S/Time: Average time to score the flag once
K/D: Kill/Death Ratio
Kills: <--
Deaths: <--
K/Match: Kills per match
D/Match: Deaths per match
KPM: Kills per minute
Wins: <--
Losses: <--
Total: Total amount of matches
Time: Total time played
Ø Time: Average time per match
L10: Last 10 matches (wins-losses)
Streaks: Longest win and losing streak
Last seen: <--
To be ranked: Matches above or under the average to count as ranked "top" player, + means how many matches you can miss without getting unranked. If you are -1, you need 1 more match to be ranked

The stats can be sorted by clicking on the name of a certain category.


Here is the screenshot, please note that the data of my name is not 100% correct because I got one test match reported, this one will be removed so he data is going to be correct in the next update. However, this only changes my KPM and time played. All other data is correct.
Hidden content:
Image


Okay, now you probably think "way too much numbers and information, cant have a good look at it". So let me tell you, when you click on preferences in the left top corner you can chose your settings that you want to be shown. As seen in the next screenshots.
Hidden content:
Image
Image
Image
Image
Image


Before we move to the clans, you should know that right clicking the player column (same for clans) will open a window with detailed information and a drawn graph to display the player development.

Examples:
Hidden content:
Image
Image
Image



I guess it's time to move to the clans now. Now that you know most of the app, the screenshots will be enough.
Hidden content:
Image
Image
Image



Let me show you the matches really quick, again, you can select which data you want to be shown.
Hidden content:
Image


By now I hope you have noticed the "Search" button on top of all tables, with that one you can search for a player in the player window (also multiple names at once, seperated by a comma).

In the match window, you can search for any given team. For example "Ironhide, Vash" vs "Storm, Crimson". Also for all matches from one player alone, like "Crimson". Although the search window shows Team1 and Team2, its not seperated by Republic and Trandoshan. All matches with those players against/together will be shown. You can also search for one team only, like "Ironhide, Zafiro".

It also supports shortcuts, "Iron" for "Ironhide", "Narc" or simply "Noluck" instead of "Noluck/Noskill"

Playersearch:
Hidden content:
Image
Image


Matchsearch (one example for a non existing match, and you can see the players I have been searching at the top of the screenshots):
Hidden content:
Image
Image
Image
Image


Thats's almost it, here is one screenshot of the live server viewer included within the application. I am working on a way to let it update every 10 seconds, so long, you have to use the update button to reload the live stats.
Hidden content:
Image
Image


And if you dont like the theme, there are 6 included. I will show you 2 more now:
Hidden content:
Image
Image



And if you are interested, here is the explanation of the ranking system, how those numbers came up:
•Not all categories count for the ranking, those that matter are Win/Loss Ratio, Scores per Match, amount of Matches played, KPM and K/D.
•The tool is looking for the best value from each category, and sees it as "best available" (100%). From there on, it will calculate the percentage for every other played compared to the "best available" result. If I have K/D of 3, and Storm has 1.5, I would get 100% and Storm 50%. My explanation might be complicated, but it's actually quite simple.
•Once all individual stats are calculated, they are counted together with the following value:
-->40% Win/loss, 25% Flagscores, 20% matches played, 10% KD 5% KPM
•That means if one player leads ALL categories, he can get a 100.0 ranking (100%), if he leads all but K/D he has at least 90% and depending on his K/D he can get 99.9% maximum.

_________________
Image
Narcissus: You never miss more than 2 sniper shots in a row. Never have.


Top
 Profile  
Reply with quote  
 Post subject: Re: Republic Commando Stats Application
PostPosted: Fri May 02, 2014 9:01 am 
Offline
Chief Warrant Officer
Chief Warrant Officer
User avatar

Joined: Wed Jan 27, 2010 9:27 pm
Posts: 2299
I love it :) it's sad we were not able to creat it when RC was still alive :slash:
But well for the next matches we'll play it's cool to have something such detailled :up:

_________________

SWRC: THE MOVIE is back on YOUTUBE
»SWRC: THE MOVIE«
Please give it a blue thumbs up and a comment in order to give the video a new good reference :)


Top
 Profile  
Reply with quote  
 Post subject: Re: Republic Commando Stats Application
PostPosted: Fri May 02, 2014 9:45 am 
Offline
Grand Commander
Grand Commander
User avatar

Joined: Mon Oct 16, 2006 1:37 pm
Posts: 9886
Location: At home.
Impressive work, Iron! Really nice. :up:

_________________
Image

CPU: AMD Ryzen 7 2700X - RAM: G.Skill RipJaws 16GB DDR4-3200 - Motherboard: ASUS B350-Plus - SSD: Crucial MX300 750GB - Video: ZOTAC GeForce GTX 1070 Mini - Monitor: Lenovo ThinkVision P24h - Sound Card: ASUS Xonar Essence ST + ASUS Xonar H6 - Speakers/Headphones: Teufel Concept G THX 7.1 / Logitech G533 - Keyboard: Cherry MX-Board 3.0 - Mouse: Logitech G400 - Case: Lian Li PC-A70B - PSU: Enermax Modu87+ 700W OS: Windows 10 Pro x64
Quote:
[18:30] -=TAG=-Snoop: Okay, Thank you, and sorry for interrupting your ingenious laboratory work Professor Vash.


Top
 Profile  
Reply with quote  
 Post subject: Re: Republic Commando Stats Application
PostPosted: Fri May 02, 2014 4:25 pm 
Offline
Omicron Private
Omicron Private
User avatar

Joined: Wed Aug 07, 2013 6:12 pm
Posts: 177
Location: Germany
So now Storm will start playing with stacked teams only again? :xD:

Anyways, looks like a hudge amount of work, nicely done Iron :up:

Dunno if thats possible but could you integrate that if you win with lesser ranked players against higher ranked players you get an higher score?
What happens if we would play TDM? Would each kill count as a score?

_________________
ImageImage


Top
 Profile  
Reply with quote  
 Post subject: Re: Republic Commando Stats Application
PostPosted: Fri May 02, 2014 5:08 pm 
Offline
RepCom Mapper
RepCom Mapper
User avatar

Joined: Thu Aug 14, 2008 12:09 am
Posts: 7194
NoLuck/NoSkill wrote:
So now Storm will start playing with stacked teams only again? :xD:

Anyways, looks like a hudge amount of work, nicely done Iron :up:

Dunno if thats possible but could you integrate that if you win with lesser ranked players against higher ranked players you get an higher score?
What happens if we would play TDM? Would each kill count as a score?

1) Yes, thats possible. Its a shame we have this too late, would have been awesome to have this for tournaments. You wouldnt have to do anything, just play and the app would calculate the rankings for players and clans.

2) This is based on the website Storm/Vash made, I think it is only saving CTF stats.

_________________
Image
Narcissus: You never miss more than 2 sniper shots in a row. Never have.


Top
 Profile  
Reply with quote  
 Post subject: Re: Republic Commando Stats Application
PostPosted: Sun May 04, 2014 1:56 pm 
Offline
1st Commander
1st Commander
User avatar

Joined: Wed Dec 03, 2008 8:45 am
Posts: 5722
Location: Switzerland [CH]
STEAM: cost2008 + cost2007
LoL Name: TxDC17
Wow. This is so impressive O.o

Amazing job, congratulations!! Indeed, so sad we couldn't use such feature some years ago already.

I was wondering the same as Noluck, and I'm not sure I understood the reason if you gave one: do you get more/less ranking points depending on your opponents and teammates average ranking points? So you have more incentives not to just play with very good players vs lesser skilled players?

Again, really nice job from the 3 of you (talking about the website and these new features), I'm always more impressed :wink:

_________________
Image


Top
 Profile  
Reply with quote  
 Post subject: Re: Republic Commando Stats Application
PostPosted: Sun May 04, 2014 3:30 pm 
Offline
RepCom Mapper
RepCom Mapper
User avatar

Joined: Thu Aug 14, 2008 12:09 am
Posts: 7194
DC-17 wrote:
I was wondering the same as Noluck, and I'm not sure I understood the reason if you gave one: do you get more/less ranking points depending on your opponents and teammates average ranking points? So you have more incentives not to just play with very good players vs lesser skilled players?
First of all, thanks.:)

To answer your question, such a calculation is not included yet, if you guys want that I could change the stats calculation so it matters who you play with/against. I have an assignment due tuesday, afterwards I can spend some time on this app again (thats why I didnt post a download link yet, found a small bug that can be fixed in no time, but I just dont have any until tuesday).

_________________
Image
Narcissus: You never miss more than 2 sniper shots in a row. Never have.


Top
 Profile  
Reply with quote  
 Post subject: Re: Republic Commando Stats Application
PostPosted: Fri May 09, 2014 8:31 pm 
Offline
RepCom Mapper
RepCom Mapper
User avatar

Joined: Thu Aug 14, 2008 12:09 am
Posts: 7194
Just an update why I couldnt release the app yet: All bugs seem to be fixed, but I want to switch my database to Vashs server and need to randomly meet him online one day to get this done. Also barely had much time to be online myself, not sure how long its going to take. Old database is already off (saved the data of course) so I cant even release the old version right now.

_________________
Image
Narcissus: You never miss more than 2 sniper shots in a row. Never have.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Theme designed by Vash © 2009
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All times are UTC + 1 hour [ DST ]