Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

balexandre

By: a guest on Jan 7th, 2010  |  syntax: PHP  |  size: 2.58 KB  |  hits: 109  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
This paste has a previous version, view the difference. Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  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. ?>
create a new version of this paste RAW Paste Data