Block to take images from selected album

[aussie]

I have a scrolling block and would like to just select random pictures from one album. Can one of these blocks be changed and if so what would I need to change to select the album needed?
Thanks.

[Śyama_Dāsa]

sure, just post your website and specs here, directions are in my signature.
Then open the scrolling random block and post the queries here we will help you modify them.

[aussie]

Code::

// modified by DJMaze $result = $db->sql_query("SELECT COUNT(*) FROM ".$cpg_prefix."pictures AS p INNER JOIN ".$cpg_prefix."albums AS a ON (p.aid = a.aid AND ".VIS_GROUPS.") WHERE approved='YES' GROUP BY pid"); $nbEnr = $db->sql_fetchrow($result); $pic_count = $nbEnr[0]; // mysql_free_result($result); // if we have more than 1000 pictures, we limit the number of picture returned // by the SELECT statement as ORDER BY RAND() is time consuming if ($pic_count > 1000) { $result = $db->sql_query("SELECT COUNT(*) from " . $cpg_prefix . "pictures WHERE approved = 'YES'"); $nbEnr = mysql_fetch_row($result); $total_count = $nbEnr[0]; // mysql_free_result($result); $granularity = floor($total_count / 1000); $cor_gran = ceil($total_count / $pic_count); srand(time()); for ($i = 1; $i <= $cor_gran; $i++) $random_num_set = rand(0, $granularity) . ', '; $random_num_set = substr($random_num_set, 0, -2); // modified by DJMaze $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 randpos IN ($random_num_set) AND approved='YES' GROUP BY pid ORDER BY RAND() DESC LIMIT $limit"); } else { // modified by DJMaze $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='YES' GROUP BY pid ORDER BY RAND() DESC LIMIT $limit"); } $rowset = array(); 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); } } stripslashes($thumb_title); $content .= '<a href="' . $CPG_M_URL . '&amp;file=displayimage&amp;album='.$row['aid'].'&amp;pos=' . $row["pid"] . '"><img src="' . get_pic_url($row, 'thumb') . '" border="0" alt="' . $thumb_title . '" title="' . $thumb_title . '"><br />' . truncate_string_randpic($thumb_title) . '</a><br />'; } $content .= '<br /><a href="' . $CPG_M_URL . '">'.$lang_pagetitle_php["photogallery"].'</a></p>'; ?>

Need to pick pictures from the category Agents Pictures and album also Agents Pictures. I woiuld appreciate any help you can give me.
I am also a newbie at this kind of thing so please excuse any ignorance.

Thanks

[sarah]

Photo Gallery is access denied, otherwise I would look to see what that album id is. You'll need the album id, which you can get from the url when viewing that album. Then, untested but this should work,

Change this part:

Code::

// modified by DJMaze $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 randpos IN ($random_num_set) AND approved='YES' GROUP BY pid ORDER BY RAND() DESC LIMIT $limit"); } else { // modified by DJMaze $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='YES' GROUP BY pid ORDER BY RAND() DESC LIMIT $limit"); }

To:

Code::

// modified by DJMaze $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 randpos IN ($random_num_set) AND approved='YES' AND p.aid='xxx' GROUP BY pid ORDER BY RAND() DESC LIMIT $limit"); } else { // modified by DJMaze $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='YES' AND p.aid='xxx' GROUP BY pid ORDER BY RAND() DESC LIMIT $limit"); }

But where you see those xxx, replace them with your real album id.

[Śyama_Dāsa]

http://www.ictravelhost.com/portal wrote:

PHP-Nuke Copyright � 2004 by Francisco Burzi. This is free software, and you may redistribute it under the GPL.

I hope you are doing this for your new install of Dragonfly.....

[sarah]

I need to start checking those better first.

[venumsgurl]

Thanks for this, it worked for me!

[Dizfunkshunal]

well i guess i am missing something but what is it? I put in the album=24


