MySQL code not working :X
#1

hey.

i dont know what worng with this code, look:

Код:
  		if(IsPlayerConnected(playerid))
 		{
			new MoneyStunts;
			MoneyStunts = GetPlayerMoney(playerid);
			if(MoneyStunts > 0 && MoneyStunts < 1001)
			{
				PlayerInfo[playerid][Points] = PlayerInfo[playerid][Points]+MoneyStunts/25;
				ResetPlayerMoney(playerid);
				format(query,1024,"UPDATE `Users` SET `Points` = '%d' WHERE `Nick` = '%s'",PlayerInfo[playerid][Points], GetName(playerid));
				mysql_query(query);
			}
			else ResetPlayerMoney(playerid);
		}
what's worng?

btw, when i taking the var from the my sql to a varbial, its gives me the password and not the thing i taked.


code:

Код:
			new query2[256];
			format(query2, 256, "SELECT `Points` FROM `Users` WHERE Nick='%s'", GetName(playerid));
			mysql_query(query2);
	    	mysql_fetch_row_format(szResult,"|");
	    	if(strval(szResult) == 0) return 1;
	    	PlayerInfo[playerid][Points] = strval(szResult);
Thanks.


Sorry for bad english.

never mine, fixed.

thanks anyway...
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)