Jump to content

jacven

Members
  • Content count

    112
  • Joined

  • Last visited

Everything posted by jacven

  1. jacven

    Sitemap SEO

    Hello all, At the sitemap_seo_page_control.php I have some custom pages, they are not checked to be excluded, and they are not shown in the front-end What could be wrong? Thank you.
  2. Hello, Can anyone please help me adding a custom field to this contribution? Quick Price Updates. I have the RSS field added to the products and would like to have this at the Quick P U Thank you.
  3. jacven

    manufacturer2 2.0

    Hello, thanks for this great contribution. I have successfully installed it but I would like to know how to change the aspect. It is currently setup as drop down list, I would like to have it as the category box. I went to the setup in admin where you in maximum value, but when I changed that it disappeared. Can anyone please help me? Thank you.
  4. jacven

    [Contrib] Manufacturers Multilanguage

    Hello thanks for this contribution. Does anyone know what should I do if I only need to have the multilanguage for manufacturers? Thank you
  5. hello to all, I have seen a couple of these contribs but is there a way to enable or disable them from the admin? thanks.
  6. jacven

    private store - true or false

    hello thank you, can you tell me how? thanks.
  7. jacven

    Customers extra fields

    Hello, great contribution, has anyone made work an extra field to show in invoice.php at the administrator? I have added code in this forum, but nothing happens. Thanks in advanced.
  8. hello I have a store, and for some specific products I need to have two payment options, one is with CC and the other is with cash on delivery. I have installed SPPC but it is not what I am looking for. Thanks in advanced.
  9. jacven

    Payment Module for each language

    Thank you it worked like a charm.
  10. jacven

    Payment Module for each language

    Hello, is it possible? I need to specify a Bank Transfer Module for each language that I have configured in our store. Thank you.
  11. Hello thank you, I will give it a try, right now.
  12. Hello, I really don't know where to start to setup this, or what contribution would help me to achieve this: Scenario 1: If product is shipped to one specific country, UPS won't be an option for selection Scenario 2: If shop amount is greater than $ 2000 only UPS will be available Scenario 3: If total weight is greater than 30 pounds, UPS will show I really hope that you can guide me on this because I am totally lost. Thank you.
  13. jacven

    Featured Product Support v1.5.4

    hello I need to add the product module to the front page of featured products, can anyone help me? Thanks.
  14. Hello all, thanks for this great contrib, but I need to know how is it possible to add customer details, such as email address and phone number in the same order email? THanks,
  15. Hello all, thanks for this great contrib, but I need to know how is it possible to add customer details, such as email address and phone number in the same order email? THanks,
  16. jacven

    Master Products - MS2

    hello all the products_listing_status tinyint(2) I change it to varchar(50) I need to find out where in the code it says to insert the data with tinyint(2) thanks
  17. jacven

    Will pay for module for credit card processing

    Thanks Bertsu for posting this question. I am also looking for someone that can build a custom gateway for my store.
  18. I deleted by mistake a PM from someone that offered some certain amount of money install this script for me. I need to catch up on that, thx.
  19. Hello all, I am used only to integrate with 2CO or PayPal, but recently a friend of mine needs to integrate with a local provider in my country (Venezuela) So, this provider has sent to me couple of instructions, something like this: http://www.xxx/xxx/A_merc.jsp? invoiceNumber=$valor1&totalAmount=$valor2 But where should I edit in my store this to point to the gateway? Thanks.
  20. Hello, thx for your reply, now, I have seen many modules, but is there anything in a module where I can define where the variables should go to a specifi link? Thanks.
  21. jacven

    Featured Product Support v1.5.4

    Hello everyone, please help me this code, I need to also do a query from Specials, It's actually working, but it's taking too long to display them. I tried with a new_products.php and it worked so here it's the new_products.php code with an extra query for specials that works for me <?php /* $Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ ?> <!-- new_products //--> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B'))); new contentBoxHeading($info_box_contents); if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { // get rid of the join with specials $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price from " . TABLE_PRODUCTS . " p where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit ". MAX_DISPLAY_NEW_PRODUCTS); } if (($no_of_new_products = tep_db_num_rows($new_products_query)) > 0) { while ($_new_products = tep_db_fetch_array($new_products_query)) { $new_products[] = $_new_products; $list_of_prdct_ids[] = $_new_products['products_id']; } $select_list_of_prdct_ids = "products_id = '".$list_of_prdct_ids[0]."' "; if ($no_of_new_products > 1) { for ($n = 1; $n < count($list_of_prdct_ids); $n++) { $select_list_of_prdct_ids .= "or products_id = '".$list_of_prdct_ids[$n]."' "; } } // an extra query is now used for all the specials $specials_query = tep_db_query("select products_id, specials_new_products_price from specials where (".$select_list_of_prdct_ids.") and status = '1' "); while ($specials_array = tep_db_fetch_array($specials_query)) { $new_s_prices[] = array ('products_id' => $specials_array['products_id'], 'specials_new_products_price' => $specials_array['specials_new_products_price']); } // replace products_price with the specials_new_products_price if(!empty($new_s_prices)) { for ($x = 0; $x < $no_of_new_products; $x++) { for ($i = 0; $i < count($new_s_prices); $i++) { if( $new_products[$x]['products_id'] == $new_s_prices[$i]['products_id'] ) { $new_products[$x]['products_price'] = $new_s_prices[$i]['specials_new_products_price']; } } } } // // end if(!empty($new_s_prices) $row = 0; $col = 0; $info_box_contents = array(); // while ($new_products = tep_db_fetch_array($new_products_query)) { for ($x = 0; $x < $no_of_new_products; $x++) { $new_products[$x]['products_name'] = tep_get_products_name($new_products[$x]['products_id']); $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products[$x]['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products[$x]['products_image'], $new_products[$x]['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products[$x]['products_id']) . '">' . $new_products[$x]['products_name'] . '</a><br>' . $currencies->display_price($new_products[$x]['products_price'], tep_get_tax_rate($new_products[$x]['products_tax_class_id']))); $col ++; if ($col > 2) { $col = 0; $row ++; } } // end for ($x = 0; $x < $no_of_new_products; $x++) } // end if (($no_of_new_products = tep_db_num_rows($new_products_query)) > 0) new contentBox($info_box_contents); ?> <!-- new_products_eof //--> What I need is to have that same extra query in new_products.php I need to adapt to /includes/modules/featured.php <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 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(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(); 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>'); list($usec, $sec) = explode(' ', microtime()); srand( (float) $sec + ((float) $usec * 100000) ); $mtm= rand(); $featured_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_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); } 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; } $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price 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 where c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); } $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); } $featured_products['products_name'] = tep_get_products_name($featured_products['products_id']); if($featured_products['specstat']) { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" 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><s>' . $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</s><br><span class="productSpecialPrice">' . $currencies->display_price($featured_products['specials_new_products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</span>'); } else { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" 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>' . $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id']))); } $col ++; if ($col > 2) { $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 include (DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); } if ($num == 0) { include (DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); } ?> <!-- featured_products_eof //-->
  22. Please I need help with this version "Easy Populate 2.8-MS2" I am trying to populate my SPECIALS. I was able to import all my 4k records with no problems, when I try populate also 4k SPECIAL prices it only imports 20 or 30% of them, no error message is displayed but I dont understand why it is not populating all of them. Does anyone knows something about this? Best regards, JC
  23. Hi, I have installed two contributions to my store. 1. Photo Gallery 1.0 http://www.oscommerce.com/community/contri.../search,gallery 2. Ultimate SEO URLs http://www.oscommerce.com/community/contri...ch,ultimate+seo Right before installing 2nd one photo galleries were working great but now after activating 2nd contr it is not working. If I click on a product where it says "Click to view photo gallery" it opens up the popup page with the 1rst pic My URL would be something like this http://mysite.com/catalog/seo-url-bla-bla-bla.html there I have this menu 1 2 3 4 5 6 7 8 9 | Next > When I click on number 2, img does not show up and get this url http://mysite.com/catalog/popup_image.php?...popup_image.php Can anyone help me out with this? Really appreciate it. Thanks
  24. hi, i'm new at oscommerce, installed, configured, and it's now running. I downloaded easy populate latest version. downloaded from admin, "Complete tab-delimited .txt file to edit" checked in excel, but i would like to delete some information, and put the data I want, i tried just cleaning to cells, uploaded but doesn't work. any help? thanks
×