Jørn Wildt

Hi guys!

First a big thnx for an exelent module!
I' planing to use it as a personal image gallery for my registered users, and also include the first album created (the thumbnail of that album) in there userprofile, righ now i'm on my way as you can see from the code belove:[php]if(pnModAvailable('photoshare')) {
$pssql = "SELECT ps_id
FROM ".pnConfigGetVar('prefix')."_photoshare_folders
WHERE ps_owner = '".pnVarPrepForDisplay($userlist['pn_uid'])."' AND ps_parentfolder = '-1' AND ps_accesslevel = '1'";
$result = mysql_query($pssql);
echo "
<font class="\"pn-title\"">"._MY_GALLERY."</font>

";
if(mysql_num_rows($result) > 0){
$photosharegal = @mysql_result($result,0,'ps_id');
echo ""._PSIMAGE."";
}else{
echo ""._NOIMAGEGALLERY."";
}
echo "
";
} [/php]
This is all fine and dandy, with a link to there album, but i also want to display the album thumbnail inside the link. So i gues, my question is how to ii find out what thumbnail ID to use, and how to display it in the userprofile. I have tryed to use: [php] $psimage = "SELECT ps_id, ps_thumbnaildata
FROM CA_photoshare_images
WHERE ps_owner = '".pnVarPrepForDisplay($userlist['pn_uid'])."' AND ps_parentfolder = '-1' AND ps_position = '0'";
$result = mysql_query($psimage);
$photoshareimg = @mysql_result($result,0,'ps_thumbnaildata');
$photosharegal = @mysql_result($result,0,'ps_id');
echo '';
[/php] with no success, it dosent return anything...... :(

Problem solved!

Again thnx for an exelent mod!
swedish translations is on it's way

Regards
Black_Skorpio
PostNuke Sweden

Care to share your fix?

I am very interested if anyone ever got this hack working and if so, can they share the code and instructions....anything?.
Thank you.