September 7th, 2008, 02:34 PM
|
|
Registered User
|
|
Join Date: Sep 2008
Posts: 27
Time spent in forums: 10 h 8 m 31 sec
Reputation Power: 0
|
|
Limit number of downloads per IP
Hi,
This is my first post in this forum. What this code suppose to do is to check whether user has download more than 3. If < 3 they will redirect to download.php page but if = 3 user will be redirect to index.php page.
This is the closes I can get but still one error left... what is wrong this code... 
PHP Code:
<?php
// every page needs to start with these basic things
// I'm using a separate config file. so pull in those values
require("config.inc.php");
// pull in the file with the database class
require("database.class.php");
// create the $db ojbect
$db = new Database($config['server'], $config['user'],
$config['pass'], $config['database'], $config['tablePrefix']);
// connect to the server
$db->connect();
$config['download_limit'] = 3;
// check database for their IP
$sql = "SELECT count(*) AS number FROM ".$db->pre."downloads
WHERE ip='$_SERVER[REMOTE_ADDR]'";
$iplocked = $db->query_first($sql);
// check to see if IP and/or cookie is over the limit
if($iplocked['number'] >= $config['download_limit'] ||
$_COOKIE['download_limit'] >= $config['download_limit']){
ob_start();
echo "over user limit error";
// YOU: exit or redirect them
header("Location: http://www.mypage.com/index.php");
ob_flush();
}
// they're good to go. allow download
else{
// insert their ip into database
$data = array('ip'=>$_SERVER['REMOTE_ADDR'], 'time'=>time());
$db->query_insert("downloads", $data);
// set a cookie too
setcookie("download_limit", ($_COOKIE['download_limit']+1), time() + 24 * 3600);
// YOU: send the user to the file
header("Location: http://www.mypage.com/download.php");
}
// and you're done, remember to close connection
$db->close();
This is what I run in phymyadmin:
Code:
CREATE TABLE `downloads` (
`id` int(11) auto_increment,
`ip` varchar(15) NOT NULL,
`time` TIME NOT NULL,
PRIMARY KEY (`id`)
)
This is the error:
Code:
Database Error
Message: Result ID: 1 could not be freed.
Date: Sunday, September 7, 2008 at 2:38:27 PM
Script: /lol/test.php
or view error image here > http://www.freeimagehosting.net/uploads/92954369b4.png
Any idea what Result ID : 1 could not be freed might be?? Problem with php code or database 
Thanks in advance.
Last edited by sg552 : September 8th, 2008 at 01:27 PM.
Reason: picture gone?
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
