Gangauto Problem

EnzO_SalvatorE · 15. Januar 2016

Jetzt habe ich grade das Problem das im MySQL Log nichts steht

Jeffry · 16. Januar 2016

Welche MySQL Version nutzt du?

EnzO_SalvatorE · 16. Januar 2016

Meinst du das hier ?

Code

CMySQLHandler::Query(SELECT * FROM `gangautos` WHERE `SlotID` = '0') - Successfully executed.


[12:31:54] >> mysql_store_result( Connection handle: 1 )


[12:31:54] CMySQLHandler::StoreResult() - Result was stored.


[12:31:54] >> mysql_num_rows( Connection handle: 1 )


[12:31:54] CMySQLHandler::NumRows() - Returned 0 row(s)


[12:31:54] >> mysql_free_result( Connection handle: 1 )


[12:31:54] CMySQLHandler::FreeResult() - Result was successfully free'd.


[12:31:54] >> mysql_query( Connection handle: 1 )


[12:31:54] CMySQLHandler::Query(SELECT * FROM `gangautos` WHERE `SlotID` = '1') - Successfully executed.


[12:31:54] >> mysql_store_result( Connection handle: 1 )


[12:31:54] CMySQLHandler::StoreResult() - Result was stored.


[12:31:54] >> mysql_num_rows( Connection handle: 1 )


[12:31:54] CMySQLHandler::NumRows() - Returned 1 row(s)


