A better click counter for the proxy List script

[proxies2u]

Hi,

just wrote some tutorial for a safer click counter on proxy list script sites:

the code you should use for your "count_hits.php" file is:

PHP Code:

if (empty($_GET['url'])) {
    $url = 'http://www.yoursite.com/';
} else {
    if (get_magic_quotes_gpc()) $_GET['url'] = stripslashes($_GET['url']);
    $gURL = mysql_real_escape_string($_GET['url']);
    $result = mysql_query("SELECT ident FROM links WHERE ident = '".$gURL."'");
    if (mysql_num_rows($result) == 1) {
        $id = mysql_result($result, 0, 'ident');
        $IP = mysql_real_escape_string($_SERVER['REMOTE_ADDR']);
        $time_diff = 3600*24*14; // count ones in 14 days
        $sql = sprintf("SELECT COUNT(*) AS testval FROM clicks WHERE ip_adr = '%s' AND click_time+%d > NOW() AND site_id = %d", $IP, $time_diff, $id);
        $res = mysql_query($sql) or die(mysql_error());
        $test = mysql_result($res, 0, 'testval');
        if ($tell == 0) {
            mysql_query(sprintf("INSERT INTO clicks SET ip_adr = '%s', site_id = %d", $IP, $gURL));
        }
    } else {
        $url = 'http://www.yoursite.com/';
    }
}
header('Location: '.$url);
exit; 


Check the original URL for database preparations and further information:
Count clicks the right way! | Web Development Blog

I hope this will help, don't forget empty your clicks database table once in a few month!

[WebEvader.org]

Thanks for this, very useful code

[proxies2u]

Originally Posted by WebEvader.org

Thanks for this, very useful code

You're welcome after visiting your site I remembered that the code from my own list is very easy to integrate in many listing sites.

[fear1]

It was very nice and useful but my proxy list had this from the first day.

[proxies2u]

Originally Posted by fear1

It was very nice and useful but my proxy list had this from the first day.

You don't! Check also the comment on my blog site

[Aquarezz]

Great!
I made a post about it on my proxy blog!
Check it out here: ProxLists.Com Weblog :: Tips :: A better click counter for the proxy List script

Greetz and thanks

[Aquarezz]

I don't understand, in this script (count_hits.php) where to add your code?


<?php

include "config.php";

$url=$_GET['url'];

$link = mysql_connect($db_host,$db_user,$db_pass);

mysql_select_db($db_name);

$query = "SELECT * FROM submission WHERE url='$url';";

$result = mysql_query($query) or die("d");

$line = mysql_fetch_row($result);

if ($line[5]==""){$line[5]=0;}

$count=$line[5]+1;

$query="UPDATE `submission` SET `url` = '$line[0]',`category` = '$line[1]',`email` = '$line[2]', `status` = '$line[3]', `time` = '$line[4]', `hits` = '$count' WHERE `url` = '$url' LIMIT 1 ;";

$result = mysql_query($query) or die("<font color=red>QUERY FALLED</font><br>");

mysql_close($link);

Header("Location: $url");

?>

[proxies2u]

you need to replace the code, the original code is really BAD

[mori]

tanks this is what i needed. If you have some more nice fixes or new options for this script pm. Mayby i can share my code too... see Unblock blocked sites with web proxies

I have date see:
http://unblocked.me/recent.php

and i have special sections youtube myspace etc...Very good for seo!

[proxies2u]

Mori,

you have a great list but the script is really bad written and is missing important features.

compare your listings with them on proxyroll.com