Parse Error: Syntax Error, Unexpected T_else In

adz1976 · June 5, 2007

Hi,

Hope someone can help, I have installed Seperate prices per customer v3.51 & everything seems fine

but when I come to add specials under the admin section the following appears:

Parse error: syntax error, unexpected T_ELSE in /content/xxxx/admin/specials.php on line 211

Part of the code from specials.php is attached below, the bottom of the code where } else { is displayed, this is line 211

Hope you can spot something :-)

// BOF - Separate_Pricing_Per_Customer_v3.5

<tr>

<td class="main"><?php echo tep_draw_pull_down_menu('customers_group', $input_groups, (isset($sInfo->customers_group_id)?$sInfo->customers_group_id:''));?> </td>

</tr>

// EOF - Separate_Pricing_Per_Customer_v3.5

<tr>

<td class="main"><?php echo tep_draw_input_field('specials_price', (isset($sInfo->specials_new_products_price) ? $sInfo->specials_new_products_price : '')); ?></td>

</tr>

<tr>

<td class="main"><?php echo tep_draw_input_field('day', (isset($sInfo->expires_date) ? substr($sInfo->expires_date, 8, 2) : ''), 'size="2" maxlength="2" class="cal-TextBox"') . tep_draw_input_field('month', (isset($sInfo->expires_date) ? substr($sInfo->expires_date, 5, 2) : ''), 'size="2" maxlength="2" class="cal-TextBox"') . tep_draw_input_field('year', (isset($sInfo->expires_date) ? substr($sInfo->expires_date, 0, 4) : ''), 'size="4" maxlength="4" class="cal-TextBox"'); ?><a class="so-BtnLink" href="java script:calClick();return false;" onmouseover="calSwapImg('BTN_date', 'img_Date_OVER',true);" onmouseout="calSwapImg('BTN_date', 'img_Date_UP',true);" onclick="calSwapImg('BTN_date', 'img_Date_DOWN');showCalendar('new_special','dteWhen','BTN_date');return false;"><?php echo tep_image(DIR_WS_IMAGES . 'cal_date_up.gif', 'Calendar', '22', '17', 'align="absmiddle" name="BTN_date"'); ?></a></td>

</tr>

</table></td>

</tr>

<tr>

<tr>

<td class="main" align="right" valign="top"><br><?php echo (($form_action == 'insert') ? tep_image_submit('button_insert.gif', IMAGE_INSERT) : tep_image_submit('button_update.gif', IMAGE_UPDATE)). ' <a href="' . tep_href_link(FILENAME_SPECIALS, 'page=' . $HTTP_GET_VARS['page'] . (isset($HTTP_GET_VARS['sID']) ? '&sID=' . $HTTP_GET_VARS['sID'] : '')) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td>

</tr>

</table></td>

</form></tr>

<?php

} else {

?>

Thanks

Adam :-)

germ · June 5, 2007

Please post the entire contents of the PHP file.

:)

adz1976 · June 5, 2007

Please post the entire contents of the PHP file.
:)

Hi Jim

Here is the entire content as requested

Thanks

Adam :-)

<?php

