X-Cart forums

[arabayaservis.com]

thanks for mod

[xcell67]

hi,
thanks for this nifty mod, slight problem though, the Sort by Name function doesn't work. If you click sort by name or sort by count, it always sorts by the count. I used your latest edited php code, is the sort by name problem caused by something else?

[OshkoshJon]

Will this work with 3.4.12?

[Emerson]

It should work with any version.
All it does is grab the search query and saves it to the DB tables you created

[OshkoshJon]

I'm having the same problem as maki - it's re-loading the admin home page when I click on it. How can I get it to work properly? Please help!

[Emerson]

Ok, for those of you having the problem being directed to the home.php page with the 3.4.x branch, do this...

Open the stats_keywords.php file and replace:

require "./auth.php"; 
require $xcart_dir."/include/categories.php";

With...

require "../smarty.php";
require "../config.php";
@include "./https.php";
require "./auth.php";
require "../include/categories.php";

I just tried it on a 3.4.x and it works!

HTH

[OshkoshJon]

Sort by name and sort by count both sort by count... might want to fix that

[Emerson]

Originally Posted by OshkoshJon

Sort by name and sort by count both sort by count... might want to fix that

Here is a fix...

Find:

$sql_q = mysql_query("select search_text, search_count from search_queries_sorted order by search_count DESC");

And replace it with:

$sql_q = mysql_query("select search_text, search_count from search_queries_sorted order by " . $HTTP_POST_VARS['sortorder'] . " " . $HTTP_POST_VARS['ascdsc']);

The original post has been update with this fix

[OshkoshJon]

Thank you much!

Got an idea if you don't mind - the most frequent search is actually blank. A neat idea might be to automatically delete "blank" searches.

[Emerson]

Originally Posted by OshkoshJon

Thank you much!

Got an idea if you don't mind - the most frequent search is actually blank. A neat idea might be to automatically delete "blank" searches.

Yes, that would be nice but it is more then I know how to do.

Maybe one of the pros here might shed some light how to do that?