Jump to content


Submitter

SUPPORT TOPIC File Information

  • Submitted: Mar 26 2009 10:13 AM
  • Last Updated: Feb 25 2014 06:14 PM
  • File Size: 57.16KB
  • Views: 6462
  • Downloads: 347
  • Supported Versions: IP.Board 3.1.x, IP.Board 3.2.x, IP.Board 3.3.x, IP.Board 3.4.x
  • Support Info: Support Topic.

Previous Versions

  • 22 Jul 2013 Download Saved Queries 1.2.1
  • 06 Apr 2012 Download Saved Queries 1.2.0
  • 12 Sep 2011 Download Saved Queries [3.2] 1.1.0

Download Saved Queries 1.2.2

* * * * * 10 Votes



Screenshots
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.

What's New in Version 1.2.2 (See full changelog)

  • Fixed issue with query with parameters,
  • Added new feature - last run time on queries list.


Screenshots

Screenshots Screenshots Screenshots Screenshots Screenshots Screenshots Screenshots Screenshots Screenshots



Other files you may be interested in ..





  • 1,972 Total Files
  • 19 Total Categories
  • 278 Total Authors
  • 499,535 Total Downloads
  • Delete My Account Latest File
  • Adriano Faria Latest Submitter

53 user(s) are online (in the past 30 minutes)

13 members, 39 guests, 0 anonymous users


+cofee_iv, Bing (1), +PasXal, +ValkyrieGaming, +Klaus J., ProEdvinas, Epic Beard Studios, Pan Otlet, +luber-forum, +Matt Medhat, +netspeed, +Michael Keith, Prozoreanu Alexandru, +Heitchel