MUP clanovi

// lista clanova | MUPara
mysql_format(Database, DB_Query, sizeof(DB_Query), "SELECT Nick_yuBb, OrgRank_yuBb FROM `korisnici` WHERE `Clan_yuBb` = '%d' ORDER BY `OrgRank_yuBb` DESC", 2);
new Cache:rezultat = mysql_query(Database, DB_Query), rows;
cache_get_row_count(rows);
if (!rows) return SendClientMessage( playerid, COLOR_GRAY, "Vasa organizacija nema clanova.");
new info[2048], ImeClana[27], pRankic, onlinedata[20];
new spec_vodje[144], spec_clanovi[444];
new istr_vodje[144], istr_clanovi[444];
new pres_vodje[144], pres_clanovi[444];
new saob_vodje[144], saob_clanovi[444],
    novi_clanovi[144];
for (new i; i != rows; i++)
{
    cache_get_value(i, "Nick_yuBb", ImeClana, 24);
    cache_get_value_int(i, "OrgRank_yuBb", pRankic);

    if(IgracKonektovan(ImeClana)) format(onlinedata, sizeof(onlinedata), "{4BFB33}Online");
    else format(onlinedata, sizeof(onlinedata), "{f81414}Offline");

    if(pRankic == 1)        format(saob_clanovi, sizeof(saob_clanovi), "%s{FFFFFF}%s {F3FF02}Saobracajac %s\n", saob_clanovi, BezDonje(ImeClana), onlinedata);
    else if(pRankic == 2)   format(pres_clanovi, sizeof(pres_clanovi), "%s{FFFFFF}%s {F3FF02}Presretac %s\n", pres_clanovi, BezDonje(ImeClana), onlinedata);
    else if(pRankic == 3)   format(istr_clanovi, sizeof(istr_clanovi), "%s{FFFFFF}%s {F3FF02}Inspektor %s\n", istr_clanovi, BezDonje(ImeClana), onlinedata);
    else if(pRankic == 4)   format(spec_clanovi, sizeof(spec_clanovi), "%s{FFFFFF}%s {F3FF02}Specijalac %s\n", spec_clanovi, BezDonje(ImeClana), onlinedata);
    else if(pRankic == 5)   format(saob_vodje, sizeof(saob_vodje), "%s{FFFFFF}%s {D7B20E}Vodja: Saobracajna %s\n", saob_vodje, BezDonje(ImeClana), onlinedata);
    else if(pRankic == 6)   format(istr_vodje, sizeof(istr_vodje), "%s{FFFFFF}%s {D7B20E}Vodja: Presretaci %s\n", istr_vodje, BezDonje(ImeClana), onlinedata);
    else if(pRankic == 7)   format(pres_vodje, sizeof(pres_vodje), "%s{FFFFFF}%s {D7B20E}Vodja: Istrazna %s\n", pres_vodje, BezDonje(ImeClana), onlinedata);
    else if(pRankic == 8)   format(spec_vodje, sizeof(spec_vodje), "%s{FFFFFF}%s {D7B20E}Vodja: Specijalna %s\n", spec_vodje, BezDonje(ImeClana), onlinedata);
    else                    format(novi_clanovi, sizeof(novi_clanovi), "%s{FFFFFF}%s {00C0FF}Novi %s\n", novi_clanovi, BezDonje(ImeClana), onlinedata);
}
format(info, sizeof(info), "{336BFF}Spisak svih pripadnika ministarstva:\n\n%s\n%s\n%s\n%s\n%s\n%s\n%s\n%s\n%s\n{FFFFFF}Brojnost: {8781E7}%d/%d",
                            spec_vodje, spec_clanovi,
                            istr_vodje, istr_clanovi,
                            pres_vodje, pres_clanovi,
                            saob_vodje, saob_clanovi,
                            novi_clanovi,
                            rows, OrgInfo[2][oMaxClanova]);
AC_ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_MSGBOX, "Spisak svih clanova", info, "Zatvori", "" );
cache_delete(rezultat);