GTAONLINE.PL :: Tagi • kwoty

local kwota = math.random(1,10000)
local druzyna1 = "team1"

function test()
exports["mysql"]:dbSet("UPDATE druzyny SET pieniadze=? WHERE druzyna=?",kwota, druzyna1)
end
addCommandHandler("dodajkwote", test)

		case D_CASH_OUT:

		{

		    new cash = strval(inputtext), string[128], query[256];

			new result[12], card_number, card_cash;

			format(query, sizeof(query), "SELECT `card_number`, `card_cash` FROM `fc_cards` WHERE `card_number` = '%d'", CardUse[playerid]);

			mysql_check();

			mysql_query(query);

			mysql_store_result();

			mysql_fetch_row_format(result, "|");

			sscanf(result, "p<|>dd", card_number, card_cash);

			mysql_free_result();

			if(card_cash < cash)

			{

				ShowPlayerDialog(playerid, D_INFO, DIALOG_STYLE_MSGBOX, " Wyst?pi? b??d", "Na Twoim koncie nie znajduje si? odpowiednia ilo?? got?wki.", "Zamknij", "");

			    return 1;

			}

			GivePlayerCash(playerid, cash);

			SavePlayerStats(playerid, SAVE_PLAYER_BASIC);

			format(query, sizeof(query), "UDATE `fc_cards` SET `card_cash` = `card_cash` - '%d' WHERE `card_number` = '%d'", cash, CardUse[playerid]);

			mysql_query(query);

			CardUse[playerid] = 0;

			format(string, sizeof(string), "Pomy?lnie wyp?aci?e? got?wk? ($%d) z karty bankowej.", cash);

			ShowPlayerDialog(playerid, D_INFO, DIALOG_STYLE_MSGBOX, " Informacja", string, "Zamknij", "");

		}