coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 (BBS) Integration / Bridging => Topic started by: mahiraminc on July 07, 2005, 03:12:52 AM

Title: Displaying user galleries from Coppermine on Vbulletin's member profile page
Post by: mahiraminc on July 07, 2005, 03:12:52 AM
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!
Title: Re: Displaying user galleries from Coppermine on Vbulletin's member profile page
Post by: Joachim Müller on July 07, 2005, 10:41:54 AM
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.
Title: Re: Displaying user galleries from Coppermine on Vbulletin's member profile page
Post by: Nibbler on July 07, 2005, 08:03:20 PM
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.