<?php
include 'inc/header.php';
online('1');
$online_query = mysql_query("SELECT * FROM `member_accounts` WHERE DATE_ADD(uLast, INTERVAL 150 SECOND) > NOW() AND uOnline = 1 ORDER BY `uLast` DESC") or trigger_error(mysql_error());
$online_queryl = mysql_query("SELECT * FROM `gast_online` WHERE DATE_ADD(uLast, INTERVAL 150 SECOND) > NOW() ORDER BY `uLast` DESC") or trigger_error(mysql_error());
if(mysql_num_rows($online_query) != 0 || mysql_num_rows($online_queryl) != 0)
{
        echo '<table><tr><td><strong>Gebruikersnaam:</strong></td><td><strong>Laatst gezien:</strong></td><td><strong>Locatie:</strong></td></tr>';
        while($online = mysql_fetch_assoc($online_query))
        {
                        $sq = mysql_query("SELECT * FROM member_accounts WHERE uId = ".$online['uId']."") or die(mysql_error());
                        while($online2 = mysql_fetch_assoc($sq))
                        {
                                echo '<tr><td style="width: 150px;"><a href="profiel?id=' . htmlentities($online['uId']) . '"><span style="color:' . htmlentities($online2['uCol']) . ';font-weight: bold;width: 150px;">' . htmlentities($online2['uName']) . '</span></a></td><td>' . htmlentities($online['uLast']) . '</td><td><a href="
                                ' . htmlentities($online['uPage']) . '
">' . htmlentities($online['uPage']) . '</a></td></tr>';
                        }
                }
                while($online = mysql_fetch_assoc($online_queryl))
                {
                        echo'<tr><td style="width: 150px;"><em>Gast</em></td><td>' . htmlentities($online['uLast']) . '</td><td><a href="' . htmlentities($online['uPage']) . '">' . htmlentities($online['uPage']) . '</a></td></tr>';
                }
        echo '</table>';
        }
include 'inc/footer.php';
?>

<?php
require_once 'inc/header.php';


