Die daten weren gepsichert sobald das ganze Tutorial fertig ist.
Egal, ich habe trotzdem einfach mal überall SpielerSpeichern hin getan.
Es geht immer noch nicht.
SpielerSpeichern Funktion:
SpielerSpeichern(playerid)
{
if(pInfo[playerid][pEingeloggt] == 0)return 1;
new query[256];
format(query,256,"UPDATE spielerdaten SET level='%i', geld='%i', geschlecht='%i', age='%i', `wohnort`='%i' WHERE id='%i'",GetPlayerScore(playerid),
GetPlayerMoney(playerid), pInfo[playerid][pGeschlecht],pInfo[playerid][pAlter],pInfo[playerid][pWohnort],pInfo[playerid][db_id]);
mysql_function_query(dbhandle,query,false,"","");
}
Log:
Code
[16:22:44] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE spielerdaten SET level='0', geld='0', geschlecht='0', age", callback: "(null)", format: "(null)"
[16:22:44] [DEBUG] mysql_close - connection: 1
[16:22:44] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[16:22:44] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[16:22:44] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[16:22:44] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called
[16:22:56] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "samp", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[16:22:56] [DEBUG] CMySQLHandle::Create - creating new connection..
[16:22:56] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[16:22:56] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[16:22:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[16:22:56] [DEBUG] CMySQLConnection::Connect - connection was successful
[16:22:56] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[16:22:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[16:22:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[16:22:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[16:22:56] [DEBUG] CMySQLConnection::Connect - connection was successful
[16:22:56] [DEBUG] CMySQLConnection::Connect - connection was successful
[16:22:56] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[16:22:56] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[16:22:56] [DEBUG] CMySQLConnection::Connect - connection was successful
[16:22:56] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[16:23:00] [DEBUG] mysql_tquery - connection: 1, query: "SELECT id FROM spielerdaten WHERE username='Sonntag'", callback: "OnUserCheck2", format: "i"
[16:23:00] [DEBUG] CMySQLQuery::Execute[OnUserCheck2] - starting query execution
[16:23:00] [DEBUG] CMySQLQuery::Execute[OnUserCheck2] - query was successfully executed within 0.998 milliseconds
[16:23:00] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[16:23:00] [DEBUG] Calling callback "OnUserCheck2"..
[16:23:00] [DEBUG] cache_get_data - connection: 1
[16:23:00] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[16:23:03] [DEBUG] mysql_tquery - connection: 1, query: "SELECT id FROM spielerdaten WHERE username='Sonntag'", callback: "OnUserCheck", format: "i"
[16:23:03] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - starting query execution
[16:23:03] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - query was successfully executed within 0.675 milliseconds
[16:23:03] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[16:23:03] [DEBUG] Calling callback "OnUserCheck"..
[16:23:03] [DEBUG] cache_get_data - connection: 1
[16:23:03] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[16:23:05] [DEBUG] mysql_escape_string - source: "pascal", connection: 1, max_len: 35
[16:23:05] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO spielerdaten (username,passwort,geschlecht,age,wohno", callback: "OnPlayerRegister", format: "i"
[16:23:05] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - starting query execution
[16:23:05] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - query was successfully executed within 68.158 milliseconds
[16:23:05] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[16:23:05] [DEBUG] Calling callback "OnPlayerRegister"..
[16:23:05] [DEBUG] cache_insert_id - connection: 1
[16:23:05] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
Alles anzeigen