Fetch last 4 updated album with details

[bb3]

Hi,

I just want to know if it is possible to fetch last 4 updated albums with details like in the "cpm_showAlbumsUpdatedOverLastDays($numberOfDays,$options="")" (no. of lates files, album name, category name)

thanks

http://redlens.org

[bb3]

hi there,

i just want to update this query.

I want to know how to fetch only 4 updated albums instead of "ALL" updated albums since "date" thanks

[Joachim Müller]

http://forum.coppermine-gallery.net/index.php/topic,35221.msg197845.html#msg197845

[bb3]

sorry for that joachim...

i've already made a research but still no luck... i tried to put this code

Code Select Expand

<style type="text/css">.style {border:1px solid #CCC;}</style>
<?php require_once "./gallery/cpmfetch/cpmfetch.php"; $objCpm = new cpm("./gallery/cpmfetch/cpmfetch_config.php")
;$objCpm->cpm_setfilter($filter = ".jpg");
$options = array("imagewidth"=>"100","imageheight"=>"75","imageStyle"=>"style")
;$objCpm->cpm_showAlbumsUpdatedOverLastDays(7,$options); $albumstoshow = 3;
  $objCpm->cpm_close();?>           


and replace cpmfetch_dao.php code

Code Select Expand

function getMediaAddedSince ($timestamp) {
$resultset = array();

if (is_numeric($timestamp)) {
$sqlcode = "SELECT {$this->sqlPostSelect} " . $this->sqlSelect
. ', c.name AS cName, count( p.pid ) AS count '
. ' FROM '
. $this->sqlTableSelect
. " WHERE a.category = c.cid "
. $this->sqlUserDataLink
. " AND p.approved='YES' {$this->privacyfilter} AND p.ctime > " . $timestamp
. ' GROUP BY a.category, a.aid'
. ' ORDER BY c.name, p.mtime';


to this

Code Select Expand

function getMediaAddedSince ($timestamp) {
$resultset = array();

if (is_numeric($timestamp)) {
$sqlcode = "SELECT {$this->sqlPostSelect} " . $this->sqlSelect
. ', c.name AS cName, count( p.pid ) AS count '
. ' FROM '
. $this->sqlTableSelect
. " WHERE a.category = c.cid "
. $this->sqlUserDataLink
. " AND p.approved='YES' {$this->privacyfilter} AND p.ctime > " . $timestamp
. ' GROUP BY a.category, a.aid'
. ' ORDER BY p.ctime DESC';


but it is still showing "ALL" of the updated album...

thanks

[bb3]

i figured it out.

find in cpmfetch_dao

Code Select Expand

function getMediaAddedSince ($timestamp) {
$resultset = array();

if (is_numeric($timestamp)) {
$sqlcode = "SELECT {$this->sqlPostSelect} " . $this->sqlSelect
. ', c.name AS cName, count( p.pid ) AS count '
. ' FROM '
. $this->sqlTableSelect
. " WHERE a.category = c.cid "
. $this->sqlUserDataLink
. " AND p.approved='YES' {$this->privacyfilter} AND p.ctime > " . $timestamp
. ' GROUP BY a.category, a.aid'
. ' ORDER BY c.name, p.mtime';

$resultset = $this->dbExecuteSql($sqlcode);
$this->addPathInfo($resultset);
}


change to

Code Select Expand

function getMediaAddedSince ($timestamp) {
$resultset = array();

if (is_numeric($timestamp)) {
$sqlcode = "SELECT {$this->sqlPostSelect} " . $this->sqlSelect
. ', c.name AS cName, count( p.pid ) AS count '
. ' FROM '
. $this->sqlTableSelect
. " WHERE a.category = c.cid "
. $this->sqlUserDataLink
. " AND p.approved='YES' {$this->privacyfilter} AND p.ctime > " . $timestamp
. ' GROUP BY a.category, a.aid'
. ' ORDER BY p.ctime DESC LIMIT 3 ';

$resultset = $this->dbExecuteSql($sqlcode);
$this->addPathInfo($resultset);
}