Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: 1 ... 25 26 27 28 [29] 30 31 32 33 ... 54   Go Down

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

0 Members and 1 Guest are viewing this topic.

vuud

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 1803
  • [cpmfetch.fistfullofcode.com]
    • Fist Full Of Code
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #560 on: January 01, 2006, 12:10:37 am »

I updated my CPG and Cpmfethch comes up with this

Unknown column 'u.user_website' in 'field list'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/virtual/site12/fst/var/www/html/cpmfetch/cpmfetch_dao.php on line 710

I predict you will soon read the release notes that can with cpmfetch, and furthermore - all will become clear

 Happy new year all
Logged
Please post for help to the forum... PM me only if you are sending security related items (passwords, security problems, etc).

cpmFetch - Images, RSS feeds from CPG from outside CPG
New release notification signup also. 
See http://cpmfetch.fistfullofco

imrich

  • Tester
  • Coppermine regular visitor
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 70

I understand what you are saying about the database. If I was better at db work, I would volunteer to help, but I'm not! ;)

If you run cftest.php, Under the test thumbnail grid, 'Views' always shows 0.  Even on my test installation which does not have any phpbb installed.  I noticed that the code had %V instead of %v, I tried to change it to %v, but it didn't seem to work. However, I didn't do much more testing than that.



I found why cftest.php wasn't displaying the number of views in thumbnail test grid.

find this code in cftest.php
Code: [Select]
"subtitle" => "%o<br>%V views",

change the %V to %h like this:

Code: [Select]
"subtitle" => "%o<br>%h views",

After reading the documentation, I found that %V is the current rating in the number of stars, not the number of views!

Happy New Year! :)
Logged

benseth

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 50
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #562 on: January 02, 2006, 10:41:42 am »

I did what the release notes had and now i get

You have an error in your SQL syntax near 'FROM cpg143_pictures as p, cpg143_albums as a, cpg143_users AS u where p.aid =' at line 1
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/virtual/site12/fst/var/www/html/cpmfetch/cpmfetch_dao.php on line 713
Logged

vuud

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 1803
  • [cpmfetch.fistfullofcode.com]
    • Fist Full Of Code
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #563 on: January 02, 2006, 04:13:33 pm »

I did what the release notes had and now i get

You have an error in your SQL syntax near 'FROM cpg143_pictures as p, cpg143_albums as a, cpg143_users AS u where p.aid =' at line 1
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/virtual/site12/fst/var/www/html/cpmfetch/cpmfetch_dao.php on line 713

Please be sure you did not accidentally muck up the SQL statement and that you removed the comments from around it fully and such.

I don't think a SQL Syntax error would be caused by any changes to the database and such

Logged
Please post for help to the forum... PM me only if you are sending security related items (passwords, security problems, etc).

cpmFetch - Images, RSS feeds from CPG from outside CPG
New release notification signup also. 
See http://cpmfetch.fistfullofco

Zanelli

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 22
  • Jet-Angel
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #564 on: January 02, 2006, 06:26:34 pm »

Okay I'm not sure how posting here works, but I've got a big problem.

Seen I've just got hold of CpmFetch I don't really know much about it and would like some help setting it up.

I've installed it and got the test file working with my CPG.

The problem is that I have my CPG briged with my PHPBB board and the little info I got from searching says there's a big problem with this, but I don't know if this has been solved or not?
Logged

n3n

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 173
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #565 on: January 03, 2006, 12:44:23 am »

Hi Vuud, I got it to work. Dont know how I did it, but it works.

Only problem i have is that im getting only 3 images shown.

Any idea what the problem could be ?
Logged

vuud

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 1803
  • [cpmfetch.fistfullofcode.com]
    • Fist Full Of Code
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #566 on: January 03, 2006, 04:57:03 am »

Okay I'm not sure how posting here works, but I've got a big problem.

Seen I've just got hold of CpmFetch I don't really know much about it and would like some help setting it up.

I've installed it and got the test file working with my CPG.

The problem is that I have my CPG briged with my PHPBB board and the little info I got from searching says there's a big problem with this, but I don't know if this has been solved or not?

Yes, you need to create users in cpmfetch... dummy users.  Someone posted information on linking to phpbb somewhere here, but I have not tried it.

You should be able to find lots of posts on this here.
Logged
Please post for help to the forum... PM me only if you are sending security related items (passwords, security problems, etc).

cpmFetch - Images, RSS feeds from CPG from outside CPG
New release notification signup also. 
See http://cpmfetch.fistfullofco

vuud

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 1803
  • [cpmfetch.fistfullofcode.com]
    • Fist Full Of Code
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #567 on: January 03, 2006, 04:58:12 am »

Hi Vuud, I got it to work. Dont know how I did it, but it works.

Only problem i have is that im getting only 3 images shown.

Any idea what the problem could be ?

How many did you expect?
Logged
Please post for help to the forum... PM me only if you are sending security related items (passwords, security problems, etc).

cpmFetch - Images, RSS feeds from CPG from outside CPG
New release notification signup also. 
See http://cpmfetch.fistfullofco

benseth

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 50
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #568 on: January 03, 2006, 05:18:54 am »

Is it supposed to  be like this?

        var $topPercentForTopRated = 10;
/*
   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';
*/
Logged

imrich

  • Tester
  • Coppermine regular visitor
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 70
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #569 on: January 03, 2006, 02:05:30 pm »

Okay I'm not sure how posting here works, but I've got a big problem.

Seen I've just got hold of CpmFetch I don't really know much about it and would like some help setting it up.

I've installed it and got the test file working with my CPG.

The problem is that I have my CPG briged with my PHPBB board and the little info I got from searching says there's a big problem with this, but I don't know if this has been solved or not?

