I think I'll add a few more goodies. One thing that might pinpoint spikes is a one-minute chart, link for each minute to isolate what was going on. Also stats for most active hosts, scripts, spiders... stay tuned :)

Wa'il

What would be nice is to see query specs like whats the most run right now ect ect to troubleshoot even the queries being used.

You say to add:
Shouldn't it be:
You spelled vBusy with 2 's'.

You are correct :) I'll correct the spelling, but it should still work, since the spelling error is in the title, not the script name.

The most useful thing would be to see where the majority of people are coming from. Within the thread with the most views, show the referers by their frequency.

The referrer information is not stored in the session table. It's not that hard to add, it just requires adding a new field to the session table, and trivial code changes to the /includes/session.php file. So, it is doable. But there are a few caveats, that may make it not so desirable. The session data is not cumilative, which means when the visitor clicks on a link (say to see the next page in the thread), the record will be replaced with this activity, and the referrer will be your site/forum, so it will not give you the data you really want, unless you run the script at the righ time. This means if you run the script, a couple minutes later, you may not find the actual referrer.

The best thing to do, IMHO, is that once you identify the time when the spike occured, is to look at the server logs for that time period (you will have the exact time down to the second), and just look at the "referrer" tag in the apache log.

If you still want the referrer though, I can send you to required steps by PM, to avoid having others here do the database updates if they'd rather not have this feature. Or if there's enough demand, I can list the steps here.

Referrers would be useful.

tamarian, the situation which leads to the scenario I am taking about here is a link to a specific thread on your site from another site. (or sometimes if you're lucky, more than one site) when something particularly interesting has caught their attention.
Their referer information*should* in the first instance hold the site containing the link to yours.
Perhaps the referer information could only be stored if it's off site.
Although having all the referer information would allow us to show the route people take though the site. Something which may be useful in analysing how well presented and usable your site is.
However, I don't think any of this fucntionality is worth slowing down the forums significantly.
I can't actually analyse our apache logs as they are too big.

[Edit:] My moderators have asked if the thread title rather than the thread number could be shown. I agree that this would be most useful.

Nice hacks, installed en works like it should.

The session table won't be helpful in analysing the viewing patterns, or route through the site, because it replaces the activity, rather than add a new record.

There's an easier option, if you want to know when a specific site is sending referrals to you. You can add a short peice of code in showthread.php, that "if the referral is site xyz.com, then email this address that they've come". This would have the advanatage the information is not lost, and gives you an email alert. It also has the advanatage of no database access, and no added processing, unless the referral you're interested in has dropped by.

Exactly. The session table is heavily used, and any additional fields and processing in the session file will be executed on every single vBulletin function.

You might want to consider adding Urchin to your server. It's very effecient in crunching the logs and making useful reports out of it. Most hosting companies can install it for a one time license fee of $20 or so.

That would be easy to add.