snubbr.com

Use of Verisign SSL to serve webpages gives what % speed decrease?

Get a Verisign SSL certificate for 30 days FREE. Click here to use coupon...

Get a free trial of Verisign SSL certificates. Click here for this special deal...
Quick question: Use of Verisign SSL to serve webpages gives what % speed decrease? Many thanks for any comment. Another question I got... Hi, as title says I have followed peoples advice on this forum regarding changing the default text on the main page, I have added my own, but nothing seems to be visible at all.

Below is the index.php from /includes/languages/English/index.php but where I have put HELLOOOOO (just as a test) does not show up on the main page, when I goto my main page, I have a featured products section which I want to make into my own welcome message to the site.

Can anyone see what needs to be done or what could be wrong, as to why it is not showing up.

Thanks.

<?php.

/*.

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

OsCommerce, Open Source E-Commerce Solutions.

Http://www.oscommerce.com.

Copyright (c) 2003 osCommerce.

Released under the GNU General Public License.

*/.

Define('TEXT_MAIN', HELLLOOOOOOOOOOOOOOOOOOO);.

Define('TABLE_HEADING_NEW_PRODUCTS', 'New Products For %s');.

Define('TABLE_HEADING_UPCOMING_PRODUCTS', 'Upcoming Products');.

Define('TABLE_HEADING_DATE_EXPECTED', 'Date Expected');.

If ( ($category_depth == 'products') || (isset($HTTP_GET_VARS['manufacturers_id'])) ) {.

Define('HEADING_TITLE', 'Let\'s See What We Have Here');.

Define('TABLE_HEADING_IMAGE', '');.

Define('TABLE_HEADING_MODEL', 'Model');.

Define('TABLE_HEADING_PRODUCTS', 'Product Name');.

Define('TABLE_HEADING_MANUFACTURER', 'Manufacturer');.

Define('TABLE_HEADING_QUANTITY', 'Quantity');.

Define('TABLE_HEADING_PRICE', 'Price');.

Define('TABLE_HEADING_WEIGHT', 'Weight');.

Define('TABLE_HEADING_BUY_NOW', 'Buy Now');.

Define('TEXT_NO_PRODUCTS', 'There are no products to list in this category.');.

Define('TEXT_NO_PRODUCTS2', 'There is no product available from this manufacturer.');.

Define('TEXT_NUMBER_OF_PRODUCTS', 'Number of Products: ');.

Define('TEXT_SHOW', '<b>Show:</b>');.

Define('TEXT_BUY', 'Buy 1 \'');.

Define('TEXT_NOW', '\' now');.

Define('TEXT_ALL_CATEGORIES', 'All Categories');.

Define('TEXT_ALL_MANUFACTURERS', 'All Manufacturers');.

} elseif ($category_depth == 'top') {.

Define('HEADING_TITLE', 'What\'s New Here?');.

} elseif ($category_depth == 'nested') {.

Define('HEADING_TITLE', 'Categories');.

}.

?>..

Comments (178)

Good question... I dunno what is the right answer to your question. I'll do some poking around and get back to you if I got an good answer. You should email the people at Verisign as they probably can help you..

Comment #1

So does your index.php has a TEXT_MAIN in it?.

If not, this is how a standard index.php looks like in the relevant area (close to the bottom of the file):.

<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_MODULESFILENAME_NEW_PRODUCTS); ?></td>.

</tr>.

FILENAME_NEW_PRODUCTS in your case will probably be something like FILENAME_FEATURED_PRODUCTS...

Comment #2

Thanks for the reply.

I have checked and here is the original code missing the TEXT_MAIN.

<tr>.

<td><?php include(DIR_WS_MODULESFILENAME_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>.

<?php include(DIR_WS_MODULESFILENAME_NEW_PRODUCTS); ?>.

<table cellspacing=0 cellpadding=0>.

<tr><td height=16></td></tr>.

</table>.

</td>.

</tr>.

</table>.

</td>.

And here is the new code with TEXT_MAIN.

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

<tr>.

<td>.

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

</tr>.

<tr>.

<?php include(DIR_WS_MODULESFILENAME_NEW_PRODUCTS); ?>.

<table cellspacing=0 cellpadding=0>.

<tr><td height=16></td></tr>.

</table>.

But it pushes the bottom out, I guess my coding is wrong but thanks for the tip as that was obviously the problem..

Comment #3

Hi, me again.

I scrapped that template and I am now using a different one but having a similar problem with displaying the define main text on the homepage.

I have made the edit in includes/languages/english/index.php.

As follows.

Define('TEXT_MAIN', '.

<html>.

<body>.

The content of the body element is displayed in your browser..

</body>.

</html>.

');.

Define('TABLE_HEADING_NEW_PRODUCTS', 'New Products For %s');.

And I checked my catalog index.php and there was not a php echo text main, so I have added it as follows.

</tr>.

</table></td>.

<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_MODULESFILENAME_PRODUCT_LISTING); ?></td>.

</tr>.

</table></td>.

<?php.

} else { // default page.

I don't get any errors, the page loads fine but I cannot see any of my text that I want to show on the homepage, is there anything that could be stopping it being visible.

Anyone have any idea, I am very new to oscommerce so any help is much appreciated.

Thanks..

Comment #4

In your language file change it back to.

Define('TEXT_MAIN', HELLLOOOOOOOOOOOOOOOOOOO);..

Comment #5

Hi thanks for the reply, but I have just changed that and it is still not visible.

Any idea?..

Comment #6

Thanks.

<?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 (c) 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 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>.

<! header //>.

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

<! header_eof //>.

<! body //>.

<table border="0" width="1024" align="center" cellspacing="0" cellpadding="0">.

<tr align="left" valign="top">.

<td width="<?php echo BOX_WIDTH; ?>"><?php require(DIR_WS_INCLUDES'column_left.php'); ?></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%" height="100%"><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>.

</tr>.

</table></td>.

</tr>.

<tr>.

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

<tr>.

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

<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_MODULESFILENAME_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%"><table border="0" width="97%" 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'&nbsp;';.

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

}.

?>.

</tr>.

</table></td>.

<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_MODULESFILENAME_PRODUCT_LISTING); ?></td>.

</tr>.

</table></td>.

<?php.

} else { // default page.

?>.

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

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="0" style="background-image:url(images/linever.jpg) ">.

<tr>.

<td><?php include(DIR_WS_MODULESFILENAME_NEW_PRODUCTS); ?></td>.

</tr>.

<?php.

Include(DIR_WS_MODULESFILENAME_UPCOMING_PRODUCTS);.

?>.

</table></td>.

</tr>.

</table></td>.

<td width="<?php echo BOX_WIDTH2; ?>"><?php require(DIR_WS_INCLUDES'column_right.php'); ?></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 //>.

<br>.

</body>.

</html>.

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

Comment #7

Adjust your code at the bottom of the file so that it looks like this.

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

<tr>.

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

</tr>.

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="0" style="background-image:url(images/linever.jpg) ">.

<tr>.

<td><?php include(DIR_WS_MODULESFILENAME_NEW_PRODUCTS); ?></td>.

</tr>.

<?php.

Include(DIR_WS_MODULESFILENAME_UPCOMING_PRODUCTS);.

?>.

</table></td>.

</tr>.

</table></td>.

<td width="<?php echo BOX_WIDTH2; ?>"><?php require(DIR_WS_INCLUDES'column_right.php'); ?></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 //>.

<br>.

</body>.

</html>.

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

Comment #8

Hi thanks for that, I did the changes mentioned above, I have no errors page loads fine but still not text showing?.

Thanks for helping..

Comment #9

Do you have a Verisign website we can see?..

Comment #10

Hi I think you must be doing it wrong as the file I sent works fine on mine..

Comment #11

Thanks for the help guys!.

As far as I am aware I have been doing it right, as I managed to get it to work on a different template that had the echo define missing from the cat/index.php but I cannot on this one for some reason!!.

I will send you both a pm to the site, it is still being worked on so not open for public viewing yet.

Thanks..

Comment #12

Can you post both your catalog/index.php and catalog/includes/languages/english/index.php as they are right now?..

Comment #13

Sure here they are as they are running now.

Catalog/index.php.

<?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 (c) 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 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>.

<! header //>.

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

<! header_eof //>.

<! body //>.

<table border="0" width="1024" align="center" cellspacing="0" cellpadding="0">.

<tr align="left" valign="top">.

<td width="<?php echo BOX_WIDTH; ?>"><?php require(DIR_WS_INCLUDES'column_left.php'); ?></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%" height="100%"><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>.

</tr>.

</table></td>.

</tr>.

<tr>.

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

<tr>.

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

<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_MODULESFILENAME_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%"><table border="0" width="97%" 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'&nbsp;';.

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

}.

?>.

</tr>.

</table></td>.

</tr>.

<tr>.

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

</tr>.

<tr>.

<td ><?php include(DIR_WS_MODULESFILENAME_PRODUCT_LISTING); ?></td>.

</tr>.

</table></td>.

<?php.

} else { // default page.

?>.

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

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="0" style="background-image:url(images/linever.jpg) ">.

<tr>.

<td><?php include(DIR_WS_MODULESFILENAME_NEW_PRODUCTS); ?></td>.

</tr>.

<?php.

Include(DIR_WS_MODULESFILENAME_UPCOMING_PRODUCTS);.

?>.

</table></td>.

</tr>.

</table></td>.

<td width="<?php echo BOX_WIDTH2; ?>"><?php require(DIR_WS_INCLUDES'column_right.php'); ?></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 //>.

<br>.

</body>.

</html>.

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

Catalog/includes/languages/english/index.php.

<?php.

/*.

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

OsCommerce, Open Source E-Commerce Solutions.

Http://www.oscommerce.com.

Copyright (c) 2003 osCommerce.

Released under the GNU General Public License.

*/.

Define('TEXT_MAIN', HELLLOOOOOOOOOOOOOOOOOOO);.

Define('TABLE_HEADING_NEW_PRODUCTS', 'New Products For %s');.

Define('TABLE_HEADING_UPCOMING_PRODUCTS', 'Upcoming Products');.

Define('TABLE_HEADING_DATE_EXPECTED', 'Date Expected');.

If ( ($category_depth == 'products') || (isset($HTTP_GET_VARS['manufacturers_id'])) ) {.

Define('HEADING_TITLE', 'Let\'s See What We Have Here');.

Define('TABLE_HEADING_IMAGE', '');.

Define('TABLE_HEADING_MODEL', 'Model');.

Define('TABLE_HEADING_PRODUCTS', 'Product Name');.

Define('TABLE_HEADING_MANUFACTURER', 'Manufacturer');.

Define('TABLE_HEADING_QUANTITY', 'Quantity');.

Define('TABLE_HEADING_PRICE', 'Price');.

Define('TABLE_HEADING_WEIGHT', 'Weight');.

Define('TABLE_HEADING_BUY_NOW', 'Buy Now');.

Define('TEXT_NO_PRODUCTS', 'There are no products to list in this category.');.

Define('TEXT_NO_PRODUCTS2', 'There is no product available from this manufacturer.');.

Define('TEXT_NUMBER_OF_PRODUCTS', 'Number of Products: ');.

Define('TEXT_SHOW', '<b>Show:</b>');.

Define('TEXT_BUY', 'Buy 1 \'');.

Define('TEXT_NOW', '\' now');.

Define('TEXT_ALL_CATEGORIES', 'All Categories');.

Define('TEXT_ALL_MANUFACTURERS', 'All Manufacturers');.

} elseif ($category_depth == 'top') {.

Define('HEADING_TITLE', 'What\'s New Here?');.

} elseif ($category_depth == 'nested') {.

Define('HEADING_TITLE', 'Categories');.

}.

?>.

Many thanks..

Comment #14

Double post*.

This post has been edited by.

Techmob.

: 18 January 2009, 01:19..

Comment #15

Well I don't know how you expect it to show when you have NOT added the call for the degine in the index page..

Try this.

<?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 (c) 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 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>.

<! header //>.

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

<! header_eof //>.

<! body //>.

<table border="0" width="1024" align="center" cellspacing="0" cellpadding="0">.

<tr align="left" valign="top">.

<td width="<?php echo BOX_WIDTH; ?>"><?php require(DIR_WS_INCLUDES'column_left.php'); ?></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%" height="100%"><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>.

</tr>.

</table></td>.

</tr>.

<tr>.

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

<tr>.

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

<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_MODULESFILENAME_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%"><table border="0" width="97%" 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'&nbsp;';.

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

}.

?>.

</tr>.

</table></td>.

</tr>.

<tr>.

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

</tr>.

<tr>.

<td ><?php include(DIR_WS_MODULESFILENAME_PRODUCT_LISTING); ?></td>.

</tr>.

</table></td>.

