iangallacher/sc2-ai-website

The source code behind the SC2 AI community ladder.

sc2-ai-website's Issues

Add ELO column to BotProfile table

Just as an idea for the website, maybe when you click on a bot to see it's win percentage against opponents, we could have in that table the ELO rating of each opponent. That helps put perspective on the win ratings, and see that e.g. although you lose to some low rated, you do beat some high rated consistently,... more nuance. I'm guessing it's not too hard a feature to add, since the data is all there.

For instance on here : https://www.sc2ai.net/BotProfile.php?BotId=90&season=6

As an added bonus, you can use it as secondary sort criterion, i.e. sort by DESC win percent followed by DESC ELO. It would help discriminate among the 100% bots what's impressive or not.

Time frames adjustable.

Since the bots get updated it would be cool if you could give a time frame for the stats on the bot specific page.

More stats in bot page

• Win ration per match up.
• Win ratio per map.
• Best win ratio against: (XX%)
• Worst win ratio against: (XX%)

Mobile view for ladder table is not working correctly

Also as per discord:

https://cdn.discordapp.com/attachments/385160867861495809/464459535034220565/Screenshot_2018-07-05-17-55-15-080_com.android.chrome.png

Suggestions

Some suggestions I had while browsing the new site.

On the landing page:

• Maybe embed a recent (or the most recent) youtube video from our youtube channel.
• Embed the most recent twitter message.
• A blog posts/News section.

In Results:

• In Bots if you click on the race of one bot it filters for that race. It would be could if you could also somehow apply filters in Results. Examples would be matchup (TvT, TvX=XvT, etc), participant=, winner=, loser= (!), map name = , from ... to...
• Rename "Results" to "Recent Results".
• Limit the number of entries to XX.
• switch the place in the menu with bots.

In Bots:

• Default ordering by ELO.
• Rename to "Standings" or "Ladder".

In the page of a specific bot:

• Win ration per match up.
• Win ratio per map.
• Best win ratio against: (XX%)
• Worst win ratio against: (XX%)
• A button with link to a list of all replays of said bot. The same thing you get on the current site when you click on "view matches".
• Would be cool if there is a "compare yourself with" option in the ELO graph.
• All of the above for a certain time frame.
• Github (website) link.

Regards

win ratio graphic

Hi,

the text in the win ratio graphic is clipped.

Regards

favicon still the old symbol

Plus the wiki could also have one :)

Pagination - Incorrect amount of items listed

Could be the same as or related to #34.
Browser used: Firefox
Steps to reproduce:
Go here: http://beta.sc2ai.net/results
Set season to "Season 6"
Scroll down to the bottom of the page.
Click the pagination link to go to the last page (currently page 80). Nothing changes, as per #34.
Click the pagination link to go to page one.
This should result in only 5 items being listed - an incorrect amount of items.

Reduce size of elements and fonts

Refer to the discord: It looks much nicer on 80% in Chrome and maybe it should be formalized as such

Profile formatting issue - Firefox

There's a formatting issue on http://beta.sc2ai.net with the Firefox browser where, when viewing an author's profile, the list of bots extends out too far to the right.

Replays not uploaded

Replays aren't being uploaded to the site

Drawn games are shown without a winner

Games have the winner field blank if the game is drawn. It should show either 'Tie' or 'Timeout'

Pagination - limit number of pages listed

Currently the pagination on the results page lists every single page available: https://beta.sc2ai.net/results

Ideally, it should limit the listed page numbers. Something like:
|< < 1 2 3 4 5...9 10 > >|

Show Ladder Health (metrics)

It would be nice to see how many games are played in the last 24h.

Additionally, if no game was played in the last 1h, the Ladderstatus could be given as 'Offline'

Multiple versions of bots detected as seperate bots

When a user uploads a bot with the same name as a bot he currently has, the site should upload it as a new version of that bot, and not a new bot

Replay downloads should be a button

Users don't need to know the filename of a replay before downloading it, so the information isn't really useful. Should have a download button or something similar.

Also replays with the same name should have a unique ID associated to avoid overwiting previous replays

Media section

Embed a recent (or the most recent) youtube video from our youtube channel.
Embed the most recent twitter message.
Twitch

PHP Email verification wrong DNS

Hai im new so please be patient with the used term.

Im handling existing website, and ive changed the DNS to a new one.

There is signup form and after the user registered they have to verified the email.

The problem is the url for activation is pointed out to the old DNS/activation instead of the new one.

and the email send from [email protected]

How can i change this. Kindly assist me thanks everyone

Rename Bots to "Standings" or "Ladder".

Pagination - Doesn't initially work

Browser used: Firefox.
Steps to reproduce:
Go here: http://beta.sc2ai.net/results
Scroll down to the bottom and click the pagination link for page 2.
Nothing will change.
Clicking the pagination link again will then work.

The website main redirect should directly go to the ladder results

There is no point in showing just a blank "Welcome to the SC2 AI Bot Ladder!" splash screen.

Either make this a blog where admin can write new articles on upcoming stuff (my preference), or go straight to the ladder results.

Results page - Order by ... not correctly working

Hi,

On the results page, the result looks random if you want to order by "First Bot", "Second Bot", or "Replay". "Map" and "Winner" works as expected.

Side note: The naming of the replays will probably cause conflicts.

Regards

Rename "Results" to "Recent Results".

and limit the number of entries to XX (unless filters are applied see other issue).

Github (website) link on the bot specific page

Installation requires mysql root password

Hey, the installation routine requires the mysql user 'root' password during setup. It would be better if the installation guide would require the user to let the user create a mysql account for the site.

Another issue is that the travis file tries to reset the mysql root password using sudo.

Would be cool if there is a "compare yourself with" option in the ELO graph.

Add a time date field for Results

This makes it easier to distinguish between the different games.

Configurable options

The website should allow more configurable options:

mysql database user/pass
mysql database name
application port

Preferably via config file, not env variables.

Bots page should be first page and ordered by MMR

Currently the results page is the default, this should be changed to the bots page, also the bots page should default to being sorted by MMR

Easy access to all replays of one bot

A button with link to a list of all replays of a bot on the bot specific page. The same thing you get on the current site when you click on "view matches". Maybe it could just jump to results with the corresponding filters already in place (see other issue).

Filters for Results

In Bots if you click on the race of one bot it filters for that race. It would be could if you could also somehow apply filters in Results. Examples would be matchup (TvT, TvX=XvT, etc), participant=, winner=, loser= (!), map name = , from ... to...

Email verification on user signup

Ideally email verification functionality - such as is seen on user signup with the existing live PHP site - should be implemented.
Otherwise I expect we'll get botted eventually.

Reset password option

This isn't working currently, although it may be because we can't send mail from that box, I can sort that side of things when we switch over, but would be good to have it there ready

Add more statistics

I would really like to see more statistics for the current ladder season. This is what I imagine for the matchups, from aligulac.com:

Moreover, I can think of a list of other statistics like longest winstreak this season, current longest winstreak, highest elo gain in a week and stuff like that.
I think that would be really interesting.