'Zuletzt Online' Speichern

Dominik · 6. März 2014

Jetzt wo dus sagst, nein Aber es ging vorher noch

H4rd_B4se · 6. März 2014

Dann schau mal in die Serverlog. Schalte mysql_debug(1); ein und schau danach in die Debuglog.
Da müsste dann der Fehler stehen.

Dominik · 6. März 2014

SQL

[14:24:37] >> mysql_store_result( Connection handle: 1 )


[14:24:37] CMySQLHandler::StoreResult() - Result was stored.


[14:24:37] >> mysql_fetch_row_format( Connection handle: 1 )


[14:24:37] CMySQLHandler::FetchRow() - Return: creative1A


[14:24:37] >> mysql_free_result( Connection handle: 1 )


[14:24:37] CMySQLHandler::FreeResult() - Result was successfully free'd.


[14:24:37] >> mysql_query( Connection handle: 1 )


[14:24:37] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Name`='Dominik') - Successfully executed.


[14:24:37] >> mysql_store_result( Connection handle: 1 )


[14:24:37] CMySQLHandler::StoreResult() - Result was stored.


[14:24:37] >> mysql_num_rows( Connection handle: 1 )


[14:24:37] CMySQLHandler::NumRows() - Returned 1 row(s)


[14:24:37] >> mysql_retrieve_row( Connection handle: 1 )


[14:24:37] >> mysql_fetch_field_row( Connection handle: 1 )


[14:24:37] CMySQLHandler::FetchField("pGeld") - 3500


[14:24:37] >> mysql_fetch_field_row( Connection handle: 1 )


[14:24:37] CMySQLHandler::FetchField("pTeam") - 5


[14:24:37] >> mysql_fetch_field_row( Connection handle: 1 )


[14:24:37] CMySQLHandler::FetchField("pBan") - 0


[14:24:37] >> mysql_fetch_field_row( Connection handle: 1 )


[14:24:37] CMySQLHandler::FetchField("pWarn") - 0


[14:24:37] >> mysql_fetch_field_row( Connection handle: 1 )


[14:24:37] CMySQLHandler::FetchField("pGeschlecht") - 1


[14:24:37] >> mysql_fetch_field_row( Connection handle: 1 )


[14:24:37] CMySQLHandler::FetchField("pTutorial") - 1


[14:24:37] >> mysql_fetch_field_row( Connection handle: 1 )


[14:24:37] CMySQLHandler::FetchField("pExp") - 0


[14:24:37] >> mysql_fetch_field_row( Connection handle: 1 )


[14:24:37] CMySQLHandler::FetchField("pTode") - 0


[14:24:37] >> mysql_fetch_field_row( Connection handle: 1 )


[14:24:37] CMySQLHandler::FetchField("pKills") - 0


[14:24:37] >> mysql_fetch_field_row( Connection handle: 1 )


[14:24:37] CMySQLHandler::FetchField("Datum") - 2014.03.6


[14:24:37] >> mysql_fetch_field_row( Connection handle: 1 )


[14:24:37] CMySQLHandler::FetchField("Zeit") - 13:49:46


[14:24:37] >> mysql_fetch_field_row( Connection handle: 1 )


[14:24:37] CMySQLHandler::FetchField("pLastOnlineZeit") - NULL


[14:24:37] >> mysql_fetch_field_row( Connection handle: 1 )


[14:24:37] CMySQLHandler::FetchField("pLastOnlineDatum") - NULL


[14:24:37] >> mysql_fetch_field_row( Connection handle: 1 )


[14:24:37] CMySQLHandler::FetchField("pEmail") - Dominik@Fabulous-Life.de

Alles anzeigen

H4rd_B4se · 6. März 2014

Das ist das falsche, das ist vom Laden

Dominik · 6. März 2014

SQL

[14:35:24]  


[14:35:24] ---------------------------


[14:35:24] MySQL Debugging activated (03/06/14)


[14:35:24] ---------------------------


[14:35:24]  


[14:35:56] >> mysql_connect( )


[14:35:57] CMySQLHandler::Connect() - Connection was successful.


[14:35:57] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.


[14:35:57] >> mysql_ping( Connection handle: 1 )


[14:35:57] CMySQLHandler::Ping() - Connection is still alive.


[14:36:01] >> mysql_real_escape_string( Connection handle: 1 )


[14:36:01] CMySQLHandler::EscapeString(Dominik); - Escaped 7 characters to Dominik.


[14:36:01] >> mysql_query( Connection handle: 1 )


[14:36:01] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Name` = 'Dominik') - Successfully executed.


[14:36:01] >> mysql_store_result( Connection handle: 1 )


[14:36:01] CMySQLHandler::StoreResult() - Result was stored.


[14:36:01] >> mysql_num_rows( Connection handle: 1 )


[14:36:01] CMySQLHandler::NumRows() - Returned 1 row(s)


[14:36:01] >> mysql_free_result( Connection handle: 1 )


[14:36:01] CMySQLHandler::FreeResult() - Result was successfully free'd.


[14:36:01] >> mysql_real_escape_string( Connection handle: 1 )


[14:36:01] CMySQLHandler::EscapeString(Dominik); - Escaped 7 characters to Dominik.


[14:36:01] >> mysql_query( Connection handle: 1 )


