vb.org Archive - Statistics Modifications

Page 10 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)

Tom_S

03-01-2007 11:03 AM

Installed then Uninstalled. It crashed my board:

Quote:

Database error in vBulletin 3.6.4:

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

MySQL Error : Table 'myboard.vb_coder_searchstats' doesn't exist Error Number : 1146

Tom_S

03-01-2007 11:21 AM

Okay...I read through all this thread and see that I have to manually fix this issue. It also says it would be updated and fixed in the next few days from the 21st but it isn't. I will wait until it is. doing it manually is no problem. just don't want to :p

Great mod though ;)

coderphp

03-01-2007 09:00 PM

Quote:

Originally Posted by Tom_S (Post 1193257)

the new version isnot to be released now as im busy with my work...

u can query it manually though :)

dutchbb

03-19-2007 04:11 PM

Is there a way to just show the top 5 most searched on forumhome? Without changing the fontsize, just 1. keyword 2. keyword 3. etc...

I'm guessing it's

ORDER BY RAND()

rand = random? How to make it order by most searched?

coffee

04-27-2007 09:46 AM

Great job brother ..

Could you please add search terms from search engines like Google, Yahoo and MSN?

That can be done through reading visitor's browser header.

coderphp

05-02-2007 06:54 AM

Quote:

Originally Posted by dutchbb (Post 1207409)

replace

Code:

ORDER BY RAND()

with

Code:

ORDER BY `count`

regards

coderphp

05-02-2007 06:57 AM

Quote:

Originally Posted by coffee (Post 1236324)

Great job brother ..

Could you please add search terms from search engines like Google, Yahoo and MSN?

That can be done through reading visitor's browser header.

Ahlan mohammed :)

yes it could maybe soon ill add this feature

Regards

dutchbb

05-05-2007 08:35 AM

Quote:

Originally Posted by coderphp (Post 1239519)

replace

Code:

ORDER BY RAND()

with

Code:

ORDER BY `count`

regards

I tried it without succes.

Can you please check my plugin code for errors:

Quote:

if($vbulletin->options['setting_searchstats_showuser']){
$most_searched = "";
$m = $db->query_read("SELECT MAX(`count`) AS m FROM " . TABLE_PREFIX . "coder_searchstats");
$ma = $db->fetch_array($m);
$max = $ma['m'];
if($max)
{
$rat = 5/$max;
$get = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "coder_searchstats ORDER BY `count` LIMIT " . $vbulletin->options['setting_searchstats_showusernum']);
while($put = $db->fetch_array($get))
{
$r = round($rat*$put['count']);
$most_searched .= "<span dir=\"rtl\"><a href=\"search.php?q=". $put['query'] ."\"><font size=\"".$r."\">" . strip_tags($put['query']) . "</font></a></span>  ";
}
}
else
{
$most_searched .= "None";
}
}

Thank you

coderphp

05-05-2007 08:40 AM

Quote:

Originally Posted by dutchbb (Post 1241796)

I tried it without succes.

Can you please check my plugin code for errors:

Thank you

the code looks good

can u please copy the error u got?

dutchbb

05-05-2007 09:12 AM

it didn't order on count. But I installed it again and now it seems to order ok :)

But I still get this problem with the blank keyword:

http://aycu14.webshots.com/image/170...5538836_rs.jpg

All times are GMT. The time now is 11:32 PM.

Page 10 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.02165 seconds Memory Usage 1,744KB 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 (7)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: