Beiträge von Grapefruit

Kommt nichts an, aber wenn ich md5 ganz rausnehme funktioniert alles.

Und wie mach ich ein print debug? Meinst du einfach printen?

Hallo breadfish,
Ich hab ein kleines Problem mit dem Hashen von Passwörtern. Beim Registrieren wird das Passwort normal gehasht, dass klappt auch wunderbar bloß beim Login, sagt er mir immer das, dass Passwort falsch ist.

Hier wird das beim Login gehasht
if(!strcmp(MD5_Hash(inputtext), MySQL_Password(sName(playerid)), true))

Mit freundlichen Grüßen
Grapefruit

Ich weiß nicht ob du/oder der Ersteller des Scriptes es als Globalen oder Player Textdraw erstellt hast/hat. PlayerTextdraws befinden sich unter dem Callback OnPlayerConnect, und die Globalen Textdraws unter dem Callback OnGameModeInit. Und du musst dann, dass Textdraw suchen mit dem Login/Register und die TextDrawTextSize anpasst. Und hast du überhaupt nach geschaut ob SelectTextDraw existiert?

Das ist die Box, und nicht der Text Register/Login.

Entweder bin ich blind oder es ist dort keine zusehen. Das problem kann trozdem an der TextDrawTextSize liegen, wenn sie zu klein ist, passiert ebenfalls nichts.

Erstmal schaust du im Script, ob SelectTextDraw schon vorhanden ist. Wenn es sie gibt, musst du die TextDrawTextSize verändern. Das machst du indem du auf das Textdraw gehst, was du anklicken möchtest, und die TextDrawTextSize X Y Koordinate veränderst. Wenn SelectTextdraw nicht vorhanden ist, musst du es dort einfügen, wo du die TextDraws auch zeigst.

Zitat

Achso, du kannst deine Maus nicht bewegen oder hast keine Möglichkeit dazu?
Sag das doch gleich ^^.
Dafür brauchst du die Funktion SelectTextdraw (anpassen)
Die muss dahin, wo auch der Textdraw gezeigt wird. (ShowTextDrawForPlayer)

Und du musst die TextDrawTextSize anpassen.

Das wird uns nicht helfen, such mal im Script nach SelectTextDraw und schick uns mal denn Code, wo es sich befindet.

Werden die Textdraws denn wenigsten gehovert? Und such mal im Script nach SelectTextDraw und schreib uns, wo sich dies befindet.

Forum: 10/10 Gefällt mir, gibt nichts zu bemängeln, außer kleinigkeiten die niemanden stören.

Server: 6/10 Das Script buggt ziemlich rum, die Textdraws gefallen mir nicht. Das Garagen System kenne ich von Russischen Servern bzw. gibt es auf Youtube als Filterscript.

Mit freundlichen Grüßen

Grapefruit

Das hab ich unter DialogResponse stehen, beim Register.

//Edit

Jeffry @[NGD]Manne Ich bedanke mich bei euch, für diese ganze hilfe. Danke

@[NGD]Manne hatte es mir bereits per PN geschickt, trozdem Danke. Nun wird die E-Mail vernünftig gespeichert, nun wird die IP-Adresse nicht gespeichert.

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

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

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.

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.

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

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)

Schuldigung, wird nicht wieder vor kommen

enum SpielerInfo
{
sNames[MAX_PLAYER_NAME+1],
sAdresse,
sEmail,
sAdminlevel
};

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)