Support Thread for Supertracker Contribution

[jennec]

Hey all,

I have a problem with my refferals in PPC. If I look in the above corner of de adwords campaign is see: total refferals 27.

I have 2 search words and after each words stands by refferals 1 so this doesn't match. And when I try to follow the link he counts 1 refferal more at the total but not with the words seperate.

Can someone please help me?

My code is below:

 

<-unnessecary coding deleted for this post->



$ppc = array ('google' => array ('title' => 'Google België 01 sexshop', 'keywords' => 'seksshop:seksshop,erotische:erotische,sex_shop:sex shop,erotica:erotica,erotheek:erotheek,erotiek_shop:erotiek shop,sexshops:sexshops,sex_shops:sex shops,erotisch:erotisch,sexshop:sexshop,erotiekshop:erotiekshop,erotika:erotika,
seks_shop:seks shop,sexwinkels:sexwinkels,sexwinkel:sexwinkel,erotiekshops:erotiekshops,erotiek
winkel:erotiekwinkel,eroteek:eroteek,erotiek_be:erotiek be,erotiekwinkels:erotiekwinkels,erotiek_nl:erotiek nl,seks_shops:seks shops,erotisme:erotisme,erotiekpagina:erotiekpagina,erotieksites:erotieksites,er
otieksite:erotieksite,erotieklink:erotieklink,erotieklinks:erotieklinks,sexschop:
sexschop'),
'google1' => array ('title' => 'Google België Porno', 'keywords' => 'porno_films:porno films,sex_dvd:sex dvd,pornofilm:pornofilm,pornodvd:pornodvd,erotiek_film:erotiek film,erotiek_films:erotiek films,private_dvd:private dvd,erotiekfilm:erotiekfilm,sexdvd:sexdvd,erotiekfilms:erotiekfilms'),
'google2' => array ('title' => 'Google België Lingerie voor haar', 'keywords' => 'sexy_lingerie:sexy lingerie,panty:panty\'s,string:string,nylon_kousen:nylon kousen,bh:bh,slipjes:slipjes,sexylingerie:sexylingerie,erotische_lingerie:erotis
che lingerie,netkousen:netkousen,sexy_strings:sexy strings,catsuit:catsuit,sexy_pantys:sexy panty\'s,g_strings:g string,jarretellen:jarretellen,strings:strings,sexy_schoenen:sexy schoenen,sexy_slipjes:sexy slipjes,lingerie_erotiek:lingerie erotiek,nachtkleed:nachtkleed,sexy_slipje:sexy slipje,catsuits:catsuits,sexy_laarzen:sexy laarzen,sexy_jurkjes:sexy jurkjes,sexy_catsuit:sexy catsuit,tepel_juweel:tepel juweel,luxe_lingerie:luxe lingerie,lingerie_erotisch:lingerie erotisch,vrouwen_string:vrouwen string,kimono:kimono,vrouwen_strings:vrouwen strings,nachthemd:nachthemd,sexy_bodys:sexy body\'s,erotische_lingerie_online:erotische lingerie online,nightdress:nightdress,sexy_kimono:sexy kimono,bhs:bh\'s,lederen_laarzen:lederen laarzen,babydoll_string:babydoll & string,babydollmetstring:babydoll met string,bh_setjes:bh setjes,corsage_setje:corsage setje,diamand_tattoo:diamand tattoo,erotische_lingerie_voor_haar:erotische lingerie voor haar,jarretellen_set:jarretellen set,jarretellen_setjes:jarretellen setjes')
);

//Set the following to true to enable the PPC referrer report							
//Eventually, this will probably be moved into the configuration menu
//in admin, where it really should be!

define ('SUPERTRACKER_USE_PPC', true);				

// ********** PAY PER CLICK CONFIGURATION SECTION EOF ************

<-unnessecary coding deleted for this post->

 //PPC Summary report
  if ($HTTP_GET_VARS['special'] == 'ppc_summary') {
    echo '<table width="100%" border=0 cellspacing=0 cellpadding=5 style="border:1px solid #000;">';     
     foreach ($ppc as $ref_code => $details) {
         $scheme_name = $details['title'];
           $keywords = $details['keywords'];

         $ppc_q = "SELECT * from supertracker where landing_page like '%ref=" . $ref_code . "%'";
           $ppc_result = tep_db_query ($ppc_q);
           $ppc_num_refs = tep_db_num_rows($ppc_result);
           echo '<tr><td colspan="4" style="font-weight:bold;text-decoration:underline;">' . $scheme_name . '(ref='.$ref_code.') - Totale Verwijzingen ' . $ppc_num_refs . '</td></tr>';
// display headings
           echo '<tr class="dataTableHeadingRow"><td class="dataTableHeadingContent">  (referentie):Zoekwoord</td>';
           echo '<td class="dataTableHeadingContent">Verwijzingen</td><td class="dataTableHeadingContent">Gemiddelde tijd</td><td class="dataTableHeadingContent">Gemiddeld aantal kliks</td>';
           echo '<td class="dataTableHeadingContent"># Aangekocht</td><td class="dataTableHeadingContent">Conversie</td>';

           if ($keywords != '%') {
             $keyword_array = explode(',',$keywords);
             foreach ($keyword_array as $key => $val) {
               $colon_pos = strpos ($val, ':');
                 $keyword_code = substr($val,0,$colon_pos);
                 $keyword_friendly_name = substr($val,$colon_pos+1,strlen($val)-$colon_pos);
                 $ppc_key_q = "SELECT *, count(*) as count, AVG(num_clicks) as ave_clicks, AVG(UNIX_TIMESTAMP(last_click) - UNIX_TIMESTAMP(time_arrived))/60 as ave_time from supertracker where landing_page like '%ref=" . $ref_code . "&keyw=" . $keyword_code . "%' group by landing_page";
                 $ppc_key_result = tep_db_query($ppc_key_q);
                   $ppc_row = tep_db_fetch_array($ppc_key_result);
                 $ppc_key_refs = $ppc_row['count'];

                 // conversion data
               $ppc_key_p_sql = "SELECT COUNT(*) as conversions FROM supertracker where landing_page like '%ref=" . $ref_code . "&keyw=" . $keyword_code . "%' and completed_purchase='true'";
               $ppc_key_p_array = tep_db_fetch_array(tep_db_query($ppc_key_p_sql));

               if ($ppc_key_p_array['conversions'] == 0)
                   $conversion_rate  = 0;
               else
                   $conversion_rate = ($ppc_key_p_array['conversions']/$ppc_key_refs)*100;

//test
                 echo '<tr class="dataTableContent"><td>('.$keyword_code.'):'.$keyword_friendly_name.'</td>';
                 echo '<td> '.$ppc_key_refs.'</td><td> '.number_format($ppc_row['ave_time'],2).'</td><td> '.number_format($ppc_row['ave_clicks']).'</td>';
                 echo '<td> '.$ppc_key_p_array['conversions'].'</td><td> '.number_format($conversion_rate,2).'%</td>';

             }
           }
       }
       echo '</table>';

    }//End PPC Summary Report	

Edited November 7, 2007 by jennec

[Guest]

I have been using the contrib for a while now, I must say its extremely useful. Have a problem though:

 

I have an ad on lycos, see link below its based in the header, on clicking the link in lycos supertracker alway see's it as direct access/bookmark.

 

Could somebody help to make it that it shows it correct link.

 

http://search.lycos.co.uk/cgi-bin/pursuit?...ets&cat=loc

Edited November 22, 2007 by blagger

[AlexStudio]

For those considering this contribution, here are my thoughts after using it for about a year. First of all, I'd have to say it is a nice contrib and provides useful info. However, it places a huge demand on your server having to query and find each IP record each and every time someone visits a page. So we have decided to uninstall it and use google analytics exclusively, which is free and provides the same data excluding it does not provide the page on which someone added to cart and dropped unfortunately :'( . We came to this decision after we forgot to remove old data for a couple of months and saw our average page loading time go from about 2 seconds to 5.6 seconds slowly over those couple of months and couldn't figure out why until we realized we had let data in supertacker build for about 2.5 months. As soon as we deleted the old data however it shot back down to about 2 seconds and when we removed the supertracker code it got even faster, about 1.6 seconds. So these are our experiences, take from it what you will. I'd have to say it is a nice contrib and provides useful info, it is just too intensive on server queries for us.

When the supertracker table grows it can drag down the page parsing speed significantly. This problem can be avoid by adding a second supertracker_temp table in database which only contains 7 fields for referencing including tracking_id, customer_id, ip_address, browser_string, cart_total and last_click, and an auto_increment temp_id as primary key. Then modify the supertracker class to delete records in this supertracker_temp table which are older than an hour, to keep it as small as possible. And when a new visitor arrives, only check in this supertracker_temp table for existing tracking data, so it can be really quick. Finally when logging data into supertracker table, make a copy to the supertracker_temp table as well so the records within last 60 minutes are synchronized in both tables.

[concorde44]

When the supertracker table grows it can drag down the page parsing speed significantly. This problem can be avoid by adding a second supertracker_temp table in database which only contains 7 fields for referencing including tracking_id, customer_id, ip_address, browser_string, cart_total and last_click, and an auto_increment temp_id as primary key. Then modify the supertracker class to delete records in this supertracker_temp table which are older than an hour, to keep it as small as possible. And when a new visitor arrives, only check in this supertracker_temp table for existing tracking data, so it can be really quick. Finally when logging data into supertracker table, make a copy to the supertracker_temp table as well so the records within last 60 minutes are synchronized in both tables.

Sounds good! But Have you a more detailed How to... with a text file to apply what you say ? and the php amendments code for this contrib ?

It could be very helpful.

TIA.

Seb

[AlexStudio]

OK, this is based on the 3.2b package dated 21 Mar 2006 by mr_absinthe.

How to create a second referencing table for supertracker

So it won't drag down the page parsing speed when supertracker data grows really large.

 

1. Create the referencing database table - Run this script in phpMyAdmin:

CREATE TABLE `supertracker_temp` (
 `temp_id` bigint(20) NOT NULL auto_increment,
 `tracking_id` bigint(20) NOT NULL default '0',
 `customer_id` int(11) NOT NULL default '0',
 `ip_address` varchar(40) NOT NULL default '',
 `browser_string` varchar(255) NOT NULL default '',
 `cart_total` int(11) NOT NULL default '0',
 `last_click` datetime NOT NULL default '0000-00-00 00:00:00',
 PRIMARY KEY  (`temp_id`)
) ;

2. Modify catalog/includes/classes/supertracker.php

Find at around line 194:

		 $query = "INSERT INTO `supertracker` (`ip_address`, `browser_string`, `country_code`, `country_name`, `referrer`,`referrer_query_string`,`landing_page`,`exit_page`,`time_arrived`,`last_click`) VALUES ('" . $ip . "','" . $browser_string . "','" . $country_code . "', '" . $country_name . "', '" . $referrer . "', '" . $query_string . "','" . $landing_page . "','" . $current_page . "','" . $time_arrived . "','" . $time_arrived . "')";		 
		 tep_db_query($query);

Add immediately after:

		  $tracking_id = tep_db_insert_id();
	  tep_db_query("insert into supertracker_temp (tracking_id, ip_address, browser_string, last_click) values ('" . $tracking_id . "', '" . $ip . "', '" . $browser_string . "', '" . $time_arrived . "')");

Find at around line 166:

			  $query = "UPDATE supertracker set last_click='" . $last_click . "', exit_page='" . $current_page . "', num_clicks='" . $num_clicks . "', added_cart='" . $added_cart . "', categories_viewed='" . $categories_viewed . "', products_viewed='" . $products_viewed . "', customer_id='" . $cust_id . "', completed_purchase='" . $completed_purchase . "', cart_contents='" . $cart_contents . "', cart_total = '" . $cart_total . "', order_id = '" . $order_id . "' where tracking_id='" . $tracking_id . "'";
		tep_db_query($query);

Add immediately after:

		$query_temp = "update supertracker_temp set last_click='" . $last_click . "', customer_id='" . $cust_id . "', cart_total = '" . $cart_total . "' where tracking_id='" . $tracking_id . "'";
	  tep_db_query($query_temp);

Find at around line 101:

		  //Having worked out if we have a new or existing user session lets record some details....!
	  if ($existing_session) {
	   //Existing tracked session, so just update relevant existing details
		$tracking_data = tep_db_fetch_array($result);
		$tracking_id = $tracking_data['tracking_id'];

Replace with:

		  //Having worked out if we have a new or existing user session lets record some details....!
	  if ($existing_session) {
	   //Existing tracked session, so just update relevant existing details
		$temp_data = tep_db_fetch_array($result);
			  $tracking_id = $temp_data['tracking_id'];
			  $tracking_query = tep_db_query("select * from supertracker where tracking_id = '" . $tracking_id . "'");
			  $tracking_data = tep_db_fetch_array($tracking_query);

Find at around line 92:

			  $query = "select * from supertracker where cart_total ='" . $cart->show_total() . "'  and last_click > '" . $thirty_mins_ago . "'";
		  $result = tep_db_query($query);

Replace with:

		  $query = "select tracking_id from supertracker_temp where cart_total ='" . $cart->show_total() . "'  and last_click > '" . $thirty_mins_ago . "'";
	  $result = tep_db_query($query);

Find at around line 81:

			$query = "select * from supertracker where browser_string ='" . $browser_string . "' and ip_address like '" . $ip_start . "%' and last_click > '" . $thirty_mins_ago . "'";
		$result = tep_db_query($query);

Replace with:

			$query = "select tracking_id from supertracker_temp where browser_string ='" . $browser_string . "' and ip_address like '" . $ip_start . "%' and last_click > '" . $thirty_mins_ago . "'";
		$result = tep_db_query($query);

Find at around line 67:

			$query = "select * from supertracker where customer_id ='" . $customer_id . "'  and last_click > '" . $thirty_mins_ago . "'";
		$result = tep_db_query($query);

Replace with:

			$query = "select tracking_id from supertracker_temp where customer_id ='" . $customer_id . "'  and last_click > '" . $thirty_mins_ago . "'";
		$result = tep_db_query($query);

Find at around line 57:

		  $thirty_ago_timestamp = strtotime("now") - (30*60);
	  $thirty_mins_ago = date('Y-m-d H:i:s', $thirty_ago_timestamp);

Add immediately after:

		  $sixty_ago_timestamp = strtotime("now") - (60*60);
	  $sixty_mins_ago = date('Y-m-d H:i:s', $sixty_ago_timestamp);
	  tep_db_query("delete from supertracker_temp where last_click < '" . $sixty_mins_ago . "'");

That's it.

[technophobe]

I have installed to the readme file, and i think i followed to the tee, but i get this error.

 

 

1054 - Unknown column 'agent' in 'field list'

 

INSERT INTO `supertracker` (`ip_address`, `browser_string`, `country_code`, `country_name`, `referrer`,`referrer_query_string`,`landing_page`,`exit_page`,`time_arrived`,`last_click`, `agent`) VALUES ('82.3.131.233','Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.9) Gecko/20071025 Firefox/2.0.0.9','gb', 'United Kingdom', '', '','/','/index.php','2007-11-24 10:53:28','2007-11-24 10:53:28','')

 

[TEP STOP]

 

I have also checked and the database has been updated with the supertracker table.

 

Any help would be much appreciated..

[technophobe]

OK, i needed to alter the database for agent.

ALTER TABLE `supertracker` ADD `agent` VARCHAR(255) NULL;

 

 

I have installed to the readme file, and i think i followed to the tee, but i get this error.

1054 - Unknown column 'agent' in 'field list'

 

INSERT INTO `supertracker` (`ip_address`, `browser_string`, `country_code`, `country_name`, `referrer`,`referrer_query_string`,`landing_page`,`exit_page`,`time_arrived`,`last_click`, `agent`) VALUES ('82.3.131.233','Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.9) Gecko/20071025 Firefox/2.0.0.9','gb', 'United Kingdom', '', '','/','/index.php','2007-11-24 10:53:28','2007-11-24 10:53:28','')

 

[TEP STOP]

 

I have also checked and the database has been updated with the supertracker table.

 

Any help would be much appreciated..

[Guest]

I have been using the contrib for a while now, I must say its extremely useful. Have a problem though:

 

I have an ad on lycos, see link below its based in the header, on clicking the link in lycos supertracker alway see's it as direct access/bookmark.

 

Could somebody help to make it that it shows it correct link.

 

http://search.lycos.co.uk/cgi-bin/pursuit?...ets&cat=loc

 

 

Has anyone got a clue how I can fix this problem?

[SHOP4M]

Hi

 

just wondering if their is a new update contribution coming soon,

 

i see from the support thread for supertracker contribution there has been update and changes

 

i'm just about to add few new feature's to my website and this is one of them

 

by they looks and comments in this support thread, this contribution is great piece of work. :thumbsup:

 

Thanks

Mark

[SHOP4M]

LAST MESSAGE SHOULD HAVE BEEN LIKE THIS:-

by they looks and comments in this support thread, this contribution is great piece of work. thumbsup.gif

thanks Mark for this contribution

 

Thanks

Tahir

 

right back to the issue i have i have installed 3.2b and is working fine, i also have who's online 3.3 install

 

i have notice that in who's online 3.3, i'm looking for this file but i'm not

Online Name IP Address Entry Last Click Last URL

00:09:51 Guest Admin 14:16:23 14:26:14 /admin/includes/menu.js

 

it's trying to find this file since i have install the 3.2b, and don't have the file

 

i did find this in /admin/supertracker.php

<script language="javascript" src="includes/menu.js"></script> what is this for?

<script language="javascript" src="includes/general.js"></script>

 

i found that someone els did as the Question but no answer

http://www.oscommerce.com/forums/index.php?showtopic=193869

 

do i need the file?? what is it for?? should just delete???

 

Thanks

Tahir

[pulp2]

Just got done installing, I'm getting an error that I see some people have already posted about but can't seem to find a solution.

 

 

The error is:

 

 

 

Warning: fopen(includes/GeoIP.dat) [function.fopen]: failed to open stream: No such file or directory in /home/***/public_html/includes/geoip.inc on line 322

 

Warning: ftell(): supplied argument is not a valid stream resource in /home/***/public_html/includes/geoip.inc on line 276

 

Warning: fseek(): supplied argument is not a valid stream resource in /home/***/public_html/includes/geoip.inc on line 277

 

etc...

 

I realize that it thinks that I'm missing this file in root folder/includes/geoip.inc but I've quadruple checked and its there. Thinking it might be corrupted I've even tried to replace the geoip.inc with earlier version and this does not work either.

 

Any ideas?

 

Thanks!

[pulp2]

Please. Anyone?

[♥FWR Media]

I realize that it thinks that I'm missing this file in root folder/includes/geoip.inc

Any ideas?

 

Yup it's not looking for /includes/geoip.inc

 

It's looking for includes/GeoIP.dat

[pulp2]

Yup it's not looking for /includes/geoip.inc

 

It's looking for includes/GeoIP.dat

 

 

Thanks Robert Fisher. Not sure how I missed that. I appreciate your help!

[Simmi0505]

Warning: fopen(includes/GeoIP.dat) [function.fopen]: failed to open stream: No such file or directory in /home/***/public_html/includes/geoip.inc on line 322

 

Warning: ftell(): supplied argument is not a valid stream resource in /home/***/public_html/includes/geoip.inc on line 276

 

Warning: fseek(): supplied argument is not a valid stream resource in /home/***/public_html/includes/geoip.inc on line 277

 

etc...

 

Thanks!

 

 

I am new to this and also had the above problem. There have been several questions in this thread about this problem which didnt resolve it for me - probably because it is so obvious to those more experienced. Anyway for future newbies, the solution to my problem was:

 

In step 5 the file downloaded from http://www.maxmind.com/app/geoip_country is GeoIP.dat.gz - which is a compressed file. It must be decompressed with WinAce or similar and the decompressed file (GeoIP.dat) uploaded to the /catalog/includes folder.

[wargaming]

I've just installed this contrib and dont think i've done anything wrong my admin side works fine but my shop side has this error

 

 

1054 - Unknown column 'agent' in 'field list'

INSERT INTO `supertracker` (`ip_address`, `browser_string`, `country_code`, `country_name`, `referrer`,`referrer_query_string`,`landing_page`,`exit_page`,`time_arrived`,`last_click`, `agent`) VALUES ('86.4.233.148','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)','gb', 'United Kingdom', '', '','/store/index.php','/store/index.php','2008-02-17 18:33:18','2008-02-17 18:33:18','')

[TEP STOP]

 

 

anyone have any ideas what I could have done wrong

Thanks :blush:

[wargaming]

problem solved answer was within this topic I hadn't added the database line :blush:

[tanicos]

OK, i needed to alter the database for agent.

ALTER TABLE `supertracker` ADD `agent` VARCHAR(255) NULL;

thank you very much

[GothicBeast]

I just added Supertracker to my site.

 

The instructions did not include:

- ALTER TABLE `supertracker` ADD `agent` VARCHAR(255) NULL;

 

It would probably help some people to have this call added to the supertracker_setup_db.php the call to add the agent to the supertracker table.

 

if (tep_db_num_rows($check_result) < 1){

//First time user, so just install the new database schema

$insert_query = "CREATE TABLE `supertracker` (

`tracking_id` bigint(20) NOT NULL auto_increment,

`ip_address` varchar(15) NOT NULL default '',

`browser_string` varchar(255) NOT NULL default '',

`country_code` char(2) NOT NULL default '',

`country_name` varchar(100) NOT NULL default '',

`customer_id` int(11) NOT NULL default '0',

`order_id` int(11) NOT NULL default '0',

`referrer` varchar(255) NOT NULL default '',

`referrer_query_string` varchar(255) NOT NULL default '',

`landing_page` varchar(255) NOT NULL default '',

`exit_page` varchar(100) NOT NULL default '',

`time_arrived` datetime NOT NULL default '0000-00-00 00:00:00',

`last_click` datetime NOT NULL default '0000-00-00 00:00:00',

`num_clicks` int(11) NOT NULL default '1',

`added_cart` varchar(5) NOT NULL default 'false',

`completed_purchase` varchar(5) NOT NULL default 'false',

`categories_viewed` varchar(255) NOT NULL default '',

`products_viewed` varchar(255) NOT NULL default '',

`cart_contents` mediumtext NOT NULL,

`cart_total` int(11) NOT NULL default '0',

`agent` varcgar(255) NOT NULL default '',

PRIMARY KEY (`tracking_id`)

) TYPE=MyISAM AUTO_INCREMENT=1 ;";

@$insert_result = tep_db_query($insert_query);

if ($insert_result) echo 'New Supertracker Database Table Successfully Created';

else echo 'There was a problem in trying to create the database. You may need to do this manually using the following SQL code: <br>' . $insert_query;

 

Just a suggestion... help some of the people from having a problem :)

[ladyshanae]

I have installed this mod on an OSCommerce for a client. However, because of the error with the database table, the install did not work. The host she uses does not have phpmyadmin, which is the only thing I have used to alter databases in the past. Is there a file somewhere that could instruct the database to alter that table like the file that altered it to begin with? I'm just not sure of the code I am supposed to use and have never worked with a database like this host has before.

 

Thank you!

[Guest]

Mark,

 

Just wanted to take a moment to say thank you for this contribution. It was easy to convert and install in my heavily modified store. I started the install and modifications this morning and other than my typos, I had no problems. The programming logic seemed easy to grasp and follow. :thumbsup:

 

When I read the contribution description, I was mostly drawn by mbuswell's with Agent(or sales rep) Tracking. I figured sales rep meant sales rep (Outside $ale$ Repre$entative) not affiliate linker, as I later learned. Letting the Outside Salesmen know when one of their customers has been online and viewing equipment could be fantastic sales oppertunities for them (Primarily items priced upwards of $5000.00). I may not have installed the contribution had I read all the material. But, even having Google Analytics, I think I like it anyways.

 

With just a couple modifications I got to see more information in my who's online window in admin/index.php. Known friendly ips are labeled with nicknames. If its a bot, I call it by name and not a guest. I'll figure a way to tie Agents to our sales reps and their clients and get the reports I want. Editing a line here and there is pretty easy, you folks did all the hard work.

 

My thanks to equilla, azer, Monika in Germany, mr_absinthe, and mbuswell for their files on this project and to the people of the forums who contributed ideas and solutions.

[Maurice69]

Hi Mark,

 

Great Contrib!!! :thumbsup:

 

I have a little question. In the source of supertracker.php (the one that is placed in the classes folder) I discovered a little piece of code at the end of the file I don't understand:

 

    		 $time_arrived = date('Y-m-d H:i:s');
   		 $landing_page = addslashes(tep_db_input(urldecode($_SERVER['REQUEST_URI'])));
        $query = "INSERT INTO `supertracker` (`ip_address`, `browser_string`, `country_code`, `country_name`, `referrer`,`referrer_query_string`,`landing_page`,`exit_page`,`time_arrived`,`last_click`) VALUES ('" . $ip . "','" . $browser_string . "','" . $country_code . "', '" . $country_name . "', '" . $referrer . "', '" . $query_string . "','" . $landing_page . "','" . $current_page . "','" . $time_arrived . "','" . $time_arrived . "')";		 
   		 tep_db_query($query);
	 $refquery = "INSERT INTO `orders` (`orders_referrer`) VALUES ('" . $referrer . "')";		 
		 tep_db_query($refquery);

		 }//end if for prohibited pages   
   	}//end else
	}//End big If statement (Record Exclusion for certain IPs)

	}//End function update
}//End Class

