$row_transfer_deposit_address_a = mysql_fetch_assoc($rlt_transfer_deposit_address_a); if ($row_transfer_deposit_address_a["user"] != $user_id) { json_error("Invalid id"); } brief_check(); $slt_transfer_deposit_a = "SELECT SUM(amount) AS amount FROM transfer_deposit WHERE deposit_address = '{$id}'"; $rlt_transfer_deposit_a = mysql_query($slt_transfer_deposit_a); $row_transfer_deposit_a = mysql_fetch_assoc($rlt_transfer_deposit_a); $total_amount = $row_transfer_deposit_a["amount"]; $slt_transfer_deposit_b = "SELECT SUM(amount) AS amount FROM transfer_deposit WHERE deposit_address = '{$row_transfer_deposit_address_a['id']}' AND type = 'extern'"; $rlt_transfer_deposit_b = mysql_query($slt_transfer_deposit_b); $row_transfer_deposit_b = mysql_fetch_assoc($rlt_transfer_deposit_b); $total_amount_extern = $row_transfer_deposit_b["amount"]; $udt_transfer_deposit_address_a = "UPDATE transfer_deposit_address SET last_check_amount = '{$total_amount}' WHERE id = {$row_transfer_deposit_address_a['id']}"; mysql_query($udt_transfer_deposit_address_a); $pending_amount = $solidcoin->sc_getreceivedbyaddress("main", $row_transfer_deposit_address_a["address"], 0) / 10000 - $total_amount_extern; $new_amount = $total_amount - $row_transfer_deposit_address_a["last_check_amount"]; json_success(array("address" => $row_transfer_deposit_address_a["address"], "group" => $row_transfer_deposit_address_a["group"], "send_mail" => $row_transfer_deposit_address_a["send_mail"], "callback" => $row_transfer_deposit_address_a["callback"], "data" => $row_transfer_deposit_address_a["data"], "total_amount" => api_sc_format($total_amount), "pending_amount" => api_sc_format($pending_amount), "new_amount" => api_sc_format($new_amount))); } if (isset($_GET["a"])) { // 4.1.3 Get deposit address info by address $address = mysql_real_escape_string($_GET["a"], $db); //mysql_query("LOCK TABLES transfer_deposit_address WRITE, transfer_deposit WRITE, transaction WRITE"); $slt_transfer_deposit_address_a = "SELECT * FROM transfer_deposit_address WHERE address = '{$address}'"; $rlt_transfer_deposit_address_a = mysql_query($slt_transfer_deposit_address_a); $row_transfer_deposit_address_a = mysql_fetch_assoc($rlt_transfer_deposit_address_a); if ($row_transfer_deposit_address_a["user"] != $user_id) { json_error("Invalid address"); } brief_check(); $slt_transfer_deposit_a = "SELECT SUM(amount) AS amount FROM transfer_deposit WHERE deposit_address = '{$row_transfer_deposit_address_a['id']}'";