vBug Tracker Lite 3.5.1

[high]The XSS security flaw reported in this modification has been fixed by Staff and a new zip file (3.5.1a) uploaded.[/high]

Here is a port of my vBug Tracker hack from vb 3.0.x. This mimics the Bug Tracker found at vBulletin.

Details:

• 7 - table additions
  96 - Phrases Added
  3 - file additions
  2 - xml files
  8 - template additions
  3 - Plugins

Please click install for support! For those interested, the Pro version is in development and should be out soon. It will be released at vb-scripts.com.

Sept 25, 2005
Bug fixes:

• * Added Missing phrases for editing status, type & severity.
  * Fixed bug in changing displayorder

Sept 26, 2005
Bug Fixes/Changes

• * Fixed bugcache issue and tested
  * Added admin usergroup permissions

Sept 27, 2005 (Part 1)
Bug Fixes:

• * Fixed subscribe issues and missing phrases.

Sept 27, 2005 (Part 2)

• * Complete rewrite of the subscription piece including the unsubscribe.
  * Subscriptions fully tested and working from all aspects!

Nov 7, 2005

• * Fixed missing table prefix when editing status.
  * Fixed issue when editing severities.
  * Now supports secondary usergroups.

Nov 24, 2005

• * Fixed extra span tag in list template.
  * Fixed searching on version.
  * Added "unassigned" to dropdown.

Jul 11, 2006

• * XSS Flaw fixed by Staff.

To upgrade:

Import the product xml and select "Allow Overwrite".
Upload all the files overwriting the old ones.

Lastly... Please follow the instructions exactly as they are outlined in the documents/install.txt and in the order as listed to avoid any problems.

Updated for vBulletin 3.7, Get it here

[Noxious]

Originally Posted by Zelda-King

Backup the vbug tables and then when the product is reinstalled, select edit for one of your types/versions then save in order to update the dropdowns.

may i point to the quoted highlighted part

[akanevsky]

Of course, but if there is a difference in table structure between the new and old versions, there could be a problem.

[Noxious]

ah stop crying your only moaning because you expect people to be ripped off by you, if you wanna upgrade from vb3.5 to vb3.6 and keep the bug system all you have to do is manually enter this sql code

INSERT INTO datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:5:\"title\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:9:\"Won''t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:5:\"title\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:5:\"title\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:5:\"title\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}',0);

otherwise if its a new installation, the altered files me and murdo did in this post are fine.

quite simple really isn't it much better than being ripped off $35 for one, wouldn't you say. Lets all boycot VisonScripts and shut this fool up once and for all, says everything about him his sig do not expect any of my free 3.5 hacks to become available on 3.6 anytime soon! get a life stop trying to rip people off

[Delphiprogrammi]

Originally Posted by Noxious

ah stop crying your only moaning because you expect people to be ripped off by you, if you wanna upgrade from vb3.5 to vb3.6 and keep the bug system all you have to do is manually enter this sql code

INSERT INTO datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:5:\"title\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:9:\"Won''t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:5:\"title\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:5:\"title\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:5:\"title\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}',0);

otherwise if its a new installation, the altered files me and murdo did in this post are fine.

quite simple really isn't it much better than being ripped off $35 for one, wouldn't you say. Lets all boycot VisonScripts and shut this fool up once and for all, says everything about him his sig do not expect any of my free 3.5 hacks to become available on 3.6 anytime soon! get a life stop trying to rip people off

hmmm "being ripped off" i use two scripts provided by visonscripts and i have never been ripped off.This bugtracker is nothing compared to the Vs bugtracker ...If he chooces not to update his free hacks that's his right nothing you can say about that.

[Zelda-King]

Originally Posted by Psionic Vision

Of course, but if there is a difference in table structure between the new and old versions, there could be a problem.

Possible. I haven't found one yet. What I do have is a cosmetic problem as reported in this post. It looks alright when a new bug is submitted then goes awry (see attachment in link) when an admin edits/assigns the bug.

[akanevsky]

do not expect any of my free 3.5 hacks to become available on 3.6 anytime soon!

The reason I have that in my signature is because I do have a life and unfortunately, due to a variety of personal reasons that exist outside of the internet, this particular year have almost no spare time. I won't get into details as to why since you probably don't care anyway...

P.S. It seems that there is a slight difference between the datastore table in vBulletin 3.5 and vBulletin 3.6... Also, foreach is not just a cosmetic problem, but instead it a rather significant sign that there is a problem within the script, and that problem is causing an array of information not to be built properly. I wouldn't know the reason though since I am not the author of this script...

[alfaowner]

I get this every time I try to update the usergroups permissions:

Love to use this... any help out there... its ugp in field list unknown??

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Admin',
`opentag` = '<span style=\"color: #FF7D01; font-weight: bold; text-decoration: none;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`pagerpermissions` = '13',
`pagerquota` = '100',
`pagerminpost` = '0',
`pagerminpostperday` = '0',
`pagermaxperday` = '10000',
`pagersendmax` = '100',
`pagersendmaxchar` = '500',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '150',
`pmpermissions` = '3',
`pmsendmax` = '100',
`calendarpermissions` = '63',
`wolpermissions` = '23',
`adminpermissions` = '3',
`genericpermissions` = '205520895',
`genericoptions` = '23',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '100000',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '100',
`avatarmaxsize` = '20000',
`advanced_bbcode_usergroup_on` = '1',
`advanced_bbcode_usergroup_permissions` = '121',
`advanced_bbcode_usergroup_permissions_custom` = 'a1024',
`googlemappermissions` = '1',
`vbugpermissions` = '7',
`ugp` = '0'
WHERE usergroupid=6;

MySQL Error : Unknown column 'ugp' in 'field list'
Error Number : 1054
Date : Tuesday, November 21st 2006 @ 08:51:59 PM
Script : /faqtests/admincp/usergroup.php
Referrer : http:///faqtests/admincp/usergroup.p...&usergroupid=6
Username : alfaown
Classname : vb_database


BTW - I installed this one as well, still get same error - vBug Tracker Lite 3.5.1a (with 3.6 support).zip

[midihead]

Been a while since last post. Any support still for this?

Thanks,

M

[midihead]

Any fix yet for the blank page issue? I get a blank page when I check the "subscribe" box and submit a message. This only occurs if I'm REPLYING to an existing bug, not when I post one.

I see others have experienced the same thing. Would be nice to have a fix. Also, it appears to be posting the reply, but twice. Any ideas?

One more thing: How can I set it up so that an Admin is notified every time a new bug or reply is posted?

Thanks,

M

[akanevsky]

This project has long been dead, you may want to check out vS-Bug Tracker instead. You can find the link in my signature.