<?
$num = 5;
$substr = 27;

$DB->query("SELECT * FROM mkp_reviews ORDER BY id DESC LIMIT 0,".$num);

$content='<table width=100% cellspacing=0 cellpadding=0>';

$i = 1;
while($res=$DB->fetch_row())
{
  $title1 = $res["title"];
   $title = substr($res["title"],0,$substr);
if(strlen($title1)>$substr)
  {
   $title.='...';
}

   $content.='<tr><td bgcolor=silver><a style="font-weight:bold" title="'.$res["title"].'" href=?ind=reviews&op=entry_view&iden='.$res["id"].'>'.$title.'</a></td><td align=center></td></tr>
<tr><td>'.substr(strip_tags($res["review"]),0,100).'...</td></tr>
';
   $i++;
}

$content.='</table>';
?>

<?
//=======//
//         MKPortal Top Photos Block           //
//                  By Dexter                  //
//                  (c) 2005                   //
//=======//

$limit = 10;

$text = '
<script language="JavaScript">

function select_elem(elem)
{
   if(document.all[elem].style.display == "none")
   {
       document.all[elem].style.display = "";
   }else{
       document.all[elem].style.display = "none";
   }
}
</script>
<table width="100%">
<tr><td bgcolor="silver">#</td><td bgcolor="silver">Название</td><td bgcolor="silver">looks</td><td bgcolor="silver">Rate</td></tr>
';

$q = $DB->query("SELECT * FROM mkp_gallery WHERE evento='5' AND trate>'20' ORDER BY rate DESC LIMIT 0,$limit");
$i = 1;
while($res = $DB->fetch_row($q))
{
   $img = $res["file"];
   $size = getimagesize("mkportal/modules/gallery/album/".$img);
   $h = $size[1]*150/$size[0];
   $h = ceil($h);
   $q2 = $DB->query("SELECT * FROM mkp_gallery_comments WHERE identry='".$res[id]."'");
$comments = mysql_num_rows($q2);

$text.='<tr><td align="center">'.$i.'</td><td><span style="cursor: hand; text-decoration: underline" onclick="select_elem(\'sp_'.$i.'\')"><b>'.$res["titolo"].'</b></span></td><td>'.$res['click'].'</td><td>'.$res['rate'].'</td></tr>';
   $text.='<tr><td colspan="4" align="center"><span style="display: none" id="sp_'.$i.'"><a href=?ind=gallery&op=foto_show&ida='.$res["id"].'><img src=mkportal/modules/gallery/album/'.$img.' border="3" style="border-color: silver" width=150 height='.$h.'></a></span></td></tr>';
$text.='<tr><td colspan="2">Голосов: <b>'.$res["trate"].'</b></td><td colspan="2">Комментов: <b>'.$comments.'</b></td></tr>';
$text.='<tr><td height="1px" bgcolor="silver" colspan="4"></td></tr>';
$i++;
}

$text.='</table><div style="font-size:8px; font-color:silver" align="center">Для просмотра миниатюры нажмите на название фото.</div>
<div style="font-size:8px; font-color:silver" align="center">Фотографии упорядочиваются по среднему рейтингу</div>
';

$content = $text;
?>

<?

$content =<<<EOF
<script language='JavaScript'>
 var ar=new Array('links_page', 'links_radio', 'links_server', 'links_service');
 var ar2=new Array('links_td_page', 'links_td_radio', 'links_td_server', 'links_td_service');
 function links_show(suf, suf2){  
 
  for (i=0; i<ar.length; i++){
   document.getElementById(ar[i]).style.display = 'none';                        
   document.getElementById(ar2[i]).className = 'nosel';  
  }
  document.getElementById(suf).style.display = 'block';
  document.getElementById(suf2).className = 'sel';                        
                       
 }
