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); } }