RN 2.4 and Coppermine

Posted: Tue Sep 15, 2009 3:58 pm

Hi RN team,

Congratulations on RN 2.4! Looks great so far.
My upgrade went really well except one thing. It seams my coppermine gallery does not work properly anymore Crying or Very sad

Everything seams as normal. I can even upload pics and everything except when I click on any thumbnail to display picture it now gives me a:

The selected album/picture does not exist !

I was surprised about this and not expecting it, any ideas???

jc

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

No ideas. Are you using ShortURLs? What version of coppermine?

Posted: Tue Sep 15, 2009 4:20 pm

Coppermine for Php-Nuke v1.3.1d

I have tested both with and with out shortlinks and I get the same error.
I have tested two different installs with same result.

jc

Posted: Tue Sep 15, 2009 4:28 pm

NeapolitanWorld wrote:

Coppermine for Php-Nuke v1.3.1d

I have tested both with and with out shortlinks and I get the same error.
I have tested two different installs with same result.

jc

the urls are the same from a good install or mine with mine giving me an error when clicking last album photo/ thumbnail:

/modules.php?name=coppermine&file=displayimage&meta=lastalb&cat=0&pos=0

Posted: Tue Sep 15, 2009 4:39 pm

I have never used this so I may have no idea what I am talking about. In the past where there not changes that needed to be made to header.php for this to work? I may be confused with another gallery.

Posted: Tue Sep 15, 2009 4:43 pm

Hi Palbin, no coppermine works pretty much out of the box with RN. I have installed several and tested with previous versions and all do well with RN. Unfortunately I did not click an image on my test site so I upgraded my live site as well both ending with the same problem.

jc

Posted: Tue Sep 15, 2009 4:55 pm

Sounds like one of the arguments is getting messed up. Does that same link work on other sites?

Posted: Tue Sep 15, 2009 5:02 pm

Can you point me to a download for your version of coopermine?

Posted: Tue Sep 15, 2009 5:03 pm

kguske, Yes it does. If you try this link on a coppermine site that works:

/modules.php?name=coppermine&file=displayimage&meta=lastalb&cat=0&pos=0

it will display the image correctly.

Take a look at these two sites:

http://www.fantasyana.com/modules.php?name=coppermine

This is my test site which I just upgraded to coppermine 1.3.2 to see if it fixed but similar issue:

http://www.mastindelabahia.com/test/modules.php?name=coppermine

Posted: Tue Sep 15, 2009 5:08 pm

Palbin, This thread has the links for downloads I believe.

http://www.ravenphpscripts.com/posts16827-start-0.html

Posted: Tue Sep 15, 2009 5:57 pm

Maybe somewhere in the modules/coppermine/displayimage.php file? any guru's see anything that sticks out?

Code:

<?php





/************************************************************************/


/*    Pc-Nuke! Systems -  Advanced Content Management System            */


/************************************************************************/


/*    Created by Pc-Nuke! Systems -- Released: 2008                     */


/*    http://www.pcnuke.com                                            */


/*    All Rights Reserved || 2003-2008 || by Pc-Nuke!                   */


/************************************************************************/


/*         The Power of the Nuke - Without the Radiation!               */


/************************************************************************/


/************************************************************************/


/* - Copyright Notice (read and understand the GNU_GPL)                 */


/* - THIS PACKAGE IS RELEASED AS GPL/GNU SCRIPTING.                     */


/* - http://www.pcnuke.com/modules.php?name=GNU_GPL                     */


/************************************************************************/


/* This program is free software. You can redistribute it and/or modify */


/* it under the terms of the GNU General Public License as published by */


/* the Free Software Foundation; either version 2 of the License.       */


/************************************************************************/


// Coppermine Photo Gallery 1.3.1D for CMS     2008.02.01               //


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


// Copyright (C) 2002,2003  GrAcgory DEMAR <gdemar@wanadoo.fr>          //


// http://www.chezgreg.net/coppermine/                                  //


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


// Updated by the Coppermine Dev Team                                   //


// (http://coppermine.sf.net/team/)                                     //


// see /docs/credits.html for details                                   //


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


// New Port by GoldenTroll                                              //


// http://coppermine.findhere.org/                                      //


// Based on coppermine 1.1d by Surf  http://www.surf4all.net/           //


/************************************************************************/


/**********************************/


/*  Module Configuration          */


/* (right side on) v3.1           */


/* Remove the following line      */


/* will remove the right side     */


/**********************************/


define('INDEX_FILE', true);


$index = 1; 





if (eregi("modules/", $_SERVER['PHP_SELF'])) {


    die ("You can't access this file directly...");


}





define('NO_EDITOR', 1);





define('DISPLAYIMAGE_PHP', true);


require("modules/" . $name . "/include/load.inc");





if ($CONFIG['enable_smilies']) require("includes/nbbcode.php");


//if ($CONFIG['enable_smilies']) include($CPG_M_DIR . "/include/smilies.inc.php");


$breadcrumb_text = '';


$cat_data = array();


if ($CONFIG['read_exif_data'] && function_exists('exif_read_data')) {


    include($CPG_M_DIR . "/include/exif_php.inc");


} elseif ($CONFIG['read_exif_data']) {


    cpg_die(CRITICAL_ERROR, 'PHP running on your server does not support reading EXIF data in JPEG files, please turn this off on the config page', __FILE__, __LINE__);


}


if ($CONFIG['read_iptc_data']) {


    include($CPG_M_DIR . "/include/iptc.inc");


}





// Local functions definition  //


// Altered security issue by Pc-Nuke! 12.23.05 -- start //


function html_picture_menu($id)


