Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SELECT name FROM players yields some awfully interesting results #209

Open
vorpal-buildbot opened this issue Apr 7, 2019 · 3 comments
Open

Comments

@vorpal-buildbot
Copy link
Collaborator

Reported on Discord by bakert#2193

@bakert
Copy link
Member

bakert commented Apr 7, 2019

| `cat /etc/passwd`                                                                  |
| `cat /etc/passwd`;                                                                 |
| `type c:\boot.ini`                                                                 |
| `type c:\boot.ini`;                                                                |
| |cat /etc/passwd .dat|                                                             |
| |cat /etc/passwd .html|                                                            |
| |cat /etc/passwd .htm|                                                             |
| |cat /etc/passwd |                                                                 |
| |cat /etc/passwd                                                                   |
| |cat /etc/passwd|                                                                  |
| |type c:\boot.ini .dat|                                                            |
| |type c:\boot.ini .html|                                                           |
| |type c:\boot.ini .htm|                                                            |
| |type c:\boot.ini |                                                                |
| |type c:\boot.ini                                                                  |
| |type c:\boot.ini|                                                                 |
| ¿'¿"                                                                               |

@stash86
Copy link

stash86 commented Jun 3, 2019

is this server issue?

@silasary
Copy link
Member

silasary commented Jul 11, 2019

We don't validate, sanitize, or captcha the signup form.
This means a lot of bots have probed the system over the years...

I think my favorite part is that we have 2900 "users" with the same password.

 SELECT COUNT(name) FROM `players` GROUP BY password ORDER BY COUNT(name) DESC LIMIT 10;
+-------------+
| COUNT(name) |
+-------------+
|        2917 |
|        1055 |
|         615 |
|         329 |
|         271 |
|         181 |
|          93 |
|          87 |
|          81 |
|          67 |
+-------------+
10 rows in set (0.02 sec)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants