Jump to content

FHCeramics

Members
  • Content count

    122
  • Joined

  • Last visited

Everything posted by FHCeramics

  1. Don't know if this will help solve where to look for the glitch but it only appears on category and subcategory pages where the categories have sub-categories... hope this helps
  2. Thanks again JanZ, got the last two problems that you caught fixed and changed the new products.php back to what it originally was but with no success, so it must be something else, here is what it shows on the source code for the affected pages at the end <td>New Products For August</td> </tr> </table> </td> </tr> </table> <!-- new_products_eof //--> </td> </tr> </table></td> </tr> </table></td> <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">Categories</td> <td align="right"><img src="images/" width="57" height="40" border="0" alt="Categories" title="Categories"></td> </tr> </table></td> </tr> <tr> <td><img src="images/pixel_trans.gif" width="100%" height="10" border="0" alt=""></td> </tr> <tr> <td><font color="#000000"><b>1109 - Unknown table 'p' in field list<br><br>select count(p.products_id) as total <br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font> , and here is the code from the unaffected pages </tr> </table> </td> </tr> </table> <!-- new_products_eof //--> </td> </tr> </table></td> </tr> </table></td> <!-- body_text_eof //--> <td width="125" valign="top"><table border="0" width="125" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <!-- shopping_cart //--> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td height="14" class="infoBoxHeading"><img src="images/infobox/corner_right_left.gif" width="11" height="14" border="0" alt=""></td> <td width="100%" height="14" class="infoBoxHeading">Shopping Cart</td> <td height="14" class="infoBoxHeading" nowrap><a href="http://shops.fhceramics.com/shopping_cart.php"><img src="images/infobox/arrow_right.gif" width="12" height="10" border="0" alt="more" title="more"></a><img src="images/infobox/corner_right.gif" width="11" height="14" border="0" alt=""></td> </tr> </table> <table border="0" width="100%" cellspacing="0" cellpadding="1" class="infoBox"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="3" class="infoBoxContents"> <tr> <td><img src="images/pixel_trans.gif" width="100%" height="1" border="0" alt=""></td> </tr> <tr> <td class="boxText">0 items</td> </tr> <tr> <td><img src="images/pixel_trans.gif" width="100%" height="1" border="0" alt=""></td> </tr> </table> </td> </tr> </table> </td> </tr> <!-- shopping_cart_eof //--> <!-- information //--> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td height="14" class="infoBoxHeading"><img src="images/infobox/corner_right_left.gif" width="11" height="14" border="0" alt=""></td> <td width="100%" height="14" class="infoBoxHeading">We Accept</td> <td height="14" class="infoBoxHeading" nowrap><img src="images/pixel_trans.gif" width="11" height="14" border="0" alt=""></td> </tr> </table> <table border="0" width="100%" cellspacing="0" cellpadding="1" class="infoBox"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="3" class="infoBoxContents"> <tr> <td><img src="images/pixel_trans.gif" width="100%" height="1" border="0" alt=""></td> </tr> <tr> <td align="center" class="boxText"><img src="images/credit-cards-square.gif" width="94" height="64" border="0" alt=""></td> </tr> <tr> <td><img src="images/pixel_trans.gif" width="100%" height="1" border="0" alt=""></td> </tr> </table> </td> </tr> </table> </td> </tr> <!-- information_eof //--> <!-- newsdesk //--> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td height="14" class="infoBoxHeading"><img src="images/infobox/corner_right_left.gif" width="11" height="14" border="0" alt=""></td> <td width="100%" height="14" class="infoBoxHeading">Latest News</td> <td height="14" class="infoBoxHeading" nowrap><img src="images/pixel_trans.gif" width="11" height="14" border="0" alt=""></td> </tr> </table> <table border="0" width="100%" cellspacing="0" cellpadding="1" class="infoBox"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="4" class="infoBoxContents"> <tr class="smallText" valign="top"> <td align="left" class="smallText" valign="top"><a class="smallText" href="http://shops.fhceramics.com/newsdesk_info.php?newsdesk_id=8">Family Heirloom Ceramics Expands</a><br><a class="smallText" href="http://shops.fhceramics.com/newsdesk_info.php?newsdesk_id=7">1 - Redesigning of website</a><br><a class="smallText" href="http://shops.fhceramics.com/newsdesk_info.php?newsdesk_id=6">Doc Holiday Artist Has Agreed to teach Seminar</a><br><a class="smallText" href="http://shops.fhceramics.com/newsdesk_info.php?newsdesk_id=5">Exciting Changes occur at Family Heirloom Ceramics</a><br></td> </tr> </table> </td> </tr> </table> <!-- newsdesk_eof //--> </td> </tr> <!-- events_calendar //--> <tr> <td> <iframe name="calendar" id="calendar" class="calendarBox" align="center" valign="top" marginwidth="0" marginheight="0" frameborder="0" scrolling="no" src="calendar_content.php?_month=&_year=" >Sorry, you browser does not support iframes.</iframe> </td> </tr> <!-- events_calendar //--> <!-- customer testimonials //--> <!-- customer testimonials_eof //--> <!-- reviews //--> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td height="14" class="infoBoxHeading"><img src="images/infobox/corner_right_left.gif" width="11" height="14" border="0" alt=""></td> <td width="100%" height="14" class="infoBoxHeading">Reviews</td> <td height="14" class="infoBoxHeading" nowrap><a href="http://shops.fhceramics.com/reviews.php"><img src="images/infobox/arrow_right.gif" width="12" height="10" border="0" alt="more" title="more"></a><img src="images/pixel_trans.gif" width="11" height="14" border="0" alt=""></td> </tr> </table> <table border="0" width="100%" cellspacing="0" cellpadding="1" class="infoBox"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="3" class="infoBoxContents"> <tr> <td><img src="images/pixel_trans.gif" width="100%" height="1" border="0" alt=""></td> </tr> <tr> <td class="boxText">There are currently no product reviews</td> </tr> <tr> <td><img src="images/pixel_trans.gif" width="100%" height="1" border="0" alt=""></td> </tr> </table> </td> </tr> </table> </td> </tr> <!-- reviews_eof //--> <!-- languages //--> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td height="14" class="infoBoxHeading"><img src="images/infobox/corner_right_left.gif" width="11" height="14" border="0" alt=""></td> <td width="100%" height="14" class="infoBoxHeading">Languages</td> <td height="14" class="infoBoxHeading" nowrap><img src="images/pixel_trans.gif" width="11" height="14" border="0" alt=""></td> </tr> </table> <table border="0" width="100%" cellspacing="0" cellpadding="1" class="infoBox"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="3" class="infoBoxContents"> <tr> <td><img src="images/pixel_trans.gif" width="100%" height="1" border="0" alt=""></td> </tr> <tr> <td align="center" class="boxText"> <a href="http://shops.fhceramics.com/index.php?language=en"><img src="includes/languages/english/images/icon.gif" width="24" height="15" border="0" alt="English" title="English"></a> </td> </tr> <tr> <td><img src="images/pixel_trans.gif" width="100%" height="1" border="0" alt=""></td> </tr> </table> </td> </tr> </table> </td> </tr> <!-- languages_eof //--> <!-- currencies //--> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td height="14" class="infoBoxHeading"><img src="images/infobox/corner_right_left.gif" width="11" height="14" border="0" alt=""></td> <td width="100%" height="14" class="infoBoxHeading">Currencies</td> <td height="14" class="infoBoxHeading" nowrap><img src="images/pixel_trans.gif" width="11" height="14" border="0" alt=""></td> </tr> </table> <table border="0" width="100%" cellspacing="0" cellpadding="1" class="infoBox"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="3" class="infoBoxContents"> <tr> <td><img src="images/pixel_trans.gif" width="100%" height="1" border="0" alt=""></td> </tr> <tr> <td align="center" class="boxText"><form name="currencies" action="http://shops.fhceramics.com/index.php" method="get"><select name="currency" onChange="this.form.submit();" style="width: 100%"><option value="USD" SELECTED>US Dollar</option><option value="CAD">Canadian Dollar</option></select></form></td> </tr> <tr> <td><img src="images/pixel_trans.gif" width="100%" height="1" border="0" alt=""></td> </tr> </table> </td> </tr> </table> </td> </tr> <!-- currencies_eof //--> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <table border="0" width="100%" cellspacing="0" cellpadding="1"> <tr class="footer"> <td class="footer">??Monday 14 August, 2006??</td> <td align="right" class="footer">??6402 requests since Wednesday 19 April, 2006??</td> </tr> </table> <br> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td align="center" class="smallText"> Copyright ? 2003 <a href="http://www.oscommerce.com" target="_blank">osCommerce</a><br>Powered by <a href="http://www.oscommerce.com" target="_blank">osCommerce</a> </td> </tr> </table> <br> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td align="center"><a href="http://shops.fhceramics.com/redirect.php?action=banner&goto=1" target="_blank"><img src="images/banners/oscommerce.gif" width="760" height="155" border="0" alt="osCommerce" title="osCommerce"></a></td> </tr> </table> <!-- footer_eof //--> <br> </body> </html> , hopefully this will give one of you an idea of where I should start looking to correct the problem. Again thanks for any help as when it comes to php I am a newbie.
  3. Thanks JanZ, that got my site back up, but now there is another glitch and I'm not sure which section to check of this contributions changes. The glitch only appears on the category and sub-category pages, the index page and product pages seem fine. Here is what the glitch is , would I look in the column_right.php or categories.php for the solution. I greatly appreciate the help.
  4. FHCeramics

    PDF Catalog v.1.5

  5. FHCeramics

    PDF Catalog v.1.5

    Here is the first half of the full categories.php, hope this helps, second half in next posting. <?php/* $Id: categories.php,v 1.146 2003/07/11 14:40:27 hpdl Exp $ adapted for Separate Pricing Per Customer v4.1.1 2005/03/20 osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : ''); if (tep_not_null($action)) { switch ($action) { case 'setflag': if ( ($HTTP_GET_VARS['flag'] == '0') || ($HTTP_GET_VARS['flag'] == '1') ) { if (isset($HTTP_GET_VARS['pID'])) { tep_set_product_status($HTTP_GET_VARS['pID'], $HTTP_GET_VARS['flag']); } if (USE_CACHE == 'true') { tep_reset_cache_block('categories'); tep_reset_cache_block('also_purchased'); } } tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $HTTP_GET_VARS['cPath'] . '&pID=' . $HTTP_GET_VARS['pID'])); break; case 'insert_category': case 'update_category': if (isset($HTTP_POST_VARS['categories_id'])) $categories_id = tep_db_prepare_input($HTTP_POST_VARS['categories_id']); $sort_order = tep_db_prepare_input($HTTP_POST_VARS['sort_order']); $sql_data_array = array('sort_order' => $sort_order); // Level begin $categories_level = tep_db_prepare_input($HTTP_POST_VARS['categories_level']); $sql_data_array2 = array('categories_level' => $categories_level); $sql_data_array = array_merge($sql_data_array, $sql_data_array2); // Level end b. <!-- Level begin --> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_CATEGORIES_LEVEL; ?></td> <!-- Level end --> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td> </tr> <?php $categories_count = 0; $rows = 0; if (isset($HTTP_GET_VARS['search'])) { $search = tep_db_prepare_input($HTTP_GET_VARS['search']); // Level begin $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.categories_level, c.date_added, c.last_modified from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and cd.categories_name like '%" . tep_db_input($search) . "%' order by c.sort_order, cd.categories_name"); } else { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.categories_level, c.date_added, c.last_modified 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 c.sort_order, cd.categories_name"); } // Level end c. <td class="dataTableContent" align="center"> </td> <!-- Level begin --> <td class="dataTableContent" align="center"><?php echo $categories['categories_level']; ?></td> <!-- Level end --> <td class="dataTableContent" align="right"><?php if (isset($cInfo) && is_object($cInfo) && ($categories['categories_id'] == $cInfo->categories_id) ) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories['categories_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td> d. <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products['products_id'] . '&action=new_product_preview&read=only') . '">' . tep_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $products['products_name']; ?></td> <!-- Level begin --> <td class="dataTableContent" align="center"> </td> <!-- Level end --> e. <!-- Level begin --> <td class="dataTableContent" align="center"> </td> <!-- Level end --> <td class="dataTableContent" align="right"><?php if (isset($pInfo) && is_object($pInfo) && ($products['products_id'] == $pInfo->products_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td> f. $contents[] = array('text' => '<br>' . TEXT_SORT_ORDER . '<br>' . tep_draw_input_field('sort_order', '', 'size="2"')); // Level begin $contents[] = array('text' => '<br>' . TEXT_CATEGORIES_LEVEL . '<br>' . tep_draw_input_field('categories_level', '', 'size="2"')); // Level end $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_save.gif', IMAGE_SAVE) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); g. $contents[] = array('text' => '<br>' . TEXT_EDIT_SORT_ORDER . '<br>' . tep_draw_input_field('sort_order', $cInfo->sort_order, 'size="2"')); // Level begin $contents[] = array('text' => '<br>' . TEXT_EDIT_CATEGORIES_LEVEL . '<br>' . tep_draw_input_field('categories_level', $cInfo->categories_level, 'size="2"')); // Level end $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_save.gif', IMAGE_SAVE) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); if ($action == 'insert_category') { $insert_sql_data = array('parent_id' => $current_category_id, 'date_added' => 'now()'); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); tep_db_perform(TABLE_CATEGORIES, $sql_data_array); $categories_id = tep_db_insert_id(); } elseif ($action == 'update_category') { $update_sql_data = array('last_modified' => 'now()'); $sql_data_array = array_merge($sql_data_array, $update_sql_data); tep_db_perform(TABLE_CATEGORIES, $sql_data_array, 'update', "categories_id = '" . (int)$categories_id . "'"); } $languages = tep_get_languages(); for ($i=0, $n=sizeof($languages); $i<$n; $i++) { $categories_name_array = $HTTP_POST_VARS['categories_name']; $language_id = $languages[$i]['id']; $sql_data_array = array('categories_name' => tep_db_prepare_input($categories_name_array[$language_id])); if ($action == 'insert_category') { $insert_sql_data = array('categories_id' => $categories_id, 'language_id' => $languages[$i]['id']); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); tep_db_perform(TABLE_CATEGORIES_DESCRIPTION, $sql_data_array); } elseif ($action == 'update_category') { tep_db_perform(TABLE_CATEGORIES_DESCRIPTION, $sql_data_array, 'update', "categories_id = '" . (int)$categories_id . "' and language_id = '" . (int)$languages[$i]['id'] . "'"); } } if ($categories_image = new upload('categories_image', DIR_FS_CATALOG_IMAGES)) { tep_db_query("update " . TABLE_CATEGORIES . " set categories_image = '" . tep_db_input($categories_image->filename) . "' where categories_id = '" . (int)$categories_id . "'"); } if (USE_CACHE == 'true') { tep_reset_cache_block('categories'); tep_reset_cache_block('also_purchased'); } tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories_id)); break; case 'delete_category_confirm': if (isset($HTTP_POST_VARS['categories_id'])) { $categories_id = tep_db_prepare_input($HTTP_POST_VARS['categories_id']); $categories = tep_get_category_tree($categories_id, '', '0', '', true); $products = array(); $products_delete = array(); for ($i=0, $n=sizeof($categories); $i<$n; $i++) { $product_ids_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$categories[$i]['id'] . "'"); while ($product_ids = tep_db_fetch_array($product_ids_query)) { $products[$product_ids['products_id']]['categories'][] = $categories[$i]['id']; } } reset($products); while (list($key, $value) = each($products)) { $category_ids = ''; for ($i=0, $n=sizeof($value['categories']); $i<$n; $i++) { $category_ids .= "'" . (int)$value['categories'][$i] . "', "; } $category_ids = substr($category_ids, 0, -2); $check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$key . "' and categories_id not in (" . $category_ids . ")"); $check = tep_db_fetch_array($check_query); if ($check['total'] < '1') { $products_delete[$key] = $key; } } // removing categories can be a lengthy process tep_set_time_limit(0); for ($i=0, $n=sizeof($categories); $i<$n; $i++) { tep_remove_category($categories[$i]['id']); } reset($products_delete); while (list($key) = each($products_delete)) { tep_remove_product($key); } } if (USE_CACHE == 'true') { tep_reset_cache_block('categories'); tep_reset_cache_block('also_purchased'); } tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath)); break; case 'delete_product_confirm': if (isset($HTTP_POST_VARS['products_id']) && isset($HTTP_POST_VARS['product_categories']) && is_array($HTTP_POST_VARS['product_categories'])) { $product_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']); $product_categories = $HTTP_POST_VARS['product_categories']; for ($i=0, $n=sizeof($product_categories); $i<$n; $i++) { tep_db_query("delete from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$product_id . "' and categories_id = '" . (int)$product_categories[$i] . "'"); // BOF Separate Pricing per Customer tep_db_query("delete from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . tep_db_input($product_id) . "' "); // EOF Separate Pricing per Customer } $product_categories_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$product_id . "'"); $product_categories = tep_db_fetch_array($product_categories_query); if ($product_categories['total'] == '0') { tep_remove_product($product_id); } } if (USE_CACHE == 'true') { tep_reset_cache_block('categories'); tep_reset_cache_block('also_purchased'); } tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath)); break; case 'move_category_confirm': if (isset($HTTP_POST_VARS['categories_id']) && ($HTTP_POST_VARS['categories_id'] != $HTTP_POST_VARS['move_to_category_id'])) { $categories_id = tep_db_prepare_input($HTTP_POST_VARS['categories_id']); $new_parent_id = tep_db_prepare_input($HTTP_POST_VARS['move_to_category_id']); $path = explode('_', tep_get_generated_category_path_ids($new_parent_id)); if (in_array($categories_id, $path)) { $messageStack->add_session(ERROR_CANNOT_MOVE_CATEGORY_TO_PARENT, 'error'); tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories_id)); } else { tep_db_query("update " . TABLE_CATEGORIES . " set parent_id = '" . (int)$new_parent_id . "', last_modified = now() where categories_id = '" . (int)$categories_id . "'"); if (USE_CACHE == 'true') { tep_reset_cache_block('categories'); tep_reset_cache_block('also_purchased'); } tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $new_parent_id . '&cID=' . $categories_id)); } } break; case 'move_product_confirm': $products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']); $new_parent_id = tep_db_prepare_input($HTTP_POST_VARS['move_to_category_id']); $duplicate_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$products_id . "' and categories_id = '" . (int)$new_parent_id . "'"); $duplicate_check = tep_db_fetch_array($duplicate_check_query); if ($duplicate_check['total'] < 1) tep_db_query("update " . TABLE_PRODUCTS_TO_CATEGORIES . " set categories_id = '" . (int)$new_parent_id . "' where products_id = '" . (int)$products_id . "' and categories_id = '" . (int)$current_category_id . "'"); if (USE_CACHE == 'true') { tep_reset_cache_block('categories'); tep_reset_cache_block('also_purchased'); } tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $new_parent_id . '&pID=' . $products_id)); break; case 'insert_product': case 'update_product': if (isset($HTTP_POST_VARS['edit_x']) || isset($HTTP_POST_VARS['edit_y'])) { $action = 'new_product'; } else { if (isset($HTTP_GET_VARS['pID'])) $products_id = tep_db_prepare_input($HTTP_GET_VARS['pID']); $products_date_available = tep_db_prepare_input($HTTP_POST_VARS['products_date_available']); $products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null'; $sql_data_array = array('products_quantity' => tep_db_prepare_input($HTTP_POST_VARS['products_quantity']), 'products_model' => tep_db_prepare_input($HTTP_POST_VARS['products_model']), 'products_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price']), //BOF Price Break 1.11.3 mod 'products_price1' => tep_db_prepare_input($HTTP_POST_VARS['products_price1']), 'products_price2' => tep_db_prepare_input($HTTP_POST_VARS['products_price2']), 'products_price3' => tep_db_prepare_input($HTTP_POST_VARS['products_price3']), 'products_price4' => tep_db_prepare_input($HTTP_POST_VARS['products_price4']), 'products_price5' => tep_db_prepare_input($HTTP_POST_VARS['products_price5']), 'products_price6' => tep_db_prepare_input($HTTP_POST_VARS['products_price6']), 'products_price7' => tep_db_prepare_input($HTTP_POST_VARS['products_price7']), 'products_price8' => tep_db_prepare_input($HTTP_POST_VARS['products_price8']), 'products_price1_qty' => (($i=tep_db_prepare_input($HTTP_POST_VARS['products_price1_qty'])) < 0) ? 0 : $i, 'products_price2_qty' => (($i=tep_db_prepare_input($HTTP_POST_VARS['products_price2_qty'])) < 0) ? 0 : $i, 'products_price3_qty' => (($i=tep_db_prepare_input($HTTP_POST_VARS['products_price3_qty'])) < 0) ? 0 : $i, 'products_price4_qty' => (($i=tep_db_prepare_input($HTTP_POST_VARS['products_price4_qty'])) < 0) ? 0 : $i, 'products_price5_qty' => (($i=tep_db_prepare_input($HTTP_POST_VARS['products_price5_qty'])) < 0) ? 0 : $i, 'products_price6_qty' => (($i=tep_db_prepare_input($HTTP_POST_VARS['products_price6_qty'])) < 0) ? 0 : $i, 'products_price7_qty' => (($i=tep_db_prepare_input($HTTP_POST_VARS['products_price7_qty'])) < 0) ? 0 : $i, 'products_price8_qty' => (($i=tep_db_prepare_input($HTTP_POST_VARS['products_price8_qty'])) < 0) ? 0 : $i, 'products_qty_blocks' => (($i=tep_db_prepare_input($HTTP_POST_VARS['products_qty_blocks'])) < 1) ? 1 : $i, // EOF Price Break 1.11.3 mod 'products_date_available' => $products_date_available, 'products_weight' => tep_db_prepare_input($HTTP_POST_VARS['products_weight']), 'products_status' => tep_db_prepare_input($HTTP_POST_VARS['products_status']), 'products_tax_class_id' => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']), 'manufacturers_id' => tep_db_prepare_input($HTTP_POST_VARS['manufacturers_id'])); if (isset($HTTP_POST_VARS['products_image']) && tep_not_null($HTTP_POST_VARS['products_image']) && ($HTTP_POST_VARS['products_image'] != 'none')) { $sql_data_array['products_image'] = tep_db_prepare_input($HTTP_POST_VARS['products_image']); } // start CAO 3 Images if (isset($HTTP_POST_VARS['products_image_medium']) && tep_not_null($HTTP_POST_VARS['products_image_medium']) && ($HTTP_POST_VARS['products_image_medium'] != 'none')) { $sql_data_array['products_image_medium'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_medium']); } if (isset($HTTP_POST_VARS['products_image_large']) && tep_not_null($HTTP_POST_VARS['products_image_large']) && ($HTTP_POST_VARS['products_image_large'] != 'none')) { $sql_data_array['products_image_large'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_large']); } // end CAO 3 Images if ($action == 'insert_product') { $insert_sql_data = array('products_date_added' => 'now()'); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); tep_db_perform(TABLE_PRODUCTS, $sql_data_array); $products_id = tep_db_insert_id(); tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$current_category_id . "')"); } elseif ($action == 'update_product') { $update_sql_data = array('products_last_modified' => 'now()'); $sql_data_array = array_merge($sql_data_array, $update_sql_data); tep_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'"); } // BOF Separate Pricing Per Customer, Price Break 1.11.3 mod $customers_group_query = tep_db_query("select customers_group_id, customers_group_name from " . TABLE_CUSTOMERS_GROUPS . " where customers_group_id != '0' order by customers_group_id"); while ($customers_group = tep_db_fetch_array($customers_group_query)) // Gets all of the customers groups { $attributes_query = tep_db_query("select customers_group_id, customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where ((products_id = '" . $products_id . "') && (customers_group_id = " . $customers_group['customers_group_id'] . ")) order by customers_group_id"); $attributes = tep_db_fetch_array($attributes_query); if (tep_db_num_rows($attributes_query) > 0) { if ($HTTP_POST_VARS['sppcoption'][$customers_group['customers_group_id']]) { // this is checking if the check box is checked if ($attributes['customers_group_id'] == $customers_group['customers_group_id'] ) { $sppc_update_query = "set "; if (isset($HTTP_POST_VARS['sppcprice'][$customers_group['customers_group_id']])) { $sppc_update_query .= "customers_group_price = '" . $HTTP_POST_VARS['sppcprice'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_qty_blocks'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_qty_blocks = '" . $HTTP_POST_VARS['sppcproducts_qty_blocks'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price1'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price1 = '" . $HTTP_POST_VARS['sppcproducts_price1'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price1_qty'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price1_qty = '" . $HTTP_POST_VARS['sppcproducts_price1_qty'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price2'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price2 = '" . $HTTP_POST_VARS['sppcproducts_price2'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price2_qty'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price2_qty = '" . $HTTP_POST_VARS['sppcproducts_price2_qty'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price3'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price3 = '" . $HTTP_POST_VARS['sppcproducts_price3'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price3_qty'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price3_qty = '" . $HTTP_POST_VARS['sppcproducts_price3_qty'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price4'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price4 = '" . $HTTP_POST_VARS['sppcproducts_price4'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price4_qty'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price4_qty = '" . $HTTP_POST_VARS['sppcproducts_price4_qty'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price5'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price5 = '" . $HTTP_POST_VARS['sppcproducts_price5'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price5_qty'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price5_qty = '" . $HTTP_POST_VARS['sppcproducts_price5_qty'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price6'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price6 = '" . $HTTP_POST_VARS['sppcproducts_price6'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price6_qty'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price6_qty = '" . $HTTP_POST_VARS['sppcproducts_price6_qty'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price7'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price7 = '" . $HTTP_POST_VARS['sppcproducts_price7'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price7_qty'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price7_qty = '" . $HTTP_POST_VARS['sppcproducts_price7_qty'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price8'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price8 = '" . $HTTP_POST_VARS['sppcproducts_price8'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price8_qty'][$customers_group['customers_group_id']])) { $sppc_update_query .= " products_price8_qty = '" . $HTTP_POST_VARS['sppcproducts_price8_qty'][$customers_group['customers_group_id']] . "' "; } // now we need to get rid of the last comma in the query string... $sppc_update_query = rtrim($sppc_update_query); $query_string_length = strlen($sppc_update_query); if (substr($sppc_update_query, -1) == ",") { $sppc_update_query = substr($sppc_update_query, $query_string_length-1); } tep_db_query("update " . TABLE_PRODUCTS_GROUPS . " " . $sppc_update_query . " where customers_group_id = '" . $attributes['customers_group_id'] . "' and products_id = '" . $products_id . "'"); // $attributes = tep_db_fetch_array($attributes_query); } /* elseif (($HTTP_POST_VARS['sppcprice'][$customers_group['customers_group_id']] == $attributes['customers_group_price'])) { $attributes = tep_db_fetch_array($attributes_query); } */ } else { // checkbox is unchecked tep_db_query("delete from " . TABLE_PRODUCTS_GROUPS . " where customers_group_id = '" . $customers_group['customers_group_id'] . "' and products_id = '" . $products_id . "'"); $attributes = tep_db_fetch_array($attributes_query); } // next } : end if (tep_db_num_rows($attributes_query) > 0) } elseif (($HTTP_POST_VARS['sppcoption'][$customers_group['customers_group_id']]) && ($HTTP_POST_VARS['sppcprice'][$customers_group['customers_group_id']] != '')) { $sppc_insert_query = "set products_id = '" . $products_id . "', customers_group_id= '" . $customers_group['customers_group_id'] . "', "; if (isset($HTTP_POST_VARS['sppcprice'][$customers_group['customers_group_id']])) { $sppc_insert_query .= "customers_group_price = '" . $HTTP_POST_VARS['sppcprice'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_qty_blocks'][$customers_group['customers_group_id']])) { $sppc_insert_query .= " products_qty_blocks = '" . $HTTP_POST_VARS['sppcproducts_qty_blocks'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price1'][$customers_group['customers_group_id']])) { $sppc_insert_query .= " products_price1 = '" . $HTTP_POST_VARS['sppcproducts_price1'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price1_qty'][$customers_group['customers_group_id']])) { $sppc_insert_query .= " products_price1_qty = '" . $HTTP_POST_VARS['sppcproducts_price1_qty'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price2'][$customers_group['customers_group_id']])) { $sppc_insert_query .= " products_price2 = '" . $HTTP_POST_VARS['sppcproducts_price2'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price2_qty'][$customers_group['customers_group_id']])) { $sppc_insert_query .= " products_price2_qty = '" . $HTTP_POST_VARS['sppcproducts_price2_qty'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price3'][$customers_group['customers_group_id']])) { $sppc_insert_query .= " products_price3 = '" . $HTTP_POST_VARS['sppcproducts_price3'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price3_qty'][$customers_group['customers_group_id']])) { $sppc_insert_query .= " products_price3_qty = '" . $HTTP_POST_VARS['sppcproducts_price3_qty'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price4'][$customers_group['customers_group_id']])) { $sppc_insert_query .= " products_price4 = '" . $HTTP_POST_VARS['sppcproducts_price4'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price4_qty'][$customers_group['customers_group_id']])) { $sppc_insert_query .= " products_price4_qty = '" . $HTTP_POST_VARS['sppcproducts_price4_qty'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price5'][$customers_group['customers_group_id']])) { $sppc_insert_query .= " products_price5 = '" . $HTTP_POST_VARS['sppcproducts_price5'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price5_qty'][$customers_group['customers_group_id']])) { $sppc_insert_query .= " products_price5_qty = '" . $HTTP_POST_VARS['sppcproducts_price5_qty'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price6'][$customers_group['customers_group_id']])) { $sppc_insert_query .= " products_price6 = '" . $HTTP_POST_VARS['sppcproducts_price6'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price6_qty'][$customers_group['customers_group_id']])) { $sppc_insert_query .= " products_price6_qty = '" . $HTTP_POST_VARS['sppcproducts_price6_qty'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price7'][$customers_group['customers_group_id']])) { $sppc_insert_query .= " products_price7 = '" . $HTTP_POST_VARS['sppcproducts_price7'][$customers_group['customers_group_id']] . "', "; } if (isset($HTTP_POST_VARS['sppcproducts_price7_qty'][$customers_group['customers_group_id']])) { $sppc_insert_query .= " products_price7_qty = '" . $HTTP_POST_VARS['sppcproducts_price
  6. FHCeramics

    PDF Catalog v.1.5

    I installed version 2.0.3 and the main catalog part works, but if you try to do a category catalog everything seems to work fine but when you click the download link all you get is one blank page. This isn't really a problem, the real problem is that it has affected the Catalog section of the admin in oscommerce. All the other sections work, but if you click on the catalog section you get and here is line 53 in /admin/categories.php, the first <!-- Level begin --> shown in the code below $sql_data_array = array_merge($sql_data_array, $sql_data_array2); // Level end b. <!-- Level begin --> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_CATEGORIES_LEVEL; ?></td> <!-- Level end --> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>?</td> </tr> <?php $categories_count = 0; and I can go no furthur, so if anyone can help it would be greatly appreciated.
  7. HELP Please!!!! I didn't notice initially, but on my product info pages the right column sits below the left column My productpage as seen here. Any help would be greatly appreciated. Here is the code for my product info page <?php /* $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $ adapted for Separate Pricing Per Customer v4 2005/03/06 osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO); $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_check = tep_db_fetch_array($product_check_query); // BOF Separate Price per Customer if(!tep_session_is_registered('sppc_customer_group_id')) { $customer_group_id = '0'; } else { $customer_group_id = $sppc_customer_group_id; } // EOF Separate Price per Customer ?> <!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"> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le ft=150') } //--></script> </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 //--> <td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0"> <?php if ($product_check['total'] < 1) { ?> <tr> <td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <?php } else { $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_image_medium, p.products_image_large, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($new_price = tep_get_products_special_price($product_info['products_id'])) { // BOF Separate Price per Customer $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'"); if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) { $product_info['products_price']= $scustomer_group_price['customers_group_price']; } // EOF Separate Price per Customer $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { // BOF Separate Price per Customer $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'"); if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) { $product_info['products_price']= $scustomer_group_price['customers_group_price']; } // EOF Separate Price per Customer $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } if (tep_not_null($product_info['products_model'])) { $products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>'; } else { $products_name = $product_info['products_name']; } ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading" valign="top"><?php echo $products_name; ?></td> <td class="pageHeading" align="right" valign="top"><?php echo $products_price; ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"> <?php if (tep_not_null($product_info['products_image'])) { ?> <table border="0" cellspacing="0" cellpadding="2" align="right"> <tr> <td align="center" class="smallText"> <script language="javascript"><!-- document.write('<?php echo '<a href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>'); //--></script> <noscript> <?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?> </noscript> </td> </tr> </table> <?php } ?> <?php if (tep_not_null($product_info[products_image_medium])) { ?> <tr> <td align="center" class="smallText"> <script language="javascript"><!-- document.write('<?php echo '<a href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE_MEDIUM, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES_MEDIUM . $product_info['products_image_medium'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>'); //--></script> <noscript> <?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES_MEDIUM . $product_info['products_image_medium']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image_medium'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?> </noscript> </td> </tr> <?php } if (tep_not_null($product_info['products_image_large'])) { ?> <tr> <td align="center" class="smallText"> <script language="javascript"><!-- document.write('<?php echo '<a href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE_LARGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES_LARGE . $product_info['products_image_large'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>'); //--></script> <noscript> <?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES_LARGE . $product_info['products_image_large']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image_large'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?> </noscript> </td> </tr> <?php } // end 3 Images ?> </table> <p><?php echo stripslashes($product_info['products_description']); ?></p> <?php if (OPTIONS_AS_IMAGES_ENABLED == 'false'){ $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { ?> <table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td> </tr> <?php $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name"); while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { $products_options_array = array(); $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); while ($products_options = tep_db_fetch_array($products_options_query)) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') '; } } if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } ?> <tr> <td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td> <td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td> </tr> <?php } ?> </table> <?php } //Options as Images. Add the curly bracket as shown on the next line } ?> <?php //Options as Images. This whole php clause needs to be added if (OPTIONS_AS_IMAGES_ENABLED == 'true') include ('options_images.php'); ?> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); $reviews = tep_db_fetch_array($reviews_query); if ($reviews['count'] > 0) { ?> <tr> <td class="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } if (tep_not_null($product_info['products_url'])) { ?> <tr> <td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) { ?> <tr> <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td> </tr> <?php } else { ?> <tr> <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td> </tr> <?php } ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td> <td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td> <?php if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_also_purchased(3600); } else { include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS); } } ?> </td> </tr> </table></form></td> <!-- 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'); ?> Again, thanks for any help you can give.
  8. I have businesses set up in Canada and the US but use the same website. Being most of the products come from the USA, I can list them at US prices, however if a customer is from Canada, in a lot of cases there are additional duties and freight charges applied when I bring products into Canada that I have to figure into the prices. Currently I have this set up through the currency view in oscommerce to show the difference but when it comes to checkout it uses the default US price. Is there a way to set the shopping cart up to charge prices based on the prices listed for country. OK, here is an example of what I am trying to explain Now when Canadian buyers view my website using the Canadian currency button, they see the Canadian equivelancy to $17.56USD but when they make the purchase they are only charged the $15.00USD price. I realize this contribution works on a percentage and that is fine, as I just use the same percentage as is set in the currency conversion on the site. Is there any way to adjust this contribution, or any other suggestions on how to correct this or do I need to set up a seperate store for my Canadian customers. Any suggestions or help with this would be greatly appreciated.
  9. FHCeramics

    Events Calendar

    I installed this contribution, and on the public side it seems to work fine, but on the admin, if I try to access any of the sections I get this error: Fatal error: Cannot redeclare class upload in /www/f/fhceramics/htdocs/osCommerce/catalog/admin/includes/classes/upload.php on line 13 Here is what the upload.php line 13 which I have underlined shows; Any help would be very much appreciated;
  10. I installed Catalog products PDF reports v.1.59 and ran it on my empty store and it produced a file showing my categories and sub-categories. However, since adding products all I keep getting is an http 500 error saying page not found and no file is produced not even the directory like it did at the start. I adjusted the php.ini file to 6 minutes for timing out and the memory to 32MB. Would appreciate it if someone could help me with this.
  11. FHCeramics

    Current AUctions V2.0

    Hi, just installed the contribution, no visible errors come up, but when I click on the box to go to the auctions, I get HTTP 404 Error Page not found and this is what appears in the address box of internet explorer Any helpful advice would be greatly appreciated
  12. FHCeramics

    Help Locating Contribution

    :) Thanks, your help is greatly appreciated. Best of luck!
  13. When I first installed osCommerce I found a contribution that showed on the product page - the Retail price (Stroked out) and a net price below which also showed the % off on the product. I just had to re-install osCommerce but can not locate this contribution. If anyone can help, it would be greatly appreciated.
  14. FHCeramics

    PDF Catalog v.1.5

    Hi, got the contribution working fine, on a 700 item catalog it was 13 seconds generating and produced a 1.94MB size file. Would probably be faster and smaller if I could figure out how to get it to list more then 4 products per page, or if there was a wayto get 2 columns per page. Great work Vger!!!!
  15. FHCeramics

    JUST RELEASED! Printable Catalog

    Hi, still having this problem. can anyone offer a suggestion on how this can be corrected? Thanks
  16. FHCeramics

    [contribution] Total B2B

    There were no modifications to the currencies.php so i overwrote it using the one from the contribution. Here the code tep_xppp_get_product_price() was mixed up, should have read tep_xppp_getproductprice() There were no modifications to the general.php so i overwrote it using the one from the contribution. It seems you missed implementing some essential parts of the contrib or you did the changes but they are not picked up from the correct files. <{POST_SNAPBACK}> Double checked everything else and it all seems correct unless there are changes made that are not clearly identified.
  17. FHCeramics

    [contribution] Total B2B

    Thanks, tried this but still getting the same error. If you go to http://fhceramics.com/osCommerce/catalog/ you will see what is happening in the What's New Box.
  18. FHCeramics

    [contribution] Total B2B

    Could you show how and where as numerous people are having this problem, and by my code, it shows what you say its supposed to listing product id first and not all of us are programmers or php wizards, we do need a little explaning and assistance. Thanks
  19. FHCeramics

    [contribution] Total B2B

    I am getting this error in the "What's new" box: Warning: Missing argument 3 for display_price() in E:\Miata\dividi\includes\classes\currencies.php on line 71 Line 71 is ? ?function display_price($products_id, $products_price, $products_tax, $quantity = 1) { I have tried everything that i could find in this forum to correct it but still getting same error. Any help would be more then greatly appreciated.
  20. FHCeramics

    Catalog products PDF reports

    Can no one help me with this, I sure would appreciate any help or suggestions :'(
  21. FHCeramics

    print_catalog.php,v 1.2 2004/09/17

    Hi Lewis, Great contribution but I'm having a problem with it. Because my images are all different sizes, the contribution is distorting about 80% of them. Is there a way where I could set a fixed height but allow the width to be adjusted to match the image porportions so that I get clear undistorted images.
  22. What I have is the 3 pwa login boxes, the non account, create account and login account which is what I'm supposed to have but right below these 3, are the oscommerce create and login boxes as well, I have 5 boxes on my page. Here is how the boxes are laid out; I know these are not the right names but you can see what I mean. 1 non account 2 create account 3login to account 4 create account 5 login to account so I obviously misplaced a piece of code or missed removing a piece, so if some has a suggestion I would appreciate it.
  23. ok, thanks, I adjusted the position of the login codeand now have the 3 boxes and they seem to be working, but must have missed something as the osCommerce standard 2 boxes are right below them. Any suggestions where I might look?
  24. I have triple checked and everything seems to match, have checked install txt against mods. Here is exactly what i did of course I removed the CODE tags when I was installing the info. Does position in file for the non-replacement pieces of code make a difference? I put items in my cart, click checkout and it goes to the default osCommerce login page. If you want I will copy and paste each section I did from each file?
  25. I installed PWA 0.82 and got no errors, and in admin under configuration/accounts PWA is set to True. However in the catalogue nothing is showing up and the standard osCommerce account login/create is still active there is no box showing the 3 options mentioned in the contribution. I have reread and checked the install and everything seems to be in place but nothing is showing up. If anyone has any ideas on this it would be greatly appreciated.
×