{


    global $lang_display_image_php, $user, $user, $cookie, $prefix, $user_prefix, $db;


    


    if (USER_ID or $CONFIG['allow_anon_fullsize'] or USER_IS_ADMIN){


    return '<div align="center"><a href="'.getlink("&amp;file=editOnePic&amp;id=$id&amp;what=picture").'"><font color=\"#000000\">Edit Picture</font></a> || 


<a href="'.getlink("&amp;file=delete&amp;id=$id&amp;what=picture").'&ampclass="admin_menu" onclick="return confirm(\''.$lang_display_image_php['confirm_del'].'\');"><font color=\"#000000\">Delete Picture</font></a></div>';


}





}


// Altered security issue by Pc-Nuke! 12.23.05 -- end //














// Prints the image-navigation menu


function html_img_nav_menu()


{


    global $CONFIG, $HTTP_SERVER_VARS,  $CURRENT_PIC_DATA;


    global $meta, $album, $cat, $pos, $pic_count, $lang_img_nav_bar, $template_img_navbar, $lang_errors;


    $cat_link = is_numeric($album) ? '&amp;album='.$album : '&amp;cat=' . $cat;


    $meta_link = ($meta == '') ? '' : '&amp;meta=' . $meta;


    $human_pos = $pos + 1;


    $page = ceil(($pos + 1) / ($CONFIG['thumbrows'] * $CONFIG['thumbcols']));


    $pid = $CURRENT_PIC_DATA['pid'];


    if ($pos > 0) {


        $prev = $pos - 1;


        $prev_tgt = getlink("&amp;file=displayimage$meta_link$cat_link&amp;pos=$prev");


        $prev_title = $lang_img_nav_bar['prev_title'];


    } else {


        $prev_tgt = "javascript:alert('" . addslashes($lang_img_nav_bar['no_less_images']) . "');";


        $prev_title = $lang_img_nav_bar['no_less_images'];


    }


    if ($pos < ($pic_count -1)) {


        $next = $pos + 1;


        $next_tgt = getlink("&amp;file=displayimage$meta_link$cat_link&amp;pos=$next");


        $next_title = $lang_img_nav_bar['next_title'];


    } else {


        $next_tgt = "javascript:alert('" . addslashes($lang_img_nav_bar['no_more_images']) . "');";


        $next_title = $lang_img_nav_bar['no_more_images'];


    }


    if ((USER_CAN_SEND_ECARDS) && (USER_ID or $CONFIG['allow_anon_fullsize'] or USER_IS_ADMIN)) {


        $ecard_tgt = getlink("&amp;file=ecard$meta_link$cat_link&amp;pid=$pid&amp;pos=$pos");


        $ecard_title = $lang_img_nav_bar['ecard_title'];


    } else {


        $ecard_tgt = "javascript:alert('" . addslashes($lang_img_nav_bar['ecard_disabled_msg']) . "');";


        $ecard_title = $lang_img_nav_bar['ecard_disabled'];


    }


    $thumb_tgt = getlink("&amp;file=thumbnails$meta_link$cat_link&amp;page=$page"); //$cat_link&page=$page


    


    


    


    // Only show the slideshow to registered user, admin, or if admin allows anon access to full size images


    if (USER_ID or $CONFIG['allow_anon_fullsize'] or USER_IS_ADMIN) {


        $slideshow_tgt = getlink("&amp;file=displayimage$meta_link$cat_link&amp;pid=$pid&amp;slideshow=5000");


        $slideshow_title = $lang_img_nav_bar['slideshow_title'];


    } else {


        $slideshow_tgt = "javascript:alert('" . addslashes($lang_img_nav_bar['slideshow_disabled_msg']) . "');";


        $slideshow_title = $lang_errors['members_only'];


    }





    $pic_pos = sprintf($lang_img_nav_bar['pic_pos'], $human_pos, $pic_count);


    $params = array('{THUMB_TGT}' => $thumb_tgt,


//                '{THUMB_TITLE}' => $lang_img_nav_bar['thumb_title'],


//                '{PIC_INFO_TITLE}' => $lang_img_nav_bar['pic_info_title'],


                '{SLIDESHOW_TGT}' => $slideshow_tgt,


                '{SLIDESHOW_TITLE}' => $slideshow_title,


                '{PIC_POS}' => $pic_pos,


                '{ECARD_TGT}' => $ecard_tgt,


                '{ECARD_TITLE}' => $ecard_title,


                '{PREV_TGT}' => $prev_tgt,


                '{PREV_TITLE}' => $prev_title,


                '{NEXT_TGT}' => $next_tgt,


                '{NEXT_TITLE}' => $next_title,


    );


    return template_eval($template_img_navbar, $params);


}





// Displays a picture


function html_picture()


{


    global $CONFIG, $CURRENT_PIC_DATA, $CURRENT_ALBUM_DATA, $USER, $HTTP_COOKIE_VARS, $CPG_M_DIR;


    global $album, $comment_date_fmt, $template_display_picture;


    global $lang_display_image_php, $lang_picinfo, $lang_config_data, $lang_errors;


    $pid = $CURRENT_PIC_DATA['pid'];


    // $ina is where the Registered Only picture is


    $ina = "$CPG_M_DIR/images/ina.jpg";


    // Check for anon picture viewing - only for registered user, admin, or if admin allows anon access to full size images


    if (USER_ID > 1 or $CONFIG['allow_anon_fullsize'] or USER_IS_ADMIN) {


        // Add 1 to hit counter unless the user reloaded the page


        if (!isset($USER['liv']) || !is_array($USER['liv'])) {


            $USER['liv'] = array();


        }


        // Add 1 to hit counter


        if ($album != "lasthits" && !in_array($pid, $USER['liv']) && isset($HTTP_COOKIE_VARS[$CONFIG['cookie_name'] . '_data'])) {


            add_hit($pid);


            if (count($USER['liv']) > 4) array_shift($USER['liv']);


            array_push($USER['liv'], $pid);


        }


        if ($CONFIG['make_intermediate'] && max($CURRENT_PIC_DATA['pwidth'], $CURRENT_PIC_DATA['pheight']) > $CONFIG['picture_width']) {


            $picture_url = get_pic_url($CURRENT_PIC_DATA, 'normal');


        } else {


            $picture_url = get_pic_url($CURRENT_PIC_DATA, 'fullsize');


        }


        $picture_menu = ((USER_ADMIN_MODE && $CURRENT_ALBUM_DATA['category'] == FIRST_USER_CAT + USER_ID) || GALLERY_ADMIN_MODE) ? html_picture_menu($pid) : '';


        $image_size = compute_img_size($CURRENT_PIC_DATA['pwidth'], $CURRENT_PIC_DATA['pheight'], $CONFIG['picture_width']);


        $pic_title = '';


        if ($CURRENT_PIC_DATA['title'] != '') {


            $pic_title .= $CURRENT_PIC_DATA['title'] . "\n";


        }


        if ($CURRENT_PIC_DATA['caption'] != '') {


            $pic_title .= $CURRENT_PIC_DATA['caption'] . "\n";


        }


        if ($CURRENT_PIC_DATA['keywords'] != '') {


            $pic_title .= $lang_picinfo['Keywords'] . ": " . $CURRENT_PIC_DATA['keywords'];


        }


        if (isset($image_size['reduced'])) {


            $CONFIG['justso']=0;


            if ($CONFIG['justso']) {


                //include('jspw.js');


                $winsizeX = $CURRENT_PIC_DATA['pwidth']+ 16;


                $winsizeY = $CURRENT_PIC_DATA['pheight']+ 16;


                $hug = 'hug image';


                $hugwidth = '4';


                $bgclr = '#000000';


                $alt = 'Click image to close this window'; // $lang_fullsize_popup[1];


                $pic_html = '<a href="'.getlink("&amp;file=justsofullsize&amp;pid=$pid").'" target="' . uniqid(rand()) . "\" onClick=\"JustSoPicWindow('".getlink("&amp;file=justsofullsize&amp;pid=$pid")."','$winsizeX','$winsizeY','$alt','$bgclr','$hug','$hugwidth');return false\">";


            } else {


                $winsizeX = $CURRENT_PIC_DATA['pwidth'] + 16;


                $winsizeY = $CURRENT_PIC_DATA['pheight'] + 16;


                $pic_html = '<a href="'.getlink("&amp;file=displayimagepopup&amp;pid=$pid&amp;fullsize=1").'" target="' . uniqid(rand()) . "\" onClick=\"MM_openBrWindow('".getlink("&amp;file=displayimagepopup&amp;pid=$pid&amp;fullsize=1")."','" . uniqid(rand()) . "','resizable=yes,scrollbars=yes,width=$winsizeX,height=$winsizeY,left=0,top=0');return false\">"; //toolbar=yes,status=yes,


                $pic_title = $lang_display_image_php['view_fs'] . "\n ============== \n" . $pic_title; //added by gaugau


            }


            $pic_html .= "<img src=\"" . $picture_url . "\" {$image_size['geom']} class=\"image\" border=\"0\" alt=\"{$pic_title}\" title=\"{$pic_title}\" /><br />";


            $pic_html .= "</a>\n";


        } else {


            $pic_html = "<img src=\"" . $picture_url . "\" {$image_size['geom']} alt=\"{$pic_title}\" title=\"{$pic_title}\" class=\"image\" border=\"0\" /><br />\n";


        }


        if (!$CURRENT_PIC_DATA['title'] && !$CURRENT_PIC_DATA['caption']) {


            template_extract_block($template_display_picture, 'img_desc');


        } else {


            if (!$CURRENT_PIC_DATA['title']) {


                template_extract_block($template_display_picture, 'title');


            }


            if (!$CURRENT_PIC_DATA['caption']) {


                template_extract_block($template_display_picture, 'caption');


            }


        }


    } else {


        $imagesize = getimagesize($ina);


        $image_size = compute_img_size($imagesize[0], $imagesize[1], $CONFIG['picture_width']);


        $pic_html = '<a href="' .NEWUSER_URL. '">';


        $pic_html .= "<img src=\"" . $ina . "\" {$image_size['geom']} alt=\"Click to register\" title=\"Click to register\" class=\"image\" border=\"0\" /></a><br />";


        $picture_menu = "";


        $CURRENT_PIC_DATA['title'] = $lang_errors['members_only'];


        $CURRENT_PIC_DATA['caption'] = '';


    }


    $params = array('{CELL_HEIGHT}' => '100',


        '{IMAGE}' => $pic_html,


        '{ADMIN_MENU}' => $picture_menu,


        '{TITLE}' => $CURRENT_PIC_DATA['title'],


        '{CAPTION}' => bb_decode($CURRENT_PIC_DATA['caption']),


    );


    return template_eval($template_display_picture, $params);


}





function html_rating_box()


{


    global $CONFIG, $CURRENT_PIC_DATA, $CURRENT_ALBUM_DATA;


    global $template_image_rating, $lang_rate_pic;


    if (!(USER_CAN_RATE_PICTURES && $CURRENT_ALBUM_DATA['votes'] == 'YES')) return '';


    $votes = $CURRENT_PIC_DATA['pic_rating'] ? sprintf($lang_rate_pic['rating'], round($CURRENT_PIC_DATA['pic_rating'] / 2000, 1), $CURRENT_PIC_DATA['votes']) : $lang_rate_pic['no_votes'];


    $pid = $CURRENT_PIC_DATA['pid'];


    $params = array(


//        '{TITLE}' => $lang_rate_pic['rate_this_pic'],


        '{VOTES}' => $votes,


        '{RATE0}' => getlink("&amp;file=ratepic&amp;pic=$pid&amp;rate=0"),


        '{RATE1}' => getlink("&amp;file=ratepic&amp;pic=$pid&amp;rate=1"),


        '{RATE2}' => getlink("&amp;file=ratepic&amp;pic=$pid&amp;rate=2"),


        '{RATE3}' => getlink("&amp;file=ratepic&amp;pic=$pid&amp;rate=3"),


        '{RATE4}' => getlink("&amp;file=ratepic&amp;pic=$pid&amp;rate=4"),


        '{RATE5}' => getlink("&amp;file=ratepic&amp;pic=$pid&amp;rate=5"),


//        '{RUBBISH}' => $lang_rate_pic['rubbish'],


//        '{POOR}' => $lang_rate_pic['poor'],


//        '{FAIR}' => $lang_rate_pic['fair'],


//        '{GOOD}' => $lang_rate_pic['good'],


//        '{EXCELLENT}' => $lang_rate_pic['excellent'],


//        '{GREAT}' => $lang_rate_pic['great'],


    );


    if (USER_ID or $CONFIG['allow_anon_fullsize'] or USER_IS_ADMIN) {


        return template_eval($template_image_rating, $params);


    }


}


// Display picture information


function html_picinfo()


{


    global $CONFIG, $CURRENT_PIC_DATA, $CURRENT_ALBUM_DATA, $THEME_DIR, $FAVPICS, $CPG_M_DIR;


    global $album, $lang_picinfo, $lang_display_image_php, $lang_byte_units;


    if ($CURRENT_PIC_DATA['owner_id'] && $CURRENT_PIC_DATA['owner_name']) {


        $owner_link = '<a href ="'.getlink('Forums&amp;file=profile&amp;mode=viewprofile&amp;u=' . $CURRENT_PIC_DATA['owner_id']) . '">' . $CURRENT_PIC_DATA['owner_name'] . '</a> ';


    } else {


        $owner_link = '';


    }


    if (GALLERY_ADMIN_MODE && $CURRENT_PIC_DATA['pic_raw_ip']) {


        if ($CURRENT_PIC_DATA['pic_hdr_ip']) {


            $ipinfo = ' (' . $CURRENT_PIC_DATA['pic_hdr_ip'] . '[' . $CURRENT_PIC_DATA['pic_raw_ip'] . ']) / ';


        } else {


            $ipinfo = ' (' . $CURRENT_PIC_DATA['pic_raw_ip'] . ') / ';


        }


    } else {


        if ($owner_link) {


            $ipinfo = '/ ';


        } else {


            $ipinfo = '';


        }


    }


    if ($CONFIG['picinfo_display_filename']) {


        $info[$lang_picinfo['Filename']] = htmlspecialchars($CURRENT_PIC_DATA['filename']);


    }


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


    // Added by Vitor Freitas on 2003-09-01.


    // Hack version: 1.1


    // Display the name of the user that upload the image whit the image information.


    // Modified by DJ Maze for CPG 1.2 RC4


    global $db, $field_user_name, $field_user_id, $lastup_date_fmt;





    $vf_sql = "SELECT $field_user_name FROM " . $CONFIG['TABLE_USERS'] . " WHERE $field_user_id='" . $CURRENT_PIC_DATA['owner_id'] . "'";


    $vf_result = $db->sql_query($vf_sql);


    $vf_row = $db->sql_fetchrow($vf_result);


    // if statement added by gtroll


    // only display if there is a value


    if ($vf_row != '') {


        $info['Upload by'] = '<a href="'.getlink('Forums&amp;file=profile&amp;mode=viewprofile&amp;u=' . $CURRENT_PIC_DATA['owner_id']) . '" target="_blank">' . $vf_row[$field_user_name] . '</a>';


      //////Added by PCN www.pcnuke.com//////


      $info['Date Added'] = '' . localised_date($CURRENT_PIC_DATA['ctime'],$lastup_date_fmt). '';


   }


    // End -- Vitor Freitas on 2003-08-29.


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


    if ($CONFIG['picinfo_display_album_name']) {


        $info[$lang_picinfo['Album name']] = '<span class="alblink"><a href="' . getlink('&amp;file=thumbnails&amp;album=' . $CURRENT_PIC_DATA['aid']) . '">' . $CURRENT_ALBUM_DATA['title'] . '</a></span>';


    }


    if ($CURRENT_PIC_DATA['votes'] > 0) {


        $info[sprintf($lang_picinfo['Rating'], $CURRENT_PIC_DATA['votes'])] = '<img src="' . $CPG_M_DIR . '/images/rating' . round($CURRENT_PIC_DATA['pic_rating'] / 2000) . '.gif" align="absmiddle"/>';


    }


    if ($CURRENT_PIC_DATA['keywords'] != "") {


        $info[$lang_picinfo['Keywords']] = '<span class="alblink">' . preg_replace("/(\S+)/", '<a href="'.getlink('&amp;file=thumbnails&amp;meta=search&amp;search=\\1').'">\\1</a>' , $CURRENT_PIC_DATA['keywords']) . '</span>';


    }


    //$info[test] = "SELECT pid FROM {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} ON visibility IN (".USER_IN_GROUPS.") WHERE p.pid='".$CURRENT_PIC_DATA['pid']."' GROUP BY pid LIMIT 1";


    for ($i = 1; $i <= 4; $i++) {


        if ($CONFIG['user_field' . $i . '_name']) {


            if ($CURRENT_PIC_DATA['user' . $i] != "") {


                $info[$CONFIG['user_field' . $i . '_name']] = cpg_make_clickable($CURRENT_PIC_DATA['user' . $i]);


            }


        }


    }


    $info[$lang_picinfo['File Size']] = ($CURRENT_PIC_DATA['filesize'] > 10240 ? ($CURRENT_PIC_DATA['filesize'] >> 10) . ' ' . $lang_byte_units[1] : $CURRENT_PIC_DATA['filesize'] . ' ' . $lang_byte_units[0]);


    if ($CONFIG['picinfo_display_file_size']) {


        $info[$lang_picinfo['File Size']] = '<span dir="LTR">' . $info[$lang_picinfo['File Size']] . '</span>';


    }


    if ($CONFIG['picinfo_display_dimensions']) {


        $info[$lang_picinfo['Dimensions']] = sprintf($lang_display_image_php['size'], $CURRENT_PIC_DATA['pwidth'], $CURRENT_PIC_DATA['pheight']);


    }


    if ($CONFIG['picinfo_display_dimensions']) {


        $info[$lang_picinfo['Displayed']] = sprintf($lang_display_image_php['views'], $CURRENT_PIC_DATA['hits']);


    }


    $path_to_pic = $CURRENT_PIC_DATA['filepath'] . $CURRENT_PIC_DATA['filename'];


    if ($CONFIG['read_exif_data']) $exif = exif_parse_file($path_to_pic);


    if (isset($exif) && is_array($exif)) {


        if (isset($exif['Camera'])) $info[$lang_picinfo['Camera']] = $exif['Camera'];


        if (isset($exif['DateTaken'])) $info[$lang_picinfo['Date taken']] = $exif['DateTaken'];


        if (isset($exif['Aperture'])) $info[$lang_picinfo['Aperture']] = $exif['Aperture'];


        if (isset($exif['ExposureTime'])) $info[$lang_picinfo['Exposure time']] = $exif['ExposureTime'];


        if (isset($exif['FocalLength'])) $info[$lang_picinfo['Focal length']] = $exif['FocalLength'];


        if (isset($exif['Comment'])) $info[$lang_picinfo['Comment']] = $exif['Comment'];





    }


    // Create the absolute URL for display in info


    if (($CONFIG['picinfo_display_URL']) || ($CONFIG['picinfo_display_URL_bookmark'])) {


        if ($CONFIG['picinfo_display_URL_bookmark']) {


            $info["URL"] = '<a href="'.$CONFIG["ecards_more_pic_target"].getlink("&amp;file=displayimage&amp;album=$CURRENT_PIC_DATA[aid]&amp;pos=$CURRENT_PIC_DATA[pid]").'" onClick="addBookmark(\''.$CURRENT_PIC_DATA["filename"].'\',\''.$CONFIG["ecards_more_pic_target"].getlink("&amp;file=displayimage&amp;album={$CURRENT_PIC_DATA['aid']}&amp;pos={$CURRENT_PIC_DATA['pid']}")."');return false\">{$lang_picinfo['bookmark_page']}</a>";


        } else {


            $info['URL'] = '<a href="'.$CONFIG["ecards_more_pic_target"].getlink("&amp;file=displayimage&amp;album=$CURRENT_PIC_DATA[aid]&amp;pos=$CURRENT_PIC_DATA[pid]").'">'.$CONFIG["ecards_more_pic_target"].getlink("&amp;file=displayimage&amp;album=$CURRENT_PIC_DATA[aid]&amp;pos=$CURRENT_PIC_DATA[pid]").'</a>';


        }


    }





    if ($CONFIG['read_iptc_data']) $iptc = get_IPTC($path_to_pic);





    if (isset($iptc) && is_array($iptc)) {


        if (isset($iptc['Title'])) $info[$lang_picinfo['iptcTitle']] = trim($iptc['Title']);


        if (isset($iptc['Copyright'])) $info[$lang_picinfo['iptcCopyright']] = trim($iptc['Copyright']);


        if (isset($iptc['Keywords'])) $info[$lang_picinfo['iptcKeywords']] = trim(implode(" ",$iptc['Keywords']));


        if (isset($iptc['Category'])) $info[$lang_picinfo['iptcCategory']] = trim($iptc['Category']);


        if (isset($iptc['SubCategories'])) $info[$lang_picinfo['iptcSubCategories']] = trim(implode(" ",$iptc['SubCategories']));


    }


    // with subdomains the variable is $_SERVER["SERVER_NAME"] does not return the right value instead of using a new config variable I reused $CONFIG["ecards_more_pic_target"] with trailing slash in the configure


    // Create the add to fav link


    if ($CONFIG['picinfo_display_favorites']) {


        if (!in_array($CURRENT_PIC_DATA['pid'], $FAVPICS)) {


            $info[$lang_picinfo['addFavPhrase']] = '<a href="' . getlink('&amp;file=addfav&amp;pid=' . $CURRENT_PIC_DATA['pid']) . '" >' . $lang_picinfo['addFav'] . '</a>';


        } else {


            $info[$lang_picinfo['addFavPhrase']] = '<a href="' . getlink('&amp;file=addfav&amp;pid=' . $CURRENT_PIC_DATA['pid']) . '" >' . $lang_picinfo['remFav'] . '</a>';


        }


    }


    if (USER_ID or $CONFIG['allow_anon_fullsize'] or USER_IS_ADMIN) {


        return theme_html_picinfo($info);


    }


}


// Displays comments for a specific picture


function html_comments($pid)


{


    global $CONFIG, $USER, $CURRENT_ALBUM_DATA, $comment_date_fmt, $HTML_SUBST, $username;


    global $template_image_comments, $template_add_your_comment, $lang_display_comments;


    $html = '';


    if (!$CONFIG['enable_smilies']) {


        $tmpl_comment_edit_box = template_extract_block($template_image_comments, 'edit_box_no_smilies', '{EDIT}');


        template_extract_block($template_image_comments, 'edit_box_smilies');


        template_extract_block($template_add_your_comment, 'input_box_smilies');


    } else {


        $tmpl_comment_edit_box = template_extract_block($template_image_comments, 'edit_box_smilies', '{EDIT}');


        template_extract_block($template_image_comments, 'edit_box_no_smilies');


        template_extract_block($template_add_your_comment, 'input_box_no_smilies');


    }


    $tmpl_comments_buttons = template_extract_block($template_image_comments, 'buttons', '{BUTTONS}');


    $tmpl_comments_ipinfo = template_extract_block($template_image_comments, 'ipinfo', '{IPINFO}');


    $result = db_query("SELECT msg_id, msg_author, msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, author_id, author_md5_id, msg_raw_ip, msg_hdr_ip FROM {$CONFIG['TABLE_COMMENTS']} WHERE pid='$pid' ORDER BY msg_id ASC");


    while ($row = mysql_fetch_array($result)) {


        $user_can_edit = (GALLERY_ADMIN_MODE) || (USER_ID > 1 && USER_ID == $row['author_id'] && USER_CAN_POST_COMMENTS) || (USER_ID < 2 && USER_CAN_POST_COMMENTS && ($USER['ID'] == $row['author_md5_id']));


        $comment_buttons = $user_can_edit ? $tmpl_comments_buttons : '';


        $comment_edit_box = $user_can_edit ? $tmpl_comment_edit_box : '';


        $comment_ipinfo = ($row['msg_raw_ip'] && GALLERY_ADMIN_MODE)?$tmpl_comments_ipinfo : '';


        if ($CONFIG['enable_smilies']) {


            $comment_body = set_smilies(cpg_make_clickable($row['msg_body']));


            $smilies = smilies_table('onerow', 'msg_body', "f{$row['msg_id']}");


//            $comment_body = process_smilies(cpg_make_clickable($row['msg_body']));


//            $smilies = generate_smilies("f{$row['msg_id']}", 'msg_body');


        } else {


            $comment_body = cpg_make_clickable($row['msg_body']);


            $smilies = '';


        }


        $params = array('{EDIT}' => &$comment_edit_box,


            '{BUTTONS}' => &$comment_buttons,


            '{IPINFO}' => &$comment_ipinfo


        );


        $template = template_eval($template_image_comments, $params);


        $params = array('{MSG_AUTHOR}' => $row['msg_author'],


            '{MSG_ID}' => $row['msg_id'],


            '{EDIT_TITLE}' => &$lang_display_comments['edit_title'],


            '{CONFIRM_DELETE}' => &$lang_display_comments['confirm_delete'],


            '{MSG_DATE}' => localised_date($row['msg_date'], $comment_date_fmt),


            '{MSG_BODY}' => &$comment_body,


            '{MSG_BODY_RAW}' => $row['msg_body'],


            '{OK}' => &$lang_display_comments['OK'],


            '{SMILIES}' => $smilies,


            '{HDR_IP}' => $row['msg_hdr_ip'],


            '{RAW_IP}' => $row['msg_raw_ip'],


        );


        $html .= template_eval($template, $params);


    }


    if (USER_CAN_POST_COMMENTS && $CURRENT_ALBUM_DATA['comments'] == 'YES') {


        if (USER_ID > 1) {


            $username_input = '<input type="hidden" name="msg_author" value="' . CPG_USERNAME . '">';


            template_extract_block($template_add_your_comment, 'username_input', $username_input);


            // $username = '';


        } else {


            $username = isset($USER['name']) ? '"' . strtr($USER['name'], $HTML_SUBST) . '"' : '"' . $lang_display_comments['your_name'] . '" onClick="javascript:this.value=\'\';"';


        }





        $params = array('{ADD_YOUR_COMMENT}' => $lang_display_comments['add_your_comment'],


            // Modified Name and comment field


            '{NAME}' => $lang_display_comments['name'],


            '{COMMENT}' => $lang_display_comments['comment'],


            '{PIC_ID}' => $pid,


            '{username}' => $username,


            '{MAX_COM_LENGTH}' => $CONFIG['max_com_size'],


            '{OK}' => $lang_display_comments['OK'],


            '{SMILIES}' => '',


        );


        if ($CONFIG['enable_smilies']) $params['{SMILIES}'] = smilies_table('onerow', 'message', 'post');


//        if ($CONFIG['enable_smilies']) $params['{SMILIES}'] = generate_smilies();


        $html .= template_eval($template_add_your_comment, $params);


    }


    if (USER_ID > 1 or $CONFIG['allow_anon_fullsize'] or USER_IS_ADMIN) {


        return $html;


    }


}





function slideshow()


{


    global $CONFIG,  $lang_display_image_php, $template_display_picture, $CPG_M_DIR;


    if (function_exists('theme_slideshow')) {


        theme_slideshow();


        return;


    }


    pageheader($lang_display_image_php['slideshow']);


    include($CPG_M_DIR."/include/slideshow.inc");


    $start_slideshow = '<script language="JavaScript" type="text/JavaScript">runSlideShow()</script>';


    template_extract_block($template_display_picture, 'img_desc', $start_slideshow);


    $params = array('{CELL_HEIGHT}' => $CONFIG['picture_width'] + 100,


        '{IMAGE}' => '<img src="' . $start_img . '" name="SlideShow" class="image" /><br />',


        '{ADMIN_MENU}' => '',


    );


    starttable();


    echo template_eval($template_display_picture, $params);


    endtable();


    starttable();


    echo <<<EOT


        <tr>


        <td align="center" class="navmenu" style="white-space: nowrap;">


        <a href="javascript:endSlideShow()" class="navmenu">{$lang_display_image_php['stop_slideshow']}</a>


        </td>


        </tr>


EOT;


    endtable();


    pagefooter();


}





/**


 * Main code


 */


global $lang_list_categories;


$pos = isset($_GET['pos']) ? intval($_GET['pos']) : 0;


$pid = isset($_GET['pid']) ? intval($_GET['pid']) : 0;


$album = isset($_GET['album']) ? intval($_GET['album']) : '';


$meta = isset($_GET['meta']) ? $_GET['meta'] : '';


$cat = isset($_GET['cat']) ? intval($_GET['cat']) : '';





// $thisalbum is passed to get_pic_data as a varible used in queries 


// to limit meta queries to the current album or category


$thisalbum = "category >= '0'";//just something that is true


if ($meta != '') {


    if ($album != '') {


        $cat = -$album;


    }


    $album = $meta;


}


if ($cat<0) { //  && $cat<0 Meta albums, we need to restrict the albums to the current category


    $actual_album = -$cat;


    $thisalbum = 'a.aid = '.$actual_album;


}


else if ($cat){


    if ($cat == USER_GAL_CAT) {


        $thisalbum = 'category > ' . FIRST_USER_CAT;


    } elseif ($meta != '' && is_numeric($cat)) {


        if ($cat > 0) $thisalbum = "category = '$cat'";


    } else if (is_numeric($album)) {


        $thisalbum= "a.aid = $album";


    }


} else if (is_numeric($album)) {


    $thisalbum= "a.aid = $album";


}


// END NEW





// Retrieve data for the current picture


if ($meta == 'random' || ($meta == '' && !is_numeric($album)) || $pid > 0 || $pos < 0) {


    if ($pid < 1) $pid = $pos;


    if ($pos < 0) $pid = -$pos;


    // modified by DJMaze


    $result = db_query("SELECT p.aid FROM {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} ON (".VIS_GROUPS.") WHERE approved = 'YES' AND p.pid=".$pid." LIMIT 1");


    //this doesn't work


    if (mysql_num_rows($result) == 0) {


        cpg_die(ERROR, $lang_errors['non_exist_ap'], __FILE__, __LINE__);


    }


    $row = mysql_fetch_array($result);


    // this doesn't work either


    if ($row[0] == ''){


          cpg_die(ERROR, $lang_errors['members_only']);


    }


    $album = $row['aid'];


    mysql_free_result($result); //added by gtroll


    $pic_data = get_pic_data('', $album, $pic_count, $album_name, -1, -1, false);


    for($pos = 0; $pic_data[$pos]['pid'] != $pid && $pos < $pic_count; $pos++);


    $pic_data = get_pic_data('', $album, $pic_count, $album_name, $pos, 1, false);


    $CURRENT_PIC_DATA = $pic_data[0];


} else if (isset($_GET['pos'])){


    $pic_data = get_pic_data($meta, $album, $pic_count, $album_name, $pos, 1, false);


    if ($pic_count == 0) {


        cpg_die(INFORMATION, $lang_errors['members_only'], __FILE__, __LINE__);


    }


    elseif (count($pic_data) == 0 && $pos >= $pic_count) {


        $pos = $pic_count - 1;


        $human_pos = $pos + 1;


        $pic_data = get_pic_data($meta, $album, $pic_count, $album_name, $pos, 1, false);


    }


    $CURRENT_PIC_DATA = $pic_data[0];


    if ($pic_count == 0) {


        cpg_die(INFORMATION, $lang_errors['members_only'], __FILE__, __LINE__);


    }


}


// Retrieve data for the current album


if (isset($CURRENT_PIC_DATA)) {


    $result = db_query("SELECT title, comments, votes, category FROM {$CONFIG['TABLE_ALBUMS']} WHERE aid='{$CURRENT_PIC_DATA['aid']}' LIMIT 1");


    if (!mysql_num_rows($result)) cpg_die(CRITICAL_ERROR, sprintf($lang_errors['pic_in_invalid_album'], $CURRENT_PIC_DATA['aid']), __FILE__, __LINE__);


    $CURRENT_ALBUM_DATA = mysql_fetch_array($result);


}


// slideshow control


if (isset($_GET['slideshow'])) {


    slideshow();


} else {


//    if (!isset($_GET['pos'])) cpg_die(ERROR, $lang_errors['non_exist_ap'], __FILE__, __LINE__);


    $picture_title = $CURRENT_PIC_DATA['title'] ? $CURRENT_PIC_DATA['title'] : strtr(preg_replace("/(.+)\..*?\Z/", "\\1", htmlspecialchars($CURRENT_PIC_DATA['filename'])), "_", " ");


    $nav_menu = html_img_nav_menu();


    $picture = html_picture();


    $votes = html_rating_box();


    $pic_info = html_picinfo();


    $comments = html_comments($CURRENT_PIC_DATA['pid']);


    pageheader($album_name . '/' . $picture_title, '', false);


    // Display Breadcrumbs


    set_breadcrumb(0);


    // Display Filmstrip if the album is not search


    if ($album != 'search') {


        $film_strip = display_film_strip($meta, $album, (isset($cat) ? $cat : 0), $pos, true);


    }


    theme_display_image($nav_menu, $picture, $votes, $pic_info, $comments, $film_strip); //,


    // strpos ( string haystack, string needle [, int offset])


    $mpl=$CONFIG['main_page_layout'];


    if (strpos("$mpl","anycontent")=== true) {


        include("$CPG_M_DIR/anycontent.php");


    }


    pagefooter();


}





?>

Posted: Tue Sep 15, 2009 7:45 pm

Go to the bottom of rnconfig and turn $disableCSRFChecking to true. See if that helps.

Posted: Tue Sep 15, 2009 9:41 pm

Palbin, No luck with switching to true.

Posted: Wed Sep 16, 2009 12:24 am

Turned on debug and got the following:

The selected album/picture does not exist !

File: /nfs/c01/h04/mnt/44596/domains/mysite.com/html/test/modules/coppermine/include/functions.inc - Line: 977

including lines: from 975 to 979

Code:

// Invalid meta album


        default :


            cpg_die(ERROR, $lang_errors['non_exist_ap'], __FILE__, __LINE__);


    } 


} // End of get_pic_data

