Server : LiteSpeed System : Linux nl-srv-web1396.main-hosting.eu 4.18.0-553.83.1.lve.el8.x86_64 #1 SMP Wed Nov 12 10:04:12 UTC 2025 x86_64 User : u107206879 ( 107206879) PHP Version : 7.2.34 Disable Function : NONE Directory :  /home/u107206879/domains/escort46.de/public_html/admin/service/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
	include "../db_connection.php";
	include "../sessioncheck.php";
	
	if(isset($_POST['trans']) && ($_POST['trans']=='change') && !empty($_POST['trans']) && isset($_POST['value']) && !empty($_POST['value'])){
		$id = $_POST['value'];
		$status = $_POST['status'];
		$preStatus = $status;
		if($status == '1')
		{
			$status = 0;
			$qry = "UPDATE payment SET payment_status='Pending' WHERE id=$id";
		}
		elseif($status == '0')
		{
			$status = 1;
			$qry = "UPDATE payment SET payment_status='Completed' WHERE id=$id";
		}
		$sql=mysqli_query($connection,$qry);
		
		if($preStatus == '0')
		{
			/*
			
			
			Array
			(
				[id] => 25
				[ad_id] => 340
				[payment_type] => Bankwire
				[paypal_txn_id] => 
				[plan_type] => Gold_30
				[plan_id] => 3
				[sub_plan_id] => 3
				[rec_amount] => 9.00
				[currency] => EUR
				[payer_email] => [email protected]
				[payer_id] => 
				[payment_date] => 2022-07-27
				[payment_status] => Completed
				[paypal_payload] => Bankwired by user, waiting from admin to approve trasaction
			)
			
			// Boost			
			Array
			(
				[id] => 23
				[ad_id] => 340
				[payment_type] => Bankwire
				[paypal_txn_id] => 
				[plan_type] => Boost
				[plan_id] => 4
				[sub_plan_id] => 3
				[rec_amount] => 36.00
				[currency] => EUR
				[payer_email] => [email protected]
				[payer_id] => 
				[payment_date] => 2022-07-27
				[payment_status] => Completed
				[paypal_payload] => Boost Bankwired by user, waiting from admin to approve trasaction
			)
			
			// Plan array 
			Array
			(
				[id] => 3
				[plan] => Boost
				[plan_days] => 30
				[plan_name] => Boost_30
				[plan_id] => 4
				[sub_plan_id] => 3
				[amount] => 36.00
				[currency] => EUR
				[status] => Active
				[payment_link] => https://v.ht/eses36
			)
			*/
			$query = "SELECT * FROM `payment` WHERE `id` = $id";
			$result = fetchOneRow($query);
			//pre($result);
			
			if($result)
			{
				if($result['plan_type'] == 'Boost')
				{
					$table = "boost_plan";
				}
				else
				{
					$table = "plans";
				}
				$queryGetPlan = "SELECT * FROM `".$table."` WHERE `plan_id` = ".$result['plan_id']." AND `sub_plan_id` = ".$result['sub_plan_id'];
				$getPlanResult = fetchOneRow($queryGetPlan);
				//pre($getPlanResult);
				
				//Get ads data 
				
				$queryGetAds = "SELECT * FROM `advertise` WHERE `id` = ".$result['ad_id'];
				$getAdsResult = fetchOneRow($queryGetAds);
				$ad_id = $getAdsResult['id'];
				//pre($getAdsResult);
				
				//ads Data
				$boost_start_date = $getAdsResult['boost_start_date']; // 2020-04-21 01:31:04
				$boost_end_date = $getAdsResult['boost_end_date']; // 2022-11-30 01:31:07
				
				
				$plan_start_date = $getAdsResult['start_date']; // 2019-10-02 00:40:23
				$plan_end_date = $getAdsResult['end_date']; // 2026-02-10 14:45:13
				
				$update_date = $getAdsResult['update_date']; // 2022-07-28 02:00:04
				
				$plan_id = $getPlanResult['plan_id'];
				$planDays = $getPlanResult['plan_days'];
				
				$currentDate = date("Y-m-d H:i:s");
				
				if($result['plan_type'] == 'Boost')
				{
					if($boost_end_date < $currentDate )
					{
						$date = new DateTime($currentDate);
						$date->add(new DateInterval('P'.$planDays.'D')); // P1D means a period of 1 day
						$newEndDate = $date->format('Y-m-d H:i:s');
						
						$boost_start_date = $currentDate;
						$boost_end_date = $newEndDate;
					}
					else
					{
						$date = new DateTime($boost_end_date);
						$date->add(new DateInterval('P'.$planDays.'D')); // P1D means a period of 1 day
						$newEndDate = $date->format('Y-m-d H:i:s');

						$boost_start_date = $boost_start_date;
						$boost_end_date = $newEndDate;
					}
					
					//$getAdsResult;
					//pre("Boost--");
					$data = array(
						"boost" 			=> 1,
						"boost_start_date" 	=> $boost_start_date,
						"boost_end_date"	=> $boost_end_date,
						"update_date"		=> $currentDate
					);
				}
				else
				{
					
					if($plan_end_date < $currentDate )
					{
						
						$date = new DateTime($currentDate);
						$date->add(new DateInterval('P'.$planDays.'D')); // P1D means a period of 1 day
						$newEndDate = $date->format('Y-m-d H:i:s');
						
						$plan_start_date = $currentDate;
						$plan_end_date = $newEndDate;	
					}
					else
					{
						$date = new DateTime($plan_end_date);
						$date->add(new DateInterval('P'.$planDays.'D')); // P1D means a period of 1 day
						$newEndDate = $date->format('Y-m-d H:i:s');
						
						$plan_start_date = $plan_start_date;
						$plan_end_date = $newEndDate;
					}
					$data = array(
						"plan_id" 		=> $plan_id,
						"start_date" 	=> $plan_start_date,
						"end_date"		=> $plan_end_date,
						"update_date"	=> $currentDate
					);
				}
				//pre($data);
				
				$dataUpdate = update('advertise', $data, 'id='.$ad_id);
				
			}
		}
		if($sql){			 
			echo '1';
		}
    }
?>