File Manager

Editing File: /home/quiczmwg/public_html/dashboard.php

<?php
// Start the session
session_start();

// Check if the 'userid' session is set
if (!isset($_SESSION['userid'])) {
    echo "Session 'userid' not set. Redirecting to login.";
    header("Location: ./login.php");
    exit();
}

// Include database connection and other necessary files
require_once('_db.php');

// Set the user ID from the session variable
$userid = $_SESSION['userid'];

// Fetch user information from the database based on userid
$sqlUser = "SELECT userid, username, account_balance, created_at FROM user_login WHERE userid = ?";
if ($stmt = $conn->prepare($sqlUser)) {
    $stmt->bind_param("s", $userid); // Use "s" for string type
    if ($stmt->execute()) {
        $stmt->bind_result($userid, $username, $account_balance, $created_at);
        $stmt->fetch();
        $stmt->close();
    } else {
        echo "Error executing user query: " . $stmt->error;
    }
} else {
    echo "Error preparing user query: " . $conn->error;
}

// Fetch the last deposit date
$sqlLastDeposit = "SELECT MAX(created_at) AS last_deposit_date FROM deposit WHERE userid = ?";
if ($stmt = $conn->prepare($sqlLastDeposit)) {
    $stmt->bind_param("s", $userid);
    if ($stmt->execute()) {
        $stmt->bind_result($lastDepositDate);
        $stmt->fetch();
        $stmt->close();
    } else {
        echo "Error executing last deposit query: " . $stmt->error;
    }
} else {
    echo "Error preparing last deposit query: " . $conn->error;
}

// Fetch the total deposit made by the user
$sqlTotalDeposit = "SELECT SUM(amount) AS total_deposit FROM deposit WHERE userid = ?";
if ($stmt = $conn->prepare($sqlTotalDeposit)) {
    $stmt->bind_param("s", $userid);
    if ($stmt->execute()) {
        $stmt->bind_result($totalDeposit);
        $stmt->fetch();
        $stmt->close();
    } else {
        echo "Error executing total deposit query: " . $stmt->error;
    }
} else {
    echo "Error preparing total deposit query: " . $conn->error;
}

// Fetch the earned total (profit_balance) from the user_login table
$sqlEarnedTotal = "SELECT profit_balance FROM user_login WHERE userid = ?";
if ($stmt = $conn->prepare($sqlEarnedTotal)) {
    $stmt->bind_param("s", $userid);
    if ($stmt->execute()) {
        $stmt->bind_result($earnedTotal);
        $stmt->fetch();
        $stmt->close();
    } else {
        echo "Error executing earned total query: " . $stmt->error;
    }
} else {
    echo "Error preparing earned total query: " . $conn->error;
}

// Fetch the pending withdrawal amount
$sqlPendingWithdrawal = "SELECT SUM(amount) AS pending_withdrawal FROM withdrawals WHERE userid = ? AND status = 'pending'";
if ($stmt = $conn->prepare($sqlPendingWithdrawal)) {
    $stmt->bind_param("s", $userid);
    if ($stmt->execute()) {
        $stmt->bind_result($pendingWithdrawal);
        $stmt->fetch();
        $stmt->close();
    } else {
        echo "Error executing pending withdrawal query: " . $stmt->error;
    }
} else {
    echo "Error preparing pending withdrawal query: " . $conn->error;
}

// Fetch the confirmed withdrawal amount
$sqlConfirmedWithdrawal = "SELECT SUM(amount) AS confirmed_withdrawal FROM withdrawals WHERE userid = ? AND status = 'confirmed'";
if ($stmt = $conn->prepare($sqlConfirmedWithdrawal)) {
    $stmt->bind_param("s", $userid);
    if ($stmt->execute()) {
        $stmt->bind_result($confirmedWithdrawal);
        $stmt->fetch();
        $stmt->close();
    } else {
        echo "Error executing confirmed withdrawal query: " . $stmt->error;
    }
} else {
    echo "Error preparing confirmed withdrawal query: " . $conn->error;
}
?>

<!DOCTYPE html>
<html lang="ru">
<head>
    <meta charset="UTF-8">
    <title>Quick-wittedtraded</title>
    <meta content="width=1200" name="viewport">
    <meta name="format-detection" content="telephone=no">

<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/sweetalert2@10.16.3/dist/sweetalert2.min.css">
    <script src="https://cdn.jsdelivr.net/npm/sweetalert2@10.16.3/dist/sweetalert2.all.min.js"></script>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/limonte-sweetalert2/7.2.0/sweetalert2.min.css">
    <script src="https://cdnjs.cloudflare.com/ajax/libs/limonte-sweetalert2/7.2.0/sweetalert2.all.min.js"></script>

