// 4.2.10 Get withdrawals by withdrawal address ID
$address = mysql_real_escape_string($_GET["a"], $db);
$slt_transfer_withdrawal_address_a = "SELECT * FROM transfer_withdrawal_address WHERE address = '{$address}' AND user = '******'";
$rlt_transfer_withdrawal_address_a = mysql_query($slt_transfer_withdrawal_address_a);
$row_transfer_withdrawal_address_a = mysql_fetch_assoc($rlt_transfer_withdrawal_address_a);
if ($row_transfer_withdrawal_address_a["user"] != $user_id) {
json_error("Invalid address.");
}
$withdrawals = array();
$slt_transfer_withdrawal_a = "SELECT *, UNIX_TIMESTAMP(filing_time) AS filing_time_u FROM transfer_withdrawal WHERE withdrawal_address = '{$row_transfer_withdrawal_address_a['id']}'";
$rlt_transfer_withdrawal_a = mysql_query($slt_transfer_withdrawal_a);
while ($row_transfer_withdrawal_a = mysql_fetch_assoc($rlt_transfer_withdrawal_a)) {
if ($row_transfer_withdrawal_address_a["type"] == "intern") {
$withdrawals[] = array("txid" => $row_transfer_withdrawal_a["txid"], "time" => $row_transfer_withdrawal_a["filing_time_u"], "amount" => api_sc_format($row_transfer_withdrawal_a["amount"]));
} else {
$withdrawals[] = array("txid" => crypte_transaction($row_transfer_withdrawal_a["txid"]), "time" => $row_transfer_withdrawal_a["filing_time_u"], "amount" => api_sc_format($row_transfer_withdrawal_a["amount"]));
}
}
json_success($withdrawals);
}
}
if ($query[2] == "addresses") {
$withdrawal_addresses = array();
$slt_transfer_withdrawal_address_a = "SELECT * FROM transfer_withdrawal_address WHERE user = '******'";
$rlt_transfer_withdrawal_address_a = mysql_query($slt_transfer_withdrawal_address_a);
while ($row_transfer_withdrawal_address_a = mysql_fetch_assoc($rlt_transfer_withdrawal_address_a)) {
$withdrawal_addresses[] = array("id" => $row_transfer_withdrawal_address_a["id"], "address" => $row_transfer_withdrawal_address_a["address"], "group" => $row_transfer_withdrawal_address_a["group"], "type" => $row_transfer_withdrawal_address_a["type"]);
}
json_success($withdrawal_addresses);
}
json_error("Unknown call.");
}
}
$server_balance = $solidcoin->sc_getbalance("main") / 10000;
if (count($errors) == 0 && $server_balance < $amountwithfee * 1.05 + 1) {
$errors[] = "There's currently not enough Solidcoins on the Solidcoin24 servers to fulfill your withdrawal request. Don't worry, a Solidcoin24 admin has been informed and will resolve this for you. You will get an email as soon as the Solidcoins are available. Sorry for the inconvenience, but remember that a big part of the amounts are stored in a seperate wallets for your own security.";
send_mail("Emergency! Solidcoin balance exhausted ({$server_balance} left)!", "A user with the email address " . $_SESSION["user_email"] . " legitimately tried to withdraw {$amount} Solidcoins. There are still {$server_balance} Solidcoins on the server. The request was denied. Please resolve this and make sure to inform the user.", "*****@*****.**");
}
if (count($errors) == 0) {
echo "{$amount} Solidcoins are being transferred to {$address}.<br />";
$result = withdraw_slc($address);
if ($result["type"] == "extern") {
$itxid = add_transaction($_SESSION["user_id"], "out", "extern", $amountwithfee, "SLC", "withdrawal", 0, $staticfee);
$tx = withdraw_slc($address, $amount, "", $itxid);
$udt_transaction_a = "UPDATE transaction SET info_id = '{$tx['txid']}' WHERE id = '{$itxid}'";
mysql_query($udt_transaction_a);
echo "<small>Transaction (extern): " . crypte_transaction($tx["txid"]) . "</small>";
} else {
$itxid = add_transaction($_SESSION["user_id"], "out", "intern", $amountwithfee, "SLC", "withdrawal", 0);
$tx = withdraw_slc($address, $amount, "", $itxid);
$udt_transaction_a = "UPDATE transaction SET info_id = '{$tx['txid']}' WHERE id = '{$itxid}'";
mysql_query($udt_transaction_a);
echo "<small>Transaction (intern): {$tx['txid']}</small>";
}
} else {
foreach ($errors as $error) {
echo "{$error}<br />";
}
?>
<br />
The Solidcoins will be transferred immediately to the specified address and removed from your balance.<br /><br />
Current balance: <?php
"><?php
echo $row_transfer_withdrawal_address_a["address"];
?>
</a> (<?php
echo $row_transfer_withdrawal_address_a["id"];
?>
)</td></tr>
<tr><td style="padding-right: 10px">Amount</td><td><?php
echo nice_format($row_transfer_withdrawal_a["amount"], false, 0, 4);
?>
</td></tr>
<tr><td style="padding-right: 10px">Txid</td><td><?php
if ($row_transfer_withdrawal_address_a["type"] == "intern") {
echo $row_transfer_withdrawal_a["txid"];
} else {
echo crypte_transaction($row_transfer_withdrawal_a["txid"]);
}
?>
</td></tr>
<tr><td style="padding-right: 10px">Date and time</td><td><?php
echo date("d.m. H:i:s", $row_transfer_withdrawal_a["filing_time_u"] - $_SESSION["time_offset"] * 60);
?>
</td></tr>
</table>
</p>
</div>
<?php
function crypte_transaction($id)
{
}
echo "</td>";
echo "<td style=\"padding-left: 10px\">";
echo "<a href=\"?c=services/transfer/deposit_address&a={$row_transfer_deposit_a['address']}\">" . substr($row_transfer_deposit_a["address"], 0, 5) . "..." . substr($row_transfer_deposit_a["address"], -3, 3) . "</a> ({$row_transfer_deposit_a['aid']})";
echo "</td>";
echo "<td style=\"text-align: center; padding-left: 10px\">";
echo date("d.m. H:i:s", $row_transfer_deposit_a["filing_time_u"] - $_SESSION["time_offset"] * 60);
echo "</td>";
echo "<td style=\"text-align: right; padding-left: 10px\">";
echo nice_format($row_transfer_deposit_a["amount"], true, 0, 4);
echo "</td>";
echo "<td style=\"padding-left: 10px\">";
if ($row_transfer_deposit_a["type"] == "intern") {
echo $row_transfer_deposit_a["txid"];
} else {
$txid = crypte_transaction($row_transfer_deposit_a["txid"]);
echo "<span title=\"{$txid}\">" . substr($txid, 0, 10) . "..." . substr($txid, -3, 3) . "</span>";
}
echo "</td>";
echo "<td style=\"padding-left: 10px\"><a href=\"?c=services/transfer/deposit&id={$row_transfer_deposit_a['id']}\"><img src=\"images/transfer.jpg\" alt=\"Deposit\" title=\"Deposit\" style=\"border: 1px solid #B7B7B7; padding: 2px\" /></a></td>";
echo "</tr>\n";
}
?>
</table>
<h3>Show</h3>
<form action="?c=services/transfer/deposits" method="post">
<table style="width: 70%">
<tr><td style="width: 50%">