CpmFetch 1.4 On... Displaying data and images from CPG on your website

[deejaymoni]

Hey I found out how CPMFETCH can work on the latest CPG.

Remove all the */ and the /* from line 54 to 59.  It should look like this

Code Select Expand

var $topPercentForMostViewed = 25;

// This is for CPG versions prior to 1.4
var $sqlPictureAlbumSelect = ' p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_name AS pOwner_name, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, a.title AS aTitle, a.description AS aDescription, p.pid AS pPid, p.pic_rating AS pPic_Rating,  p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, u.user_lastvisit AS uUser_lastvisit, u.user_regdate AS uUser_regdate, u.user_email AS uUser_email, u.user_website AS uUser_website, u.user_location AS uUser_location, u.user_interests AS uUser_interest, u.user_occupation AS uUser_occupation';


// This is for CPG v 1.4.1 beta 1

var $sqlPictureAlbumSelect = ' p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_name AS pOwner_name, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, a.title AS aTitle, a.description AS aDescription, p.pid AS pPid, p.pic_rating AS pPic_Rating,  p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, u.user_lastvisit AS uUser_lastvisit, u.user_regdate AS uUser_regdate, u.user_email AS uUser_email';




I did it and it work perfectly now

You are the man it works as well with cpg 1.4.3 bridged with phpbb Plus 1.5

thanks a lot

[n3n]

Tnx for the reply.

Could you tell me where the "html" gets spitted out with the thumb. Maybe i can add a transparant image there.
I tried with the CSS positioning, but then the image gets placed BEHIND the thumb, so that wasnt very useful
And is it possible to change the size of the thumbs ?

[vuud]

You are the man it works as well with cpg 1.4.3 bridged with phpbb Plus 1.5

thanks a lot

It would be worth adding that the instructions have you comment out the old one.  See the instructions included with cpmfetch.

While it wont cause a problem now, in the future depending - it might

[vuud]

Tnx for the reply.

Could you tell me where the "html" gets spitted out with the thumb. Maybe i can add a transparant image there.
I tried with the CSS positioning, but then the image gets placed BEHIND the thumb, so that wasnt very useful
And is it possible to change the size of the thumbs ?

Doesnt CSS layouts have something with a Z-plane layering?  That would control if its behind or above.

You can override and force the thumbs to stretch with the imageheight or imagewidth option array attributed.  Mind you this only instructs the browser to resize them.

Image tags get spit out from about line 1377 in cpmfetch.php

Hope that helps

[apassio]

Just installed CpmFetch 1.6.2 and I get an error message while running http://www.dophan.com/cpmfetch/cftest.php

Code Select Expand

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dophan2/public_html/cpmfetch/cpmfetch_dao.php on line 710

I run CPG 1.4.3.

Website: http://www.dophan.com
Coppermine gallery: http://www.dophan.com/photos/

Did I overlook something?

[vuud]

Just installed CpmFetch 1.6.2 and I get an error message while running http://www.dophan.com/cpmfetch/cftest.php

Code Select Expand

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dophan2/public_html/cpmfetch/cpmfetch_dao.php on line 710

I run CPG 1.4.3.

Website: http://www.dophan.com
Coppermine gallery: http://www.dophan.com/photos/

Did I overlook something?

Your not getting a "Unknown column 'u.user_website' in 'field list'" right above it by any chance?

Look in the releasenotes that came with 1.6.2 for what to do when running the beta

That will fix your problem.

[apassio]

Done, fixed, cftest.php runs ok now.

Thanks

[snork13]

Any ideas on my question vuud ? if you have the time.

<div style="width:190px;background-image:url(http://media.threadless.com/product/146/smallphoto.jpg);"><a href="/product/146/Saint" onmouseover="photoSwap('so146','http://media.threadless.com/imgs/soldout-r.gif')" onmouseout="photoSwap('so146','http://media.threadless.com/imgs/soldout.gif')"><img name="so146" src="http://media.threadless.com/imgs/soldout.gif" width="190" height="136"></div>

javascript

[dukuduku]

The docs are full of lies I tell you.  I hate the docs more than most of the things I hate.  And thats a lot.

Anyway, if you are on a completely different domain, you can access if using the SSI techniques that seem to work the best.  Sometimes you can call it from PHP...  The big thing is to have it working on the server you have CPG on and then start trying to remotely get data.  See the SSI thread for some more ideas on it.

Hope that helps some

Hey, at least you HAVE docs!  And lies are easily changed to... non-lies.  (I was going to say truths, but that is getting a bit too philosophical!)

I think going the SSI route is not worth the investment for me at this point.  I will probably just move coppermine and the gigs of pictures to the temporary server as we are still somewhat under development.

Cheers,
dukuduku

[vuud]

Hey, at least you HAVE docs!  And lies are easily changed to... non-lies.  (I was going to say truths, but that is getting a bit too philosophical!)

I think going the SSI route is not worth the investment for me at this point.  I will probably just move coppermine and the gigs of pictures to the temporary server as we are still somewhat under development.

Cheers,
dukuduku

Nope, the lies shall remain lies.  Except for a chosen few.  They shall become damned lies.

[martyn_c]

Hi all,

Solved my problem now - didn't fully read what i needed to do from the suggestions already posted.

Hence I can confirm that the following modifications will enable cpmfetch1.6.2 to work with cpm1.4.3 bridged to phpbb2.0.19.


>Open cpmfetch_dao.php
>Comment out line 57
>Remove comments from around line 62 (As per the instructions in the release notes!)

>Find:

Code Select Expand

$this->sqlPictureSourceSelect = " " . $database_table_prefix . "pictures as p, " . $database_table_prefix . "albums as a, "
. $database_table_prefix . "users AS u ";

>Replace with:

Code Select Expand

$this->sqlPictureSourceSelect = " " . $database_table_prefix . "pictures as p, " . $database_table_prefix . "albums as a, "
. $database_table_prefix . "users AS u , phpbb_users AS phpbb ";
(If your phpbb database tables have a different prefix than 'phpbb_' then change the phpbb_users as needed to use the same prefix as your phpbb database tables use.)

>Find every occurance of u.user_id and change it to phpbb.user_id. (This is the step I failed to read!)
>Save cpmfetch_dao.php and then try cftest.php.


Many thanks to all - just thought it would be good to present the entire solution in one place - hopefully i've not made a mistake in trying to remember what i did to make it all work together!

Keep up the good work - loving this addon to Coppermine!

[imrich]

Hi all,

Solved my problem now - didn't fully read what i needed to do from the suggestions already posted.

Hence I can confirm that the following modifications will enable cpmfetch1.6.2 to work with cpm1.4.3 bridged to phpbb2.0.19.


>Open cpmfetch_dao.php
>Comment out line 57
>Remove comments from around line 62 (As per the instructions in the release notes!)

>Find:

Code Select Expand

$this->sqlPictureSourceSelect = " " . $database_table_prefix . "pictures as p, " . $database_table_prefix . "albums as a, "
. $database_table_prefix . "users AS u ";

>Replace with:

Code Select Expand

$this->sqlPictureSourceSelect = " " . $database_table_prefix . "pictures as p, " . $database_table_prefix . "albums as a, "
. $database_table_prefix . "users AS u , phpbb_users AS phpbb ";
(If your phpbb database tables have a different prefix than 'phpbb_' then change the phpbb_users as needed to use the same prefix as your phpbb database tables use.)

>Find every occurance of u.user_id and change it to phpbb.user_id. (This is the step I failed to read!)
>Save cpmfetch_dao.php and then try cftest.php.


Many thanks to all - just thought it would be good to present the entire solution in one place - hopefully i've not made a mistake in trying to remember what i did to make it all work together!

Keep up the good work - loving this addon to Coppermine!

Yes, this is just what I did to get CpmFetch to work with PHPBB 2.0.18 and 2.0.19. Thanks for confirming this to the group! I'm sure this will help others too. It may want to be it's own thread!

[vuud]

Yes, this is just what I did to get CpmFetch to work with PHPBB 2.0.18 and 2.0.19. Thanks for confirming this to the group! I'm sure this will help others too. It may want to be it's own thread!

The test version I have here can detect when cpg is officially bridged to something else.  If everyone who is running a bridge can send me the table format for the userid I will work it out so some of the data becomes available.

Otherwise, for the ones I don't have data for I will just ignore the other db, and things will work, but username and stuff will not be available.

Vuud

[imrich]

If everyone who is running a bridge can send me the table format for the userid I will work it out so some of the data becomes available.

Is this what you need?

This is from phpbb 2.0.19

Code Select Expand


CREATE TABLE `phpbb_users` (
  `user_id` mediumint(8) NOT NULL default '0',
  `user_active` tinyint(1) default '1',
  `username` varchar(25) NOT NULL default '',
  `user_password` varchar(32) NOT NULL default '',
  `user_session_time` int(11) NOT NULL default '0',
  `user_session_page` smallint(5) NOT NULL default '0',
  `user_lastvisit` int(11) NOT NULL default '0',
  `user_regdate` int(11) NOT NULL default '0',
  `user_level` tinyint(4) default '0',
  `user_posts` mediumint(8) unsigned NOT NULL default '0',
  `user_timezone` decimal(5,2) NOT NULL default '0.00',
  `user_style` tinyint(4) default NULL,
  `user_lang` varchar(255) default NULL,
  `user_dateformat` varchar(14) NOT NULL default 'd M Y H:i',
  `user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_last_privmsg` int(11) NOT NULL default '0',
  `user_emailtime` int(11) default NULL,
  `user_viewemail` tinyint(1) default NULL,
  `user_attachsig` tinyint(1) default NULL,
  `user_allowhtml` tinyint(1) default '1',
  `user_allowbbcode` tinyint(1) default '1',
  `user_allowsmile` tinyint(1) default '1',
  `user_allowavatar` tinyint(1) NOT NULL default '1',
  `user_allow_pm` tinyint(1) NOT NULL default '1',
  `user_allow_viewonline` tinyint(1) NOT NULL default '1',
  `user_notify` tinyint(1) NOT NULL default '1',
  `user_notify_pm` tinyint(1) NOT NULL default '0',
  `user_popup_pm` tinyint(1) NOT NULL default '0',
  `user_rank` int(11) default '0',
  `user_avatar` varchar(100) default NULL,
  `user_avatar_type` tinyint(4) NOT NULL default '0',
  `user_email` varchar(255) default NULL,
  `user_icq` varchar(15) default NULL,
  `user_website` varchar(100) default NULL,
  `user_from` varchar(100) default NULL,
  `user_sig` text,
  `user_sig_bbcode_uid` varchar(10) default NULL,
  `user_aim` varchar(255) default NULL,
  `user_yim` varchar(255) default NULL,
  `user_msnm` varchar(255) default NULL,
  `user_occ` varchar(100) default NULL,
  `user_interests` varchar(255) default NULL,
  `user_actkey` varchar(32) default NULL,
  `user_newpasswd` varchar(32) default NULL,
  `user_login_tries` smallint(5) unsigned NOT NULL default '0',
  `user_last_login_try` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`),
  KEY `user_session_time` (`user_session_time`)
) TYPE=MyISAM;


I hope this helps you.

[vuud]

Is this what you need?

This is from phpbb 2.0.19

Code Select Expand


CREATE TABLE `phpbb_users` (
  `user_id` mediumint(8) NOT NULL default '0',
  `user_active` tinyint(1) default '1',
  `username` varchar(25) NOT NULL default '',
  `user_password` varchar(32) NOT NULL default '',
  `user_session_time` int(11) NOT NULL default '0',
  `user_session_page` smallint(5) NOT NULL default '0',
  `user_lastvisit` int(11) NOT NULL default '0',
  `user_regdate` int(11) NOT NULL default '0',
  `user_level` tinyint(4) default '0',
  `user_posts` mediumint(8) unsigned NOT NULL default '0',
  `user_timezone` decimal(5,2) NOT NULL default '0.00',
  `user_style` tinyint(4) default NULL,
  `user_lang` varchar(255) default NULL,
  `user_dateformat` varchar(14) NOT NULL default 'd M Y H:i',
  `user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_last_privmsg` int(11) NOT NULL default '0',
  `user_emailtime` int(11) default NULL,
  `user_viewemail` tinyint(1) default NULL,
  `user_attachsig` tinyint(1) default NULL,
  `user_allowhtml` tinyint(1) default '1',
  `user_allowbbcode` tinyint(1) default '1',
  `user_allowsmile` tinyint(1) default '1',
  `user_allowavatar` tinyint(1) NOT NULL default '1',
  `user_allow_pm` tinyint(1) NOT NULL default '1',
  `user_allow_viewonline` tinyint(1) NOT NULL default '1',
  `user_notify` tinyint(1) NOT NULL default '1',
  `user_notify_pm` tinyint(1) NOT NULL default '0',
  `user_popup_pm` tinyint(1) NOT NULL default '0',
  `user_rank` int(11) default '0',
  `user_avatar` varchar(100) default NULL,
  `user_avatar_type` tinyint(4) NOT NULL default '0',
  `user_email` varchar(255) default NULL,
  `user_icq` varchar(15) default NULL,
  `user_website` varchar(100) default NULL,
  `user_from` varchar(100) default NULL,
  `user_sig` text,
  `user_sig_bbcode_uid` varchar(10) default NULL,
  `user_aim` varchar(255) default NULL,
  `user_yim` varchar(255) default NULL,
  `user_msnm` varchar(255) default NULL,
  `user_occ` varchar(100) default NULL,
  `user_interests` varchar(255) default NULL,
  `user_actkey` varchar(32) default NULL,
  `user_newpasswd` varchar(32) default NULL,
  `user_login_tries` smallint(5) unsigned NOT NULL default '0',
  `user_last_login_try` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`),
  KEY `user_session_time` (`user_session_time`)
) TYPE=MyISAM;


I hope this helps you.

Actually yes - thats it exactly.  Thanks!

Okay, so thats phpbb down... I still need one from:

invisionboard
vbulletin23
vbulletin30
yabbse
woltlab21
punbb

I have SMF so I can get that.  Maybe also vbulletin30, but I am not sure.

Thanks for the help

[Pete77s]

Hi all,

Solved my problem now - didn't fully read what i needed to do from the suggestions already posted.

Hence I can confirm that the following modifications will enable cpmfetch1.6.2 to work with cpm1.4.3 bridged to phpbb2.0.19.


>Open cpmfetch_dao.php
>Comment out line 57
>Remove comments from around line 62 (As per the instructions in the release notes!)

>Find:

Code Select Expand

$this->sqlPictureSourceSelect = " " . $database_table_prefix . "pictures as p, " . $database_table_prefix . "albums as a, "
. $database_table_prefix . "users AS u ";

>Replace with:

Code Select Expand

$this->sqlPictureSourceSelect = " " . $database_table_prefix . "pictures as p, " . $database_table_prefix . "albums as a, "
. $database_table_prefix . "users AS u , phpbb_users AS phpbb ";
(If your phpbb database tables have a different prefix than 'phpbb_' then change the phpbb_users as needed to use the same prefix as your phpbb database tables use.)

>Find every occurance of u.user_id and change it to phpbb.user_id. (This is the step I failed to read!)
>Save cpmfetch_dao.php and then try cftest.php.


Many thanks to all - just thought it would be good to present the entire solution in one place - hopefully i've not made a mistake in trying to remember what i did to make it all work together!

Keep up the good work - loving this addon to Coppermine!

Hi, after doing the above, I ran the cftest.php and had green pass. so i guess I did something right. expect im still getting errors.. and I clicked on ranndom.php and get all sorts of erros too.

by saying to remove  line 62 and 57 do you mean the whole part? or just that spesific line?

whole part I mean this: ( line 62)
// This is for CPG v 1.4.1 beta 1   
/*
   var $sqlPictureAlbumSelect = ' p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_name AS pOwner_name, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, a.title AS aTitle, a.description AS aDescription, p.pid AS pPid, p.pic_rating AS pPic_Rating,  p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, u.user_lastvisit AS uUser_lastvisit, u.user_regdate AS uUser_regdate, u.user_email AS uUser_email';
*/

