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

[Hamsterpants]

Why use buggy JavaScript instead of actually pulling the content using php's include? The only thing you'll need is: your webhost on the server you're pulling from must allow url_fopen. Just try it, create a test file with this code:

Code Select Expand

<?php
include('http://mysite.tld/testpage.php');
?>

Ok Not sure if I understand, so this is what I tried.

I created a file called cmp.php in the root of the site that I want to get the images from (file contents):

<?php  
         include "./cpmfetch/cpmfetch.php";
         $objCpm = new cpm("/photoalbum");
         #$objCpm->cpm_viewRandomMedia(5,1);
         #$objCpm->cpm_viewMostVotedMedia(1,1);
         #$objCpm->cpm_viewRandomMostVotedMediaFrom("",5,1);
         #$objCpm->cpm_viewTopRatedMediaFrom("",5,1,array("alttag" => "filename: %f, voted %V of 5 (%v votes)"));
         
         $styleguide = array(
            "linkstyle" => "topratedlink",
            "alttag" => "voted: %V",
            "subtitle" => "voted: %V",
            "imagestyle" => "topratedimg",
            "tdstyle" => "admin_menu",
            "imagesize" => 'thumb');
            
            $objCpm->cpm_setReturnType('print');
            $data = $objCpm->cpm_viewTopRatedMediaFrom ("", 5, 1, $styleguide);
            
         $objCpm->cpm_close();
         
?>

I then use a php include   include('http://www.mystaffie.com/cmp.php'); on the site that I want to display the images. It is getting the correct images but looking on the wrong domain. I have left everything as is so if you would like to have a look at what I mean:

http://www.mystaffie.com - the site I want to pull the images from
http://www.hamsterpants.com - the site I would ike to display the images on

Thanks agan for your help.

Dill

[reyn]

IIS is notorious for not populating all required server vars, which appears to be the case for your setup (no DOCUMENT_ROOT and no SCRIPT_FILENAME). Use phpinfo() to find out what server var holds the information that is needed. Have I ranted in this thread already that self-hosting is not recommended, especially on a non-server-OS ?

I should think so, definitely not the thing todo. I should have mentioned that the setup is only local and used for testing before uploading. I have changed one of the BAD lines by changing SCRIPT_FILENAME to SCRIPT_NAME apparently IIS knows nothing about the former. To see if my setup has anything todo with the errors I have uploaded to my host and run cftest.php again with the same results. Is DOCUMENT_ROOT actually used to make it work? my host's phpinfo also shows no data for doc_root. Does anyone have the code working on a IIS server? My test site is http://www.kuckoo.co.uk/cpg141 

Frank

[vuud]

IIS is notorious for not populating all required server vars, which appears to be the case for your setup (no DOCUMENT_ROOT and no SCRIPT_FILENAME). Use phpinfo() to find out what server var holds the information that is needed. Have I ranted in this thread already that self-hosting is not recommended, especially on a non-server-OS ?

Not in this thread, but I agree with you 100%. 

One person I know fixed this by adding the DOCUMENT_ROOT into the coppermine gallery config file so it was set when cpmfetch imported it.

That aside, everytime I think I found a constant variable I can use in IIS, the next person has it completely different.

I hate IIS.  Thats just my opinion, but a desktop O/S trying to be a server is just a bad idea. 

[vuud]

Your doing great...

I am on holiday, so I don't have it in front of me, but look at the docs on my web site... in the functions section there is a function named cpm_overideUrlToCoppermine or something like that.

Call that one right after the new with the FULL url to coppermine

http://www.sitename.com/photos or something like that.

Should fix what ails you

Why use buggy JavaScript instead of actually pulling the content using php's include? The only thing you'll need is: your webhost on the server you're pulling from must allow url_fopen. Just try it, create a test file with this code:

Code Select Expand

<?php
include('http://mysite.tld/testpage.php');
?>

Ok Not sure if I understand, so this is what I tried.

I created a file called cmp.php in the root of the site that I want to get the images from (file contents):

