12
Posts: 0
Posted:
4.Jun 2003 - 15:44
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 "
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...... :(
12
Posts: 0
Posted:
4.Jun 2003 - 16:20
Again thnx for an exelent mod!
swedish translations is on it's way
Regards
Black_Skorpio
PostNuke Sweden
12
Posts: 0
Posted:
26.Oct 2004 - 21:26
12
Posts: 0
Posted:
27.Mar 2006 - 12:27
Thank you.