MyQueries - Save custom SQL for future use
 

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!


https://vborg.vbsupport.ru/external/2009/04/28.png

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:

Select Postbit [https://vborg.vbsupport.ru/showthread.php?t=203324]
Shared Admin Notes [https://vborg.vbsupport.ru/showthread.php?t=203326]
Internal Forums Closed Message/Reason [https://vborg.vbsupport.ru/showthread.php?t=207855]
Auto-Moderate Evading Banned Members [https://vborg.vbsupport.ru/showthread.php?t=207966]
Multi-Quote / Edit Integration [https://vborg.vbsupport.ru/showthread.php?t=210620]

Nice work, thank you!

Installed

man you have the same two lines posted in almost all threads LOL. Do you really install everything?

can only admins that have can run query permission run these? It looks like a useful mod, thanks for sharing.

wooow it's nice work ...i will try now :)

Ops !

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? :)

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

It is integrated directly into the query page, so it will be hidden from admins who do not have that permission.

:)

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.

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

what about my problem :)