$query = mysql_query("SELECT * FROM member_accounts WHERE DATE_ADD(uLast, INTERVAL 300 
SECOND) > NOW() AND uonline = '1'");
$query2 = mysql_query("SELECT * FROM gasten WHERE 
DATE_ADD(laatste_bezoek, INTERVAL 300 SECOND) > NOW()");




if(mysql_num_rows($query) >= 1 || mysql_num_rows($query2) >= 1)
{
	
	$query3 = mysql_query("SELECT online_leden FROM records");
	$fetch3 = mysql_fetch_assoc($query3);
	
	if(mysql_num_rows($query) > $fetch3['online_leden'])
	{
		
		mysql_query("UPDATE records SET online_leden = 


'".mysql_num_rows($query)."'");
	
	}
	
	echo 'Er '.(mysql_num_rows($query2) === 1 ? 'is 1 bezoeker' : 'zijn 


'.mysql_num_rows($query2).' bezoekers').' online, waarvan '.(mysql_num_rows($query) === 1 ? 


'1 lid is' : mysql_num_rows($query).' leden zijn').' ingelogd.
	<table width="100%">
		<tr>
			<td class="titel">Gebruiker</td>
			<td class="titel">Laatst gezien</td>
			<td class="titel">Laatste 


pagina</td>
		</tr>';
	
	while($fetch = mysql_fetch_assoc($query))
	{
		
		$tijd = time() - strtotime($fetch['uLast']);
		
		echo '<tr>
			<td><a 


href="profiel?id='.$fetch['uId'].'">'.ucfirst($fetch['uName']).'</a></td>
			<td>'.idate('i', $tijd).' min, '.idate('s', $tijd).' sec</td>
			<td>'.$fetch['laatste_pagina'].'</td>
		</tr>';
	
	}	
	while($fetch2 = mysql_fetch_assoc($query2))
	{
		
		$tijd = time() - strtotime($fetch2['laatste_bezoek']);
		
		echo '<tr>
			<td><em>Gast</em></td>
			<td>'.idate('i', $tijd).' min, '.idate('s', $tijd).' sec</td>
			<td>'.$fetch2['laatste_pagina'].'</td>
		</tr>';
	
	}
	
	echo '</table>';


}
else
{
	
	echo 'Er zijn geen leden online.';


}
include 'inc/footer.php';
?>

</div>
            
            <div class="sidebar">
            
            <div class="top">Habboregio Groep</div>
            <div class="mid"><div style="border: 1px solid #B9B9B9;"><a


href="http://www.habbo.nl/groups/79721/id"> <img src="images/groep.png" alt="Wordt lid!"


/></a></div></div>
            
    <div class="top">Poll</div>
            <div class="mid"><strong>Poll week 1</strong><br /><br />
<?php
    $poll_sql = mysql_query("SELECT * FROM poll ORDER BY id DESC LIMIT 1") or trigger_error(mysql_error());
    if(mysql_num_rows($poll_sql))
    {
        $poll = mysql_fetch_assoc($poll_sql);
        $voted_sql = mysql_query("SELECT `voted_at_answer` FROM `poll_votes` WHERE `poll_id` = '" . mysql_real_escape_string($poll['id']) . "' AND `userid_of_voter` = '" . mysql_real_escape_string($_SESSION['uId']) . "'") or trigger_error(mysql_error());
        if(isset($_POST['submit']) && $_POST['submit'])
        {
            if(isset($_SESSION['uId']))
            {
                if((isset($_POST['answer'])) && (ctype_digit($_POST['answer'])))
                {
                    if(!empty($poll['answer' . htmlentities($_POST['answer'])]))
                    {
                        if(!mysql_num_rows($voted_sql))
                        {
                            mysql_query("INSERT INTO `poll_votes` VALUES ('" . mysql_real_escape_string($poll['id']) . "','" . mysql_real_escape_string($_SESSION['uId']) . "','" . mysql_real_escape_string($_POST['answer']) . "')") or trigger_error(mysql_error());
                            $voted_sql = mysql_query("SELECT `voted_at_answer` FROM `poll_votes` WHERE `poll_id` = '" . mysql_real_escape_string($poll['id']) . "' AND `userid_of_voter` = '" . mysql_real_escape_string($_SESSION['uId']) . "'") or trigger_error(mysql_error());
                        }
                    }
                }
            }
        }
        echo '<strong>' . htmlentities($poll['question'], ENT_QUOTES) . '</strong><br />';
        $votes_sql = mysql_query("SELECT COUNT(1) AS `total_votes` FROM `poll_votes` WHERE `poll_id` = '" . mysql_real_escape_string($poll['id']) . "'") or trigger_error(mysql_error());
        $votes = mysql_fetch_assoc($votes_sql);
        if(mysql_num_rows($voted_sql))
        {
            $voted = mysql_fetch_assoc($voted_sql);
        }
        if((!isset($voted)) && (isset($_SESSION['uId'])))
        {
            echo '<form action="#" method="post">';
        }
        echo '<table>';
        for($i = 1; $i <= 10; $i++)
        {
            if (!empty($poll['answer' . $i]))
            {
                $answer_votes_sql = mysql_query("SELECT COUNT(1) AS `answer_votes` FROM `poll_votes` WHERE `poll_id` = '" . mysql_real_escape_string($poll['id']) . "' AND `voted_at_answer` = '" . mysql_real_escape_string($i) . "'") or trigger_error(mysql_error());
                $answer_votes = mysql_fetch_assoc($answer_votes_sql);
                if($votes['total_votes'] != 0)
                {
                    $percentage = ((round(($answer_votes['answer_votes'] / $votes['total_votes']), 4)) * 100);
                }
                else
                {
                    $percentage = 0;
                }
                echo '<tr>';
                if((!isset($voted)) && (isset($_SESSION['uId'])))
                {
                    echo '<td><input type="radio" name="answer" value="' . htmlentities($i) . '"></td>';
                }
                echo '<td>';
                if($voted['voted_at_answer'] == $i)
                {
                    echo '<i>' . htmlentities($poll['answer' . $i]) . '</i>';
                }
                else
                {
                    echo htmlentities($poll['answer' . $i]);
                }
                echo '</td><td><div style="background: url(http://www.one2xs.com/img/warn_bar_bg.gif) no-repeat bottom left; width: 135px; height: 10px; padding: 1px 0 0 1px; font-size: 9px;"><div style="background: url(http://www.one2xs.com/img/warn_bar_orange.gif) no-repeat bottom left; width: ' . ($percentage * 1.33) . 'px; height: 8px; float: left; margin: 1px 0 0 0;"></div></div></td><td><i>' . $percentage . '%</i></td></tr>';
            }
        }
        echo '</table>';
        if((!isset($voted)) && (isset($_SESSION['uId'])))
        {
            echo '<input type="submit" value="STEM!" name="submit"></form>';
        }
        echo 'Totaal aantal stemmen: ' . htmlentities($votes['total_votes']);
    }            
?>
</div>
            
            </div>
            


                    <div style="clear: both;"></div>
                    <div id="footer">Habboregio is geen onderdeel van Habbo of Sulake


Coperation Oy. Alle rechten voorbehouden | Habboregio 2009-2010    <a href="#top">Naar


boven</a> | <a href="contact">Contact</a></div>
        
            </div>
    </div>


</body>
</html>

<?php
require_once 'inc/header.php';
 if($_GET['act'] == 'show')
	{
   if((isset($_GET['t'])) || (ctype_digit($_GET['t'])))
        {
            $topic_info_query = mysql_query("SELECT * FROM `woordenlijst` WHERE `id` = '" . 


mysql_real_escape_string($_GET['t']) . "'") or trigger_error(mysql_error());
            if(mysql_num_rows($topic_info_query))
            {
                $topic_info = mysql_fetch_assoc($topic_info_query);
                {
                    $cat_sql = mysql_query("SELECT * FROM `woorden` WHERE `id` = '" . 


mysql_real_escape_string($topic_info['cat_id']) . "'") or trigger_error(mysql_error());
                    if(mysql_num_rows($cat_sql))
                    {
                        $cat = mysql_fetch_assoc($cat_sql);
                        {


echo '<h3>Leer de woorden</h3>';
			
			echo '<textarea onfocus="blur()">'.htmlspecialchars($cat['woord']).' - 


'.htmlspecialchars($cat['antwoord']).'</textarea><br />';
				}


			}
		}
		}
	}
}
require_once 'inc/footer.php';
?>