58 lines
1.5 KiB
PHP
58 lines
1.5 KiB
PHP
<?php
|
|
define('ALIBERR_NOTGR', 20);
|
|
define('ALIBERR_BADSMEMB', 21);
|
|
|
|
/**
|
|
* Subj class
|
|
*
|
|
* users + groups
|
|
* with "linearized recursive membership" ;)
|
|
* (allow adding users to groups or groups to groups)
|
|
*
|
|
* @package Airtime
|
|
* @subpackage Alib
|
|
* @copyright 2010 Sourcefabric O.P.S.
|
|
* @license http://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 = array(":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 = array(":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 = array(":login" => $login);
|
|
|
|
$res = Application_Common_Database::prepareAndExecute($sql, $map,
|
|
Application_Common_Database::COLUMN);
|
|
|
|
return ($res !== false) ? $res : 0;
|
|
}
|
|
|
|
} // class Subjects
|