Major Additions - vBTracker LITE - Dynamic Project Tracker

vBTracker is a dynamic project tracking system for your vBulletin!

Remember vBulletin.com's original Bug Tracker? vBTracker looks and does all of that and more!

Please note this is a LITE version containing about one third of the features of the PRO version

LITE Features

• Unlimited Concurrent Tracking Projects
  • Define Project Title, Link, Description and Versions
  • Define Active and Ordering
    • Can Remove Active Tracker from Project Directory
• Project Directory and Browsing
  • Completion Meter Based on Accepted Final Status Submissions
  • Edit Titles and Submission Active via Inline Ajax
  • Familiar Thread Icons and Markers
  • Finalized Submissions Removed from Active Listing
  • Narrow and Order Submissions by All Criteria
  • Project Jump
  • Split Submissions Over Pages
• Submissions
  • Edit Properties via Ajax by Double Clicking Properties Bar
  • Accepted Final Status Optional Response Disable
  • Core Forum Enables Searching, Subscriptions, and Alerts
  • Quick Links to New Submission, Subscription, and Accept Status
• Overall Quality
  • Preserves vB Environment
  • Fully Phrased
  • Complete Admin Help
  • WOL Locations
  • Unique Plugin Optimization
  • Uses Bitfields and Datastore
  • Maintains Sessions
  • No File or Template Edits

To compare the full set of features for the PRO version, view the vBTracker Project Page. Note that projects and submissions made in the LITE version will not be lost should you choose to upgrade. Also: Admins, Super Mods, Mods and Registered Users are the only usergroups who will have access, the latter of which has only viewing access.

If you are running vBulletin 3.6.5 or older, apply the Fix for Old vBulletins.txt!

View Our Guest Enabled Screenshot Gallery

What kind of stuff would I want to track?
If you run any kind of business or develop anything really, you'll want to be able to track progress in more structured manner. I myself made this hack so that I could have multiple Bug Trackers, Support Ticket Systems, Feature Suggestions, Submissions Review, and even track the ton of custom job requests I get all the time Basically vBTracker can be made to track anything, and you can view my own project directory as a Guest Viewable Live Demo.

Also, as a LITE script this will not receive any real updates save the obligatory bugfix, but I am happy to support your use of the LITE version here Thank you for using my scripts! To show your appreciation, please indicate that you have installed it, or perhaps a MOTM nomination Enjoy!

12, 1

[yoyoyoyo]

cool, thanks for the release

[cygy2k]

I uploaded and set permissions, etc but get a SQL error when trying to add an item to a project....

Database error in vBulletin 3.6.8:
Invalid SQL:
INSERT INTO tracker_items
(assignedid, threadid, projectid, versionid, severityid, typeid, statusid)
VALUES
(
,
16399,
1,
'1',
1,
1,
1
);
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
16399,
1,
'1',
1,
1,
1
)' at line 5
Error Number : 1064
Date : Monday, November 19th 2007 @ 09:10:16 AM
Script : http://www.xxx.com/forum/tracker.php...em&projectid=1
Referrer : http://www.xxx.com/forum/tracker.php?projectid=1
IP Address : xxx
Username : xxx
Classname : vb_database

[cygy2k]

I figured out the problem was that I hadn't tried assigning the item to a member. Can we get an error message pop-up or page stating all fields aren't completed instead of a generic SQL message?

[Darkwaltz4]

*ahem* bleeding edge thanks

in tracker.php find twice:

PHP Code:

if (!is_member_of($vbulletin->userinfo, 5, 6)) 


replace both with:

PHP Code:

if (!is_member_of($assign, 5, 6)) 


zip updated as well

[cygy2k]

Well I don't know why there are only 4 downloads - this is an amazing mod. Thank you so much!!!

[cygy2k]

Another database error issue. When editing a post outside of the project designated forum (i.e. completely different category and everything) gives the below message...

Database error in vBulletin 3.6.8:
Invalid SQL:
UPDATE tracker_items AS items LEFT JOIN tracker_statuses AS status ON (items.statusid = status.statusid) SET items.active = IF (status.final, , items.active) WHERE items.threadid = 16427;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' items.active) WHERE items.threadid = 16427' at line 1
Error Number : 1064
Date : Monday, November 19th 2007 @ 01:57:00 PM
Script : http://www.xxx.com/forum/editpost.php

Referrer : http://www.xxx.com/forum/state-rival...ot-friend.html

IP Address : xxx
Username : xxx
Classname : vb_database

[Darkwaltz4]

thanks for your carefulness as well as praise - i tried to make the lite version still have the essence of the pro one

to fix that error, replace the contents of the vBTracker - Define Active Open plugin with

PHP Code:

if ($this->fetch_field('open') !== null)
{
$this->dbobject->query_write("UPDATE " . TABLE_PREFIX . "tracker_items AS items LEFT JOIN " . TABLE_PREFIX . "tracker_statuses AS status ON (items.statusid = status.statusid) SET items.active = IF (status.final, " . $this->fetch_field('open') . ", items.active) WHERE items.threadid = " . $this->fetch_field('threadid'));
} 


also, another error, in tracker.php find

PHP Code:

$vbulletin->GPC['statusid'] 


and replace with

PHP Code:

$vbulletin->GPC['status'] 


updating the zip. anything else?

[PixelFx]

Another toy for vb.org members to enjoy , its really helped with managing my own projects as well. I can't begin to say how powerful this new script is. I could of used it 3 years ago with one of my game development sites. We needed something that could track bugs, projects, and development teams. This little script can do multiple versions of all that. !!

[cygy2k]

Just put the fixes in place and will do some testing and let you know. Thanks so much again!