Miscellany

<?
//Copyright by Stefan Jungbauer
//www.zocker-eppingen.de
//V 1.1

defined ('main') or die ( 'no direct access' );

	$laenge = 25;

echo '<b>&nbsp;&nbsp;Newest Downloads</b>';

$erg = db_query("SELECT prefix_downloads.cat,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%Y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by prefix_downloads.id DESC LIMIT 0,5");

$i = 0;
  while ($row = db_fetch_object($erg)) { 
$i++;	
$user = $row->name;
	if(strlen($user) > $laenge ){
			  $user = ''.substr($user, 0, $laenge ).'...';
			}

echo'
<table width="100%" cellspacing="0" cellpadding="0" height="13" style="padding-left:10px;">
<tr><td>&nbsp;'.$i.'.&nbsp;<a href="?downloads-show-'.$row->id.'">&nbsp;'.$user.'</a></td></tr>
</table>';


  }

echo '<hr color="#000000" size="1px" style="margin-top:4px"><b>&nbsp;&nbsp;Top Downloads</b>';
$a = 0;
$erg = db_query("SELECT prefix_downloads.cat,hits,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%Y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by hits DESC LIMIT 0,5");
  while ($row = db_fetch_object($erg)) { 
$a++;
	
	$name = $row->name;
	if(strlen($name) > $laenge ){
			  $name = ''.substr($name, 0, $laenge ).'...';
			}
echo'
<table width="100%" cellspacing="0" cellpadding="0" height="13" style="padding-left:10px;">
<tr><td>'.$a.'.&nbsp;<a href="?downloads-show-'.$row->id.'">&nbsp;'.$name.'</a></td></tr>
</table>';

  }



?>