Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Adding an Image to Index Page - Fried my Brain...


Mort-lemur

Recommended Posts

Posted

Hi,

 

I have spent the last 3 hours trying to do what I thought was going to be a simple task.

 

All I want to do is add a large image below my categories image box on my home page, with a link to my weekly special offer.

 

ie. I want the image to appear between column right and column left, above the footer, but below the categories image box.

 

this is the code I'm trying to insert:

<a href="http://www.mysite.co.uk" target="_blank">
<img border="2" alt="Verm-X Special Offer" src="/images/Promo_Banner.gif" width="660" height="300" align="center"/>

 

But try as I might inserting this in various places in index.php I just can't get it in the right place!

 

Any help would be really appreciated.

 

Thanks

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Posted

Heather,

 

Is this in the left column under the Categories box ? If so, there are many contributions you could download and alter to add a box in the column.

 

If you are talking about in the main text area, you can add text and images by editing the TEXT_MAIN area of the english.php file. OR, download and install the IPU contribution and an HTML editor to edit that area from admin.

 

 

Chris

Posted

Hi Chris,

 

No, Im not trying to add a new box to the column left or right, nor am I trying to add text to the mainpage.

 

What I have on my site (in the center between col left and right) is:

 

at the top a Rotating banner (as per the banner rotator contribution)

below this a box with my four top level categories (used categories image box contribution)

 

Now below this is where I want to add a large image to fill the space between col left & col right.

 

I will pm you the url of my site so you can see what i mean.

 

Thanks

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Posted

Hi Chris,

 

No, Im not trying to add a new box to the column left or right, nor am I trying to add text to the mainpage.

 

What I have on my site (in the center between col left and right) is:

 

at the top a Rotating banner (as per the banner rotator contribution)

below this a box with my four top level categories (used categories image box contribution)

 

Now below this is where I want to add a large image to fill the space between col left & col right.

 

I will pm you the url of my site so you can see what i mean.

 

Thanks

 

 

You can insert a row like this after your category box.

 

<tr>

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

</tr>

<tr><td><a href="http://www.mysite.co.uk" target="_blank"><img border="2" alt="Verm-X Special Offer" src="/images/Promo_Banner.gif" width="660" height="300" align="center"/></a></td></tr>

Posted

Thank you So much,

 

That worked a treat.

 

Thanks to both of you.

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Posted

Heather,

 

Next time don't wait 3 days to look for assistance, brain cells are important :lol:

 

 

 

Chris

Posted

Heather,

 

You may also want to edit the code to remove the <a href.....> if the image is not going to lead to another site or page. You can display just the image by just posting the <img src........>

 

Right now it shows as a link but just opens the index again in another tab.

 

 

Chris

Posted

When I have fried brain I usually end up having a little bruised ego to go along with it.

:blush:

 

Maybe it's just me....

:lol:

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Posted

Heather,

 

You may also want to edit the code to remove the <a href.....> if the image is not going to lead to another site or page. You can display just the image by just posting the <img src........>

 

Right now it shows as a link but just opens the index again in another tab.

 

 

Chris

 

Hi,

 

Sorry - I had not actually added the product, now I have, and the href now points to the page of the promo item.

 

Thanks

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Posted

I have a similar problem, here is my site. I would like to add 6 manufacturer images to the front page under the main picture, also remove the bit that is shadowed under the picture.

I would be very grateful for any help here, its a bit out of my league.

www.fancydressbonanza.co.uk

 

Thanks in advance

 

Mark

******************************************

** Aspire To Inspire Before You Retire Or Expire! **

******************************************

Posted

Hi,

 

I have spent the last 3 hours trying to do what I thought was going to be a simple task.

 

All I want to do is add a large image below my categories image box on my home page, with a link to my weekly special offer.

 

ie. I want the image to appear between column right and column left, above the footer, but below the categories image box.

 

this is the code I'm trying to insert:

<a href="http://www.mysite.co.uk" target="_blank">
<img border="2" alt="Verm-X Special Offer" src="/images/Promo_Banner.gif" width="660" height="300" align="center"/>

 

But try as I might inserting this in various places in index.php I just can't get it in the right place!

 

Any help would be really appreciated.

 

Thanks

 

 

Hi Heather,

 

Why don't you create first a box for your featured product. Then a banner (like the oscommerce banner which shows up or not at the bottom) in your banner manager defining the width and height) with the link to the featured page and then at the bottom of your index.php follow the structure after :

 

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

</tr>

