181 replies to this topic

[andrew71]

I've just installed this and think it's a great contribution.

However, the IP addresses appeared to be wrong. I was browsing from Demon in the UK, but was being reported as being on Lycos (who host my stores). Doing a quick check on the code (I'm no programmer!) and a comparison with another visitor reporting contribution, I made the following change:

In catalog/includes/functions/leapfrog.php, find:

$wo_ip_address = getenv('REMOTE_ADDR');

and replace it with:

$wo_ip_address = tep_get_ip_address();

After uploading the modified file, the IP address of my customers is being correctly reported.

Thanks again for a great contribution.

edit... Just thinking about this, I'm not sure if tep_get_ip_address is standard in OSC installations, so this fix might not work for everyone...

Edited by andrew71, 05 June 2007, 10:20.

[azer]

Quote

In catalog/includes/functions/leapfrog.php, find:

$wo_ip_address = getenv('REMOTE_ADDR');

and replace it with:

$wo_ip_address = tep_get_ip_address();

can someone confirm that we need to do this change for futur versions ?

[ajayzone]

Hi i have installed leapfrog , but i`m not getting any data in my leapfrog table, i`m no programmer but i think the problem is because of sts that i have added. my code for footer is a bit different than normal its below.
can some one help?

<?php
// START STS 4.5
if ($sts->display_template_output) {
  // Get content here, in case column_right is not called.
  if (!isset($sts->template['content'])) $sts->restart_capture ('content');
} else {
//END STS

  require(DIR_WS_INCLUDES . 'counter.php');
?>



<table border="0" width="100%" cellspacing="0" cellpadding="1">
  <tr class="footer">
	<td class="footer">  <?php echo strftime(DATE_FORMAT_LONG); ?>  </td>
	<td align="right" class="footer">  <?php echo $counter_now . ' ' . FOOTER_TEXT_REQUESTS_SINCE . ' ' . $counter_startdate_formatted; ?>  </td>
  </tr>
</table>
<br>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
	<td align="center" class="smallText">
<?php

  echo FOOTER_TEXT_BODY
?>
	</td>
  </tr>
</table>
<?php
  if ($banner = tep_banner_exists('dynamic', '468x50')) {
?>
<br>
<table width="100%">
<tr>
	<td align="center" class="smallText">
	  <?php echo 'Your IP Address is: ' . tep_get_ip_address(); ?>
</td></tr></table>
<br>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
	<td align="center"><?php echo tep_display_banner('static', $banner); ?></td>
  </tr>
</table>
 <?php
   require(DIR_WS_FUNCTIONS . 'leapfrog.php');
	 lf_update_tracking();
  ?>
<?php
  }
// START STS 4.1
}
// END STS 4.1

?>

Thanks Ajay.

[PatForde]

Unable to connect to the Leapfrog data feed.

Please read the following suggestions:

1. Do you have an admin login contribution installed? If so you must edit it to allow Leapfrog to access '/admin/leapfrog_feed.php'.

2. Are you using IE and SSL? There is a known issue with this setup. Please see INSTALL.txt for details. Alternatively switch to Firefox.

3. Visit the support thread on the official osCommerce forum. There might be an answer there.

Code: LDF004



Damn it ! My database is tracking and working etc as I can see the leapfrog table updating etc but nothing is showing in firefox or ie

One thing I did notice is my store is set up that the admin and catalog directories are directly under the root ( ie that the admin is not under the catalog which is the way the contribution is packaged ) is there any problem here in that I installed it to my normal admin area.

[Sandbag]

PatForde: Please can you enter the following URL in your browser:

http://www.yourdomain.com/catalog/admin/le...amp;lastclick=1

(obviously putting in the correct path to the leapfrog_feed.php file for your site) and then view the source code of the html page.

What do you get?

[PatForde]

Getting a 404 page not found error at moment

Not sure if I am trying the right thing though - will pm you sandbag

Thanks for your time

[tecno]

Does this put any extra strain on people browsing or your database? I do see a SQL dump, can i install it on a seperate database (as an optional extra) or has to be main table?

[Sandbag]

tecno, on Jan 17 2008, 09:38 PM, said:

Does this put any extra strain on people browsing or your database? I do see a SQL dump, can i install it on a seperate database (as an optional extra) or has to be main table?

It is inserting information into the database whilst people are browsing, so yes, more SQL instructions are being executed.

I very much don't one new command will cause a stain on the database, and users won't notice the effect.

Putting the Leapfrog table into a new database is not possible without changing the code (because it uses the osCommerce database connection code which points to the original database).

[tecno]

Pm'ed thanks for great work!

Edited by tecno, 26 January 2008, 14:20.

[cholondron]

Great tools. I installed the contribution to CRE loaded and everything seems to be working great, just that I'm getting double entries with one that is accurate and the second shows up as welcome. Any clue on what is doing this?

[cholondron]

I was able to get the tool working with some mods to the catalog/includes/functions/leapfrog.php. CRE running on windows server 2k3 has issues as it is so the evn vars had to be changed and some checks and balances had to be reformated. All this and I still get the double entry. It always adds an additional entry to the database for theindex.php paged after every click?

I'll continue to see where the problem is but if anyone has an idea let me know. Thanks.

[markoven]

Hi,

I installed oscommerce-2.2rc2a, can somebody update the mysql database because this needs a different code

Thank you

[Philth]

I'm getting the LDF001 error.

I've tried the http://www.ownsite.co.uk/osc/admin/leapfro...amp;lastclick=1

and am getting this:

Warning: fopen(includes/GeoIP.dat) [function.fopen]: failed to open stream: No such file or directory in /homepages/21/d103259914/htdocs/cb/osc/admin/includes/geoip.inc on line 312

Warning: ftell(): supplied argument is not a valid stream resource in /homepages/21/d103259914/htdocs/cb/osc/admin/includes/geoip.inc on line 266

lots of lines..... then:

Fatal error: error traversing database - perhaps it is corrupt? in /homepages/21/d103259914/htdocs/cb/osc/admin/includes/geoip.inc on line 420

Any ideas please? I've made sure that all of the files are in the correct locations.

Many thanks,
Philth

[Philth]

Bump - help please?

[Maxwell Smart]

I installed this on my site tonight and I'm having a problem with images. After installation I went into the leapfrog area of the admin panel. I saw the Guest 1 image box for about 20 seconds and then it dissapeared and now it's just a blank box with the settings button up top.

I'm using Firefox v2 browser on Linux in case that matters.

Update:

It's now working again. I reloaded the .sql file through PHPMyAdmin and now it's working fine. Hopefully it was just a glitch and it continues to work without problems.

Edited by Maxwell Smart, 15 July 2008, 03:07.

[dunn]

Hello,

I would like to know if this contribution would record new store sign ups and payment transaction ip address??

Thanks Alot
Dunn

[jubez]

Hello, in mySQL I have No Index Defined under my leapfrog table, what do I need to add to my table? See image below. Any help would be great, Thank you for a great Contrib.

Angie

[img]http://www.designtecmarketing.com/noindex.jpg[/img]

[jubez]

jubez, on Jan 27 2009, 11:13 PM, said:

Hello, in mySQL I have No Index Defined under my leapfrog table, what do I need to add to my table? See image below. Any help would be great, Thank you for a great Contrib.

Angie

[img]http://www.designtecmarketing.com/noindex.jpg[/img]

I did some research in this post and found that I had my
<?php
require(DIR_WS_FUNCTIONS . 'leapfrog.php');
lf_update_tracking();
?>
a few lines to high in my footer.php

It's working! I LoVe iT! Awesome Contrib!!!

[kenkenms]

I found this not work with php5, it only work mysql php4, anyone know how can it work with php5?

[halluzineyt]

Unable to connect to the Leapfrog data feed.

Please read the following suggestions:

1. Do you have an admin login contribution installed? If so you must edit it to allow Leapfrog to access '/admin/leapfrog_feed.php'.

2. Are you using IE and SSL? There is a known issue with this setup. Please see INSTALL.txt for details. Alternatively switch to Firefox.

3. Visit the support thread on the official osCommerce forum. There might be an answer there.

Code: LDF001

im getting this too??

used the latest version with fix..1.3a

my database is running perfectly and i can record the dates the weird part is i have done all what is told to fix the errors but still the same.. how can this be?? pls help