Cod: Selectaţi tot

function is_pay_coins($type, $coins)
{
	global $account;
	
	$sth = $account->prepare('SELECT coins, jcoins
		FROM account
		WHERE id = ? LIMIT 1');
	$sth->bindParam(1, $_SESSION['id'], PDO::PARAM_INT);
	$sth->execute();
	$result = $sth->fetchAll();
	
	if(!$type)
	{
		$stmt = $account->prepare("UPDATE account set coins = coins - ?, jcoins = jcoins + ? WHERE id = ?");
		$stmt->bindParam(1, $coins, PDO::PARAM_INT);
		$stmt->bindParam(3, $coins, PDO::PARAM_INT);
		$stmt->bindParam(3, $_SESSION['id'], PDO::PARAM_INT);
		$stmt->execute();
	}
	else
	{
		$stmt = $account->prepare("UPDATE account set jcoins = jcoins - ? WHERE id = ?");
		$stmt->bindParam(1, $coins, PDO::PARAM_INT);
		$stmt->bindParam(2, $_SESSION['id'], PDO::PARAM_INT);
		$stmt->execute();
	}
}