</head>
<body>
    <section class="wrapper">
                    <div class="lkPage">
                <div class="lineLeftLk">
                    <div class="logo invsLink">
                        <a href="dashboard.php?a=home"></a>
                        <img src="img/logo.png" alt="">
                    </div>
                    <button class="menuBtn">
                        <span></span>
                        <span></span>
                        <span></span>
                        <span></span>
                    </button>
                    <div class="menuLk">
                    <ul>
                        <li class="invisLink active">
                            <a href="dashboard.php?a=account"></a>
                            <span class="iconBl icon-user-icon-3"></span>
                            <span class="txt">user<br> area</span>
                        </li>
                        <li class="invisLink">
                            <a href="deposit.php?a=deposit"></a>
                            <span class="iconBl icon-plus-icon"></span>
                            <span class="txt">make a<br> deposit</span>
                        </li>
                        <li class="invisLink">
                            <a href="inevest_now.php?a=deposit"></a>
                            <span class="iconBl icon-plus-icon"></span>
                            <span class="txt">make a<br> Invesment</span>
                        </li>
                        <li class="invisLink">
                            <a href="transaction.php?a=deposit_list"></a>
                            <span class="iconBl icon-files-and-folders-1"></span>
                            <span class="txt">your<br> deposit</span>
                        </li>
                        <li class="invisLink">
                            <a href="withdraw.php?a=withdraw"></a>
                            <span class="iconBl icon-business-and-finance-3"></span>
                            <span class="txt">withdraw<br> funds</span>
                        </li>
                        <li class="invisLink">
                            <a href="transaction.php?a=earnings"></a>
                            <span class="iconBl icon-time-and-date-1"></span>
                            <span class="txt">operation<br> history</span>
                        </li>
                        <li class="invisLink">
                            <a href="change_password.php"></a>
                            <span class="iconBl icon-time-and-date-1"></span>
                            <span class="txt">Change<br> Password</span>
                        </li>

<li class="invisLink">
                            <a href="logout.php?a=logout"></a>
                            <span class="iconBl icon-placeholder-44"></span>
                            <span class="txt">Logout</span>
                        </li>                            
                    </ul>
                    </div>
                </div>
                <div class="lkLeft">
                <div class="welcomeBl">
                    <span class="desr">Welcome,</span>
                    <span class="name"><?php echo htmlspecialchars($username); ?></span>
                    <ul>
                        <li>
                            <span class="tit">Registration date:</span>
                            <span class="time"><?php echo date('M-d-Y', strtotime($created_at)); ?></span>
                        </li>
                    </ul>
                    <a href="index.php?a=home" class="btn btnYellow">Main page</a>
                </div> 
                    <div class="balanceBl" id="balance">
                            <span class="tit">Your balance:</span>
                            
                            <span class="value">$ <?php echo number_format($account_balance, 2); ?></span>

</div>
                       
                     <div class="listBalance" id="infodata">
                                                    <div class="item">
                                <span class="iconBl" style="background-image: url(img/ps_g/18.png);"></span>
                                <span class="val">0.00 <span class="cur">$</span></span>
                            </div>
                                                    <div class="item">
                                <span class="iconBl" style="background-image: url(img/ps_g/43.png);"></span>
                                <span class="val">0.00 <span class="cur">$</span></span>
                            </div>
                                                    <div class="item">
                                <span class="iconBl" style="background-image: url(img/ps_g/48.png);"></span>
                                <span class="val">0.00 <span class="cur">$</span></span>
                            </div>
                                                    <div class="item">
                                <span class="iconBl" style="background-image: url(img/ps_g/68.png);"></span>
                                <span class="val">0.00 <span class="cur">$</span></span>
                            </div>
                                                    <div class="item">
                                <span class="iconBl" style="background-image: url(img/ps_g/79.png);"></span>
                                <span class="val">0.00 <span class="cur">$</span></span>
                            </div>
                                                    <div class="item">
                                <span class="iconBl" style="background-image: url(img/ps_g/69.png);"></span>
                                <span class="val">0.00 <span class="cur">$</span></span>
                            </div>
                                                    <div class="item">
                                <span class="iconBl" style="background-image: url(img/ps_g/77.png);"></span>
                                <span class="val">0.00 <span class="cur">$</span></span>
                            </div>
                             </div>
                </div>
                <div class="lkRight">

<h2 class="capTitle">User area</h2>
<div class="accountBl">
    <div class="left">
    <div class="col colorGreen">
    <div class="line">
        <span class="iconBl icon-upload-3"></span>
        <span class="tit">Last deposit</span>
        <span class="val"><?php echo $lastDepositDate ? date("Y-m-d", strtotime($lastDepositDate)) : 'n/a'; ?><span class="cur">$</span></span>
    </div>

