<?php
/*
	(c) xxx.nl
	Alle rechten voorbehouden.
	Niets mag worden gekopieerd zonder toestemming.
*/


include ("../config.php");


logincheck ();


$page		= $_GET['p'];
$max 		= 10;
$start 		= ($_GET['n'] >= 0) ? $_GET['n'] * $max : 0;
?>
<html>
<head>
	<title>xxx.nl</title>
	<meta name="description" content="xxx is een gratis maffia game.">
	<meta name="author" content="Youri">
	<link href="../design/css/style.css" rel="stylesheet" type="text/css">
</head>
<body>
	<table width="60%" align="center">
		<tr>
			<td class="titel" colspan="3">Je berichten</td>
		</tr>
		<tr>
			<td class="text" width="20%"><b>Van</b></td>
			<td class="text" width="40%"><b>Onderwerp</b></td>
			<td class="text" width="40%"><b>Datum</b></td>
		</tr>
<?php
$dbres		= mysql_query("SELECT * FROM `Messages` WHERE `to`='{$data['name']}' AND `safe`=0 ORDER BY `time` DESC LIMIT $start, $max");
while($msg = mysql_fetch_assoc($dbres)) {
$dbres		= mysql_query("SELECT * FROM `Users` WHERE `name`='{$msg['from']}'");
$user		= mysql_fetch_assoc($dbres);
$from		= $msg['from'];
$to			= $msg['to'];
$subject	= $msg['subject'];
$time		= $msg['time'];
$showtime 	= gmdate("d-m-Y H:i:s", $time);
if ($msg['read'] == 1) {
PRINT <<<ENDHTML
		<tr>
			<td class="text"><a href="../user.php?uid={$user['id']}">{$from}</a></td>
			<td class="text"><a href="read.php?mid={$msg['id']}">{$subject}</a></td>
			<td class="text">{$showtime}</td>
		</tr>
ENDHTML;
}
else {
PRINT <<<ENDHTML
		<tr>
			<td class="text"><i><a href="../user.php?uid={$user['id']}">{$from}</a></i></td>
			<td class="text"><i><a href="read.php?mid={$msg['id']}">{$subject}</a></i></td>
			<td class="text"><i>{$showtime}</i></td>
		</tr>
ENDHTML;
}
}
?>
	</table>
</body>
</html>

--
-- Tabelstructuur voor tabel `Messages`
--


CREATE TABLE IF NOT EXISTS `Messages` (
  `id` int(100) NOT NULL auto_increment,
  `from` varchar(20) NOT NULL,
  `to` varchar(20) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `msg` text NOT NULL,
  `read` int(5) NOT NULL default '0',
  `safe` int(5) NOT NULL default '0',
  `time` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;


--
-- Gegevens worden uitgevoerd voor tabel `Messages`
--


INSERT INTO `Messages` (`id`, `from`, `to`, `subject`, `msg`, `read`, `safe`, `time`) VALUES
(1, 'Test', 'Youri', 'Onderwep', 'Message', 1, 0, 1261601566),
(2, 'Test', 'Youri', 'Onderwep', 'Message', 1, 0, 1261601566),