Moderators are group 3
so..
UPDATE ubbt_USER_PROFILE up
SET up.USER_GROUP_IMAGES='a:1:{i:1;s:1:"3";}'
WHERE up.USER_ID IN (
SELECT DISTINCT g.USER_ID
FROM ubbt_USER_GROUPS g
WHERE g.GROUP_ID=3)would enable the image for all group 3 members..
now if you are and admin AND a moderator (some boards do that), then it would change the admins too.. but this can then be 'fixed' by just running the same query after it for group 1 (change the 3's to 1's)