vb.org Archive - Statistics Modifications - Cyb

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Statistics Modifications - Cyb - Advanced Forum Statistics (https://vborg.vbsupport.ru/showthread.php?t=201274)

Quote:

Originally Posted by FractalizeR (Post 2165723)

Can't this be DDOS attack on your forum?

That's what I thought at first, but ALL these requests came from a single IP-Address. Upon checking with the user further (a woman cyclist on our board for years), she had no knowledge or any indication the event had occurred.

My guess is, our HOST has probably changed something to do with MySQL (as others mentioned above) and perhaps that tripped this product into going into a repetitive update cycle for whatever reason(s).

is there any prerequisites b4 install this mod? my page going blank after installation...pls help...

Quote:

Originally Posted by adwade (Post 2165784)

That's what I thought at first, but ALL these requests came from a single IP-Address. Upon checking with the user further (a woman cyclist on our board for years), she had no knowledge or any indication the event had occurred.

[s]My guess is, our HOST has probably changed something to do with MySQL (as others mentioned above) and perhaps that tripped this product into going into a repetitive update cycle for whatever reason(s).[/s]

In doing some more research, I don't think it was anything our HOST has done. Our problem, stemmed from a single (good/reliable) user on our website. Below is a listing of when they access our website and how many requests were made of the site, per the raw access logs:

01FEB 281 requests made from 03:15 to 21:59
02FEB 778 requests made from 00:59 to 23:18
03FEB 292 requests made from 13:44 to 22:12
05FEB 438 requests made from 02:00 to 23:19
07FEB 663 requests made from 00:08 to 23:52
08FEB 53 requests made from 11:31 to 15:08
09FEB 281 requests made from 03:16 to 21:00
10FEB 435 requests made from 00:01 to 23:19
11FEB 196 requests made from 03:22 to 05:22
12FEB 50583 requests made from 00:33 to 08:36
13FEB 249 requests made from 07:19 to 08:46
14FEB 19059 requests made from 19:00 to 23:57
15FEB 12115 requests made from 00:13 to 23:56
17FEB 171 requests made from 04:30 to 04:43
18FEB 2097 requests made from 00:05 to 23:45
19FEB 134 requests made from 09:33 to 09:34
20FEB 59174 requests made from 01:21 to 14:46
Our account suspended by HOST
21FEB 11048 requests made from 00:51 to 13:13
22FEB 308875 requests made from 01:18 to 23:59
Our account suspended by HOST
23FEB 278 requests made from 00:00 to 07:11
24FEB 331 requests made from 00:37 to 23:56
25FEB 1 request made at 06:31am
26FEB 11875 requests made from 00:24 to 23:59
27FEB 8641 requests made from 00:00 00:27
28FEB 146 requests made from 1:14 to 03:53
01MAR 9180 requests made from 00:49 to 07:13
02MAR 398 requests made from 1:12 to 11:40
03MAR 1 request made at 00:38am
06MAR 444 requests made from 00:21 to 01:32

At the worst, our HOST wrote us saying: "High resource usage, especially with PHP scripts" (i.e. misc.php, which this MOD calls for stats calculations) and "Sometimes it has spiked to 35-40% of the CPU."

The user causing this problem, was using MS-IE (Version 8.0.7600.16385) to access our website and was the only one having this issue. They also had a Macintosh computer in the household and when using it, the issue was not present. This week (i.e. 02MAR), they installed the Google Chrome Browser, and have not caused any server load issues since employing it.

Personally, I set our NIX Server Load Limit (in AdminCP) to 10, and also revised the "How often users can manually refresh Latest Posts (in seconds)" to 300. I took both these actions, in an attempt to help reduce our server load during heavy usage times and avoid getting our account suspended again by our HOST.

Again, briefly the problem was the continual reloading of our main forum page that show the stats boxes, causing them to be re-calculated continuously....(below is just 1 second of our raw access log)

Code:

xxx.xxx.158.49 - - [12/Feb/2011:08:21:33 -0500] "POST /forums/misc.php?show=newestmembers&resultsnr=5 HTTP/1.1" 200 2920 "http://www.website.com/forums/index.php" "Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; GTB6.6; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C)"

xxx.xxx.158.49 - - [12/Feb/2011:08:21:33 -0500] "POST /forums/misc.php?show=mostviewedthreads&resultsnr=5 HTTP/1.1" 200 2617 "http://www.website.com/forums/index.php" "Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; GTB6.6; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C)"

xxx.xxx.158.49 - - [12/Feb/2011:08:21:33 -0500] "POST /forums/misc.php?show=latestposts&resultsnr=5 HTTP/1.1" 200 14240 "http://www.website.com/forums/index.php" "Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; GTB6.6; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C)"

xxx.xxx.158.49 - - [12/Feb/2011:08:21:33 -0500] "POST /forums/misc.php?show=newestmembers&resultsnr=5 HTTP/1.1" 200 2920 "http://www.website.com/forums/index.php" "Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; GTB6.6; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C)"

xxx.xxx.158.49 - - [12/Feb/2011:08:21:33 -0500] "POST /forums/misc.php?show=latestposts&resultsnr=5 HTTP/1.1" 200 14240 "http://www.website.com/forums/index.php" "Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; GTB6.6; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C)"

It would be nice if this MOD could cache the last results of the stats calculation, and then if requested to re-calc them again too soon (i.e. upon multiple reloading of a webpage) it would just display such rather than having to re-calculate them all over again.

Not that any of this solves the actual issue which caused the problem (i.e. still unknown), but it might help to shed some more light on what's happening to some other administrators employing this MOD. Meanwhile, FWIW our Server Load Averages are back down to normal (i.e. 2.77 3.15 3.20) after our single problem user quit using MS-IE v8.

https://vborg.vbsupport.ru/external/2011/03/32.jpg

All posts posted as Administrator shows as double posts now.. Worked fine yesterday.

I'm using Cyb - Advanced Forum Statistics 5.7, tried 6.6.2 update, but same thing with both.
http://www.topzone.lt/forumas/

ver 6.6.2
http://farm6.static.flickr.com/5140/...929755a4_b.jpg

We just upgraded our board from the vb 3.8.2 version to vB 3.8.7 and the "latest posts" are not showing now??

Note: This problem applies to both versions of the CYB stats -- 5.8.1 and the ajax based 6.6.2

Any suggestions?

Hi,

Thank you very much for this excellent hack.

I have the following problem, related to the Social Groups: i want to show the "Latest Group Posts" in ForumHome.

But some of them have been configured -by their owners- as only readable by members of the group. However, if i visit the ForumHome as not logged in, statistics show the titles of the "Latest Group Posts" of such groups.

How can i exclude from non-members of that Social groups, the viewing of the "latest Group posts" that are configured to be private, or readable only by members of the group? I am running vBulletin 3.8.7

Thank you very much in advance.

I haven't seen this mentioned yet, but the stats do not appear to be working using the new FireFox 4.0 (vb 3.8.7). Just keeps saying "Loading...."

They ARE working in VB 4.

Is there anything that needs to be adjusted or a plug-in added?

Thanks

Are there any plans to add statistics for "Top Repped Posts" and/or "Top Repped Threads" ?

I think they would be a great addition to an already outstanding mod as they would encourage quality posts and threads.

Awesome addition to my forum! Thank you! :)

