<?=$titel;?>
0) {
while ($row = mysql_fetch_array($result)) {
if ($row['Pict'] <> "") {
$slet = $row['Pict'];
}
}
}
}
$sql = "UPDATE ".$tabel." SET Pict = '' WHERE Id= " . $id;
if (!(mysql_query($sql))) {
print $sql . "
";
return(mysql_error());
}
if ($slet != "") {
$filename = "../../grafik/artikler/" . $slet;
$filename2 = "../../grafik/artikler/thumbs200/" . $slet;
$filename3 = "../../grafik/artikler/thumbs100/" . $slet;
$filename4 = "../../grafik/artikler/thumbs440/" . $slet;
if (!(unlink($filename))){
print "Billedfejl";
}
if (!(unlink($filename2))){
print "Billedfejl - thumbs200";
}
if (!(unlink($filename3))){
print "Billedfejl - thumbs100";
}
if ($t<>"") {
if (!(unlink($filename4))){
print "Billedfejl - thumbs440";
}
}
}
}
function sletteaserpict($id) {
global $tabel;
$sql = "SELECT * FROM ".$tabel." WHERE Id= " . $id;
$result = mysql_query($sql);
if (is_resource($result)) {
if (mysql_num_rows($result)>0) {
while ($row = mysql_fetch_array($result)) {
if ($row['Teaserpict'] <> "") {
$slet = $row['Teaserpict'];
}
}
}
}
$sql = "UPDATE ".$tabel." SET Teaserpict = '' WHERE Id= " . $id;
if (!(mysql_query($sql))) {
print $sql . "
";
return(mysql_error());
}
if ($slet != "") {
$filename = "../../grafik/artikler/teaser200/" . $slet;
$filename2 = "../../grafik/artikler/teaser400/" . $slet;
if (!(unlink($filename))){
print "Billedfejl - teaser 200";
}
if (!(unlink($filename2))){
print "Billedfejl - teaser 400";
}
}
}
function url2link($txt) {
$username = "[a-z0-9_\-\.]+";
$password = "[a-z0-9_\-!#]+";
$host = "[a-z0-9\-]+\.[a-z0-9\-\.]+";
$port = "\d{1,5}";
$path = "\/[a-z0-9\/\-_\.\(\)\%#]*";
$querystr = "\?[a-z0-9&=\-_\.%\(\)#]+";
$proto = "(https?|ftp):\/\/";
$url = "$host(:$port)?($path($querystr)?)?";
$protodomain = "/$proto(($username(:$password)?@)?$url)/i";
$domain = "/(^| )(www\.$url)/im";
$protomail = "/mailto:($username@$host)/i";
$mail = "/(^| )($username@$host)/im";
$replacements = array(
$protodomain => "\\2"
,$domain => "\\1\\2"
,$protomail => "\\1"
,$mail => "\\1\\2"
);
return preg_replace( array_keys( $replacements ), array_values( $replacements ), $txt );
}
?>