/*

$Id: specials.php,v 1.41 2003/06/29 22:50:52 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

require('includes/application_top.php');

require(DIR_WS_CLASSES . 'currencies.php');

$currencies = new currencies();

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');

if (tep_not_null($action)) {

switch ($action) {

case 'setflag':

tep_set_specials_status($HTTP_GET_VARS['id'], $HTTP_GET_VARS['flag']);

tep_redirect(tep_href_link(FILENAME_SPECIALS, (isset($HTTP_GET_VARS['page']) ? 'page=' . $HTTP_GET_VARS['page'] . '&' : '') . 'sID=' . $HTTP_GET_VARS['id'], 'NONSSL'));

break;

case 'insert':

$products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']);

$products_price = tep_db_prepare_input($HTTP_POST_VARS['products_price']);

$specials_price = tep_db_prepare_input($HTTP_POST_VARS['specials_price']);

$day = tep_db_prepare_input($HTTP_POST_VARS['day']);

$month = tep_db_prepare_input($HTTP_POST_VARS['month']);

$year = tep_db_prepare_input($HTTP_POST_VARS['year']);

// BOF - Separate_Pricing_Per_Customer_v3.5

$customers_group=tep_db_prepare_input($HTTP_POST_VARS['customers_group']);

$price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS. " WHERE products_id = ".(int)$products_id . " AND customers_group_id = ".(int)$customers_group);

while ($gprices = tep_db_fetch_array($price_query)) {

$products_price=$gprices['customers_group_price'];

}

// EOF - Separate_Pricing_Per_Customer_v3.5

if (substr($specials_price, -1) == '%') {

$new_special_insert_query = tep_db_query("select products_id, products_price from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'");

$new_special_insert = tep_db_fetch_array($new_special_insert_query);

$products_price = $new_special_insert['products_price'];

$specials_price = ($products_price - (($specials_price / 100) * $products_price));

}

$expires_date = '';

if (tep_not_null($day) && tep_not_null($month) && tep_not_null($year)) {

$expires_date = $year;

$expires_date .= (strlen($month) == 1) ? '0' . $month : $month;

$expires_date .= (strlen($day) == 1) ? '0' . $day : $day;

}

// BOF - Separate_Pricing_Per_Customer_v3.5

// Next line was original code

// tep_db_query("insert into " . TABLE_SPECIALS . " (products_id, specials_new_products_price, specials_date_added, expires_date, status) values ('" . (int)$products_id . "', '" . tep_db_input($specials_price) . "', now(), '" . tep_db_input($expires_date) . "', '1')");

tep_db_query("insert into " . TABLE_SPECIALS . " (products_id, specials_new_products_price, specials_date_added, expires_date, status, customers_group_id) values ('" . (int)$products_id . "', '" . tep_db_input($specials_price) . "', now(), '" . tep_db_input($expires_date) . "', '1', ".(int)$customers_group.")");

// EOF - Separate_Pricing_Per_Customer_v3.5

tep_redirect(tep_href_link(FILENAME_SPECIALS, 'page=' . $HTTP_GET_VARS['page']));

break;

case 'update':

$specials_id = tep_db_prepare_input($HTTP_POST_VARS['specials_id']);

$products_price = tep_db_prepare_input($HTTP_POST_VARS['products_price']);

$specials_price = tep_db_prepare_input($HTTP_POST_VARS['specials_price']);

$day = tep_db_prepare_input($HTTP_POST_VARS['day']);

$month = tep_db_prepare_input($HTTP_POST_VARS['month']);

$year = tep_db_prepare_input($HTTP_POST_VARS['year']);

if (substr($specials_price, -1) == '%') $specials_price = ($products_price - (($specials_price / 100) * $products_price));

$expires_date = '';

if (tep_not_null($day) && tep_not_null($month) && tep_not_null($year)) {

$expires_date = $year;

$expires_date .= (strlen($month) == 1) ? '0' . $month : $month;

$expires_date .= (strlen($day) == 1) ? '0' . $day : $day;

}

tep_db_query("update " . TABLE_SPECIALS . " set specials_new_products_price = '" . tep_db_input($specials_price) . "', specials_last_modified = now(), expires_date = '" . tep_db_input($expires_date) . "' where specials_id = '" . (int)$specials_id . "'");

tep_redirect(tep_href_link(FILENAME_SPECIALS, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $specials_id));

break;

case 'deleteconfirm':

$specials_id = tep_db_prepare_input($HTTP_GET_VARS['sID']);

tep_db_query("delete from " . TABLE_SPECIALS . " where specials_id = '" . (int)$specials_id . "'");

tep_redirect(tep_href_link(FILENAME_SPECIALS, 'page=' . $HTTP_GET_VARS['page']));

break;

}

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

<?php

if ( ($action == 'new') || ($action == 'edit') ) {

?>

<?php

}

?>

</head>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

</table></td>

<tr>

<tr>

</tr>

</table></td>

</tr>

<?php

if ( ($action == 'new') || ($action == 'edit') ) {

$form_action = 'insert';

if ( ($action == 'edit') && isset($HTTP_GET_VARS['sID']) ) {

$form_action = 'update';

$product_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, s.specials_new_products_price, s.expires_date from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = s.products_id and s.specials_id = '" . (int)$HTTP_GET_VARS['sID'] . "'");

$product = tep_db_fetch_array($product_query);

$sInfo = new objectInfo($product);

} else {

$sInfo = new objectInfo(array());

// create an array of products on special, which will be excluded from the pull down menu of products

// (when creating a new product on special)

// BOF - Separate_Pricing_Per_Customer_v3.5

// Next lines were original code

/*

$specials_array = array();

$specials_query = tep_db_query("select p.products_id from " . TABLE_PRODUCTS . " p, " . TABLE_SPECIALS . " s where s.products_id = p.products_id");

while ($specials = tep_db_fetch_array($specials_query)) {

$specials_array[] = $specials['products_id'];

}

*/

