CpmFetch - (OLD/LOCKED) stats/thumbnails/randoms/etc from outside CPG

[ledotn]

Hey, it's no problem about the forum.  Well, actually now that I look at it... yes, there are supposed to be two 'www', but it should just be
'/www/www/gallery/', not '/home/liquidem/www/www/gallery/coppermine.php'.     I don't know where the '/home/liquidem' part is coming from.

[vuud]

Hey, it's no problem about the forum.  Well, actually now that I look at it... yes, there are supposed to be two 'www', but it should just be
'/www/www/gallery/', not '/home/liquidem/www/www/gallery/coppermine.php'.     I don't know where the '/home/liquidem' part is coming from.

The home/liquidem is read from the document_root, which is part of the filesystem path which "should" point at where your web stuff is currently residing.

Anyway, can you PM me the location of your site, and if you can put up a PHPINFO() output for me to look at it helps also

Insert <?php phpinfo(); ?> into the top of the cftest.php will do it

[stez]

Well, it seems that there is a workaround - at least for me as it's now working - but I'll leave it to the expert to explain later.   

Good luck with yours letdotn!

Cheers vuud, excellent support and product ;-)

[vuud]

Well, the problem here was with the fact that $_SERVER['DOCUMENT_ROOT'] is not as universal as I would think... and after I had accepted that, I just found out its sometimes wrong...

Sigh

Anyway, stez had a different one C_DOCUMENT_ROOT that I have not idea what it was... a quick

$_SERVER['DOCUMENT_ROOT']  =  $_SERVER['C_DOCUMENT_ROOT'];

Got the right path into the right place...

Thats all

Well, it seems that there is a workaround - at least for me as it's now working - but I'll leave it to the expert to explain later.   

Good luck with yours letdotn!

Cheers vuud, excellent support and product ;-)

[vuud]

CpmFetch Announcements from FistFullOfCode.com - Issue #4
[The exact Center of the Internet BTW]

--------------------------------------------------------------
Sign up for email notifications at http://cpmfetch.fistfullofcode.com
This will get you:
* Emails for new releases and development releases
* Notifications of new tutorials and online help
* Security notification (if we ever have one)
* Email addresses held closely - no spam, not shared
----------------------------------------------------------------