[12:31:54] >> mysql_fetch_row_format( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchRow() - Return: 1|-1|-1|-1|0|0|0|0|-1|-1|-1|50|1800


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("CarID") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("OwnerID") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("TypID") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("PosX") - 0


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("PosY") - 0


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("PosZ") - 0


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("Rotation") - 0


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("Farbe1") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("Farbe2") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("Status") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("Tank") - 50


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("ReSpawnTime") - 1800


[12:31:54] >> mysql_free_result( Connection handle: 1 )


[12:31:54] CMySQLHandler::FreeResult() - Result was successfully free'd.


[12:31:54] >> mysql_query( Connection handle: 1 )


[12:31:54] CMySQLHandler::Query(SELECT * FROM `gangautos` WHERE `SlotID` = '2') - Successfully executed.


[12:31:54] >> mysql_store_result( Connection handle: 1 )


[12:31:54] CMySQLHandler::StoreResult() - Result was stored.


[12:31:54] >> mysql_num_rows( Connection handle: 1 )


[12:31:54] CMySQLHandler::NumRows() - Returned 1 row(s)


[12:31:54] >> mysql_fetch_row_format( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchRow() - Return: 2|-1|-1|-1|0|0|0|0|-1|-1|-1|50|1800


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("CarID") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("OwnerID") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("TypID") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("PosX") - 0


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("PosY") - 0


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("PosZ") - 0


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("Rotation") - 0


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("Farbe1") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("Farbe2") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("Status") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("Tank") - 50


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("ReSpawnTime") - 1800


[12:31:54] >> mysql_free_result( Connection handle: 1 )


[12:31:54] CMySQLHandler::FreeResult() - Result was successfully free'd.


[12:31:54] >> mysql_query( Connection handle: 1 )


[12:31:54] CMySQLHandler::Query(SELECT * FROM `gangautos` WHERE `SlotID` = '3') - Successfully executed.


[12:31:54] >> mysql_store_result( Connection handle: 1 )


[12:31:54] CMySQLHandler::StoreResult() - Result was stored.


[12:31:54] >> mysql_num_rows( Connection handle: 1 )


[12:31:54] CMySQLHandler::NumRows() - Returned 1 row(s)


[12:31:54] >> mysql_fetch_row_format( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchRow() - Return: 3|-1|-1|-1|0|0|0|0|-1|-1|-1|50|1800


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("CarID") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("OwnerID") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("TypID") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("PosX") - 0


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("PosY") - 0


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("PosZ") - 0


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("Rotation") - 0


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("Farbe1") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("Farbe2") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("Status") - -1


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("Tank") - 50


[12:31:54] >> mysql_fetch_field_row( Connection handle: 1 )


[12:31:54] CMySQLHandler::FetchField("ReSpawnTime") - 1800


[12:31:54] >> mysql_free_result( Connection handle: 1 )


[12:31:54] CMySQLHandler::FreeResult() - Result was successfully free'd.


[12:31:54] >> mysql_query( Connection handle: 1 )

Alles anzeigen

Oder das hier?

Code

CMySQLHandler::Query(SELECT * FROM `gangautos` WHERE `SlotID` = '0') - Successfully executed.


[12:33:50] >> mysql_store_result( Connection handle: 1 )


[12:33:50] CMySQLHandler::StoreResult() - Result was stored.


[12:33:50] >> mysql_num_rows( Connection handle: 1 )


[12:33:50] CMySQLHandler::NumRows() - Returned 0 row(s)


[12:33:50] >> mysql_query( Connection handle: 1 )


[12:33:50] CMySQLHandler::Query(INSERT INTO `gangautos` (`SlotID`) VALUES ('0')) - Successfully executed.


[12:33:50] >> mysql_free_result( Connection handle: 1 )


[12:33:50] CMySQLHandler::FreeResult() - Result was successfully free'd.


[12:33:50] >> mysql_query( Connection handle: 1 )


[12:33:50] CMySQLHandler::Query(UPDATE `gangautos` SET `CarID`='-1', `OwnerID`='-1', `TypID`='-1', `PosX`='0.0', `PosY`='0.0', `PosZ`='0.0', `Rotation`='0.0', `Farbe1`='-1', `Farbe2`='-1', `Status`='-1', `Tank`='50', `ReSpawnTime`='1800' WHERE `SlotID`='0') - Successfully executed.


[12:33:50] >> mysql_query( Connection handle: 1 )


[12:33:50] CMySQLHandler::Query(SELECT * FROM `gangautos` WHERE `SlotID` = '1') - Successfully executed.


[12:33:50] >> mysql_store_result( Connection handle: 1 )


[12:33:50] CMySQLHandler::StoreResult() - Result was stored.


[12:33:50] >> mysql_num_rows( Connection handle: 1 )


[12:33:50] CMySQLHandler::NumRows() - Returned 1 row(s)


[12:33:50] >> mysql_free_result( Connection handle: 1 )


[12:33:50] CMySQLHandler::FreeResult() - Result was successfully free'd.


[12:33:50] >> mysql_query( Connection handle: 1 )


[12:33:50] CMySQLHandler::Query(UPDATE `gangautos` SET `CarID`='535', `OwnerID`='24', `TypID`='480', `PosX`='411.0', `PosY`='2442.0', `PosZ`='18.0', `Rotation`='90.0', `Farbe1`='6', `Farbe2`='6', `Status`='0', `Tank`='100', `ReSpawnTime`='1800' WHERE `SlotID`='1') - Successfully executed.


[12:33:50] >> mysql_query( Connection handle: 1 )


[12:33:50] CMySQLHandler::Query(SELECT * FROM `gangautos` WHERE `SlotID` = '2') - Successfully executed.


[12:33:50] >> mysql_store_result( Connection handle: 1 )


[12:33:50] CMySQLHandler::StoreResult() - Result was stored.


[12:33:50] >> mysql_num_rows( Connection handle: 1 )


[12:33:50] CMySQLHandler::NumRows() - Returned 1 row(s)


[12:33:50] >> mysql_free_result( Connection handle: 1 )


[12:33:50] CMySQLHandler::FreeResult() - Result was successfully free'd.


[12:33:50] >> mysql_query( Connection handle: 1 )


[12:33:50] CMySQLHandler::Query(UPDATE `gangautos` SET `CarID`='536', `OwnerID`='24', `TypID`='560', `PosX`='411.0', `PosY`='2442.0', `PosZ`='18.0', `Rotation`='90.0', `Farbe1`='6', `Farbe2`='6', `Status`='0', `Tank`='100', `ReSpawnTime`='1800' WHERE `SlotID`='2') - Successfully executed.


[12:33:50] >> mysql_query( Connection handle: 1 )


[12:33:50] CMySQLHandler::Query(SELECT * FROM `gangautos` WHERE `SlotID` = '3') - Successfully executed.


[12:33:50] >> mysql_store_result( Connection handle: 1 )


[12:33:50] CMySQLHandler::StoreResult() - Result was stored.


[12:33:50] >> mysql_num_rows( Connection handle: 1 )


[12:33:50] CMySQLHandler::NumRows() - Returned 1 row(s)


[12:33:50] >> mysql_free_result( Connection handle: 1 )


[12:33:50] CMySQLHandler::FreeResult() - Result was successfully free'd.


[12:33:50] >> mysql_query( Connection handle: 1 )

Alles anzeigen

Jeffry · 16. Januar 2016

Ja, das meinte ich.

Bei der Datenbankstruktur, mach da bei der Slot ID das "NOT NULL" weg, und erstelle die Tabelle dann nochmal neu. Dann sollte der Eintrag mit Slot ID 0 da sein.

EnzO_SalvatorE · 16. Januar 2016

Ok es hat geklappt
Vielen Dank Jeffry für deine Hilfe fettes Lob an dich

Gangauto Problem

breadfish.de 12. März 2022

Ähnliche Themen

[GER]WestCoast • Reallife[0.3.7]

MySQL Problem

Car explodiert 2x