<td<?php include(DIR_WS_BOXES . 'bannerX.php'); ?></td>

 

A typical banner box is something like this:

******************************************************

/*

$Id: languages.php,v 1.15 2003/06/09 22:10:48 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

?>

<tr><td class="banner_0X"><?php if ($banner = tep_banner_exists('dynamic', 'bannerX')) { echo tep_display_banner('static', $banner); }?></td></tr>

Posted

I have a similar problem, here is my site. I would like to add 6 manufacturer images to the front page under the main picture, also remove the bit that is shadowed under the picture.

I would be very grateful for any help here, its a bit out of my league.

www.fancydressbonanza.co.uk

 

Thanks in advance

 

Mark

Have you cleaned up your site?

:unsure:

 

Clicking the link in your last post the malware on your site tried to download a virus or something to my machine.

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Posted

Have you cleaned up your site?

:unsure:

 

Clicking the link in your last post the malware on your site tried to download a virus or something to my machine.

 

 

Hi Jim

 

Yes thanks, somebody had injected a malicious script through the shopping cart.

 

Hostgator sorted it out, they we're very good :rolleyes:

 

Have you any idea how to help me here Jim

 

Mark

******************************************

** Aspire To Inspire Before You Retire Or Expire! **

******************************************

Posted

The light colored area under the pic is caused by this code (that currently does nothing else):

 

<table class="content_wrapper_b" border="0" cellpadding="0" cellspacing="0">
     <tr><td class="content_wrapper_r">
       <div class="content_wrapper_t">
         <div class="content_wrapper_l">
           <div class="content_wrapper_tl">
             <div class="content_wrapper_tr">
               <div class="content_wrapper_bl">
                 <div class="content_wrapper_br">
                   <div class="width_100"> 
<!-- Welcome_box_start -->
    <!--   <table border="0" width="100%" cellspacing="0" cellpadding="0">
         <tr><td class="main"></td></tr>
         <tr><td></td></tr>
         <tr><td class="main"></td></tr>
       </table>  -->
<!-- Welcome_box_end -->
</div>
                 </div>
               </div>
             </div>
           </div>
         </div>
       </div>
     </td></tr>
</table>

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

  • 5 weeks later...
Posted

The light colored area under the pic is caused by this code (that currently does nothing else):

 

<table class="content_wrapper_b" border="0" cellpadding="0" cellspacing="0">
     <tr><td class="content_wrapper_r">
       <div class="content_wrapper_t">
         <div class="content_wrapper_l">
           <div class="content_wrapper_tl">
             <div class="content_wrapper_tr">
               <div class="content_wrapper_bl">
                 <div class="content_wrapper_br">
                   <div class="width_100"> 
<!-- Welcome_box_start -->
    <!--   <table border="0" width="100%" cellspacing="0" cellpadding="0">
         <tr><td class="main"></td></tr>
         <tr><td></td></tr>
         <tr><td class="main"></td></tr>
       </table>  -->
<!-- Welcome_box_end -->
</div>
                 </div>
               </div>
             </div>
           </div>
         </div>
       </div>
     </td></tr>
</table>

 

Thanks for the reply Jim, and sorry for the delay. I have been away.

Can you explain in a little more detail what i have to do please.

 

Thanks

******************************************

** Aspire To Inspire Before You Retire Or Expire! **

******************************************

Posted

If you want to remove the light area under the pic remove the code I posted.

 

It currently does nothing else but cause the light area you don't like.

 

Read my signature about backups - You break it, you bought it.

:blush:

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Posted

If you want to remove the light area under the pic remove the code I posted.

 

It currently does nothing else but cause the light area you don't like.

 

Read my signature about backups - You break it, you bought it.

:blush:

 

Hi Jim

 

Sorted it now, the text i had to remove was

 

<?php echo tep_draw_top();?>

 

<!-- Welcome_box_start -->

<?php /* tep_draw_heading_top(); */?>

<?php /* tep_draw_heading_top_3(); */?>

<?php /* echo tep_draw_prod_top(); */ ?>

<!-- <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>

</table> -->

 

<?php /* echo tep_draw_prod_bottom(); */ ?>

<?php /* tep_draw_heading_bottom_3(); */?>

<?php /* echo tep_draw_separate(); */ ?>

<!-- Welcome_box_end -->

 

I did nt work because i did nt delete

 

<?php echo tep_draw_top();?>

 

Anyway sorted now thanks for your help.

 

