:: Forums ⇒

#16: Re: Last Picture Block - 2 rows Author: WebSiteGuru,

Posted: Mon Jun 09, 2008 2:56 pm
----
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>';

#17: Re: Last Picture Block - 2 rows Author: rlgura, Location: Cleveland, OH USA

Posted: Mon Jun 09, 2008 4:46 pm
----
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))

#18: Re: Last Picture Block - 2 rows Author: 3DdesktopsUK, Location: Surrey - UK

Posted: Mon Jun 09, 2008 6:07 pm
----
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.

#19: Re: Last Picture Block - 2 rows Author: rlgura, Location: Cleveland, OH USA

Posted: Mon Jun 09, 2008 7:59 pm
----
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>';

#20: Re: Last Picture Block - 2 rows Author: WebSiteGuru,

Posted: Mon Jun 09, 2008 8:18 pm
----
Oops Embarassed

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

#21: Re: Last Picture Block - 2 rows Author: 3DdesktopsUK, Location: Surrey - UK

Posted: Mon Jun 09, 2008 10:17 pm
----
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!!

#22: Re: Last Picture Block - 2 rows Author: rlgura, Location: Cleveland, OH USA

Posted: Tue Jun 10, 2008 4:52 pm
----
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");

-> Coppermine

All times are GMT

Go to page Previous 1, 2 :| |: Page 2 of 2