示例#1
0
/**
 * 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;
}
示例#2
0
/**
 * 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;
}
示例#3
0
/**
 * 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;
}
示例#4
0
/**
 * 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;
    }
}