[imrich]

Pete,

What is means is to find this code:

Code Select Expand


// This is for CPG versions prior to 1.4
var $sqlPictureAlbumSelect = ' p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_name AS pOwner_name, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, a.title AS aTitle, a.description AS aDescription, p.pid AS pPid, p.pic_rating AS pPic_Rating,  p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, u.user_lastvisit AS uUser_lastvisit, u.user_regdate AS uUser_regdate, u.user_email AS uUser_email, u.user_website AS uUser_website, u.user_location AS uUser_location, u.user_interests AS uUser_interest, u.user_occupation AS uUser_occupation';



and change it to this:

Code Select Expand


// This is for CPG versions prior to 1.4
/*
var $sqlPictureAlbumSelect = ' p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_name AS pOwner_name, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, a.title AS aTitle, a.description AS aDescription, p.pid AS pPid, p.pic_rating AS pPic_Rating,  p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, u.user_lastvisit AS uUser_lastvisit, u.user_regdate AS uUser_regdate, u.user_email AS uUser_email, u.user_website AS uUser_website, u.user_location AS uUser_location, u.user_interests AS uUser_interest, u.user_occupation AS uUser_occupation';
*/


THEN

Find the lines:

Code Select Expand


// This is for CPG v 1.4.1 beta 1
/*
var $sqlPictureAlbumSelect = ' p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_name AS pOwner_name, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, a.title AS aTitle, a.description AS aDescription, p.pid AS pPid, p.pic_rating AS pPic_Rating,  p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, u.user_lastvisit AS uUser_lastvisit, u.user_regdate AS uUser_regdate, u.user_email AS uUser_email';
*/


