Jump to content

acidvertigo

Members
  • Content count

    278
  • Joined

  • Last visited

  • Days Won

    4

Posts posted by acidvertigo


  1. Please can you try this to give me more information. Open your browser and navigate to:

     

    http://www.yourdomain.com/catalog/admin/leapfrog_feed.php?action=newclicks&lastclick=1

     

    When that page appears, view the HTML source. There you will see the XML data Leapfrog uses to animate visitors.

     

    Look for a <thumburl></thumburl> tag and let me know what data string it contains. Some will be blank, but product info pages should contain the location of the image.

     

    no <thumburl> and no <page url>

     

    But ok for <pagetitle><visitorsid><visitorsname><refererurl><sessionid><visitorname><clicktime><visitorip> :blink:


  2. If you have your images folder in a different location to the default installation then follow this procedure.

     

    1. Open 'catalog\admin\includes\functions\leapfrog.php.

     

    2. On line 90 find:

     

    $thumbUrl = DIR_WS_CATALOG . DIR_WS_IMAGES . "/" . $item->products_image;

     

    This normal resolves to something like /www/catalog/images/product_image.jpg. You will need to change this line to point to your images folder.

     

    Yes, i tried it. But nothing. IN all the other contribution that i have DIR_WS_IMAGES is set correctly. :'(


  3. Glad you're enjoying it!

     

    At the moment Leapfrog DOES NOT delete the data in the database. You have to do that manually by clicking the 'Purge Database' button.

     

    Here is an option I could include - only track visitors when the Leapfrog UI is open. This might work. I will try and include it in the next release.

     

    In the meantime, if you are worried about the table becoming too large you might want to set up a CRON job to run every day that clears the leapfrog table. I don't know much about CRON but expect that would be possible (if your host supports it).

     

    forgot to tell you that i'am running this contrib on IIS server (impossible the CRON job) on a old 2003 snapshot ( pre MS1 era ). I can't se also the images, but not a problem for me.

     

    But i like your idea to track users only when the UI is open. :rolleyes:


  4. After a year i can't split this page result!!!! Thats incredible!!!!!

     

    :P

     

    Here is my code and i use the same xsl file listed in mine and your post.

     

    <?php
    Header( 'Content-Type: text/xml' );
    echo '<?xml version="1.0" ?>';
    echo '<?xml-stylesheet type="text/xsl" href="stile.xsl"?>';
    echo "<STOREITEMS>";
    /*
     OSCommerce Product XML Feed
     by Kenny Boyd (kenny@theinternetfoundry.com)
     http://www.theinternetfoundry.com
    
     This hack will provide a basic xml feed which can be polled by
     applications, affiliate websites or systems using other languages
     such as C++, Perl, .NET etc to display your product line in xml
     readable format.
    
     It is rehash of the excellent Catalog Anywhere addon programmed by:
     Patrick Veverka (patrick@veverka.net) available at:
     http://www.oscommerce.com/community/contributions,294
    
     This is a real quick and dirty xml implementation so bugs may exist
    
     Please see the README.TXT before you use this
    
    */
    ////////////////////////////////////////////
    // THE FOLLOWING OPTIONS MUST BE CONFIGURED!
    
    // 1. Configure DB Connection
    $db_server = "******"; //database server
    $db_user = "********"; //database user
    $db_pass = "********"; //database password
    $db_name = "********"; //database name
    
    // 2. Configure Site Info
    //Enter the url to your website
    //don't use any slashes or http eg: www.mysite.com
    $domain_name = "www.yoursite.com";
    
    //Enter the directory name of your catalog
    //don't use any slashes  eg: catalog
    $catalog_folder_name = "********/******"; //no slashes
    
    // 3. Configure XML Data to be included
    
    // 3A: Include product prices? (1 is on, 0 is off)
    $product_price = "1";
    
    // 3B: include link to product_info.php at your website? (1 is on, 0 is off)
    $product_info_link = "1";
    
    // END CONFIGURATION
    ////////////////////////////////////////////
    
    // create connection
    $connection = mysql_connect("$db_server","$db_user","$db_pass")        or die("Couldn't make connection.");
    // select database
    $db = mysql_select_db("$db_name", $connection) or die("Couldn't select database.");
    // create SQL statement
    $sqlcount = "SELECT * FROM `products` ORDER BY 'products_model'";
    $sql = "SELECT * FROM `products` ORDER BY 'products_model'";
    // execute SQL query and get result
    $sql_result = mysql_query($sql,$connection) or die("Couldn't execute query.");
    $sqlcount_result = mysql_query($sqlcount,$connection) or die("Couldn't execute query.");
    $num = mysql_numrows($sqlcount_result);
    mysql_free_result($sqlcount_result);
    
    // format results by row
    while ($row = mysql_fetch_array($sql_result)) {
           $id = $row["products_id"];
           $model = $row["products_model"];
           $image = $row["products_image"];
           $price = $row["products_price"];
       $sql2 = "SELECT `products_name` FROM `products_description` WHERE products_id = '$id' LIMIT 1";
           $sql2_result = mysql_query($sql2,$connection) or die("Couldn't execute query.");
           $row2 = mysql_fetch_array($sql2_result);
       $name = $row2["0"];
    // add extra data here then add the xml tag below
      $products_url =  $row2["4"];
      $products_description =  $row2["5"];
    // add extra data here
    
    ?>
    <PRODUCT ITEM='<?php echo $id; ?>'>
    <NAME><?php echo $name;?></NAME>
    <MODEL><?php echo $model; ?></MODEL>
    <?php
    if ($product_price == 1) {
    ?>
    <IMAGE><?php echo $image; ?></IMAGE>
    <PRICE><?php printf("%.2f", $price);  ?></PRICE>
    <?php
    }
    if ($product_info_link == 1) {
    ?>
    <URL value="http://<?php echo $domain_name; ?>/<?php echo $catalog_folder_name; ?>/product_info.php?products_id=<?php echo $id; ?>"></URL>
    <?php
    }
    ?>
    </PRODUCT>
    <?php
    }
    // free resources and close connection
    mysql_free_result($sql_result);
    mysql_close($connection);
    ?>
    </STOREITEMS>

     

    You can see the result here CLICK HERE

     

    Regards!

     

    p.s. I have serious problems in split the result of this page. I want to split the results because the page is too long! I also tried with the pricelist HTML) contribution, but i can't split the results. TO SPLIT OR NOT TO SPLIT.... THAT'S THE PROBLEM :rolleyes:

     

    Any help would be appreciated :lol:

     

    BY!


  5. After a year i can't split this page result!!!! Thats incredible!!!!!

     

    :P

     

    Here is my code and i use the same xsl file listed in mine and your post.

     

    <?php
    Header( 'Content-Type: text/xml' );
    echo '<?xml version="1.0" ?>';
    echo '<?xml-stylesheet type="text/xsl" href="stile.xsl"?>';
    echo "<STOREITEMS>";
    /*
     OSCommerce Product XML Feed
     by Kenny Boyd (kenny@theinternetfoundry.com)
     http://www.theinternetfoundry.com
    
     This hack will provide a basic xml feed which can be polled by
     applications, affiliate websites or systems using other languages
     such as C++, Perl, .NET etc to display your product line in xml
     readable format.
    
     It is rehash of the excellent Catalog Anywhere addon programmed by:
     Patrick Veverka (patrick@veverka.net) available at:
     http://www.oscommerce.com/community/contributions,294
    
     This is a real quick and dirty xml implementation so bugs may exist
    
     Please see the README.TXT before you use this
    
    */
    ////////////////////////////////////////////
    // THE FOLLOWING OPTIONS MUST BE CONFIGURED!
    
    // 1. Configure DB Connection
    $db_server = "******"; //database server
    $db_user = "********"; //database user
    $db_pass = "********"; //database password
    $db_name = "********"; //database name
    
    // 2. Configure Site Info
    //Enter the url to your website
    //don't use any slashes or http eg: www.mysite.com
    $domain_name = "www.yoursite.com";
    
    //Enter the directory name of your catalog
    //don't use any slashes  eg: catalog
    $catalog_folder_name = "********/******"; //no slashes
    
    // 3. Configure XML Data to be included
    
    // 3A: Include product prices? (1 is on, 0 is off)
    $product_price = "1";
    
    // 3B: include link to product_info.php at your website? (1 is on, 0 is off)
    $product_info_link = "1";
    
    // END CONFIGURATION
    ////////////////////////////////////////////
    
    // create connection
    $connection = mysql_connect("$db_server","$db_user","$db_pass")        or die("Couldn't make connection.");
    // select database
    $db = mysql_select_db("$db_name", $connection) or die("Couldn't select database.");
    // create SQL statement
    $sqlcount = "SELECT * FROM `products` ORDER BY 'products_model'";
    $sql = "SELECT * FROM `products` ORDER BY 'products_model'";
    // execute SQL query and get result
    $sql_result = mysql_query($sql,$connection) or die("Couldn't execute query.");
    $sqlcount_result = mysql_query($sqlcount,$connection) or die("Couldn't execute query.");
    $num = mysql_numrows($sqlcount_result);
    mysql_free_result($sqlcount_result);
    
    // format results by row
    while ($row = mysql_fetch_array($sql_result)) {
           $id = $row["products_id"];
           $model = $row["products_model"];
           $image = $row["products_image"];
           $price = $row["products_price"];
       $sql2 = "SELECT `products_name` FROM `products_description` WHERE products_id = '$id' LIMIT 1";
           $sql2_result = mysql_query($sql2,$connection) or die("Couldn't execute query.");
           $row2 = mysql_fetch_array($sql2_result);
       $name = $row2["0"];
    // add extra data here then add the xml tag below
      $products_url =  $row2["4"];
      $products_description =  $row2["5"];
    // add extra data here
    
    ?>
    <PRODUCT ITEM='<?php echo $id; ?>'>
    <NAME><?php echo $name;?></NAME>
    <MODEL><?php echo $model; ?></MODEL>
    <?php
    if ($product_price == 1) {
    ?>
    <IMAGE><?php echo $image; ?></IMAGE>
    <PRICE><?php printf("%.2f", $price);  ?></PRICE>
    <?php
    }
    if ($product_info_link == 1) {
    ?>
    <URL value="http://<?php echo $domain_name; ?>/<?php echo $catalog_folder_name; ?>/product_info.php?products_id=<?php echo $id; ?>"></URL>
    <?php
    }
    ?>
    </PRODUCT>
    <?php
    }
    // free resources and close connection
    mysql_free_result($sql_result);
    mysql_close($connection);
    ?>
    </STOREITEMS>

     

    You can see the result here CLICK HERE

     

    Regards!

     

    p.s. I have serious problems in split the result of this page. I want to split the results because the page is too long! I also tried with the pricelist HTML) contribution, but i can't split the results. TO SPLIT OR NOT TO SPLIT.... THAT'S THE PROBLEM :rolleyes:

     

    Any help would be appreciated :lol:

     

    BY!


  6. ;) Hi all.

     

    I downloaded and installed this contrib:

     

    http://www.oscommerce.com/community/contributions,1705

     

    Here a demo Pricelist

     

    And modified to show category images and to take the result for the default language.

     

    Here the code:

     

    <?php
    
    define('TITLE_PRICE', 'List Price'); 
    //define('TITLE_PRICE', 'Price list');
    
    define('SHOW_QUANTITY',false); // true - show, false - hide quantity
    define('SHOW_MARKED_OUT_STOCK',true); // show marked out of stock (true - show, false - hide)
    define('TAX_INCREASE', 0); // 0 - No increase, 1 - Add 1%, 5 - Add 5%, Any number - add number%
    define('SHOW_MODEL',true); // true - show model, false - hide model
    
    require('includes/application_top.php');
    // the following cPath references come from application_top.php
    $category_depth = 'top';
    if (isset($cPath) && tep_not_null($cPath)) {
     $categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");
     $cateqories_products = tep_db_fetch_array($categories_products_query);
     if ($cateqories_products['total'] > 0) {
    	 $category_depth = 'products'; // display products
     } else {
    	 $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");
    	 $category_parent = tep_db_fetch_array($category_parent_query);
    	 if ($category_parent['total'] > 0) {
       $category_depth = 'nested'; // navigate through the categories
    	 } else {
       $category_depth = 'products'; // category has no products, but display the 'no products' message
    	 }
     }
    }
    require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);
    $breadcrumb->add(TITLE_PRICE, tep_href_link("price.php", '', 'SSL')); 
    ?>
    
    <html <?php echo HTML_PARAMS; ?>>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> 
    <title><?php echo TITLE; ?></title>
    <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
    <link rel="stylesheet" type="text/css" href="stylesheet.css">
    </head>
    
    <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
    <!-- header //-->
     <?php require(DIR_WS_INCLUDES . 'header.php');?>
    <!-- header_eof //-->
    
    <!-- body //-->
    <table border="0" width="100%" cellspacing="3" cellpadding="3">
    
     <!-- body_text //-->
     <td valign="top">
    	 <table border="0" cellspacing="0" cellpadding="2">
        <tr>
           <td class="pageHeading"><? echo TITLE_PRICE ?></td>
      	 
         </tr>
       <tr>
       <td class="headerNavigation">I prezzi sono IVA esclusa e possono variare senza preavviso</td>
       </tr>
         <tr>
           <td>
    <?
    // ???? ? ?????? ?????????
    // group have products?
    function check_products($id_group){
    $products_price_query = tep_db_query("select products_to_categories.products_id FROM products_to_categories where products_to_categories.categories_id = ".$id_group." LIMIT 0,1");
    if($products_price = tep_db_fetch_array($products_price_query)){
     return true;	
    }
    return false;
    }
    
    // ??????? ?????? ????????? ???????????? ?????? $id_group
    // list products determined group
    function get_products($id_group){
    global $currencies;
    $query = "";
    
    $products_price_query = tep_db_query("SELECT products_description.products_name, products.products_quantity, products.products_price, products.products_model, products_to_categories.products_id, products_to_categories.categories_id
    FROM products, products_description, products_to_categories
    WHERE products.products_id = products_description.products_id AND products_description.language_id =2".$query." and products.products_id = products_to_categories.products_id and products_to_categories.categories_id = ".$id_group);
    $x=0;
    while ($products_price = tep_db_fetch_array($products_price_query)){
     $cell = tep_get_products_special_price($products_price['products_id']);
     if($cell == 0)
    	 $cell = $products_price['products_price'];
     if($x==1) {
    	 $col = "#F8F8F9";
    	 $x = 0;	
     }else{
    	 $col = "#FFFFFF";
    	 $x++;
     }
     $quantity = "";
     $model = "";
     if(SHOW_QUANTITY)
    	 $quantity = "<td width=\"100\" align=\"right\" class=\"productListing-data\">(".$products_price['products_quantity'].")</td>";
     if(SHOW_MODEL)
    	 $model = "<td width=\"100\" align=\"left\" class=\"productListing-data\">[".$products_price['products_model']."]</td>";
     print "<tr bgcolor=\"".$col."\" align = \"left\">".$model."<td width=\"1000\" class=\"productListing-data\" align=\"left\">        <a href=\"" . tep_href_link(FILENAME_PRODUCT_INFO, "products_id=" . $products_price['products_id']) . "\"<a>".$products_price['products_name']."</td>".$quantity."<td width=\"150\" align=\"left\" class=\"productListing-data\">".$currencies->display_price($cell,TAX_INCREASE)."</td></tr>";
    }
    }
    
    
    // ??????????? ???????, ???????? ?????? ?? ???????
    // get all groups
    function get_group($id_parent,$position){
    $groups_price_query = tep_db_query("select categories.categories_id,categories_image,categories_description.categories_name from categories, categories_description where categories.categories_id = categories_description.categories_id and categories.parent_id = ".$id_parent." and categories_description.language_id = 2 order by categories_description.categories_name");
    while ($groups_price = tep_db_fetch_array($groups_price_query)){
     $str = "";
     for($i = 0; $i < $position; $i++){
    	 $str = $str . "        ";
     }
     $class = "productListing-heading";
     if($position == 0) {
    	 $class = "headerNavigation";
    	 print "<tr><td colspan=\"4\" width=\"1000\" class=\"productListing-data\"> </td></tr>"; // ?????? ??????
     }
     if(check_products($groups_price['categories_id']) || $position == 0){
    	 print "<br<tr><td colspan=\"4\" width=\"1000\" class=\"".$class."\"><img src= \"/public/".$groups_price['categories_image']."\" height=\"64\" width=\"84\"><strong><font color=\"#FFFFFF\" size=\"3\"><u>".$str.$groups_price['categories_name']."</font></u></strong></td></tr>";
    	 get_products($groups_price['categories_id']);
     }
     get_group($groups_price['categories_id'],$position+1); // ????????? ??????
    }
    }
    
    ?>
    <table width="100%" border="0" cellspacing="1" cellpadding="0">
    <?
    // Content is in $site 
    
     get_group(0,0);
    
    ?>
    
    </table>
           </td>
         </tr>
    	 </table>
     </td>
     <!-- body_text_eof //-->
     
    </tr>
    </table>
    <!-- body_eof //-->
    
    <!-- footer //-->
    <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
    <!-- footer_eof //-->
    </body>
    </html>
    <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

     

     

     

    How i can split the result by page with a navigation bar?

×