Zanelli,

You can try this: http://forum.coppermine-gallery.net/index.php?topic=19564.msg117615#msg117615

This is what I did to get cpmfetch working with phpbb and it seems to be working well.

If you get it working also, let us know so we can get more validation on this 'work around' method.
Logged

Zanelli

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 22
  • Jet-Angel
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #570 on: January 03, 2006, 03:48:22 pm »

Yes, you need to create users in cpmfetch... dummy users.  Someone posted information on linking to phpbb somewhere here, but I have not tried it.

You should be able to find lots of posts on this here.


I have over 300 members I don't really want to do that.
Logged

imrich

  • Tester
  • Coppermine regular visitor
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 70
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #571 on: January 03, 2006, 05:41:13 pm »

I have over 300 members I don't really want to do that.

Zanelli, Try this, It works great with phpbb. I use it as documented in the post which I mentioned before.

This is an excerpt from the previous post to get phpbb 2.0.18 (or 2.0.19) to work with CPMFetch 1.6.2

open cpmfetch.dao.php and find line:

Code: [Select]
$this->sqlPictureSourceSelect = " " . $database_table_prefix . "pictures as p, " . $database_table_prefix . "albums as a, "
. $database_table_prefix . "users AS u ";
change it to the following:

Code: [Select]
$this->sqlPictureSourceSelect = " " . $database_table_prefix . "pictures as p, " . $database_table_prefix . "albums as a, "
. $database_table_prefix . "users AS u , phpbb_users AS phpbb ";

note! 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.

THEN, find every occurance of
Code: [Select]
u.user_id

 and change it to

Code: [Select]
phpbb.user_id

Save cpmfetch_dao.php and then try cftest.php.

I left out a lot of details which were in my original post. See it for those details.
Logged

sigepjedi

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 111
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #572 on: January 03, 2006, 09:44:43 pm »

Trying to install the latest version and i get the following:

Quote
Unknown column 'u.user_website' in 'field list'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in cpmfetch_dao.php on line 710
 
Logged

NiklasT

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #573 on: January 04, 2006, 10:50:57 am »

I have the same problem as sigepjedi - the script does not work!
Is there no solution?!
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #574 on: January 04, 2006, 12:51:16 pm »

reporting things like "the script doesn't work" is just silly and not helpful at all. Read the docs that come with it and that are available online as well - they should tell you what you need to do if you actually need support (i.e. what you need to post). Reading this thread might help as well. Don't be lazy and expect people to say something like "got problems with the script - I'll fix them for you". After all, you're looking for support on a great free add-on script that the author has spent countless hours on; it works flawlessly for thousands. Probably a PEBKAC issue.
Logged

vuud

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 1803
  • [cpmfetch.fistfullofcode.com]
    • Fist Full Of Code
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #575 on: January 04, 2006, 02:45:47 pm »

Trying to install the latest version and i get the following:
 


The releasenotes that came with it have notes on this very topic...

The forum has about a dozen entries in it that covers this topic...

Logged
Please post for help to the forum... PM me only if you are sending security related items (passwords, security problems, etc).

cpmFetch - Images, RSS feeds from CPG from outside CPG
New release notification signup also. 
See http://cpmfetch.fistfullofco

vuud

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 1803
  • [cpmfetch.fistfullofcode.com]
    • Fist Full Of Code
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #576 on: January 04, 2006, 02:46:57 pm »

Is it supposed to  be like this?

        var $topPercentForTopRated = 10;
/*
   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';
*/



Try removing the /* and */ from the second one...   I know it says its for beta, but it still counts
Logged
Please post for help to the forum... PM me only if you are sending security related items (passwords, security problems, etc).

cpmFetch - Images, RSS feeds from CPG from outside CPG
New release notification signup also. 
See http://cpmfetch.fistfullofco

vuud

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 1803
  • [cpmfetch.fistfullofcode.com]
    • Fist Full Of Code
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #577 on: January 04, 2006, 02:48:19 pm »

I have the same problem as sigepjedi - the script does not work!
Is there no solution?!


Stay in school?

Check the release notes also for instructions
Logged
Please post for help to the forum... PM me only if you are sending security related items (passwords, security problems, etc).

cpmFetch - Images, RSS feeds from CPG from outside CPG
New release notification signup also. 
See http://cpmfetch.fistfullofco

JoeyE

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #578 on: January 04, 2006, 03:28:58 pm »

Strange... can you tell me where you saw that owner or author was a valid tag for the source block?




I actually figured out what I was doing wrong. Below is my corrected fix for my WP2.0 author.php page: http://viscomcreatives.org/?author=12

Code: [Select]
<?php
  
include "./cpmfetch/cpmfetch.php";
  
$authgal $curauth->display_name;     // Returns author name for $Source
  
$objCpm = new cpm('/photo');
  
$objCpm->cpm_viewRandomMediaFrom(3,4,"owner=$authgal");
  
$objCpm->cpm_close();
?>

Now my question is:
Which variable would work best to add an if statement so that users with no albums will echo a 'No Album Available' string?  For example:

Code: [Select]
if ($thisguysalbum != '') {
  // add cpfetch stuff to obtain galleries
}
  echo "No Album Available";

Any suggestions?
Logged

n3n

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 173
Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website
« Reply #579 on: January 04, 2006, 04:24:26 pm »

How many did you expect?

Well im using the following code:

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

So I'm supposed to get 5 images back right ? Im only getting 3 images, and always the same images.
Logged
Pages: 1 ... 25 26 27 28 [29] 30 31 32 33 ... 54   Go Up
 

Page created in 0.032 seconds with 20 queries.