/** * Logs the user out and unsets cookie and database auth_token * * @since 1.0.0 * @return bool True if called * */ public function logout() { $uname = $this->_auth->getUserField('login'); $update = array("auth_token" => 'NULL'); $bind = array(":login" => $uname); DB::inst()->update("user", $update, "login = :login", $bind); $this->_auth->_setcookie("TP_COOKNAME", '', time() - COOKIE_EXPIRE); $this->_auth->_setcookie("TP_COOKID", '', time() - COOKIE_EXPIRE); $this->_auth->_setcookie("TP_REMEMBER", '', time() - COOKIE_EXPIRE); redirect(BASE_URL); }
public function __destruct() { DB::inst()->close(); }
function tp_set_password($password, $user_id) { $update = ["password" => tp_hash_password($password)]; $bind = [":id" => $user_id]; $q = DB::inst()->update('user', $update, 'userID=:id', $bind); }
public static function delete_option($name) { $results = DB::inst()->query("SELECT option_id FROM `option` WHERE `option_name` = '{$name}'"); if (is_null($results) || !$results->fetch(\PDO::FETCH_BOTH)) { return false; } self::do_action('delete_option', $option_name); DB::inst()->query("DELETE FROM `option` WHERE `option_name` = '{$name}'"); return true; }
public function getUsername($id) { $strSQL = DB::inst()->select('user', 'userID = "' . floatval($id) . '"', null, 'login LIMIT 1'); $row = $strSQL->fetch(); return $row[0]; }
/** * Retrieve requested field from user table * based on user's id. * * @since 3.0.2 * @return mixed * */ public function getUserValue($id, $field) { $bind = [":id" => $id]; $q = DB::inst()->select("user", "userID = :id", "", $field, $bind); foreach ($q as $r) { return $r[$field]; } }