Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Add custom MySQL query in Admin CP drop-down Details »
Add custom MySQL query in Admin CP drop-down
Mod Version: 1.00, by djbaxter (Coder/Designer) djbaxter is offline
Developer Last Online: Nov 2017 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.6.0 Rating: (0 vote - 0 average) Installs: 11
Released: 08 Sep 2006 Last Update: Never Downloads: 3
Not Supported  

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.

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Comments
  #2  
Old 24 Nov 2006, 21:50
Been Told Been Told is offline
 
Join Date: Oct 2006
Nice!
I use that to insert a query to empty the chatbox. Thanks
Reply With Quote
  #3  
Old 21 Feb 2007, 17:18
msibm msibm is offline
 
Join Date: Aug 2002
Nice!
Thanks!
Reply With Quote
  #4  
Old 22 Feb 2007, 00:11
ZomgStuff's Avatar
ZomgStuff ZomgStuff is offline
 
Join Date: Feb 2007
Reserved! Thanks!
Reply With Quote
  #5  
Old 23 Mar 2007, 21:17
gator777's Avatar
gator777 gator777 is offline
 
Join Date: Feb 2005
Installed! I wish the VB guys would make this a feature. Thanks for the info.
Reply With Quote
  #6  
Old 28 Jul 2008, 16:09
TMSBrad TMSBrad is offline
 
Join Date: Jan 2007
Real name: Brad
Very nice. Used it for my Master Member List which includes custom profile fields. Thanks.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 10:55.

Layout Options | Width: Wide Color: