Jump to content
Sign in to follow this  
spooks

Product Listing Enhancements, Thumbnails & Manufacturer Headings

Recommended Posts

1054 - Unknown column 'mi.manufacturers_description' in 'field list'

 

 

The problem area is code that hasn't changed for some time, however recent changes means its now used when b4 it was'nt, anyway to fix means adding a condition to the query:

 

find (540):

$filterlist_sql= tep_db_query("select distinct m.manufacturers_id, m.manufacturers_name, mi.manufacturers_description from " . TABLE_MANUFACTURERS . " m left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "' and mi.languages_id = '" . (int)$languages_id . "'");
}else{
$filterlist_sql= tep_db_query("select distinct m.manufacturers_id, m.manufacturers_name, mi.manufacturers_description from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id 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 . "' and mi.languages_id = '" . (int)$languages_id . "' order by m.manufacturers_name");

 

replace with:

 

if (isset($_GET['manufacturers_id']) && tep_not_null($_GET['manufacturers_id'])) {
$filterlist_sql= tep_db_query("select distinct m.manufacturers_id, m.manufacturers_name" . (MANU_DESCRIPTION == 'true' ? ", mi.manufacturers_description" : "") . " from " . TABLE_MANUFACTURERS . " m left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "' and mi.languages_id = '" . (int)$languages_id . "'");
 }else{
$filterlist_sql= tep_db_query("select distinct m.manufacturers_id, m.manufacturers_name" . (MANU_DESCRIPTION == 'true' ? ", mi.manufacturers_description" : "") . " from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id 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 . "' and mi.languages_id = '" . (int)$languages_id . "' order by m.manufacturers_name");

 

 

You must ensure you have Product Listing Manufacturers Description set to false in admin unless you have added the Manufacturers Description parts of this add-on


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

Hi Spooks.

 

I have spent the day playing with the contribution on my local test site and have been very impressed.

There are however a couple of things that are preventing me from going live an i was hoping you coul dhelp me please.

 

1. If a product is on special with a discount prive it shows in the relevant category view but not on the new products module on the homepage.

2. I have the contribution salemaker installed and can not for the life of me work out how to get the price reductions incldued in the product listing or new product modules

3. I would like to be able to remove the option to select a page from beneath the new products module on the home page so that if it is set to only show 4 prodcuts then that is all it shows without the option to click through pages and find more. Some one asked about this a page or so back and you suggested some code to replace but i couldn't find it to replace so thought i could ask again in case i had misunderstood.

 

I have included below the examples of my existing product listing and new products modules that i am trying to amend which show how i currenlyt display the prices generate by the salemaker contribution which i am trying to replicate now within my new product listing and new product files.

 

Old New PRoducts Module:

 

<?php

/*

$Id: new_products.php 1806 2008-01-11 22:48:15Z hpdl $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2008 osCommerce

 

Released under the GNU General Public License

*/

?>

<!-- new_products //-->

 

 

<?php

 

if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {

$new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by RAND() limit " . MAX_DISPLAY_NEW_PRODUCTS);

} else {

$new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

}

 

$row = 0;

$col = 0;

$info_box_contents = array();

while ($new_products = tep_db_fetch_array($new_products_query)) {

 

$special_price = tep_get_products_special_price($new_products['products_id']);

if ($special_price) {

$products_price = '<s>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])) . '</s>  <span class="productSpecialPrice">' . $currencies->display_price($special_price, tep_get_tax_rate($new_products['products_tax_class_id'])) . '</span>';

} else {

$products_price = '<span class="productPrice">' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])). '</span>';

}

$info_box_contents[$row][$col] = array('align' => 'center',

'params' => 'class="smallText" width="' . round(100/(MAX_DISPLAY_NEW_PRODUCTS_PER_ROW), 0). '%" valign="top"',

 

'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br>' . $products_price);

 

 

 

$col ++;

if ($col > (MAX_DISPLAY_NEW_PRODUCTS_PER_ROW - 1)) {

$col = 0;

$row ++;

}

}

 

new contentBox($info_box_contents);

?>

<!-- new_products_eof //-->

 

 

 

 

 

Old Product Listing:

 

 

<?php

/*

$Id: product_listing.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

*/

 

$listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'p.products_id');

 

if ( ($listing_split->number_of_rows > 0) && ( (PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3') ) ) {

?>

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

<tr>

<td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>

<td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>

</tr>

</table>

<?php

}

 

$list_box_contents = array();

 

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

switch ($column_list[$col]) {

case 'PRODUCT_LIST_MODEL':

$lc_text = TABLE_HEADING_MODEL;

$lc_align = '';

break;

case 'PRODUCT_LIST_NAME':

$lc_text = TABLE_HEADING_PRODUCTS;

$lc_align = '';

break;

case 'PRODUCT_LIST_MANUFACTURER':

$lc_text = TABLE_HEADING_MANUFACTURER;

$lc_align = '';

break;

case 'PRODUCT_LIST_PRICE':

$lc_text = TABLE_HEADING_PRICE;

$lc_align = 'center';

break;

case 'PRODUCT_LIST_QUANTITY':

$lc_text = TABLE_HEADING_QUANTITY;

$lc_align = 'right';

break;

 

case 'PRODUCT_LIST_INFO':

$lc_text = 'More Info';

$lc_align = 'center';

break;

 

case 'PRODUCT_LIST_WEIGHT':

$lc_text = TABLE_HEADING_WEIGHT;

$lc_align = 'right';

break;

case 'PRODUCT_LIST_IMAGE':

$lc_text = TABLE_HEADING_IMAGE;

$lc_align = 'center';

break;

case 'PRODUCT_LIST_BUY_NOW':

$lc_text = TABLE_HEADING_BUY_NOW;

$lc_align = 'center';

break;

}

 

if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list[$col] != 'PRODUCT_LIST_IMAGE') && ($column_list[$col] != 'PRODUCT_LIST_INFO')) {

$lc_text = tep_create_sort_heading($HTTP_GET_VARS['sort'], $col+1, $lc_text);

}

 

$list_box_contents[0][] = array('align' => $lc_align,

'params' => 'class="productListing-heading"',

'text' => ' ' . $lc_text . ' ');

}

 

