Okay this is an upgrade to the PhotoPal so that it is compatible to run with Photopost 5.0 file structure<br /><br />You must be running Photopost 5.0 or above

I was just making a post asking about an update <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" /><br /><br /><br />I have everything set, well, at least I think I do and am getting this error:<br /><br /><br />Fatal error: Call to undefined function: pp_get_ext() in /home/socaps/public_html/ubbthreads/pals/custombox2pal.php on line 11

above the pp_is_image function add this<br /><br />function pp_get_ext( $filename ) {<br /> return substr($filename, strrpos($filename,"."));<br />}

ok, did that and now it's showing up, but not showing the images. I can however click on the broken image and it does link to the medium image.

Thanks for updating this Chuck - I needed the fix you posted as well <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

[]AllenAyres said:<br />Thanks for updating this Chuck - I needed the fix you posted as well <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> [/]<br />OK, what am I doing wrong here? When I add the fix above it does not show the images and also make the calendar go crazy ???<br /><br />I guess I will delete the files and try from scratch again.

Thank you for the update.

I know, this pal is sometimes a little bit tricky. I attach my working version here. Always remeber to setup your inc file properly. In my script you need to set your path and your threads DB name at the end.

thanks, I figured it out. I was not setting the data directory path correct. <br /> <br />Now, I have a problem with the calendar pal, which is 2 boxes bellow and am getting this error: <br /> <br /> <br /> <br />Whats weird is that if I turn the Photopal off it works. <br /> <br />Idea's ??? <br /> <br /> <br />www.socaps.com

sounds like a variable in the photopal is conflicting with a variable in the calendar pal.. try this.. add the photopal to your sidebar and just the photopal and go to the calendar itself.. see if same error

Thanks Chuck!

I have added this to the footer of my site and changed it around a little:<br />http://www.laondalatina.com<br /><br />What I want to know is what change would I have to make so it doesn't pull any photos from users member albums, private or not.<br /><br />Thanks!

As I was having problems with 1.3, ive upgraded to 5.1 and this version, but I still get the same error..<br /><br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in g:\webs\www.bm3w.co.uk\public_html\ubbthreads\pals\custombox1pal.php on line 78<br /><br />Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in g:\webs\www.bm3w.co.uk\public_html\ubbthreads\pals\custombox1pal.php on line 103<br /><br />Anyone have any idea why?

Those lines are:<br /><br />while ( list($pid, $puser, $puserid, $pcat, $ptitle, $photo, $pviews) = mysql_fetch_array($result)) { <br /><br />and<br /><br />mysql_free_result($result);

Featured Photos <br /> <br />I'm not getting any pictures displayed on the sidebar. It just shows the title bar on the side that says Featured Photos. <br /> <br />Mmm....any thoughts on this? <br /> <br />You can view this at: www.f-bodyhideout.com/ubbthreads

[]MattUK said:<br />As I was having problems with 1.3, ive upgraded to 5.1 and this version, but I still get the same error..<br /><br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in g:\webs\www.bm3w.co.uk\public_html\ubbthreads\pals\custombox1pal.php on line 78<br /><br />Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in g:\webs\www.bm3w.co.uk\public_html\ubbthreads\pals\custombox1pal.php on line 103<br /><br />Anyone have any idea why? [/]<br /><br />Anyone?

[]MattUK said:<br />Those lines are:<br /><br />while ( list($pid, $puser, $puserid, $pcat, $ptitle, $photo, $pviews) = mysql_fetch_array($result)) { <br /><br />and<br /><br />mysql_free_result($result); [/]<br /><br />thats not the line in question.. those only respond to the query.. whats the query above those lines?

//<br />// Featured Photos Code<br />// Follow down to End Feature Photos Code<br />//<br /><br />// which type of images do you want to show<br />$q_switch = "random";<br /><br />switch ($q_switch) {<br /> case "most_view":<br /> $query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views <br /> FROM {$pp_db_prefix}photos p <br /> LEFT JOIN {$pp_db_prefix}categories c ON c.id=p.cat <br /> WHERE c.password = '' <br /> ORDER BY c.views DESC";<br /> break;<br /> case "lastest":<br /> $query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views <br /> FROM {$pp_db_prefix}photos p <br /> LEFT JOIN {$pp_db_prefix}categories c ON c.id=p.cat <br /> WHERE c.password = '' <br /> ORDER BY date DESC";<br /> break;<br /> case "random":<br /> $query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views <br /> FROM {$pp_db_prefix}photos p <br /> LEFT JOIN {$pp_db_prefix}categories c ON c.id=p.cat <br /> WHERE c.password = '' <br /> ORDER BY RAND()";<br /> break;<br />}<br />$result = mysql_query($query);<br /><br />$counted = 0; $featured = "";<br /><br />while ( list($pid, $puser, $puserid, $pcat, $ptitle, $photo, $pviews) = mysql_fetch_array($result)) { <br /> if ( pp_is_image($photo) ) {<br /> $photolen = strlen($photo);<br /> $theext = pp_get_ext($photo);<br /> $photo_name = str_replace( $theext, "", $photo );<br /> <br /> $temp_user = $line['userid'];<br /> $thumbtag = "{$full_path}{$pcat}/thumbs/{$photo}";<br /> $mthumb = "<img border=\"0\" src=\"{$data_dir}{$pcat}/thumbs/{$photo}\" alt=\"$thumbtag\" />";

so then this is the actual query that is giving you problems<br /><br /> $query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views<br />FROM {$pp_db_prefix}photos p<br />LEFT JOIN {$pp_db_prefix}categories c ON c.id=p.cat<br />WHERE c.password = ''<br />ORDER BY RAND()";<br />break;<br />}<br /><br />so in a sql window try running<br /><br /><br />SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views<br />FROM pp_photos p<br />LEFT JOIN pp_categories c ON c.id=p.cat<br />WHERE c.password = ''<br />ORDER BY RAND()";<br />break;<br />}<br /><br />pp_ is whatever YOUR table PREFIX is

SQL Error.. see next post