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'); } // DB Interaction $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die (); mysql_select_db($dbname); $result = mysql_query("SELECT * FROM " . $tblprefix . "cron_schedule") or die (mysql_error()); // CSS for NexStyle echo ' '; // DB info for user to see echo '

' . 'DB Host: ' . $dbhost . ' ' . 'DB User: ' . $dbuser . ' ' . 'DB Name: ' . $dbname . '.' . $tblprefix . '

'; // Set up the table echo " "; // Display the data from the query while ($row = mysql_fetch_array($result)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } // Close table and last few tags echo "

schedule_id	job_code	status	messages	created_at	scheduled_at	executed_at	finished_at
" . $row['schedule_id'] . "	" . $row['job_code'] . "	" . $row['status'] . "	" . $row['messages'] . "	" . $row['created_at'] . "	" . $row['scheduled_at'] . "	" . $row['executed_at'] . "	" . $row['finished_at'] . "

"; mysql_close($conn); ?>