vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=126096

Add custom MySQL query in Admin CP drop-down
by djbaxter
08 Sep 2006 17:03

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.

Been Told 24 Nov 2006 20:50

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

msibm 21 Feb 2007 16:18

Nice!
Thanks!

ZomgStuff 21 Feb 2007 23:11

Reserved! Thanks!

gator777 23 Mar 2007 20:17

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

TMSBrad 28 Jul 2008 15:09

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


All times are GMT. The time now is 08:34.

Powered by vBulletin® Version 3.8.12
Copyright © 2019, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.