Print

[mahiraminc]

Hi, I'd like to accomplish the following but here are few facts about my setup:

I run VB3.07 integerated with CPG... that works flawlessly Now, I have users creating galleries in CPG and I'd like to display the list of their albums on their VB Profile Page. I'd like to know...

What query/code can I insert into my Vb MEMBERINFO template to pull a list of the user albums.

Any help will be outmost appreciated!

I also apologize for posting this question if it was already answered. I search the forum and didn't find anything. This forum has really been slow today so that could be a reason if anything.

Thanks again!

[Joachim Müller]

you better post this question on the vb support boards then, as it would take knowledge of the vb code to accomplish what you're requesting. We (the coppermine dev team) have no idea how vb works.

[Nibbler]

Code: [Select]

SELECT * FROM cpg_albums WHERE category = 10000 + userid
That will retrieve all the user's 'user gallery' albums, replace cpg_ with the coppermine tablename prefix you chose during installation, and userid with the userid token of vb.