977 is this cpg_die(ERROR, $lang_errors['non_exist_ap'], __FILE__, __LINE__);

Posted: Wed Sep 16, 2009 7:14 am

Looks to me like the "default" statement you quoted is at the end of a case statement which displays the picture or album if it is found. You might need to quote the full case statement for us. Wondering is some variable we introduced in 2.4 might be stepping on a variable name usage in Coppermine and causing Coppermine not to find the file.

Posted: Wed Sep 16, 2009 8:05 am

fkelly, Yes, I think it is at the end of a statement. I think it begins here:

Code:

/**


 * Functions for album/picture management


 */


function get_cat_content(&$list, $cat, $title)


{


    if (!GALLERY_ADMIN_MODE) $upload = "AND uploads = 'YES'";


    global $CONFIG;





    $albums = db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = " . $cat . " $upload ORDER BY title");


    while ($album = mysql_fetch_array($albums)) {


        $rowset['aid'] = $album['aid'];


        $rowset['title'] = $title . $album['title'];


        $list[] = $rowset;


    }


    mysql_free_result($albums);





    $cats = db_query("SELECT cid, catname FROM {$CONFIG['TABLE_CATEGORIES']} WHERE parent=".$cat." ORDER BY catname");


    while ($subcat = mysql_fetch_array($cats)) {


        $tmptitle = $title . $subcat['catname'] . " > ";


        get_cat_content($list, $subcat['cid'], $tmptitle);


    }


    mysql_free_result($cats);


}


// get a full list of albums to use


function get_albumlist($user_id=0)


{


    if (!GALLERY_ADMIN_MODE) $upload = "AND uploads = 'YES'";


    global $CONFIG, $field_user_name, $field_user_id;





    $select = array();


    get_cat_content($select, 0, '');





    if (GALLERY_ADMIN_MODE)


        $sql = "SELECT aid, CONCAT('(', $field_user_name, ') ', title) AS title FROM {$CONFIG['TABLE_ALBUMS']} AS a " . "INNER JOIN {$CONFIG['TABLE_USERS']} AS u ON category = (" . FIRST_USER_CAT . " + $field_user_id) " . "ORDER BY title";


    else


        $sql = "SELECT aid, CONCAT('* ', title) AS title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category='" . (FIRST_USER_CAT + $user_id) . "' ORDER BY title";


    $result = db_query($sql);


    while ($row = mysql_fetch_array($result)) $select[] = $row;


    mysql_free_result($result);


    return $select;


}





// Retrieve the data for a picture or a set of picture


function get_pic_data($meta, $album, &$count, &$album_name, $limit1 = -1, $limit2 = -1, $set_caption = true)


{


    global $USER, $CONFIG, $HTTP_GET_VARS, $HTML_SUBST, $THEME_DIR, $FAVPICS;


    global $album_date_fmt, $lastcom_date_fmt, $lastup_date_fmt, $lasthit_date_fmt, $thisalbum, $cat;


    global $lang_get_pic_data, $lang_meta_album_names, $lang_errors, $CPG_M_DIR, $CPG_PROFILE_URL;


    global $db;


    $sort_array = array('na' => 'filename ASC', 'nd' => 'filename DESC', 'ta' => 'title ASC', 'td' => 'title DESC', 'da' => 'pid ASC', 'dd' => 'pid DESC', 'ra' => 'pic_rating ASC', 'rd' => 'pic_rating DESC', 'sd' => 'max(pwidth,pheight) DESC', 'sa' => 'max(pwidth,pheight) ASC'); //'sa' => 'max(pwidth,pheight) DESC'


    $sort_code = isset($USER['sort'])? $USER['sort'] : $CONFIG['default_sort_order'];


    $sort_order = isset($sort_array[$sort_code]) ? $sort_array[$sort_code] : $sort_array[$CONFIG['default_sort_order']];


    $cat = is_numeric($cat)  ?  $cat  :  0;


    $limit = ($limit1 != -1) ? ' LIMIT ' . $limit1 : '';


    $limit .= ($limit2 != -1) ? ' ,' . $limit2 : '';


    if ($limit2 == 1) {


        $select_columns = 'p.*';


    } else {


        $select_columns = 'pid, filepath, filename, p.title, keywords, url_prefix, filesize, pwidth, pheight, ctime, p.aid';


    }


    // Regular albums


    if (is_numeric($album) && $meta == '') {


        $album_name = get_album_name($album);


        $result = db_query("SELECT COUNT(*) from {$CONFIG['TABLE_PICTURES']} as p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (a.aid = $album AND ".VIS_GROUPS.") WHERE p.aid='$album' AND approved='YES'");


        $nbEnr = mysql_fetch_row($result);


        $count = $nbEnr[0];


        mysql_free_result($result);


        if ($select_columns != '*') {


            $select_columns .= ', p.title, caption, hits, description';


        }


        $result = db_query("SELECT $select_columns from {$CONFIG['TABLE_PICTURES']} as p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (a.aid = $album AND ".VIS_GROUPS.") WHERE p.aid='$album' AND approved='YES' ORDER BY $sort_order $limit");


        $rowset = db_fetch_rowset($result);


        mysql_free_result($result);


        // Set picture caption


        if ($set_caption) foreach ($rowset as $key => $row) {


            $caption = ($rowset[$key]['title'] || $rowset[$key]['hits']) ? "<span class=\"thumb_title\">" . $rowset[$key]['title'] . (($rowset[$key]['title'])?"-":"") . sprintf($lang_get_pic_data['n_views'], $rowset[$key]['hits']) . "</span>" : '';


            if ($CONFIG['caption_in_thumbview']) {


                $caption .= $rowset[$key]['caption'] ? "<span class=\"thumb_caption\">" . bb_decode($rowset[$key]['caption']) . "</span>" : '';


            }


            if ($CONFIG['display_comment_count']) {


                $comments_nr = count_pic_comments($row['pid']);


                if ($comments_nr > 0) $caption .= "<span class=\"thumb_num_comments\">" . sprintf($lang_get_pic_data['n_comments'], $comments_nr) . "</span>";


            }


            $rowset[$key]['caption_text'] = $caption;


        }


        return $rowset;


    }


    // Meta albums


    $album_name = $lang_meta_album_names[$meta];


    // Limits pictures to the amount shown


    switch ($meta) {


        // Last comments


        case 'lastcom': 


            if ($select_columns == '*') {


                $select_columns = 'p.*';


            } else {


                $select_columns = str_replace('pid', 'p.pid', $select_columns) . ', msg_id, author_id, msg_author, UNIX_TIMESTAMP(msg_date) as msg_date, msg_body, p.aid';


            }


            $result = db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_COMMENTS']} as c INNER JOIN {$CONFIG['TABLE_PICTURES']} AS p ON (p.pid = c.pid AND approved='YES') INNER JOIN {$CONFIG['TABLE_ALBUMS']} as a ON (p.aid = a.aid AND ".VIS_GROUPS." AND $thisalbum) ORDER BY msg_date DESC");


            $nbEnr = mysql_fetch_row($result);


            $count = $nbEnr[0];


            mysql_free_result($result);


            $result = db_query("SELECT $select_columns FROM {$CONFIG['TABLE_COMMENTS']} as c INNER JOIN {$CONFIG['TABLE_PICTURES']} AS p ON (p.pid = c.pid AND approved='YES') INNER JOIN {$CONFIG['TABLE_ALBUMS']} as a ON (p.aid = a.aid AND ".VIS_GROUPS." AND $thisalbum) ORDER BY msg_date DESC $limit");


            $rowset = db_fetch_rowset($result);


            mysql_free_result($result);


            if ($set_caption) foreach ($rowset as $key => $row) {


                // FIX PostNuke


                if ($row['author_id']) {


                    $user_link = '<a href ="'.$CPG_PROFILE_URL.'' . (defined('IN_POSTNUKE')?$row['msg_author']:$row['author_id']) . '">' . $row['msg_author'] . '</a>';


                } else {


                    $user_link = $row['msg_author'];


                } 


                $msg_body = strlen($row['msg_body']) > 50 ? @substr($row['msg_body'], 0, 50) . "...": $row['msg_body']; 


                // if ($CONFIG['enable_smilies']) $msg_body = process_smilies($msg_body);


                $caption = '<span class="thumb_title">' . $user_link . '</span>' . '<span class="thumb_caption">' . localised_date($row['msg_date'], $lastcom_date_fmt) . '</span>' . '<span class="thumb_caption">' . $msg_body . '</span>';


                $rowset[$key]['caption_text'] = $caption;


            } 


            return $rowset;


            break;





        // Last comments by a specific user


        case 'lastcomby':


            $result = db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_COMMENTS']} as c INNER JOIN {$CONFIG['TABLE_PICTURES']} AS p ON (p.pid = c.pid AND approved='YES') INNER JOIN {$CONFIG['TABLE_ALBUMS']} as a ON (p.aid = a.aid AND ".VIS_GROUPS.") WHERE author_id = " .USER_ID. " GROUP BY p.pid ORDER BY msg_date DESC");


            $nbEnr = mysql_fetch_row($result);


            $count = $nbEnr[0];


            mysql_free_result($result);


            if ($select_columns == '*') {


                $select_columns = 'p.*';


            } else {


                $select_columns = str_replace('pid', 'c.pid', $select_columns) . ', msg_id, author_id, msg_author, UNIX_TIMESTAMP(msg_date) as msg_date, msg_body, p.aid';


            } 


            $result = db_query("SELECT $select_columns FROM {$CONFIG['TABLE_COMMENTS']} as c INNER JOIN {$CONFIG['TABLE_PICTURES']} AS p ON (p.pid = c.pid AND approved='YES') INNER JOIN {$CONFIG['TABLE_ALBUMS']} as a ON (p.aid = a.aid AND ".VIS_GROUPS.") WHERE author_id = " .USER_ID. " GROUP BY p.pid ORDER BY msg_date DESC $limit");


            $rowset = db_fetch_rowset($result);


            mysql_free_result($result);


            if ($set_caption) foreach ($rowset as $key => $row) {


                $comment_body = cpg_make_clickable($row['msg_body']);


                $user_link = $row['msg_author'];


                $caption = '<span class="thumb_title">' . $user_link . '</span>' . '<span class="thumb_caption">' . localised_date($row['msg_date'], $lastcom_date_fmt) . '</span>' . '<span class="thumb_caption">' . $comment_body . '</span>';


                $rowset[$key]['caption_text'] = $caption;


                } 


            return $rowset;


            break; // END Last comments





        // Last uploads


        case 'lastup': 


            $result = db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS." AND $thisalbum) WHERE approved='YES' ORDER BY p.pid DESC");


            $nbEnr = mysql_fetch_row($result);


            $count = $nbEnr[0];


            mysql_free_result($result);


            if ($select_columns == '*') {


                $select_columns = 'p.*';


            } else {


                $select_columns = str_replace('pid', 'p.pid', $select_columns) . ', owner_id, owner_name';


            }


            $result = db_query("SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS." AND $thisalbum) WHERE approved='YES' ORDER BY p.pid DESC $limit");


            $rowset = db_fetch_rowset($result);


            mysql_free_result($result);


            if ($set_caption) foreach ($rowset as $key => $row) {


                if ($row['owner_id'] && $row['owner_name']) {


                    $user_link = '<span class="thumb_title"><a href ="$CPG_PROFILE_URL' . (defined('IN_POSTNUKE')?$row['owner_name']:$row['owner_id']) . '">' . $row['msg_author'] . '</a></span>';


                } else {


                    $user_link = '';


                } 


                $caption = $user_link . '<span class="thumb_caption">' . localised_date($row['ctime'], $lastup_date_fmt) . '</span>';


                $rowset[$key]['caption_text'] = $caption;


            } 


            return $rowset;


            break;





        // Last uploads by a specific user


        case 'lastupby':


            $user_name = get_username(USER_ID);


            $result = db_query("SELECT COUNT(*) from {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} ON (".VIS_GROUPS.") WHERE approved='YES' AND owner_id = '".USER_ID."' GROUP BY p.pid ORDER BY p.pid DESC");


            $nbEnr = mysql_fetch_row($result);


            $count = $nbEnr[0];


            mysql_free_result($result);


            if ($select_columns != '*') $select_columns .= ', owner_id, owner_name, p.aid';


            $result = db_query("SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS." AND $thisalbum) WHERE approved='YES' AND owner_id = '$uid' GROUP BY p.pid ORDER BY p.pid DESC $limit");


            $rowset = db_fetch_rowset($result);


            mysql_free_result($result);


            if ($set_caption) foreach ($rowset as $key => $row) {


                if ($row['owner_id'] && $row['owner_name']) {


                    $user_link = '<span class="thumb_title"><a href ="$CPG_PROFILE_URL' . (defined('IN_POSTNUKE')?$row['owner_name']:$row['owner_id']) . '">' . $row['msg_author'] . '</a></span>';


                } else {


                    $user_link = '';


                } 


                $caption = $user_link . '<span class="thumb_caption">' . localised_date($row['ctime'], $lastup_date_fmt) . '</span>';


                $rowset[$key]['caption_text'] = $caption;


            } 


            return $rowset;


            break;





        // Most viewed pictures


        case 'topn':


            $result = db_query("SELECT COUNT(*) from {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS." AND $thisalbum) WHERE approved='YES' AND hits > 0");


            $nbEnr = mysql_fetch_row($result);


            $count = $nbEnr[0];


            mysql_free_result($result);


            if ($select_columns == '*') {


                $select_columns = 'p.*';


            } else {


                $select_columns .= ', hits, p.aid';


            }


            $result = db_query("SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS." AND $thisalbum) WHERE approved='YES' AND hits > 0 ORDER BY hits DESC $limit");


            //$result2 = db_query("SELECT FOUND_ROWS()");


            $rowset = db_fetch_rowset($result);


            //$nbEnr = mysql_fetch_array($result2);


            //$count = $nbEnr[0];


            mysql_free_result($result);


            if ($set_caption) foreach ($rowset as $key => $row) {


                $caption = "<span class=\"thumb_caption\">" . sprintf($lang_get_pic_data['n_views'], $row['hits']) . '</span>';


                $rowset[$key]['caption_text'] = $caption;


            } 


            return $rowset;


            break;





        // Top rated pictures


        case 'toprated':


            $result = db_query("SELECT count(*) FROM {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS." AND $thisalbum) WHERE approved='YES' AND p.votes >= {$CONFIG['min_votes_for_rating']}");


            $nbEnr = mysql_fetch_row($result);


            $count = $nbEnr[0];


            mysql_free_result($result);


            if ($select_columns == '*') {


                $select_columns = 'p.*';


            } else {


                $select_columns .= ', pic_rating, p.votes AS votes';


            }


            $result = db_query("SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS." AND $thisalbum) WHERE approved='YES' AND p.votes >= '{$CONFIG['min_votes_for_rating']}' ORDER BY ROUND((pic_rating+1)/2000) DESC, p.votes DESC, filename $limit");


            $rowset = db_fetch_rowset($result);


            mysql_free_result($result);


            if ($set_caption) foreach ($rowset as $key => $row) {


                if (defined('THEME_HAS_RATING_GRAPHICS')) {


                    $theme_prefix = "$CONFIG[theme]/";


                } else {


                    $theme_prefix = '';


                } 


                $caption = "<img src=\"" . $CPG_M_DIR . "/" . $theme_prefix . "images/rating" . round($row['pic_rating'] / 2000) . ".gif\" align=\"center\" border=\"0\">" . "<br />" . round($row['pic_rating'] / 2000, 2) . "/5 ";


                $caption .= sprintf(N_VOTES, $row['votes']);


                $rowset[$key]['caption_text'] = $caption;


            } 


            return $rowset;


            break;





        // Last viewed pictures


        case 'lasthits':


            // count the number of pics to show


            $result = db_query("SELECT COUNT(*) from {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS." AND $thisalbum) WHERE approved='YES' AND $thisalbum");


            $nbEnr = mysql_fetch_row($result);


            $count = $nbEnr[0];


            mysql_free_result($result);


            if ($select_columns != '*') $select_columns .= ', UNIX_TIMESTAMP(mtime) as mtime, aid';





            $result = db_query("SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS." AND $thisalbum) WHERE approved='YES' AND $thisalbum GROUP BY p.pid ORDER BY mtime DESC $limit");


            $rowset = db_fetch_rowset($result);


            mysql_free_result($result);


            if ($set_caption) foreach ($rowset as $key => $row) {


                $caption = "<span class=\"thumb_caption\">" . localised_date($row['mtime'], $lasthit_date_fmt) . '</span>';


                $rowset[$key]['caption_text'] = $caption;


            } 


            return $rowset;


            break;





        // Random pictures


        case 'random':


            // count the number of pics to show


            $result = db_query("SELECT COUNT(*) from {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS." AND $thisalbum) WHERE approved='YES' GROUP BY p.pid");


            $nbEnr = mysql_fetch_row($result);


            $pic_count = $nbEnr[0];


            mysql_free_result($result);


            if ($select_columns != '*') $select_columns .= ', p.aid';


            // if we have more than 1000 pictures, we limit the number of picture returned


            // by the SELECT statement as ORDER BY RAND() is time consuming


            if ($pic_count > 1000) {


//                $result = db_query("SELECT COUNT(*) from {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS." AND $thisalbum) WHERE approved='YES' AND $thisalbum GROUP BY p.pid");


//                $nbEnr = mysql_fetch_row($result);


                $total_count = $nbEnr[0];


                mysql_free_result($result);


                $granularity = floor($total_count / RANDPOS_MAX_PIC);


                $cor_gran = ceil($total_count / $pic_count);


                srand(time());


                for ($i = 1; $i <= $cor_gran; $i++) $random_num_set = rand(0, $granularity) . ', ';


                $random_num_set = substr($random_num_set, 0, -2);


                $result = db_query("SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} ON (".VIS_GROUPS." AND $thisalbum) WHERE  randpos IN ($random_num_set) AND approved = 'YES' GROUP BY p.pid ORDER BY RAND() LIMIT $limit2");


            } else {


                $result = db_query("SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS." AND $thisalbum) WHERE approved='YES' GROUP BY p.pid ORDER BY RAND() LIMIT $limit2");


            } 


            $rowset = db_fetch_rowset($result);


/*            $rowset = array();


            while ($row = mysql_fetch_array($result)) {


                $row['caption_text'] = '';


                $rowset[$row['pid']] = $row;


            }*/


            mysql_free_result($result);


            return $rowset;


            break;





        //All pictures by member


        case 'allby':


            $m_id = (isset($_GET['member_id'])) ? intval($_GET['member_id']) : 1;


            $result = db_query("SELECT * from {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS.") WHERE owner_id = '$m_id' AND  approved='YES' GROUP BY p.pid ORDER BY p.pid DESC");


            $nbEnr = mysql_fetch_row($result);


            $count = $nbEnr[0];


            mysql_free_result($result);


            if ($select_columns != '*') $select_columns .= ', owner_id, owner_name, p.aid';


            $result = db_query("SELECT $select_columns from {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS.") WHERE owner_id = '$m_id' AND  approved='YES' GROUP BY p.pid ORDER BY p.pid DESC $limit");


            $rowset = db_fetch_rowset($result);


            mysql_free_result($result);


            return $rowset;


            break;





        // Search results


        case 'search':


            if (isset($_GET['search'])) {


                $USER['search'] = $_GET['search'];


                if (isset($_GET['type']) && $_GET['type'] == 'full') {


                   $USER['search'] = '###' . $USER['search'];


                } 


            } elseif (isset($_POST['search'])) {


                $USER['search'] = $_POST['search'];


                if (isset($_POST['type']) && $_POST['type'] == 'full') {


                    $USER['search'] = '###' . $USER['search'];


                }


            }


            if (isset($USER['search'])) {


                $search_string = $USER['search'];


            } else {


                cpg_die(CRITICAL_ERROR, 'The searchstring is empty', __FILE__, __LINE__);


                $search_string = '';


            }





            if (substr($search_string, 0, 3) == '###') {


                $query_all = 1;


                $search_string = substr($search_string, 3);


            } else {


                $query_all = 0;


            } 


            $album_name .= ' - "' . strtr($search_string, $HTML_SUBST) . '"';





            require('search.inc');


            $rowset = search_pics($search_string, $select_columns, $query_all, $limit, $pic_count);


            $count = $pic_count;


            return $rowset;


            break;





        // Last albums to which uploads


        case 'lastalb':


            // count the number of pics to show


            $result = db_query("SELECT COUNT(*) from {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS." AND $thisalbum) WHERE approved='YES' AND $thisalbum");


            $nbEnr = mysql_fetch_row($result);


            $count = $nbEnr[0];


            mysql_free_result($result);


            $result = db_query("SELECT *, a.title AS title, a.aid AS aid FROM {$CONFIG['TABLE_PICTURES']} AS p INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON (p.aid = a.aid AND ".VIS_GROUPS."  AND $thisalbum) WHERE  approved = 'YES' GROUP  BY p.aid ORDER BY p.ctime DESC $limit");


            $rowset = db_fetch_rowset($result);


            mysql_free_result($result);


            if ($set_caption) foreach ($rowset as $key => $row) {


                $caption = "<span class=\"thumb_caption\">" . $row['title'] . " - " . localised_date($row['ctime'], $lastup_date_fmt) . '</span>';


                $rowset[$key]['caption_text'] = $caption;


            } 


            return $rowset;


            break;





        // Favourite Pictures


        case 'favpics':


            if (count($FAVPICS) > 0) {


                $favs = implode(",", $FAVPICS);


                $result = db_query("SELECT COUNT(*) from {$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES' AND pid IN ($favs) GROUP BY pid");


                $nbEnr = mysql_fetch_array($result);


                $count = $nbEnr[0];


                mysql_free_result($result);


                $select_columns = '*';





                $result = db_query("SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} AS p WHERE approved = 'YES' AND pid IN ($favs) GROUP BY pid $limit");


                $rowset = db_fetch_rowset($result);


                mysql_free_result($result);


                if ($set_caption) foreach ($rowset as $key => $row) {


                    $caption = $rowset[$key]['title'] ? "<span class=\"thumb_caption\">" . ($rowset[$key]['title']) . "</span>" : '';


                    $rowset[$key]['caption_text'] = $caption;


                } 


                return $rowset;


            }


            else return null;


            break;





        // Invalid meta album


        default :


            cpg_die(ERROR, $lang_errors['non_exist_ap'], __FILE__, __LINE__);


    } 


} // End of get_pic_data


