Parse Error

January 21, 2006

I am getting this parse error:

Parse error: parse error, unexpected $ in /home/www/deviltro/includes/modules/new_products.php on line 181

in this document:

<?php
/*

$Id: new_products.php,v 1.35 2004/02/05 15:50:00 adf Exp $

Randomize New Products

$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 © 2003 osCommerce

Released under the GNU General Public License

*/

?>



<?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') ) {

// BOF Separate Pricing per Customer

$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);

}

// 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'];

}

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 RAND() limit " . MAX_RANDOM_SELECT_NEW);

} else { // in a category

$cats[] = $new_products_category_id; // current catID as starting value

// 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'];

$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();

// 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']);

$cats=array_unique($cats); // sort out doubles

}

$num = (int) 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 in (".implode(', ', $cats).") and p.products_status = '1' order by RAND() limit " . MAX_RANDOM_SELECT_NEW);

// end random new products

}

$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> <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products[$x]['products_id']) . '">' . $new_products[$x]['products_name'] . '</a> ' . $currencies->display_price($new_products[$x]['products_price'], tep_get_tax_rate($new_products[$x]['products_tax_class_id'])));

if (tep_db_num_rows($new_products_query) > 0) {

$info_box_contents = array();

$info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')));

new contentBoxHeading($info_box_contents);

$row = 0;

$col = 0;

$pCount = 0;

$info_box_contents = array();

$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 . " ";

if ($num_rows > 0) {

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;

}

$col ++;

if ($col > 2) {

$col = 0;

$row ++;

}

if ($found == 0) {

// keep track of found id's

$found_products[$pCount] += $random_product['products_id'];

$pCount ++;

// add to display array

$random_product['products_name'] = tep_get_products_name($random_product['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=' . $random_product['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $random_product['products_image'], $random_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a> <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . $random_product['products_name'] . '</a> ' . $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($info_box_contents);

}

} // end for ($x = 0; $x < $no_of_new_products; $x++)

} // end if (($no_of_new_products = tep_db_num_rows($new_products_query)) > 0)

// EOF Separate Pricing per Customer

new contentBox($info_box_contents);

?>

Can someone help?

Line 181 is the final line and is highlighted in red.

pooltime · January 24, 2006

try moving the eof to above ?>

Parse Error

Recommended Posts

Guest

pooltime

Archived

Browse

Activity