Sure, here it is. I replaced my column_left.php just for testing with the original one from oscommerce kit, but build computer box didn't appear on my site.
<?php
/*
$Id: column_left.php,v 1.15 2003/07/01 14:34:54 hpdl Exp $
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
Released under the GNU General Public License
*/
require(DIR_WS_BOXES . 'consult.php');
require(DIR_WS_BOXES . 'shopping_cart.php');
if ((USE_CACHE == 'true') && empty($SID)) {
echo tep_cache_categories_box();
} else {
include(DIR_WS_BOXES . 'categories.php');
include(DIR_WS_BOXES . 'compbuild.php');
}
require(DIR_WS_BOXES . 'information.php');
require(DIR_WS_BOXES . 'whats_new.php');
if (isset($HTTP_GET_VARS['products_id'])) include(DIR_WS_BOXES . 'manufacturer_info.php');
if (tep_session_is_registered('customer_id')) include(DIR_WS_BOXES . 'order_history.php');
if (isset($HTTP_GET_VARS['products_id'])) {
if (tep_session_is_registered('customer_id')) {
$check_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . (int)$customer_id . "' and global_product_notifications = '1'");
$check = tep_db_fetch_array($check_query);
if ($check['count'] > 0) {
include(DIR_WS_BOXES . 'best_sellers.php');
} else {
include(DIR_WS_BOXES . 'product_notifications.php');
}
} else {
include(DIR_WS_BOXES . 'product_notifications.php');
}
} else {
include(DIR_WS_BOXES . 'best_sellers.php');
}
if (isset($HTTP_GET_VARS['products_id'])) {
if (basename($PHP_SELF) != FILENAME_TELL_A_FRIEND) include(DIR_WS_BOXES . 'tell_a_friend.php');
} else {
include(DIR_WS_BOXES . 'specials.php');
}
require(DIR_WS_BOXES . 'reviews.php');
if ((USE_CACHE == 'true') && empty($SID)) {
echo tep_cache_manufacturers_box();
} else {
include(DIR_WS_BOXES . 'manufacturers.php');
}
require(DIR_WS_BOXES . 'search.php');
if (substr(basename($PHP_SELF), 0, 8) != 'checkout') {
/*include(DIR_WS_BOXES . 'languages.php');*/
include(DIR_WS_BOXES . 'currencies.php');
}
?>
The 33rd line is this:
$check_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . (int)$customer_id . "' and global_product_notifications = '1'");
My shop works fine (without Buil Computer option) before pressing the INSTALL button in Pc Creator in Admin, but as soon as I hit INSTALL in Build Computer in Admin the site goes crazy and remains this way even after I press UNINSTALL.