Öffentliche Methoden | |
setSQL () | |
blobEncode ($blob) |
Definiert in Zeile 19 der Datei MySQLStore.php.
blobEncode | ( | $ | blob | ) |
private
Erneute Implementation von Auth_OpenID_SQLStore.
Definiert in Zeile 72 der Datei MySQLStore.php.
setSQL | ( | ) |
private
Erneute Implementation von Auth_OpenID_SQLStore.
Definiert in Zeile 23 der Datei MySQLStore.php.
00024 { 00025 $this->sql['nonce_table'] = 00026 "CREATE TABLE %s (\n". 00027 " server_url VARCHAR(2047) NOT NULL,\n". 00028 " timestamp INTEGER NOT NULL,\n". 00029 " salt CHAR(40) NOT NULL,\n". 00030 " UNIQUE (server_url(255), timestamp, salt)\n". 00031 ") ENGINE=InnoDB"; 00032 00033 $this->sql['assoc_table'] = 00034 "CREATE TABLE %s (\n". 00035 " server_url BLOB NOT NULL,\n". 00036 " handle VARCHAR(255) NOT NULL,\n". 00037 " secret BLOB NOT NULL,\n". 00038 " issued INTEGER NOT NULL,\n". 00039 " lifetime INTEGER NOT NULL,\n". 00040 " assoc_type VARCHAR(64) NOT NULL,\n". 00041 " PRIMARY KEY (server_url(255), handle)\n". 00042 ") ENGINE=InnoDB"; 00043 00044 $this->sql['set_assoc'] = 00045 "REPLACE INTO %s (server_url, handle, secret, issued,\n". 00046 " lifetime, assoc_type) VALUES (?, ?, !, ?, ?, ?)"; 00047 00048 $this->sql['get_assocs'] = 00049 "SELECT handle, secret, issued, lifetime, assoc_type FROM %s ". 00050 "WHERE server_url = ?"; 00051 00052 $this->sql['get_assoc'] = 00053 "SELECT handle, secret, issued, lifetime, assoc_type FROM %s ". 00054 "WHERE server_url = ? AND handle = ?"; 00055 00056 $this->sql['remove_assoc'] = 00057 "DELETE FROM %s WHERE server_url = ? AND handle = ?"; 00058 00059 $this->sql['add_nonce'] = 00060 "INSERT INTO %s (server_url, timestamp, salt) VALUES (?, ?, ?)"; 00061 00062 $this->sql['clean_nonce'] = 00063 "DELETE FROM %s WHERE timestamp < ?"; 00064 00065 $this->sql['clean_assoc'] = 00066 "DELETE FROM %s WHERE issued + lifetime < ?"; 00067 }
Copyright © 2003 - 2009 MyOOS [Shopsystem]. All rights reserved. MyOOS [Shopsystem] is Free Software released under the GNU/GPL License. Webmaster: info@r23.de (Impressum) |
|