</script>
<style>
.nosel {border:0px; border-bottom: 1px solid #cccccc; background-color:#efefef;}
.sel {border: 0px;  border-top: 1px solid #cccccc;  border-left: 1px solid #cccccc;  border-right: 1px solid #cccccc;}
</style>
<table width=100% cellpadding=0 cellspacing=0>
 <tr>
  <td align=center style='padding: 0px 5px 0px 5px;' class='nosel' id='links_td_page' onmouseover="links_show('links_page', 'links_td_page')">page</td><td align=center style='padding: 0px 5px 0px 5px;' class='nosel' id='links_td_radio' onmouseover="links_show('links_radio', 'links_td_radio')">radio</td><td align=center style='padding: 0px 5px 0px 5px;' class='sel' id='links_td_server' onmouseover="links_show('links_server', 'links_td_server')">server</td><td align=center style='padding: 0px 5px 0px 5px;' class='nosel' id='links_td_service' onmouseover="links_show('links_service', 'links_td_service')">service</td><td align=center </td>
 </tr>
</table>
<table width=100% style='border-bottom:1px solid #cccccc;'><Tr><td id='links_page' style='display: none'>
   
    <table width=100% cellpadding=5 cellspacing=0>
   
  <tr><td><a href='http://cod.lan'>cod.lan</a></td>
   <td align=right><a href='ftp://cod.lan/'>upload</a></td></tr>
  <tr><td><a href='http://bbs.ncn.lan//'>Доска объявлений</a></td>
   <td align=right><a href=''></a></td></tr>
  <tr><td><a href='http://www.blog.lan/'>blog.lan</a></td>
   <td align=right><a href='ftp://blog.lan/'>ftp</a></td></tr>
  <tr><td><a href='http://www.soft.lan'>soft.lan</a></td>
   <td align=right><a href=''></a></td></tr>
  <tr><td><a href='http://technics.lan'>technics.lan</a></td>
   <td align=right><a href=''></a></td></tr>
  <tr><td><a href='http://www.wdp.lan'>www.wdp.lan</a></td>
   <td align=right></td></tr>
  <tr><td><a href=''></a></td>
   <td align=right><a href=''></a></td></tr>
    </table>
   </td></tr><Tr><td id='links_radio' style='display: none'>
   
    <table width=100% cellpadding=5 cellspacing=0>
   
  <tr><td><a href='http://fmradio.lan'>FMRadio</a></td>
   <td align=right><a href=''></a></td></tr>
  <tr><td><a href='mms://fmradio.lan/delta'>mms://fmradio.lan/delta</a></td>
   <td align=right><a href=''></a></td></tr>
  <tr><td><a href='mms://fmradio.lan/dinamit'>mms://fmradio.lan/dinamit</a></td>
   <td align=right><a href=''></a></td></tr>
  <tr><td><a href='mms://fmradio.lan/rocord'>mms://fmradio.lan/record</a></td>
   <td align=right><a href=''></a></td></tr>
  <tr><td><a href='mms://fmradio.lan/europe'>mms://fmradio.lan/europe</a></td>
   <td align=right><a href=''></a></td></tr>
  <tr><td><a href='mms://fmradio.lan/avto'>mms://fmradio.lan/avto</a></td>
   <td align=right><a href=''></a></td></tr>
    </table>
   </td></tr><Tr><td id='links_server' style='display: block'>
   
    <table width=100% cellpadding=5 cellspacing=0>
   
  <tr><td><a href='http://first.lan/'>First Rescue</a></td>
   <td align=right><a href='ftp://first.lan/'>ftp</a></td></tr>
  <tr><td><a href='http://funk.lan'>Funk</a></td>
   <td align=right><a href='ftp://funk.lan'>ftp</a></td></tr>
  <tr><td><a href='http://www.kair.net'>KairNet</a></td>
   <td align=right><a href='ftp://kairnet.lan'></a></td></tr>
  <tr><td><a href='http://northline.lan'>Northline</a></td>
   <td align=right><a href='ftp://northline:2121/'>upload</a></td></tr>
  <tr><td><a href='http://ultimate.lan'>UltimateG</a></td>
   <td align=right><a href='ftp://ultimate.lan'>ftp</a></td></tr>
    </table>
   </td></tr><Tr><td id='links_service' style='display: none'>
   
    <table width=100% cellpadding=5 cellspacing=0>
   
  <tr><td><a href='http://billing.ncn.lan'>billing.ncn.lan</a></td>
   <td align=right><a href=''></a></td></tr>
  <tr><td><a href='http://icq.ncn.lan/'>Регистрация в сетевой ICQ</a></td>
   <td align=right><a href=''></a></td></tr>
  <tr><td><a href='http://cityline.lan/client/client.php'>Счёт CityLine</a></td>
   <td align=right><a href=''></a></td></tr>
  <tr><td><a href='http://172.22.64.253/~nakovalnya/'>Счёт Kaircom</a></td>
   <td align=right><a href=''></a></td></tr>
    </table></td></tr></table>

EOF;


?>