Skip to content

Instantly share code, notes, and snippets.

@Andygmb

Andygmb/tables

Last active August 29, 2015 14:10
Show Gist options
  • Save Andygmb/b7cce56facbd9f2b0272 to your computer and use it in GitHub Desktop.
Save Andygmb/b7cce56facbd9f2b0272 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
tables
For keeping history of people registered to the RUGC trading systems, tracking IP's, alternate accounts, new accounts, multiple logins from different accounts on the same ip or same reddit account.
-------------------------------------------------------------------------------------------------------------
Registered Users Table
Primary Key | Reddit | Steam | IP | Status |
1 | andygmb | 000000000000000000 | 0.0.0.0 | Banned |
-------------------------------------------------------------------------------------------------------------
Bans Table
Primary Key | Subreddit | Ban reason | Reddit | Steam | Autoban
1 | globaloffensivetrade | "Automatic scammer ban" | jsmith5 | 000000000000000001 | True
1 | tf2trade | "Automatic scammer ban" | jsmith5 | 000000000000000001 | True
1 | dota2trade | "Automatic scammer ban" | jsmith5 | 000000000000000001 | True
2 | tf2trade | "Broke subreddit rules" | anneea7 | 000000000000000003 | False
-------------------------------------------------------------------------------------------------------------
Attempted Registrations Table
| Primary Key | Timestamp | New registration | Reddit | Steam | IP | SteamRep | Subreddit |
| 1 | 14781250601 | True | andygmb | 000000000000000000 | 0.0.0.0 | Clean | tf2trade
| 2 | 14781250662 | False | andygmb | 000000000000000000 | 0.0.0.0 | Clean | globaloffensivetrade
| 3 | 14781250919 | False | jsmith5 | 000000000000000001 | 0.0.0.0 | Scammer | dota2trade
-------------------------------------------------------------------------------------------------------------
TF2trade Table
Primary Key | Reg. Users table FKEY |
1 | 1 |
2 | 6 |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment