|
edit: 7 Aug 10
This is going to turn into a post about various projects that RTS-Sanctuary is working on that may interest the community so I'll be reformatting things over the next day or two. For now I will just copy and paste some things here.
StarCraft Statistics Launch
+ Show Spoiler +RTS-Sanctuary is pleased to announce that our StarCraft Statistics service has been launched! As everyone knows Blizzard quarantines our view of league statistics so that you can only see yourself against the 100 people in your Division. In phase 2 of the beta two sites made a start on providing an integrated view of stats across all the Divisions. Neither of these sites have updated their data yet so I have decided to launch my own Sanctuary StarCraft Statistics service. You can find the page by going to SC Stats here. At the moment there is a simple searchable ladder that covers all divisions of the European, North American and South-East Asian Servers. You can refine your search by player name, server, league and race and results can be ordered by overall ranking, name. win ratio ot total games played. There are only a couple of thousand names in the database so far as Blizzard made it harder to do automatic searches of the player information by including the player name in your statistics url. You will find an entry form on the statistics page that will allow you to add your details to the database (or anyone else's if you know them). Once added you will be automatically tracked as your rating changes and/or you move through the divisions. So help us populate the database and go put your player url into the database!! You don't need to be logged into the site to view the dataor add your details so come on over and get your data registered.
StarCraft Statistics V2 Original Thread - http://www.teamliquid.net/forum/viewmessage.php?topic_id=141777 + Show Spoiler +Keeping the friendly competition going between the 3 of us who are working on stats sites atm, I've just put version two of the Sanctuary StarCraft Statistics live onto the site. There are a bunch of changes including : - separate sections for ladder, player and division stats viewing and searching - additional options for filtering ladder searches such as specifying minimum or maximum thresholds for points, games played and win ratio - links from ladder listings to summary player profiles - player profiles include details of all replays fetauring that player that have been posted to the site's replay system and links to information about the the division the player is in - listings of divisions by realm and league sortable by a range of player statistics calculated on your choice of the top ranked player, all players, the top 10 or the top 25 players in the division - summary statistics view with player listings for each division The best way to see the new features is to try it out. In terms of player coverage the player counts that are displayed are only for players with a 1v1 profile. I am going through a process of vetting all links to new profiles that are gathered from url harvesting and have a backlong that seems to be sitting at around 120K players no matter how many I get through at the moment  Although I have the data I still haven't put direct links to battle.net profiles or character codes in the information displayed on the site. I'm interested in understanding whether people want to be able to be identified easily in game through sites like this before I put that data available. You an add character codes in when searching for someone but the character code isn't shown when you view a player's profile.
Population Profiles
+ Show Spoiler +I've made another addition to the StarCraft Statistics Analysis options - Population Profiles. When you select this option you can choose a region (or all regions) and a league to analyse. Once the analysis is complete you will be presented with 3 charts: - Race Profile: A breakdown of the races used by players at different point levels within the league. - Population Profile: A breakdown of the number of players at different point levels within the league - Cumulative Population Profile: The cumulative proportion of the population at or above the different point levels within the league. Point bands are currently set at 50 point intervals within the league. Examples of the charts are shown below: Race Profile Population Profile Cumulative Population Profile![[image loading]](http://rts-sanctuary.com/images/cpopprofile.jpg)
Making Replay Posting Easier
+ Show Spoiler +I've noticed that the people that visit TeamLiquid often like to do so without having to worry about registering or logging in to the site. Soon after I started visiting here I changed the access policies on RTS-Sanctuary to allow guest to access all areas of the site with the exception of posting in the forums or posting replays. Over the last month or so I've seen that there is quite a demand for somewhere reasonable to be able to upload replays without the hassle of logging in. We've heard the message at RTS-Sanctuary and from today I have modified our replay system to allow you to upload replays in our General Replays forum without logging in. When you upload a replay at the site it is automatically created as a topic in the General Replays forum. All the details are extracted from the file automatically and you just need to check the winner has been determined correctly and add any comment you'd like to go with the replay post. You'll also be asked to enter a name to associate with the post. The game will be displayed in a neat format and there will be a link from the name of each player to be able to view their 1v1 statistics as well as the league they were in and their points at the time the replay was posted. In the post you will see detail of the link you can use to direct others to your game. We've set up a system that gets around the cumbersome url structure of the forums and your link will be something simple like http://rts-sanctuary.com/replay.php?186687 (which btw is a game of one of our posters against SelecT who was a top Dawn of War player). After you've posted your game it will be accessible in the forum for people to discuss and it will also appear in the Replay Database This gives you access to all SC2 replays posted on the site and can be searched by on a range of conditions including player name, race, map, number of players, game mode, patch version, and league. We aren't changing things to allow guests to make posts in the forums as that would be a moderation nightmare so you'll still need to register if you want to take part in forum discussions (as you have to here as well) but at least you will have somewhere convenient to post your replays and they will be easier to discuss than if they rae tucked away on a file share somewhere. To post a game just go to the General Replays Forum and click the New replay button. It is a simple and painless process. Hope you enjoy
Caster/VoD Database Original thread - http://www.teamliquid.net/forum/viewmessage.php?topic_id=133427 + Show Spoiler +Just wanted to put a call out to StarCraft II casters/commentators who might be interested in adding their details to the Caster Database at RTS-Sanctuary.com. The database is for people with live casts and/or video libraries and you can read about it in the thread at http://rts-sanctuary.com/index.php?portal=SC2&showtopic=184562. I know there have been a couple of different caster tracking systems posted about recently but most of those have tended to be stand-alone sites rather than being integrated with other community features like forums and replay posting (of course TL has the most comprehensive collection of casters and I'm not trying to compete with that .. I'd just like to have some information together for people when they are on the site). The system lets users add their own details directly into the database, creates a topic with an embedded viewer for their stream and/or VOD library, adds all their VODs into the library and monitors online status. Search functionality for the VOD library will be added soon. So far I have set up the details for: /v/craft ArtosisTV AskJoshy bballguard Big TV BlizShouter Brandon TV Day9TV DiggitySC DrewN3O Forsti GLHF.it GLHF.tv Goatrope Good2Game Gretorp Guilloteen Hateplow HDHomerJ HDStarcraft HuK HuskyStarcraft iCCup.TV LS Gamers/NostalgiaTag MakhStarcraft N3O Gaming Nevake OMFG - eSports LIVE! PainUser Pigzy-F5 Polygon revue TV PsyStarcraft PullSC SchickySC SCLegacy sc2noobschool Shoutcraft Shigarex SirazTV SpookyCaster Starcraft: Legacy Starcraft Pulse TechnoBoyForce The Elitists TheSCChronicles TL_Grobyc TrumpSC vegasraab Vincere Wolfcast (list edited to reflect additions since posting) If I've already set your stream up and you want to be able to edit the details you can register an account on the site and drop me a PM and I will transfer ownesrhip of the topic to you. If you want to add your own (or a favourite) stream just create an account and enter it into the database.
|
45th and 143rd, woo. That's right, trial account.
Looks good.
Edit: I'd like to see some replays from that darkshrine character, he's in my league but haven't run into him yet, he's ranked #1 at the moment with a good w/l.
|
That reminds me ... the other way you can add a player to the system is upload a replay they are in to our replay system in the Replay Forums ... they will be automatically added to the system and a link to their profile will be included in the replay posting.
|
Cool, thanks for doing this.
Yeah I noticed about the character name being added to the url, making brute force data mining of the leagues like was done in beta practically impossible :/
Hopefully a lot of people get on board and support this with submitting and replays so there is a good coverage
|
Very very cool, and thanks, I can see im in the top 25 overall!
|
This is great, thank you!  One question though: since names can be repeated in sc2, how will this affect the statistics? I know different profiles have different numbers, but how will it show on the website?
|
So I'm rank #13 overall on the US server? Something's not right, I'd be amazed if that's legit.
|
Aotearoa39261 Posts
... this is no where near complete yet
|
On July 29 2010 16:30 chieftan wrote: So I'm rank #13 overall on the US server? Something's not right, I'd be amazed if that's legit.
the server stats are very 'thin' atm especially for the US .. it's basically impossible to farm the stats so we need people to enter themselves in to get the process rolling
also once you enter yourself yourwhole div and overall ratings won't be updated till the enxt update. I will add in an ability to sort by points as well so you can at least see where you are easily
|
On July 29 2010 16:44 StaR_Robo wrote:Show nested quote +On July 29 2010 16:30 chieftan wrote: So I'm rank #13 overall on the US server? Something's not right, I'd be amazed if that's legit. the server stats are very 'thin' atm especially for the US .. it's basically impossible to farm the stats so we need people to enter themselves in to get the process rolling also once you enter yourself yourwhole div and overall ratings won't be updated till the enxt update. I will add in an ability to sort by points as well so you can at least see where you are easily
Got it. Should've kept reading your first post. Will there ever be a way to see global rankings?
|
well hopefully if we get the database populated you'll get a pretty good idea
|
Pity they made it so hard to automatically mine the information, still though good job Robo
|
|
|
We have no asian players posted into the database yet but I have added suport for that server into the system now. I don't post many replays from there to have started off the link process but please feel free to post players from the Asian server into the system.
I think we had about 2.7K players in the database when I launched earlier and we now have about 15.7K so we are making progress !
|
Nice work Robo. It says N/A when I look up my league rank and I've posted a replay. Is it because I'm to low ranked or will it rank everyone?
|
No I am doing ranks for every league on all the servers with whatever data I have. I assume you are talking about the playerprofile that you can look at from a replay post? I haven't updated that to pull information from the new player database yet - it's grabbing the data directly from battle.net so that's why it isn't showing the ranking. I only decided to go ahead and do the statistics this morning because it seemed the others hadn't done anything yet and I had most of what I needed from working on my replay system and a new tournament system.
There is also some delay between when you get added to the database and when you will be ranked because I only do a ranking when I run a full update of the divisions and I don't want to do that every time a player gets added. If you see yourself with a ranking of 0 in the ladder just sort by Points rather than rating and you'll get a feel for where you sit until the next ranking update is processed.
|
didn't we already have a site for this? sorry but I think once StarcraftRankings.com is updated no one will care about your site, that one was much simpler since it was the only purpose of the site
|
Thanks for being so positive Gorguts. 
Yes there were two sites doing this back in the second phase of beta starcraftrankings.com and sc2.vacau.com. Neither of those sites have updated since the launch and I had been working on the stats side of things for other parts of my site so when I saw people asking if this sort of thing was going to be available again I decided to make what I had public. Because of the way Blizzard have changed the player stats url no site is going to be able to just brute force farm the data for the rankings the way we did it in phase 2 of the beta (I had a full data set back then but I didn't have the time to get it in shape to make public) so you aren't going to find a 'simpler' ay of building the database up.
As for whether people want to use something that is part of a site that has a comprehensive database of casters, a well-maintained replay system and forums for discussion rather than a series of stand-alone sites I guess only time will tell - I do know that we are up to 16000 players in the database now so some people must be finding it useful. By your logic every forum should shut down because we already have TL and every caster should stop because we already have Husky HD and day[9].
|
Innovative idea on how to get this to work. Now we gotta find a way to get people to submit their profile (sticky the thread?). You have 16k? Only about 1,7 million to go... O.O
At least we'll be able to follow how the important players (TL members ) are doing compared to each other.
|
|
|
Awesome tool here. I hope we can get all of TL to submit
|
Just did a check of how we are going and we're up to 34,000 in the database now .. keep adding your links please :D
|
On July 29 2010 21:24 Gorguts wrote: didn't we already have a site for this? sorry but I think once StarcraftRankings.com is updated no one will care about your site, that one was much simpler since it was the only purpose of the site They can't data mine anymore >.< Either can SC2.Vacau.com
|
|
|
All the leagues are covered .. it's just a matter of whether we have any players added who are in silver
|
Oh, I just didn't see a division for Silver, so I thought you missed it. But I supposed if no one submitted their profile in silver, then you wouldn't have it. (I'm in platinum, so I can't test it for myself.)
|
The ranking of the OP is based on the points of players?
|
On July 30 2010 07:01 Apolo wrote: The ranking of the OP is based on the points of players? oops ... I had a conflicting key value in my array for the search options that meant that Silver wasn't showing up in the drop down list. Should be fixed now and TY for noticing it
|
what are the two numbers next to your name(on the left mean) i know one of them is rank but whats the other one?
|
On July 30 2010 08:39 hopewellsmash wrote: what are the two numbers next to your name(on the left mean) i know one of them is rank but whats the other one?
Two numbers where sorry? In the ranking table display each column is labelled and there is only one number. Are you talking about the link to your profile on battle.net (eg http://us.battle.net/sc2/en/profile/45672/1/name/) ? If so the /1/ is just a standard part of the stats url and the other number is your player id.
|
|
|
On July 29 2010 15:45 iEchoic wrote: 45th and 143rd, woo. That's right, trial account.
Looks good.
Edit: I'd like to see some replays from that darkshrine character, he's in my league but haven't run into him yet, he's ranked #1 at the moment with a good w/l.
I uploaded a replay from him vs. HuK at the link in my sig.
Thanks for being so prompt with this, Star_Robo... Gibybo told me his would be around eventually as well.
|
Awesome work, looks nice and up in a timely manner!
I have been too busy with work and playing the game to spend much time on updating starcraftrankings.com, so it's nice that you stepped up and satisfied the need to see my real rank.
Of course, you can expect some friendly competition in the near future 
On July 29 2010 21:59 StaR_Robo wrote: Because of the way Blizzard have changed the player stats url no site is going to be able to just brute force farm the data for the rankings the way we did it in phase 2 of the beta (I had a full data set back then but I didn't have the time to get it in shape to make public) so you aren't going to find a 'simpler' ay of building the database up. .
On July 30 2010 06:39 Skee wrote: They can't data mine anymore >.< Either can SC2.Vacau.com
Oh really? Sounds like a challenge.
|
Keep adding your names guys, the more the merrier!
|
Great work, thanks for doing this. I noticed some players added their clanname into their nickname, like mouzxxx. If one of them leave the clan they stay with this clan tag stuck in their sc2 name forever..
|
55,000 entries and climbing ... still fairly thin on SE-Asia with only about 3,500 entries and the rest split fairly evenly between US and EU. No entries for the Asian server at all at this stage.
|
Dakota_Fanning
Hungary2357 Posts
Good idea, but I wasn't able to try it, SQL error is returned.
Looks like the query misses the WHERE keyword and an initial condition, or simply just the AND keyword is used instead of the WHERE.
Produced by: I simply entered a name and clicked on Search.
|
Tip to the creator of the website:
Revealing your SQL Queries in errors = considering a disclosure exploit. Put in "or die('Clean error here')" messages on all of your MySQL Queries.
Otherwise, innovative way to figure the new profile system out. Another suggestion (I saw mention of it, but I've not really looked into the new system completely), is maybe pull information from publicly accessible replays, if they have the info?
Just an idea :D
|
looks like huk is on a roll =P
|
whats the point of this if its voluntary? i can't know how many noobs i am better than
|
hmm i mucked around with the queries before guess i didn't check every variation .. offf I go
|
I hate the fact that you have to imput the settings everytime in order to view the rankings.
It would be better if the URL would change when you change the settings, so that a specific list can be bookmarked and viewed easily everytime.
|
|
|
Thanks for picking those bugs up ... I had it set before so you had to choose a specific server and league and I thought people might want to do a search across all servers/leagues so I quickly changed the query and mucked up between a '=' and a '.=' :s
deViation it should be defaulting to US server, Diamond Div when you load the page - I thought the majority of people would be looking at Diamond div so all you have to do is select the correct server and hit search. Most of my other search functions have been the way you described but this time I wanted to try out using AJAX style functions to transmit the query and display the results so it unfortunately doesn't appear in the url. I can set it up so that you can have the variables in the url and it automatically loads them ready to hit submit if it was wanted
|
|
|
I'm in IdrA's division...in platinum. He's currently 40-3 with 903 points. Someone needs to kick the league promoter, but it cracks me up to see him there every time I check my ranking .
|
Good stuff, any chance we get that on the LA server?
|
Hi there,
Looks like a really nice tool, but I cannot find my own profile...
Raylek - US Server (I'm from Canada so I presume it's US)
Platinum in 2v2 Silver in 1v1
|
On July 31 2010 01:51 FTemplar wrote: Looks like a really nice tool, but I cannot find my own profile... Raylek - US Server (I'm from Canada so I presume it's US)
You actually choose it when you activate your account.
Edit: Just realized that came out kinda obscure, i meant you choose your server when you activate your SC account.
|
On July 31 2010 00:24 Sentient wrote:I'm in IdrA's division...in platinum. He's currently 40-3 with 903 points. Someone needs to kick the league promoter, but it cracks me up to see him there every time I check my ranking  .
gretorp is also in my plat division, stuck at last i remember, 16/2 winloss
|
There's a lot of other hawks =[
|
great work lets keep this updated
|
Can you add links to the SC2 profiles?
|
On July 31 2010 00:24 Sentient wrote:I'm in IdrA's division...in platinum. He's currently 40-3 with 903 points. Someone needs to kick the league promoter, but it cracks me up to see him there every time I check my ranking  .
i am more curious how he lost 3 games. I'll blame bnet.
back on topic: ty for putting this together.
|
The rank thing can't be right. I'm at rank 107 with only 17-2. Idra is is at rank 372 with 44-7. Doesn't make sense to me.
|
I guess much better if you add all available servers (regions): North America (in your base United States) Latin America Europe (added) Russia Korea (Asia?) Taiwan Southeast Asia & ANZ (SE Asia?) and use official names of these servers (regions)
|
hmm.. i dun get it.. how is the ranking decided?
|
Ranked 1220! lol :D awsome, consider this is out of a minimum of 1.8 million.
|
so, noob question...where do I find my player profile url? o.O
edit: nvm
|
|
|
Why are there random people rank 0 with like a couple hundred points?
K thanks mr dude below me v.v
|
Rank 0 just means that player's stats were recently added to the database and haven't been rank sorted in their respective league yet.
|
On July 31 2010 03:40 link0 wrote: The rank thing can't be right. I'm at rank 107 with only 17-2. Idra is is at rank 372 with 44-7. Doesn't make sense to me. Because there are only a few thousand in the database and not 1.8+ millions. I'm also building a database of players and it takes work to get it seeded to collect player information. If you like the idea of having searchable databases, then you need to help seed them. Go to the OP site and enter your player information and if you don't mind, help seed my crawler as well.
|
To the guy who said 17-2 ranked him higher i doubt you are in diamond before 30 ranked games so its probably a different division.
|
Right now there seems to be over 70000 people if you count every player (1458 pages with 50 players on each page).
How can this be? If mining names is no longer possible, how come so many people show up here? I really doubt that 70000+ people have manually added themselves to the database.
I saw my own name there for instance, but I have not submitted anything to the database.
|
I'm playing around with when I re-generate rankings to remove the issue with the 0 rankings. There seem to be a few glitches showing in ranking order etc atm that I'm looking into. All the underlying data is there - it's just a matter of balancing the process of people adding themselves and rankings being generated so be patient with me .. it's only been live collecting data for < 2 days
|
Where do I find my player URL?
|
haha, random facts for stalkers (real life stalkers): DeMusliM has 30 wins to 0 losses and is in Platinum league. GLaDe (41-3 Asia) aka moonglade has the best win rate of all diamond players, idrA (44-7 US) is 3rd. Socke (42-10 EU) is fifth. Most games played: FlatWhite already 271 (is he going for the 1000 wins achievement?).
|
On July 31 2010 08:14 CondorHero wrote: Where do I find my player URL?
If you log into battle.net on the web (it will be http://<server>.battle.net/en/sc2 where <server> depends on where you account is (us, eu, sea, kr etc). Once logged in you will see an panel with your name to the right of the menu options. Click that and it takes you to your profile. That is the url you enter - just copy/paste it into the field
|
On July 31 2010 03:40 link0 wrote: The rank thing can't be right. I'm at rank 107 with only 17-2. Idra is is at rank 372 with 44-7. Doesn't make sense to me. IdrA was in Platinum for a long while, and it looks like he finally got promoted. From my experience, when you get promoted, it puts you near the bottom with a lot of bonus points. He probably hasn't used them all up yet. He'll rocket up to the top once he does.
|
83,000 in database ... let's crack the 100K
|
On July 31 2010 10:45 StaR_Robo wrote:83,000 in database ... let's crack the 100K 
Very, very cool site. Really hope this catches on and gets a lot of data.
Any way to make players' names link to their B.Net profile? Their names on the ladder pages are profile links so the info should be available to you.
|
Thanks for the positive feedback everyone! Keep adding your names, let's break 100k by the end of the weekend. :D
|
This definitely is useless if you aren't in platinum. I'm in silver, and I basically suck, and I'm rank 1715? Whoever develops the system needs to make it so that at the very least all plat > all gold > all silver, etc
Edit: Disregard this, I am an idiot. Great site . My name was already in the database though. That's odd o.O
|
On July 30 2010 10:09 JoshSuth wrote:Show nested quote +On July 29 2010 15:45 iEchoic wrote: 45th and 143rd, woo. That's right, trial account.
Looks good.
Edit: I'd like to see some replays from that darkshrine character, he's in my league but haven't run into him yet, he's ranked #1 at the moment with a good w/l. I uploaded a replay from him vs. HuK at the link in my sig. Thanks for being so prompt with this, Star_Robo... Gibybo told me his would be around eventually as well.
And him vs Louder. Awesome, gonna watch this now, thanks!
|
Great initiative, will there be 2v2 rankings aswell in the future?
|
On July 31 2010 17:27 Nawyria wrote: Great initiative, will there be 2v2 rankings aswell in the future?
Yes I plan to add that as well .. just using 1v1 to sort out all the bugs and get the most efficient way of updating the data
|
Any chance this could be expanded to LA servers?
|
awesome! I love looking at all the top names on all the servers
|
On July 31 2010 17:35 phfantunes wrote: Any chance this could be expanded to LA servers?
Do LA players have a separate battle.net address for their profiles or are they on the main US battle.net site? I can easily add them whichever way it is
|
|
|
On July 31 2010 10:45 StaR_Robo wrote:83,000 in database ... let's crack the 100K 
How many users can your site handle? Would it handle a million users?
btw Kitsune is listed twice, with the same stats. He's ranked 24th and 25th. Good job on the site so far, it seems to update quite often which I like.
|
Could you please change the default "Sort Results by" to Points Descending. My guess is that almost everyone uses that one since it makes more sense to sort by points then the other options.
|
|
|
@Kahmunrah: It is only a ranking of the players that I have in the database so if we are missing some (and we certainly are) then that affects your absolute ranking. There is a lot of debate about the merits of using the points as a comparator across divisions but it really is the only option we have at the moment. Points are going to be misleading at this early stage but will settle down into a better indicator as people play more games. The earlier we get the database started the easier it will be to keep it maintained as the player base grows.
@MockHamill: The default search at the moment is the ranking which effectively is the Points Descending. I have been adjusting when rankings are recalculated and now it is virtually regenerated every time the data for a league is changed .. the longest you would get before an update would be from the start to the end of updating a division of players which isn't very long. I thought about removing the ranking number and just generating an index against the display order but then I thought that there are times when people are doing searches (eg by race) when they would want to see the actual rankings of the players as part of the display.
|
I don't see why Blizzard has to make it so hard for dataminers to compile rankings like this. The way I see it, the noncompetitive players won't even know about the site, so showing their true ranking on this site wouldn't really hurt their gaming experience at all. On the other hand, by allowing data miners to compile data, they could satisfy the hardcore segment of their user base...Blizzard really doesn't go through the motions before they implement retarded shit, do they?
|
|
|
Really great site!
A few bugs to fix though, for instance duplicates: XlorD XlorD
|
You could parse the battle.net forums for more users. Ok, you get mostly noobs by it's gonna be them you are gonna be missing in your ranking since you can get the platinium players with replays.
You can also browse the 2v2 scene. You take a division and get all the profiles from all the players and all their allies and their allie's allies. And the division in which these allie's allies play, etc....
|
Thanks a ton for this. Great work
|
Some input from a fellow developer, why don't you just create a spider to gather names?
Since you can see every player in a certain players division you could start with a player and pick up the id and name of each opponent in their division. You would probably have at least someone added from most of the divisions. This could be complimented with the manual add and you would have full coverage in no time. 
Edit: This was practically what Kapoue proposed two posts up. I missed his post when reading through the thread the first time. :O
|
mining data frequently by lots of people could slow servers i suppose
|
Yeah I plan to mine the team data to broaden the coverage since I have a reasonable chunk of players in the database now. I have a few bugs I'm trying to squash with the updating where I am occasionally getting a weird dataset being returned and then I will expand it out.
|
Very nice. Especially the submit a Bnet url to add. I like it a lot. Thanks.
|
when i look myself up it says that the last update was more than 10 hours ago. how can i update? thx for a great tool!
|
On August 01 2010 09:16 oldahe wrote: when i look myself up it says that the last update was more than 10 hours ago. how can i update? thx for a great tool!
I'm doing some debugging so I'm not running full updates atm - should be back updating in a few hours
|
I'm getting this error when I hit the search button:
Incorrect access You cannot access this file this way.
|
|
|
On August 01 2010 10:03 Dionyseus wrote: I'm getting this error when I hit the search button:
Incorrect access You cannot access this file this way. That happened to me too. Just refresh the page.
EDIT: beaten
|
Yeah I've changed the error message to reflect that you should refresh the page if you get that error.
|
On July 31 2010 17:52 StaR_Robo wrote:Show nested quote +On July 31 2010 17:35 phfantunes wrote: Any chance this could be expanded to LA servers? Do LA players have a separate battle.net address for their profiles or are they on the main US battle.net site? I can easily add them whichever way it is
On the main US site I believe, our servers are still on the US. Link to my profile: http://us.battle.net/sc2/pt/profile/8796/2/Hero/ (the highlight is a small differente on the address, not sure it's important).
Let me know if I can help with anything.
|
woah im surprised i'm on this ranking site
|
|
|
Then feel free to submit your name.
|
I would like to make list of top 1000 is this even possible here?
|
Props to LunaR for being worldwide rank 5 and US rank 1 for most games played despite only 19 points in diamond. Nice dedication ^^. You can see however, that 'dem asians just play the most, they are rank 1-4 with 362 games played already, might be due to account sharing however.
|
On August 01 2010 12:05 Liquorshot_852 wrote: woah im surprised i'm on this ranking site
Maybe if someone of your division is registered, it can see you division on bnet website.
|
Thank you.
I am missing the per race statistics we had in war3 !
|
I love sanctuary since dowsanctuary
|
On August 01 2010 11:24 phfantunes wrote:Show nested quote +On July 31 2010 17:52 StaR_Robo wrote:On July 31 2010 17:35 phfantunes wrote: Any chance this could be expanded to LA servers? Do LA players have a separate battle.net address for their profiles or are they on the main US battle.net site? I can easily add them whichever way it is On the main US site I believe, our servers are still on the US. Link to my profile: pt/profile/8796/2/Hero/]http://us.battle.net/sc2/pt/profile/8796/2/Hero/ (the highlight is a small differente on the address, not sure it's important). Let me know if I can help with anything. [/b]
Sorry for the delay in replying .. been bug squashing today and the little buggers kept running away from my hammer :p
The /pt/ in your url is just the portuguese language setting when viewing the battle.net site ... the url works equally as well with the /en/ in it. I'll adjust my script to be handle your urls and then it's just a matter of getting people to get details into the database. It looks like your leagues are separate to the North American ones even though they are on the same battle.net server
|
Currently ranked 2370 on the American server, just made it into a Diamond league named Selendis Nu last night
|
StaR_Robo, This might help you. http://www.cybergamer.com.au/sc2/players/ Here is a website which I believe has figured out a way to pull everyone's profile names and full profile URL address. Maybe you can analyze their code and figure out how they did it.
On a related note, I'm not extremely knowledgeable on coding, but I really need to figure out a way to pull profile stats and display them on the front of my website just for my clan members. Do you know how I can do that? My website is www.magogclan.com and my email address is kruelgor [at] yahoo.com
Thank you
|
It seems pretty up to date now.. Well done!... That aussie sight seems to have more though...
|
On August 01 2010 11:24 phfantunes wrote:Show nested quote +On July 31 2010 17:52 StaR_Robo wrote:On July 31 2010 17:35 phfantunes wrote: Any chance this could be expanded to LA servers? Do LA players have a separate battle.net address for their profiles or are they on the main US battle.net site? I can easily add them whichever way it is On the main US site I believe, our servers are still on the US. Link to my profile: http://us.battle.net/sc2/pt/profile/8796/2/Hero/ (the highlight is a small differente on the address, not sure it's important). Let me know if I can help with anything. It's the /2/ that's the important part (rather than /1/ for us servers)
Also, I'd been looking for the la servers, thanks for showing me them! I can see this will explain the "holes" in division numbers I've been looking for on the US servers. I've been running my own automated profile parser, and I'm up to about 150k in US, 60k in EU, 20k in Korea, and then it falls off a cliff. Unfortunately I don't have a website to put my data on (or enough experience to really make a decent one anyway), but I can do some nice stuff with the data at least, that I'll probably post up around tl.net somewhere once I automate that part.
EDIT: Also, if anyone else is doing automated peeling of b.net stuff, do you know why sometimes (especially on kr/sea I've noticed) PEOPLE'S NAMES GET SWAPPED AROUND A LOT. Holy shit it's annoying since names are important to getting profiles. I've resorted to using the matches history hole to confirm names, but of course I can't imagine that working forever.
|
Most of the reason I've delayed extending the information for the last few days has been the data corruption issue that muffley refers to - I don't know what it is but b.net does exactly what he describes and swaps information around.
|
On August 02 2010 06:26 StaR_Robo wrote: Most of the reason I've delayed extending the information for the last few days has been the data corruption issue that muffley refers to - I don't know what it is but b.net does exactly what he describes and swaps information around.
Sounds like an anti-fan-made-rating-list algorithm.
|
Out of curiosity, are you not cascade scanning? I've been spidering for about 17 hours for http://sc2ranks.com and have:
sc_production=> SELECT COUNT(*) as count, region FROM characters GROUP BY region ORDER BY count DESC; count | region --------+-------- 144824 | us 101926 | eu 14830 | sea 13669 | tw 200 | kr (5 rows)
This is with manually entering about 25 names on various regions. If you have an email I can dump a list of character regions/names/bnet_id/the stupid 1 or 2 in the URL and send you them to seed data faster.
What name swap issue were you seeing? I might need to look closer, but I don't recall seeing any information swapping itself.
[edit] Ah speak of the devil, are you talking about say http://tw.battle.net/sc2/zh/profile/79135/2/一抹清风/ladder/1223 where "top" is listed as 1st but he's not in any 1v1 league?
|
On August 02 2010 06:44 Shadowed wrote:Out of curiosity, are you not cascade scanning? I've been spidering for about 17 hours for http://sc2ranks.com and have: Show nested quote + sc_production=> SELECT COUNT(*) as count, region FROM characters GROUP BY region ORDER BY count DESC; count | region --------+-------- 144824 | us 101926 | eu 14830 | sea 13669 | tw 200 | kr (5 rows)
This is with manually entering about 25 names on various regions. If you have an email I can dump a list of character regions/names/bnet_id/the stupid 1 or 2 in the URL and send you them to seed data faster. What name swap issue were you seeing? I might need to look closer, but I don't recall seeing any information swapping itself. It seems like a decent amount of times (I'm doing kr and eu right now, and there's been too many to count) it simply switches the name (and only the name) of 2 people in a division. It's incredibly frustrating, and if the matches history hole didn't exist it would be a larger pain. My plan is to 'confirm' a name and simply hope they never implement name changing or ever recycle profile IDs after a ban.
Here's my localization info for various url requirements. First three are dictionaries (python), just a mapping object, for whatever you're using. Such that the url base is: http://LOCALE_BASE.battle.net/sc2/LOCALE_LANG/profile/id_here/LOCALE_NUM/name_here/
locale_lang = { 'us': 'en', 'sea': 'en', 'eu': 'en', 'tw': 'zh', 'kr': 'ko', 'la': 'en'}
locale_base = { 'us': 'us', 'sea': 'sea', 'eu': 'eu', 'tw': 'tw', 'kr': 'kr', 'la': 'us'}
locale_num = { 'us': 1, 'sea': 1, 'eu': 1, 'tw': 2, 'kr': 1, 'la': 2}
locale_divnoslash = ('us', 'kr', 'tw', 'la' )
|
No, but that's a hell of a thing, haha. The name changing happens only sometimes. That is, if you get a division 4 times, 2-3 will be all correct, while 1-2 will have names scrambled about. If you were to click on a person's name with this problem, it would lead to an error because "page does not exist" since the name would be incorrect.
I've never actually encountered this problem while using a webbrowser, but then again I haven't really tried, as it would be a mild needle-haystack thing.
|
Aha, that must be why I'm seeing random 404s when I do profile scans. This entire armory is held together with duck tape and spaghetti I swear. Some regions requiring trailing slashes and others not requiring it is fun too.
|
It's not just a case of 1 or 2 players being transposed either. I have debug dumps of ladder tables where almost every entry has been scrambled by putting the name of player A with the id of Player B for almost all the entries. Because names aren't unique can't assume one way or the other whether a new id/name combo is valid or invalid without testing each one in some way which increases the maintenance task. This is the main reason I haven't cascaded out from the data I have yet - I wanted to get an efficient solid update logic that doesn't require me to check the individual profile page of each player every time I update
|
I think the way to go is only check the profile page if the names don't match up. If it's a new person even don't look at their page as most of the time the division is correct. Even if it's not, next time it will be, or next time. A 'confirmed' flag for names for everyone is what I'm doing right now actually.
|
On July 29 2010 16:44 StaR_Robo wrote:Show nested quote +On July 29 2010 16:30 chieftan wrote: So I'm rank #13 overall on the US server? Something's not right, I'd be amazed if that's legit. the server stats are very 'thin' atm especially for the US .. it's basically impossible to farm the stats so we need people to enter themselves in to get the process rolling also once you enter yourself yourwhole div and overall ratings won't be updated till the enxt update. I will add in an ability to sort by points as well so you can at least see where you are easily lol yet im in there Woot im somwhere around 9000th
|
holy crap 87% win for idra :D
|
Doing a revalidation of all the existing entries atm and will start updating and expanding again after that .. rankings are still online but it will just be a bit longer between updates
|
On July 31 2010 08:58 StaR_Robo wrote:If you log into battle.net on the web (it will be http://<server>.battle.net/en/sc2 where <server> depends on where you account is (us, eu, sea, kr etc). Once logged in you will see an panel with your name to the right of the menu options. Click that and it takes you to your profile. That is the url you enter - just copy/paste it into the field
It says my name then "no characters available." I can't click on it.
|
I have just completed a full validation of all the entries in the database to remove the corruption caused by the random scrambling of ladder pages and I've introduced a new update procedure that will only add new players when they are fully validated. Updates are running atm.
I've also added in the support for player profiles from Taiwan and Latin America and changed the region labelling on the ladder display and search so they match the way Blizzard refers to them a bit better as well.
|
lol here's a fun example of the quality of battle.net data
http://eu.battle.net/sc2/en/profile/188181/1/Servy/
They'll probably have it fixed by the time people look at it but the main page of this character says he is rank 2 in his 1v1 div ... go to the div ladder and there is no entry for him :s
|
On August 03 2010 17:22 StaR_Robo wrote:lol here's a fun example of the quality of battle.net data http://eu.battle.net/sc2/en/profile/188181/1/Servy/They'll probably have it fixed by the time people look at it but the main page of this character says he is rank 2 in his 1v1 div ... go to the div ladder and there is no entry for him :s
Wow... that's just sad. His 3v3 stats are also messed up. His 2v2 stats are accurate for some reason though... gogo blizzard.
|
On August 02 2010 08:32 dolpiff wrote: holy crap 87% win for idra :D
88,88% atm:D
90 games, 80 wins and 10 losses, he is so good.
|
Germany2762 Posts
On August 03 2010 21:29 Stoles wrote:88,88% atm:D 90 games, 80 wins and 10 losses, he is so good.
sick stats... and i thought my 73% would be gosu.
in silver though... *cough*...
|
|
|
And that is the guy who dischacks =P
|
hah I thought it was but when I posted that last night I didn't have time to go searching for the thread where it had been discussed :p after him the longest win run drops down to about 17
|
lucifron is there 7 times, might want to fix that O_o
|
sigh .. how the hell did that slip in there :s
ty for noticing it
|
man this site is awesome :D thanks alot for putting it together
|
Hi StaR_Robo,
I try to get this profile info, but i have a problem with the first page redirection, Do you use any trick to get through this redirection?
Very nice site man...
|
Great site!
How about adding more advanced queries such as:
Points <=> X Games <=> X
etc etc
A mid level player can better gauge his progress by comparing people who've played the same amount of games.
NA shows about 94,000 entries as of today. But I'm sure many people have little to very few actual games. It'd be nice to be able to filter them out. Not sure if other people are interested in those stats since most people are probably only interested in the top and not the bottom.
Just a thought!
|
I'm updating the section including the search functionality at the moment. I'll add in some screens you can do > or < on .. I won't add in the ability to do x < played < y as you can just use the search order to display them in the same way (eg put played < y and order by played desc)
|
Sweet, 3897th!
Look out HuK and dayvie I'm coming after ya!
|
awesome, kinda slow and buggy though
|
I'm running the player discovery routines at a pretty heavy load atm so that is slowing the server down a bit - once we get to more of a maintenance phase this will ease off.
I'm not quite sure what you mean by buggy - if you are referring to the error message about 'Incorrect Access' that occurs because there is a session based authorisation in place at the moment for querying ladder details and it has a limited period of validity. Refreshing the page generates a new authorisation.
|
Going to be transforming this into a thread where I can talk about different projects that RTS-Sanctuary is doing that may be of interest to the community so I'll post this news here now and clean up/reformat the original post when I get time
Making Posting Replays Easier
I've noticed that the people that visit TeamLiquid often like to do so without having to worry about registering or logging in to the site. Soon after I started visiting here I changed the access policies on RTS-Sanctuary to allow guest to access all areas of the site with the exception of posting in the forums or posting replays.
Over the last month or so I've seen that there is quite a demand for somewhere reasonable to be able to upload replays without the hassle of logging in. We've heard the message at RTS-Sanctuary and from today I have modified our replay system to allow you to upload replays in our General Replays forum without logging in.
When you upload a replay at the site it is automatically created as a topic in the General Replays forum.
All the details are extracted from the file automatically and you just need to check the winner has been determined correctly and add any comment you'd like to go with the replay post. You'll also be asked to enter a name to associate with the post. The game will be displayed in a neat format and there will be a link from the name of each player to be able to view their 1v1 statistics as well as the league they were in and their points at the time the replay was posted.
In the post you will see detail of the link you can use to direct others to your game. We've set up a system that gets around the cumbersome url structure of the forums and your link will be something simple like http://rts-sanctuary.com/replay.php?186687 (which btw is a game of one of our posters against SelecT who was a top Dawn of War player).
After you've posted your game it will be accessible in the forum for people to discuss and it will also appear in the Replay Database
This gives you access to all SC2 replays posted on the site and can be searched by on a range of conditions including player name, race, map, number of players, game mode, patch version, and league.
We aren't changing things to allow guests to make posts in the forums as that would be a moderation nightmare so you'll still need to register if you want to take part in forum discussions (as you have to here as well) but at least you will have somewhere convenient to post your replays and they will be easier to discuss than if they rae tucked away on a file share somewhere.
To post a game just go to the General Replays Forum and click the New replay button. It is a simple and painless process.
Hope you enjoy
|
Cool - that will make it much easier for people to share replays.
|
Nice work Robo, thanks for your ongoing efforts keeping your site up to date.
|
Awesome site, I have one minor complaint though which is that under "Replays", the name of the players and their races and perhaps what map the game is played on, aren't very well "pronounced". I think they should stand out a little more so that I could do a quick "scan" with my eyes and immediately notice the games I am interested in. I mean scan as opposed to having to actually read.
Again, not a major complaint. I find the replays I find interesting but I do feel that it could be a little smoother.
|
On August 09 2010 03:10 Nightbiscuit wrote: Awesome site, I have one minor complaint though which is that under "Replays", the name of the players and their races and perhaps what map the game is played on, aren't very well "pronounced". I think they should stand out a little more so that I could do a quick "scan" with my eyes and immediately notice the games I am interested in. I mean scan as opposed to having to actually read.
Again, not a major complaint. I find the replays I find interesting but I do feel that it could be a little smoother.
Thanks for the feedback .. overhauling the layout of the replay search is something I want to do so I'll keep this in mind
|
Keep uploading your URLs. The more people we can get in the database the better,
|
I've just put a range of analysis of the StarCraft Statistics live on the site. You can access the page by selecting the 'Analysis' button on the menu while viewing the Statistics Section. All statistics are being cached in the database to manage load on the server and are refreshed every 60 minutes. The initial views will trigger the caching and given the size of the database they may take a while to load so please be patient.
The range of analysis available is detailed below. There are a large number of calculations and my head is still hurting from getting them all sorted out so if you find an error please let me know.
+ Show Spoiler + Race Splits By League Breakdown of race usage by League for the selected player population. Breakdown is shown for all regions combined and each region separately. Population choices are total population or the top 20, 50, 100, 200, 500, 1000, 2000 or 5000 players.
Race Splits By Region Breakdown of race usage by Region for the selected player population. Breakdown is shown for all leagues combined and each league separately. Population choices are total population or the top 20, 50, 100, 200, 500, 1000, 2000 or 5000 players.
League Split By Region Breakdown of player numbers by league for each region. Breakdown is shown for all races combined and each race separately. Analysis is only available for the total population.
Race Win Ratios By Region Breakdown of win ratios by race for each region. Breakdown is shown for all leagues combined and each league separately. Population choices are total population or the top 20, 50, 100, 200, 500, 1000, 2000 or 5000 players.
Race Win Ratios by League Breakdown of win ratios by race for each League. Breakdown is shown for all regions combined and each region separately. Population choices are total population or the top 20, 50, 100, 200, 500, 1000, 2000 or 5000 players.
Player Statistics by Region Breakdown of average player statistics by race (number of players, average points, games played, games won, games lost, win ratio). Breakdown is shown for all regions combined and each region separately. League can be set to all leagues or your choice of league. Population choices are total population or the top 20, 50, 100, 200, 500, 1000, 2000 or 5000 players.
Player Statistics by League Breakdown of average player statistics by race (number of players, average points, games played, games won, games lost, win ratio). Breakdown is shown for all leagues combined and each league separately. Region can be set to all regions or your choice of region. Population choices are total population or the top 20, 50, 100, 200, 500, 1000, 2000 or 5000 players.
Player Statistics by Population Breakdown of average player statistics by race (number of players, average points, games played, games won, games lost, win ratio). Breakdown is shown for all total player population and samples of the top 20, 50, 100, 200, 500, 1000, 2000 and 5000 players. League and region can be set to all, or your choice of individual league and region.
|
Awesome so far, whoever can first make more in depth statistical analysis such as win ratio as/vs each race, and on each map so that players can check their strengths and weaknesses wins.
|
Awesome! The race win percentage by league show that the game is very balanced. So Zerg players can quit whining now.
|
On August 10 2010 21:20 DirDirDirty wrote: Awesome so far, whoever can first make more in depth statistical analysis such as win ratio as/vs each race, and on each map so that players can check their strengths and weaknesses wins.
Unfortunately atm we can only work with the data we have. The race info is your most used race and it doesn't mean that you used it in every game recorded for you in a league and there is no infor on maps of anything in the profiles.
I do have links from profiles to any replays posted on the site but that is only a very small portion of the population so not much I can do with it
|
I've added another element to your 1v1 profile - Realm %.
This shows the % of players in your realm that are at or above your ranking - so lower is better
|
I've made another addition to the StarCraft Statistics Analysis options - Population Profiles. When you select this option you can choose a region (or all regions) and a league to analyse. Once the analysis is complete you will be presented with 3 charts: - Race Profile: A breakdown of the races used by players at different point levels within the league. - Population Profile: A breakdown of the number of players at different point levels within the league - Cumulative Population Profile: The cumulative proportion of the population at or above the different point levels within the league.
Point bands are currently set at 50 point intervals within the league.
Examples of the charts are shown below:
Race Profile
![[image loading]](http://rts-sanctuary.com/images/raceprofile.jpg)
Population Profile
![[image loading]](http://rts-sanctuary.com/images/popprofile.jpg)
Cumulative Population Profile
|
Way too much red (terran) and yellow (protoss) in the top ranks 
GOOOO ZERG!
|
I was quite suprised at how 'thin' the top end of the diamond division is when I put that chart together actually ... only 5% of diamond players worldwide above 700 points
|
I've changed the update routine on the 1v1 stats to be:
Diamond: Top 100 divisions measured by highest player points updated every 30 minutes, balance updated on a cycle that takes about 2 hrs to go through Platinum: Updated on a cycle that takes about 6 hours to complete depending on server load (>1K divisions in Platinum now) Gold, Silver, Bronze: Updated on a cycle that runs Bronze->Silver->Gold that should update once per day (>5K divisions in these three leagues now)
If the last cycle doesn't update once per day I will break Gold off into a separate loop.
With about 700K players in 1v1 now it takes a while to chew through them all
|
Good info. I was surprised by how few 700+ diamond players there actually are.
|
|
|
|
|
|