vBTracker LITE - Dynamic Project Tracker

[Darkwaltz4]

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 (http://www.vbcredits.com/projects/vbtracker/index.php). 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 (http://www.vbcredits.com/gallery/browseimages.php?c=8)

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 (http://www.vbcredits.com/forum/tracker.php).

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?do=newitem&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 :D thanks

in tracker.php find twice:

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


replace both with:

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-rivals/16427-got-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

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

$vbulletin->GPC['statusid']


and replace with

$vbulletin->GPC['status']


updating the zip. anything else? :D

[PixelFx]

Another toy for vb.org members to enjoy :D, 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. :D!!

[cygy2k]

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

[ERuiz]

I installed it as per your instructions, but I don't see any options in the usergroups, to control their permissions for vbTracker. I have VB 3.6.7 installed.

EDIT: Nevermind, just noticed that the Usergroups feature is for the PRO version only.

[Darkwaltz4]

as noted the following permissions are hardcoded for the lite version:

A = admins, S = super mods, M = mods, R = registered users

can see and browse tracker projects: RASM
can post and reply: ASM
can edit own responses: AS
can edit all responses: A
can be assigned to submissions: AS
can manage submissions (update properties): A

[projectego]

Awesome! :D

* projectego clicks install

[trancetopia]

I've followed the instructions, rechcked them but no matter what I change the setting to I continue to get the following message:

Sorry, there are no projects available for you to browse at this time.

I have created the initial project as per your notes but it's not being identified!

[Darkwaltz4]

the order for the project has to be greater than 0. using a value of 0 will not prevent access if you accessed a direct link, but removes from the project directory.

[trancetopia]

That did the trick, thank you.

[MDK-Indy]

Salü,

i have a Design error...

see Picture...

[Darkwaltz4]

please note that i design from the default vbulletin skin, if there are any discrepancies in the style its to be expected..

to fix that, increase the size of the box in the tracker_project template

[MDK-Indy]

That is the default vbulletin skin.

greeting Indy

[Darkwaltz4]

well then blame the browser :D either way once its not 100% it will look okay, and you can increase the size of the completion box by 5 pixels in the tracker_project template

[MDK-Indy]

5 pixels make the error bigger, 2 pixels fix it ;)

greeting Indy

[RedGTiVR6]

wow -

this is what I've been looking for for ages!

One question...in either the lite or the full version, is it possible to have fields that MUST be filled out?

For instance, right now I have users submit a form: http://www.mp3car.com/vbulletin/newthread.php?do=StreetDeck%20Bug%20Report

Once the user submits the bug, a new thread is created in the bug reporting forum, here: http://www.mp3car.com/vbulletin/streetdeck-bug-reports/

I've used the following hacks to make this whole system work:

Forms hack
Support Forum hack
New thread icons hack
New thread button hack

It's very cumbersome and it leaves a LOT to be desired.

This hack looks like it does most everything I need, except for custom fields. Is this the case?

I'm trying to find a price on the vBCredits web page, but I cannot find a price at all.

[RedGTiVR6]

question -

If you turn off the portal, you can link to each tracker using the link tracker.php?projectid=X, where X is the projectid for the specific tracker.
So lets say I have multiple individuals hosting their software on our forums. I'd like to give each of them the ability to have their own tracking system but I don't want it all to be located through one link. I'd rather they create a link in their forum to their particular project and their users access that project tracker via that link. Is this possible with this setting?

[Darkwaltz4]

wow -

this is what I've been looking for for ages!

One question...in either the lite or the full version, is it possible to have fields that MUST be filled out?

For instance, right now I have users submit a form: http://www.mp3car.com/vbulletin/newthread.php?do=StreetDeck%20Bug%20Report

Once the user submits the bug, a new thread is created in the bug reporting forum, here: http://www.mp3car.com/vbulletin/streetdeck-bug-reports/

I've used the following hacks to make this whole system work:

Forms hack
Support Forum hack
New thread icons hack
New thread button hack

It's very cumbersome and it leaves a LOT to be desired.

This hack looks like it does most everything I need, except for custom fields. Is this the case?

I'm trying to find a price on the vBCredits web page, but I cannot find a price at all.

All of the submission properties must be configured upon submission, as you can see in this screenshot http://www.vbcredits.com/gallery/showimage.php?i=26&c=8

You can use the versions field for a custom settings field, and you can see how I do that in my own project directory http://www.vbcredits.com/forum/tracker.php
Otherwise, adding/editing/deleting the severity/type/status labels is only available in the pro version (the set is hardcoded in lite)

You can see the price for it when you click the purchase button on this page http://www.vbcredits.com/projects/vbtracker/index.php. I cant say the price here, but its less than Project Tools

question -


So lets say I have multiple individuals hosting their software on our forums. I'd like to give each of them the ability to have their own tracking system but I don't want it all to be located through one link. I'd rather they create a link in their forum to their particular project and their users access that project tracker via that link. Is this possible with this setting?

Yes, simply add their project, and look in the project manager to find the id for that project. Report to that group what their project id is, and they can then link to it.
Note that should an outsider guess the url, they will have regular access. Also remember lite has usergroup restrictions, so your script hosters will need to be moderator or better to post in it. Full usergroup permissions as well as usergroup restriction per project is in pro.

[ChaosProgrammer]

My users are unable to post any bug. As an admin, I can. DO you know why this happens?

[RedGTiVR6]

Can they see the projects?

[Crrrazzzy]

I don't see the Usergroup Permissions area for the vBTracker. The only thing I see in the ACP for the vBTracker is this:

http://www.vbcredits.com/gallery/showimage.php?i=32&c=8

Without the last two options. "Manage Labels" and "Manage Submissions" are not there.

Did I mis-install?

[RedGTiVR6]

Those are options only available in the pro version.

To learn about the difference between the pro and lite versions, see here: http://www.vbcredits.com/projects/vbtracker/index.php

[Crrrazzzy]

Gotcha. How much is the pro version? (I'm registering right now just to check it out)

[Darkwaltz4]

My users are unable to post any bug. As an admin, I can. DO you know why this happens?

Can they see the projects?

Usergroup permissions are hardcoded in LITE, but available in PRO. to see what they are in LITE, i detailed that in this post:
https://vborg.vbsupport.ru/showpost.php?p=1386071&postcount=12

I don't see the Usergroup Permissions area for the vBTracker. The only thing I see in the ACP for the vBTracker is this:

http://www.vbcredits.com/gallery/showimage.php?i=32&c=8

Without the last two options. "Manage Labels" and "Manage Submissions" are not there.

Did I mis-install?

Gotcha. How much is the pro version? (I'm registering right now just to check it out)

to see what you are missing and how much it costs, see the link posted above or in the first post (i cant post that here or another link) thanks! :)

[bjohnson045]

Is it possible to import projects/bugs from vBulletins official Project Tools addon?

[Darkwaltz4]

not as of yet :) but planning to.

[speedoleague]

<font color="black">Can't seem to view the demo version, wants’ me to login first</font>

[PixelFx]

I updated the site permissions so you shouldn't have any issues with a non registered account. Registering on our site is also free for users. we have a bigger feature list on the site should it interest you. Thanks for bringing this to my attention.

[speedoleague]

Still can't see it if your not a member, I'll just signup

[Darkwaltz4]

sorry for that - we modified the permissions to our site recently, and pixelfx accidentally turned off the guest permissions for those sections

they have been restored again to be guest-viewable :)

