• Welcome to Simple Machines Community Forum. Please login or sign up.
December 07, 2021, 04:27:27 PM

News:

SMF 2.1 RC4 has been released! Try it out and help us test! :) Read more.


mysql query help

Started by .Vapor, July 27, 2011, 05:10:34 PM

Previous topic - Next topic

.Vapor

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 :)

Joey Smith™

Uhm you dont need a query for that. Enable post count membergroups and create the group, set the post count ;)

Joey Smith™

The default is newbie I think if memory serves, dont delete that group.

Illori

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

Joey Smith™

Yea, which is why I posted *if memory serves*, been a minute since I checked ;)

Advertisement: