Geld speichert nicht

HighSociety · 20. November 2015

Guten Tag, leider speichert mein Mode mein Geld nicht Richtig. Woran könnte das Problem liegen

hier der ausschnitt von OnPlayerDisconnect

Code

savePlayer(playerid)
{//Speichern//
	new query[128];
	format(query,sizeof(query),"UPDATE accounts SET Money=`%i´");


}
public OnPlayerDisconnect(playerid, reason)
{
	if(!IsPlayerNPC(playerid)) {
	    GetPlayerName(playerid,sendername,sizeof sendername);
	    new Hour,Minute,Second,Year,Month,Day,dt[16],ti[16],rs[32],query[256];
	    switch(reason) {
	        case 0: { format(rs,sizeof rs,"Timeout/Crash"); }
	        case 1: { format(rs,sizeof rs,"Quit"); }
	        case 2: { format(rs,sizeof rs,"Kick/Ban"); }
	    }
	    gettime(Hour,Minute,Second), getdate(Year,Month,Day);
		format(dt,16,"%d.%d.%d",Day,Month,Year), format(ti,16,"%d:%d:%d",Hour,Minute,Second);
		format(query, 256, "INSERT INTO `Logouts` (`Name`, `Date`, `Time`, `Reason`, `Sessiontime`) VALUES ('%s', '%s', '%s', '%s', '%d')",sendername,dt,ti,rs,Sessiontime[playerid]);
		mysql_query(query);
		savePlayer (playerid);
		PlayerTextDrawHide(playerid, Moneystring[playerid]);
		PlayerTextDrawHide(playerid, Statustext1[playerid]);
		PlayerTextDrawHide(playerid, Statustext2[playerid]);
		PlayerTextDrawHide(playerid, Tacho1[playerid]);
		PlayerTextDrawHide(playerid, JobInfo0[playerid]);
		PlayerTextDrawHide(playerid, JobInfo2[playerid]);

		if(GetPVarInt(playerid,"Admincar") != -1){ DestroyVehicle(GetPVarInt(playerid,"Admincar")); }
		DestroyVehicle(Jobtrailer[playerid]);
		Delete3DTextLabel(Adminlabel[playerid]);
		DestroyPlayerObject(playerid, ErzObj[0][playerid]);
		DestroyPlayerObject(playerid, ErzObj[1][playerid]);
		KillTimer(Mintimer[playerid]);
		KillTimer(tutTimer[playerid]);
		KillTimer(MariTimer[playerid]);
		KillTimer(KokaTimer[playerid]);
		currPL--;

		for(new i;i<MaxVehikel;i++) {
			if(!pCarInfo[i][cCreated])continue;
   			if((!strcmp(pCarInfo[i][cOwner],sendername,true))) {
			    SavePrivateVehicle(pCarInfo[i][cVeh]);
				PVC[pCarInfo[i][cVeh]] = 0;
				DestroyVehicle(pCarInfo[i][cVeh]);
				KillTimer(pCarInfo[i][cSaveTimer]);
				pCarInfo[i][cCreated] = false;
			}
		}


		if(GetPVarInt(playerid,"SupportID") != -1) {
			new Partner = GetPVarInt(playerid,"SupportID");
			GetPlayerName(Partner,usedname,sizeof usedname);
			SetPVarInt(Partner,"inSupport",0);
			SetPVarInt(Partner,"SupportID",-1);
			SetPVarInt(Partner,"TicketGeschrieben",0);
			SetPVarInt(playerid,"inSupport",0);
			SetPVarInt(playerid,"SupportID",-1);
			format(query, 256, "UPDATE `Tickets` SET `Bearbeitung` = '1', `Status` = '3' WHERE `Besitzer` = '%s'",usedname);
			mysql_query(query);
			SendClientMessage(Partner,COLOR_YELLOW,"Dein Supportpartner hat das Spiel verlassen. Der Supportchat wurde geschlossen.");
		}

		if(GetPVarInt(playerid,"inCall") == 1) {
		    SetPVarInt(GetPVarInt(playerid,"CallID"),"inCall",0);
			SetPVarInt(GetPVarInt(playerid,"CallID"),"CallID",-1);
			SetPVarInt(playerid,"inCall",0);
			SetPVarInt(playerid,"CallID",-1);
			SetPVarInt(playerid,"Called",0);
			SendClientMessage(GetPVarInt(playerid,"CallID"),COLOR_GREY,"Die Telefonverbindung wurde unterbrochen..");
		}


		//if(MariV[playerid] != 0){ pInfo[playerid][pUnreadyMari] += MariV[playerid]; }
		//if(KokaV[playerid] != 0){ pInfo[playerid][pUnreadyKoka] += KokaV[playerid]; }
        pInfo[playerid][pUnreadyMari] += MariV[playerid];
		pInfo[playerid][pUnreadyKoka] += KokaV[playerid];


	    SkinSel[playerid] = 0;
		amsg[playerid] = 0;
		SupDuty[playerid] = 0;
		TruckerjobCP[playerid] = 0;
	    ErzjobCP[playerid] = -1;
	    inJob[playerid] = 0;
	    Durchlauf[playerid] = 0;
	    Pingwarn[playerid] = 0;
	    Sessiontime[playerid] = 0;
	    Beintreffer[playerid] = 0;
	    Armtreffer[playerid] = 0;
	    UsedDrugs[playerid] = 0;
	    gSpectateID[playerid] = -1;
	    Findcar[playerid] = 0;
	    tutTime[playerid] = 0;
	    ECabholen[playerid] = 0;
	    MariV[playerid] = 0;
		KokaV[playerid] = 0;
		GM[playerid] = 0;


	    DeletePVar(playerid,"Eingeloggt");
	    DeletePVar(playerid,"Acc");
	    DeletePVar(playerid,"savepos");
	    DeletePVar(playerid,"backport");
	    DeletePVar(playerid,"inSupport");
		DeletePVar(playerid,"SupportID");
		DeletePVar(playerid,"Lieferkosten");
		if(GetPVarInt(playerid,"TicketGeschrieben") == 1) {
		    format(query, sizeof query,"UPDATE `Tickets` SET `Status` = '3' WHERE `Besitzer` = '%s'",sendername);
		    mysql_query(query);
		    DeletePVar(playerid,"TicketGeschrieben");
		} else {
		    DeletePVar(playerid,"TicketGeschrieben");
		}
		SetPVarInt(playerid,"ImportVeh",-1);
		if(GetPVarInt(playerid,"Eingeloggt") == 1) { SavePlayer(playerid); }

	}
	return 1;
}

