84 lines
2.9 KiB
PHP
84 lines
2.9 KiB
PHP
<?php
|
|
namespace Mince;
|
|
|
|
use InvalidArgumentException;
|
|
use RuntimeException;
|
|
use Index\Data\{DbStatementCache,IDbConnection};
|
|
|
|
class Capes {
|
|
private DbStatementCache $cache;
|
|
|
|
public function __construct(IDbConnection $dbConn) {
|
|
$this->cache = new DbStatementCache($dbConn);
|
|
}
|
|
|
|
public function checkHash(string $hash): bool {
|
|
if(!ctype_xdigit($hash) || strlen($hash) !== 64)
|
|
throw new InvalidArgumentException('$hash is not a valid hash string.');
|
|
|
|
$stmt = $this->cache->get('SELECT COUNT(*) FROM capes WHERE cape_hash = UNHEX(?)');
|
|
$stmt->addParameter(1, $hash);
|
|
$stmt->execute();
|
|
$result = $stmt->getResult();
|
|
return $result->next() && $result->getInteger(0) > 0;
|
|
}
|
|
|
|
public function getCape(AccountLinkInfo|UserInfo|string $userInfo): ?CapeInfo {
|
|
if($userInfo instanceof AccountLinkInfo)
|
|
$userInfo = $userInfo->getUserId();
|
|
elseif($userInfo instanceof UserInfo)
|
|
$userInfo = $userInfo->getId();
|
|
|
|
$stmt = $this->cache->get('SELECT user_id, LOWER(HEX(cape_hash)), UNIX_TIMESTAMP(cape_updated) FROM capes WHERE user_id = ?');
|
|
$stmt->addParameter(1, $userInfo);
|
|
$stmt->execute();
|
|
|
|
$result = $stmt->getResult();
|
|
return $result->next() ? CapeInfo::fromResult($result) : null;
|
|
}
|
|
|
|
public function updateCape(AccountLinkInfo|UserInfo|string $userInfo, string $hash): void {
|
|
if(!ctype_xdigit($hash) || strlen($hash) !== 64)
|
|
throw new InvalidArgumentException('$hash is not a valid hash string.');
|
|
|
|
if($userInfo instanceof AccountLinkInfo)
|
|
$userInfo = $userInfo->getUserId();
|
|
elseif($userInfo instanceof UserInfo)
|
|
$userInfo = $userInfo->getId();
|
|
|
|
$stmt = $this->cache->get('REPLACE INTO capes (user_id, cape_hash) VALUES (?, UNHEX(?))');
|
|
$stmt->addParameter(1, $userInfo);
|
|
$stmt->addParameter(2, $hash);
|
|
$stmt->execute();
|
|
}
|
|
|
|
public function deleteCape(
|
|
AccountLinkInfo|UserInfo|string|null $userInfo = null,
|
|
?string $hash = null
|
|
): void {
|
|
$hasUserInfo = $userInfo !== null;
|
|
$hasHash = $hash !== null;
|
|
|
|
if(!$hasUserInfo && !$hasHash)
|
|
throw new InvalidArgumentException('At least one argument must be specified.');
|
|
if($hasUserInfo && $hasHash)
|
|
throw new InvalidArgumentException('Only one argument may be specified.');
|
|
|
|
$value = null;
|
|
$query = 'DELETE FROM capes';
|
|
if($hasUserInfo) {
|
|
$query .= ' WHERE user_id = ?';
|
|
$value = $userInfo instanceof AccountLinkInfo
|
|
? $userInfo->getUserId()
|
|
: ($userInfo instanceof UserInfo ? $userInfo->getId() : $userInfo);
|
|
} elseif($hasHash) {
|
|
$query .= ' WHERE cape_hash = UNHEX(?)';
|
|
$value = $hash;
|
|
}
|
|
|
|
$stmt = $this->cache->get($query);
|
|
$stmt->addParameter(1, $value);
|
|
$stmt->execute();
|
|
}
|
|
}
|