Content last modified Sunday 12 October 2008
hop to #bottom
Categories:
Author:
Current version:
0.12
About It:
Get it:
Rate it:
  • Helpful?
  • 2 Yes
  • 0 No
Flag it:
Contact Reason [ ? ]

smd_query

If you ever get the urge to just dive into the TXP database and run an SQL query to do stuff, this could be the ticket. It’s a halfway house between the existing TXP tags/plugins and writing PHP directly. If you know SQL syntax, you can use this plugin as it allows you to run pretty much any SQL query you like and parse each row, one by one, via a form (or using the plugin as a container tag).

In true smd_ fashion you can specify that any input strings to the SQL queries are read from the current article, file or link fields (it does not currently read from the address bar, since that’s a huge security hole).

Use it wisely — carefully — and it might just touch the parts other plugins cannot reach, but if your database turns to spaghetti, it wasn’t me. Honest.

Article Request Count:
Keywords/tags:
Initially released:
22 May 2008
Posted here:
22 May 2008
Article modified:
14 Jul 2008

If there is a comment form at the Information URL, you may want to leave your comments/questions there or at the Forum thread for quicker feedback. Otherwise, comment away:

Your comment will NOT be submitted until you click the 'Submit' button on the next pageload.

Subscribe to this article's comments RSS feed. [ ? ]   View Recent Comments across the site. Get a Gravatar.

You know you want to visit the Archives.

Browse

Categories


Articles

There are also tag clouds, 'cause those are fun.
TxP · TxD · GG