Statistics Modifications - [DBTech] vBAnalytics v1 (vB4)

vBAnalytics: What is it?
vBAnalytics provides detailed and customized analytics from traffic including bounce rates, landings, pageviews, visits and many more customized just for vBulletin! Think Google Analytics but made for vBulletin!

Uses
If you ever wanted Google Analytics to provide more attention to your forum specific aspects than this is a must have for you. It provides statistics specifically requested from experienced board owners and displays them in an friendly and knowledgeable manner. Allowing even the most novice of board owners to know exactly what his users like and dislike in his community.

Use vBAnalytics to see how your individual forums are doing overtime, great to see if recent changes to boost activity there actually worked. You could do the same thing to individual pages in your forum, to see if recent changes to boost activity on those pages actually worked. With the pro version you can monitor search trends, to see what your users are searching on your forum and what links they click from the search allowing you to tailor to the needs of your community.

The benefits of this mod can raise your traffic and your overall member experience by showing exactly what the most and least popular aspects of your forum is. Tracking landings, bounces, visits and pageviews is a quintessential part of finding out where work needs to be done in order to improve your forum's activity and success.

-------------------------------------------------------------------------------------------

If you like this mod please hit the button to the right ---->

Please remember to click the, button to the right if you installed the mod ---->

What does 'Marking As Installed' do ?

* It helps you to stay on top of updates - members who have installed modifications will be notified by us whenever new updates are available.

* For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention.

* Marking a modification as installed also helps us know how many people are using our work, giving us extra incentive to provide more features and new modifications.

We appreciate the support!
-------------------------------------------------------------------------------------------

Priority support & Product Demos available at: http://www.dragonbyte-tech.com

-------------------------------------------------------------------------------------------

Translations available @ our forum
Support for translations handled by the translator in its respective threads only.

-------------------------------------------------------------------------------------------
Major Features
Automatically Track Analytics: Automatically track forum analytics. Daily or hourly scheduled tasks ensure data integrity and consistency without any involvement from you.

Flexible & Comprehensive: From forums, threads, members, registrations, searches and overall analytics tracking, vBAnalytics is the most comprehensive analytics add-on for vBulletin. Allowing you to specify what exactly you want to track and how the tracked data displays to you.

Comparing Data: Allows you to compare different data from different time periods to easily compare via graph and aggregated results.

Real-time Stats: You can see the exact analytics of your forum in real-time without having to wait like you would in other Analytics systems.

Conversions: Monitor new registrations to see how your site appeals to new users. Track register bounce rates, pageviews & time before and after members register to your site!

• Daily analytics tracking for:
  • Entire forum
    • Visits
    • Bounces
    • Pageviews
    • Pages/Visit
    • Total Time on Site
    • Average Time on Site
    • Referrals
  • Forums
    • Replies
    • Threads
    • Visits
    • Bounces
    • Landings
    • Pageviews
    • Pages/Visit
    • Referrals
  • Pages (this_script)
    • Visits
    • Bounces
    • Landings
    • Pageviews
    • Pages/Visit
    • Referrals
  • Registrations
    • Registrations
    • Activated Accounts
    • Bounces
    • Pageviews before and after registering
    • Posts
    • Time on site before and in the process of registering
    • Average time on site before and in the process of registering
  • Admin Defined Threads
    • Visits
    • Bounces
    • Landings
    • Pageviews
    • Pages/Visit
    • Referrals
    • Posts
    • Posts/Day
  • Admin Defined Members
    • Visits and the areas they were made in.
    • Bounces and the areas they were made in.
    • Pageviews and the areas they were made in.
    • Posts and the forums they were made in.
    • Threads and the forums they were made in.
    • Pages/Visit
    • Total Time on site.
    • Average Time on site.
  • Analytics for Searches
    • Amount of Searches
• Detailed graph shows timeline of analytics.
• Choose the metric you wish to compare in the timeline.
• Shows aggregated results of all metrics below graph.
• Compare two different time periods and/or page/forum/search/thread.
• Ajax-enabled browsers can compare and view analytics without page refresh.
• Google Analytics-esque page design to improve user expierence.

• Analytics Administration
  • Statistics Page shows analytic stats of today in real-time
    • Most Active Pages/Forums/Threads
    • Least Active Pages/Forums/Threads
  • Maintenance page to update the date of the first post in each forum and the total thread views for each forum.
  • Analytics Searching shows analytics stats of today in real-time for:
    • Forums
    • Threads
    • Pages
    • Searches
    • Sessions
  • Settings
    • Enable Modification
    • Enable Navbar Tab
    • Forum Integration
    • Default Overview - Number of days in the past to show for default in the analytics viewer.
    • Google Analytics template integration.
    • Enable hourly tracking instead of daily tracking. (Pro)
    • Threads to Track Over Time
    • Users to Track Over Time
    • Update Forum Total Views
    • Option to prune sessions older than x days.
• Per Usergroup
  • Can view vBAnalytics

Pro-only Features:

• Front-end
  • In-depth Conversions (New Registrations) tracking.
  • Average Time on Site.
  • Analytics for Searches.
• Analytics Administration
  • Option for hourly tracking.
  • Scripts to Exclude
  • Forums to Exclude

-------------------------------------------------------------------------------------------

