Nu se salveaza variabila

[Mark S.]

Problema intalnita (descriere): Am facut un sistem pe dialog sa ii adauge o variabila ++  la playerul care l-ai scris in dialog si inloc sa imi adauge 1 la variabila se face 1

Ero(area / rile) / warning-(ul / urile): -
Liniile de cod / sursa / script-ul(obligatoriu):

if(dialogid == 6808)
	{
	    if(response)
	    {
      		if(!strlen(inputtext))
			{
				ShowPlayerDialog(playerid, 6808, DIALOG_STYLE_INPUT, "Acest Cont nu exista","Poti da skip daca nu stii numele","OK","SKIP ->");
				return 1;
			}
			if(!strcmp(inputtext, PlayerName(playerid),  false)) return ShowPlayerDialog(playerid, 6808, DIALOG_STYLE_INPUT, "Nu te poti adauga singur","Poti da skip daca nu stii numele","OK","SKIP ->");
			new result[12],variabila[123],asd;
			format(string,100,"SELECT * FROM `players` WHERE `username`='%s'",inputtext);
			mysql_query(string);
		    mysql_store_result();
			if(mysql_num_rows() > 0)//contul exista
			{
				new sendernamde[123];
		        GetPlayerName(playerid,sendernamde, sizeof(sendernamde));
    			format(string,100,"SELECT `Adjustable` FROM `players` WHERE `username`='%s'",inputtext);
				mysql_query(string);
				mysql_store_result();
				if(mysql_retrieve_row())
				{
   				    if(IsPlayerConnected(ReturnUser(inputtext)))
				    {
						PlayerInfo[ReturnUser(inputtext)][pAdjustable] ++;
						Update(ReturnUser(inputtext), pAdjustablex);
			    		format(string,100,"%s Ti-a dat un punct in plus",sendernamde,PlayerInfo[ReturnUser(inputtext)][pAdjustable]);
						SendClientMessage(ReturnUser(inputtext),-1,string);
			       		mysql_free_result();
    				}
    				else
    				{
    				    mysql_get_field("Adjustable", result);
				    	strmid(variabila, result, 0, 255, 255);
				    	asd = result[2];
				    	format(string,100,"I-ai dat un punct lui %s ",inputtext);
						SendClientMessage(playerid,-1,string);
	    			    format(string,100,"UPDATE `players` SET `Adjustable`='%d' WHERE `username`='%s'",inputtext,asd+1);
						mysql_query(string);
	   				}
    			}
    			PlayerInfo[playerid][pAchievement7] = 1;
    			Update(playerid, pAchievement7x);
	       		mysql_free_result();

			}
			else return ShowPlayerDialog(playerid, 6808, DIALOG_STYLE_INPUT, "Acest Cont nu exista","Poti da skip daca nu stii numele","OK","SKIP ->");
   		}

am pus asta PlayerInfo[ReturnUser(inputtext)][pAdjustable] ++;

si se intampla ca si cum as fi pus asta PlayerInfo[ReturnUser(inputtext)][pAdjustable]  = 1;
Imagini / Video (optional): -
Ati incercat sa rezolvati singur?: Da am incercat o gramada de variante

[InfiniTy.]

Atunci incearca sa updatezi asa.

format(string,100,"UPDATE `players` SET `Adjustable` = `Adjustable` + 1 WHERE `username`='%s'",inputtext);

Edited June 24, 2015 by InfiniTy.

[Alexander.]

Incearca in loc de

PlayerInfo[ReturnUser(inputtext)][pAdjustable] ++

sa pui asta

PlayerInfo[ReturnUser(inputtext)][pAdjustable] += 1;

 

[Mark S.]

este acelasi lucru += 1 sau ++

si inainte a fost ++ am schimbat-o eu in += 1 ca nu mergea si tot nu merge

[InfiniTy.]

format(string,100,"UPDATE `players` SET `Adjustable`='%d' WHERE `username`='%s'",asd+1,inputtext);

Si vezi ca e vulnerabil codul.. MySQL injection.

[Mark S.]

acelasi lucru mi se seteaza variabila 1 desi eu o am in database 5 ar trebui sa creasca la 6 dar se face 1

[Mark S.]

Rezolvat multumesc InfiniTy.