| Server IP : 147.93.80.58 / Your IP : 216.73.216.195 Web Server : LiteSpeed System : Linux id-dci-web1866.main-hosting.eu 5.14.0-503.38.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 18 08:52:10 EDT 2025 x86_64 User : u939086737 ( 939086737) PHP Version : 8.2.28 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u939086737/domains/chocolate-mouse-719686.hostingersite.com/public_html/action/ |
Upload File : |
<?php
include 'db_connect.php';
// error_reporting(0);
date_default_timezone_set("Asia/Kolkata");
// $shop = mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM shop"));
$comp_name = $shop['name'] = 'Vintage Glow';
$page = ucwords(pathinfo(str_replace('-', ' ', $_SERVER['PHP_SELF']), PATHINFO_FILENAME));
$path = '../user/assets/images/users/'; //Admin Side
$path2 = './assets/images/users/'; // User Side
$domain1 = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? "https" : "http") . "://$_SERVER[HTTP_HOST]"; //Get full domain name
function getDomain($url)
{
$pieces = parse_url($url);
$domain2 = isset($pieces['host']) ? $pieces['host'] : '';
if (preg_match('/(?P<domain>[a-z0-9][a-z0-9\-]{1,63}\.[a-z\.]{2,6})$/i', $domain2, $regs)) {
return $regs['domain'];
}
return FALSE;
}
$domain = getDomain($domain1); // Get only domain name without wwww
// //================Admin Change Password============================================
// if (isset($_POST['admin_change_pass'])) {
// $username = mysqli_real_escape_string($conn, $_POST['username']);
// $npass = mysqli_real_escape_string($conn, $_POST['npass']);
// $cpass = mysqli_real_escape_string($conn, $_POST['cpass']);
// if ($npass == $cpass) {
// mysqli_query($conn, "UPDATE `admin_login` SET `password`='$npass' WHERE `username`='$username' ");
// echo ' <script>alert("Update Successful !"); window.location.href="";</script> ';
// } else {
// echo ' <script>alert("Password Does Not Matched !"); window.location.href="";</script> ';
// }
// }
//======================= Add plan ========================================
if (isset($_POST['add_plan'])) {
$name = $_POST['name'];
$price = $_POST['price'];
$t_amt = $_POST['t_amt'];
$gst_amt = $_POST['gst_amt'];
$refer_by_bonus = $_POST['refer_by_bonus'];
$refer_to_bonus = $_POST['refer_to_bonus'];
$pairing_limit = $_POST['pairing_limit'];
$flush_out_policy = $_POST['flush_out_policy'];
$carry_forward = $_POST['carry_forward'];
$date = date('Y-m-d');
$sql = mysqli_query($conn, "INSERT INTO `plans`(`name`, `price`, `total_amount`, `gst_amount`, `refer_by_bonus`, `refer_to_bonus`, `pairing_limit`, `flush_out_policy`, `carry_forward`, `created_at`)
VALUES ('$name', '$price', '$t_amt', '$gst_amt', '$refer_by_bonus', '$refer_to_bonus', '$pairing_limit', '$flush_out_policy', '$carry_forward', '$date')");
echo '<script>window.location.href="";</script>';
}
//======================= Add plan ========================================
if (isset($_POST['add_upgrade_plan'])) {
$name = $_POST['name'];
$price = $_POST['price'];
$t_amt = $_POST['t_amt'];
$gst_amt = $_POST['gst_amt'];
// $refer_by_bonus = $_POST['refer_by_bonus'];
// $refer_to_bonus = $_POST['refer_to_bonus'];
$pairing_limit = $_POST['pairing_limit'];
$flush_out_policy = $_POST['flush_out_policy'];
// $carry_forward = $_POST['carry_forward'];
$date = date('Y-m-d');
// $sql = mysqli_query($conn, "INSERT INTO `plan_upgrade`(`name`, `price`, `total_amount`, `gst_amount`, `refer_by_bonus`, `refer_to_bonus`, `pairing_limit`, `flush_out_policy`, `carry_forward`, `created_at`)
// VALUES ('$name', '$price', '$t_amt', '$gst_amt', '$refer_by_bonus', '$refer_to_bonus', '$pairing_limit', '$flush_out_policy', '$carry_forward', '$date')");
$sql = mysqli_query($conn, "INSERT INTO `plan_upgrade`(`name`, `price`, `total_amount`, `gst_amount`, `pairing_limit`, `flush_out_policy`, `created_at`)
VALUES ('$name', '$price', '$t_amt', '$gst_amt', '$pairing_limit', '$flush_out_policy', '$date')");
echo '<script>window.location.href="";</script>';
}
// //======================= Update plan ========================================
if (isset($_POST['update_plan'])) {
$id = $_POST['id'];
$name = $_POST['name'];
$price = $_POST['price'];
$gst_amt = $_POST['gst_amt'];
$t_amt = $_POST['t_amt'];
$refer_by_bonus = $_POST['refer_by_bonus'];
$refer_to_bonus = $_POST['refer_to_bonus'];
$pairing_limit = $_POST['pairing_limit'];
$flush_out_policy = $_POST['flush_out_policy'];
$carry_forward = $_POST['carry_forward'];
$update = mysqli_query($conn, "UPDATE plans SET
name='$name',
price='$price',
gst_amount='$gst_amt',
total_amount='$t_amt',
refer_by_bonus='$refer_by_bonus',
refer_to_bonus='$refer_to_bonus',
pairing_limit='$pairing_limit',
flush_out_policy='$flush_out_policy',
carry_forward='$carry_forward'
WHERE id='$id'
");
if ($update) {
echo '<script>alert("Plan updated successfully!"); window.location.href="plans";</script>';
} else {
echo '<script>alert("Error updating plan!");</script>';
}
}
// //===================== Add Plan Level Comission =======================
if (isset($_POST['add_plan_level'])) {
// Collecting form data
$plan_id = $_POST['plan_id'];
$level = $_POST['level'];
$level_pair_limit = $_POST['level_pair_limit'];
$level_income = $_POST['level_income'];
$income_limit = $_POST['income_limit'];
$required_directs = $_POST['required_directs'];
$auto_upgrade_enabled = $_POST['auto_upgrade_enabled'];
// Current datetime
$created_at = date("Y-m-d H:i:s");
// Insert query
$query = "INSERT INTO `plan_level_commissions`
(`plan_id`, `level`, `level_pair_limit`, `level_income`, `income_limit`, `required_directs`, `auto_upgrade_enabled`, `created_at`)
VALUES
('$plan_id', '$level', '$level_pair_limit', '$level_income', '$income_limit', '$required_directs', '$auto_upgrade_enabled', '$created_at')";
// Run the query
if (mysqli_query($conn, $query)) {
echo "<script>alert('Plan level commission added successfully!'); window.location.href='';</script>";
} else {
echo "<script>alert('Error: " . mysqli_error($conn) . "');</script>";
}
}
// ====================== Update Plan Level Commision ==================
if (isset($_POST['update_plan_level'])) {
$id = $_POST['id'];
$plan_id = $_POST['plan_id'];
$level = $_POST['level'];
$level_pair_limit = $_POST['level_pair_limit'];
$level_income = $_POST['level_income'];
$income_limit = $_POST['income_limit'];
$required_directs = $_POST['required_directs'];
$auto_upgrade_enabled = $_POST['auto_upgrade_enabled'];
$updated_at = date("Y-m-d H:i:s");
$updateQuery = "UPDATE plan_level_commissions SET
plan_id = '$plan_id',
level = '$level',
level_pair_limit = '$level_pair_limit',
level_income = '$level_income',
income_limit = '$income_limit',
required_directs = '$required_directs',
auto_upgrade_enabled = '$auto_upgrade_enabled',
updated_at = '$updated_at'
WHERE id = '$id'";
if (mysqli_query($conn, $updateQuery)) {
echo "<script>alert('Plan level updated successfully'); window.location.href='./plan-level-commission';</script>";
} else {
echo "<script>alert('Update failed: " . mysqli_error($conn) . "');</script>";
}
}
//===================== User Activation =============================
//======================= ADMIN Approve Investment========================================
if (isset($_POST['user_active'])) {
$date = date('Y-m-d H:i:s');
$userid = $_POST['userid'];
$user = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM `users` WHERE username='$userid'"));
$sponsor_id = $user['ref_id'];
$user_id = $user['username'];
$pl = $_POST['plan'];
$plan = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM `plans` WHERE id = '$pl'"));
$plan_name = $plan['name'];
$total_amount = $plan['total_amount'];
$q2 = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM `payment_requests` WHERE userid = '$user_id'"));
if ($q2['status'] == 0) {
// UPDATE `payment_requests` SET `status`='[value-7]' WHERE userid = ''
mysqli_query($conn, "UPDATE `payment_requests` SET `status`=1, `accept_at` = '$date' WHERE userid = '$user_id'");
mysqli_query($conn, "UPDATE `users` SET `active_status`=1 WHERE username = '$user_id'");
mysqli_query($conn, "INSERT INTO `transactions`( `user_id`, `type`, `amount`, `referral_id`, `remarks`, `created_at`) VALUES ('$user_id','invest','$total_amount', '$sponsor_id ','$plan_name - First Investment','$date')");
// if ($amount >= 10 and $amount <= 100) {
// $plan = 'Basic ($ 10 - $ 100)';
// $month_count = 16;
// $mi = (12 / 100) * $amount;
// } elseif ($amount >= 110 and $amount <= 1000) {
// $plan = 'Advance ($ 110 - $ 1000)';
// $month_count = 13;
// $mi = (15 / 100) * $amount;
// } elseif ($amount >= 1100 and $amount <= 5000) {
// $plan = 'Silver ($ 1100 - $ 5000)';
// $month_count = 11;
// $mi = (18 / 100) * $amount;
// } elseif ($amount >= 5100 and $amount <= 25000) {
// $plan = 'Gold ($ 5100 - $ 25000)';
// $month_count = 9;
// $mi = (22.5 / 100) * $amount;
// }
// if (mysqli_num_rows($query12) == 1) {
// echo '<script> window.location.href="";</script> ';
// } else {
// echo ' <script> window.location.href="";</script> ';
// }
echo ' <script>alert("Accept Successful !"); window.location.href="";</script> ';
} else {
echo ' <script>alert(" Payment Not Success !"); window.location.href="";</script> ';
}
}