Alles anzeigen

ReborN · 20. November 2015

solltest evtl auch einen Wert angeben:

format(query,sizeof(query),"UPDATE accounts SET Money = '%d' WHERE name = '%s'",money[playerid],name[playerid]);

musst die hintersten variablen noch angeben wie du sie benannt hast ebenfalls wenn du mit mysql arbeitest auch noch mysql_format etc verwenden

HighSociety · 20. November 2015

So hatte ich es auch schon gelesen gehabt nur weiß ich dann nicht wo bei mir der Fehler ist.

Code

C:\Users\Papa\Desktop\script.pwn(3203) : warning 215: expression has no effect
C:\Users\Papa\Desktop\script.pwn(3203) : error 001: expected token: ";", but found "]"
C:\Users\Papa\Desktop\script.pwn(3203) : error 029: invalid expression, assumed zero
C:\Users\Papa\Desktop\script.pwn(3203) : fatal error 107: too many error messages on one line

ReborN · 20. November 2015

jetzt noch die zeile, wie du sie bisher geschrieben hast, dann kann man helfen

HighSociety · 20. November 2015

So wie du den Wert oben angegeben hattest.

Aber iwas stimmt da net

Jeffry · 20. November 2015

Wie gibst du dem Spieler denn Geld? Poste dazu bitte mal den Code.

HighSociety · 21. November 2015

Ich vermute mal ganz stark das du meinst sobald der User Joint das mache ich mit einem String

Code

Moneystring[playerid] = CreatePlayerTextDraw(playerid, 606.400268, 79.644401, "123.456.789.999");
	PlayerTextDrawLetterSize(playerid, Moneystring[playerid], 0.265599, 1.570134);
	PlayerTextDrawAlignment(playerid, Moneystring[playerid], 3);
	PlayerTextDrawColor(playerid, Moneystring[playerid], -1);
	PlayerTextDrawSetShadow(playerid, Moneystring[playerid], 0);
	PlayerTextDrawSetOutline(playerid, Moneystring[playerid], 1);
	PlayerTextDrawBackgroundColor(playerid, Moneystring[playerid], 51);
	PlayerTextDrawFont(playerid, Moneystring[playerid], 2);
	PlayerTextDrawSetProportional(playerid, Moneystring[playerid], 1);

Code

