[Deyth]

Your query isn't checking quotes.approved = 1

[QUOTE=Giveit2u43]Yeah just noticed that as I was looking at the code.. I changed your query to:

$result_quote = $DB_site->query("
			SELECT quotes.*,user.username AS quotename FROM ".TABLE_PREFIX."quotes AS quotes
			LEFT JOIN ".TABLE_PREFIX."user AS user ON (user.userid = quotes.userid)
			ORDER BY rand() LIMIT 1
		");
	
		while ($quote = $DB_site->fetch_Array($result_quote)) {
			$randomquote[quoteid] = $quote[quoteid];
			$randomquote[quote] = $quote

	
	

			
				;
			$randomquote[author] = $quote[author];
			$randomquote[username] = $quote[quotename];
		}
		$DB_site->free_result($result_quote);
	
		eval('$showrandomquote .= "' . fetch_template('randomquote') . '";');
			
		

and then you can place $randomquote[username] where you want the submitters username to show