MySQL speichert Ziffern?

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link

    Schönen Abend breadfish,
    Ich hab das problem, dass wenn ich etwas in die Datenbank speichern möchte zb. die E-Mail, dass es so aussieht in der Datenbank ÿ7.0.0.1. Das ist aber nur, wenn ich mysql_real_escape_string benutze.


    mysql_real_escape_string(inputtext, inputtext);
    format(sInfo[playerid][sEmail], 36, "%s", inputtext);


    Wenn ich die IP-Adresse speichern möchte, sieht es in der Datenbank so aus 49.


    GetPlayerIp(playerid, sInfo[playerid][sAdresse], 16);


    Und ich benutze die Spalte Adminlevel garnicht, aber er trägt trozdem etwas ein?


    stock SavePlayer(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    if(GetPVarInt(playerid, "Eingeloggt") == 1)
    {
    new query[200];
    format(query, sizeof(query), "UPDATE accounts SET Adresse = %i, Email = '%s', Adminlevel = %d WHERE Spielername = '%s'",
    sInfo[playerid][sAdresse],
    sInfo[playerid][sEmail],
    sInfo[playerid][sAdminlevel],
    sName(playerid));
    mysql_query(query);
    }
    }
    return 1;
    }



    Mit freundlichen Grüßen
    Grapefruit

    Auf Anfrage in PN:


    Schalte doch mal den MySQL Debug an (mysql_log oder mysql_debug, je nach Plugin) und setze es auch LOG_ALL bzw. 1, je nach Plugin. Dann poste bitte was im Server Log geprintet wird wenn du das Query ausführst.

    Gut.


    Ja du musst den Spieler auch mindestens einmal speichern, sodass das Query an die Datenbank geschickt wird, sonst wird die natürlich nichts angezeigt.
    Möglicherweise steht es auch in einer extra Log Datei, mysql_log oder so, so ist es bei mir. Kommt auf das Plugin an.

  • do.de - Domain-Offensive - Domains für alle und zu super Preisen

    So hab mal SavePlayer ingame ausgeführt, nun wird mir was in die log geschrieben.


    [23:47:50] [23:47:50] ---------------------------[23:47:50] MySQL Debugging activated (08/09/14)[23:47:50] ---------------------------[23:47:50] [23:48:50] >> mysql_real_escape_string( Connection handle: 1 )[23:48:50] CMySQLHandler::EscapeString(GrapeGrape); - Escaped 10 characters to GrapeGrape.[23:48:50] >> mysql_query( Connection handle: 1 )[23:48:50] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Spielername` = 'GrapeGrape') - Successfully executed.[23:48:50] >> mysql_store_result( Connection handle: 1 )[23:48:50] CMySQLHandler::StoreResult() - Result was stored.[23:48:50] >> mysql_num_rows( Connection handle: 1 )[23:48:50] CMySQLHandler::NumRows() - Returned 0 row(s)[23:48:50] >> mysql_free_result( Connection handle: 1 )[23:48:50] CMySQLHandler::FreeResult() - Result was successfully free'd.[23:48:57] >> mysql_real_escape_string( Connection handle: 1 )[23:48:57] CMySQLHandler::EscapeString(GrapeGrape); - Escaped 10 characters to GrapeGrape.[23:48:57] >> mysql_real_escape_string( Connection handle: 1 )[23:48:57] CMySQLHandler::EscapeString(123456); - Escaped 6 characters to 123456.[23:48:57] >> mysql_query( Connection handle: 1 )[23:48:57] CMySQLHandler::Query(INSERT INTO `accounts` (`Spielername`, `Passwort`) VALUES ('GrapeGrape', MD5('123456'))) - Successfully executed.[23:49:04] >> mysql_real_escape_string( Connection handle: 1 )[23:49:04] CMySQLHandler::EscapeString(Email@web.de); - Escaped 15 characters to Email@web.de.[23:49:04] >> mysql_query( Connection handle: 1 )[23:49:04] CMySQLHandler::Query(UPDATE accounts< SET Adresse = '127.0.0.1', Email = '27.0.0.1', Adminlevel = 55 WHERE Spielername = 'GrapeGrape') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '< SET Adresse = '127.0.0.1', Email = '27.0.0.1', Adminlevel = 55 WHERE Spielerna' at line 1)[23:49:07] >> mysql_real_escape_string( Connection handle: 1 )[23:49:07] CMySQLHandler::EscapeString(GrapeGrape); - Escaped 10 characters to GrapeGrape.[23:49:07] >> mysql_query( Connection handle: 1 )[23:49:07] CMySQLHandler::Query(SELECT `Passwort` FROM `accounts` WHERE `Spielername` = 'GrapeGrape') - Successfully executed.[23:49:07] >> mysql_store_result( Connection handle: 1 )[23:49:07] CMySQLHandler::StoreResult() - Result was stored.[23:49:07] >> mysql_fetch_row_format( Connection handle: 1 )[23:49:07] CMySQLHandler::FetchRow() - Return: 73eef00cc792ddc3[23:49:07] >> mysql_free_result( Connection handle: 1 )[23:49:07] CMySQLHandler::FreeResult() - Result was successfully free'd.[23:49:07] >> mysql_real_escape_string( Connection handle: 1 )[23:49:07] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[23:49:07] >> mysql_real_escape_string( Connection handle: 1 )[23:49:07] CMySQLHandler::EscapeString(Adresse); - Escaped 7 characters to Adresse.[23:49:07] >> mysql_real_escape_string( Connection handle: 1 )[23:49:07] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.[23:49:07] >> mysql_real_escape_string( Connection handle: 1 )[23:49:07] CMySQLHandler::EscapeString(GrapeGrape); - Escaped 10 characters to GrapeGrape.[23:49:07] >> mysql_query( Connection handle: 1 )[23:49:07] CMySQLHandler::Query(SELECT `Adresse` FROM `accounts` WHERE `Spielername` = 'GrapeGrape') - Successfully executed.[23:49:07] >> mysql_store_result( Connection handle: 1 )[23:49:07] CMySQLHandler::StoreResult() - Result was stored.[23:49:07] >> mysql_fetch_int( Connection handle: 1 )[23:49:07] CMySQLHandler::FetchRow() - Return: [23:49:07] >> mysql_free_result( Connection handle: 1 )[23:49:07] CMySQLHandler::FreeResult() - Result was successfully free'd.[23:49:07] >> mysql_real_escape_string( Connection handle: 1 )[23:49:07] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[23:49:07] >> mysql_real_escape_string( Connection handle: 1 )[23:49:07] CMySQLHandler::EscapeString(Email); - Escaped 5 characters to Email.[23:49:07] >> mysql_real_escape_string( Connection handle: 1 )[23:49:07] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.[23:49:07] >> mysql_real_escape_string( Connection handle: 1 )[23:49:07] CMySQLHandler::EscapeString(GrapeGrape); - Escaped 10 characters to GrapeGrape.[23:49:07] >> mysql_query( Connection handle: 1 )[23:49:07] CMySQLHandler::Query(SELECT `Email` FROM `accounts` WHERE `Spielername` = 'GrapeGrape') - Successfully executed.[23:49:07] >> mysql_store_result( Connection handle: 1 )[23:49:07] CMySQLHandler::StoreResult() - Result was stored.[23:49:07] >> mysql_fetch_int( Connection handle: 1 )[23:49:07] CMySQLHandler::FetchRow() - Return: [23:49:07] >> mysql_free_result( Connection handle: 1 )[23:49:07] CMySQLHandler::FreeResult() - Result was successfully free'd.[23:49:07] >> mysql_real_escape_string( Connection handle: 1 )[23:49:07] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[23:49:07] >> mysql_real_escape_string( Connection handle: 1 )[23:49:07] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.[23:49:07] >> mysql_real_escape_string( Connection handle: 1 )[23:49:07] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.[23:49:07] >> mysql_real_escape_string( Connection handle: 1 )[23:49:07] CMySQLHandler::EscapeString(GrapeGrape); - Escaped 10 characters to GrapeGrape.[23:49:07] >> mysql_query( Connection handle: 1 )[23:49:07] CMySQLHandler::Query(SELECT `Adminlevel` FROM `accounts` WHERE `Spielername` = 'GrapeGrape') - Successfully executed.[23:49:07] >> mysql_store_result( Connection handle: 1 )[23:49:07] CMySQLHandler::StoreResult() - Result was stored.[23:49:07] >> mysql_fetch_int( Connection handle: 1 )[23:49:07] CMySQLHandler::FetchRow() - Return: 0[23:49:07] >> mysql_free_result( Connection handle: 1 )[23:49:07] CMySQLHandler::FreeResult() - Result was successfully free'd.[23:49:09] >> mysql_query( Connection handle: 1 )[23:49:09] CMySQLHandler::Query(UPDATE accounts< SET Adresse = 'ÿÿ', Email = 'ÿ', Adminlevel = 0 WHERE Spielername = 'GrapeGrape') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '< SET Adresse = 'ÿÿ', Email = 'ÿ', Adminlevel = 0 WHERE Spielername = 'GrapeG' at line 1)

    Kannst du das nächstes Mal bitte nicht alles in eine Zeile schreiben, so erkennt man gar nichts.
    Aber gut, es wird also so übergeben, dann liegt es nicht an der Datenbank.


    Wie hast du denn
    [sEmail]
    in deinem enum definiert? Poste mal das enum.

    Jetzt schreibt er die Adresse und die Email garnicht rein, und in der mysqllog kommt dies hier.


    [00:08:26] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:26] CMySQLHandler::EscapeString(Versuch); - Escaped 7 characters to Versuch.
    [00:08:26] >> mysql_query( Connection handle: 1 )
    [00:08:26] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Spielername` = 'Versuch') - Successfully executed.
    [00:08:26] >> mysql_store_result( Connection handle: 1 )
    [00:08:26] CMySQLHandler::StoreResult() - Result was stored.
    [00:08:26] >> mysql_num_rows( Connection handle: 1 )
    [00:08:26] CMySQLHandler::NumRows() - Returned 0 row(s)
    [00:08:26] >> mysql_free_result( Connection handle: 1 )
    [00:08:26] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [00:08:30] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:30] CMySQLHandler::EscapeString(Versuch); - Escaped 7 characters to Versuch.
    [00:08:30] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:30] CMySQLHandler::EscapeString(123456); - Escaped 6 characters to 123456.
    [00:08:30] >> mysql_query( Connection handle: 1 )
    [00:08:30] CMySQLHandler::Query(INSERT INTO `accounts` (`Spielername`, `Passwort`) VALUES ('Versuch', MD5('123456'))) - Successfully executed.
    [00:08:38] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:38] CMySQLHandler::EscapeString(email@web.de); - Escaped 12 characters to email@web.de.
    [00:08:38] >> mysql_query( Connection handle: 1 )
    [00:08:38] CMySQLHandler::Query(UPDATE accounts< SET Adresse = '127.0.0.1', Email = 'email@web.de', Adminlevel = 0 WHERE Spielername = 'Versuch') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '< SET Adresse = '127.0.0.1', Email = 'email@web.de', Adminlevel = 0 WHERE Spiele' at line 1)
    [00:08:43] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:43] CMySQLHandler::EscapeString(Versuch); - Escaped 7 characters to Versuch.
    [00:08:43] >> mysql_query( Connection handle: 1 )
    [00:08:43] CMySQLHandler::Query(SELECT `Passwort` FROM `accounts` WHERE `Spielername` = 'Versuch') - Successfully executed.
    [00:08:43] >> mysql_store_result( Connection handle: 1 )
    [00:08:43] CMySQLHandler::StoreResult() - Result was stored.
    [00:08:43] >> mysql_fetch_row_format( Connection handle: 1 )
    [00:08:43] CMySQLHandler::FetchRow() - Return: e10adc3949ba59ab
    [00:08:43] >> mysql_free_result( Connection handle: 1 )
    [00:08:43] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [00:08:43] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:43] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
    [00:08:43] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:43] CMySQLHandler::EscapeString(Adresse); - Escaped 7 characters to Adresse.
    [00:08:43] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:43] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
    [00:08:43] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:43] CMySQLHandler::EscapeString(Versuch); - Escaped 7 characters to Versuch.
    [00:08:43] >> mysql_query( Connection handle: 1 )
    [00:08:43] CMySQLHandler::Query(SELECT `Adresse` FROM `accounts` WHERE `Spielername` = 'Versuch') - Successfully executed.
    [00:08:43] >> mysql_store_result( Connection handle: 1 )
    [00:08:43] CMySQLHandler::StoreResult() - Result was stored.
    [00:08:43] >> mysql_fetch_int( Connection handle: 1 )
    [00:08:43] CMySQLHandler::FetchRow() - Return:
    [00:08:43] >> mysql_free_result( Connection handle: 1 )
    [00:08:43] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [00:08:43] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:43] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
    [00:08:43] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:43] CMySQLHandler::EscapeString(Email); - Escaped 5 characters to Email.
    [00:08:43] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:43] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
    [00:08:43] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:43] CMySQLHandler::EscapeString(Versuch); - Escaped 7 characters to Versuch.
    [00:08:43] >> mysql_query( Connection handle: 1 )
    [00:08:43] CMySQLHandler::Query(SELECT `Email` FROM `accounts` WHERE `Spielername` = 'Versuch') - Successfully executed.
    [00:08:43] >> mysql_store_result( Connection handle: 1 )
    [00:08:43] CMySQLHandler::StoreResult() - Result was stored.
    [00:08:43] >> mysql_fetch_int( Connection handle: 1 )
    [00:08:43] CMySQLHandler::FetchRow() - Return:
    [00:08:43] >> mysql_free_result( Connection handle: 1 )
    [00:08:43] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [00:08:43] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:43] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
    [00:08:43] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:43] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.
    [00:08:43] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:43] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
    [00:08:43] >> mysql_real_escape_string( Connection handle: 1 )
    [00:08:43] CMySQLHandler::EscapeString(Versuch); - Escaped 7 characters to Versuch.
    [00:08:43] >> mysql_query( Connection handle: 1 )
    [00:08:43] CMySQLHandler::Query(SELECT `Adminlevel` FROM `accounts` WHERE `Spielername` = 'Versuch') - Successfully executed.
    [00:08:43] >> mysql_store_result( Connection handle: 1 )
    [00:08:43] CMySQLHandler::StoreResult() - Result was stored.
    [00:08:43] >> mysql_fetch_int( Connection handle: 1 )
    [00:08:43] CMySQLHandler::FetchRow() - Return: 0
    [00:08:43] >> mysql_free_result( Connection handle: 1 )
    [00:08:43] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [00:08:44] >> mysql_query( Connection handle: 1 )
    [00:08:44] CMySQLHandler::Query(UPDATE accounts< SET Adresse = 'ÿ27.0.0.1', Email = 'ÿmail@web.de', Adminlevel = 0 WHERE Spielername = 'Versuch') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '< SET Adresse = 'ÿ27.0.0.1', Email = 'ÿmail@web.de', Adminlevel = 0 WHERE Spie' at line 1)

    Schreib das ganze mal so:


    stock SavePlayer(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    if(GetPVarInt(playerid, "Eingeloggt") == 1)
    {
    new query[200];
    format(query, sizeof(query), "UPDATE `accounts` SET `Adresse`= '%s', `Email` = '%s', `Adminlevel`= %d WHERE `Spielernamen` = '%s'",
    sInfo[playerid][sAdresse],
    sInfo[playerid][sEmail],
    sInfo[playerid][sAdminlevel],
    sName(playerid));
    mysql_query(query);
    }
    }
    return 1;
    }

    Gut...naja, nicht gut, aber der Fehler liegt hier, offensichtlich:

    Zitat

    [00:08:44] CMySQLHandler::Query(UPDATE accounts< SET Adresse = 'ÿ27.0.0.1', Email = 'ÿmail@web.de', Adminlevel = 0 WHERE Spielername = 'Versuch') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '< SET Adresse = 'ÿ27.0.0.1', Email = 'ÿmail@web.de', Adminlevel = 0 WHERE Spie' at line 1)


    Poste bitte nochmal den Code der SavePlayer-Funktion so wie die Funktion im Moment ist.
    Poste dazu auch gleich noch den Teil wo der Spieler seine Mail eingibt, und den Teil wo die IP Adresse gespeichert wird.



    EDIT: Außer das oben funktioniert, denke ich aber eher nicht, da diese `` hier nicht notwendig sind.

    Zitat von CIBERKILLER

    Schreib das ganze mal so:


    Hat leider nicht funktioniert.


    Jeffry


    stock SavePlayer(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    if(GetPVarInt(playerid, "Eingeloggt") == 1)
    {
    new query[500];
    format(query, sizeof(query), "UPDATE accounts SET Adresse = '%s', Email = '%s', Adminlevel = %d WHERE Spielername = '%s'",
    sInfo[playerid][sAdresse],
    sInfo[playerid][sEmail],
    sInfo[playerid][sAdminlevel],
    sName(playerid));
    mysql_query(query);
    }
    }
    return 1;
    }


    if(dialogid == DIALOG_EMAIL)
    {
    if(response)
    {
    if(strlen(inputtext) < 0 || strlen(inputtext) > 36) return ShowPlayerDialog(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "xxx", "xxx", "Register", "Abbrechen");
    if(strfind(inputtext, "@", true) == -1) return ShowPlayerDialog(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "XXX", "XXX", "Register", "Abbrechen");
    {
    mysql_real_escape_string(inputtext, inputtext);
    format(sInfo[playerid][sEmail], 36, "%s", inputtext);
    GetPlayerIp(playerid, sInfo[playerid][sAdresse], 20);
    SetPVarInt(playerid, "Eingeloggt", 1);
    SavePlayer(playerid);
    }
    }
    else
    {
    Kick(playerid);
    }
    }

    mysql_real_escape_string(inputtext, inputtext);
    format(sInfo[playerid][sEmail], 36, "%s", inputtext);


    zu:
    mysql_real_escape_string(inputtext, sInfo[playerid][sEmail]);



    Und:
    format(query, sizeof(query), "UPDATE accounts< SET Adresse
    Mach das < weg, das hat da nichts zu suchen.



    Falls es noch immer nicht funktioniert, poste nochmal den Log dazu.

    Zitat von Jeffry

    Mach das < weg, das hat da nichts zu suchen.



    Der ist mir gerade beim kopieren, dazwischen gekommen. Er zeigt die E-Mail in der Datenbank so an ÿmail@web.de


    //Edit


    [00:24:11] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:11] CMySQLHandler::EscapeString(versuch2); - Escaped 8 characters to versuch2.
    [00:24:11] >> mysql_query( Connection handle: 1 )
    [00:24:11] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Spielername` = 'versuch2') - Successfully executed.
    [00:24:11] >> mysql_store_result( Connection handle: 1 )
    [00:24:11] CMySQLHandler::StoreResult() - Result was stored.
    [00:24:11] >> mysql_num_rows( Connection handle: 1 )
    [00:24:11] CMySQLHandler::NumRows() - Returned 0 row(s)
    [00:24:11] >> mysql_free_result( Connection handle: 1 )
    [00:24:11] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [00:24:19] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:19] CMySQLHandler::EscapeString(versuch2); - Escaped 8 characters to versuch2.
    [00:24:19] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:19] CMySQLHandler::EscapeString(123456); - Escaped 6 characters to 123456.
    [00:24:19] >> mysql_query( Connection handle: 1 )
    [00:24:19] CMySQLHandler::Query(INSERT INTO `accounts` (`Spielername`, `Passwort`) VALUES ('versuch2', MD5('123456'))) - Successfully executed.
    [00:24:24] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:24] CMySQLHandler::EscapeString(email@web.de); - Escaped 12 characters to email@web.de.
    [00:24:24] >> mysql_query( Connection handle: 1 )
    [00:24:24] CMySQLHandler::Query(UPDATE accounts SET Adresse = '127.0.0.1', Email = 'email@web.de', Adminlevel = 0 WHERE Spielername = 'versuch2') - Successfully executed.
    [00:24:27] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:27] CMySQLHandler::EscapeString(versuch2); - Escaped 8 characters to versuch2.
    [00:24:27] >> mysql_query( Connection handle: 1 )
    [00:24:27] CMySQLHandler::Query(SELECT `Passwort` FROM `accounts` WHERE `Spielername` = 'versuch2') - Successfully executed.
    [00:24:27] >> mysql_store_result( Connection handle: 1 )
    [00:24:27] CMySQLHandler::StoreResult() - Result was stored.
    [00:24:27] >> mysql_fetch_row_format( Connection handle: 1 )
    [00:24:27] CMySQLHandler::FetchRow() - Return: e10adc3949ba59ab
    [00:24:27] >> mysql_free_result( Connection handle: 1 )
    [00:24:27] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [00:24:27] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:27] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
    [00:24:27] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:27] CMySQLHandler::EscapeString(Adresse); - Escaped 7 characters to Adresse.
    [00:24:27] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:27] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
    [00:24:27] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:27] CMySQLHandler::EscapeString(versuch2); - Escaped 8 characters to versuch2.
    [00:24:27] >> mysql_query( Connection handle: 1 )
    [00:24:27] CMySQLHandler::Query(SELECT `Adresse` FROM `accounts` WHERE `Spielername` = 'versuch2') - Successfully executed.
    [00:24:27] >> mysql_store_result( Connection handle: 1 )
    [00:24:27] CMySQLHandler::StoreResult() - Result was stored.
    [00:24:27] >> mysql_fetch_int( Connection handle: 1 )
    [00:24:27] CMySQLHandler::FetchRow() - Return: 127.0.0.1
    [00:24:27] >> mysql_free_result( Connection handle: 1 )
    [00:24:27] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [00:24:27] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:27] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
    [00:24:27] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:27] CMySQLHandler::EscapeString(Email); - Escaped 5 characters to Email.
    [00:24:27] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:27] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
    [00:24:27] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:27] CMySQLHandler::EscapeString(versuch2); - Escaped 8 characters to versuch2.
    [00:24:27] >> mysql_query( Connection handle: 1 )
    [00:24:27] CMySQLHandler::Query(SELECT `Email` FROM `accounts` WHERE `Spielername` = 'versuch2') - Successfully executed.
    [00:24:27] >> mysql_store_result( Connection handle: 1 )
    [00:24:27] CMySQLHandler::StoreResult() - Result was stored.
    [00:24:27] >> mysql_fetch_int( Connection handle: 1 )
    [00:24:27] CMySQLHandler::FetchRow() - Return: email@web.de
    [00:24:27] >> mysql_free_result( Connection handle: 1 )
    [00:24:27] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [00:24:27] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:27] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
    [00:24:27] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:27] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.
    [00:24:27] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:27] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
    [00:24:27] >> mysql_real_escape_string( Connection handle: 1 )
    [00:24:27] CMySQLHandler::EscapeString(versuch2); - Escaped 8 characters to versuch2.
    [00:24:27] >> mysql_query( Connection handle: 1 )
    [00:24:27] CMySQLHandler::Query(SELECT `Adminlevel` FROM `accounts` WHERE `Spielername` = 'versuch2') - Successfully executed.
    [00:24:27] >> mysql_store_result( Connection handle: 1 )
    [00:24:27] CMySQLHandler::StoreResult() - Result was stored.
    [00:24:27] >> mysql_fetch_int( Connection handle: 1 )
    [00:24:27] CMySQLHandler::FetchRow() - Return: 0
    [00:24:27] >> mysql_free_result( Connection handle: 1 )
    [00:24:27] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [00:24:29] >> mysql_query( Connection handle: 1 )
    [00:24:29] CMySQLHandler::Query(UPDATE accounts SET Adresse = 'ÿ27.0.0.1', Email = 'ÿmail@web.de', Adminlevel = 0 WHERE Spielername = 'versuch2') - Successfully executed.