X-Cart forums

[OshkoshJon]

Not a problem, the script is still very useful, and the price can't be beat

[OshkoshJon]

I figured out how, it's pretty simple actually. You can either have it as part of the Update DB subroutine, or you can make a separate button "Clean DB".

Basically all it does is run an SQL query and delete any row where the search text is empty:



mysql_query("DELETE FROM `search_queries_sorted` WHERE search_text = ''");


Additionally you can have it remove other searches, such as "test" and "testing" (diagnostic searches).

[Emerson]

Cool, Thank You

[wallachee]

Awesome Mod. Works great in 3.5.10.

-Bradley

[wallachee]

I've got this mod up and working, but there is one problem. The search registers an unusally large number of blank searches. Does anyone else have this issue and is there any way to fix it?

-Bradley

[Lucent88]

Does this work for v4.x users?

[B00MER]

Originally Posted by Lucent88

Does this work for v4.x users?

It's built into 4.x.