$specials_array = array();

$specials_query = tep_db_query("select p.products_id, s.customers_group_id from " . TABLE_PRODUCTS . " p, " . TABLE_SPECIALS . " s where s.products_id = p.products_id");

while ($specials = tep_db_fetch_array($specials_query)) {

$specials_array[] = (int)$specials['products_id'].":".(int)$specials['customers_group_id'];

}

$customers_groups_query = tep_db_query("select distinct customers_group_name, customers_group_id from " . TABLE_CUSTOMERS . " order by customers_group_id ");

$input_groups=array();

$all_groups=array();

while ($existing_groups = tep_db_fetch_array($customers_groups_query)) {

$input_groups[$sde++]=array("id"=>$existing_groups['customers_group_id'], "text"=> $existing_groups['customers_group_name']);

$all_groups[$existing_groups['customers_group_id']]=$existing_groups['customers_group_name'];

}

if(isset($HTTP_GET_VARS['sID']) && $sInfo->customers_group_id!=0){

$customer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . $sInfo->products_id . "' and customers_group_id = '" . $sInfo->customers_group_id . "'");

if ($customer_group_price = tep_db_fetch_array($customer_group_price_query)) {

$sInfo->products_price = $customer_group_price['customers_group_price'];

}

// EOF - Separate_Pricing_Per_Customer_v3.5

?>

<tr><form name="new_special" <?php echo 'action="' . tep_href_link(FILENAME_SPECIALS, tep_get_all_get_params(array('action', 'info', 'sID')) . 'action=' . $form_action, 'NONSSL') . '"'; ?> method="post"><?php if ($form_action == 'update') echo tep_draw_hidden_field('specials_id', $HTTP_GET_VARS['sID']); ?>

<tr>

<td class="main"><?php echo (isset($sInfo->products_name)) ? $sInfo->products_name . ' <small>(' . $currencies->format($sInfo->products_price) . ')</small>' : tep_draw_products_pull_down('products_id', 'style="font-size:10px"', $specials_array); echo tep_draw_hidden_field('products_price', (isset($sInfo->products_price) ? $sInfo->products_price : '')); ?></td>

</tr>

// BOF - Separate_Pricing_Per_Customer_v3.5

<tr>

<td class="main"><?php echo tep_draw_pull_down_menu('customers_group', $input_groups, (isset($sInfo->customers_group_id)?$sInfo->customers_group_id:''));?> </td>

</tr>

// EOF - Separate_Pricing_Per_Customer_v3.5

<tr>

<td class="main"><?php echo tep_draw_input_field('specials_price', (isset($sInfo->specials_new_products_price) ? $sInfo->specials_new_products_price : '')); ?></td>

</tr>

<tr>

<td class="main"><?php echo tep_draw_input_field('day', (isset($sInfo->expires_date) ? substr($sInfo->expires_date, 8, 2) : ''), 'size="2" maxlength="2" class="cal-TextBox"') . tep_draw_input_field('month', (isset($sInfo->expires_date) ? substr($sInfo->expires_date, 5, 2) : ''), 'size="2" maxlength="2" class="cal-TextBox"') . tep_draw_input_field('year', (isset($sInfo->expires_date) ? substr($sInfo->expires_date, 0, 4) : ''), 'size="4" maxlength="4" class="cal-TextBox"'); ?><a class="so-BtnLink" href="java script:calClick();return false;" onmouseover="calSwapImg('BTN_date', 'img_Date_OVER',true);" onmouseout="calSwapImg('BTN_date', 'img_Date_UP',true);" onclick="calSwapImg('BTN_date', 'img_Date_DOWN');showCalendar('new_special','dteWhen','BTN_date');return false;"><?php echo tep_image(DIR_WS_IMAGES . 'cal_date_up.gif', 'Calendar', '22', '17', 'align="absmiddle" name="BTN_date"'); ?></a></td>

