| Forum Index > SC2 General |
|
Koibu0
United States513 Posts
Phase 1: completed - rewrite all the css with sass, basic simplification of classes and scripts. Phase 2: started - reposition elements, redefine the color pallet, total simplification of classes and scripts. Phase 3: outstanding - new icons, images, and banners | ||
|
LotsofLuck
United States62 Posts
| ||
|
Koibu0
United States513 Posts
| ||
|
Koibu0
United States513 Posts
Added imagery for HDWT as well. This week is going to be super slow in terms of updates (aside from adding vods and winners to the existing tournaments) because I'm getting pretty slammed at work. Have no fear though, there's a lot going on behind the scenes. | ||
|
LotsofLuck
United States62 Posts
+ Show Spoiler + Strelok won the HDWT | ||
|
Koibu0
United States513 Posts
Thanks. <3 | ||
|
pingy[wen]
United States157 Posts
| ||
|
Koibu0
United States513 Posts
Player pages now have win/loss records, also broken down by race. Example: MVP What changes would you like to see in these stats? Would you like to be able to filter the stats by a time frame, or tournament? Let me know. | ||
|
Koibu0
United States513 Posts
Fixed all the broken names for players Implemented a way to find broken player names reliably These in turn have corrected errors in the stats of a few players. | ||
|
Koibu0
United States513 Posts
Groups now display the average score of all the matches in the heading. For example, in SlayerS Vs. MVP, we now see it has an average score of 3.7. This way, you can kind of get an idea of how good the matches within the group (hidden by the spoiler tags) are. The current problem is that one or two bad games can really bring down an excellent group: Again with the SlayerS vs MVP from GSL TL3. Amazing set, totally worth watching, but averages out at 3.7. :/ | ||
|
LotsofLuck
United States62 Posts
For the player database, are you manually keeping track of those wins & loses, or do you have something that updates for you? I would personally focus more on the tournaments, but the player stats is interesting.... | ||
|
Koibu0
United States513 Posts
When I'm adding a new tournament, into one database I enter the players real names, user names, and race. If the person (real name) doesn't already exist in the database, an entry for that person is automatically created. So now we have all the 'Users' in one table, which relates to the 'Players' in another. Then we go in and add each match, filling out info such as: Player 1, player 2, winner, etc. Those first 3 fields, look up the 'User', which is how we get their race. When we look at a player page, for example MC, we look up the 'player' of that 'user'. Then we find all the 'users' that are related to that 'player'. [single user] => [player] => [all users] Still with me? Now we search our table of matches for all instances of player1 or player2 having any of those user names (that wasn't cancelled). Each time they win a match, we add 1 to their match count against that race, and one to their win count. against that race. Each time their opponent won a match, we add+1 to their total match count against that race. That way we don't count matches that haven't been played yet, or a winner hasn't been reported yet. From there it's just simple math: wins / (total games - wins) Now that I think about it, I probably could have just said, "I have a script that does it for me". The point is, it's all done behind the scenes and calculated on the fly every time you load the page. That keeps the number of fields in the tables down, and keeps all the logic behind calculating and displaying this information in one area.  Now that I'm recording player stats, it seems to me that I should add as many tournaments as possible, even if I can't find all (or any) of the vods. I mean, if you look at TLO's record, it's really really sad: 3 and 6? He's a better player than that, he's just under represented because I mostly have Korean tournaments. Maybe with this 3 day weekend coming up, I'll be able to add in a ton of stuff. | ||
|
LotsofLuck
United States62 Posts
On May 27 2011 10:30 Koibu0 wrote: Now that I think about it, I probably could have just said, "I have a script that does it for me". The point is, it's all done behind the scenes and calculated on the fly every time you load the page. That keeps the number of fields in the tables down, and keeps all the logic behind calculating and displaying this information in one area. Now that I'm recording player stats, it seems to me that I should add as many tournaments as possible, even if I can't find all (or any) of the vods. I mean, if you look at TLO's record, it's really really sad: 3 and 6? He's a better player than that, he's just under represented because I mostly have Korean tournaments. Maybe with this 3 day weekend coming up, I'll be able to add in a ton of stuff. Great, I like Black boxes as well. Just making sure you're cutting down on the stuff you have to add manually. If you are keeping track of players, you might want to eventually add a search for them as well. But yes, I like the idea of adding more tournaments. :D | ||
|
Koibu0
United States513 Posts
Update Added a search function for players. You can search by real name and user name. As things progress, it will become more sophisticated, but I'd wanted to get the bare bones functionality out right now. [edit] Put a search bar on the home page as well | ||
|
Vorlik
1522 Posts
| ||
|
Koibu0
United States513 Posts
Which ones should get priority!? | ||
|
LotsofLuck
United States62 Posts
On May 28 2011 06:59 Koibu0 wrote: This weekend, I'm going to add in as many tournaments as I can. Which ones should get priority!? I'd say anything upcoming under the Big Tournament Tracker http://www.teamliquid.net/events/ Definitely some of the IPL Qualifers, or the EG Masters. On another note, I think you may have gotten the schedule for the Ro64 GSL Super Tournament on May 28th. Here are the matches that were correct for the day: http://www.teamliquid.net/calendar/2011/5/#event_4890 | ||
|
Koibu0
United States513 Posts
GSL Team League 1 GSL Season 5 Up and Down GSL Season 4 Code A GSL Season 4 Up and Down [GSL 2011 is now complete] | ||
|
Koibu0
United States513 Posts
EG Master's Cup Series 5 (up to current week) The format of this is very different, so it doesn't look as smooth on the page  Also, there are lots of missing vods on the the EG page, so I'm missing many vods too.Because of the odd formating, it's a pain in the ass to add more matches for this tournament, so I might not be as on top of the updates with this as I am with other tournaments. | ||
|
Koibu0
United States513 Posts
Dreamhack Winter 2010 Added Dream Hack invitational 2011 | ||
| ||
StarCraft 2 StarCraft: Brood War Dota 2 League of Legends Counter-Strike Other Games |
|
The PondCast
OSC
Wardi Open
CranKy Ducklings
Safe House 2
Sparkling Tuna Cup
Safe House 2
Tenacious Turtle Tussle
|
|
|
EPT
