Ok so I'm trying to move users from the registered user group into another user group if they have a certain url in their signature, have zero posts, and a certain lastvisit time.
This is the query I came up with;
Code:
UPDATE user SET usergroupid = 3
WHERE (SELECT userid
FROM usertextfield
WHERE signature LIKE 'google')
AND posts = 0
AND lastvisit = 1342328885
The attached picture is what happens in phpmyadmin.
No users get moved
Yes I have one user with the signature of
www.google.com with zero posts and a lastvisit of 1341119285. Doesn't do anything different if I replace = with another symbol ( < > <= >= ) in the lastvisit clause.
09-15-2012, 04:23 AM
Moving users into a user group based on signature url and ...
Hybrid Mode
