Guten Morgen Community,
Ich bekomme aus meiner Debug folgende Meldung wenn ich den Spieler laden lassen möchte... :
[19:01:17] >> mysql_real_escape_string( Connection handle: 1 )
[19:01:17] CMySQLHandler::EscapeString([DT]Nightstr3am); - Escaped 15 characters to [DT]Nightstr3am.
[19:01:17] >> mysql_query( Connection handle: 1 )
[19:01:17] CMySQLHandler::Query(SELECT `Passwort` FROM `accounts` WHERE = '[DT]Nightstr3am') - 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 '= '[DT]Nightstr3am'' at line 1)
[19:01:17] >> mysql_store_result( Connection handle: 1 )
[19:01:17] CMySQLHandler::StoreResult() - No data to store.
[19:01:17] >> mysql_fetch_row_format( Connection handle: 1 )
[19:01:17] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[19:01:17] >> mysql_free_result( Connection handle: 1 )
[19:01:17] CMySQLHandler::FreeResult() - The result is already empty.
[19:01:17] >> mysql_query( Connection handle: 1 )
[19:01:17] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Name` = '[DT]Nightstr3am') - Successfully executed.
[19:01:17] >> mysql_store_result( Connection handle: 1 )
[19:01:17] CMySQLHandler::StoreResult() - Result was stored.
[19:01:17] >> mysql_num_rows( Connection handle: 1 )
[19:01:17] CMySQLHandler::NumRows() - Returned 1 row(s)
[19:01:17] >> mysql_fetch_field_row( Connection handle: 1 )
[19:01:17] CMySQLHandler::FetchField() - You cannot call this function now. (Reason: Fields/Rows are empty.)
[19:01:17] >> mysql_fetch_field_row( Connection handle: 1 )
[19:01:17] CMySQLHandler::FetchField() - You cannot call this function now. (Reason: Fields/Rows are empty.)
[19:01:17] >> mysql_fetch_field_row( Connection handle: 1 )
[19:01:17] CMySQLHandler::FetchField() - You cannot call this function now. (Reason: Fields/Rows are empty.)
[19:01:17] >> mysql_fetch_field_row( Connection handle: 1 )
[19:01:17] CMySQLHandler::FetchField() - You cannot call this function now. (Reason: Fields/Rows are empty.)
[19:01:17] >> mysql_fetch_field_row( Connection handle: 1 )
[19:01:17] CMySQLHandler::FetchField() - You cannot call this function now. (Reason: Fields/Rows are empty.)
[19:01:23] >> mysql_query( Connection handle: 1 )
[19:01:23] CMySQLHandler::Query(UPDATE `accounts` SET `Tut` = '0', `pX` = '796.329650', `pY` = '-2238.296875', `pZ` = '4.596553',`Skin` = '0' WHERE `Name` = '[DT]Nightstr3am') - Successfully executed.
[19:01:40] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[19:01:40] CMySQLHandler::FreeResult() - Result was successfully free'd.
[19:01:40] CMySQLHandler::Disconnect() - Connection was closed.
[19:01:40] CMySQLHandler::~CMySQLHandler() - deconstructor called.Und hier lasse ich den Spieler Laden :
stock LoadPlayer(playerid)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
new query[250],val[128];
format(query,sizeof(query),"SELECT * FROM `accounts` WHERE `Name` = '%s'",SpielerName(playerid));
mysql_query(query);
mysql_store_result();
if(mysql_num_rows())
{
mysql_fetch_field_row("Tut",val); PlayerInfo[playerid][pTut] = strval(val);
mysql_fetch_field_row("pX",val); PlayerInfo[playerid][pX] = floatstr(val);
mysql_fetch_field_row("pY",val); PlayerInfo[playerid][pY] = floatstr(val);
mysql_fetch_field_row("pZ",val); PlayerInfo[playerid][pZ] = floatstr(val);
mysql_fetch_field_row("Skin",val); PlayerInfo[playerid][pSkin] = strval(val);
}
}
return 1;
}
