ahmed_aly's blog

Now you can filter Codeforces users by country
By ahmed_aly, 14 years ago, In English
Hi everyone,

Finally I did it, now you can filter Codeforces users by country.
Just go to this page and select the country and click view table.

I found that many Codeforces users didn't write a country in their profile,
but I have a TopCoder Tools website and I have all TopCoders countries in my database,
and I assumed that many users have the same usernames in TopCoder and Codeforces.
So if the country is unknown for a Codeforces user and I found a TopCoder account with the same username,
I assigned the TopCoder country to this Codeforces user.
I know that this way could assign someone the wrong country, but it will happen with low probability.
Also I got the country using this way for 1318 Codeforces users with unknown country, which I think it's very good number.

If you have just added or changed your country, you can go to this page, and write your username and click update my country, and it will be updated in my database too.
You don't need to enter your country in my website, just update it in Codeforces and do the above steps.

Anyway, if you found that your country is selected incorrectly, please send a message to me and I'll fix it.

I hope that you will find this useful.
  • Vote: I like it
  • +125
  • Vote: I do not like it

14 years ago, # |
  Vote: I like it +11 Vote: I do not like it
We should give thanks to ahmed_aly. 

Thanks a lot for it :).
→ Reply
14 years ago, # |
  Vote: I like it +5 Vote: I do not like it

Good job!

Waiting for new features :)

→ Reply
14 years ago, # |
  Vote: I like it 0 Vote: I do not like it
How does the script retrieve the country of a user? I'm asking just cause i'm not showed in Italy users :)
→ Reply
  • 14 years ago, # ^ |
      Vote: I like it +5 Vote: I do not like it
    now your country is Unknown You have to select your country from your account setting select Personal --> Social then write your country.
    → Reply
14 years ago, # |
  Vote: I like it +5 Vote: I do not like it
I think that the main administrator may add this feature to the main page:)
→ Reply
14 years ago, # |
  Vote: I like it +5 Vote: I do not like it
Good job!!! Thanks for this feature.
→ Reply
14 years ago, # |
  Vote: I like it +5 Vote: I do not like it
Thanks  ahmed_aly for such a trememndous effort in doing something of this sort which other would have felt as a mundane task to do.
Thanks a lot.
→ Reply
14 years ago, # |
  Vote: I like it +5 Vote: I do not like it
Thanks  ahmed_aly for such a trememndous effort in doing something of this sort which other would have felt as a mundane task.
Thanks a lot.
→ Reply
14 years ago, # |
  Vote: I like it +12 Vote: I do not like it
I missed the contest because I stayed awake till 4:30 AM to finish this tool, and the contest was at 9:00 AM. :(
→ Reply
14 years ago, # |
  Vote: I like it 0 Vote: I do not like it
I just updated my country in my profile, doesn't seem to reflect in the website.
→ Reply
  • 14 years ago, # ^ |
      Vote: I like it 0 Vote: I do not like it
    It's updated now.
    → Reply
  • 14 years ago, # ^ |
      Vote: I like it 0 Vote: I do not like it
    If you have just added or changed your country, you can go to this page, and write your username and click update my country, and it will be updated in my database too.
    You don't need to enter your country in my website, just update it in Codeforces and do the above steps.
    → Reply
14 years ago, # |
  Vote: I like it 0 Vote: I do not like it
Could you update this and this?
→ Reply
  • 14 years ago, # ^ |
      Vote: I like it 0 Vote: I do not like it
    It's updated now.
    6 users from the Japanese table and 8 users from the Iranian table are now updated in my database.
    Thanks!
    → Reply
14 years ago, # |
  Vote: I like it 0 Vote: I do not like it
What's happened with your database?
→ Reply
  • 14 years ago, # ^ |
      Vote: I like it 0 Vote: I do not like it
    yeah there's a problem with your database.. it was after beta round #63..
    → Reply
  • 14 years ago, # ^ |
      Vote: I like it 0 Vote: I do not like it
    I had a stupid bug in my code, which cleared the country field for everyone.
    I'm running the script which updates the countries again now, but it may take couple of hours.
    Sorry for this mistake.
    → Reply
  • 14 years ago, # ^ |
    ← Rev. 3   Vote: I like it 0 Vote: I do not like it
    Post is deleted, sorry.
    → Reply
  • 14 years ago, # ^ |
      Vote: I like it 0 Vote: I do not like it
    It should be fixed now, sorry again for this mistake.
    → Reply
14 years ago, # |
  Vote: I like it +5 Vote: I do not like it
I want to like this post a hundred times! Thank you ahmed_aly!
→ Reply
14 years ago, # |
  Vote: I like it 0 Vote: I do not like it
http://ahmed-aly.selfip.com/CodeforcesTools/Users.jsp?Country=All+Countries
Egor - Russia
Petr - Russian Federation
But there is no country "Russian Federation" in Select Country list
I think it's a bug
→ Reply
  • 14 years ago, # ^ |
      Vote: I like it +3 Vote: I do not like it
    Because Petr's country in Codeforces is undefined, but it's Russian Federation in TopCoder.
    And as you see in the main post, I used my TopCoder database to get the country for some users.

    Anyway, it's fixed now, you can check it here.
    → Reply
14 years ago, # |
  Vote: I like it +5 Vote: I do not like it
Thanks A Lot .... :D
→ Reply
14 years ago, # |
  Vote: I like it 0 Vote: I do not like it
your web shows empty table again.. :(
→ Reply
14 years ago, # |
← Rev. 2   Vote: I like it 0 Vote: I do not like it
Thank you a lot.
I think you should change ir5's country from Iran to Japan.
Edit: Also Mohammad_jrs and piloop are from Iran. Their TopCoder handles: Mohamad_jrs and piloop
→ Reply