define("MSG_SET_USER_TOKEN", 7);
define("MSG_SET_USER_TOKEN_TYPE", 8);
define("MSG_GET_USERS", 9);
+define("MSG_GET_OTK_PNG", 10);
+define("MSG_GET_OTK_ID", 11);
+define("MSG_DELETE_USER_TOKEN", 12);
+define("MSG_SYNC_TOKEN", 13);
+define("MSG_GET_TOKEN_TYPE", 14);
+
+// BASE_DIR =
+$BASE_DIR = realpath(dirname(__FILE__)."/../../");
+global $BASE_DIR;
+
+// messy
+require_once(dirname(__FILE__)."/../../lib/ga4php.php");
+
+function generateRandomString()
+{
+ $str = "";
+ $strpos = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
+
+ for($i=0; $i<128; $i++) {
+ $str .= $strpos[rand(0, strlen($strpos)-1)];
+ }
+
+ return $str;
+}
-if(file_exists("../../lib/ga4php.php")) require_once("../../lib/ga4php.php");
-if(file_exists("../lib/ga4php.php")) require_once("../lib/ga4php.php");
function getDatabase() {
$dbobject = false;
- if(file_exists("gaasdata.sqlite")) {
+ global $BASE_DIR;
+ if(file_exists("$BASE_DIR/authserver/authd/gaasdata.sqlite")) {
try {
- $dbobject = new PDO("sqlite:gaasdata.sqlite");
+ $dbobject = new PDO("sqlite:$BASE_DIR/authserver/authd/gaasdata.sqlite");
} catch(PDOException $exep) {
error_log("execpt on db open");
}
} else {
try {
- $dbobject = new PDO("sqlite:gaasdata.sqlite");
+ $dbobject = new PDO("sqlite:$BASE_DIR/authserver/authd/gaasdata.sqlite");
} catch(PDOException $exep) {
error_log("execpt on db open");
}
- $sql = 'CREATE TABLE "users" ("users_id" INTEGER PRIMARY KEY AUTOINCREMENT,"users_username" TEXT, "users_realname" TEXT, "users_password" TEXT, "users_tokendata" TEXT);';
+ $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);';
$dbobject->query($sql);
}
$res = $dbObject->query($sql);
if($res->fetchColumn() > 0) {
// do update
+ error_log("doing userdata update");
$sql = "update users set users_tokendata='$data' where users_username='$username'";
} else {
// do insert
- $sql = "insert into users values (NULL, '$username', '', '', '$data')";
+ error_log("doing user data create");
+ $sql = "insert into users values (NULL, '$username', '', '', '$data', '')";
}
if($dbObject->query($sql)) {