coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 cpmFetch by vuud => Topic started by: jaiak on January 29, 2008, 11:10:21 AM

Title: [Solved]: Show the last albums added in yout gallery in text mode
Post by: jaiak on January 29, 2008, 11:10:21 AM
Sorry for the rescue this post, I have installed the cpmfetch 2.0 and coppermine 1.4.14 in powweb.com server.

I have merge phpBB 2.0.22 and coppermine 1.4.14 installation.

I have in my index the cpmfetch work ok with the last comments, the last thumbnails, etc. But I can't show the last titles of my albums added in my gallery. I want show the titles in text mode. Can you help me?

Regards from spain anda thanks in Advance!
Title: Re: Show the last albums added in yout gallery in text mode
Post by: Joachim Müller on January 29, 2008, 05:44:33 PM
Read the docs and sticky threads here on this board - yours is not even a valid support request.
Title: Re: Show the last albums added in yout gallery in text mode
Post by: jaiak on January 29, 2008, 06:04:47 PM
Hello again Gaugau

I have read all documentatino but I don't find how Can I show the last album in text mode.

Regards from spain
Title: Re: Show the last albums added in yout gallery in text mode
Post by: jaiak on June 04, 2008, 01:18:42 AM
Hello Again

I had developed this code for show the last albums in text mode (show the title)

<?php define('IN_COPPERMINE'true); require('include/init.inc.php'); $base rtrim($CONFIG['ecards_more_pic_target'], '/'); $albumpath "$base/" $CONFIG['fullpath']; $result mysql_query("SELECT tb.aid, ta.title FROM {$CONFIG['TABLE_ALBUMS']} tb LEFT OUTER JOIN {$CONFIG['TABLE_ALBUMS']} ta ON tb.aid = ta.aid ORDER BY ta.aid DESC LIMIT 0,8"); while (list($aid$title) = mysql_fetch_row($result)) {
echo 
"<li><a href=$base/thumbnails-$aid.html target=_top><font face=arial color=black><b>$title</b></font></a></li>"; } ?>
Title: Re: Show the last albums added in yout gallery in text mode
Post by: Joachim Müller on June 04, 2008, 08:14:37 AM
Making your code more readable:<?php 
define
('IN_COPPERMINE'true); 
require(
'include/init.inc.php'); 
$base rtrim($CONFIG['ecards_more_pic_target'], '/'); 
$albumpath "$base/" $CONFIG['fullpath']; 
$result mysql_query("SELECT tb.aid, ta.title FROM {$CONFIG['TABLE_ALBUMS']} tb LEFT OUTER JOIN {$CONFIG['TABLE_ALBUMS']} ta ON tb.aid = ta.aid ORDER BY ta.aid DESC LIMIT 0,8"); while (list($aid$title) = mysql_fetch_row($result)) {
  echo 
"<li><a href=$base/thumbnails-$aid.html target=_top><font face=arial color=black><b>$title</b></font></a></li>"

?>
Title: Re: Show the last albums added in yout gallery in text mode
Post by: Fabricio Ferrero on June 04, 2008, 06:44:35 PM
Regards from spain
Quote

I just remember you that the Spanish sub-board had just re-opened. If you have trouble whit the language, don't doubt to make your question there.

Regards.
Title: Re: Show the last albums added in yout gallery in text mode
Post by: jaiak on June 05, 2008, 09:23:13 AM
Very thanks fabri :)