Tuuba Time: 2025-09-15 18:24:03 | Local Time: 2025-09-15 15:24:03

You are not logged in.

#196 Whatever of importance » The GDPR compliancy post no one asked for » 2018-05-25 13:25:53

IppE
Replies: 3

No, we're not changing our privacy policies, because they're nonexistent and what we do is already compliant with GDPR, but just to be safe, here's a rundown of what information we store about the users on this forum and what it's used for.

database entry for users
+------------------+---------------------+------+-----+---------+----------------+
| Field            | Type                | Null | Key | Default | Extra          |
+------------------+---------------------+------+-----+---------+----------------+
| id               | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| group_id         | int(10) unsigned    | NO   |     | 3       |                |
| username         | varchar(200)        | NO   | UNI |         |                |
| password         | varchar(128)        | NO   |     |         |                |
| email            | varchar(80)         | NO   |     |         |                |
| title            | varchar(50)         | YES  |     | NULL    |                |
| realname         | varchar(40)         | YES  |     | NULL    |                |
| url              | varchar(100)        | YES  |     | NULL    |                |
| steam            | varchar(30)         | YES  |     | NULL    |                |
| youtube          | varchar(80)         | YES  |     | NULL    |                |
| twitter          | varchar(15)         | YES  |     | NULL    |                |
| discord          | varchar(80)         | YES  |     | NULL    |                |
| mal              | varchar(16)         | YES  |     | NULL    |                |
| location         | varchar(30)         | YES  |     | NULL    |                |
| signature        | mediumtext          | YES  |     | NULL    |                |
| disp_topics      | tinyint(3) unsigned | YES  |     | NULL    |                |
| disp_posts       | tinyint(3) unsigned | YES  |     | NULL    |                |
| email_setting    | tinyint(1)          | NO   |     | 1       |                |
| notify_with_post | tinyint(1)          | NO   |     | 0       |                |
| notify_pm_full   | tinyint(1)          | NO   |     | 0       |                |
| auto_notify      | tinyint(1)          | NO   |     | 0       |                |
| show_smilies     | tinyint(1)          | NO   |     | 1       |                |
| show_img         | tinyint(1)          | NO   |     | 1       |                |
| show_img_sig     | tinyint(1)          | NO   |     | 1       |                |
| show_avatars     | tinyint(1)          | NO   |     | 1       |                |
| show_sig         | tinyint(1)          | NO   |     | 1       |                |
| timezone         | float               | NO   |     | 0       |                |
| dst              | tinyint(1)          | NO   |     | 0       |                |
| time_format      | tinyint(1)          | NO   |     | 0       |                |
| date_format      | tinyint(1)          | NO   |     | 0       |                |
| language         | varchar(25)         | NO   |     | English |                |
| style            | varchar(25)         | NO   |     | Air     |                |
| num_posts        | int(10) unsigned    | NO   |     | 0       |                |
| num_pms          | int(10) unsigned    | NO   |     | 0       |                |
| last_post        | int(10) unsigned    | YES  |     | NULL    |                |
| last_search      | int(10) unsigned    | YES  |     | NULL    |                |
| last_email_sent  | int(10) unsigned    | YES  |     | NULL    |                |
| last_report_sent | int(10) unsigned    | YES  |     | NULL    |                |
| registered       | int(10) unsigned    | NO   | MUL | 0       |                |
| registration_ip  | varchar(39)         | NO   |     | 0.0.0.0 |                |
| last_visit       | int(10) unsigned    | NO   |     | 0       |                |
| admin_note       | varchar(30)         | YES  |     | NULL    |                |
| activate_string  | varchar(128)        | YES  |     | NULL    |                |
| activate_key     | varchar(8)          | YES  |     | NULL    |                |
| use_pm           | tinyint(1)          | NO   |     | 1       |                |
| notify_pm        | tinyint(1)          | NO   |     | 1       |                |
+------------------+---------------------+------+-----+---------+----------------+

Most of the values are forum settings, and the ones considered "personal information" by GDPR are username, password, email and the registration ip address, out of which only usernames are public to other users. Passwords are stored as SHA512 hashes so we don't know what they are, but do still keep general good password practises in mind. Possible upgrade to bcrypt password hashing in the future is a thing, but no promises. In addition, the IP address is logged for each post you make.

We do not share any of the information that the forum software itself doesn't display by default to 3rd parties, nor do we think it would be ethical to do so. If you wish to have a copy of the user information we've stored about you, or have all of your user information removed, pm me (IppE) or zertap. (Please note that removing user information means deleting your account.)

#201 Re: Off Topic » ITT: Pretend we are still writing in osu! OT » 2018-04-10 18:02:33

Don't be all huddled up in your own shit and maybe the people of the forum pop around, who knows.

#202 Re: Off Topic » ITT: Pretend we are still writing in osu! OT » 2018-04-10 17:12:55

Got back from a walk, grabbed a package while at it.

All in all it's going alright for the moment.

#203 Re: Off Topic » ITT: Pretend we are still writing in osu! OT » 2018-04-10 07:03:35

Contact us for pricing on user data! Great deals for unsanitized database dumps!

#204 Re: Forum games » Rate the avatar above you » 2018-04-09 16:20:57

6/10

Would be better if it was just the artwork without the text and other doodads around it.

#205 Re: Forum games » Explain your Avatar » 2018-04-07 17:10:36

See above.

I'm a pro at this game think2

#206 Re: Off Topic » oblibatory ytuube/webm thread » 2018-04-07 15:44:19

They've at least upgraded their graphics.

None of this still makes any logical sense though.

#207 Re: Off Topic » ITT: Pretend we are still writing in osu! OT » 2018-04-05 17:39:17

fittan wrote:

a CD i ordered was shipped on 23.3 and I'm still waiting on it, usually post (letters) in finland takes a maximum of two days to arrive to anywhere in the country

I've seen them take anywhere from one day to a week with letters.

#208 Re: Off Topic » ITT: Pretend we are still writing in osu! OT » 2018-04-04 06:46:31

Men aren't the only gender that gets all weird in the head sometimes.

#209 Re: Off Topic » What's cooking good looking? » 2018-04-03 18:43:14

looks weeb, but that's a nice keyboard

Board footer

Powered by Maki (r-e 139/git:b8267ee)

mascot