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

[timmed]

I'm getting an SQL error

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
UPDATE vb3_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<font color=\"red\"><b><i>',
`closetag` = '</i></b></font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '500',
`pmpermissions` = '3',
`pmsendmax` = '500',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '204472255',
`genericoptions` = '31',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`supportpermissions` = '0',
`vbugpermissions` = '7'
WHERE usergroupid=6;

MySQL Error : Unknown column 'supportpermissions' in 'field list'
Error Number : 1054
Date : Sunday, September 25th 2005 @ 04:24:54 PM
Script : url/admincp/usergroup.php
Referrer : url/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : HIDDEN
Username : Admin
Classname : vb_database

[Revan]

Another error: When editing statuses, the print_table_header phrase is empty.

[Dark_Wizard]

Originally Posted by Revan

Another error: When editing statuses, the print_table_header phrase is empty.

Ok...let me look into it...

[Dark_Wizard]

Originally Posted by timmed

I'm getting an SQL error

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
UPDATE vb3_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<font color=\"red\"><b><i>',
`closetag` = '</i></b></font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '500',
`pmpermissions` = '3',
`pmsendmax` = '500',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '204472255',
`genericoptions` = '31',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`supportpermissions` = '0',
`vbugpermissions` = '7'
WHERE usergroupid=6;

MySQL Error : Unknown column 'supportpermissions' in 'field list'
Error Number : 1054
Date : Sunday, September 25th 2005 @ 04:24:54 PM
Script : url/admincp/usergroup.php
Referrer : url/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : HIDDEN
Username : Admin
Classname : vb_database

supportpermissions is another hack and isn't associated with vBug Tracker. Did you just uninstll a support hack? If so the uninstaller didn't remove it's permissions.

[timmed]

Originally Posted by Dark_Wizard

supportpermissions is another hack and isn't associated with vBug Tracker. Did you just uninstll a support hack? If so the uninstaller didn't remove it's permissions.

actually, yes i did, thanks

[Dark_Wizard]

Originally Posted by mtha

install and get this msg. everything seems working fine

Are you running a branded free vbulletin? This line does a preg to add my info to the vbulletin footer.

[Zelda-King]

Originally Posted by Dark_Wizard

Go to your admincp and edit only one of each item i.e Version, type, status etc...and then your cache will be set. Let me update the installer so this won't happen again.

That did the trick. Cheers!

Successfully posted a test bug too.

[hydrostatic]

Originally Posted by Dan

Might want to change that error message as it's under usergroup settings not Admin Permissions. Also when adding this I got this blank field under Admin Permissions screen.

That's caused by another hack, not this one as I took the liberty to find out. It's caused by the RPG Inferno hack.

[Zelda-King]

I found a little something: In 'Modify Bug Types' it doesn't save the orders if you edit them. To update the order you have to click on each bug type manually.

[hydrostatic]

Originally Posted by Zelda-King

I found a little something: In 'Modify Bug Types' it doesn't save the orders if you edit them. To update the order you have to click on each bug type manually.

Yeah update order doesn't work on anything including severities etc. I think that's because there's no "redirect" thing. Also, I'm not sure if this is intended, the bar on top when you edit bug types is a little weird looking. Nothing major though. Other than that, no bugs & great hack. Thanks man.