<?php 
         include "./cpmfetch/cpmfetch.php";
         $objCpm = new cpm("/photoalbum");
         #$objCpm->cpm_viewRandomMedia(5,1);
         #$objCpm->cpm_viewMostVotedMedia(1,1);
         #$objCpm->cpm_viewRandomMostVotedMediaFrom("",5,1);
         #$objCpm->cpm_viewTopRatedMediaFrom("",5,1,array("alttag" => "filename: %f, voted %V of 5 (%v votes)"));
         
         $styleguide = array(
            "linkstyle" => "topratedlink",
            "alttag" => "voted: %V",
            "subtitle" => "voted: %V",
            "imagestyle" => "topratedimg",
            "tdstyle" => "admin_menu",
            "imagesize" => 'thumb');
            
            $objCpm->cpm_setReturnType('print');
            $data = $objCpm->cpm_viewTopRatedMediaFrom ("", 5, 1, $styleguide);
            
         $objCpm->cpm_close();
         
?>

I then use a php include   include('http://www.mystaffie.com/cmp.php'); on the site that I want to display the images. It is getting the correct images but looking on the wrong domain. I have left everything as is so if you would like to have a look at what I mean:

http://www.mystaffie.com - the site I want to pull the images from
http://www.hamsterpants.com - the site I would ike to display the images on

Thanks agan for your help.

Dill

[Hamsterpants]

Hi Vuud,

I can’t tell you how much I appreciate your help, especially while on holiday . Anyways, when you get back from hols maybe you can give us some more help. I think it is my knowledge and understanding of PHP that is actually letting me down here. I found the function that you were talking about, but to be honest I am not sure how I need to use it. This is what I tried; almost feel embarrassed putting this up here. Anyways if you can point us in the right direction that would be great. Hope you enjoy your hols:

<?php  
         include "./cpmfetch/cpmfetch.php";
         $objCpm = new cpm("http://www.mystaffie.com/photoalbum");
         $objCpm->cpm_OverrideUrlToCoppermine($newpath_);

         
         $styleguide = array(
            "linkstyle" => "topratedlink",
            "alttag" => "voted: %V",
            "subtitle" => "voted: %V",
            "imagestyle" => "topratedimg",
            "tdstyle" => "admin_menu",
            "imagesize" => 'thumb');
            
            $objCpm->cpm_setReturnType('print');
            $data = $objCpm->cpm_viewTopRatedMediaFrom ("", 5, 1, $styleguide);
            
         $objCpm->cpm_close();
         
?>

Thanks
Dill
EDITED ->

Wanted to add, this is the error I receive. Plus side is although it is an error it is pointing to the correct domain:

