/**
* @param $user_id
* @param $removed_perm
*/
public static function removePerm($user_id, $removed_perm)
{
$original = UserRoleModel::getPerms($user_id);
$being_removed = array_search($removed_perm, $original);
unset($original[$being_removed]);
$database = DatabaseFactory::getFactory()->getConnection();
$sql = "UPDATE users SET perms = :new WHERE user_id = :user_id";
$query = $database->prepare($sql);
$query->execute(array(':new' => json_encode($original), ':user_id' => $user_id));
}
/**
* Remove A user permission
* @param $user_id
* @param $removed_perm
*/
public static function removePerm($user_id, $removed_perm)
{
if (self::$removePermQuery === null) {
self::$removePermQuery = DatabaseFactory::getFactory()->getConnection()->prepare("UPDATE users SET perms = :new WHERE user_id = :user_id");
}
$original = UserRoleModel::getPerms($user_id);
$being_removed = array_search($removed_perm, $original);
unset($original[$being_removed]);
self::$removePermQuery->execute(array(':new' => json_encode($original), ':user_id' => $user_id));
Session::add('feedback_positive', 'Removed that permission!');
}
