Show Posts

1

Mods & Plugins (Requests & Discussions) / Re: PIN MOD

« on: September 26, 2017, 08:30:43 AM »

Hallo,
ich habe den PIN MOD von KurtW in eine frische 4images 1.8 eingebaut. http://www.grosspeterwitz.de/4images_kinder/details.php?image_id=1

Leider tritt in der Detailansicht folgender fehler auf.

Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in /www/htdocs/w00aca3c/4images_kinder/details.php on line 605

Warning: mysql_query(): A link to the server could not be established in /www/htdocs/w00aca3c/4images_kinder/details.php on line 605

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/htdocs/w00aca3c/4images_kinder/details.php on line 610

hier ein auszug aus meiner details.php
<?php
/**************************************************************************
* *
* 4images - A Web Based Image Gallery Management System *
* ---------------------------------------------------------------- *
* *
* File: details.php *
* Copyright: (C) 2002-2016 4homepages.de *
* Email: 4images@4homepages.de *
* Web: http://www.4homepages.de *
* Scriptversion: 1.8 *
* *
**************************************************************************
* *
* 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. *
* *
*************************************************************************/

$main_template = 'details';

define('GET_CACHES', 1);
define('ROOT_PATH', './');
define('MAIN_SCRIPT', __FILE__);
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) {
 redirect($url);
}

$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")."
 FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c)
 LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
 WHERE i.image_id = $image_id AND i.image_active = 1 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) {
 redirect($url);
}

$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);

//-----------------------------------------------------
//--- 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);
show_image($image_row, $mode, 0, 1);

//--- Start mod: pin images -----------------------------
$image_pin_allow = $image_row['image_pin_allow'];
$ext = get_file_extension($image_row['image_media_file']);
$allow_filetypes = array('jpg','jpeg','JPG','JPEG','gif','bmp','png');
if (in_array($ext, $allow_filetypes) && $image_pin_allow == '1') {
$image_pin_allow = '1'; } else {
$image_pin_allow = '0';
}
//--- End mod: pin images -------------------------------

 //--- SEO variables -------------------------------

 $meta_keywords = !empty($image_row['image_keywords']) ? strip_tags(implode(", ", explode(",", $image_row['image_keywords']))) : "";
 $meta_description = !empty($image_row['image_description']) ? strip_tags($image_row['image_description']) . ". " : "";

 $site_template->register_vars(array(
 "detail_meta_description" => str_replace('"', """, $meta_description),
 "detail_meta_keywords" => str_replace('"', """, $meta_keywords),
 "prepend_head_title" => $image_name . " - ",
 ));

$in_mode = 0;

$sql = "";
if ($mode == "lightbox") {
 if (!empty($user_info['lightbox_image_ids'])) {
 $image_id_sql = str_replace(" ", ", ", trim($user_info['lightbox_image_ids']));
 $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 = 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);

//-----------------------------------------------------
//--- 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']));

 $captcha = (isset($HTTP_POST_VARS['captcha'])) ? un_htmlspecialchars(trim($HTTP_POST_VARS['captcha'])) : "";

 // 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 != "") ? " " : "").$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 != "") ? " " : "").$lang['username_exists'];
 $error = 1;
 }
 }
 if ($user_name == "") {
 $msg .= (($msg != "") ? " " : "").$lang['name_required'];
 $error = 1;
 }
 if ($comment_headline == "") {
 $msg .= (($msg != "") ? " " : "").$lang['headline_required'];
 $error = 1;
 }
 if ($comment_text == "") {
 $msg .= (($msg != "") ? " " : "").$lang['comment_required'];
 $error = 1;
 }

 if ($captcha_enable_comments && !captcha_validate($captcha)) {
 $msg .= (($msg != "") ? " " : "").$lang['captcha_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']);
 $msg = $lang['comment_success'];
 $site_sess->set_session_var("msgdetails", $msg);
 redirect(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$image_id.((!empty($mode)) ? "&mode=".$mode : "").(($page > 1) ? "&page=".$page : ""));
 }
 }
 unset($row);
 unset($spam_row);
}

//-----------------------------------------------------
//--- Show Comments -----------------------------------
//-----------------------------------------------------
if ($msgdetails = $site_sess->get_session_var("msgdetails"))
{
 $msg .= ($msg !== "" ? " " : "").$msgdetails;
 unset($msgdetails);
 $site_sess->drop_session_var("msgdetails");
}

if ($image_allow_comments == 1) {
 $site_template->register_vars(array(
 "has_rss" => true,
 "rss_title" => "RSS Feed: ".$image_name." (".str_replace(':', '', $lang['comments']).")",
 "rss_url" => $script_url."/rss.php?action=comments&".URL_IMAGE_ID."=".$image_id
 ));

 $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 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 = format_text($comment_row[$i]['comment_user_name'], 2);
 $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 = format_text($comment_row[$i][$user_table_fields['user_name']], 2);

 $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 href=\"".$comment_user_profile_link."\"><img src=\"".get_gallery_image("profile.gif")."\" border=\"0\" alt=\"".$comment_user_name."\" /></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']])) ? format_text($comment_row[$i][$user_table_fields['user_icq']]) : "";
 if (!empty($comment_user_icq)) {
 $comment_user_icq_button = "<a href=\"http://www.icq.com/people/about_me.php?uin=".$comment_user_icq."\" target=\"_blank\"><img src=\"http://status.icq.com/online.gif?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 = format_text($comment_row[$i][$user_table_fields['user_email']]);
 $comment_user_email_save = format_text(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 .= " ";
 $comment_user_info .= (isset($comment_row[$i][$user_table_fields['user_joindate']])) ? " ".$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']])) ? " ".$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 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 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) {
 $admin_links .= ($config['user_edit_comments'] != 1) ? "" : "<a 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 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) ? format_text(trim(stripslashes($HTTP_POST_VARS['user_name'])), 2) : (($user_info['user_level'] != GUEST) ? format_text($user_info['user_name'], 2) : "");
 $comment_headline = (isset($HTTP_POST_VARS['comment_headline']) && $error) ? format_text(trim(stripslashes($HTTP_POST_VARS['comment_headline'])), 2) : "";
 $comment_text = (isset($HTTP_POST_VARS['comment_text']) && $error) ? format_text(trim(stripslashes($HTTP_POST_VARS['comment_text'])), 2) : "";

 $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'],
 "lang_captcha" => $lang['captcha'],
 "lang_captcha_desc" => $lang['captcha_desc'],
 "captcha_comments" => (bool)$captcha_enable_comments
 ));
 $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 .= "<a href=\"".$site_sess->url(ROOT_PATH."admin/index.php?goto=".urlencode("images.php?action=editimage&image_id=".$image_id))."\" target=\"_blank\">".$lang['edit']."</a> ";
 $admin_links .= "<a href=\"".$site_sess->url(ROOT_PATH."admin/index.php?goto=".urlencode("images.php?action=removeimage&image_id=".$image_id))."\" target=\"_blank\">".$lang['delete']."</a>";
}
elseif ($is_image_owner) {
 $admin_links .= ($config['user_edit_image'] != 1) ? "" : "<a href=\"".$site_sess->url(ROOT_PATH."member.php?action=editimage&".URL_IMAGE_ID."=".$image_id)."\">".$lang['edit']."</a> ";
 $admin_links .= ($config['user_delete_image'] != 1) ? "" : "<a href=\"".$site_sess->url(ROOT_PATH."member.php?action=removeimage&".URL_IMAGE_ID."=".$image_id)."\">".$lang['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);
}

//-----------------------------------------------------
//---Clickstream---------------------------------------
//-----------------------------------------------------
$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_url = "?".URL_PAGE."=".$regs[1];
 }
 }
 $clickstream .= "<a href=\"".$site_sess->url(ROOT_PATH."lightbox.php".$page_url)."\" class=\"clickstream\">".$lang['lightbox']."</a>".$config['category_separator'];
}
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).$config['category_separator'];
}
$clickstream .= $image_name."";
//-----------------------------------------------------
//--- Start mod: pin images ---------------------------
//-----------------------------------------------------
if (($config['pin_image_show'] == 'yes' && $image_pin_allow == '1') || ($config['pin_image_show'] == 'yes1' && $user_info['user_level'] >= USER && $image_pin_allow == '1') || ($config['pin_image_show'] == 'yes2' && $user_info['user_level'] >= USER && $image_pin_allow == '1') || ($config['pin_image_show'] == 'yes3' && $user_info['user_level'] == ADMIN && $image_pin_allow == '1') || ($config['pin_image_show'] == 'yes4' && $user_info['user_level'] == ADMIN && $image_pin_allow == '1')) {
$pin_image_show = '1';
$pin_image_show_info = '1';
$pin_image_show_access = '1';
} elseif ($config['pin_image_show'] == 'yes1' && $user_info['user_level'] == GUEST && $image_pin_allow == '1') {
$pin_image_show = '1';
$pin_image_show_info = '1';
$pin_image_show_access = '0';
} elseif ($config['pin_image_show'] == 'yes2' && $user_info['user_level'] == GUEST && $image_pin_allow == '1') {
$pin_image_show = '0';
$pin_image_show_info = '1';
$pin_image_show_access = '0';
} elseif ($config['pin_image_show'] == 'yes3' && $user_info['user_level'] != ADMIN && $image_pin_allow == '1') {
$pin_image_show = '1';
$pin_image_show_info = '0';
$pin_image_show_access = '0';
} elseif ($config['pin_image_show'] == 'yes4' && $user_info['user_level'] >= USER && $image_pin_allow == '1') {
$pin_image_show = '1';
$pin_image_show_info = '0';
$pin_image_show_access = '0';
} else {
$pin_image_show = '0';
$pin_image_show_info = '0';
$pin_image_show_access = '0';
}

