Auth_OpenID_MySQLStore Klassenreferenz

Abgeleitet von Auth_OpenID_SQLStore.

Zusammengehörigkeiten von Auth_OpenID_MySQLStore:

Collaboration graph
[Legende]

Öffentliche Methoden

 setSQL ()
 blobEncode ($blob)

Ausführliche Beschreibung

Definiert in Zeile 19 der Datei MySQLStore.php.


Dokumentation der Elementfunktionen

blobEncode ( blob  ) 

private

Erneute Implementation von Auth_OpenID_SQLStore.

Definiert in Zeile 72 der Datei MySQLStore.php.

00073     {
00074         return "0x" . bin2hex($blob);
00075     }

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     }


Die Dokumentation für diese Klasse wurde erzeugt aufgrund der Datei:
Copyright © 2003 - 2009 MyOOS [Shopsystem]. All rights reserved.
MyOOS [Shopsystem] is Free Software released under the GNU/GPL License.

Webmaster: info@r23.de (Impressum)
doxygen