Файл: public_html/ajax/php/smiles.php
Строк: 41
<?
include_once '../../sys/inc/start.php';
include_once '../../sys/inc/compress.php';
include_once '../../sys/inc/sess.php';
include_once '../../sys/inc/home.php';
include_once '../../sys/inc/settings.php';
include_once '../../sys/inc/db_connect.php';
include_once '../../sys/inc/ipua.php';
include_once '../../sys/inc/fnc.php';
include_once '../../sys/inc/user.php';
if (!isset($_GET['dir']))
{
$_SESSION['category'] = 21;
}else{
$_SESSION['category'] = $_GET['dir'];
}
if (!isset($_SESSION['category']) || mysql_result(mysql_query("SELECT COUNT(*) FROM `smile_dir` WHERE `id`='".intval($_SESSION['category'])."'"),0) == 0)
{
// Находим id категории если ранее не смотрели
$category = mysql_fetch_assoc(mysql_query("SELECT * FROM `smile_dir` LIMIT 1"));
$_SESSION['category'] = $category['id'];
}
$q = mysql_query("SELECT * FROM `smile` WHERE `dir`='".intval($_SESSION['category'])."' ORDER BY id DESC ");
echo '<div class="layer">';
while($post = mysql_fetch_array($q)){
echo '<a href="javascript:emoticon(''.$post['smile'].'')"><img src="/style/smiles/' . $post['name'] . '" title="'.$post['smile'].'" /></a>';
}
echo '</div>';
echo '<div class="title">Категории</div>';
$q=mysql_query("SELECT * FROM `smile_dir` ORDER BY id ASC");
while ($dir = mysql_fetch_assoc($q))
{
echo '<a onclick="showContent2('/ajax/php/smiles.php?dir='.$dir['id'].'')" class="onclick">' . htmlspecialchars($dir['name']) . '</a> ';
echo '('.mysql_result(mysql_query("SELECT COUNT(*) FROM `smile` WHERE `dir` = '$dir[id]'"),0).') ';
}
?>