MariaDB [isaac]> select * from banned_users; +----+---------+-------------------+--------+---------------------+ | id | user_id | admin_responsible | reason | datetime_banned | +----+---------+-------------------+--------+---------------------+ | 1 | 59 | 1 | - | 2017-08-15 22:15:56 | +----+---------+-------------------+--------+---------------------+ 1 row in set (0.00 sec) ` MariaDB [isaac]> select * from users where id = 59; +----+-------------------+----------+---------------------+---------------------+---------------+-------+----------+------------------+-------------------------+------------------------+------------------+------------------+---------------------------+-----------------------+--------------------+-----------------------+--------------------------+----------------------+--------------------+------------+--------------------+------------------+ | id | steam_id | username | datetime_created | datetime_last_login | last_ip | admin | verified | seeded_trueskill | seeded_trueskill_change | seeded_trueskill_sigma | seeded_num_races | seeded_last_race | unseeded_adjusted_average | unseeded_real_average | unseeded_num_races | unseeded_num_forfeits | unseeded_forfeit_penalty | unseeded_lowest_time | unseeded_last_race | stream_url | twitch_bot_enabled | twitch_bot_delay | +----+-------------------+----------+---------------------+---------------------+---------------+-------+----------+------------------+-------------------------+------------------------+------------------+------------------+---------------------------+-----------------------+--------------------+-----------------------+--------------------------+----------------------+--------------------+------------+--------------------+------------------+ | 59 | 76561197999265092 | TovahCat | 2017-08-13 22:25:42 | 2017-08-15 20:49:17 | [snipped] | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | - | 0 | 15 | +----+-------------------+----------+---------------------+---------------------+---------------+-------+----------+------------------+-------------------------+------------------------+------------------+------------------+---------------------------+-----------------------+--------------------+-----------------------+--------------------------+----------------------+--------------------+------------+--------------------+------------------+ 1 row in set (0.00 sec) MariaDB [isaac]> select * from race_participants where user_id = 59; +-----+---------+---------+---------------------+-----------+---------------+-------+---------------------+----------+---------+ | id | user_id | race_id | datetime_joined | seed | starting_item | place | datetime_finished | run_time | comment | +-----+---------+---------+---------------------+-----------+---------------+-------+---------------------+----------+---------+ | 107 | 59 | 78 | 2017-08-13 23:31:24 | | 0 | 8 | 2017-08-13 23:31:24 | 1004673 | | | 162 | 59 | 86 | 2017-08-13 23:55:00 | SRMJ HTSN | 0 | 7 | 2017-08-13 23:55:00 | 886576 | | | 196 | 59 | 98 | 2017-08-14 00:31:46 | 8A6P W34L | 0 | 16 | 2017-08-14 00:31:46 | 1383873 | | | 245 | 59 | 108 | 2017-08-14 01:11:32 | VK23 077X | 0 | 4 | 2017-08-14 01:11:32 | 584481 | | | 297 | 59 | 127 | 2017-08-14 02:29:39 | XGT7 EZR4 | 0 | 1 | 2017-08-14 02:29:39 | 709320 | | | 315 | 59 | 132 | 2017-08-14 02:54:21 | 9VDV 4NH1 | 0 | 1 | 2017-08-14 02:54:21 | 213811 | | | 311 | 59 | 133 | 2017-08-14 02:47:58 | RR7V TSE0 | 0 | 1 | 2017-08-14 02:47:58 | 90209 | | | 348 | 59 | 149 | 2017-08-14 04:56:11 | YSFA LTLF | 0 | -1 | 2017-08-14 04:56:11 | 624704 | | | 352 | 59 | 152 | 2017-08-14 04:57:22 | KGS8 H86V | 0 | -1 | 2017-08-14 04:57:22 | 29669 | | | 358 | 59 | 154 | 2017-08-14 05:12:25 | HEHV M2KJ | 0 | -1 | 2017-08-14 05:12:25 | 877851 | | | 363 | 59 | 165 | 2017-08-14 05:31:25 | MXHQ SX7B | 0 | -1 | 2017-08-14 05:31:25 | 486544 | | | 531 | 59 | 287 | 2017-08-14 15:57:37 | 47D7 ZN9R | 0 | -1 | 2017-08-14 15:57:37 | 1800000 | | | 533 | 59 | 295 | 2017-08-14 16:16:50 | 9Y8X BZL6 | 0 | -1 | 2017-08-14 16:16:50 | 1061596 | | | 579 | 59 | 349 | 2017-08-14 21:01:25 | Q8FP GCK7 | 0 | -1 | 2017-08-14 21:01:25 | 10715 | | | 582 | 59 | 350 | 2017-08-14 21:16:09 | GLSK CT6P | 0 | -1 | 2017-08-14 21:16:09 | 835042 | | | 584 | 59 | 353 | 2017-08-14 21:29:22 | LLX9 BQ42 | 0 | -1 | 2017-08-14 21:29:22 | 779848 | | | 587 | 59 | 355 | 2017-08-14 21:53:42 | RM96 SCLH | 0 | -1 | 2017-08-14 21:53:42 | 1449443 | | | 805 | 59 | 559 | 2017-08-15 14:51:47 | 6GZ9 6683 | 0 | 1 | 2017-08-15 14:51:47 | 61079 | | | 815 | 59 | 561 | 2017-08-15 15:23:51 | T49K XFW3 | 0 | 1 | 2017-08-15 15:23:51 | 1795404 | | | 888 | 59 | 636 | 2017-08-15 21:02:05 | SSL6 T1HW | 0 | 1 | 2017-08-15 21:02:05 | 210250 | | | 899 | 59 | 639 | 2017-08-15 21:22:19 | ECSJ TQ6X | 0 | 1 | 2017-08-15 21:22:19 | 133556 | | | 942 | 59 | 678 | 2017-08-15 23:02:38 | CMSA AFLY | 0 | 1 | 2017-08-15 23:02:38 | 498733 | | | 947 | 59 | 680 | 2017-08-15 23:18:35 | HQYE NRFY | 0 | 2 | 2017-08-15 23:18:35 | 931619 | | +-----+---------+---------+---------------------+-----------+---------------+-------+---------------------+----------+---------+ 23 rows in set (0.00 sec) MariaDB [isaac]> select * from race_participant_rooms where race_participant_id = 942; +-------+---------------------+---------+-----------+------------+ | id | race_participant_id | room_id | floor_num | stage_type | +-------+---------------------+---------+-----------+------------+ | 97505 | 942 | 1.2 | 1 | 1 | | 97506 | 942 | 1.0 | 11 | 1 | | 97507 | 942 | 5.3391 | 11 | 1 | +-------+---------------------+---------+-----------+------------+ 3 rows in set (0.00 sec)
Comments