vBusy: Last minute session stats analyzer for admins

There's also a vB 3.5 version: https://vborg.vbsupport.ru/showthrea...threadid=82788

What this hack does: This hack will allow you to have a quick glance at what's going on in the forum, based on the session table. The session table contains short-term information, that can be useful in finding out if things are more busy than usual. This idea come from this thread: How to view the busiest threads? You will have the option to view the bussiest threads, or all activities, in the last 1, 5 or 10 minutes. You can enter addiitonal minute values in the URL.

Features:
Lists is descending order busiets/most active:

• Threads
• Forums
• PHP Scripts
• Hosts IP's
• Resolved IP's
• Useragents and bots

Lists all session data, with sort options based on (time, user, host, useragent, location.

Per minute chart of sessions table activities.

Installation: : Just copy the file vbusy.php into your admincp directory.

Optional: If you want to have it integrated in the admin panel menu, just do this simple edit:

In ./admincp/index.php:

Find:

PHP Code:

construct_nav_option($vbphrase['scheduled_task_log'], 'cronlog.php?do=choose', '<br />'); 


Add after it:

PHP Code:

// vBusy hack
        construct_nav_option('vBusy', 'vbusy.php', '<br />');
// vBusy end 


Click install to receive auto updates about new features/bugs.

[Moparx]

Invalid SQL: 
		SELECT count(inthread) as viewers, inthread, thread.title FROM vb3_session 
                LEFT JOIN  vb3_thread ON thread.threadid=session.inthread
                WHERE inthread > 0
                AND lastactivity >= 1119493313
                GROUP BY inthread ORDER BY viewers DESC
mysql error: Unknown table 'thread' in field list

mysql error number: 1109

there is no thread.title (or forum.title) in the sessions table. (i'm running 3.0.7)

[tamarian]

Originally Posted by Moparx

Invalid SQL: 
		SELECT count(inthread) as viewers, inthread, thread.title FROM vb3_session 
                LEFT JOIN  vb3_thread ON thread.threadid=session.inthread
                WHERE inthread > 0
                AND lastactivity >= 1119493313
                GROUP BY inthread ORDER BY viewers DESC
mysql error: Unknown table 'thread' in field list

mysql error number: 1109

there is no thread.title (or forum.title) in the sessions table. (i'm running 3.0.7)

Those are to read from the thread and forum tables for the tile.

I just updated the file, please re-download, and let me know if it fixes the problem.

[Moparx]

Database error in vBulletin 3.0.7:

Invalid SQL: 
		SELECT count(inthread) as viewers, inthread, thread.title FROM vb3_session 
                LEFT JOIN  vb3_thread as thread ON thread.threadid=session.inthread
                WHERE inthread > 0
                AND lastactivity >= 1119495417
                GROUP BY inthread ORDER BY viewers DESC
mysql error: Unknown table 'session' in on clause

mysql error number: 1109

works with . TABLE_PREFIX . added to to session.inforum

[tamarian]

Originally Posted by Moparx

works with . TABLE_PREFIX . added to to session.inforum

Well, while we're at it, try the new version I just re-uploaded. It was missing one "as" alias. Let me know if it fixes it.

[Moparx]

working perfectly

[tamarian]

Originally Posted by Moparx

working perfectly

Great. I need to have a table prefix on my test server, so I don't forget those aliases

[Hornstar]

tamarian, im going to pm you....but im very interested to know anything you can share on finding the IP of a person who is ddossing my site.

Secondly if i find the ip of the person, they are most likely using a proxy, could there be a way to detect if that ip is a proxy, and if yes reveal the true ip.

and lastly, will blocking that ip address from my site, stop the ddosing, or are most ddosing programs going to hide the ip anyway.

Anything on this would be really good.

Another question because you seem smart ^^ someone was mentioning something about find out where they came from, im also interested to find out where people are coming from b4 they get to my site, e.g other sites or google etc.

Thanks for any info you can help me with.