[Solved]: Best thumb pic instead of last thumb in cpm_viewLastUpdatedAlbumsFrom !? [Solved]: Best thumb pic instead of last thumb in cpm_viewLastUpdatedAlbumsFrom !?
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

[Solved]: Best thumb pic instead of last thumb in cpm_viewLastUpdatedAlbumsFrom !?

Started by florennes-as.be, September 30, 2007, 10:14:11 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

florennes-as.be

September 30, 2007, 10:14:11 AM Last Edit: March 19, 2008, 08:38:05 PM by Nibbler
Hello all !

I have set up a small code (below) to extract the last three albums informations from a category. It shows in a three cells table the thumbnail picture (this is the problem), a link from the picture to the relevant album, number of pictures in the album, and the description of the album. This works fine (nearly, see below) !
  I know i can achieve a better code but this works fine, and will do it later ... This can be seen at www.florennes-as.be

  In Copperimne you can select the thumb of an album (amongst all thumb's album, in album/properties) which will represent the album in albums lists. I select the best shot thumb, of course ...

  When the call to cpm_viewLastUpdatedAlbumsFrom is done, cpm does not get the selected album's thumb (under copperimne's album properties) but the last thumb of the album. I would like to have the selected thumb instead of the last one ...
  This little detail is important for us, and i guess for some other people ...

  Have i missed something ?
  Any clues very much appreciated ! ;-)

  All my thanks for people behind cpmfetch !!!

L@urent



Code Select
<?php
  include "./engine/cpmfetch/cpmfetch.php";
  $objCpm = new cpm("./engine/cpmfetch/cpmfetch_config.php");
  $objCpm->cpm_setReturnType ("resultset"); 
  $table = $objCpm->cpm_viewLastUpdatedAlbumsFrom("cat=2",3,1,$options);
?>
<body>

<table width="380" border="0">
<tr>
<TD>
<div align="center"><img src="/toolbox/welcome/lastthreeflorennes.png" width="272" height="20"></p>
</tr>
</TD>

<table width="380" border="0">

  <tr>
  <? $lien = "http://www.florennes-as.be/engine/thumbnails.php?album=" . $table[0][aAid] ; ?>
 
    <td colspan="2"><div align="center"><? echo "<a href=\"  ". $lien . "\" target=\"_blank\">" . $table[0]["aTitle"] . "<a><br>" ; ?></td>
  </tr>
  <tr>
    <td width="202" height="135"><? echo "<a href=\"  ". $lien . "\" target=\"_blank\">" . "<img src=\" " . "engine/" . $table[0]["fullPathToThumb"] . "\" /></a>" ; ?></td>
    <td><? $numb = $objCpm->cpm_getMediaCountForAlbum($table[0][aAid]) ; ?>
<? echo "Picture Number : " . $numb  ; ?>
<br />
<br />
<? echo $table[0]["aDescription"]  ; ?></td>
  </tr>
 
   <tr>
   <? $lien = "http://www.florennes-as.be/engine/thumbnails.php?album=" . $table[1][aAid] ; ?>
    <td colspan="2"><div align="center"><? echo "<a href=\"  ". $lien . "\" target=\"_blank\">" . $table[1]["aTitle"] . "<a><br>" ; ?></td>   
  </tr>
  <tr>
    <td width="202" height="135"><? echo "<a href=\"  ". $lien . "\" target=\"_blank\">" . "<img src=\" " . "engine/" . $table[1]["fullPathToThumb"] . "\" /></a>" ; ?></td>     
    <td><? $numb = $objCpm->cpm_getMediaCountForAlbum($table[1][aAid]) ; ?>
<? echo "Picture Number : " . $numb  ; ?>
<br />
<br />
<? echo  $table[1]["aDescription"]  ; ?></td>
  </tr>
 
  <tr>
  <? $lien = "http://www.florennes-as.be/engine/thumbnails.php?album=" . $table[2][aAid] ; ?>
    <td colspan="2"><div align="center"><? echo "<a href=\"  ". $lien . "\" target=\"_blank\">" . $table[2]["aTitle"] . "<a><br>" ; ?></td>
  </tr>
  <tr>
    <td width="202" height="135"><? echo "<a href=\"  ". $lien . "\" target=\"_blank\">" . "<img src=\" " . "engine/" . $table[2]["fullPathToThumb"] . "\" /></a>" ; ?></td>
    <td><? $numb = $objCpm->cpm_getMediaCountForAlbum($table[2][aAid]) ; ?>
<? echo "Picture Number : " . $numb  ; ?>
<br />
<br />
<? echo  $table[2]["aDescription"]  ; ?></td>
  </tr>
 
</table>

<?php  
  $objCpm->cpm_close();
?>
</body>

Nibbler

#1
September 30, 2007, 04:44:41 PM
cpmfetch_dao.php, function getLastUpdatedAlbumsFrom()

find

Code Select

$sqlcode = "SELECT {$this->sqlPostSelect} " . $this->sqlSelect . " FROM "
. $this->sqlTableSelect ." LEFT JOIN "
. $this->cfg['table_prefix'] . "pictures AS p2 ON p.aid = p2.aid and p.ctime < p2.ctime "
. " WHERE p2.pid is NULL "
. $this->sqlUserDataLink
. $this->filetypefilter
. " AND p.approved='YES' "
. $sourceSql
. " {$this->privacyfilter} "
. " GROUP BY p.aid "
. " ORDER BY p.ctime DESC LIMIT 0,$count";


change to

Code Select

$sqlcode = "SELECT {$this->sqlPostSelect} " . $this->sqlSelect . " FROM "
. $this->sqlTableSelect ." LEFT JOIN "
. $this->cfg['table_prefix'] . "pictures AS p2 ON p.aid = p2.aid and p.ctime < p2.ctime "
. " WHERE (p2.pid is NULL OR p.pid = a.thumb)  "
. $this->sqlUserDataLink
. $this->filetypefilter
. " AND p.approved='YES' "
. $sourceSql
. " {$this->privacyfilter} "
. " GROUP BY p.aid "
. " ORDER BY (p.pid = a.thumb) DESC, p.pid DESC  LIMIT 0,$count";

florennes-as.be

#2
March 19, 2008, 08:07:45 PM
Many thanks ! This worked fine !!!

I realised i forgot to thank you, shame on me !!!

L@urent

florennes-as.be

#3
May 16, 2008, 10:09:58 PM
Hello !

  After several weeks of use, all works fine except the last albums are not well ordered.
  Most of the time, it is okay. I have started a new album, and it is not showed on top of the list ... strange isn't it ?

  In fact, i had three albums, correctly ordered by descending date.
  I have now added a new album, it should be showed on top of list, but it is not, and i still have the same "first" three albums ...

  Can you help me ? Many thanks in advance,

L@urent

florennes-as.be

#4
May 16, 2008, 10:27:33 PM
When looking at the slight modification of the code ... Is it due to the "p.ctime DESC" removed on the "order by" ?

L@urent

florennes-as.be

#5
May 18, 2008, 03:06:00 PM
Well, i solved the problem ...

Initially, I made a new album, put it in top of the list and uploaded by FTP, added by ftp=> and the result was cpmfetch did not saw it (on first place).
I solved it when I deleted a picture of the newly created album via coppermine, and added it again by ftp=> then now, the gallery is in top in cpmfetch.

L@urent
Print
Go Up Pages1
User actions