Mature Content - mass update via SQL

aacircle · September 29th, 2007, 06:31 AM

Hello,

SQL for a certain category
I have a heap of images in a certain category, and it would be too time consuming to manually edit each image and select the mature content to Yes. Does anyone know how I can just run an SQL job to update this flag to Yes for all images in a certain category?

SQL for all users
Furthermore, I think it's better to set EVERYONE's profile to Yes for block mature content. This is required by the law, and members need to actively accept or change their settings before we show them mature content. So can you please advise the SQL to update this for all members?

Thank you.

Chuck S · September 29th, 2007, 11:05 AM

UPDATE pp_photos SET ismature='yes' WHERE cat=blah blah

UPDATE pp_users SET mature='no'

aacircle · September 29th, 2007, 11:26 AM

Thank you.

UPDATE pp_photos SET ismature='yes' WHERE cat=blah blah

didn't work. Instead I used:

UPDATE pp_photos SET ismature='1' WHERE cat=blah blah

Thanks again.

Chuck S · September 29th, 2007, 12:46 PM

ok whichever works for you

kisii · March 25th, 2008, 03:24 AM

whats weird is that this will change the profiles of the existing users in the database and any new users BUT if you wend on the profile of the new users, it still reflects as "NO" even though you are not able to see mature content. I agree with aacircle, by default, this should be set as 'YES: so that users can only opt in to view mature content and hence be in compliant of the user agreement.

Chuck S · March 25th, 2008, 10:09 AM

default is no anything else you can set as you wish but this is an option the user sets.

kisii · March 25th, 2008, 12:03 PM

I ubderstand Chuck...but what we are saying ( i think) is that it means that so long as someone has registered to be a member, they automatically have access to mature content - right? Why cant it be that so long as someone who registers, they become just a member AND if they want to view mature content, they can set this setting "Do you want to block mature content? = NO" in their profile. That way you have registered members who want to view mature content and others who don't want to - voluntarily versus lumping every registered member to be able to view? - I hope that makes sense now - sorry for the confusion.

Chuck S · March 25th, 2008, 12:36 PM

Well it is all a matter of how someone views the philosophy. I beleive Michael looks at it as it is a users choose whether they want to see mature content the admins.

kisii · March 25th, 2008, 01:14 PM

any way that I can change it to "Do you want to block mature content? = YES" by default for new users?

Chuck S · March 25th, 2008, 01:34 PM

This is something they set when they register. You can try altering your database to make the default field yes but they still answer this on registration. You are free to post modification questions in THE MOD CORNER.

kisii · March 25th, 2008, 02:10 PM

That is only true when you have a stand alone install of PP. When you are using an integration like SMF, thats not an option during registration. I don't mean to be so persistent but i'm sure others will appreciate a workaround on this if Michael and yourself decide on this status quo "controversial philosophy" !!!!!

Chuck S · March 25th, 2008, 03:09 PM

Your free to modify the database as you choose. Queries where posted above.