mass moving members from one group to another without an active subscription

[StEaLtH666]

hi,

I currently run a large forum, and over the years and just recently we are trying to change our set-up.

However we have around 1000 members or more who don't have an active paid subscription in the group we also have our monthly paid subscribers.

I'm looking for a way to move all these members in one foul swoop from say group a to b, but don't have an active subscription.

I'm guessing it may be an sql query to run, but i am not that competent in sql and was wondering if anyone could lead me in the right direction please

Many thanks

[StEaLtH666]

anyone any ideas please?

[ChopSuey]

AdminCP > Users > Mass move users

[StEaLtH666]

thanks for your help, but i cant pick out those with no active paid subscription from that page.

any other ideas on how to achieve this please?

many thanks

[Marco van Herwaarden]

There is no buildin function for this

[StEaLtH666]

oks i had someone else figure this for me

the query was

PHP Code:

update user left join (select userid from subscriptionlog where expirydate > unix_timestamp()) sl using (userid) set usergroupid = 2 where usergroupid = 32 and sl.userid is null 


however i have a little mess left behind such as usertitles didnt change back, but i sorted this with

PHP Code:

UPDATE `user` SET `usertitle` = 'Stowaway' WHERE `usergroupid` = 34 


and so on for all those that were not right

however the problem i now have is that the users colour hasnt changed for some of them and the only way i have found to make it change is by manually altering their usergroup in the board software one by one.

I have tried rebuilding the user ranks and titles etc, but does anyone have any ideas how i can get them to display the correct colours again on the usersonline page and within their posts?

many thanks for anyone who can help