[Rokzlive]

Here are the functions now, but still not working correctly.

pawn Код:

stock LoadOwnedVehicles()
{
    new
        String[2000],
        ModelL,
        CL[2],
        PriceL,
        OwnerL[MAX_PLAYER_NAME],
        Float:PosL[4],
        ID,
        PlateNumL[32];

    mysql_query("SELECT * FROM `ownedcars` WHERE `ID`");
    mysql_store_result();

    while(mysql_fetch_row(String, "|"))
    {
        if(!mysql_num_rows()) continue;
        sscanf(String,"p<|>iiiiis[24]ffffs[32]", ID, ModelL, CL[0], CL[1], PriceL, OwnerL, PosL[0], PosL[1], PosL[2], PosL[3], PlateNumL);//1695
        print(String);
        vehicledata[ID][Model] = ModelL;
        vehicledata[ID][Color1] = CL[0];
        vehicledata[ID][Color2] = CL[1];
        vehicledata[ID][Price] = PriceL;
        format(vehicledata[ID][Owner], 24, "%s", OwnerL);
        vehicledata[ID][PosX] = PosL[0];
        vehicledata[ID][PosY] = PosL[1];
        vehicledata[ID][PosZ] = PosL[2];
        vehicledata[ID][PosA] = PosL[3];
        format(vehicledata[ID][Plate], 32, "%s", PlateNumL);

        new
            ownedcar = CreateVehicle(ModelL, PosL[0], PosL[1], PosL[2], PosL[3], CL[0], CL[1], 500000);//1708
        SetVehicleNumberPlate(ownedcar, PlateNumL);

        isowned[ID] = ownedcar;
        printf("Owned vehicle %d spawned!",ID);
    }
    mysql_free_result();
    return 1;
}

pawn Код:

stock AddStoreFromMysql()
{
    new Str[1000], id, Float:X, Float:Y, Float:Z, STotal;
    mysql_query("SELECT * FROM `stores`");
    mysql_store_result();


    while(mysql_fetch_row(Str, "|"))
    {
        if(!mysql_num_rows()) continue;
        sscanf(Str, "p<|>ifff",id, X, Y, Z);
        print(Str);
        StorePickup = CreateDynamicPickup(1274, 23, X, Y, Z, -1, -1, -1, PICKUPDISTANCE);
        CreateDynamic3DTextLabel("Store", COLOR_YELLOW, X, Y, Z, 100.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, TEXTLABELDISTANCE);
        CreateDynamicMapIcon(X, Y, Z, 38, 0, -1, -1, -1, MAPICONDISTANCE);
        printf("Store spawned at %f %f %f!",X,Y,Z);
        STotal++;
    }
    mysql_free_result();
    printf("** %i\t<->\tStores Loaded From\t<->\tMySQL\t\t   **", STotal);
    return 1;
}