[jesus likes pie]

Originally Posted by hornstar1337

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.

Originally Posted by ahmed-samara

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

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.

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.