// Get the name of an album


function get_album_name($aid)


{


    global $CONFIG;


    global $lang_errors;


    $result = db_query("SELECT title from {$CONFIG['TABLE_ALBUMS']} WHERE aid='$aid'");


    $count = mysql_num_rows($result);


    if ($count > 0) {


        $row = mysql_fetch_array($result);


        return $row['title'];


    } else {


        cpg_die($lang_errors['non_exist_ap']);


    } 


} 


// Return the name of a user


function get_username($uid)


{


    global $CONFIG, $field_user_name, $field_user_id;


    $result = db_query("SELECT $field_user_name FROM {$CONFIG['TABLE_USERS']} WHERE $field_user_id = '" . $uid . "'");


    $count = mysql_num_rows($result);


    if ($count > 0) {


        $row = mysql_fetch_array($result);


        return $row['username'];


    } else {


        return '';


    } 


} 


// Return the ID of a user


function get_userid($user_name)


{


    global $CONFIG, $field_user_id, $field_user_name;





    $user_name = addslashes($user_name); 


    // if ($user_id<2) {


    // return 0;


    // } else {


    $result = db_query("SELECT $field_user_id FROM {$CONFIG['TABLE_USERS']} WHERE $field_user_name = '" . $user_name . "'");


    return $result; 


    // }


} 


