MySQL code not working :X - Printable Version

MySQL code not working :X - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL code not working :X (/showthread.php?tid=265588)

- ben4uka - 01.07.2011

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...