Guten Tag.
Ich frage mich wie mache ich nun ein autopark befehl so das die autos in der DB abgespeichert werden?
Guten Tag.
Ich frage mich wie mache ich nun ein autopark befehl so das die autos in der DB abgespeichert werden?
Jacke_Bauer mal hier im beitrag auf seite 2 erster beitrag schauen:
Ich brauche hier beim System keine hilfe mehr
ja wurde es
Alles geht.
brauche keine hilfe Mehr
ocmd:autoabschliessen(playerid,params[])
{
new tmp_engine,
tmp_lights,
tmp_alarm,
tmp_doors,
tmp_bonnet,
tmp_boot,
tmp_objective;
// abschlissen
for(new i= 0; i<MAX_VEHICLES; i++)
{
new Float:vPos[3];
GetVehiclePos(i,vPos[0],vPos[1],vPos[2]);
if(IsPlayerInRangeOfPoint(playerid,3,vPos[0],vPos[1],vPos[2]))
GetVehicleParamsEx(i,tmp_engine,tmp_lights,tmp_alarm,VEHICLE_PARAMS_ON,tmp_bonnet,tmp_boot,tmp_objective);
if(tmp_doors==1){
tmp_doors= 0;
}else{
tmp_doors=1;
}
SetVehicleParamsEx(i,tmp_engine,tmp_lights,tmp_alarm,VEHICLE_PARAMS_ON,tmp_bonnet,tmp_boot,tmp_objective);
SendClientMessage(playerid,blau,"Auto wurde abgeschlossen/aufgeschlossen");
break;
}
return 1;
}
lernen.p(457) : error 035: argument type mismatch (argument 5)
also wenn ich /autoabschliessen benutze steht zwar aufgeschlossen/abgeschlossen aber kann dennoch ins auto
also ich habe es jetzt so wie du es gesagt hast:
ocmd:autoabschliessen(playerid,params[])
{
tmp_engine,
tmp_lights,
tmp_alarm,
tmp_doors,
tmp_bonnet,
tmp_boot,
tmp_objective;
// abschlissen
for(new i= 0; i<MAX_VEHICLES; i++)
{
new Float:vPos[3];
GetVehiclePos(i,vPos[0],vPos[1],vPos[2]);
if(IsPlayerInRangeOfPoint(playerid,3,vPos[0],vPos[1],vPos[2]))
GetVehicleParamsEx(i,tmp_engine,tmp_lights,tmp_alarm,tmp_doors,tmp_bonnet,tmp_boot,tmp_objective);
if(tmp_doors==1){
tmp_doors= 0;
}else{
tmp_doors=1;
}
SetVehicleParamsEx(i,tmp_engine,tmp_lights,tmp_alarm,tmp_doors,tmp_bonnet,tmp_boot,tmp_objective);
SendClientMessage(playerid,blau,"Auto wurde abgeschlossen/aufgeschlossen");
break;
}
return 1;
}
dann kommen aber diese fehler und wanings:
lernen.p(444) : error 017: undefined symbol "tmp_engine"
lernen.p(444 -- 450) : warning 215: expression has no effect
lernen.p(457) : error 017: undefined symbol "tmp_engine"
lernen.p(458) : error 017: undefined symbol "tmp_doors"
lernen.p(459) : error 017: undefined symbol "tmp_doors"
lernen.p(459) : warning 215: expression has no effect
lernen.p(461) : error 017: undefined symbol "tmp_doors"
lernen.p(461) : warning 215: expression has no effect
lernen.p(463) : error 017: undefined symbol "tmp_engine"
ich habe es jetzt so gemacht:
ocmd:autoabschliessen(playerid,params[])
{
new vID=GetPlayerVehicleID(playerid),
tmp_engine,
tmp_lights,
tmp_alarm,
tmp_doors,
tmp_bonnet,
tmp_boot,
tmp_objective;
// abschlissen
for(new i= 0; i<MAX_VEHICLES; i++)
{
new Float:vPos[3];
GetVehiclePos(i,vPos[0],vPos[1],vPos[2]);
if(IsPlayerInRangeOfPoint(playerid,3,vPos[0],vPos[1],vPos[2]))
break;
}
GetVehicleParamsEx(vID,tmp_engine,tmp_lights,tmp_alarm,tmp_doors,tmp_bonnet,tmp_boot,tmp_objective);
if(tmp_doors==1){
tmp_doors= 0;
}else{
tmp_doors=1;
}
SetVehicleParamsEx(vID,tmp_engine,tmp_lights,tmp_alarm,tmp_doors,tmp_bonnet,tmp_boot,tmp_objective);
SendClientMessage(playerid,blau,"Auto wurde abgeschlossen/aufgeschlossen");
return 1;
}
aber ich könnte doch auch so wie ich es gemacht habe einfach nur
GetVehiclePos(i, vPos[0], vPos[1], vPos[2]);
if(IsPlayerInRangeOfPoint(playerid, 3, vPos[0], vPos[1], vPos[2])){
//Der Spieler ist an Fahrzeug mit der ID i und daher kann es abgeschlossen werden. Vorher muss natürlich noch die Legitimation, das Fahrzeug abzuschließen, geprüft werden.
break;
machen in den ocmd befehl oder?
wie meinst das mit Diebstahlalarm?
Guten Tag.
Ich habe eine frage:
Geht das Motor/Lichtsystem auch einfacher als:
ocmd:autostarten(playerid,params[])
{
if(GetPlayerState(playerid)!=PLAYER_STATE_DRIVER)return SendClientMessage(playerid,dunkelgrün,"Du bist nicht der Fahrer eines Fahrzeuges!");
new vID=GetPlayerVehicleID(playerid),
tmp_engine,
tmp_lights,
tmp_alarm,
tmp_doors,
tmp_bonnet,
tmp_boot,
tmp_objective;
//autostarten
GetVehicleParamsEx(vID,tmp_engine,tmp_lights,tmp_alarm,tmp_doors,tmp_bonnet,tmp_boot,tmp_objective);
if(tmp_engine==1){
tmp_engine= 0;
}else{
tmp_engine=1;
}
SetVehicleParamsEx(vID,tmp_engine,tmp_lights,tmp_alarm,tmp_doors,tmp_bonnet,tmp_boot,tmp_objective);
SendClientMessage(playerid,grau,"Auto wurde gestartet!");
return 1;
}
ocmd:licht(playerid,params[])
{
if(GetPlayerState(playerid)!=PLAYER_STATE_DRIVER)return SendClientMessage(playerid,dunkelgrün,"Du bist nicht der Fahrer eines Fahrzeuges!");
new vID=GetPlayerVehicleID(playerid),
tmp_engine,
tmp_lights,
tmp_alarm,
tmp_doors,
tmp_bonnet,
tmp_boot,
tmp_objective;
//autostarten
GetVehicleParamsEx(vID,tmp_engine,tmp_lights,tmp_alarm,tmp_doors,tmp_bonnet,tmp_boot,tmp_objective);
if(tmp_lights==1){
tmp_lights= 0;
}else{
tmp_lights=1;
}
SetVehicleParamsEx(vID,tmp_engine,tmp_lights,tmp_alarm,tmp_doors,tmp_bonnet,tmp_boot,tmp_objective);
SendClientMessage(playerid,grau,"Licht wurde eingeschalten!");
return 1;
}
2 Frage:
Ich habe es zwar geschafft Auto abschlissen zu lassen nur die frage ist wie kann ich es auserhalb des Fahrzeuges machen?
ocmd:autoabschliessen(playerid,params[])
{
if(GetPlayerState(playerid)!=PLAYER_STATE_DRIVER)return SendClientMessage(playerid,dunkelgrün,"Du bist nicht der Fahrer eines Fahrzeuges!");
new vID=GetPlayerVehicleID(playerid),
tmp_engine,
tmp_lights,
tmp_alarm,
tmp_doors,
tmp_bonnet,
tmp_boot,
tmp_objective;
//autostarten
GetVehicleParamsEx(vID,tmp_engine,tmp_lights,tmp_alarm,tmp_doors,tmp_bonnet,tmp_boot,tmp_objective);
if(tmp_doors==1){
tmp_doors= 0;
}else{
tmp_doors=1;
}
SetVehicleParamsEx(vID,tmp_engine,tmp_lights,tmp_alarm,tmp_doors,tmp_bonnet,tmp_boot,tmp_objective);
SendClientMessage(playerid,grau,"Auto wurde abgeschlossen/aufgeschlossen");
return 1;
}
3Frage: Für was ist das alarm bei: SetVehicleParamsEx ?
Ich schlage vor den Samp Map construction zu benutzen
Ich weiss nicht wie ich anfangen soll für das Licht/Motorsystem
poste den code
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?
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
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:
[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
Alles anzeigen
aber wieso:
muss ich es dann so:
new string[256], string1[128];
muss ich den zweiten string nicht auch auf 256 machen?
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;
}
----------
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.
[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
Alles anzeigen