Bukkit

2012-10-30 11:35:58 [INFO] [Statistician] Enabling Statistician v2.0.10
2012-10-30 11:35:59 [SEVERE] [Statistician] Critical Error, could not connect to mySQL. Is the database Available? Check config file and try again. (com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
2012-10-30 11:35:59 [INFO] [Statistician] Disabling Statistician v2.0.10

mysql_connect('localhost', 'user', 'pass') or die;//Username and Password here
mysql_select_db('database') or die;//Database name here

<?php
mysql_connect('localhost', 'user', 'pass') or die;//Username and Password here
mysql_select_db('database') or die;//Database name here
 
    if (isset($_GET['player'])) {
        $name = $_GET['player'];
 
        $res = mysql_query("SELECT COUNT(player_name) AS player_name FROM players WHERE player_name='{$name}'");
            $row = mysql_fetch_array($res);
            $count = $row['player_name'];
 
            if ($count == '2') {
 
                //get old uuid
                $res = mysql_query("SELECT uuid, last_logout FROM players WHERE player_name='{$name}' GROUP BY last_logout ASC LIMIT 1");
                    while ($else = mysql_fetch_array($res))
                    {
                        $olduuid = $else['uuid'];
                    }
                //get new uuid
                $res = mysql_query("SELECT uuid, last_logout FROM players WHERE player_name='{$name}' GROUP BY last_logout DESC LIMIT 1");
                    while ($else = mysql_fetch_array($res))
                    {
                        $newuuid = $else['uuid'];
                    }
 
                //fix blocks
                $res = mysql_query("SELECT block_ID, SUM(num_destroyed) AS num_destroyed, SUM(num_placed) AS num_placed FROM blocks WHERE UUID='{$olduuid}' OR UUID='{$newuuid}' GROUP BY block_ID");
                    while ($else = mysql_fetch_array($res))
                    {
                        mysql_query("DELETE FROM blocks WHERE (UUID='{$olduuid}' OR UUID='{$newuuid}') AND block_ID='".$else['block_ID']."'");
                        mysql_query("INSERT INTO blocks (uuid, block_ID, num_destroyed, num_placed)
                                    VALUES ('{$newuuid}', '".$else['block_ID']."', '".$else['num_destroyed']."', '".$else['num_placed']."')");
                    }
 
                //fix pickup_drop
                $res = mysql_query("SELECT item, SUM(num_pickedup) AS num_pickedup, SUM(num_dropped) AS num_dropped FROM pickup_drop WHERE UUID='{$olduuid}' OR UUID='{$newuuid}' GROUP BY item");
                    while ($else = mysql_fetch_array($res))
                    {
                        mysql_query("DELETE FROM pickup_drop WHERE (UUID='{$olduuid}' OR UUID='{$newuuid}') AND item='".$else['item']."'");
                        mysql_query("INSERT INTO pickup_drop (uuid, item, num_pickedup, num_dropped)
                                    VALUES ('{$newuuid}', '".$else['item']."', '".$else['num_pickedup']."', '".$else['num_dropped']."')");
                    }
 
                //fix kills
                mysql_query("UPDATE kills SET killed_by_uuid = replace(killed_by_uuid, '{$olduuid}', '{$newuuid}')");
                mysql_query("UPDATE kills SET killed_uuid = replace(killed_uuid, '{$olduuid}', '{$newuuid}')");
 
                //fix player
                $res = mysql_query("SELECT player_name, MIN(firstever_login) AS firstever_login, SUM(num_logins) AS num_logins, SUM(num_secs_loggedon) AS num_secs_loggedon, SUM(distance_traveled) AS distance_traveled, SUM(distance_traveled_in_minecart) AS distance_traveled_in_minecart, SUM(distance_traveled_in_boat) AS distance_traveled_in_boat, SUM(distance_traveled_on_pig) AS distance_traveled_on_pig FROM players WHERE UUID='{$olduuid}' OR UUID='{$newuuid}' GROUP BY player_name");
                    while ($else = mysql_fetch_array($res))
                    {
                        mysql_query("UPDATE players SET firstever_login='".$else['firstever_login']."', num_logins='".$else['num_logins']."', num_secs_loggedon='".$else['num_secs_loggedon']."', distance_traveled='".$else['distance_traveled']."', distance_traveled_in_minecart='".$else['distance_traveled_in_minecart']."', distance_traveled_in_boat='".$else['distance_traveled_in_boat']."', distance_traveled_on_pig='".$else['distance_traveled_on_pig']."' WHERE UUID='{$newuuid}'");
                        mysql_query("DELETE FROM players WHERE UUID='{$olduuid}'");
                    }
 
                echo $name.' was in the database twice.<BR/>Cleanup was performed.';
 
            } else if ($count == '1') {
 
                echo $name.' is in the database only once, so no cleanup is needed!';
 
            } else if ($count == '0') {
 
                echo $name.' is not in the database!';
 
            } else {
 
                echo $name.' is in the database more than twice, so you got problems bigger than the scope of this script!';
 
            }
 
        echo '<BR/><BR/><a href="'.$_SERVER['PHP_SELF'].'">back</a>';
 
    } else {
 
        $res = mysql_query("SELECT COUNT(*) AS Rows, player_name FROM players GROUP BY player_name ORDER BY Rows DESC");
            while ($else = mysql_fetch_array($res))
            {
                echo $else['Rows'];
                echo ' ';
                echo '<a href="?player='.$else['player_name'].'">'.$else['player_name'].'</a>';
                echo '<BR/>';
            }
 
    }
 
mysql_close();
?>