<%@ LANGUAGE="VBSCRIPT" %>
<% Response.Buffer = True %>

<%
'***********************************************************************
'   System     :   ASPBanner											
'   Author     :   Christopher Williams of CJWSoft www.CJWSoft.com		
'																		
'                         COPYRIGHT NOTICE								
'																		
'   See attached Software License Agreement								
'																		
'   (c) Copyright 2000 - 2001 by CJWSoft.			 All rights reserved
'***********************************************************************
%>

<!--#INCLUDE FILE="dataconn_inc.asp"-->
<!--#INCLUDE FILE="config_inc.asp"-->

<%
Banner_ID = Request("Banner_ID")
	
Set ConnPasswords = Server.CreateObject("ADODB.Connection")
ConnPasswords.Open BannerConnectionString
Set cmdTemp = Server.CreateObject("ADODB.Command")
Set CmdUpdateStats = Server.CreateObject("ADODB.Recordset")
	
If 	BannerDatabaseType = "SQL" Then
	cmdTemp.CommandText = "SELECT Banner_Stats.* FROM Banner_Stats WHERE (Banner_ID = " & Banner_ID & ") AND Banner_Day = '" & DATE & "'"
ElseIf BannerDatabaseType = "MSACCESS" Then
	cmdTemp.CommandText = "SELECT Banner_Stats.* FROM Banner_Stats WHERE (Banner_ID = " & Banner_ID & ") AND Banner_Day = #" & DATE & "#"
End IF
	
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = ConnPasswords
CmdUpdateStats.Open cmdTemp, , 1, 3
	
CmdUpdateStats.Fields("Banner_Clicks") = (CmdUpdateStats("Banner_Clicks") + 1)
CmdUpdateStats.Update
CmdUpdateStats.Close
Set CmdUpdateStats = Nothing
	
Set ConnPasswords = Server.CreateObject("ADODB.Connection")
ConnPasswords.Open BannerConnectionString
Set cmdTemp = Server.CreateObject("ADODB.Command")
Set CmdRetrieveBannerInfo = Server.CreateObject("ADODB.Recordset")
cmdTemp.CommandText = "SELECT Banners.* FROM Banners WHERE Banner_ID = " & Banner_ID
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = ConnPasswords
CmdRetrieveBannerInfo.Open cmdTemp, , 0, 1
	
Banner_Link_URL = CmdRetrieveBannerInfo("Banner_Link_URL")
	
CmdRetrieveBannerInfo.Close
Set CmdRetrieveBannerInfo = Nothing
	
ConnPasswords.Close
Set ConnPasswords = Nothing	
	
	
Response.Redirect Banner_Link_URL
%>