Topic: CpmFetch 1.4 On... Displaying data and images from CPG on your website (Read 970992 times)

vuud · « **Reply #940 on:** July 27, 2006, 06:07:24 am »

Quote from: stuarta on July 26, 2006, 06:23:36 pm

ok pm'd u.

Your bridged with something. It's a well known problem. Basically, cpmfetch is looking for user information and its not there since it is in the forum database instead.

There are some posted solutions in the forums here, but essentially you need to yank all the information out of the sql statements that look up user info.

Or

Create the same number of users in your cpg forum that you have in the other forum

Or

wait an indeterminant amount of time for me to start sorting out how to handle this in the next next version.

One of those, but that is definately your problem.

stuarta · « **Reply #941 on:** July 27, 2006, 02:57:33 pm »

ok I've turned off the bridge and it appears to be working.

One last thing, how can I fix the depth of the tables. At the moment it's pulling out 4 images, but depth depends on how many lines of text is there. I could possibly just fix the table depth to a certain pixel in Dreamweaver

vuud · « **Reply #942 on:** July 27, 2006, 03:43:47 pm »

Quote from: stuarta on July 27, 2006, 02:57:33 pm

ok I've turned off the bridge and it appears to be working.

One last thing, how can I fix the depth of the tables. At the moment it's pulling out 4 images, but depth depends on how many lines of text is there. I could possibly just fix the table depth to a certain pixel in Dreamweaver

No idea on this one... there is no provision to truncate the text or anything. Sorry

stuarta · « **Reply #943 on:** July 27, 2006, 04:12:51 pm »

that's ok. thanks anyway for all your help

stuarta · « **Reply #944 on:** July 28, 2006, 10:53:48 am »

Code: [Select]

Your bridged with something.  It's a well known problem.  Basically, cpmfetch is looking for user information and its not there since it is in the forum database instead. 

There are some posted solutions in the forums here, but essentially you need to yank all the information out of the sql statements that look up user info.  

Or 

Create the same number of users in your cpg forum that you have in the other forum

Ok everything done now, just looking at solving this problem. I've rebridged and getting the same sort of problem where it's not picking up individual albums.

The user list in the gallery and forum has the same amount of users.

Been looking for solutions but not 100% sure of the error that I'm looking for

vuud · « **Reply #945 on:** July 28, 2006, 04:04:11 pm »

Quote from: stuarta on July 28, 2006, 10:53:48 am

Code: [Select]
Your bridged with something. It's a well known problem. Basically, cpmfetch is looking for user information and its not there since it is in the forum database instead. There are some posted solutions in the forums here, but essentially you need to yank all the information out of the sql statements that look up user info. Or Create the same number of users in your cpg forum that you have in the other forum
Ok everything done now, just looking at solving this problem. I've rebridged and getting the same sort of problem where it's not picking up individual albums.

The user list in the gallery and forum has the same amount of users.

Been looking for solutions but not 100% sure of the error that I'm looking for

Here is what I would do... Find a photo that you should be getting but are not. Look in the pictures table and get the owners id. Then look that up in your users and make sure it exists. If one is missing then that could be something.

Basically that is what is probably happening... the picture table has user id's that can't be found in the cpg user table (because its bridged).

At least thats my experience

stuarta · « **Reply #946 on:** July 28, 2006, 04:14:04 pm »

pics were uploaded by myself though had have same username on both, that's what's odd

vuud · « **Reply #947 on:** July 28, 2006, 04:20:29 pm »

Quote from: stuarta on July 28, 2006, 04:14:04 pm

pics were uploaded by myself though had have same username on both, that's what's odd

Username does not matter. Each has a number assigned to the name. The number is what matters

stuarta · « **Reply #948 on:** July 28, 2006, 04:36:47 pm »

ok completely confused now. think i may forget the bridging.

My user id for Stuart in the forums is "1", which is also my admin username and was the only username that I had in coppermine. All the albums were created with this user.

vuud · « **Reply #949 on:** July 28, 2006, 05:49:14 pm »

Quote from: stuarta on July 28, 2006, 04:36:47 pm

ok completely confused now. think i may forget the bridging.

My user id for Stuart in the forums is "1", which is also my admin username and was the only username that I had in coppermine. All the albums were created with this user.

I don't know. If you can tell me what picture should be coming up, the code and page it is trying from and email me the access information again, I can take another look tonight.

stuarta · « **Reply #950 on:** July 28, 2006, 05:55:32 pm »

That's ok, switched off the bridging for now and about to leave work and go home and chill over the weekend lol

My brain fried ere trying to do private work and getting stupid requests from staff when they printer or pc won't work lol

Thanks anyway Vuud, have good weekend

stuarta · « **Reply #951 on:** July 31, 2006, 05:13:42 pm »

right sorry only me again with an option query.

Is it possible to show ratings for an image and/or get people to rate it from the thumbnail in a random display.

I'm using

Code: [Select]

$options = array('subtitle'=>'%t by %o',"cellstyle" => "copyright" );
$objCpm->cpm_viewRandomMediaFrom(1,1,"album=7",$options);

on this page. Its an album for a screenshot competition. Would like to show ratings or stars below it. I've tried various things with no joy

http://www.simaviatorsuk.co.uk.streamlinenettrial.co.uk/home.php

vuud · « **Reply #952 on:** July 31, 2006, 05:38:10 pm »

Quote from: stuarta on July 31, 2006, 05:13:42 pm

right sorry only me again with an option query.

Is it possible to show ratings for an image and/or get people to rate it from the thumbnail in a random display.

I'm using

Code: [Select]
$options = array('subtitle'=>'%t by %o',"cellstyle" => "copyright" ); $objCpm->cpm_viewRandomMediaFrom(1,1,"album=7",$options);
on this page. Its an album for a screenshot competition. Would like to show ratings or stars below it. I've tried various things with no joy

