forum.coppermine-gallery.net
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
-
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!
-
Read the docs and sticky threads here on this board - yours is not even a valid support request.
-
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
-
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>"; } ?>
-
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>";
}
?>
-
Regards from spain
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.
-
Very thanks fabri :)