vBulletin Mods

I wanted a fast way to access the subscribed list for my forum newsletter, for which I had added a custom variable. The technique below could be used for any MySQL query that you may want to add to the predefined "Automatic Query" drop down list in the Admin CP.

Open /admincp/queries.php

Find

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Add before

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Find

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Add before

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

SAVE and UPLOAD.

You will need to edit the above for your own variable and table names, of course. Also do a FIND to ensure that the CASE is not already in use.

Nice! :)
I use that to insert a query to empty the chatbox. Thanks :)

Nice!
Thanks!

Reserved! Thanks!

Installed! I wish the VB guys would make this a feature. Thanks for the info. :D

Very nice. Used it for my Master Member List which includes custom profile fields. Thanks.