Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Does anyone understand this?


SpinerC

Recommended Posts

Thanks for the guidance in the past month to any and all who were able to help me learn some of the scripting codes and the layouts etc...

 

I have a new issue....... on going it seems :'(

 

I had an SSL Certificate installed, someone else did it. Since then it has been a nightmare! :blink: :huh:

 

First, all my Language files disappeared, I was able to get that back, due to a back up file, thank you Jesus!

 

Now..... well if you go to my site, you will see the error that doesn't exist, as far as I can tell.

 

www.diamondsahara.ca

 

Parse error: parse error, unexpected $ in /index.php on line 346

 

Because....... this is that line.........

 

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

 

And it seems fine, I compared it to the original files which I have saved.

 

When I went into the Admin Control Panel to add products yesterday, I noticed my little English Flag gif was missing and nothing I did would bring it back....

 

Well today I went to log in and couldn't..... then I was able to get the english.php file AND the folder re-installed....

 

And now I have a screen like this at my admin site.....

 

==================================

 

Administration | Online Catalog | Support Site

 

osCommerce

BOX_ENTRY_SUPPORT_SITE

BOX_ENTRY_SUPPORT_FORUMS

BOX_ENTRY_CONTRIBUTIONS

 

BOX_TITLE_ORDERS

Received:

Processing:

Shipped:

 

BOX_TITLE_STATISTICS

BOX_ENTRY_CUSTOMERS

BOX_ENTRY_PRODUCTS

BOX_ENTRY_REVIEWS

 

BOX_CONNECTION_PROTECTED

 

HEADING_TITLE EnglishEnglish

 

Configuration

My Store, Logging, Cache

 

Modules

Payment, Shipping

 

 

Catalog

CATALOG_CONTENTS, Manufacturers

 

Locations / Taxes

Countries, Tax Zones

 

 

Customers

Customers, Orders

 

Localization

Currencies, Languages

 

 

Reports

REPORTS_PRODUCTS, REPORTS_ORDERS

 

Tools

TOOLS_BACKUP, TOOLS_BANNERS, TOOLS_FILES

 

E-Commerce Engine Copyright © 2005 osCommerce

osCommerce provides no warranty and is redistributable under the GNU General Public License

 

Powered by osCommerce

 

====================================

 