Jim I would like to put 9 brand images 3 x 3 under the image now with links to pages in the site, have you any idea how i can achieve this.

 

Thanks in advance

 

Mark

******************************************

** Aspire To Inspire Before You Retire Or Expire! **

******************************************

Posted

Find the code for the <table> that currently presents the pic in the middle:

 

<table border="0" cellpadding="2" cellspacing="5" width="100%"
 <tr>
   <td class="main2" valign="top"><img src="images/indeximage.gif" alt="" border="0" height="375" width="500"></td>
 </tr>
</table>

 

Change it to:

 

      <table border="0" cellpadding="2" cellspacing="5" width="100%">
       <tr>
         <td class="main2" valign="top"><img src="images/indeximage.gif" alt="" border="0" height="375" width="500"></td>
       </tr>

       <tr><td valign="top">
         <table border="0" width="100%" cellpadding="0" cellspacing="0">
           <tr>
             <td align="center" width="33%">
             <!--r1c1-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_canon.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
             <td align="center" width="34%">
             <!--r1c2-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_fox.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
             <td align="center" width="33%">
             <!--r1c3-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_gt_interactive.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
           </tr>
         </table>
       </td></tr>


       <tr><td valign="top">
         <table border="0" width="100%" cellpadding="0" cellspacing="0">
           <tr>
             <td align="center" width="33%">
             <!--r2c1-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_hewlett_packard.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
             <td align="center" width="34%">
             <!--r2c2-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_logitech.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
             <td align="center" width="33%">
             <!--r2c3-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_matrox.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
           </tr>
         </table>
       </td></tr>

       <tr><td valign="top">
         <table border="0" width="100%" cellpadding="0" cellspacing="0">
           <tr>
             <td align="center" width="33%">
             <!--r3c1-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_microsoft.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
             <td align="center" width="34%">
             <!--r3c2-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_sierra.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
             <td align="center" width="33%">
             <!--r3c3-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_warner.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
           </tr>
         </table>
       </td></tr>

     </table>

 

In the code I posted just change the image names. the 'Mouseover text' and the cPath=1 part of the code to link to the proper category you want.

 

If you do it correctly it will work (I wrote a test program and copy/pasted the HTML into your site's code using the web developer plugin in Firefox).

 

Better backiup the file 1st.

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Posted

Find the code for the <table> that currently presents the pic in the middle:

 

<table border="0" cellpadding="2" cellspacing="5" width="100%"
 <tr>
   <td class="main2" valign="top"><img src="images/indeximage.gif" alt="" border="0" height="375" width="500"></td>
 </tr>
</table>

 

Change it to:

 

      <table border="0" cellpadding="2" cellspacing="5" width="100%">
       <tr>
         <td class="main2" valign="top"><img src="images/indeximage.gif" alt="" border="0" height="375" width="500"></td>
       </tr>

       <tr><td valign="top">
         <table border="0" width="100%" cellpadding="0" cellspacing="0">
           <tr>
             <td align="center" width="33%">
             <!--r1c1-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_canon.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
             <td align="center" width="34%">
             <!--r1c2-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_fox.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
             <td align="center" width="33%">
             <!--r1c3-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_gt_interactive.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
           </tr>
         </table>
       </td></tr>


       <tr><td valign="top">
         <table border="0" width="100%" cellpadding="0" cellspacing="0">
           <tr>
             <td align="center" width="33%">
             <!--r2c1-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_hewlett_packard.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
             <td align="center" width="34%">
             <!--r2c2-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_logitech.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
             <td align="center" width="33%">
             <!--r2c3-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_matrox.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
           </tr>
         </table>
       </td></tr>

       <tr><td valign="top">
         <table border="0" width="100%" cellpadding="0" cellspacing="0">
           <tr>
             <td align="center" width="33%">
             <!--r3c1-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_microsoft.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
             <td align="center" width="34%">
             <!--r3c2-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_sierra.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
             <td align="center" width="33%">
             <!--r3c3-->
<?php
     echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=1') . '">' . tep_image(DIR_WS_IMAGES . 'manufacturer_warner.gif', 'Mouseover text') .  '</a>' . "\n";
?>
             </td>
           </tr>
         </table>
       </td></tr>

     </table>

 

In the code I posted just change the image names. the 'Mouseover text' and the cPath=1 part of the code to link to the proper category you want.

 

If you do it correctly it will work (I wrote a test program and copy/pasted the HTML into your site's code using the web developer plugin in Firefox).

 

Better backiup the file 1st.

 

Hi Jim

 

Thank you so much for the trouble you have obviously gone to to help me out here but im having problems finding the code to replace. I assume that we are talking about the index.php which is below

<?php

/*

$Id: index.php 1739 2007-12-20 00:52:16Z hpdl $

 

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 name="google-site-verification" content="MKxokVsBG5sfVMZmQMYCp5uWMCdLIN80OvLgIAl_yyM" />

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

<?php include(DIR_WS_INCLUDES . 'easy_meta_tags.php'); ?>

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

<script type="text/javascript" src="iepngfix_tilebg.js"></script>

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

<style type="text/css">

.ie6_png {behavior: url("iepngfix.htc") }

.ie6_png img {behavior: url("iepngfix.htc") }

.ie6_png input {behavior: url("iepngfix.htc") }

</style>

<!--[if IE]>

<script type="text/javascript" src="ie_png.js"></script>

<script type="text/javascript">

ie_png.fix('.png');

</script>

<![endif]-->

</head>

<body>

<!-- header //-->

<?php $tab_sel = 2; ?>

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

<!-- header_eof //-->

 

<!-- body //-->

<table border="0" class="<?php echo MAIN_TABLE; ?>" cellspacing="0" cellpadding="0">

<tr>

<td class="<?php echo BOX_WIDTH_TD_LEFT; ?>"><table border="0" class="<?php echo BOX_WIDTH_LEFT; ?>" cellspacing="0" cellpadding="0">

<!-- 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 class="<?php echo CONTENT_WIDTH_TD; ?>"><?php echo panel_top(); ?>

 

<?php echo tep_draw_top();?>

 

<?php new contentBoxHeading_ProdNew($info_box_contents);?>

 

<?php echo tep_draw3_top();?>

 

 

<table border="0" width="100%" cellspacing="0" cellpadding="0" class="main" style="margin:0px 0px 7px 0px;">

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

 

$p_pic_sub = '<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) . '</a>';

 

$p_name_sub = '<a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . $categories['categories_name'] . '</a>';

 

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

echo '<td align="center" width="' . $width . '">

<table cellpadding="0" cellspacing="0" border="0">

<tr><td class="pic3_padd">'.tep_draw_prod_pic_top().''.$p_pic_sub.''.tep_draw_prod_pic_bottom().'</td></tr>

<tr><td class="name name3_padd">'.$p_name_sub.'</td></tr>

</table>

</td>'."\n";

 

if ($col!=(MAX_DISPLAY_CATEGORIES_PER_ROW-1)){

echo '

<td class="prod_line_y">'.tep_draw_separator('spacer.gif', '1', '1').'</td>

';

}else{

 

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

echo '

</tr><tr><td class="prod_line_x" colspan="'.(MAX_DISPLAY_CATEGORIES_PER_ROW + MAX_DISPLAY_CATEGORIES_PER_ROW -1).'">'.tep_draw_separator('spacer.gif', '1', '15').'</td></tr>' . "\n";

echo '<tr>' . "\n";

}

}

if ($col==MAX_DISPLAY_CATEGORIES_PER_ROW-1){

$col=0;

}else{

$col++;

}

}

 

// needed for the new products module shown below

$new_products_category_id = $current_category_id;

?>

</tr>

</table>

 

 

 

<?php echo tep_draw3_bottom();?>

 

<?php echo tep_draw_bottom();?>

 

<?php echo tep_draw_top();?>

 

<?php new contentBoxHeading_WHATS_NEW($info_box_contents, true, false);?>

 

<?php echo tep_draw3_top();?><?php echo tep_draw3_bottom();?>

 

<?php echo tep_draw_bottom();?> </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);

 

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

case 'PRODUCT_LIST_MODEL':

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

break;

case 'PRODUCT_LIST_NAME':

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

break;

case 'PRODUCT_LIST_MANUFACTURER':

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

break;

case 'PRODUCT_LIST_QUANTITY':

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

break;

case 'PRODUCT_LIST_IMAGE':

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

break;

case 'PRODUCT_LIST_WEIGHT':

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

break;

case 'PRODUCT_LIST_PRICE':

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

break;

}

}

?>

<td class="<?php echo CONTENT_WIDTH_TD; ?>"><?php echo panel_top(); ?>

 

<?php echo tep_draw_top();?>

 

<?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 tep_draw_side_top();

echo '

<table cellpadding="0" cellspacing="0" border="0" class="select2">

<tr><td align="right" class="main">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . '<b>'.TEXT_SHOW . '</b>  ';

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 tep_hide_session_id() . '</form></td></tr>

</table>' . "\n";

echo tep_draw_side_bottom();

}

}

 

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

}

?>

 

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

 

<?php echo tep_draw3_bottom();?>

 

<?php echo tep_draw_bottom();?>

 

</td>

<?php

} else { // default page

?>

<td class="<?php echo CONTENT_WIDTH_TD; ?>"><?php echo panel_top(); ?>

 

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

 

 

 

 

 

 

<?php include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS); ?>

 

<?php echo tep_draw_bottom();?>

 

</td>

<?php

}

?>

<!-- body_text_eof //-->

<td class="<?php echo BOX_WIDTH_TD_RIGHT; ?>"><table border="0" class="<?php echo BOX_WIDTH_RIGHT; ?>" cellspacing="0" cellpadding="0">

<!-- 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>

</html>

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

 

I can find no sign of the code that needs replaceing.

 

Saying that if i go to includes/languages/english/index.php there is something in there see below

<?php

/*

$Id: index.php 1739 2007-12-20 00:52:16Z hpdl $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2007 osCommerce

 

Released under the GNU General Public License

*/

define('TEXT_MAIN', '<table border="0" width="100%" cellspacing="5" cellpadding="2"><tr><td class="main2" valign="top">' . tep_image(DIR_WS_IMAGES . 'indeximage.gif') . '</td>');

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

}

?>

 

Im sorry to be a pain Jim but i am at a loss what to do and i really dont want to break anything.

 

Thanks again for your imput Jim

 

Mark

******************************************

** Aspire To Inspire Before You Retire Or Expire! **

******************************************

  • 1 year later...
Posted

You can insert a row like this after your category box.

 

<tr>

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

</tr>

<tr><td><a href="http://www.mysite.co.uk" target="_blank"><img border="2" alt="Verm-X Special Offer" src="/images/Promo_Banner.gif" width="660" height="300" align="center"/></a></td></tr>

 

OK going round the buoy again - how to best do this in OSC 2.3.1??

 

Many Thanks

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Posted

@@Mort-lemur can you post your code of index.php after the } else { default page

 

Hi George,

 

The code is:

 

 } else { // default page
?>
<h1><?php echo HEADING_TITLE; ?></h1>
<div class="contentContainer">
 <div class="contentText">
   <?php echo tep_customer_greeting(); ?>
 </div>
<?php
   if (tep_not_null(TEXT_MAIN)) {
?>
 <div class="contentText">
   <?php echo TEXT_MAIN; ?>
 </div>
<?php
   }
//    include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS);
   // <!--- BEGIN Header Tags SEO Social Bookmarks -->
   if (HEADER_TAGS_DISPLAY_SOCIAL_BOOKMARKS == 'true') {
  include(DIR_WS_MODULES . 'header_tags_social_bookmarks.php');
   }
   // <!--- END Header Tags SEO Social Bookmarks --> 
   include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);
