Moving users into a user group based on signature url and ...

[John Lester]

Originally Posted by Scanu

Did you try this?
<snip>

Hi I did indeed, the query executed successfully, but the users user group wasn't changed.

It might be an issue with the user, I'll have to adjust the lastactive time and see if that works.

--------------- Added [DATE]1347775503[/DATE] at [TIME]1347775503[/TIME] ---------------

So I decided I could live without using lastvisit since I'm already checking signature url and post count.

UPDATE user LEFT JOIN usertextfield ON (user.userid = usertextfield.userid)
SET usergroupid = 3
WHERE signature LIKE '%google%'
AND posts = 0

Funny enough, if I use the code I posted first and leave off the lastvisit time, it moves all users with zero posts regardless of what's in their signature. *shrug* I would love to go to school and learn the bass ackwards logic the codes seems to like