example/tokenstore.php

   1 <?php
   2 // define our data-set functions
   3 function mySetData($query, $data) {
   4         global $dbobject;
   5
   6 //      echo "called set data: $query<pre>";
   7 //      print_r($query);
   8 //      print_r($data);
   9 //      echo "</pre>";
  10
  11         switch($query) {
  12                 case "settokentype":
  13                         $ttype = $data["tokentype"];
  14                         $tuser = $data["username"];
  15                         $res = $dbobject->query("update users set users_tokentype='$ttype' where users_username='$tuser'");
  16                         break;
  17                 case "setusertoken":
  18                         $ttype = $data["tokentype"];
  19                         $tkey = $data["tokenkey"];
  20                         $tuser = $data["username"];
  21
  22                         // dont really care if it does or not
  23                         $res = $dbobject->query("delete from users where users_username = '$tuser'");
  24
  25                         $sql = "insert into users values (NULL, '$tuser', '$ttype', '$tkey', '0')";
  26                         error_log("would call: $sql");
  27                         $res = $dbobject->query($sql);
  28                         break;
  29                 case "deleteusertoken":
  30                         $res = $dbobject->query("delete from users where users_username = '$data'");
  31                         break;
  32                 case "settokencounter":
  33                         $tcount = $data["tokencounter"];
  34                         $tuser = $data["username"];
  35                         $res = $dbobject->query("update users set users_tokencounter='$tcount' where users_username='$tuser'");
  36                         break;
  37                 default:
  38                         // do nothing
  39         }
  40 }
  41
  42 function myGetData($query, $data) {
  43         //echo "called get data:<pre>";
  44         //print_r($query);
  45         //print_r($data);
  46         //echo "</pre>";
  47         global $dbobject;
  48
  49         switch($query) {
  50                 case "userlist":
  51                         $sql = "select users_username from users";
  52                         $res = $dbobject->query($sql);
  53                         $i = 0;
  54                         $names[0] = "";
  55                         foreach($res as $row) {
  56                                 //error_log("got username, ".$row["users_username"]);
  57                                 $names[$i] = $row["users_username"];
  58                                 $i++;
  59                         }
  60                         return $names;
  61                         break;
  62                 case "gettoken":
  63                         $sql = "select * from users where users_username='$data'";
  64                         $res = $dbobject->query($sql);
  65                         $i = 0;
  66                         $token = "";
  67                         foreach($res as $row) {
  68                                 $token["tokentype"] = $row["users_tokentype"];
  69                                 $token["tokenkey"] = $row["users_tokenkey"];
  70                                 $token["tokencounter"] = $row["users_tokencounter"];
  71                         }
  72                         return $token;
  73                 default:
  74                         // nothing
  75         }
  76 }
  77
  78 ?>