Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

rjckicks1

Pioneers
  • Posts

    72
  • Joined

  • Last visited

Everything posted by rjckicks1

  1. Addition: I tried using the updated database (ran sql queries to update it from 2.2 rca2 to 2.3) and tried the module on a fresh install - getting the same issue. The login box just gets stuck. So I am thinking now maybe it has something to do with the database? Any advice is much appreciated.
  2. I am trying to use this module and would appreciate a step in the right direction to get it working properly. We want to use this module over the original one for 2.2 that it is based off of, because this module has guest checkout functionality. So because of this - we have tried setting this up on a 2.2 rca2 installation. For the most part it seems to be functioning, except for one issue. When we try using the login feature it just gets stuck on the loading gif. If we enter incorrect login details it will come back with the error like it should, but if correct details are entered it gets stuck at the loading gif and nothing happens. I do not see any errors and am not sure how to figure out why it is doing this. I have attached a screenshot of where it gets stuck. Highly appreciate any help.
  3. Hi spooks, Like I said it was hard to manipulate this problem for me also. It's my client that's saying it's happening on her computer, and when I suggested it may be her computer she had several friends try it on their computers and she claimed it happened on all her friends computers also. I was able to get someone I know to try it out and they said the problem happened on their computer. Weird huh? Not sure what to do about this.
  4. Hi spooks, The issue happens when going to the main page for the first time, without navigating anywhere. You pick the make, year, and then the model (last field) will not load, it will say loading or whatever, so I'm pretty sure it does not have to do with the navigation on top of that. I'm thinking maybe preloading the AJAX or something might possibly fix it? It happens only the first time, but if users navigate to other pages and come back, etc, it will not happen again, until they close out their browser and go to the site, then it will happen again.
  5. Hi Spooky, Thanks for the advise, and actually I setup your contribution on another clients site before and it's working great :) I was able to get this working actually. I applied the database.php updated in the 1.2 version of this image module and that fixed the problem. Thanks for your help!
  6. Hi Spooky, I'm not sure where it is directly linking like you are saying it is, I looked through the code for the module, and also posted it here in my last past. Do you think anywhere needs to be changed? If you close your browser fully, open the website, the first time you try to use the menu it should have the problem. If you navigate to another page the problem wont happen anymore. It's hard for me to duplicate the problem also, but my client says it happens every time, and I've asked other people to do it and they have been able to, and I had was able to get it to do it once or twice. The problem being after choosing the second dropdown ( year ) it will not load the third dropdown items ( models ).
  7. Bump Can anyone help me with this?? I'd really appreciate the help. I think it might be fixed if I preload the scripts or something but I'm not sure how I should do that properly? I think this might fix it because the problem only happen the first time the user visits the page. If they navigate to another page and come back the problem isn't there. But if they close and re-open their browser it will happen the first time again.
  8. Bump Is anyone able to help me out with this? I'd think I'm not the only one that is using this mod on a php5 / mysql5 setting? I'm guessing this is the reason for my problem .. Thanks!
  9. Bump Also, I should note this error has started happening after moving the osCommerce installation to a new server. The old server and new server PHP and MYSQL configuration is as follows - Old Server - PHP 4.3.9, MYSQL 4.1.22 New Server - PHP 5.1.6 , MYSQL 5.0.45 Is this images contribution not compatible with PHP 5 or MYSQL 5? Thanks in advance for any help!
  10. Hi Guys, I'm getting the following error when trying to add an extra image to a product in the admin - 1065 - Query was empty [TEP STOP] This error pops up after clicking the Update button on the preview page. I checked my server error log and it has the following information - [sat Oct 24 13:58:27 2009] [error] [client 43.244.104.24] PHP Warning: require(includes/application_top.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /var/www/vhosts/acgears.jp/httpdocs/images/index.php on line 4, referer: http://acgears.jp/1207sire/categories.php?cPath=200&pID=2644&action=new_product_preview [sat Oct 24 13:58:27 2009] [error] [client 43.244.104.24] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/application_top.php' (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/vhosts/acgears.jp/httpdocs/images/index.php on line 4, referer: http://acgears.jp/1207sire/categories.php?cPath=200&pID=2644&action=new_product_preview My index.php code is as follows - <?php /* index rebuilt by almighty 2006/05 */ ?> <?php 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); //reset($lng->catalog_languages); while (list($key, $value) = each($lng->catalog_languages)) {/* echo '<link rel="alternate" type="application/rss+xml" title="' . STORE_NAME . ' ' . BOX_INFORMATION_RSS . ' ' . $value['name'] . '" href="' . FILENAME_RSS . '?language=' . $key . '" />'; */} if ($category_depth == 'nested') { require(DIR_WS_INCLUDES . 'header.php'); require(DIR_WS_INCLUDES . 'header_nav.php'); require(DIR_WS_INCLUDES . 'header_breadcrumbs.php'); ?> <div id="pageContent"> <div id="contentLeft"> <?php include(DIR_WS_BOXES . 'categories.php'); ?> </div> <div id="contentCenterx"> <div id="productDescriptionx"> <div id="altContentx"> <?php /* <?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); echo '<h1>'; for($i=0; $i<sizeof($cPath_array); $i++) { $category_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . $cPath_array[$i] . "' and language_id='" . $languages_id . "'"); $category = tep_db_fetch_array($category_query); echo $category['categories_name'] . ''; } ?></h1><br><hr><br> <table border="0" width="560" cellspacing="0" cellpadding="2"> <tr><?php $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" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image($categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></td>'; if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) { echo ' </tr>'; echo ' <tr>'; } } // needed for the new products module shown below $new_products_category_id = $current_category_id; ?> </tr> </table> <br><br> */ ?> <?php include(DIR_WS_BOXES . 'featured_products.php'); ?> </div> </div> </div> <?php } elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) { // create column list $define_list = array('PRODUCT_LIST_REVIEW' => '1', 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE, //bof column product listing with attributes 'PRODUCT_LIST_MULTIPLE' => PRODUCT_LIST_MULTIPLE, 'PRODUCT_LIST_BUY_NOW_MULTIPLE' => PRODUCT_LIST_BUY_NOW_MULTIPLE, //eof column product listing with attributes 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT, 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE, 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER, 'PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME, 'PRODUCT_LIST_30SALES' => PRODUCT_LIST_30SALES, '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++) { if ( ($column_list[$col] == 'PRODUCT_LIST_BUY_NOW') || ($column_list[$col] == 'PRODUCT_LIST_PRICE') ) { continue; } 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_30SALES': $select_column_list .= 'p.products_recent_sales, '; 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; case 'PRODUCT_LIST_REVIEW': $select_column_list .= '(avg(r.reviews_rating) / 5 * 10) as average_rating, '; 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_date_added, p.products_id, p.products_recent_sales, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_map, 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 left join " . TABLE_REVIEWS . " r on p.products_id=r.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'] . "' group by p.products_id"; if (tep_not_null($customer_group_id) && (int)$customer_group_id > 0) { $listing_sql = "select " . $select_column_list . " p.products_date_added, p.products_id, p.manufacturers_id, p.products_price, g.customers_group_id, g.customers_group_price, p.products_tax_class_id, p.products_map, 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_GROUPS . " g," . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p2c.products_id = s.products_id left join " . TABLE_REVIEWS . " r on p.products_id=r.products_id where p.products_status = '1' and p.products_id = g.products_id 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 g.customers_group_id = '" . (int)$customer_group_id . "' and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' group by p.products_id"; }else{ $listing_sql = "select " . $select_column_list . " p.products_date_added, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_map, 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 p2c.products_id = s.products_id left join " . TABLE_REVIEWS . " r on p.products_id=r.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'] . "' group by p.products_id"; } } else { // We show them all if (tep_not_null($customer_group_id) && (int)$customer_group_id > 0) { $listing_sql = "select " . $select_column_list . " p.products_date_added, p.products_id, p.manufacturers_id, p.products_price, g.customers_group_id, g.customers_group_price, p.products_tax_class_id, p.products_map, 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_GROUPS . " g," . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p2c.products_id = s.products_id left join " . TABLE_REVIEWS . " r on p.products_id=r.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = g.products_id and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' group by p.products_id"; //$listing_sql = "select " . $select_column_list . " p.products_date_added, p.products_id, p.products_recent_sales, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_map, 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 left join " . TABLE_REVIEWS . " r on p.products_id=r.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'] . "' group by p.products_id"; }else{ $listing_sql = "select " . $select_column_list . " p.products_date_added, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_map, 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 p2c.products_id = s.products_id left join " . TABLE_REVIEWS . " r on p.products_id=r.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'] . "' group by p.products_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 if (tep_not_null($customer_group_id) && (int)$customer_group_id > 0) { //$listing_sql = "select " . $select_column_list . " p.products_date_added, p.products_id, p.products_recent_sales, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_map, 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 left join " . TABLE_REVIEWS . " r on p.products_id=r.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 . "' group by p.products_id"; $listing_sql = "select " . $select_column_list . " p.products_date_added, p.products_id, p.manufacturers_id, p.products_price, g.customers_group_id, g.customers_group_price,p.products_tax_class_id, p.products_map, 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_GROUPS . " g," . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p2c.products_id = s.products_id left join " . TABLE_REVIEWS . " r on p.products_id=r.products_id where p.products_status = '1' and p.products_id = g.products_id 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 g.customers_group_id = '" . (int)$customer_group_id . "' and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "' group by p.products_id"; }else{ $listing_sql = "select " . $select_column_list . " p.products_date_added, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_map, 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 p2c.products_id = s.products_id left join " . TABLE_REVIEWS . " r on p.products_id=r.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 . "' group by p.products_id"; } } else { // We show them all if (tep_not_null($customer_group_id) && (int)$customer_group_id > 0) { $listing_sql = "select " . $select_column_list . " p.products_date_added, p.products_id, p.manufacturers_id, p.products_price, g.customers_group_id, g.customers_group_price, p.products_tax_class_id, p.products_map, 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_GROUPS . " g," . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_REVIEWS . " r on p.products_id=r.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p2c.products_id = s.products_id where p.products_id = g.products_id and p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and g.customers_group_id = '" . (int)$customer_group_id . "' and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "' group by p.products_id"; //$listing_sql = "select " . $select_column_list . " p.products_date_added, p.products_id, p.products_recent_sales, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_map, 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_REVIEWS . " r on p.products_id=r.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id 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 . "' group by p.products_id"; }else{ $listing_sql = "select " . $select_column_list . " p.products_date_added, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_map, 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_REVIEWS . " r on p.products_id=r.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p2c.products_id = s.products_id 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 . "' group by p.products_id"; } } } if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { if ( ($column_list[$col] == 'PRODUCT_LIST_BUY_NOW') || ($column_list[$col] == 'PRODUCT_LIST_PRICE') ) { continue; } if ($column_list[$i] == 'PRODUCT_LIST_30SALES') { $HTTP_GET_VARS['sort'] = $i+1 . 'a'; $listing_sql .= " order by p.products_recent_sales desc, pd.products_name desc"; 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_30SALES': $listing_sql .= "p.products_recent_sales desc, pd.products_name 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; case 'PRODUCT_LIST_REVIEW': $listing_sql .= "average_rating " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } require(DIR_WS_INCLUDES . 'header.php'); require(DIR_WS_INCLUDES . 'header_nav.php'); require(DIR_WS_INCLUDES . 'header_breadcrumbs.php'); ?> <div id="pageContent"> <div id="contentLeft"> <?php include(DIR_WS_BOXES . 'categories.php'); ?> </div> <div id="contentCenter1"> <div id="productDescriptionLong"> <div id="altContent1"><?php for($i=0; $i<sizeof($cPath_array); $i++) { $category_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . $cPath_array[$i] . "' and language_id='" . $languages_id . "'"); $category = tep_db_fetch_array($category_query); $heading_title = $category['categories_name']; } echo '<table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr><td width=270 align="left">'; $image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $image = tep_db_fetch_array($image); $catimage = $image['categories_image']; // $imagename=$image['categories_name']; //echo '<td align="left">'; echo tep_image($catimage); //echo tep_image('thumbnailer.php?&resize_width=80&img_src_name='.$image, $imagename); echo '</td>' . "\n"; ?></td> <td align="right"> <?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="left" width="130">' . 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"; } // Additional Products Sort /* echo '<td align="right" width=150>' . tep_draw_form('sort', FILENAME_DEFAULT, 'get') . 'Sort by: '; if (isset($HTTP_GET_VARS['manufacturers_id'])) { echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']); } else { echo tep_draw_hidden_field('cPath', $cPath); } $sort_list = array('5d' => 'Best Sellers', '1d' => 'Best Ratings', '3a' => 'Products Name A to Z', '3d' => 'Products Name Z to A', '4a' => 'Price Low to High', '4d' => 'Price High to Low'); foreach($sort_list as $id=>$text) { $sort_range[] = array('id' => $id, 'text' => $text); } echo tep_draw_pull_down_menu('sort', $sort_range, (isset($HTTP_GET_VARS['sort']) ? $HTTP_GET_VARS['sort'] : ''), 'onchange="this.form.submit()"'); echo tep_draw_hidden_field('filter_id', (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : '')); echo '</form></td>' . "\n";*/ $image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $image = tep_db_fetch_array($image); $catimage = $image['categories_image']; // $imagename=$image['categories_name']; /* echo '<td align="left" width=80>'; echo tep_image($catimage); //echo tep_image('thumbnailer.php?&resize_width=80&img_src_name='.$image, $imagename); echo '</td>' . "\n";*/ // End Additional Products Sort } // 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></tr> </table> <hr> <?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?> </div> </div> </div> <?php } else { // default page require(DIR_WS_INCLUDES . 'header.php'); require(DIR_WS_INCLUDES . 'header_nav.php'); ?> <div id="homePromo"> <table border=0 cellpadding=0 cellspacing=0 width=100%> <Tr> <Td valign=top rowspan=2 width=250><h1><?php echo INDX_CONTENT_WELCOME; ?></h1><br> <h2>Yes, you made it.<br><Br><?php echo INDX_CONTENT_ACG; ?><br><br /> <?php echo INDEX_CONTENT_NOW; ?> </h2><br> <center><hr size=1 width=90%></center> <?php include(DIR_WS_BOXES . 'newsletter.php'); ?> </td> <td valign="top" rowspan=2 align=right> <table width=100% border=0> <tr> <td colspan=2 align=right> <a href="http://www.geddem.com"><img src="images/audio_intro_start.jpg"></a> </td> </tr> <tr> <td align=right><a href="http://japan.acgears.com/category/MIMOBOTS.html"><img src="images/mimobot_front.jpg"></a> </td> <td align=right><a href="http://www.facebook.com/group.php?gid=7047413274" target="_blank"><img src="images/joinfacebook.gif"></a> </td> </tr> </table> </tr> <tr> <Td valign=middle> </td> </tr> </table> </div> <?php } require(DIR_WS_INCLUDES . 'application_bottom.php'); require(DIR_WS_INCLUDES . 'footer.php'); ?> <?php /* index rebuilt by almighty 2006/05 */ ?> Does anyone think they know what's up with this? The last coder who did work on the site did not make comments on the code used, so it took me forever to even track down what image module was being used, but I'm certain it's nicos extra images module now. Would appreciate any help!! Thanks
  11. Hi spooks, Here is the code for the box - <?php /* avsearch.php,v 0.01 2005/07/30 02:30:00 Iván Prieto Advanced Searches based on Ajax Contribution for Oscommerce v2.2 MS2 Using xajax v0.10 Beta 4 (http://xajax.sourceforge.net) Released under the GNU General Public License */ ?> <!-- search //--> <tr> <td> <?php //xajax will convert our php functions to javascript require("avsearch.common.php"); $xajax->printJavascript(); //In the next lines we say to the browser that write our //lists into the container ?> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_SEARCH); new infoBoxHeading($info_box_contents, false, false); $info_box_contents = array(); $info_box_contents[] = array('form' => tep_draw_form('quick_find', tep_href_link(FILENAME_ADVANCED_SEARCH_RESULT, '', 'NONSSL', false), 'get', 'id="quick_find"'), 'align' => 'center', 'text' => '<div id="container"></div><div id="searchInputs"></div>' . tep_draw_hidden_field('keywords', '', 'size="10" maxlength="30" style="width: ' . (BOX_WIDTH-30) . 'px" id="keywords"') . ' ' . tep_hide_session_id() . tep_draw_hidden_field('inc_subcat', '1') . tep_image_submit('button_quick_find.gif', BOX_HEADING_SEARCH, 'onclick="manage_search()"') ); new infoBox($info_box_contents); ?> <div align="center"><font face="verdana" size="1">If you do not see your bike listed, please <a href="/contact.php">click here</a> to contact us.</font><br> <script type="text/javascript" src="avsearch.javascript.php"></script> </div> </td> </tr> <!-- search_eof //--> The last code does not have to do with the search and it was not working before adding that so you can ignore that text. What do you think would be causing the problem explained in my last post? I don't see any direct links setup in the script. It's pulling categories, subcategories, etc from the website and displaying them. I did not set links anywhere. Thanks for your help.
  12. Bump Can anyone help out with these, please?? I'd appreciate any advise!! I really need to get this fixed! Thanks in advance!
  13. Hi, I've installed the contribution here - http://trickmounts.com/ I'm getting complaints that it seems the form will not work on the first time it is used. After choosing a make, the years are out of order, then if you choose a year it will not load a model number. If the user browses to a different page and comes back to the homepage it then works fine. If they re-close their browser, go back to the website for the first time without clicking anything else and try the menu again it will be broken again. Does anyone know why this is happening? I'd greatly appreciate any feedback! I'm using AV Search 1.1 , I tried version 1.0 also. Thanks!
  14. Hi, I'm trying to setup a store with a template that was purchased from template monster and the products have been set to downloadable and for some reason the download link is not showing up anywhere. I even tried installing the Super Download Shop attribute which is supposed to make the link viewable on the checkout success page also, but still nothing. All I see is the red text that says payment must be confirmed before download link shows, but the payment has been configured and the setting for Super Download Shop is set so when order status is "Payment Confirmed" the download link should be available. Does anyone know why the download link wouldn't be showing up? Any help would be greatly appreciated. Thanks
  15. Hi, I'm getting this same exact error but I am using the correct database, and yes the admin table is defined in database tables file. Any ideas? Here's the error - 1146 - Table 'databasename.admin' doesn't exist select admin_id as login_id, admin_groups_id as login_groups_id, admin_firstname as login_firstname, admin_email_address as login_email_address, admin_password as login_password, admin_modified as login_modified, admin_logdate as login_logdate, admin_lognum as login_lognum from admin where admin_email_address = 'admin@localhost'
  16. Update, please read this post instead - Hi, I'm experiencing a problem where only about half the time an order is made that the shopping cart will recive the IPN response from paypal and the order will update to "Pending", otherwise half of the orders stay at Preparing [PayPal IPN] and never update. Has anyone else experienced a similar problem where it only works sometimes? For example here are my last couple test orders - Order Added at 00:43:39 Status updated to Pending at 04:08:53 Order Added at 21:41:11 Status never updated Order Added at 01:05:43 Status updated to Pending at 01:16:58 As you can see for one order it took over 3 hours to update, then for the second order it never updated, then for the third it only took 10 minutes. This problem seems very strange to me and it's as if maybe there are some network problems with paypal contacting back to the shopping cart or something? I can't understand why it would work "sometimes" and sometimes it doesn't I appreciate your help, Thanks
  17. Hi, I'm experiencing a problem where only about half the time an order is made that the shopping cart will recive the IPN response from paypal and the order will update to "Pending", otherwise half of the orders stay at Preparing [PayPal IPN] and never update. Has anyone else experienced a similar problem where it only works sometimes? For example here are my last couple test orders - Order Added at 00:43:39 Status updated to Pending at 04:08:53 Order Added at 21:41:11 Status never updated Order Added at 01:05:43 Status updated to Pending at 01:16:58 As you can see for one order it took over 3 hours to update, then for the second order it never updated, then for the third it only took 10 minutes. This problem seems very strange to me and it's as if maybe there are some network problems with paypal contacting back to the shopping cart or something? I can't understand why it would work "sometimes" and sometimes it doesn't I appreciate your help, Thanks
  18. Hi, I'm having a problem with the PayPal IPN 2.3.3 module (osCommerce_PayPal_IPN_v2.3.3.zip). The other paypal module, PayPal_Shopping_Cart_IPN_v3.1.5, would never update the order status (it would never recieve the IPN information from PayPal), so I downloaded the 2.3.3 module, and it seems like it updates the order status only half the time. Sometimes it does and sometimes it doesn't. Does anyone know how I can even check why this happens? Why would it only recieve the information half the time?? I am on a godaddy hosting account, but the curl proxy is set correctly, obviously since it is recieving IPN information 'sometimes'. This is really frusterating. In TEST mode the order is never updated, so I can't run tests. I need to run live orders, and it seems that in LIVE mode the order status is only updated sometimes. I do have PayPal_Shopping_Cart_IPN_v3.1.5 installed, but it is not enabled. I do have osCommerce_PayPal_IPN_v2.3.3 installed and enabled. I don't care which module I use, but I currently have the 2.3.3 enabled since it sometimes works compared to IPN 3.1.5 which NEVER works (probably because there isn't even a way to enable proxy support on this module). Can someone please help me? I'm really frustrated with this problem. If the IPN information is not sent back from paypal to the website then paypal is no good. I appreciate your responses. Thanks.
  19. EDIT: Just noticed ppl are posting answer for this I will try their techniques and reply if it dosen't work. I just installed the latest google checkout but am having a problem with it. I can process orders just fine in sanbox and live mode, but after order is processed I go to the admin section under Orders to find the order and it does not show the order. So it is not fully processing the order I guess? I even tried using the original files that come with the download instead of editing my files, and that also produced the same result (nothing under orders in admin). If I don't enable the .ht basic access it will ask me for username and password to access responsehandler.php. If I turn that on then it will show the invalid message like it's supposed to. Ive tried both with and without ht basic access turned on, and also I've tried with my manually edited files and with all the files that came pre-made with the mod and either way it will not add the order to the admin orders page. Can anyone advise some help for this? Thanks
  20. Can no one answer my question? Anyone that uses this module should be able to answer this question? Thanks
  21. I fixed my problems. The problem was that the sort order for discount coupons had to go before the total, and that fixed it. For the tax it was becuase products were set to show price after tax, I had to set that to false so that products would show prices before tax.
  22. Hi, I installed version 5.19 and am having a problem with the order totaling up correctly. The VAT (tax) and also if a coupon code is applied the coupon code also is not added to the price. Here's an example here - It correctly applies the shipping charge, but not the tax (VAT) or the discount coupon. I tried seeing if this had anything to do with my files and I replaced my customized files with all the files included in the 5.19 CCGV package. It still did not calculate the order total correctly. What file processes the order total and why would this be happening? The modules I have installed include CGV, CCGV, bundles, and paypal WPP. If maybe I knew what files processed the order total and would make this happen I could look into it further? I don't understand why replacing all the files with the default files wouldn't have fixed it. Thanks
  23. Hi, I haven't gotten a response yet. My questions is does this module allow you to edit the order, then send a notification to the customer showing the changes and letting the customer click on a link where they can pay for the orders new price? I want to make sure on this before installing this contribution on my oscommerce installation. Thanks!
  24. bump - does anyone know a solution to this? It dosen't seem like that big of a question to me, just if someone can point me to a module or something that can do this if there is one, or if someone can explain the order editor module more and if it does this? Thanks
  25. Hi, I didnt recieve a response to the question I posted. This module seems perfect to edit an order that has been placed, but can the customer pay for the orders edited ammount after the order has been edited? For example I edit the order, send them an email with the edited order, and they can pay for it? Thanks
×
×
  • Create New...