rah_sql_query
Published under current TXP projects
Tired of running little php line, or login to phpMyAdmin to run single, very simple query? Do you wish you could do it from Textpattern’s user-interface? Rah_sql_query brings SQL queries directly to backstage of all Textpattern installs. Run queries directly from Textpattern’s backend, nothing more or less. One field to type in, one button. One task.
Image: rah_sql_query
List of features
- Allows you to run SQL queries directly from Textpattern’s user-interface
- Very simple and clean admin panel.
Requirements
Minimum requirement:
- Textpattern 4.2.0 or newer.
Installation and usage
The general behavior stands:
- Navigate to your Textpattern install’s Plugins pane.
- Paste the downloaded plugin code to the plugin installer field.
- Click the button and run the automated setup program.
- When all done, just activate the plugin from the list of plugins.
- Now the new rah_sql_query is accessible under Extensions.
Changelog
Version 0.4
- Added: rah_ui classes to common elements for easier theming of the plugin interface.
- Changed: Make the navigation link and page title to use language strings.
- Changed: Use
set_pref()instead ofsafe_insert(). - Changed: Return uninstaller query’s status for TXP.
- Fix: Don’t spit out JavaScript to the top of the admin-side page if JavaScript is disabled.
Version 0.3
- Added privileges for the options link.
- Changed privileges back to Publisher and Editor (1 and 2 levels) in favor of the plugins pane’s options link.
Version 0.2
- Now the pane requires Publisher’s privaleges.
- Added language string support.
- Added confirmation dialog for extra safety.
- Added option to hide the safety notice.
- Now keeps the last run query in the field.
- Removed inline styles.
- Uses Textpattern’s message system to deliver the feedback messages.
- Now requires Textpattern version 4.2.0 or newer.
Version 0.1
- Initial release.