uipágina
file;
$addte = $row->text;
$addti = $row->title;
$addkeys = $row->keywords;
$addcat = $row->categories;
$addcustom = $row->custom;
$addid = $row->id;
$adddate = $row->date;
$res = mysql_query("INSERT INTO $table_images (file, date, text, keywords, categories, title, custom)
VALUES ('$addf', '$adddate', '$addte','$addkeys', '$addcat', '$addti', '$addcustom')");
$res = mysql_query("DELETE FROM $table_addlater WHERE id='$addid'");
$changed = 1;
}
if ($display_mode && !$galleryid) {
$result = mysql_query("SELECT * FROM $table_images WHERE id = $id");
$galleries = explode("#",@mysql_result($result,0,"categories"));
$galleryid = $galleries[1];
}
if (!$display_mode) {
$querystring = "($table_images.visible='t')
$template_prefix = "templates/blog_
}
else {
$querystring = "categories LIKE '%#$galleryid#%'
$gallerystr = "&galleryid=$galleryid
$template_prefix = "templates/gallery_
}
$result = mysql_query("SELECT * FROM $table_images WHERE $querystring order by id DESC");
$visible = mysql_num_rows($result);
if (!$display_mode) {
if ($visible == 0) exit("No images to display");
if (!$id && !$page) {
$id = mysql_result($result,0,"id");
}
}
$scriptpath = "http://".$_SERVER[HTTP_HOST].$_SERVER[PHP_SELF];
$t = new MiniTemplator();
$t->subtemplateBasePath = "templates
$result = mysql_query("SELECT * FROM $table_images WHERE ($table_images.id = $id) AND $querystring");
$index = readtemplate($template_prefix."index.tpl");
if ($page == "all" || ($display_mode && $galleryid && !$id)) {
$index = str_replace('${main}',readtemplate($template_prefix."all.tpl"),$index);
}
elseif ($page == "mailinglist") {
$index = str_replace('${main}',readtemplate($template_prefix."mailinglist.tpl"),$index);
}
elseif ($page == "search") {
$index = str_replace('${main}',readtemplate($template_prefix."search.tpl"),$index);
}
elseif($page){
ob_start();
if (file_exists("$contentdir/$page")) {
include("$contentdir/$page");
}
$content = ob_get_contents();
ob_end_clean();
$index = str_replace('${main}',$content,$index);
}
elseif($display_mode && !$galleryid && !$id){
$index = str_replace('${main}',readtemplate($template_prefix."overview.tpl"),$index);
}
elseif(($image = mysql_fetch_assoc($result))){
$index = str_replace('${main}',readtemplate($template_prefix."main.tpl"),$index);
}
else {
$index = str_replace('${main}',"No valid image id",$index);
$t->setTemplateString($index);
$t->generateOutput();
exit();
}
$index = str_replace('${custom1}',readtemplate($template_prefix."custom1.tpl"),$index);
$index = str_replace('${custom2}',readtemplate($template_prefix."custom2.tpl"),$index);
preg_match('/${previous(d+)}/', $index, $matches);
$previous = $matches[1];
$index = str_replace($matches[0],readtemplate($template_prefix."previous.tpl"),$index);
preg_match('/${next(d+)}/', $index, $matches);
$next = $matches[1];
$index = str_replace($matches[0],readtemplate($template_prefix."next.tpl"),$index);
preg_match('/${recent(d+)}/', $index, $matches);
$recent = $matches[1];
$index = str_replace($matches[0],readtemplate($template_prefix."recent.tpl"),$index);
$t->setTemplateString($index);
if ($display_mode && !$id && !$galleryid) {
$result = mysql_query("SELECT * FROM $table_topcat ORDER BY ID ASC");
while ($row = mysql_fetch_assoc($result)){
$query = "SELECT name,file,description, $table_category.id FROM $table_category LEFT JOIN $table_images ON $table_category.foto_id = $table_images.id WHERE top_category = $row[id] ORDER BY $table_category.id DESC
$result2 = mysql_query($query);
if (mysql_num_rows($result2) == 0) continue;
$t->setVariable("top_name",$row[name]);
while ($row2 = mysql_fetch_assoc($result2)){
$cattest = mysql_fetch_assoc(mysql_query("SELECT id,file FROM $table_images WHERE categories LIKE '%#".$row2[id]."#%' LIMIT 1;"));
if (!$cattest){
continue;
}
if (!$row2[file]) {
$row2[file] = $cattest[file];
}
$t->setVariable("image","$imagedir/$thumbdir/$row2[file]");
$t->setVariable("name",$row2[name] );
$t->setVariable("description",getstring(nl2br($row2[description])) );
$t->setVariable("url","$scriptpath?galleryid=$row2[id]");
$t->addBlock("category");
}
$t->addBlock("top_category");
}
}
if($display_mode && $galleryid){
$result = mysql_query("SELECT * FROM $table_category WHERE id = $galleryid");
$row = mysql_fetch_assoc($result);
$t->setVariable("gallery_name",$row[name]);
$t->setVariable("gallery_link","$scriptpath?galleryid=$galleryid");
}
if ($id) {
$result = mysql_query("SELECT * FROM $table_images WHERE ($table_images.id < $id) AND $querystring ORDER BY id DESC LIMIT 1");
if ($row = mysql_fetch_assoc($result)) {
$t->setVariable("back_url","$scriptpath?id=$row[id]$gallerystr");
$t->setVariable("back_image","$imagedir/$thumbdir/$row[file]");
$url = '
$t->setVariable("back",$url);
$t->addBlock("back");
}
$result = mysql_query("SELECT * FROM $table_images $joinstr WHERE ($table_images.id > $id) AND $querystring ORDER BY id ASC LIMIT 1");
if ($row = mysql_fetch_assoc($result)) {
$t->setVariable("next_url","$scriptpath?id=$row[id]$gallerystr");
$t->setVariable("next_image","$imagedir/$thumbdir/$row[file]");
$url = '
$t->setVariable("next",$url);
$t->addBlock("next");
}
$t->setVariable("file","$image[file]" );
$t->setVariable("image","$imagedir/$image[file]" );
if (!$dateformat) $dateformat = "Y-m-d
$t->setVariable("date", date($dateformat,$image[date]));
$t->setVariable("title",getstring($image[title]) );
$t->setVariable("custom",getstring(nl2br($image[custom])) );
$size = getimagesize("$imagedir/$image[file]");
$t->setVariable("width",$size[0]);
$t->setVariable("height",$size[1]);
$t->setVariable("this","$imagedir/$thumbdir/$image[file]");
$t->setVariable("this_thumbnail",'
');
if ($image[text]) {
$t->setVariable("text",getstring(nl2br($image[text])) );
$t->addBlock("text");
}
if($enable_comments){
$result = mysql_query("SELECT * FROM $table_comments WHERE $table_comments.img_id = $id");
$t->setVariable("comment_count",mysql_num_rows($result));
if ($commentsplace == "popup") { // popup
$t->setVariable("comment_link","javascript:commentswindow(400,500)");
}
elseif ($comments == 0 && $showcomments == 0) {
$t->setVariable("comment_link","$scriptpath?id=$id&comments=1");
}
else {
$t->setVariable("comment_link","$scriptpath?id=$id&comments=0");
}
if (($showcomments == 1 || $_POST[comments] == 1) && $commentsplace == "page") {
include("comments.php");
$t->setVariable("comments",$comments);
}
$t->addBlock("comments");
}
load_exif($image["file"], 0);
}
$result = mysql_query("SELECT * FROM $table_images ORDER BY rand() LIMIT 1");
if ($row = mysql_fetch_assoc($result)) {
$t->setVariable("random_url","$scriptpath?id=$row[id]$gallerystr");
$t->setVariable("random_image","$imagedir/$thumbdir/$row[file]");
$url = '
$t->setVariable("random",$url);
}
$java = '
$t->setVariable("java",$java);
$t->setVariable("visible",$visible);
if ($page == "all" || ($page == "search" && $_REQUEST[term]) || ($galleryid && !$id)){
if(!$display_mode) $numimages = $images_per_blog_page;
else $numimages = $images_per_gallery_page;
if ($page == "search"){
$terms = explode(" ",$_REQUEST[term] );
if(!$display_mode){
$searchstr = "AND visible = 't'
}
foreach($terms AS $term){
$searchstr .= " AND (keywords LIKE '%$term%')
}
$query = "SELECT * FROM $table_images WHERE true $searchstr ORDER BY id DESC
$total = mysql_num_rows(mysql_query($query));
$query = "SELECT * FROM $table_images WHERE true $searchstr ORDER BY id DESC LIMIT $from, $numimages
}
else {
$query = "SELECT * FROM $table_images WHERE $querystring ORDER BY id DESC LIMIT $from, $numimages
$total = $visible;
}
$result = mysql_query($query);
for ($i=0; $i<$total; $i+=$numimages) {
if ($i < $from || $i >= $from+$numimages ) {
if ($_REQUEST[term]) {
$term = "&term=$_REQUEST[term]
}
$t->setVariable("page_url","$scriptpath?page=$page&from=$i$gallerystr$term");
$t->setVariable("page_number",(ceil($i/$numimages) + 1));
$t->addBlock("page_link");
$t->addBlock("page");
}
else {
$t->setVariable("page_number",(ceil($i/$numimages) + 1));
$t->addBlock("page_active");
$t->addBlock("page");
}
}
if (!$from) $from = 0;
while($row=mysql_fetch_assoc($result)){
$t->setVariable("image","$imagedir/$thumbdir/$row[file]");
$t->setVariable("url","$scriptpath?id=$row[id]$gallerystr");
$t->setVariable("title",htmlspecialchars($row["title"]));
$t->setVariable("text",htmlspecialchars($row["text"]));
$t->setVariable("image_full","$imagedir/$row[file]");
$t->addBlock("image");
}
if ($page == "search") {
$t->setVariable("term", $_REQUEST[term]);
if (!$total) {
$t->addBlock("notfound");
}
else {
$t->addBlock("found");
}
}
}
if ($_POST[add]) {
$result = mysql_query("INSERT INTO $table_mailing (email, name) VALUES ('$_POST[mail]', '$_POST[name]')");
$t->addBlock("thankyou");
}
if ($_POST[delete]) {
$result = mysql_query("DELETE FROM `$table_mailing` WHERE `email` = '$_POST[mail]'");
$t->addBlock("maildelete");
}
if ($page == "search"){
if (!$_REQUEST[term]){
$t->addBlock("searchform");
}
}
preg_match_all('/thumb(d+)/', $index, $matches);
foreach($matches[0] AS $k => $v){
$thumbid = $matches[1][$k];
$result = mysql_query("SELECT * from $table_images where id = $thumbid");
if ($row = mysql_fetch_assoc($result)) {
$t->setVariable($v."_url","$scriptpath?id=$row[id]$gallerystr");
$t->setVariable($v."_image","$imagedir/$thumbdir/$row[file]");
$url = '
$t->setVariable($v,$url);
}
}
if ($recent) {
$result = mysql_query("SELECT * FROM $table_images WHERE $querystring ORDER BY id DESC LIMIT $recent");
while($row = mysql_fetch_assoc($result)){
$t->setVariable("recent_url","$scriptpath?id=$row[id]$gallerystr");
$t->setVariable("recent_image","$imagedir/$thumbdir/$row[file]");
$t->addBlock("recent");
}
}
if ($next) {
$result = mysql_query("SELECT * FROM $table_images WHERE id > $id AND $querystring ORDER BY id ASC LIMIT $next");
$nextleft = $next - mysql_num_rows($result);
}
if ($previous) {
$result = mysql_query("SELECT * FROM $table_images WHERE id < $id AND $querystring ORDER BY id ASC LIMIT $previous");
$previousleft = $previous - mysql_num_rows($result);
}
if ($next) {
$result = mysql_query("SELECT * FROM $table_images WHERE id > $id AND $querystring ORDER BY id ASC LIMIT ".($next + $previousleft)."");
while($row = mysql_fetch_assoc($result)){
$t->setVariable("nextX_url","$scriptpath?id=$row[id]$gallerystr");
$t->setVariable("nextX_image","$imagedir/$thumbdir/$row[file]");
$t->addBlock("nextX");
}
}
if($previous){
$result = mysql_query("SELECT * FROM $table_images WHERE id < $id AND $querystring ORDER BY id ASC LIMIT ".($previous + $nextleft)."");
while($row = mysql_fetch_assoc($result)){
$t->setVariable("previousX_url","$scriptpath?id=$row[id]$gallerystr");
$t->setVariable("previousX_image","$imagedir/$thumbdir/$row[file]");
$t->addBlock("previousX");
}
}
if ($_COOKIE['sylverblog_admin'] && $id) {
}
$t->generateOutput();
@mysql_free_result($result);
?>
