Problema su MYSQL

Matas Luc · Rugsėjo 21, 2016

Sveiki, susidūriau su problema, kad nesaugoja mašinos spalvos, visa kita išsaugoja, o per localhost/phpmyadmin, neeina nieko pakeist, kas čia gali būt blogai?

bebras · Rugsėjo 21, 2016

Tai reiškia būtent tai kas ten ir parašyta. Nėra jokio unikalaus stulpelio. pMA veikia tom pačiom užklausom kurias rašai Pawn kode. O be unikalaus stulpelio jis negali suformuluoti užklausos "WHERE" dalies. Tiesiog jį sukurk...

Arba įvykdyk šitą užklausą:

ALTER TABLE vehicles ADD COLUMN id INT AUTO_INCREMENT NOT NULL;

Matas Luc · Rugsėjo 21, 2016

Tai reiškia būtent tai kas ten ir parašyta. Nėra jokio unikalaus stulpelio. pMA veikia tom pačiom užklausom kurias rašai Pawn kode. O be unikalaus stulpelio jis negali suformuluoti užklausos "WHERE" dalies. Tiesiog jį sukurk...

Arba įvykdyk šitą užklausą:
ALTER TABLE vehicles ADD COLUMN id INT AUTO_INCREMENT NOT NULL;

Ačiū gerasis ir protingasis dėde, turiu dar vieną klausimą, mano mašinų spalvas išsaugoja(bent jau taip viską rodo, o kaip užkrauna jas, jos tampa juodos, jeigu perdažau į raudoną pvz, tai per mysql rodo 3id, bet jei vėl prisijungiu vėl rodo juodą mašiną ir vėl pasidaro 0 spalvos id, kas gali būt?

        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);

bebras · Rugsėjo 21, 2016

Mysql log?

Matas Luc · Rugsėjo 21, 2016

Mysql log?

[20:28:27] CMySQLHandler::Query(SELECT * FROM `vehicles` WHERE `Transportas` = 'Jeremy_White') - Successfully executed.

[20:28:27] >> mysql_store_result( Connection handle: 1 )

[20:28:27] CMySQLHandler::StoreResult() - Result was stored.

[20:28:27] >> mysql_num_rows( Connection handle: 1 )

[20:28:27] CMySQLHandler::NumRows() - Returned 1 row(s)

[20:28:28] >> mysql_fetch_row_format( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchRow() - Return: 1|Jeremy_White|559|-1784.74|-1719.88|33.0337|130.013|999.864|10.1096|33|3|3|-1|0|0|0|0|0|0|0|0|0|0|0|0|0|1|Nera

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Model") - 559

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Pos_X") - -1784.74

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Pos_Y") - -1719.88

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Pos_Z") - 33.0337

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Pos_A") - 130.013

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Color1") - 3

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Color2") - 3

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Health") - 999.864

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Pos_X") - -1784.74

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Pos_Y") - -1719.88

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Pos_Z") - 33.0337

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Pos_A") - 130.013

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Rida") - 10.1096

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Fuel") - 33

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Paintjob") - -1

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Tune0") - 0

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Tune1") - 0

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Tune2") - 0

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Tune3") - 0

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Tune4") - 0

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Tune5") - 0

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:28] CMySQLHandler::FetchField("Tune6") - 0

[20:28:28] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Tune7") - 0

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Tune8") - 0

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Tune9") - 0

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Tune10") - 0

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Tune11") - 0

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Tune12") - 0

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Locked") - 1

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("NumberPlate") - Nera

[20:28:29] >> mysql_free_result( Connection handle: 1 )

[20:28:29] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:28:29] >> mysql_query( Connection handle: 1 )

[20:28:29] CMySQLHandler::Query(SELECT * FROM `vehicles` WHERE `Transportas` = 'Jeremy_White2') - Successfully executed.

[20:28:29] >> mysql_store_result( Connection handle: 1 )

[20:28:29] CMySQLHandler::StoreResult() - Result was stored.

[20:28:29] >> mysql_num_rows( Connection handle: 1 )

[20:28:29] CMySQLHandler::NumRows() - Returned 1 row(s)

[20:28:29] >> mysql_fetch_row_format( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchRow() - Return: 2|Jeremy_White2|445|-1793.95|-1725.97|33.1834|0|1000|0|40|1|1|-1|0|0|0|0|0|0|0|0|0|0|0|0|0|1|Nera

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Model") - 445

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Pos_X") - -1793.95

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Pos_Y") - -1725.97

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Pos_Z") - 33.1834

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Pos_A") - 0

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Color1") - 1

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Color2") - 1

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Health") - 1000

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Pos_X") - -1793.95

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Pos_Y") - -1725.97

[20:28:29] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:29] CMySQLHandler::FetchField("Pos_Z") - 33.1834

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Pos_A") - 0

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Rida") - 0

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Fuel") - 40

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Paintjob") - -1

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Tune0") - 0

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Tune1") - 0

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Tune2") - 0

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Tune3") - 0

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Tune4") - 0

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Tune5") - 0

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Tune6") - 0

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Tune7") - 0

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Tune8") - 0

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Tune9") - 0

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Tune10") - 0

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Tune11") - 0

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Tune12") - 0

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("Locked") - 1

[20:28:30] >> mysql_fetch_field_row( Connection handle: 1 )

[20:28:30] CMySQLHandler::FetchField("NumberPlate") - Nera

bebras · Rugsėjo 21, 2016

Prieš kuriant transporto priemonę išprintink "Color[]" vertes.

Matas Luc · Rugsėjo 24, 2016

Prieš kuriant transporto priemonę išprintink "Color[]" vertes.

loge sukuriant mašiną rodo normalią spalvą, o paskui žaidime vistiek juoda būna...

VISKAS SUSITVARKIAU GALIMA RAKINT TEMĄ

Redaguota Rugsėjo 24, 2016, nario JWhite

Prisijungti

Problema su MYSQL

Recommended Posts

Matas Luc

bebras

Matas Luc

bebras

Matas Luc

bebras

Matas Luc

Šiame puslapyje naršo: 0 nariai

Skelbimai

Naujausios temos

Naujausi būsenos atnaujinimai

Nustatymai

Teksto formatavimas

Nario nuotrauka

Member

Nustatymai

Populiariausi nariai

📝 Referatai, konspektai, kursiniai ir kt. rašto darbai ✏️

📝 Referatai, konspektai, kursiniai ir kt. rašto darbai ✏️

📝 Referatai, konspektai, kursiniai ir kt. rašto darbai ✏️

Naujienos

Bendruomenė

Prisijungti

Problema su MYSQL

Recommended Posts

Šiame puslapyje naršo: 0 nariai

Skelbimai

Naujausios temos

Naujausi būsenos atnaujinimai Nustatymai Teksto formatavimas Nario nuotrauka Member Išsaugoti

Nustatymai

Populiariausi nariai

Naujausi būsenos atnaujinimai

Nustatymai

Teksto formatavimas

Nario nuotrauka

Member