Code: Select all
SELECT user_id, username, user_regdate FROM `phpbb_users` WHERE user_type = 0 AND mot_last_login = 0
phpbb_users
accordingly.Hold on i did something wrong and i can't delete my post. need to re-run somethingMike-on-Tour wrote: ↑Wed Jun 17, 2020 6:27 amSounds indeed strange, the other two lists are working? You may check in the database itself by entering the following sql query in phpMyAdmin:If you chose another table prefix than 'phpbb_' please adjust the partCode: Select all
SELECT user_id, username, user_regdate FROM `phpbb_users` WHERE user_type = 0 AND mot_last_login = 0
phpbb_users
accordingly.
That is basically the query used within Userreminder so if you get users with this query and the users are not listed in the 'Protected members' field in the settings tab there is a problem with the extension. In this case it would be nice if I could see your version of the 'acp/registrated_only_module.php' file.
yup... i totally misunderstood the meaning. thanks for the helpMike-on-Tour wrote: ↑Wed Jun 17, 2020 4:56 pmThen those 7 users should show up on the Zeroposters list which is a totally different thing. Sleepers have been activated and never have logged in, Zeroposters have been activated, logged into your forum but don't post anything.
If the MySQL query returned an empty result I would assume that you don't have any Sleepers but 7 Zeroposters.