View file ajax/php/smiles.php

File size: 1.63Kb
<?php 

include_once $_SERVER['DOCUMENT_ROOT'].'/sys/inc/home.php';
include_once H.'sys/inc/start.php';

if (!isset($_GET['dir'])) {
    $_SESSION['category'] = 21;
} else {
    $_SESSION['category'] = (int) $_GET['dir'];
}

$cache = new Cache(600); 
$cacheId = md5('ajax.smiles.' . $_SESSION['category']); 

$smiles = $cache->read($cacheId);

if ($smiles) {
    die($smiles);
}

include_once H.'sys/inc/sess.php';
include_once H.'sys/inc/settings.php';
include_once H.'sys/inc/db_connect.php';

if (!isset($_SESSION['category']) || mysql_result(mysql_query("SELECT COUNT(*) FROM `smile_dir` WHERE `id`='" . $_SESSION['category'] . "'"),0) == 0)
{	
  	$category = mysql_fetch_assoc(mysql_query("SELECT * FROM `smile_dir` LIMIT 1"));
  	$_SESSION['category'] = $category['id'];
}

$q = mysql_query("SELECT * FROM `smile` WHERE `dir`='" . $_SESSION['category'] . "' ORDER BY id DESC ");

ob_start(); 
echo '<div class="layer">';
while($post = mysql_fetch_array($q)) {
	  echo '<a href="javascript:emoticon(\''.$post['smile'].'\')"><img src="/style/smiles/' . $post['id'] . '.gif" 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).') ';
}
$end = ob_get_contents();
ob_end_clean();

echo $cache->write($cacheId, $end);