Problem: mysql command that causes crash.
#2

Try better version

pawn Код:
CMD:vermiembrosfacc(playerid, params[])
{
    if(pInfo[playerid][jAdminXLEP] <= 4) return SCM(playerid, COLOR_GRAD, "Necesitas ser administrador nivel 5 para usar este comando.");
    if(sscanf(params, "i", params[0])) return SCM(playerid, COLOR_LABELS, "Modo de uso: /vermiembrosfacc [ID facciуn]"), SCM(playerid, -1, "{FFFF00}[ID Facciones] {A6F06F}1: {FFFFFF}ASR {A6F06F}2: {FFFFFF}CMA {A6F06F}3: {FFFFFF}CIH {A6F06F}4: {FFFFFF}SAEM");
    if(params[0] < 1 || params[0] > 4) return SCM(playerid, COLOR_GRAD, "Sуlo es vбlida la ID 1 y 4, colocar sуlo /vermiembrosfacc para saber las IDґs.");
    mysql_tquery(mysql, "SELECT * FROM `usuarios`", "MiembrosFaccion", "ii", params[0], playerid);
    PlayerPlaySound(playerid, 1057, 0.0, 0.0, 0.0);
    return 1;
}

funcion:MiembrosFaccion(id, playerid)
{
    new rows = cache_num_rows();
    if(rows != 0)
    {
        new i, faccionid, rango, cadena[64], username[MAX_PLAYER_NAME];
        for(i = 0; i < rows; i++)
        {
            cache_get_field_content(i, "Nombre", username, mysql, MAX_PLAYER_NAME);
            faccionid = cache_get_field_content_int(i, "Faccion");
            rango = cache_get_field_content_int(i, "Rango");
            if(id == 1) format(cadena, sizeof(cadena), "{FFFF00}[Facciуn ASR] {FFFFFF}%s Rango: [%i/8]", username, rango);
            else if(id == 2) format(cadena, sizeof(cadena), "{FFFF00}[Facciуn CMA] {FFFFFF}%s Rango: [%i/8]", username, rango);
            else if(id == 3) format(cadena, sizeof(cadena), "{FFFF00}[Facciуn CIH] {FFFFFF}%s Rango: [%i/8]", username, rango);
            else format(cadena, sizeof(cadena), "{FFFF00}[Facciуn SAEM] {FFFFFF}%s Rango: [%i/8]", username, rango);

            SCM(playerid, -1, cadena);
        }
        if(i == 0) SCM(playerid, COLOR_GRAD, "No hay miembros en la facciуn.");
    }
    return 1;
}
Reply


Messages In This Thread
Problem: mysql command that causes crash. - by Unrea1 - 28.11.2015, 00:03
Re: Problem: mysql command that causes crash. - by Jefff - 28.11.2015, 00:34
Re: Problem: mysql command that causes crash. - by Unrea1 - 29.11.2015, 01:06
Re: Problem: mysql command that causes crash. - by Unrea1 - 30.11.2015, 12:13
Re: Problem: mysql command that causes crash. - by maddinat0r - 07.12.2015, 09:58

Forum Jump:


Users browsing this thread: 1 Guest(s)