Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

jacven

Pioneers
  • Posts

    112
  • Joined

  • Last visited

Posts posted by jacven

  1. 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.

  2. Make the UPS module "interactive" to do this;

     

    www.clubosc.com/interactive-modules-in-oscommerce.html

     

    will give you a good start.

     

    You should be able to work out how to do #2 really easily, #3 fairly easy, and #1 might be a bit more problematic, but you should be able to get it.

     

     

    Hello thank you, I will give it a try, right now.

  3. 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.

  4. I'm looking for someone who can build, or redesign an excisting oscommerce creditcard payment module.

     

    Script must redirect after checkout confirmation to my processor payment page (2 pages in fact, different cards, 2 different pages) and return after payment complete to checkout_success.php.

     

    There are serveral excisting modules/contributions (post action) that are doing this so it should be not to hard to modify one of these with my processor's details.

     

    I need the module asap, please pm with price, timeframe and if possible some reference.

     

    Thanks Bertsu for posting this question. I am also looking for someone that can build a custom gateway for my store.

  5. 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 //-->

  6. 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

  7. 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

×
×
  • Create New...