<?php.

} else { // default page.

?>.

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

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="0" style="background-image:url(images/linever.jpg) ">.

<tr>.

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

</tr>.

<tr>.

<td><?php include(DIR_WS_MODULESFILENAME_NEW_PRODUCTS); ?></td>.

</tr>.

<?php.

Include(DIR_WS_MODULESFILENAME_UPCOMING_PRODUCTS);.

?>.

</table></td>.

</tr>.

</table></td>.

<td width="<?php echo BOX_WIDTH2; ?>"><?php require(DIR_WS_INCLUDES'column_right.php'); ?></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 //>.

<br>.

</body>.

</html>.

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

Comment #16

That would be because I replaced my edited version (the one with define in) with my default one after I edited it, because it didn't show when I did include it (as you can see from my above edits), and I was hoping for someone to show me exactly where it would work.

Thanks, will try yours now.

EDIT: and I am glad to say your edit worked and I am very greatful for your help.

This post has been edited by.

Techmob.

: 18 January 2009, 10:12..

Comment #17

Hi, as title says I have followed peoples advice on this forum regarding changing the default text on the main page, I have added my own, but nothing seems to be visible at all.

Below is the index.php from /includes/languages/English/index.php but where I have put HELLOOOOO (just as a test) does not show up on the main page, when I goto my main page, I have a featured products section which I want to make into my own welcome message to the site.

Can anyone see what needs to be done or what could be wrong, as to why it is not showing up.

Thanks.

<?php.

/*.

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

OsCommerce, Open Source E-Commerce Solutions.

Http://www.oscommerce.com.

Copyright (c) 2003 osCommerce.

Released under the GNU General Public License.

*/.

Define('TEXT_MAIN', HELLLOOOOOOOOOOOOOOOOOOO);.

Define('TABLE_HEADING_NEW_PRODUCTS', 'New Products For %s');.

Define('TABLE_HEADING_UPCOMING_PRODUCTS', 'Upcoming Products');.

Define('TABLE_HEADING_DATE_EXPECTED', 'Date Expected');.

If ( ($category_depth == 'products') || (isset($HTTP_GET_VARS['manufacturers_id'])) ) {.

Define('HEADING_TITLE', 'Let\'s See What We Have Here');.

Define('TABLE_HEADING_IMAGE', '');.

Define('TABLE_HEADING_MODEL', 'Model');.

Define('TABLE_HEADING_PRODUCTS', 'Product Name');.

Define('TABLE_HEADING_MANUFACTURER', 'Manufacturer');.

Define('TABLE_HEADING_QUANTITY', 'Quantity');.

Define('TABLE_HEADING_PRICE', 'Price');.

Define('TABLE_HEADING_WEIGHT', 'Weight');.

Define('TABLE_HEADING_BUY_NOW', 'Buy Now');.

Define('TEXT_NO_PRODUCTS', 'There are no products to list in this category.');.

Define('TEXT_NO_PRODUCTS2', 'There is no product available from this manufacturer.');.

Define('TEXT_NUMBER_OF_PRODUCTS', 'Number of Products: ');.

Define('TEXT_SHOW', '<b>Show:</b>');.

Define('TEXT_BUY', 'Buy 1 \'');.

Define('TEXT_NOW', '\' now');.

Define('TEXT_ALL_CATEGORIES', 'All Categories');.

Define('TEXT_ALL_MANUFACTURERS', 'All Manufacturers');.

} elseif ($category_depth == 'top') {.

Define('HEADING_TITLE', 'What\'s New Here?');.

} elseif ($category_depth == 'nested') {.

Define('HEADING_TITLE', 'Categories');.

}.

?>..

Comment #18

I think the template I am using is relevant and I am not sure if the define('TEXT_MAIN', is disabled or not used because of the layout...

Here is a pic of the template I am using, I have spent alot of time making changes to it and only have one more thing to do, which is where it shows featured products, I would like to have a welcome message/greeting like many sites do and then have some products underneath that.

Does anyone know what I need to do to achieve this, this is driving me bonkers.

Thanks.

This post has been edited by.

Techmob.

: 09 January 2009, 19:58..

Comment #19


This question was taken from a support group/message board and re-posted here so others can learn from it.

 

Categories: Home | Diet & Weight Management | Vitamins & Supplements | Herbs & Cleansing |

Sexual Health | Medifast Support | Nutrisystem Support | Medifast Questions |

Web Hosting | Web Hosts | Website Hosting | Hosting |

Web Hosting | GoDaddy | Digital Cameras | Best WebHosts |

Web Hosting FAQ | Web Hosts FAQ | Hosting FAQ | Hosting Group |

Hosting Questions | Camera Tips | Best Cameras To Buy | Best Cameras This Year |

Camera Q-A | Digital Cameras Q-A | Camera Forum | Nov 2010 - Cameras |

Oct 2010 - Cameras | Oct 2010 - DSLRs | Oct 2010 - Camera Tips | Sep 2010 - Cameras |

Sep 2010 - DSLRS | Sep 2010 - Camera Tips | Aug 2010 - Cameras | Aug 2010 - DSLR Tips |

Aug 2010 - Camera Tips | July 2010 - Cameras | July 2010 - Nikon Cameras | July 2010 - Canon Cameras |

July 2010 - Pentax Cameras | Medifast Recipes | Medifast Recipes Tips | Medifast Recipes Strategies |

Medifast Recipes Experiences | Medifast Recipes Group | Medifast Recipes Forum | Medifast Support Strategies |

Medifast Support Experiences |

 

(C) Copyright 2010 All rights reserved.