[Forum] Mass settings list

[valerios]

Hello there

Based on the following posts:

http://www.vbulletin.com/forum/showthread.php/374828-Mass-profile-change

and

http://www.vbulletin.com/forum/showthread.php/197826-Updating-Options-en-masse

Is it possibile to find a list of query to do to modify the settings?
Maybe you can create a post where the users ask the setting to do and you post the related query so step by step they cover the entire configuration on the forum.

For example I have to mass edit there settings:



in particular i have to change:
- Blog entry settings
- Blog Comment
- And all the setting regarding "View Blog " and " Leave Comment"

wich are the correct queries?

Thank you

[valerios]

Ok, Maybe I understand,

Execute sql Query:

For Other Member... :

UPDATE blog_user SET options_member = X

For Guest... :

UPDATE blog_user SET options_guest = X

For ignore user ... :

UPDATE blog_user SET options_ignore = X

For Buddy...:

UPDATE blog_user SET options_buddy = X

Replace X with the following numbers:

0 if none (no leave comment, no view blog)
1 if view blog
2 if leave a comment
3 if both

Please VB staff check and confirm !

[Bojeunx]

vBulletin Message
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'wiiso.blog_user' doesn't exist

I returned with this error please help!

[valerios]

What are you trying to do exactly?

What is exactly the query that are you writing?

that is mean that the table that you specify does not exist, and that error appear when:
- the table name specified is wrong (wrong name or mispelled).
- the table does not exist (so can not be updated).

why you typed "wiiso.blog_user" ?
did you have the product blog installed? is the table present in your database?

Please note do not do that online without perform a test offline, it is a suggestion.