If you want to add the username to the random quote, in index.php find:
PHP Code:
$randomquote = $DB_site->query_first('
SELECT quotes.* FROM ' . TABLE_PREFIX . 'quotes AS quotes
WHERE approved = 1 ' . $threshold . ' LIMIT ' . $row . ', 1
');
Replace that with:
PHP Code:
$randomquote = $DB_site->query_first('
SELECT quotes.*, user.username FROM ' . TABLE_PREFIX . 'quotes AS quotes
LEFT JOIN ' . TABLE_PREFIX . 'user AS user ON quotes.userid = user.userid
WHERE approved = 1 ' . $threshold . ' LIMIT ' . $row . ', 1
');
I don't see what you mean about the tables being messy. Could you post a screenshot? That's an interesting redesign of the random quote you've got going there.