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

[jluerken]

I found a small bug:

I added an additional usergroup and set this group as secondary group to some of my users.
Those users should be allowed to administrate bugs.

I gave the rights to that group but it is not working.
I cannot select people from this group to assign them calls.

It is working when I make this group a primary usergroup but I can't do this.

Please Dark_Wizard, how can I make also Secondary Usergroups work?

[SilverDawn]

I keep getting the below error when I do the "Add/Import Product" step. I did have the vBug Tracker 1.0.3 for vb 3.0 previously.

Any ideas?

Database error in vBulletin 3.5.1:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'vbug_bugsperpage',
'vbug',
'15',
'15',
'number',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==5,\'selected=\"selected\"\') . \">5</option>\r\n<option value=\\\"10\\\" \" . iif($setting[\'value\']==10,\'selected=\"selected\"\') . \">10</option>\r\n<option value=\\\"15\\\" \" . iif($setting[\'value\']==15,\'selected=\"selected\"\') . \">15</option>\r\n<option value=\\\"20\\\" \" . iif($setting[\'value\']==20,\'selected=\"selected\"\') . \">20</option>\r\n</select>',
10,
0,
1,
'vBug'
),
(
'vbug_status',
'vbug',
'1',
'1',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\" . eval(\'$states = $vbulletin->db->query_read(\"SELECT vbug_statusid, title FROM \" . TABLE_PREFIX . \"vbug_status\");\r\nwhile ($state = $vbulletin->db->fetch_array($states))\r\n{\r\n $options .= \"<option value=\\\"$state[vbug_statusid]\\\" \" . iif($setting[\\\'value\\\']==$state[\\\'vbug_statusid\\\'],\\\'selected=\"selected\"\\\') . \">$state[title]</option>\";\r\n}\r\nreturn $options;\') . \"</select>',
20,
0,
1,
'vBug'
),
(
'vbug_bug_moderate',
'vbug',
'0',
'0',
'boolean',
'yesno',
30,
0,
1,
'vBug'
),
(
'vbug_versionname',
'vbug',
'vBug',
'vBug',
'',
'',
40,
0,
1,
'vBug'
),
(
'vbug_admin_legend',
'vbug',
'1',
'1',
'boolean',
'yesno',
50,
0,
1,
'vBug'
);

MySQL Error : Duplicate entry 'vbug_status' for key 1
Error Number : 1062
Date : Saturday, November 5th 2005 @ 01:28:04 PM
Script : http://dfrsquad.com/forums/phpsuper/plugin.php
Referrer : http://dfrsquad.com/forums/phpsuper/...?do=productadd
IP Address : 24.243.43.250
Username : dfr.sd
Classname : vb_database

[Dark_Wizard]

Originally Posted by SilverDawn

I keep getting the below error when I do the "Add/Import Product" step. I did have the vBug Tracker 1.0.3 for vb 3.0 previously.

Any ideas?

There wasn't an updater included with this thus your error. Contact me via IM and I will help you through removing the old version so you can install the new version.

[Dark_Wizard]

Originally Posted by jluerken

I found a small bug:

I added an additional usergroup and set this group as secondary group to some of my users.
Those users should be allowed to administrate bugs.

I gave the rights to that group but it is not working.
I cannot select people from this group to assign them calls.

It is working when I make this group a primary usergroup but I can't do this.

Please Dark_Wizard, how can I make also Secondary Usergroups work?

I will look into this....

[theArchitect]

I have just upgraded to 3.5.1 and the uptions under User Groups to set if members can see/add etc. bugs have vanished.

I checked and the bitfield_vbug.xml file is in the includes directory. I have even re-imported the Product but still nothing.

[Dark_Wizard]

Originally Posted by theArchitect

I have just upgraded to 3.5.1 and the uptions under User Groups to set if members can see/add etc. bugs have vanished.

I checked and the bitfield_vbug.xml file is in the includes directory. I have even re-imported the Product but still nothing.

Upgrade coming in about 15mins....

[Dark_Wizard]

New version released, sorry for the delay as I have been very busy lately.

[theArchitect]

Originally Posted by Dark_Wizard

New version released, sorry for the delay as I have been very busy lately.

The user group permissions have appeared ok, but I am getting this error message when I go to vbugs.php:

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT userid, username
FROM user
WHERE usergroupid IN(5,6)
OR FIND_IN_SET(5,6, membergroupids);

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 ' membergroupids)' at line 4
Error Number : 1064

[Dark_Wizard]

Originally Posted by theArchitect

The user group permissions have appeared ok, but I am getting this error message when I go to vbugs.php:

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT userid, username
FROM user
WHERE usergroupid IN(5,6)
OR FIND_IN_SET(5,6, membergroupids);

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 ' membergroupids)' at line 4
Error Number : 1064

One sec...looking into it. Stick around

[theArchitect]

Originally Posted by Dark_Wizard

One sec...looking into it. Stick around

I may have to catch your next update in the morning. I have the Flu, it is 12:23 am here and I have been working for the last 16 hours; so I don't know if I can keep my eyes open much longer.