This just stopped working all of a sudden... just stays at "loading...". Any ideas?

Quote:

Originally Posted by yesfans (Post 2165083)

3. Optional - if you use custom styles and link to re-enable stats is not shown:
Open desired template and add "$cybts_enablelink" where you wish "Enable Top Statistics" link to appear

I CAN NOT GET THIS TO WORK. IT IS NOT SHOWING UP IN MY QUICK LINKS DROP DOWN.

ANYONE????????????????

I edited this plugin to include an "Exclude Forums" functionality that caches per user. I had some members complaining about there always being posts shown in a section they are not fans of so to speak. So by adding that function it allows each user to select which forums display new posts in that section. (to the right)

Thank you ! Good effort !! but,not working for 4.x !! please try to apply a fix for 4.x versions !!

Thanks :)

Quote:

Originally Posted by charkman (Post 2202747)

Thank you ! Good effort !! but,not working for 4.x !! please try to apply a fix for 4.x versions !!

Thanks :)

4.X version... https://vborg.vbsupport.ru/showthread.php?t=235841

please make one for ver. 4.X

downloaded and installed..

Cool Mod..Thanks

thanks bunu arıyordum çok saolun teşekkürler

i have this installed on my forums but for some reason it is not showing any latest topics or anything. just keeps on saying loading... how can i fix this?

p.s this is installed on 3.8.7 version of board

Reason This happened is my datacenter nulled the misc.php script because of this mod. caused huge server resources. please fix this as this is an awesome mod. i havent clicced install yet cause as of now this mod is not proper, there is a huge bug u need to fix somewhere within it.

hi dear coder and other friends
I just installed it and it works good out of the box but if i want to change/modify setting I sopuse I have to go to setting page
this page i mean
but I can't find it.
to change hacks setting I should go to Go to admin cp, then vBulletin Options -> Cyb hack setting
right?
sorry for noob question, vb option means right column in admin cp, right?
I can't find Cyb link in there

How to fix this error?

Code:

If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error.]]>

Quote:

Originally Posted by yesfans (Post 2165083)

3. Optional - if you use custom styles and link to re-enable stats is not shown:
Open desired template and add "$cybts_enablelink" where you wish "Enable Top Statistics" link to appear

