[Parker Clack]

For the first file does this look ok?

<?php
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('THIS_SCRIPT', 'click');


// ######################### REQUIRE BACK-END ############################
require('./global.php');

$timenow = time();
$boarduser = $vbulletin->userinfo['userid'];

if(isset($bannerid))

{
	$banner =  $vbulletin->db->query_first("SELECT * FROM " . TABLE_PREFIX . "banner WHERE id='$bannerid'");
	$url = $banner['redirector_url'];
	
	if (!empty($boarduser))
	{
		$vbulletin->db->query("UPDATE banner SET " . TABLE_PREFIX . "userclicks=userclicks+1 WHERE id='$bannerid'");
		
		// is there a user in the table who still has clicked?
		$clickeduser = $vbulletin->db->query_first("SELECT * FROM " . TABLE_PREFIX . "userclicks WHERE userid='$boarduser' AND bannerid='$bannerid'");
		$clickeduser = $clickeduser['userid'];
		if(!empty($clickeduser))
			$vbulletin->db->query_first("UPDATE " . TABLE_PREFIX . "userclicks SET clicks=clicks+1 WHERE userid='$boarduser' AND bannerid='$bannerid'");
		else
			$vbulletin->db->query_first("INSERT INTO " . TABLE_PREFIX . "userclicks (userid, bannerid, clicks) VALUES ('$boarduser', '$bannerid', '1')");
	}
	else
		$vbulletin->db->query_first("UPDATE banner SET " . TABLE_PREFIX . "guestclicks=guestclicks+1 WHERE id='$bannerid'");
	
	header("Location:$url");
}
else
	echo	("Please Include an ID!");
?>

and for the second

<?php

// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('THIS_SCRIPT', 'view');

// ###################### Start init #######################

require("../includes/config.php");
$servername=$config['MasterServer']['servername'];
$dbusername=$config['MasterServer']['username'];
$dbpassword=$config['MasterServer']['password'];
$dbname=$config['Database']['dbname'];
$db=mysql_connect($servername,$dbusername,$dbpassword) or die("Can't open connection to MySQL");

mysql_select_db($dbname) or die("Can't select database");


if(isset($bannerid))
{
	$banner = $vbulletin->db->query_first("SELECT * FROM " . TABLE_PREFIX . "banner WHERE id='$bannerid'");
	$url = $banner['url_to_banner'];
	
	$update = $vbulletin->db->query_first("UPDATE " . TABLE_PREFIX . "banner SET views=views+1 WHERE id='$bannerid'");
		
	header("Location:$url");
}
else
	echo	("Please Include an ID!");
?>

Thanks