dm18k

Members
  • Content count

    73
  • Joined

  • Last visited

Community Reputation

0 Neutral

About dm18k

Profile Information

  • Real Name
    Dusty

Contact Methods

  1. products model is working now. Typen Names and Model does bring up products when typed Is there away to have to Search my Keywords?
  2. I have just installed AJAX Quick Search. Just a few questions. Is there a way to make keywords lead to other products. ---------------------------- Example: A Bug's Life You start typing: A Bug AJAX Quick Search Finds: A Bug's Life Is there a way to add such keywords as Children Movies / Kids Movies and make A Bug's Life comes up? ---------------------------- I use oscommerce for a vitamins store. most of my customers know what they want, but there is a select few that would search for common terms such as Flu, Colds, Inflammation, MultiVitamins, so on... anyone who types this gets nothing. Is there something I can do, our can someone point me in the right direction? Thank you
  3. 1146 - Table 'XXXXXX_osc1.TABLE_ORDERS_MAXMIND' doesn't exist select distance, country_match, country_code, free_mail, anonymous_proxy, score, bin_match, bin_country, err, proxy_score, spam_score, bin_name, cust_phone, ip_city, ip_latitude, ip_longitude, ip_region, ip_isp, ip_org, hi_risk from TABLE_ORDERS_MAXMIND where order_id = '8602' I keep getting this error, I had Maxmind working great for the passed 6 months I made some updates to orders.php had some problems, and updated orders.php with the back up before the changes. Now I get this message when I uploaded the backup of orders.php Any ideas why? I have tried: Removing SQL Table Adding SQL Table Back in Full Reinstalling MaxMind Nothing seems to work any ideas?
  4. Found my answer in Reply#158
  5. Haveing Troubles... I just installed LinksManager_V_1.10 Now when I goto the admin section... I get this error... Warning: Division by zero in /home/*****/public_html/Store/admin/includes/classes/split_page_results.php on line 33 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'MAX_LINKS_DISPLAY' at line 1 select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_status from links l left join links_description ld on l.links_id = ld.links_id where ld.language_id = '1' order by ld.links_title limit -0, MAX_LINKS_DISPLAY Any idea why?
  6. I have a small problem, I get this white space before my header name... I have checked my english.php / column_right.php for spaces.. I added Bold Text for my box Top, Middle, Bottom maybe I didnt put them in the right place... Edit: Bold doesn't work when you are already useing Code :angry: It's mostly right under my nose, but looking at code all day will drive you insane.. a second set of eyes always does wonders! Thank you, <?php // Set the sort order for the display ?switch(SIMILAR_PRODUCTS_ORDER){ ? ?case 'Random': ? ? ?$sort_order = 'RAND() '; ? ? ?break; ? ?case 'Products ID': ? ? ?$sort_order = 'p.products_id '; ? ? ?break; ? ?case 'Model Number': ? ? ?$sort_order = 'p.products_model '; ? ? ?break; ? ?case 'Price': ? ? ?$sort_order = 'p.products_price '; ? ? ?break; ? ?case 'Date Added': ? ? ?$sort_order = 'p.products_date_added '; ? ? ?break; ? ?case 'Last Modified': ? ? ?$sort_order = 'p.products_last_modified '; ? ? ?break; ? ?case 'Products Ordered': ? ? ?$sort_order = 'p.products_ordered '; ? ? ?break; ? ?case 'Products Name': ? ? ?$sort_order = 'pd.products_name '; ? ? ?break; ? ?case 'Products Viewed': ? ? ?$sort_order = 'pd.products_viewed '; ? ? ?break; ? ?default: ? ? ?$sort_order = 'RAND() '; ?} // switch ?switch(SIMILAR_PRODUCTS_SORT_ORDER){ ? ?case 'Ascending': ? ? ?$sort_order .= 'asc'; ? ? ?break; ? ?case 'Descending': ? ? ?$sort_order .= 'desc'; ? ? ?break; ? ?default: ? ? ?$sort_order .= 'asc'; ?} // switch // Find the id # of the category that the current product is in ? ?$category_query = tep_db_query("select categories_id ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? from " . TABLE_PRODUCTS_TO_CATEGORIES . " ? ? ? ? where products_id = '" . (int)$_GET['products_id'] . "'" ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?); ? ?$category = tep_db_fetch_array($category_query); ? ?$category_id = $category['categories_id']; // Select the other products in the same category ? ?$products_query = tep_db_query("select p.products_id, ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? p.products_price, ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? p.products_model, ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? pd.products_name ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?from " . TABLE_PRODUCTS . " p, ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? " . TABLE_PRODUCTS_DESCRIPTION . " pd, ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? " . TABLE_PRODUCTS_TO_CATEGORIES . " pc ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?where p.products_id = pc.products_id ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?and p.products_id = pd.products_id ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?and p.products_id != '" . (int)$_GET['products_id'] . "' ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?and p.products_status = '1' ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?and pc.categories_id = '" . (int)$category_id . "' ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?and pd.language_id = '" . (int)$languages_id . "' ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?order by " . $sort_order . " ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?limit " . MAX_SIMILAR_PRODUCTS ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?); // Write the output containing each of the products ? ?$products_string = ''; ? ?$count_products = 0; ? ?while ($products = tep_db_fetch_array($products_query)) { ? if ($products['products_id'] != $_GET['products_id']) { ? ? ? ?$products_string .= '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products['products_id']) . '">'; ? ? ?//$products_string .= tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); ? ? ? ?$products_string .= '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products['products_id']) . '">'; ? ? ? ?if (SIMILAR_PRODUCTS_SHOW_MODEL == 'true' && tep_not_null($products['products_model'])) { ? ? ? ? ?$products_string .= $products['products_model'] . '<br>'; ? ? ? ?} ? ? ? ?if ((SIMILAR_PRODUCTS_SHOW_NAME == 'true') && tep_not_null($products['products_name'])) { ? ? ? ? ?$products_string .= $products['products_name'] . '<br>'; ? ? ? ?} ? ? ? ?if (SIMILAR_PRODUCTS_SHOW_PRICE == 'true') { ? ? ? ? ?$products_string .= $currencies->display_price($products['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '<br>'; ? ? ? ?} ? ? ? ?$products_string .= '</a><br>'; ? ? ? ?$count_products++; ? } ? ?} ? ? ?> <!-- similar_products //--> ? ? ? ? ?<tr> ? ? ? ? ? ?<td> <?php ? ?$info_box_contents = array(); require(DIR_WS_INCLUDES . 'boxes/boxTop.php'); $info_box_contents[] = array('text' => BOX_HEADING_SIMILAR_PRODUCTS); ? ?new infoBoxHeading($info_box_contents, false, false); ? require(DIR_WS_INCLUDES . 'boxes/boxMiddle.php'); ? ?$info_box_contents = array(); ? ?$info_box_contents[] = array('align' => 'center', ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'text' => $products_string ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?); ? ?new infoBox($info_box_contents); require(DIR_WS_INCLUDES . 'boxes/boxBottom.php'); ?> ? ? ? ? ? ?</td> ? ? ? ? ?</tr> <!-- similar_products_eof //-->
  7. I have just downloaded and installed Similar Products to my OSC page. Similar Products-- This contribution provides a box on the Product Info page showing products that are similar to the product in the main part of the page. It pulls the products from the same category as the main product. Is there a way to make Similar Product Tie into your advanced search results?
  8. All Products Enchanced http://www.oscommerce.com/community/contributions,1785 I just installed this contribution. Very easy to install also. It lists all my products. It lists them from lowest price to highest price. Is there a way to change this? Like to A-Z?