wp-dbmanager / database-manager.php

database-manager.php in WP-DBManager 2.00, at database-manager.php

601 lines 24.3 KB

Raw Download Zip

1	<?php
2	/*
3	+----------------------------------------------------------------+
4	\| \|
5	\| WordPress 2.0 Plugin: WP-DBManager 2.00 \|
6	\| Copyright (c) 2005 Lester "GaMerZ" Chan \|
7	\| \|
8	\| File Written By: \|
9	\| - Lester "GaMerZ" Chan \|
10	\| - http://www.lesterchan.net \|
11	\| \|
12	\| File Information: \|
13	\| - Manage Your WordPress Database \|
14	\| - wp-admin/database-manager.php \|
15	\| \|
16	+----------------------------------------------------------------+
17	*/
18
19
20	### Require Admin Header
21	require_once('./admin.php');
22
23
24	### Variables Variables Variables
25	$title = __('Manage Database');
26	$this_file = 'database-manager.php';
27	$parent_file = 'database-manager.php';
28	$mode = trim($_GET['mode']);
29	$backup = array();
30	$backup['date'] = time();
31	$backup['mysqldumppath'] = 'mysqldump';
32	$backup['mysqlpath'] = 'mysql';
33	$backup['path'] = ABSPATH.'wp-backup-db/';
34
35
36	### Cancel
37	if(isset($_POST['cancel'])) {
38	Header('Location: database-manager.php');
39	exit();
40	}
41
42
43	### Format Bytes Into KB/MB
44	function format_size($rawSize) {
45	if ($rawSize / 1048576 > 1)
46	return round($rawSize/1048576, 1) . ' MB';
47	else if ($rawSize / 1024 > 1)
48	return round($rawSize/1024, 1) . ' KB';
49	else
50	return round($rawSize, 1) . ' bytes';
51	}
52
53
54	### Check Folder Whether There Is Any File Inside
55	function is_emtpy_folder($folder){
56	if(is_dir($folder) ){
57	$handle = opendir($folder);
58	while( (gettype( $name = readdir($handle)) != 'boolean')){
59	$name_array[] = $name;
60	}
61	foreach($name_array as $temp)
62	$folder_content .= $temp;
63
64	if($folder_content == '...')
65	return true;
66	else
67	return false;
68	closedir($handle);
69	}
70	else
71	return true; // folder doesnt exist
72	}
73
74
75	### Form Processing
76	if($_POST['do']) {
77	// Lets Prepare The Variables
78	$database_file = trim($_POST['database_file']);
79	$optimize = $_POST['optimize'];
80	$delete = $_POST['delete'];
81	$nice_file_date = date('l, jS F Y @ H:i', substr($database_file, 0, 10));
82
83	// Decide What To Do
84	switch($_POST['do']) {
85	case 'Backup':
86	$gzip = intval($_POST['gzip']);
87	if($gzip == 1) {
88	$backup['filename'] = $backup['date'].'_-_'.DB_NAME.'.sql.gz';
89	$backup['filepath'] = $backup['path'].'/'.$backup['filename'];
90	$backup['command'] = $backup['mysqldumppath'].' -h'.DB_HOST.' -u'.DB_USER.' -p'.DB_PASSWORD.' --add-drop-table '.DB_NAME.' \| gzip > '.$backup['filepath'];
91	} else {
92	$backup['filename'] = $backup['date'].'_-_'.DB_NAME.'.sql';
93	$backup['filepath'] = $backup['path'].'/'.$backup['filename'];
94	$backup['command'] = $backup['mysqldumppath'].' -h'.DB_HOST.' -u'.DB_USER.' -p'.DB_PASSWORD.' --add-drop-table '.DB_NAME.' > '.$backup['filepath'];
95	}
96	passthru($backup['command'], $error);
97	if(!is_writable($backup['path'])) {
98	$text = "<font color=\"red\">Database Failed To Backup On '".date('l, jS F Y @ H:i')."'. Backup Folder Not Writable</font>";
99	} elseif(filesize($backup['filepath']) == 0) {
100	unlink($backup['filepath']);
101	$text = "<font color=\"red\">Database Failed To Backup On '".date('l, jS F Y @ H:i')."'. Backup File Size Is 0KB</font>";
102	} elseif(!is_file($backup['filepath'])) {
103	$text = "<font color=\"red\">Database Failed To Backup On '".date('l, jS F Y @ H:i')."'. Invalid Backup File Path</font>";
104	} elseif($error) {
105	$text = "<font color=\"red\">Database Failed To Backup On '".date('l, jS F Y @ H:i')."'</font>";
106	} else {
107	$text = "<font color=\"green\">Database Backed Up Successfully On '".date('l, jS F Y @ H:i')."'</font>";
108	}
109	break;
110	case 'Restore':
111	if(!empty($database_file)) {
112	if(stristr($database_file, '.gz')) {
113	$backup['command'] = 'gunzip < '.$backup['path'].'/'.$database_file.' \| '.$backup['mysqlpath'].' -h'.DB_HOST.' -u'.DB_USER.' -p'.DB_PASSWORD.' '.DB_NAME;
114	} else {
115	$backup['command'] = $backup['mysqlpath'].' -h'.DB_HOST.' -u'.DB_USER.' -p'.DB_PASSWORD.' '.DB_NAME.' < '.$backup['path'].'/'.$database_file;
116	}
117	passthru($backup['command'], $error);
118	if($error) {
119	$text = "<font color=\"red\">Database On '$nice_file_date' Failed To Restore</font>";
120	} else {
121	$text = "<font color=\"green\">Database On '$nice_file_date' Restored Successfully</font>";
122	}
123	} else {
124	$text = '<font color="red">No Backup Database File Selected</font>';
125	}
126	break;
127	case 'Delete':
128	if(!empty($delete)) {
129	foreach($delete as $dbbackup) {
130	$nice_file_date = date('l, jS F Y @ H:i', substr($dbbackup, 0, 10));
131	if(is_file($backup['path'].'/'.$dbbackup)) {
132	if(!unlink($backup['path'].'/'.$dbbackup)) {
133	$text .= "<font color=\"red\">Unable To Delete Database Backup File On '$nice_file_date'</font><br />";
134	} else {
135	$text .= "<font color=\"green\">Database Backup File On '$nice_file_date' Deleted Successfully</font><br />";
136	}
137	} else {
138	$text = "<font color=\"red\">Invalid Database Backup File On '$nice_file_date'</font>";
139	}
140	}
141	} else {
142	$text = '<font color="red">No Backup Database File Selected</font>';
143	}
144	break;
145	case 'Download':
146	if(!empty($database_file)) {
147	$file_path = $backup['path'].'/'.$database_file;
148	$nice_file_name = date('jS_F_Y', substr($database_file, 0, 10)).'-'.substr($database_file, 13);
149	header("Pragma: public");
150	header("Expires: 0");
151	header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
152	header("Content-Type: application/force-download");
153	header("Content-Type: application/octet-stream");
154	header("Content-Type: application/download");
155	header("Content-Disposition: attachment; filename=".basename($nice_file_name).";");
156	header("Content-Transfer-Encoding: binary");
157	header("Content-Length: ".filesize($file_path));
158	@readfile($file_path);
159	} else {
160	$text = '<font color="red">No Backup Database File Selected</font>';
161	}
162	break;
163	case 'Optimize':
164	foreach($optimize as $key => $value) {
165	if($value == 'yes') {
166	$tables_string .= ', '.$key;
167	}
168	}
169	$selected_tables = substr($tables_string, 2);
170	if(!empty($selected_tables)) {
171	$optimize2 = $wpdb->query("OPTIMIZE TABLE $selected_tables");
172	if(!$optimize2) {
173	$text = "<font color=\"red\">Table(s) '$selected_tables' Failed To Be Optimized</font>";
174	} else {
175	$text = "<font color=\"green\">Table(s) '$selected_tables' Optimized Successfully</font>";
176	}
177	} else {
178	$text = '<font color="red">No Tables Selected</font>';
179	}
180	break;
181	case 'Run':
182	$sql_queries2 = trim($_POST['sql_query']);
183	$totalquerycount = 0;
184	$successquery = 0;
185	if($sql_queries2) {
186	$sql_queries = array();
187	$sql_queries2 = explode("\n", $sql_queries2);
188	foreach($sql_queries2 as $sql_query2) {
189	$sql_query2 = trim(stripslashes($sql_query2));
190	$sql_query2 = preg_replace("/[\r\n]+/", '', $sql_query2);
191	if(!empty($sql_query2)) {
192	$sql_queries[] = $sql_query2;
193	}
194	}
195	if($sql_queries) {
196	foreach($sql_queries as $sql_query) {
197	if (preg_match("/^\\s*(insert\|update\|replace\|delete\|create) /i",$sql_query)) {
198	$run_query = $wpdb->query($sql_query);
199	if(!$run_query) {
200	$text .= "<font color=\"red\">$sql_query</font><br />";
201	} else {
202	$successquery++;
203	$text .= "<font color=\"green\">$sql_query</font><br />";
204	}
205	$totalquerycount++;
206	} elseif (preg_match("/^\\s*(select\|drop\|show\|grant) /i",$sql_query)) {
207	$text .= "<font color=\"red\">$sql_query</font><br />";
208	$totalquerycount++;
209	}
210	}
211	$text .= "<font color=\"blue\">$successquery/$totalquerycount Query(s) Executed Successfully</font>";
212	} else {
213	$text = "<font color=\"red\">Empty Query</font>";
214	}
215	} else {
216	$text = "<font color=\"red\">Empty Query</font>";
217	}
218	break;
219	}
220	}
221
222
223	### Switch $mode
224	switch($mode) {
225	// Backup Database
226	case 'backup':
227	$title = __('Backup Database');
228	require("./admin-header.php");
229	$backup['filename'] = $backup['date'].'_-_'.DB_NAME.'.sql';
230	?>
231	<ul id="submenu">
232	<li><a href="database-manager.php"><?php _e('Manage Database'); ?></a></li>
233	<li><a href="database-manager.php?mode=backup" class="current"><?php _e('Backup DB'); ?></a></li>
234	<li><a href="database-manager.php?mode=optimize"><?php _e('Optimize DB'); ?></a></li>
235	<li><a href="database-manager.php?mode=restore"><?php _e('Restore/Download DB'); ?></a></li>
236	<li><a href="database-manager.php?mode=delete"><?php _e('Delete Backup DB'); ?></a></li>
237	<li class="last"><a href="database-manager.php?mode=run"><?php _e('Run SQL Query'); ?></a></li>
238	</ul>
239	<!-- Backup Database -->
240	<div class="wrap">
241	<h2>Backup Database</h2>
242	<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
243	<table width="100%" cellspacing="3" cellpadding="3" border="0">
244	<tr style='background-color: #eee'>
245	<th align="left" scope="row">Database Name:</th>
246	<td><?=DB_NAME?></td>
247	</tr>
248	<tr style='background-color: none'>
249	<th align="left" scope="row">Database Backup To:</th>
250	<td><?=$backup['path']?></td>
251	</tr>
252	<tr style='background-color: #eee'>
253	<th align="left" scope="row">Database Backup Date:</th>
254	<td><?=date('jS F Y', $backup['date'])?></td>
255	</tr>
256	<tr style='background-color: none'>
257	<th align="left" scope="row">Database Backup File Name:</th>
258	<td><?=$backup['filename']?> / <?=date('jS_F_Y', substr($backup['filename'], 0, 10)).'-'.substr($backup['filename'], 13);?></td>
259	</tr>
260	<tr style='background-color: #eee'>
261	<th align="left" scope="row">Database Backup Type:</th>
262	<td>Full (Structure and Data)</td>
263	</tr>
264	<tr style='background-color: none'>
265	<th align="left" scope="row">MYSQL Dump Location</th>
266	<td><?=$backup['mysqldumppath']?></td>
267	</tr>
268	<tr style='background-color: #eee'>
269	<th align="left" scope="row">GZIP Database Backup File?</th>
270	<td><input type="radio" name="gzip" value="1">Yes  <input type="radio" name="gzip" value="0" CHECKED>No</td>
271	</tr>
272	<tr>
273	<td colspan="2" align="center"><input type="submit" name="do" value="Backup" class="button">  <input type="submit" name="cancel" Value="Cancel" class="button"></td>
274	</tr>
275	</table>
276	</form>
277	</div>
278	<?php
279	break;
280	// Optimize Database
281	case 'optimize':
282	$title = __('Optimize Database');
283	require("./admin-header.php");
284	$tables = $wpdb->get_results("SHOW TABLES");
285	?>
286	<ul id="submenu">
287	<li><a href="database-manager.php"><?php _e('Manage Database'); ?></a></li>
288	<li><a href="database-manager.php?mode=backup"><?php _e('Backup DB'); ?></a></li>
289	<li><a href="database-manager.php?mode=optimize" class="current"><?php _e('Optimize DB'); ?></a></li>
290	<li><a href="database-manager.php?mode=restore"><?php _e('Restore/Download DB'); ?></a></li>
291	<li><a href="database-manager.php?mode=delete"><?php _e('Delete Backup DB'); ?></a></li>
292	<li class="last"><a href="database-manager.php?mode=run"><?php _e('Run SQL Query'); ?></a></li>
293	</ul>
294	<!-- Optimize Database -->
295	<div class="wrap">
296	<h2>Optimize Database</h2>
297	<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
298	<table width="100%" cellspacing="3" cellpadding="3" border="0">
299	<tr>
300	<th align="left" scope="col">Tables</th>
301	<th align="left" scope="col">Options</th>
302	</tr>
303	<?php
304	foreach($tables as $dbtable) {
305	if($no%2 == 0) {
306	$style = 'style=\'background-color: #eee\'';
307	} else {
308	$style = 'style=\'background-color: none\'';
309	}
310	$no++;
311	$table_name = '$dbtable->Tables_in_'.DB_NAME;
312	eval("\$table_name = \"$table_name\";");
313	echo "<tr $style><th align=\"left\" scope=\"row\">$table_name</th>\n";
314	echo "<td><input type=\"radio\" name=\"optimize[$table_name]\" value=\"no\">No  <input type=\"radio\" name=\"optimize[$table_name]\" value=\"yes\" CHECKED>Yes</td></tr>";
315	}
316	?>
317	<tr>
318	<td colspan="2" align="center">Database should be optimize once every month.</td>
319	</tr>
320	<tr>
321	<td colspan="2" align="center"><input type="submit" name="do" value="Optimize" class="button">  <input type="submit" name="cancel" Value="Cancel" class="button"></td>
322	</tr>
323	</table>
324	</form>
325	</div>
326	<?php
327	break;
328	// Restore Database
329	case 'restore':
330	$title = __('Restore/Download Database');
331	require("./admin-header.php");
332	?>
333	<ul id="submenu">
334	<li><a href="database-manager.php"><?php _e('Manage Database'); ?></a></li>
335	<li><a href="database-manager.php?mode=backup"><?php _e('Backup DB'); ?></a></li>
336	<li><a href="database-manager.php?mode=optimize"><?php _e('Optimize DB'); ?></a></li>
337	<li><a href="database-manager.php?mode=restore" class="current"><?php _e('Restore/Download DB'); ?></a></li>
338	<li><a href="database-manager.php?mode=delete"><?php _e('Delete Backup DB'); ?></a></li>
339	<li class="last"><a href="database-manager.php?mode=run"><?php _e('Run SQL Query'); ?></a></li>
340	</ul>
341	<!-- Restore/Download Database -->
342	<div class="wrap">
343	<h2>Restore/Download Database</h2>
344	<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
345	<table width="100%" cellspacing="3" cellpadding="3" border="0">
346	<tr>
347	<th align="left" scope="row" colspan="5">Choose A Backup Date To Restore Or Download</th>
348	</tr>
349	<tr>
350	<th align="left" scope="col">No.</th>
351	<th align="left" scope="col">Database File</th>
352	<th align="left" scope="col">Date/Time</th>
353	<th align="left" scope="col">Size</th>
354	<th align="left" scope="col">Select</th>
355	</tr>
356	<?php
357	if(!is_emtpy_folder($backup['path'])) {
358	if ($handle = opendir($backup['path'])) {
359	$database_files = array();
360	while (false !== ($file = readdir($handle))) {
361	if ($file != '.' && $file != '..') {
362	$database_files[] = $file;
363	}
364	}
365	closedir($handle);
366	for($i = (sizeof($database_files)-1); $i > -1; $i--) {
367	if($no%2 == 0) {
368	$style = 'style=\'background-color: #eee\'';
369	} else {
370	$style = 'style=\'background-color: none\'';
371	}
372	$no++;
373	$database_text = substr($database_files[$i], 13);
374	$date_text = date('l, jS F Y @ H:i', substr($database_files[$i], 0, 10));
375	$size_text = filesize($backup['path'].'/'.$database_files[$i]);
376	echo "<tr $style>\n<td>$no</td>";
377	echo "<td>$database_text</td>";
378	echo "<td>$date_text</td>";
379	echo '<td>'.format_size($size_text).'</td>';
380	echo "<td><input type=\"radio\" name=\"database_file\" value=\"$database_files[$i]\" /></td>\n</tr>\n";
381	$totalsize += $size_text;
382	}
383	} else {
384	echo '<tr><td align="center" colspan="5">There Are No Database Backup Files Available</td></tr>';
385	}
386	} else {
387	echo '<tr><td align="center" colspan="5">There Are No Database Backup Files Available</td></tr>';
388	}
389	?>
390	</tr>
391	<tr>
392	<th align="left" colspan="3"><?=$no?> Backup File(s)</th>
393	<th align="left"><?=format_size($totalsize)?></th>
394	<td> </td>
395	</tr>
396	<tr>
397	<td colspan="5" align="center"><input type="submit" name="do" value="Download" class="button">  <input type="submit" class="button" name="do" value="Restore" onclick="return confirm('You Are About To Restore A Database.\nThis Action Is Not Reversible.\nAny Data Inserted After The Backup Date Will Be Gone.\n\n Choose \'Cancel\' to stop, \'OK\' to restore.')" class="button">  <input type="submit" name="cancel" Value="Cancel" class="button"></td>
398	</tr>
399	</table>
400	</form>
401	</div>
402	<?php
403	break;
404	// Delete Database Backup Files
405	case 'delete':
406	$title = __('Delete Backup Database');
407	require("./admin-header.php");
408	?>
409	<ul id="submenu">
410	<li><a href="database-manager.php"><?php _e('Manage Database'); ?></a></li>
411	<li><a href="database-manager.php?mode=backup"><?php _e('Backup DB'); ?></a></li>
412	<li><a href="database-manager.php?mode=optimize"><?php _e('Optimize DB'); ?></a></li>
413	<li><a href="database-manager.php?mode=restore"><?php _e('Restore/Download DB'); ?></a></li>
414	<li><a href="database-manager.php?mode=delete" class="current"><?php _e('Delete Backup DB'); ?></a></li>
415	<li class="last"><a href="database-manager.php?mode=run"><?php _e('Run SQL Query'); ?></a></li>
416	</ul>
417	<!-- Delete Database Backup Files -->
418	<div class="wrap">
419	<h2>Delete Database Backup Files</h2>
420	<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
421	<table width="100%" cellspacing="3" cellpadding="3" border="0">
422	<tr>
423	<th align="left" scope="row" colspan="5">Choose Database Backup Files To Delete</th>
424	</tr>
425	<tr>
426	<th align="left" scope="col">No.</th>
427	<th align="left" scope="col">Database File</th>
428	<th align="left" scope="col">Date/Time</th>
429	<th align="left" scope="col">Size</th>
430	<th align="left" scope="col">Select</th>
431	</tr>
432	<?php
433	if(!is_emtpy_folder($backup['path'])) {
434	if ($handle = opendir($backup['path'])) {
435	$database_files = array();
436	while (false !== ($file = readdir($handle))) {
437	if ($file != '.' && $file != '..') {
438	$database_files[] = $file;
439	}
440	}
441	closedir($handle);
442	for($i = (sizeof($database_files)-1); $i > -1; $i--) {
443	if($no%2 == 0) {
444	$style = 'style=\'background-color: #eee\'';
445	} else {
446	$style = 'style=\'background-color: none\'';
447	}
448	$no++;
449	$database_text = substr($database_files[$i], 13);
450	$date_text = date('l, jS F Y @ H:i', substr($database_files[$i], 0, 10));
451	$size_text = filesize($backup['path'].'/'.$database_files[$i]);
452	echo "<tr $style>\n<td>$no</td>";
453	echo "<td>$database_text</td>";
454	echo "<td>$date_text</td>";
455	echo '<td>'.format_size($size_text).'</td>';
456	echo "<td><input type=\"checkbox\" name=\"delete[]\" value=\"$database_files[$i]\" /></td>\n</tr>\n";
457	$totalsize += $size_text;
458	}
459	} else {
460	echo '<tr><td align="center" colspan="5">There Are No Database Backup Files Available</td></tr>';
461	}
462	} else {
463	echo '<tr><td align="center" colspan="5">There Are No Database Backup Files Available</td></tr>';
464	}
465	?>
466	</tr>
467	<tr>
468	<th align="left" colspan="3"><?=$no?> Backup File(s)</th>
469	<th align="left"><?=format_size($totalsize)?></th>
470	<td> </td>
471	</tr>
472	<tr>
473	<td colspan="5" align="center"><input type="submit" class="button" name="do" value="Delete" onclick="return confirm('You Are About To Delete The Selected Database Backup Files.\nThis Action Is Not Reversible.\n\n Choose \'Cancel\' to stop, \'OK\' to delete.')">  <input type="submit" name="cancel" Value="Cancel" class="button"></td>
474	</tr>
475	</table>
476	</form>
477	</div>
478	<?php
479	break;
480	// Run SQL Query
481	case 'run':
482	$title = __('Run SQL Query');
483	require("./admin-header.php");
484	?>
485	<ul id="submenu">
486	<li><a href="database-manager.php"><?php _e('Manage Database'); ?></a></li>
487	<li><a href="database-manager.php?mode=backup"><?php _e('Backup DB'); ?></a></li>
488	<li><a href="database-manager.php?mode=optimize"><?php _e('Optimize DB'); ?></a></li>
489	<li><a href="database-manager.php?mode=restore"><?php _e('Restore/Download DB'); ?></a></li>
490	<li><a href="database-manager.php?mode=delete"><?php _e('Delete Backup DB'); ?></a></li>
491	<li class="last"><a href="database-manager.php?mode=run" class="current"><?php _e('Run SQL Query'); ?></a></li>
492	</ul>
493	<!-- Run SQL Query -->
494	<div class="wrap">
495	<h2>Run SQL Query</h2>
496	<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
497	<p><b>Seperate Multiple Queries With A New Line</b><br /><font color="green">Use Only INSERT, UPDATE, REPLACE, DELETE and CREATE statements.</font></p>
498	<p align="center"><textarea cols="150" rows="30" name="sql_query"></textarea></p>
499	<p align="center"><input type="submit" name="do" Value="Run" class="button">  <input type="submit" name="cancel" Value="Cancel" class="button"></p>
500	<p>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.<br />2. UPDATE statement may return an error sometimes due to the newly updated value being the same as the previous value.</font></p>
501	</form>
502	</div>
503	<?php
504	break;
505	// Database Information
506	default:
507	$title = __('Manage Database');
508	require("./admin-header.php");
509	// Get MYSQL Version
510	$sqlversion = $wpdb->get_var("SELECT VERSION() AS version");
511	?>
512	<ul id="submenu">
513	<li><a href="database-manager.php" class="current"><?php _e('Manage Database'); ?></a></li>
514	<li><a href="database-manager.php?mode=backup"><?php _e('Backup DB'); ?></a></li>
515	<li><a href="database-manager.php?mode=optimize"><?php _e('Optimize DB'); ?></a></li>
516	<li><a href="database-manager.php?mode=restore"><?php _e('Restore/Download DB'); ?></a></li>
517	<li><a href="database-manager.php?mode=delete"><?php _e('Delete Backup DB'); ?></a></li>
518	<li class="last"><a href="database-manager.php?mode=run"><?php _e('Run SQL Query'); ?></a></li>
519	</ul>
520	<?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?>
521	<!-- Database Information -->
522	<div class="wrap">
523	<h2>Database Information</h2>
524	<table width="100%" cellspacing="3" cellpadding="3" border="0">
525	<tr>
526	<th align="left" scope="col">Setting</th>
527	<th align="left" scope="col">Value</th>
528	</tr>
529	<tr>
530	<td>Database Host</td>
531	<td><?=DB_HOST?></td>
532	</tr>
533	<tr>
534	<td>Database Name</td>
535	<td><?=DB_NAME?></td>
536	</tr>
537	<tr>
538	<td>Database User</td>
539	<td><?=DB_USER?></td>
540	</tr>
541	<tr>
542	<td>Database Type</td>
543	<td>MYSQL</td>
544	</tr>
545	<tr>
546	<td>Database Version</td>
547	<td>v<?=$sqlversion?></td>
548	</tr>
549	</table>
550	</div>
551	<div class="wrap">
552	<h2>Tables Information</h2>
553	<table width="100%" cellspacing="3" cellpadding="3" border="0">
554	<tr>
555	<th align="left" scope="col">No.</th>
556	<th align="left" scope="col">Tables</th>
557	<th align="left" scope="col">Records</th>
558	<th align="left" scope="col">Data Usage</th>
559	<th align="left" scope="col">Index Usage</th>
560	<th align="left" scope="col">Overhead</th>
561	</tr>
562	<?php
563	// If MYSQL Version More Than 3.23, Get More Info
564	if($sqlversion >= '3.23') {
565	$tablesstatus = $wpdb->get_results("SHOW TABLE STATUS");
566	foreach($tablesstatus as $tablestatus) {
567	if($no%2 == 0) {
568	$style = 'style=\'background-color: #eee\'';
569	} else {
570	$style = 'style=\'background-color: none\'';
571	}
572	$no++;
573	echo "<tr $style>\n<td>$no</td>\n";
574	echo "<td>$tablestatus->Name</td>\n";
575	echo "<td>".number_format($tablestatus->Rows)."</td>\n";
576	echo "<td>".format_size($tablestatus->Data_length)."</td>\n";
577	echo "<td>".format_size($tablestatus->Index_length)."</td>\n";
578	echo "<td>".format_size($tablestatus->Data_free)."</td>\n";
579	$row_usage += $tablestatus->Rows;
580	$data_usage += $tablestatus->Data_length;
581	$index_usage += $tablestatus->Index_length;
582	$overhead_usage += $tablestatus->Data_free;
583	}
584	echo "<tr><th align=\"left\" scope=\"row\">Total:</th>\n";
585	echo "<th align=\"left\" scope=\"row\">$no Tables</th>\n";
586	echo "<th align=\"left\" scope=\"row\">".number_format($row_usage)."</th>\n";
587	echo "<th align=\"left\" scope=\"row\">".format_size($data_usage)."</th>\n";
588	echo "<th align=\"left\" scope=\"row\">".format_size($index_usage)."</th>";
589	echo "<th align=\"left\" scope=\"row\">".format_size($overhead_usage)."</th></tr>";
590	} else {
591	echo '<tr><td colspan="6" align="center"><b>Could Not Show Table Status Due To Your MYSQL Version Is Lower Than 3.23.</b></td></tr>';
592	}
593	?>
594	</table>
595	</div>
596	<?php
597	} // End switch($mode)
598
599	### Require Admin Footer
600	require_once 'admin-footer.php';
601	?>