Jump to content

sunbound2

Members
  • Content count

    63
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Jon
  • Gender
    Male
  1. sunbound2

    ULTIMATE Seo Urls 5 - by FWR Media

    oops, please delete post.
  2. I'll be continuing in a current post looking for information pages help; http://forums.oscommerce.com/topic/396532-content-not-changing-for-info-pages/page__hl__+information%20+pages#entry1695222. starting at post #11. Thanks again.
  3. OK, so I've installed Catagory CSS Menu. That went ok... things look the same though... The pages i created in information pages still aren't showing up. I'm going to look for the information pages support page, or create one, and take it there. Thanks for your help guys. :thumbsup:
  4. Looks like I'm missing ANOTHER mod... one of the errors points to a file "menu.css"... looks like that might be linked to "Catagory CSS Menu". I'm wondering if the reason things didn't work was because i was missing some mods...
  5. OK, SO... After commenting everything out that had any variation of ezpages, or ez_pages of my php files, and after refreshing my page, all the catagories along the top of the page are gone. The only things left along the top are the buttons for "contact us" and "request for quote". Somewhere there is something hiding from ez pages thought because the entry is still there on the admin side. There are still some redundant links along the side that still work, I think that's a good thing... on the apache side, I'm getting errors along the lines of File does not exist: C:/wamp/www/can-products-c-1_2.html, referer: http://localhost/index.php?cPath=8 and File does not exist: C:/wamp/www/images/site/heading_gradient_med_hover.png, referer: http://localhost/includes/css/menu.css I'm not seeing any new errors on the PHP side for the last few minutes...
  6. OH, and I installed that version of information pages you suggested.... not much from the configuration standpoint has changed. it looks a little different on the admin side, but is still functions the same.
  7. I'm not sure our "lines" are the same... my line 305 = <?php my line 323 = $EZPAGES_DESCRIPTION = stripslashes($row['ezpages_description']); my line 326 = $EZPAGES_META_KEYWORDS = stripslashes($row['ezpages_head_keywords_tag']); my line 331 = <!--h1><?php echo HEADING_TITLE; ?></h1--> I guess why I'm confused is why take some of the lines about ezpages out, and leave others behind. did you want me to replace $category_depth = 'top'; with if($category_depth == 'top' && !isset($_GET['manufacturers_id'])) {
  8. Nope, still working on it. In what file do i need to make those changes from post #25?
  9. I'm running a findstr right now for ezpages in my PHP files right now... I'm hoping to find an answer in there somewhere. PS. Thanks for the Tip about the command MrPhil... looking back, it seems you have been helping me with this project since the beginning. I owe you a beer after this! :beers:
  10. After commenting out the EZ_pages stuff from those files (only two of them had stuff), the website fails... that was expected... something is still looking for that information. the error i get on the page is "1146 - Table 'marlin.table_ezpages' doesn't exist Select e.ezpages_id as id, ed.ezpages_name as name, e.passthru as is_passthru, 0 as is_header, e.target as target, e.ezpages_parent_category as parent_id From TABLE_EZPAGES e Inner Join TABLE_EZPAGES_DESCRIPTION ed On e.ezpages_id = ed.ezpages_id And ed.language_id = 1 Where e.ezpages_status = 1 AND e.ezpages_nav_status = 1 Order By parent_id, sort_order, ezpages_name" and its correct, that table doesn't exist in my database. I'm not seeing the if($_GET['info_id'] == 1){ code in my index.php file.
  11. I actually have Information Pages Unlimited v2.05 A for OSC v2.3.1 installed, you want me to reverse those changes and install the one release just before that from SLiCK? code from my... Includes/filenames.php <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2012 osCommerce Released under the GNU General Public License */ // define the filenames used in the project define('FILENAME_ACCOUNT', 'account.php'); define('FILENAME_ACCOUNT_EDIT', 'account_edit.php'); define('FILENAME_ACCOUNT_HISTORY', 'account_history.php'); define('FILENAME_ACCOUNT_HISTORY_INFO', 'account_history_info.php'); define('FILENAME_ACCOUNT_NEWSLETTERS', 'account_newsletters.php'); define('FILENAME_ACCOUNT_NOTIFICATIONS', 'account_notifications.php'); define('FILENAME_ACCOUNT_PASSWORD', 'account_password.php'); define('FILENAME_ADDRESS_BOOK', 'address_book.php'); define('FILENAME_ADDRESS_BOOK_PROCESS', 'address_book_process.php'); define('FILENAME_ADVANCED_SEARCH', 'advanced_search.php'); #define('FILENAME_ADVANCED_SEARCH_RESULT', 'search.php'); define('FILENAME_ADVANCED_SEARCH_RESULT', 'advanced_search_result.php'); define('FILENAME_ALSO_PURCHASED_PRODUCTS', 'also_purchased_products.php'); define('FILENAME_CHECKOUT_CONFIRMATION', 'checkout_confirmation.php'); define('FILENAME_CHECKOUT_PAYMENT', 'checkout_payment.php'); define('FILENAME_CHECKOUT_PAYMENT_ADDRESS', 'checkout_payment_address.php'); define('FILENAME_CHECKOUT_PROCESS', 'checkout_process.php'); define('FILENAME_CHECKOUT_SHIPPING', 'checkout_shipping.php'); define('FILENAME_CHECKOUT_SHIPPING_ADDRESS', 'checkout_shipping_address.php'); define('FILENAME_CHECKOUT_SUCCESS', 'checkout_success.php'); define('FILENAME_CONTACT_US', 'contact_us.php'); define('FILENAME_CONDITIONS', 'conditions.php'); define('FILENAME_COOKIE_USAGE', 'cookie_usage.php'); define('FILENAME_CREATE_ACCOUNT', 'create_account.php'); define('FILENAME_CREATE_ACCOUNT_SUCCESS', 'create_account_success.php'); define('FILENAME_DEFAULT', 'index.php'); define('FILENAME_DOWNLOAD', 'download.php'); define('FILENAME_INFORMATION', 'information.php'); define('FILENAME_INFO_SHOPPING_CART', 'info_shopping_cart.php'); define('FILENAME_LOGIN', 'login.php'); define('FILENAME_LOGOFF', 'logoff.php'); define('FILENAME_NEW_PRODUCTS', 'new_products.php'); define('FILENAME_PASSWORD_FORGOTTEN', 'password_forgotten.php'); define('FILENAME_PASSWORD_RESET', 'password_reset.php'); define('FILENAME_POPUP_IMAGE', 'popup_image.php'); define('FILENAME_POPUP_SEARCH_HELP', 'popup_search_help.php'); define('FILENAME_PRIVACY', 'privacy.php'); define('FILENAME_PRODUCT_INFO', 'product_info.php'); //define('FILENAME_PRODUCT_LISTING', 'product_listing.php'); define('FILENAME_PRODUCT_LISTING', 'product_listing_ajax.php'); define('FILENAME_PRODUCT_REVIEWS', 'product_reviews.php'); define('FILENAME_PRODUCT_REVIEWS_INFO', 'product_reviews_info.php'); define('FILENAME_PRODUCT_REVIEWS_WRITE', 'product_reviews_write.php'); define('FILENAME_PRODUCTS_NEW', 'products_new.php'); define('FILENAME_REDIRECT', 'redirect.php'); define('FILENAME_REVIEWS', 'reviews.php'); define('FILENAME_SHIPPING', 'shipping.php'); define('FILENAME_SITEMAP', 'sitemap.php'); define('FILENAME_SHOPPING_CART', 'shopping_cart.php'); define('FILENAME_SITE_SEARCH', 'site_search.php'); define('FILENAME_SPECIALS', 'specials.php'); define('FILENAME_SSL_CHECK', 'ssl_check.php'); define('FILENAME_TELL_A_FRIEND', 'tell_a_friend.php'); define('FILENAME_UPCOMING_PRODUCTS', 'upcoming_products.php'); // BOF: Information Pages Unlimited define('FILENAME_INFORMATION', 'information.php'); // EOF: Information Pages Unlimited ?> includes/database_tables.php <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2007 osCommerce Released under the GNU General Public License */ // define the database table names used in the project define('TABLE_ACTION_RECORDER', 'action_recorder'); define('TABLE_ADDRESS_BOOK', 'address_book'); define('TABLE_ADDRESS_FORMAT', 'address_format'); define('TABLE_ADMINISTRATORS', 'administrators'); define('TABLE_BANNERS', 'banners'); define('TABLE_BANNERS_HISTORY', 'banners_history'); define('TABLE_CATEGORIES', 'categories'); define('TABLE_CATEGORIES_DESCRIPTION', 'categories_description'); define('TABLE_CONFIGURATION', 'configuration'); define('TABLE_CONFIGURATION_GROUP', 'configuration_group'); define('TABLE_COUNTER', 'counter'); define('TABLE_COUNTER_HISTORY', 'counter_history'); define('TABLE_COUNTRIES', 'countries'); define('TABLE_CURRENCIES', 'currencies'); define('TABLE_CUSTOMERS', 'customers'); define('TABLE_CUSTOMERS_BASKET', 'customers_basket'); define('TABLE_CUSTOMERS_BASKET_ATTRIBUTES', 'customers_basket_attributes'); define('TABLE_CUSTOMERS_INFO', 'customers_info'); define('TABLE_LANGUAGES', 'languages'); define('TABLE_MANUFACTURERS', 'manufacturers'); define('TABLE_MANUFACTURERS_INFO', 'manufacturers_info'); define('TABLE_ORDERS', 'orders'); define('TABLE_ORDERS_PRODUCTS', 'orders_products'); define('TABLE_ORDERS_PRODUCTS_ATTRIBUTES', 'orders_products_attributes'); define('TABLE_ORDERS_PRODUCTS_DOWNLOAD', 'orders_products_download'); define('TABLE_ORDERS_STATUS', 'orders_status'); define('TABLE_ORDERS_STATUS_HISTORY', 'orders_status_history'); define('TABLE_ORDERS_TOTAL', 'orders_total'); define('TABLE_PRODUCTS', 'products'); define('TABLE_PRODUCTS_ATTRIBUTES', 'products_attributes'); define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD', 'products_attributes_download'); define('TABLE_PRODUCTS_DESCRIPTION', 'products_description'); define('TABLE_PRODUCTS_IMAGES', 'products_images'); define('TABLE_PRODUCTS_NOTIFICATIONS', 'products_notifications'); define('TABLE_PRODUCTS_OPTIONS', 'products_options'); define('TABLE_PRODUCTS_OPTIONS_VALUES', 'products_options_values'); define('TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS', 'products_options_values_to_products_options'); define('TABLE_PRODUCTS_TO_CATEGORIES', 'products_to_categories'); define('TABLE_REVIEWS', 'reviews'); define('TABLE_REVIEWS_DESCRIPTION', 'reviews_description'); define('TABLE_SESSIONS', 'sessions'); define('TABLE_SPECIALS', 'specials'); define('TABLE_TAX_CLASS', 'tax_class'); define('TABLE_TAX_RATES', 'tax_rates'); define('TABLE_GEO_ZONES', 'geo_zones'); define('TABLE_ZONES_TO_GEO_ZONES', 'zones_to_geo_zones'); define('TABLE_WHOS_ONLINE', 'whos_online'); define('TABLE_ZONES', 'zones'); define('TABLE_EZPAGES', 'ezpages'); define('TABLE_EZPAGES_DESCRIPTION', 'ezpages_description'); define('TABLE_SEO_URLS', 'seo_urls'); define('TABLE_SEO_HISTORY', 'seo_history'); define('TABLE_SEO_301S', 'seo_301s'); // BOF: Information Pages Unlimited define('TABLE_INFORMATION', 'information'); // EOF: Information Pages Unlimited ?> index.php <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2010 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 . "'"); $categories_products = tep_db_fetch_array($categories_products_query); if ($categories_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); require(DIR_WS_INCLUDES . 'template_top.php'); if ($category_depth == 'nested') { $category_query = tep_db_query("select cd.categories_name, c.categories_image, cd.description 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); ?> <div class="breadcrumb_trail"><?php echo ' ' . $breadcrumb->trail(' » '); ?></div> <h1><?php echo $category['categories_name']; ?></h1> <div class="contentContainer"> <div class="contentText"> <div class="cat_description"> <?php if (!empty($category['categories_image'])) { echo '<div id="piGal" class="picR"><a href="' . tep_href_link(DIR_WS_IMAGES . $category['categories_image'], '', 'NONSSL', false) . '" target="_blank" rel="fancybox">' . tep_image(DIR_WS_IMAGES . $category['categories_image'], $category['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br />Click to Enlarge</a></div>'; } echo stripslashes(stripslashes($category['description'])); ?> <script type="text/javascript"> $("#piGal a[rel^=fancybox]").fancybox({ cyclic: true }); </script> </div> <table border="0" width="100%" cellspacing="5" cellpadding="5"> <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 box_back" height="146" 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 /><span>' . $categories['categories_name'] . '</span></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> <br /> <?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?> </div> </div> <?php } elseif ($category_depth == 'products' || (isset($HTTP_GET_VARS['manufacturers_id']) && !empty($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']) && !empty($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'])) || (!preg_match('/^[1-8][ad]$/', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { if ($column_list[$i] == 'PRODUCT_LIST_NAME') { $HTTP_GET_VARS['sort'] = $i+1 . 'a'; $listing_sql .= " order by pd.products_name"; break; } } } else { $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1); $sort_order = substr($HTTP_GET_VARS['sort'], 1); switch ($column_list[$sort_col-1]) { case 'PRODUCT_LIST_MODEL': $listing_sql .= " order by p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= " order by pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= " order by m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= " order by p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $listing_sql .= " order by pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= " order by p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= " order by final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } $catname = HEADING_TITLE; if (isset($HTTP_GET_VARS['manufacturers_id']) && !empty($HTTP_GET_VARS['manufacturers_id'])) { $image = tep_db_query("select manufacturers_image, manufacturers_name as catname from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"); $image = tep_db_fetch_array($image); $catname = $image['catname']; } elseif ($current_category_id) { $image = tep_db_query("select c.categories_image, cd.description, cd.categories_name as catname from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'"); $image = tep_db_fetch_array($image); $catname = $image['catname']; $description = $image['description']; $picture = $image['categories_image']; } ?> <div class="breadcrumb_trail"><?php echo ' ' . $breadcrumb->trail(' » '); ?></div> <h1><?php echo $catname; ?></h1> <div id="printNav"> <a href="<?php echo tep_href_link('html2pdf/html2ps.php', 'url=' . urlencode(preg_replace('%^'. preg_quote(DIR_WS_CATALOG) .'%', '', tep_href_link(FILENAME_DEFAULT , 'cPath=' . $cPath . '&nothumbs=1')))); ?>" target="_blank" rel="nofollow"><img src="images/site/pdficon_small.gif" width="17" height="17" alt="Download PDF of this page" title="Download PDF of this page"></a> <a href="javascript:void(window.print());"><img src="images/site/printer_small.gif" width="17" height="17" alt="Print this page" title="Print this page"></a><br> </div> <div class="contentContainer"> <?php if (!empty($picture)) { echo '<div id="piGal" class="picR"><a href="' . tep_href_link(DIR_WS_IMAGES . $picture, '', 'NONSSL', false) . '" target="_blank" rel="fancybox">' . tep_image(DIR_WS_IMAGES . $picture, $catname, SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br />Click to Enlarge</a></div>'; } ?> <script type="text/javascript"> $("#piGal a[rel^=fancybox]").fancybox({ cyclic: true }); </script> <?php if($description != ''){ echo $description; } // optional Product List Filter if (PRODUCT_LIST_FILTER > 0) { if (isset($HTTP_GET_VARS['manufacturers_id']) && !empty($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 '<div>' . tep_draw_form('filter', tep_href_link( FILENAME_DEFAULT ), 'get') . '<p align="right">' . TEXT_SHOW . ' '; if (isset($HTTP_GET_VARS['manufacturers_id']) && !empty($HTTP_GET_VARS['manufacturers_id'])) { echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']); $options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES)); } else { echo tep_draw_hidden_field('cPath', $cPath); $options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS)); } echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']); while ($filterlist = tep_db_fetch_array($filterlist_query)) { $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']); } echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"'); echo tep_hide_session_id() . '</p></form></div>' . "\n"; } } include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?> </div> <?php } else { // default page $category_depth = 'top'; if($category_depth == 'top' && !isset($_GET['manufacturers_id'])) { $properPageName = tep_href_link(FILENAME_DEFAULT); $EZPAGES_VISIBLE = false; $body_class = "body_home"; $sql = tep_db_query("SELECT e.ezpages_status as visible, ed.ezpages_name, ed.ezpages_description, ezpages_head_title_tag, ezpages_head_desc_tag, ezpages_head_keywords_tag FROM " . TABLE_EZPAGES . " e inner join " . TABLE_EZPAGES_DESCRIPTION . " ed on e.ezpages_id = ed.ezpages_id WHERE e.ezpages_status = 1 AND e.ezpages_id = 1 and ed.language_id = " . (int)$languages_id) or die(mysql_error()); $row = tep_db_fetch_array($sql); if ($row['visible'] == '1') $EZPAGES_VISIBLE = true; $EZPAGES_TITLE = stripslashes($row['ezpages_name']); $EZPAGES_DESCRIPTION = stripslashes($row['ezpages_description']); $EZPAGES_META_TITLE = stripslashes($row['ezpages_head_title_tag']); $EZPAGES_META_DESC = stripslashes($row['ezpages_head_desc_tag']); $EZPAGES_META_KEYWORDS = stripslashes($row['ezpages_head_keywords_tag']); } ?> <!--h1><?php echo $EZPAGES_TITLE; ?></h1--> <!--h1><?php echo HEADING_TITLE; ?></h1--> <div class="contentContainer"> <div class="contentText homeText" align="center"> <?php echo '<div style="margin-bottom: 0px;">' . $EZPAGES_DESCRIPTION . '</div>'; ?> <?php #echo tep_customer_greeting(); ?> </div> <?php if (tep_not_null(TEXT_MAIN)) { ?> <div class="contentText"> <?php echo TEXT_MAIN; ?> </div> <?php } #include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); #include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS); ?> </div> <?php } require(DIR_WS_INCLUDES . 'template_bottom.php'); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> /includes/modules/boxes/bm_information.php <?php /* $Id$ adapted for Information Pages Unlimited v2.05 osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2010 osCommerce Released under the GNU General Public License */ class bm_information { var $code = 'bm_information'; var $group = 'boxes'; var $title; var $description; var $sort_order; var $enabled = false; function bm_information() { $this->title = MODULE_BOXES_INFORMATION_TITLE; $this->description = MODULE_BOXES_INFORMATION_DESCRIPTION; if ( defined('MODULE_BOXES_INFORMATION_STATUS') ) { $this->sort_order = MODULE_BOXES_INFORMATION_SORT_ORDER; $this->enabled = (MODULE_BOXES_INFORMATION_STATUS == 'True'); $this->group = ((MODULE_BOXES_INFORMATION_CONTENT_PLACEMENT == 'Left Column') ? 'boxes_column_left' : 'boxes_column_right'); } } function execute() { global $oscTemplate; // BOF: Information Pages Unlimited require_once(DIR_WS_FUNCTIONS . 'information.php'); // EOF: Information Pages Unlimited $data = '<div class="ui-widget infoBoxContainer">' . ' <div class="ui-widget-header infoBoxHeading">' . MODULE_BOXES_INFORMATION_BOX_TITLE . '</div>' . ' <div class="ui-widget-content infoBoxContents">' . tep_information_show_category(1) . // ' <a href="' . tep_href_link(FILENAME_SHIPPING) . '">' . MODULE_BOXES_INFORMATION_BOX_SHIPPING . '</a><br />' . // ' <a href="' . tep_href_link(FILENAME_PRIVACY) . '">' . MODULE_BOXES_INFORMATION_BOX_PRIVACY . '</a><br />' . // ' <a href="' . tep_href_link(FILENAME_CONDITIONS) . '">' . MODULE_BOXES_INFORMATION_BOX_CONDITIONS . '</a><br />' . ' <a href="' . tep_href_link(FILENAME_CONTACT_US) . '">' . MODULE_BOXES_INFORMATION_BOX_CONTACT . '</a>' . ' </div>' . '</div>'; $oscTemplate->addBlock($data, $this->group); } function isEnabled() { return $this->enabled; } function check() { return defined('MODULE_BOXES_INFORMATION_STATUS'); } function install() { tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Information Module', 'MODULE_BOXES_INFORMATION_STATUS', 'True', 'Do you want to add the module to your shop?', '6', '1', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Content Placement', 'MODULE_BOXES_INFORMATION_CONTENT_PLACEMENT', 'Left Column', 'Should the module be loaded in the left or right column?', '6', '1', 'tep_cfg_select_option(array(\'Left Column\', \'Right Column\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_BOXES_INFORMATION_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0', now())"); } function remove() { tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')"); } function keys() { return array('MODULE_BOXES_INFORMATION_STATUS', 'MODULE_BOXES_INFORMATION_CONTENT_PLACEMENT', 'MODULE_BOXES_INFORMATION_SORT_ORDER'); } } ?> I will start commenting out anything that references ez pages I'm not sure what you mean by "If you can access the information text / html back up so you can use later", sorry. Thank you for your help with this. Everything you guys can do is greatly appreciated. :thumbsup:
  12. Thanks for the response Joli, And everything youve helped me with so far MrPhil, I would like to have one, or the other (preferable EZ_pages because weve used it before, but considering its being a PITA right now, id settle for whatever works. Right now its only partly working (i can turn pages on and off, but not edit them), (I think its also somehow screwing up my SEO urls). If i could uninstall, or just turn it off (then transport the database info to information pages, that would be great. I do have the information pages showing up in the admin side, and i can create and turn the pages on/off but those changes aren't reflected in the live site. (they are polar opposites... I can edit the pages that don't show up in information pages, and i cant edit the pages that do show up in EZ_pages... oh if i had hair id be pulling it out by now.) I'm a bit confused... maybe my brain isn't quite switched on yet. I think your asking to see the code from Includes/filename.php, includes/database.php(i have a database_tables.php), index.php. and /includes/modules/boxes/bm_information.php. is that right? I'll post whatever is needed, I just want to be sure what your asking first.
  13. Most of these files have not changed from when they where running on the LINUX stack... makes me wonder why are they issues now? custom code that doesn't work well in outside of linux? unfortunately, what your telling me is over my head at the moment. Add a check? I'm not sure how to do that. what would be the default action? I cant tell you where the information.php file came from because it was part of the original server. Someone told me that the information.PHP file was from information pages (and it looks similar to EZ_pages), and i just modified the file during the information pages installation. I'm wondering now if I should start a new post on the information pages support page... if there is one.
  14. Nope, the installation isn't zen-cart. The only reason i brought that up was because the only information i could get about EZ_pages was from zen-cart. Nothing else points in that direction. The version of OSC I'm using is 2.3.3
  15. In this file I'm finding Mention of a tool (ez_pages) that i cannot get to work on this server, although it works on the original LAMP server... It was installed by the original page builders. I'm unsure how to uninstall this tool/mod or how to get it to work. I'm thinking EZ_pages is a custom mod from zen-cart. Could that be causing this error?
×