Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Tomcat

Pioneers
  • Posts

    185
  • Joined

  • Last visited

Posts posted by Tomcat

  1. Hi all,

     

    Would it be possible to process images during upload?

    I guess there will be many problems with users trying to upload huge photos either in size or dimensions.

     

    There is an interesting class called class.upload that just does all the image processing, resizing, watermarking, etc.

    Does anybody know how to make it work together with photo gallery?

     

    Thank you

  2. for those of you having the login redirect problem try to change the form constructor for uploading images located in gallery_user.php from:

     

    <form enctype="multipart/form-data" action="gallery_user.php" method="POST">

     

    to:

    <?php echo tep_draw_form('fotouploaden', 'gallery_user.php?osCsid=' . $osCsid  ,'post', 'enctype="multipart/form-data"');?>

  3. Given you have a syntax error on the regular edit orders page, there should be something that doesn't work, such as the payment dropdown, one or more of the tooltips, on the fly calcs, something. Is there anything you notice that doesn't work?

     

    Hi,

     

    I have the same problem. I can't see any articles next to or under the imput field.

     

    I also have errors on the JS, I think it's because I removed the

    Function    : tep_html_quotes
     // Arguments   : string	any string
     // Return      : string with single quotes converted to html equivalent
     // Description : Function to change quotes to HTML equivalents for form inputs.
     function tep_html_quotes($string) {
       return str_replace("'", "'", $string);
     }

     

    If I put it back it gives me an error...

     

     

    Thanks

  4. In the admin menu you will see the Leapfrog menu. You can access Leapfrog by clicking on the HEADER of this menu.

     

    When the menu EXPANDS, you will see another Leapfrog link below. This one links to a NON SSL version of Leapfrog. Please can you try using this link to run Leapfrog and see if you still get the error.

     

    You will know you are on the correct page because the URL in the address bar will be http:// not https://.

     

    Thanks.

     

    Ed,

    I'm not under SSL on my admin

  5. Hi,

     

    why I keep getting disconnected from the DB ?

     

    this is the msg I get:

     

    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.

  6. Yeah it could be reset somewhere else. I think in the next version, I will do the spider identification when extracting the db info, and not when it goes in. This should help eliminate problems like this.

     

    I don't think it's a good idea since in many cases (like mine) robots do thousands of hits per hour...

    Why not using the session_id instead ? seems to work fine

     

    Franco

  7. Spider recognition is based on the code already found in MS2. The HTTP_USER_AGENT variable is checked against entries in the catalog/includs/spiders.txt file. If there is a match, then OSC knows it's a spider.

     

    It is possible that google and inktomi have changed their HTTP_USER_AGENT ids, and are no longer picked up.

     

    Can you look in your logs and see what the HTTP_USER_AGENT variable is for these two bots? They usually look something like:

     

    Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)

     

    Then add the name to spiders.txt. So in the above example you would add the line 'Yahoo! Slurp'.

     

    Let me know if that works.

     

    Hi,

     

    well, for some reasons I can't access my logs right now, so I can't really check the user agent. I had a look at my spider.txt and found that either googlebot and slurp where already there. Do you think the names must be written the same way ? I mean capital letter like "Googlebot" or is googlebot the same thing ?

     

    Since spiders were recorded despite I excluded them from settings I had to change functions/leapfrog.php to only write into DB the hits with a session ID assigned. The exclusion via settings wasn't working for me...

     

    Thanks

  8. Leapfrog V1.3 has been released!

     

    It includes the following new features:

     

    * IP lookup added

    * Visitor real name displayed after they have logged out

    * Added auto-purge feature that automatically clears Leapfrog tracking data from the database after a set period of time

    * Bot/spider name displayed

    * Guests given unique number to help identify them

     

    Hope you like it :).

     

    PS. If you are upgrading from a previous version, you MUST still run the SQL commands on your database.

     

    Hi Ed,

     

    Just installe version 1.3

     

    All fine except for the fact that I have google and inktomi recorded by leapfrog even though I've excluded robots in settings (IP 74.6.74.205 for ink and 66.249.65.46 for google )

     

    any ideas why ?

     

    Thanks

    Franco

  9. What about making the IP clickable with link to dnsstuff whois ?

     

    You know ? I have a problem with sessions: Even though I downloaded and installed the latest spiders.txt I have many robots getting the session_id. I have this on my catalog/functions/leapfrog.php

    if ($wo_session_id != 0 ) {
    		$insert_query = "insert into leapfrog" .
    										" (customer_id, customer_name, session_id, ip_address, click_time, page_url, page_title, referer_url, thumb_url)" .
    										' values ("' . $wo_customer_id . '", "' . $wo_full_name . '", "' . $wo_session_id . '", "' . $wo_ip_address .
    										'", "' . $current_time . '", "' . $wo_last_page_url . '", "' . $page_desc . '", "' . $referer_url . '", "' . $page_thumb . '")';
         tep_db_query($insert_query);
    	}

     

    and this on my application_top.php:

     

    // start the session
    
     $session_started = false;
    
     if (SESSION_FORCE_COOKIE_USE == 'True') {
    
       tep_setcookie('cookie_test', 'please_accept_for_session', time()+60*60*24*30, $cookie_path, $cookie_domain);
    
    
    
       if (isset($HTTP_COOKIE_VARS['cookie_test'])) {
    
         tep_session_start();
    
    
      // user_tracking modifications
      if (!$referer_url) {
       $referer_url = $HTTP_SERVER_VARS['HTTP_REFERER'];
           if ($referer_url) {
               tep_session_register('referer_url');
           }
       }
    
         $session_started = true;
    
       }
    
     } elseif (SESSION_BLOCK_SPIDERS == 'True') {
    
       $user_agent = strtolower(getenv('HTTP_USER_AGENT'));
    
       $spider_flag = false;
    
    
    
       if (tep_not_null($user_agent)) {
    
         $spiders = file(DIR_WS_INCLUDES . 'spiders.txt');
    
    
    
         for ($i=0, $n=sizeof($spiders); $i<$n; $i++) {
    
           if (tep_not_null($spiders[$i])) {
    
             if (is_integer(strpos($user_agent, trim($spiders[$i])))) {
    
               $spider_flag = true;
    
               break;
    
             }
    
           }
    
         }
    
       }
    
    
    
       if ($spider_flag == false) {
    
         tep_session_start();
    
         $session_started = true;
    
       }
    
     } else {
    
       tep_session_start();
    
       $session_started = true;
    
     }

     

    what can it be ?

  10. I understand your points about language id and manufacturer now. I will try and put these ideas into the next release. So far we have:
    • Display page language
    • Display manufacturer
    • Auto delete tracking data after a set period of time

    Any more?

     

    possibility of interacting with the guest ? I mean by java chat or something ?

    Sometimes I see scammers I don't want to be on the website and I feel like saying:<<..don't even think of using your flipping cards on my website, you're just waisting your (and my) time..>> :lol:

  11. I'm glad that fixed it, but it does mean that you can't use the settings menu to stop robots being tracked. Still not sure why that line would cause the admin to crash. Hmm...

     

    Hi,

     

    Are you sure the if statemets makes sense ?

    if ( (LEAPFROG_EXCLUDE_ROBOTS == 'true' && $wo_session_id != '') || LEAPFROG_EXCLUDE_ROBOTS == 'false') {

     

    Meaning: if LEAPFROG_EXCLUDE_ROBOTS is true and session is not empty or LEAPFROG_EXCLUDE_ROBOTS is false...

     

    Thanks

  12. Actually, in relation to the above post I should mention something else.

     

    Leapfrog will not start tracking until you visit the Leapfrog admin page. This is because on startup it inserts some configuration settings into the database. So, I think you will have to solve the browser crashing issue before any records will show in the DB.

     

     

    Hi,

     

    I removed the if statement on line 112 and now works like a charm. Thanks

  13. I've just upgraded from Leapfrog 1.1 to 1.2. I now get this message at the bottom of my store's main page (the footer):

     

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

     

    I have removed the Leapfrog additions to the footer.php file until I get the issue resolved but would love to reinsert the lines.

     

    How can I rectify this?

     

    Thanks,

    Anthony

     

    delete the existing leapfrog table and run the new sql statement included in package 1.2

     

    I upgraded to version 1.2.3 as well and have a different issue: records are not written to DB, not even one and if I run admin/leapfrog.php with Firefox ( 1.5 or 2) the browser crashes...

     

    Any help on that ?

     

    Thanks

  14. Hi everyone.

     

    I am ALMOST ready to release Leapfrog V1.2. It has several new features including:

    • Visitor country displayed
    • Length of page view displayed
    • Ability to show/hide spider and robot sessions
    • Now compatible with Ultimate SEO URLs 'out of the box'
    • Improved image handling - fixes problems people had seeing the product images

    You can see the new version in action in the following locations:

     

    Simulated demo - clicks generated artificially

    Live demo - click around in my dummy shop and see your movements being tracked!

     

    Before I release it, I need a couple of people to test it to make sure I haven't missed anything. This is to prevent a duff version being uploaded to the contributions sections. Anyone willing to test the new version, please PM me for a link. Only need one or two testers so if you want a sneak peak make sure you get PMing fast!

     

    Thanks,

     

    Ed

     

    Ed,

     

    Nice work, very nice indeed. Can you make the referal field a bit wider (or in two lines) so that one can read all the referal url?

     

    Thanks

  15. The change to the url parser made above by abra123cadabra wasn't working for me.

    I'm using this one instead:

     

    // Get the product image if on product item page    
               $pattern = "/p-[0-9]+/";
               preg_match($pattern, $row['page_url'], $matches);
               $productPage = $matches[0];
    
               $productId = substr($productPage, strpos($productPage, "p-")+2);
               $productId = str_replace (".html", '', $productId);
    
               if ($productId == "") {
                   $thumbUrl = "";
    
                   } else {
                   $itemQuery = "select products_image from products where products_id=" . $productId;
                   $itemResult = mysql_query($itemQuery);
                   $item = mysql_fetch_object($itemResult);
                   $thumbUrl = DIR_WS_CATALOG . DIR_WS_IMAGES . "/" . $item->products_image;
               }

  16. I also made the script discard all the hits without a session_id ( robots, mainly ) changing this bit of code:

    // Insert all the information we have gathered into the database
       $current_time = time();
           if ($skip_tracking[$wo_ip_address] != 1) {
    
    		$insert_query = "insert into leapfrog" .
    										" (customer_id, customer_name, session_id, ip_address, click_time, page_url, page_title, referer_url)" .
    										' values ("' . $wo_customer_id . '", "' . $wo_full_name . '", "' . $wo_session_id . '", "' . $wo_ip_address .
    										'", "' . $current_time . '", "' . $wo_last_page_url . '", "' . $page_desc . '", "' . $referer_url . '")';
         tep_db_query($insert_query);
    	}
    
      }

     

    to this :

     

     

    // Insert all the information we have gathered into the database
       $current_time = time();
      [b]  if ($wo_session_id > 0 ) {[/b]
       if ($skip_tracking[$wo_ip_address] != 1) {
    
    		$insert_query = "insert into leapfrog" .
    										" (customer_id, customer_name, session_id, ip_address, click_time, page_url, page_title, referer_url)" .
    										' values ("' . $wo_customer_id . '", "' . $wo_full_name . '", "' . $wo_session_id . '", "' . $wo_ip_address .
    										'", "' . $current_time . '", "' . $wo_last_page_url . '", "' . $page_desc . '", "' . $referer_url . '")';
         tep_db_query($insert_query);
    	}
    [b] }[/b]
      }

  17. Hi,

     

    I love this contrib.

    Could someone add the country of provenience based on the IP ?

    something like:

    require(DIR_WS_INCLUDES . 'geoip.inc');
     $gi = geoip_open(DIR_WS_INCLUDES . 'GeoIP.dat',GEOIP_STANDARD);

     

    and then:

    <td class="dataTableContent" valign="top"><?php
                      if (geoip_country_code_by_addr($gi, $whos_online['ip_address'])) {
                   echo tep_image(DIR_WS_FLAGS . strtolower(geoip_country_code_by_addr($gi, $whos_online['ip_address'])) . '.gif', geoip_country_name_by_addr($gi, $whos_online['ip_address'])) . '  ' . geoip_country_name_by_addr($gi, $whos_online['ip_address']);
                     } else {
                       echo TEXT_UNKNOWN_COUNTRY ;
                       }
                   ?></td>

     

    thanks again

×
×
  • Create New...