1
Installation, Update & Configuration / Re: Problem nach Upgrade auf 1.7.7
« on: January 20, 2010, 08:42:40 PM »schick die daten per PN + 4images url und zugang
Ich habe dir die Daten per PN geschickt und hoffe, dass du mir helfen kannst.
4images code on GitHub Click here to visit GitHub.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
schick die daten per PN + 4images url und zugang
An unexpected error occured. Please try again later.
Bad SQL Query: SELECT cat_id, cat_name, cat_description, cat_parent_id, cat_hits, cat_order, auth_viewcat, auth_viewimage, auth_download, auth_upload, auth_directupload, auth_vote, auth_sendpostcard, auth_readcomment, auth_postcomment
FROM 4images_categories
ORDER BY c.cat_name ASC
Unknown column 'c.cat_name' in 'order clause'
Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/digitcom/includes/db_mysql.php:192) in /www/htdocs/digitcom/includes/sessions.php on line 101
Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/digitcom/includes/db_mysql.php:192) in /www/htdocs/digitcom/includes/sessions.php on line 101
Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/digitcom/includes/db_mysql.php:192) in /www/htdocs/digitcom/includes/sessions.php on line 101
An unexpected error occured. Please try again later.
Bad SQL Query: SELECT cat_id, cat_name, cat_description, cat_parent_id, cat_hits, cat_order, auth_viewcat, auth_viewimage, auth_download, auth_upload, auth_directupload, auth_vote, auth_sendpostcard, auth_readcomment, auth_postcomment
FROM 4images_categories
ORDER BY c.cat_name ASC Unknown column 'c.cat_name' in 'order clause'
Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/digitcom/includes/db_mysql.php:192) in /www/htdocs/digitcom/includes/sessions.php on line 101
Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/digitcom/includes/db_mysql.php:192) in /www/htdocs/digitcom/includes/sessions.php on line 101
Warning: fopen(slideshow_1.xml) [function.fopen]: failed to open stream: Permission denied in /categories.php on line 220
<?php
/**************************************************************************
* *
* 4images - A Web Based Image Gallery Management System *
* ---------------------------------------------------------------- *
* *
* File: categories.php *
* Copyright: (C) 2002 Jan Sorgalla *
* Email: jan@4homepages.de *
* Web: http://www.4homepages.de *
* Scriptversion: 1.7.4 *
* *
* 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. *
* *
*************************************************************************/
$templates_used = 'categories,category_bit,thumbnail_bit';
$main_template = 'categories';
define('GET_CACHES', 1);
define('ROOT_PATH', './');
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
$user_access = get_permission();
include(ROOT_PATH.'includes/page_header.php');
if (!$cat_id || !isset($cat_cache[$cat_id]) || !check_permission("auth_viewcat", $cat_id)) {
redirect("index.php");
}
$cache_id = create_cache_id(
'page.categories',
array(
$user_info[$user_table_fields['user_id']],
$cat_id,
$page,
$perpage,
isset($user_info['lightbox_image_ids']) ? substr(md5($user_info['lightbox_image_ids']), 0, 8) : 0,
$config['template_dir'],
$config['language_dir']
)
);
if (!$cache_page_categories || !$content = get_cache_file($cache_id)) {
// Always append session id if cache is enabled
if ($cache_page_categories) {
$old_session_mode = $site_sess->mode;
$site_sess->mode = 'get';
}
ob_start();
//-----------------------------------------------------
//--- Show Categories ---------------------------------
//-----------------------------------------------------
if (!check_permission("auth_upload", $cat_id)) {
$upload_url = "";
$upload_button = "<img src=\"".get_gallery_image("upload_off.gif")."\" border=\"0\" alt=\"\" />";
}
else {
$upload_url = $site_sess->url(ROOT_PATH."member.php?action=uploadform&".URL_CAT_ID."=".$cat_id);
$upload_button = "<a href=\"".$upload_url."\"><img src=\"".get_gallery_image("upload.gif")."\" border=\"0\" alt=\"\" /></a>";
}
$random_cat_image = (defined("SHOW_RANDOM_IMAGE") && SHOW_RANDOM_IMAGE == 0) ? "" : get_random_image($cat_id);
$site_template->register_vars(array(
"categories" => get_categories($cat_id),
"cat_name" => format_text($cat_cache[$cat_id]['cat_name'], 2),
"cat_description" => format_text($cat_cache[$cat_id]['cat_description'], 1, 0, 1),
"cat_hits" => $cat_cache[$cat_id]['cat_hits'],
"upload_url" => $upload_url,
"upload_button" => $upload_button,
"random_cat_image" => $random_cat_image
));
unset($random_cat_image);
//-----------------------------------------------------
//--- Show Images -------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
"has_rss" => true,
"rss_title" => "RSS Feed: ".format_text($cat_cache[$cat_id]['cat_name'], 2)." (".str_replace(':', '', $lang['new_images']).")",
"rss_url" => $script_url."/rss.php?action=images&".URL_CAT_ID."=".$cat_id
));
$num_rows_all = (isset($cat_cache[$cat_id]['num_images'])) ? $cat_cache[$cat_id]['num_images'] : 0;
$link_arg = $site_sess->url(ROOT_PATH."categories.php?".URL_CAT_ID."=".$cat_id);
include(ROOT_PATH.'includes/paging.php');
$getpaging = new Paging($page, $perpage, $num_rows_all, $link_arg);
$offset = $getpaging->get_offset();
$site_template->register_vars(array(
"paging" => $getpaging->get_paging(),
"paging_stats" => $getpaging->get_paging_stats()
));
$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;
}
}
$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")."
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 i.cat_id = $cat_id AND c.cat_id = i.cat_id
ORDER BY ".$config['image_order']." ".$config['image_sort'].", image_id ".$config['image_sort']."
LIMIT $offset, $perpage";
$result = $site_db->query($sql);
$num_rows = $site_db->get_numrows($result);
if (!$num_rows) {
$thumbnails = "";
$msg = $lang['no_images'];
}
else {
$thumbnails = "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\">\n";
$count = 0;
$bgcounter = 0;
//-----------------------------------------------------
//--- flash Show changes 01 starts here ---------
//-----------------------------------------------------
//-----------------------------------------------------
// Configrable variables ------------------------------
$max_height = "1024"; // any images with a greater height will not be included in slide show
$max_width = "1024"; // any images with a greater width will not be included in slide show
//-----------------------------------------------------
$xmlfile_user = "slideshow_".$user_info['user_id'].".xml"; // [UPDATED] mod for unique xml slideshow file by user : don't change this value : .SWF need it
foreach (glob('slideshow_*') as $filename) {
// $Diff = (time() - filemtime($filename))/60/60/24; // Difference in days
$Diff = (time() - filemtime($filename))/60/60; // Difference in hours
// $Diff = (time() - filemtime($filename))/60; // Difference in minutes
if ($Diff > 1) unlink($filename); // xx days/hours/minutes after generation, the .xml file is deleted
}
$xmlcontent ="";
$imagePath = MEDIA_PATH."/".$cat_id."/";
$countit = 0;
if (file_exists($xmlfile_user) === TRUE) {
unlink($xmlfile_user);
}
$xmlcontent.="<slideshow>\r\n <settings>\r\n <image_folder>".$imagePath."</image_folder>\r\n <time>3</time>\r\n <fade>2</fade>\r\n <pause>false</pause>\r\n <playReverse>false</playReverse>\r\n <repeat>true</repeat>\r\n <captions>true</captions>\r\n </settings>\r\n <images>\r\n\r\n";
//-----------------------------------------------------
//--- flash Show changes 01 ends here ---------
//-----------------------------------------------------
while ($image_row = $site_db->fetch_array($result)){
if ($count == 0) {
$row_bg_number = ($bgcounter++ % 2 == 0) ? 1 : 2;
$thumbnails .= "<tr class=\"imagerow".$row_bg_number."\">\n";
}
$thumbnails .= "<td width=\"".$imgtable_width."\" valign=\"top\">\n";
show_image($image_row);
$thumbnails .= $site_template->parse_template("thumbnail_bit");
$thumbnails .= "\n</td>\n";
$count++;
if ($count == $config['image_cells']) {
$thumbnails .= "</tr>\n";
$count = 0;
}
//-----------------------------------------------------
//--- flash Show changes 02 starts here ---------
//-----------------------------------------------------
if (!is_remote($image_row['image_media_file'])) {
$image_info = @getimagesize(($imagePath."/".$image_row['image_media_file']));
$width = $image_info[0];
$height = $image_info[1];
} // end if
$flashshow_id = MEDIA_PATH."/".$image_row['cat_id']."/";
if ($width >= $max_width) continue;
if ($height >= $max_height) continue;
if (stristr($image_row['image_media_file'],".jpg") || stristr($image_row['image_media_file'],".jpeg") || stristr($image_row['image_media_file'],".bmp") || stristr($image_row['image_media_file'],".gif")){
$countit = $countit + 1;
$xmlcontent.=" <image>\r\n <file>".$image_row['image_media_file']."</file>\r\n <caption>\r\n <![CDATA[".$image_row['image_name']."]]>\r\n </caption>\r\n </image>\r\n\r\n";
} // end if
//-----------------------------------------------------
//--- flash Show changes 02 ends here ---------
//-----------------------------------------------------
} // end while
if ($count > 0) {
$leftover = ($config['image_cells'] - $count);
if ($leftover > 0) {
for ($i = 0; $i < $leftover; $i++){
$thumbnails .= "<td width=\"".$imgtable_width."\">\n \n</td>\n";
}
$thumbnails .= "</tr>\n";
}
}
$thumbnails .= "</table>\n";
//-----------------------------------------------------
//--- flash Show changes 03 starts here ---------
//-----------------------------------------------------
$xmlcontent.=" </images>\r\n</slideshow>\r\n";
if (!$handle = fopen($xmlfile_user, 'a')) {
$msg .= "Impossible to read (<b>$xmlfile_user</b>)";
exit;
}
if (fwrite($handle, $xmlcontent) === FALSE) {
$msg .= "Impossible to write (<b>$xmlfile_user</b>)";
exit;
}
//-----------------------------------------------------
//--- flash Show changes 03 starts here ---------
//-----------------------------------------------------
} //end else
//-----------------------------------------------------
//--- flash Show changes 04 starts here ---------
//-----------------------------------------------------
if ($countit > 1) {
$flashshow_url = $site_sess->url(ROOT_PATH."flashshow.php?action=flashshow&".URL_CAT_ID."=".$cat_id);
$flashshow_button = "<A HREF=\"#\" onClick=\"window.open('".$flashshow_url."','_blank','toolbar=0, location=0, directories=0, status=0, scrollbars=0, resizable=0, copyhistory=0, menuBar=0, width=640, height=480');return(false)\"><img src=\"".get_gallery_image("flashshow.gif")."\" border=\"0\" alt=\"".$lang['alt_flashshow']."\" /></a>";
} else {
$flashshow_button = " <img src=\"".get_gallery_image("flashshow_off.gif")."\" border=\"0\" alt=\"Sorry, but you cannot make a flashshow with only 1 picture!!!\" />";
}
$num_rows_all = (isset($cat_cache[$cat_id]['num_images'])) ? $cat_cache[$cat_id]['num_images'] : 0;
if ($num_rows_all > 0) {
$random_cat_image = (defined("SHOW_RANDOM_IMAGE") && SHOW_RANDOM_IMAGE == 0) ? "" : get_random_image($cat_id);
$site_template->register_vars(array(
"flashshow_url" => $flashshow_url,
"cat_name" => htmlspecialchars($cat_cache[$cat_id]['cat_name']),
"flashshow_button" => $flashshow_button
));
}
//-----------------------------------------------------
//--- flash Show changes 04 ends here ---------
//-----------------------------------------------------
$site_template->register_vars("thumbnails", $thumbnails);
unset($thumbnails);
//################################ Start MOD Ajax Slideshow/Diashow ##############################
$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")."
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 i.cat_id = $cat_id AND c.cat_id = i.cat_id
ORDER BY ".$config['image_order']." ".$config['image_sort'].", image_id ".$config['image_sort']."
LIMIT $offset, ".$config['ajax_slideshowviewer_how_many']."";
$result = $site_db->query($sql);
$num_rows = $site_db->get_numrows($result);
$max_length_image_name = 65;
$max_length_image_description = 55;
$ajax_slideshow_view = 0;
if (!$num_rows) {
$site_template->register_vars(array(
"ajax_slideshow" => "",
"ajax_slideshow_button" => "",
));
}
else {
$ajax_slideshow = "<script type=\"text/javascript\" src=\"http://slideshow.triptracker.net/slide.js\"></script>\n";
$ajax_slideshow .= "<script type=\"text/javascript\">\n<!-- \n";
$ajax_slideshow .= "var viewer = new PhotoViewer();\n";
$ajax_slideshow .= "viewer.setSlideDuration(".$config['ajax_slideshowviewer_setSlideDuration'].");\n";
$ajax_slideshow .= "viewer.".$config['ajax_slideshowviewer_Panning']."Panning();\n";
$ajax_slideshow .= "viewer.".$config['ajax_slideshowviewer_AutoPlay']."AutoPlay();\n";
$ajax_slideshow .= "viewer.".$config['ajax_slideshowviewer_Fading']."Fading();\n";
$ajax_slideshow .= "viewer.setBackgroundColor('".$config['ajax_slideshowviewer_setBackgroundColor']."');\n";
$ajax_slideshow .= "viewer.setBorderWidth(".$config['ajax_slideshowviewer_setBorderWidth'].");\n";
$ajax_slideshow .= "viewer.setFontSize(".$config['ajax_slideshowviewer_setFontSize'].");\n";
$ajax_slideshow .= "viewer.".$config['ajax_slideshowviewer_Shade']."Shade();\n";
$ajax_slideshow .= "viewer.setShadeColor('".$config['ajax_slideshowviewer_setShadeColor']."');\n";
$ajax_slideshow .= "viewer.setShadeOpacity('".$config['ajax_slideshowviewer_setShadeOpacity']."');\n";
$ajax_slideshow .= "viewer.".$config['ajax_slideshowviewer_Loop']."Loop();\n";
$ajax_slideshow .= "viewer.setOnClickEvent(".$config['ajax_slideshowviewer_OnClickEvent'].");\n";
if ($config['ajax_slideshowviewer_Toolbar'] == "disable") {
$ajax_slideshow .= "viewer.disableToolbar();\n"; }
if ($config['ajax_slideshowviewer_EmailLink'] == "disable") {
$ajax_slideshow .= "viewer.disableEmailLink();\n"; }
if ($config['ajax_slideshowviewer_PhotoLink'] == "disable") {
$ajax_slideshow .= "viewer.disablePhotoLink();\n"; }
$count = 0;
$bgcounter = 0;
while ($image_row = $site_db->fetch_array($result)) {
$ext = get_file_extension($image_row['image_media_file']);
$config['ajax_slideshowviewer_Types_array'] = explode(",", $config['ajax_slideshowviewer_Types']);
if (in_array($ext, $config['ajax_slideshowviewer_Types_array'])) {
$ajax_slideshow_view = 1;
show_image($image_row);
$image_name_short = (isset($image_row['image_name']) && strlen($image_row['image_name']) > $max_length_image_name) ? substr(format_text(stripslashes($image_row['image_name']), 2), 0, $max_length_image_name)."..." : format_text(stripslashes($image_row['image_name']), 2);
$image_name_short = str_replace("\r","",$image_name_short);
$image_name_short = str_replace("\n","",$image_name_short);
$image_name_short = str_replace("<br>","",$image_name_short);
$image_name_short = str_replace("<br />","",$image_name_short);
$image_name_short = str_replace("'","",$image_name_short);
$image_name_short = str_replace("<","<",$image_name_short);
$image_name_short = str_replace(">",">",$image_name_short);
$image_name_short = stripslashes($image_name_short);
$image_name_short = "".$lang['image_name']." $image_name_short";
if ($config['ajax_slideshowviewer_description'] == "enable") {
$image_description_short = (isset($image_row['image_description']) && strlen($image_row['image_description']) > $max_length_image_description) ? substr(format_text(stripslashes($image_row['image_description']), 1, 0, 1), 0, $max_length_image_description)."..." : format_text(stripslashes($image_row['image_description']), 1, 0, 1);
$image_description_short = str_replace("\r","",$image_description_short);
$image_description_short = str_replace("\n","",$image_description_short);
$image_description_short = str_replace("<br>","",$image_description_short);
$image_description_short = str_replace("<br />","",$image_description_short);
$image_description_short = str_replace("'","",$image_description_short);
$image_description_short = str_replace("<","<",$image_description_short);
$image_description_short = str_replace(">",">",$image_description_short);
$image_description_short = stripslashes($image_description_short);
if ($image_description_short == "") {
$image_description_short = " ";
} else {
$image_description_short = "<br>".$lang['description']." $image_description_short";
}
}
else {
$image_description_short = " ";
}
$ajax_slideshow .= "viewer.add('".MEDIA_DIR."/".$image_row['cat_id']."/".$image_row['image_media_file']."', '".$image_description_short."', '".$image_name_short."');\n";
}
}
if ($count > 0) {
$leftover = ($config['image_cells'] - $count);
}
$ajax_slideshow .= "//-->\n</script>\n";
if ($user_info['user_level'] == GUEST && $config['ajax_slideshowviewer_Show'] == "1" && $ajax_slideshow_view == "1") {
$ajax_slideshow_button = "<img src=\"".get_gallery_image("diashow_off.gif")."\" border=\"0\" alt=\"\" />";
$site_template->register_vars(array(
"ajax_slideshow_button" => $ajax_slideshow_button
));
}
elseif ($user_info['user_level'] != GUEST && $config['ajax_slideshowviewer_Show'] == "1" && $ajax_slideshow_view == "1" || $config['ajax_slideshowviewer_Show'] == "2" && $ajax_slideshow_view == "1") {
$ajax_slideshow_button = "<a href=\"javascript:void(viewer.show(0))\"><img src=\"".get_gallery_image("diashow.gif")."\" border=\"0\" alt=\"\" /></a>";
$site_template->register_vars(array(
"ajax_slideshow" => $ajax_slideshow,
"ajax_slideshow_button" => $ajax_slideshow_button
));
}
else {
$site_template->register_vars(array(
"ajax_slideshow" => "",
"ajax_slideshow_button" => "",
));
}
}
unset($ajax_slideshow);
//################################ End MOD Ajax Slideshow/Diashow ##############################
//-----------------------------------------------------
//--- Clickstream -------------------------------------
//-----------------------------------------------------
$clickstream = "<span class=\"clickstream\"><a href=\"".$site_sess->url(ROOT_PATH."index.php")."\" class=\"clickstream\">".$lang['home']."</a>".$config['category_separator'].get_category_path($cat_id)."</span>";
//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
"msg" => $msg,
"clickstream" => $clickstream
));
$site_template->print_template($site_template->parse_template($main_template));
$content = ob_get_contents();
ob_end_clean();
if ($cache_page_categories) {
// Reset session mode
$site_sess->mode = $old_session_mode;
save_cache_file($cache_id, $content);
}
} // end if get_cache_file()
echo $content;
//Update Category Hits
if ($user_info['user_level'] != ADMIN && $page == 1) {
$sql = "UPDATE ".CATEGORIES_TABLE."
SET cat_hits = cat_hits + 1
WHERE cat_id = $cat_id";
$site_db->query($sql);
}
include(ROOT_PATH.'includes/page_footer.php');
?>