|
On April 07 2010 17:27 Gibybo wrote:Good stuff nagash I want to display rank next to the players name when I search for it like you do, but to do that I need to store the rank in my db (which I'm currently not doing). Is there a way I can add rank with one or two SQL queries or do I just have to do one for each player? Also, currently doing a massive div 1-31 update.
Well, I've got the updates in for pagination and sorting. Also added a search option for "minimum rating" as it makes sense when sorting by ratio so you dont get a bunch of 5-0 players with 100% ratio at the top.
I personally just added the rank once for each player, since my database is only updated once an hour/day/whatever I don't see it as a big deal.
I'm sure it is possible to grab a rank using some sort of SQL function in one query, but I couldn't tell you how
Throw me a PM with MSN details or similar and we can help each other out / look at merging.
Edit: Actually I just realized it's easy, I was thinking way too much into it lol. $sql = "SELECT count(*) FROM players WHERE rating > $player_rating"; in SQL terms. Doesn't take into account if someone has the same rating as them, but no big deal I guess.
|
My stupid suggestion.. make the page abit prettier.. maybe black background, nice banner at top.. etc etc =]
|
On April 07 2010 17:50 Skyze wrote: My stupid suggestion.. make the page abit prettier.. maybe black background, nice banner at top.. etc etc =]
Aha yer, I'm no designer, but that's probably the next thing I'll work on since I can't think of any more features to add.
If someone wants to design a header/logo feel free...
|
Alright I just updated all divisions 1-36, which is the first time I've had every platinum player on the US server!
*Except division 35, I need a name from that still
On April 07 2010 17:40 nagash wrote: Throw me a PM with MSN details or similar and we can help each other out / look at merging.
PMed! Also, I can give you direct access to my DB so you aren't an hour behind if you want.
Edit: Actually I just realized it's easy, I was thinking way too much into it lol. $sql = "SELECT count(*) FROM players WHERE rating > $player_rating"; in SQL terms. Doesn't take into account if someone has the same rating as them, but no big deal I guess.
Eh that seems expensive since I'd have to run it once for every search (or still once for every player if I cache it). It's probably plenty efficient, but I am pretty sure there is a way to do it in one query (though that query might not actually be much more efficient) for all players at once.
|
awesome, all divisions are there :D
|
Guess im late get back to the party, if you think the direction is useful I'l set about automating it, had more fun thinking about how to use the data. Only put a few up mind.
Mmman its been a while since i've done web dev outside corporate, didn't even have a db set up on my site let alone the apps.
http://www.tjisher.com/sc2/
edit: finished for today, concentrated on overall charting rather than the tables that already covered here, be more useful in a week or two
ps my working file if its any use to anyone
|
|
On April 06 2010 01:15 lolaloc wrote:Show nested quote +On April 06 2010 01:06 Nub4ever wrote:hmmm I can't seem to find davy on that list The BlizzBoyz (dayvie and cowgomoo) must have changed their names or took a break from ladder. pshh I retired while I was ahead =P I went all-in, doubled up, then immediately left the table.
|
Just updated 1-37 (I'm getting better, only took me 15 minutes to update them all this time!).
IdrA and HuK continue their close race meanwhile ericpanda shot up from 5th to take 1st from both of them!
|
14 Zerg, 15 Protoss, 15 Terran, 6 random.
I have to say I'm impressed. Of course there are definite issues to work out, but hot damn, that's nice.
|
Just reviewing the work from yesterday I think I've got as far as I can go without historic data, so theres going to be a lul before the site changes again. Not to mention having to set up the whole php+MySQL stack (some calls gonna be expensive) blah blah.
But I think we've got to an interesting point. For instance I think we can make judgements like excluding players with less than 20 wins from top player listings, as it just seems to be a hangover from a good placement round.
[evidence here, gonna watch day9 first ]
|
tjisher site is bugged when you search my name, JiYan, or JiYan.lee
|
|
can't believe I missed this, Great JOB! I hope u get payed for this lol.
|
Amazing, thanks. Love honstats.heroku.com too
|
Updated divisions 1-39 (missing 38). HuK keeps getting knocked away from first, this time by Durrrr!
I have also added a new feature. In cooperation with TopReplays.com and soon to be many other replay sites, you can now view a player's replays by clicking the link next to their name. Top 100 players only.
|
This is awesome, do you think you can expand it to the gold league too? I think eventually this should be done for plat/gold/silver and just leave bronze out..
|
wow this is awesome, nice job. Especially the replays feature :o... Do you get those replays from sites or are there directly uploaded from the bnet server (stupid question, I know)?
|
On April 10 2010 00:52 lew wrote: wow this is awesome, nice job. Especially the replays feature :o... Do you get those replays from sites or are there directly uploaded from the bnet server (stupid question, I know)?
The replays are coming from replay sites. I will be adding more sites to pull them from in the near future, just piloting it with TopReplays.com since they worked with me on the integration.
I'm taking suggestions on the best replay sites to add next
On April 10 2010 00:47 Whitecrow wrote: This is awesome, do you think you can expand it to the gold league too? I think eventually this should be done for plat/gold/silver and just leave bronze out..
Haha, I plan on doing it for all 5 leagues. I just uploaded a FAQ with more details.
|
Wow, I expected user-made region ladder will come, but not this fast. GJ Gibybo!
|
|
|
|