Home
Customization
Products
Free Stuff
Templates
Support
Portfolio
Partners
Forum
Products     Magento Extension     PCI-Shopping-Carts     Templates       CRELoaded     WordPress Modules     osCommerce Modules       osCommerce Addons       osCommerce Features       osCommerce Management       Payment Modules     CRELoaded Modules       CRE Loaded Addons       CRE Loaded Features       CRE Loaded Management       Payment Modules       CRELoaded Services
Free Stuff
Customization
Templates
Compare Products
You have no items to compare.
Affiliate Info
Affiliate Program FAQ
Affiliate Log In
Recent Orders
Hot Keywords: Order Notification, Order Search, Coupon, Flash Board, Compare, Floating Message, Tracking, Moneris, RSS, Visitor Filter

  Search Enhancements

    1 of 1494   Next >   Last >>  
The following osCommerce contribution is a free Opensource code originated from official osCommerce website and provided for your reference only, you may download the original contribution file(s) and install it on your own; or you may request a Paid Installation Service from Agents Of Power; Agents Of Power does the "AS IS" installation on your website, we do not guarantee it will work properly on your website. Extra Paid service is available for repairing the problem from the original contribution or from your website.
Search Unenhancements

There are times when tracking search keywords is undesireable.

Rather than replacing the file:
'/catalog/advanced_search_result.php'

Rename it to:
'/catalog/advanced_search_result_notally.php' and reference it instead.

This is great if you want to embed into a product description a pre-composed search link for other products in a series, or email a pre-composed search link in an email to a client , and don't want the pre-composed search to count in the totals.

Example:
<a href="http://your.website.here/catalog/advanced_search_result.php?keywords=search_term+another_search_term&x=0&y=0" title="Search for other items in the same series">Check out other models in the same series.</a>

Since I employ a standard for naming products, I can search for specific unique phrases, such as "Tele Vue Ethos" without worry of other un-related products appearing in the listing. To do this, simply separate search words with a plus sign, as in my example.

Perhaps some day I'll generate an add-on to make creating these pre-composed search links easier to author. There is probably a contribution that presents related or similar products to visitors, but this was quick-and-dirty.

Thanks to everyone involved in Search Enhancements. I think it's one of the best add-ons, and should be incorporated into the next version.
modified this section in the admin/stats_keywords.php file to have addslashes around the search_text.
also deleting search_text one by one in the while loop
if ($_GET['update'] == BUTTON_UPDATE_WORD_LIST) {
$sql_q = tep_db_query("SELECT DISTINCT search_text, COUNT(*) AS ct FROM search_queries GROUP BY search_text");

while ($sql_q_result = tep_db_fetch_array($sql_q)) {
$update_q = tep_db_query("select search_text, search_count from search_queries_sorted where search_text = '" . addslashes($sql_q_result['search_text']) . "'");
$update_q_result = tep_db_fetch_array($update_q);
$count = $sql_q_result['ct'] + $update_q_result['search_count'];

if ($update_q_result['search_count'] != '') {
tep_db_query("update search_queries_sorted set search_count = '" . $count . "' where search_text = '" . addslashes($sql_q_result['search_text']) . "'");
} else {
tep_db_query("insert into search_queries_sorted (search_text, search_count) values ('" .
addslashes($sql_q_result['search_text']) . "'," . $count . ")");
} // search_count

tep_db_query("delete from search_queries where search_text = '" . addslashes($sql_q_result['search_text']) ."'");
} // while
} // updatedb

full package atta
   Posted on: 11/15/2008     See contribution details Request Installation with Paid service