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 = 8; //number of thumbs $maxlength = 20; // maximum length of name in block // marquee info at http://www.faqs.org/docs/htmltut/_MARQUEE.html $content = '<p style="text-align:center;"><a name="scroller"></a><marquee loop="1" behavior="scroll" direction="left" height="135" width="80%" scrollamount="1" scrolldelay="1" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'>'; //END USER DEFINABLES $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 .= '<table width="100%" cols="' . $length . '" border="0" cellpadding="0" cellspacing="7"><tr align="center">'; $pic = 0; $thumb_title = ''; 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="' . URL::index($cpg_dir . '&file=displayimage&meta=lastup&cat=0&pos=' . $pic) . '"><img src="' . get_pic_url($row, 'thumb') . '" alt="' . $thumb_title . '" title="' . $thumb_title . '" /><br />' . truncate_stringblocks($thumb_title, $maxlength) . '</a> </td>'; $pic++; } $content .= '</tr></table></marquee></p><p style="text-align:center;"><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr align="center"><td valign="baseline"><a href="' . URL::index($cpg_dir) . '">' . _coppermineLANG . '</a><br /></td></tr></table></p>';
$length = 5; //number of thumbs $title_length = 15; //length of title below thumb // marquee info at http://www.faqs.org/docs/htmltut/_MARQUEE.html $body_length = 50; //length of body of comment to show $auth_length = 10; //length of author name to show $content = '<a name="scroller"></a><marquee loop="1" behavior="scroll" direction="up" height="150" scrollamount="1" scrolldelay="1" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'><p style="text-align:center;">'; // END USER DEFINEABLES $result = $db->sql_query("SELECT p.pid, p.title, filepath, filename, msg_author, msg_date, msg_body FROM (" . $cpg_prefix . "comments as c, " . $cpg_prefix . "pictures AS p) INNER JOIN " . $cpg_prefix . "albums AS a ON (p.aid = a.aid AND " . VIS_GROUPS . ") WHERE c.pid=p.pid AND approved=1 ORDER BY msg_date DESC LIMIT {$length}"); $pic = 0; $thumb_title = $date = $author = $messagebody = ''; 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); } } $date = formatDateTime($row['msg_date'], LASTCOM_DATE_FMT); $author = $row["msg_author"]; $messagebody = $row["msg_body"]; $content .= '<a href="' . URL::index($cpg_dir . '&file=displayimage&meta=lastcom&cat=0&pos=' . $pic) . '"><img src="' . get_pic_url($row, 'thumb') . '" style="border:0;" alt="' . $thumb_title . '" title="' . $thumb_title . '" /><br />' . truncate_stringblocks($author, $auth_length) . '</a> <br />' . truncate_stringblocks($messagebody, $body_length) . '<br />(' . $date . ')<br /><br />'; $pic++; } $content .= '</p></marquee><p style="text-align:center;"><a href="' . URL::index($cpg_dir) . '">' . _coppermineLANG . '</a></p>';
// 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 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 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="' . URL::index("{$cpg_dir}&file=displayimage&album=" . $row['aid'] . "&pid=" . $row['pid']) . '"><img src="' . get_pic_url($row, 'thumb') . '" alt="' . $thumb_title . '" title="' . $thumb_title . '" /><br />' . truncate_stringblocks($thumb_title, $maxlength) . '</a><br />'; } $content .= '</marquee></p><div style="text-align:center;"><a href="' . URL::index("{$cpg_dir}") . '">' . _coppermineLANG . '</a></div>';
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 = 10; //number of thumbs $title_length = 20; // maximum length of title under pictures, 20 is default // marquee info at http://www.faqs.org/docs/htmltut/_MARQUEE.html $content = '<p style="text-align:center;"><a name="scroller"></a><marquee loop="1" behavior="scroll" direction="up" height="150" scrollamount="1" scrolldelay="1" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'>'; // END USER DEFINABLES // 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=1 GROUP BY pid ORDER BY pid DESC LIMIT {$length}"); $pic = 0; $thumb_title = ''; 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="' . URL::index($cpg_dir . '&file=displayimage&meta=lastup&cat=0&pos=' . $pic) . '"><img src="' . get_pic_url($row, 'thumb') . '" border="0" alt="' . $thumb_title . '" title="' . $thumb_title . '" /><br />' . truncate_stringblocks($thumb_title, $title_length) . '</a><br /><br />'; $pic++; } $content .= '</marquee></p><p style="text-align:center;"><a href="' . URL::index($cpg_dir) . '">' . _coppermineLANG . '</a></p>';
} $cpg_block = true; require "modules/" . $cpg_dir . "/include/load.inc"; $cpg_block = false; // $length = $CONFIG['thumbcols']; //number of thumbs $length = 5; //number of thumbs $title_length = 15; //length of title below thumb // marquee info at http://www.faqs.org/docs/htmltut/_MARQUEE.html $content = '<p style="text-align:center;"><a name="scroller"></a><marquee loop="1" 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 pid, filepath, filename, hits, 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 hits DESC LIMIT {$length}"); $pic = 0; $thumb_title = $views_title = ''; 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); } } truncate_stringblocks($thumb_title, $title_length); $views_title = sprintf($lang_get_pic_data['n_views'], $row['hits']); $content .= '<a href="' . URL::index($cpg_dir . '&file=displayimage&meta=topn&cat=0&pos=' . $pic) . '"><img src="' . get_pic_url($row, 'thumb') . '" border="0" alt="' . $thumb_title . '" title="' . $thumb_title . '" /><br />' . $views_title . '</a><br /><br />'; $pic++; } $content .= '</marquee></p><p style="text-align:center;"><a href="' . URL::index($cpg_dir) . '">' . _coppermineLANG . '</a></p>';
$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 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 GROUP BY pid ORDER BY RAND() DESC LIMIT {$limit}"); } // marquee info at http://www.faqs.org/docs/htmltut/_MARQUEE.html $content = '<div style="text-align:center;"><a name="scroller"></a><marquee loop="0" behavior="scroll" direction="left" height="125" width="80%" scrollamount="2" scrolldelay="1" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'>'; $content .= '<table width="100%" cols="' . $limit . '" border="0" cellpadding="0" cellspacing="7"><tr align="center">'; 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="' . URL::index("{$cpg_dir}&file=displayimage&album=" . $row['aid'] . "&pid=" . $row['pid']) . '"><img src="' . get_pic_url($row, 'thumb') . '" alt="' . $thumb_title . '" title="' . $thumb_title . '" /><br />' . truncate_stringblocks($thumb_title, $title_length) . '</a> </td>'; } $content .= '</tr></table></marquee></div><p style="text-align:center;"><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr align="center"><td valign="baseline"><a href="' . URL::index("{$cpg_dir}") . '">' . _coppermineLANG . '</a><br /></td></tr></table></p>';