GiveWeaponPlayer OR Whatever!!

GiveWeaponPlayer OR Whatever!! - 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)
+--- Thread: GiveWeaponPlayer OR Whatever!! (/showthread.php?tid=432804)

GiveWeaponPlayer OR Whatever!! - Yashas - 24.04.2013

The CODE:

Code:

format(query, sizeof(query), "SELECT * FROM weapons WHERE Username = '%s'",PlayerInfo[playerid][Name]);
		mysql_query(query);
		mysql_store_result();
		ResetPlayerWeapons(playerid);
		while(mysql_fetch_row_format(query,"|"))
		{
			mysql_fetch_field_row(newdata, "Slot1");
			mysql_fetch_field_row(newdata2, "Slot1Ammo");
			GivePlayerWeapon(playerid,strval(newdata),strval(newdata2));
            mysql_fetch_field_row(newdata, "Slot2");
			mysql_fetch_field_row(newdata2, "Slot2Ammo");
			GivePlayerWeapon(playerid,strval(newdata),strval(newdata2));
			mysql_fetch_field_row(newdata, "Slot3");
			mysql_fetch_field_row(newdata2, "Slot3Ammo");
			GivePlayerWeapon(playerid,strval(newdata),strval(newdata2));
			mysql_fetch_field_row(newdata, "Slot4");
			mysql_fetch_field_row(newdata2, "Slot4Ammo");
			GivePlayerWeapon(playerid,strval(newdata),strval(newdata2));
			mysql_fetch_field_row(newdata, "Slot5");
			mysql_fetch_field_row(newdata2, "Slot5Ammo");
			GivePlayerWeapon(playerid,strval(newdata),strval(newdata2));
			mysql_fetch_field_row(newdata, "Slot6");
			mysql_fetch_field_row(newdata2, "Slot6Ammo");
			GivePlayerWeapon(playerid,strval(newdata),strval(newdata2));
			mysql_fetch_field_row(newdata, "Slot7");
			mysql_fetch_field_row(newdata2, "Slot7Ammo");
			GivePlayerWeapon(playerid,strval(newdata),strval(newdata2));
			mysql_fetch_field_row(newdata, "Slot8");
			mysql_fetch_field_row(newdata2, "Slot8Ammo");
			GivePlayerWeapon(playerid,strval(newdata),strval(newdata2));
			mysql_fetch_field_row(newdata, "Slot9");
			mysql_fetch_field_row(newdata2, "Slot9Ammo");
			GivePlayerWeapon(playerid,strval(newdata),strval(newdata2));
			mysql_fetch_field_row(newdata, "Slot10");
			mysql_fetch_field_row(newdata2, "Slot10Ammo");
			GivePlayerWeapon(playerid,strval(newdata),strval(newdata2));
			mysql_fetch_field_row(newdata, "Slot11");
			mysql_fetch_field_row(newdata2, "Slot11Ammo");
			GivePlayerWeapon(playerid,strval(newdata),strval(newdata2));
			mysql_fetch_field_row(newdata, "Slot12");
			mysql_fetch_field_row(newdata2, "Slot12Ammo");
			GivePlayerWeapon(playerid,strval(newdata),strval(newdata2));
		}
		mysql_free_result();

The player doesn't get his weapons.The MySQL work perfect, tested with print(newdata) and print(newdata2), the values printed are correct.The problem is the players don't get their weapons.

Thanks

Re: GiveWeaponPlayer OR Whatever!! - RVRP - 24.04.2013

You are using strval incorrectly. Strval is used in converting a string to an integer. If you are simply retrieving a Weapon ID, this shouldn't be saved to a string in the first place. Just remove the strval and leave newdata by itself. Same goes for newdata2.