[14:36:01] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Name` = 'Dominik') - Successfully executed.


[14:36:01] >> mysql_store_result( Connection handle: 1 )


[14:36:01] CMySQLHandler::StoreResult() - Result was stored.


[14:36:01] >> mysql_num_rows( Connection handle: 1 )


[14:36:01] CMySQLHandler::NumRows() - Returned 1 row(s)


[14:36:01] >> mysql_free_result( Connection handle: 1 )


[14:36:01] CMySQLHandler::FreeResult() - Result was successfully free'd.


[14:36:04] >> mysql_real_escape_string( Connection handle: 1 )


[14:36:04] CMySQLHandler::EscapeString(Dominik); - Escaped 7 characters to Dominik.


[14:36:04] >> mysql_query( Connection handle: 1 )


[14:36:04] CMySQLHandler::Query(SELECT `passwort` FROM `accounts` WHERE `Name` = 'Dominik') - Successfully executed.


[14:36:04] >> mysql_store_result( Connection handle: 1 )


[14:36:04] CMySQLHandler::StoreResult() - Result was stored.


[14:36:04] >> mysql_fetch_row_format( Connection handle: 1 )


[14:36:04] CMySQLHandler::FetchRow() - Return: creative1A


[14:36:04] >> mysql_free_result( Connection handle: 1 )


[14:36:04] CMySQLHandler::FreeResult() - Result was successfully free'd.


[14:36:04] >> mysql_query( Connection handle: 1 )


[14:36:04] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Name`='Dominik') - Successfully executed.


[14:36:04] >> mysql_store_result( Connection handle: 1 )


[14:36:04] CMySQLHandler::StoreResult() - Result was stored.


[14:36:04] >> mysql_num_rows( Connection handle: 1 )


[14:36:04] CMySQLHandler::NumRows() - Returned 1 row(s)


[14:36:04] >> mysql_retrieve_row( Connection handle: 1 )


[14:36:04] >> mysql_fetch_field_row( Connection handle: 1 )


[14:36:04] CMySQLHandler::FetchField("pGeld") - 3500


[14:36:04] >> mysql_fetch_field_row( Connection handle: 1 )


[14:36:04] CMySQLHandler::FetchField("pTeam") - 5


[14:36:04] >> mysql_fetch_field_row( Connection handle: 1 )


[14:36:04] CMySQLHandler::FetchField("pBan") - 0


[14:36:04] >> mysql_fetch_field_row( Connection handle: 1 )


[14:36:04] CMySQLHandler::FetchField("pWarn") - 0


[14:36:04] >> mysql_fetch_field_row( Connection handle: 1 )


[14:36:04] CMySQLHandler::FetchField("pGeschlecht") - 1


[14:36:04] >> mysql_fetch_field_row( Connection handle: 1 )


[14:36:04] CMySQLHandler::FetchField("pTutorial") - 1


[14:36:04] >> mysql_fetch_field_row( Connection handle: 1 )


[14:36:04] CMySQLHandler::FetchField("pExp") - 0


[14:36:04] >> mysql_fetch_field_row( Connection handle: 1 )


[14:36:04] CMySQLHandler::FetchField("pTode") - 0


[14:36:04] >> mysql_fetch_field_row( Connection handle: 1 )


[14:36:04] CMySQLHandler::FetchField("pKills") - 0


[14:36:04] >> mysql_fetch_field_row( Connection handle: 1 )


[14:36:04] CMySQLHandler::FetchField("Datum") - 2014.03.6


[14:36:04] >> mysql_fetch_field_row( Connection handle: 1 )


[14:36:04] CMySQLHandler::FetchField("Zeit") - 13:49:46


[14:36:04] >> mysql_fetch_field_row( Connection handle: 1 )


[14:36:04] CMySQLHandler::FetchField("pLastOnlineZeit") - NULL


[14:36:04] >> mysql_fetch_field_row( Connection handle: 1 )


[14:36:04] CMySQLHandler::FetchField("pLastOnlineDatum") - NULL


[14:36:04] >> mysql_fetch_field_row( Connection handle: 1 )


[14:36:04] CMySQLHandler::FetchField("pEmail") - Dominik@Fabulous-Life.de

Alles anzeigen

mehr ist das nicht

H4rd_B4se · 6. März 2014

Und die normale Serverlog?

Dominik · 6. März 2014

SQL

Loaded log file: "server_log.txt".----------SA-MP Dedicated Server----------------------v0.3z, (C)2005-2014 SA-MP Team[14:35:23] filterscripts = ""  (string)[14:35:23] [14:35:23] Server Plugins[14:35:23] --------------[14:35:23]  Loading plugin: mysql[14:35:23]   > MySQL plugin R5 successfully loaded.[14:35:23]   Loaded.[14:35:23]  Loading plugin: sscanf[14:35:23] [14:35:23]  ===============================[14:35:23]       sscanf plugin loaded.     [14:35:23]    (c) 2009 Alex "Y_Less" Cole[14:35:23]    0.3d-R2 500 Players "dnee"[14:35:23]  ===============================[14:35:23]   Loaded.[14:35:23]  Loaded 2 plugins.[14:35:23] [14:35:23] Filterscripts[14:35:23] ---------------[14:35:23]   Loaded 0 filterscripts.[14:35:23] <-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt![14:35:24] ----------------------------------[14:35:24]  Fabulous Life 0.1a[14:35:24] ----------------------------------[14:35:24] Number of vehicle models: 0[14:35:56] Incoming connection: 127.0.0.1:49262[14:35:56] [join] Dominik has joined the server (0:127.0.0.1)[14:36:07] [part] Dominik has left the server (0:1)

Cydia · 6. März 2014

print aus was Query dir ausgibt, wenn du dies noch nicht gemacht hast.

breadfish.de 12. März 2022