vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Statistics Modifications - Forum Search Stats 1.0 (https://vborg.vbsupport.ru/showthread.php?t=139829)

coderphp 02-18-2007 10:00 PM

Forum Search Stats 1.0
 
Hi all

Did you ever wondered what your users expect to find in your forums?
Did you ever wanted to know what are their needs?
Did you ever wanted to let them know what they can easily find?
If your answer is "Yes", then you must use this product ...

Features
1- Log user searches in your forums.
2- Show most searched keywords on the main forums page in away that demonstrates every keywords importance in your forums.

Version
Expected to work on all vBulletin 3.6 versions tell now.

Template Edits
1 template edit in FORUMHOME

Plugins
2 Plugins

Installation
1- Upload the directory "upload" contents to your forum root.
2- Import the attached product "[product] Forum Search Stats 1.0.xml" into your AdminCP.
3- Edit template "FORUMHOME":
BEFORE:
Code:

</table>
<br />
<!-- end what's going on box -->

ADD:
Code:

<if condition="$vbulletin->options['setting_searchstats_showuser']">
<tbody>
 <tr>
  <td class="thead" colspan="2">
  <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_events')"><img id="collapseimg_forumhome_events" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_events].gif" alt="" border="0" /></a>
$vbphrase[most_searched]
</td>
 </tr>
</tbody>
<tbody id="collapseobj_forumhome_events" style="$vbcollapse[collapseobj_forumhome_events]">
 <tr>
  <td class="alt2"><img src="images/misc/search_stats.gif" alt="$vbphrase[most_searched]" border="0" /></td>
  <td class="alt1" width="100%">$most_searched</td>
 </tr>
</tbody>
</if>

Finally, if you like the product Please show your support by clicking INSTALL..
you can also NOMINATE FOR MOD OF THE MONTH :)


IMPORTANT: after installation if you noticed that keyword font size is very large, wait and give it a try as font size is depending on num of search in ur forum, so wait and give it a try...

soletrader 02-19-2007 10:29 AM

Installed! Thank you very much for this. Looks nice :)

TheBlackPoet 02-19-2007 10:32 AM

great hack!! since i have a dark theme... i changed the graphic to something appropiate... and made the search result text smaller... but other than that.... this is great!! really nice..

i personally cant think of anything this hack needs to be any better

coderphp 02-19-2007 10:36 AM

Quote:

Originally Posted by soletrader (Post 1185887)
Installed! Thank you very much for this. Looks nice :)


thank you...

coderphp 02-19-2007 10:38 AM

Quote:

Originally Posted by TheBlackPoet (Post 1185890)
great hack!! since i have a dark theme... i changed the graphic to something appropiate... and made the search result text smaller... but other than that.... this is great!! really nice..

i personally cant think of anything this hack needs to be any better


thank you for your feedback...
dont change font size till you test the hack for sometime.. as keyword size is dependable upon its importance in ur forum.. :)
if you could put a url for ur forum as a demonstartion

TheBlackPoet 02-19-2007 10:40 AM

Fatal error: Cannot re-assign $this in /xxxxxxxxxx/xxxxxxx/admincp/search_stats.php on line 14
??? i clicked on the show statistics and got this error....

the /xxxxxxxxxx/xxxxxxx/ is just my url info.. thats not a problem....

i just get a white page... with the error..

coderphp 02-19-2007 10:46 AM

Quote:

Originally Posted by TheBlackPoet (Post 1185895)
Fatal error: Cannot re-assign $this in /xxxxxxxxxx/xxxxxxx/admincp/search_stats.php on line 14
??? i clicked on the show statistics and got this error....

the /xxxxxxxxxx/xxxxxxx/ is just my url info.. thats not a problem....

i just get a white page... with the error..

so sorry Malik...

i think i was using the same name as $this class..

fixed the problem please re-upload the file "search_stats.php" from the new attachment

TheBlackPoet 02-19-2007 10:50 AM

PERFECTION!!! works like a charm!!!! good job Mahmoud!!

projectego 02-19-2007 11:20 AM

Wow! This looks awesome. Thanks very much, coderphp!