and change it to this:

Code Select Expand


// This is for CPG v 1.4.1 beta 1
var $sqlPictureAlbumSelect = ' p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_name AS pOwner_name, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, a.title AS aTitle, a.description AS aDescription, p.pid AS pPid, p.pic_rating AS pPic_Rating,  p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, u.user_lastvisit AS uUser_lastvisit, u.user_regdate AS uUser_regdate, u.user_email AS uUser_email';


So you are turning off the first bit of code by turning it into a comment
and then you are enabling the second  bit of code by removing the start and end comment delimiters.

The actual instructions for doing this are in the release notes, this is what it says:

CODE: QUICKFIX FOR PEOPLE WANTING TO USE CPG BETA 1.4.1
(SAME NOTE AS RELEASE 1.6.0)
========================================
The Coppermine Dev's have (in what I would would say was a logical move) changed some of the internal database structure, and replaced a few fields with generic fields.  So instead of user web site, you have a few placeholder fields you can define into anything you want.  This of course breaks a bit of my code and stops CpmFetch from working.  I am going to work out a permanent solution, but for the short term, if you really want to use CPG BETA 1.4.1 (and the dev's would appreciate you doing so, so would I) you must edit the top of the cpmfetch_dao.php file.  There are two sections around line 54 and line 59.  You need to comment out the one at line 54, and uncomment the one at line 59.  Comment it by placing /* before it and */ after it.  Uncomment by removing the same from the other section.  If you are on a version prior to 1.4 you DO NOT NEED TO DO ANYTHING.