All the underscoring is showing where it was clean text before the SSL Certificate being added.... seems it dropped things and doesn't recognize things..... I am so lost :'(

 

Is there anyone who can help me to get my store back on line?

 

I am a Newbie :(

 

Thank you :wub: to anyone who can help me......

 

Sincerely

Charlene :)

Link to comment
Share on other sites

I guess I am screwed in plain english....

 

I have been here all weekend asking, no begging and pleading for help :(

 

I haven't a clue where to go from here or what to do..... I have a $1400.00 Advertising Promotion that is coming out on the 10th of March and the site isn't really lol!! Heck, its not even viewable any more lol!

 

Thanks for reading my frustrations.....

 

Hope your weekend has gone better then mine :(

 

Sincerely

Charlene

Link to comment
Share on other sites

When I went into the Admin Control Panel to add products yesterday, I noticed my little English Flag gif was missing and nothing I did would bring it back....

 

Well today I went to log in and couldn't..... then I was able to get the english.php file AND the folder re-installed....

 

And now I have a screen like this at my admin site.....

 

==================================

 

Administration | Online Catalog | Support Site

 

osCommerce

BOX_ENTRY_SUPPORT_SITE

BOX_ENTRY_SUPPORT_FORUMS

BOX_ENTRY_CONTRIBUTIONS

 

BOX_TITLE_ORDERS

Received:

Processing:

Shipped:

 

BOX_TITLE_STATISTICS

BOX_ENTRY_CUSTOMERS

BOX_ENTRY_PRODUCTS

BOX_ENTRY_REVIEWS

 

BOX_CONNECTION_PROTECTED

 

HEADING_TITLE EnglishEnglish

 

Configuration

My Store, Logging, Cache

 

Modules

Payment, Shipping

 

 

Catalog

CATALOG_CONTENTS, Manufacturers

 

Locations / Taxes

Countries, Tax Zones

 

 

Customers

Customers, Orders

 

Localization

Currencies, Languages

 

 

Reports

REPORTS_PRODUCTS, REPORTS_ORDERS

 

Tools

TOOLS_BACKUP, TOOLS_BANNERS, TOOLS_FILES

 

E-Commerce Engine Copyright © 2005 osCommerce

osCommerce provides no warranty and is redistributable under the GNU General Public License

 

Powered by osCommerce

 

====================================

 

All the underscoring is showing where it was clean text before the SSL Certificate being added.... seems it dropped things and doesn't recognize things..... I am so lost :'(

 

Is there anyone who can help me to get my store back on line?

 

I am a Newbie :(

 

Thank you :wub: to anyone who can help me......

 

Sincerely

Charlene :)

 

Not sure about your first problem, but the second problem in your admin is because of your langauge files. The defines for all those items are missing from your files.

 

This is an excellent site for finding the file that is missing a define:

link

 

Tim

Link to comment
Share on other sites

Not sure about your first problem, but the second problem in your admin is because of your langauge files. The defines for all those items are missing from your files.

 

This is an excellent site for finding the file that is missing a define:

link

 

Tim

 

Thank you Tim :wub: for your response, I have the site and will be going through it to try and find all that is missing, you're the best! :blush:

 

Sincerely

Charlene :)

Link to comment
Share on other sites

Well I have exhausted all that I can do, thanks again :wub: Tim for the link to that site...... I went through the files there and can't find anything any different then what I already have.

 

This nightmare all started when the SSL Certificate was added to the site..... first the English Icon disappeared, then when I check the checkout proces, there were no shipping choices and no payment choices.....

 

It is like everything from the "My Admin php" was just gone...... :huh:

 

And I am a newbie, :blink: I have no idea what was added when they moved the site to a secure site and what codes were added to the files...... I know that the configure.php files on in admin and one in includes where both changed but, they seem to be set to all the references I can find.

 

As I said before........

 

I am screwed!! :'(

 

Thanks anyways.....

 

Hope your weekend was better then mine..... I am dreading Monday morning.....

 

Sincerely

Charlene

Link to comment
Share on other sites

Char :o),

Well what I would do to locate the problem...is to change the SSL option to false in the catalog/include/configure.php and see if that points to the SSL cert install... until you can resolve the problem. When you set it to false then it won't go into the HTTPS mode

define('ENABLE_SSL', false);

I hope this helps.

Roman

Link to comment
Share on other sites

I would suggest restoring your back up again. I restored once and many of my files were only half there when the process was done. Coincidentally, they were the english files with the defines.

 

If your store was working when the backup was made, it should still work after doing a restore. The SSL change should only have been a couple of lines in your config files.

 

Tim

Link to comment
Share on other sites

Thanks Roman and Tim for your response, I did go into the two configure files and reset the SSL Certificate to False.

 

I am still getting this error:

 

Parse error: parse error, unexpected $ in /html/index.php on line 335

 

Where the heck would this file be? I know where the ADMIN/index.php file is and the includes/language/english/index/php file is located but, HTML?

 

I replaced so many files last night..... I sat here until 2am going through the list that Tim provided and made backups of my files to my hard drive first of course then tried changing files to the ones on the list.

 

My/admin console still looks the same, nothing any different..... still showing the headers in the boxes with BOX_TITLE throughout the screen. I have the Icon of the box but, the words on it and most of the files in it, are all missing or screwed up.

 

The Configuration with "My Store" -- "Modules" -- "Locations/Taxes" and "Localizations" are the only words not effected but, when you click on them, some like Modules, it has no options in it. I can't choose payments etc.... because there is nothing in there and all the buttons are missing.

 

Thanks again for trying.... I am so desperate, at this point if I could afford to get someone to fix it, I would but, I spent so much money on advertising..... :'(

 

I called anyone and everyone I could think of to see if they had any experience with this stuff last night.... and still can't get ahold of the fella that installed it. He said he was going to fix it on Saturday morning..... nope.

 

Sincerely

Charlene

 

Char :o),

Well what I would do to locate the problem...is to change the SSL option to false in the catalog/include/configure.php and see if that points to the SSL cert install... until you can resolve the problem. When you set it to false then it won't go into the HTTPS mode

define('ENABLE_SSL', false);

I hope this helps.

Roman

 

 

I would suggest restoring your back up again. I restored once and many of my files were only half there when the process was done. Coincidentally, they were the english files with the defines.

 

If your store was working when the backup was made, it should still work after doing a restore. The SSL change should only have been a couple of lines in your config files.

 

Tim

Link to comment
Share on other sites

If I understand this error, it is suppose to be found in the very last line of the script in this index.php file. Yet, I have compared it to the one Tim gave me and I copied a portion of the bottom of the file and still nothing, the error is still on the site.

 

www.diamondsahara.ca

 

Thanks :)

 

Sincerely a desperate

Charlene

 

 

<?php

