Add custom MySQL query in Admin CP drop-down

[djbaxter]

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



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Add before



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Find



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Add before



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



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.

[Been Told]

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

[msibm]

Nice!
Thanks!

[ZomgStuff]

Reserved! Thanks!

[gator777]

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

[TMSBrad]

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