I hope to have a development version out in a few days to permanently address this change.

Does this help at all?

[SpoiledMutts_Com]

I am having problems showing all pics (regardless if random or latest) from all albums in a category.  I would actually like to show all the latests pics that are public.  I am running the latest stable versions of everthing, here is the code I have used.  It coppermine is bridged with SMF, I have tried all the commented lines but regardless of which I use it only shows the first album made in the category (there are only 2 categories).

Code Select Expand

echo '<div align="right">';
include "/var/www/html/photogallery/ssi/cpmfetch/cpmfetch.php";
$objCpm = new cpm("/photogallery");
//$objCpm->cpm_viewRandomMedia(5,1);
//$objCpm->cpm_viewLastAddedMedia (5,1);
//$objCpm->cpm_viewLastAddedMediaFrom (5,1, "cat=1");
//$objCpm->cpm_viewLastAddedMediaFromCategory (5, 1, 1);
//$objCpm->cpm_viewRandomMediaFrom(5,1,"cat=1");
$objCpm->cpm_viewLastAddedMediaFromCategory(18,1,2);
$objCpm->cpm_close();
echo '</div>';

Like I said, I have tried all the commented out ways, I get pics but only from the first album created in those categories.  I am wanting to show all latest pics in all public categories.  Thanks for any help.

