All pastes #958144 Raw Edit

Untitled

public php v1 · immutable
#958144 ·published 2008-03-26 14:58 UTC
rendered paste body
<?phprequire_once('include/application_top.php');if(isset($_GET['b'])) {	$sql = "SELECT url					FROM banners					WHERE id = {$_GET['b']}					LIMIT 1";	$result = db_query($sql);	if(mysql_num_rows($result) === 1) {		$row = db_fetch_array($result);		$redirect_url = $row['url'];		$sql = "SELECT banner_id						FROM banners_activities						WHERE banner_id = {$_GET['b']}						AND date = NOW()";		$result = db_query($sql);		if(mysql_num_rows($result) === 0) {			$sql = "INSERT INTO banners_activities (banner_id, date, clicks)							VALUES ('{$_GET['b']}', NOW(), '1')";		} else {			$sql = "UPDATE banners_activities SET clicks = clicks + 1							WHERE banner_id = {$_GET['b']}							AND date = NOW()";		}		db_query($sql);		header('location:' . $redirect_url);	} else {		header('location:index.php');	}} else {	header('location:index.php');}?>