<?php

// This is a PLUGIN TEMPLATE.

// Copy this file to a new name like abc_myplugin.php. Edit the code, then

// run this file at the command line to produce a plugin for distribution:

// $ php abc_myplugin.php > abc_myplugin-0.1.txt

// Plugin name is optional. If unset, it will be extracted from the current

// file name. Uncomment and edit this line to override:

$plugin['name'] = 'rss_admin_db_manager';

$plugin['version'] = '4.3';

$plugin['author'] = 'Rob Sable';

$plugin['author_uri'] = 'http://www.wilshireone.com/';

$plugin['description'] = 'Database management system.';

// Plugin types:

// 0 = regular plugin; loaded on the public web side only

// 1 = admin plugin; loaded on both the public and admin side

// 2 = library; loaded only when include_plugin() or require_plugin() is called

$plugin['type'] = '1';

@include_once('zem_tpl.php');

# --- BEGIN PLUGIN CODE ---

if (@txpinterface == 'admin') {

add_privs('rss_db_man', '1');

register_tab("extensions", "rss_db_man", "DB Manager");

register_callback("rss_db_man", "rss_db_man");

add_privs('rss_sql_run', '1');

register_tab("extensions", "rss_sql_run", "Run SQL");

register_callback("rss_sql_run", "rss_sql_run");

add_privs('rss_db_bk', '1');

register_tab("extensions", "rss_db_bk", "DB Backup");

register_callback("rss_db_bk", "rss_db_bk");

}

function rss_db_bk($event, $step) {

}

function rss_db_man($event, $step) {

}

function rss_sql_run($event, $step) {

}

function prettyFileSize ($bytes) {

}

function is_folder_empty($dir) {

}

# --- END PLUGIN CODE ---

if (0) {

?>

<!--

# --- BEGIN PLUGIN HELP ---

<p>

h1. Textpattern Database Manager</p>

<p>The rss_admin_db_manager plugin adds 3 new tabs to your Textpattern admin interface. Each tab contains different functionality to help manage<br />

your <a href="http://www.mysql.com/">MySQL</a> database. You can think of this plugin as a lightweight replacement for <a href="http://www.phpmyadmin.net/home_page/">phpMyAdmin</a>.</p>

<h2>Database Backup</h2>

<p>The <strong>DB Backup tab</strong> allows you to backup, download and restore the MySQL database that is used for your Textpattern installation.<br />

The database backups and restores are run using MySQL&#8217;s <a href="http://dev.mysql.com/doc/mysql/en/mysqldump.html">mysqldump</a> command.<br />

On this tab you are able to:</p>

<ul>

<li>Create a .sql backup file on windows with the additional option of creating a gzipped backup on *nix operating systems</li>

<li>View a list of previous backup files</li>

<li>Restore your database from one of the previous backups</li>

<li>Download a backup file</li>

<li>Delete old backups</li>

</ul>

<h2>Backup Preferences</h2>

<p>You have the ability to set several preferences related to your database backups. You can set these options on the backup tab. The options include:</p>

<ul>

<li><strong>Lock Tables</strong> &#8211; Your host may or may not support this option. For example, by default, Textdrive doesn&#8217;t allow table locking. If your backup fails, try setting this to &#8220;No&#8221;.</li>

<li><strong>Debug Mode</strong> &#8211; Turning debugging on will echo the command being run to the screen.</li>

<li><strong>Backup Path</strong> &#8211; Set the directory that your backups will be saved to.</li>

<li><strong>Mysqldump Path</strong> &#8211; Its likely that the default will work for you. If not, enter the full path the the executable.</li>

<li><strong>Mysql Path</strong> &#8211; Its likely that the default will work for you. If not, enter the full path the the executable.</li>

</ul>

<h2>Database Manager</h2>

<p>The <strong>DB Manager tab</strong> displays information about your MySQL database and all of its tables. A detailed list includes the name of the table, number of rows and file space usage.<br />

You will also be alerted of any overhead or errors that need to be repaired. Tables can be repaired, dropped or backed up from this listing.</p>

<ul>

<li>Clicking on the name of the table will run a select * [table name] <span class="caps">SQL</span> statement and take you to the <strong>Run <span class="caps">SQL</span> tab</strong> to display the results.</li>

<li>Repair a single table in the listing by clicking the Repair link.</li>

<li>Repair all tables in the listing by clicking the Repair All link.</li>

<li>Backup a single table in the listing by clicking the Backup link.</li>

<li>Drop a single table in the listing by clicking the Drop link.</li>

</ul>

<h2>Run <span class="caps">SQL</span> Window</h2>

<p>The <strong>Run <span class="caps">SQL</span> tab</strong> allows for free form entry and execution of <span class="caps">SQL</span> statements. The <span class="caps">SQL</span> window accepts<br />

<span class="caps">SELECT</span>, <span class="caps">INSERT</span>, <span class="caps">UPDATE</span>, <span class="caps">CREATE</span>, <span class="caps">REPLACE</span>, <span class="caps">TRUNCATE</span>, and <span class="caps">DELETE</span> statements. If a <span class="caps">SELECT</span> statement is run, the results will be displayed to you below the <span class="caps">SQL</span> window in a table.<br />

The table markup allows you to add your own styles for creating a <a href="http://www.agavegroup.com/?p=31"><span class="caps">CSS</span> Scrollable Table</a>.</p>

<h2>Major Ransom Contributors</h2>

<p><ul>

<li>Jan Willem de Bruijn</li>

<li>Heikki Yl</li></ul></p>

# --- END PLUGIN HELP ---

-->

<?php

}

?>