Downloads script help

kazuki

Hi,

I was wondering on how to create a script
that counts the no. of times of an image or program
has been downloaded.

Eg.

example.zip has been downloaded 2840 times.

Are there free scripts of this kind available for it's use?

Help!:😕

rIkLuNd

Yes, there are lots of free scripts out on the net, but these kind of scripts are quite easy to create. The only thing I'm haveing difficulties with are creating a function that will show the number of downloads. I can do it with just plain php, but it's quite hard to do it every time I want to show the download count...

rIkLuNd

This is the script that I've created. You refer to a file as ...?id=1,2,3 and so on...

<?php

$host = "localhost";
$user = "root";
$pass = "";
$db = "downloads";

if(isset($id))
{
if(empty($id))
{
print "You must specify a file";
}
else
{
$connect = mysql_connect($host,$user,$pass);
if(!$connect)
die(mysql_error());

$select = mysql_select_db($db);
if(!$select)
die(mysql_error());

$get = mysql_query("SELECT * FROM downloads WHERE id='$id'");
if(!$get)
die(mysql_error());

$row = mysql_fetch_assoc($get);
if(!$row)
die(mysql_error());

$row[clicks]++;

$add = mysql_query("UPDATE downloads SET clicks='$row[clicks]' WHERE id='$id'");
if(!$add)
die(mysql_error());

$close = mysql_close($connect);

header("Location: $row[link]");
}
}
else
{
print "You must specify a file";
}
?>