62 lines
1.5 KiB
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
|