Jump to content

ruidasilva@bellnet.ca

Members
  • Content count

    19
  • Joined

  • Last visited

Posts posted by ruidasilva@bellnet.ca


  1. Hello everyone:

    I want to offer Certapay to my costumers

    I have just installed this contribution on my website but it does not show up has a payment option even knowing I have activated it in the admin payment modules.

     

    I followed the instructions in the contribution and all it has is the two CERTAPAY PHP files for copying.

     

    Catalog/includes/languages/english/modules/payment

     

    Catalog/includes/modules/payment

     

    I think something is missing.

    Can anyone help??

    It would be appreciated.

    Thank you Rui


  2. I There:

     

    I have been using the complete file for Easypopulate successfully for about two weeks.

    Only now I had the need to use the Product Attributes and I ran into a problem:

    When I add a product option in the Product attributes I can still download the complete file but when I go one step further and add a product option value I can no longer download the complete file.

    I get the following error:

     

     

    1146 - Table 'loja_menasboutique_com.TABLE_PRODUCTS_STOCK' doesn't exist

     

    select products_stock_quantity from TABLE_PRODUCTS_STOCK where products_id = '28' and products_stock_attributes = '1-1'

     

    This only happens when I add a value to the product option. I have downloaded over 2000 products up to now but in oder to continue I have to delete the value.Once I do that It works again. Any ideas?????


  3. I There:

     

    I have been using the complete file for Easypopulate successfully for about two weeks.

    Only now I had the need to use the Product Attributes and I ran into a problem:

    When I add a product option in the Product attributes I can still download the complete file but when I go one step further and add a product option value I can no longer download the complete file.

    I get the following error:

     

     

    1146 - Table 'loja_menasboutique_com.TABLE_PRODUCTS_STOCK' doesn't exist

     

    select products_stock_quantity from TABLE_PRODUCTS_STOCK where products_id = '28' and products_stock_attributes = '1-1'

     

     

    I guess I must uncomment something in the file but I can not find where. Please some one help.


  4. It works fine if i upload a product in the traditional way.

    it only does not register when I use the EP.

    I hope we can find the answer. The product info looks rediculous without the date.

     

     

     

    I am not sure if this is a problem related to EP. I COULD BE WRONG.

     

    Try to update the date by going the traditional way in the Admin. I tried it - it didn't work for me. So...

     

    Googled the problem:

    http://forums.oscommerce.com/index.php?sho...mode=linearplus

    http://forums.oscommerce.com/lofiversion/i...php/t45044.html

     

    Sorry I could not help further.


  5. Help please:

     

    When I update the complete file I have the date included in the proper colum but it does not register on the product and the product shows no date updated.

    I use the same text file that is downloaded, I make the right changes and then I upload it but the date does not register. The rest of the product info does get updated but not the date.

    in the store it shows the phrase about the date but no date in front of it.

    Any idea why???

    Please reply and thank you.


  6. Repeat post:

     

     

    Can someone give me an idea on this please??????

     

    Help Please:

     

    I have 3 languages on my site: English, Brasilian and Spanish.

     

    I am using easypopulate just fine but I have a small problem that I can not find the answer.

    The text for the 3 languages are in the right place, but only the spanish and the english show up.

    When I am in the website am I am in English and Spanish the products are there but when I switch to Brasilian the products are no longer there.

    This only happens with the products that are uploaded using easypopulate.

    Products that are uploaded using admin they are just fine.

    This has to do with a configuration in easypopulate.

    I tried to find it but I can not. Please someone advice.

    Thank you.


  7. Help Please:

     

    I have 3 languages on my site: English, Brasilian and Spanish.

     

    I am using easypopulate just fine but I have a small problem that I can not find the answer.

    The text for the 3 languages are in the right place, but only the spanish and the english show up.

    When I am in the website am I am in English and Spanish the products are there but when I switch to Brasilian the products are no longer there.

    This only happens with the products that are uploaded using easypopulate.

    Products that are uploaded using admin they are just fine.

    This has to do with a configuration in easypopulate.

    I tried to find it but I can not. Please someone advice.

    Thank you.


  8. Hello:

     

    I am now able to download change and upload the complete file and that does me fine.

    My complete file includes all my categories but does not include specials and the "Top" category.

    Can anyone tell me the changes that I have to make to the easypopulate file in order for the complete file to include the TOP category and the Specials category?

    Your help with be very much appreciated

    Thanks Rui


  9. Hello:

     

    On easy populate when I upload changes I get an error due to the apostrophe on some words.

    I know that I have to escape out quotes \' like this or eliminate them all together.

     

    But I also know that there is a delimiter option on the easypopulate page. I tried adding in my case the following:

     

    ???

    But it still affects the upload and does not pass to the next product:

     

    Is there any other way of me avoiding this problem instead of having to manually make the changes on each product that may have quotes?????

     

    Can I make easypopulate recognize the quotes and not be affected???

     

    Please reply


  10. Hello:

     

     

     

    I still have not gotten help on this. Anyone out there please???????

     

     

     

     

     

    Can anyone help me with easy populate.

    After following all the instructions given in the new release posted today April 17, I find the following problem.

    At the Admin, Catalog, Easy populate we heve the working box with the links on the bottom.

    We have the following ?download the txt file to edit? links:

     

    Download .txt file with TAB delimited to edit ( Complete )

    Download .txt file with TAB delimited to edit ( Model / Price / Quantity )

    Download .txt file with TAB delimited to edit ( Model / Category )

    Download .txt file with TAB delimited to edit ( Products extra fields )

    Download .txt file with TAB delimited to edit ( Froogle )

     

     

    I can only download and save the Download .txt file with TAB delimited to edit ( Model / Category ).

     

    The others open something like this on my IE:

     

    This is what opens for Download .txt file with TAB delimited to edit ( Complete ) :

     

    1054 - Unknown column 'p.products_price1_qty' in 'field list'

     

    SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_price1_qty as v_products_price1_qty, p.products_price1 as v_products_price1, p.products_price2_qty as v_products_price2_qty, p.products_price2 as v_products_price2, p.products_price3_qty as v_products_price3_qty, p.products_price3 as v_products_price3, p.products_price4_qty as v_products_price4_qty, p.products_price4 as v_products_price4, p.products_price5_qty as v_products_price5_qty, p.products_price5 as v_products_price5, p.products_price6_qty as v_products_price6_qty, p.products_price6 as v_products_price6, p.products_price7_qty as v_products_price7_qty, p.products_price7 as v_products_price7, p.products_price8_qty as v_products_price8_qty, p.products_price8 as v_products_price8, p.products_qty_blocks as v_products_qty_blocks, p.products_weight as v_products_weight, p.products_date_available as v_date_avail, p.products_date_added as v_date_added, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id, p.products_status as v_status FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id

     

    [TEP STOP] [TEP STOP]

     

    This is what opens for Download .txt file with TAB delimited to edit ( Model / Price / Quantity )

     

    1054 - Unknown column 'p.products_price1' in 'field list'

     

    SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_status as v_status, p.products_price as v_products_price, p.products_tax_class_id as v_tax_class_id, p.products_price1 as v_products_price1, p.products_price2 as v_products_price2, p.products_price3 as v_products_price3, p.products_price4 as v_products_price4, p.products_price5 as v_products_price5, p.products_price6 as v_products_price6, p.products_price7 as v_products_price7, p.products_price8 as v_products_price8, p.products_price1_qty as v_products_price1_qty, p.products_price2_qty as v_products_price2_qty, p.products_price3_qty as v_products_price3_qty, p.products_price4_qty as v_products_price4_qty, p.products_price5_qty as v_products_price5_qty, p.products_price6_qty as v_products_price6_qty, p.products_price7_qty as v_products_price7_qty, p.products_price8_qty as v_products_price8_qty, p.products_qty_blocks as v_products_qty_blocks, p.products_quantity as v_products_quantity FROM products as p

     

    [TEP STOP]

     

     

    This is what opens for Download .txt file with TAB delimited to edit ( Products extra fields )

     

     

    1146 - Table 'loja_menasboutique_com.TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS' doesn't exist

     

    SELECT p.products_id as v_products_id, p.products_model as v_products_model, subc.products_extra_fields_id as v_products_extra_fields_id, subc.products_extra_fields_value as v_products_extra_fields_value, ptoc.products_extra_fields_name as v_products_extra_fields_name FROM products as p, TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS as subc, TABLE_PRODUCTS_EXTRA_FIELDS as ptoc WHERE p.products_id = subc.products_id AND ptoc.products_extra_fields_id = subc.products_extra_fields_id

     

    [TEP STOP]

     

    Froogle I am not using and did not open an account.

     

    Can anyone tell me what might be wrong. I have a lot of products to upload and it will take me forever manually.

    Thanks


  11. Hello:

     

    Can anyone help me with easy populate.

    After following all the instructions given in the new release posted today April 17, I find the following problem.

    At the Admin, Catalog, Easy populate we heve the working box with the links on the bottom.

    We have the following ?download the txt file to edit? links:

     

    Download .txt file with TAB delimited to edit ( Complete )

    Download .txt file with TAB delimited to edit ( Model / Price / Quantity )

    Download .txt file with TAB delimited to edit ( Model / Category )

    Download .txt file with TAB delimited to edit ( Products extra fields )

    Download .txt file with TAB delimited to edit ( Froogle )

     

     

    I can only download and save the Download .txt file with TAB delimited to edit ( Model / Category ).

     

    The others open something like this on my IE:

     

    This is what opens for Download .txt file with TAB delimited to edit ( Complete ) :

     

    1054 - Unknown column 'p.products_price1_qty' in 'field list'

     

    SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_price1_qty as v_products_price1_qty, p.products_price1 as v_products_price1, p.products_price2_qty as v_products_price2_qty, p.products_price2 as v_products_price2, p.products_price3_qty as v_products_price3_qty, p.products_price3 as v_products_price3, p.products_price4_qty as v_products_price4_qty, p.products_price4 as v_products_price4, p.products_price5_qty as v_products_price5_qty, p.products_price5 as v_products_price5, p.products_price6_qty as v_products_price6_qty, p.products_price6 as v_products_price6, p.products_price7_qty as v_products_price7_qty, p.products_price7 as v_products_price7, p.products_price8_qty as v_products_price8_qty, p.products_price8 as v_products_price8, p.products_qty_blocks as v_products_qty_blocks, p.products_weight as v_products_weight, p.products_date_available as v_date_avail, p.products_date_added as v_date_added, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id, p.products_status as v_status FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id

     

    [TEP STOP] [TEP STOP]

     

    This is what opens for Download .txt file with TAB delimited to edit ( Model / Price / Quantity )

     

    1054 - Unknown column 'p.products_price1' in 'field list'

     

    SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_status as v_status, p.products_price as v_products_price, p.products_tax_class_id as v_tax_class_id, p.products_price1 as v_products_price1, p.products_price2 as v_products_price2, p.products_price3 as v_products_price3, p.products_price4 as v_products_price4, p.products_price5 as v_products_price5, p.products_price6 as v_products_price6, p.products_price7 as v_products_price7, p.products_price8 as v_products_price8, p.products_price1_qty as v_products_price1_qty, p.products_price2_qty as v_products_price2_qty, p.products_price3_qty as v_products_price3_qty, p.products_price4_qty as v_products_price4_qty, p.products_price5_qty as v_products_price5_qty, p.products_price6_qty as v_products_price6_qty, p.products_price7_qty as v_products_price7_qty, p.products_price8_qty as v_products_price8_qty, p.products_qty_blocks as v_products_qty_blocks, p.products_quantity as v_products_quantity FROM products as p

     

    [TEP STOP]

     

     

    This is what opens for Download .txt file with TAB delimited to edit ( Products extra fields )

     

     

    1146 - Table 'loja_menasboutique_com.TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS' doesn't exist

     

    SELECT p.products_id as v_products_id, p.products_model as v_products_model, subc.products_extra_fields_id as v_products_extra_fields_id, subc.products_extra_fields_value as v_products_extra_fields_value, ptoc.products_extra_fields_name as v_products_extra_fields_name FROM products as p, TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS as subc, TABLE_PRODUCTS_EXTRA_FIELDS as ptoc WHERE p.products_id = subc.products_id AND ptoc.products_extra_fields_id = subc.products_extra_fields_id

     

    [TEP STOP]

     

    Froogle I am not using and did not open an account.

     

    Can anyone tell me what might be wrong. I have a lot of products to upload and it will take me forever manually.

    Thanks


  12. I need to add about 2000 products to my store in as quick as time it is possible.

    I have ckecked the easypopulate contribution but there are so many fixs and versions leading up to the last one that I don't know the one to use.

    Can any one tell me the version that is the most stable and/or publish a new complete package.

    Your help would be very much appreciated. I am under pressure.

    Thanks Rui and God Bless


  13. All the changes in the index file where correct but I did them again anyway. It still do not work. Any other ideas?

     

    I pasted my index with all the chenges in case you want to check it. Could there be any where else that the problem migth be?

    I also have instaled categories block contribution but I don't think that affects it because it does not touch in any of these scripts.

    please help, 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 © 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 marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

    <!-- header //-->

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

    <!-- header_eof //-->

     

    <!-- body //-->

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

    <tr>

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

    <!-- left_navigation //-->

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

    <!-- left_navigation_eof //-->

    </table></td>

    <!-- body_text //-->

    <?php

    if ($category_depth == 'nested') {

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

    $category = tep_db_fetch_array($category_query);

    ?>

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

    <tr>

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

    <tr>

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

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

    </tr>

    </table></td>

    </tr>

    <tr>

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

    </tr>

    <tr>

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

    <tr>

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

    <tr>

    <?php

    if (isset($cPath) && strpos('_', $cPath)) {

    // check to see if there are deeper categories within the current category

    $category_links = array_reverse($cPath_array);

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

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

    $categories = tep_db_fetch_array($categories_query);

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

    // do nothing, go through the loop

    } else {

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

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

    }

    }

    } else {

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

    }

     

    $number_of_categories = tep_db_num_rows($categories_query);

     

    $rows = 0;

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

    $rows++;

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

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

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

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

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

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

    }

    }

     

    // needed for the new products module shown below

    $new_products_category_id = $current_category_id;

    ?>

    </tr>

    </table></td>

    </tr>

    <tr>

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

    </tr>

    <tr>

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

    </tr>

    <tr>

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

    </tr>

     

    <tr>

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

    </tr>

    </table></td>

    </tr>

    </table></td>

    <?php

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

    // create column list

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

    'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,

    'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,

    'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,

    'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,

    'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,

    'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,

    'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);

     

    asort($define_list);

     

    $column_list = array();

    reset($define_list);

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

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

    }

     

    $select_column_list = '';

     

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

    switch ($column_list[$i]) {

    case 'PRODUCT_LIST_MODEL':

    $select_column_list .= 'p.products_model, ';

    break;

    case 'PRODUCT_LIST_NAME':

    $select_column_list .= 'pd.products_name, ';

    break;

    case 'PRODUCT_LIST_MANUFACTURER':

    $select_column_list .= 'm.manufacturers_name, ';

    break;

    case 'PRODUCT_LIST_QUANTITY':

    $select_column_list .= 'p.products_quantity, ';

    break;

    case 'PRODUCT_LIST_IMAGE':

    $select_column_list .= 'p.products_image, ';

    break;

    case 'PRODUCT_LIST_WEIGHT':

    $select_column_list .= 'p.products_weight, ';

    break;

    }

    }

     

    // show the products of a specified manufacturer

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

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

    // We are asked to show only a specific category

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

    } else {

    // We show them all

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

    }

    } else {

    // show the products in a given categorie

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

    // We are asked to show only specific catgeory

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

    } else {

    // We show them all

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

    }

    }

     

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

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

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

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

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

    break;

    }

    }

    } else {

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

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

    $listing_sql .= ' order by ';

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

    case 'PRODUCT_LIST_MODEL':

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

    break;

    case 'PRODUCT_LIST_NAME':

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

    break;

    case 'PRODUCT_LIST_MANUFACTURER':

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

    break;

    case 'PRODUCT_LIST_QUANTITY':

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

    break;

    case 'PRODUCT_LIST_IMAGE':

    $listing_sql .= "pd.products_name";

    break;

    case 'PRODUCT_LIST_WEIGHT':

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

    break;

    case 'PRODUCT_LIST_PRICE':

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

    break;

    }

    }

    ?>

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

    <tr>

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

    <tr>

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

    <?php

    // optional Product List Filter

    if (PRODUCT_LIST_FILTER > 0) {

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

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

    } else {

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

    }

    $filterlist_query = tep_db_query($filterlist_sql);

    if (tep_db_num_rows($filterlist_query) > 1) {

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

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

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

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

    } else {

    echo tep_draw_hidden_field('cPath', $cPath);

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

    }

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

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

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

    }

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

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

    }

    }

     

    // Get the right image for the top-right

    $image = DIR_WS_IMAGES . 'table_background_list.gif';

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

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

    $image = tep_db_fetch_array($image);

    $image = $image['manufacturers_image'];

    } elseif ($current_category_id) {

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

    $image = tep_db_fetch_array($image);

    $image = $image['categories_image'];

    }

    ?>

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

    </tr>

    </table></td>

    </tr>

    <tr>

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

    </tr>

    <tr>

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

    </tr>

    <?php

    /* Begin: Product Specials */

    if (SHOW_PRODUCT_SPECIALS_ON_PRODUCTS_LIST=='true') {

    ?>

    <tr>

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

    </tr>

    <tr>

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

    </tr>

    <?php

    }

    /* End: Product Specials */ ?>

    </table></td>

    <?php

    } else { // default page

    ?>

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

    <tr>

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

    <tr>

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

    <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_default.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

    </tr>

    </table></td>

    </tr>

    <tr>

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

    </tr>

    <tr>

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

    <tr>

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

    </tr>

    <tr>

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

    </tr>

    <tr>

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

    </tr>

    <tr>

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

    </tr>

    <?php if (CATEGORIES_BLOCK=="true") { ?>

    <tr>

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

    </tr>

    <tr>

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

    </tr>

     

    <tr>

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

    </tr>

    <tr>

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

    </tr><?php } ?>

     

    <tr>

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

    </tr>

    <?php

    include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);

    ?>

    </table></td>

    </tr>

    </table></td>

    <?php

    }

    ?>

    <!-- body_text_eof //-->

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

    <!-- right_navigation //-->

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

    <!-- right_navigation_eof //-->

    </table></td>

    </tr>

    </table>

    <!-- body_eof //-->

     

    <!-- footer //-->

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

    <!-- footer_eof //-->

    <br>

    </body>

    </html>

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


  14. Hello Todd:

     

    I have installed your New Products box contribution and I might have done something wrong?

    I have double checked everything and I can't find where I went wrong.

    The specials module is in my Admin, I can control some of the options but when I put true to put box in the main catalog page I cannot get it going. Any ideas whrer I may check for this problem?

    It works fine on the catagories page, I can control the amount, I can control the lines but Icanot get on the Main catalog page.

    Please advise if you have any ideas as to where I may look first.

    Thank you in advance, Rui

×