?>
</div>
<?php
 // Start Modular Front Page
?>
<div class="contentContainer">
<?php echo $oscTemplate->getBlocks('front_page'); ?>
</div>
<?php
 // End Modular Front Page
 }
 require(DIR_WS_INCLUDES . 'template_bottom.php');
 require(DIR_WS_INCLUDES . 'application_bottom.php');
?>

 

When I insert the code for the image, the alt text appears, and I see an image box as the page loads, but then the greeting and categories box covers it up....

 

Also been looking at your mini-template,,,Im Tempted....

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Posted

Hi Heather

 

It looks like you have a lot of stuff in there

1) First "contentContainer" div include

- the default H1

- the "text main" from the language file

- some social bookmarks getting included

- Upcoming products getting included

 

2) Second "contentContainer" div include

- any active modules from "front page" addon

 

First thought is, to make some order here. Maybe "just" the front page addon is enough?

Second thought, that you could add this image using the front page addon? I think it include an option to display banners?

 

If you want to have an image additional to this, then do as follows

<div class="contentText">
 <?php echo '<a href="' . tep_href_link(FILENAME_THE_FILE, 'any parameters') . '">' . tep_image(DIR_WS_IMAGES . 'path_to_your_image/your_image.jpg', 'the image title', width(plain number), height(plain number)) . '</a>'; ?>
</div>

 

This you can add to any of the 2 existing "contentContainer" blocks

Archived

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

×
×
  • Create New...