X-Git-Url: http://git.pjr.cc/?p=ga4php.git;a=blobdiff_plain;f=example%2Ftokenstore.php;fp=example%2Ftokenstore.php;h=017439cc0fe9d1dad5345c6e19ef81ac20a4c87b;hp=0000000000000000000000000000000000000000;hb=30d86631e9cf0adda2fc14c01ea1bcc6c91356bf;hpb=f88ed4325723f38ed064d4abb07485ab990e6464

diff --git a/example/tokenstore.php b/example/tokenstore.php
new file mode 100644
index 0000000..017439c
--- /dev/null
+++ b/example/tokenstore.php
@@ -0,0 +1,78 @@
+<?php
+// define our data-set functions
+function mySetData($query, $data) {
+	global $dbobject;
+	
+//	echo "called set data: $query<pre>";
+//	print_r($query);
+//	print_r($data);
+//	echo "</pre>";
+	
+	switch($query) {
+		case "settokentype":
+			$ttype = $data["tokentype"];
+			$tuser = $data["username"];
+			$res = $dbobject->query("update users set users_tokentype='$ttype' where users_username='$tuser'");
+			break;
+		case "setusertoken":
+			$ttype = $data["tokentype"];
+			$tkey = $data["tokenkey"];
+			$tuser = $data["username"];
+			
+			// dont really care if it does or not
+			$res = $dbobject->query("delete from users where users_username = '$tuser'");
+			
+			$sql = "insert into users values (NULL, '$tuser', '$ttype', '$tkey', '0')";
+			error_log("would call: $sql");
+			$res = $dbobject->query($sql);
+			break;
+		case "deleteusertoken":
+			$res = $dbobject->query("delete from users where users_username = '$data'");
+			break;
+		case "settokencounter":
+			$tcount = $data["tokencounter"];
+			$tuser = $data["username"];
+			$res = $dbobject->query("update users set users_tokencounter='$tcount' where users_username='$tuser'");
+			break;
+		default:
+			// do nothing
+	}
+}
+
+function myGetData($query, $data) {
+	//echo "called get data:<pre>";
+	//print_r($query);
+	//print_r($data);
+	//echo "</pre>";
+	global $dbobject;
+	
+	switch($query) {
+		case "userlist":
+			$sql = "select users_username from users";
+			$res = $dbobject->query($sql);
+			$i = 0;
+			$names[0] = "";
+			foreach($res as $row) {
+				//error_log("got username, ".$row["users_username"]);
+				$names[$i] = $row["users_username"];
+				$i++;
+			}
+			return $names;
+			break;
+		case "gettoken":
+			$sql = "select * from users where users_username='$data'";
+			$res = $dbobject->query($sql);
+			$i = 0;
+			$token = "";
+			foreach($res as $row) {
+				$token["tokentype"] = $row["users_tokentype"];
+				$token["tokenkey"] = $row["users_tokenkey"];
+				$token["tokencounter"] = $row["users_tokencounter"];
+			}
+			return $token;
+		default:
+			// nothing
+	}
+}
+
+?>
\ No newline at end of file