Import SimpleAuth YAML to MySQL

gistfile1.txt

<?php

//Set Paths
$hostname = "localhost";
$username = "DB_USER";
$password = "DB_PASSWORD";
$dbname = "DB_NAME";
$usertable = "simpleauth_players";

$connection = mysql_connect($hostname, $username, $password);
mysql_select_db($dbname, $connection);

set_include_path(get_include_path() . PATH_SEPARATOR . '/PATH_TO_SPYC');
require_once ('Spyc.php');

$di = new RecursiveDirectoryIterator('/SERVER_PATH/plugins/SimpleAuth/players/');
foreach (new RecursiveIteratorIterator($di) as $filename => $file) {

    $playeryml = $file->getRealPath();
    $player = basename($playeryml, ".yml");

    $firstletter = substr($player, 0, 1);

    $Data = Spyc::YAMLLoad($playeryml);

    $hash = $Data["hash"];
    $registerdate = $Data["registerdate"];
    $logindate = $Data["logindate"];
    $lastip = $Data["lastip"];

    $query = "INSERT INTO simpleauth_players (name, hash, registerdate, logindate) VALUES ('" . $player . "', '" . $hash . "', '" . $registerdate . "', '" . $logindate . "')";
    $result = mysql_query($query);

    if ($result) {
        echo "New record created for " . $player . "\n";
    } else {
        echo "Error: " . $query . "\n" . $connection->error;
    }
}
?>