Jump to content


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
  1. kartdemon

    NEW! Complete Order Editing Tool!

    Hi, Great contribution and works perfect for me... almost. Does anyone know of a way of showing the number of items in stock when adding a product from the drop down. Would make my life easier rather than looking up my stock on the site? Thanks.
  2. kartdemon

    Automatically send data feed to Froogle

    Just wanted to say thanks. Works perfect. Utterly brilliant.
  3. kartdemon

    ULTIMATE Seo Urls 5 - by FWR Media

    OK. Just discovered my Google Base Feed produces the same error also but works when run manually. Again this is the error I get: <br /> < b>Fatal error</b>: Call to a member function retrieveDependencies() on a non-object in <b>/home/******/public_html/includes/modules/ultimate_seo_urls5/uri_modules/standard.php</b> on line <b>84</b><br /> Help. Pretty please.
  4. kartdemon

    ULTIMATE Seo Urls 5 - by FWR Media

    Hi, Just after I made my post I thought I would had another look at the documentation and found what you are referring too. Tried it but exactley the same error. When I run the command from a browser the sitemap gets created fine. But from a CRON job is when I get the error. Worked fine before and works when disabling the mod. Tried different methods to setup the CRON but same result. Seem no near yet so far :-(
  5. kartdemon

    ULTIMATE Seo Urls 5 - by FWR Media

    Hi, I seem to be having a similar problem that someone posted a while back. Could not see a definative answer. It occurs when I submit my sitemaps. Using OSC 2.2 with latest ULTIMATE Seo Urls 5 - by FWR Media. Sitemap contrib I am using is: Google XML Sitemap SEO compitable with Ultimate SEO URL by FWR Media. If I disable SEO I do not get the error. *** <br /> <b>Fatal error</b>: Call to a member function retrieveDependencies() on a non-object in <b>/home/******/public_html/includes/modules/ultimate_seo_urls5/uri_modules/standard.php</b> on line <b>84</b><br /> Hope someone can help. Thanks.
  6. kartdemon

    Order viewing problem

    Hi, Great contribution. Is there a way the code could be modded slightly so instead of the link going to the product of what a customers see's, it would go to the product edit page? Thanks.
  7. kartdemon

    Featured Product Support v1.5.4

    Hi all, Hope someone can elp with this. I am running featured.php and have managed to limit the columns to 2 instead of 3 columns as 3 columns were pushing my borders out. However the featured.php box is still too wide but only because the length of the text. Does anyone know of a way to wrap the text after 20 characters or so? Or is there a way of limiting the actual table itself so it nevers goes beyond a certain amount. Below is the code I am using in featured.php module. Help. ****** <?php /* $Id: featured.php,v 1.7 2008/08/22 22:30:20 aa0001 Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License Featured Products V1.1 Displays a list of featured products, selected from admin For use as an Infobox instead of the "New Products" Infobox */ ?> <!-- featured_products //--> <?php if( defined('FEATURED_PRODUCTS_DISPLAY') AND FEATURED_PRODUCTS_DISPLAY == 'true' ) { $featured_products_category_id = $new_products_category_id; $cat_name_query = tep_db_query('SELECT `categories_name` FROM ' . TABLE_CATEGORIES_DESCRIPTION . " WHERE `categories_id` = '" . $featured_products_category_id . "' limit 1"); $cat_name_fetch = tep_db_fetch_array($cat_name_query); $cat_name = $cat_name_fetch['categories_name']; $info_box_contents = array(); list($usec, $sec) = explode(' ', microtime()); srand( (float) $sec + ((float) $usec * 100000) ); $mtm= rand(); if ( (!isset($featured_products_category_id)) || ($featured_products_category_id == '0') ) { $info_box_contents[] = array('align' => 'left', 'text' => '<a class="headerNavigation" href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS) . '">' . TABLE_HEADING_FEATURED_PRODUCTS . '</a>'); // Phocea Optimize featured query // Ben: Option to only show featured products on sale $query = 'SELECT p.products_id, p.products_image, p.products_tax_class_id, IF (s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, p.products_price, pd.products_name '; if ( defined('FEATURED_PRODUCTS_SPECIALS_ONLY') AND FEATURED_PRODUCTS_SPECIALS_ONLY == 'true' ) { $query .= 'FROM ' . TABLE_SPECIALS . ' s LEFT JOIN ' . TABLE_PRODUCTS . ' p ON s.products_id = p.products_id '; } else { $query .= 'FROM ' . TABLE_PRODUCTS . ' p LEFT JOIN ' . TABLE_SPECIALS . ' s ON p.products_id = s.products_id '; } $query .= 'LEFT JOIN ' . TABLE_PRODUCTS_DESCRIPTION . " pd ON p.products_id = pd.products_id AND pd.language_id = '" . $languages_id . "' LEFT JOIN " . TABLE_FEATURED . " f ON p.products_id = f.products_id WHERE p.products_status = '1' AND f.status = '1' order by rand($mtm) DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS; $featured_products_query = tep_db_query( $query ); } else { $info_box_contents[] = array('align' => 'left', 'text' => sprintf(TABLE_HEADING_FEATURED_PRODUCTS_CATEGORY, $cat_name)); $subcategories_array = array(); tep_get_subcategories($subcategories_array, $featured_products_category_id); $featured_products_category_id_list = tep_array_values_to_string($subcategories_array); if ($featured_products_category_id_list == '') { $featured_products_category_id_list .= $featured_products_category_id; } else { $featured_products_category_id_list .= ',' . $featured_products_category_id; } if ( defined('FEATURED_PRODUCTS_SUB_CATEGORIES') AND FEATURED_PRODUCTS_SUB_CATEGORIES == 'true' ) { // current catID as starting value $cats[] = $new_products_category_id; // put cat-IDs of all cats nested in current branch into $cats array, // go through all subbranches for($i=0; $i<count($cats); $i++) { $categorie_query = tep_db_query('SELECT `categories_id` FROM ' . TABLE_CATEGORIES . " WHERE parent_id = '" . (int)$cats[$i] . "'"); while ($categorie = tep_db_fetch_array($categorie_query)) { $cats[] = $categorie['categories_id']; } // sort out doubles $cats = array_unique($cats); } $catIdSql = implode(', ', $cats); } else { $catIdSql = $featured_products_category_id_list; } // Phocea Optimize featured query $query = 'SELECT distinct p.products_id, p.products_image, p.products_tax_class_id, IF (s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, p.products_price, pd.products_name FROM ' . TABLE_PRODUCTS . ' p LEFT JOIN ' . TABLE_PRODUCTS_TO_CATEGORIES . ' p2c using(products_id) LEFT JOIN ' . TABLE_CATEGORIES . ' c USING (categories_id) LEFT JOIN ' . TABLE_FEATURED . ' f ON p.products_id = f.products_id LEFT JOIN ' . TABLE_SPECIALS . ' s ON p.products_id = s.products_id LEFT JOIN ' . TABLE_PRODUCTS_DESCRIPTION . " pd ON p.products_id = pd.products_id AND pd.language_id = '" . $languages_id . "' where c.categories_id IN(" . $catIdSql . ") AND p.products_status = '1' AND f.status = '1' "; if ( defined('FEATURED_PRODUCTS_SPECIALS_ONLY') AND FEATURED_PRODUCTS_SPECIALS_ONLY == 'true' ) { $query .= " AND s.status = '1' "; } $query .= 'ORDER BY rand(' . $mtm . ') DESC LIMIT ' . MAX_DISPLAY_FEATURED_PRODUCTS; $featured_products_query = tep_db_query( $query ); } $row = 0; $col = 0; $num = 0; while ($featured_products = tep_db_fetch_array($featured_products_query)) { $num ++; if ($num == 1) { new contentBoxHeading($info_box_contents); } // If on special show regular and sale price if (tep_not_null($featured_products['specials_new_products_price'])) { $products_price = '<s>' . $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</s><br>'; $products_price .= '<span class="productSpecialPrice">' . $currencies->display_price($featured_products['specials_new_products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])); } $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="15" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . $featured_products['products_name'] . '</a><br>' . $products_price); $col ++; if ($col > 1) { $col = 0; $row ++; } } if($num) { new contentBox($info_box_contents); } } else { // If it's disabled, then include the original New Products box // include (DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); // disable for dont show if desactive the feature module } ?> <!-- featured_products_eof //--> ******
  8. All, (Should be Customers purchased by Product) I have looked around but caanot find such a contribution. Maybe a contribution does it a side effect but none seem to state. I am after a contribution that will show what customers have purchased a particular product by stating the product. Anyone know of a such a contribution. It would be handy for me and I guess others too. I have some technical products and would like to keep those customers updated with information if they purchase a product that could benefit from updates. Thanks.
  9. kartdemon

    Out of Stock

    OK sorted it. This is the code to remove. if ( ($stock_left < 1) && (STOCK_ALLOW_CHECKOUT == 'false') ) { tep_db_query("update " . TABLE_PRODUCTS . " set products_status = '0' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); }
  10. kartdemon

    Out of Stock

    I am sure I have done this before but since updating the module have overwritten the code. The problem is that when someone purchases via PayPal the stock is deducted which is fine but when the level reaches zero the product is then taken out of stock. I would rather the product to still show on my site. I only wish the stock to be deducted. Anyone know what code to change ? Thanks.
  11. kartdemon


    Grr, In an effort to be more secure I installed some of the extra security contributions. IP TRAP, Site Monitor, Security Pro. However I also changed permissions on all folders to what was recommend. Anyway after doing all of this, we then realised that IPN was not working. Payments where going through but we where just not getting notified. Causes problems with stock levels not changing and also logging into paypal to confirm payments. Anyway thought we could not live with that so got rid of everything to how it was. But now I am confused as we still do not get IPN. Upgraded to latest IPN module PayPal IPN Module but still no joy. Had a search and also have gone through the troubleshooting steps as outlined in the read me but no joy. The ext folder has the correct permissions and I can put in the url to get to xxxxx/ipn.php which gets to it fine but still no luck. Am I being a plumb ? Have I over looked something simple. Help. Thanks.
  12. kartdemon

    PayPal double notifications

    Just to confirm that when a double notifiaction of payment is recieved, the items of that order are taken from stock twice. Help.
  13. kartdemon

    PayPal double notifications

    Getting 2 PayPal notifications for customers once they have paid now. Is anyone else getting this. It only just started. They are not getting charged twice. Not sure if this is deducting my stock twice also. Just trying to work it out. Anyone?
  14. Just noticed a update for this released version 2. Anyone tried it yet and does it work so that it sends to a list of people who wanted notification of the same product. But does not just use the first person names for everyone? Thanks
  15. Anyone ever fix this. I did not realize about the problem until some customers emailed me. Or is there something else to use? Thanks.