/*

$Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

require('includes/application_top.php');

 

// the following cPath references come from application_top.php

$category_depth = 'top';

if (isset($cPath) && tep_not_null($cPath)) {

$categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

$cateqories_products = tep_db_fetch_array($categories_products_query);

if ($cateqories_products['total'] > 0) {

$category_depth = 'products'; // display products

} else {

$category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");

$category_parent = tep_db_fetch_array($category_parent_query);

if ($category_parent['total'] > 0) {

$category_depth = 'nested'; // navigate through the categories

} else {

$category_depth = 'products'; // category has no products, but display the 'no products' message

}

}

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);

?>

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

<html <?php echo HTML_PARAMS; ?>>

<head>

*META INFOMATION GOES HERE ---- REMOVED FOR THE SAKE OF POSTING THE FILE HERE*

<META name="robots" CONTENT="index,follow">

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- header //-->

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

<!-- header_eof //-->

<!-- body //-->

<table border="0" width="100%" align="center" cellspacing="3" cellpadding="3">

<tr>

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

<!-- left_navigation //-->

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

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<?php

if ($category_depth == 'nested') {

$category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");

$category = tep_db_fetch_array($category_query);

?>

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . $category['categories_image'], $category['categories_name'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<?php

if (isset($cPath) && strpos('_', $cPath)) { // check to see if there are deeper categories within the current category

$category_links = array_reverse($cPath_array); for($i=0, $n=sizeof($category_links); $i<$n; $i++) {

$categories_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'");

$categories = tep_db_fetch_array($categories_query);

if ($categories['total'] < 1) {

// do nothing, go through the loop

} else {

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

break; // we've found the deepest category the customer is in

}

}

} else {

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

}

$number_of_categories = tep_db_num_rows($categories_query);

$rows = 0;

while ($categories = tep_db_fetch_array($categories_query)) {

$rows++;

$cPath_new = tep_get_path($categories['categories_id']);

$width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';

echo '

<td align="center" class="smallText" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></td>' . "\n";

if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) {

echo '

</tr>' . "\n";

echo '

<tr>' . "\n";

}

}

// needed for the new products module shown below

$new_products_category_id = $current_category_id;

?>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td>

</tr>

</table></td>

</tr>

</table></td>

<?php

} elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) {

// create column list

$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,

'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,

'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,

'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,

'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,

'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,

'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,

'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);

asort($define_list);

$column_list = array();

reset($define_list);

while (list($key, $value) = each($define_list)) {

if ($value > 0) $column_list[] = $key;

}

$select_column_list = '';

for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

switch ($column_list[$i]) {

case 'PRODUCT_LIST_MODEL':

$select_column_list .= 'p.products_model, ';

break;

case 'PRODUCT_LIST_NAME':

$select_column_list .= 'pd.products_name, ';

break;

case 'PRODUCT_LIST_MANUFACTURER':

$select_column_list .= 'm.manufacturers_name, ';

break;

case 'PRODUCT_LIST_QUANTITY':

$select_column_list .= 'p.products_quantity, ';

break;

case 'PRODUCT_LIST_IMAGE':

$select_column_list .= 'p.products_image, ';

break;

case 'PRODUCT_LIST_WEIGHT':

$select_column_list .= 'p.products_weight, ';

break;

}

}

// show the products of a specified manufacturer

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only a specific category

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";

} else {

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

}

} else {

// show the products in a given categorie

if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only specific catgeory

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

} else {

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

}

}

if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {

for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

if ($column_list[$i] == 'PRODUCT_LIST_NAME') {

$HTTP_GET_VARS['sort'] = $i+1 . 'a';

$listing_sql .= " order by pd.products_name";

break;

}

}

} else {

$sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);

$sort_order = substr($HTTP_GET_VARS['sort'], 1);

$listing_sql .= ' order by ';

switch ($column_list[$sort_col-1]) {

case 'PRODUCT_LIST_MODEL':

$listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_NAME':

$listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : '');

break;

case 'PRODUCT_LIST_MANUFACTURER':

$listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_QUANTITY':

$listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_IMAGE':

$listing_sql .= "pd.products_name";

break;

case 'PRODUCT_LIST_WEIGHT':

$listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_PRICE':

$listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

}

}

?>

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

<?php

// optional Product List Filter

if (PRODUCT_LIST_FILTER > 0) {

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";

} else {

$filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name";

}

$filterlist_query = tep_db_query($filterlist_sql);

if (tep_db_num_rows($filterlist_query) > 1) {

echo ' <td align="center" class="main">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' ';

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']);

$options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES));

} else {

echo tep_draw_hidden_field('cPath', $cPath);

$options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS));

}

echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']);

while ($filterlist = tep_db_fetch_array($filterlist_query)) {

$options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);

}

echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"');

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

}

}

// Get the right image for the top-right

$image = DIR_WS_IMAGES . 'table_background_list.gif';

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

$image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");

$image = tep_db_fetch_array($image);

$image = $image['manufacturers_image'];

} elseif ($current_category_id) {

$image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

$image = tep_db_fetch_array($image);

$image = $image['categories_image'];

}

?>

<td align="right"><?php echo tep_image(DIR_WS_IMAGES . $image, HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td>

</tr>

</table></td>

<?php

} else { // default page

?>

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

<td class="pageHeading" align="right"></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td class="main"><?php echo tep_customer_greeting(); ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td class="main"><?php echo TEXT_MAIN; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td>

</tr>

<?php

include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);

?>

</table></td>

</tr>

</table></td>

<?php

}

?>

<!-- body_text_eof //-->

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

<!-- right_navigation //-->

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

<!-- right_navigation_eof //-->

</table></td>

</tr>

</table>

<!-- body_eof //-->

 

!-- footer //-->

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

<!-- footer_eof //-->

</body>

<br>

</html>

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...