Need Query!

[Murty]

Hey,

I need a query that will allow me to reverse all the users options that allows them to have custom avatars and signatures. Someone told me to use this:

UPDATE (TABLE_PREFIX)user SET vbp_genericperm = vbp_genericperm & (-1 ^ 512);

and change (TABLE_PREFIX) to my table_prefix but it didnt work.

Need some help

Thanks

[Jake Bunce]

That query appears to be for vBPortal. That field is not a default field in the user table.

You can set the default for most user preferences in your:

Admin CP -> vBulletin Options -> User Registration Options -> Default Registration Options

You can mass update the preferences of exsiting users in your:

Admin CP -> Maintenance -> Execute SQL Query

There is a menu with predefined queries. You must have permission to execute queries in your includes/config.php file:

	//	****** USERS WITH QUERY RUNNING PERMISSIONS ******
	//	The users specified here will be allowed to run queries from the control panel.
	//	See the above entries for more information on the format.
	//	Please note that the ability to run queries is quite powerful. You may wish
	//	to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';

[Murty]

I dont think you understand what i am saying sorry.I had vbbux and vbplaza installed until yesterday, and users were able to purchase the right to have a custom signature and avatar. So once they bought it, it enabled the option in their UserCP. But i have removed vbbux and vbplaza and i want to reverse those options, so they can no longer customise their signatures and avatars.

[Jake Bunce]

You would have to contact the hack author for removal instructions. You say those options are from the hack, and I am not familiar with that hack.

[Murty]

lol...funny you should say that :P

the query above that doesnt work, is what he told me to do

[Murty]

I really need some help guys

[Zachery]

Sorry, we don't provide support for custom hacks and addons.

However check the usergroup permissions and ensure that your settings are correct.

[Murty]

well all this hack has done, is enable some options that i dont want enabled, and i have checked usergroup permission several times and they dont do anything.

[Lats]

Check here...

http://www.vbulletin.com/forum/showthread.php?p=1016921#post1016921

[Murty]

Thanks, but the ones i want are not there.

[Lats]

Okay, the custom avatar bit is a usergroup permission under 'General Permissions' however, there doesn't seem to be one for custom signature - perhaps that was part of a hack.

[Murty]

I am the biggest noob!! I forgot to readjust all my usergroup permissions. It all fine now, really sorry about this guys. Thanks for you help.