Peršokti į turinį
  • ŽAIDIMAI
  • , ŽAIDIMAI
  • ŽAIDIMAI

Nori pirkti ar parduoti SA:MP turtą? SPAUSK ČIA!

SA-MP MYSQL Užkrovimas

Matas Luc

Parašė Matas Luc
forume SA:MP Klausimai, pagalba ir prašymai

 Pasidalinti

Ši tema yra neaktyvi. Paskutinis pranešimas šioje temoje buvo prieš 4140 dienas (-ų). Patariame sukurti naują temą, o ne rašyti naują pranešimą.

Už neaktyvių temų prikėlimą galite sulaukti įspėjimo ir pranešimo pašalinimo!

Recommended Posts

Matas Luc Užkietėjęs dalyvis (-ė)

Matas Luc

(redaguota)

Sveiki, kažkas mano užkrovime blogai yra, nes ir mašinos spalvą ir kordinates išsaugo gerai, bet kaip jas užkrauna serveryje, jos tampa 0, kas gali būt blogai

        mysql_fetch_field_row(Query, "Model");         Modelis = strval(Query);
        mysql_fetch_field_row(Query, "Pos_X");         vPos[0] = floatstr(Query);
        mysql_fetch_field_row(Query, "Pos_Y");         vPos[1] = floatstr(Query);
        mysql_fetch_field_row(Query, "Pos_Z");         vPos[2] = floatstr(Query);
        mysql_fetch_field_row(Query, "Pos_A");         vPos[3] = floatstr(Query);
        mysql_fetch_field_row(Query, "Color1");        Color[0] = strval(Query);
        mysql_fetch_field_row(Query, "Color2");        Color[1] = strval(Query);
        mysql_fetch_field_row(Query, "Health");        Health = floatstr(Query);

        new vehicleid = CreateVehicle(Modelis, vPos[0], vPos[1], vPos[2] + 3, vPos[3], Color[0], Color[1], -1);
        SetVehicleHealth(vehicleid, Health);

Duomenų bazėj atrodo taip tos eilutės

42d881f0ace28f4b2f08f07efefb9d55306.png

Redaguota , nario JWhite

sanFrisco.lt

Matas Luc Užkietėjęs dalyvis (-ė)

Matas Luc

  • Autorius

Mysql debugas?

[18:04:40] CMySQLHandler::Query(SELECT * FROM `vehicles` WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:40] >> mysql_store_result( Connection handle: 1 )
[18:04:40] CMySQLHandler::StoreResult() - Result was stored.
[18:04:40] >> mysql_num_rows( Connection handle: 1 )
[18:04:40] CMySQLHandler::NumRows() - Returned 1 row(s)
[18:04:40] >> mysql_fetch_row_format( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchRow() - Return: Jeremy_White|0|31|402|0|0|-86.8723|163.673|2.96479|79.3574|1000|Nera|1210890|0|0|0|0|0|0|0|0|0|0|0|0|0|-1|0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Model") - 402
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Pos_X") - -86.8723
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Pos_Y") - 163.673
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Pos_Z") - 2.96479
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Pos_A") - 79.3574
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Color1") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Color2") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Health") - 1000
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Rida") - 1210890
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Insurance") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Fuel") - 31
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Paintjob") - -1
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Tune0") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Tune1") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Tune2") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Tune3") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Tune4") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Tune5") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Tune6") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Tune7") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Tune8") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Tune9") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Tune10") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Tune11") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Tune12") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("Locked") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("NumberPlate") - Nera
[18:04:40] >> mysql_free_result( Connection handle: 1 )
[18:04:40] CMySQLHandler::FreeResult() - Result was successfully free'd.
[18:04:40] >> mysql_query( Connection handle: 1 )
[18:04:40] CMySQLHandler::Query(SELECT * FROM `dzinutes` WHERE `KokioDarboZinute` = 'Taxi') - Successfully executed.
[18:04:40] >> mysql_store_result( Connection handle: 1 )
[18:04:40] CMySQLHandler::StoreResult() - Result was stored.
[18:04:40] >> mysql_retrieve_row( Connection handle: 1 )
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("ArIjungtaZinute") - 0
[18:04:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:04:40] CMySQLHandler::FetchField("ZinutesTekstas") - TS.SFVG.LT
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(SELECT * FROM `vehicles` WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_store_result( Connection handle: 1 )
[18:04:45] CMySQLHandler::StoreResult() - Result was stored.
[18:04:45] >> mysql_num_rows( Connection handle: 1 )
[18:04:45] CMySQLHandler::NumRows() - Returned 1 row(s)
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Transportas` = 'Jeremy_White' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Model` = '402' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Pos_X` = '0.000000' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Pos_Y` = '0.000000' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Pos_Z` = '0.000000' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Pos_A` = '79.357398' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Health` = '1000.000000' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Rida` = '1210890.000000' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Fuel` = '31' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Color1` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Color2` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Paintjob` = '-1' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Insurance` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Tune0` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Tune1` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Tune2` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Tune3` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Tune4` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Tune5` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Tune6` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Tune7` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Tune8` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Tune9` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Tune10` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Tune11` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Tune12` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Locked` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_query( Connection handle: 1 )
[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `NumberPlate` = 'Nera' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.
[18:04:45] >> mysql_free_result( Connection handle: 1 )
[18:04:45] CMySQLHandler::FreeResult() - Result was successfully free'd.
[18:04:45] >> mysql_query( Connection handle: 1 )

sanFrisco.lt

Tomas Anderbosas (-ė)

Tomas

[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Color1` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.

[18:04:45] >> mysql_query( Connection handle: 1 )

[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Color2` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.

Reiškia, tu jos neišsauga. Parodyk string, kurioje formatuoji saugojimą būtent spalvos.

 

Better known as f0cus

Matas Luc Užkietėjęs dalyvis (-ė)

Matas Luc

  • Autorius

[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Color1` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.

[18:04:45] >> mysql_query( Connection handle: 1 )

[18:04:45] CMySQLHandler::Query(UPDATE `vehicles` SET `Color2` = '0' WHERE `Transportas` = 'Jeremy_White') - Successfully executed.

Reiškia, tu jos neišsauga. Parodyk string, kurioje formatuoji saugojimą būtent spalvos.

		format(Query, sizeof(Query), "UPDATE `vehicles` SET `Pos_X` = '%f' WHERE `Transportas` = '%s'", vPos[0], GetPlayerNameEx(playerid));
		mysql_query(Query);

		format(Query, sizeof(Query), "UPDATE `vehicles` SET `Pos_Y` = '%f' WHERE `Transportas` = '%s'", vPos[1], GetPlayerNameEx(playerid));
		mysql_query(Query);

		format(Query, sizeof(Query), "UPDATE `vehicles` SET `Pos_Z` = '%f' WHERE `Transportas` = '%s'", vPos[2], GetPlayerNameEx(playerid));
		mysql_query(Query);

		format(Query, sizeof(Query), "UPDATE `vehicles` SET `Pos_A` = '%f' WHERE `Transportas` = '%s'", vPos[3], GetPlayerNameEx(playerid));
		mysql_query(Query);

		format(Query, sizeof(Query), "UPDATE `vehicles` SET `Health` = '%f' WHERE `Transportas` = '%s'", vPos[4], GetPlayerNameEx(playerid));
		mysql_query(Query);

		format(Query, sizeof(Query), "UPDATE `vehicles` SET `Rida` = '%f' WHERE `Transportas` = '%s'", vehicleDB[vehicleid][Rida], GetPlayerNameEx(playerid));
		mysql_query(Query);

		format(Query, sizeof(Query), "UPDATE `vehicles` SET `Fuel` = '%d' WHERE `Transportas` = '%s'", vehicleDB[vehicleid][gas], GetPlayerNameEx(playerid));
		mysql_query(Query);

		format(Query, sizeof(Query), "UPDATE `vehicles` SET `Color1` = '%d' WHERE `Transportas` = '%s'", vehicleDB[vehicleid][vColor][0], GetPlayerNameEx(playerid));
		mysql_query(Query);

		format(Query, sizeof(Query), "UPDATE `vehicles` SET `Color2` = '%d' WHERE `Transportas` = '%s'", vehicleDB[vehicleid][vColor][1], GetPlayerNameEx(playerid));
		mysql_query(Query);

sanFrisco.lt

Ši tema yra neaktyvi. Paskutinis pranešimas šioje temoje buvo prieš 4140 dienas (-ų). Patariame sukurti naują temą, o ne rašyti naują pranešimą.

Už neaktyvių temų prikėlimą galite sulaukti įspėjimo ir pranešimo pašalinimo!

Prisijungti prie diskusijos

Palikti atsakymą galite iš karto, o užsiregistruoti vėliau. Jeigu jau turite paskyrą mūsų forume, Prisijunkite.

Svečias
Atsakyti šioje temoje...

×   Įklijuotas tekstas turi teksto formatavimą.   Pašalinti teksto formatavimą

  Galimi tik 75 veidukai.

×   Nuoroda buvo automatiškai įterpta.   Įterpti nuorodą paprastai

×   Jūsų ankstesnis pranešimas buvo atkurtas.   Išvalyti redaktorių

×   Jūs negalite įkelti nuotraukas tiesiogiai.Įkelkite arba įdėkite nuotraukas iš URL.

×
 Pasidalinti
Eiti į

  • Šiame puslapyje naršo:   0 nariai

    • Nėra registruotų narių peržiūrinčių šį forumą.

Skelbimai


×
×
  • Sukurti naują...