New products for month - RANDOMIZED - help!

[intensea]

Download the OSCmax v2 here.

Purchased a template..the template is under Catalog/templates/templatenamehere..

i believe i was using
Catalog/templates/aabox before i purchased a template.

my question is..i researched how to make the "New Products for [Month]" randomized..

i did these steps
Problem with new products for _Month_ -

i download the contrib..put the new_products.php under my "Catalog/includes/modules".. and replace it and it didnt work..

is there any way? please help!

thanks!!

[intensea]

anyone????

[michael_s]

What is the link to the actual mod?

[intensea]

you got PMed

[jpf]

You can't simply replace any files in osCMax with most mods.

Use a merge tool like Windiff or Beyond Compare.

This might work:

 <?php
/*
$Id: new_products.php 3 2006-05-27 04:59:07Z user $
 
  osCMax Power E-Commerce
  http://oscdox.com
 
  Copyright 2006 osCMax
 
  Released under the GNU General Public License
*/
?>
<!-- new_products //-->
<?php
 
// BOF: MOD - Separate Pricing per Customer
//  $info_box_contents = array();
  $box_content = array();
//  $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')));
  $box_content[] = array('align' => 'left', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCTS_NEW) . '" class="headerNavigation">' . sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B') . '</a>'));
//  new contentBoxHeading($info_box_contents);
  new infoBoxHeading($box_content, false, false, tep_href_link(FILENAME_PRODUCTS_NEW));
 
  if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
// start random new products
//  $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);
//  $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_RANDOM_SELECT_NEW);
    $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' and month(p.products_date_added) = month(now()) order by p.products_date_added desc limit " . MAX_RANDOM_SELECT_NEW); 
  } else {
//  $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . 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);
//  $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . 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_RANDOM_SELECT_NEW);
    $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' and month(p.products_date_added) = month(now()) order by p.products_date_added desc limit ".     $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_RANDOM_SELECT_NEW);
// end random new products    
  }
 
// global variable (session) $sppc_customer_group_id -> local variable customer_group_id
  if(!tep_session_is_registered('sppc_customer_group_id')) { 
    $customer_group_id = '0';
  } else {
    $customer_group_id = $sppc_customer_group_id;
  }
 
  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]."' ";   
     }
  }
// get all customers_group_prices for products with the particular customer_group_id
// however not necessary for customer_group_id = 0
  if ($customer_group_id != '0') {
    $pg_query = tep_db_query("select pg.products_id, customers_group_price as price from " . TABLE_PRODUCTS_GROUPS . " pg where (".$select_list_of_prdct_ids.") and pg.customers_group_id = '".$customer_group_id."'");
    while ($pg_array = tep_db_fetch_array($pg_query)) {
      $new_prices[] = array ('products_id' => $pg_array['products_id'], 'products_price' => $pg_array['price'], 'specials_new_products_price' => '');
    }
  
    for ($x = 0; $x < $no_of_new_products; $x++) {
// replace products prices with those from customers_group table
        if(!empty($new_prices)) {
          for ($i = 0; $i < count($new_prices); $i++) {
            if( $new_products[$x]['products_id'] == $new_prices[$i]['products_id'] ) {
              $new_products[$x]['products_price'] = $new_prices[$i]['products_price'];
            }
          }
        } // end if(!empty($new_prices)
      } // end for ($x = 0; $x < $no_of_products_new; $x++)
    } // end if ($customer_group_id != '0')
 
// an extra query is needed 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' and customers_group_id = '" .$customer_group_id. "' ");
      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 correct 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();
      $box_content = array();
// start random new products
  $pCount = 0;
  $found_products = array();
  $num_rows = tep_db_num_rows($new_products_query);
  if (MAX_DISPLAY_NEW_PRODUCTS > MAX_RANDOM_SELECT_NEW) {
    // don't allow more new products than will be queried
    $max_new_products = MAX_RANDOM_SELECT_NEW;
  } else {
    $max_new_products = MAX_DISPLAY_NEW_PRODUCTS;
  }
  if ($num_rows < $max_new_products) {
      $max_new_products = $num_rows;
  }
//  echo "num_rows: " . $num_rows . " max_new_products " . $max_new_products . "<br>";
  if ($num_rows > 0) {        
//  while ($new_products = tep_db_fetch_array($new_products_query)) {
    while ($pCount < $max_new_products) {    
      // choose a random row 
      $random_product = '';
      $random_row = tep_rand(0, ($num_rows - 1));
      tep_db_data_seek($new_products_query, $random_row);
      $random_product = tep_db_fetch_array($new_products_query);
      // see if found already, if not use else skip
      $found = 0;
      for ($ii=0; $ii < $pCount; $ii++) {
        if ($found_products[$ii] == $random_product['products_id']) {
          $found = 1;
          break;
        }
      }
      if ($found == 0) {
        // keep track of found id's
        $found_products[$pCount] += $random_product['products_id'];
        $pCount ++; 
        // add to display array
//      $new_products['products_name'] = tep_get_products_name($new_products['products_id']);
        $random_product['products_name'] = tep_get_products_name($random_product['products_id']);
        $box_content[$row][$col] = array('align' => 'center',
                                                    'params' => 'class="smallText" width="33%" valign="top"',
                                                    'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $random_product['products_image'], $random_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . $random_product['products_name'] . '</a><br>' . $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])));
 
        $col ++;
        if ($col > 2) {
          $col = 0;
          $row ++;
        }
      } // found
    } // while pCount
  } // num_rows  
// end random new products
 
  new contentBox($box_content);
// EOF: MOD - Separate Pricing per Customer
?>
<!-- new_products_eof //--> 

Sorry - have not tested - but should be close.

Good Luck!

[intensea]

oh ok..ill try that! thanks!