if ($listing_split->number_of_rows > 0) {

$rows = 0;

$listing_query = tep_db_query($listing_split->sql_query);

while ($listing = tep_db_fetch_array($listing_query)) {

$rows++;

 

if (($rows/2) == floor($rows/2)) {

$list_box_contents[] = array('params' => 'class="productListing-even"');

} else {

$list_box_contents[] = array('params' => 'class="productListing-odd"');

}

 

$cur_row = sizeof($list_box_contents) - 1;

 

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

$lc_align = '';

 

switch ($column_list[$col]) {

case 'PRODUCT_LIST_MODEL':

$lc_align = '';

$lc_text = ' ' . $listing['products_model'] . ' ';

break;

case 'PRODUCT_LIST_NAME':

$lc_align = '';

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

$lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a>';

} else {

$lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a> ';

}

break;

case 'PRODUCT_LIST_MANUFACTURER':

$lc_align = '';

$lc_text = ' <a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $listing['manufacturers_id']) . '">' . $listing['manufacturers_name'] . '</a> ';

break;

case 'PRODUCT_LIST_PRICE':

$lc_align = 'center';

 

if (tep_get_products_special_price($listing['products_id'])) {

$lc_text = ' <s>' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</s>  <span class="productSpecialPrice">' . $currencies->display_price(tep_get_products_special_price($listing['products_id']), tep_get_tax_rate($listing['products_tax_class_id'])) . '</span> ';

 

} else {

$lc_text = ' ' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . ' ';

}

break;

case 'PRODUCT_LIST_QUANTITY':

$lc_align = 'right';

$lc_text = ' ' . $listing['products_quantity'] . ' ';

break;

 

case 'PRODUCT_LIST_INFO':

$lc_align = 'center';

 

$lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . tep_image_button('button_more_info.gif', 'More Info') . '</a> ';

 

break;

 

 

 

case 'PRODUCT_LIST_WEIGHT':

$lc_align = 'right';

$lc_text = ' ' . $listing['products_weight'] . ' ';

break;

case 'PRODUCT_LIST_IMAGE':

$lc_align = 'center';

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

$lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>';

} else {

 

$lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a> ';

}

break;

case 'PRODUCT_LIST_BUY_NOW':

$lc_align = 'center';

/** original **/ //$lc_text = '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</a> ';

 

/** show-soldout-v1.0 **/

if($listing['products_quantity'] <= 0 || $listing['products_status']==0)

$lc_text = tep_image_button('button_sold_out_sm.gif', IMAGE_BUTTON_SOLD_OUT) . ' ';

else

$lc_text = ' <a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</a> ';

/** end show-soldout-v1.0 **/

break;

}

 

 

 

 

 

 

 

