coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 pnCPG (Coppermine for postNuke/Zikula) => Topic started by: PacketDropped on November 03, 2006, 12:55:31 AM

Title: Postnuke URL to show top rated and most viewed coppermine pages?
Post by: PacketDropped on November 03, 2006, 12:55:31 AM

Hi,

I'd like to add a menu entry on my postnuke site allowing a link
into my pnCPG showing top rated , most viewed photos, etc. What
are the URL arguments needed to show those links?

TIA, PD

Title: Re: Postnuke URL to show top rated and most viewed coppermine pages?
Post by: casNuy on November 04, 2006, 04:19:32 PM
You can use the blocks to enable that function.

Cas
Title: Re: Postnuke URL to show top rated and most viewed coppermine pages?
Post by: PacketDropped on November 04, 2006, 06:36:04 PM

Hi Cas,

I did not understand this? A pnCPG block?

Thanks.

Title: Re: Postnuke URL to show top rated and most viewed coppermine pages?
Post by: casNuy on November 07, 2006, 09:36:22 PM
If you downloaded pnCPG, you also get a number of Postnuke blocks which handle this functonality.
Go to admin/blocks (insied Postnuke) and add a pnCPG block.

Cas
Title: Re: Postnuke URL to show top rated and most viewed coppermine pages?
Post by: PacketDropped on November 13, 2006, 10:38:53 PM

Hi Cas,

Top Rated is not one of the blocks listed. Is it possible to request by a postnuke
URL ?

Thanks, PD
Title: Re: Postnuke URL to show top rated and most viewed coppermine pages?
Post by: PacketDropped on November 14, 2006, 11:48:58 PM
Hi Cas,

I've gone back and looked at the blocks in pnCPG. Only one block is named as
though targeted to the logged in user (Scroll Your Coppermine Pictures). I'd like
to create my own block to allow me to show only the the Albums or pictures  or
top-rated pics from the logged in user.  Are there any other custom pnCPG
blocks like this available..ie donated back to pnCPG? Is there a description
of the pnCPG or Coppermine schema somewhere.  I explored and believe I
see the linkage between some of the tables.

select a.owner_id,a.owner_name,a.pid,a.aid,a.pwidth,a.pheight,b.title 
from cpg_v1_pictures as a, cpg_v1_albums as b where a.owner_id='9'
and a.aid=b.aid ;

This query appears to give me name, pictures and albums for a user. Am I
missing anything here?

Thanks, PD
Title: Re: Postnuke URL to show top rated and most viewed coppermine pages?
Post by: casNuy on November 28, 2006, 11:42:09 AM
This looks good enough to me, all you need to do is to extract the correct userid and you are in business.
Cas