if ($config['pin_image_smilie'] == 0 && $config['pin_image_captcha'] == 0) {
$pin_window_height = '245';
}
elseif ($config['pin_image_smilie'] == 1 && $config['pin_image_captcha'] == 0) {
$pin_window_height = '285';
}
elseif ($config['pin_image_smilie'] == 1 && $config['pin_image_captcha'] == 1) {
$pin_window_height = '475';
}

if ($config['pin_image_show'] == 'yes' || $config['pin_image_show'] == 'yes1' || $config['pin_image_show'] == 'yes2' || $config['pin_image_show'] == 'yes3' || $config['pin_image_show'] == 'yes4') {
$sql = "SELECT * FROM ".PIN_TABLE."
 WHERE pin_image_id = $image_id
 ORDER BY pin_id DESC";
 $result = mysql_query($sql);

$pin_image = "\n";
$pin_image .= "<div id=\"image_content\">\n";
$pin_image .= "<div class=pgdiv>\n";
for ($i=0; $i<mysql_num_rows($result); $i++) {
mysql_data_seek ($result, $i);
$row = mysql_fetch_row($result);
$pin_id=$row[0];
$pin_image_id=$row[1];
$pin_user_id=$row[2];
$pin_user_name=$row[3];
$pin_art=$row[4];
$pin_col=$row[5];
$pin_headline=$row[6];
$pin_text=$row[7];
$pin_date = format_date($config['date_format']." ".$config['time_format'],$row[9]);
$pin_x=$row[10];
$pin_y=$row[11];

// ---- Start Admin Pin Links --------------------------------------------------
$admin_pin_links = "";
if ($user_info['user_level'] == ADMIN) {
 $admin_pin_links .= "<a href='admin/pins.php?action=editpin&pin_id=".$pin_id."' target='_blank'>(Edit)</a> ";
 $admin_pin_links .= "<a href='admin/pins.php?action=removepin&pin_id=".$pin_id."' target='_blank'>(Delete)</a>";
}
// ---- END Admin Pin Links ----------------------------------------------------
// ---- Start replace smilie codes ---------------------------------------------
if ($config['pin_image_smilie'] != 0) {
 $search_smilie = array("#)", "#-D", "#(", "#-o", "#?#", "#?", "#-)", "#-x", "#-p", "#-*", "#*-(", "#3-(", "#roll#", "#wink#", "#-|", "#o", "#3-)", "#lol#", "LOL", "#!#", "#idea#");
 $replace_smilie = array("smile", "biggrin", "sad", "eek", "question", "confused", "cool", "mad", "razz", "redface", "cry", "evil", "rolleyes", "wink", "neutral", "surprised", "twisted", "lol", "lol", "exclaim", "idea");
 for($smile=0;$smile<count($search_smilie);$smile++) {
 $pin_headline = str_replace($search_smilie[$smile],"<img src='".TEMPLATE_PATH."/smilies/icon_".$replace_smilie[$smile].".gif'>",$pin_headline);
 $pin_text = str_replace($search_smilie[$smile],"<img src='".TEMPLATE_PATH."/smilies/icon_".$replace_smilie[$smile].".gif'>",$pin_text);
 }
}
// ---- End replace smilie codes -----------------------------------------------
// ---- Start pin text Umbruch -------------------------------------------------
$pin_text = wordwrap($pin_text, 17, "\n", TRUE);
// ---- END pin text Umbruch ---------------------------------------------------
if ($pin_user_id != -1) {
$pin_image .= "<a style=\"cursor:pointer;\"><img src=\"".TEMPLATE_PATH."/images/pin/pin".$pin_art.".gif\" border=\"0\" style=\"position:absolute; left:".($pin_x-($config['pin_position_x']))."; top:".($pin_y-($config['pin_position_y'])).";\" title=\"header=[".$pin_headline."] body=[".$pin_text."".$lang['pin_from']." <a href='member.php?action=showprofile&user_id=".$pin_user_id."'>".$pin_user_name."</a> (".$pin_date.")".$admin_pin_links."] fade=[on] fadespeed=[0.06] requireclick=[off] singleclickstop=[on] doubleclickstop=[off]\"></a>\n";
}
else {
$pin_image .= "<a style=\"cursor:pointer;\"><img src=\"".TEMPLATE_PATH."/images/pin/pin".$pin_art.".gif\" border=\"0\" style=\"position:absolute; left:".($pin_x-($config['pin_position_x']))."; top:".($pin_y-($config['pin_position_y'])).";\" title=\"header=[".$pin_headline."] body=[".$pin_text."".$lang['pin_from']." ".$pin_user_name." (".$pin_date.")".$admin_pin_links."] fade=[on] fadespeed=[0.06] requireclick=[off] singleclickstop=[on] doubleclickstop=[off]\"></a>\n";
}
}
$pin_image .= "<script src=\"".TEMPLATE_PATH."/pin_images.js\"></script> \n";
$pin_image .= "</div>\n";
$pin_image .= "</div>\n";
}
$site_template->register_vars(array(
 "pin_image" => $pin_image,
 "pin_window_height" => $pin_window_height,
 "pin_image_show" => $pin_image_show,
 "lang_pin_info" => $lang['pin_info'],
 "pin_image_show_info" => $pin_image_show_info,
 "lang_pin_info_access" => $lang['pin_info_access'],
 "pin_image_show_access" => $pin_image_show_access,
 "url_pin_images" => $site_sess->url(ROOT_PATH."pin_images.php?pin=1"),
 "lang_pin_post" => $lang['pin_post']
));
unset($pin_image);
//-----------------------------------------------------
//--- End mod: pin images -----------------------------
//-----------------------------------------------------
//-----------------------------------------------------
//--- 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');
?>

Es liegt wohl an der Verbindung zur Datenbank.
meine PHP Version lautet 5.5.38

Der Code von KurtW wurde um das Jahr 2008 Programmiert. Mit der 4images Version 1.7.9 funktioniert es einwandfrei.

Könnte sich jemand mit fundierten PHP Kenntnissen das mal anschauen?

MFG kubiczek

2

Discussion & Troubleshooting / Re: Suchergebnissausgabe

« on: June 26, 2017, 10:30:52 AM »

Hallo,

ich berechne anhand der Geburts-Sterbedaten das Alter eines Grabsteins, http://www.grosspeterwitz.de/friedhof/4images/alteste_lukas.php
leider stimmt die abwärts Sortierung nicht,
zur Zeit sortiere ich die Ausgabe mittels SQL "ORDER BY image_alter desc LIMIT 0,25" in der Zeile 51
wie bekomme ich es hin, dass die errechnete $ausgabe nach $alter sortiert wird. sehe Zeile 76

"ORDER BY image_alter desc" muss gelöscht werden, aber weiter komme ich nicht.........

sort_desc ($alter)???????????

@Rembrandt wäre schön wenn du mir da einen kleinen Tipp geben könntest,

MFG

<?php
/**************************************************************************
* *
* 4images - A Web Based Image Gallery Management System *
* ---------------------------------------------------------------- *
* *
* File: alteste.php *
* Copyright: (C) 2002-2009 Jan Sorgalla *
* Email: jan@4homepages.de *
* Web: http://www.4homepages.de *
* Scriptversion: 1.7.9 *
* File Version: 1.0.0 (by Rembrandt www.vienna-pictures.com) *
* 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. *
* *
*************************************************************************/

$main_template = 'statistic'; // <-- Your Template Title

define('GET_CACHES', 1);
define('ROOT_PATH', './');
define('MAIN_SCRIPT', __FILE__);
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
include(ROOT_PATH.'includes/page_header.php');
$txt_clickstream = $lang['statistic_page_title'];
$verstorbene = $lang['verstorbene'];
$geboren_stat = $lang['geboren_stat'];
$gestorben_stat = $lang['gestorben_stat'];
$geborene = $lang['geborene'];
$anklicken = $lang['anklicken']; // <-- Clickstream Name
$zginol= $lang['zginol'] ;
$gefallen= $lang['gefallen'] ;

