vb.org Archive - Statistics Modifications

Page 6 of 13

« First

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)

dutchbb

02-21-2007 04:51 PM

Quote:

Originally Posted by mcyates (Post 1187620)

I've had to disable it as people where spamming the search box with urls to other sites, also a lot of people were swearing and basically just abusing the box.

In the forumhome template, paste this before the code: <if condition="$bbuserinfo[usergroupid] == 6">

and this after: </if>

So only admins can see it. It's good for finding keywords for your site, because if you know what users are searching for you can focus on those words to make articles, threads, tags, meta keywords, titles, etc.

Neal-UK

02-21-2007 05:21 PM

Quote:

Originally Posted by mcyates (Post 1187620)

I've had to disable it as people where spamming the search box with urls to other sites, also a lot of people were swearing and basically just abusing the box.

Slightly off topic, but when I view your football forum as a guest, I get the fist page showing the image url in the poll pushing the forums out....

See attached:

coderphp

02-21-2007 07:32 PM

Quote:

Originally Posted by dutchbb (Post 1187624)

In the forumhome template, paste this before the code: <if condition="$bbuserinfo[usergroupid] == 6">

and this after: </if>

right and you can also use:

Code:

<if condition="$vbulletin->userinfo['usergroupid'] == 6">

</if>

Quote:

Originally Posted by dutchbb (Post 1187624)

So only admins can see it. It's good for finding keywords for your site, because if you know what users are searching for you can focus on those words to make articles, threads, tags, meta keywords, titles, etc.

Agree with you 100% as this is the main reason - for me - for programming this hack..

Masiello

02-22-2007 08:09 AM

Hi, Ive my forum in a root and not in a /forum dir, I have install this mod but after the product is active the database error appear in a forum index, it don't find the table, any fix?

coderphp

02-22-2007 09:58 AM

Quote:

Originally Posted by Masiello (Post 1188158)

Hi, Ive my forum in a root and not in a /forum dir, I have install this mod but after the product is active the database error appear in a forum index, it don't find the table, any fix?

execute this 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`) )

ncweb

02-22-2007 03:20 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`) )

Great mod, I also had to use this query with mysql 4.1.21-standard and dev box with 4.0.26. Is there something missing from installer?

/installed ;)

nikki712

02-22-2007 04:49 PM

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

Can you please tell me how you made the text smaller?

Masiello

02-22-2007 05:41 PM

Quote:

Originally Posted by coderphp (Post 1188183)

execute this 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`) )

Hello, the table that you have write already exist, this is the error with the product enabled:

Quote:

Database error in vBulletin 3.6.4:

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

MySQL Error : Table 'db.vb_coder_searchstats' doesn't exist
Error Number : 1146
Date : Thursday, February 22nd 2007 @ 08:34:40 PM
Script : http://www.mysite.com/index.php
Referrer : http://www.mysite.com/admincp/index.php?do=head
IP Address : xxx.xxx.xxx
Username : xxx
Classname : vb_database

I think have to create a table named vb_coder_searchstats and drop the table coder_searchstats.

HMBeaty

02-22-2007 05:47 PM

Quote:

Originally Posted by nikki712 (Post 1188414)

Can you please tell me how you made the text smaller?

Hi Nikki, the easiest way I could do it was this...

Go into your admincp > plugins & products > plugin manager

and edit Forum Search Stats 1.0 at hook location forumhome_complete

Then change:

PHP Code:


		
			
$rat = 5/$max;

To:

PHP Code:


		
			
$rat = 2/$max;

You can change 2 to whatever number you want. 2 is just what I have mine at

dutchbb

02-22-2007 06:44 PM

There seem to be something wrong... it shows a completely different list of keywords every F5, there is no ranking or words marked bigger because they are searched more? isn't that what statistics is about? Because this is pretty useless if you don't know what the top keywords are...

All times are GMT. The time now is 04:04 PM.

Page 6 of 13

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01274 seconds Memory Usage 1,754KB 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 (4)bbcode_code_printable (2)bbcode_php_printable (10)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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: