[xVIP3Rx]

Quote:

Originally Posted by Mellnik You gotta save the current cache in the for loop then run the mysql_query and delete the result. Then set the saved cache active again. @xVIP3Rx That changes nothing at all.

In some cases it gives me a warning,

Quote:

Originally Posted by Metharon Can somebody fix the code for me .. please? i mean to show an example or something

I think that's how the threaded query should be..

pawn Код:

mysql_tquery(SQL, "SELECT * FROM `sBusiness`", IncarcaSBIZZ);//replace IncarcaSBIZZ() with it, it'll call the stock.
forward IncarcaSBIZZ();
public IncarcaSBIZZ()
{
    new Get[2]; 
    cache_get_data(Get[0], Get[1], SQL); // Get[0] - Rows || Get[1] - Fields || SQL - connectionHandle
    new IDSB;
    new string[456];
    for(new i = 0; i < Get[0]; i++)
    {
        IDSB = cache_get_field_content_int(i, "ID");
        sBizz[IDSB][sBOwnable] = cache_get_field_content_int(i, "Ownable");
        sBizz[IDSB][sBDeposit] = cache_get_field_content_int(i, "Depozit");
        sBizz[IDSB][sBSettings] = cache_get_field_content_int(i, "Settings");
        sBizz[IDSB][sBPret] = cache_get_field_content_int(i, "Price");
        sBizz[IDSB][sBX] = cache_get_field_content_float(i, "PozitieX", SQL);
        sBizz[IDSB][sBY] = cache_get_field_content_float(i, "PozitieY", SQL);
        sBizz[IDSB][sBZ] = cache_get_field_content_float(i, "PozitieZ", SQL);
        cache_get_field_content(i, "Titlu", sBizz[IDSB][sBTitlu], SQL, 80);
        cache_get_field_content(i, "Detinator", sBizz[IDSB][sBDetinator], SQL, 50);
        CreateDynamicPickup(1239, 1,  sBizz[IDSB][sBX], sBizz[IDSB][sBY], sBizz[IDSB][sBZ], -1, -1, -1, 250.0);
        if(sBizz[IDSB][sBOwnable] == 0)
        {
            format(string, sizeof(string), "{FFCC00}[ %s ]\n\n( Pret de cumparare: {00cc33} %s$ {FFCC00})\n{FFCC00}( Tasteaza {CC0033}/buysbizz{FFCC00} )", sBizz[IDSB][sBTitlu], FormatMoney(sBizz[IDSB][sBPret]));
            sbizz[IDSB] = CreateDynamic3DTextLabel(string, COLOR_DCHAT, sBizz[IDSB][sBX], sBizz[IDSB][sBY], sBizz[IDSB][sBZ]+0.75,10.0,INVALID_PLAYER_ID,INVALID_VEHICLE_ID,1,0,-1,-1, 10.5);
        }
        if(sBizz[IDSB][sBOwnable] == 1)
        {
            format(string, sizeof(string), "{FFCC00}[ %s ]\n\n( Detinator: {00cc33} %s {FFCC00})", sBizz[IDSB][sBTitlu], sBizz[IDSB][sBDetinator]);
            sbizz[IDSB] = CreateDynamic3DTextLabel(string, COLOR_DCHAT, sBizz[IDSB][sBX], sBizz[IDSB][sBY], sBizz[IDSB][sBZ]+0.75,10.0,INVALID_PLAYER_ID,INVALID_VEHICLE_ID,1,0,-1,-1, 10.5);
        }
        if(sBizz[IDSB][sBOwnable] == 1)
        {
            format(szQuery, 500, "SELECT * FROM `Accounts` WHERE `Name` = '%s' LIMIT 1;", sBizz[IDSB][sBDetinator]);
            new Cache: result2 = mysql_query(SQL, szQuery);
            new Gete[ 2 ];
            cache_get_data(Gete[ 0 ], Gete[ 1 ], SQL);
            if(!Gete[ 0 ])
            {
                sBizz[IDSB][sBOwnable] = 0;
                format(sBizz[IDSB][sBDetinator], 50, "No-One");
            }
            cache_delete(result2);
        }
        sSBizz++;
    }
    GasPrice = sBizz[1][sBSettings] * Rata;
    //cache_delete(Result); Don't think you should delete a cache;
    printf("[8.] Am incarcat toate sbizz-urile [%d]",sSBizz);
}