View difference between Paste ID: f373bdff6 and
SHOW: | | - or go back to the newest paste.
1-
1+
<?php
2
	/* 
3
	*  Subject: Track Banner Clicks on Magento
4
	*  Post Origin: http://www.magentocommerce.com/wiki/how_to/how_to_add_jw_image_gallery_xml-flash
5
	*
6
	*  Creator: Bruno Alexandre
7
	*  Creation date: 08 January 2010
8
	*/
9
10
	date_default_timezone_set('UTC');
11
12
	// ######################################################################  Get Database Settings
13
	$dbprefix = "";
14
	$xml    = simplexml_load_file('../app/etc/local.xml');
15
	$dbhost = $xml->global->resources->default_setup->connection->host;
16
	$dbuser = $xml->global->resources->default_setup->connection->username;
17
	$dbpw   = $xml->global->resources->default_setup->connection->password;
18
	$dbname = $xml->global->resources->default_setup->connection->dbname;
19
	if ($xml->global->resources->db->table_prefix != "") 
20
		$dbprefix = $xml->global->resources->db->table_prefix . ".";
21
22
	// for debug proposes, so you know it is loading the right values
23
	/**
24
	echo "<br/>dbhost: ".$dbhost.
25
		 "<br/>dbuser: ".$dbuser.
26
		 "<br/>dbpw: ".$dbpw.
27
		 "<br/>dbname: ".$dbname.
28
		 "<br/>dbprefix: ".$dbprefix."<br/>";
29
	die();
30
	**/
31
		
32
	// ######################################################################  Get Banner Information
33
	$referer  = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '';	// from witch page got here
34
	$qstring  = isset($_SERVER['QUERY_STRING']) ? $_SERVER['QUERY_STRING'] : '';	// what is the full query string info
35
	$addid    = isset($_GET['adid']) ? $_GET['adid'] : '';				// advertisement ID
36
	$landing  = isset($_GET['page']) ? $_GET['page'] : '';				// landing page (if none, will redirect to last line)
37
	$date     = date(DATE_RFC822);							// current date
38
	$clientIp = getenv("REMOTE_ADDR");						// client IP
39
40
	// ######################################################################  Create Insert Statement
41
	mysql_connect($dbhost,$dbuser,$dbpw);	
42
	@mysql_select_db($dbname) or die("Unable to select database");
43
		
44
	$query = "INSERT INTO " . $dbprefix . "ads_tracking " .
45
			 "(ad_datetime, ad_referer, ad_click, ad_clientip, ad_querystring) " .
46
			 "VALUES " .
47
			 "(NOW(), '$referer', '1', '$clientIp', '$addid');";
48
	
49
	// ######################################################################  Execute Insert Statement
50
	$result = mysql_query($query);
51
	if (!$result) {
52
		//die('Invalid query: ' . mysql_error());
53
	}
54
	mysql_close();	
55
56
	// ######################################################################  Redirect User to Landing Page
57
	if(strlen($landing) > 0)
58
		header("Location: $landing");
59
	else
60
		header("Location: http://www.mydomain.com/");				// TODO: Add your Store URL here
61
?>