time()) $spam=true; if ($t"; mysqli_query($dbc, "INSERT INTO `albums` (`name`,`tag`) VALUES ('".$d."','')") or die(mysqli_error($dbc)); } } } } if (($action=="update-fotos" && $admin!=0) || ($_GET["doupdate"]??"")=="jagraag") { $res=mysqli_query($dbc, "SELECT * FROM `albums` WHERE `id`='".mysqli_real_escape_string($dbc, $album)."'") or die(mysqli_error($dbc)); //' $a=mysqli_fetch_assoc($res); $f=explode(' ',$a["fotos"]); $dir=opendir("foto/".$a["name"]); echo "foto/".$a["name"]."
"; while ($d=readdir($dir)) { if (strpos(strtolower($d),".jpg")!=FALSE && substr(strtolower($d),0,4)!="tmb-") { echo "$d"; $res=mysqli_query($dbc, "SELECT * FROM `fotos` WHERE `album`='".mysqli_real_escape_string($dbc, $album)."' AND `file`='".mysqli_real_escape_string($dbc, $d)."'") or die(mysqli_error($dbc)); //' if (!mysqli_fetch_array($res)) { echo " is new."; $res=mysqli_query($dbc, "INSERT INTO `fotos` (`album`,`file`,`visible`,`tag`,`prio`) VALUES ('".mysqli_real_escape_string($dbc, $album)."','".mysqli_real_escape_string($dbc, $d)."','1','','0')") or die(mysqli_error($dbc)); } if (!file_exists("foto/".$a["name"].'/tmb-'.$d)) { echo " -> No thumbnail yet. Creating tmb-".$d."...
"; set_time_limit(30); flush(); chdir("foto/".$a["name"]."/"); system("exiftran -a -i ".$d); $img=imagecreatefromjpeg($d); chdir("../.."); $maxx=500; $maxy=600; //$maxx=400; $maxy=300; $sy=imagesy($img); $sx=imagesx($img); if ($sx>$maxx) { $sy=($maxx/$sx)*$sy; $sx=$maxx; } if ($sy>$maxy) { $sx=($maxy/$sy)*$sx; $sy=$maxy; } $tmb=imagecreatetruecolor($sx,$sy); imagecopyresampled($tmb,$img,0,0,0,0,$sx,$sy,imagesx($img),imagesy($img)); imagejpeg($tmb,"foto/".$a["name"].'/tmb-'.$d,95); } echo "
"; } } } if ($action=='update-tags' && $admin!=0) { $res=mysqli_query($dbc, "SELECT * FROM `albums` WHERE `id`='".$album."'") or die(mysqli_error($dbc)); //' $a=mysqli_fetch_assoc($res); $res=mysqli_query($dbc, "SELECT * FROM `fotos` WHERE `album`='".$album."' LIMIT $frompic,30"); $rethumb=0; while ($v=mysqli_fetch_assoc($res)) { if (isset($_REQUEST["vis_".$v["id"]])) $vs=1; else $vs=0; if (isset($_REQUEST["nobr_".$v["id"]])) $nbr=1; else $nbr=0; if (isset($_REQUEST["rotl_".$v["id"]])) { system('exiftran -i -p -2 "foto/'.$a["name"].'/'.$v["file"].'" "foto/'.$a["name"].'/tmb-'.$v["file"].'"'); echo htmlentities('exiftran -i -p -2 "foto/'.$a["name"].'/'.$v["file"].'" "foto/'.$a["name"].'/tmb-'.$v["file"].'"').'
'; } if (isset($_REQUEST["rotr_".$v["id"]])) { system('exiftran -i -p -9 "foto/'.$a["name"].'/'.$v["file"].'" "foto/'.$a["name"].'/tmb-'.$v["file"].'"'); echo htmlentities('exiftran -p -9 "foto/'.$a["name"].'/'.$v["file"].'" "foto/'.$a["name"].'/tmb-'.$v["file"].'"').'
'; } // echo $vs."
"; mysqli_query($dbc, "UPDATE `fotos` SET `tag`='".mysqli_real_escape_string($dbc, $_REQUEST["tag-".$v["id"]])."', `visible`='".$vs."', `nobr`='".$nbr."', `pos`='".$_REQUEST["pos_".$v["id"]]."' WHERE `id`='".$v["id"]."'") or die(mysqli_error($dbc)); //' } } if ($album=="") { echo '

'; $res=mysqli_query($dbc, "SELECT * FROM `albums` WHERE 1") or die(mysqli_error($dbc)); if ($admin!=0) echo '

'; while ($album=mysqli_fetch_assoc($res)) { if ($admin==0) { if ($album["tag"]!="INVISIBLE") { echo ''.$album["name"].' - '.process_output($album["tag"])."
\n"; } } else { echo ''.$album["name"].' - '; echo ''.$album["tag"]."
\n"; } } if ($admin!=0) echo '

'; } else if ($foto=="") { echo ''; if ($frompic>0) echo 'Prev page <- '; echo 'Up -> Next page
'; $res=mysqli_query($dbc, "SELECT * FROM `albums` WHERE `id`='".$album."'") or die(mysqli_error($dbc)); //' $a=mysqli_fetch_assoc($res); echo "".$a["name"]."
".$a["tag"]."

\n"; if ($admin==0) $visclause=" AND `visible`='1'"; else $visclause=''; $res=mysqli_query($dbc, "SELECT * FROM `fotos` WHERE `album`='".$album."'".$visclause." ORDER BY `pos`,`file` LIMIT $frompic,30") or die(mysqli_error($db)); //' if ($admin!=0) echo '

'; while ($v=mysqli_fetch_assoc($res)) { echo ''; if ($v["nobr"]==0) echo "
"; if ($admin!=0) { echo '[url=https://meuk.spritesserver.nl/foto/foto/'.$a["name"].'/'.$v["file"].'][img]https://meuk.spritesserver.nl/foto/foto/'.$a["name"].'/tmb-'.$v["file"].'[/img][/url]
'; echo '<a href="https://meuk.spritesserver.nl/foto/foto/'.$a["name"].'/'.$v["file"].'"><img src="https://meuk.spritesserver.nl/foto/foto/'.$a["name"].'/tmb-'.$v["file"].'" /></a>
'; if ($v["visible"]!=0) $c=" CHECKED"; else $c=""; if ($v["nobr"]!=0) $d="CHECKED"; else $d=""; echo 'Visible'; echo 'NoBR'; echo ''; echo ''; echo ' Pos:
'; echo ''.$v["tag"]."

"; } else { echo process_output($v["tag"]); if ($v["nobr"]==0) echo "
"; } /* if ($v["nobr"]==0) { $cmt=mysql_query("SELECT * FROM `comments` WHERE `foto`='".$v["id"]."'") or die(mysql_error()); //' $s=mysql_num_rows($cmt)==1?"":"s"; echo ''.mysql_num_rows($cmt).' comment'.$s.'
'; } */ } if ($admin!=0) { echo '

'; echo '

'; echo ''; echo ''; echo ''; echo '

'; } echo '<- Up ->
'; echo ''; } else { $res=mysqli_query($dbc, "SELECT * FROM `albums` WHERE `id`='".$album."'") or die(mysqli_error($dbc)); $a=mysqli_fetch_array($res); $res=mysqli_query($dbc, "SELECT * FROM `fotos` WHERE `id`='".$foto."' ORDER BY `prio`") or die(mysqli_error($dbc)); $v=mysqli_fetch_array($res); echo 'Terug naar gallerij -- Terug naar hoofdmenu
'; echo '
'; echo ''.process_output($v["tag"]).'

Commentaar:
'; $res=mysqli_query($dbc, "SELECT * FROM `comments` WHERE `foto`='".$foto."'") or die(mysqli_error($dbc)); while ($c=mysqli_fetch_assoc($res)) { echo 'Door '.$c["nick"].' op '.date('D M j Y H:i T',$c['date']).'
'; echo process_output($c["text"])."

"; } echo 'Reply:'; echo '

'; echo 'Name: E-mail:
'; echo ''; echo ''; echo ''; echo '

'; } ?>