opentable("Последние обновления");
echo "<table border=0 width=100%><td align=left width=100%><a href='".BASEDIR."articles.php'><b>Статьи</b></a></td></table>";
$result = dbquery(
"SELECT ta.*,tac.* FROM ".$db_prefix."articles ta
INNER JOIN ".$db_prefix."article_cats tac ON ta.article_cat=tac.article_cat_id
WHERE ".groupaccess('article_cat_access')." ORDER BY article_datestamp DESC LIMIT 0,3"
);
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['article_subject'], 120);
$itemsubject2 = trimlink($data['article_cat_name'], 30);
echo "<table border=0 width=100%><td align=left width=25%><a href='".BASEDIR."articles.php?cat_id=".$data['article_cat_id']."' title='".$data['article_cat_name']."' class='side'><font color='#808080'>$itemsubject2</font></a></td><td width=57%><img src='/images/icons/bullet.gif' alt=''> <a href='".BASEDIR."readarticle.php?article_id=".$data['article_id']."' title='".$data['article_subject']."' class='side'>$itemsubject</a></td><td align=right width=18%><font color='#808080'>".showdate("longdate", $data['article_datestamp'])."</font></td></table>\n";
}
} else {
echo "<center>".$locale['004']."</center>\n";
}

echo "<table border=0 width=100%><td align=left width=100%><a href='".BASEDIR."infusions/video_infusion/videos.php'><b>Видео</b></a></td></table>";
$result = dbquery(
"SELECT ta.*,tac.* FROM ".$db_prefix."videos ta
INNER JOIN ".$db_prefix."video_cats tac ON ta.video_cat=tac.video_cat_id
WHERE ".groupaccess('video_cat_access')." ORDER BY video_datestamp DESC LIMIT 0,3"
);
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$vidsubject = trimlink($data['video_title'], 120);
$vidsubject2 = trimlink($data['video_cat_name'], 30);
echo "<table border=0 width=100%><td align=left width=25%><a href='".BASEDIR."infusions/video_infusion/videos.php?cat_id=".$data['video_cat_id']."' title='".$data['video_cat_name']."' class='side'><font color='#808080'>$vidsubject2</font></a></td><td width=57%><img src='/images/icons/bullet.gif' alt=''> <a href='".BASEDIR."infusions/video_infusion/videos.php?view=".$data['video_id']."' title='".$data['video_title']."' class='side'>$vidsubject</a></td><td align=right width=18%><font color='#808080'>".showdate("longdate", $data['video_datestamp'])."</font></table>\n";
}
} else {
echo "<center>".$locale['004']."</center>\n";
}

echo "<table border=0 width=100%><td align=left width=100%><a href='".BASEDIR."photogallery.php'><b>Фотогалерея</b></a></td></table>";
$result = dbquery(
"SELECT ta.*,tac.* FROM ".$db_prefix."photos ta
INNER JOIN ".$db_prefix."photo_albums tac ON ta.album_id=tac.album_id
WHERE ".groupaccess('album_access')." ORDER BY photo_datestamp DESC LIMIT 0,1"
);
$rows = dbrows($result);
if ($rows!=0) {
while ($data = dbarray($result)) {
$photos_count = dbcount("(*)","photos","album_id=".$data['album_id']);
$photosubject = trimlink($data['album_title'], 30);
echo "<table border=0 width=100%><td align=left width=25%><a href='".BASEDIR."photogallery.php?album_id=".$data['album_id']."'><font color='#808080'>$photosubject</font></a></td><td width=57%><img src='".THEME."images/bullet.gif' alt='bullet' /> <a href='".BASEDIR."photogallery.php?album_id=".$data['album_id']."'>".$photos_count." фото</a></td><td align=right width=18%><font color='#808080'>".showdate("longdate", $data['photo_datestamp'])."</font></table>\n";
}
}

closeside();
?>