This mod displays a copyright notification in the footer of pages generated by this mod which includes:

• Link to DragonByte Technologies homepage
• Link to Product Description page of this modification

-------------------------------------------------------------------------------------------

Notes:

1. Do not run any of the scheduled tasks manually. They are set up to run at the allotted times for a reason. If you run a scheduled task manually your analytics data will be extremely inaccurate.

[mort2412]

Already done thanks for your input ozzy

[ozzy47]

I was pretty sure that those errors were sorted, but I guess not.

[DragonByte Tech]

Originally Posted by mort2412

hi Im getting the following errors:

Warning: Non-static method VBANALYTICS_RESULTS::fetch_vbanalytics_array() should not be called statically in ..../dbtech/vbanalytics/actions/pages/users.php on line 48

Warning: Non-static method VBANALYTICS_RESULTS::fetch_vbanalytics_array() should not be called statically in ..../dbtech/vbanalytics/actions/pages/threads.php on line 45

Warning: Non-static method VBANALYTICS_RESULTS::fetch_vbanalytics_array() should not be called statically in ..../dbtech/vbanalytics/actions/pages/forums.php on line 74

And does this mod only calculate registration and other data from the day it was installed to the forum?

Can you try re-downloading the Lite version from here: http://www.dragonbyte-tech.com/demo/153-vbanalytics and see if that works for you?


Fillip

[spd2612]

Any idea why i would get this error

Invalid SQL:

SELECT dbtech_vbanalytics_tracking_scripts.*, dbtech_vbanalytics_tracking_scripts.this_script
FROM dbtech_vbanalytics_tracking_scripts AS dbtech_vbanalytics_tracking_scripts

WHERE (dbtech_vbanalytics_tracking_scripts.dateline BETWEEN '1409716801' AND '1410407999') AND this_script != ''

ORDER BY dbtech_vbanalytics_tracking_scripts.pages/visit DESC
LIMIT 0, 20;

MySQL Error : Unknown column 'dbtech_vbanalytics_tracking_scripts.pages' in 'order clause'
Error Number : 1054
Request Date : Wednesday, September 10th 2014 @ 03:08:38 PM
Error Date : Wednesday, September 10th 2014 @ 03:08:38 PM
Script : http://tsite.com/forums/vbanalytics....&submit=Submit
Referrer : http://site.com/forums/vbanalytics.php
IP Address : 24.38.44.147
Username : test
Classname : vB_Database_MySQLi
MySQL Version : 5.5.28

[spd2612]

And now this error

And now this error

Database error in vBulletin 4.2.0:

Invalid SQL:

INSERT INTO dbtech_vbanalytics_tracking_users
(userid, visits, bounces, pageviews, total_time, posts, threads, data, dateline)
SELECT
userid,
dbtech_vbanalytics_visits,
dbtech_vbanalytics_bounces,
dbtech_vbanalytics_pageviews,
dbtech_vbanalytics_total_time,
dbtech_vbanalytics_posts,
dbtech_vbanalytics_threads,
dbtech_vbanalytics_data,
1410321599 AS dateline
FROM user;

MySQL Error : Duplicate entry '1-1410321599' for key 'PRIMARY'
Error Number : 1062
Request Date : Wednesday, September 10th 2014 @ 04:04:22 PM
Error Date : Wednesday, September 10th 2014 @ 04:04:22 PM
Script : http://web.com/forums/cron.php?rand=1410379461
Referrer : http://web.com/forums/member.php?16-ssratracer
IP Address : 24.38.44.147
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

[ForceHSS]

Originally Posted by spd2612

Any idea why i would get this error

Invalid SQL:

SELECT dbtech_vbanalytics_tracking_scripts.*, dbtech_vbanalytics_tracking_scripts.this_script
FROM dbtech_vbanalytics_tracking_scripts AS dbtech_vbanalytics_tracking_scripts

WHERE (dbtech_vbanalytics_tracking_scripts.dateline BETWEEN '1409716801' AND '1410407999') AND this_script != ''

ORDER BY dbtech_vbanalytics_tracking_scripts.pages/visit DESC
LIMIT 0, 20;

MySQL Error : Unknown column 'dbtech_vbanalytics_tracking_scripts.pages' in 'order clause'
Error Number : 1054
Request Date : Wednesday, September 10th 2014 @ 03:08:38 PM
Error Date : Wednesday, September 10th 2014 @ 03:08:38 PM
Script : http://tsite.com/forums/vbanalytics....&submit=Submit
Referrer : http://site.com/forums/vbanalytics.php
IP Address : 24.38.44.147
Username : test
Classname : vB_Database_MySQLi
MySQL Version : 5.5.28

Unknown column means you are missing a table you need to reinstall go to their site and download the latest version as it will also fix your other problem

[DragonByte Tech]

vBAnalytics v1.2.0 Patch Level 1

Bug Fixes:

• Fixed an issue with the cron calculations that could produce a database error

Fillip

[m7sen]

can you support this mod for vb 3.8.8 please

[Pandemikk]

There's not enough demand for us to make that possible, sorry

[DragonByte Tech]

Changed Features:

• A fresh copy of the jQuery library is now only downloaded if one has not been downloaded previously. Requires updating of all other affected DBTech mods to take full effect.

Fillip