<?php
require_once "maincore.php";
require_once THEMES."templates/header.php";
echo"<script type='text/javascript' src='".INCLUDES."title.js'></script>";
?>
<style type="text/css">
 
tooltip {
   font-family: Verdana, Arial, Helvetica, sans-serif;
   font-size: 10px;
   color: #ffffff;
   position: absolute;
   z-index: 3000;
   /*border: 1px solid #111;*/
   background-color: #000;
   padding: 5px;
 
}
 
tooltip h3, #tooltip div { margin: 0;  }
 
div#qTip {
 padding: 5px;
 border: 0px solid #666;
 display: none;
 background: #000;
 color: #FFFFFF;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
 text-align: left;
 position: absolute;
 z-index: 1000;
 
</style>
<?php
 
 
 $items_per_page = 16;
 
 
  if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { 
  $_GET['rowstart'] = 0; 
}
 
 $rows = dbcount("(*)", DB_NEWS, "news_draft='0'");   
//opentable("");
 
    //$result = dbquery("SELECT * FROM ".$db_prefix."news ORDER BY news_datestamp DESC LIMIT 0,4");
$result = dbquery(
    "SELECT * FROM ".DB_NEWS." 
     WHERE news_draft='0' ORDER BY news_datestamp DESC 
     LIMIT ".$_GET['rowstart'].",$items_per_page"
 );
 
 
if (dbrows($result) != 0) {
      $counter = 0; $columns = 4;
      echo"<table cellpadding='0' cellspacing='0' width='100%' style='padding:5px;'>\n<tr>\n";
while($data = dbarray($result)) {
//$kat = dbresult(dbquery("SELECT download_cat_name FROM ".$db_prefix."download_cats WHERE download_cat_id='$id'"), 0);
if ($counter != 0 && ($counter % $columns == 0)) { echo "</tr>\n<tr>\n"; }
 
            $wynik = dbquery("SELECT SUM(rating_vote) FROM ".DB_RATINGS." WHERE rating_type='N' AND rating_item_id='".$data['news_id']."'");
                $info2 = dbresult($wynik,0);
                $num_rating = dbcount("(rating_vote)", DB_RATINGS, "rating_type='N' AND rating_item_id='".$data['news_id']."'");
                $wyn_rating = ($num_rating ? $info2 / $num_rating : 0);
$komentarai = dbcount("(comment_id)", DB_COMMENTS, "comment_type='N' AND comment_item_id='".$data['news_id']."'");
   // $tas = trimlink($data['news_news'], 600);
    $tas = $data['news_breaks'] == "y" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news']);
 
echo"<td  style='padding:5px;'>";
 
   echo "<table cellpadding='0' cellspacing='0' width='150' class='borderis' onmouseover=\"className='borderis2'\" onmouseout=\"className='borderis'\">\n<tr>\n";
 
   echo"<td colspan='2' align='center'><a href='/news.php?readmore=".$data['news_id']."' tit='<table width=260px><tr><td class=c>
<b><span style=color:#0099FF;font-size:12px;>".$data['news_subject']."</span></b><br>$tas<br>
<b>Žiūrėjo: ".$data['news_reads']."</b>
 
</td></tr>
</table>'><img src='".IMAGES_N.$data['news_image']."' width='160' height='245' /></a></td>";
 
   echo"</tr>
   <td width='105' style='padding:2px;'><img src='".THEME."images/retitingai/".ceil($wyn_rating).".png' width='80' height='13' alt='".ceil($wyn_rating)."' style='vertical-align:middle;' title='".ceil($wyn_rating)."' /></td>
   <td class='c' align='right'><a href='/news.php?readmore=".$data['news_id']."'>Žiūrėti</a></td>
   </tr>";
 
   echo"</table>";   
 
 
 
echo "</td>\n" ;
$counter++;
}
echo "</tr>\n</table>\n";
 
}
 
 
//closetable();   
echo"<div align='center'>";
if ($rows > $items_per_page) {
    echo makepagenav($_GET['rowstart'], $items_per_page, $rows, 3);
}
 
require_once THEMES."templates/footer.php";
 
?>