Download Saved Queries 1.2.1

Gives you a place to store commonly used SQL queries so that they can be re-run later just by clicking a Run Query button as opposed to saving the full SQL code and running it manually in your SQL Toolbox. The same security checks that IPB uses in it's SQL Toolbox (making sure you can't DROP or FLUSH tables, or delete data out of admin_login_logs) is also enforced when using this application.

In addition, this application supports the ability to add 'parameters' to your queries. When you set up or edit a query, you can define these parameters, which are pieces of data you provide when you go to actually run the query. For example, you can set up a query that finds the 5 latest posts of a member, and the parameter would be the ID# of the member to find the posts for. When you run a query that contains parameters, it prompts you for this required information, which it then uses in the actual execution of the query.