public Speedometer()
{
	for(new i;i<MAX_PLAYERS;i++) {
	    if(!IsPlayerNPC(i)) {
		    if(IsPlayerConnected(i) && GetPVarInt(i,"Eingeloggt") == 1) {
				new str[156];
				format(str,sizeof str,"%s",inspoints(pInfo[i][pMoney]));
		        PlayerTextDrawSetString(i, Moneystring[i], str);
		        if(GM[i]){ SetPlayerHealth(i,100); }
				if(IsPlayerInAnyVehicle(i) && GetPlayerVehicleSeat(i) == 0) {
		            new Float:CarHealth,string[256],kmh,veh,Float:Distance;
					veh=GetPlayerVehicleID(i);
					GetVehicleHealth(veh,CarHealth);
					CarHealth=CarHealth-250;
					CarHealth=CarHealth/10;
					CarHealth=CarHealth/75;
					CarHealth=CarHealth*100;
					kmh=GetPlayerSpeed(i, true);
					if(Handbrake[veh] == 1 && kmh > 6){ SetVehicleSpeed(veh,22); }
					if(Motor[veh] == true){ format(str,sizeof str,"~g~Motor    "); } else { format(str,sizeof str,"~r~Motor    "); }
					if(Handbrake[veh] == 1){ strcat(str,"~g~Handbremse    "); } else { strcat(str,"~r~Handbremse    "); }
					if(Licht[veh] == true){ strcat(str,"~g~Licht"); } else { strcat(str,"~r~Licht"); }
					PlayerTextDrawSetString(i,Tacho1[i],str);
					GetVehiclePos(veh,pNewKM[0][i],pNewKM[1][i],pNewKM[2][i]);
					Distance=GetVehicleDistanceFromPoint(veh,pOldKM[0][i],pOldKM[1][i],pOldKM[2][i]);
					if(Distance>150){Distance=0;}
					KM[veh] += Distance/900;
					pOldKM[0][i] = pNewKM[0][i];
					pOldKM[1][i] = pNewKM[1][i];
					pOldKM[2][i] = pNewKM[2][i];
					format(string,sizeof string,"%0.1f KM",KM[veh]);
					switch(Tank[veh]/(MaxTank[GetVehicleModel(veh)-400]/10))
					{
					    case 10,11: format(string,sizeof string,"Geschwingidkeit: %d km/h~n~Tankinhalt: ~g~I I I I I I I I I I~w~ (%d/%dL)~n~Zustand: %d%%~n~Fahrzeug: %s~n~Kilometer: %s",kmh,Tank[veh],MaxTank[GetVehicleModel(veh)-400],floatround(CarHealth,floatround_floor),PlayerVehicle[GetVehicleModel(veh) - 400],string);
						case 9: format(string,sizeof string,"Geschwingidkeit: %d km/h~n~Tankinhalt: ~g~I I I I I I I I I ~r~I~w~ (%d/%dL)~n~Zustand: %d%%~n~Fahrzeug: %s~n~Kilometer: %s",kmh,Tank[veh],MaxTank[GetVehicleModel(veh)-400],floatround(CarHealth,floatround_floor),PlayerVehicle[GetVehicleModel(veh) - 400],string);
					 	case 8: format(string,sizeof string,"Geschwingidkeit: %d km/h~n~Tankinhalt: ~g~I I I I I I I I ~r~I I~w~ (%d/%dL)~n~Zustand: %d%%~n~Fahrzeug: %s~n~Kilometer: %s",kmh,Tank[veh],MaxTank[GetVehicleModel(veh)-400],floatround(CarHealth,floatround_floor),PlayerVehicle[GetVehicleModel(veh) - 400],string);
					    case 7: format(string,sizeof string,"Geschwingidkeit: %d km/h~n~Tankinhalt: ~g~I I I I I I I ~r~I I I~w~ (%d/%dL)~n~Zustand: %d%%~n~Fahrzeug: %s~n~Kilometer: %s",kmh,Tank[veh],MaxTank[GetVehicleModel(veh)-400],floatround(CarHealth,floatround_floor),PlayerVehicle[GetVehicleModel(veh) - 400],string);
					    case 6: format(string,sizeof string,"Geschwingidkeit: %d km/h~n~Tankinhalt: ~g~I I I I I I ~r~I I I I~w~ (%d/%dL)~n~Zustand: %d%%~n~Fahrzeug: %s~n~Kilometer: %s",kmh,Tank[veh],MaxTank[GetVehicleModel(veh)-400],floatround(CarHealth,floatround_floor),PlayerVehicle[GetVehicleModel(veh) - 400],string);
					    case 5: format(string,sizeof string,"Geschwingidkeit: %d km/h~n~Tankinhalt: ~g~I I I I I ~r~I I I I I~w~ (%d/%dL)~n~Zustand: %d%%~n~Fahrzeug: %s~n~Kilometer: %s",kmh,Tank[veh],MaxTank[GetVehicleModel(veh)-400],floatround(CarHealth,floatround_floor),PlayerVehicle[GetVehicleModel(veh) - 400],string);
						case 4: format(string,sizeof string,"Geschwingidkeit: %d km/h~n~Tankinhalt: ~g~I I I I ~r~I I I I I I~w~ (%d/%dL)~n~Zustand: %d%%~n~Fahrzeug: %s~n~Kilometer: %s",kmh,Tank[veh],MaxTank[GetVehicleModel(veh)-400],floatround(CarHealth,floatround_floor),PlayerVehicle[GetVehicleModel(veh) - 400],string);
						case 3: format(string,sizeof string,"Geschwingidkeit: %d km/h~n~Tankinhalt: ~g~I I I ~r~I I I I I I I~w~ (%d/%dL)~n~Zustand: %d%%~n~Fahrzeug: %s~n~Kilometer: %s",kmh,Tank[veh],MaxTank[GetVehicleModel(veh)-400],floatround(CarHealth,floatround_floor),PlayerVehicle[GetVehicleModel(veh) - 400],string);
						case 2: format(string,sizeof string,"Geschwingidkeit: %d km/h~n~Tankinhalt: ~g~I I ~r~I I I I I I I I~w~ (%d/%dL)~n~Zustand: %d%%~n~Fahrzeug: %s~n~Kilometer: %s",kmh,Tank[veh],MaxTank[GetVehicleModel(veh)-400],floatround(CarHealth,floatround_floor),PlayerVehicle[GetVehicleModel(veh) - 400],string);
						case 1: format(string,sizeof string,"Geschwingidkeit: %d km/h~n~Tankinhalt: ~g~I ~r~I I I I I I I I I~w~ (%d/%dL)~n~Zustand: %d%%~n~Fahrzeug: %s~n~Kilometer: %s",kmh,Tank[veh],MaxTank[GetVehicleModel(veh)-400],floatround(CarHealth,floatround_floor),PlayerVehicle[GetVehicleModel(veh) - 400],string);
						case 0: format(string,sizeof string,"Geschwingidkeit: %d km/h~n~Tankinhalt: ~r~I I I I I I I I I I~w~ (%d/%dL)~n~Zustand: %d%%~n~Fahrzeug: %s~n~Kilometer: %s",kmh,Tank[veh],MaxTank[GetVehicleModel(veh)-400],floatround(CarHealth,floatround_floor),PlayerVehicle[GetVehicleModel(veh) - 400],string);
					}
					PlayerTextDrawSetString(i, Tacho0[i], string);
		        }
		    }
	    }
	}
	for(new v;v<MAX_VEHICLES;v++) {
	    new Float:ch;
	    if(GetVehicleHealth(v,ch) > 1000) { SetVehicleHealth(v,1000); }
	    for(new i; i<sizeof NagelBand; i++) {
			if(NagelBand[i][nErstellt]) {
			    if(IsVehicleInRangeOfPoint(v, 4, NagelBand[i][NagelBandX], NagelBand[i][NagelBandY], NagelBand[i][NagelBandZ])) {
					new panels, tires;
					GetVehicleDamageStatus(v, panels, doors, lights, tires);
					tires = encode_tires(1, 1, 1, 1);
					UpdateVehicleDamageStatus(v, panels, doors, lights, tires);
				}
			}
	    }
	}
	return 1;
}

Alles anzeigen

Jeffry · 21. November 2015

C

savePlayer(playerid)
{   
	//Speichern//
	new query[256], pname[MAX_PLAYER_NAME];
	GetPlayerName(playerid, pname, MAX_PLAYER_NAME);
	format(query,sizeof(query),"UPDATE accounts SET money='%i' WHERE name = '%s'", pInfo[playerid][pMoney], pname);
	mysql_query(query);
	return 1;
}

HighSociety · 21. November 2015

Hej Jeffry danke dir es funktioniert =) auf dich ist verlass

Geld speichert nicht

breadfish.de 12. März 2022

Ähnliche Themen

MySQL (Installation, Zugriff, Einstellungen, Login & Register Beispiel)

Problem mit Speicherung (R39-3)

Tutorial Bug

10 Level ups , Mit dialog hilfe

MYSQL-Account speichern

MySQL Speicher fehler? Warum???