<?php
include('config.php');
if(!isset($_GET['m'])) {
    echo "Error! No method is given!";
} else if(!isset($_GET['p'])) {
    echo "Error! A password is required!";
} else if($_GET['p'] != $password) {
    echo "Error! Password incorrect!";
} else if($_GET['m'] == 'firstJoin') {
    $query = "SELECT * FROM playerlist WHERE username='". $_GET['d']."' ";
    $result = mysql_query($query) or die(mysql_error());

    if (mysql_num_rows($result) )
    {
        mysql_query('UPDATE playerlist SET status=1 WHERE username="'.$_GET['d'].'"')or die(mysql_error());
        echo "[BukkitStats] Updated player status";
    } else {
        mysql_query('INSERT INTO playerlist (username, status, kills, deaths) VALUES("'.$_GET["d"].'", 1, 0, 0)')or die(mysql_error());
        echo "[BukkitStats] Create new user in database";
    }

} else if($_GET['m'] == 'playerJoin') {
    mysql_query('UPDATE playerlist SET status=1 WHERE username="'.$_GET["d"].'"')or die(mysql_error());
    echo "[BukkitStats] Updated player status";
} else if($_GET['m'] == 'playerQuit') {
    $data = explode('|', $_GET['d']);
    mysql_query('UPDATE playerlist SET status=0, totaltime=totaltime+"'.$data[1].'" WHERE username="'.$data[0].'"')or die(mysql_error());
    echo "[BukkitStats] Updated player status";
} else if($_GET['m'] == 'pvpkill') {
    $data = explode('|', $_GET['d']);
    mysql_query('UPDATE playerlist SET kills = kills+1 WHERE username="'.$data[0].'"')or die(mysql_error());
    mysql_query('UPDATE playerlist SET deaths = deaths+1 WHERE username="'.$data[1].'"')or die(mysql_error());
    if($logKills == true) {
        mysql_query('INSERT INTO pvpkills (killer, victim) VALUES ("'.$data[0].'", "'.$data[1].'")')or die(mysql_error());
    }
    echo "[BukkitStats] Added kill to database";
} else {
    echo "Method Not Recognized";
}