[Rokzlive]

Ok, i have 2 mysql based stocks origianlly coded in Gstyles, but i switched to strikenkids for better speed and stableness.

When i switched, alot of things had to change but i fixed them, but i did everythign i know how to these and nothing works.

Can someone help me get them working again?

This stock is supposed to load vehicle form a mysql db.

pawn Код:

stock LoadOwnedVehicles()
{
    new
        String[512],
        ModelL,
        CL[2],
        PriceL,
        OwnerL[MAX_PLAYER_NAME],
        Float:PosL[4],
        ID,
        PlateNumL[32];
        
    mysql_query("SELECT * FROM `ownedcars` WHERE `ID`");
    mysql_store_result();
    
    if(mysql_num_rows() > 0)
    {
        while(mysql_fetch_row(String))
        {
            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
            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;
}

This stock is supposed to load 3dTexts and Pickups from a mysql db.

pawn Код:

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

    if(mysql_num_rows() > 0)
    {
        while(mysql_fetch_row(Str))
        {
            sscanf(Str, "p<|>fff", X, Y, Z);
            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);
            STotal++;
        }
    }
    mysql_free_result();
    printf("** %i\t<->\tStores Loaded From\t<->\tMySQL\t\t   **", STotal);
    return 1;
}