ForumsGeneral › USL Database
USL Database 📰 News
Champion Oct 30, 2017 40 replies 742 views
1 2 3 »
OP Webmaster 👑 x24 👑 Gentlemen CO
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.
OP Webmaster 👑 x24 👑 Gentlemen CO
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.
Advisor 💎 x13 🔱 Monkey Business CO
strong work
M
League Analyst 💎 x10 🥇 Gentlemen
Looks good, killer finally passed that nerd leak for most games
C
⭐ x1 👑 Gentlemen
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?
OP Webmaster 👑 x24 👑 Gentlemen CO
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
OP Webmaster 👑 x24 👑 Gentlemen CO
I could probably add wins and losses to this as well.
3
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
OP Webmaster 👑 x24 👑 Gentlemen CO
probably because I'm working on it right now
OP Webmaster 👑 x24 👑 Gentlemen CO
added wins, losses and healing
K
🛡️ x1
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
OP Webmaster 👑 x24 👑 Gentlemen CO
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
🛡️ x1
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
🛡️ x1
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
OP Webmaster 👑 x24 👑 Gentlemen CO
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
🛡️ x1
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
League Analyst 💎 x10 🥇 Gentlemen
Nice I can see how I got robbed of marine award season 10 now
K
⭐ x10
my stats are the best...

so sexy
K
🛡️ x1
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.
1 2 3 »