[reSet]

Dear CPG peoples!
I've been searching the forum for an hour without success

my name is reSet Sakrecoer and i've been using your softwar for some time now.
I just installed a cpg 1.4.3 to our server on barcelona_hq.micromusic.net
it works brilliant i love all the new features!

Still one thing bothers me, in 1.3, coppermine used quicktime to display mp3's, now aday its microsoft Mplayer.
Since the Microsoft player is completley out of control on macintoshs, i realy wonder why you chose this. Quicktime works the same on any station? see i'm no wizz about best compression and best thhis or that... i timidely think "compatibilty"

Now i've noticed some people get mad when peoples are requesting about other features than picture related, and i hope i wont bother them. But i would love to know how i can make it use the quictime player again

[vuud]

Dear CPG peoples!
I've been searching the forum for an hour without success

my name is reSet Sakrecoer and i've been using your softwar for some time now.
I just installed a cpg 1.4.3 to our server on barcelona_hq.micromusic.net
it works brilliant i love all the new features!

Still one thing bothers me, in 1.3, coppermine used quicktime to display mp3's, now aday its microsoft Mplayer.
Since the Microsoft player is completley out of control on macintoshs, i realy wonder why you chose this. Quicktime works the same on any station? see i'm no wizz about best compression and best thhis or that... i timidely think "compatibilty"

Now i've noticed some people get mad when peoples are requesting about other features than picture related, and i hope i wont bother them. But i would love to know how i can make it use the quictime player again

Are you talking about CPMFETCH of Coppermine Photo Gallery?

You could be in the wrong forum