Bonjour,
je voudrait rajouter quelque chose dans ce code php qui permettrer de compter une fois l'ip du visiteur
je voudrait rajouter quelque chose dans ce code php qui permettrer de compter une fois l'ip du visiteur
Code:
<?php
require("databaseselect.php");
include("include/functions.php");
$image = checkerr($_POST['text']);
$uip = getIP();
$image = mysql_real_escape_string($image);
?>
<html>
<head>
<meta charset="ISO-8859-1">
<title> AdsLink.be | Réducteur de lien rémunérer </title>
<script type="text/javascript">
// 30 seconds on the clock to start with
var timer = 5;
function countdown() {
timer--;
var countdownArea = document.getElementById("area");
countdownArea.innerHTML = timer;
if (timer == 0) {
// time to show the button!
countdownArea.innerHTML = "<br><form method='POST'><input type='hidden' name='text'><input type='image' name='image' src='skipad.png'></form>";
} else {
// calling this function again in 1000 microseconds (1 second)
setTimeout('countdown()', 1000);
}
}
</script>
<style type="text/css">
</style>
</head>
<body onload="countdown();" style="margin:0; padding:0;">
<?php
$code = checkerr($_GET['code']);
$code = mysql_real_escape_string($code);
$query = mysql_query("SELECT * FROM items WHERE code='$code'");
$numrows = mysql_num_rows($query);
if (isset($_POST['text'])) {
if($numrows == 1){
$row = mysql_fetch_assoc($query);
$url = $row['url'];
if (false === strpos($url, '://')) {
$url = 'http://' . $url;
}
echo"<script type='text/javascript'>window.location.replace('$url'); </script>";
}
else
die ("No Shortened url was found");
mysql_close();
}
?>
<?php
$q = mysql_query("SELECT * FROM settings WHERE id='1'");
$qa = mysql_fetch_array($q);
$ppv = $qa['ppv'];
$ppr = $qa['ppr'];
?>
<?php
$qq = mysql_query("SELECT * FROM items WHERE code='$code'");
$qarray = mysql_fetch_assoc($qq);
$usernamm = $qarray['username'];
?>
<?php
$querycheck = mysql_query("SELECT * FROM ipcheck WHERE username='$code' AND ip='$uip'");
$rowip = mysql_num_rows($querycheck);
if ($rowip == 0) {
$ipadd = mysql_query("INSERT INTO ipcheck (username,ip) VALUES ('$code','$uip')");
$addin = mysql_query("UPDATE members SET balance=balance + $ppv WHERE username='$usernamm'");
$referalcheck = mysql_query("SELECT * FROM members WHERE username='$usernamm'");
$referalfetch = mysql_fetch_array($referalcheck);
$referalname = $referalfetch['refid'];
if ($referalname != "none") {
$addbalref = mysql_query("UPDATE members SET balance=balance + $ppr WHERE username='$referalname'");
}
$graphup = mysql_query("UPDATE graphdetails SET date7=date7+1 WHERE username='$usernamm'");
$hitupdate = mysql_query("UPDATE members SET hits=hits+1 WHERE username='$usernamm'");
$targettingcheck = mysql_query("SELECT * FROM advertisers WHERE targetted=1 AND active=1 AND credits1 > 0 ") or die(mysql_error());
$notarget = 0;
$j = 0;
$cadlist = array();
if(mysql_num_rows($targettingcheck))
{
$ip = $_SERVER['REMOTE_ADDR'];
$ip_number = sprintf("%u", ip2long($ip));
$country_query = "SELECT `country_name` FROM `ip2country` WHERE `begin_ip_num`<=$ip_number AND `end_ip_num`>=$ip_number";
$country_exec = mysql_query($country_query);
$ccode_array = @mysql_fetch_array($country_exec);
$country_name = $ccode_array['country_name'];
$j = -1;
while($tarrow = mysql_fetch_array($targettingcheck))
{
$countrylist = explode(",",$tarrow['countries']);
$i = 0;
while($countrylist[$i] != "")
{
if($countrylist[$i] == $country_name)
{
$j++;
$cadlist[$j] = $tarrow['id'];
$notarget = 1;
}
$i++;
}
}
}
if($notarget == 0)
{
$query = mysql_query("SELECT * FROM advertisers WHERE targetted=0 AND active=1 AND credits1 > 0 ORDER BY RAND() LIMIT 0 , 1");
$numrows = mysql_num_rows($query);
if($numrows == 1)
{
$row = mysql_fetch_assoc($query);
$url = $row['myurl1'];
$id = $row['id'];
$url2 = $row['credits1'];
$url3 = $url2 - 1;
mysql_query("UPDATE advertisers SET credits1 = '$url3' WHERE id='$id'");
}
}
else
{
$randid = rand(0,$j);
$adverid = $cadlist[$randid];
$query = mysql_query("SELECT * FROM advertisers WHERE id='$adverid'");
if($numrows == 1)
{
$row = mysql_fetch_assoc($query);
$url = $row['myurl1'];
$id = $row['id'];
$url2 = $row['credits1'];
$url3 = $url2 - 1;
mysql_query("UPDATE advertisers SET credits1 = '$url3' WHERE id='$id'");
}
}
}
else {
$targettingcheck = mysql_query("SELECT * FROM advertisers WHERE targetted=1 AND active=1 AND credits1 > 0 ") or die(mysql_error());
$notarget = 0;
$j = 0;
$cadlist = array();
if(mysql_num_rows($targettingcheck))
{
$ip = $_SERVER['REMOTE_ADDR'];
$ip_number = sprintf("%u", ip2long($ip));
$country_query = "SELECT `country_name` FROM `ip2country` WHERE `begin_ip_num`<=$ip_number AND `end_ip_num`>=$ip_number";
$country_exec = mysql_query($country_query);
$ccode_array = @mysql_fetch_array($country_exec);
$country_name = $ccode_array['country_name'];
$j = -1;
while($tarrow = mysql_fetch_array($targettingcheck))
{
$countrylist = explode(",",$tarrow['countries']);
$i = 0;
while($countrylist[$i] != "")
{
if($countrylist[$i] == $country_name)
{
$j++;
$cadlist[$j] = $tarrow['id'];
$notarget = 1;
}
$i++;
}
}
}
if($notarget == 0)
{
$query = mysql_query("SELECT * FROM advertisers WHERE targetted=0 AND active=1 AND credits1 > 0 ORDER BY RAND() LIMIT 0,1");
$numrows = mysql_num_rows($query);
if($numrows ==1)
{
$row = mysql_fetch_assoc($query);
$url = $row['myurl1'];
}
}
else
{
$randid = rand(0,$j);
$adverid = $cadlist[$randid];
$query = mysql_query("SELECT * FROM advertisers WHERE id='$adverid'");
$row = mysql_fetch_array($query);
$url = $row['myurl1'];
}
}
?>
<div style="width: auto; margin:0;"><div style="float:left;"><img src="/img/logo.png">
<span style="font-size:18px;"><strong><span style="color:#000000;"> <strong><span style="font-size:14px;"><a href="http://urllll.be/register.php"><span style="color:#000000;">Gagner de l'argent avec vos liens</span></a> / <a href="http://urlll.be/register.php"><span style="color:#000000;"><span class="hps" title="Cliquer ici pour voir d'autres traductions">Earn</span> <span class="hps" title="Cliquer ici pour voir d'autres traductions">money with</span> <span class="hps" title="Cliquer ici pour voir d'autres traductions">your</span> <span class="hps" title="Cliquer ici pour voir d'autres traductions">link</span></span></a></span></strong></p></div><div id="area" align="right" style="width: 100%; height: 90px; background: url(images/fond.png) repeat-x;"><br><img src="loading.gif"></div> </div>
<iframe src='<?php echo"$url"; ?>' border='0' framespacing='0' marginheight='0' marginwidth='0' vspace='0' hspace='0' frameborder='0' height='100%' scrolling='auto' width='100%' id='site' allowtransparency='true'></iframe></div>
</body>
</html>