1) Was sagt der Log?
2) Poste bitte einen Screenshot von der Tabelle in deiner Datenbank.
autos laden
- Blackshadowscript
- Geschlossen
- Erledigt
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
-
-
Habe die autos raus gelöscht jetzt grade ebend.
-
Jetzt hab ich meine beiden Fragen schon nummeriert und du beantwortest erst nur eine.
1) Was sagt der Log?
-
Code
Alles anzeigen---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z-R4, (C)2005-2014 SA-MP Team [19:11:39] filterscripts = "" (string) [19:11:39] [19:11:39] Server Plugins [19:11:39] -------------- [19:11:39] Loading plugin: sscanf [19:11:39] [19:11:39] =============================== [19:11:39] sscanf plugin loaded. [19:11:39] (c) 2009 Alex "Y_Less" Cole [19:11:39] 0.3d-R2 500 Players "dnee" [19:11:39] =============================== [19:11:39] Loaded. [19:11:39] Loading plugin: mysql [19:11:39] >> plugin.mysql: R39 successfully loaded. [19:11:39] Loaded. [19:11:39] Loaded 2 plugins. [19:11:39] [19:11:39] Filterscripts [19:11:39] --------------- [19:11:39] Loaded 0 filterscripts. [19:11:39] Server wurde gestartet [19:11:39] MYSQL verbindung aufgebaut! [19:11:39] ---------------------------------- [19:11:39] Blackshadowscript [19:11:39] ---------------------------------- [19:11:39] Number of vehicle models: 0
SQL
Alles anzeigen[19:12:21] [DEBUG] mysql_connect - host: "25.3.164.220", user: "blackshadow", database: "test", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [19:12:21] [DEBUG] CMySQLHandle::Create - creating new connection.. [19:12:21] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [19:12:21] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [19:12:21] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:12:21] [DEBUG] CMySQLConnection::Connect - connection was successful [19:12:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:12:21] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:12:21] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:12:21] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:12:21] [DEBUG] CMySQLConnection::Connect - connection was successful [19:12:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:12:21] [DEBUG] CMySQLConnection::Connect - connection was successful [19:12:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:12:21] [DEBUG] CMySQLConnection::Connect - connection was successful [19:12:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
-
Hast du auch wieder Autos erstellt? Ohne Autos in der Datenbank kann es ja auch keine laden.
Mach das mal, und poste dann erneut den MySQL Log. -
SQL
Alles anzeigen[19:27:28] [DEBUG] mysql_connect - host: "25.3.164.220", user: "blackshadow", database: "test", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [19:27:28] [DEBUG] CMySQLHandle::Create - creating new connection.. [19:27:28] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [19:27:28] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [19:27:28] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:27:28] [DEBUG] CMySQLConnection::Connect - connection was successful [19:27:28] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:27:28] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:27:28] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:27:28] [DEBUG] CMySQLConnection::Connect - connection was successful [19:27:28] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:27:28] [DEBUG] CMySQLConnection::Connect - connection was successful [19:27:28] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:27:28] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:27:28] [DEBUG] CMySQLConnection::Connect - connection was successful [19:27:28] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:27:54] [DEBUG] mysql_tquery - connection: 1, query: "SELECT id FROM user WHERE username='Blackshadow'", callback: "OnUserCheck", format: "d" [19:27:54] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - starting query execution [19:27:54] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - query was successfully executed within 0.405 milliseconds [19:27:54] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [19:27:54] [DEBUG] Calling callback "OnUserCheck".. [19:27:54] [DEBUG] cache_get_data - connection: 1 [19:27:54] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [19:27:58] [DEBUG] mysql_escape_string - source: "klom19pom", connection: 1, max_len: 35 [19:27:58] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE username='Blackshadow' AND passwort=MD5", callback: "OnPasswordResponse", format: "i" [19:27:58] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - starting query execution [19:27:58] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - query was successfully executed within 0.417 milliseconds [19:27:58] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [19:27:58] [DEBUG] Calling callback "OnPasswordResponse".. [19:27:58] [DEBUG] cache_get_data - connection: 1 [19:27:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "level", connection: 1 [19:27:58] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "level", data: "3" [19:27:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Adminlevel", connection: 1 [19:27:58] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Adminlevel", data: "12" [19:27:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "money", connection: 1 [19:27:58] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "money", data: "9994954" [19:27:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "id", connection: 1 [19:27:58] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "id", data: "0" [19:27:58] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM Autos WHERE Besitzer='0' ", callback: "OnPlayerCarsLoad", format: "i" [19:27:58] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [19:27:58] [DEBUG] CMySQLQuery::Execute[OnPlayerCarsLoad] - starting query execution [19:27:58] [DEBUG] CMySQLQuery::Execute[OnPlayerCarsLoad] - query was successfully executed within 0.436 milliseconds [19:27:58] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [19:27:58] [DEBUG] Calling callback "OnPlayerCarsLoad".. [19:27:58] [DEBUG] cache_get_data - connection: 1 [19:27:58] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [19:28:14] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO Autos (Besitzer, model, x, y, z, r) VALUES ('0', '56", callback: " ", format: "(null)" [19:28:14] [DEBUG] CMySQLQuery::Execute[ ] - starting query execution [19:28:14] [ERROR] CMySQLQuery::Execute[ ] - (error #1054) Unknown column 'x' in 'field list' [19:28:14] [DEBUG] CMySQLQuery::Execute[ ] - error will be triggered in OnQueryError [19:28:26] [DEBUG] mysql_close - connection: 1 [19:28:26] [DEBUG] CMySQLConnection::Disconnect - connection was closed [19:28:26] [DEBUG] CMySQLConnection::Disconnect - connection was closed [19:28:26] [DEBUG] CMySQLConnection::Disconnect - connection was closed [19:28:26] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called [19:28:38] [DEBUG] mysql_connect - host: "25.3.164.220", user: "blackshadow", database: "test", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [19:28:38] [DEBUG] CMySQLHandle::Create - creating new connection.. [19:28:38] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [19:28:38] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [19:28:38] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:28:38] [DEBUG] CMySQLConnection::Connect - connection was successful [19:28:38] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:28:38] [DEBUG] mysql_tquery - connection: 1, query: "SELECT id FROM user WHERE username='Blackshadow'", callback: "OnUserCheck", format: "d" [19:28:38] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:28:38] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:28:38] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:28:38] [DEBUG] CMySQLConnection::Connect - connection was successful [19:28:38] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:28:38] [DEBUG] CMySQLConnection::Connect - connection was successful [19:28:38] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:28:38] [DEBUG] CMySQLConnection::Connect - connection was successful [19:28:38] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:28:38] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - starting query execution [19:28:38] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - query was successfully executed within 0.321 milliseconds [19:28:38] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [19:28:38] [DEBUG] Calling callback "OnUserCheck".. [19:28:38] [DEBUG] cache_get_data - connection: 1 [19:28:38] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [19:28:43] [DEBUG] mysql_escape_string - source: "klom19pom", connection: 1, max_len: 35 [19:28:43] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE username='Blackshadow' AND passwort=MD5", callback: "OnPasswordResponse", format: "i" [19:28:43] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - starting query execution [19:28:43] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - query was successfully executed within 0.323 milliseconds [19:28:43] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [19:28:43] [DEBUG] Calling callback "OnPasswordResponse".. [19:28:43] [DEBUG] cache_get_data - connection: 1 [19:28:43] [DEBUG] cache_get_field_content_int - row: 0, field_name: "level", connection: 1 [19:28:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "level", data: "3" [19:28:43] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Adminlevel", connection: 1 [19:28:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Adminlevel", data: "12" [19:28:43] [DEBUG] cache_get_field_content_int - row: 0, field_name: "money", connection: 1 [19:28:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "money", data: "9994954" [19:28:43] [DEBUG] cache_get_field_content_int - row: 0, field_name: "id", connection: 1 [19:28:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "id", data: "0" [19:28:43] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM Autos WHERE Besitzer='0' ", callback: "OnPlayerCarsLoad", format: "i" [19:28:43] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [19:28:43] [DEBUG] CMySQLQuery::Execute[OnPlayerCarsLoad] - starting query execution [19:28:43] [DEBUG] CMySQLQuery::Execute[OnPlayerCarsLoad] - query was successfully executed within 0.622 milliseconds [19:28:43] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [19:28:43] [DEBUG] Calling callback "OnPlayerCarsLoad".. [19:28:43] [DEBUG] cache_get_data - connection: 1 [19:28:43] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [19:28:54] [DEBUG] mysql_close - connection: 1 [19:28:54] [DEBUG] CMySQLConnection::Disconnect - connection was closed [19:28:54] [DEBUG] CMySQLConnection::Disconnect - connection was closed [19:28:54] [DEBUG] CMySQLConnection::Disconnect - connection was closed [19:28:54] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called
-
Zitat
[19:28:14] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO Autos (Besitzer, model, x, y, z, r) VALUES ('0', '56", callback: " ", format: "(null)"
[19:28:14] [ERROR] CMySQLQuery::Execute[ ] - (error #1054) Unknown column 'x' in 'field list'Beim INSERT musst du es auch zu c_x (etc) ändern.
-
----------
Loaded log file: "server_log.txt".
----------SA-MP Dedicated Server
----------------------
v0.3z-R4, (C)2005-2014 SA-MP Team[19:48:09] filterscripts = "" (string)
[19:48:09]
[19:48:09] Server Plugins
[19:48:09] --------------
[19:48:09] Loading plugin: sscanf
[19:48:09][19:48:09] ===============================
[19:48:09] sscanf plugin loaded.
[19:48:09] (c) 2009 Alex "Y_Less" Cole
[19:48:09] 0.3d-R2 500 Players "dnee"
[19:48:09] ===============================
[19:48:09] Loaded.
[19:48:09] Loading plugin: mysql
[19:48:09] >> plugin.mysql: R39 successfully loaded.
[19:48:09] Loaded.
[19:48:09] Loaded 2 plugins.[19:48:09]
[19:48:09] Filterscripts
[19:48:09] ---------------
[19:48:09] Loaded 0 filterscripts.[19:48:09] Server wurde gestartet
[19:48:09] MYSQL verbindung aufgebaut!
[19:48:09]
----------------------------------
[19:48:09] Blackshadowscript
[19:48:09] ----------------------------------[19:48:09] Number of vehicle models: 0
[19:48:43] Incoming connection: 25.3.164.220:65072
[19:48:43] [join] Blackshadow has joined the server (0:25.3.164.220)
[19:48:43] num rows = 1
[19:49:02] Der Server wurde beendet
[19:49:14] Server wurde gestartet
[19:49:14] MYSQL verbindung aufgebaut!
[19:49:14]
----------------------------------
[19:49:14] Blackshadowscript
[19:49:14] ----------------------------------[19:49:14] Number of vehicle models: 0
[19:49:14] num rows = 1
[19:49:28] [part] Blackshadow has left the server (0:1)
[19:49:32] --- Server Shutting Down.
[19:49:32] Der Server wurde beendet
[19:49:32][19:49:32] ===============================
[19:49:32] sscanf plugin unloaded.
[19:49:32] ===============================
[19:49:32] plugin.mysql: Unloading plugin...
[19:49:32] plugin.mysql: Plugin unloaded.SQL
Alles anzeigen[19:48:09] [DEBUG] mysql_connect - host: "25.3.164.220", user: "blackshadow", database: "test", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [19:48:09] [DEBUG] CMySQLHandle::Create - creating new connection.. [19:48:09] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [19:48:09] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [19:48:09] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:48:09] [DEBUG] CMySQLConnection::Connect - connection was successful [19:48:09] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:48:09] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:48:09] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:48:09] [DEBUG] CMySQLConnection::Connect - connection was successful [19:48:09] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:48:09] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:48:09] [DEBUG] CMySQLConnection::Connect - connection was successful [19:48:09] [DEBUG] CMySQLConnection::Connect - connection was successful bled [19:48:09] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:48:43] [DEBUG] mysql_tquery - connection: 1, query: "SELECT id FROM user WHERE username='Blackshadow'", callback: "OnUserCheck", format: "d" [19:48:43] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - starting query execution [19:48:43] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - query was successfully executed within 0.504 milliseconds [19:48:43] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [19:48:43] [DEBUG] Calling callback "OnUserCheck".. [19:48:43] [DEBUG] cache_get_data - connection: 1 [19:48:43] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [19:48:46] [DEBUG] mysql_escape_string - source: "klom19pom", connection: 1, max_len: 35 [19:48:46] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE username='Blackshadow' AND passwort=MD5", callback: "OnPasswordResponse", format: "i" [19:48:46] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - starting query execution [19:48:46] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - query was successfully executed within 0.396 milliseconds [19:48:46] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [19:48:46] [DEBUG] Calling callback "OnPasswordResponse".. [19:48:46] [DEBUG] cache_get_data - connection: 1 [19:48:46] [DEBUG] cache_get_field_content_int - row: 0, field_name: "level", connection: 1 [19:48:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "level", data: "3" [19:48:46] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Adminlevel", connection: 1 [19:48:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Adminlevel", data: "12" [19:48:46] [DEBUG] cache_get_field_content_int - row: 0, field_name: "money", connection: 1 [19:48:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "money", data: "9994954" [19:48:46] [DEBUG] cache_get_field_content_int - row: 0, field_name: "id", connection: 1 [19:48:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "id", data: "0" [19:48:46] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM Autos WHERE Besitzer='0' ", callback: "OnPlayerCarsLoad", format: "i" [19:48:46] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [19:48:46] [DEBUG] CMySQLQuery::Execute[OnPlayerCarsLoad] - starting query execution [19:48:46] [DEBUG] CMySQLQuery::Execute[OnPlayerCarsLoad] - query was successfully executed within 0.403 milliseconds [19:48:46] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [19:48:46] [DEBUG] Calling callback "OnPlayerCarsLoad".. [19:48:46] [DEBUG] cache_get_data - connection: 1 [19:48:46] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [19:48:56] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO Autos (Besitzer, model, c_x, c_y, c_z, c_r) VALUES (", callback: " ", format: "(null)" [19:48:56] [DEBUG] CMySQLQuery::Execute[ ] - starting query execution [19:48:56] [ERROR] CMySQLQuery::Execute[ ] - (error #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 ''359.7481' at line 1 [19:48:56] [DEBUG] CMySQLQuery::Execute[ ] - error will be triggered in OnQueryError [19:49:02] [DEBUG] mysql_close - connection: 1 [19:49:02] [DEBUG] CMySQLConnection::Disconnect - connection was closed [19:49:02] [DEBUG] CMySQLConnection::Disconnect - connection was closed [19:49:02] [DEBUG] CMySQLConnection::Disconnect - connection was closed [19:49:02] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called [19:49:14] [DEBUG] mysql_connect - host: "25.3.164.220", user: "blackshadow", database: "test", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [19:49:14] [DEBUG] CMySQLHandle::Create - creating new connection.. [19:49:14] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [19:49:14] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [19:49:14] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:49:14] [DEBUG] CMySQLConnection::Connect - connection was successful [19:49:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:49:14] [DEBUG] mysql_tquery - connection: 1, query: "SELECT id FROM user WHERE username='Blackshadow'", callback: "OnUserCheck", format: "d" [19:49:14] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:49:14] [DEBUG] CMySQLConnection::Connect - connection was successful [19:49:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:49:14] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:49:14] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [19:49:14] [DEBUG] CMySQLConnection::Connect - connection was successful [19:49:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:49:14] [DEBUG] CMySQLConnection::Connect - connection was successful [19:49:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [19:49:14] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - starting query execution [19:49:14] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - query was successfully executed within 0.523 milliseconds [19:49:14] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [19:49:14] [DEBUG] Calling callback "OnUserCheck".. [19:49:14] [DEBUG] cache_get_data - connection: 1 [19:49:14] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [19:49:24] [DEBUG] mysql_escape_string - source: "klom19pom", connection: 1, max_len: 35 [19:49:24] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE username='Blackshadow' AND passwort=MD5", callback: "OnPasswordResponse", format: "i" [19:49:24] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - starting query execution [19:49:24] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - query was successfully executed within 0.382 milliseconds [19:49:24] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [19:49:24] [DEBUG] Calling callback "OnPasswordResponse".. [19:49:24] [DEBUG] cache_get_data - connection: 1 [19:49:24] [DEBUG] cache_get_field_content_int - row: 0, field_name: "level", connection: 1 [19:49:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "level", data: "3" [19:49:24] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Adminlevel", connection: 1 [19:49:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Adminlevel", data: "12" [19:49:24] [DEBUG] cache_get_field_content_int - row: 0, field_name: "money", connection: 1 [19:49:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "money", data: "9994954" [19:49:24] [DEBUG] cache_get_field_content_int - row: 0, field_name: "id", connection: 1 [19:49:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "id", data: "0" [19:49:24] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM Autos WHERE Besitzer='0' ", callback: "OnPlayerCarsLoad", format: "i" [19:49:24] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [19:49:24] [DEBUG] CMySQLQuery::Execute[OnPlayerCarsLoad] - starting query execution [19:49:24] [DEBUG] CMySQLQuery::Execute[OnPlayerCarsLoad] - query was successfully executed within 0.294 milliseconds [19:49:24] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [19:49:24] [DEBUG] Calling callback "OnPlayerCarsLoad".. [19:49:24] [DEBUG] cache_get_data - connection: 1 [19:49:24] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [19:49:32] [DEBUG] mysql_close - connection: 1 [19:49:32] [DEBUG] CMySQLConnection::Disconnect - connection was closed [19:49:32] [DEBUG] CMySQLConnection::Disconnect - connection was closed [19:49:32] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called
-
Zeige bitte den Code von dem INSERT INTO von den Autos. Da ist ein Fehler drin.
-
ocmd:autosetzen(playerid,params[])
{
if(!isAdmin(playerid,8)) return SendClientMessage(playerid,helbau,"Du hast nicht die passende Rechte dafür!");
new mID,pID;
if(sscanf(params,"ui",pID,mID))return SendClientMessage(playerid,helbau,"Benutze: /autosetzen [playerid] [model]");
if(mID<400||mID>611)return SendClientMessage(playerid,rot,"Ungültige Modelid!");
new Float:X,Float:Y,Float:Z,Float:R;
GetPlayerPos(pID,X,Y,Z);
GetPlayerFacingAngle(pID,R);
new string[128], string1[128];
format(string, sizeof(string), "INSERT INTO Autos (Besitzer, model, c_x, c_y, c_z, c_r) VALUES ('%i', '%i', '%f', '%f', '%f', '%f')",pID,mID,X,Y,Z,R);
format(string1, sizeof(string1), "Du hast erfolgreich das Auto mit der Model ID %d erstellt!", mID);
SendClientMessage(playerid, grün, string1);
CreateVehicle(mID, X, Y, Z, R, -1, -1, -1);
mysql_function_query(dbhandle,string,false," "," ");
return 1;
} -
new string[128], string1[128];
Zu
new string[256], string1[128];Der String für das query war zu kurz.
-
aber wieso:
muss ich es dann so:
new string[256], string1[128];
muss ich den zweiten string nicht auch auf 256 machen?
-
Mit dem zweiten String gibst du ja nur die Nachricht aus. Dafür könntest du aber auch den ersten String nehmen, dann sparst du dir den zweiten, wenn du die Reihenfolge etwas änderst.
-
Beitrag von Blackshadowscript ()
Dieser Beitrag wurde gelöscht, Informationen über den Löschvorgang sind nicht verfügbar. -
Log auszüge:
----------
Loaded log file: "server_log.txt".
----------SA-MP Dedicated Server
----------------------
v0.3z-R4, (C)2005-2014 SA-MP Team[20:29:41] filterscripts = "" (string)
[20:29:41]
[20:29:41] Server Plugins
[20:29:41] --------------
[20:29:41] Loading plugin: sscanf
[20:29:41][20:29:41] ===============================
[20:29:41] sscanf plugin loaded.
[20:29:41] (c) 2009 Alex "Y_Less" Cole
[20:29:41] 0.3d-R2 500 Players "dnee"
[20:29:41] ===============================
[20:29:41] Loaded.
[20:29:41] Loading plugin: mysql
[20:29:41] >> plugin.mysql: R39 successfully loaded.
[20:29:41] Loaded.
[20:29:41] Loaded 2 plugins.[20:29:41]
[20:29:41] Filterscripts
[20:29:41] ---------------
[20:29:41] Loaded 0 filterscripts.[20:29:41] Server wurde gestartet
[20:29:41] MYSQL verbindung aufgebaut!
[20:29:41]
----------------------------------
[20:29:41] Blackshadowscript
[20:29:41] ----------------------------------[20:29:41] Number of vehicle models: 0
[20:30:05] Incoming connection: 25.3.164.220:65521
[20:30:05] [join] Blackshadow has joined the server (0:25.3.164.220)
[20:30:05] num rows = 1
[20:30:25] Der Server wurde beendet
[20:30:37] Server wurde gestartet
[20:30:37] MYSQL verbindung aufgebaut!
[20:30:37]
----------------------------------
[20:30:37] Blackshadowscript
[20:30:37] ----------------------------------[20:30:37] Number of vehicle models: 0
[20:30:37] num rows = 1
[20:31:05] [part] Blackshadow has left the server (0:1)
[20:31:12] --- Server Shutting Down.
[20:31:12] Der Server wurde beendet
[20:31:12][20:31:12] ===============================
[20:31:12] sscanf plugin unloaded.
[20:31:12] ===============================
[20:31:12] plugin.mysql: Unloading plugin...
[20:31:12] plugin.mysql: Plugin unloaded.Mysql-Log:
SQL
Alles anzeigen[20:29:41] [DEBUG] mysql_connect - host: "25.3.164.220", user: "blackshadow", database: "test", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [20:29:41] [DEBUG] CMySQLHandle::Create - creating new connection.. [20:29:41] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [20:29:41] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [20:29:41] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:29:41] [DEBUG] CMySQLConnection::Connect - connection was successful [20:29:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:29:41] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:29:41] [DEBUG] CMySQLConnection::Connect - connection was successful database... [20:29:41] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:29:41] [DEBUG] CMySQLConnection::Connect - connection was successful [20:29:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:29:41] [DEBUG] CMySQLConnection::Connect - connection was successful [20:29:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:30:05] [DEBUG] mysql_tquery - connection: 1, query: "SELECT id FROM user WHERE username='Blackshadow'", callback: "OnUserCheck", format: "d" [20:30:05] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - starting query execution [20:30:05] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - query was successfully executed within 0.644 milliseconds [20:30:05] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [20:30:05] [DEBUG] Calling callback "OnUserCheck".. [20:30:05] [DEBUG] cache_get_data - connection: 1 [20:30:05] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [20:30:09] [DEBUG] mysql_escape_string - source: "klom19pom", connection: 1, max_len: 35 [20:30:09] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE username='Blackshadow' AND passwort=MD5", callback: "OnPasswordResponse", format: "i" [20:30:09] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - starting query execution [20:30:09] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - query was successfully executed within 0.365 milliseconds [20:30:09] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [20:30:09] [DEBUG] Calling callback "OnPasswordResponse".. [20:30:09] [DEBUG] cache_get_data - connection: 1 [20:30:09] [DEBUG] cache_get_field_content_int - row: 0, field_name: "level", connection: 1 [20:30:09] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "level", data: "3" [20:30:09] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Adminlevel", connection: 1 [20:30:09] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Adminlevel", data: "12" [20:30:09] [DEBUG] cache_get_field_content_int - row: 0, field_name: "money", connection: 1 [20:30:09] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "money", data: "9994954" [20:30:09] [DEBUG] cache_get_field_content_int - row: 0, field_name: "id", connection: 1 [20:30:09] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "id", data: "0" [20:30:09] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM Autos WHERE Besitzer='0' ", callback: "OnPlayerCarsLoad", format: "i" [20:30:09] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [20:30:09] [DEBUG] CMySQLQuery::Execute[OnPlayerCarsLoad] - starting query execution [20:30:09] [DEBUG] CMySQLQuery::Execute[OnPlayerCarsLoad] - query was successfully executed within 0.337 milliseconds [20:30:09] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [20:30:09] [DEBUG] Calling callback "OnPlayerCarsLoad".. [20:30:09] [DEBUG] cache_get_data - connection: 1 [20:30:09] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [20:30:18] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO Autos (Besitzer, model, c_x, c_y, c_z, c_r) VALUES (", callback: " ", format: "(null)" [20:30:18] [DEBUG] CMySQLQuery::Execute[ ] - starting query execution [20:30:18] [DEBUG] CMySQLQuery::Execute[ ] - query was successfully executed within 65.778 milliseconds [20:30:18] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [20:30:25] [DEBUG] mysql_close - connection: 1 [20:30:25] [DEBUG] CMySQLConnection::Disconnect - connection was closed [20:30:25] [DEBUG] CMySQLConnection::Disconnect - connection was closed [20:30:25] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called [20:30:37] [DEBUG] mysql_connect - host: "25.3.164.220", user: "blackshadow", database: "test", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [20:30:37] [DEBUG] CMySQLHandle::Create - creating new connection.. [20:30:37] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [20:30:37] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [20:30:37] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:30:37] [DEBUG] CMySQLConnection::Connect - connection was successful [20:30:37] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:30:37] [DEBUG] mysql_tquery - connection: 1, query: "SELECT id FROM user WHERE username='Blackshadow'", callback: "OnUserCheck", format: "d" [20:30:37] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:30:37] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:30:37] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:30:37] [DEBUG] CMySQLConnection::Connect - connection was successful [20:30:37] [DEBUG] CMySQLConnection::Connect - connection was successful [20:30:37] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:30:37] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:30:37] [DEBUG] CMySQLConnection::Connect - connection was successful [20:30:37] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:30:37] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - starting query execution [20:30:37] [DEBUG] CMySQLQuery::Execute[OnUserCheck] - query was successfully executed within 0.410 milliseconds [20:30:37] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [20:30:37] [DEBUG] Calling callback "OnUserCheck".. [20:30:37] [DEBUG] cache_get_data - connection: 1 [20:30:37] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [20:30:43] [DEBUG] mysql_escape_string - source: "klom19pom", connection: 1, max_len: 35 [20:30:43] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE username='Blackshadow' AND passwort=MD5", callback: "OnPasswordResponse", format: "i" [20:30:43] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - starting query execution [20:30:43] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - query was successfully executed within 0.385 milliseconds [20:30:43] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [20:30:43] [DEBUG] Calling callback "OnPasswordResponse".. [20:30:43] [DEBUG] cache_get_data - connection: 1 [20:30:43] [DEBUG] cache_get_field_content_int - row: 0, field_name: "level", connection: 1 [20:30:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "level", data: "3" [20:30:43] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Adminlevel", connection: 1 [20:30:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Adminlevel", data: "12" [20:30:43] [DEBUG] cache_get_field_content_int - row: 0, field_name: "money", connection: 1 [20:30:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "money", data: "9994954" [20:30:43] [DEBUG] cache_get_field_content_int - row: 0, field_name: "id", connection: 1 [20:30:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "id", data: "0" [20:30:43] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM Autos WHERE Besitzer='0' ", callback: "OnPlayerCarsLoad", format: "i" [20:30:43] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [20:30:43] [DEBUG] CMySQLQuery::Execute[OnPlayerCarsLoad] - starting query execution [20:30:43] [DEBUG] CMySQLQuery::Execute[OnPlayerCarsLoad] - query was successfully executed within 0.313 milliseconds [20:30:43] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [20:30:43] [DEBUG] Calling callback "OnPlayerCarsLoad".. [20:30:43] [DEBUG] cache_get_data - connection: 1 [20:30:43] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Besitzer", connection: 1 [20:30:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Besitzer", data: "0" [20:30:43] [DEBUG] cache_get_field_content_int - row: 0, field_name: "model", connection: 1 [20:30:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "model", data: "560" [20:30:43] [DEBUG] cache_get_field_content_float - row: 0, field_name: "c_x", connection: 1 [20:30:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "c_x", data: "370.472" [20:30:43] [DEBUG] cache_get_field_content_float - row: 0, field_name: "c_y", connection: 1 [20:30:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "c_y", data: "-2032.39" [20:30:43] [DEBUG] cache_get_field_content_float - row: 0, field_name: "c_z", connection: 1 [20:30:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "c_z", data: "7.67188" [20:30:43] [DEBUG] cache_get_field_content_float - row: 0, field_name: "c_r", connection: 1 [20:30:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "c_r", data: "0.688133" [20:30:43] [DEBUG] cache_get_field_content_int - row: 0, field_name: "id", connection: 1 [20:30:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "id", data: "80" [20:30:43] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [20:31:12] [DEBUG] mysql_close - connection: 1 [20:31:12] [DEBUG] CMySQLConnection::Disconnect - connection was closed [20:31:12] [DEBUG] CMySQLConnection::Disconnect - connection was closed [20:31:12] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called
-
Laut Log müsste das Fahrzeug jetzt gespawnt werden. Besteht noch ein Problem, oder ist es erledigt? Einen Error gibt es nämlich nicht mehr.
-
Die autos werden einfach nicht geladen. Autos werden ohne probs in die Datenbank-Tabelle: Autos gespeichert aber es wird einfach nicht ausgelesen aus der db die Autos
-
Was ich grade noch gesehen habe, in den ersten Posts:
AutoInfo[id][model]=cache_get_field_content_int(i,"Besitzer",dbhandle);
AutoInfo[id][Besitzer]=cache_get_field_content_int(i,"model",dbhandle);Das ist falsch rum. Du speicherst den Besitzer in die Model ID. Prüfe mal ob das noch immer so ist, wenn ja ändere es.
-
Vielen dank Jeffry.
Da ich nun autos laden kann wäre doch in demmoment besser wenn ich doch dann Motor/Licht System mache oder doch erst autohaus?
-
Gerne!
Ich persönlich würde erst mal das mit dem Motor/Licht machen, denn das brauchst du für das Autohaus System wahrscheinlich auch, dann wäre es ja gut, wenn du es schon hast. Wahrscheinlich ist es auch weniger Arbeit und fällt dir daher leichter. Aber das musst du machen, wie es dir liegt. -