vb.org Archive - Statistics Modifications

Page 1 of 4

Last »

Show 40 post(s) from this thread on one page

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)

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)

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)

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 11:55 PM.

Page 1 of 4

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01332 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
Messages: