public function __construct(MySQLDatabase $db, AccountInfo $info, $overwrite = true)
{
parent::__construct($db->getCredentials());
$this->info = $info;
$this->tableName = $db->getMainTable();
$this->overwrite = $overwrite;
}
public function __construct(MySQLDatabase $db, $name, $identifier)
{
parent::__construct($db->getCredentials());
$this->tableName = $db->getMainTable();
$this->name = $name;
$this->identifier = $identifier;
}
public function __construct(MySQLDatabase $database, $name, $hookId)
{
parent::__construct($database->getCredentials());
$this->tableName = $database->getMainTable();
$this->name = $name;
$this->hookId = $hookId;
}
public function __construct(MySQLDatabase $db, $oldName, $newName, $hookId)
{
parent::__construct($db->getCredentials());
$this->tableName = $db->getMainTable();
$this->oldName = strtolower($oldName);
$this->newName = strtolower($newName);
$this->hookId = $hookId;
}
public function __construct(MySQLDatabase $database, $ip, $limit, $time, $identifier)
{
parent::__construct($database->getCredentials());
$this->tableName = $database->getMainTable();
$this->ip = $ip;
$this->limit = $limit;
$this->since = time() - $time;
$this->identifier = $identifier;
}
/**
* @return \mysqli|null
*/
protected function getMysqli()
{
$mysqli = $this->getFromThreadStore(self::MYSQLI_KEY);
if ($mysqli !== null) {
return $mysqli;
}
$mysqli = MySQLDatabase::createMysqliInstance($this->credentials);
$this->saveToThreadStore(self::MYSQLI_KEY, $mysqli);
return $mysqli;
}
public function read($params, AccountWriter $writer)
{
$args = new FormattedArgumentMap($params);
$this->cred->host = $args->opt("h", $this->cred->host);
$this->cred->username = $args->opt("u", $this->cred->username);
$this->cred->password = $args->opt("p", $this->cred->password);
$this->cred->schema = $args->opt("d", $this->cred->schema);
$this->cred->schema = $args->opt("s", $this->cred->schema);
$this->cred->port = (int) $args->opt("port", $this->cred->port);
$this->cred->socket = $args->opt("socket", $this->cred->socket);
$this->cred->socket = $args->opt("sk", $this->cred->socket);
$this->setStatus("Connecting");
$conn = MySQLDatabase::createMysqliInstance($this->cred);
if (isset($conn->connect_error)) {
throw new \InvalidArgumentException("Could not connect to {$this->cred}");
}
$this->setStatus("Preparing data");
$result = $conn->query("SELECT name, registerdate, logindate, lastip, hash FROM simpleauth_players");
$this->setStatus("Transferring data");
if ($result instanceof \mysqli_result) {
$this->setProgress(0.0);
$rows = 0;
while (is_array($row = $result->fetch_assoc())) {
$info = AccountInfo::defaultInstance($row["name"], $this->defaultOpts);
$info->registerTime = (int) $row["registerdate"];
$info->lastLogin = (int) $row["logindate"];
$info->lastIp = $result["lastip"];
$info->passwordHash = hex2bin($result["hash"]);
$writer->write($info);
$this->setProgress(++$rows / $result->num_rows);
}
$result->close();
} else {
throw new \InvalidArgumentException("Not a SimpleAuth user database");
}
}
public function read($params, AccountWriter $writer)
{
$args = new FormattedArgumentMap($params);
$this->cred->host = $args->opt("h", $this->cred->host);
$this->cred->username = $args->opt("u", $this->cred->username);
$this->cred->password = $args->opt("p", $this->cred->password);
$this->cred->schema = $args->opt("d", $this->cred->schema);
$this->cred->schema = $args->opt("s", $this->cred->schema);
$this->cred->port = (int) $args->opt("port", $this->cred->port);
$this->cred->socket = $args->opt("socket", $this->cred->socket);
$this->cred->socket = $args->opt("sk", $this->cred->socket);
$this->setStatus("Connecting");
$conn = MySQLDatabase::createMysqliInstance($this->cred);
if (isset($conn->connect_error)) {
throw new \InvalidArgumentException("Could not connect to {$this->cred}");
}
$prefix = $args->opt("prefix", null);
$prefix = $args->opt("pfx", $prefix);
if ($prefix === null) {
$this->setStatus("Searching for tables");
$result = $conn->query("SHOW TABLES LIKE '%serverauth%'");
if ($result === false) {
throw new \InvalidArgumentException("Could not search tables");
}
$prefixes = [];
while (is_array($row = $result->fetch_array(MYSQLI_NUM))) {
if (StringUtils::endsWith($row[0], "serverauth")) {
$prefix = substr($row[0], 0, -10);
if (isset($prefixes[$prefix])) {
$prefixes[$prefix]++;
} else {
$prefix[$prefix] = 1;
}
} elseif (StringUtils::endsWith($row[0], "serverauthdata")) {
$prefix = substr($row[0], 0, -14);
if (isset($prefixes[$prefix])) {
$prefixes[$prefix]++;
} else {
$prefix[$prefix] = 1;
}
}
}
$result->close();
foreach ($prefixes as $prefix => $cnt) {
if ($cnt === 2) {
$ok = true;
break;
}
}
if (!isset($ok)) {
throw new \RuntimeException("ServerAuth tables not found in {$this->cred}");
}
}
$serverAuthTable = $prefix . "serverauth";
$serverAuthDataTable = $prefix . "serverauthdata";
$hashMethod = $args->opt("hash", null);
if ($hashMethod === null) {
$this->setStatus("Detecting hash algorithm");
$result = $conn->query("SELECT password_hash FROM `{$serverAuthTable}`");
$row = $result->fetch_assoc();
if (!is_array($row)) {
throw new \RuntimeException("Corrupted ServerAuth database: serverauth table empty");
}
$hashMethod = $row["password_hash"];
if (!in_array($hashMethod, hash_algos())) {
throw new \RuntimeException("ServerAuth database uses a hash algorithm not supported by PHP " . PHP_MAJOR_VERSION . "." . PHP_MINOR_VERSION . "." . PHP_RELEASE_VERSION . ". This may imply a corrupted database.");
}
}
$this->setStatus("Preparing data for transfer");
$result = $conn->query("SELECT user,password,ip,firstlogin,lastlogin FROM `{$serverAuthDataTable}`");
$this->setStatus("Transferring");
if ($result instanceof \mysqli_result) {
$rows = 0;
while (is_array($row = $result->fetch_assoc())) {
$info = AccountInfo::defaultInstance($result["user"], $this->defaultOpts);
$info->registerTime = (int) $result["firstlogin"];
$info->lastLogin = (int) $result["lastlogin"];
$info->lastIp = $result["ip"];
$info->passwordHash = "{IMPORTED}";
$info->multiHash = ["saltless;" . $hashMethod => $result["password"], "nonhash:salt" => strtolower($result["user"])];
$writer->write($info);
$this->setProgress(++$rows / $result->num_rows);
}
$result->close();
} else {
throw new \InvalidArgumentException("Not a SimpleAuth user database");
}
}
public function __construct(bool $overwrite, MySQLCredentials $cred, string $tableName)
{
$this->overwrite = $overwrite;
$this->mysqli = MySQLDatabase::createMysqliInstance($cred);
$this->tableName = $tableName;
}
