File "dashboard.php"
Full path: /home/quiczmwg/lightspringdigitals.com/../../quiczmwg/public_html/dashboard.php
File size: 18.92 KiB (19376 bytes)
MIME-type: text/x-php; charset=utf-8
Charset: utf-8
Download Open Edit Advanced Edit Back
<?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="shortcut icon" href="favicon.ico" type="image/x-icon">
<link rel="icon" href="favicon.ico" type="image/x-icon">
<link rel="stylesheet" type="text/css" href="fonts/icomoon/style.css" />
<link rel="stylesheet" type="text/css" href="fonts/stylesheet.css" />
<link rel="stylesheet" type="text/css" href="css/jquery-ui.min.css" />
<link rel="stylesheet" type="text/css" href="css/selectric.css" />
<link rel="stylesheet" type="text/css" href="css/owl.carousel.min.css" />
<link rel="stylesheet" type="text/css" href="css/animate.css" />
<link rel="stylesheet" type="text/css" href="css/style.css" />
<link rel="stylesheet" type="text/css" href="css/responsive.css" />
<!-- Include SweetAlert CSS and JS via CDN -->
<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>
<script type="text/javascript" src="js/jquery-3.3.1.min.js"></script>
<script type="text/javascript" src="js/detect.min.js"></script>
<script type="text/javascript" src="js/jquery-ui.min.js"></script>
<script type="text/javascript" src="js/jquery.selectric.min.js"></script>
<script type="text/javascript" src="js/owl.carousel.min.js"></script>
<script type="text/javascript" src="js/clipboard.min.js"></script>
<script type="text/javascript" src="js/wow.min.js"></script>
<script type="text/javascript" src="js/clock.js"></script>
<script type="text/javascript" src="js/modal.js"></script>
<script type="text/javascript" src="js/script.js"></script>
<!-- Start of HubSpot Embed Code -->
<script type="text/javascript" id="hs-script-loader" async defer src="//js-eu1.hs-scripts.com/145918011.js"></script>
<!-- End of HubSpot Embed Code -->
<!-- <script src="//code.jivosite.com/widget/jaS5xGD7Od" async></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($row['account_balance'], 2); ?></span> -->
<span class="value">$ <?php echo number_format($account_balance, 2); ?></span>
<!-- <span class="value"></?php echo $row['username']; ?></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>
<!-- Popup containers -->
<div id="popup1" class="popup">
<span class="close" onclick="closePopup(1)">×</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)">×</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)">×</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)">×</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)">×</span>
<p>Someone from France just made a withdrawal of $7000.</p>
</div>
</div>
<!-- <a href="?a=referallinks" class="btn btnGreen">Promo banners</a> -->
</div>
<!-- Additional script for the popups -->
<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>
<!-- Google Translate script -->
<script type="text/javascript">
function googleTranslateElementInit() {
new google.translate.TranslateElement({
pageLanguage: 'en',
layout: google.translate.TranslateElement.InlineLayout.SIMPLE
}, 'google_translate_element');
}
</script>
<script type="text/javascript" src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script>
<!--Start of Tawk.to Script-->
<!-- <script type="text/javascript">
var Tawk_API=Tawk_API||{}, Tawk_LoadStart=new Date();
(function(){
var s1=document.createElement("script"),s0=document.getElementsByTagName("script")[0];
s1.async=true;
s1.src='https://embed.tawk.to/663575c307f59932ab3bb03c/default';
s1.charset='UTF-8';
s1.setAttribute('crossorigin','*');
s0.parentNode.insertBefore(s1,s0);
})();
</script> -->
</body>
</html>