<?php

// * * SETTINGS * * //
$online_timelimit = 300; // Wer war die letzen X Sekunden online?

function db_connect()
{
	$host = 'localhost';
	$db = 'Euer Datenbankname'; // <---------------------- Hier noch alles eintragen
	$user = 'Euer Datenbankuser'; // <---------------------- Hier noch alles eintragen
	$pass = 'Euer Datenbank Passwort'; // <---------------------- Hier noch alles eintragen
	mysql_connect($host, $user, $pass) or die ("Verbindung zu Datenbankserver fehlgeschlagen");
	mysql_select_db($db) or die ("Auswahl der Datenbank $db fehlgeschlagen");
}

function check_ip($ip)
{
	$check_ip = mysql_query("SELECT lastonlinetime
							 FROM active_players
							 WHERE player_ip = '".$ip."'");
	$check_fetch = mysql_num_rows($check_ip);
	if($check_fetch)
	{
		$fetch = mysql_fetch_array($check_ip);
		return $fetch['lastonlinetime'];
	} else {
		return false;
	}
}

function check_nick($nick)
{
	$check_nick = mysql_query("SELECT lastonlinetime
							 FROM active_players
							 WHERE nickname = '".$nick."'");
	$check_fetch = mysql_num_rows($check_nick);
	if($check_fetch)
	{
		$fetch = mysql_fetch_array($check_nick);
		return $fetch['lastonlinetime'];
	} else {
		return false;
	}
}

if(isset($_GET['active']) && $_GET['active'] == 1)
{
	db_connect();
	$check = check_ip($_SERVER['REMOTE_ADDR']);
	if(!$check)
	{
		mysql_query("INSERT INTO active_players
		SET player_ip = '".$_SERVER['REMOTE_ADDR']."',
			starttime = '".time()."',
			lastonlinetime = '".time()."'");
	} else {
		mysql_query("UPDATE active_players
					 SET lastonlinetime = '".time()."'
					 WHERE player_ip = '".$_SERVER['REMOTE_ADDR']."'");
					 echo mysql_error();
	}
}

if(isset($_GET['who_is_online']))
{
	db_connect();
	switch($_GET['who_is_online'])
	{
		case 1:
			$online_count = mysql_query("SELECT count(*) AS anzahl
										 FROM active_players
										 WHERE lastonlinetime > ".(time() - $online_timelimit)."");
										 echo mysql_error();
			$fetch = mysql_fetch_array($online_count);
			$players_online = $fetch['anzahl'];
			echo $players_online;
		break;

		case 2:
			$query = mysql_query("SELECT player_ip, starttime, lastonlinetime
								  FROM active_players
								  WHERE lastonlinetime > ".(time() - $online_timelimit)."");
			while($players = mysql_fetch_array($query))
			{
				if($show_nicknames)
				{
					echo '<b>'.$players['nickname'].'</b> IP: '.$players['player_ip'].' - Erstes mal online: '.date('H:i:s', $players['starttime']).' - Letzter Onlinekontakt @ '.date('H:i:s', $players['lastonlinetime']).'<br>';
				} else {
					echo 'IP: '.$players['player_ip'].' - Erstes mal online: '.date('H:i:s', $players['starttime']).' - Letzter Onlinekontakt @ '.date('H:i:s', $players['lastonlinetime']).'<br>';
				}
			}
		break;
	}
}

if(isset($_GET['search']) && $_GET['search'] = 1)
{
	echo '<form method="POST" action="active_players.php">
	<input name="search_input" type="text" />
	<input type="submit" />
	</form>';
}

if(isset($_POST['search_input']))
{
	db_connect();
	$query = mysql_query("SELECT lastonlinetime, starttime, player_ip
						  FROM active_players
						  WHERE player_ip = '".mysql_real_escape_string($_POST['search_input'])."'");

	$players = mysql_fetch_array($query);
	if(isset($players['nickname']))
	{
	echo 'IP: '.$players['player_ip'].' - Erstes mal online: '.date('H:i:s', $players['starttime']).' - Letzter Onlinekontakt @ '.date('H:i:s', $players['lastonlinetime']).'<br>';
	} else {
		echo 'Not found';
	}
}

?>