The last IP each user logged in with is stored in the userinfo table in the lastip column. So you could theoretically parse the IP down to xxx.xxx.xxx, and run an RLIKE ^xxx.xxx.xxx on the column where count() is less than 3. Maybe I'll add this in a future version, but if you want it now you're on your own.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2000-12-06
I guess the ip wont do it has to be macaddresses or something else since the ip changes in most modem users.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
How can one limit a user or an ip to have only one account, or lets say 3 in case there are several persons per computer.
This will avoid that some joker creates a batch which would create 100.000 accounts.
Any idea?
Regards
Carlita17
The last IP each user logged in with is stored in the userinfo table in the lastip column. So you could theoretically parse the IP down to xxx.xxx.xxx, and run an RLIKE ^xxx.xxx.xxx on the column where count() is less than 3. Maybe I'll add this in a future version, but if you want it now you're on your own.
I guess the ip wont do it has to be macaddresses or something else since the ip changes in most modem users.