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?
Last edited by aacircle; September 29th, 2007 at 08:02 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.
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.
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.
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" !!!!!