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

    Uhh, da hast aber was hinbekommen dann. 8|


    Ändere das enum mal zu:
    enum SpielerInfo
    {
    sAdresse[32],
    sEmail[32],
    sAdminlevel,
    sNames[MAX_PLAYER_NAME+1]
    };


    Wenn das auch nichts ändert, dann poste noch wie du "sNames" einen Wert zuweist.
    So langsam gehen mir die Ideen aus. :S

    Müsste gestern Nacht leider schon früher Offline, dafür entschuldige ich mich erstmal.


    Das problem besteht leider weiterhin.


    mysqllog


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

    Kein Ding, aber hey, schau mal:

    Zitat

    [12:30:12] CMySQLHandler::Query(UPDATE accounts SET Adresse = '127.0.0.1', Email = 'email@web.de', Adminlevel = 0 WHERE Spielername = 'versuch4') - Successfully executed.


    Das tut doch.


    Dann lädst du es wieder:

    Zitat

    [12:30:18] CMySQLHandler::Query(SELECT `Email` FROM `accounts` WHERE `Spielername` = 'versuch4') - Successfully executed
    [12:30:18] CMySQLHandler::FetchRow() - Return: email@web.de


    Tut auch.


    Und erst dann ist es falsch:

    Zitat

    [12:30:21] CMySQLHandler::Query(UPDATE accounts SET Adresse = 'ÿ27.0.0.1', Email = 'ÿmail@web.de', Adminlevel = 0 WHERE Spielername = 'versuch4') - Successfully executed.



    Also poste bitte mal den Code mit dem du die E-Mail lädst, also der Teil:
    SELECT `Email` FROM `accounts` WHERE `Spielername` = 'versuch4'

    stock LoadPlayer(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    GetPlayerName(playerid, sInfo[playerid][sNames], MAX_PLAYER_NAME);
    sInfo[playerid][sAdresse] = MySQL_GetInt("accounts", "Adresse", "Spielername", sInfo[playerid][sNames]);
    sInfo[playerid][sEmail] = MySQL_GetInt("accounts", "Email", "Spielername", sInfo[playerid][sNames]);
    sInfo[playerid][sAdminlevel] = MySQL_GetInt("accounts", "Adminlevel", "Spielername", sInfo[playerid][sNames]);
    }
    return 1;
    }

    Das ist der Fehler!


    stock LoadPlayer(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    GetPlayerName(playerid, sInfo[playerid][sNames], MAX_PLAYER_NAME);
    format(sInfo[playerid][sAdresse],32, MySQL_GetString("accounts", "Adresse", "Spielername", sInfo[playerid][sNames]));
    format(sInfo[playerid][sEmail],32, MySQL_GetString("accounts", "Email", "Spielername", sInfo[playerid][sNames]));
    sInfo[playerid][sAdminlevel] = MySQL_GetInt("accounts", "Adminlevel", "Spielername", sInfo[playerid][sNames]);
    }
    return 1;
    }


    IP und E-Mail sind keine Integers.