X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)
-   -   Keep track of keywords searched! (https://forum.x-cart.com/showthread.php?t=7057)

arabayaservis.com 05-27-2004 01:27 AM

thanks for mod

xcell67 05-31-2004 02:31 PM

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 06-06-2004 06:53 AM

Will this work with 3.4.12?

Emerson 06-06-2004 06:57 AM

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

OshkoshJon 06-06-2004 07:09 AM

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 06-06-2004 07:23 AM

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:
Code:

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


With...

Code:

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 06-06-2004 07:29 AM

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

Emerson 06-06-2004 12:32 PM

Quote:

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:
Code:

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

And replace it with:
Code:

$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 06-06-2004 12:34 PM

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 06-06-2004 12:46 PM

Quote:

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?


All times are GMT -8. The time now is 12:13 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.