<?php $sql_result = $db->query( "SELECT p.id, p.date, p.short_story, p.xfields, p.title, p.category, p.alt_name FROM " . PREFIX . "_post p LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) WHERE p.approve=1 ORDER BY RAND() LIMIT 0,2" );

while ( $row = $db->get_row())
{
   
   $row['date'] = strtotime( $row['date'] );$row['category'] = intval( $row['category'] );

if( $config['allow_alt_url'] == "yes")

{
   if( $row['flag'] and $config['seo_type']){if( $row['category'] and $config['seo_type'] == 1 )
{
   $full_link = $config['http_home_url'] . get_url( $row['category'] ) . "/" . $row['id'] . "-" . $row['alt_name'] . ".html";}else{$full_link = $config['http_home_url'] . $row['id'] . "-" . $row['alt_name'] . ".html";}
   }else{$full_link = $config['http_home_url'] . date( 'Y/m/d/', $row['date'] ) . $row['alt_name'] . ".html";}}

else{$full_link = $config['http_home_url'] . "index.php?newsid=" . $row['id'];}$title = substr( $row['title'], 0, 73 ) . "...";$short_story = substr( strip_tags($row['short_story']), 0, 0 )."...";



$xfieldsdata = xfieldsdataload( $row['xfields'] );
   
$image= $xfieldsdata[poster_news];


echo('<a class="catName" href="'.$full_link.'" title=Смотреть {title} онлайн><table border="0" cellpadding="0" cellspacing="0">
<tbody><tr>

<td width="18" background="{THEME}/images/ram/tl.png" height="18">
</td>
<td background="{THEME}/images/ram/tm.png" height="18">
</td>

<td width="18" background="{THEME}/images/ram/tr.png" height="18">
</td>
</tr>
<tr>
<td width="18" background="{THEME}/images/ram/ml.png">
</td>
<td><img align="center" src="'.$image.'" width="180" height="150"></td>
<td width="18" background="{THEME}/images/ram/mr.png">
</td>
</tr>
<tr>
<td width="18" background="{THEME}/images/ram/bl.png" height="18">
</td>
<td background="{THEME}/images/ram/bm.png" height="18">
</td>

<td width="18" background="{THEME}/images/ram/br.png" height="18">
</td>
</tr>
</tbody></table><br />'.$title.'</a>')
;}
?>