sarum 02-20-2007 03:07 AM

very nice hack
*clicks installed*

ever thought about expanding this to show statistics by usergroups/users etc

coderphp 02-20-2007 03:58 AM

Quote:

Originally Posted by TheBlackPoet (Post 1185900)
PERFECTION!!! works like a charm!!!! good job Mahmoud!!

u welcome :)

Quote:

Originally Posted by projectego (Post 1185911)
Wow! This looks awesome. Thanks very much, coderphp!

thank you .. please click install

Quote:

Originally Posted by sarum (Post 1186490)
very nice hack
*clicks installed*

ever thought about expanding this to show statistics by usergroups/users etc

thank you..

bchertov 02-20-2007 04:14 AM

When users search for multiple keywords, does it track them individually or as a group/phrase? It should do them individually, IMO.

coderphp 02-20-2007 04:17 AM

Quote:

Originally Posted by bchertov (Post 1186513)
When users search for multiple keywords, does it track them individually or as a group/phrase?

yes it tracks them as one phrase....


Quote:

Originally Posted by bchertov (Post 1186513)
It should do them individually, IMO.

why should it? did the user entered them individually?!

BigJimTheLug 02-20-2007 06:13 AM

Quote:

Originally Posted by coderphp (Post 1185893)
thank you...

Thanks, you do great work!

coderphp 02-20-2007 06:33 AM

Quote:

Originally Posted by MARKETPROFITS (Post 1186551)
Thanks, you do great work!

u welcome

Distance 02-20-2007 06:44 AM

Wasn't this removed?

coderphp 02-20-2007 06:51 AM

Quote:

Originally Posted by Distance (Post 1186560)
Wasn't this removed?

No it only needed update

maxicep 02-20-2007 10:28 AM

very nice, thanks

coderphp 02-20-2007 10:34 AM

Quote:

Originally Posted by maxicep (Post 1186614)
very nice, thanks

u welcome :)

Moodeey 02-20-2007 10:40 AM

INSTALLED, thx bro :)
gr8 one, it make the board like web 2.0 sites :D

موودي

coderphp 02-20-2007 10:47 AM

Quote:

Originally Posted by Moodeey (Post 1186618)
INSTALLED, thx bro :)
gr8 one, it make the board like web 2.0 sites :D

موودي

u welcome.. glad to c u

يا أهلا مودي :)

Kihon Kata 02-20-2007 11:29 AM

Installed

jwaany 02-20-2007 12:05 PM

very nice hack
*clicks installed*

جواني

coderphp 02-20-2007 03:48 PM

Quote:

Originally Posted by Kihon Kata (Post 1186644)
Installed

Quote:

Originally Posted by jwaany (Post 1186664)
very nice hack
*clicks installed*

جواني

u welcome

mcyates 02-20-2007 05:37 PM

When i click on one of the search terms on the forum home, the search term brings up nothing except for the search.php page with the search term in the search box, so the user has to click search to see the results.

I though the user would only have to click on the search term on the forum home, to bring up the searched terms.

coderphp 02-20-2007 09:03 PM

Quote:

Originally Posted by mcyates (Post 1186875)
When i click on one of the search terms on the forum home, the search term brings up nothing except for the search.php page with the search term in the search box, so the user has to click search to see the results.

I though the user would only have to click on the search term on the forum home, to bring up the searched terms.

nop :)

soletrader 02-20-2007 09:33 PM

I installed the new update and nothing is showing now. Any help?

AMG021 02-20-2007 09:34 PM

thanks dude!

coderphp 02-20-2007 09:42 PM

Quote:

Originally Posted by soletrader (Post 1187005)
I installed the new update and nothing is showing now. Any help?


be sure to do the 3 installation steps discussed in the first post

coderphp 02-20-2007 09:42 PM

Quote:

Originally Posted by AMG021 (Post 1187008)
thanks dude!

anytime u welcome

AMG021 02-20-2007 09:43 PM

Code:

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT MAX(`count`) AS m FROM coder_searchstats;

