Version: 2.10, by jesus likes pie
Developer Last Online: Jul 2013
Category: Administrative and Maintenance Tools -
Version: 3.8.x
Rating:
Released: 04-10-2009
Last Update: 04-19-2009
Installs: 24
DB Changes Uses Plugins
Re-useable Code Translations
No support by the author.
My Queries by Rafael Lopez
04/10/2009 (m/d/y)
This mod allows you to store custom queries for later use. Simply define the query once, save it, and it'll appear under "Automatic Queries" in the
Admin CP - allowing you to run it again in a matter of seconds.
::: CHANGE LOG :::
v1.0 - original release
v2.0 - 4/12/09
-----New feature: Variables
-----A few bug fixes
v2.1 - 4/20/09
-----Saved queries can now be edited.
::: Installation :::
Extract product-my_queries.xml
Upload product-my_queries.xml by going to ADMIN CP --> PLUGINS AND PRODUCTS --> MANAGE PRODUCTS --> ADD/IMPORT PRODUCT
If you are upgrading then you should set "over-write" to yes.
And you're done!
As always with my releases, you are free to modify, distribute, derive work from, and translate this mod.
If you liked this mod you might also like my others:
MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1350' at line 6 Error Number : 1064
I think this would be great if there was some preset sample queries added to the text file for us to use Like one for deleting visitor messages of X user etc
________ Fix ps3
can only admins that have can run query permission run these? It looks like a useful mod, thanks for sharing.
It is integrated directly into the query page, so it will be hidden from admins who do not have that permission.
Quote:
Originally Posted by ahmed-samara
wooow it's nice work ...i will try now
Quote:
Originally Posted by ArnyVee
For those of us that are not so familiar with some of the backend functions like queries, could you explain what this would do or help us in doing?
Queries allow you to make mass-changes by running code. It's relatively advanced and has the potential to completely ruin your forum if you make a slip. With that said, most syntax errors end up with an error message which simply doesnt execute the query.
The query page already has examples. Like you could run a query to make everyone on your forum use the WYSIWYG editor. Or, like the person below you stated, you could run a query to delete ALL visitor messages of a specific user.
Things like that.
Quote:
Originally Posted by Sweeks
I think this would be great if there was some preset sample queries added to the text file for us to use Like one for deleting visitor messages of X user etc
This is functionality that will be added shortly. At the moment the example you gave wouldn't work well because that query would require a WHERE clause of something like
WHERE userid = 123
I'll be adding something to add "variables" to saved queries and so when you save a query you define the above as
WHERE userid = {userid}
and then you add "userid" as a variable, and then when you run the query vBulletin will ask you to fill in the variable "userid" to which you would enter "123".
Long answer short: right now this, could, for example reset everyone's invitations to whatever number you wanted. (Obviously this would require the invitation mod).
The key is that as it works at the moment, it can run any query which affects ALL users.
I cant wait for this added functionality, things like deleting all users private messages etc would be awesome too. Great work
________ LOW COST VAPORIZER
MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1350' at line 6 Error Number : 1064
MyQueries - Save custom SQL for future use Details »»
About Developer
DB Changes 
No support by the author.
04-11-2009, 04:27 AM