<div class="line">
        <span class="iconBl icon-upload-3"></span>
        <span class="tit">Total deposit</span>
        <span class="val"><?php echo $totalDeposit ? number_format($totalDeposit, 2) : '0.00'; ?><span class="cur">$</span></span>
    </div>
</div>
        <div class="col colorYellow">
        <div class="line">
    <span class="iconBl icon-download-16"></span>
    <span class="tit">Earned total</span>
    <span class="val"><?php echo number_format($earnedTotal, 2); ?><span class="cur">$</span></span>
</div>
<div class="line">
    <span class="iconBl icon-download-16"></span>
    <span class="tit">Pending withdrawal</span>
    <span class="val"><?php echo number_format($pendingWithdrawal, 2); ?><span class="cur">$</span></span>
</div>
<div class="line">
    <span class="iconBl icon-download-16"></span>
    <span class="tit">Withdraw total</span>
    <span class="val"><?php echo number_format($confirmedWithdrawal, 2); ?><span class="cur">$</span></span>
</div>
     
        </div>
    </div>
    <div class="right">
        <div class="youline" id="upline">
            <span class="iconBl fonicon1 icon-user-33"></span>
            <ul>
                <li>
                    <span class="tit">Your upline:</span>
                                            <span class="name"></span>                        
                                    
                </li>

</ul>
        </div>
    </div>
       
    <div id="popup1" class="popup">
        <span class="close" onclick="closePopup(1)">&times;</span>
        <p>Someone from South Korea just made a withdrawal of $45000.</p>
    </div>
    <div id="popup2" class="popup" style="display: none;">
        <span class="close" onclick="closePopup(2)">&times;</span>
        <p>Someone from Israel just made a withdrawal of $12500.</p>
    </div>
    <div id="popup3" class="popup" style="display: none;">
        <span class="close" onclick="closePopup(3)">&times;</span>
        <p>Someone from Netherlands just made a withdrawal of $3500.</p>
    </div>
    <div id="popup4" class="popup" style="display: none;">
        <span class="close" onclick="closePopup(4)">&times;</span>
        <p>Someone from Australia just made a withdrawal of $35000.</p>
    </div>
    <div id="popup5" class="popup" style="display: none;">
        <span class="close" onclick="closePopup(5)">&times;</span>
        <p>Someone from France just made a withdrawal of $7000.</p>
    </div> 
</div>

</div>
 
 <script>
        // Function to show the popups sequentially
        window.onload = function() {
            setTimeout(function() {
                openPopup(1);
            }, 1000); // Show the first popup after 1 second
        };

function openPopup(popupNumber) {
            var popupId = 'popup' + popupNumber;
            document.getElementById(popupId).style.display = 'block';

// Show the next popup after closing the current one
            var nextPopupNumber = popupNumber + 1;
            setTimeout(function() {
                if (nextPopupNumber <= 5) {
                    openPopup(nextPopupNumber);
                }
            }, 5000); // Show the next popup after 5 seconds
        }

// Function to close the popup
        function closePopup(popupNumber) {
            var popupId = 'popup' + popupNumber;
            document.getElementById(popupId).style.display = 'none';
        }
    </script>
<script>
    $.ajax({
        url: "?a=referals",
        context: document.body
    }).done(function(data) {      
        $('#upline').html($(data).find('#upline').html());            
    });
</script>

</div>
            <div class="lineRightLk">
                <div class="infoLine">
                    <div class="top">
                        <div class="socialBl">
                            <ul>
                               
                                <li><a href="#"><span class="iconBl icon-telegram"></span></a></li>
                                    
                            </ul>
                        </div>
                        
                        <div class="linksBlock">
                            <ul>
                                
                                <li>
                                    <span class="iconBl icon-mail-6"></span>
                                    <span class="tit">E-mail: </span>
                                    <a href="mailto:quickwittedtradedorg@gmail.com" class="mail">quickwittedtradedorg@gmail.com</a>
                                </li>
                                <li>
                                    <span class="iconBl icon-calendar-50"></span>
                                    <span class="tit">Working days: </span>
                                    <span class="txt">Daily<br> 24/7</span>
                                </li>
                            </ul>
                        </div>
                        <div class="copy"><p>© 2013 - <script> document.write(new Date().getFullYear())</script> Copyright <a href="#" class="light text-decoration-none">Quick-wittedtraded</a>. All rights reserved </p></div>
                    </div>
                </div>
            </div>
        </div>

</section>
    <div id="google_translate_element" style="text-align: left; padding: 10px;"></div>
    <canvas class='canvas'></canvas>
</footer>

<script type="text/javascript">
function googleTranslateElementInit() {
    new google.translate.TranslateElement({
        pageLanguage: 'en',
        layout: google.translate.TranslateElement.InlineLayout.SIMPLE
    }, 'google_translate_element');
}
</script>

</body>
    
</html>

Back to Directory File Manager