link to the album

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-scroll-Random_pictures.php,v $ $Revision: 9.7 $ $Author: djmaze $ $Date: 2006/01/16 12:19:33 $ Encoding test: n-array summation ∑ latin ae w/ acute ǽ ********************************************************/ if (!defined('CPG_NUKE')) { exit; } global $prefix, $db, $CONFIG, $cpg_dir,$cpg_prefix; $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; $numberpic = $CONFIG['thumbcols']; //number of thumbs // $numberpic=4; //number of thumbs $limit = $numberpic; $maxlength = 20; // maximum length of name in block // marquee info at www.faqs.org/docs/html...RQUEE.html $content = '<p align="center"><a name="scroller"></a><marquee loop="0" behavior="scroll" direction="up" height="150" scrollamount="1" scrolldelay="1" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'><center>'; // END USER DEFINABLES $result = $db->sql_query("SELECT COUNT(*) 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"); $pic_count = $db->sql_numrows($result); //$pic_count = $nbEnr[0]; $total_count = $granularity = $cor_gran = $random_num_set = $thumb_title = ''; $db->sql_freeresult($result); // if we have more than 1000 pictures, we limit the number of picture returned // by the SELECT statement as ORDER BY RAND() is time consuming if ($pic_count > 1000) { $result = $db->sql_query("SELECT COUNT(*) from " . $cpg_prefix . "pictures WHERE approved = 1"); $nbEnr = $db->sql_fetchrow($result); $total_count = $nbEnr[0]; $db->sql_freeresult($result); $granularity = floor($total_count / 1000); $cor_gran = ceil($total_count / $pic_count); srand(time()); for ($i = 1; $i <= $cor_gran; $i++) $random_num_set = rand(0, $granularity) . ', '; $random_num_set = substr($random_num_set, 0, -2); $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 randpos IN ($random_num_set) AND approved='YES' AND p.aid='album=24' GROUP BY pid ORDER BY RAND() DESC LIMIT $limit"); } else { $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='YES' AND p.aid='album=24' GROUP BY pid ORDER BY RAND() DESC LIMIT $limit"); } $rowset = array(); 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 .= '<a href="' .getlink("$cpg_dir&amp;file=displayimage&amp;album=".$row['aid']."&amp;pid=" . $row['pid']). '"><img src="' .get_pic_url($row, 'thumb') . '" border="0" alt="' . $thumb_title . '" title="' . $thumb_title . '" /><br />' . truncate_stringblocks($thumb_title,$maxlength) . '</a><br />'; } $content .= '</center></marquee><center><a href="' . getlink("$cpg_dir") . '">'._coppermineLANG.'</a></center>';

[sarah]

p.aid='24'

Also, I don't see any pictures in that album, but maybe you meant it to be that way.

[Dizfunkshunal]

I tried that its not working also had to change the id from 24 to 25 same code as above any other ideas? thanks

[sarah]

Oh dude, this is an old thread.

Code::

<?php /********************************************* CPG Dragonfly™ CMS ******************************************** Copyright © 2004 - 2005 by CPG-Nuke Dev Team http://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-scroll-Random_pictures.php,v $ $Revision: 9.7 $ $Author: djmaze $ $Date: 2006/01/16 12:19:33 $ Encoding test: n-array summation ∑ latin ae w/ acute ǽ ********************************************************/ if (!defined('CPG_NUKE')) { exit; } global $prefix, $db, $CONFIG, $cpg_dir,$cpg_prefix; $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; $numberpic = $CONFIG['thumbcols']; //number of thumbs // $numberpic=4; //number of thumbs $limit = $numberpic; $maxlength = 20; // maximum length of name in block // marquee info at http://www.faqs.org/docs/htmltut/_MARQUEE.html $content = '<p align="center"><a name="scroller"></a><marquee loop="0" behavior="scroll" direction="up" height="150" scrollamount="1" scrolldelay="1" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'><center>'; // END USER DEFINABLES $result = $db->sql_query("SELECT COUNT(*) 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"); $pic_count = $db->sql_numrows($result); //$pic_count = $nbEnr[0]; $total_count = $granularity = $cor_gran = $random_num_set = $thumb_title = ''; $db->sql_freeresult($result); // if we have more than 1000 pictures, we limit the number of picture returned // by the SELECT statement as ORDER BY RAND() is time consuming if ($pic_count > 1000) { $result = $db->sql_query("SELECT COUNT(*) from " . $cpg_prefix . "pictures WHERE approved = 1"); $nbEnr = $db->sql_fetchrow($result); $total_count = $nbEnr[0]; $db->sql_freeresult($result); $granularity = floor($total_count / 1000); $cor_gran = ceil($total_count / $pic_count); srand(time()); for ($i = 1; $i <= $cor_gran; $i++) $random_num_set = rand(0, $granularity) . ', '; $random_num_set = substr($random_num_set, 0, -2); $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 randpos IN ($random_num_set) AND approved=1 AND p.aid='25' GROUP BY pid ORDER BY RAND() DESC LIMIT $limit"); } else { $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 p.aid='25'GROUP BY pid ORDER BY RAND() DESC LIMIT $limit"); } $rowset = array(); 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 .= '<a href="' .getlink("$cpg_dir&amp;file=displayimage&amp;album=".$row['aid']."&amp;pid=" . $row['pid']). '"><img src="' .get_pic_url($row, 'thumb') . '" border="0" alt="' . $thumb_title . '" title="' . $thumb_title . '" /><br />' . truncate_stringblocks($thumb_title,$maxlength) . '</a><br />'; } $content .= '</center></marquee><center><a href="' . getlink("$cpg_dir") . '">'._coppermineLANG.'</a></center>';

[Dizfunkshunal]

an oldie but a goodie

[Dizfunkshunal]

thanks that worked great

[sarah]

NP. Database changes in coppermine since I posted the first one.

[Dizfunkshunal]

thanks just so anyone else reads this that last code posted will work with 9.1.1