sintonia/legacy/application/models/Subjects.php

62 lines
1.5 KiB
PHP

<?php
/**
* Subj class.
*
* users + groups
* with "linearized recursive membership" ;)
* (allow adding users to groups or groups to groups)
*
* @copyright 2010 Sourcefabric O.P.S.
* @license https://www.gnu.org/licenses/gpl.txt
*/
class Application_Model_Subjects
{
// ======================================================= public methods
public static function increaseLoginAttempts($login)
{
$sql = 'UPDATE cc_subjs SET login_attempts = login_attempts+1'
. ' WHERE login=:login';
$map = [':login' => $login];
$res = Application_Common_Database::prepareAndExecute(
$sql,
$map,
Application_Common_Database::EXECUTE
);
return intval($res) > 0;
}
public static function resetLoginAttempts($login)
{
$sql = "UPDATE cc_subjs SET login_attempts = '0'"
. ' WHERE login=:login';
$map = [':login' => $login];
$res = Application_Common_Database::prepareAndExecute(
$sql,
$map,
Application_Common_Database::EXECUTE
);
return true;
}
public static function getLoginAttempts($login)
{
$sql = 'SELECT login_attempts FROM cc_subjs WHERE login=:login';
$map = [':login' => $login];
$res = Application_Common_Database::prepareAndExecute(
$sql,
$map,
Application_Common_Database::COLUMN
);
return ($res !== false) ? $res : 0;
}
} // class Subjects