vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=298254

[DBTech] vBSearch Log v1 (vB3)
by DragonByte Tech
17 May 2013 21:43

3 Attachment(s)
Why use, vBSearch Log?
Myself, as alot of members on here, have at times wanted to know what the members or guests are searching for on our sites. vBSearch Log logs every search query made on your forum after installation. Useful to see what the members or guests are searching for on our sites.

Lets say you run a site that is about cars. You look in the search log and see that there is quite a few searches for Corvette Stingray. Now you look on your forums and see there is not to much information about Corvette Stingray. So what you could do is find some info to post in your forums about that.

Lets say you run a site that is about gaming. You look in the search log and see that there is quite a few searches for Borderlands 2. Now you look on your forums and see there is not to much information about Borderlands 2. So what you could do is find some info to post in your forums about that.

So in theory, by adding missing information about such things should, retain your existing members and get guests to register, cause members and guests found what they are looking for, and have no need to go look elsewhere.

-------------------------------------------------------------------------------------------

If you like this mod please hit the https://www.vbulletin.org/forum/external/2015/08/1.png button to the right ---->

Please remember to click the, https://www.vbulletin.org/forum/external/2015/08/2.png button to the right if you installed the mod ---->

What does 'Marking As Installed' do ?

* It helps you to stay on top of updates - members who have installed modifications will be notified by us whenever new updates are available.

*
For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention.

* Marking a modification as installed also helps us know how many people are using our work, giving us extra incentive to provide more features and new modifications.

We appreciate the support!
-------------------------------------------------------------------------------------------

Other addons available @ www.DragonByte-Tech.com/forum

There are no vB settings settings for the mod.

-------------------------------------------------------------------------------------------------------

This mod displays NO copyright notification in the footer as it is a admin only mod.

cheech47 18 May 2013 16:04

Im getting an error when trying to look at the logs:

Quote:

Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT DISTINCT dbtech_search_log.userid, user.username
FROM dbtech_search_log AS dbtech_search_log
INNER JOIN user AS user USING(userid)
ORDER BY username;

MySQL Error : Table 'XXXadmin_XXXforums.dbtech_search_log' doesn't exist
Error Number : 1146
Request Date : Saturday, May 18th 2013 @ 12:01:31 PM
Error Date : Saturday, May 18th 2013 @ 12:01:31 PM
Script : http://www.xxx.com/forums/admincp/db....php?do=select
Referrer : http://www.xxx.com/forums/admincp/index.php?do=nav
IP Address : XXX.XXX.XXX.XXX
Username : Mine
Classname : vB_Database
MySQL Version : 5.1.68-cll

DragonByte Tech 18 May 2013 17:13

Quote:

Originally Posted by cheech47 (Post 2422853)
Im getting an error when trying to look at the logs:


Sorted, uninstall the mod, redownload the files and proceed as a fresh install. I dunno how it was missing the install but it was.

Chris

christon26 18 May 2013 20:37

I got that too but the first time I tried to install my database glitched at the same time so I thought it was that LOL and just used the sql in the 100.php file to create the table myself :P

DragonByte Tech 18 May 2013 21:25

Lol cool, but you should still import the new xml, so if yo happen to uninstall the mod, the table gets removed.

Chris

cheech47 20 May 2013 07:21

Still getting the same error as before, re-uploaded all files and re-imported the xml, as soon as you go to the option in the admincp the error shows

ozzy47 20 May 2013 11:10

Did you uninstall the mod first? If no you need to do so in order to activate the installer.

cheech47 21 May 2013 06:51

Quote:

Originally Posted by ozzy47 (Post 2423095)
Did you uninstall the mod first? If no you need to do so in order to activate the installer.

I had, removed everything including uploaded files instead of overwriting, reinstalled and its now working, thanks

DragonByte Tech 21 May 2013 10:31

Quote:

Originally Posted by cheech47 (Post 2423286)
I had, removed everything including uploaded files instead of overwriting, reinstalled and its now working, thanks

That's good to here, thanks for reporting back.
Chris

juan71287 21 May 2013 20:09

Let me give it a shoot :)

Hope to have it In a Positive Use :)

DragonByte Tech 21 May 2013 22:27

Quote:

Originally Posted by juan71287 (Post 2423402)
Let me give it a shoot :)

Hope to have it In a Positive Use :)

I hope ya like it. Don't forget to mark installed if you are using the mod.

Chris

Alfa1 24 May 2013 00:19

It would be nice if this addon would show the X top search queries in the last Y days. I have too many active users to keep track of such logs.

DragonByte Tech 27 May 2013 10:21

It don't do that at this time, but it is something that can be look into for future versions.

Chris

ehd 29 May 2013 08:19

Quote:

Originally Posted by DragonByte Tech (Post 2424414)
It don't do that at this time, but it is something that can be look into for future versions.

Chris

This would be awesome! Thanks in advance!

TK1990 02 Jul 2013 16:28

In the readme file stand it require al least vb 4.0.2... so is it possible to install this version on 3.8.x with this file? :X


All times are GMT. The time now is 08:20.

Powered by vBulletin® Version 3.8.12
Copyright © 2019, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.