OPTIONS, Pixelpost version 1.6 users can find it under GENERAL INFO

Based on the wonderful WordPress-DBManager by Lester Chan.

© 2008, Dennis Mooibroek || Check for update || If you like this addon you might want to buy me a coffee or another beverage.

"; $querystr = "SELECT version FROM {$pixelpost_db_prefix}version ORDER BY version DESC LIMIT 1"; $query = mysql_query($querystr); if($query){ if( $row = mysql_fetch_array( $query)) { $installed_version =$row[0]; } } if( $installed_version > 1.515){ $addon_workspace = "info"; $addon_menu = "info"; } else { $addon_workspace = "options"; $addon_menu = "options"; } $addon_admin_submenu = "DBManager"; $addon_function_name = "Show_DBManager_Interface"; add_admin_functions($addon_function_name,$addon_workspace,$addon_menu,$addon_admin_submenu); add_admin_functions('Show_HTML_Head','admin_html_head','',''); add_admin_functions('Automatic_Optimize_All_Tables','admin_html_head','',''); //******************************************************************************************************************* // DATABASE INITIALISATION //******************************************************************************************************************* $query = "SELECT * FROM {$pixelpost_db_prefix}DBManager LIMIT 1"; if( !mysql_query( $query ) ) { // Create table with default values. $query = "CREATE TABLE ".$pixelpost_db_prefix."DBManager ( id SMALLINT( 1 ) NOT NULL AUTO_INCREMENT PRIMARY KEY, mysqldump_path VARCHAR(100) NOT NULL default '', mysql_path VARCHAR(100) NOT NULL default '', backup_path VARCHAR(100) NOT NULL default '', drop_database ENUM('y','n') NOT NULL DEFAULT 'y', empty_tables ENUM('y','n') NOT NULL DEFAULT 'y', adv_backup ENUM('y','n') NOT NULL DEFAULT 'n', del_sql ENUM('y','n') NOT NULL DEFAULT 'n', ftpserver VARCHAR(100) NOT NULL default '', ftpuser VARCHAR(100) NOT NULL default '', ftppath VARCHAR(100) NOT NULL default '', ftppassive ENUM('y','n') NOT NULL DEFAULT 'n' )"; mysql_query( $query ) OR die(mysql_error()); $query = "INSERT INTO ".$pixelpost_db_prefix."DBManager(id,mysqldump_path,mysql_path, backup_path,ftpserver,ftpuser,ftppath) VALUES ('','NOT SET!','NOT SET!','NOT SET!','NOT SET!','NOT SET!','NOT SET!')"; mysql_query( $query ) OR die(mysql_error()); } //******************************************************************************************************************* // DOWNLOAD FUNCTION! //******************************************************************************************************************* if ((isset($_GET['file'])) && (isset($_GET['dl'])) && (intval($_GET['dl']) == 1)) { $DBMan_backup=sql_array("select * from {$pixelpost_db_prefix}DBManager LIMIT 1"); $backup_path = $DBMan_backup['backup_path']; $file =trim($_GET['file']); if(strpos($file, '../') !== false || strpos($file, './') !== false || strpos($file, '//') !== false) { die('Invalid Directory'); } $temp = explode('/', $file); $file_name = $temp[(sizeof($temp)-1)]; ### Get File Extension $file_ext = explode('.', $file_name); $file_ext = $file_ext[sizeof($file_ext)-1]; $file_ext = strtolower($file_ext); ### Check Whether File Exists if(!is_file($backup_path.'/'.$file)) { die('File Does Not Exist'); } if (($file_ext == 'sql') || ($file_ext == 'zip') || ($file_ext == 'gz')){ $file_name = preg_replace("/\s/e" , "_" , $file_name); header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); header("Content-Type: application/download"); if (($file_ext == 'zip') || ($file_ext == 'gz')){ header("Content-type: application/zip"); } else { header("Content-type: text/plain"); } header("Content-Disposition: attachment; filename=".basename($backup_path.'/'.$file_name).";"); header("Content-Transfer-Encoding: binary"); header("Content-Length: ".filesize($backup_path.'/'.$file)); @readfile($backup_path.'/'.$file); exit(); } else { die("Unsupported FileFormat"); } } //******************************************************************************************************************* // Automatic OPTIMIZE function upon login of the adminpanel //******************************************************************************************************************* function Automatic_Optimize_All_Tables() { ### Show Tables global $pixelpost_db_pixelpost; $query = "SHOW TABLE STATUS"; $qresult = mysql_query($query) or die( mysql_error() ); while($row = mysql_fetch_array($qresult)){$overhead_usage += $row['Data_free'];} if ($overhead_usage!= 0){ // optimize tables $query = "SHOW TABLES"; $qresult = mysql_query($query) or die( mysql_error() ); $firstrow=true; while($row = mysql_fetch_array($qresult)) { //construct if ($firstrow==true){ $optimizeQuery = 'OPTIMIZE TABLE '.$row['Tables_in_'.$pixelpost_db_pixelpost]; $firstrow = false; } else { $optimizeQuery .= ', '.$row['Tables_in_'.$pixelpost_db_pixelpost]; } } mysql_query($optimizeQuery) or die( mysql_error() ); } } //******************************************************************************************************************* // FUNCTIONS PROVIDING LAYOUT (FORMS AND STUFF) //******************************************************************************************************************* function Show_Database_Info_DBMan($text){ global $pixelpost_db_host, $pixelpost_db_pixelpost, $pixelpost_db_user, $pixelpost_db_prefix, $cfgrow; ### Get MYSQL Version $query = "SELECT VERSION() AS version"; $qresult = mysql_query($query) or die( mysql_error() ); if( $row = mysql_fetch_row($qresult) ){ $sqlversion = $row['0']; } if(!empty($text)) { echo '

'.$text.'

'; $text = "";} if ((!isset($_GET['structure'])) || ((isset($_GET['structure'])) && ($_GET['structure'] == "database"))) { echo '
» Database Information
Setting Value
Database MYSQL '.$sqlversion.'
Database Host '.$pixelpost_db_host.'
Database Name '.$pixelpost_db_pixelpost.'
Database User '.$pixelpost_db_user.'
Table Prefix '.$pixelpost_db_prefix.'
»Tables Information
'; // If MYSQL Version More Than 3.23, Get More Info if($sqlversion >= '3.23') { $query = "SHOW TABLE STATUS"; $qresult = mysql_query($query) or die( mysql_error() ); while($row = mysql_fetch_array($qresult)) { if($no%2 == 0) { $style = 'style=\'background-color: #eee\''; } else { $style = 'style=\'background-color: none\''; } $no++; $row['1']; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if ($row['Data_free']== 0){ echo "\n"; } else { echo "\n"; } echo "\n"; echo "\n"; echo "\n"; $row_usage += $row['Rows']; $data_usage += $row['Data_length']; $index_usage += $row['Index_length']; $overhead_usage += $row['Data_free']; echo "\n"; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ""; if ($overhead_usage== 0){ echo ""; } else { echo ""; } echo ""; } else { echo ''; } echo '
No. Tables Records Data Usage Index Usage Overhead Created Last Changed Structure
$no".$row['Name']."".number_format($row['Rows'])."".format_size($row['Data_length'])."".format_size($row['Index_length'])."".format_size($row['Data_free'])."".format_size($row['Data_free'])."".gmdate('d-M-Y @ H:i', strtotime($row['Create_time'])+(3600*$cfgrow['timezone']))."".gmdate('d-M-Y @ H:i', strtotime($row['Update_time'])+(3600*$cfgrow['timezone']))."view
Total:$no Tables".number_format($row_usage)."".format_size($data_usage)."".format_size($index_usage)."".format_size($overhead_usage)."".format_size($overhead_usage)."
Could Not Show Table Status Due To Your MYSQL Version Is Lower Than 3.23.
'; } elseif (isset($_GET['structure'])){ // do fields view $fields_for_table = $_GET['structure']; echo '
» Fields in Selected Table
'; $query_fields = "SHOW FULL COLUMNS FROM `".$fields_for_table."`"; $qresult_fields = mysql_query($query_fields) or die( mysql_error() ); while($row = mysql_fetch_array($qresult_fields)) { if($no%2 == 0) { $style = 'style=\'background-color: #eee\''; } else { $style = 'style=\'background-color: none\''; } $no++; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } $querystr = "SELECT version FROM {$pixelpost_db_prefix}version ORDER BY version DESC LIMIT 1"; $query = mysql_query($querystr); if($query){ if( $row = mysql_fetch_array( $query)) { $installed_version =$row[0]; } } if( $installed_version > 1.515){ $link="index.php?view=info&infoview=dbmanager"; } else { $link="index.php?view=options&optionsview=dbmanager"; } echo '
Fields Type Collation Key Default Extra Privileges Comment
".$row['Field']."".$row['Type']."".$row['Collation']."".$row['Key']."".$row['Default']."".$row['Extra']."".$row['Privileges']."".$row['Comment']."
Go Back
'; } } function Show_Drop_Fields_DBMan($text){ global $pixelpost_db_pixelpost; if(!empty($text)) { echo '

'.$text.'

'; $text = "";} if (isset($_POST['fieldstable'])){ $fields_for_table = $_POST['fieldstable']; } $selected="first"; echo '
» Select Table

» Fields in Selected Table
'; $query_fields = "SHOW FULL COLUMNS FROM `".$fields_for_table."`"; $qresult_fields = mysql_query($query_fields) or die( mysql_error() ); while($row = mysql_fetch_array($qresult_fields)) { if($no%2 == 0) { $style = 'style=\'background-color: #eee\''; } else { $style = 'style=\'background-color: none\''; } $no++; echo "\n"; echo "\n"; echo "\n"; echo ""; } echo '
Fields Type Empty Drop
".$row['Field']."".$row['Type']." Empty Drop
1. DROPPING a field means deleting the field. This action is not REVERSIBLE.
2. EMPTYING a field means all the rows in the field will be deleted. This action is not REVERSIBLE.
   
'; } function Show_Drop_Tables_DBMan($text){ ### Show Tables global $pixelpost_db_pixelpost; if(!empty($text)) { echo '

'.$text.'

'; $text = "";} echo '
» Empty/Drop Tables
'; $query = "SHOW TABLES"; $qresult = mysql_query($query) or die( mysql_error() ); while($row = mysql_fetch_array($qresult)) { if($no%2 == 0) { $style = 'style=\'background-color: #eee\''; } else { $style = 'style=\'background-color: none\''; } $no++; echo "\n"; echo ""; echo ""; } echo '
Tables Empty Drop
".$row['Tables_in_'.$pixelpost_db_pixelpost]." Empty Drop
1. DROPPING a table means deleting the table. This action is not REVERSIBLE.
2. EMPTYING a table means all the rows in the table will be deleted. This action is not REVERSIBLE.
   
'; } function Show_Backup_DBman($text){ global $pixelpost_db_prefix, $pixelpost_db_pixelpost, $cfgrow; ### Backup File Name ### MYSQL Options $DBMan_backup=sql_array("select * from {$pixelpost_db_prefix}DBManager LIMIT 1"); $backup_path = $DBMan_backup['backup_path']; $drop_database = $DBMan_backup['drop_database']; $empty_tables = $DBMan_backup['empty_tables']; if(!empty($text)) { echo '

'.$text.'

'; $text = "";} echo '
» Checking Backup Status

Checking Backup Folder ('.stripslashes($backup_path).') ...
'; if(is_dir(stripslashes($backup_path))) { echo 'Backup folder exists
'; $status_count++; if(is_writable(stripslashes($backup_path))) { echo 'Backup folder is writable'; $status_count++; } else { echo 'Backup folder is NOT writable. Please CHMOD it to \'777\'.'; } } else { echo 'Backup folder does NOT exist. Please create a backup folder (e.g. \'backup-db\') in \'pixelpost\' folder and CHMOD it to \'777\'. Don\'t forget to change the location of the backup folder under the "Options" tab.
'; } echo '

'; if($status_count == 2) { echo 'Excellent. You Are Good To Go.'; } else { echo 'Please Rectify The Error Highlighted In Red Before Proceeding On.'; } echo '

» Backup Database

Please note these SQL dumps are compatible with PHPMyAdmin.

Database Name: '.$pixelpost_db_pixelpost.'
Database Backup To: '.$backup_path.'
Database Backup File Name: SQL_backup_'.date("Y-m-d_H.i.s").'.sql
Database Backup Type: '; if ($drop_database=="y"){ echo 'Full (Structure and Data): Database will be dropped!'; } else { if ($empty_tables=="y"){ echo 'Data Only: Tables will be emptied!'; } else { echo 'These settings will not work! If you want to restore data you need to empty the tables!'; } } echo '
ZIP Database Backup File? Yes  No
'; } function Show_AdvBackup_DBMan($text){ global $pixelpost_db_prefix, $pixelpost_db_pixelpost, $cfgrow; ### Backup File Name ### MYSQL Options $DBMan_backup=sql_array("select * from {$pixelpost_db_prefix}DBManager LIMIT 1"); $mysql_path = $DBMan_backup['mysql_path']; $mysqldump_path = $DBMan_backup['mysqldump_path']; $backup_path = $DBMan_backup['backup_path']; $mysql_basedir = '/'; if($mysql_basedir == '/') { $mysql_basedir = '/usr/'; } $status_count = 0; $stats_function_disabled = 0; $tz = $cfgrow["timezone"]; $current_date_time = gmdate($cfgrow['dateformat'],time() + (3600 * $tz)); $current_date_time = str_replace(" ","_",$current_date_time); $current_date_time = str_replace(":",".",$current_date_time); $backup['filename'] = $current_date_time.'_-_'.$pixelpost_db_pixelpost.'.sql'; if(!empty($text)) { echo '

'.$text.'

'; $text = "";} echo '
» Checking Advanced Backup Status

Checking Backup Folder ('.stripslashes($backup_path).') ...
'; if(is_dir(stripslashes($backup_path))) { echo 'Backup folder exists
'; $status_count++; } else { echo 'Backup folder does NOT exist. Please create \'backup-db\' folder in \'pixelpost\' folder and CHMOD it to \'777\' or change the location of the backup folder under the "Options" tab.
'; } if(is_writable(stripslashes($backup_path))) { echo 'Backup folder is writable'; $status_count++; } else { echo 'Backup folder is NOT writable. Please CHMOD it to \'777\'.'; } echo '

'; if(file_exists($mysql_basedir.'bin/'.stripslashes($mysqldump_path))) { echo 'Checking MYSQL Dump Path ('.$mysql_basedir.'bin/'.stripslashes($mysqldump_path).') ...
'; echo 'MYSQL dump path exists.'; $status_count++; } else if(file_exists(stripslashes($mysqldump_path))) { echo 'Checking MYSQL Dump Path ('.stripslashes($mysqldump_path).') ...
'; echo 'MYSQL dump path exists.'; $status_count++; } else { echo 'Checking MYSQL Dump Path ...
'; echo 'MYSQL dump path does NOT exist. Please check your mysqldump path under the "Options" tab. If uncertain, contact your server administrator.'; } echo '

'; if(file_exists($mysql_basedir.'bin/'.stripslashes($mysql_path))) { echo 'Checking MYSQL Path ('.$mysql_basedir.'bin/'.stripslashes($mysql_path).') ...
'; echo 'MYSQL path exists.'; $status_count++; } else if(file_exists(stripslashes($mysql_path))) { echo 'Checking MYSQL Path ('.stripslashes($mysql_path).') ...
'; echo 'MYSQL path exists.'; $status_count++; } else { echo 'Checking MYSQL Path ...
'; echo 'MYSQL path does NOT exist. Please check your mysql path under the "Options" tab. If uncertain, contact your server administrator.'; } echo '

Checking PHP Functions (passthru(), system() and exec()) ...
'; if(function_exists('passthru')) { echo 'passthru() enabled.
'; $status_count++; } else { echo 'passthru() disabled.
'; $stats_function_disabled++; } if(function_exists('system')) { echo 'system() enabled.
'; } else { echo 'system() disabled.
'; $stats_function_disabled++; } if(function_exists('exec')) { echo 'exec() enabled.'; } else { echo 'exec() disabled.'; $stats_function_disabled++; } echo '

'; if($status_count == 5) { echo 'Excellent. You Are Good To Go.'; } else if($stats_function_disabled == 3) { echo 'I\'m sorry, your server administrator has disabled passthru(), system() and exec(), thus you cannot use this backup script. You may consider using the default Pixelpost database backup script instead.'; } else { echo 'Please Rectify The Error Highlighted In Red Before Proceeding On.'; } echo '

Note: The checking of backup status is still undergoing testing, if you get a "Good To Go" status but can\'t perform the backup or you get some errors but still can perform the backup, please drop me an email.

» Advanced Backup Database
Database Name: '.$pixelpost_db_pixelpost.'
Database Backup To: '.$backup_path.'
Database Backup Date: '.$current_date_time.'
Database Backup File Name: '.$backup['filename'].'
Database Backup Type: Full (Structure and Data)
MYSQL Dump Location: '.$mysqldump_path.'
GZIP Database Backup File? Yes  No
'; } function Show_Manage_Backup_DBMan($text){ global $cfgrow, $pixelpost_db_prefix; $DBMan_backup=sql_array("select * from {$pixelpost_db_prefix}DBManager LIMIT 1"); $backup['path'] = $DBMan_backup['backup_path']; if(!empty($text)) { echo '

'.$text.'

'; $text = "";} echo '
» Manage Backup Database
'; if(!is_emtpy_folder($backup['path'])) { if ($handle = opendir($backup['path'])) { $database_files = array(); while (false !== ($file = readdir($handle))) { if ($file != '.' && $file != '..' && (file_ext($file) == 'sql' || file_ext($file) == 'gz' || file_ext($file) == 'zip')) { $database_files[] = array('name' => $file, 'ext' => file_ext($file) ,'date' => filemtime($backup['path'].'/'.$file), 'size' => filesize($backup['path'].'/'.$file) ); } } closedir($handle); usort($database_files, 'array_datesort'); foreach($database_files as $key => $value) { $file_name = $value['name']; $file_date = date('jS F Y @ H:i', $value['date']); $file_size = $value['size']; $file_ext = $value['ext']; if($no%2 == 0) { $style = 'style=\'background-color: #eee\''; } else { $style = 'style=\'background-color: none\''; } $no++; echo "\n"; if ($file_ext == "zip"){ echo ""; } else { echo ""; } echo ""; echo ''; echo "\n\n"; $totalsize += $file_size; } } else { echo ''; } } else { echo ''; } echo'
Choose A Backup Date To E-Mail, Restore, Download Or Delete
No. Database File DL link Date/Time Size Select
$no$file_name$file_namedownload$file_date'.format_size($file_size).'
There Are No Database Backup Files Available
There Are No Database Backup Files Available
'.$no.' Backup File(s) '.format_size($totalsize).'  
E-mail database backup file to:   
FTP database backup using password:   
Please note: all other FTP connection settings are in set in the Options tab.
  
'; } function Show_SQL_DBMan($text) { if(!empty($text)) { echo '

'.$text.'

'; $text = "";} echo '
» Run SQL Query

Seperate Multiple Queries With A New Line
Use Only INSERT, UPDATE, REPLACE, DELETE, CREATE and ALTER statements.

1. CREATE statement will return an error, which is perfectly normal due to the database class. To confirm that your table has been created check the Manage Database page.
2. UPDATE statement may return an error sometimes due to the newly updated value being the same as the previous value.
3. ALTER statement will return an error because there is no value returned.

'; } function Show_Options_DBMan($text) { global $pixelpost_db_prefix,$admin_lang_optn_yes,$admin_lang_optn_no; if(!empty($text)) { echo '

'.$text.'

'; $text = "";} $DBMan_backup=sql_array("select * from {$pixelpost_db_prefix}DBManager LIMIT 1"); $backup_options['mysqlpath'] = $DBMan_backup['mysql_path']; $backup_options['mysqldumppath'] = $DBMan_backup['mysqldump_path']; $backup_options['path'] = $DBMan_backup['backup_path']; $backup_options['adv_backup'] = $DBMan_backup['adv_backup']; $backup_options['drop_database'] = $DBMan_backup['drop_database']; $backup_options['empty_tables'] = $DBMan_backup['empty_tables']; $backup_options['del_sql'] = $DBMan_backup['del_sql']; $backup_options['ftpserver'] = $DBMan_backup['ftpserver']; $backup_options['ftpuser'] = $DBMan_backup['ftpuser']; $backup_options['ftppath'] = $DBMan_backup['ftppath']; $backup_options['ftppassive'] = $DBMan_backup['ftppassive']; if (($backup_options['mysqldumppath']=="NOT SET!") || ($backup_options['mysqlpath']=="NOT SET!")){ $mysql_paths = detect_mysql(); if ($backup_options['mysqldumppath']=="NOT SET!"){ $backup_options['mysqldumppath']= $mysql_paths['mysqldump']; } if ($backup_options['mysqlpath']=="NOT SET!"){ $backup_options['mysqlpath']=$mysql_paths['mysql']; } } echo '
» DBManager Options
Path To Backup:
The path to your database backup folder without trailing slash. Make sure the folder is writable. ("backup-db" will point to the "backup-db" folder in "admin").
Add drop database: '; if ($backup_options['drop_database']=='y') $toecho = $admin_lang_optn_yes; else $toecho = $admin_lang_optn_no; if ($backup_options['drop_database']=='y') $optnecho = $admin_lang_optn_no; else $optnecho = $admin_lang_optn_yes; if ($backup_options['drop_database']=='y') $optnval = 'n'; else $optnval = 'y'; echo '
Add a "drop database" statement for the structure backup. This will effectively remove the whole database prior to restoring the structure.
Add empty tables: '; if ($backup_options['empty_tables']=='y') $toecho = $admin_lang_optn_yes; else $toecho = $admin_lang_optn_no; if ($backup_options['empty_tables']=='y') $optnecho = $admin_lang_optn_no; else $optnecho = $admin_lang_optn_yes; if ($backup_options['empty_tables']=='y') $optnval = 'n'; else $optnval = 'y'; echo '
Add a "empty_tables" statement for the data backup. This will effectively wipe all tables clean before restoring the data.
Delete SQL after zip: '; if ($backup_options['del_sql']=='y') $toecho = $admin_lang_optn_yes; else $toecho = $admin_lang_optn_no; if ($backup_options['del_sql']=='y') $optnecho = $admin_lang_optn_no; else $optnecho = $admin_lang_optn_yes; if ($backup_options['del_sql']=='y') $optnval = 'n'; else $optnval = 'y'; echo '
Delete the SQL file after the creation of the zip file was succesfull.
Advanced backup: '; if ($backup_options['adv_backup']=='y') $toecho = $admin_lang_optn_yes; else $toecho = $admin_lang_optn_no; if ($backup_options['adv_backup']=='y') $optnecho = $admin_lang_optn_no; else $optnecho = $admin_lang_optn_yes; if ($backup_options['adv_backup']=='y') $optnval = 'n'; else $optnval = 'y'; echo '
Use advanced backup (needs detailed information about the location of mysqldump and mysql.
'; if ($backup_options['adv_backup']=='y'){ echo '
» DBManager Advanced Options
Path To mysqldump:
The absolute path to mysqldump without trailing slash. If unsure, please email your server administrator about this.
The script tries to determine the correct paths automatically when the paths are not set. Make sure you UPDATE the options!
Path To mysql:
The absolute path to mysql without trailing slash. If unsure, please email your server administrator about this.
The script tries to determine the correct paths automatically when the paths are not set. Make sure you UPDATE the options!
'; } echo '
» DBManager FTP Options
FTP Server:
The name of the server you want to place the backup files.
FTP Username:
The FTP username needed to connect to the server mentioned above.
FTP Path:
The path on the server without trailing slash where the backups have to be copied to.
Use passive mode: '; if ($backup_options['ftppassive']=='y') $toecho = $admin_lang_optn_yes; else $toecho = $admin_lang_optn_no; if ($backup_options['ftppassive']=='y') $optnecho = $admin_lang_optn_no; else $optnecho = $admin_lang_optn_yes; if ($backup_options['ftppassive']=='y') $optnval = 'n'; else $optnval = 'y'; echo '
Use passive mode for filetransfers. Might fix connection problems.
'; if ($backup_options['adv_backup']=='y'){ echo '

Windows Server
For mysqldump path, you can try "mysqldump.exe".
For mysql path, you can try "mysql.exe".

Linux Server
For mysqldump path, normally is just "mysqldump".
For mysql path, normally is just "mysql".

'; } echo '
'; } //******************************************************************************************************************* // COMBINING LAYOUT OUTPUT //******************************************************************************************************************* function Show_HTML_Head(){ echo' '; } function Show_DBManager_Interface(){ global $cfgrow; global $pixelpost_db_prefix; $addon_version = "1.1"; $text = ""; if(isset($_POST['DBMan_action'])) { switch ($_POST['DBMan_action']) { case "Empty/Drop Selected Tables": $textDropEmpty .= DBMan_action_DropEmpty(); break; case "Empty/Drop Selected Fields": $textDropFields .= DBMan_action_DropFields(); break; case "Backup": $textBackup .= DBMan_action_Backup(); break; case "Advanced Backup": $textAdvBackup .= DBMan_action_Backup_Advanced(); break; case "E-Mail": $textManagerMail .= DBMan_action_ManagerMail(); break; case "FTP": $textManagerFTP .= DBMan_action_ManagerFTP(); break; case "Restore": $textRestore .= DBMan_action_ManagerRestore(); break; case "Delete": $textDelete .= DBMan_action_ManagerDelete(); break; case "Run": $textRun .= DBMan_action_SQL(); break; case "Update options": $textOptions .= DBMan_action_UpdateOptions(); break; } } echo '
'; if(isset($_POST['selected_dbtab'])) { echo '