Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

amirand926

Pioneers
  • Posts

    13
  • Joined

  • Last visited

Profile Information

  • Real Name
    Ammon
  • Gender
    Male

amirand926's Achievements

  1. The only file that I have previously mentioned that is in the ../admin/ directory is the configure.php, which is correct. However, I did check ../admin/includes/ directory: There is a column_left.php and NOT a comumn_right.php. I am not sure what that means exactly since I am unfamiliar with OSC structure, let alone the way the previous user set this up. ../catalog/includes/ directory: there is both a column_left.php, column_left2.php and a column_right.php. There is no catalog.php (that I have prevously mentioned), just a catalog directory. I did a serach for a catalog.php and there is one in /public_html/admin/includes/boxes/catalog.php. Thanks a lot for your help and if you want to look elsewhere to solve this I will try. And you said that if they are setup incorrectly than no matter what I do will work... do you mean as far as defining the DB_SERVER in another location (e.g. application_top.php)?
  2. well, because the link we go to is ../admin/, where we are asked to log in, i checked the index.php in that directory which just loads/calls the ../catalog/default.php (post #20) that I listed previously. the first thing that the default.php does is require('includes/application_top.php'); which is also posted previously (post #9).
  3. the /admin/index.php calls the /catalog/default.php file which is listed below: <?php /* $Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); // the following cPath references come from application_top.php $category_depth = 'top'; if (isset($cPath) && tep_not_null($cPath)) { $categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $cateqories_products = tep_db_fetch_array($categories_products_query); if ($cateqories_products['total'] > 0) { $category_depth = 'products'; // display products } else { $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'"); $category_parent = tep_db_fetch_array($category_parent_query); if ($category_parent['total'] > 0) { $category_depth = 'nested'; // navigate through the categories } else { $category_depth = 'products'; // category has no products, but display the 'no products' message } } } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title>Thermal Transfer Labels, Direct Thermal Labels, Thermal Transfer Ribbons, Laser Labels</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" src="https://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js" type="text/javascript"></script> <link rel="stylesheet" type="text/css" href="menu.css"> <!--[if IE]> <link rel="stylesheet" type="text/css" href="menu_ie.css"> <![endif]--> <script language="JavaScript"> <!-- function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc; } function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}} } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document); if(!x && d.getElementById) x=d.getElementById(n); return x; } //--> </script> <script language="JavaScript" type="text/javascript"> $(document).ready(function(){ $("#navmenu-h li,#navmenu-v li").hover( function() { $(this).addClass("iehover"); }, function() { $(this).removeClass("iehover"); } ); }); </script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" onLoad="MM_preloadImages('nav/elec_f2.gif','../images/n_direct_transfer_labels_f2.gif','nav/pinfeed_f2.gif','nav/colored_f2.gif','../images/n_direct_thermal_labels_f2.gif','nav/nav_r4_c1_f2.gif','../images/n_thermal_ribbons_f2.gif','../images/n_thermal_label_printers_f2.gif','nav/nav_r9_c1_f2.gif','nav/nav_r10_c1_f2.gif','nav/nav_r11_c1_f2.gif','../images/n_photo_id_ribbons_f2.gif','nav/nav_r13_c1_f2.gif','nav/nav_r16_c1_f2.gif','nav/nav_r19_c1_f2.gif','nav/nav_r20_c1_f2.gif')"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="1%" valign="top"> <!-- Left Menu Start //--> <?php include("leftmenu.inc.php"); ?> <!-- Left Menu End //--> <table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> </table> <!-- left_navigation_eof //--> </td> <!-- body_text //--> <?php if ($category_depth == 'nested') { $category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . $current_category_id . "' and cd.categories_id = '" . $current_category_id . "' and cd.language_id = '" . $languages_id . "'"); $category = tep_db_fetch_array($category_query); ?> <td width="21%" valign="top"> </td> <?php } elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) { // create column list $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME, 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER, 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE, 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT, 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE, 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW); asort($define_list); $column_list = array(); reset($define_list); while (list($key, $value) = each($define_list)) { if ($value > 0) $column_list[] = $key; } $select_column_list = ''; for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { switch ($column_list[$i]) { case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model, '; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name, '; break; case 'PRODUCT_LIST_MANUFACTURER': $select_column_list .= 'm.manufacturers_name, '; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity, '; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image, '; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight, '; break; } } // show the products of a specified manufacturer if (isset($HTTP_GET_VARS['manufacturers_id'])) { if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only a specific category $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, 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, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on (p.products_id = s.products_id) 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_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, 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, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on (p.products_id = s.products_id) 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_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, 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, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on (p.products_id = s.products_id) 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_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id) left join " . TABLE_SPECIALS . " s on (p.products_id = s.products_id), " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } } //if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) { 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); $listing_sql .= ' order by '; switch ($column_list[$sort_col-1]) { case 'PRODUCT_LIST_MODEL': $listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $listing_sql .= "pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } ?> <td width="49%" valign="top"> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <form> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <?php // optional Product List Filter if (PRODUCT_LIST_FILTER > 0) { if (isset($HTTP_GET_VARS['manufacturers_id'])) { $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name"; } else { $filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name"; } $filterlist_query = tep_db_query($filterlist_sql); if (tep_db_num_rows($filterlist_query) > 1) { echo ' <td align="center" class="main">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' '; if (isset($HTTP_GET_VARS['manufacturers_id'])) { echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']); $options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES)); } else { echo tep_draw_hidden_field('cPath', $cPath); $options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS)); } echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']); while ($filterlist = tep_db_fetch_array($filterlist_query)) { $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']); } echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"'); echo '</form></td>' . "\n"; } } // Get the right image for the top-right $image = DIR_WS_IMAGES . 'table_background_list.gif'; if (isset($HTTP_GET_VARS['manufacturers_id'])) { $image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"); $image = tep_db_fetch_array($image); $image = $image['manufacturers_image']; } elseif ($current_category_id) { $image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $image = tep_db_fetch_array($image); $image = $image['categories_image']; } ?> <td align="right"><?php echo tep_image(DIR_WS_IMAGES . $image, HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </form> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td> <?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?> </td> </tr> </table> </td> <?php } else { // default page ?> <td width="28%" valign="top"> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="main"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td> <?php include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFINE_MAINPAGE); ?> </td> </tr> <tr> <td> <table width="100%" border="0" cellspacing="0" cellpadding="5"> <tr> <td class="main"><?php echo tep_customer_greeting(); ?></td> </tr> <tr> <td><font size="2" face="Arial, Helvetica, sans-serif">Par Label Company is a 100% total customer satisfaction oriented company. We realize that our customers are the reason that we are in business and we will strive continually to meet their needs, expectations, and gain their loyalty. </font> <p><font size="2" face="Arial, Helvetica, sans-serif">We provide our customers with quality products at the most competitive prices. Most orders for stock products ship the same day. We can make virtually any size label that you need. There are thousands of label sizes to choose from and ribbons for all thermal printers. Labels can be produced in several types of materials such as paper, for general purpose labeling and synthetic materials such as polyester and polypropylene for electronics and more durable labeling. Need pre-printed labels with your logo or other information? We do that too. </font></p> </td> </tr> </table> </td> </tr> </table></td> </tr> <tr> <td><br> </td> </tr> <?php include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS); ?> </table></td> </tr> </table></td> <?php } ?> <!-- body_text_eof //--> <td width="1%" 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> </table> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  4. Here is an attached file of the login box screen shot as well.
  5. Yeah i figured the same with the other .htaccess files, thanks. I have the login bookmarked so when I click it here is what happens: not sure how otinsert image here.. you can check the link though http://www.parlabel.com/admin/
  6. I opened the page in Firefox, instead of Chrome, while it was disabled to avoid any cache issues.
  7. with the .htacces disabled it did the same thing. the /admin/ page pops open a login box, i log in, and cannot connect to database message
  8. I should also note that there are a bunch of other RENAMED .htaccess files in the /admin folder: .htaccess.bk (Last modified Nov 8 2014) .htaccess.bk.CT_original_bak Last modified Sept 8 2013) .htaccess.CT_Original_bak Last modified Oct 4 2013) They seem to be backups created by others in the past. I included last modified dates. In /catalog/ there is also a .htaccess.bak. Seems the previous 'admin' was all about backups! wow. I was not involved with the transfer to new host goDaddy but I do know that it was on the date of Nov 7/8 which is the date of one of the backups. The .htaccess.bk (date of host change) is: #AuthUserFile /home/parlab/public_html/admin/.htpasswd #AuthGroupFile /dev/null #AuthName "Protected Area" #AuthType Basic #<Limit GET POST> #require valid-user #</Limit> # Enable PHP 5.4 support for .php files on this domain only AddType application/x-httpd-php54 .php The CURRENT .htaccess is : AuthUserFile /home/parlab/public_html/admin/.htpasswd AuthGroupFile /dev/null AuthName "Protected Area" AuthType Basic <Limit GET POST> require valid-user </Limit> What sucks about all this the most is that this whole site is going to be changed to Wordpress/Woocommerce in a few weeks and this is all just to make accessible by my client for changes until then. Thanks again for the help and I hope we are somewhat closer to narrowing it down.
  9. Hey Jack, I temporarily renamed the file .htaccess file and it had no effect. I have not changed the application_top file either bc I think that is a bad idea as well.
  10. Hey Jack, Sorry if I was unclear. The problem is that when I try to access the /admin/, I do get the login pop up and enter the correct username and password stored in both of the configure.php files correctly. However, I just get "Unable to connect to database server!". That's really all there is to it right now. (The previous mixup was happening because I had messsed up the password in the files so the 'popup to login' kept appearing for me to re enter the pw. This did however help me understand that it IS seeing my correct passwords and IS logging in now but is not connecting to the database at some point thereafter) I was looking around and found somewhere where someone said to hardcode "define('DB_SERVER', 'localhost');" in the /admin/includes/application_top.php and also to check the Register Globals bit (no idea where that is). Keep in mind that there are TWO application_top.php's just like configure.php's. this might matter only because they might have been/be using a version of OSC old enough for it to matter Thanks again guys. Sorry for the confusion. (relevant sections highlighted in red. Successful login shows the die() msg in red on bottom) Here is the entire /admin/includes/application_top.php. <?php /* $Id: application_top.php,v 1.155 2003/02/17 16:54:11 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ date_default_timezone_set('America/Denver'); $register_global_variables = array(); include('includes/functions/register_globals.php'); if (!isset($HTTP_GET_VARS)){ $HTTP_SERVER_VARS = &$_SERVER; $PHP_SELF = $_SERVER['PHP_SELF']; $HTTP_GET_VARS = &$_GET; $HTTP_POST_VARS = &$_POST; $HTTP_ENV_VARS = &$_ENV; $HTTP_COOKIE_VARS = &$_COOKIE; $_REQUEST = array_merge($_GET, $_POST, $_COOKIE); } my_register_globals('egpcs'); // Start the clock for the page parse time log define('PAGE_PARSE_START_TIME', microtime()); // Set the level of error reporting error_reporting(E_ALL & ~E_NOTICE); // Check if register_globals is enabled. // Since this is a temporary measure this message is hardcoded. The requirement will be removed before 2.2 is finalized. /* if (function_exists('ini_get')) { ini_get('register_globals') or exit('FATAL ERROR: register_globals is disabled in php.ini, please enable it!'); } */ if (function_exists('ini_get') && (ini_get('register_globals') == false) && (PHP_VERSION < 4.3) ) { exit('Server Requirement Error: register_globals is disabled in your PHP configuration. This can be enabled in your php.ini configuration file or in the .htaccess file in your catalog directory. Please use PHP 4.3+ if register_globals cannot be enabled on the server.'); } // Disable use_trans_sid as tep_href_link() does this manually if (function_exists('ini_set')) { ini_set('session.use_trans_sid', 0); } // Set the local configuration parameters - mainly for developers if (file_exists('includes/local/configure.php')) include('includes/local/configure.php'); // Include application configuration parameters require('includes/configure.php'); // Define the project version define('PROJECT_VERSION', 'Preview Release 2.2-MS1'); // Used in the "Backup Manager" to compress backups define('LOCAL_EXE_GZIP', '/usr/bin/gzip'); define('LOCAL_EXE_GUNZIP', '/usr/bin/gunzip'); define('LOCAL_EXE_ZIP', '/usr/local/bin/zip'); define('LOCAL_EXE_UNZIP', '/usr/local/bin/unzip'); // define the filenames used in the project define('FILENAME_BACKUP', 'backup.php'); define('FILENAME_BANNER_MANAGER', 'banner_manager.php'); define('FILENAME_BANNER_STATISTICS', 'banner_statistics.php'); define('FILENAME_CACHE', 'cache.php'); define('FILENAME_CATALOG_ACCOUNT_HISTORY_INFO', 'account_history_info.php'); define('FILENAME_CATEGORIES', 'categories.php'); define('FILENAME_CONFIGURATION', 'configuration.php'); define('FILENAME_COUNTRIES', 'countries.php'); define('FILENAME_CURRENCIES', 'currencies.php'); define('FILENAME_CUSTOMERS', 'customers.php'); define('FILENAME_DEFAULT', 'index.php'); define('FILENAME_DEFINE_LANGUAGE', 'define_language.php'); define('FILENAME_FILE_MANAGER', 'file_manager.php'); define('FILENAME_GEO_ZONES', 'geo_zones.php'); define('FILENAME_LANGUAGES', 'languages.php'); define('FILENAME_MAIL', 'mail.php'); define('FILENAME_MANUFACTURERS', 'manufacturers.php'); define('FILENAME_MODULES', 'modules.php'); define('FILENAME_NEWSLETTERS', 'newsletters.php'); define('FILENAME_ORDERS', 'orders.php'); define('FILENAME_ORDERS_INVOICE', 'invoice.php'); define('FILENAME_ORDERS_PACKINGSLIP', 'packingslip.php'); define('FILENAME_ORDERS_STATUS', 'orders_status.php'); define('FILENAME_POPUP_IMAGE', 'popup_image.php'); define('FILENAME_PRODUCTS_ATTRIBUTES', 'products_attributes.php'); define('FILENAME_PRODUCTS_EXPECTED', 'products_expected.php'); define('FILENAME_REVIEWS', 'reviews.php'); define('FILENAME_SERVER_INFO', 'server_info.php'); define('FILENAME_SHIPPING_MODULES', 'shipping_modules.php'); define('FILENAME_SPECIALS', 'specials.php'); define('FILENAME_STATS_CUSTOMERS', 'stats_customers.php'); define('FILENAME_STATS_PRODUCTS_PURCHASED', 'stats_products_purchased.php'); define('FILENAME_STATS_PRODUCTS_VIEWED', 'stats_products_viewed.php'); define('FILENAME_TAX_CLASSES', 'tax_classes.php'); define('FILENAME_TAX_RATES', 'tax_rates.php'); define('FILENAME_WHOS_ONLINE', 'whos_online.php'); define('FILENAME_ZONES', 'zones.php'); // define_mainpage define('FILENAME_DEFINE_MAINPAGE', 'define_mainpage.php'); // define_mainpage define('FILENAME_MENU', 'menu.php'); define('TABLE_MENU', 'menu'); // define the database table names used in the project define('TABLE_ADDRESS_BOOK', 'address_book'); define('TABLE_ADDRESS_FORMAT', 'address_format'); 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_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_NEWSLETTERS', 'newsletters'); 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_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'); // customization for the design layout define('BOX_WIDTH', 125); // how wide the boxes should be in pixels (default: 125) // Define how do we update currency exchange rates // Possible values are 'oanda' 'xe' or '' define('CURRENCY_SERVER_PRIMARY', 'oanda'); define('CURRENCY_SERVER_BACKUP', 'xe'); // include the database functions require(DIR_WS_FUNCTIONS . 'database.php'); // make a connection to the database... now tep_db_connect() or die('Unable to connect to database server!'); // set application wide parameters $configuration_query = tep_db_query('select configuration_key as cfgKey, configuration_value as cfgValue from ' . TABLE_CONFIGURATION . ''); while ($configuration = tep_db_fetch_array($configuration_query)) { define($configuration['cfgKey'], $configuration['cfgValue']); } // initialize the logger class require(DIR_WS_CLASSES . 'logger.php'); // include shopping cart class require(DIR_WS_CLASSES . 'shopping_cart.php'); // some code to solve compatibility issues require(DIR_WS_FUNCTIONS . 'compatibility.php'); // check to see if php implemented session management functions - if not, include php3/php4 compatible session class if (!function_exists('session_start')) { define('PHP_SESSION_NAME', 'sID'); define('PHP_SESSION_SAVE_PATH', '/tmp'); include(DIR_WS_CLASSES . 'sessions.php'); } // define how the session functions will be used require(DIR_WS_FUNCTIONS . 'sessions.php'); tep_session_name('osCAdminsID'); // lets start our session tep_session_start(); if (function_exists('session_set_cookie_params')) { session_set_cookie_params(0, substr(DIR_WS_ADMIN, 0, -1)); } my_register_globals('x'); // language require(DIR_WS_FUNCTIONS . 'languages.php'); if ( (!$language) || ($HTTP_GET_VARS['language']) ) { if (!$language) { tep_session_register('language'); tep_session_register('languages_id'); } $language = tep_get_languages_directory($HTTP_GET_VARS['language']); if (!$language) $language = tep_get_languages_directory(DEFAULT_LANGUAGE); } // include the language translations require(DIR_WS_LANGUAGES . $language . '.php'); //$current_page = split('\?', basename($PHP_SELF)); $current_page = $current_page[0]; // for BadBlue(Win32) webserver compatibility $current_page = explode('\?', basename($PHP_SELF)); $current_page = $current_page[0]; // for BadBlue(Win32) webserver compatibility if (file_exists(DIR_WS_LANGUAGES . $language . '/' . $current_page)) { include(DIR_WS_LANGUAGES . $language . '/' . $current_page); } // define our general functions used application-wide require(DIR_WS_FUNCTIONS . 'general.php'); require(DIR_WS_FUNCTIONS . 'html_output.php'); // define our localization functions require(DIR_WS_FUNCTIONS . 'localization.php'); // setup our boxes require(DIR_WS_CLASSES . 'table_block.php'); require(DIR_WS_CLASSES . 'box.php'); // initialize the message stack for output messages require(DIR_WS_CLASSES . 'message_stack.php'); $messageStack = new messageStack; // split-page-results require(DIR_WS_CLASSES . 'split_page_results.php'); // entry/item info classes require(DIR_WS_CLASSES . 'object_info.php'); // email classes require(DIR_WS_CLASSES . 'mime.php'); require(DIR_WS_CLASSES . 'email.php'); // calculate category path $cPath = $HTTP_GET_VARS['cPath']; if (strlen($cPath) > 0) { $cPath_array = explode('_', $cPath); $current_category_id = $cPath_array[(sizeof($cPath_array)-1)]; } else { $current_category_id = 0; } // default open navigation box if (!tep_session_is_registered('selected_box')) { tep_session_register('selected_box'); $selected_box = 'configuration'; } if ($HTTP_GET_VARS['selected_box']) { $selected_box = $HTTP_GET_VARS['selected_box']; } //print '\n\nselected box after:: '.$selected_box; exit; // the following cache blocks are used in the Tools->Cache section // ('language' in the filename is automatically replaced by available languages) $cache_blocks = array(array('title' => TEXT_CACHE_CATEGORIES, 'code' => 'categories', 'file' => 'categories_box-language.cache', 'multiple' => true), array('title' => TEXT_CACHE_MANUFACTURERS, 'code' => 'manufacturers', 'file' => 'manufacturers_box-language.cache', 'multiple' => true), array('title' => TEXT_CACHE_ALSO_PURCHASED, 'code' => 'also_purchased', 'file' => 'also_purchased-language.cache', 'multiple' => true) ); // check if a default currency is set if (!defined('DEFAULT_CURRENCY')) { $messageStack->add(ERROR_NO_DEFAULT_CURRENCY_DEFINED, 'error'); } // check if a default language is set if (!defined('DEFAULT_LANGUAGE')) { $messageStack->add(ERROR_NO_DEFAULT_LANGUAGE_DEFINED, 'error'); } ?>
  11. Hey Geoffrey, Thanks for your reply. However, I did take a look at what you had mentioned but along that path it does say to enter 'localhost' since the server is on Linux (cPanel). So for our connection, localhost is correct. Again, thanks for your insight and if you can find another hole please let me know. The only thing I can think of at this point is that there might be some kind of permissions error somewhere or the PATH to the db is wrong, such as in the DOCUMENT_ROOT. I believe the 'settings' are all correct. I've eliminated the user and pw as a problem so it is clearly just the db communication somewhere long the path after login. Thanks again, :) A
  12. Hey Jack, Thanks for your response. I checked the .htaccess and the path is correct. I even went so far as to renter recreate the user/password to same info to make sure. But since I am NOT being asked for the password again it is obviously correct. The issue is just the database connection. I am not sure I want to mess with the .htaccess file during this time of day since the site is live but if you still think I should check into it, I will later on tonight. Just FYI. I included some info below. I saw that the GoDaddy made a backup of the file before they attempted a fix while speaking with my client and I see in the original admin/includes/configure.php that DB_SERVER is blank and the database is 'catalog'. Weird. Thanks in advance! -------------------------------------------------------- FROM SITE BEFORE HOST CHANGE: public_html/admin/includes/configure-ORIGINAL.php: -------------------------------------------------------- define('DB_SERVER', ''); define('DB_SERVER_USERNAME', 'mysql'); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', 'catalog'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', ''); Here is the content of the files CURRENTLY USED. I removed the username, password which I assure you are the same in each file. -------------------------------------------------------- public_html/admin/includes/configure.php: -------------------------------------------------------- <?php /* $Id: configure.php,v 1.13 2002/07/20 09:08:31 project3000 Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License */ // define our webserver variables // FS = Filesystem (physical) // WS = Webserver (virtual) define('HTTP_SERVER', ''); // eg, http://localhost or - https://localhost should not be NULL for productive servers define('HTTP_CATALOG_SERVER', ''); define('HTTPS_CATALOG_SERVER', ''); define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you, replace with your local path. (eg, /usr/local/apache/htdocs) define('DIR_WS_ADMIN', '/admin/'); define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN); define('DIR_WS_CATALOG', '/catalog/'); define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); // define our database connection define('DB_SERVER', 'localhost'); define('DB_SERVER_USERNAME', 'REMOVED FOR THIS POST'); define('DB_SERVER_PASSWORD', 'REMOVED FOR THIS POST'); define('DB_DATABASE', 'parlab'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', ''); -------------------------------------------------------- public_html/catalog/includes/configure.php: -------------------------------------------------------- <?php /* $Id: configure.php,v 1.13 2003/02/10 22:30:51 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', ''); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', ''); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', false); // secure webserver for checkout procedure? define('DIR_WS_CATALOG', '/catalog/'); // absolute path required define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/'); define('DIR_FS_DOCUMENT_ROOT', $HTTP_SERVER_VARS['/home/parlab/public_html/catalog/']); //define('DIR_FS_DOCUMENT_ROOT', $HTTP_SERVER_VARS['/home/parlab/public_html/']); // where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you, replace with your local path. (eg, /usr/local/apache/htdocs) define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); // define our database connection define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', 'REMOVED FOR THIS POST'); define('DB_SERVER_PASSWORD', 'REMOVED FOR THIS POST'); define('DB_DATABASE', 'parlab'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql' ?>
  13. I have this problem after a new client of mine changed their host. I have checked the two paths mentioned by webpark and they have the same info. The login doesnt even seem to accept the new user I added onto the database. Now when I try to log in, it just pops up again implying the password is wrong where before it would go through and tell me it could not connect to the database. VERY confusing. Any help would be appreciated. Thanks!!
×
×
  • Create New...