Author Topic: PIN MOD  (Read 5980 times)

0 Members and 1 Guest are viewing this topic.

Offline kubiczek

  • Full Member
  • ***
  • Posts: 212
    • View Profile
    • Gross Peterwitz
PIN MOD
« on: July 24, 2009, 09:42:45 AM »
Hallo,

brauche hilfe beim PIN MOD von KurtW

um die Pin's   "ein" und "aus"zuschalten habe ich damals folgendes im forum gelesen

in der templates details.htm  
Quote
<p align="center" >&nbsp;<a href="#" onClick="einblenden('click_container'); return false;"><b>Pin Ein-/Ausblenden</b></a></p><br />

einbauen

leider funktioniert das nicht alleine, es muss noch was in die PIN Datei eingabaut werden. Leider weis ich nicht mehr was.

Kann mir jemand helfen?


Offline nobby

  • 4images Guru
  • *******
  • Posts: 2.851
    • View Profile
Re: PIN MOD
« Reply #1 on: July 24, 2009, 09:51:49 AM »
Hallo,

das ist nicht Einfach weil Kurtw alle seine Threads löschen lassen hat  :|

nobby

Offline kubiczek

  • Full Member
  • ***
  • Posts: 212
    • View Profile
    • Gross Peterwitz
Re: PIN MOD
« Reply #2 on: July 24, 2009, 12:27:06 PM »
habe den 2 schnipsel gefunden.

in der templates  datei   details.htm muss noch eine 2 Code passage eingefügt werden
Quote
 <script language="JavaScript" type="text/javascript">
                    <!--
                    function einblenden(div) {
                    with(document.getElementById(div).style){
                    if(display=="none"){
                    display="inline";
                    }
                    else{
                    display="none";
                    }
                    }
                    }
                    //-->
                   </script>

sehe http://grosspeterwitz.org/4images_neu/details.php?image_id=302

links kann man die PIN ausschalten

Offline kubiczek

  • Full Member
  • ***
  • Posts: 212
    • View Profile
    • Gross Peterwitz
Re: PIN MOD
« Reply #3 on: August 25, 2010, 10:32:49 PM »
Hallo,

wie kann ich die anzeige "Grabstein" unterdrücken wenn in der Datenbank das feld "pin_headline" leer ist?

in der pin_headline wir die Grabbild ID gespeichert fals die Person bereits verstorben ist und ein Grabbild existiert.

hier der auszug aus der details.php

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=[<a href=http://www.grosspeterwitz.org/friedhof/4images/details.php?image_id=".$pin_headline.">Grabstein Bild</a>] body=[".$pin_text."<p><small>".$lang['pin_from']."<br />".$pin_user_name."</u></a><br />(".$pin_date.")".$admin_pin_links."</small></p>] fade=[on] fadespeed=[0.06] requireclick=[off] singleclickstop=[on] doubleclickstop=[off]\"></a>\n";
 }

sonst kommt es zu verwirrungen
sehe beispiel http://www.grosspeterwitz.org/4images_neu/details.php?image_id=288&l=deutsch

in html templates habe ich mit {if ...} absdef {endif}  ausgeblendet  aber in details.php komme ich damit nicht weiter.

 kann mir jemand helfen?

gelöst

habe am anfang   if(!empty($pin_grab)) {   statt        if ($pin_user_id != -1)   gesetzt.



jetzt funzt es , mit meinen PHP kenntnissen hat es 14 Stunden gedauert,  ausdauer zahlt sich aus
« Last Edit: August 26, 2010, 10:14:11 PM by kubiczek »

Offline kubiczek

  • Full Member
  • ***
  • Posts: 212
    • View Profile
    • Gross Peterwitz
Re: PIN MOD
« Reply #4 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.

Warningmysql_query(): Access denied for user ''@'localhost' (using passwordNOin /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 resourceboolean 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']) ? 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$mode01);

//--- 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('"'"&quot;"$meta_description),
            
"detail_meta_keywords"      => str_replace('"'"&quot;"$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 !== "AND cat_id IN ($cat_id_sql)" "";
  }
  else {
    
$cat_id_sql get_auth_cat_sql("auth_viewcat""NOTIN");
    
$cat_id_sql $cat_id_sql !== "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)) ? "&amp;mode=".$mode ""));
  if (!
get_file_path($next_prev_cache[$next_image_id]['image_media_file'], "media"$next_prev_cache[$next_image_id]['cat_id'], 00)) {
    
$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'], 01);
  }
  if (!
get_file_path($next_prev_cache[$next_image_id]['image_thumb_file'], "thumb"$next_prev_cache[$next_image_id]['cat_id'], 00)) {
    
$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'], 01);
  }
}
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)) ? "&amp;mode=".$mode ""));
  if (!
get_file_path($next_prev_cache[$prev_image_id]['image_media_file'], "media"$next_prev_cache[$prev_image_id]['cat_id'], 00)) {
    
$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'], 01);
  }
  if (!
get_file_path($next_prev_cache[$prev_image_id]['image_thumb_file'], "thumb"$next_prev_cache[$prev_image_id]['cat_id'], 00)) {
    
$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'], 01);
  }
}
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'] == || !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 != "") ? "<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 (
$captcha_enable_comments && !captcha_validate($captcha)) {
      
$msg .= (($msg != "") ? "<br />" "").$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 !== "" "<br />" "").$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&amp;".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++ % == 0) ? 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&amp;".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&amp;".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 href=\"".$site_sess->url(ROOT_PATH."admin/index.php?goto=".urlencode("comments.php?action=editcomment&amp;comment_id=".$comment_row[$i]['comment_id']))."\" target=\"_blank\">".$lang['edit']."</a>&nbsp;";
        
$admin_links .= "<a href=\"".$site_sess->url(ROOT_PATH."admin/index.php?goto=".urlencode("comments.php?action=removecomment&amp;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&amp;".URL_COMMENT_ID."=".$comment_row[$i]['comment_id'])."\">".$lang['edit']."</a>&nbsp;";
        
$admin_links .= ($config['user_delete_comments'] != 1) ? "" "<a href=\"".$site_sess->url(ROOT_PATH."member.php?action=removecomment&amp;".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'], 00),
        
"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'] == && $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&amp;image_id=".$image_id))."\" target=\"_blank\">".$lang['edit']."</a>&nbsp;";
  
$admin_links .= "<a href=\"".$site_sess->url(ROOT_PATH."admin/index.php?goto=".urlencode("images.php?action=removeimage&amp;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&amp;".URL_IMAGE_ID."=".$image_id)."\">".$lang['edit']."</a>&nbsp;";
  
$admin_links .= ($config['user_delete_image'] != 1) ? "" "<a href=\"".$site_sess->url(ROOT_PATH."member.php?action=removeimage&amp;".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 "<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_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 "&amp;".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_id1).$config['category_separator'];
}
$clickstream .= $image_name."</span>";
//-----------------------------------------------------
//--- 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'] == && $config['pin_image_captcha'] == 0) {
$pin_window_height '245';
}
elseif (
$config['pin_image_smilie'] == && $config['pin_image_captcha'] == 0) {
$pin_window_height '285';
}
elseif (
$config['pin_image_smilie'] == && $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>&nbsp;";
  
$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_text17"\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."<p><small>".$lang['pin_from']."<br /><a href='member.php?action=showprofile&user_id=".$pin_user_id."'><u>".$pin_user_name."</u></a><br />(".$pin_date.")".$admin_pin_links."</small></p>] 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."<p><small>".$lang['pin_from']."<br />".$pin_user_name."<br />(".$pin_date.")".$admin_pin_links."</small></p>] 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

 

Post your comments here