[speedoleague]

sorry for that - we modified the permissions to our site recently, and pixelfx accidentally turned off the guest permissions for those sections

they have been restored again to be guest-viewable :)

Just for you information it still doesn't work if your a guest

[Darkwaltz4]

actually the gallery was working fine, but youre right my demo link wasnt, which has been enabled again now :) and i tested it as a guest too!

[bjohnson045]

I would definitely use this and donate but would need to be able to import first. Too much data in vB project tools right now :(

[cosy]

anyone tested this on vb 3.7?

installed lets se

[PixelFx]

I use the pro version on my personal site, of vbtracker and it's working great, I don't see why the lite version wouldn't work any less on a 37x site.

posted a few screenshots of it working vbulletin 3.7.x beta 4 on my site for those interested.

[Black Tiger]

I just discovered this one, I don't really need it, but again it's a great hack and I'm interested for minor support things on my forums.

Thanks for posting your comment and screenshots PixelFX, I don't need to ask the 3.7.x question now.;)

Will tag this mod for now and will install it after I moved the rest of my mods to the TMS system.:)

[malag]

My users can not use it :/
"You have not permission".
Where I can change it?

[Darkwaltz4]

vBTracker LITE has hardcoded user permissions which make it more suitable for internal tracking. What groups get what is detailed in this post:
https://vborg.vbsupport.ru/showpost.php?p=1386071&postcount=12

[caedas]

Dumb question, but am I able to adjust the progress bar? If not, on what values does it adjust?

Thanks!

[Darkwaltz4]

the progress bar is based on (completed submissions) / (all submissions)

what qualifies as a completed submission is one that is set to a final status (like completed, etc), and then the "accept status" link is clicked, which shows up after you first change the status to it. you can also accept status by double clicking the envelpe icon. you will know you did it right if it gets removed from the active listing. (you can still see completed submissions by selecting the status group it was in)

[fredang85]

"Sorry, there are no projects available for you to browse at this time."

I read that trancetopia had the same problem as me and he created a initial project. How do I do it?

[Darkwaltz4]

in the acp there is a link to the project manager under the vbtracker menu :)

[fredang85]

ahhh okay i didin't see the menu. thx!

[dcw]

Does this work well with 3.7?

[Darkwaltz4]

i personally am using it on two sites with vb3.7, and nothing problematic :D

[joe1989]

My completion meter does not work properly. It says 0% no matter what, even if I change one to "Fixed / Completed"

I am running 3.7.0

Thanks!

[Darkwaltz4]

there are two steps a submission must go through before it is counted as completed.

first, it must belong to a final status such as Fixed / Completed. then the admins and the person who submitted it should see a special link in the top right of their submission box which they click to accept the status change which marks the submission as finished. then it will count in your completion meter and vanish from the listing (you can still see it if you select the status group it belonged to)

[joe1989]

there are two steps a submission must go through before it is counted as completed.

first, it must belong to a final status such as Fixed / Completed. then the admins and the person who submitted it should see a special link in the top right of their submission box which they click to accept the status change which marks the submission as finished. then it will count in your completion meter and vanish from the listing (you can still see it if you select the status group it belonged to)

Worked like a charm! Thank you!

[sparkster666]

the Configure Settings link in the admincp brings me to a black page

[Darkwaltz4]

edit (forum)/includes/xml/cpnav_tracker.xml

find and remove


do=options&amp;