ERROR: Path to Coppermine incorrect. (/home/mystaffi/public_htmlhttp://www.mystaffie.com/photoalbum//include/config.inc.php)

Dill

Your doing great...

I am on holiday, so I don't have it in front of me, but look at the docs on my web site... in the functions section there is a function named cpm_overideUrlToCoppermine or something like that.

Call that one right after the new with the FULL url to coppermine

http://www.sitename.com/photos or something like that.

Should fix what ails you

Why use buggy JavaScript instead of actually pulling the content using php's include? The only thing you'll need is: your webhost on the server you're pulling from must allow url_fopen. Just try it, create a test file with this code:

Code Select Expand

<?php
include('http://mysite.tld/testpage.php');
?>

Ok Not sure if I understand, so this is what I tried.

I created a file called cmp.php in the root of the site that I want to get the images from (file contents):

<?php  
         include "./cpmfetch/cpmfetch.php";
         $objCpm = new cpm("/photoalbum");
         #$objCpm->cpm_viewRandomMedia(5,1);
         #$objCpm->cpm_viewMostVotedMedia(1,1);
         #$objCpm->cpm_viewRandomMostVotedMediaFrom("",5,1);
         #$objCpm->cpm_viewTopRatedMediaFrom("",5,1,array("alttag" => "filename: %f, voted %V of 5 (%v votes)"));
         
         $styleguide = array(
            "linkstyle" => "topratedlink",
            "alttag" => "voted: %V",
            "subtitle" => "voted: %V",
            "imagestyle" => "topratedimg",
            "tdstyle" => "admin_menu",
            "imagesize" => 'thumb');
            
            $objCpm->cpm_setReturnType('print');
            $data = $objCpm->cpm_viewTopRatedMediaFrom ("", 5, 1, $styleguide);
            
         $objCpm->cpm_close();
         
?>

I then use a php include   include('http://www.mystaffie.com/cmp.php'); on the site that I want to display the images. It is getting the correct images but looking on the wrong domain. I have left everything as is so if you would like to have a look at what I mean:

http://www.mystaffie.com - the site I want to pull the images from
http://www.hamsterpants.com - the site I would ike to display the images on

Thanks agan for your help.

Dill

[vuud]

I think you mean this...

Code Select Expand


include "./cpmfetch/cpmfetch.php";
$objCpm = new cpm("/photoalbum");
$objCpm->cpm_OverrideUrlToCoppermine("http://www.mystaffie.com/photoalbum");


Keep the other lines that come after this part... just change the above to these settings

Hope that helps

<?php 
         include "./cpmfetch/cpmfetch.php";
         $objCpm = new cpm("http://www.mystaffie.com/photoalbum");
         $objCpm->cpm_OverrideUrlToCoppermine($newpath_);

    ... snip...
         
?>

[Hamsterpants]

Arr man I could just jump for joy, I was really excited when I saw your reply and tried it out right away, althou it didn't work fisrt time, had a quick look and noticed a "/" missing


$objCpm->cpm_OverrideUrlToCoppermine("http://www.mystaffie.com/photoalbum");
should be
$objCpm->cpm_OverrideUrlToCoppermine("http://www.mystaffie.com/photoalbum/");

But I am not complaining only mentioning it incase anyone else is interested in what I was trying to do.

Once again a HUGE big thankyou.

Dill

I think you mean this...

Code Select Expand


include "./cpmfetch/cpmfetch.php";
$objCpm = new cpm("/photoalbum");
$objCpm->cpm_OverrideUrlToCoppermine("http://www.mystaffie.com/photoalbum");


Keep the other lines that come after this part... just change the above to these settings

Hope that helps

<?php 
         include "./cpmfetch/cpmfetch.php";
         $objCpm = new cpm("http://www.mystaffie.com/photoalbum");
         $objCpm->cpm_OverrideUrlToCoppermine($newpath_);

    ... snip...
         
?>

[vuud]

Excellent - hopefully I will remember to add that to the docs!

Arr man I could just jump for joy, I was really excited when I saw your reply and tried it out right away, althou it didn't work fisrt time, had a quick look and noticed a "/" missing

[anika]

hi guys! im totally  new with php and i need all the help i can get

how come this code:

<?php
include "./cpmfetch/cpmfetch.php";
$objCpm = new cpm("/gallery");
$objCpm->cpm_viewRandomMedia(1,5);
$objCpm->cpm_close();?>

totally works great when my .php file is in the cpmfetch directory
and it doesnt work at all when i tried it in my http://www.site.com/index.php ?

and really need a big help with this one i cant figure it out i tried reading the .doc but nothing seems to work
can anyone show me what code to place when i want my pictures when click opens in a new browser?

hope you can help me owt 

[vuud]

Well, I was going to give you kudos for providing a link to the page with the error (which helps immensly when trying to figure out what part is not working).

I mean, picture calling a mechanic and saying "My car does not work, how much to fix it?".  Anyway I digress...

Please post a link to the cftest page, and the error you are getting and where your cpmfetch folder is installed.

Thanks

Vuud

hi guys! im totally  new with php and i need all the help i can get

how come this code:

<?php
include "./cpmfetch/cpmfetch.php";
$objCpm = new cpm("/gallery");
$objCpm->cpm_viewRandomMedia(1,5);
$objCpm->cpm_close();?>

totally works great when my .php file is in the cpmfetch directory
and it doesnt work at all when i tried it in my http://www.site.com/index.php ?

and really need a big help with this one i cant figure it out i tried reading the .doc but nothing seems to work
can anyone show me what code to place when i want my pictures when click opens in a new browser?

hope you can help me owt 

[reyn]

IIS is notorious for not populating all required server vars, which appears to be the case for your setup (no DOCUMENT_ROOT and no SCRIPT_FILENAME). Use phpinfo() to find out what server var holds the information that is needed. Have I ranted in this thread already that self-hosting is not recommended, especially on a non-server-OS ?

Not in this thread, but I agree with you 100%. 

One person I know fixed this by adding the DOCUMENT_ROOT into the coppermine gallery config file so it was set when cpmfetch imported it.

That aside, everytime I think I found a constant variable I can use in IIS, the next person has it completely different.

I hate IIS.  Thats just my opinion, but a desktop O/S trying to be a server is just a bad idea. 

Ok I give in, I have changed remote host to site5.com (unix/apache/php4/mysql4) I have also installed wampserver on my local machine. Now to see if it all comes together!

Frank

[reyn]

Ok I give in, I have changed remote host to site5.com (unix/apache/php4/mysql4) I have also installed wampserver on my local machine. Now to see if it all comes together!

I have installed cpmfetch 1.4 and 1.5 just renaming the 1.4 dir to cpmfetch_14. Made the same change to cftest.php in both versions. I now have Pass on all required lines in both versions and with 1.4 I see the thumbnails (it works). With 1.5 I see no thumbs and get this error.

Unknown column 'u.user_website' in 'field list'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in c:\wamp\www\kuckoo_couk\cpmfetch\cpmfetch_dao.php on line 686

Frank
ps: I did not realise how good the program is, clicking the thumbnails and being taken to the intermediate picture in coppermine is excellent.

[vuud]

Ok I give in, I have changed remote host to site5.com (unix/apache/php4/mysql4) I have also installed wampserver on my local machine. Now to see if it all comes together!

I have installed cpmfetch 1.4 and 1.5 just renaming the 1.4 dir to cpmfetch_14. Made the same change to cftest.php in both versions. I now have Pass on all required lines in both versions and with 1.4 I see the thumbnails (it works). With 1.5 I see no thumbs and get this error.

Unknown column 'u.user_website' in 'field list'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in c:\wamp\www\kuckoo_couk\cpmfetch\cpmfetch_dao.php on line 686

Frank
ps: I did not realise how good the program is, clicking the thumbnails and being taken to the intermediate picture in coppermine is excellent.

I think over all you will be happier with unix hosting... I had to deal with a windows web server the other day and had a horrible time of it...  But anyway...

Make sure you have version 1.5.3 from the web site... I think there was a problem with this in one of the earlier 1.5.x series
http://www.fistfullofcode.com/projects/copperminefetch/downloads.php

If that is not it, what version of cpg are you using?

Thanks

Vuud

[reyn]

Make sure you have version 1.5.3 from the web site... I think there was a problem with this in one of the earlier 1.5.x series
http://www.fistfullofcode.com/projects/copperminefetch/downloads.php

If that is not it, what version of cpg are you using?

I have cpmfetch 1.5.3 and Coppermine 1.4.1 Beta.  also  Apache 1.3.33
- MySQL 4.1.10a and  PHP4.3.11

Hope this helps you - to help me.

Thanks
Frank

[vuud]

Make sure you have version 1.5.3 from the web site... I think there was a problem with this in one of the earlier 1.5.x series
http://www.fistfullofcode.com/projects/copperminefetch/downloads.php

If that is not it, what version of cpg are you using?

I have cpmfetch 1.5.3 and Coppermine 1.4.1 Beta.  also  Apache 1.3.33
- MySQL 4.1.10a and  PHP4.3.11

Hope this helps you - to help me.

Thanks
Frank

Ah phooey.  I tried the beta awhile back, before adding the user web stuff... Ironically I was planning on upgrading my stuff to the beta's now so...

Give me a day or two and I should have resolution for you

[anika]

sorry for my newbie post..

i tried the php code in http://www.mysite.com/gallery/cpmfetch/randomimages.php
and it works great!

but when i tried it in my index page:
this is what i got when i posted the php code in the http://www.mysite.com/index.php


Warning: main(./cpmfetch.php): failed to open stream: No such file or directory in /home/nbeltran/public_html/index3.php on line 192

Warning: main(./cpmfetch.php): failed to open stream: No such file or directory in /home/nbeltran/public_html/index3.php on line 192

Warning: main(): Failed opening './cpmfetch.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/nbeltran/public_html/index3.php on line 192

Fatal error: Cannot instantiate non-existent class: cpm in /home/nbeltran/public_html/index3.php on line 193

[vuud]

sorry for my newbie post..

i tried the php code in http://www.mysite.com/gallery/cpmfetch/randomimages.php
and it works great!

but when i tried it in my index page:
this is what i got when i posted the php code in the http://www.mysite.com/index.php

Warning: main(./cpmfetch.php): failed to open stream: No such file or directory in /home/nbeltran/public_html/index3.php on line 192

Warning: main(./cpmfetch.php): failed to open stream: No such file or directory in /home/nbeltran/public_html/index3.php on line 192

Warning: main(): Failed opening './cpmfetch.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/nbeltran/public_html/index3.php on line 192

Fatal error: Cannot instantiate non-existent class: cpm in /home/nbeltran/public_html/index3.php on line 193

Part of the code you inserted in your main page is an include statement that says "./cpmfetch.php".  That is wrong now that you are in a different directory.

If the file you are using is in the same directory the cpmfetch DIRECTORY is in...  it should be "./cpmfetch/cpmfetch.php"

If we were all still using DOS, this would not be an issue

[vuud]

Make sure you have version 1.5.3 from the web site... I think there was a problem with this in one of the earlier 1.5.x series
http://www.fistfullofcode.com/projects/copperminefetch/downloads.php

If that is not it, what version of cpg are you using?

I have cpmfetch 1.5.3 and Coppermine 1.4.1 Beta.  also  Apache 1.3.33
- MySQL 4.1.10a and  PHP4.3.11

Hope this helps you - to help me.

Thanks
Frank

Frank,

I checked out the code for the beta 1.4.1 today, and the problem is that the database layout changed slightly...

I am not sure how I am going to handle this, but rest assured I will.  Its just like 1am here and I don't want to think.

But in the meantime - if you feel brave and stuff... open up cpmfetch_dao in your favorite editor and find this line

(should be around line 50)

Code Select Expand


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 replace it with

Code Select Expand

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';

The only other caveat is that you should be careful with subtitles and avoid any thing that looks like it would display:

user_website
user_location
user_interests
user_occupation

As these are handled differently under 1.4.1

THIS APPLIES TO CpmFetch 1.5.x Only.  I will fix this at some point soon (as I am moving to the beta) and will post a new version.

Hope this at least gets you working... I'd be very interested to hear of any other issues you may encounter under the beta

Thanks!

Vuud

[reyn]

Frank,
The only other caveat is that you should be careful with subtitles and avoid any thing that looks like it would display:
user_website
user_location
user_interests
user_occupation
As these are handled differently under 1.4.1
THIS APPLIES TO CpmFetch 1.5.x Only.  I will fix this at some point soon (as I am moving to the beta) and will post a new version.
Hope this at least gets you working... I'd be very interested to hear of any other issues you may encounter under the beta
Thanks!
Vuud

cftest.php now works ok in cpmfetch 1.5.3 I can see and activate the thumbnails.
Now I will be a bit more adventurous and include some code in my site, if anything shows up I will post here.

I have registered with your mail service so I should get notified when you update.

Sorry to keep you up, have a nice Sunday. It's 12:53 pm here, maybe your still asleep.

Frank

[vuud]

Frank,
The only other caveat is that you should be careful with subtitles and avoid any thing that looks like it would display:
user_website
user_location
user_interests
user_occupation
As these are handled differently under 1.4.1
THIS APPLIES TO CpmFetch 1.5.x Only.  I will fix this at some point soon (as I am moving to the beta) and will post a new version.
Hope this at least gets you working... I'd be very interested to hear of any other issues you may encounter under the beta
Thanks!
Vuud

cftest.php now works ok in cpmfetch 1.5.3 I can see and activate the thumbnails.
Now I will be a bit more adventurous and include some code in my site, if anything shows up I will post here.

I have registered with your mail service so I should get notified when you update.

Sorry to keep you up, have a nice Sunday. It's 12:53 pm here, maybe your still asleep.

Frank

Absolutely... I may also make a new release with a patch and post it just and notify the list.

Whatever I do, I will make it clear on the announcement list whats up with 1.4.x compatibility

Thanks for the help

Vuud