[Drek]

Hello,

So my concern is that stores load properly, but the pickups and labels, not apparraisse games ..

Here's the code:

pawn Код:

public Shop_load()
{
    new Requete[504], fields[57][MAX_PLAYER_NAME], row[320];

    format(Requete, sizeof(Requete), "SELECT COUNT(*) FROM shops");
    mysql_query(Requete);
    mysql_store_result();
    mysql_fetch_row(row);
    Total_shop = strval(row);
    mysql_free_result();

    for(new i=1; i<=Total_shop; i++)
    {
        format(Requete, sizeof(Requete), "SELECT * FROM shops WHERE id=%d", i);
        mysql_query(Requete);
        mysql_store_result();
        mysql_fetch_row(row);
        split(row, fields, '|');

        Shop_infos[i][shopX] = floatstr(fields[1]);
        Shop_infos[i][shopY] = floatstr(fields[2]);
        Shop_infos[i][shopZ] = floatstr(fields[3]);
        Shop_infos[i][shopXexit] = floatstr(fields[4]);
        Shop_infos[i][shopYexit] = floatstr(fields[5]);
        Shop_infos[i][shopZexit] = floatstr(fields[6]);
        Shop_infos[i][shopCaisse] = strval(fields[7]);
        Shop_infos[i][shopInterieur] = strval(fields[8]);
        Shop_infos[i][shopLock] = strval(fields[9]);

        if(Shop_is_valide(i))
        {
            Shop_infos[i][shopPickup] = CreateDynamicPickup(1318, 1, Shop_infos[i][shopX], Shop_infos[i][shopY], Shop_infos[i][shopZ], -1, -1, -1, PICKUP_STREAM_DISTANCE);
            Shop_infos[i][shopLabel] = CreateDynamic3DTextLabel("/entrer",COLOR_LABEL,Shop_infos[i][shopX], Shop_infos[i][shopY], Shop_infos[i][shopZ]+0.5,25.0,INVALID_PLAYER_ID,INVALID_VEHICLE_ID,0,0,0,-1,LABEL_STREAM_DISTANCE);
        }
        mysql_free_result();
    }
    
    printf(">   %d load     !", Total_shop);
    return 1;
}

if(Shop_is_valide(i))
{
Shop_infos[i][shopPickup] = CreateDynamicPickup(1318, 1, Shop_infos[i][shopX], Shop_infos[i][shopY], Shop_infos[i][shopZ], -1, -1, -1, PICKUP_STREAM_DISTANCE);
Shop_infos[i][shopLabel] = CreateDynamic3DTextLabel("/entrer",COLOR_LABEL,Shop_infos[i][shopX], Shop_infos[i][shopY], Shop_infos[i][shopZ]+0.5,25.0,INVALID_PLAYER_ID,INVALID_VEHICLE_ID,0,0 ,0,-1,LABEL_STREAM_DISTANCE);
}

Sorry for the spelling mistakes, I am French.

Sincerely,
Drek.

[Drek]

Hello,

Concerns repair , but I like to know if someone with a method for if id does not start with 1, the load does not load, and if for example a 4 am id the id 6, the 6-7-8-9 id will not charge because the id 5 is absent in the table.

I hope I was understood, and this will help you huh ..


Sincerely .