3 if(!isset($MSG_QUEUE_KEY_ID_SERVER)) $MSG_QUEUE_KEY_ID_SERVER = "189751072"; // i would use ftok, but its crap
4 if(!isset($MSG_QUEUE_KEY_ID_CLIENT)) $MSG_QUEUE_KEY_ID_CLIENT = "189751073"; // ftok is not ok!
5 global $MSG_QUEUE_KEY_ID_SERVER, $MSG_QUEUE_KEY_ID_CLIENT;
7 define("MSG_AUTH_USER_TOKEN", 1);
8 define("MSG_ADD_USER_TOKEN", 2);
9 define("MSG_DELETE_USER", 3);
10 define("MSG_AUTH_USER_PASSWORD", 4);
11 define("MSG_SET_USER_PASSWORD", 5);
12 define("MSG_SET_USER_REALNAME", 6);
13 define("MSG_SET_USER_TOKEN", 7);
14 define("MSG_SET_USER_TOKEN_TYPE", 8);
15 define("MSG_GET_USERS", 9);
16 define("MSG_GET_OTK_PNG", 10);
17 define("MSG_GET_OTK_ID", 11);
18 define("MSG_DELETE_USER_TOKEN", 12);
19 define("MSG_SYNC_TOKEN", 13);
20 define("MSG_GET_TOKEN_TYPE", 14);
23 $BASE_DIR = realpath(dirname(__FILE__)."/../../");
27 require_once(dirname(__FILE__)."/../../lib/ga4php.php");
29 function generateRandomString()
32 $strpos = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
34 for($i=0; $i<128; $i++) {
35 $str .= $strpos[rand(0, strlen($strpos)-1)];
42 function getDatabase() {
45 if(file_exists("$BASE_DIR/authserver/authd/gaasdata.sqlite")) {
47 $dbobject = new PDO("sqlite:$BASE_DIR/authserver/authd/gaasdata.sqlite");
48 } catch(PDOException $exep) {
49 error_log("execpt on db open");
53 $dbobject = new PDO("sqlite:$BASE_DIR/authserver/authd/gaasdata.sqlite");
54 } catch(PDOException $exep) {
55 error_log("execpt on db open");
57 $sql = 'CREATE TABLE "users" ("users_id" INTEGER PRIMARY KEY AUTOINCREMENT,"users_username" TEXT, "users_realname" TEXT, "users_password" TEXT, "users_tokendata" TEXT, "users_otk" TEXT);';
58 $dbobject->query($sql);
64 function closeDatabase($db) {
65 // doesnt do anything yet
68 class gaasGA extends GoogleAuthenticator {
69 function getData($username) {
70 echo "called into getdata\n";
72 // get our database connection
73 $dbObject = getDatabase();
75 // set the sql for retreiving the data
76 $sql = "select users_tokendata from users where users_username='$username'";
79 $result = $dbObject->query($sql);
83 if(!$result) return false;
85 // now just retreieve all the data (there should only be one, but whatever)
88 foreach($result as $row) {
89 $tokendata = $row["users_tokendata"];
92 echo "next3, $username, $tokendata\n";
93 // now we have our data, we just return it. If we got no data
94 // we'll just return false by default
97 // and there you have it, simple eh?
101 function putData($username, $data) {
102 // get our database connection
103 $dbObject = getDatabase();
105 // we need to check if the user exists, and if so put the data, if not create the data
106 $sql = "select * from users where users_username='$username'";
107 $res = $dbObject->query($sql);
108 if($res->fetchColumn() > 0) {
110 error_log("doing userdata update");
111 $sql = "update users set users_tokendata='$data' where users_username='$username'";
114 error_log("doing user data create");
115 $sql = "insert into users values (NULL, '$username', '', '', '$data', '')";
118 if($dbObject->query($sql)) {
126 function getUsers() {
127 // get our database connection
128 $dbObject = getDatabase();
131 $sql = "select users_username from users";
134 $result = $dbObject->query($sql);
136 // iterate over the results - we expect a simple array containing
137 // a list of usernames
140 foreach($result as $row) {
141 $users[$i] = $row["username"];
145 // now return the list