//################## EXAMPLE CUSTOM PHP CODE STARTS HERE ############################
$imgtable_width = ceil((intval($config['image_table_width'])) / $config['image_cells']);
 if ((substr($config['image_table_width'], -1)) == "%") {
 $imgtable_width .= "%";
 }

 $sql = "SELECT ((substr(i.image_gestorbenGP,7,4)) - (substr(i.image_geboren,7,4))) AS image_alter, i.image_gefallenam,i.image_gestorbenGP,i.image_geboren, i.image_id, i.cat_id, i.user_id, i.image_name,i.image_active, i.image_media_file, i.image_thumb_file
 FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c)
 WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND image_gestorbenGP LIKE '%%.%%.%%%%' AND image_geboren LIKE '%%.%%.%%%%'
 ORDER BY image_alter desc LIMIT 0,25
 ";
 $result = $site_db->query($sql);

 $liste = "<table style=\"text-align:center;\" width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\">\n";
 $liste .= "<tr><td class=\"title4\">Die 25 ältesten Peterwitzer.</td></tr>";
 $liste .= "</table>";
 $liste .= "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\">\n";

 $count = 0;
 $bgcounter = 0;
 $ausgabe="";
 $config['image_cells'] = 1;
 while ($image_row = $site_db->fetch_array($result)) {

$datum_gestorben = explode(".",$image_row['image_gestorbenGP']);

$datum_geboren = explode(".",$image_row['image_geboren']);

$alter = ($datum_gestorben[2]) - ($datum_geboren[2]);
if (($datum_gestorben[1]) < ($datum_geboren[1]) || ($datum_gestorben[1] == ($datum_geboren[1]) && ($datum_gestorben[0]) < ($datum_geboren[0]))) {
$alter--;
}

$ausgabe = ($alter >= 0) ? "Mit ".$alter." Jahren ist ".$image_row['image_name']." ".$gestorben_stat."" :"";

 if(!empty($ausgabe)){
 if ($count == 0) {
 $row_bg_number = ($bgcounter++ % 2 == 0) ? 1 : 2;
 $liste .= "<tr class=\"imagerow".$row_bg_number."\">\n";
 }
 $liste .= "<td width=\"".$imgtable_width."\" valign=\"top\"><a href=\"./details.php?image_id=".$image_row['image_id']."\"onmouseover=\"Tip('".$anklicken." <CENTER><img src=\'./data/media/".$image_row['cat_id']."/".$image_row['image_media_file']."\' width=\'300\' ></CENTER> ')\" onmouseout=\"UnTip()\" >".$ausgabe."</td>\n";
 $liste .= "</tr>\n";
 $count++;
 if ($count == $config['image_cells']) {
 $liste .= "</tr>\n";
 $count = 0;
 }
 }
 }// end while
 $liste .= "</table>\n";

 $content = $liste;
 unset($liste);

//-----------------------------------------------------
//--- Clickstream -------------------------------------
//-----------------------------------------------------
$clickstream = "<a href=\"".$site_sess->url(ROOT_PATH."index.php")."\" class=\"clickstream\">".$lang['home']."</a>".$config['category_separator'].$txt_clickstream."";

//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
"content" => $content,
 "msg" => $msg,
 "clickstream" => $clickstream,
 "lang_statistic_page_title" => $lang['statistic_page_title']
));
$site_template->print_template($site_template->parse_template($main_template));
include(ROOT_PATH.'includes/page_footer.php');
?>

3

Chit Chat / Re: KurtW MODs and Templates

« on: April 28, 2017, 07:11:01 PM »

Quote from: Netsu on March 12, 2010, 12:04:10 PM

web.archive.org/web/20080312164311/www.4homepages.de/forum/index.php?board=15.100;sort=starter

web.archive.org/web/20080312164311/www.4homepages.de/forum/index.php?board=15.100;sort=starter

Hallo,

hat jemand noch eine Kopie der Einbauanleitung vom PIN MOD. Leider ist die erste Seite mit der Anleitung gesperrt.
die Dateien habe ich noch.

Meine Instalation ist schon sehrveraltet, bin grade dabei alles auf 1.8 umzustellen, aber ohne den PIN MODE ist es absolut uninteressant.

http://www.grosspeterwitz.de/4images_neu/details.php?image_id=18&l=deutsch

würde mich freuen, wenn jemand sie mir zuschicken könnte.

gruß

4

Discussion & Troubleshooting / Re: Datumsberechnung

« on: June 29, 2014, 05:33:55 PM »

Hallo Rembrand,
vor zwei Jahren hast Du mir geholfen eine Datumausgabe zu erzeugen.
seit einiger zeit funktioniert die die Funktion nicht mehr.
währst Du so net und könntest mal drüber schauen.?

meines wissens habe ich nichts geändert.

gruß

Quote from: kubiczek on January 17, 2012, 10:48:50 PM

Hallo,

Prima, es klappt. ich habe es ein wennig erweitert. Berechnung erfolgt nun in JAHREN MONATEN TAGEN

suche in details.php
//-----------------------------------------------------
//---Clickstream---------------------------------------

füge darüber ein

function alter_berechnen($datum1,$datum2) {
 list ($t1, $m1, $j1) = split('[.]', $datum1);
 list ($t2, $m2, $j2) = split('[.]', $datum2);
 if ($j1 % 4 != 0 or ($j1 % 100 == 0 and $j1 % 400 != 0)){
 $tf= 28;}
 else {
 $tf = 29;
 }
 $xtage = array( 0, 31, $tf, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31);
 if ($t2 < $t1){
 $t2 += $xtage[(int)$m1];
 $m1 += 1;
 }
 if ($m2 < $m1){
 $m2 += 12;
 $j1 +=1;
 }
 $tage = $t2 - $t1;
 $monate = $m2 - $m1;
 $jahre = $j2 - $j1;
 $alter = array('j'=>$jahre, 'm'=>$monate, 't'=>$tage);
 return $alter;
}

# Beispiel:

if($image_row['image_gestorbenGP'] && $image_row['image_geboren']){

$alter_jahr_monat_tag = alter_berechnen($image_row['image_geboren'],$image_row['image_gestorbenGP']);

}

