Need help on adding something in PHPMyAdmin...

I’m installing WLPE on my website. Right now, all of my web users from PPP don’t have avatars, because PPP didn’t use MODx’s innate photo field.

The photo field is blank for all of them, so a search+replace won’t work. Does anyone know of a command for phpMyAdmin where it will add this code to everyone’s profile that doesn’t have any text in their photo field?



I’d rather not have to go through all 50+ profile’s fields and have to manually that to all of them...x_x.

I think the better solution to add a check in snippet which looks for the avatar, and if empty it uses the default one.

Or if the avatar field is a TV, no need for a snippet.

You can set the default value directly in the TV itself. Or use PHx with an ifempty or if... then...else clause which allow a different output if the field is empty = default avatar, if the field has a value = avatar field.

I’ve done it several times, works like a charm

Assuming your table prefix is the default "modx_"...


-sD-
Dr. Scotty Delicious, Scientist DFPA.

Quote from: Dr. at Sep 16, 2007, 07:43 AM

Assuming your table prefix is the default "modx_"...

UPDATE `modx_web_user_attributes`
SET `photo` = 'assets/snippets/webloginpe/userimages/default_user.jpg'
WHERE `photo` = ''

-sD-
Dr. Scotty Delicious, Scientist DFPA.

Thanks, that’s just what I needed.