$list_box_contents[$cur_row][] = array('align' => $lc_align,

'params' => 'class="productListing-data"',

'text' => $lc_text);

}

 

if ($listing_split->number_of_rows > $rows) {

$list_box_contents[][] = array(

'params' => 'valign="middle" colspan="' . sizeof($column_list) . '"',

'text' => tep_draw_separator('pixel_silver.gif', '100%', '1') );

}

 

}

 

new productListingBox($list_box_contents);

} else {

$list_box_contents = array();

 

$list_box_contents[0] = array('params' => 'class="productListing-odd"');

$list_box_contents[0][] = array('params' => 'class="productListing-data"',

'text' => TEXT_NO_PRODUCTS);

 

new productListingBox($list_box_contents);

}

 

if ( ($listing_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3')) ) {

?>

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

<tr>

<td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>

<td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>

</tr>

</table>

<?php

}

?>

 

 

 

 

Any help gratefully recieved.

 

Matt S

Share this post


Link to post
Share on other sites

1054 - Unknown column 'mi.manufacturers_description' in 'field list'

 

 

The problem area is code that hasn't changed for some time, however recent changes means its now used when b4 it was'nt, anyway to fix means adding a condition to the query:

 

find (540):

$filterlist_sql= tep_db_query("select distinct m.manufacturers_id, m.manufacturers_name, mi.manufacturers_description from " . TABLE_MANUFACTURERS . " m left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "' and mi.languages_id = '" . (int)$languages_id . "'");
}else{
$filterlist_sql= tep_db_query("select distinct m.manufacturers_id, m.manufacturers_name, mi.manufacturers_description from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id 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 . "' and mi.languages_id = '" . (int)$languages_id . "' order by m.manufacturers_name");

 

replace with:

 

if (isset($_GET['manufacturers_id']) && tep_not_null($_GET['manufacturers_id'])) {
$filterlist_sql= tep_db_query("select distinct m.manufacturers_id, m.manufacturers_name" . (MANU_DESCRIPTION == 'true' ? ", mi.manufacturers_description" : "") . " from " . TABLE_MANUFACTURERS . " m left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "' and mi.languages_id = '" . (int)$languages_id . "'");
 }else{
$filterlist_sql= tep_db_query("select distinct m.manufacturers_id, m.manufacturers_name" . (MANU_DESCRIPTION == 'true' ? ", mi.manufacturers_description" : "") . " from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id 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 . "' and mi.languages_id = '" . (int)$languages_id . "' order by m.manufacturers_name");

 

 

You must ensure you have Product Listing Manufacturers Description set to false in admin unless you have added the Manufacturers Description parts of this add-on

 

Spooks,

 

Which specific file should I be looking for this change in? If you are meaning modules/product_listing.php which I did find the code in it actually did not change the error.

Edited by fan4chevy

Share this post


Link to post
Share on other sites

Which specific file should I be looking for this change in? If you are meaning modules/product_listing.php which I did find the code in it actually did not change the error.

 

Yes, it is the listing file.

 

 

 

You clearly did'nt manage to read my last line, its here

 

You must ensure you have [b]Product Listing Manufacturers Description[/b] set to [b]false[/b] in admin unless you have added the [b]Manufacturers Description[/b] parts of this add-on 

 

Have you done that now!! ohmy.gif


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

Yes, it is the listing file.

 

 

 

You clearly did'nt manage to read my last line, its here

 

You must ensure you have [b]Product Listing Manufacturers Description[/b] set to [b]false[/b] in admin unless you have added the [b]Manufacturers Description[/b] parts of this add-on 

 

Have you done that now!! ohmy.gif

 

In admin, my Product Listing Manufacturers Description is set to false. It was actually set to false as one of the first things.

 

In the contrib supplied incl/mods/product_listing.php I did the find and replace exactly as explained but I then get this error:

Parse error: syntax error, unexpected $end in /home/public_html/domain.com/catalog/includes/modules/product_listing.php on line 583 which 583 points to ?>

 

Before the new contrib updates, I had this on a previous cart and did not see these errors. It is only since I created a fresh OC with the new contrib updates nstall. Have you or anyone else had this issue?

 

Thank you for your patience and help. Love this mod.

Charles

Edited by fan4chevy

Share this post


Link to post
Share on other sites

In admin, my Product Listing Manufacturers Description is set to false. It was actually set to false as one of the first things.

 

In the contrib supplied incl/mods/product_listing.php I did the find and replace exactly as explained but I then get this error:

Parse error: syntax error, unexpected $end in /home/public_html/domain.com/catalog/includes/modules/product_listing.php on line 583 which 583 points to ?>

 

Before the new contrib updates, I had this on a previous cart and did not see these errors. It is only since I created a fresh OC with the new contrib updates nstall. Have you or anyone else had this issue?

 

Thank you for your patience and help. Love this mod.

Charles

 

 

Check your edits & setting again more carefully, if you have done as I said its impossible for you to get the same error


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

 

 

 

1. Don't know what you mean huh.gif

 

2. I gave code for salemaker only a few posts ago wink.gif

 

3. If you want only 4 new products, set it so in admin. wink.gif


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

1. Don't know what you mean huh.gif

 

 

 

I`ve looked again with more time, I see what u mean now, please read para 5 of the doc, this point has also been discussed at lenght in this thread, as the mode is (as it should be) illegal, it will never be supported by this.


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

Uploaded new version 2.8

 

Added Support for SaleMaker (http://addons.oscommerce.com/info/1340) See usage for how to enable.

Added option to show a checkbox field in place of other quantity boxes.

Fixed query bug in specials.php module.

Modified Manufacturers Description query to avoid possible issues.

Added Grid mode heading (not sure how many will want it though?)

Added admin setting for max product age.

Added Add-On Pages package provided by Ronnie (ronrrico) Thanks for the effort.

Package adds Best Sellers, Featured products, Coming Soon and Bundled products pages.

 

Changed files: product_listing.php, products_new.php, new_products.php, specials.php.

css entries: classes .productListing-title

New files: SQL query for max product age setting addition.

 

There is currently on-going development of this contribution, so some controls that currently require changes within the code will ultimately be ported to admin controls.

 

UPGRADING

Upload any changed & new files & apply SQL upgrade file if needed, edit your style sheet.

If you wish the admin date setting, there is a seperate file for that. If the admin setting does not exist, or is not set the max age will revert to that set in the file.

 

oops!! blush.gif

 

 

After uploading I realised there are a couple setting in the listing file that remained from testing:

 

$no_drop = true; Should normally be set to false

$checkbox = true; Should normally be set to false


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

Some addon pages to this wonderfull cotribution created by Sam.

 

Best Sellers page

Fearured products page

Coming Soom page

Bundled products page

 

 

 

Thanks for your efforts, your file is quite small, so I have added it as is to the latest version (2.8). thumbsup.gif

 

Good work, got anything else planned? smile.gif


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

Sam,

 

Beautifully done on the new 2.8. I just installed it.

 

 

I noticed on the previous versions as well as this version that in I.E the nice greyed background mouse over is not showing up. I see it in FireFox perfectly. Any idea as to how I can make this effect in the other browsers?

 

Can you show me what I would need to do as far as code to do sort order, etc for products new?

 

Thanks,

 

Charles

Edited by fan4chevy

Share this post


Link to post
Share on other sites

mouseover effects in ie

 

 

 

See the notes in the doc regarding mouseover effects in ie & what to add. ohmy.gif

 

Default sort order I delt with in this thread http://forums.oscommerce.com/index.php?showtopic=308798&hl= wink.gif


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

Hi,

 

Sorry,....but I don't underdestand you.

I don't have the html that works with this...and I can't create it.

 

What dou you think about my idea?

 

Best regards,

Javier

 

 

Add icons

 

 

The php for this is simple, but the html not so, remember this has many modes so there is much to consider fo any addition

 

You have shown the icons overlaying the pics and aligned to the box edges, if you care to come up with the html for that that works, I sort the php. wink.gif

Share this post


Link to post
Share on other sites

Sorry,....but I don't underdestand you.

I don't have the html that works with this...and I can't create it.

 

What dou you think about my idea?

 

 

 

I was saying nice idea, but the html required is awkward to do, if your prepared to create that I'll do the rest.

 

But it seems you are unable, so never mind, another one bites the dust!! biggrin.gif


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

Hi Sam,

 

I spent all night getting v2.7 up and running only to discover that you've already outdone yourself! Well done! You mentioned in the new release notes that you fixed a query bug in specials.php module. Is this the code change in line 130? And would I able to just add the new addons to my existing v2.7 installation if I don't need the other improvements at this time? Thanks for all your work with this great contribution!

 

Nick

Share this post


Link to post
Share on other sites

Hi Sam,

 

I spent all night getting v2.7 up and running only to discover that you've already outdone yourself! Well done! You mentioned in the new release notes that you fixed a query bug in specials.php module. Is this the code change in line 130? And would I able to just add the new addons to my existing v2.7 installation if I don't need the other improvements at this time? Thanks for all your work with this great contribution!

 

Nick

 

 

Yes, its the fix on that line.

 

Yes you could upgrade without using the new additions, note the in file settings I managed to leave set, detailed in the release post.


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

I was saying nice idea, but the html required is awkward to do, if your prepared to create that I'll do the rest.

 

But it seems you are unable, so never mind, another one bites the dust!! biggrin.gif

 

I am sorry....but I am not able to do that...

As you know, sometimes you have good ideas...but not have the tools :'(

 

Thanks for your help¡ :D

Javier

Share this post


Link to post
Share on other sites

Can some one point me in the right direction as to where I would need to go on the product_listing.php to change the title that is being showed in the heading of the box. It's showing the category and I want to know if it's possible to show the subcategory instead.

 

Thanks in advance.

Share this post


Link to post
Share on other sites

Thanks for your efforts, your file is quite small, so I have added it as is to the latest version (2.8). thumbsup.gif

 

Good work, got anything else planned? smile.gif

 

Thanks Sam,

I got the modules done for:

Best Sellers

Featured products

Coming Soon

Bundled products

&

Specials

 

I'm sure someone can put them to use :lol:

I'll include them tomorrow in the zip link I posted earlier.

 

Now I'm trying to integrate these modules with Ajax Tabs keeping all the features within an iframe, drops,Paging,RSS and Switch function. See

 

I'm not sure that this will be accomplished do to iframe/Ajax issues

 

,,,Im not a genius at this stuff,,, So all we can do is try....

 

Keep ya posted....

 

Ronnie

Share this post


Link to post
Share on other sites

Thanks for your efforts, your file is quite small, so I have added it as is to the latest version (2.8). thumbsup.gif

 

Good work, got anything else planned? smile.gif

 

Hi Sam, I got 2 issues left to complete my integration of the modules with ajaxtabs.

I was hoping you could give a hand here if you can.

 

1. Modules are running under the iframe option of ajaxtabs,: so I have added target=_top on the image,title and cart buttons to brake out of the iframe as needed, and left drops,switch,ect to work within the iframe which is just fine. For some reason target=_top is behaving like target=blank! I'm getting a new window popup with every click. >_< .

I was hoping you could give some advice on how to properly execute target=_top for this situation.

 

2.Regarding Lightbox: I can't seem to get the Lightbox working in ajaxtabs, I think it is not loading the script on click to function in ajaxtabs. Any suggestions?

 

Anyway, everything else is just a matter of tweaking a little bit here and there and I should be done.

 

Oh, there go's that last little thing... How in GODs Earth can I set Iframe to auto size Height according to content?

I have tried about a dozen different scripts that I googled up, and nothing.. <_<

 

Life is a beauty, ain't it :D Example

 

Any suggestion are welcome :thumbsup:

Ronnie

Share this post


Link to post
Share on other sites

Can some one point me in the right direction as to where I would need to go on the product_listing.php to change the title that is being showed in the heading of the box. It's showing the category and I want to know if it's possible to show the subcategory instead.

 

Thanks in advance.

 

 

This shows the current category name for the listed products, titles outside the module are done by the calling page


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

This shows the current category name for the listed products, titles outside the module are done by the calling page

 

Sam thanks for your reply. Yes I know that this mod shows the current category name. I was wondering if it could be changed to show the subcategory name instead for the listed products.

What I mean I have a category BAKERY with subcategories MUFFINS, CROISSANTS, DANISHES, etc. Instead of having BAKERY on all the titles, I want if possible to have the MUFFINS, CROISSANTS, DANISHES, etc. when clicked on. Hope I made my self clear.

 

Thanks in advance.

Share this post


Link to post
Share on other sites

hello i just found out that disabling the enlarge image mouse will take off the double image? but the layout still messy.. i guess shop_by_price.php is not compatible with the layout of product listing enhancement? Can i have some help what to do to fix this??

 

My link

Share this post


Link to post
Share on other sites

hello i just found out that disabling the enlarge image mouse will take off the double image? but the layout still messy.. i guess shop_by_price.php is not compatible with the layout of product listing enhancement? Can i have some help what to do to fix this??

 

My link

 

 

If you add/create any new pages that call the listing you must add the changes detailed for Tool tip images & rounded corners in IE for those pages too if you set Product Listing Image zoom on hover to true

 

Otherwise you also need to adjust your style sheet to make the listing suit your site, firefox and its web developer & firebug plugins will help you do that.


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×