</tr>

</table></td>

</tr>

<tr>

<tr>

<td class="main" align="right" valign="top"><br><?php echo (($form_action == 'insert') ? tep_image_submit('button_insert.gif', IMAGE_INSERT) : tep_image_submit('button_update.gif', IMAGE_UPDATE)). ' <a href="' . tep_href_link(FILENAME_SPECIALS, 'page=' . $HTTP_GET_VARS['page'] . (isset($HTTP_GET_VARS['sID']) ? '&sID=' . $HTTP_GET_VARS['sID'] : '')) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td>

</tr>

</table></td>

</form></tr>

<?php

} else {

?>

<tr>

<tr>

</tr>

<?php

// BOF - Separate_Pricing_Per_Customer_v3.5

// Next line was original code

// $specials_query_raw = "select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from " . TABLE_PRODUCTS . " p, " . TABLE_SPECIALS . " s, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = s.products_id order by pd.products_name";

$all_groups=array();

$customers_groups_query = tep_db_query("select distinct customers_group_name, customers_group_id from " . TABLE_CUSTOMERS . " order by customers_group_id ");

while ($existing_groups = tep_db_fetch_array($customers_groups_query)) {

$all_groups[$existing_groups['customers_group_id']]=$existing_groups['customers_group_name'];

}

$specials_query_raw = "select p.products_id, pd.products_name, p.products_price, s.specials_id, s.customers_group_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from " . TABLE_PRODUCTS . " p, " . TABLE_SPECIALS . " s, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = s.products_id order by pd.products_name";

// EOF - Separate_Pricing_Per_Customer_v3.5

$specials_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $specials_query_raw, $specials_query_numrows);

$specials_query = tep_db_query($specials_query_raw);

while ($specials = tep_db_fetch_array($specials_query)) {

if ((!isset($HTTP_GET_VARS['sID']) || (isset($HTTP_GET_VARS['sID']) && ($HTTP_GET_VARS['sID'] == $specials['specials_id']))) && !isset($sInfo)) {

$products_query = tep_db_query("select products_image from " . TABLE_PRODUCTS . " where products_id = '" . (int)$specials['products_id'] . "'");

$products = tep_db_fetch_array($products_query);

$sInfo_array = array_merge($specials, $products);

$sInfo = new objectInfo($sInfo_array);

}

if (isset($sInfo) && is_object($sInfo) && ($specials['specials_id'] == $sInfo->specials_id)) {

echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_SPECIALS, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->specials_id . '&action=edit') . '\'">' . "\n";

} else {

echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_SPECIALS, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $specials['specials_id']) . '\'">' . "\n";

}

// BOF - Separate_Pricing_Per_Customer_v3.5

$scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . $specials['products_id']. "' and customers_group_id = '" . $sInfo->customers_group_id . "'");

if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query))

$sInfo->products_price=$specials['products_price']=$scustomer_group_price['customers_group_price'];

// EOF - Separate_Pricing_Per_Customer_v3.5

?>

// BOF - Separate_Pricing_Per_Customer_v3.5

// Next line was original code

// <td class="dataTableContent" align="right"><span class="oldPrice"><?php echo $currencies->format($specials['products_price']); ?></span> <span class="specialPrice"><?php echo $currencies->format($specials['specials_new_products_price']); ?></span></td>

<td class="dataTableContent" align="right"><span class="oldPrice"><?php echo $currencies->format($specials['products_price']); ?></span> <span class="specialPrice"><?php echo $currencies->format($specials['specials_new_products_price'])." (".$all_groups[$specials['customers_group_id']].")"; ?></span></td>

// EOF - Separate_Pricing_Per_Customer_v3.5

<?php

