<?php
/*===================================================+
|| # Woodpecker Housekeeping
|+====================================================+
|| # Copyright © 2008 SuperFun. All rights reserved.
|| # http://www.superfunn.nl/
|+===================================================+
|| # Notice: This is free software.
|+===================================================+
|| # Versions.
|| # Housekeeping version: V3.5
|| # Version of this file: V1.2 (chatlog.php)
|+===================================================+
||
|| # Usage of this page:
|| #  Chatlogs, via user, userid, or global.
||
|+===================================================*/

include('inc/header.php');
if(min_fuse('housekeeping_chatlog', $my_id)){
	if($_POST['submit_user']){
		$aa = mysql_query("SELECT * FROM users WHERE username = '".beveilig($_POST['user'])."'");
		$ab = mysql_num_rows($aa);
		$ac = mysql_fetch_array($aa);
		$a = mysql_query("SELECT * FROM moderation_chatlog WHERE userid = '".beveilig($ac['id'])."' ORDER BY timestamp DESC");
		$b = mysql_num_rows($a);
		if(empty($_POST['user'])){
			echo 'Vul een gebruiker in.';
		}elseif($ab < 1){
			echo 'Deze gebruiker bestaat niet.';
		}elseif($b < 1){
			echo 'Er zijn geen chatlogs van deze gebruiker.';
		}else{
			if($_POST['full_user'] == "1"){
				$a = mysql_query("SELECT * FROM moderation_chatlog WHERE userid = '".beveilig($ac['id'])."' ORDER BY timestamp DESC");
			}else{
				$a = mysql_query("SELECT * FROM moderation_chatlog WHERE userid = '".beveilig($ac['id'])."' ORDER BY timestamp DESC LIMIT 50");
			}
			if(mysql_num_rows($a) < 1){
				echo 'Er zijn op het moment geen chatlogs.';
			}else{
				if($_POST['full_user'] == "1"){
					echo '<b>Laat volledige chatlog zien';
				}else{
					echo '<b>Laat laatste 50 chatlogs zien</b><br>';
				}
				if($_POST['full_user'] != "1"){
					echo '<form method="post" action="./chatlog.php">';
					echo '<input type="hidden" name="user" value="'.$_POST['user'].'">';
					echo '<input type="hidden" name="full_user" value="1">';
					echo '<input type="submit" name="submit_user" value="Laat gebruikers chatlog zien">';
					echo '<br>';
				}
				echo '<br>';
				echo '<table border="1">';
				echo '<tr>';
				echo '<td><B>Tijd</B></td>';
				echo '<td><B>Gebruiker</B></td>';
				echo '<td><B>Kamer ID</B></td>';
				echo '<td><B>Ontvanger ID</B></td>';
				echo '<td><B>Type</B></td>';
				echo '<td><B>Bericht</B></td>';
				echo '</tr>';
				while($b = mysql_fetch_assoc($a)){
					echo '<tr>';
					echo '<td>'.$b['timestamp'].'</td>';
					echo '<td>'.gebruiker($b['userid']).'</td>';
					echo '<td>'.$b['roomid'].'</td>';
					if($b['receiverid'] != "0"){
						echo '<td>'.gebruiker($b['receiverid']).'</td>';
					}else{
						echo '<td><u>Niet gefluisterd</u></td>';
					}
					echo '<td>'.ucwords($b['type']).'</td>';
					echo '<td>'.htmlspecialchars($b['text']).'</td>';
					echo '<tr>';
					}
				echo '</table>';
			}
		}	
	}elseif($_POST['submit_room']){
		$aa = mysql_query("SELECT * FROM moderation_chatlog WHERE roomid = '".beveilig($_POST['room'])."'");
		$ab = mysql_num_rows($aa);
		$ac = mysql_fetch_array($aa);
		if(empty($_POST['room'])){
			echo 'Vul een gebruiker in.';
		}elseif(!is_numeric($_POST['room'])){
			echo 'Een kamer ID is een nummer.';
		}elseif($ab < 1){
			echo 'Er zijn geen chatlogs voor deze kamer.';
		}else{
			if($_POST['full_room'] == "1"){
				$a = mysql_query("SELECT * FROM moderation_chatlog WHERE roomid = '".beveilig($_POST['room'])."' ORDER BY timestamp DESC");
			}else{
				$a = mysql_query("SELECT * FROM moderation_chatlog WHERE roomid = '".beveilig($_POST['room'])."' ORDER BY timestamp DESC LIMIT 50");
			}
			if(mysql_num_rows($a) < 1){
				echo 'Er zijn op het moment geen chatlogs.';
			}else{
				if($_POST['full_room'] == "1"){
					echo '<b>Laat volledige chatlog zien';
				}else{
					echo '<b>Laat laatste 50 chatlogs zien</b><br>';
				}
				if($_POST['full_room'] != "1"){
					echo '<form method="post" action="./chatlog.php">';
					echo '<input type="hidden" name="room" value="'.$_POST['room'].'">';
					echo '<input type="hidden" name="full_room" value="1">';
					echo '<input type="submit" name="submit_room" value="Laat volledige kamer chatlog zien">';
					echo '<br>';
				}
				echo '<br>';
				echo '<table border="1">';
				echo '<tr>';
				echo '<td><B>Tijd</B></td>';
				echo '<td><B>Gebruiker</B></td>';
				echo '<td><B>Kamer ID</B></td>';
				echo '<td><B>Ontvanger ID</B></td>';
				echo '<td><B>Type</B></td>';
				echo '<td><B>Bericht</B></td>';
				echo '</tr>';
				while($b = mysql_fetch_assoc($a)){
					echo '<tr>';
					echo '<td>'.$b['timestamp'].'</td>';
					echo '<td>'.gebruiker($b['userid']).'</td>';
					echo '<td>'.$b['roomid'].'</td>';
					if($b['receiverid'] != "0"){
						echo '<td>'.gebruiker($b['receiverid']).'</td>';
					}else{
						echo '<td><u>Niet gefluisterd</u></td>';
					}
					echo '<td>'.ucwords($b['type']).'</td>';
					echo '<td>'.htmlspecialchars($b['text']).'</td>';
					echo '<tr>';
					}
				echo '</table>';
			}
		}
	}elseif($_POST['submit_global']){
		$a = mysql_query("SELECT * FROM moderation_chatlog ORDER BY timestamp DESC LIMIT 50");
		if(mysql_num_rows($a) < 1){
			echo 'Er zijn op het moment geen chatlogs.';
		}else{
			echo '<b>Showing latest 50 sayings</b><br><br>';
			echo '<table border="1">';
			echo '<tr>';
			echo '<td><B>Tijd</B></td>';
			echo '<td><B>Gebruiker</B></td>';
			echo '<td><B>Kamer ID</B></td>';
			echo '<td><B>Ontvanger ID</B></td>';
			echo '<td><B>Type</B></td>';
			echo '<td><B>Bericht</B></td>';
			echo '</tr>';
			while($b = mysql_fetch_assoc($a)){
				echo '<tr>';
				echo '<td>'.$b['timestamp'].'</td>';
				echo '<td>'.gebruiker($b['userid']).'</td>';
				echo '<td>'.$b['roomid'].'</td>';
				if($b['receiverid'] != "0"){
					echo '<td>'.gebruiker($b['receiverid']).'</td>';
				}else{
					echo '<td><u>Niet gefluisterd</u></td>';
				}
				echo '<td>'.ucwords($b['type']).'</td>';
				echo '<td>'.htmlspecialchars($b['text']).'</td>';
				echo '<tr>';
			}
		echo '</table>';
		}
	}else{
		echo '<form method="post" action="./chatlog.php">';
		echo 'Vind chatlog van gebruiker: <input type="hidden" name="full_user" value="0"> <input type="text" name="user"> <input type="submit" name="submit_user" value="Zoek"><br>';
		echo 'Vind chatlog van kamer ID: <input type="hidden" name="full_room" value="0"> <input type="text" name="room"> <input type="submit" name="submit_room" value="Zoek"><br>';
		echo 'Globale chatlog: <input type="submit" name="submit_global" value="Zoek"><br>';
	}
}else{
	echo $acc_denied;
}
include('inc/footer.php');
?>