<?php
//Failo pavadinimas online_users_panel.php
//Sukurimo data: 2010.11.15 16:46
//Kurtas Neaglezzz
//Skype assassin.k.
 
//JavaScript
echo "<link rel='stylesheet' type='text/css' href='".INFUSIONS."online_users_panel/javascript/Script.css' />
<script src='".INFUSIONS."online_users_panel/javascript/Script_01.js' type='text/javascript'></script>
<script src='".INFUSIONS."online_users_panel/javascript/Script_02.js' type='text/javascript'></script>";
//
 
if (!defined("IN_FUSION")) { header("Location: ../../index.php"); exit; }
 
$time_1= date('d');
$time_2= date('m');
$time_3= date('Y');
$time_4 = mktime(0,0,0,$time_2,$time_1,$time_3);
$time_5 = mktime(23,59,59,$time_2,$time_1,$time_3);
$time_6 = mktime(0,0,0,$time_2,$time_1-1,$time_3);
$time_7 = mktime(23,59,59,$time_2,$time_1-1,$time_3);
 
if ($settings['maintenance'] != "1") {
	$cond = ($userdata['user_level'] != 0 ? "'".$userdata['user_id']."'" : "'0' AND online_ip='".USER_IP."'");
	$result = dbquery("SELECT * FROM ".$db_prefix."online WHERE online_user=".$cond."");
	if (dbrows($result) != 0) {
		$result = dbquery("UPDATE ".$db_prefix."online SET online_lastactive='".time()."' WHERE online_user=".$cond."");
	} else {
		$name = ($userdata['user_level'] != 0 ? $userdata['user_id'] : "0");
		$result = dbquery("INSERT INTO ".$db_prefix."online (online_user, online_ip, online_lastactive) VALUES ('$name', '".USER_IP."', '".time()."')");
	}
	$result = dbquery("DELETE FROM ".$db_prefix."online WHERE online_lastactive<".(time()-60)."");
	$naujokas = dbarray(dbquery("SELECT user_id,user_name FROM ".$db_prefix."users WHERE user_status='0' ORDER BY user_joined DESC LIMIT 0,1"));
	$resultatas = dbquery("SELECT ton.*, tu.user_id,user_name FROM ".$db_prefix."online ton LEFT JOIN ".$db_prefix."users tu ON ton.online_user=tu.user_id");
	$guests = 0; $members = 0;
	while ($data = dbarray($resultatas)) {
		if ($data['online_user'] == "0") {
			$guests++;
		} else {
			$members++;
		}
	}
	$isvis = ($members+$guests);
 
	openside("Vartotojų statistika");
 
echo "
<br><img src='http://www.iconarchive.com/icons/fasticon/fast-icon-users/16/user-icon.png'><b>Narių Statistika:</b><br>";
 
 
$data = dbarray(dbquery("SELECT user_id,user_name FROM ".$db_prefix."users WHERE user_status='0' ORDER BY user_joined DESC LIMIT 0,1"));
echo "<span class='small'>&#194;°</span> ".$locale['on117']."<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side' title='".$data['user_name']."'>".trimlink($data['user_name'], 12)."</a><br />\n";$tag1= date('d');
$tag1= date('d');
$monat1= date('m');
$jahr1= date('Y');
$hanfang = mktime(0,0,0,$monat1,$tag1,$jahr1);
$hende = mktime(23,59,59,$monat1,$tag1,$jahr1);
$ganfang = mktime(0,0,0,$monat1,$tag1-1,$jahr1);
$gende = mktime(23,59,59,$monat1,$tag1-1,$jahr1);
 
$result = mysql_query("SELECT user_level FROM ".$db_prefix."users where user_level=103");
$num_rows = mysql_num_rows($result);
//display the result
echo "&#194;° Super Administratorių: ".$num_rows."</a><br>\n";
 
$result = mysql_query("SELECT user_level FROM ".$db_prefix."users where user_level=102");
$num_rows = mysql_num_rows($result);
//display the result
echo "&#194;° Administratorių: ".$num_rows."</a><br>\n";
$result = mysql_query("SELECT user_level FROM ".$db_prefix."users where user_level=102");
$num_rows = mysql_num_rows($result);
//display the result
echo "&#194;° Forumo Moderatorių: ".$num_rows."</a><br>\n";
$result = dbquery("SELECT count(group_id) FROM ".$db_prefix."user_groups");
echo "&#194;° Vartotojų grupių: [".dbresult($result, 0)."]<br>";
echo "<hr />\n".THEME_BULLET." ".$locale['global_014'].": ".number_format(dbcount("(user_id)", DB_USERS, "user_status<='1'"))."<br />\n";
echo "
<hr>
<b><img src='http://www.iconarchive.com/icons/dan-wiersma/solar-system/16/Earth-icon.png'>SvetainÄ—s Statistika:</b><br>";
$result = dbquery("SELECT count(news_id) FROM ".$db_prefix."news");
echo "&#194;° Naujienų: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads");
echo "&#194;° Siuntinių: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(photo_id) FROM ".$db_prefix."photos");
echo "&#194;° Nuotraukų: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(post_id) FROM ".$db_prefix."posts");
echo "&#194;° Forumo praneÅ&#161;imų: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(comment_id) FROM ".$db_prefix."comments");
echo "&#194;° Komentarų: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(shout_id) FROM ".$db_prefix."shoutbox");
echo "&#194;° Å aukyklos praneÅ&#161;imų: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(poll_id) FROM ".$db_prefix."polls");
echo "&#194;° Apklausų: [".dbresult($result, 0)."]<br>";
 
