Technically you could probably modify the sql into something really horrible to do this - but I wouldnt recommend trying. :)

Oh ok, thanks, then I won't try altering the SQL :D

I too must learn to read! I installed this mod but then got called away before I could make any changes. Consequently, I didn't get round to setting the Lurker cut off point to 0 until the next day. Of course, by then, I presume the daily check had been run and loads of my members have been moved to usergroup 0, which is preventing them accessing some parts of the forum and getting a message they have been banned.

Other than going through every member that hasn't made a post for 90 days, is there an easier way I can get them back to the registered users group from usergroup 0?

Many thanks

Try setting the lurker group as usergroup 2, it should then move them all to that next time it runs.

Otherwise you can just run a bit of SQL :

Paul, many thanks. I ran the SQL, which worked a treat!

Is there a lurker option for the 3.8.x mod ?

I only see inactive option. Thanks.

Nope, its only in the 4.0 version.

Thanks Paul M

OK can you help me structure an SQL query then please ? :)

basically to update a usergroup id if belongs to X where join date is before Y and activity after Z with posts less than A

example move users from registered ug to lurker ug if they registered before 2010-01-01 and visited the board after 2010-05-01 with posts less than 1

nvm

Wow! Exactly what I need! Will this work with 4.0.3? If so, count me in and I'll happily donate!
Managing users has been a real pain.