suche
$site_template->register_vars(array(
 "msg" => $msg,

füge darunter
"image_jahr_monat_tag" => $alter_jahr_monat_tag['j'] ." Jahre + ". $alter_jahr_monat_tag['m'] ." Monate + ". $alter_jahr_monat_tag['t'] ." Tage ",

und in details.html an passender stelle einfügen

{alter_jahr_monat_tag}

DEMO: www.grosspeterwitz.de/friedhof/4images/details.php?image_id=865

5

Mods & Plugins (Releases & Support) / Re: [MOD] Pfeile als Overlay auf Bild (arrows as overlay on picture)

« on: December 24, 2012, 01:05:36 PM »

Klasse sache,

ich bin auf der suche nach einer möglichkeit eines Auswahlmenüs für verschiedene Overlays in der Detailsansicht.

ich habe bei mir auf meiner Seite den Pin MOD instaliert.
http://www.grosspeterwitz.de/gp/details.php?image_id=6478

desweiteren bin ich schon seit einiger zeit dran einen ZOOM Mod auf meiner Seite zu Instalieren.
http://www.grosspeterwitz.de/4images/details.php?image_id=14
http://www.4homepages.de/forum/index.php?topic=29056.msg155686#msg155686

Leider bekomme ich es nicht hin ein Auswahlmenü für die Overlays zu erstellen.
http://www.grosspeterwitz.de/4images_puzzle/details.php?image_id=1

Siehst Du da eine einfach möglichkeit einer UMSCHALTUNG?

6

Mods & Plugins (Releases & Support) / Re: [Mod] Captcha can mathematics

« on: November 18, 2012, 09:55:09 PM »

Ich habe es seit einigen Monaten, bis jetzt ist kein einziger eintrag erfolgt.

Die Akzeptanz der User ist auch vorhanden,

Danke Rembrandt

7

Discussion & Troubleshooting / Re: SPAM trotz CAPTCHA

« on: August 09, 2012, 08:02:10 PM »

Hallo,

seit einer woche werden keine Kommentare mehr von Spam Programmen hinterlassen.

@ Remmbrandt dein Mathematisches Captcha funktioniert einwandfrei.

Gruß

8

Discussion & Troubleshooting / Re: SPAM trotz CAPTCHA

« on: August 05, 2012, 05:08:43 PM »

So,

auf deiner DEMO Seite klappt es.

Bei mir geht es nicht. Habe es jetzt mehrmals eingebaut, DIE ZAHLEN werden nicht mehr gelöscht.

liegt es daran das ich noch die Version 1.7.6 verwende?

link : http://www.grosspeterwitz.de/gp/details.php?image_id=6509&l=deutsch

Code: [Select]

<table  width="370"  border="0">
  <tr>
    <td ><form name="commentform" action="{self}" method="post" onsubmit="postbutton.disabled=true;"> 

              <table width="370"  cellpadding="4" cellspacing="0">

                <tr>
                  <td colspan="2" valign="top"  class="head47">{lang_post_comment}</td>
                </tr>
                <tr> 

                  <td CLASS="reg_table16" width="100" ><b>{lang_name}</b></td>

                  <td CLASS="reg_table15"><input type="text" name="user_name" size="30" value="{user_name}" class="commentinput" /></td>
                </tr>

                <tr> 

                  <td width="100" valign="top" CLASS="reg_table16"><b>{lang_comment}</b></td>

                  <td CLASS="reg_table15"><textarea name="comment_text" cols="35" rows="10" class="commenttextarea">{comment_text}</textarea></td>
                </tr>

                <tr> 

                  <td width="100" valign="top" CLASS="reg_table16">&nbsp;</td>

                  <td CLASS="reg_table15">{bbcode}</td>
                </tr>

								{if captcha_comments}

								<tr> 

                  <td CLASS="reg_table16" width="100" valign="top" ><b>{lang_captcha}</b></td>

                  <td CLASS="reg_table15" >

									  <a href="javascript:new_captcha_image();"><img src="{url_captcha_image}" border="0" id="captcha_image" /></a>

									  <br />

										<span class="setval"><input type="text" name="captcha" size="20" class="captchainput" id="captcha_input" value="1 + 2 + 3"  onfocus="loesche();" />{if captcha_calculation} = <input class="input_res" name="result" type="text" value=" 6 "  onfocus="loesche2();" >{endif captcha_calculation}</span>



										<br />

								  {lang_captcha_desc}									</td>
                </tr>

								{endif captcha_comments}

                <tr> 

                  <td CLASS="reg_table13" width="100" valign="top" >&nbsp;</td>

                  <td CLASS="reg_table14">

                    <input type="hidden" name="action" value="postcomment" />

                    <input type="hidden" name="id" value="{image_id}" />

                  <input type="submit" name="postbutton" value="{lang_post_comment}" class="button" />                  </td>
                </tr>
          </table>

            </form>
            
            <script type="text/javascript" language="JavaScript">
function loesche() {
  window.document.contact_mailform.captcha.value = '';
}
function loesche2() {
  window.document.contact_mailform.result.value = '';
}
</script>

            </td>
  </tr>
</table>

9

Discussion & Troubleshooting / Re: SPAM trotz CAPTCHA

« on: August 05, 2012, 03:30:47 PM »

Hallo,

ohne das script na </form>

Code: [Select]

<script type="text/javascript" language="JavaScript">
function loesche() {
window.document.commentform.captcha.value = '';
window.document.commentform.result.value = '';
}
</script>

geht es, sobald ich das script einbaue werden die Zahlen aus der rechnung gelöscht, wenn man das ergebniss einträgt.

bei Deinem Kontakt Formular ist es genau das gleiche Problem.

10

Discussion & Troubleshooting / Re: SPAM trotz CAPTCHA

« on: August 05, 2012, 10:29:26 AM »

Hallo,

könnte man nicht in das Textfeld, Grau hinterlegt, ein Beispiel eintragen "1 + 2 + 3 = 6 " damit die User verstehen was sie machen sollen.

Denn die Meisten habe sich schon an das normale capcha gewöhnt.

Habe was mit Photoshop vorbereitet.

gruß

11

Discussion & Troubleshooting / Re: SPAM trotz CAPTCHA

« on: August 05, 2012, 09:44:14 AM »

Quote from: Rembrandt on August 04, 2012, 05:31:22 AM

Oder wenn es Spambots sind kannst du meinen Mod ausprobieren:
http://www.4homepages.de/forum/index.php?topic=28210.msg152417#msg152417

Hallo,

Dein Mathe Captcha funktioniert Klasse. Bis jezt keine Einträge.
hoffentlich kappieren die User gleich , das Sie rechnen müssen.

gruß

12

Discussion & Troubleshooting / Re: SPAM trotz CAPTCHA

« on: August 03, 2012, 10:09:15 PM »

Hallo,

Trotz CAPTCHA habe ich in letzter Zeit ca. 20-30 Spam Einträge an TAG in den Kommentaren.

habe schon die Einstellungen verändert. GROß klein, mit Zahlen, usw. auch habe ich es so eingestellt das man das CHAPCHA kaum noch erkennen kann, und troztem wurde Spam eingetragen,

Hat jemand eine Idee was man noch machen kann?

Die OPTION: Nur Regestrierte Benutzer dürfen POSTEN , will ich nicht umsetzten, da sonst noch wenniger Kommentare geschrieben werden.

gruß

13

Discussion & Troubleshooting / Re: If i use polish letter "ó" in image comment - the comment is blank - help !

« on: June 17, 2012, 07:35:28 PM »

Hi,

w lang/main.php

poprawnie "Proszê wpisaæ komentarz!"

nie poprawnie "Proszę wpisać komentarz!"

jak wyglada twoja lang/main.php

to jest moja

<?php
/**************************************************************************
* *
* 4images - A Web Based Image Gallery Management System *
* ---------------------------------------------------------------- *
* *
* File: main.php *
* Copyright: (C) 2002 Jan Sorgalla *
* Email: jan@4homepages.de *
* Web: http://www.4homepages.de *
* Scriptversion: 1.7 *
* *
* 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. *
* --------------------------------------------------------------- *
* Ten skrypt nie jest darmowy! Proszê przeczytaæ

*
*

o prawach autporskich (Licence.txt). *
* *
*************************************************************************/

/**************************************************************************
* *
* Polskie t³umaczenie: Pawe³ Szybiak (www.mycreation.prv.pl) *
* *
*************************************************************************/

$lang['no_settings'] = "B£¡D: Nie mo¿na za³adowaæ ustawieñ konfiguracyjnych!";

//-----------------------------------------------------
//--- Templates ---------------------------------------
//-----------------------------------------------------
$lang['charset'] = "ISO-8859-2";
$lang['direction'] = "ltr";

//-----------------------------------------------------
//--- Userlevel ---------------------------------------
//-----------------------------------------------------
$lang['userlevel_admin'] = "Administratror";
$lang['userlevel_user'] = "U¿ytkownik";
$lang['userlevel_guest'] = "Go¶æ";

//-----------------------------------------------------
//--- Categories --------------------------------------
//-----------------------------------------------------
$lang['no_categories'] = "Nie znaleziono kategorii";
$lang['no_images'] = "Nie ma zdjêæ w tej kategorii";
$lang['select_category'] = "Zaznacz kategoriê";

//-----------------------------------------------------
//--- Comments ----------------------------------------
//-----------------------------------------------------
$lang['name_required'] = "Proszê wpisaæ osobê!";
$lang['headline_required'] = "Proszê wpisaæ tytu³!";
$lang['comment_required'] = "Proszê wpisaæ komentarz!";
$lang['spamming'] = "Nie mo¿na postowac tak szybko, proszê spróbowac za chwilê.";
$lang['comments'] = "Komentarzy:";
$lang['no_comments'] = "Nie ma komentarzy dla tego zdjêcia";
$lang['comments_deactivated'] = "Komentarz nieaktywny!";
$lang['post_comment'] = "Wy¶lij komentarz";
$lang['exif_info'] = "Poka¿ EXIF Informacje";
$lang['schreib_comment'] = "Wy¶lij komentarz";
$lang['bild_info'] = "Poka¿ Informacje do Zdjêcia";
$lang['lesen_comment'] = "Czytaj dodane komentarze";
//-----------------------------------------------------
//--- BBCode ------------------------------------------
//-----------------------------------------------------
$lang['bbcode'] = "BBCode";
$lang['tag_prompt'] = "Wpisz tekst, który ma byæ formatowany:";
$lang['link_text_prompt'] = "Wpisz tekst, który ma byæ pokazywany dla ³±cza (opcjonalnie)";
$lang['link_url_prompt'] = "Wpisz pe³ny URL dla ³±cza";
$lang['link_email_prompt'] = "Wpisz adres e-mail dla ³±cza";
$lang['list_type_prompt'] = "Jaki typ listy chcesz utworzyæ? Wpisz '1' dla listy numerowanej, 'a' dla listy alfabetycznej lub zostaw pole puste dla listy punktowej.";
$lang['list_item_prompt'] = "Wpisz pozycje listy. Zostaw okienko puste lub kliknij 'Anuluj', aby zakoñczyæ listê.";

//-----------------------------------------------------
//--- Image Details -----------------------------------
//-----------------------------------------------------
$lang['download_error'] = "Pobiernie nie powiod³o siê!";
$lang['register_download'] = "Aby pobraæ zdjêcia trzeba siê zarejestrowaæ. » <a href=\"{url_register}\">Zarejestruj siê</a>";
$lang['voting_success'] = "Dziêkujê za ocenê tego zdjêcia";
$lang['voting_error'] = "Ocena niew³a¶ciwa!";
$lang['already_voted'] = "Ostatnio ju¿ g³osowa³e¶ na to zdjêcie.";
$lang['prev_image'] = "Poprzednie zdjêcie:";
$lang['next_image'] = "Nastêpne zdjêcie:";
$lang['category'] = "Kategoria:";
$lang['description'] = "Opis";
$lang['keywords'] = "S³owa kluczowe:";
$lang['date'] = "Data Dodania:";
$lang['hits'] = "Wy¶wietleñ:";
$lang['downloads'] = "Pobrañ:";
$lang['rating'] = "Ocena:";
$lang['votes'] = "g³osów";
$lang['file_size'] = "Wielko¶æ pliku:";
$lang['author'] = "Autor:";
$lang['name'] = "Imiê:";
$lang['headline'] = "Tytu³:";
$lang['comment'] = "Komentarz:";
$lang['added_by'] = "Doda³:";
$lang['allow_comments'] = "Dozwolone komentarze:";

// IPTC Tags
$lang['iptc_caption'] = "Caption:";
$lang['iptc_caption_writer'] = "Caption writer:";
$lang['iptc_headline'] = "Headline:";
$lang['iptc_special_instructions'] = "Special instructions:";
$lang['iptc_byline'] = "Byline:";
$lang['iptc_byline_title'] = "Byline title:";
$lang['iptc_credit'] = "Credit:";
$lang['iptc_source'] = "Source:";
$lang['iptc_object_name'] = "Object name:";
$lang['iptc_date_created'] = "Date created:";
$lang['iptc_city'] = "City:";
$lang['iptc_state'] = "State:";
$lang['iptc_country'] = "Country:";
$lang['iptc_original_transmission_reference'] = "Original transmission reference:";
$lang['iptc_category'] = "Category:";
$lang['iptc_supplemental_category'] = "Supplemental category:";
$lang['iptc_keyword'] = "Keywords:";
$lang['iptc_copyright_notice'] = "Copyright Notice:";

//-----------------------------------------------------
//--- Postcards ---------------------------------------
//-----------------------------------------------------
$lang['send_postcard'] = "Wy¶lij eKartkê";
$lang['edit_postcard'] = "Modfikuj eKartkê";
$lang['preview_postcard'] = "Podgl±d eKartki";
$lang['bg_color'] = "Kolor t³a:";
$lang['border_color'] = "Kolor ramki:";
$lang['font_color'] = "Kolor czcionki:";
$lang['font_face'] = "Czcionka:";
$lang['recipient'] = "Odbiorca";
$lang['sender'] = "Nadawca";
$lang['send_postcard_emailsubject'] = "eKartka dla Ciebie!";
$lang['send_postcard_success'] = "Dziêkujê! Twoja eKartka zosta³a wys³ana!";
$lang['back_to_gallery'] = "Wróæ do galerii";
$lang['invalid_postcard_id'] = "Niew³a¶ciwe ID eKartki.";

//-----------------------------------------------------
//--- Top Images --------------------------------------
//-----------------------------------------------------
$lang['top_image_hits'] = "Top 10 zdjêæ wg wy¶wietleñ";
$lang['top_image_downloads'] = "Top 10 zdjêæ wg pobrañ";
$lang['top_image_rating'] = "Top 10 zdjêæ wg oceny";
$lang['top_image_votes'] = "Top 10 zdjêæ wg ilo¶ci g³osów";

//-----------------------------------------------------
//--- Users -------------------------------------------
//-----------------------------------------------------
$lang['send_password_emailsubject'] = "Has³o dla {site_name}";

    // Temat maila dla has³a.
$lang['update_email_emailsubject'] = "Aktywacja adresu e-mail dla {site_name}";     // Temat maila dla kodu aktywacyjnego, kiedy zmieniono adres e-amil.
$lang['register_success_emailsubject'] = "Rejestracja na {site_name}";

// Temat maila dla kodu aktywacyjnego.
$lang['admin_activation_emailsubject'] = "Aktywacja konta";

// Temat maila dla aktywacyji konta przez admina.
$lang['activation_success_emailsubject'] = "Konto aktywne";

// Temat maila po aktywacyji konta przez admina.

$lang['no_permission'] = "Nie jeste¶ zalogowany lub nie masz ustawionych praw wstêpu na t± stronê!";
$lang['already_registered'] = "Jeste¶ ju¿ zarejestrowany. Je¶li zapomnia³e¶ has³a, kliknij <a href=\"{url_lost_password}\">tutaj</a>.";
$lang['username_exists'] = "U¿ytkownik jest ju¿ w bazie.";
$lang['email_exists'] = "Adres e-mail jest ju¿ w bazie.";
$lang['invalid_email_format'] = "Proszê wpisaæ poprawny adres e-mail.";
$lang['register_success'] = "Zosta³e¶ zarejestrowany. Na Twój adres e-mail zosta³ wys³any kod aktywcyjny.";
$lang['register_success_admin'] = "Zosta³e¶ zarejestrowany. Twoje konto jest w tej chwili nieaktywne - zanim bêdziesz móg³ siê zalogowaæ, Twoje konto bêdzie musia³ aktywowaæ administrator. Zostaniesz powiadomiony, kiedy Twoje konto zostanie aktywowane.";
$lang['register_success_none'] = "Zosta³e¶ zarejestrowany. Proszê siê zalogowaæ.";
$lang['missing_activationkey'] = "Twój klucz aktywacyjny zagin±³.";
$lang['invalid_activationkey'] = "Konto nieaktywne. Proszê zarejestrowaæ siê ponownie.</>";
$lang['activation_success'] = "Dziêkujê! Twoje konto jest ju¿ aktywne. Mo¿esz siê zalogowaæ.";
$lang['general_error'] = "Wyst±pi³y b³êdy. Proszê siê <a href=javascript:history.go(-1)>cofn±æ</a> i spróbowaæ ponownie. Je¶li problem siê powtórzy, skontaktuj siê z administratorem.";
$lang['invalid_login'] = "Poda³e¶ niew³a¶ciwy login lub has³o.";
$lang['update_email_error'] = "Proszê ponownie wpisaæ adres e-mail!";
$lang['update_email_confirm_error'] = "Adresy e-mail, które poda³e¶ nie s± identyczne!";
$lang['update_profile_success'] = "Twój profil zosta³ zaktualizowany!";
$lang['update_email_instruction'] = "Poniewa¿ zmieni³e¶ adres e-mail, musisz reaktywowaæ Twoje konto. Kod aktywacyjny zostanie wys³any na Twój nowy adres e-mail!";
$lang['update_email_admin_instruction'] = "Poniewa¿ zmieni³e¶ adres e-mail, administrator musi reaktywowaæ Twoje konto. Zostaniesz powiadomiony, kiedy Twoje konto bêdzie ponownie aktywne.";
$lang['invalid_email'] = "Niew³a¶ciwy adres e-mail.";
$lang['send_password_success'] = "Twoje has³o zosta³o wys³ane na Twój adres e-mail.";
$lang['update_password_error'] = "Wpisa³e¶ niew³a¶ciwe has³o.";
$lang['update_password_confirm_error'] = "Has³o, które poda³e¶ i potwierdzenie has³a, nie s± identyczne!";
$lang['update_password_success'] = "Twoje has³o zosta³o zmienione.";
$lang['invalid_user_id'] = "Nie znaleziono u¿ytkownika!";
$lang['emailuser_success'] = "E-mail zosta³ wys³any.";
$lang['send_email_to'] = "Wy¶lij wiadomo¶æ e-mail do:";
$lang['subject'] = "Temat:";
$lang['message'] = "Wiadomo¶æ:";
$lang['profile_of'] = "Profil u¿ytkownika:";
$lang['edit_profile_msg'] = "Tutaj mo¿esz zmieniæ swój profil u¿ytkownika i has³o.";
$lang['edit_profile_email_msg'] = " Notatka: je¶li zmieniasz Twój adres e-mail, musisz reaktywowaæ swoje konto. Kod aktywacyjny zostanie wys³any na Twój nowy adres e-mail.";
$lang['edit_profile_email_msg_admin'] = " Notatka: je¶li zmieniasz Twój adres e-mail, administrator musi reaktywowaæ Twoje konto.";
$lang['join_date'] = "Data:";
$lang['last_action'] = "Ostatnia aktywno¶æ:";
$lang['email'] = "E-mail:";
$lang['email_confirm'] = "Potwierdzenie e-mail'a:";
$lang['homepage'] = "Strona g³ówna:";
$lang['icq'] = "Numer gadu-gadu:";
$lang['show_email'] = "Pokazuj mój adres e-mail:";
$lang['allow_emails'] = "Przyjmowanie e-maili od administratora:";
$lang['invisible'] = "Ukryj mnie, gdy jestem on-line:";
$lang['optional_infos'] = "Opcjonalnie";
$lang['change_password'] = "Zmieñ has³o";
$lang['old_password'] = "Stare has³o:";
$lang['new_password'] = "Nowe has³o:";
$lang['new_password_confirm'] = "Potwierd¼ nowe has³o:";
$lang['lost_password'] = "Wpisz has³o ponownie";
$lang['lost_password_msg'] = "Je¶li zapomnia³e¶ has³a, wpisz adres e-mail, który poda³e¶ przy rejestracji.";
$lang['user_name'] = "U¿ytkownik:";
$lang['password'] = "Has³o:";

$lang['register_msg'] = "Proszê uzupe³niæ wszystkie pola. Na Twój adres e-mail zostanie wys³any kod aktywacyjny.";
$lang['agreement'] = "Warunki rejestracji:";
$lang['agreement_terms'] = "
Administratorzy podejm± starania maj±ce na celu usuwanie wszelkich uznawanych za obra¼liwe

materia³ów jak najszybciej, jednak¿e nie zawsze jest mo¿liwe przeczytanie ka¿dej wiadomo¶ci.

Zgadzasz siê wiêc, ¿e zawarto¶æ ka¿dego postu wyra¿a pogl±dy i opinie jego autora a

nie administratorów czy webmastera (poza wiadomo¶ciami pisanymi przez nich)

i nie ponosz± oni za te tre¶ci odpowiedzialno¶ci.
 
Zobowi±zujesz siê nie pisaæ ¿adnych uwag obra¼liwych, obscenicznych, wulgarnych, oszczerczych,

nienawistnych, zawieraj±cych gro¼by oraz udostêpniaæ innych materia³ów, które mog± byæ

sprzeczne z prawem.

Z³amanie tej zasady mo¿e byæ przyczyn± natychmiastowego i trwa³ego usuniêcia z listy

u¿ytkowników (wraz z powiadomieniem odpowiednich w³adz). Aby wspomóc te dzia³ania rejestrowane

s± adresy IP autorów. Przyjmujesz do wiadomo¶ci, ¿e webmaster i administratorzy maj± prawo

do usuwania, zmiany lub zamykania ka¿dego w±tku w ka¿dej chwili, je¶li zajdzie taka potrzeba.
Jako u¿ytkownik zgadzasz siê, ¿e wszystkie informacje, które wpiszesz bêd± przechowywane w

bazie danych. Informacje te nie bêd± podawane bez twojej zgody ¿adnym osobom ani podmiotom

trzecim, jednak¿e webmaster i administratorzy nie bêd± obarczeni odpowiedzialno¶ci±

za w³amania hackerskie prowadz±ce do pozyskania tych danych.
 
Ten system wykorzystuje cookies do przechowywania informacji na twoim komputerze.

Cookies nie zawieraj± ¿adnych informacji, które poda³e¶ i s³u¿± jedynie u³atwieniu

korzystania z tego systemu. Adres e-mail jest wykorzystywany jedynie dla potwierdzenia podanych

informacji oraz has³a (i dla przes³ania nowego has³a, gdyby¶ zapomnia³ stare).
 
 Klikaj±c odno¶nik Rejestracja na dole zgadzasz siê na te warunki.";

$lang['agree'] = "Rejestracja";
$lang['agree_not'] = "Nie zgadzam siê";
$lang['show_user_images'] = "Poka¿ wszystkie zdjêcia, które doda³ {user_name}";

//-----------------------------------------------------
//--- Edit Images -------------------------------------
//-----------------------------------------------------
$lang['image_edit'] = "Edycja zdjêcia";
$lang['image_edit_success'] = "Zdjêcie zmodyfikowano";
$lang['image_edit_error'] = "B³±d edycji zdjêcia";
$lang['image_delete'] = "Usuwanie zdjêcia";
$lang['image_delete_success'] = "Zdjêcie usuniêto";
$lang['image_delete_error'] = "B³±d usuwania zdjêcia";
$lang['image_delete_confirm'] = "Na pewno chcesz usun±æ ten plik zdjêcia?";

//-----------------------------------------------------
//--- Edit Comments -----------------------------------
//-----------------------------------------------------
$lang['comment_edit'] = "Edycja komentarza";
$lang['comment_edit_success'] = "Komentarz zmodyfikowano";
$lang['comment_edit_error'] = "B³±d edycji komentarza.";
$lang['comment_delete'] = "Usuwanie komentarza";
$lang['comment_delete_success'] = "Komentarz usuniêto";
$lang['comment_delete_error'] = "B³±d usuwania komentarza";
$lang['comment_delete_confirm'] = "Usun±c ten komentarz?";

//-----------------------------------------------------
//--- Image Upload ------------------------------------
//-----------------------------------------------------
$lang['field_required'] = "Proszê uzupe³niæ pole {field_name}!";
$lang['kb'] = "kb";
$lang['px'] = "px";
$lang['file_upload_error'] = "B³±d ³adowania pliku zdjêcia";
$lang['thumb_upload_error'] = "B³±d ³adowania pliku miniaturki";
$lang['invalid_file_type'] = "Niew³a¶ciwy typ pliku";
$lang['invalid_image_width'] = "Niew³a¶ciwa szeroko¶æ zdjêcia";
$lang['invalid_image_height'] = "Niew³a¶ciwa wysoko¶æ zdjêcia";
$lang['invalid_file_size'] = "Niew³a¶ciwa wielko¶æ zdjêcia";
$lang['image_add_success'] = "Zdjêcie dodano";
$lang['allowed_mediatypes_desc'] = "Akceptowane rozszerzenia: ";
$lang['keywords_ext'] = "S³owa kluczowe: S³owa kluczowe musz± byæ oddzielone spacj±.";
$lang['user_upload'] = "£adowanie zdjêcia";
$lang['image_name'] = "Nazwa zdjêcia:";
$lang['media_file'] = "Plik zdjêcia:";
$lang['thumb_file'] = "Plik miniaturki:";
$lang['max_filesize'] = "Max. wielko¶æ pliku: ";
$lang['max_imagewidth'] = "Max. szeroko¶æ zdjêcia: ";
$lang['max_imageheight'] = "Max. wysoko¶æ zdjêcia: ";
$lang['image_file_required'] = "Zaznacz plik zdjêcia!";
$lang['new_upload_emailsubject'] = "Nowe zdjêcia na stronie {site_name}";
$lang['new_upload_validate_desc'] = "Twoje zdjêcie zostanie sprawdzone przez administratora.";

//-----------------------------------------------------
//--- Lightbox ----------------------------------------
//-----------------------------------------------------
$lang['lightbox_no_images'] = "Nie ma zdjêæ w ulubionych.";
$lang['lightbox_add_success'] = "Zdjêcie dodano.";
$lang['lightbox_add_error'] = "B³±d dodania zdjêcia do ulubionych!";
$lang['lightbox_remove_success'] = "Usuniêto zdjêcie z ulubionych.";
$lang['lightbox_remove_error'] = "B³±d usuniêcia zdjêcia!";
$lang['lightbox_register'] = "abu móc u¿ywaæ Ulubionych, musisz siê zarejestrowaæ. » <a href=\"{url_register}\">Zarejestruj siê</a>";
$lang['lightbox_delete_success'] = "Album usuniêto.";
$lang['lightbox_delete_error'] = "B³±d usuwnia ulubionych!";
$lang['delete_lightbox'] = "Usuwanie Ulubionych";
$lang['lighbox_lastaction'] = "Ostatnia aktualizacja ulubionych:";
$lang['delete_lightbox_confirm'] = "Na pewno chcesz usun±æ Album?";

//-----------------------------------------------------
//--- Misc --------------------------------------------
//-----------------------------------------------------
$lang['new'] = "nowe"; // Oznaczenie kategorii i zdjêæ jako "NOWE"
$lang['home'] = "Strona g³ówna";
$lang['categories'] = "Kategorie";
$lang['sub_categories'] = "Podkategorie";
$lang['lightbox'] = "Album";
$lang['friedhof'] = "Wirtualny Cmentarz";
$lang['gpschule'] = "Zdjêcie Klasowe";
$lang['error'] = "B³±d";
$lang['register'] = "Rejestracja";
$lang['control_panel'] = "Panel kontrolny";
$lang['profile'] = "Profil u¿ytkownika";
$lang['search'] = "Szukaj";
$lang['advanced_search'] = "Szukaj";
$lang['new_images'] = "Nowe zdjêcia";
$lang['top_images'] = "Najlepsze zdjêcia";
$lang['registered_user'] = "Rejestracja";
$lang['nav_user'] = "Nawigacja";
$lang['Fehl'] = "Wpisz imiê, je¶li kogo¶ rozpoznajesz";
$lang['logout'] = "Wyloguj";
$lang['login'] = "Zaloguj";
$lang['lang_auto_login'] = "Zalogowaæ automatycznie przy nastêpnej wizycie?";
$lang['lost_password'] = "Zapomnia³em has³a";
$lang['random_image'] = "Losowe zdjêcie";
$lang['site_stats'] = "Zdjêæ {total_images} w¶ród {total_categories} kategorii.";
$lang['lang_loggedin_msg'] = "Jeste¶ zalogowany jako: {loggedin_user_name}";
$lang['go'] = "Id¼";
$lang['submit'] = "Wy¶lij";
$lang['reset'] = "Reset";
$lang['save'] = "Zapisz";
$lang['yes'] = "Tak";
$lang['no'] = "Nie";
$lang['images_per_page'] = "Zdjêæ na stronie:";
$lang['user_online'] = "Aktywnych u¿ytkowników: {num_total_online}";
$lang['user_online_detail'] = "W tej chwili aktywnych jest: zarejestrowanych u¿ytkowników {num_registered_online} (,i go¶ci {num_guests_online}.";
$lang['lostfield_error'] = "Proszê wype³niæ wszystkie pola!";
$lang['rate'] = "Oceñ";

//-----------------------------------------------------
//--- Paging ------------------------------------------
//-----------------------------------------------------
$lang['paging_stats'] = "Znaleziono zdjêæ: {total_cat_images} na {total_pages} stronie(ach). Wy¶wietlone zdjêcia: {first_page} do {last_page}.";
$lang['paging_next'] = "»";
$lang['paging_previous'] = "«";
$lang['paging_lastpage'] = "Ostatnia strona »";
$lang['paging_firstpage'] = "« Pierwsza strona";

//-----------------------------------------------------
//--- Search ------------------------------------------
//-----------------------------------------------------
$lang['search_no_results'] = "Nic nie znaleziono. ";
$lang['search_by_keyword'] = "Szukaj wg s³ów kluczowych: U¿yj operatorów logicznych I oraz LUB, aby znale¿æ wiêcej szczegó³ów. U¿yj gwiazdki (*) do zast±pienia zero lub wiêcej znaków.";
$lang['search_by_username'] = "Szukaj wg nazwy: U¿yj gwiazdki (*) do zast±pienia zero lub wiêcej znaków.";
$lang['search_terms'] = "Szukanie wyra¿eñ:";
$lang['search_fields'] = "Przeszukaj poni¿sze pola:";
$lang['new_images_only'] = "Pokazuj tylko nowe zdjêcia";
$lang['all_fields'] = "Wszystkie pola";
$lang['name_only'] = "Tylko nazwa zdjêcia";
$lang['description_only'] = "Tylko komentarz";
$lang['keywords_only'] = "Tylko s³owa kluczowe";
$lang['and'] = "I";
$lang['or'] = "LUB";

//-----------------------------------------------------
//--- New Images --------------------------------------
//-----------------------------------------------------
$lang['no_new_images'] = "W tej chwili nie ma nowych zdjêæ.";

//-----------------------------------------------------
//--- Admin Links -------------------------------------
//-----------------------------------------------------
$lang['edit'] = "[Edytuj]";
$lang['delete'] = "[Usuñ]";
//-----------------------------------------------------
//--- Puzzle Box -----------------------------------
//-----------------------------------------------------
$lang['puzzlebox_fadein_fadeout'] = "<a href='#' onclick='showTbl()'>Puzzlebox wlaczyc / wylaczyc</a> Viel Spass ;-)";
$lang['puzzle_parts'] = "Puzzle rozdzielnosc:";
$lang['puzzle_generate'] = "Puzzle generieren";
$lang['puzzle_error'] = "Fehler ... Keine Bilddatei";
$lang['puzzle_direction_code'] = "Left";
$lang['puzzle_finish'] = "Gratulacje ... Jestes Gotowy";

$lang['all_comments'] = "Wszystkie komentarze";
$lang['variable_text'] = "Auf den folgenden Seiten kannst du alle Bild-Kommentare nachlesen.";
$lang['navigation'] = "Seiten-Navigation :";
$lang['com_per_page'] = "Kommentare pro Seite :";
$lang['com'] = "Kommentar";
$lang['for_image'] = "zum Bild :";
$lang['in_cat'] = "In Kategorie :";
$lang['com_date'] = "gepostet am :";
$lang['com_by'] = "gepostet von :";

//-----------------------------------------------------
//--- Mitgliederliste ---------------------------------
//-----------------------------------------------------
$lang['lang_userlist_title'] = "Lista uzytkowników";
$lang['lang_userlist_page'] = "Seite ";
$lang['lang_total_user_images'] = "Bilder:";
$lang['lang_total_user_comments'] = "Kommentare:";
$lang['paging_user_stats'] = "Gefunden: {total_cat_images} Benutzer auf {total_pages} Seite(n). Angezeigt: Benutzer {first_page} bis {last_page}.";

$lang['lang_sort_homepage'] = "Homepage";
$lang['lang_sort_username'] = "Benutzername";
$lang['lang_sort_useremail'] = "Email";
$lang['lang_sort_comments'] = "Kommentare";
$lang['lang_sort_pictures'] = "Bilder";
$lang['lang_sort_joindate'] = "Registriert seit";
$lang['lang_sort_asc'] = "Aufsteigend";
$lang['lang_sort_desc'] = "Absteigen";
$lang['lang_select_sort_method'] = "Sortierungsmethode";
$lang['lang_select_sort_order'] = "Ordnung";

//-----------------------------------------------------
//--- Google-Map---------------------------------------
//-----------------------------------------------------
$lang['image_gmap_longitude'] = "Longitude of the place (-180...+180)";
$lang['image_gmap_latitude'] = "Latitude of the place (-90...+90)";
$lang['image_gmap_zoom'] = "Zoom-level (1-20)";
$lang['image_gmap_type'] = "Type of Google Map 1: Map 2:Satellite 3:Hybrid";
$lang['image_gmap_show'] = "Show Google Map?";
$lang['image_gmap_text1'] = "To Zdjecie";
$lang['image_gmap_text2'] = "zrobiono z tego miejsca.";
// <<<<<<<<<<<<<<<<<< [MOD] Google-Map <<<<<<<<<<<<<<<<<<
//-----------------------------------------------------
//--- Mod: Pin images ---------------------------------
//-----------------------------------------------------
$lang['pin_images_allow'] = "Znam na Zdjeciu: User können mein Bild pinnen.";
$lang['pin_allowed_mediatypes'] = "Möglich für Dateitypen: jpg, jpeg, gif, png";
$lang['pin_images_allow_yes'] = "Ja";
$lang['pin_images_allow_no'] = "Nein";
$lang['pin_submit'] = "Znam na Zdjeciu";
$lang['pin_color'] = "Pinezka :";
$lang['pin_headline'] = "Überschrift:";
$lang['pin_text'] = "Znam na Zdjeciu..... ";
$lang['pin_smilie'] = "Smilies:";
$lang['pin_error'] = "Bitte alles ausfüllen";
$lang['pin_post'] = "Znam na Zdjeciu:";
$lang['pin_from'] = "Gepinnt von:";
$lang['pin_info'] = "Aby Dodac Pinezkê klick na Zdjeciê.";
$lang['pin_info_access'] = "Sie müssen eingelogged sein,um dieses Bild pinnen zu können.";
$lang['pin_success'] = " Bild erfolgreich gepinnt!";
$lang['image_pin_allow'] = "Image pinnen erlauben";
$lang['archive'] = "Pietrowickie Archiwum zdjêciowe";
$lang['fullname'] = "Prawdziwe Imiê:";
$lang['guestbook'] = "Ksiêga Go¶ci";
$lang['site'] = "Your Homepage:";
$lang['post_guestbook'] = "Wpisz Ksiêgi Go¶ci";
$lang['sign_my_guestbook'] = "Please sign our GuestBook";
$lang['be_the_first'] = "Be the first to sign our GuestBook";
$lang['guest_site'] = "Homepage:";
$lang['guest_from'] = "From:";

$lang['user_wohnort'] = "Miejscowo¶æ:";
$lang['user_nname'] = "Nazwisko:";
$lang['user_vname'] = "Imie:";

$lang['curr_image_number'] = "Zdjecie";
$lang['all_image_number'] = "z";

$lang['gpportal'] = "Strona Glowna";
$lang['tagesbild'] = "Dzisiaj w Pietrowicach";

//-----------------------------------------------------
//--- Last active User ---------------------------------
//-----------------------------------------------------
$lang['lang_user_last_action'] = "Osatatni Aktywni";

$lang['lang_user_last_today'] = "Dzisiaj";
$lang['pin'] = "PINEZKA wy³±czyæ/ w³±czyæ ";
$lang['mitglied'] = "Nie masz jeszcze konta? Zarejestruj siê!";
//-----------------------------------------------------
//--- Photo of the month ------------------------------
//-----------------------------------------------------

$lang['potm_link'] = "Foto des Monats";
$lang['potm_title'] = "Foto des Monats Wahl";
$lang['potm'] = "fdm";
$lang['potm_vote'] = "Abstimmen";
$lang['potm_votes'] = "Stimmen:";
$lang['potm_lastwinners'] = "Die Gewinner der letzten Monate";
$lang['potm_vote_menu'] = "Zurück zur Wahl";
$lang['potm_winner'] = "Gewinner des Monats";
$lang['potm_top_title'] = "Führende Fotos";
$lang['potm_winners_title'] = "Gewinner der letzten Monate";
$lang['potm_no_permission'] = "Du hast diesen Monat schon deine Stimme abgegeben";
$lang['potm_locv'] = "Führende Fotos der aktuellen Wahl";
$lang['top_user'] = "Benutzer";
$lang['top_category'] = "Kategorie";
$lang['month_array'] = array("Januar", "Februar", "März", "April", "Mai", "Juni", "July", "August", "September", "Oktober", "November", "Dezember");

// --------- MOD TOP 100 ----------
$lang['lang_top100'] = "TOP 100";
$lang['lang_toplist_title_top100'] = " TOP 100";
$lang['lang_toplist_page'] = " Seite:";
$lang['no_top100'] = "Es sind noch keine Bilder mit dem Auswahlkriterium vorhanden";
$lang['top_100_picture'] = "Bild";
$lang['top_100_picture_name'] = "Name";
$lang['top_100_picture_id'] = "ID";
$lang['top_100_picture_cat'] = "Kat.";
$lang['top_100_picture_date'] = "Datum";
$lang['top_100_picture_hits'] = "Hits";
$lang['top_100_picture_votes'] = "Votes";
$lang['top_100_pos'] = "Pos.";
$lang['top_100_picture_rating'] = "Rating";
$lang['top_100_picture_last_view'] = "am";
$lang['top_100_picture_last_view_who'] = "von";
$lang['top_100_picture_last_view_date'] = "zuletzt gesehen am:";
$lang['top_100_picture_last_view_user'] = "zuletzt gesehen von:";
$lang['top_100_picture_downloads'] = "Downl.";
$lang['top_100_picture_comment'] = "Anm.";
$lang['top_100_url_votes'] = "Top100 Votes";
$lang['top_100_url_hits'] = "Top100 Treffer";
$lang['top_100_url_downloads'] = "Top100 Downloads";
$lang['top_100_url_comment'] = "Top100 Kommentare";
$lang['top_100_url_view'] = "zuletzt angesehen";
$lang['top_100_url_rating'] = "Top100 Bewertung";
// --------- MOD TOP 100 ----------

$lang['back_portal'] = "Wróæ do Portalu";
$lang['anmelden'] = "Zaloguj";
$lang['pictures'] = "Wszystkie zdjêcia";
$lang['pin_nk'] = "Kamieñ nagrobny ID:";

$lang['hat_das_Bild'] = " Dodal Zdjêcie ";
$lang['hinzugefügt'] = " do Albumu.";
$lang['am'] = " ";
$lang['lightbox_zuletzt'] = "Ostatnio do Albumu dodane Zdjêcia";
$lang['pin_grab'] = "Kamien nagrobowy ID: dobrowolnie";

//-----------------------------------------------------
//--- ImageCodes v1.0 Begins --------------------------
//-----------------------------------------------------
$lang['Thumbnail_for_websites'] = " Vorschaubild für Webseiten ";
$lang['Thumbnail_for_forums'] = " Vorschaubild für Forums";
$lang['Hotlink_for_websites'] = " Hotlink für Webseiten";
$lang['Hotlink_for_forums'] = " Hotlink für Forums";
$lang['Share_this_image'] = " Share this image";
$lang['Direct_path_to_image'] = " Direct path to image";

//########################## Start Mod Search all images since (Date) ##############################
$lang['search_by_date'] = "Wszystkie Zdjêcia od: (Format: {date_format} ) .";
//########################## End Mod Search all images since (Date) ################################

$lang['last_visit'] = "Nowe Zdjêcia od ostatnich odwiedzin:";
//[MOD] Facebook Like Button
$lang['fb_language'] = "pl_PL";
//END [MOD] Facebook Like Button
?>

14

Discussion & Troubleshooting / Re: Suchergebnissausgabe

« on: January 30, 2012, 10:08:07 PM »

nicht ganz , jetzt wird nach dem Geburtsdatum sortiert.

ich will aber das es nach dem $alter ( Lebensalter ) sortiert wird. Die ältesten Personen zuerst.

die berechnung funktioniert
$alter = ($datum_gestorben[2]) - ($datum_geboren[2]);
if (($datum_gestorben[1]) < ($datum_geboren[1]) || ($datum_gestorben[1] == ($datum_geboren[1]) && ($datum_gestorben[0]) < ($datum_geboren[0]))) {
$alter--;
}

15

Discussion & Troubleshooting / Re: Suchergebnissausgabe

« on: January 30, 2012, 09:10:04 PM »

Ja,

nur ich bin der meineung das ORDER BY STR_TO_DATE(image_gestorbenGP , '%d.%m.%Y') ASC LIMIT 15 "; gelöscht werden kann, denn es soll nicht nach gestorbenGP sortiert werden,
sondern nur nach Alter ($alter)

hier noch mal die alteste.php
<?php
/**************************************************************************
* *
* 4images - A Web Based Image Gallery Management System *
* ---------------------------------------------------------------- *
* *
* File: statistic.php *
* Copyright: (C) 2002-2009 Jan Sorgalla *
* Email: jan@4homepages.de *
* Web: http://www.4homepages.de *
* Scriptversion: 1.7.9 *
* File Version: 1.0.0 (by Rembrandt www.vienna-pictures.com) *
* 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. *
* *
*************************************************************************/

$main_template = 'statistic'; // <-- Your Template Title

define('GET_CACHES', 1);
define('ROOT_PATH', './');
define('MAIN_SCRIPT', __FILE__);
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
include(ROOT_PATH.'includes/page_header.php');
$txt_clickstream = $lang['statistic_page_title'];
$verstorbene = $lang['verstorbene'];
$geboren_stat = $lang['geboren_stat'];
$gestorben_stat = $lang['gestorben_stat'];
$geborene = $lang['geborene'];
$anklicken = $lang['anklicken']; // <-- Clickstream Name
$zginol= $lang['zginol'] ;
$gefallen= $lang['gefallen'] ;

//################## EXAMPLE CUSTOM PHP CODE STARTS HERE ############################
$imgtable_width = ceil((intval($config['image_table_width'])) / $config['image_cells']);
 if ((substr($config['image_table_width'], -1)) == "%") {
 $imgtable_width .= "%";
 }

 $additional_sql = "";
 if (!empty($additional_image_fields)) {
 foreach ($additional_image_fields as $key => $val) {
 $additional_sql .= ", i.".$key;
 }
 }

 $datum_heute = date("d.m.Y");
//,date_format( str_to_date( i.image_datum, '%m.%d.%Y' ) , '%m.%d.%Y' ) AS my_date
 $sql = "SELECT i.image_gestorbenGP, i.image_geboren, i.image_gefallenam, 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")."
 FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c)
 LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
 WHERE i.image_active = 1 AND image_gestorbenGP LIKE '%%.%%.%%%%' AND image_geboren LIKE '%%.%%.%%%%'
 $sql_where_query
 AND c.cat_id = i.cat_id $cat_id_sql

ORDER BY STR_TO_DATE(image_gestorbenGP , '%d.%m.%Y') ASC LIMIT 15 ";



 $result = $site_db->query($sql);


 $liste = "<table style=\"text-align:center;\" width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\">\n";


$liste .= "<tr><td class=\"title4\">Die 15 ältesten Peterwitzer.</td></tr>";



 $liste .= "</table>";

 $liste .= "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\">\n";

 $count = 0;
 $bgcounter = 0;
 $config['image_cells'] = 1;
 while ($image_row = $site_db->fetch_array($result)) {

 $ausgabe="";
 //array "$datum_gestorben" erstellen
 $datum_gestorben = explode(".",$image_row['image_gestorbenGP']);

$datum_geboren = explode(".",$image_row['image_geboren']);

$alter = ($datum_gestorben[2]) - ($datum_geboren[2]);
if (($datum_gestorben[1]) < ($datum_geboren[1]) || ($datum_gestorben[1] == ($datum_geboren[1]) && ($datum_gestorben[0]) < ($datum_geboren[0]))) {
 $alter--;
}

 if($alter)

{
$ausgabe = "Mit ".$alter." Jahren ist ".$image_row['image_name']." ".$gestorben_stat."";

}

 if(!empty($ausgabe)){
 if ($count == 0) {
 $row_bg_number = ($bgcounter++ % 2 == 0) ? 1 : 2;
 $liste .= "<tr class=\"imagerow".$row_bg_number."\">\n";
 }
 $liste .= "<td width=\"".$imgtable_width."\" valign=\"top\"><a href=\"./details.php?image_id=$image_row[image_id]\"onmouseover=\"Tip('".$anklicken." <CENTER><img src=\'./data/media/$image_row[cat_id]/$image_row[image_media_file]\' width=\'300\' ></CENTER> ')\" onmouseout=\"UnTip()\" >".$ausgabe."

</td>\n";
 //$liste .= "<td width=\"".$imgtable_width."\" valign=\"top\">".$image_row['image_datumr']."</td>\n";

 $liste .= "</tr>\n";
 $count++;
 if ($count == $config['image_cells']) {
 $liste .= "</tr>\n";
 $count = 0;
 }
 }
 }// end while
 $liste .= "</table>\n";








