public static function banAccount($accountId)
{
if (isset($accountId)) {
$db = db::getInstance();
$stmt = $db->prepare('UPDATE
tblUserAccount
SET
tblUserAccount_banned = 1
WHERE
tblUserAccount_accId = :aid');
$stmt->bind_param('aid', $accountId);
$stmt->execute();
}
}
public static function saveUnauthorizedAccess($checksum, $accountId)
{
if (isset($checksum) && isset($accountId)) {
$db = db::getInstance();
$stmt = $db->prepare('SELECT
count(tblAPIUnauthorizedAccess_accessId)
AS
counter
FROM
tblAPIUnauthorizedAccess
WHERE
tblAPIUnauthorizedAccess_accountId = :aid');
$stmt->bind_param('aid', $accountId);
$stmt->execute();
$result = $stmt->fetch_assoc();
$stmt2 = $db->prepare('INSERT INTO
tblAPIUnauthorizedAccess
SET
tblAPIUnauthorizedAccess_checksum = :csum,
tblAPIUnauthorizedAccess_accountId = :accId');
$stmt2->bind_param('csum', $checksum);
$stmt2->bind_param('accId', $accountId);
$stmt2->execute();
if ($result['counter'] >= 1) {
Account::killSession();
Account::banAccount($accountId);
return 'banned';
}
}
}
public function addAccount($accountData)
{
if (!isset($accountData)) {
// Error Handling
return false;
} else {
if ($this->validateData($accountData) == false) {
return false;
} else {
$db = db::getInstance();
$stmt = $db->prepare('INSERT INTO
tblUserAccount
SET
tblUserAccount_loginName = :lName,
tblUserAccount_pwd = :password,
tblUserAccount_email = :accountmail');
$stmt->bind_param('lName', $this->loginName);
$stmt->bind_param('password', $this->password);
$stmt->bind_param('accountmail', $this->email);
$stmt->execute();
return true;
}
}
}
