[KinderClans]

I need some help to convert this MySQL R39 code to R41-4, i can't figure out how to make it work.

pawn Код:

cache_get_field_content(f, "salaries_string", query, dbHandle, 256);
        sscanf(query, "p<|>ddddddddddddddd",
        FactionInfo[f][fSalary][0], FactionInfo[f][fSalary][1], FactionInfo[f][fSalary][2],
        FactionInfo[f][fSalary][3], FactionInfo[f][fSalary][4], FactionInfo[f][fSalary][5],
        FactionInfo[f][fSalary][6], FactionInfo[f][fSalary][7], FactionInfo[f][fSalary][8],
        FactionInfo[f][fSalary][9], FactionInfo[f][fSalary][10], FactionInfo[f][fSalary][11],
        FactionInfo[f][fSalary][12], FactionInfo[f][fSalary][13], FactionInfo[f][fSalary][14]);

        mysql_format(dbHandle, query, sizeof(query), "SELECT * FROM characters WHERE faction_id = '%d' AND banned = 0 AND deleted = 0 AND deleted_at IS NULL", f);
        mysql_tquery(dbHandle, query, "OnQueryFinished", "dd", f, THREAD_FACTION_MEMBERS);

        for(new j; j < MAX_FACTION_RANKS; j++)
        {
            if(FactionInfo[f][fSkins][j]) FactionInfo[f][fSkinsCount]++;

            format(query, sizeof(query), "rank_%d", j + 1);
            cache_get_field_content(f, query, fRanks[f][j], dbHandle, 80);
        }

            for(new i; i < MAX_FACTION_RANKS; i++)
    {
        format(skins_string, sizeof(skins_string), "%s%d|", skins_string, FactionInfo[factionid][fSkins][i]);
        format(salaries_string, sizeof(salaries_string), "%s%d|", salaries_string, FactionInfo[factionid][fSalary][i]);
        mysql_format(dbHandle, query, sizeof(query), "%s, rank_%d = '%e'", query, i + 1, fRanks[factionid][i]);
    }

Thanks.

[Rolux]

Change

Код:

cache_get_field_content(f, "salaries_string", query, dbHandle, 256);

to

Код:

cache_get_value_name(f, "salaries_string", query,256);

and

Код:

cache_get_field_content(f, query, fRanks[f][j], dbHandle, 80);

to

Код:

cache_get_value_name(f, query, fRanks[f][j],80);