if ($specials['status'] == '1') {

echo tep_image(DIR_WS_IMAGES . 'icon_status_green.gif', IMAGE_ICON_STATUS_GREEN, 10, 10) . ' <a href="' . tep_href_link(FILENAME_SPECIALS, 'action=setflag&flag=0&id=' . $specials['specials_id'], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_red_light.gif', IMAGE_ICON_STATUS_RED_LIGHT, 10, 10) . '</a>';

} else {

echo '<a href="' . tep_href_link(FILENAME_SPECIALS, 'action=setflag&flag=1&id=' . $specials['specials_id'], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_green_light.gif', IMAGE_ICON_STATUS_GREEN_LIGHT, 10, 10) . '</a> ' . tep_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10);

}

?></td>

<td class="dataTableContent" align="right"><?php if (isset($sInfo) && is_object($sInfo) && ($specials['specials_id'] == $sInfo->specials_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_SPECIALS, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $specials['specials_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td>

</tr>

<?php

}

?>

<tr>

<tr>

<td class="smallText" valign="top"><?php echo $specials_split->display_count($specials_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_SPECIALS); ?></td>

<td class="smallText" align="right"><?php echo $specials_split->display_links($specials_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page']); ?></td>

</tr>

<?php

if (empty($action)) {

?>

<tr>

<td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_SPECIALS, 'page=' . $HTTP_GET_VARS['page'] . '&action=new') . '">' . tep_image_button('button_new_product.gif', IMAGE_NEW_PRODUCT) . '</a>'; ?></td>

</tr>

<?php

}

?>

</table></td>

</tr>

</table></td>

<?php

$heading = array();

$contents = array();

switch ($action) {

case 'delete':

$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_SPECIALS . '</b>');

$contents = array('form' => tep_draw_form('specials', FILENAME_SPECIALS, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->specials_id . '&action=deleteconfirm'));

$contents[] = array('text' => TEXT_INFO_DELETE_INTRO);

$contents[] = array('text' => '<br><b>' . $sInfo->products_name . '</b>');

$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . tep_href_link(FILENAME_SPECIALS, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->specials_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

break;

default:

if (is_object($sInfo)) {

$heading[] = array('text' => '<b>' . $sInfo->products_name . '</b>');

$contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_SPECIALS, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->specials_id . '&action=edit') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_SPECIALS, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->specials_id . '&action=delete') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');

$contents[] = array('text' => '<br>' . TEXT_INFO_DATE_ADDED . ' ' . tep_date_short($sInfo->specials_date_added));

$contents[] = array('text' => '' . TEXT_INFO_LAST_MODIFIED . ' ' . tep_date_short($sInfo->specials_last_modified));

$contents[] = array('align' => 'center', 'text' => '<br>' . tep_info_image($sInfo->products_image, $sInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT));

$contents[] = array('text' => '<br>' . TEXT_INFO_ORIGINAL_PRICE . ' ' . $currencies->format($sInfo->products_price));

$contents[] = array('text' => '' . TEXT_INFO_NEW_PRICE . ' ' . $currencies->format($sInfo->specials_new_products_price));

$contents[] = array('text' => '' . TEXT_INFO_PERCENTAGE . ' ' . number_format(100 - (($sInfo->specials_new_products_price / $sInfo->products_price) * 100)) . '%');

$contents[] = array('text' => '<br>' . TEXT_INFO_EXPIRES_DATE . ' <b>' . tep_date_short($sInfo->expires_date) . '</b>');

$contents[] = array('text' => '' . TEXT_INFO_STATUS_CHANGE . ' ' . tep_date_short($sInfo->date_status_change));

}

break;

}

if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) {

echo ' <td width="25%" valign="top">' . "\n";

$box = new box;

echo $box->infoBox($heading, $contents);

echo ' </td>' . "\n";

}

?>

</tr>

</table></td>

</tr>

</table></td>

</tr>

</table>

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Hope this helps!!

germ · June 6, 2007

I have installed Seperate prices per customer v3.51

Can you post the link to the instructions for that?

:unsure:

I've counted the {'s and the }'s and they're equally matched. I thought you had more of one than another, but not so.

:huh:

June 6, 2007

Check your quotes, this one shows a double quote at the end, but no begining quote

you will have to go back to square one and make sure the quotes are where they need to be and there are no doubles where they should not be

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');

This line to me should be

$action = ('isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : ');

but you need to check it out, Ralph

adz1976 · June 6, 2007

QUOTE

I have installed Seperate prices per customer v3.51

Jim

Module SPPC 3.51 just tells you to upload the files attached right over the original OSC files then to upload a few amendments to SQL database.

Below is the link to the mod

http://www.oscommerce.com/community/contri...SEPERATE+PRICES

The mod I downloaded was the one with the title below:

