Last Picture Block - 2 rows

WebSiteGuru · 1000+ Posts Club Offline Joined: Jun 09, 2005 Posts: 2318

See if that's work. I'm not at my computer so I can't test it.

PHP:

<?php
/*********************************************
  CPG Dragonfly™ CMS
  ********************************************
  Copyright © 2004 - 2005 by CPG-Nuke Dev Team
  www.dragonflycms.com

  Dragonfly is released under the terms and conditions
  of the GNU GPL version 2 or any later version

  $Source: /cvs/html/blocks/block-CPG-Last_pictures_thumb.php,v $
  $Revision: 9.6 $
  $Author: djmaze $
  $Date: 2006/01/16 12:19:32 $
Encoding test: n-array summation ? latin ae w/ acute ?
********************************************************/
if (!defined('CPG_NUKE')) { exit; }
global $prefix, $db, $CONFIG, $cpg_dir;
$cpg_dir = "coppermine";

if (!is_active($cpg_dir)) {
$content = 'ERROR';
return trigger_error($cpg_dir.' module is inactive', E_USER_WARNING);
}

$cpg_block = true;
require("modules/" . $cpg_dir . "/include/load.inc");
$cpg_block = false;
$length = $CONFIG['thumbcols']; //number of thumbs
// $length=4; //number of thumbs
$length=3;
$rows=4;
$content = $thumb_title = '';
$result = $db->sql_query("SELECT pid, filepath, filename, p.aid, p.title FROM ".$cpg_prefix."pictures AS p INNER JOIN ".$cpg_prefix."albums AS a ON (p.aid = a.aid AND ".VIS_GROUPS.") WHERE approved=1 GROUP BY pid ORDER BY pid DESC LIMIT $length");
$content .= '<br /><table width="100%" border="0" cellpadding="0" cellspacing="0" align="center"><tr align="center">';
$pic = 0;
while ($row = $db->sql_fetchrow($result)) {
if ($CONFIG['seo_alts'] == 0) {
$thumb_title = $row['filename'];
} else {
if ($row['title'] != '') {
$thumb_title = $row['title'];
} else {
$thumb_title = substr($row['filename'], 0, -4);
}
}
$content .= '<td align="center" valign="baseline"><a href="' . getlink($cpg_dir . '&amp;file=displayimage&amp;meta=lastup&amp;cat=0&amp;pos=' . $pic) . '"><img src="' . get_pic_url($row, 'thumb') . '" border="0" alt="' . $thumb_title . '" title="' . $thumb_title . '" /><br />' . truncate_stringblocks($thumb_title) . '</a></td>';
$pic++;
  if ($length/$rows == $pic) $content .= '</tr><tr>';
}
$content .= '</tr><tr><tr align="center"></td></tr></table>';

rlgura · Posted: Mon Jun 09, 2008 4:46 pm Post subject: Re: Last Picture Block - 2 rows

Nope: problem is here:

Code::

if ($length/$rows == $pic)

This will be true only once, no matter how many rows.
change to

Code::

if ($pic/$length/$rows == floor($pic/$length/$rows))

3DdesktopsUK · Posted: Mon Jun 09, 2008 6:07 pm Post subject: Re: Last Picture Block - 2 rows

sorry guys, still no joy Sad

I have pasted guru's code (changed $length=12) into a new block and replaced the code rlgura mentions to ensure I hadn't left any old bits in there.

Now 12 displaying in 1 row

xxxxxxxxxxxx

Any ideas? and cheers alot.

rlgura · Posted: Mon Jun 09, 2008 7:59 pm Post subject: Re: Last Picture Block - 2 rows

Hmmm - guess I need a couple parens in there... Here's the complete code, tested this time:

Code::

<?php
/*********************************************
  CPG Dragonfly™ CMS
  ********************************************
  Copyright © 2004 - 2005 by CPG-Nuke Dev Team
  www.dragonflycms.com

  Dragonfly is released under the terms and conditions
  of the GNU GPL version 2 or any later version

  $Source: /cvs/html/blocks/block-CPG-Last_pictures_thumb.php,v $
  $Revision: 9.6 $
  $Author: djmaze $
  $Date: 2006/01/16 12:19:32 $
Encoding test: n-array summation ? latin ae w/ acute ?
********************************************************/
if (!defined('CPG_NUKE')) { exit; }
global $prefix, $db, $CONFIG, $cpg_dir;
$cpg_dir = "coppermine";

if (!is_active($cpg_dir)) {
$content = 'ERROR';
return trigger_error($cpg_dir.' module is inactive', E_USER_WARNING);
}

$cpg_block = true;
require("modules/" . $cpg_dir . "/include/load.inc");
$cpg_block = false;
$length = $CONFIG['thumbcols']; //number of thumbs
// $length=4; //number of thumbs
$length=12;
$rows=4;
$content = $thumb_title = '';
$result = $db->sql_query("SELECT pid, filepath, filename, p.aid, p.title FROM ".$cpg_prefix."pictures AS p INNER JOIN ".$cpg_prefix."albums AS a ON (p.aid = a.aid AND ".VIS_GROUPS.") WHERE approved=1 GROUP BY pid ORDER BY pid DESC LIMIT $length");
$content .= '<br /><table width="100%" border="0" cellpadding="0" cellspacing="0" align="center"><tr align="center">';
$pic = 0;
while ($row = $db->sql_fetchrow($result)) {
if ($CONFIG['seo_alts'] == 0) {
$thumb_title = $row['filename'];
} else {
if ($row['title'] != '') {
$thumb_title = $row['title'];
} else {
$thumb_title = substr($row['filename'], 0, -4);
}
}
$content .= '<td align="center" valign="baseline"><a href="' . getlink($cpg_dir . '&amp;file=displayimage&amp;meta=lastup&amp;cat=0&amp;pos=' . $pic) . '"><img src="' . get_pic_url($row, 'thumb') . '" border="0" alt="' . $thumb_title . '" title="' . $thumb_title . '" /><br />' . truncate_stringblocks($thumb_title) . '</a></td>';
$pic++;
  if ($pic/($length/$rows) == floor($pic/($length/$rows))) $content .= '</tr><tr>';
}
$content .= '</tr><tr><tr align="center"></td></tr></table>';

WebSiteGuru · 1000+ Posts Club Offline Joined: Jun 09, 2005 Posts: 2318

Oops

missed read the first time. Follow rlgura last codes, It should work now.

3DdesktopsUK · Posted: Mon Jun 09, 2008 10:17 pm Post subject: Re: Last Picture Block - 2 rows

Cheers guys, works like a charm!! Jus one other thing while we'll on topic, if I wanted to specify an album, which part could I change to point to something like

"coppermine/thumbnails/album=190.html"

thanks again for all your help ***** service!!

rlgura · Posted: Tue Jun 10, 2008 4:52 pm Post subject: Re: Last Picture Block - 2 rows

Off the top of my head, something like this:

PHP:

$result = $db->sql_query("SELECT pid, filepath, filename, p.aid, p.title FROM ".$cpg_prefix."pictures AS p INNER JOIN ".$cpg_prefix."albums AS a ON (p.aid = a.aid AND ".VIS_GROUPS.") WHERE approved=1 and a.aid=190 GROUP BY pid ORDER BY pid DESC LIMIT $length");