// Return the total number of comments for a certain picture


function count_pic_comments($pid, $skip = 0)


{


    global $CONFIG;


    $result = db_query("SELECT count(*) from {$CONFIG['TABLE_COMMENTS']} where pid=$pid and msg_id!=$skip");


    $nbEnr = mysql_fetch_array($result);


    $count = $nbEnr[0];


    mysql_free_result($result);





    return $count;


} 


// Add 1 everytime a picture is viewed.


function add_hit($pid)


{


    global $CONFIG;





    db_query("UPDATE {$CONFIG['TABLE_PICTURES']} SET hits=hits+1 WHERE pid='$pid'");


} 





// Build the breadcrumb array


function set_breadcrumb($lasturl = 0)


{


    global $CONFIG, $CPG_M_URL, $album, $cat, $field_user_name, $field_user_id, $lang_meta_album_names;


    $breadcrumb = array();


    $aid = $album;


    if ($cat < 0 && $cat != -$aid) {


        $aid = -$cat;


        $lasturl = 1;


    }


    if (is_numeric($aid) && $aid > 0) {


        $result = db_query("SELECT aid AS id, title, category AS parent FROM {$CONFIG['TABLE_ALBUMS']} WHERE aid = ".$aid);


        if (mysql_num_rows($result) > 0) {


            $row = mysql_fetch_array($result);


            $row['last'] = !$lasturl;


            $row['album'] = 1;


            $breadcrumb[] = $row;


            mysql_free_result($result);


        }


    }


    else if (is_numeric($cat) && $cat > 0) {


        if ($cat > FIRST_USER_CAT) {


            $result = db_query("SELECT $field_user_name AS title FROM {$CONFIG['TABLE_USERS']} WHERE $field_user_id = " . ($cat - FIRST_USER_CAT));


            if (mysql_num_rows($result) != 0) {


                $row = mysql_fetch_array($result);


                $row['id'] = $cat;


                $row['parent'] = 1;


                $row['last'] = !$lasturl;


                $breadcrumb[] = $row;


                mysql_free_result($result);


            }


        }


        else {


            $result = db_query("SELECT cid as id, parent, catname AS title FROM {$CONFIG['TABLE_CATEGORIES']} WHERE cid='$cat'");


            if (mysql_num_rows($result) > 0) {


                $row = mysql_fetch_array($result);


                $row['last'] = !$lasturl;


                $breadcrumb[] = $row;


                mysql_free_result($result);


            }


        }


    }


    get_breadcrumb($breadcrumb);


    $navigation = '<a class="statlink" id="statlink" href="'.$CPG_M_URL.'">' . $CONFIG['gallery_name'] . '</a>';


    foreach($breadcrumb as $crumb) {


        if ($crumb['last']) $navigation .= " > ".$crumb['title'];


        elseif ($crumb['album']) $navigation .= ' > <a class="statlink" id="statlink" href="'.getlink("&file=thumbnails&album=".$crumb['id'])."\">".$crumb['title']."</a>";


        else $navigation .= " > <a class=\"statlink\" id=\"statlink\" href=\"$CPG_M_URL&cat=".$crumb['id']."\">".$crumb['title']."</a>";


    }


    if (!is_numeric($album)) switch ($album) {


        case 'lastup':


        case 'lastupby':


        case 'lastcom':


        case 'lastcomby':


        case 'topn':


        case 'toprated':


        case 'search':


        case 'random':


            $navigation .= " > ".$lang_meta_album_names[$album];


            break;


    }


    if ($navigation == "") $navigation = "> Coppermine";


    $dummy = array();


    theme_display_breadcrumb($navigation, $dummy);


}





