Problema Factions

[AdY.Capone]

Problema intalnita (descriere):Nu extrage corect factiuniile din database.
Ero(area / rile) / warning-(ul / urile): -
Liniile de cod / sursa / script-ul(obligatoriu):

 

 

 

CMD:factions(playerid, params[])
{
    new members;
    new stringz2[1024];
    for(new xf = 0; xf < MAX_GROUPS; xf++)
    {
        if(strlen(groupVariables[xf][gGroupName]) >= 1 && strcmp(groupVariables[xf][gGroupName], "None", true))
        {
            new stringy2[256], app;
            mysql_format(handle, stringy2, 256, "SELECT * FROM `playeraccounts` WHERE  `playerGroup` = '%d'", xf);
            new Cache: resultx = mysql_query (handle, stringy2);
            members = cache_get_row_count();
            cache_delete(resultx);
            
            mysql_format(handle, stringy2, 256, "SELECT * FROM `groups` WHERE `groupID` = '%d'", xf);
            new Cache: resultd = mysql_query(handle, stringy2);
            if(cache_get_row_count() != 0)
            {
                cache_get_field_content(0, "groupApplication", result); app = strval(result);
            }
            cache_delete(resultd);
            
            if(app == 1)
            {
                format(stringz2, sizeof(stringz2),"%s%s [%d/%d] {00FF00}[applications online]{FFFFFF}\n", stringz2, groupVariables[xf][gGroupName], members, groupVariables[xf][gMaxMembers]);
            }
            else if(app == 1)
            {
                format(stringz2, sizeof(stringz2),"%s%s [%d/%d] {FF0000}[applications offline]{FFFFFF}\n", stringz2, groupVariables[xf][gGroupName], members, groupVariables[xf][gMaxMembers]);
            }
        }
        ShowPlayerDialog(playerid, DIALOG_FACTIONS, DIALOG_STYLE_LIST,"Server: Factions", stringz2, "Select", "Cancel");
    }
    return 1;
}

 

 

In database sunt 10 factiunii.. acestia nu se extrag corect.. pe server apar decat 9, doar primele 3 apar informatiile necesare.. la celelalte sunt inversate ex.. scrie Grove Street iar cand dau click apare hitman

Imagini / Video (optional):
Ati incercat sa rezolvati singur?:

 

[alexredd]

Quote

CMD:factions(playerid, params[])
{
    new members;
    new stringz2[1024];
    for(new xf = 0; xf < MAX_GROUPS; xf++)
    {
        if(strlen(groupVariables[xf][gGroupName]) >= 1 && strcmp(groupVariables[xf][gGroupName], "None", true))
        {
            new stringy2[256], app;
            mysql_format(handle, stringy2, 256, "SELECT * FROM `playeraccounts` WHERE  `playerGroup` = '%d'", xf);
            new Cache: resultx = mysql_query (handle, stringy2);
            members = cache_get_row_count();
            cache_delete(resultx);
            
            mysql_format(handle, stringy2, 256, "SELECT * FROM `groups` WHERE `groupID` = '%d'", xf);
            new Cache: resultd = mysql_query(handle, stringy2);
            if(cache_get_row_count() != 0)
            {
                cache_get_field_content(0, "groupApplication", result); app = strval(result);
            }
            cache_delete(resultd);
            
            if(app == 1)
            {
                format(stringz2, sizeof(stringz2),"%s%s [%d/%d] {00FF00}[applications online]{FFFFFF}\n", stringz2, groupVariables[xf][gGroupName], members, groupVariables[xf][gMaxMembers]);
            }
            else if(app == 0)
            {
                format(stringz2, sizeof(stringz2),"%s%s [%d/%d] {FF0000}[applications offline]{FFFFFF}\n", stringz2, groupVariables[xf][gGroupName], members, groupVariables[xf][gMaxMembers]);
            }
        }
        ShowPlayerDialog(playerid, DIALOG_FACTIONS, DIALOG_STYLE_LIST,"Server: Factions", stringz2, "Select", "Cancel");
    }
    return 1;
}

POFTIM!