<?//-*- C++ -*-
/*   ********************************************************************   **
**   Copyright (C) 1995-2000 Michael Oertel                                 **
**   Copyright (C) 2000-     PHPOpenChat Development Team                   **
**   http://www.ortelius.de/phpopenchat/                                    **
**                                                                          **
**   This program is free software. You can redistribute it and/or modify   **
**   it under the terms of the PHPOpenChat License Version 1.0              **
**                                                                          **
**   This program is distributed in the hope that it will be useful,        **
**   but WITHOUT ANY WARRANTY, without even the implied warranty of         **
**   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.                   **
**                                                                          **
**   You should have received a copy of the PHPOpenChat License             **
**   along with this program.                                               **
**   ********************************************************************   */

include ("defaults_inc.php");
/*
 * Open a database connection
 * The following include returns a database handle
 */
include ("connect_db_inc.php");
$db_handle=connect_db($DATABASEHOST,$DATABASEUSER,$DATABASEPASSWD);
if(!$db_handle){
  exit;//the error message is printed in connect_db_inc.php
}

$query = 'select smiley, count from smiley_stats_last24 order by count desc limit 30';
$result_today=mysql_query($query,$db_handle);
$query = 'select smiley, c as count from smiley_stats_lastweek order by count desc limit 30';
$result_week=mysql_query($query,$db_handle);
$query = 'select smiley, c as count from smiley_stats_lastmonth order by count desc limit 30';
$result_month=mysql_query($query,$db_handle);
if($_SESSION['nick'] != ''){
	$query = "select smiley, count(*) as count from smiley_stats where nick = '".$_SESSION['nick']."' group by smiley order by count desc limit 30";
	$result_nick=mysql_query($query,$db_handle);
}

while($row = mysql_fetch_assoc($result_today)){
	$data['today'][] = $row;
}
while($row = mysql_fetch_assoc($result_week)){
	$data['week'][] = $row;
}
while($row = mysql_fetch_assoc($result_month)){
	$data['month'][] = $row;
}
if($_SESSION['nick'] != ''){
	while($row = mysql_fetch_assoc($result_nick)){
		$data['nick'][] = $row;
	}
}

// put full path to Smarty.class.php
require_once('/usr/share/php/smarty/libs/Smarty.class.php');
$smarty = new Smarty();
$smarty->template_dir = '/home/www/schulhofchat/includes/templates';
$smarty->compile_dir = '/home/www/schulhofchat/includes/templates_c';
$smarty->cache_dir = '/home/www/schulhofchat/includes/cache';
$smarty->config_dir = '/home/www/schulhofchat/includes/configs';
$smarty->assign('data',$data);
$smarty->display('topsmileys.tpl');

?>