I can not get this to work. It is not showing up in my Quick Links drop box

I too am having the same problem. If your using a custom style, this is considered a requirement.

If someone could point out the template where "$cybts_enablelink" needs to go I would be very appreciative.
Or do I edit the .xml file? Anyone know?

edit: This post clears everything up.
Great mod!

I want to change 'Most Viewed' to 'Most Rated'

Can you help me with this query:

PHP Code:


		
			
// Most view thread
    if ($_REQUEST['top'] == '+++++++_most_viewed')    {
        $get_stats_mostviewed = $vbulletin->db->query_read("
            SELECT threadid,
                title,
                forumid,
                views,
                dateline,
                visible,
                open,
                lastpost,
                replycount,
                postusername,
                lastposter                
            FROM " . TABLE_PREFIX . "thread AS thread
            WHERE NOT ISNULL(threadid) AND visible = '1' AND views > '0' AND open!='10' $+++++++exclforums $+++++++topstats_timecut_mostviewed
            ORDER BY views DESC
            LIMIT 0, $resultthread
            ");        
        while ($get_most_viewed = $db->fetch_array($get_stats_mostviewed))    {
            $get_most_viewed[fullthreadtitle] = strip_tags($get_most_viewed[title]);
            if ($trimthreadtitle > 0)    {
                $get_most_viewed[titletrimmed] = fetch_trimmed_title($get_most_viewed[fullthreadtitle], $trimthreadtitle);
            }
            else    {
                $get_most_viewed[titletrimmed] = $get_most_viewed[fullthreadtitle];
            }
            $get_most_viewed[newpost] = ($get_most_viewed[lastpost] > $vbulletin->userinfo['lastvisit'])? 'new' : 'old';
            $get_most_viewed_forumtitle = strip_tags($vbulletin->forumcache["$get_most_viewed[forumid]"]['title_clean']);
            $get_most_viewed[fullforumtitle] = strip_tags($get_most_viewed_forumtitle);        
            $get_new_postdate = vbdate($vbulletin->options['+++++++topstats_date_format'], $get_most_viewed[lastpost]);
            $get_new_posttime = vbdate($vbulletin->options['+++++++topstats_time_format'], $get_most_viewed[lastpost]);
            $get_startdate = vbdate($vbulletin->options['+++++++topstats_date_format'], $get_most_viewed[dateline]);
            $get_starttime = vbdate($vbulletin->options['+++++++topstats_time_format'], $get_most_viewed[dateline]);    
            eval('$+++++++topstats_top.= "' . $vbulletin->templatecache['+++++++_topstats_mostviewed'] . '";');
        }
        if (!$+++++++topstats_top)    $+++++++topstats_top = 'No Result';
        print_output($+++++++topstats_top);
        exit;
    }

Can anyone help me with this problem? They shouldn't be spaced out like that.

http://img9.imageshack.us/img9/9947/...10930at101.png

Is there a version for 4.17?

how can i remove numbering
that
1
2
3
4
5

The latest thread view count has stopped working all of a sudden? Anyone else having the same problem?

"Forums excluded from stats (List IDs, separate with commas"

Don't work!

Help me!

I installed this on 4.1.7pl2 and it made my site error 500 ...

I guess, it doesn't work with vb4

Quote:

Originally Posted by Scyther (Post 2271354)

I guess, it doesn't work with vb4

Same coder made a version of this for vB 4. This is the 3.8.x version.

The one for vB4 is here:

https://vborg.vbsupport.ru/showthread.php?t=235841

Are you using vb4? You should probably uninstall this mod and use this one instead: https://vborg.vbsupport.ru/showthread.php?t=235841 . (It's by the same author, he changed from Cyb to VSa when naming his mods).

Quote:

Originally Posted by kh99 (Post 2278677)

ahhh thanks i am using vb4.... i couldnt find the one for vb4 s.... but thanks :D

Just installed this a couple days ago. I happened to look at my Members list and it's only displaying 17 of the 88,000 members now. The only members which are being displayed have high post counts.

Anyone else have this problem or know how to fix it?
VB 3.8.7

Quote:

Originally Posted by DaveMN (Post 2279272)

Link?

Somehow the Minimum Posts to display in User Listing was changed to 5000. Have no idea how that got changed. But all fixed now!

Quote:

Originally Posted by DaveMN (Post 2279409)

Somehow the Minimum Posts to display in User Listing was changed to 5000. Have no idea how that got changed. But all fixed now!

I suspected it was something like that. However I see nothing in the code for this Mod that would do that. Glad you got it worked out!

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02404 seconds Memory Usage 1,866KB 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 (2)bbcode_code_printable (1)bbcode_php_printable (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (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: