Postnuke URL to show top rated and most viewed coppermine pages?

[PacketDropped]

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

[casNuy]

You can use the blocks to enable that function.

Cas

[PacketDropped]

Hi Cas,

I did not understand this? A pnCPG block?

Thanks.

[casNuy]

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

[PacketDropped]

Hi Cas,

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

Thanks, PD

[PacketDropped]

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

[casNuy]

This looks good enough to me, all you need to do is to extract the correct userid and you are in business.
Cas