email as mailto:jillyjunes at hotmail dot com

All about webserver configurations, PHP and databases.

Moderator: Thorsten

Post Reply
tedthrasher
Posts: 7
Joined: Tue Apr 20, 2004 2:41 pm

email as mailto:jillyjunes at hotmail dot com

Post by tedthrasher » Wed May 19, 2004 1:20 pm

is there a fix for this, it comes up in open questions?

thanks
sorry for the english...canadian guy..no culture...

Thorsten
Posts: 14720
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten » Wed May 19, 2004 1:39 pm

Hi,

you have to edit the printOpenQuestions() function in the file inc/functions.php:

Code: Select all

function printOpenQuestions()
{
	global $db, $sids, $sqltblpre, $msg2answer, $msgNoQuestionsAvailable;
	$categories = getCategories();
	
	$query = "SELECT id,ask_username,ask_usermail,ask_rubrik,ask_content,ask_date FROM ".$sqltblpre."faqfragen ORDER BY ask_date ASC";
	$result = $db->query($query);
	$output = "";
	if ($db->num_rows($result) > 0) {
		while ($row = $db->fetch_object($result)) {
			$output .= "\t<tr class=\"openquestions\">\n";
			$output .= "\t\t<td valign=\"top\" nowrap>".makeDate($row->ask_date)."<br><a href=\"mailto:".$row->ask_usermail."\">".$row->ask_username."</a></td>\n";
			$output .= "\t\t<td valign=\"top\"><b>".$categories[$row->ask_rubrik].":</b><br>".stripslashes($row->ask_content)."</td>\n";
        	$output .= "\t\t<td valign=\"top\"><a href=\"".$_SERVER["PHP_SELF"]."?".$sids."aktion=add&question=".rawurlencode($row->ask_content)."&rubrik=".$row->ask_rubrik."\">".$msg2answer."</a></td>\n";
    		$output .= "\t</tr>\n";
			}
		}
	else {
		$output = "\t<tr>\n\t\t<td colspan=\"3\">".$msgNoQuestionsAvailable."</td>\n\t</tr>\n";
		}
	return $output;
}
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Post Reply