<?php

// * * SETTINGS * * //
$active_send_time = 4; // Zeit in Minuten, wie oft der Nickname geschickt wird
$online_timelimit = 300; // Wer war die letzen X Sekunden online?
$show_nicknames = true; // Nicknamen in Ausgabe anzeigen?


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['nick']))
{
    db_connect();
    $nick = mysql_real_escape_string($_GET['nick']);
    $check = check_nick($nick);
    if(!$check)
    {
        mysql_query("INSERT INTO active_players
        SET player_ip = '".$_SERVER['REMOTE_ADDR']."',
            nickname = '".$nick."',
            starttime = '".time()."',
            lastonlinetime = '".time()."'");

    } else {
        mysql_query("UPDATE active_players
                     SET lastonlinetime = '".time()."',
                     player_ip = '".$_SERVER['REMOTE_ADDR']."',
                     overalltime = overalltime + ".$active_send_time."
                     WHERE nickname = '".$nick."'");
                     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 nickname, 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 nickname, lastonlinetime, starttime, player_ip
                          FROM active_players
                          WHERE nickname = '".mysql_real_escape_string($_POST['search_input'])."'");

    $players = mysql_fetch_array($query);
    if(isset($players['nickname']))
    {
    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 'Not found';
    }
}

?>