“;
while ($myrow = mysql_fetch_row($result)) {
echo “
$TEXT = $myrow[4];
$TEXT = preg_replace(“/([^\w\/])(www\.[a-z0-9\-]+\.[a-z0-9\-]+)/i”, “$1http://$2”, $TEXT);
$TEXT = preg_replace(“/([\w]+:\/\/[\w-?+!&;#~=\.\/\@]+[\w\/])/i”, “$1“, $TEXT);
$TEXT = preg_replace(“/([\w-?&;#~=\.\/]+\@(\[?)[a-zA-Z0-9\-\.]+\.([a-zA-Z]{2,3}|[0-9]{1,3})(\]?))/i”, “$1“, $TEXT);
$TEXT = preg_replace(“/\r\n|\r|\n/”, “
“, $TEXT);
$attachment = “”;
$filewouldbe = “”;
$filename = “”;
$filename = $myrow[5];
if ($myrow[1]) {
echo “
$myrow[1]
“;}
if ($filename) {
$filewouldbe = “/var/www/vhosts/biia.net/httpdocs/library/” . $filename;
}
if(file_exists($filewouldbe))
{
$attachment=”/library/$filename”;
echo “$myrow[2]“;
}
else {
echo “
$myrow[2]
“;
}
if ($myrow[3]) {
echo “
$myrow[3]
“;
}
if ($TEXT) {
echo “
$TEXT
“;
}
echo “
if ($attachment) {
echo “
}
echo “
}
echo ““;
?>