//----------------------------------------------------------------------


 $content = $liste;
 unset($liste);

//Here starts the lang register
$site_template->register_vars(array(
 "content" => $content, // <-- It is important that the same name used as in PHP Code above (in this example "my_php")
 "lang_statistic_page_title" => $lang['statistic_page_title'] // <-- Page Title
 // <-- the "example_text" must still be registered in the "lang/your language/main.php"
));

//################## EXAMPLE CUSTOM PHP CODE END HERE ################################

//-----------------------------------------------------
//--- Clickstream -------------------------------------
//-----------------------------------------------------
$clickstream = "<a href=\"".$site_sess->url(ROOT_PATH."index.php")."\" class=\"clickstream\">".$lang['home']."</a>".$config['category_separator'].$txt_clickstream."";

//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
 "content" => $content,
 "msg" => $msg,
 "clickstream" => $clickstream
));
$site_template->print_template($site_template->parse_template($main_template));
include(ROOT_PATH.'includes/page_footer.php');
?>

kannst nochmal bitte drüberschauen?

4images Forum & Community

News:

Messages - kubiczek

Mods & Plugins (Requests & Discussions) / Re: PIN MOD

Discussion & Troubleshooting / Re: Suchergebnissausgabe

Chit Chat / Re: KurtW MODs and Templates

Discussion & Troubleshooting / Re: Datumsberechnung

Mods & Plugins (Releases & Support) / Re: [MOD] Pfeile als Overlay auf Bild (arrows as overlay on picture)

Mods & Plugins (Releases & Support) / Re: [Mod] Captcha can mathematics

Discussion & Troubleshooting / Re: SPAM trotz CAPTCHA

Discussion & Troubleshooting / Re: SPAM trotz CAPTCHA

Discussion & Troubleshooting / Re: SPAM trotz CAPTCHA

Discussion & Troubleshooting / Re: SPAM trotz CAPTCHA

Discussion & Troubleshooting / Re: SPAM trotz CAPTCHA

Discussion & Troubleshooting / Re: SPAM trotz CAPTCHA

Discussion & Troubleshooting / Re: If i use polish letter "ó" in image comment - the comment is blank - help !

Discussion & Troubleshooting / Re: Suchergebnissausgabe

Discussion & Troubleshooting / Re: Suchergebnissausgabe