/** * Get a token's information * @param integer Token type * @param integer User ID * @return array Token row */ function token_get($p_type, $p_user_id = null) { token_purge_expired_once(); $c_type = db_prepare_int($p_type); $c_user_id = db_prepare_int($p_user_id == null ? auth_get_current_user_id() : $p_user_id); $t_tokens_table = db_get_table('mantis_tokens_table'); $t_query = "SELECT * FROM {$t_tokens_table}\n\t\t\t\t\tWHERE type=" . db_param() . " AND owner=" . db_param(); $t_result = db_query_bound($t_query, array($c_type, $c_user_id)); if (db_num_rows($t_result) > 0) { return db_fetch_array($t_result); } return null; }
/** * Get a token's information * @param integer $p_type The token type to retrieve. * @param integer $p_user_id A valid user identifier. * @return array Token row */ function token_get($p_type, $p_user_id = null) { token_purge_expired_once(); $c_type = (int) $p_type; $c_user_id = (int) ($p_user_id == null ? auth_get_current_user_id() : $p_user_id); $t_query = 'SELECT * FROM {tokens} WHERE type=' . db_param() . ' AND owner=' . db_param(); $t_result = db_query($t_query, array($c_type, $c_user_id)); $t_row = db_fetch_array($t_result); if ($t_row) { return $t_row; } return null; }
/** * Get a token's information * @param integer $p_type Token type * @param integer $p_user_id User ID * @return array Token row */ function token_get($p_type, $p_user_id = null) { token_purge_expired_once(); $c_type = (int) $p_type; $c_user_id = (int) ($p_user_id == null ? auth_get_current_user_id() : $p_user_id); $t_tokens_table = db_get_table('tokens'); $t_query = "SELECT * FROM {$t_tokens_table}\n\t\t\t\t\tWHERE type=" . db_param() . " AND owner=" . db_param(); $t_result = db_query_bound($t_query, array($c_type, $c_user_id)); $t_row = db_fetch_array($t_result); if ($t_row) { return $t_row; } return null; }
/** * Get a token's information * @param integer Token type * @param integer User ID * @return array Token row */ function token_get($p_type, $p_user_id = null) { token_purge_expired_once(); $c_type = db_prepare_int($p_type); $c_user_id = db_prepare_int($p_user_id == null ? auth_get_current_user_id() : $p_user_id); $t_tokens_table = config_get('mantis_tokens_table'); $query = "SELECT * FROM {$t_tokens_table} \n\t\t\t\t\tWHERE type='{$c_type}' AND owner='{$c_user_id}'"; $result = db_query($query); if (db_num_rows($result) > 0) { return db_fetch_array($result); } else { return null; } }