// Get the breadcrumb array


function get_breadcrumb(&$breadcrumb)


{


    global $CONFIG, $field_user_name, $field_user_id;


    if (!$breadcrumb) return;


    $last = count($breadcrumb);


    if ($breadcrumb[0]['parent'] == 0 || !is_numeric($breadcrumb[0]['parent'])) return;


    if ($breadcrumb[$last-1]['parent'] > FIRST_USER_CAT) {


        $cat = $breadcrumb[$last-1]['parent'];


        $result = db_query("SELECT $field_user_name AS title FROM {$CONFIG['TABLE_USERS']} WHERE $field_user_id = " . ($cat - FIRST_USER_CAT));


        if (mysql_num_rows($result) > 0) {


            $row = mysql_fetch_array($result);


            $row['id'] = $cat;


            $row['parent'] = 1;


            $breadcrumb[] = $row;


            mysql_free_result($result);


            get_breadcrumb($breadcrumb);


        }


        return;


    }

Posted: Wed Sep 16, 2009 8:25 am

A variable $meta was introduced in RN2.4 in the program dh.class.php as well as in nukeSEOdh.php (and I think elsewhere). I wonder if it could be interfering with the value of $meta in Coppermine. $meta is used as a switch as well as for other purposes in the Coppermine function you are having problems with.

You could stick some diagnostics in the get_pic_data function to echo $meta back out and see what value is being passed in.

There is a parameter to turn of Nukenav in rnconfig. I don't know if it would stop the the dh (SEO based) programs from being called but it might be worth giving it a try. Kguske knows way more about the internals of this than the rest of and might have an insight into whether I am on the right track here.

Posted: Wed Sep 16, 2009 9:16 am

I just had the same thought, fkelly. I'm pretty sure that's correct, but turning off nukeNAV won't solve the problem.

Let me look at the code to see what alternatives there are - right now I'm thinking of renaming the variable, either in nukeSEO DH or coppermine.

Posted: Wed Sep 16, 2009 10:04 am

In includes/nukeSEOdh.php and blocks/block-nukeSEOdh.php,

change all instances of $meta to $dhMETA

The nukeNAV module uses $META instead of $meta, and the classes define the variable locally.

Only registered users can see links on this board! Get registered or login! are the changed files, which can overwrite the existing files.

Posted: Wed Sep 16, 2009 10:43 am

kguske, For a non-coder like me the fact you guys can look at this what seams to be random text to me and fix it is INCREDIBLE! Thanks! that was it. Both test and my live install were fixed right away.

the nukeSEOdh.php is in includes/nukeSEO/
but that was easy for me to figure out, but any level higher than that can result difficult lol!

jc

Posted: Wed Sep 16, 2009 10:46 am

Posted: Tue Mar 30, 2010 11:36 pm

kguske, Hi do you happen to know if I'll run in to this problem again? or if the variable was changed to not conflict with coppermine. Did not see anything on the change log.

Thanks in advance Embarassed

jc

Posted: Wed Mar 31, 2010 2:16 pm

You are good to go Smile

Posted: Wed Mar 31, 2010 5:38 pm

Palbin, Thanks Dance-Y

I'll be doing my back up soon, upgrading and then giving a small contribution Very Happy

RN rocks!

jc