<?php
    define( 'MQ_SERVER_ADDR', 'localhost' );
    define( 'MQ_SERVER_PORT', 25566 );
    define( 'MQ_TIMEOUT', 1 );
    define( 'TS_IP', 'localhost' );
    define( 'TS_PORT', '9987' );
    define ( 'MYSQL_HOST',      'localhost' );
    define ( 'MYSQL_BENUTZER',  'minecraft' );
    define ( 'MYSQL_KENNWORT',  'Cb4d8MxehmbZLGuQ' );
    define ( 'MYSQL_DATENBANK', 'minecraft_server1.0' );

    require __DIR__ . '/MinecraftQuery.class.php';
    require __DIR__ . '/TeamSpeak3.php';

    $db_link = mysql_connect (  MYSQL_HOST,
                                MYSQL_BENUTZER,
                                MYSQL_KENNWORT);

    $timestamp = time();

    $Query = new MinecraftQuery( );
    try
    {
        $Query->Connect( MQ_SERVER_ADDR, MQ_SERVER_PORT, MQ_TIMEOUT );
    }
    catch( MinecraftQueryException $e )
    {
        $Error = $e->getMessage( );
    }

if( ( $Info = $Query->GetInfo( ) ) !== false ):
if ($Info):
$mc_hn = $Info['HostName'];
$num_players =  $Info['Players'];
$max_players = $Info['MaxPlayers'];
$mc_version = $Info['Version'];
$mc_ip = $Info['HostIp'];
$mc_port = $Info['HostPort'];
$mc_online = true;
else:
$mc_hn = 0;
$num_players =  0;
$max_players = 0;
$mc_version = 0;
$mc_ip = 0;
$mc_port = 0;
$mc_online = false;
endif;
endif;


####Prozessinfo

$cpu_used = exec("ps aux | grep -v grep | grep -v SCREEN | grep craftbukkit | awk '{print $3}'");
$ram_used = exec("ps aux | grep -v grep | grep -v SCREEN | grep craftbukkit | awk '{print $6}'");
if ( !$ram_used ):
$ram_used = 0;
$cpu_used = 0;
endif;
//print_r($proc);
//echo $ram_used;


####Query

$ts3_user = "tsatze";
$ts3_pass = "S+JEj1bj";
$ts3_ip = "213.133.109.27";
$ts3_aport = "10011";
$ts3_uport = "9987";

try{
    $ts3query =  TeamSpeak3::factory("serverquery://".
                                                $ts3_user.":".
                                                $ts3_pass."@".
                                                $ts3_ip.":".
                                                $ts3_aport."/?server_port=".
                                                $ts3_uport);
    $tsusers = $ts3query->ClientCount();
    $tsversiona = $ts3query->Version();
    $tsversion = $tsversiona['version'];
    $tsonline = true;


    }catch(Exception $e){

    $tsusers = 0;
    $tsversion = 0;
    $tsonline = false;
    }




####In DB schreiben


if ( $db_link )
{
    echo 'Verbindung erfolgreich: ';
    echo $db_link;
}
else
{
        // hier sollte dann später dem Programmierer eine
        // E-Mail mit dem Problem zukommen gelassen werden
                die('keine Verbindung möglich: ' . mysql_error());
}
mysql_select_db( MYSQL_DATENBANK )
  or die("Auswahl der Datenbank fehlgeschlagen");

// MySQL-Befehl der Variablen $sql zuweisen
$sql =
    "INSERT INTO `query` (
        `timestamp`,
        `mc_cpu_used`,
        `mc_ram_kb`,
        `num_players`,
        `max_players`,
        `mc_online`,
        `mc_version`,
        `ts_numuser`,
        `ts_version`,
        `ts_online`
    ) VALUES(
        ".$timestamp.",
        ".$cpu_used.",
        ".$ram_used.",
        ".$num_players.",
        ".$max_players.",
        ".$mc_online.",
        '".$mc_version."',
        ".$tsusers.",
        '".$tsversion."',
        ".$tsonline."
    ); ";

//var_dump($sql);


// MySQL-Anweisung ausführen lassen
$db_erg = mysql_query($sql)
  or die("Anfrage fehlgeschlagen: " . mysql_error());
    mysql_close($db_link );



?>