Print Page - mysql query help

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: Tyrsson 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: Tyrsson 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: Tyrsson on July 28, 2011, 01:35:00 AM

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

Simple Machines Community Forum

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