Database Look Cleanup...

Have you ever noticed the look of the page when you optimize the DB or when you check the status of the DB? The layout is not the greatest is it? I've changed that.

Here's what you need to do:

1. Open the file inc/admin_db.php and right about line 40 you should see:

Code:

$vars['optimize'][] = LANG_DB_OPTIMIZING ." $table... " . table_status($table, 'Data_free') . LANG_DB_OPTIMIZED;

Now, change that line from whatever you have to this:

Code:

$vars['optimize'][] = "<TD WIDTH='40%' CLASS='mainTable'> " . LANG_DB_OPTIMIZING ." $table" . "</TD><TD WIDTH='60%' CLASS='mainTable'>" . table_status($table, 'Data_free') . LANG_DB_OPTIMIZED . "</TD>";

2. Next, open the inc/admin_db.html.php file and around line 92 you should see the following code (hint: it's the very end of this file):

Code:

<?php
} elseif ($_POST['suba'] == 'optimize') {
?>
<DIV CLASS="admin" ID="db">
<?php
    foreach($vars['optimize'] as $result) {
echo $result
    }
    ?>
</DIV>
<?php
}
?>

Or something of that sort....I had to do my best to remember what the original code looked like.

Now, change this section to this:

Code:

<?php
} elseif ($_POST['suba'] == 'optimize') {
?>
<DIV CLASS="admin" ID="db">
<?php
    foreach($vars['optimize'] as $result) {
?>
<TABLE BORDER="0" WIDTH="50%">
<TR><?php echo $result;?></TR>
</TABLE>
<?php
    }
    ?>
</DIV>
<?php
}
?>

That's it! Save your files and visit the Database page, then click on the "Database Status" button and the "Optimize Database" buttons. Much easier to read!