Jump to content

rjckicks1

Members
  • Content count

    72
  • Joined

  • Last visited

About rjckicks1

  • Birthday 03/02/1989

Profile Information

  • Real Name
    squirLy
  • Website
  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. rjckicks1

    [CONTRIBUTION] Dropdownmenu

    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. rjckicks1

    [CONTRIBUTION] Dropdownmenu

    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. rjckicks1

    Multi images extra contribution

    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. rjckicks1

    [CONTRIBUTION] Dropdownmenu

    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. rjckicks1

    [CONTRIBUTION] Dropdownmenu

    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. rjckicks1

    Multi images extra contribution

    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. rjckicks1

    Multi images extra contribution

    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. rjckicks1

    Multi images extra contribution

    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. rjckicks1

    [CONTRIBUTION] Dropdownmenu

    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. rjckicks1

    [CONTRIBUTION] Dropdownmenu

    Bump Can anyone help out with these, please?? I'd appreciate any advise!! I really need to get this fixed! Thanks in advance!
  13. rjckicks1

    [CONTRIBUTION] Dropdownmenu

    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. rjckicks1

    [Contribution] Documents Manager

    Hi Jim, I must of looked that over, thanks for your help! It's working perfectly now.
  15. rjckicks1

    [Contribution] Documents Manager

    Hello, I installed your contribution because it fits exactly what I need done on my site. I'm just running into one problem. I am able to add/remove document types, and documents through the admin, but when I go to the document page for that document type it says there are no documents currently available for this document type. Do you know why this would be happening? You can see the document page here - http://dandyblend.biz/store2/documents.php?type=1 There is currently a product under Brochure and it is activated under admin( green ). I'd really appreciate your help. Thanks
×