Example #1
0
 public static function getTokenData($token)
 {
     if (MyUtil::isNullOrEmpty($token)) {
         return MyUtil::fnOk(false, "Must have a token", null);
     }
     $stm = "SELECT tok.USER_ID, use.USER_TYPE_NBR, tok.SESSION_ID " . " FROM " . self::$table_name . " tok " . " JOIN spire.USERS use ON tok.USER_ID = use.ID " . " WHERE TOKEN_ID = '{$token}' ";
     $result = ConnDB::query_db($stm);
     if (!$result) {
         return MyUtil::fnOk(false, "SQL Error", null);
     }
     $row = pg_fetch_assoc($result);
     if (isset($row['user_id'])) {
         return MyUtil::fnOk(true, "User-Token found", $row);
     }
 }