4images Forum & Community
4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: TIMT on December 01, 2007, 11:02:35 AM
-
Hi
Ich habe meine Bilder nach dem Rating sortiert. Wenn ich nun in die Detailansicht gehe und auf den Link "nächstes Bild" klicke, wird das falsche Bild gezeigt. Es entspricht nicht der Reihenfolge, wie sie in der Kategorie-Bildübersicht gezeigt wird.
Bitte sagt mir, was für weitere Infos ihr benötigt (z.B. die Datei details.php).
Vielen Dank für die Hilfe.
Gruss
TIMIT
-
Hi
Kann mir da jemand helfen? Das Problem kann auf www.photofront.ch nachvollzogen werden.
Vielen Dank!
-
Hei Du hast ein DB Error. Die Fehlermeldung geht über den gesamten Bildschirm.
Die schrift ist so dunkel das man diese so nicht sieht :!:
nobby
-
Das ist Deine fehlermeldung:
DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, i.price_1, i.price_2, i.image_format, i.image_ort, i.image_date2, i.image_aufloesung1, i.image_aufloesung2, i.image_filegroesse, i.image_exklusiv, i.image_modelrelease, i.image_propertyrelease, i.image_medium, i.image_colorsearch_colors, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0, 2, 16, 1, 14, 17, 8, 18, 12, 7, 15, 3, 19, 21, 6, 23, 13) AND i.cat_id IN () ORDER BY RAND() LIMIT 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY RAND() LIMIT 1' at line 4
Das sieht aus wie ein Syntax-Fehler...
nobby
-
Hallo nobby
ich weiss, das ist nur meine testseite - ist nicht weiter schlimm :wink:
Aber wähl mal eine Kategorie aus, klick dann auf ein Bild und klick auf nächstes Bild (Bildname oben im orangen Balken).
Es wird nicht das Bild präsentiert, das eigentlich gemäss Reihenfolge in der Kategorieübersicht, gezeigt werden müsste.
-
Kann ich nicht nachvollziehen. Bei mir wird es richtig ausgegeben...
[EDIT]
Habe es noch einmal probiert.... wird richtig ausgegeben...
[EDIT ENDE]
-
Hier gelangst du in die Kategorie "Architektur"
http://www.photofront.ch/categories.php?cat_id=2&sessionid=9eebed0b07107d899dad2a8c1cec7794 (http://www.photofront.ch/categories.php?cat_id=2&sessionid=9eebed0b07107d899dad2a8c1cec7794)
Das erste Bild heisst "rear window", dann folgt "Schatten".
Klick nun auf das Bild "Schatten".
Oben rechts wird nun als nächstes Bild "rear window" angezeigt.
Das stimmt aber nicht, rear window ist das vorherige Bild und das nächste Bild sollte "UP" sein.
Wenn du das Bild rear window in der Detailansicht anschaust, siehst du oben rechts "Schatten" als das vorherige Bild und "UP" als das nächste Bild.
Hier gibt es aber kein vorheriges Bild (rear window ist das erste Bild) und das nächste Bild müsste "Schatten" sein.
-
... in deiner details.php im Abschnitt "Get next and previous image" wird sicher vom modifizieren der Wurm drin stecken ...
... tausche diesen Codeabschnitt einfach mal mit dem gleichen Abschnitt aus einer unmodifizierten Version aus ...
-
ich habs versucht. nun stimmt es in den kategorien, aber nicht in der Lightbox.
http://www.photofront.ch/details.php?image_id=733&sessionid=9eebed0b07107d899dad2a8c1cec7794 (http://www.photofront.ch/details.php?image_id=733&sessionid=9eebed0b07107d899dad2a8c1cec7794)
hier stimmt Bild vorher und nachher
Auf der rechten Seite gibt es einen Link "San Francisco"
Mit Klick auf diesen Link wird man in die Lightbox "San Francisco" geführt.
http://www.photofront.ch/lightbox.php?action=show&lightbox_id=545b22454ac16273c246a260117cc396 (http://www.photofront.ch/lightbox.php?action=show&lightbox_id=545b22454ac16273c246a260117cc396)
Klickt man nun hier auf ein Bild, stimmt Bild vorher und nachher nicht.
hier ist mein details.php
<?php
/**************************************************************************
* *
* 4images - A Web Based Image Gallery Management System *
* ---------------------------------------------------------------- *
* *
* File: details.php *
* Copyright: (C) 2002 Jan Sorgalla *
* Email: jan@4homepages.de *
* Web: http://www.4homepages.de *
* Scriptversion: 1.7.1 *
* *
* Never released without support from: Nicky (http://www.nicky.net) *
* *
**************************************************************************
* *
* Dieses Script ist KEINE Freeware. Bitte lesen Sie die Lizenz- *
* bedingungen (Lizenz.txt) für weitere Informationen. *
* --------------------------------------------------------------- *
* This script is NOT freeware! Please read the Copyright Notice *
* (Licence.txt) for further information. *
* *
*************************************************************************/
if (isset($HTTP_GET_VARS['big']) || isset($HTTP_POST_VARS['big'])) {
$templates_used = 'big,header';
$main_template = 'big';
}else{
$templates_used = 'details,header';
$main_template = 'details';
}
define('GET_CACHES', 1);
define('ROOT_PATH', './');
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
$user_access = get_permission();
include(ROOT_PATH.'includes/page_header.php');
if (!$image_id) {
header("Location: ".$site_sess->url($url, "&"));
exit;
}
$additional_sql = "";
if (!empty($additional_image_fields)) {
foreach ($additional_image_fields as $key => $val) {
$additional_sql .= ", i.".$key;
}
}
$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email").", d.user_id AS image_single_download
FROM ".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c
LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
LEFT JOIN ".IMAGES_DOWNLOAD_TABLE." d ON (d.image_id = i.image_id AND d.user_id = ".$user_info['user_id'].")
WHERE i.image_id = $image_id AND c.cat_id = i.cat_id";
$image_row = $site_db->query_firstrow($sql);
$cat_id = (isset($image_row['cat_id'])) ? $image_row['cat_id'] : 0;
$is_image_owner = ($image_row['user_id'] > USER_AWAITING && $user_info['user_id'] == $image_row['user_id']) ? 1 : 0;
if (!check_permission("auth_viewcat", $cat_id) || !check_permission("auth_viewimage", $cat_id) || !$image_row) {
header("Location: ".$site_sess->url($url, "&"));
exit;
}
$random_cat_image = (defined("SHOW_RANDOM_IMAGE") && SHOW_RANDOM_IMAGE == 0) ? "" : get_random_image($cat_id);
$site_template->register_vars("random_cat_image", $random_cat_image);
unset($random_cat_image);
//################################ Start MOD Ajax Slideshow/Diashow ##############################
$max_length_image_name = 65;
$max_length_image_description = 55;
$ajax_slideshow_view = 0;
$ajax_slideshow = "<script type=\"text/javascript\" src=\"http://slideshow.triptracker.net/slide.js\"></script>\n";
$ajax_slideshow .= "<script type=\"text/javascript\">\n<!-- \n";
$ajax_slideshow .= "var viewer = new PhotoViewer();\n";
$ajax_slideshow .= "viewer.setSlideDuration(".$config['ajax_slideshowviewer_setSlideDuration'].");\n";
$ajax_slideshow .= "viewer.".$config['ajax_slideshowviewer_Panning']."Panning();\n";
$ajax_slideshow .= "viewer.".$config['ajax_slideshowviewer_AutoPlay']."AutoPlay();\n";
$ajax_slideshow .= "viewer.".$config['ajax_slideshowviewer_Fading']."Fading();\n";
$ajax_slideshow .= "viewer.setBackgroundColor('".$config['ajax_slideshowviewer_setBackgroundColor']."');\n";
$ajax_slideshow .= "viewer.setBorderWidth(".$config['ajax_slideshowviewer_setBorderWidth'].");\n";
$ajax_slideshow .= "viewer.setFontSize(".$config['ajax_slideshowviewer_setFontSize'].");\n";
$ajax_slideshow .= "viewer.".$config['ajax_slideshowviewer_Shade']."Shade();\n";
$ajax_slideshow .= "viewer.setShadeColor('".$config['ajax_slideshowviewer_setShadeColor']."');\n";
$ajax_slideshow .= "viewer.setShadeOpacity('".$config['ajax_slideshowviewer_setShadeOpacity']."');\n";
$ajax_slideshow .= "viewer.".$config['ajax_slideshowviewer_Loop']."Loop();\n";
$ajax_slideshow .= "viewer.setOnClickEvent(viewer.close);\n";
$ajax_slideshow .= "viewer.disableToolbar();\n";
if ($config['ajax_slideshowviewer_EmailLink'] == "disable") {
$ajax_slideshow .= "viewer.disableEmailLink();\n"; }
if ($config['ajax_slideshowviewer_PhotoLink'] == "disable") {
$ajax_slideshow .= "viewer.disablePhotoLink();\n"; }
$count = 0;
$bgcounter = 0;
$ext = get_file_extension($image_row['image_media_file']);
$config['ajax_slideshowviewer_Types_array'] = explode(",", $config['ajax_slideshowviewer_Types']);
if (in_array($ext, $config['ajax_slideshowviewer_Types_array'])) {
$ajax_slideshow_view = 1;
show_image($image_row);
$image_name_short = (isset($image_row['image_name']) && strlen($image_row['image_name']) > $max_length_image_name) ? substr(format_text(stripslashes($image_row['image_name']), 2), 0, $max_length_image_name)."..." : format_text(stripslashes($image_row['image_name']), 2);
$image_name_short = str_replace("\r","",$image_name_short);
$image_name_short = str_replace("\n","",$image_name_short);
$image_name_short = str_replace("<br>","",$image_name_short);
$image_name_short = str_replace("<br />","",$image_name_short);
$image_name_short = str_replace("'","",$image_name_short);
$image_name_short = str_replace("<","<",$image_name_short);
$image_name_short = str_replace(">",">",$image_name_short);
$image_name_short = stripslashes($image_name_short);
$image_name_short = "".$lang['image_name']." $image_name_short";
if ($config['ajax_slideshowviewer_description'] == "enable") {
$image_description_short = (isset($image_row['image_description']) && strlen($image_row['image_description']) > $max_length_image_description) ? substr(format_text(stripslashes($image_row['image_description']), 1, 0, 1), 0, $max_length_image_description)."..." : format_text(stripslashes($image_row['image_description']), 1, 0, 1);
$image_description_short = str_replace("\r","",$image_description_short);
$image_description_short = str_replace("\n","",$image_description_short);
$image_description_short = str_replace("<br>","",$image_description_short);
$image_description_short = str_replace("<br />","",$image_description_short);
$image_description_short = str_replace("'","",$image_description_short);
$image_description_short = str_replace("<","<",$image_description_short);
$image_description_short = str_replace(">",">",$image_description_short);
$image_description_short = stripslashes($image_description_short);
if ($image_description_short == "") {
$image_description_short = " ";
} else {
$image_description_short = "<br>".$lang['description']." $image_description_short";
}
}
else {
$image_description_short = " ";
}
$ajax_slideshow .= "viewer.add('".MEDIA_DIR."/".$image_row['cat_id']."/".$image_row['image_media_file']."', '".$image_description_short."', '".$image_name_short."');\n";
}
if ($count > 0) {
$leftover = ($config['image_cells'] - $count);
}
$ajax_slideshow .= "//-->\n</script>\n";
if ($user_info['user_level'] == GUEST && $config['ajax_slideshowviewer_Show'] == "1" && $ajax_slideshow_view == "1") {
$ajax_slideshow_button = "<img src=\"".get_gallery_image("diashow_off.gif")."\" border=\"0\" alt=\"\" />";
$site_template->register_vars(array(
"ajax_slideshow_button" => $ajax_slideshow_button
));
}
elseif ($user_info['user_level'] != GUEST && $config['ajax_slideshowviewer_Show'] == "1" && $ajax_slideshow_view == "1" || $config['ajax_slideshowviewer_Show'] == "2" && $ajax_slideshow_view == "1") {
$ajax_slideshow_button = "<a href=\"javascript:void(viewer.show(0))\"><img src=\"".get_gallery_image("diashow.gif")."\" border=\"0\" alt=\"\" /></a>";
$site_template->register_vars(array(
"ajax_slideshow" => $ajax_slideshow,
"ajax_slideshow_button" => $ajax_slideshow_button
));
}
else {
$site_template->register_vars(array(
"ajax_slideshow" => "",
"ajax_slideshow_button" => "",
));
}
unset($ajax_slideshow);
//################################ End MOD Ajax Slideshow/Diashow ##############################
//-----------------------------------------------------
//--- Show Image --------------------------------------
//-----------------------------------------------------
$image_allow_comments = (check_permission("auth_readcomment", $cat_id)) ? $image_row['image_allow_comments'] : 0;
$image_name = format_text($image_row['image_name'], 2);
/*
MOD MULTI-LIGHTBOXES
START REPLACE
*/
$lightbox_id = (isset($HTTP_POST_VARS['lightbox_id']) && $HTTP_POST_VARS['lightbox_id']) ? $HTTP_POST_VARS['lightbox_id'] : ((isset($HTTP_GET_VARS['lightbox_id']) && $HTTP_GET_VARS['lightbox_id']) ? $HTTP_GET_VARS['lightbox_id'] : 0);
show_image($image_row, $mode.(($lightbox_id) ? "&lightbox_id=".$lightbox_id : ""), 0, 1);
/*
MOD MULTI-LIGHTBOXES
END REPLACE
*/
$in_mode = 0;
$sql = "";
if ($mode == "lightbox") {
/*
MOD MULTI-LIGHTBOXES
START REPLACE
*/
$ids = $user_info['lightbox_image_ids'];
if ($lightbox_id)
{
$sql = "SELECT l.lightbox_id, l.lightbox_name, l.lightbox_private, l.lightbox_image_ids, l.user_id, u.user_name, u.user_lightbox_private
FROM ".LIGHTBOXES_TABLE." l
LEFT JOIN ".USERS_TABLE." u ON u.user_id = l.user_id
WHERE l.lightbox_id = '".$lightbox_id."'";
if ($row = $site_db->query_firstrow($sql))
{
$ids = (!$row['lightbox_private'] && $row['user_lightbox_private'] && $config['lightbox_share'] || $user_info['user_level'] == ADMIN ) ? $row['lightbox_image_ids'] : "";//$user_info['lightbox_image_ids'];
$lightbox_name = $row['lightbox_name']." (".$row['user_name'].")";
}
else
{
$lightbox_name = "";
}
}
else
{
$lightbox_name = $user_info['lightboxes'][$user_info['user_lightbox']]['name'];
}
$txt_clickstream = $lang['lightbox'].(($lightbox_name) ? " - ".$lightbox_name : "");
if (!empty($ids)) {
$image_id_sql = str_replace(" ", ", ", trim($ids));
/*
MOD MULTI-LIGHTBOXES
END REPLACE
*/
$sql = "SELECT image_id, cat_id, image_name, image_media_file, image_thumb_file
FROM ".IMAGES_TABLE."
WHERE image_active = 1 AND image_id IN ($image_id_sql) AND (cat_id NOT IN (".get_auth_cat_sql("auth_viewimage", "NOTIN").", ".get_auth_cat_sql("auth_viewcat", "NOTIN")."))
ORDER BY ".$config['image_order']." ".$config['image_sort'].", image_id ".$config['image_sort'];
$in_mode = 1;
}
}
elseif ($mode == "search") {
if (!isset($session_info['searchid']) || empty($session_info['searchid'])) {
$session_info['search_id'] = $site_sess->get_session_var("search_id");
}
if (!empty($session_info['search_id'])) {
$search_id = unserialize($session_info['search_id']);
}
$sql_where_query = "";
if (!empty($search_id['image_ids'])) {
$sql_where_query .= "AND image_id IN (".$search_id['image_ids'].") ";
}
if (!empty($search_id['user_ids'])) {
$sql_where_query .= "AND user_id IN (".$search_id['user_ids'].") ";
}
if (!empty($search_id['search_new_images']) && $search_id['search_new_images'] == 1) {
$new_cutoff = time() - 60 * 60 * 24 * $config['new_cutoff'];
$sql_where_query .= "AND image_date >= $new_cutoff ";
}
if (!empty($search_id['search_cat']) && $search_id['search_cat'] != 0) {
$cat_id_sql = 0;
if (check_permission("auth_viewcat", $search_id['search_cat'])) {
$sub_cat_ids = get_subcat_ids($search_id['search_cat'], $search_id['search_cat'], $cat_parent_cache);
$cat_id_sql .= ", ".$search_id['search_cat'];
if (!empty($sub_cat_ids[$search_id['search_cat']])) {
foreach ($sub_cat_ids[$search_id['search_cat']] as $val) {
if (check_permission("auth_viewcat", $val)) {
$cat_id_sql .= ", ".$val;
}
}
}
}
$cat_id_sql = $cat_id_sql !== 0 ? "AND cat_id IN ($cat_id_sql)" : "";
}
else {
$cat_id_sql = get_auth_cat_sql("auth_viewcat", "NOTIN");
$cat_id_sql = $cat_id_sql !== 0 ? "AND cat_id NOT IN (".$cat_id_sql.")" : "";
}
if (!empty($sql_where_query)) {
$sql = "SELECT image_id, cat_id, image_name, image_media_file, image_thumb_file
FROM ".IMAGES_TABLE."
WHERE image_active = 1
$sql_where_query
$cat_id_sql
ORDER BY ".$config['image_order']." ".$config['image_sort'].", image_id ".$config['image_sort'];
$in_mode = 1;
}
}
if (!$in_mode || empty($sql)) {
$sql = "SELECT image_id, cat_id, image_name, image_media_file, image_thumb_file
FROM ".IMAGES_TABLE."
WHERE image_active = 1 AND cat_id = $cat_id
ORDER BY ".$config['image_order']." ".$config['image_sort'].", image_id ".$config['image_sort'];
}
$result = $site_db->query($sql);
$image_id_cache = array();
$next_prev_cache = array();
$break = 0;
$prev_id = 0;
while($row = $site_db->fetch_array($result)) {
$image_id_cache[] = $row['image_id'];
$next_prev_cache[$row['image_id']] = $row;
if ($break) {
break;
}
if ($prev_id == $image_id) {
$break = 1;
}
$prev_id = $row['image_id'];
}
$site_db->free_result();
if (!function_exists("array_search")) {
function array_search($needle, $haystack) {
$match = false;
foreach ($haystack as $key => $value) {
if ($value == $needle) {
$match = $key;
}
}
return $match;
}
}
$act_key = array_search($image_id, $image_id_cache);
$next_image_id = (isset($image_id_cache[$act_key + 1])) ? $image_id_cache[$act_key + 1] : 0;
$prev_image_id = (isset($image_id_cache[$act_key - 1])) ? $image_id_cache[$act_key - 1] : 0;
unset($image_id_cache);
// Get next and previous image
if (!empty($next_prev_cache[$next_image_id])) {
$next_image_name = htmlspecialchars($next_prev_cache[$next_image_id]['image_name']);
/*
MOD MULTI-LIGHTBOXES
START REPLACE
*/
$next_image_url = $site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$next_image_id.((!empty($mode)) ? "&mode=".$mode.(($lightbox_id) ? "&lightbox_id=".$lightbox_id : "") : ""));
/*
MOD MULTI-LIGHTBOXES
END REPLACE
*/
if (!get_file_path($next_prev_cache[$next_image_id]['image_media_file'], "media", $next_prev_cache[$next_image_id]['cat_id'], 0, 0)) {
$next_image_file = ICON_PATH."/404.gif";
}
else {
$next_image_file = get_file_path($next_prev_cache[$next_image_id]['image_media_file'], "media", $next_prev_cache[$next_image_id]['cat_id'], 0, 1);
}
if (!get_file_path($next_prev_cache[$next_image_id]['image_thumb_file'], "thumb", $next_prev_cache[$next_image_id]['cat_id'], 0, 0)) {
$next_thumb_file = ICON_PATH."/".get_file_extension($next_prev_cache[$next_image_id]['image_media_file']).".gif";
}
else {
$next_thumb_file = get_file_path($next_prev_cache[$next_image_id]['image_thumb_file'], "thumb", $next_prev_cache[$next_image_id]['cat_id'], 0, 1);
}
}
else {
$next_image_name = REPLACE_EMPTY;
$next_image_url = REPLACE_EMPTY;
$next_image_file = REPLACE_EMPTY;
$next_thumb_file = REPLACE_EMPTY;
}
if (!empty($next_prev_cache[$prev_image_id])) {
$prev_image_name = htmlspecialchars($next_prev_cache[$prev_image_id]['image_name']);
/*
MOD MULTI-LIGHTBOXES
START REPLACE
*/
$prev_image_url = $site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$prev_image_id.((!empty($mode)) ? "&mode=".$mode.(($lightbox_id) ? "&lightbox_id=".$lightbox_id : "") : ""));
/*
MOD MULTI-LIGHTBOXES
END REPLACE
*/
if (!get_file_path($next_prev_cache[$prev_image_id]['image_media_file'], "media", $next_prev_cache[$prev_image_id]['cat_id'], 0, 0)) {
$prev_image_file = ICON_PATH."/404.gif";
}
else {
$prev_image_file = get_file_path($next_prev_cache[$prev_image_id]['image_media_file'], "media", $next_prev_cache[$prev_image_id]['cat_id'], 0, 1);
}
if (!get_file_path($next_prev_cache[$prev_image_id]['image_thumb_file'], "thumb", $next_prev_cache[$prev_image_id]['cat_id'], 0, 0)) {
$prev_thumb_file = ICON_PATH."/".get_file_extension($next_prev_cache[$prev_image_id]['image_media_file']).".gif";
}
else {
$prev_thumb_file = get_file_path($next_prev_cache[$prev_image_id]['image_thumb_file'], "thumb", $next_prev_cache[$prev_image_id]['cat_id'], 0, 1);
}
}
else {
$prev_image_name = REPLACE_EMPTY;
$prev_image_url = REPLACE_EMPTY;
$prev_image_file = REPLACE_EMPTY;
$prev_thumb_file = REPLACE_EMPTY;
}
$site_template->register_vars(array(
"next_image_id" => $next_image_id,
"next_image_name" => $next_image_name,
"next_image_url" => $next_image_url,
"next_image_file" => $next_image_file,
"next_thumb_file" => $next_thumb_file,
"prev_image_id" => $prev_image_id,
"prev_image_name" => $prev_image_name,
"prev_image_url" => $prev_image_url,
"prev_image_file" => $prev_image_file,
"prev_thumb_file" => $prev_thumb_file
));
unset($next_prev_cache);
/*
//-----------------------------------------------------
//--- Show Count Users Lightbox -----------------------------
//-----------------------------------------------------
$sql = "SELECT lightbox_id, lightbox_name, id
FROM ".LIGHTBOXES_TABLE."
WHERE lightbox_image_ids REGEXP '([^0-9]|^)".$image_row['image_id']."([^0-9]|$)' AND user_id = ".$user_info['user_id'];
$result = $site_db->query($sql);
$url_users_lightbox = '';
while ($row = $site_db->fetch_array($result)) {
//$url_users_lightbox .= "<a href=\"".$site_sess->url(ROOT_PATH."lightbox.php?action=show&lightbox_id=".$row['lightbox_id'])."\" class=\"keywordstyle\">".$row['lightbox_name']."</a><br />";
$url_users_lightbox .= "<a href=\"".$site_sess->url(ROOT_PATH."lightbox.php?action=show&user_lightbox=".$row['id'])."\" class=\"keywordstyle\">".$row['lightbox_name']."</a><br />";
}
$site_template->register_vars(array(
"url_users_lightbox" => $url_users_lightbox
));
unset($url_users_lightbox);
*/
//-----------------------------------------------------
//--- Show Image Owners Lightbox PUBLIC ---------------
//-----------------------------------------------------
$sql = "SELECT lightbox_id, lightbox_name, id, lightbox_private
FROM ".LIGHTBOXES_TABLE."
WHERE lightbox_image_ids REGEXP '([^0-9]|^)".$image_row['image_id']."([^0-9]|$)' AND user_id = ".$image_row['user_id']." AND lightbox_private = 0";
$result = $site_db->query($sql);
$url_users_lightbox = '';
while ($row = $site_db->fetch_array($result)) {
$url_users_lightbox .= " <img border=\"0\" src=\"./picture_library/pfeil_orange.gif\"> <a href=\"".$site_sess->url(ROOT_PATH."lightbox.php?action=show&lightbox_id=".$row['lightbox_id'])."\" class=\"keywordstyle\">".$row['lightbox_name']."</a><br />";
//$url_users_lightbox .= "<a href=\"".$site_sess->url(ROOT_PATH."lightbox.php?action=show&user_lightbox=".$row['id'])."\" class=\"keywordstyle\">".$row['lightbox_name']."</a><br />";
}
$site_template->register_vars(array(
"url_users_lightbox" => $url_users_lightbox
));
unset($url_users_lightbox);
//-----------------------------------------------------
//--- Save Comment ------------------------------------
//-----------------------------------------------------
$error = 0;
if ($action == "postcomment" && isset($HTTP_POST_VARS[URL_ID])) {
$id = intval($HTTP_POST_VARS[URL_ID]);
$sql = "SELECT cat_id, image_allow_comments
FROM ".IMAGES_TABLE."
WHERE image_id = $id";
$row = $site_db->query_firstrow($sql);
if ($row['image_allow_comments'] == 0 || !check_permission("auth_postcomment", $row['cat_id']) || !$row) {
$msg = $lang['comments_deactivated'];
}
else {
$user_name = un_htmlspecialchars(trim($HTTP_POST_VARS['user_name']));
$comment_headline = un_htmlspecialchars(trim($HTTP_POST_VARS['comment_headline']));
$comment_text = un_htmlspecialchars(trim($HTTP_POST_VARS['comment_text']));
// Flood Check
$sql = "SELECT comment_ip, comment_date
FROM ".COMMENTS_TABLE."
WHERE image_id = $id
ORDER BY comment_date DESC
LIMIT 1";
$spam_row = $site_db->query_firstrow($sql);
$spamtime = $spam_row['comment_date'] + 180;
if ($session_info['session_ip'] == $spam_row['comment_ip'] && time() <= $spamtime && $user_info['user_level'] != ADMIN) {
$msg .= (($msg != "") ? "<br />" : "").$lang['spamming'];
$error = 1;
}
$user_name_field = get_user_table_field("", "user_name");
if (!empty($user_name_field)) {
if ($site_db->not_empty("SELECT $user_name_field FROM ".USERS_TABLE." WHERE $user_name_field = '".strtolower($user_name)."' AND ".get_user_table_field("", "user_id")." <> '".$user_info['user_id']."'")) {
$msg .= (($msg != "") ? "<br />" : "").$lang['username_exists'];
$error = 1;
}
}
// if ($user_name == "") {
// $msg .= (($msg != "") ? "<br />" : "").$lang['name_required'];
// $error = 1;
// }
// if ($comment_headline == "") {
// $msg .= (($msg != "") ? "<br />" : "").$lang['headline_required'];
// $error = 1;
// }
if ($comment_text == "") {
$msg .= (($msg != "") ? "<br />" : "").$lang['comment_required'];
$error = 1;
}
if (!$error) {
$sql = "INSERT INTO ".COMMENTS_TABLE."
(image_id, user_id, user_name, comment_headline, comment_text, comment_ip, comment_date)
VALUES
($id, ".$user_info['user_id'].", '$user_name', '$comment_headline', '$comment_text', '".$session_info['session_ip']."', ".time().")";
$site_db->query($sql);
$commentid = $site_db->get_insert_id();
update_comment_count($id, $user_info['user_id']);
}
}
unset($row);
unset($spam_row);
}
//-----------------------------------------------------
//--- Show Comments -----------------------------------
//-----------------------------------------------------
if ($image_allow_comments == 1) {
$sql = "SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c.comment_text, c.comment_ip, c.comment_date".get_user_table_field(", u.", "user_level").get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email").get_user_table_field(", u.", "user_showemail").get_user_table_field(", u.", "user_invisible").get_user_table_field(", u.", "user_joindate").get_user_table_field(", u.", "user_lastaction").get_user_table_field(", u.", "user_comments").get_user_table_field(", u.", "user_homepage").get_user_table_field(", u.", "user_icq")."
FROM ".COMMENTS_TABLE." c
LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = c.user_id)
WHERE c.image_id = $image_id
ORDER BY c.comment_date ASC";
$result = $site_db->query($sql);
$comment_row = array();
while ($row = $site_db->fetch_array($result)) {
$comment_row[] = $row;
}
$site_db->free_result($result);
$num_comments = sizeof($comment_row);
if (!$num_comments) {
$comments = "<tr><td width=\"100%\" class=\"commentrow1\" colspan=\"2\">".$lang['no_comments']."</td></tr>";
}
else {
$comments = "";
$bgcounter = 0;
for ($i = 0; $i < $num_comments; $i++) {
$row_bg_number = ($bgcounter++ % 2 == 0) ? 1 : 2;
$comment_user_email = "";
$comment_user_email_save = "";
$comment_user_mailform_link = "";
$comment_user_email_button = "";
$comment_user_homepage_button = "";
$comment_user_icq_button = "";
$comment_user_profile_button = "";
$comment_user_status_img = REPLACE_EMPTY;
$comment_user_name = htmlspecialchars($comment_row[$i]['comment_user_name']);
$comment_user_info = $lang['userlevel_guest'];
$comment_user_id = $comment_row[$i]['user_id'];
if (isset($comment_row[$i][$user_table_fields['user_name']]) && $comment_user_id != GUEST) {
$comment_user_name = htmlspecialchars($comment_row[$i][$user_table_fields['user_name']]);
$comment_user_profile_link = !empty($url_show_profile) ? $site_sess->url(preg_replace("/{user_id}/", $comment_user_id, $url_show_profile)) : $site_sess->url(ROOT_PATH."member.php?action=showprofile&".URL_USER_ID."=".$comment_user_id);
$comment_user_profile_button = "<a class=\"menu\" href= \"".$comment_user_profile_link."\"><img src=\"".get_gallery_image("pfeil_orange.gif")."\" border=\"0\" alt=\"".$comment_user_name."\" /> Profil</a>";
$comment_user_status_img = ($comment_row[$i][$user_table_fields['user_lastaction']] >= (time() - 300) && ((isset($comment_row[$i][$user_table_fields['user_invisible']]) && $comment_row[$i][$user_table_fields['user_invisible']] == 0) || $user_info['user_level'] == ADMIN)) ? "<img src=\"".get_gallery_image("user_online.gif")."\" border=\"0\" alt=\"Online\" />" : "<img src=\"".get_gallery_image("user_offline.gif")."\" border=\"0\" alt=\"Offline\" />";
$comment_user_homepage = (isset($comment_row[$i][$user_table_fields['user_homepage']])) ? format_url($comment_row[$i][$user_table_fields['user_homepage']]) : "";
if (!empty($comment_user_homepage)) {
$comment_user_homepage_button = "<a href=\"".$comment_user_homepage."\" target=\"_blank\"><img src=\"".get_gallery_image("homepage.gif")."\" border=\"0\" alt=\"".$comment_user_homepage."\" /></a>";
}
$comment_user_icq = (isset($comment_row[$i][$user_table_fields['user_icq']])) ? $comment_row[$i][$user_table_fields['user_icq']] : "";
if (!empty($comment_user_icq)) {
$comment_user_icq_button = "<a href=\"http://wwp.icq.com/scripts/search.dll?to=".$comment_user_icq."\" target=\"_blank\"><img src=\"http://web.icq.com/whitepages/online?icq=".$comment_user_icq."&img=5\" width=\"18\" height=\"18\" border=\"0\" alt=\"".$comment_user_icq."\" /></a>";
}
if (!empty($comment_row[$i][$user_table_fields['user_email']]) && (!isset($comment_row[$i][$user_table_fields['user_showemail']]) || (isset($comment_row[$i][$user_table_fields['user_showemail']]) && $comment_row[$i][$user_table_fields['user_showemail']] == 1))) {
$comment_user_email = $comment_row[$i][$user_table_fields['user_email']];
$comment_user_email_save = str_replace("@", " at ", $comment_row[$i][$user_table_fields['user_email']]);
if (!empty($url_mailform)) {
$comment_user_mailform_link = $site_sess->url(preg_replace("/{user_id}/", $comment_user_id, $url_mailform));
}
else {
$comment_user_mailform_link = $site_sess->url(ROOT_PATH."member.php?action=mailform&".URL_USER_ID."=".$comment_user_id);
}
$comment_user_email_button = "<a href=\"".$comment_user_mailform_link."\"><img src=\"".get_gallery_image("email.gif")."\" border=\"0\" alt=\"".$comment_user_email_save."\" /></a>";
}
if (!isset($comment_row[$i][$user_table_fields['user_level']]) || (isset($comment_row[$i][$user_table_fields['user_level']]) && $comment_row[$i][$user_table_fields['user_level']] == USER)) {
$comment_user_info = $lang['userlevel_user'];
}
elseif ($comment_row[$i][$user_table_fields['user_level']] == ADMIN) {
$comment_user_info = $lang['userlevel_admin'];
}
$comment_user_info .= "<br />";
$comment_user_info .= (isset($comment_row[$i][$user_table_fields['user_joindate']])) ? "<br />".$lang['join_date']." ".format_date($config['date_format'], $comment_row[$i][$user_table_fields['user_joindate']]) : "";
$comment_user_info .= (isset($comment_row[$i][$user_table_fields['user_comments']])) ? "<br />".$lang['comments']." ".$comment_row[$i][$user_table_fields['user_comments']] : "";
}
$comment_user_ip = ($user_info['user_level'] == ADMIN) ? $comment_row[$i]['comment_ip'] : "";
$admin_links = "";
if ($user_info['user_level'] == ADMIN) {
$admin_links .= "<a class=\"keywordstyle\" href=\"".$site_sess->url(ROOT_PATH."admin/index.php?goto=".urlencode("comments.php?action=editcomment&comment_id=".$comment_row[$i]['comment_id']))."\" target=\"_blank\">".$lang['edit']."</a> ";
$admin_links .= "<a class=\"keywordstyle\" href=\"".$site_sess->url(ROOT_PATH."admin/index.php?goto=".urlencode("comments.php?action=removecomment&comment_id=".$comment_row[$i]['comment_id']))."\" target=\"_blank\">".$lang['delete']."</a>";
}
elseif ($is_image_owner || $comment_user_id == $user_info['user_id'] && $user_info['user_level'] >= USER) {
$admin_links .= ($config['user_edit_comments'] != 1) ? "" : "<a class=\"keywordstyle\" href=\"".$site_sess->url(ROOT_PATH."member.php?action=editcomment&".URL_COMMENT_ID."=".$comment_row[$i]['comment_id'])."\">".$lang['edit']."</a> ";
$admin_links .= ($config['user_delete_comments'] != 1) ? "" : "<a class=\"keywordstyle\" href=\"".$site_sess->url(ROOT_PATH."member.php?action=removecomment&".URL_COMMENT_ID."=".$comment_row[$i]['comment_id'])."\">".$lang['delete']."</a>";
}
$site_template->register_vars(array(
"comment_id" => $comment_row[$i]['comment_id'],
"comment_user_id" => $comment_user_id,
"comment_user_status_img" => $comment_user_status_img,
"comment_user_name" => $comment_user_name,
"comment_user_info" => $comment_user_info,
"comment_user_profile_button" => $comment_user_profile_button,
"comment_user_email" => $comment_user_email,
"comment_user_email_save" => $comment_user_email_save,
"comment_user_mailform_link" => $comment_user_mailform_link,
"comment_user_email_button" => $comment_user_email_button,
"comment_user_homepage_button" => $comment_user_homepage_button,
"comment_user_icq_button" => $comment_user_icq_button,
"comment_user_ip" => $comment_user_ip,
"comment_headline" => format_text($comment_row[$i]['comment_headline'], 0, $config['wordwrap_comments'], 0, 0),
"comment_text" => format_text($comment_row[$i]['comment_text'], $config['html_comments'], $config['wordwrap_comments'], $config['bb_comments'], $config['bb_img_comments']),
"comment_date" => format_date($config['date_format']." ".$config['time_format'], $comment_row[$i]['comment_date']),
"row_bg_number" => $row_bg_number,
"admin_links" => $admin_links
));
$comments .= $site_template->parse_template("comment_bit");
} // end while
} //end else
$site_template->register_vars("comments", $comments);
unset($comments);
//-----------------------------------------------------
//--- BBCode & Form -----------------------------------
//-----------------------------------------------------
$allow_posting = check_permission("auth_postcomment", $cat_id);
$bbcode = "";
if ($config['bb_comments'] == 1 && $allow_posting) {
$site_template->register_vars(array(
"lang_bbcode" => $lang['bbcode'],
"lang_tag_prompt" => $lang['tag_prompt'],
"lang_link_text_prompt" => $lang['link_text_prompt'],
"lang_link_url_prompt" => $lang['link_url_prompt'],
"lang_link_email_prompt" => $lang['link_email_prompt'],
"lang_list_type_prompt" => $lang['list_type_prompt'],
"lang_list_item_prompt" => $lang['list_item_prompt']
));
$bbcode = $site_template->parse_template("bbcode");
}
if (!$allow_posting) {
$comment_form = "";
}
else {
$user_name = (isset($HTTP_POST_VARS['user_name']) && $error) ? stripslashes(htmlspecialchars(trim($HTTP_POST_VARS['user_name']))) : (($user_info['user_level'] != GUEST) ? htmlspecialchars($user_info['user_name']) : "");
$comment_headline = (isset($HTTP_POST_VARS['comment_headline']) && $error) ? stripslashes(htmlspecialchars(trim($HTTP_POST_VARS['comment_headline']))) : "";
$comment_text = (isset($HTTP_POST_VARS['comment_text']) && $error) ? stripslashes(htmlspecialchars(trim($HTTP_POST_VARS['comment_text']))) : "";
$site_template->register_vars(array(
"bbcode" => $bbcode,
"user_name" => $user_name,
"comment_headline" => $comment_headline,
"comment_text" => $comment_text,
"lang_post_comment" => $lang['post_comment'],
"lang_name" => $lang['name'],
"lang_headline" => $lang['headline'],
"lang_comment" => $lang['comment']
));
$comment_form = $site_template->parse_template("comment_form");
}
$site_template->register_vars("comment_form", $comment_form);
unset($comment_form);
} // end if allow_comments
// Admin Links
$admin_links = "";
if ($user_info['user_level'] == ADMIN) {
$admin_links .= "<br> <img border=\"0\" src=\"./picture_library/pfeil.gif\"/> <a class=\"schwarz\" href=\"".$site_sess->url(ROOT_PATH."admin/index.php?goto=".urlencode("images.php?action=editimage&image_id=".$image_id))."\" target=\"_blank\">".$lang['image_edit']." </a>";
$admin_links .= "<img border=\"0\" src=\"./picture_library/pfeil.gif\"/> <a class=\"schwarz\" href=\"".$site_sess->url(ROOT_PATH."admin/index.php?goto=".urlencode("images.php?action=removeimage&image_id=".$image_id))."\" target=\"_blank\">".$lang['image_delete']."</a>";
}
elseif ($is_image_owner) {
$admin_links .= ($config['user_edit_image'] != 1) ? "" : "<br> <img border=\"0\" src=\"./picture_library/pfeil.gif\"/> <a class=\"schwarz\" href=\"".$site_sess->url(ROOT_PATH."member.php?action=editimage&".URL_IMAGE_ID."=".$image_id)."\">".$lang['image_edit']." </a>";
$admin_links .= (!$config['user_delete_image']) ? "" : "<img border=\"0\" src=\"./picture_library/pfeil.gif\"/> <a class=\"schwarz\" href=\"".$site_sess->url(ROOT_PATH."member.php?action=removeimage&".URL_IMAGE_ID."=".$image_id)."\">".$lang['image_delete']."</a>";
}
$site_template->register_vars("admin_links", $admin_links);
// Update Hits
if ($user_info['user_level'] != ADMIN) {
$sql = "UPDATE ".IMAGES_TABLE."
SET image_hits = image_hits + 1
WHERE image_id = $image_id";
$site_db->query($sql);
}
// #################################### Start Mod Colorsearch ##################################
global $site_db, $config, $site_sess, $lang, $user_info, $setting;
$show_colors = $config['colorsearch_colors'];
$show_colors_lines_br = $config['colorsearch_colors_line'];
$show_colors_size = $config['colorsearch_size'];
$ext = get_file_extension($image_row['image_media_file']);
$config['colorsearch_types_array'] = explode(",", $config['colorsearch_types']);
if (in_array($ext, $config['colorsearch_types_array']) && ($config['colorsearch_Show'] == "1")) {
class GetMostCommonColors
{
var $image;
function Get_Color()
{
if (isset($this->image))
{
$PREVIEW_WIDTH = 150;
$PREVIEW_HEIGHT = 150;
$size = GetImageSize($this->image);
$scale=1;
if ($size[0]>0)
$scale = min($PREVIEW_WIDTH/$size[0], $PREVIEW_HEIGHT/$size[1]);
if ($scale < 1)
{
$width = floor($scale*$size[0]);
$height = floor($scale*$size[1]);
}
else
{
$width = $size[0];
$height = $size[1];
}
$image_resized = imagecreatetruecolor($width, $height);
if ($size[2]==1)
$image_orig=imagecreatefromgif($this->image);
if ($size[2]==2)
$image_orig=imagecreatefromjpeg($this->image);
if ($size[2]==3)
$image_orig=imagecreatefrompng($this->image);
imagecopyresampled($image_resized, $image_orig, 0, 0, 0, 0, $width, $height, $size[0], $size[1]);
$im = $image_resized;
$imgWidth = imagesx($im);
$imgHeight = imagesy($im);
for ($y=0; $y < $imgHeight; $y++)
{
for ($x=0; $x < $imgWidth; $x++)
{
$index = imagecolorat($im,$x,$y);
$Colors = imagecolorsforindex($im,$index);
$Colors['red']=intval((($Colors['red'])+15)/32)*32;
$Colors['green']=intval((($Colors['green'])+15)/32)*32;
$Colors['blue']=intval((($Colors['blue'])+15)/32)*32;
if ($Colors['red']>=256)
$Colors['red']=240;
if ($Colors['green']>=256)
$Colors['green']=240;
if ($Colors['blue']>=256)
$Colors['blue']=240;
$hexarray[]=substr("0".dechex($Colors['red']),-2).substr("0".dechex($Colors['green']),-2).substr("0".dechex($Colors['blue']),-2);
}
}
$hexarray=array_count_values($hexarray);
natsort($hexarray);
$hexarray=array_reverse($hexarray,true);
return $hexarray;
}
else die("ERROR! (\$image parameter)");
}
}
$ex=new GetMostCommonColors();
$ex->image= ROOT_PATH.MEDIA_DIR."/".$image_row['cat_id']."/".$image_row['image_media_file']."";
$colors=$ex->Get_Color();
$colors_key=array_keys($colors);
$how_many = count(array_keys($colors))-1;
$image_farbton_suche = '';
// Start line 1
if ($show_colors_lines_br >= $how_many && $show_colors >= $how_many) {
for ($i = 0; $i <= $how_many; $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
}
elseif ($show_colors_lines_br >= $how_many && $show_colors <= $how_many) {
for ($i = 0; $i <= ($show_colors-1); $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
}
elseif ($show_colors_lines_br <= $how_many && $show_colors <= $how_many && $show_colors_lines_br >= $show_colors) {
for ($i = 0; $i <= ($show_colors-1); $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
}
// End line 1
// Start line 1
else {
for ($i = 0; $i <= ($show_colors_lines_br -1); $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
$image_farbton_suche .="</tr>\n";
// End line 1
// Start line 2
if ($show_colors >= $show_colors_lines_br && $show_colors >= ($show_colors_lines_br*2) && $how_many >= ($show_colors_lines_br*2)) {
$image_farbton_suche .="<tr>\n";
for ($i = $show_colors_lines_br; $i <= ($show_colors_lines_br*2-1); $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
$image_farbton_suche .="</tr>\n";
}
elseif ($show_colors >= $show_colors_lines_br && $show_colors >= ($show_colors_lines_br*2) && $how_many <= ($show_colors_lines_br*2) || $show_colors >= $show_colors_lines_br && $how_many >= $show_colors_lines_br && $how_many <= ($show_colors_lines_br*2)) {
$image_farbton_suche .="<tr>\n";
for ($i = $show_colors_lines_br; $i <= $how_many; $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
}
elseif ($show_colors >= $show_colors_lines_br && $show_colors <= ($show_colors_lines_br*2) && $how_many >= ($show_colors_lines_br*2)) {
$image_farbton_suche .="<tr>\n";
for ($i = $show_colors_lines_br; $i <= ($show_colors-1); $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
}
// End line 2
// Start line 3
if ($show_colors >= ($show_colors_lines_br*2) && $show_colors >= ($show_colors_lines_br*3) && $how_many >= ($show_colors_lines_br*3)) {
$image_farbton_suche .="<tr>\n";
for ($i = ($show_colors_lines_br*2); $i <= ($show_colors_lines_br*3-1); $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
$image_farbton_suche .="</tr>\n";
}
elseif ($show_colors >= ($show_colors_lines_br*2) && $show_colors >= ($show_colors_lines_br*3) && $how_many <= ($show_colors_lines_br*3) || $show_colors >= ($show_colors_lines_br*2) && $how_many >= ($show_colors_lines_br*2) && $how_many <= ($show_colors_lines_br*3)) {
$image_farbton_suche .="<tr>\n";
for ($i = ($show_colors_lines_br*2); $i <= $how_many; $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
}
elseif ($show_colors >= ($show_colors_lines_br*2) && $show_colors <= ($show_colors_lines_br*3) && $how_many >= ($show_colors_lines_br*3)) {
$image_farbton_suche .="<tr>\n";
for ($i = ($show_colors_lines_br*2); $i <= ($show_colors-1); $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
}
// End line 3
// Start line 4
if ($show_colors >= ($show_colors_lines_br*3) && $show_colors >= ($show_colors_lines_br*4) && $how_many >= ($show_colors_lines_br*4)) {
$image_farbton_suche .="<tr>\n";
for ($i = ($show_colors_lines_br*3); $i <= ($show_colors_lines_br*4-1); $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
$image_farbton_suche .="</tr>\n";
}
elseif ($show_colors >= ($show_colors_lines_br*3) && $show_colors >= ($show_colors_lines_br*4) && $how_many <= ($show_colors_lines_br*4) || $show_colors >= ($show_colors_lines_br*3) && $how_many >= ($show_colors_lines_br*3) && $how_many <= ($show_colors_lines_br*4)) {
$image_farbton_suche .="<tr>\n";
for ($i = ($show_colors_lines_br*3); $i <= $how_many; $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
}
elseif ($show_colors >= ($show_colors_lines_br*3) && $show_colors <= ($show_colors_lines_br*4) && $how_many >= ($show_colors_lines_br*4)) {
$image_farbton_suche .="<tr>\n";
for ($i = ($show_colors_lines_br*3); $i <= ($show_colors-1); $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
}
// End line 4
// Start line 5
if ($show_colors >= ($show_colors_lines_br*4) && $show_colors >= ($show_colors_lines_br*5) && $how_many >= ($show_colors_lines_br*5)) {
$image_farbton_suche .="<tr>\n";
for ($i = ($show_colors_lines_br*4); $i <= ($show_colors_lines_br*5-1); $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
$image_farbton_suche .="</tr>\n";
}
elseif ($show_colors >= ($show_colors_lines_br*4) && $show_colors >= ($show_colors_lines_br*5) && $how_many <= ($show_colors_lines_br*5) || $show_colors >= ($show_colors_lines_br*4) && $how_many >= ($show_colors_lines_br*4) && $how_many <= ($show_colors_lines_br*5)) {
$image_farbton_suche .="<tr>\n";
for ($i = ($show_colors_lines_br*4); $i <= $how_many; $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
}
elseif ($show_colors >= ($show_colors_lines_br*4) && $show_colors <= ($show_colors_lines_br*5) && $how_many >= ($show_colors_lines_br*5)) {
$image_farbton_suche .="<tr>\n";
for ($i = ($show_colors_lines_br*4); $i <= ($show_colors-1); $i++)
{
$colorsearch_link = $site_sess->url(ROOT_PATH."search.php?search_keywords=".$colors_key[$i]."&search_fields=image_farbton");
$image_farbton_suche .="<td bgcolor=\"#".$colors_key[$i]."\" class=\"colorsearch\"><a href=\"".$colorsearch_link."\" style=\"background-color: #".$colors_key[$i].";\"><img src=\"templates/".$config['template_dir']."/images/spacer.gif\" alt=\"[".$lang['farbton_suche_link_1']." ".$colors[$colors_key[$i]]." Pixel] ".$lang['farbton_suche_link_2']."\" width=\"".$show_colors_size."\" height=\"".$show_colors_size."\" border=\"0\"></a></td>\n";
}
}
// End line 5
}
$site_template->register_vars(array(
"image_farbton_suche" => $image_farbton_suche,
"lang_farbton_suche" => $lang['farbton_suche'],
"lang_farbton_suche_link_1" => $lang['farbton_suche_link_1'],
"lang_farbton_suche_link_2" => $lang['farbton_suche_link_2'],
"lang_farbton_suche_haeufigkeit" => $lang['farbton_suche_haeufigkeit']
));
}
else {
$image_farbton_suche = '';
$site_template->register_vars(array(
"image_farbton_suche" => $image_farbton_suche
));
}
unset($image_farbton_suche);
// #################################### End Mod Colorsearch ##################################
//-----------------------------------------------------
//---Clickstream---------------------------------------
//-----------------------------------------------------
$clickstream = "<span class=\"clickstream\"><a href=\"".$site_sess->url(ROOT_PATH."index.php")."\" class=\"clickstream\">".$lang['home']."</a>".$config['category_separator'];
if ($mode == "lightbox" && $in_mode) {
$page_url = "";
if (preg_match("/".URL_PAGE."=([0-9]+)/", $url, $regs)) {
if (!empty($regs[1]) && $regs[1] != 1 && !$page_details) {
$page_url = "?".URL_PAGE."=".$regs[1];
}
}
/*
MOD MULTI-LIGHTBOXES
START REPLACE
*/
$page_url .= ($lightbox_id) ? (($page_url) ? "&" : "?")."lightbox_id=".$lightbox_id : "";
$clickstream .= "<a href=\"".$site_sess->url(ROOT_PATH."lightbox.php".$page_url)."\" class=\"clickstream\">".$txt_clickstream."</a>".$config['category_separator'];
/*
MOD MULTI-LIGHTBOXES
END REPLACE
*/
}
elseif ($mode == "search" && $in_mode) {
$page_url = "";
if (preg_match("/".URL_PAGE."=([0-9]+)/", $url, $regs)) {
if (!empty($regs[1]) && $regs[1] != 1) {
$page_url = "&".URL_PAGE."=".$regs[1];
}
}
$clickstream .= "<a href=\"".$site_sess->url(ROOT_PATH."search.php?show_result=1".$page_url)."\" class=\"clickstream\">".$lang['search']."</a>".$config['category_separator'];
}
else {
$clickstream .= get_category_path($cat_id, 1, $cur_page).$config['category_separator'];
}
$clickstream .= $image_name."</span>";
//-----------------------------------------------------
//--- Voted stats -------------------------------------
//-----------------------------------------------------
$sql = "SELECT v.user_id, v.vote, u.user_name
FROM ".VOTED_TABLE." v
LEFT JOIN ".USERS_TABLE." u ON (u.user_id = v.user_id)
WHERE u.user_id = v.user_id AND image_id = ".$image_id;
$result = $site_db->query($sql);
$voted_list = "";
while ($row = $site_db->fetch_array($result))
{
$vote = ($user_info['user_level'] == ADMIN) ? " (".$row['vote'].")" : "";
$voted_list .= "<a class=\"keywordstyle\" href=\"".$site_sess->url(ROOT_PATH."member.php?action=showprofile&user_id=".$row['user_id'])."\">".$row['user_name']."</a>".$vote."<br />"; //member name WITH a link to their profile page
// $voted_list .= $row['user_name'].$vote."<br />"; //member name WITHOUT a link to their profile page
}
$site_template->register_vars(array(
"voted_list" => $voted_list,
"lang_voted_list" => $lang['voted_list']
));
//----- End Voted stats ----------------
//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
"msg" => $msg,
"clickstream" => $clickstream,
"lang_category" => $lang['category'],
"lang_added_by" => $lang['added_by'],
"lang_description" => $lang['description'],
"lang_keywords" => $lang['keywords'],
"lang_date" => $lang['date'],
"lang_hits" => $lang['hits'],
"lang_downloads" => $lang['downloads'],
"lang_rating" => $lang['rating'],
"lang_votes" => $lang['votes'],
"lang_author" => $lang['author'],
"lang_comment" => $lang['comment'],
"lang_prev_image" => $lang['prev_image'],
"lang_next_image" => $lang['next_image'],
"lang_file_size" => $lang['file_size']
));
$site_template->print_template($site_template->parse_template($main_template));
include(ROOT_PATH.'includes/page_footer.php');
?>
-
Diese ist der Original Abschnitt ohne Mod's aus der details.php
// Get next and previous image
if (!empty($next_prev_cache[$next_image_id])) {
$next_image_name = format_text($next_prev_cache[$next_image_id]['image_name'], 2);
$next_image_url = $site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$next_image_id.((!empty($mode)) ? "&mode=".$mode : ""));
if (!get_file_path($next_prev_cache[$next_image_id]['image_media_file'], "media", $next_prev_cache[$next_image_id]['cat_id'], 0, 0)) {
$next_image_file = ICON_PATH."/404.gif";
}
else {
$next_image_file = get_file_path($next_prev_cache[$next_image_id]['image_media_file'], "media", $next_prev_cache[$next_image_id]['cat_id'], 0, 1);
}
if (!get_file_path($next_prev_cache[$next_image_id]['image_thumb_file'], "thumb", $next_prev_cache[$next_image_id]['cat_id'], 0, 0)) {
$next_thumb_file = ICON_PATH."/".get_file_extension($next_prev_cache[$next_image_id]['image_media_file']).".gif";
}
else {
$next_thumb_file = get_file_path($next_prev_cache[$next_image_id]['image_thumb_file'], "thumb", $next_prev_cache[$next_image_id]['cat_id'], 0, 1);
}
}
else {
$next_image_name = REPLACE_EMPTY;
$next_image_url = REPLACE_EMPTY;
$next_image_file = REPLACE_EMPTY;
$next_thumb_file = REPLACE_EMPTY;
}
if (!empty($next_prev_cache[$prev_image_id])) {
$prev_image_name = format_text($next_prev_cache[$prev_image_id]['image_name'], 2);
$prev_image_url = $site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$prev_image_id.((!empty($mode)) ? "&mode=".$mode : ""));
if (!get_file_path($next_prev_cache[$prev_image_id]['image_media_file'], "media", $next_prev_cache[$prev_image_id]['cat_id'], 0, 0)) {
$prev_image_file = ICON_PATH."/404.gif";
}
else {
$prev_image_file = get_file_path($next_prev_cache[$prev_image_id]['image_media_file'], "media", $next_prev_cache[$prev_image_id]['cat_id'], 0, 1);
}
if (!get_file_path($next_prev_cache[$prev_image_id]['image_thumb_file'], "thumb", $next_prev_cache[$prev_image_id]['cat_id'], 0, 0)) {
$prev_thumb_file = ICON_PATH."/".get_file_extension($next_prev_cache[$prev_image_id]['image_media_file']).".gif";
}
else {
$prev_thumb_file = get_file_path($next_prev_cache[$prev_image_id]['image_thumb_file'], "thumb", $next_prev_cache[$prev_image_id]['cat_id'], 0, 1);
}
}
else {
$prev_image_name = REPLACE_EMPTY;
$prev_image_url = REPLACE_EMPTY;
$prev_image_file = REPLACE_EMPTY;
$prev_thumb_file = REPLACE_EMPTY;
}
$site_template->register_vars(array(
"next_image_id" => $next_image_id,
"next_image_name" => $next_image_name,
"next_image_url" => $next_image_url,
"next_image_file" => $next_image_file,
"next_thumb_file" => $next_thumb_file,
"prev_image_id" => $prev_image_id,
"prev_image_name" => $prev_image_name,
"prev_image_url" => $prev_image_url,
"prev_image_file" => $prev_image_file,
"prev_thumb_file" => $prev_thumb_file
));
unset($next_prev_cache);
nobby
-
Leider stimmt die Bilder "vorher" / "nachher" in der Lightbox auch mit dem Originalcode nicht. Muss wohl was mit dem Mode Multi Lightbox zu tun haben :(
-
... Eventuell das Mod entfernen und so rantasten ...