File indexing completed on 2025-02-09 07:14:34

0001 <?php
0002 
0003 /**
0004  *  ocs-webserver
0005  *
0006  *  Copyright 2016 by pling GmbH.
0007  *
0008  *    This file is part of ocs-webserver.
0009  *
0010  *    This program is free software: you can redistribute it and/or modify
0011  *    it under the terms of the GNU Affero General Public License as
0012  *    published by the Free Software Foundation, either version 3 of the
0013  *    License, or (at your option) any later version.
0014  *
0015  *    This program is distributed in the hope that it will be useful,
0016  *    but WITHOUT ANY WARRANTY; without even the implied warranty of
0017  *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
0018  *    GNU Affero General Public License for more details.
0019  *
0020  *    You should have received a copy of the GNU Affero General Public License
0021  *    along with this program.  If not, see <http://www.gnu.org/licenses/>.
0022  *
0023  *    Created: 09.12.2016
0024  **/
0025 class Default_Model_DbTable_MemberToken extends Local_Model_Table
0026 {
0027 
0028     protected $_name = "member_token";
0029 
0030     protected $_keyColumnsForRow = array('token_member_id', 'token_provider_name');
0031 
0032     protected $_key = 'token_id';
0033 
0034     protected $_defaultValues = array(
0035         'token_member_id' => null,
0036         'token_provider_name' => null,
0037         'token_value' => 0,
0038         'token_provider_username' => null,
0039         'token_fingerprint' => 0,
0040         'token_created' => null,
0041         'token_changed' => null,
0042         'token_deleted' => null
0043     );
0044 
0045     /**
0046      * @param int $identifer
0047      * @return int
0048      */
0049     public function setDeleted($identifer)
0050     {
0051         return $this->delete($identifer);
0052     }
0053 
0054     /**
0055      * @param int $id
0056      * @return int
0057      */
0058     public function delete($id)
0059     {
0060         $sql = "UPDATE `{$this->_name}` SET `token_deleted` = NOW() WHERE `{$this->_key}` = :elementId";
0061         $stmnt = $this->_db->query($sql, array('elementId' => $id));
0062         return $stmnt->rowCount();
0063     }
0064 
0065 }