* * * Development release 1.3.6 is ONLINE now * * *
( get it at http://cpmfetch.fistfullofcode.com )


***********************************************
IMPORTANT:  The coppermine.php file has been removed... see
below for making changes to your system so this (and all future)
versions continue to work.
***********************************************

I have posted a new development release online.  Updating to this is purely up to you... 
If there is something you like here, go ahead.  If not stick with what you have.  If you think
you have a bug now, upgrade to this before reporting it (or else)

:::::::::News:::::::::::
Well, I have had less and less time to work on this, but thankfully I got a
breather today and finished up a bunch of functions and changes.  There
is of course, more on my list.

Coppermine forums online:
As some of you may have noticed, someone in a lapse of judgement :p gave
CpmFetch its own child board and gave me moderator status.  While I have not
really had a chance to abuse my power, I play to when I get a chance.

The board is now at http://forum.coppermine-gallery.net/index.php?board=57.0

I'd like to ask people to first try posting in the relevant thread there before E-mailing me...  If I
can't help right away perhaps some other people can help.  There are some smart people
in there...  really.

This will most likely be the last changes before marking it as a stable, so please try it out
and tell me what bugs you find.  Some significant refactoring has taken place, so I am
sure I broke something.

:::::::::::Here is what is new:::::::::::::::
* Using CPMFETCH (NOT cfimageget) from your html pages !!!!!
* Recode coppermine.php to cpmfetch.php [VERY IMPORTANT]
* Recode coppermine_dao.php to cpmfetch_dao.php
* Random from Top rated
* Random from Most viewed
* Cfimageget_classic.php removed
* Improved cftest.php
* Conversion to arrays back from coppermine_dao (instead of result sets)


USING CPMFETCH (NOT CFIMAGEGET) FROM YOUR HTML PAGES !!!!!
=========================================
Whodathunkit?  Anyway, I posted a new thread on the support forums giving a
run down on how to do this easily.  Its so damned simple that I may not ever
put out an SSI module!  We will have to see:

http://forum.coppermine-gallery.net/index.php?topic=18547.0

Its incredibly fun, and just to boot, its 100% ORGANIC


RENAME COPPERMINE.PHP TO CPMFETCH.PHP
RENAME COPPERMINE_DAO.PHP TO CPMFETCH_DAO.PHP
============================================
I renamed the coppermine.php and coppermine_dao.php files to something
a little less sounding than coppermine.  This is a painful change for everyone since it
will involve you altering any page you are using cpmfetch on.  It was not a
decision made lightly - but I feel it had to be done.  This should reduce some
confusion and make it easier to work with the coppermine photo gallery in close
proximity. 

What you have to change:
* Any page that used coppermine.php has to be changed from:
   
   include "./coppermine.php";
   to
   include "./cpmfetch.php";

Again, sorry - but its for the best.


RANDOM FROM TOP RATED
RANDOM FROM MOST VIEWED
=================================
cpm_viewRandomMostViewedMediaFrom ($source,  $rows, $columns, $options)
cpm_viewRandomTopRatedMediaFrom ($source,  $rows, $columns, $options)

So a simple request like "I'd like to show a random number of the highest rated image" is a lot
harder than you would think.  These two are very similar so I will only cover the
description of what happens internally to figure this out.  I am OPEN to suggestions on
improving these...

When you request 5 rows x 5 columns (10 images) the functions do a few things:
1. Gets the total number of images available to that source
2. Mutiples the number by a percent to qualify (currently 25% for rated and 10% for viewed)
3. Gets that many back from the database sorted by rating or views (depending)
4. Randomly grabs the count you want from there.



CONVERSION TO ARRAYS BACK FROM COPPERMINE_DAO
===========================================
(INSTEAD OF RESULT SETS)
This will not affect almost everyone, but internally I was handing around mysql resultsets. 
Moving forward this will be done by assocaitive arrays.  This makes my job a lot
easier with some things I want to do.  The drawback?  You can't get a resultset back
for the foreseeable future from the dao.  If this is a big problem for you, let me know
and if your reason is good enough - I will work something out.  Requesting a resultset to be
returned will now return an associative array.


CFIMAGEGET_CLASSIC.PHP REMOVED
============================================
This is the old version, no redeeming qualities at all.  Saw one person trying
to use it, so I am just plain out removing it from the package. 


IMPROVED CFTEST.PHP
============================================
CFTEST was useful once upon a time.  After some changes to object creation
and destruction it was less so.  So I spent some time redoing it all so it will help you
and me get you working faster.  I'll be changing it as you, the user community,
find new and innovative ways to break my lovingly crafted program.


::::::::::::::A WORD ABOUT DEV RELEASES:::::::::::::

Typically development releases are done in software when new features are added... New features sometimes
introduce bugs (software errors) that the testing we do here misses.  If this happens, it is usually something
strange.  The dev releases here are generally very stable.  Changes sometimes even make the program
more stable, which adding new features.

Overall, In most circumstances, if your random thumbnail is not working for a few minutes when you upgrade
you are going to be okay.  If a dev release has something you like, give it a try.  I always have all the older versions up
for download so you can go back if it breaks.

If you do have a problem, PLEASE let me know.  That way I can fix it.  If I don't know about it, it could be
a long time before it gets fixed.

-------------------------------------------------------------------------------------------------------

Thanks!

Bill@fistfullofcode.com aka Vuud

[vuud]

I need help. My site is game portal. I want my website's main page to load the latest 6 titles of the last updated or created albums, from one cathegory only (e.g. catherory 2). At present I'm doing this manually all by my own, but it takes awfully long time ( http://pszone.headoff.com - Sections "Screenshots" and "Videos"). I also wandered if it is possible before every new name of an album to apeear tha date of the update. For example:

02/05/05 Max Payne 2
06/05/05 Metal Gear Solid 3

I've done this... I am using the latest dev version 1.3.6 (anything newer will work, but older will not)... to do this, insert this code into your page where you want the results displayed.

Code Select Expand



<?php
include "./cpmfetch.php";                  //Change this so it reflects your system
$objCpm = new cpm('/photos');         //Change this so it reflects your system
$objCpm->cpm_setReturnType("resultset");
$data = $objCpm->cpm_viewLastAddedMediaFrom(1000, 1000, "cat=5");  //Change cat=5 to the category(s) you want

$cnt = 0;
$albumstoshow = 6;
$arrayofalbums = array();

foreach ($data as $row) {
if (! in_array($row['aTitle'],$arrayofalbums)) {
print date("m/d/y",$row['pCtime']);
print "&nbsp;&nbsp;&nbsp;";
print "<a href=\"/photos/thumbnails.php?album={$row['pAid']}\">";  //Change /photos so it reflects your system
print $row['aTitle']. "</a><br>\n";
array_push($arrayofalbums,$row['aTitle']);
$cnt++;
if ($cnt == $albumstoshow) break;
}
}
$objCpm->cpm_close();
?>



IN my system, it generates something like:

06/10/05   Misc - Just don't fit anywhere
06/05/05   Panthorn Park trails day 2005
06/05/05   Our furry friends
12/07/04   Aug 2004 - My birthday at Session Woods
12/07/04   May 2003 - Beckett Trip

Where the titles are links.  Its not terribly efficent as it does a query for every image in the category, but c'est la vie

Let me know how well this works out for you...

[pszone]

Realy thanx Vuud, it works perfect  http://pszone.headoff.com - Sections "Screenshots" and "Videos"  Thanx again!

[vuud]

Realy thanx Vuud, it works perfect  http://pszone.headoff.com - Sections "Screenshots" and "Videos"  Thanx again!

Not a problem... That is really a well done site... very cool looking

[mustang_lex]

Ok . I got it working fine on my site. The only question I have now is...

Can I make a limit to the height of the thumbnail (its 75 pixel right now but some people are submitting portriat format making the height of the thubmnail bigger, thus messing up my site layout. I tried to add the tags in coppermine.php but got errors so I know I have no clue what to do.

Besides that I give this 3 thumbs up!!!

[vuud]

Ok . I got it working fine on my site. The only question I have now is...

Can I make a limit to the height of the thumbnail (its 75 pixel right now but some people are submitting portriat format making the height of the thubmnail bigger, thus messing up my site layout. I tried to add the tags in coppermine.php but got errors so I know I have no clue what to do.

Besides that I give this 3 thumbs up!!!

If you download and use the latest dev version (1.3.6) you can set the width or height setting for your images, which will in turn force the browser to resize them on the fly.

They go in the optionarray for the call, and I believe they are called imageheight and imagewidth... I would not use both of them at the same time

[vuud]

I've been updating some test pages to be visible by everyone... I am working on the format now, and have lots of examples - but not sure of the format.

http://www.fistfullofcode.com/projects/copperminefetch/tests/

Feel free to browse any of them... pay attention to the first two examples on test 1, that what I am thinking for a layout (color and font not applied).  Is that enough information? 

I don't want to make this too hard for me to update...

Comments?

[stez]

I like those test pages - it gives me lots of ideas of what can be done with it.  As I'm dog sitting tonight, I'm going to have a play with the different examples... :-)

[vuud]

I like those test pages - it gives me lots of ideas of what can be done with it.  As I'm dog sitting tonight, I'm going to have a play with the different examples... :-)

Thanks - there is still much to be done.  But I am doing it on a time available basis so no idea when they will all be updated

Let me know how it works out for you

[vuud]

This is really a few fixes to 1.3.6... if you do not have 1.3.6, don't worry about it.


* * * Development release 1.3.7 is ONLINE now * * *
( get it at http://cpmfetch.fistfullofcode.com )

I have posted a new development release online.  Updating to this is purely up to you... 
If there is something you like here, go ahead.  If not stick with what you have.  If you think
you have a bug now, upgrade to this before reporting it (or else)

HERE IS WHAT IS NEW:
---------------------------------------------------
Bugfix  to cpmfetch (Minor)
Bugfix to cfimageget  (Major)
Bugfix to cfrssget (Major)

cfimageget and cfrssget were completely broken in the 1.3.6 test release.  This addresses those problems.

EXAMPLES ONLINE
---------------------------------------------------
I finally started adding in my examples I use for development, some are not formatted nicely,
but it is a lovely tour-de-force of the capabilities of CPMFetch.  They are off the doc's page on my
web site, and I am updating them a few at a time.  See the link for "Examples and tests"

http://cpmfetch.fistfullofcode.com/projects/copperminefetch/docs.php

SOLICITING FOR COOLNESS
---------------------------------------------------
If this has been useful for you, or if you have done something really cool with it, please e-mail me
with a link and if its okay to show it off / link to it from my site.  I hope that some cool ones will come through
that I can then post as examples (complete credit given of course) for others.

Send to:  Bill@FistFullOfCode.com

[tutone]

vuud,

I love this ability.... works great on my site.  How would i go about formatting the category name that you can have displayed under the pic?  Something like a bold and center?

thanks

[vuud]

I love this ability.... works great on my site.  How would i go about formatting the category name that you can have displayed under the pic?  Something like a bold and center?

You can insert the strong tags into the subtitle tag... See the examples on this page:

http://www.fistfullofcode.com/projects/copperminefetch/tests/test3.php

As for the centering you really need to use css for that at this time...  I am working on adding in some new options to help, but for now, you need to set the cellstyle (or something like that, and provide CSS entries).

Hope that helps

Vuud

[tutone]

vuud,

thanks... got that working.  Great examples. Have you coded the ability so that there could be a line that says "X number of pics added in the last week".  I see the example of listing by categories ect.. but i was trying to have just that line...

Also... i have been meaning to ask about an error that i get.  Not really an error.. i get the image not found error once in awhile.  I then go into the gallery and the thumbnail exists.  I am not sure why it appears.  Any ideas?  Is there any way that a default blank image could appear if that error appears?  The reason why this is a problem is because some of the filenames are very long so the message pushes my page over.

thanks again.  And i really like the examples... gave me great ideas.

[vuud]

Actually, yes and no on displaying how many added since... I have it, but its kinda buried and not directly accessable.  However, I added three new tests to the top of this page...  the first two show the next dev version exposing that (version 1.3. and the third shows how you can do it with pretty much any version of cpmfetch going back.  its an extra statement or two, but its not hard

http://cpmfetch.fistfullofcode.com/projects/copperminefetch/tests/test2.php

About the error, I am going to need more information... Like if the next time it happens, do view source, copy and send the table it made to me and let me know which one is the bad image.  Bascically if you are getting a bad image, then my code thinks the image exists.  This means that I can't send a blank one.  So lets find out where the real problem is (yes, I could file check to make sure its there, but all that I/O will cause slowdown and increase in server usage - probably negligable, but I don't roll that way).  So I am here to help

Glad you like the tests... I am on the verge of a new stable - since the list of new stuff is huge.  I guess 8 dev releases will do that to you

Vuud

vuud,

thanks... got that working.  Great examples. Have you coded the ability so that there could be a line that says "X number of pics added in the last week".  I see the example of listing by categories ect.. but i was trying to have just that line...

Also... i have been meaning to ask about an error that i get.  Not really an error.. i get the image not found error once in awhile.  I then go into the gallery and the thumbnail exists.  I am not sure why it appears.  Any ideas?  Is there any way that a default blank image could appear if that error appears?  The reason why this is a problem is because some of the filenames are very long so the message pushes my page over.

thanks again.  And i really like the examples... gave me great ideas.

[tutone]

vuud,

I got the missing image error again... here is the code that was generated...

<td><a href="/gallery/displayimage.php?pos=-548"  ><img class="test1" alt="Uploaded: 11-Apr-2005, Filename: Tyler #2 (University Place, WA) 121904.jpg, Size: 68961, Album: WA Christmas Trip, Uploaded By: msn, Title: " title="Uploaded: 11-Apr-2005, Filename: Tyler #2 (University Place, WA) 121904.jpg, Size: 68961, Album: WA Christmas Trip, Uploaded By: msn, Title: " src="/gallery/albums/x/thumb_Tyler #2 (University Place, WA) 121904.jpg"/></a><br /><center></center></td>

thanks in advance for your help

[vuud]

src="/gallery/albums/x/thumb_Tyler #2 (University Place, WA) 121904.jpg"

Do you think you could have worked in a few other strange characters?  Curse windows and its permissive ways.

Anyway, there is a problem somewhere... when CPG renders it, it shows as:

thumb_Tyler%20%232%20%28University%20Place%2C%20WA%29%20121904.jpg

When I do the same, in cpmfetch I get:

thumb_Tyler%20#2%20%28University%20Place,%20WA%29%20121904.jpg

So somewhere I am not doing my job on encoding # and ,

I will look into it... assume this will be fixed in the next dev release (1.3.  I will post when I got it.

Thanks for the bug report though