Файл: test.otwap.aux.su/pages/withdrow.php
Строк: 25
<?
if (isset($_GET[id])) {
if (updata("UPDATE `user` u, `withdrow` w SET u.balance = u.balance + w.cash WHERE u.id = $id_user AND w.id = $_GET[id] AND w.id_user = $id_user")) insert("DELETE FROM `withdrow` WHERE `id_user` = $id_user AND `id` = $_GET[id]");
}
$query = "SELECT `balance` FROM `user` WHERE `id` = '$id_user'";
$set = select($query);
$row = mysql_fetch_array($set);
$query1 = "SELECT `n` FROM `outcash` ";
$set1 = select($query1);
$row1 = mysql_fetch_array($set1);
$query2 = "SELECT `s` FROM `outcash` ";
$set2 = select($query2);
$row2 = mysql_fetch_array($set2);
if ($row[balance] >= 1) {
if (($_POST[cash] >= 2) AND ($_POST[cash] <= $row[balance])) {
if (insert("INSERT INTO `withdrow` VALUES('','$id_user','','$_POST[cash]')")) {
updata("UPDATE `user` SET `balance` = `balance` - $_POST[cash] WHERE `id` = '$id_user'");
$row[balance] = $row[balance] - $_POST[cash];
updata("UPDATE `outcash` SET `n` = $row1[n] + '1' ");
updata("UPDATE `outcash` SET `s` = $row2[s] + $_POST[cash] ");
}
}
?>
<form id=pay name=pay method="POST" action="">
Заявка на снятие средств<br><br>
Сумма: <input type="Text" name="cash" value = "<?=floor($row[balance])?>" class="window" size="7"> WMR<br><br>
<input type="submit" name="submit" value = "Принять" class="field2" size="10">
</form><br><br>
<? } else {
echo "Недостаточно средств для снятия. Должно быть минимум 2 WMR. У вас только $row[balance] WMR.<br><br>";
}
$query = "SELECT * FROM `withdrow` WHERE `id_user` = '$id_user'";
$set = select($query);
while ($row = mysql_fetch_array($set)) {
echo "Заявка № $row[id] на сумму $row[cash] WMR в ожидании. - <a href='?id=$row[id]'>Отменить</a><br>";
}
?>
<?
print "<li>Минимум к выплате 2 wmr ";
?>