Feature: Database Structs

[Tolfx]

A list of all structs of database tables we will have.

Servers

• uuid
• ip
• port
• rcon
• kills
• players (amount of players who has played)
• act_players
• max_players
• act_map
• lat?
• lang?
• server_name?

Players

• uuid
• name
• ip(s)
• server_id
• country
• lat?
• lang?

Chat

• uuid
• player_id
• server_id
• message

Points

• uuid
• player_id
• server_id
• points
• deaths
• session: SessionStruct { total_play_time, last_connect }

Bans

• uuid
• player_id
• server_id
• issued_at
• expires_at? (Can be optional, if we don't have it or if NULL is a perma ban)
• ip
• reason
• comment
• issued_by

Comms

• uuid
• type: gag | mute | silence (silence is both gag and mute)
• player_id
• server_id
• issued_at
• expires_at? (Can be optional, if we don't have it or if NULL is a perma gag/mute/silence)
• ip
• reason
• comment
• issued_by

Admins

• uuid
• steam_id
• name
• flags
• group_id
• immunity
• is_donator (Could change to a type, since we would like to have donators but not viewed as admins)
• web_flags (Create bits flags to indicate what power an user has in the web interface)

Groups

• uuid
• name
• flags
• web_flags

IP Block

• uuid
• ip?
• network?
• enabled
• name

[QtKaii]

GDPR concerns?

[Tolfx]

We are not collecting personal data such as their home address & full name etc. So collecting IP doesn't fall in there nor country,

[QtKaii]

Lat, Long, (and sadly, grey area is IP addresses)

Examples of personal data:

• a name and surname;
• a home address;
• an email address such as [email protected];
• an identification card number;
• location data (for example the location data function on a mobile phone)*;
• an Internet Protocol (IP) address;
• a cookie ID*;
• the advertising identifier of your phone;
• data held by a hospital or doctor, which could be a symbol that uniquely identifies a person.

This is a table provided by the europa commission.

I would say the collection of longitude and latitude + ip-addresses + country information, does qualify as PII (Personally Identifiable Information) as if even one user has a static ip (Which is wildly common for some ISPs, I know from experience).

Proposed fixes: Write a privacy policy, or we just don't collect data which has these grey areas.

[Tolfx]

Just don't include lat and lang, but honestly most stats systems have had this for decades in game servers. IP and Country will stay but lang and lat can be skipped.

[QtKaii]

LGTM