<?php
include 'includes/config.php';
include 'includes/header.php';


if(isset($_GET['id']))
{
	$sql = $core->mysql->query("SELECT
								id,
								titel,
								inhoud,
								lid_id,
								datum
							FROM
								nieuws
							WHERE id = '".$_GET['id']."'
							");
							
	$fetch = $core->mysql->fetch($sql);
	
	$sqln = $core->mysql->query("SELECT naam FROM leden WHERE id = '".$fetch['lid_id']."'");
	$fetchn = $core->mysql->fetch($sqln);
	
	if($core->mysql->num_rows($sql) >= 1)
	{
	
		echo '<h1>'.ucfirst($fetch['titel']).'</h1>
		'.$fetch['inhoud'].'<br /><br />
		Gepost door <strong>'.ucfirst(htmlentities($fetchn['naam'])).'</strong> op '.$fetch['datum'].'<br /><br />
		<a href="">Reageer</a><br /><br />
		
		<h1>Reacties</h1>';
		
		$perpage = 1; // Resultaten per pagina


		$query = $core->mysql->query("SELECT
								id,
								lid_id,
								bericht,
								datum
							FROM
								comments
							WHERE
								nieuws_id = '".$_GET['id']."'
							");
							
			 $p = (isset($_GET['p']) && ctype_digit($_GET['p']) ? $_GET['p'] : 1);




$total = $core->mysql->num_rows($core->mysql->query($query)) or die(mysql_error());
$pages = ceil($total/$perpage);
if($p > $pages){ $p = 1; }
if($pages == 1 || $p == 1){
	$start = 0;
}
else{
	$start = ($p-1)*$perpage;
}
$sqld = $core->mysql->query($query." LIMIT ".$perpage." OFFSET ".$start."");


					
		if($core->mysql->num_rows($sqld) >= 1)
		{
		
		
			while($fetchd = $core->mysql->fetch($sqld))
			{
				$start ++;


				$sqlnd = $core->mysql->query("SELECT naam FROM leden WHERE id = '".$fetchd['lid_id']."'");
				$fetchnd = $core->mysql->fetch($sqlnd);
		
				echo 'Gepost door '.htmlentities(ucfirst($fetchnd['naam'])).' op '.$fetchd['datum'].'<br /><br /> '.$fetchd['bericht'].'<br /><hr /><br />';
			}
		






	echo '<div style="text-align: center;">Pagina (<strong>'.$p.'</strong> van de '.$pages.')</div><br />';
	
		echo '</table>';
		if($p != 1){
	?>
	<div style="text-align: center;"><br /><a href="?p=<?php echo $p-1; ?>">Vorige</a></div>
	<?php
}
if($p < $pages){
	?>
	<div style="text-align: center;"><br /><a href="?p=<?php echo $p+1; ?>">Volgende</a> &raquo;</div>
	<?php
}


		}
		else
		{
			echo '<div class="error">Er zijn geen reacties.</div>';
		}	
		
	}
	else
	{
		echo '<div class="error">Deze pagina bestaat niet.</div>';
	}
}


include 'includes/footer.php';
?>

<?php
define('TITEL','Aanmelden');
    include 'includes/config.php';
    include 'includes/header.php';


    if(!isset($_COOKIE['id']))
    {
        
        if(isset($_POST['submit']))
        {
            
            $errorMelding = '';
            
            if(trim($_POST['naam']) === '' || trim($_POST['wachtwoord']) === '')
            {
				$errorMelding .= 'Je hebt niet alle velden ingevuld.';
            }
            else
            {
			$sql = mysql_query("SELECT * FROM leden WHERE naam = '".mysql_real_escape_string($_POST['naam'])."'");
        
            if(mysql_num_rows($sql) == 0)
            {
            
                $errorMelding .= 'Dit account bestaat niet.';
            }
            else
            {
                $fetch = mysql_fetch_assoc($sql);
                if(hash('sha256', hash('sha512', $_POST['wachtwoord']) != $fetch['wachtwoord']))
                {
                
                    $errorMelding .= 'Het ingevoerde wachtwoord is incorrect.';
                
                }
			}
            
			if(!empty($errorMelding))
            {
                echo $errorMelding;
            }
            else
            {
               $id = $_COOKIE['id'];
			   
             set_cookie('id',$id,time()+60*60*24*30);
			 
			 echo 'Je bent ingelogd';
                                
            }
		}
	}
?>
<form action="" method="post">
    <table>
        <tr>
            <td width="350">Tovenaarsnaam:</td>
            <td><input class="text" type="text" name="naam" maxlength="20" /></td>
        </tr>
        <tr>
            <td>Wachtwoord:</td>
            <td><input class="text" type="password" name="wachtwoord" maxlength="50" /></td>
        </tr>
        <tr>
            <td><input type="submit" class="text" name="submit" value="- Inloggen! -" /></td>
            <td><input type="submit" class="text" name="send" value="- Opnieuw -" /></td>
			            <td>Nog geen account? | Wachtwoord vergeten?</td>


        </tr>
  </table>
 </form>
 
<?php
    }
    else
    {
        echo '<div id="error">Je bent al op Zweinstein</div>';
    }
        
    include 'includes/footer.php';
?>