Problem getting variable from MySQL, again
#3

Quote:
Originally Posted by Jefff
Посмотреть сообщение
pawn Код:
forward CargarVeh(limit);
public CargarVeh(limit)
{
    new h, rows, data[50], team;
    cache_get_row_count(rows);
    for(new i = 0; i < rows; i++)
    {
        if(h >= limit)
        {
            print("Limite de vehнculos excedido!");
            break;
        }
        cache_get_value_name(i, "idTeam", data); object[h][idTeam] = strval(data);
        cache_get_value_name(i, "modelo", data); object[h][modelo] = strval(data);
        cache_get_value_name(i, "posx", data); object[h][posx] = floatstr(data);
        cache_get_value_name(i, "posy", data); object[h][posy] = floatstr(data);
        cache_get_value_name(i, "posz", data); object[h][posz] = floatstr(data);
        cache_get_value_name(i, "posrot", data); object[h][posrot] = floatstr(data);
        cache_get_value_name(i, "color1", data); object[h][color1] = strval(data);
        cache_get_value_name(i, "color2", data); object[h][color2] = strval(data);

        object[h][idTeam] = AddStaticVehicle(object[h][modelo], object[h][posx], object[h][posy], object[h][posz], object[h][posrot], object[h][color1], object[h][color2]);
        printf("Vehiculo con idTeam %i, pos x: %i pos y: %i pos z: %i creado", object[h][idTeam], object[h][posx], object[h][posy], object[h][posz]);
        h++;
    }
    printf("Vehiculos cargados: %d",h);
    return 1;
}
and change %i to %f in pos
Hi again!, with your code the result is same

Final code with integers changed to floats
pawn Код:
forward CargarVeh(limit);
public CargarVeh(limit)
{
    new h, rows, data[50];
    cache_get_row_count(rows);
    for(new i = 0; i < rows; i++)
    {
        if(h >= limit)
        {
            print("Limite de vehiculos excedido!");
            break;
        }
        cache_get_value_name(i, "idTeam", data); object[h][idTeam] = strval(data);
        cache_get_value_name(i, "modelo", data); object[h][modelo] = strval(data);
        cache_get_value_name(i, "posx", data); object[h][posx] = floatstr(data);
        cache_get_value_name(i, "posy", data); object[h][posy] = floatstr(data);
        cache_get_value_name(i, "posz", data); object[h][posz] = floatstr(data);
        cache_get_value_name(i, "posrot", data); object[h][posrot] = floatstr(data);
        cache_get_value_name(i, "color1", data); object[h][color1] = strval(data);
        cache_get_value_name(i, "color2", data); object[h][color2] = strval(data);

        object[h][idTeam] = AddStaticVehicle(object[h][modelo], object[h][posx], object[h][posy], object[h][posz], object[h][posrot], object[h][color1], object[h][color2]);
        printf("Vehiculo con idTeam %i, pos x: %f pos y: %f pos z: %f creado", object[h][idTeam], object[h][posx], object[h][posy], object[h][posz]);
        h++;
    }
    printf("Vehiculos cargados: %d",h);
    return 1;
}
Output console:
Код HTML:
Vehiculo con idTeam 1, pos x: 1536.407226 pos y: -1674.460693 pos z: 13.382813 creado
Vehiculo con idTeam 2, pos x: 1531.569946 pos y: -1671.101074 pos z: 13.382813 creado
Vehiculo con idTeam 3, pos x: 1531.474243 pos y: -1689.005126 pos z: 13.382813 creado
Vehiculos cargados: 3
New structure for table vehicles:
Код HTML:
SELECT * FROM `vehiculos`


idTeam	modelo	posx	posy	posz	posrot	color1	color2	
1	522	1536.407227	-1674.460693	13.382813	0	1	1	
4	522	1531.569946	-1671.101074	13.382813	0	1	1	
2	522	1531.474243	-1689.005127	13.382813	0	1	1	
Thanks you!
Reply


Messages In This Thread
Problem getting variable from MySQL, again - by dabv_astur - 18.11.2018, 22:36
Re: Problem getting variable from MySQL, again - by Jefff - 18.11.2018, 23:26
Re: Problem getting variable from MySQL, again - by dabv_astur - 19.11.2018, 01:52
Re: Problem getting variable from MySQL, again - by Jefff - 19.11.2018, 02:10
Re: Problem getting variable from MySQL, again - by dabv_astur - 19.11.2018, 02:24
Re: Problem getting variable from MySQL, again - by Rolux - 19.11.2018, 04:12
Re: Problem getting variable from MySQL, again - by dabv_astur - 19.11.2018, 05:54

Forum Jump:


Users browsing this thread: 1 Guest(s)