Gudde,
Kurze Frage wie kann ich am besten machen wer LetzterFahrer war vom Fahrzeug?
Das muss halt nur solange sein wielange der Letzte Fahrer online ist dann wird zurück gesetzt auf "Niemand"
Ansonst z.b Ich (ID: 45)
4 you: GetVehicleLastDriver
Gudde,
Kurze Frage wie kann ich am besten machen wer LetzterFahrer war vom Fahrzeug?
Das muss halt nur solange sein wielange der Letzte Fahrer online ist dann wird zurück gesetzt auf "Niemand"
Ansonst z.b Ich (ID: 45)
4 you: GetVehicleLastDriver
stock ShowPlayerCarkeys(playerid, type) {
new string[248] = "Fahrzeug\tFarbe\tDetails\tFahrzeug-ID";
for( new i = 0; i < MaxVehicles(playerid); i++) {
if(PlayerCar[playerid][i][CarModel] >= 400 && PlayerCar[playerid][i][CarModel] <= 611) {
new funcmodel = (PlayerCar[playerid][i][CarModel]-400);
format(string, sizeof(string), "%s\n\%s\t%d / %d\t\t%d\n", string, CarName[funcmodel], PlayerCar[playerid][i][vehColor1], PlayerCar[playerid][i][vehColor2], PlayerCar[playerid][i][CarId]);
if(PlayerCar[playerid][i][vehAbgeschleppt] == 1) {
format(string, sizeof(string), "%s\n\%s\n%s\t%d / %d\t{AA3333}(Verwahrstelle)\t{FFFFFF}%d\n", string, CarName[funcmodel], PlayerCar[playerid][i][vehColor1], PlayerCar[playerid][i][vehColor2], PlayerCar[playerid][i][CarId]);
}
} else {
string = "{FFFFFF}--\n";
}
if( i == 0 ) {
DialogString = "";
}
format(DialogString, sizeof(DialogString), "%s%s", DialogString, string);
}
ShowPlayerDialog(playerid, type == CARKEY_TYPE_NORMAL ? DIALOG_CARKEY : (type == CARKEY_TYPE_MOVE1 ? DIALOG_MOVECARKEY1 : DIALOG_MOVECARKEY2), DIALOG_STYLE_TABLIST_HEADERS, "Fahrzeugschlüssel", DialogString, "OK", "Abbrechen");
return 1;
}
Alles anzeigen
Dr. Frauenarzt hatte dir schon mal gesagt, nutze keinen globalen Dialog-String, das bringt nur Ärger.
Den Code musst du nur etwas schöner formatieren:
stock ShowPlayerCarkeys(playerid, type)
{
new string[512] = "Fahrzeug\tFarbe\tDetails\tFahrzeug-ID";
for(new i,m; i < MaxVehicles(playerid); i++)
{
m = PlayerCar[playerid][i][CarModel]-400;
if(m >= 0 && m <= 211)
{
format(string, sizeof(string), "%s\n%s\t%d / %d\t%s\t%d", string,
CarName[m],
PlayerCar[playerid][i][vehColor1],
PlayerCar[playerid][i][vehColor2],
((PlayerCar[playerid][i][vehAbgeschleppt]==1)?("{AA3333}(Verwahrstelle)"):(" ")),
PlayerCar[playerid][i][CarId]);
}
else strcat(string,"\n{FFFFFF}--");
}
ShowPlayerDialog(playerid, type == CARKEY_TYPE_NORMAL ? DIALOG_CARKEY : (type == CARKEY_TYPE_MOVE1 ? DIALOG_MOVECARKEY1 : DIALOG_MOVECARKEY2), DIALOG_STYLE_TABLIST_HEADERS, "Fahrzeugschlüssel", string, "OK", "Abbrechen");
return 1;
}
Alles anzeigen
Ich möchte eine Leader Liste Ingame erstellen die auslesen tut wieviele Leader es gibt und wer alles Leader einer Fraktion ist.
ocmd:leadertest(playerid)
{
new query[160], string[1700];
if(SpielerInfo[playerid][sFraktion] > 0 || SpielerInfo[playerid][sRank] >= 7)
{
format(string,sizeof(string),"%s: %s\n%s",FrakName(SpielerInfo[playerid][sFraktion]),SpielerInfo[playerid][sName],string);
ShowPlayerDialog(playerid,DIALOG_LEADERS,DIALOG_STYLE_MSGBOX,"Leader Liste",string,"Verlassen","");
}
format(query, sizeof(query), "SELECT `Name`, `Level`, `Fraktion` FROM `accounts` WHERE `Fraktion` > 0 ORDER BY `Fraktion` DESC LIMIT 0,30", SpielerInfo[playerid][sFraktion]);
mysql_query(string);
mysql_store_result();
return 1;
}
Alles anzeigen
Alles anzeigenguten morgen,ich habe der problem das ich nicht einlogen kann und mein leben auf 0 ist. registieren geht ohne problemaber mit einlogen nicht.
script
CAlles anzeigen#include <a_samp> #include <a_mysql> #include <md5> //MYSL DATEN #define MYSQL_HOST "127.0.0.1" #define MYSQL_USER "root" #define MYSQL_DATA "selfmade" #define MYSQL_PASS "" new Handle; enum playerInfo{ db_id, pEingeloggt, pNeuling, pAlter, pGeschlecht, pSkin, Float:pRussi, Float:pLeben }; new pInfo[MAX_PLAYERS][playerInfo]; //DIALOGE #define DIALOG_REGISTER 1 #define DIALOG_CHAR1 2 #define DIALOG_CHAR2 3 #define DIALOG_CHAR3 4 #define DIALOG_LOGIN 5 #define DIALOG_LOGINT 6 //Farben #define geld 0xFFFF00FF #define weiss 0xFFFFFFFF //news new Logintest[MAX_PLAYERS]; main() { print("\n----------------------------------"); print(" selfmade by kevin"); print("----------------------------------\n"); } public OnGameModeInit() { SetGameModeText("Selfmade v0,0,0"); //MYSQL Verbindung Handle=mysql_connect (MYSQL_HOST,MYSQL_USER,MYSQL_DATA,MYSQL_PASS); if (mysql_errno() <1) print ("MYSQL: Die Verbindung war erfolgreich!"), mysql_log (LOG_ALL);else print ("MYSQL: Die Verbindung konnte nicht hergestellt werden! | Server wirt herundergefahren!"), SendRconCommand ("exit"); return 1; } public OnGameModeExit() { return 1; } public OnPlayerRequestClass(playerid, classid) { SetSpawnInfo(playerid,0,0,0,0,0,0,0,0,0,0,0,0); SpawnPlayer(playerid); return 1; } public OnPlayerConnect(playerid) { new query [256]; mysql_format (Handle, query, sizeof (query), "SELECT * FROM user WHERE Username='%e'",Spielername(playerid)); mysql_tquery(Handle,query,"UserCheck","i",playerid); ClearChat(playerid); TogglePlayerSpectating(playerid,1); //news auf 0 Logintest[playerid]=0; return 1; } public OnPlayerDisconnect(playerid, reason) { SpielerSpeichern(playerid); return 1; } public OnPlayerSpawn(playerid) { SetPlayerVirtualWorld(playerid,0); SetCameraBehindPlayer(playerid); TogglePlayerControllable(playerid,1); if(pInfo[playerid][pNeuling]==1) { ClearChat(playerid); SendClientMessage(playerid,geld,"Herzlich Willkommen!"); SetPlayerPos(playerid,858.8041,-1655.6134,13.5523); SetPlayerFacingAngle(playerid,1.0462); pInfo[playerid][pNeuling]=0; pInfo[playerid][pLeben]=100; if(pInfo[playerid][pGeschlecht]==1) { SetPlayerSkin(playerid,60); } else { SetPlayerSkin(playerid,40); } GameTextForPlayer(playerid,"~y~Wilkommen ~n~auf ~n~Den besten ~g~Sever",6000,4); SpielerSpeichern(playerid); } else { SendClientMessage(playerid,geld,"Willkommen Zurück!"); SetPlayerPos(playerid,858.8041,-1655.6134,13.5523); SetPlayerFacingAngle(playerid,1.0462); if(pInfo[playerid][pGeschlecht]==1) { SetPlayerSkin(playerid,60); } else { SetPlayerSkin(playerid,40); } } SetPlayerColor(playerid,0xF3F3F3FF); return 1; } public OnPlayerDeath(playerid, killerid, reason) { return 1; } public OnVehicleSpawn(vehicleid) { return 1; } public OnVehicleDeath(vehicleid, killerid) { return 1; } public OnPlayerText(playerid, text[]) { return 1; } public OnPlayerCommandText(playerid, cmdtext[]) { if (strcmp("/mycommand", cmdtext, true, 10) == 0) { // Do something here return 1; } return 0; } public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger) { return 1; } public OnPlayerExitVehicle(playerid, vehicleid) { return 1; } public OnPlayerStateChange(playerid, newstate, oldstate) { return 1; } public OnPlayerEnterCheckpoint(playerid) { return 1; } public OnPlayerLeaveCheckpoint(playerid) { return 1; } public OnPlayerEnterRaceCheckpoint(playerid) { return 1; } public OnPlayerLeaveRaceCheckpoint(playerid) { return 1; } public OnRconCommand(cmd[]) { return 1; } public OnPlayerRequestSpawn(playerid) { return 1; } public OnObjectMoved(objectid) { return 1; } public OnPlayerObjectMoved(playerid, objectid) { return 1; } public OnPlayerPickUpPickup(playerid, pickupid) { return 1; } public OnVehicleMod(playerid, vehicleid, componentid) { return 1; } public OnVehiclePaintjob(playerid, vehicleid, paintjobid) { return 1; } public OnVehicleRespray(playerid, vehicleid, color1, color2) { return 1; } public OnPlayerSelectedMenuRow(playerid, row) { return 1; } public OnPlayerExitedMenu(playerid) { return 1; } public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid) { return 1; } public OnPlayerKeyStateChange(playerid, newkeys, oldkeys) { return 1; } public OnRconLoginAttempt(ip[], password[], success) { return 1; } public OnPlayerUpdate(playerid) { return 1; } public OnPlayerStreamIn(playerid, forplayerid) { return 1; } public OnPlayerStreamOut(playerid, forplayerid) { return 1; } public OnVehicleStreamIn(vehicleid, forplayerid) { return 1; } public OnVehicleStreamOut(vehicleid, forplayerid) { return 1; } public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) { //mysql dialogen if(dialogid == DIALOG_REGISTER) { if(!response)return Kick(playerid); SetPVarString(playerid,"passwortvar",inputtext); if(strlen(inputtext) >=4) { ShowPlayerDialog(playerid,DIALOG_CHAR1,DIALOG_STYLE_MSGBOX,"{00FFFA}Charackter 1/3","{FFFFFF}Welches Geschlecht bist du?","{00FFFA}Männlich","{00FFFA}Weiblich"); } else { ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"{00FFFA}Neuanfang","{00FFFA}Herzlich Willkommen{FFFFFF},\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}\n auf unseren Server bitte geben ein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen"); } } if(dialogid == DIALOG_CHAR1) { if(response) { //männ pInfo[playerid][pGeschlecht]=1; ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen"); } else { //weib pInfo[playerid][pGeschlecht]=2; ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen"); } } if(dialogid == DIALOG_CHAR2) { if(response) { if(listitem==0) { ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen"); } if(listitem==1) { Kick(playerid); } if(listitem==2) { Kick(playerid); } if(listitem==3) { ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen"); } } else {Kick (playerid);} } if(dialogid == DIALOG_CHAR3) { if(response) { if(IsNummeric(inputtext)) { //new alterabfrage=strval(inputtext); if(strval(inputtext)>=18 && strval(inputtext) <=48) { pInfo[playerid][pAlter]=strval(inputtext); pInfo[playerid][pEingeloggt]=1; pInfo[playerid][pNeuling]=1; new query [256],passworteingabe[128]; GetPVarString(playerid,"passwortvar",passworteingabe,128); mysql_format(Handle, query, sizeof(query), "INSERT INTO user (Username, Passwort) VALUES ('%e',MD5('%e'))",Spielername(playerid),passworteingabe); mysql_function_query(Handle,query,true,"OnPlayerRegister","i",playerid); printf("%s",query); } else { ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen"); } } else { ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen"); } } else {Kick (playerid);} } if(dialogid == DIALOG_LOGIN) { if(!response)return Kick(playerid); new query[256]; mysql_format(Handle,query,sizeof(query),"SELECT * user FROM WHERE Username='%e'AND Passwort=MD5('%e')",Spielername(playerid),inputtext); mysql_tquery(Handle,query,"OnPassordResponse","i",playerid); return 1; } return 1; } public OnPlayerClickPlayer(playerid, clickedplayerid, source) { return 1; } //OnPlayerRegister forward OnPlayerRegister(playerid); public OnPlayerRegister(playerid) { pInfo[playerid][db_id]=cache_insert_id(Handle); TogglePlayerSpectating(playerid,0); SpawnPlayer(playerid); SetCameraBehindPlayer(playerid); return 1; } //User-Check forward UserCheck(playerid); public UserCheck(playerid) { new num_rows, num_fields; cache_get_data(num_rows,num_fields,Handle); SetPlayerVirtualWorld(playerid,1); if(num_rows == 0) { //reg ClearChat(playerid); ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"{00FFFA}Neuanfang","{00FFFA}Herzlich Willkommen{FFFFFF},\n auf unseren Server bitte geben ein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen"); } else { //log ClearChat(playerid); ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"{00FFFA}Einloggen","{00FFFA}Willkommen Zurück{FFFFFF},\n auf unseren Server bitte geben Dein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen"); } return 1; } //für login forward OnPasswordResponse(playerid); public OnPasswordResponse(playerid) { new num_fields,num_rows; cache_get_data(num_rows,num_fields); if(num_rows==0) { //Passwort Falsch Logintest[playerid]+=1; new string [250]; format(string,sizeof(string),"{00FFFA}Einloggen {FF0005}[%d/3]",Logintest[playerid]); if(Logintest[playerid]>=3) { ShowPlayerDialog(playerid,DIALOG_LOGINT,DIALOG_STYLE_MSGBOX,"{FF0005}Fehler","{FF0005}Maximale {FFFFFF}Versuche verbraucht sie werden aus sicherheits gründen von Server entfernt!","{FF0005}Okay",""); return SetTimerEx("KickHackInfo",1000,false,"i",playerid); } else { ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,string,"{00FFFA}Willkommen Zurück{FFFFFF},\n auf unseren Server bitte geben Dein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen"); } } else { //Passwort Richtig SendClientMessage(playerid,geld,"Erfolgreich Eingeloggt"); LoadAccount(playerid); } return 1; } //LoadAccount stock LoadAccount(playerid) { pInfo[playerid][db_id]=cache_get_field_content_int(0,"ID",Handle); pInfo[playerid][pEingeloggt]=1; pInfo[playerid][pAlter]=cache_get_field_content_int(0,"Alter",Handle); pInfo[playerid][pGeschlecht]=cache_get_field_content_int(0,"Geschlecht",Handle); pInfo[playerid][pSkin]=cache_get_field_content_int(0,"Skin",Handle); pInfo[playerid][pNeuling]=cache_get_field_content_int(0,"Neuling",Handle); pInfo[playerid][pLeben]=cache_get_field_content_float(0,"Leben",Handle); pInfo[playerid][pRussi]=cache_get_field_content_float(0,"Russi",Handle); SetPlayerHealth(playerid,pInfo[playerid][pLeben]); SetPlayerArmour(playerid,pInfo[playerid][pRussi]); SpawnPlayer(playerid); TogglePlayerSpectating(playerid,0); SetCameraBehindPlayer(playerid); return 1; } //SpielerSpeichern stock SpielerSpeichern(playerid) { if(pInfo[playerid][pEingeloggt]!=1)return 1; if(IsPlayerNPC(playerid))return 1; GetPlayerHealth(playerid,pInfo[playerid][pLeben]); GetPlayerArmour(playerid,pInfo[playerid][pRussi]); new query[256]; mysql_format(Handle,query,sizeof (query),"Update `user` Set `Skin`='%d',`Alter`='%d',`Geschlecht`='%d',`Neuling`='%d',`Leben`='%.0f',`Russi`='%.0f' WHERE `ID`='%i'",GetPlayerSkin(playerid), pInfo[playerid][pAlter], pInfo[playerid][pGeschlecht],pInfo[playerid][pNeuling],pInfo[playerid][pLeben],pInfo[playerid][pRussi],pInfo[playerid][db_id]); mysql_pquery(Handle,query,"",""); printf("%s",query); pInfo[playerid][pEingeloggt]=0; return 1; } //KickHackInfo forward KickHackInfo(playerid); public KickHackInfo(playerid) { return Kick(playerid); } //Spielername stock Spielername(playerid) { new name[MAX_PLAYER_NAME]; GetPlayerName(playerid,name,MAX_PLAYER_NAME); return name; } //Clear-Chat stock ClearChat(playerid) { for(new i = 0;i<100;i++) { SendClientMessage(playerid,weiss,""); } return 1; } //IsNummeric stock IsNummeric(string[]) { for(new i=0,j=strlen(string);i<j;i++) { if((string[i] > '9' || string[i] < '0'))return 0; } return 1; }Server-Log
CodeAlles anzeigenSA-MP Dedicated Server ---------------------- v0.3.7-R2, (C)2005-2015 SA-MP Team [08:07:19] [08:07:19] Server Plugins [08:07:19] -------------- [08:07:19] Loading plugin: streamer [08:07:19] *** Streamer Plugin v2.9.4 by Incognito loaded *** [08:07:19] Loaded. [08:07:19] Loading plugin: mysql [08:07:19] >> plugin.mysql: R39-3 successfully loaded. [08:07:19] Loaded. [08:07:19] Loaded 2 plugins. [08:07:19] [08:07:19] Filterscripts [08:07:19] --------------- [08:07:19] Loading filterscript 'samplife-mapps.amx'... [08:07:19] Server Objecte werden geladen [08:07:19] 0 Gemappte Objecte Geladen [08:07:19] Loaded 1 filterscripts. [08:07:19] MYSQL: Die Verbindung war erfolgreich! [08:07:19] ---------------------------------- [08:07:19] selfmade by kevin [08:07:19] ---------------------------------- [08:07:19] Number of vehicle models: 0 [08:08:52] [connection] 127.0.0.1:64023 requests connection cookie. [08:08:53] [connection] incoming connection: 127.0.0.1:64023 id: 0 [08:08:53] [join] ShadowKev1999 has joined the server (0:127.0.0.1) [08:09:13] INSERT INTO user (Username, Passwort) VALUES ('ShadowKev1999',MD5('kevin7372')) [08:09:13] Update `user` Set `Skin`='60',`Alter`='20',`Geschlecht`='1',`Neuling`='0',`Leben`='0',`Russi`='0' WHERE `ID`='0' [08:09:20] [part] ShadowKev1999 has left the server (0:1) [08:09:56] [connection] 127.0.0.1:53304 requests connection cookie. [08:09:57] [connection] incoming connection: 127.0.0.1:53304 id: 0 [08:09:57] [join] ShadowKev1999 has joined the server (0:127.0.0.1) [08:10:15] [part] ShadowKev1999 has left the server (0:1) Console input: gmx [08:10:46] MYSQL: Die Verbindung war erfolgreich! [08:10:46] ---------------------------------- [08:10:46] selfmade by kevin [08:10:46] ---------------------------------- [08:10:46] Number of vehicle models: 0 [08:12:18] [connection] 127.0.0.1:56461 requests connection cookie. [08:12:19] [connection] 127.0.0.1:56461 requests connection cookie. [08:12:20] [connection] incoming connection: 127.0.0.1:56461 id: 0 [08:12:21] [join] ShadowKev1999 has joined the server (0:127.0.0.1) [08:12:37] [part] ShadowKev1999 has left the server (0:1)
mysql-log
CodeAlles anzeigen[08:03:40] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [08:03:40] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [08:03:40] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [08:03:40] [DEBUG] CMySQLConnection::Connect - connection was successful [08:03:40] [DEBUG] CMySQLConnection::Connect - connection was successful [08:03:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [08:03:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [08:03:41] [DEBUG] CMySQLConnection::Connect - connection was successful [08:03:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [08:05:41] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "selfmade", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [08:05:41] [DEBUG] CMySQLHandle::Create - creating new connection.. [08:05:41] [WARNING] CMySQLHandle::Create - connection already exists [08:05:41] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [08:05:41] [DEBUG] CMySQLConnection::Connect - connection was successful [08:05:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [08:05:41] [DEBUG] mysql_errno - connection: 1 [08:05:41] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [08:05:41] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [08:05:41] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [08:05:41] [DEBUG] CMySQLConnection::Connect - connection was successful [08:05:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [08:05:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [08:05:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [08:07:19] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [08:07:19] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [08:07:19] [DEBUG] CMySQLConnection::Connect - connection was successful [08:07:19] [DEBUG] CMySQLConnection::Connect - connection was successful [08:07:19] [DEBUG] CMySQLConnection::Connect - connection was successful [08:07:19] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [08:07:19] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [08:08:53] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e'" [08:08:53] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='ShadowKev1999'", callback: "UserCheck", format: "i" [08:08:53] [DEBUG] CMySQLQuery::Execute[UserCheck] - starting query execution [08:08:53] [DEBUG] CMySQLQuery::Execute[UserCheck] - query was successfully executed within 0.737 milliseconds [08:08:53] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [08:08:53] [DEBUG] Calling callback "UserCheck".. [08:08:53] [DEBUG] cache_get_data - connection: 1 [08:08:53] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [08:09:13] [DEBUG] mysql_format - connection: 1, len: 256, format: "INSERT INTO user (Username, Passwort) VALUES ('%e',MD5('%e'))" [08:09:13] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO user (Username, Passwort) VALUES ('ShadowKev1999',MD", callback: "OnPlayerRegister", format: "i" [08:09:13] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - starting query execution [08:09:13] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - query was successfully executed within 21.49 milliseconds [08:09:13] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [08:09:13] [DEBUG] Calling callback "OnPlayerRegister".. [08:09:13] [DEBUG] cache_insert_id - connection: 1 [08:09:13] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [08:09:13] [DEBUG] mysql_format - connection: 1, len: 256, format: "Update `user` Set `Skin`='%d',`Alter`='%d',`Geschlecht`='%d',`Neuling`='%d',`Leben`='%.0f',`Russi`='%.0f' WHERE `ID`='%i'" [08:09:13] [DEBUG] mysql_pquery - connection: 1, query: "Update `user` Set `Skin`='60',`Alter`='20',`Geschlecht`='1',`Neu", callback: "(null)", format: "(null)" [08:09:13] [DEBUG] CMySQLQuery::Execute[] - starting query execution [08:09:13] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 28.804 milliseconds [08:09:13] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving [08:09:57] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e'" [08:09:57] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='ShadowKev1999'", callback: "UserCheck", format: "i" [08:09:57] [DEBUG] CMySQLQuery::Execute[UserCheck] - starting query execution [08:09:57] [DEBUG] CMySQLQuery::Execute[UserCheck] - query was successfully executed within 0.432 milliseconds [08:09:57] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [08:09:57] [DEBUG] Calling callback "UserCheck".. [08:09:57] [DEBUG] cache_get_data - connection: 1 [08:09:57] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [08:10:05] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * user FROM WHERE Username='%e'AND Passwort=MD5('%e')" [08:10:05] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * user FROM WHERE Username='ShadowKev1999'AND Passwort=MD", callback: "OnPassordResponse", format: "i" [08:10:05] [DEBUG] CMySQLQuery::Execute[OnPassordResponse] - starting query execution [08:10:05] [ERROR] CMySQLQuery::Execute[OnPassordResponse] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'user FROM WHERE Username='ShadowKev1999'AND Passwort=MD5('kevin7372')' at line 1 [08:10:05] [DEBUG] CMySQLQuery::Execute[OnPassordResponse] - error will be triggered in OnQueryError [08:10:46] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "selfmade", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [08:10:46] [DEBUG] CMySQLHandle::Create - creating new connection.. [08:10:46] [WARNING] CMySQLHandle::Create - connection already exists [08:10:46] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [08:10:46] [DEBUG] CMySQLConnection::Connect - connection was successful [08:10:46] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [08:10:46] [DEBUG] mysql_errno - connection: 1 [08:10:46] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [08:10:46] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [08:10:46] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [08:10:46] [DEBUG] CMySQLConnection::Connect - connection was successful [08:10:46] [DEBUG] CMySQLConnection::Connect - connection was successful [08:10:46] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [08:10:46] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [08:12:21] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e'" [08:12:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='ShadowKev1999'", callback: "UserCheck", format: "i" [08:12:21] [DEBUG] CMySQLQuery::Execute[UserCheck] - starting query execution [08:12:21] [DEBUG] CMySQLQuery::Execute[UserCheck] - query was successfully executed within 0.635 milliseconds [08:12:21] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [08:12:21] [DEBUG] Calling callback "UserCheck".. [08:12:21] [DEBUG] cache_get_data - connection: 1 [08:12:21] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [08:12:29] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * user FROM WHERE Username='%e'AND Passwort=MD5('%e')" [08:12:29] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * user FROM WHERE Username='ShadowKev1999'AND Passwort=MD", callback: "OnPassordResponse", format: "i" [08:12:29] [DEBUG] CMySQLQuery::Execute[OnPassordResponse] - starting query execution [08:12:29] [ERROR] CMySQLQuery::Execute[OnPassordResponse] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'user FROM WHERE Username='ShadowKev1999'AND Passwort=MD5('kevin7372')' at line 1 [08:12:29] [DEBUG] CMySQLQuery::Execute[OnPassordResponse] - error will be triggered in OnQueryError
kann mir nicht einer helfen? 
kann mir nicht einer helfen
AKA Zeile 381 [tt]mysql_format(Handle,query,sizeof(query),"SELECT * FROM user WHERE Username='%e'AND Passwort=MD5('%e')",Spielername(playerid),inputtext);/tt]
Ich möchte eine Leader Liste Ingame erstellen die auslesen tut wieviele Leader es gibt und wer alles Leader einer Fraktion ist.
Als erstes ist die Frage ob nur, die angezeigt werden sollen, die online sind oder auch die die offline sind.
Wenn nur online:
- Schleife durch alle Spieler die Online sind
- Abfragen ob Rank >= 7 && Fraktion != 0
- Im Dialog o.Ä. ausgeben
Wenn auch offline:
- Bei deiner bestehenden Query ein Callback angeben
- Dort den cache auslesen und wie oben (Wenn nur offline) vorgehen.
- [08:10:05] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * user FROM WHERE Username='%e'AND Passwort=MD5('%e')"
- [08:10:05] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * user FROM WHERE Username='ShadowKev1999'AND Passwort=MD", callback: "OnPassordResponse", format: "i"
- [08:10:05] [DEBUG] CMySQLQuery::Execute[OnPassordResponse] - starting query execution
- [08:10:05] [ERROR] CMySQLQuery::Execute[OnPassordResponse] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'user FROM WHERE Username='ShadowKev1999'AND Passwort=MD5('kevin7372')' at line 1
AKA Zeile 381 [tt]mysql_format(Handle,query,sizeof(query),"SELECT * FROM user WHERE Username='%e'AND Passwort=MD5('%e')",Spielername(playerid),inputtext);/tt]
entschuldige aber verstehe nicht.
ich habe das so wie im der video
entschuldige aber verstehe nicht.
ich habe das so wie im der video
Hab das Video nicht geschaut, jedoch ist dies einfaches SQL SELECT [DATEN] FROM [DATABASE] WHERE [DATEN]
Hab das Video nicht geschaut, jedoch ist dies einfaches SQL SELECT [DATEN] FROM [DATABASE] WHERE [DATEN]
mysql_format(Handle, query, sizeof(query), "INSERT INTO user (Username, Passwort) VALUES ('%e',MD5('%e'))",Spielername(playerid),passworteingabe);
entschuldige,ich stehe auf den schlau,wie mache ich am besten?
Zeile 381
ändern zu
mysql_format(Handle,query,sizeof(query),"SELECT * FROM user WHERE Username='%e'AND Passwort=MD5('%e')",Spielername(playerid),inputtext);
ändern zu
jetzt speichert er net mehr.
if(dialogid == DIALOG_CHAR3)
{
if(response)
{
if(IsNummeric(inputtext))
{
//new alterabfrage=strval(inputtext);
if(strval(inputtext)>=18 && strval(inputtext) <=48)
{
pInfo[playerid][pAlter]=strval(inputtext);
pInfo[playerid][pEingeloggt]=1;
pInfo[playerid][pNeuling]=1;
new query [256],passworteingabe[128];
GetPVarString(playerid,"passwortvar",passworteingabe,128);
//mysql_format(Handle, query, sizeof(query), "INSERT INTO user (Username, Passwort) VALUES ('%e',MD5('%e'))",Spielername(playerid),passworteingabe);
//SQL SELECT [DATEN] FROM [DATABASE] WHERE [DATEN]
mysql_format(Handle,query,sizeof(query),"SELECT * FROM user WHERE Username='%e'AND Passwort=MD5('%e')",Spielername(playerid),inputtext);
mysql_function_query(Handle,query,true,"OnPlayerRegister","i",playerid);
printf("%s",query);
}
else
{
ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
}
}
else
{
ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
}
}
Alles anzeigen
Server.Log
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team
[10:28:39]
[10:28:39] Server Plugins
[10:28:39] --------------
[10:28:39] Loading plugin: streamer
[10:28:39]
*** Streamer Plugin v2.9.4 by Incognito loaded ***
[10:28:39] Loaded.
[10:28:39] Loading plugin: mysql
[10:28:39] >> plugin.mysql: R39-3 successfully loaded.
[10:28:39] Loaded.
[10:28:39] Loaded 2 plugins.
[10:28:39]
[10:28:39] Filterscripts
[10:28:39] ---------------
[10:28:39] Loading filterscript 'samplife-mapps.amx'...
[10:28:39] Server Objecte werden geladen
[10:28:39] 0 Gemappte Objecte Geladen
[10:28:39] Loaded 1 filterscripts.
[10:28:39] MYSQL: Die Verbindung war erfolgreich!
[10:28:39]
----------------------------------
[10:28:39] selfmade by kevin
[10:28:39] ----------------------------------
[10:28:39] Number of vehicle models: 0
[10:29:01] [connection] 127.0.0.1:54451 requests connection cookie.
[10:29:02] [connection] incoming connection: 127.0.0.1:54451 id: 0
[10:29:02] [join] ShadowKev1999 has joined the server (0:127.0.0.1)
[10:29:36] SELECT * FROM user WHERE Username='ShadowKev1999'AND Passwort=MD5('20')
[10:29:36] Update `user` Set `Skin`='60',`Alter`='20',`Geschlecht`='1',`Neuling`='0',`Leben`='0',`Russi`='0' WHERE `ID`='0'
[10:29:47] [part] ShadowKev1999 has left the server (0:1)
Alles anzeigen
Mysql-Log
[10:28:39] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[10:28:39] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[10:28:39] [DEBUG] CMySQLConnection::Connect - connection was successful
[10:28:39] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:28:39] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:29:02] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e'"
[10:29:02] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='ShadowKev1999'", callback: "UserCheck", format: "i"
[10:29:02] [DEBUG] CMySQLQuery::Execute[UserCheck] - starting query execution
[10:29:02] [DEBUG] CMySQLQuery::Execute[UserCheck] - query was successfully executed within 0.612 milliseconds
[10:29:02] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[10:29:02] [DEBUG] Calling callback "UserCheck"..
[10:29:02] [DEBUG] cache_get_data - connection: 1
[10:29:02] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[10:29:36] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e'AND Passwort=MD5('%e')"
[10:29:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='ShadowKev1999'AND Passwort=MD", callback: "OnPlayerRegister", format: "i"
[10:29:36] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - starting query execution
[10:29:36] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - query was successfully executed within 0.481 milliseconds
[10:29:36] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[10:29:36] [DEBUG] Calling callback "OnPlayerRegister"..
[10:29:36] [DEBUG] cache_insert_id - connection: 1
[10:29:36] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[10:29:36] [DEBUG] mysql_format - connection: 1, len: 256, format: "Update `user` Set `Skin`='%d',`Alter`='%d',`Geschlecht`='%d',`Neuling`='%d',`Leben`='%.0f',`Russi`='%.0f' WHERE `ID`='%i'"
[10:29:36] [DEBUG] mysql_pquery - connection: 1, query: "Update `user` Set `Skin`='60',`Alter`='20',`Geschlecht`='1',`Neu", callback: "(null)", format: "(null)"
[10:29:36] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[10:29:36] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.506 milliseconds
[10:29:36] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
Alles anzeigen
jetzt speichert er net mehr.
Min jung.. hier nochmal die Query die Fehler macht (Siehe deine SQL Log aus dem 1 Beitrag)
Dort musst du es auch ändern, deswegen auch die Zeilenangabe aus dem 1 Beitrag von dir.
Das ganze nochmal Bildlich

Min jung.. hier nochmal die Query die Fehler macht (Siehe deine SQL Log aus dem 1 Beitrag)
Dort musst du es auch ändern, deswegen auch die Zeilenangabe aus dem 1 Beitrag von dir.
Das ganze nochmal Bildlich
eentschuldige ich verstehe immer noch nicht
eentschuldige ich verstehe immer noch nicht
? Was verstehst du denn nicht, die auf dem Bild marktierte SQL abfrage ist Fehlerhaft, das user und FROM sind vertauscht, das musst du ändern
ocmd:oparken(playerid, params[])
{
new Geld;
new vehicleid = GetVehicleTrailer(GetPlayerVehicleID(playerid));
if(Spieler[playerid][pFraktion] != 5)return SendClientMessage(playerid, COLOR_WHITE, ERROR_FRAKTION);
if(GetVehicleModel(GetPlayerVehicleID(playerid)) != 525)return SendClientMessage(playerid, COLOR_WHITE, "{AFAFAF}Du bist in keinem Abschlepper");
if(sscanf(params, "d", Geld))return SendClientMessage(playerid, COLOR_WHITE, "{3592D7}* Benutze {00CC00}/oparken [Kaution]");
if(vehicleid == INVALID_VEHICLE_ID)return SendClientMessage(playerid, COLOR_WHITE, "{AFAFAF}Du hast kein Fahrzeug am Hacken.");
if(IsPlayerInRangeOfPoint(playerid, 10.0, 1764.8523, -1124.7183, 24.0859)) {
for(new slot = 0;slot<MAX_PLAYER_VEHICLES;slot++)
{
for(new i=0;i<GetMaxPlayers();i++)
{
if(IsValidVehicle(PlayerCar[i][slot][CarId]))
{
if(vehicleid == PlayerCar[i][slot][CarId])
{
new VehicleID, string[128];
VehicleID = GetPlayerVehicleID(playerid);
new occupiedCarID = GetVehicleTrailer(VehicleID);
PlayerCar[playerid][slot][vehAbgeschleppt] = 1;
format(PlayerCar[playerid][slot][vehAbgeschlepptVon], MAX_PLAYER_NAME, "%s", GetName(playerid));
PlayerCar[playerid][slot][vehKaution] = Geld;
SavePlayerVehicle(playerid);
DestroyVehicleEx(occupiedCarID);
format(string, sizeof(string), "{F3FF02}Du hast den %s erfolgreich abgeschleppt und erhältst am nächsten Payday 3000$. Kaution: %d$", CarName[PlayerCar[playerid][slot][CarModel]-400], Geld);
SendClientMessage(playerid, COLOR_WHITE, string);
Spieler[playerid][pPayCheck] += 3000;
Kasse[Oamt] = Geld;
return 1;
}
}
}
}
}
return 1;
}
Alles anzeigen
Moin Kurze Frage,
Wen ich das Fahrzeug Abschleppe das Funktioniert alles Wunderbar,
Aber wen ich das 2 Fahrzeug von mir abschleppe wird das nicht übernommen weiß jemand vilt was ich falsch mache?
Schau mal in deinem Code Zeile 22 bis 25
müsste playerid nicht zu i? wie du davor auch für die if abfragen genutzt hast?
PlayerCar[i][slot][vehAbgeschleppt] = 1;
format(PlayerCar[i][slot][vehAbgeschlepptVon], MAX_PLAYER_NAME, "%s", GetName(playerid));
PlayerCar[i][slot][vehKaution] = Geld;
SavePlayerVehicle(i);
Sonst speicherst du die Daten ja nur für die playerid... könnte evt. der Fehler sein.
mfg. Mogly1
Ist es nicht möglich, einen smoothen Zeitübergang zu machen wie im singleplayer?! Der Unterschied zwischen 6 und 7 Uhr zB ist enorm.
Mit,
https://wiki.sa-mp.com/wiki/SetPlayerTime
,kannst du auch die Minuten angeben. Wenn du jede Minute die zeit setzt, sollte es Smoother aussehen.
Dann muss ich für denen Player einen Timer setzen oder?
Wie ressourcenhungrig ist eigentlich so ein Timer? ich brüchte ja 100Stk bei 100 Spielern. Bei SetWorldTime brauche ich nur einen (da geht die minute ja nicht?)