<?php
if(!defined('DATALIFEENGINE'))
{
  die("Hacking attempt!");
}
$top_users = dle_cache ("top_users", $config['skin']);
if(!$top_users)
{
  $top_users = "<h3>Топ журналістів</h3>";
  $query  = "SELECT `".PREFIX."_users`.name,COUNT(`".PREFIX."_users`.name) AS count
            FROM `".PREFIX."_users`,`".PREFIX."_post`
            WHERE `".PREFIX."_users`.name = `".PREFIX."_post`.autor ORDER by count
            GROUP BY `".PREFIX."_users`.name";
  $result = $db->query($query);
  while ($row = $db->get_row($result))
  {
    $top_users .= "<a href=".$config['http_home_url']."user/".$row['name']."/>".$row['name']."</a> - ".$row['count']."<br>";
  }
  create_cache("top_users", $top_users);
}

?>

$tpl->load_template('main.tpl');

$tpl->set('{top_users}',$top_users);

{top_users}

require_once ENGINE_DIR.'/modules/top_users.php';