Del ridos saugojimo

[John'K]

Taigi man nesaugo ridos.

enume rasiau

Float:Rida,

Mysql saugojimas/krovimas
 

format( query,sizeof( query ),"UPDATE `Masinos` SET Modelis = '%i', Rida = '%f', PosX = '%f', PosY = '%f', PosZ = '%f', Rot = '%f' WHERE Savininkas = '%s'",\
MID, mInfo[playerid][Rida], Float:Pos[0], Float:Pos[1], Float:Pos[2], Float:Pos[3], zVardas( playerid ));

Krovimas |

               V

mysql_fetch_field_row( tmp,"Rida"); mInfo[playerid][Rida]  = strval( tmp );

 

[Virsenas]

mInfo[playerid][Rida]  = strval( tmp );

Čia nelabai supratau kodėl tmp paverti į integer ir patalpinį jį tarp float.

[John'K]

mInfo[playerid][Rida]  = strval( tmp );

Čia nelabai supratau kodėl tmp paverti į integer ir patalpinį jį tarp float.

 

Sutvarkiau bet man jos net nesaugo...

[Virsenas]

Ar tikrinai mysql log'ą ? Ar nėra jokių klaidų saugojant ?

[John'K]

Ar tikrinai mysql log'ą ? Ar nėra jokių klaidų saugojant ?

Klaidu nemeta tuoj numesiu loga

 

[16:17:50] >> mysql_connect( )


[16:17:50] CMySQLHandler::CMySQLHandler() - constructor called.


[16:17:50] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "serveris" | Username: "root" ...


[16:17:50] CMySQLHandler::Connect() - Connection was successful.


[16:17:50] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.


[16:17:50] >> mysql_ping( Connection handle: 1 )


[16:17:50] CMySQLHandler::Ping() - Connection is still alive.


[16:18:22] >> mysql_query( Connection handle: 1 )


[16:18:22] CMySQLHandler::Query(SELECT * FROM `serveris` WHERE Vardas = 'John_Kuperis') - Successfully executed.


[16:18:22] >> mysql_store_result( Connection handle: 1 )


[16:18:22] CMySQLHandler::StoreResult() - Result was stored.


[16:18:22] >> mysql_num_rows( Connection handle: 1 )


[16:18:22] CMySQLHandler::NumRows() - Returned 0 row(s)


[16:18:22] >> mysql_free_result( Connection handle: 1 )


[16:18:22] CMySQLHandler::FreeResult() - Result was successfully free'd.


[16:18:26] >> mysql_real_escape_string( Connection handle: 1 )


[16:18:26] CMySQLHandler::EscapeString(labas); - Escaped 5 characters to labas.


[16:18:26] >> mysql_query( Connection handle: 1 )


[16:18:26] CMySQLHandler::Query(INSERT INTO `serveris` (Vardas,Slaptazodis) VALUES ('John_Kuperis','labas')) - Successfully executed.


[16:18:34] >> mysql_query( Connection handle: 1 )


[16:18:34] CMySQLHandler::Query(INSERT INTO `Masinos` (Savininkas,Modelis) VALUES ('John_Kuperis','411')) - Successfully executed.


[16:19:50] >> mysql_query( Connection handle: 1 )


[16:19:50] CMySQLHandler::Query(UPDATE `serveris` SET x = '-2045.210205', y = '-86.203376', z = '35.164062' WHERE vardas = 'John_Kuperis') - Successfully executed.


[16:19:50] >> mysql_query( Connection handle: 1 )


[16:19:50] CMySQLHandler::Query(UPDATE `serveris` SET Skin = '6', Pinigai = '0', Patirtis = '0', Admin = '0', Lytis = '1', Darbas = '0', Uniforma = '0', Uniformaa = '0', Banke = '0' WHERE vardas = 'John_Kuperis') - Successfully executed.


[16:19:50] >> mysql_query( Connection handle: 1 )


[16:19:50] CMySQLHandler::Query(UPDATE `serveris` SET Uzbanintas = '0', Bpriezastis = '', Bvardas = '', Tmasina = '1', Teises = '0', Direktorius = '0', Bsaskaita = '0', Saskaitoskodas = '0' WHERE vardas = 'John_Kuperis') - Successfully executed.


[16:19:50] >> mysql_query( Connection handle: 1 )


[16:19:51] CMySQLHandler::Query(UPDATE `Masinos` SET Modelis = '411', Rida = '0.000000', PosX = '-2047.334716', PosY = '-86.296707', PosZ = '34.891143', Rot = '176.501724' WHERE Savininkas = 'John_Kuperis') - Successfully executed.


[16:19:51] >> mysql_query( Connection handle: 1 )


[16:19:51] CMySQLHandler::Query(UPDATE `serveris` SET hp = '100.000000', armour = '0.000000' WHERE vardas = 'John_Kuperis') - Successfully executed.


[16:19:51] >> mysql_query( Connection handle: 1 )


[16:19:51] CMySQLHandler::Query(UPDATE `Masinos` SET Modelis = '411', Rida = '0.000000', PosX = '-2047.334716', PosY = '-86.296707', PosZ = '34.891143', Rot = '176.501724' WHERE Savininkas = 'John_Kuperis') - Successfully executed.

Redaguota Rugsėjo 24, 2014, nario John'K

[Virsenas]

Parodyk ridos didėjimo kodą.

[John'K]

new model = GetVehicleModel(vehicleid);

GetVehicleVelocity(vehicleid,speed_x,speed_y,speed_z);

final_speed = floatsqroot(((speed_x*speed_x)+(speed_y*speed_y))+(speed_z*speed_z))*216.666667; // 136.666667 = kmph  // 85.4166672= mph

final_speed_int = floatround(final_speed,floatround_round);

mInfo[vehicleid][Rida] += final_speed;

if(ShiftInfo[playerid] == true)

{

format(speed_string,156,"~n~~n~  ~y~Transportas: ~w~%s~n~  ~g~Greitis: ~w~%i KM/h~n~  ~r~Bukle: ~w~%s~n~  ~b~Degalai: ~w~%dL~n~  ~p~Pravaziuota: ~w~%.2fKm", VehicleNames[model-400], final_speed_int, masinosbukle, mInfo[vehicleid][gas], mInfo[vehicleid][Rida]/100000);

      TextDrawSetString(SPEEDOS[playerid], speed_string);

TextDrawShowForPlayer(playerid, spidometras[playerid]);

   TextDrawShowForPlayer(playerid, SPEEDOS[playerid]);

}else{

TextDrawHideForPlayer(playerid, spidometras[playerid]);

   TextDrawHideForPlayer(playerid, SPEEDOS[playerid]);

}

[Virsenas]

O tarp spidometro rodo gerai, kad didėja rida, taip ?

[John'K]

O tarp spidometro rodo gerai, kad didėja rida, taip ?

Taip rodo gerai islipi ylipi vistiek gerai rodo nedingsta tik po rr dingsta

[Virsenas]

Dar galim pabandyt pasižiūrėt į mysql lentutės struktūrą.

[bebras]

mInfo[playerid][Rida] - Krovimas

mInfo[vehicleid][Rida]  - Ridos kėlimas

 

Nesupratau. O tu?

[Expert*]

Skripterei jūs...

mInfo[playerid][Rida]

mInfo[vehicleid][Rida]

mInfo[playerid][Rida] - Krovimas

mInfo[vehicleid][Rida] - Ridos kėlimas

Nesupratau. O tu?

Aš irgi nesuprantu, tik kam tu sekunde pirmiau už mane parašei ?

Redaguota Rugsėjo 24, 2014, nario Justas Š.

[John'K]

Skripterei jūs...

mInfo[playerid][Rida]

mInfo[vehicleid][Rida]

Aš irgi nesuprantu, tik kam tu sekunde pirmiau už mane parašei ?

 

Dekui, niekas ir nesako kad as pro tai tik klausiu....

[Expert*]

Dekui, niekas ir nesako kad as pro tai tik klausiu....

Niekas ir nesako, kad tu turėtum buti pro.