Bored? Looking to kill some time? Want to chat with other SMF users? Join us in IRC chat or Discord
Started by Doug Heffernan, May 31, 2020, 12:24:45 PM
SELECT member_ip, COUNT(*) AS accounts_registered, GROUP_CONCAT(member_name) as names FROM smf_members GROUP BY member_ip HAVING COUNT( member_ip ) > 1;
SELECT poster_ip, COUNT( * ) AS multipe_posters, GROUP_CONCAT(poster_name) as posters FROM smf_messages GROUP BY poster_ip HAVING COUNT(DISTINCT poster_name) > 1;
Quote from: Decent_946 on June 06, 2020, 03:42:54 PMAnd also, mostly people are using dynamic IP. So it's possible that the IP of user will change occasionally. As in my case, my IP keeps changing on every visit. I look forward if this can be done with uniqueID of system or mac address. So this can actually avoid a user from registering multiple accounts from 1 machine.
Quote from: Arantor on June 07, 2020, 08:32:37 AMKind of shame that would be illegal in the EU
Quote from: Arantor on June 07, 2020, 08:36:47 AMIt would violate GDPR as well as not being part of the 'necessary cookies' such that you'd have to get users to accept explicitly.
Third Party CookiesThe site owner has set an additional cookie, smf_member_id, in addition to the standard cookies. This cookie is used to identify if you are logged in and it is used for website usage tracking.
Quote from: Arantor on June 07, 2020, 09:20:13 AMNo, it's not the webmaster's duty to inform. Their duty is to obtain permission before using such a cookie. Unless you facilitate such, which seems antithetical to the design and implementation, you have bigger problems.
Quote from: Arantor on June 07, 2020, 09:38:56 AMTry reading the legislation; user consent has to be obtained *before the cookies are delivered*. And the use for tracking requires explicit consent under the GDPR or as I have to deal with it, the Data Protection Act 2018.It really isn't enough to just 'inform users'.
Quote from: Arantor on June 07, 2020, 10:10:31 AMNo, for the kind of tracking you're doing, implied consent is not considered sufficient.But I only have to deal with this in a very practical and legal context, I've only presented on it at international conferences, and I've only had to actually talk to the regulators, I'm not nearly as equipped as someone on the internet.Sorry for trying to be cautious.
Quote from: Doug Heffernan on June 07, 2020, 09:53:40 AMAnd the user has the choice to either vist the website or not. And if the user visists said site, he/she has consented.
Quote from: m4z on June 07, 2020, 12:12:59 PMQuote from: Doug Heffernan on June 07, 2020, 09:53:40 AMAnd the user has the choice to either vist the website or not. And if the user visists said site, he/she has consented. That's not correct, see https://gdpr.eu/cookies/