echo "<br><img src= '".INFUSIONS."online_users_panel/images/on-off.png'> PrisijungÄ™:<br><br>";
 
$result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_lastvisit>'0' AND user_status='0' ORDER BY user_lastvisit DESC LIMIT 10");
 
echo "<table cellpadding='0' cellspacing='0' width='100%'>";
		if (dbrows($result) != 0) {
		while ($data = dbarray($result)) {
		$laikas = time() - $data['user_lastvisit'];
		$laikasoff ="<img src= '".INFUSIONS."online_users_panel/images/offline.png' title='Atsijunges'>";
		$laikason = "<img src= '".INFUSIONS."online_users_panel/images/online.gif' title='Prisijunges'>";
		$laikas1=sprintf("%2d",floor($laikas/604800));
		$laikas2=sprintf("%2d",floor($laikas/(60*60*24)));
 
 
		if ($laikas < 60){
		$laikas = $laikason;
		} elseif ($laikas < 360){
		$laikas = $laikasoff;
		} elseif ($laikas1 > 0){
		if ($laikas1 == 1) {}
		$laikas = $laikasoff;
		} elseif ($laikas2 > 0){
		if ($laikas2 == 1) {}
		$laikas = $laikasoff;
		} else {
		$laikas = $laikasoff;
		}
		$userimg = "<img src= '".INFUSIONS."online_users_panel/images/user.png'>";
		$spalvaR = "<span style='color:#b40101'>"; //Raudona
		$spalvaZ = "<span style='color:#6ab401'>"; //?alia
		$spalvaB = "<span style='color:#000000'>"; //Juoda
		if($data['user_level'] == 103){ $atsakymas=$userimg; $spalva=$spalvaR;}
		if($data['user_level'] == 102){ $atsakymas=$userimg; $spalva=$spalvaZ;}
		if($data['user_level'] == 101){ $atsakymas=$userimg; $spalva=$spalvaB;}
		echo "<tr>\n<td class='small' align='left'>\n";
		echo "$atsakymas<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' title='Vartotojas - ".$data['user_name']."' class='small'>\n";
		echo " $spalva".trimlink($data['user_name'], 30)."</a></span>";
		if (iMEMBER) {	
		echo "<a href='".BASEDIR."messages.php?msg_send=".$data['user_id']."' target='_blank'><img src= '".INFUSIONS."online_users_panel/images/pm.png' border='0' title='Siøsti PM &#254;inute' ></a>";
		}
		echo "</td><td class='small' align='right'>".$laikas."</td>\n</tr>\n";
 
 
 
	}
}
echo "</table>";
echo "
<br><img src='http://www.scream.lt/infusions/online_users_panel/images/coment.png'><b>Daugiausiai komentarų paraÅ&#161;Ä—:</b><br>";
$result=dbquery("SELECT user_name, user_location, user_icq, user_id, count(user_id) AS comment_count FROM ".$db_prefix."comments INNER JOIN
".$db_prefix."users ON comment_name=user_id GROUP BY user_name ORDER BY comment_count DESC LIMIT 0,5");
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
if(dbrows($result)!=0){
while($data=dbarray($result)){
echo "<tr><td class='small2' align='left'>  <img src='".THEME."images/bullet.gif'> <a href='".BASEDIR."profile.php?lookup=$data[user_id]' class='side'>";
echo "$data[user_name]</a></td><td class='small2' align='right'>[$data[comment_count]]</td></tr>";
}
}
echo "</table>";
echo "
<br><img src='http://www.scream.lt/infusions/online_users_panel/images/coment.png'><b>Å aukyklos aktyviausi:</b><br>";
$result=dbquery("SELECT user_name, user_location, user_icq, user_id, count(user_id) AS shout_count FROM ".$db_prefix."shoutbox INNER JOIN
".$db_prefix."users ON shout_name=user_id GROUP BY user_name ORDER BY shout_count DESC LIMIT 0,5");
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
if(dbrows($result)!=0){
while($data=dbarray($result)){
echo "<tr><td class='small2' align='left'> <img src='".THEME."images/bullet.gif'> <a href='".BASEDIR."profile.php?lookup=$data[user_id]' class='side'>";
echo "$data[user_name]</a></td><td class='small2' align='right'>[$data[shout_count]]</td></tr>";
}
}
echo "</table>";
 
 
	closeside();
}
?>