?>

 

The piece I was interested in was that where it says:

		 $refquery = "INSERT INTO `orders` (`orders_referrer`) VALUES ('" . $referrer . "')";		 
		 tep_db_query($refquery);

 

As I can say, it looks as it should update the table orders_referrer which should be in Orders. I could not find that you made this field in the setup and I made this field by hand. I hoped it would be filled with the referrer of the client that belonged with the order.

 

I was looking for a field that stored that information with the order. Can you (or maybe someone else) help me out a little where I could put a little code in your supertracker.php so that the referrer would be put in that table orders_referrer within the Orders table?

 

Kind regards!

 

 

Maurice

[tanicos]

great contrib..using it for years...yet 1problem

from time to time i get this when i press the last ten visitors:

select * from products as p, products_description as pd where p.products_id=pd.products_id and p.products_id='101'

[TEP STOP]

2006 - MySQL server has gone away

select count(*) as total from sessions where sesskey = '3537263e6421d0b503b87fda28210e24'

[TEP STOP]


Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

if i refresh it couple of times no problem...any ideea? i got about 10.000 table rows for supertracker:)

[blingyourself]

Hi,

 

we used supertracker and it worked like a dream. However, yesterday we moved to a more powerful server. Now our supertracker reports only deliver blank results (I checked the database and supertracker is still collecting information, but it is not displayed anymore if I e.g. select last 10 visitors).

I thought it was a problem with permissions and set pretty much all supertracker files to full access.

 

Do you have any suggestions?

 

Thank you,

 

Carsten

[fossle]

I just transferred my site to a new server. Now I am getting the following error:

 

Fatal error: error traversing database - perhaps it is corrupt? in /home/scmsport/public_html/wwwroot/epcstore/includes/geoip.inc on line 416

 

I downloaded the GeoIP.dat file from the external site and made sure I transferred in Binary. I tried using the old GeoIP.dat file and a new one.

Then I accidentally uploaded the dat file to the old site (which was still working) and now I am getting the same error on that site too.

 

 

This is what I have in the geoip.inc file around line 416:

 

    }
   if ($ipnum & (1 << $depth)) {
     if ($x[1] >= $gi->databaseSegments) {
       return $x[1];
     }
     $offset = $x[1];
       } else {
     if ($x[0] >= $gi->databaseSegments) {
       return $x[0];
     }
     $offset = $x[0];
   }
 }  trigger_error("error traversing database - perhaps it is corrupt?", E_USER_ERROR);
 return false;
}