<?php
include('inc/conf.php');
$getid = explode('/', $_GET['id']);
$id = intval(wu_decode($getid[1]));

$nw = mysqli_fetch_assoc(mysqli_query($connect_db, "SELECT id,n,url FROM `t_news_links` WHERE id = '$id' LIMIT 1"));
$n = $nw['n'];

//Статистика
$crabs_sub = intval($_COOKIE['sub']);
$nowday = date('Ymd',$dt);

$isday = mysqli_num_rows(mysqli_query($connect_db, "SELECT id FROM t_news_links_stat WHERE lnk = '$id' AND ymd = '$nowday' LIMIT 1"));
if ($crabs_sub > 0) {
mysqli_query($connect_db, "UPDATE `t_news_links` SET `clk` = `clk`+1, `s".$crabs_sub."_clk` = `s".$crabs_sub."_clk`+1 WHERE id = '$id' LIMIT 1");
mysqli_query($connect_db, "UPDATE `t_news` SET `lnkclick` = `lnkclick`+1, `s".$crabs_sub."_lnkclick` = `s".$crabs_sub."_lnkclick`+1 WHERE id = '$n' LIMIT 1");
if ($isday == 0) {
mysqli_query($connect_db, "INSERT INTO t_news_links_stat (lnk,n,ymd,clk,s".$crabs_sub."_clk) VALUES ('$id','$n','$nowday','1','1')");
} else {
mysqli_query($connect_db, "UPDATE `t_news_links_stat` SET `clk` = `clk`+1, `s".$crabs_sub."_clk` = `s".$crabs_sub."_clk`+1 WHERE lnk = '$id' AND ymd = '$nowday' LIMIT 1");
}
} else {
mysqli_query($connect_db, "UPDATE `t_news_links` SET `clk` = `clk`+1 WHERE id = '$id' LIMIT 1");
mysqli_query($connect_db, "UPDATE `t_news` SET `lnkclick` = `lnkclick`+1 WHERE id = '$n' LIMIT 1");
if ($isday == 0) {
mysqli_query($connect_db, "INSERT INTO t_news_links_stat (lnk,n,ymd,clk) VALUES ('$id','$n','$nowday','1')");
} else {
mysqli_query($connect_db, "UPDATE `t_news_links_stat` SET `clk` = `clk`+1 WHERE lnk = '$id' AND ymd = '$nowday' LIMIT 1");
}
}

$isday2 = mysqli_num_rows(mysqli_query($connect_db, "SELECT id FROM t_news_stat WHERE n = '$n' AND ymd = '$nowday' LIMIT 1"));
if ($crabs_sub > 0) {
if ($isday2 == 0) {
mysqli_query($connect_db, "INSERT INTO t_news_stat (n,ymd,lnkclick,s".$crabs_sub."_lnkclick) VALUES ('$n','$nowday','1','1')");
} else {
mysqli_query($connect_db, "UPDATE `t_news_stat` SET `lnkclick` = `lnkclick`+1, `s".$crabs_sub."_lnkclick` = `s".$crabs_sub."_lnkclick`+1 WHERE n = '$n' AND ymd = '$nowday' LIMIT 1");
}
} else {
if ($isday2 == 0) {
mysqli_query($connect_db, "INSERT INTO t_news_stat (n,ymd,lnkclick) VALUES ('$n','$nowday','1')");
} else {
mysqli_query($connect_db, "UPDATE `t_news_stat` SET `lnkclick` = `lnkclick`+1 WHERE n = '$n' AND ymd = '$nowday' LIMIT 1");
}
}

//Замена макросов
$macros_oid = 'none';
$macros_nid = $n;
if (isset($_COOKIE['sid1'])) { $macros_sid1 = $_COOKIE['sid1']; } else { $macros_sid1 = 'none'; }
if (isset($_COOKIE['sid2'])) { $macros_sid2 = $_COOKIE['sid2']; } else { $macros_sid2 = 'none'; }
if (isset($_COOKIE['sub']) && $_COOKIE['sub'] > 0) { $macros_sub = $_COOKIE['sub']; } else { $macros_sub = 'none'; }

$endlink = str_replace('[OID]',$macros_oid,$nw['url']);
$endlink = str_replace('[NID]',$macros_nid,$endlink);
$endlink = str_replace('[SID1]',$macros_sid1,$endlink);
$endlink = str_replace('[SID2]',$macros_sid2,$endlink);
$endlink = str_replace('[SUBID]',$macros_sub,$endlink);

header ("Location: ".$endlink);
exit;