181 replies to this topic

[halezmum]

Apparently I worked out all my issues and it's fine now. Don't ask me what I did, because I haven't the foggiest... LOL. Nifty little tool, it is!

[evanmugford]

i just finished installing ( great work btw )

problem is its not showing anything on the leapfrog screen when i click it in admin,

shows me the setting button and below nothing loads. even if im browsing in another browser.

i did login to sql and it is not recording data here is the bottom of my footer , i belive that must be were the problem is.

 if ($banner = tep_banner_exists('dynamic', '468x50')) {
?>
<br>

<table border="0" width="90%" cellspacing="0" cellpadding="0" align="center">
  <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
  }
?>

any idea what could be wrong?

[evanmugford]

i fixed it, all i had to do was move the code a bit

 echo FOOTER_TEXT_BODY
?>
 <?php
	   require(DIR_WS_FUNCTIONS . 'leapfrog.php');
	   lf_update_tracking();
	 ?> 

	</td>
  </tr>
</table>
<br />
	</td>
  </tr>
</table>
<?php
  if ($banner = tep_banner_exists('dynamic', '468x50')) {
?>
<br>

<table border="0" width="90%" cellspacing="0" cellpadding="0" align="center">
  <tr>
	<td align="center"><?php echo tep_display_banner('static', $banner); ?></td>

  </tr>

</table>

<?php
  }
?>

[evanmugford]

sorry double post

Edited by evanmugford, 31 March 2007, 19:14.

[evanmugford]

quick question, would it be hard to mod this to display when someone has something in there shopping cart? we could pull the info from the whos online data.

[Sandbag]

evanmugford, on Apr 2 2007, 04:05 PM, said:

quick question, would it be hard to mod this to display when someone has something in there shopping cart? we could pull the info from the whos online data.

The code if footer.php should actually go at the very bottom of the file, not in the middle as you have it. But I guess it's working for you so leave it if you want.

With regards to the question above, this is a feature I want to include sometime in the future. It's not too difficult, but screen real estate is the problem. At the moment there is not much space to add the information.

If I can figure that out...

Edited by Sandbag, 02 April 2007, 15:24.

[evanmugford]

Sandbag, on Apr 2 2007, 03:23 PM, said:

The code if footer.php should actually go at the very bottom of the file, not in the middle as you have it. But I guess it's working for you so leave it if you want.

With regards to the question above, this is a feature I want to include sometime in the future. It's not too difficult, but screen real estate is the problem. At the moment there is not much space to add the information.

If I can figure that out...

what i was thinking was in the top right hand corner of each block, if they have something in there cart. to add a small shopping cart logo and next to it just give the total of what is actually in there cart

[Sandbag]

Ok. There should be space for that. I'll have a go in the coming weeks.

[Marcial]

Hello from Spain and sorry for my bad English:

In the table leapfrog, row click_time, the data stored is in format Unix (I thing).

I Will see in date format? (2007/04/20 15:30:25).

Thank you.

[Marcial]

Hello from Spain and sorry for my bad English:

In the table leapfrog, row click_time, the data stored is in format Unix (I think).

I Will see in date format? (2007/04/20 15:30:25).

Thank you.

[Marcial]

Hello from Spain and sorry for my bad English:

In the table leapfrog, row click_time, the data stored is in format Unix (I think).

I Will see in date format? (2007/04/20 15:30:25).

Thank you.

[Marcial]

Hello from Spain and sorry for my bad English:

In the table leapfrog, row click_time, the data stored is in format Unix (I think).

I Will see in date format? (2007/04/20 15:30:25).

Thank you.

Sorry for repeat, but I receiving error to the server

Edited by Marcial, 20 April 2007, 17:11.

[Sandbag]

Marcial, on Apr 20 2007, 06:07 PM, said:

Hello from Spain and sorry for my bad English:

In the table leapfrog, row click_time, the data stored is in format Unix (I think).

I Will see in date format? (2007/04/20 15:30:25).

Thank you.

Sorry for repeat, but I receiving error to the server

The date is stored in mySQL date time format (YYYY-MM-DD HH:MM:SS). However the date is not displayed in the Leapfrog GUI as things happen in realtime.

[Marcial]

Sandbag, on Apr 20 2007, 07:45 PM, said:

The date is stored in mySQL date time format (YYYY-MM-DD HH:MM:SS). However the date is not displayed in the Leapfrog GUI as things happen in realtime.

Ok Sandbag, Thank you. But I will can see in mysql table to date time format.?

Actually, I see it of this form.

[img]http://www.ambarex.net/mysql.jpg[/img]

[Sandbag]

Marcial, on Apr 21 2007, 11:43 AM, said:

Ok Sandbag, Thank you. But I will can see in mysql table to date time format.?

Actually, I see it of this form.

[img]http://www.ambarex.net/mysql.jpg[/img]

Hi. Yes you are right and I was wrong in my previous post. The time is stored in unix time (seconds since Jan 1, 1970) not mysql date format as I previously mentioned. You could write a little PHP script to convert the seconds into a more readable format if you wish.

[Marcial]

Sandbag, on Apr 21 2007, 06:22 PM, said:

Hi. Yes you are right and I was wrong in my previous post. The time is stored in unix time (seconds since Jan 1, 1970) not mysql date format as I previously mentioned. You could write a little PHP script to convert the seconds into a more readable format if you wish.

Hello Sand newly:

Thanks for your quick answer
I´m sorry but i cant make this script because I have no idea about write in php code, if it is posible, could you write it for me?
. I could SQL consult in MyAdmin?

You could write me, code or SQL? Please.

Thank You

[eurolife]

Hello Ed,
I seem to be having some diffculty installing your latest contribution. I am getting varios errors at the moment and I don't know why. I followed your instructions tto the T but I guess there is something missing.

1) The first error after I installed is the LDF001 error that I saw in the forum.

I get a prompt:
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.
I have an SSL connection but I uses Firefox and it still does not work.



2) The second is an error when I try to see the xml that evryone is talking about i get a Fatal error.

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

Fatal error: Call to undefined function: lf_getclicks() in /hsphere/local/home/xxxxx/www.xxxxxx.com/catalog/admin/leapfrog_feed.php on line 43

What can this be? Is there something missing.

I haven't seen any fixes for this and. I have an htaccess file and a highly modified store.

I have tried disabling htaccess and everything in the forum but no luck. I used version 1.3.

Edited by eurolife, 10 May 2007, 03:38.

[Sandbag]

Can you check that the file /catalog/admin/includes/functions/leapfrog.php is present. That is where the function lf_getclicks is located.

[Qihun]

Hi Ed ! thank you for the very nice contribution.
My question about using "leapfrog" and "user tracking" together

is there any problem to be expected ?

and do you think using both of them may slowdown shop performance ?

thanx Miclosh

[Sandbag]

Qihun, on Jun 3 2007, 05:45 PM, said:

Hi Ed ! thank you for the very nice contribution.
My question about using "leapfrog" and "user tracking" together

is there any problem to be expected ?

and do you think using both of them may slowdown shop performance ?

thanx Miclosh

I don't think there will be a problem as the code is seperate. Performance will be slower because more data is being inserted into the database, but that performance drop probably won't be noticeable.