coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 cpmFetch by vuud => Topic started by: Tin0 on March 30, 2008, 09:18:30 PM

Title: Fetched based on pWidth
Post by: Tin0 on March 30, 2008, 09:18:30 PM
Hi,

This is driveing me carzy, Cant find it out.


Is there a way to fetch
$objCpm->cpm_viewRandomMedia(3,2, $aOption);

Based on the images pWidth size?
Title: Re: Fetched based on pWidth
Post by: Tin0 on March 30, 2008, 09:55:06 PM
On my own, I got this, now... but Im not happy with it. It works, but its a sluppy way to do it.

function getLastAddedMediaFrom ($source, $count = 1) {
$resultset = array();
if (is_numeric($count)) {

$sourceSql = $this->makeSourceSql($source);

if ($sourceSql != "") $sourceSql = " AND " . $sourceSql;

$sqlcode = "SELECT {$this->sqlPostSelect} " . $this->sqlSelect . " FROM "
. $this->sqlTableSelect
. " WHERE 1 "
. $this->sqlUserDataLink
. $this->filetypefilter
. " AND p.approved='YES' AND p.pwidth='1024'  "


I added:
AND p.pwidth='1024'
to this code
" AND p.approved='YES' "
But was not sure where to do it, so I did what everyone with a brain would do..... Change all of them... It works, but is it possible to do this with a override function?

Best Regards,
Tin0