Separate Pricing Per Customer v3.5 - Packaged

Thanks for your help

Adam :-)

June 6, 2007

Check your quotes, this one shows a double quote at the end, but no begining quote
you will have to go back to square one and make sure the quotes are where they need to be and there are no doubles where they should not be

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');

This line to me should be

$action = ('isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : ');

but you need to check it out, Ralph

There should never be a quote (single or double) around php. Quotes only go around text, such as in an echo

echo 'hello' . $variable;

the php variable doesn't have quotes around it.

therefore that line should probably be:

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : );

adz1976 · June 6, 2007

There should never be a quote (single or double) around php. Quotes only go around text, such as in an echo
echo 'hello' . $variable;
the php variable doesn't have quotes around it.

therefore that line should probably be:
$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : );

I cant see how that can be the case, as from the original OSC MS2 specials.php file under the admin section that has a line in there as follows:

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');

and this file works fine.

So still very confused why you would say this could be the problem ?

Thanks

Adam :)

June 6, 2007

ah I've just realised what it is about that line.. just me being stupid. The last part is a double quote, it's two singles, which is correct.

still, it's got nothing to do with your problem.

You've probably missed out some brackets {} or a ; at the end of a statement.

germ · June 6, 2007

I think I found it.

:thumbsup:

Before editing the file, make a safe backup so you can replace it if necessary.

Edit this code:

// create an array of products on special, which will be excluded from the pull down menu of products
// (when creating a new product on special)

// BOF - Separate_Pricing_Per_Customer_v3.5

// Next lines were original code

/*

$specials_array = array();

$specials_query = tep_db_query("select p.products_id from " . TABLE_PRODUCTS . " p, " . TABLE_SPECIALS . " s where s.products_id = p.products_id");

while ($specials = tep_db_fetch_array($specials_query)) {

$specials_array[] = $specials['products_id'];

}

} <--- MOVE THIS LINE

*/

To this:

<td class="main"><br><?php echo TEXT_SPECIALS_PRICE_TIP; ?></td>
<td class="main" align="right" valign="top"><br><?php echo (($form_action == 'insert') ? tep_image_submit('button_insert.gif', IMAGE_INSERT) : tep_image_submit('button_update.gif', IMAGE_UPDATE)). ' <a href="' . tep_href_link(FILENAME_SPECIALS, 'page=' . $HTTP_GET_VARS['page'] . (isset($HTTP_GET_VARS['sID']) ? '&sID=' . $HTTP_GET_VARS['sID'] : '')) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td>

</tr>

</table></td>

</form></tr>

<?php

} <-- DOWN HERE

} else {

?>

That's moving it to right above the "else" you were having trouble with.

adz1976 · June 7, 2007

I think I found it.
:thumbsup:

Before editing the file, make a safe backup so you can replace it if necessary.

Edit this code:

To this:

That's moving it to right above the "else" you were having trouble with.

Hi Jim

No, sorry I can't do that because if you notice the code you are asking me to move,

it is only there for info, its not live code.

As you will see with the } you are asking me to move, it is within \* */ (therefore this is only info)

It's not actual live code.

Anyway, just got rid of SPPCv3.5 with V4.0, the specials section is now working fine but just came across another problem.

You will see my new post under

SPPC 4.0 Problem

1054 - Unknown column 'p.products_id' in 'on clause'

Thanks for your time anyway

Adam :-)

germ · June 7, 2007

I know it wasn't "live code", and that, my friend, was your problem.

With that one "}" commented out, you had one more live "{" than you did "}", thus the parse error.

It wasn't your fault.

I looked at the install instructions, and I believe them to be erroneous.

Sorry I can't help with your other problem.

:blush:

adz1976 · June 7, 2007

I know it wasn't "live code", and that, my friend, was your problem.

With that one "}" commented out, you had one more live "{" than you did "}", thus the parse error.

It wasn't your fault.

I looked at the install instructions, and I believe them to be erroneous.

Sorry I can't help with your other problem.

:blush:

Thanks for taking time to help Jim :-)

Parse Error: Syntax Error, Unexpected T_else In

Recommended Posts

adz1976

germ

adz1976

germ

Guest

adz1976

Guest

adz1976

Guest

germ

adz1976

germ

adz1976

Archived

Browse

Activity