Champion
OP
Webmaster
👑 x24
👑
Gentlemen CO
Oct 30, 2017 2:50 PM
I finished working on a database that I started a while ago and just remembered it today. I am going to add healing to it eventually but for now it should show all the basics. If there are any other reasonable sorting metrics you'd like to see added I will try to get them implemented.
The link to the database can be found on the left side under the Top 10.
Direct link: <a href="/usl/database.php?page=1&s=kills&o=desc"> Database </a>
If you encounter any bugs please let me know.
Champion
OP
Webmaster
👑 x24
👑
Gentlemen CO
Oct 30, 2017 3:10 PM
I think the 10 game requirement to show up in the KPG/KDR sorting is enough to weed out any inflated stat pads. Could even go to 15 if necessary but I think 10 will work for now.
Also, there are some names missing in the rows. May just be inactive/deleted accounts.
M
Mecca
League Analyst
💎 x10
⭐
🥇
Gentlemen
Oct 30, 2017 5:25 PM
Looks good, killer finally passed that nerd leak for most games
C
Cross
⭐ x1
⭐
👑
Gentlemen
Oct 30, 2017 5:56 PM
well done champion, thats for putting in the work for that, now i gotta click on page 78 to find myself. good looks.
J
nice stuff. i also remember the video section somewhere, did you remove it?
Champion
OP
Webmaster
👑 x24
👑
Gentlemen CO
Oct 30, 2017 7:47 PM
Jin wrote:
nice stuff. i also remember the video section somewhere, did you remove it?
yea because romulocks stopped doing sl live and it was messy
Champion
OP
Webmaster
👑 x24
👑
Gentlemen CO
Oct 30, 2017 7:50 PM
I could probably add wins and losses to this as well.
3
3KWEREWOLF
Oct 30, 2017 8:03 PM
clicking any values in the drop down menus inside the database THEN pressing the button to change the view goes to a error page saying "this page has stopped working"
Edited Oct 30, 2017
Champion
OP
Webmaster
👑 x24
👑
Gentlemen CO
Oct 30, 2017 8:06 PM
probably because I'm working on it right now
Champion
OP
Webmaster
👑 x24
👑
Gentlemen CO
Oct 30, 2017 8:41 PM
added wins, losses and healing
K
KobraRaider
🛡️ x1
Oct 31, 2017 11:32 AM
Probably not doable, but any chance of "ownage" stats? Like "Ownage %" or "Ownage Rating"?
Just curious.
Edit: Either way bud, great job. Also, I would like to see a return of a Video section if ya get the time. I love the weekly match videos and having a specific section with all of them would keep me from having to scrounge through the forums for the older ones when I'm in a mood for intensive research.
Keep up the good work bud. It is appreciated.
Edited Oct 31, 2017
Champion
OP
Webmaster
👑 x24
👑
Gentlemen CO
Oct 31, 2017 11:41 AM
What would ownage % or ownage rating be comprised of? Like, how would you calculate those things?
Video section will probably make a return soon. Was thinking of adding a direct embed function with a drop down similar to Reddit for easier browsing.
K
KobraRaider
🛡️ x1
Oct 31, 2017 11:43 AM
Bah, just had some ideas for a video section. Ya could have it default to the weekly match vids and sorted by posting date or something. 2 drop down menus, one for category (match vids, duel vids, other, etc...) and one for sorting (newest, oldest, whatever). Just some thoughts.
K
KobraRaider
🛡️ x1
Oct 31, 2017 11:47 AM
Champion wrote:
What would ownage % or ownage rating be comprised of? Like, how would you calculate those things?
Video section will probably make a return soon. Was thinking of adding a direct embed function with a drop down similar to Reddit for easier browsing.
Video - Sounds good to me.
Ownage % would probably be too difficult to calculate with current stat data, tbh. Ownage Rating however could probably be done by combining things like number of games, kills, deaths, kdr, healing, and possibly hit %? into a single rating based on all of that data to determine one's Ownage Rating. If ya want an exact formula ya could use I can probably find one that could handle those data sets.
Edit: Just realized the OR would also need to take into account if the games were wins or losses as well (ie. 24 kills in a win is less impressive than 24 kills in a loss).
Edited Oct 31, 2017
Champion
OP
Webmaster
👑 x24
👑
Gentlemen CO
Oct 31, 2017 2:32 PM
Added a season view. Can check all the different stats per season instead of overall. Also added colors to the current column that you're sorting for easier viewing.
K
KobraRaider
🛡️ x1
Oct 31, 2017 2:35 PM
Looking better bud. Has anyone told you lately that you're an awesome person? =D
Edit: Also, is hit percent still tracked? I don't see it in the stats on site. Just curious.
Edited Oct 31, 2017
M
Mecca
League Analyst
💎 x10
⭐
🥇
Gentlemen
Oct 31, 2017 2:48 PM
Nice I can see how I got robbed of marine award season 10 now
K
kippa
⭐ x10
Oct 31, 2017 5:45 PM
my stats are the best...
so sexy
K
KobraRaider
🛡️ x1
Oct 31, 2017 6:08 PM
Update: I've been fiddling around with creating a formula, but the current version rates Killer as an Ownage Rating of 96 and me as an Ownage Rating of -33. Now, while I agree with these ratings, others may have issues with them. So I'll keep working on it, lols.