global->resources->db->table_prefix;
$dbhost = $xml->global->resources->default_setup->connection->host;
$dbuser = $xml->global->resources->default_setup->connection->username;
$dbpass = $xml->global->resources->default_setup->connection->password;
$dbname = $xml->global->resources->default_setup->connection->dbname;
}
else {
exit('Failed to open app/etc/local.xml');
}
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
mysql_select_db($dbname);
mysql_query("TRUNCATE " . $tblprefix . "dataflow_batch_export") or die (mysql_error());
mysql_query("TRUNCATE " . $tblprefix . "dataflow_batch_import") or die (mysql_error());
}
// Get the name of this script
$myname = $_SERVER["SCRIPT_NAME"];
// Check to see if we're truncating tables
$p = $_REQUEST['clear'];
if ($p) {
emptyTables();
echo "
Tables truncated!
";
}
// DB Interaction
if (file_exists('app/etc/local.xml')) {
$xml = simplexml_load_file('app/etc/local.xml');
$tblprefix = $xml->global->resources->db->table_prefix;
$dbhost = $xml->global->resources->default_setup->connection->host;
$dbuser = $xml->global->resources->default_setup->connection->username;
$dbpass = $xml->global->resources->default_setup->connection->password;
$dbname = $xml->global->resources->default_setup->connection->dbname;
}
else {
exit('Failed to open app/etc/local.xml');
}
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
mysql_select_db($dbname);
mysql_select_db($dbname);
$exportresult = mysql_query("SELECT COUNT(batch_id) FROM " . $tblprefix . "dataflow_batch_export") or die (mysql_error());
$importresult = mysql_query("SELECT COUNT(batch_id) FROM " . $tblprefix . "dataflow_batch_import") or die (mysql_error());
$numexportrows = mysql_fetch_array($exportresult);
$numimportrows = mysql_fetch_array($importresult);
$numexport = $numexportrows[0];
$numimport = $numimportrows[0];
// CSS for NexStyle
echo '
';
// DB info for user to see
echo '
