Dragonfly CMS - German Community

<?php
if (!defined('CPG_NUKE')) { exit; }
echo '<br />';
OpenTable();
global $prefix, $db, $CONFIG, $cpg_dir;

$cpg_dir = 'coppermine';

if (!is_active($cpg_dir)) {
   echo '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=2; //number of thumbs
$userinfo = getusrdata($username);
$cpg_user_gallery = 10000+$userinfo['user_id'];


// END USER DEFINABLES
$getaid = $db->sql_query("select aid FROM ".$cpg_prefix."albums where category = '".$user_gallery."' GROUP BY aid");
$row1 = $db->sql_fetchrow($getaid);
$aid1 = $row1['aid'];

$result = $db->sql_query("select pid, filepath, filename FROM ".$cpg_prefix."pictures WHERE approved='YES'  AND aid = '".$aid1."' GROUP BY pid ORDER BY pid DESC LIMIT $length",false,__FILE__,__LINE__);

if (!$row1) {echo '<center><br>Kein Userbild von <b>'.$userinfo['username'].'</b> vorhanden !<br><br></center>';
            CloseTable(); }
            else {


echo '<center><h3><b>'.$userinfo['username'].'s</b> Userbild(er)</h3> <br>';


$pic = 0;
while ($row = $db->sql_fetchrow($result)) {

if (file_exists(get_pic_url($row,'normal'))){

   echo '<a href="' . getlink($cpg_dir . '&amp;file=displayimage&amp;meta=lastup&amp;cat='.$cpg_user_gallery.'&amp;pos=' . $pic) . '"><img src="' . get_pic_url($row,'normal') . '" border="0" alt="' . $thumb_title . '" title="' . $thumb_title . '" /></a> '; }
else {

   echo '<a href="' . getlink($cpg_dir . '&amp;file=displayimage&amp;meta=lastup&amp;cat='.$user_gallery.'&amp;pos=' . $pic) . '"><img src="' . get_pic_url($row,'normal') . '" border="0" alt="' . $thumb_title . '" title="' . $thumb_title . '" /></a>   '; }

   $pic++;
}
echo '<br /><br /><a href="'.getlink('coppermine&amp;cat='.$user_gallery).'">Usergallery</a></center></p>';
}
CloseTable();
?>