Search Log 2.9

[Slind]

This add-on uses the xf_search table to get its data. XenForo prunes the xf_search table once a day and removes any data older than 24 hours. So the Search Log add-on will display only the last 24 hours search results.

Ah ok. Could you create a own save file for search log, please?

 

[Slind]

Waiting for a reply...

A other thing would be to see the country of the user/guest, to get more informations about seeker.

 

[Scharesoft]

Thanks for this addon

One suggestion: In my opinion the link to the search log would be better in the "Useful Searches" list.

 

[AndyB]

AndyB updated Search Log with a new update entry:

Changes to v1.4

1. Added table to store data
2. Added option to delete data older than number of days
   
3. Added user only search
4. Added Newer Than Column
5. Result Counts over 100 now show 100+
6. Logs successful and unsuccessful searches

 

[Slind]

Works thanks, the no result bug is also fixed.

 

[xfandroid]

Good thing i hadn't add it yet, thank you Andy!

 

[maxicep]

Is possible that visible the search log link for moderators too ?

 

[Deepmartini]

Does this affect the database at all or slow a site down? I can imagine even at 30 days when you are logging information it will clog the site? I don't know how that works but would be a concern.

 

[AndyB]

Does this affect the database at all or slow a site down? I can imagine even at 30 days when you are logging information it will clog the site? I don't know how that works but would be a concern.

The information is stored in a table called xf_search_log. You can use phpMyAdmin to view the size if this file. On an average sized forum I think you can save years worth of search logs without this table getting very large.

 

[maxicep]

Also, can u show all searched keywords by group.

I want to see same search terms and how much times searched?

For example;
Audi A7 Car - 138 times searched
Bmw Z4 Gear - 12 times searched


So, we can see most searched terms via search log.

 

[Aceros]

I think parsing might be a little difficult, especially as users type things wrong a lot. What about a quick export button to csv format for excel?

 

[AndyB]

What about a quick export button to csv format for excel?

The data is stored in in a table called xf_search_log. You can use phpMyAdmin to export the data into a cvs file.

 

[AndyB]

AndyB updated Search Log with a new update entry:

Fixed error if trying to search for word with an apostrophe.

Fixed error if trying to search for word with an apostrophe.

Read the rest of this update entry...

 

[Digital Doctor]

I'd be interested how often people are searching their own posts.



I've always wanted to be able to use me as a shortform for digital doctor.

 

[Slind]

Would be great if you add a hover for the lines that it is easier to find the associated .stuff

 

[AndyB]

Would be great if you add a hover for the lines that it is easier to find the associated .stuff

To add a hover effect to highlight a row, add this to the andy_searchlog.css template:

.dataTable tr:hover {
  background-color: #f0f7fc;
}

 

[LuvMeSumZen]

Andy I tried to prune my logs but did not see how. I tried changing the prune days to zero and save but defaults to 1 day, so would have to wait a day for the log to clear. Is there a way to clear manually the log without going into the database to do it?

 

[AndyB]

AndyB updated Search Log with a new update entry:

See description.

Added the ability to set the date format within the Options page. Now when viewing the search log, the date can be in the format you prefer.

Read the rest of this update entry...

 

[santamo]

May You add IP of guests?

 

[maxicep]

Is possible that visible the search log link for moderators too ?

@AndyB ?