PNG  IHDR pHYs   OiCCPPhotoshop ICC profilexڝSgTS=BKKoR RB&*! J!QEEȠQ, !{kּ> H3Q5 B.@ $pd!s#~<<+"x M0B\t8K@zB@F&S`cbP-`'{[! eDh;VEX0fK9-0IWfH  0Q){`##xFW<+*x<$9E[-qWW.(I+6aa@.y24x6_-"bbϫp@t~,/;m%h^ uf@Wp~<5j>{-]cK'Xto(hw?G%fIq^D$.Tʳ?D*A, `6B$BB dr`)B(Ͱ*`/@4Qhp.U=pa( Aa!ڈbX#!H$ ɈQ"K5H1RT UH=r9\F;2G1Q= C7F dt1r=6Ыhڏ>C03l0.B8, c˱" VcϱwE 6wB aAHXLXNH $4 7 Q'"K&b21XH,#/{C7$C2'ITFnR#,4H#dk9, +ȅ3![ b@qS(RjJ4e2AURݨT5ZBRQ4u9̓IKhhitݕNWGw Ljg(gwLӋT071oUX**| J&*/Tު UUT^S}FU3S ԖUPSSg;goT?~YYLOCQ_ cx,!k u5&|v*=9C3J3WRf?qtN (~))4L1e\kXHQG6EYAJ'\'GgSSݧ M=:.kDwn^Loy}/TmG X $ <5qo</QC]@Caaᄑ.ȽJtq]zۯ6iܟ4)Y3sCQ? 0k߬~OCOg#/c/Wװwa>>r><72Y_7ȷOo_C#dz%gA[z|!?:eAAA!h쐭!ΑiP~aa~ 'W?pX15wCsDDDޛg1O9-J5*>.j<74?.fYXXIlK9.*6nl {/]py.,:@LN8A*%w% yg"/6шC\*NH*Mz쑼5y$3,幄'L Lݛ:v m2=:1qB!Mggfvˬen/kY- BTZ(*geWf͉9+̳ې7ᒶKW-X潬j9(xoʿܔĹdff-[n ڴ VE/(ۻCɾUUMfeI?m]Nmq#׹=TR+Gw- 6 U#pDy  :v{vg/jBFS[b[O>zG499?rCd&ˮ/~јѡ򗓿m|x31^VwwO| (hSЧc3- cHRMz%u0`:o_F@8N ' p @8N@8}' p '#@8N@8N pQ9p!i~}|6-ӪG` VP.@*j>[ K^<֐Z]@8N'KQ<Q(`s" 'hgpKB`R@Dqj '  'P$a ( `D$Na L?u80e J,K˷NI'0eݷ(NI'؀ 2ipIIKp`:O'`ʤxB8Ѥx Ѥx $ $P6 :vRNb 'p,>NB 'P]-->P T+*^h& p '‰a ‰ (ĵt#u33;Nt̵'ޯ; [3W ~]0KH1q@8]O2]3*̧7# *p>us p _6]/}-4|t'|Smx= DoʾM×M_8!)6lq':l7!|4} '\ne t!=hnLn (~Dn\+‰_4k)0e@OhZ`F `.m1} 'vp{F`ON7Srx 'D˸nV`><;yMx!IS钦OM)Ե٥x 'DSD6bS8!" ODz#R >S8!7ّxEh0m$MIPHi$IvS8IN$I p$O8I,sk&I)$IN$Hi$I^Ah.p$MIN$IR8I·N "IF9Ah0m$MIN$IR8IN$I 3jIU;kO$ɳN$+ q.x* tEXtComment

Viewing File: /home/u403625155/domains/onegrandholding.com/public_html/dashboard/sell-usdt.php

<?php
$pagename = "Sell Tether";
require "header.php";
$user_id = $_SESSION['user_id'];

$query = mysqli_query($conn, "SELECT balance, usd FROM users WHERE id='$user_id'");
if (mysqli_num_rows($query) > 0) {
    $row = mysqli_fetch_assoc($query);
    $rem_bal = $row['balance'];
    $coin = $row['usd'];
}

$usdtUrl = 'https://api.coincap.io/v2/assets/tether';
$usdtResponse = file_get_contents($usdtUrl);
$usdtData = json_decode($usdtResponse, true);

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $amount = $_POST['amount'];

    if ($coin >= $amount) {
        $usdtPrice = $usdtData['data']['priceUsd'];
        $equivalentValue = $amount * $usdtPrice;

        $new_coin_balance = $coin - $amount;
        $update_coin_query = "UPDATE users SET usd = $new_coin_balance WHERE id = $user_id";
        mysqli_query($conn, $update_coin_query);

        $new_balance = $rem_bal + $equivalentValue;
        $update_balance_query = "UPDATE users SET balance = $new_balance WHERE id = $user_id";
        mysqli_query($conn, $update_balance_query);

        echo "<script>
        swal('Success', 'You sold $amount Tether (USDT) for $$equivalentValue. Your balance has been updated.', 'success')
        .then((value) => {
            window.location.href = 'crypto.php';
        });
        </script>";

        exit;
    } else {
        echo "<script>
        swal('Error', 'Insufficient Tether (USDT) balance for this transaction', 'error');
        </script>";
    }
}
?>







<div class="container my-4 py-4">
    <div class="row my-4 py-4">
        <div class="col-lg-6 mx-auto">
            <div class="card mb-4">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <h3 class="mb-0">Convert USDT To Fiat
                        <br> (Balance -
                        <?php echo number_format($usd, 5); ?> USDT)
                    </h3>
                    <small class="text-muted float-end"></small>
                </div>
                <div class="card-body">
                    <form method="post">
                        <div class="mb-3">
                            <label class="form-label" for="basic-icon-default-company">Select A Coin</label>
                            <div class="input-group input-group-merge">
                                <span id="basic-icon-default-company2" class="input-group-text"><i
                                        class='bx bx-timer'></i></span>
                                <select class="form-control" style="color:#fff; background-color:#000;" name="currency"
                                    id="currency" required>
                                    <option value="bitcoin" selected readonly>USDT</option>
                                    <!-- Set Bitcoin as selected and readonly -->
                                </select>
                            </div>
                        </div>
                        <div class="mb-3">
                            <label class="form-label" for="basic-icon-default-email">Amount To Convert</label>
                            <div class="input-group input-group-merge">
                                <span class="input-group-text"><i class='bx bx-dollar-circle'></i></span>
                                <input type="number" name="amount" id="basic-icon-default-email" class="form-control"
                                    style="color:#fff; background-color:#000;" placeholder="Amount" aria-label="Amount"
                                    aria-describedby="basic-icon-default-email2" step="0.0000000001" required />
                            </div>

                        </div>
                        <button type="submit" class="btn btn-primary">Sell</button>
                    </form>

                </div>
            </div>
        </div>

    </div>
</div>


<?php require "footer.php"; ?>
Back to Directory=ceiIENDB`