Jump to content

acidvertigo

Members
  • Content count

    275
  • Joined

  • Last visited

  • Days Won

    4

Everything posted by acidvertigo

  1. And if i write $wo_last_page_url = addslashes(getenv('QUERY_STRING')); i have the cpath (all the query after ? ) How to unify with $wo_last_page_url = addslashes(getenv('PATH_INFO')); ?
  2. My server likes addslashes(getenv('PATH_INFO')); Leapfrog Says "Unable to connect to database" The page are stored now in mysql database, but without cpath= etc etc. With addslashes(getenv('ORIG_PATH_INFO')); nothing change
  3. Shows only "The Url is:" and nothing. I think that REQUEST_URI doesn't work on IIS server
  4. http://www.mydomain.com/public/catalog/def...hp?cPath=27_666
  5. no <thumburl> and no <page url> But ok for <pagetitle><visitorsid><visitorsname><refererurl><sessionid><visitorname><clicktime><visitorip> :blink:
  6. Yes, i tried it. But nothing. IN all the other contribution that i have DIR_WS_IMAGES is set correctly. :'(
  7. No, i haven't But my images folder is different from conventional installation
  8. 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:
  9. Hi, beautiful contribution. Just one question, Leapfrog can delete data stored after a defined time? I ask this beacause i see the leapfrog table in mysql database increase in size and i don't want taht the size of this table waste all mysql space.... :'(
  10. acidvertigo

    XML Feed with Category Name

    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!
  11. acidvertigo

    XML Feed with Category Name

    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!
×