http://www.simaviatorsuk.co.uk.streamlinenettrial.co.uk/home.php

I suspected we'd not heard the last from you.
http://www.fistfullofcode.com/projects/copperminefetch/manual/ch06s03.html
--------------------------------------------------

%v - total number of votes cast for this photo
%V - the current rating in number of stars to one decimal place

There is no way through my code to cast a vote from the thumbnail - they can click on it and go to the gallery and then cast a vote there. I'd include some instructions telling them to do this.

Otherwise, maybe some custom PHP in there to increment the vote counter or something... I dunno

stuarta · « **Reply #953 on:** July 31, 2006, 05:44:37 pm »

Quote

I suspected we'd not heard the last from you.

nice

Tried that on

Code: [Select]

$options = array('subtitle'=>'%V,%t by %o',"cellstyle" => "copyright" );
assume it just returns number and not stars

vuud · « **Reply #954 on:** July 31, 2006, 05:51:42 pm »

Quote from: stuarta on July 31, 2006, 05:44:37 pm

nice

Tried that on

Code: [Select]
$options = array('subtitle'=>'%V,%t by %o',"cellstyle" => "copyright" );
assume it just returns number and not stars

Right you are! Inserting images of stars in there would be a headache for layout and formatting and stuff. May be an option someday since the stars come with cpg... but for now... nope.

You could do:

'subtitle'=>'Rated %V out of 5<br>%t by %o'

A little nicer, but still no stars

stuarta · « **Reply #955 on:** July 31, 2006, 06:10:07 pm »

ok got

Code: [Select]

$options = array('subtitle'=>'Rated %V out of 5 %t by %o',"cellstyle" => "copyright" );
$objCpm->cpm_viewRandomMediaFrom(1,1,"album=7",$options);

on one column, but now the following one with

Code: [Select]

$options = array('%t by %o',"cellstyle" => "copyright" );
$objCpm->cpm_viewLastAddedMedia(4,1,$options);
$objCpm->cpm_close();

returns nothing

vuud · « **Reply #956 on:** July 31, 2006, 06:40:03 pm »

Quote from: stuarta on July 31, 2006, 06:10:07 pm

ok got

Code: [Select]
$options = array('subtitle'=>'Rated %V out of 5 %t by %o',"cellstyle" => "copyright" ); $objCpm->cpm_viewRandomMediaFrom(1,1,"album=7",$options);
on one column, but now the following one with

Code: [Select]
$options = array('%t by %o',"cellstyle" => "copyright" ); $objCpm->cpm_viewLastAddedMedia(4,1,$options); $objCpm->cpm_close();
returns nothing

There is an obvious error. Please check it over carefully.

Please check carefully before posting.

twofer · « **Reply #957 on:** August 01, 2006, 04:41:14 pm »

When I run cftest.php I'm getting this:

Code: [Select]

5 You set your partial URL to /pics PASS 
10 No dots in partial url PASS 
15 coppermine.php not present PASS 
20 coppermine_dao.php not present PASS 
25 cpmfetch.php found PASS 
30 cpmfetch_dao.php found PASS 
35 Server OS = Linux linhost133.prod.mesa1.secureserver.net 2.4.21-27.ELsmp #1 SMP Wed Dec 1 21:59:02 EST 2004 i686 INFO 
40 WebServer = Apache INFO 
45 PHP Version = 4.3.11 INFO 
55 DOCUMENT_ROOT: /home/content/t/w/o/twotrackbrewing/html INFO 
60 C_DOCUMENT_ROOT: Not found INFO 
65 doc_root: Not found (IIS Servers only) INFO 
70 SCRIPT_FILENAME: /cgi-bin/php INFO 
75 DOCUMENT_ROOT is not a good match BAD 
80 Found CPG config file PASS

The thumbnails do not end up getting displayed and I am using the default prefixes for image files. Any ideas?

TIA

vuud · « **Reply #958 on:** August 01, 2006, 05:16:07 pm »

Quote from: twofer on August 01, 2006, 04:41:14 pm

When I run cftest.php I'm getting this:

Code: [Select]
5 You set your partial URL to /pics PASS 10 No dots in partial url PASS 15 coppermine.php not present PASS 20 coppermine_dao.php not present PASS 25 cpmfetch.php found PASS 30 cpmfetch_dao.php found PASS 35 Server OS = Linux linhost133.prod.mesa1.secureserver.net 2.4.21-27.ELsmp #1 SMP Wed Dec 1 21:59:02 EST 2004 i686 INFO 40 WebServer = Apache INFO 45 PHP Version = 4.3.11 INFO 55 DOCUMENT_ROOT: /home/content/t/w/o/twotrackbrewing/html INFO 60 C_DOCUMENT_ROOT: Not found INFO 65 doc_root: Not found (IIS Servers only) INFO 70 SCRIPT_FILENAME: /cgi-bin/php INFO 75 DOCUMENT_ROOT is not a good match BAD 80 Found CPG config file PASS
The thumbnails do not end up getting displayed and I am using the default prefixes for image files. Any ideas?

TIA

Are you bridging coppermine to something, like SMF, PhpBB, etc, etc... If so, search this thread for the problem and solutions to this.

Your document root is also pretty different from your script_filename variable... Where did you put cpmfetch?

twofer · « **Reply #959 on:** August 01, 2006, 08:06:23 pm »

I'm bridging it to SMF and I did comment out line 54 and uncomment 59 but I'm still having this problem.

I placed the cpmfetch folder in the root so it's /cpmfetch.

News:

Author Topic: CpmFetch 1.4 On... Displaying data and images from CPG on your website (Read 970992 times)