MySQL Error  : Table 'amg209_forum.coder_searchstats' doesn't exist
Error Number : 1146
Date        : Tuesday, February 20th 2007 @ 03:34:50 PM

i got this error WHY ?

coderphp 02-20-2007 09:47 PM

Quote:

Originally Posted by AMG021 (Post 1187017)
Code:

Database error in vBulletin 3.6.4:
 
Invalid SQL:
SELECT MAX(`count`) AS m FROM coder_searchstats;
 
MySQL Error  : Table 'vastatic_forum.coder_searchstats' doesn't exist
Error Number : 1146
Date        : Tuesday, February 20th 2007 @ 03:34:50 PM

i got this error WHY ?


it tells that the hack table doesnt exist..

Please re-install the product again..

If for any reason the problem presists execute this query manually from the admincp:
Code:

CREATE TABLE `coder_searchstats` ( `id` int(10) unsigned NOT NULL auto_increment, `query` varchar(200) NOT NULL default '', `dateline` int(10) unsigned NOT NULL default '0', `count` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM

AMG021 02-20-2007 09:49 PM

ok

let me try again


this is wat i got

Code:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM' at line 1


coderphp 02-20-2007 10:05 PM

Quote:

Originally Posted by AMG021 (Post 1187025)
ok

let me try again


this is wat i got

Code:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM' at line 1


ok now it is clear for me

do the following:
1- reinstall the product.
2- execute this new query:
Code:

CREATE TABLE `coder_searchstats` ( `id` int(10) unsigned NOT NULL auto_increment, `query` varchar(200) NOT NULL default '', `dateline` int(10) unsigned NOT NULL default '0', `count` int(11) NOT NULL default '0', PRIMARY KEY (`id`) )

AMG021 02-20-2007 11:03 PM

Quote:

Originally Posted by coderphp (Post 1187042)
ok now it is clear for me

do the following:
1- reinstall the product.
2- execute this new query:
Code:

CREATE TABLE `coder_searchstats` ( `id` int(10) unsigned NOT NULL auto_increment, `query` varchar(200) NOT NULL default '', `dateline` int(10) unsigned NOT NULL default '0', `count` int(11) NOT NULL default '0', PRIMARY KEY (`id`) )

Thank you sooo much! It worked

coderphp 02-20-2007 11:11 PM

Quote:

Originally Posted by AMG021 (Post 1187076)
Thank you sooo much! It worked


ok good

rwilkins108 02-21-2007 01:38 AM

Works great, any chance of getting a way to remove 1 search term from the box, like the way Zoints Tags works (which looks similar) is that if you're an admin, there's an x next to each tag (or search term in this case) which will remove it. Also, it might be good to have a list of words that would be ignored, i've already got a swear word up on mine :)

Great work!
Thanks!!

HMBeaty 02-21-2007 03:05 AM

I'm getting the following error on my forums after product upload....

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT MAX(`count`) AS m FROM vb_coder_searchstats;

MySQL Error : Table 'Redline.vb_coder_searchstats' doesn't exist
Error Number : 1146
Date : Tuesday, February 20th 2007 @ 09:54:06 PM
Script : http://www.mysite.org/forum/index.php
Referrer : http://www.mysite.org/forum/admincp/index.php?do=head
IP Address : xx.xx.xx.xx
Username : xxxxxxx
Classname : vb_database




I tried the fix above but it didn't work for me

HMBeaty 02-21-2007 03:43 AM

Nevermind, I went in and manually edited the database. The problem is that your product is not creating the "TABLE_PREFIX" because its not in the product to include it. So you might want to fix that as well. Also, the "expand / collapse" doesn't work. It expands / collapses my "upcoming events"

EDIT: and that would be because you're USING the "upcoming events" module for it. As shown in your FORUMHOME template edit here:

HTML Code:

onclick="return toggle_collapse('forumhome_events')
So you should fix that as well

HMBeaty 02-21-2007 03:53 AM

/me uninstalled until fixes are made


All times are GMT. The time now is 10:29 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01358 seconds
  • Memory Usage 1,837KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (9)bbcode_code_printable
  • (1)bbcode_html_printable
  • (22)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete