Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: .Vapor on July 27, 2011, 05:10:34 PM

Title: mysql query help
Post by: .Vapor on July 27, 2011, 05:10:34 PM
I would like to move users with zero posts into an "inactive" group. But my sql is bad to say the least....
What would i query to place zero posters into group "xxx"?

Thanks :)
Title: Re: mysql query help
Post by: Joey Smith™ on July 27, 2011, 08:24:26 PM
Uhm you dont need a query for that. Enable post count membergroups and create the group, set the post count ;)
Title: Re: mysql query help
Post by: Joey Smith™ on July 27, 2011, 08:25:13 PM
The default is newbie I think if memory serves, dont delete that group.
Title: Re: mysql query help
Post by: Illori on July 27, 2011, 08:26:28 PM
Quote from: Tyrsson™ on July 27, 2011, 08:25:13 PM
The default is newbie I think if memory serves, dont delete that group.

it is impossible via the admin interface to delete that group
Title: Re: mysql query help
Post by: Joey Smith™ on July 28, 2011, 01:35:00 AM
Yea, which is why I posted *if memory serves*, been a minute since I checked ;)