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

[Dark_Wizard]

Originally Posted by theArchitect

I am sorry, I wasn't doubting the competency of your coding and certainly not insinuating that there was something wrong with your product. But there is clearly a problem with the way in which my board is processing this hack (I should add that I have installed this onto a fresh test board with no problems at all. It just won't work on my live board).

I have used the product manager to uninstall this hack and then re-installed it using the overwrite option. but am still getting the same error:

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

I was merely wondering if you might have had a solution to get around this problem so that I could use your excellent system.

I can help if you provide the following in a PM:

• * admincp access
  * mysql access
  * url where the hack is used

[ozmazdaclub]

how do i change the bug version from test to something else?

[ozmazdaclub]

Ignore my last post i found it... thanks!

[twitch]

If I try to delete one of the "statuses" in the admin panel, I get the following database error

Database error in vBulletin 3.5.0:

Invalid SQL:

	SELECT *
	FROM vbug_status
	WHERE vbug_statusid = 12;

MySQL Error  : Table 'clanvdqa_slave.vbug_status' doesn't exist
Error Number : 1146
Date         : Thursday, October 6th 2005 @ 01:18:48 PM
Script       : http://www.s2tg.com/forum/admincp/vbugs_admin.php?do=removestatus&vbug_statusid=12
Referrer     : http://www.s2tg.com/forum/admincp/vbugs_admin.php?do=modifystatus
IP Address   : 206.174.3.123
Username     : |s2tg|twitch
Classname    : vb_database

[twitch]

Also, how would I go about changing the link text on the vgub page "submite bug" to be an image instead of text? Where would I edit for that?

Great job on vbugtracker!

[majorxp]

This working ok on gold?

[ozmazdaclub]

Yes i have it running on my vb3.5.0 Gold board with no problems

[twitch]

Originally Posted by twitch

If I try to delete one of the "statuses" in the admin panel, I get the following database error

Database error in vBulletin 3.5.0:

Invalid SQL:

	SELECT *
	FROM vbug_status
	WHERE vbug_statusid = 12;

MySQL Error  : Table 'clanvdqa_slave.vbug_status' doesn't exist
Error Number : 1146
Date         : Thursday, October 6th 2005 @ 01:18:48 PM
Script       : http://www.s2tg.com/forum/admincp/vbugs_admin.php?do=removestatus&vbug_statusid=12
Referrer     : http://www.s2tg.com/forum/admincp/vbugs_admin.php?do=modifystatus
IP Address   : 206.174.3.123
Username     : |s2tg|twitch
Classname    : vb_database

Thats the only unfixed problem I have found

[ozmazdaclub]

any chance you can get the tracker to email an email address when a new bug is added or any bug is updated?

[Whissi]

Originally Posted by ozmazdaclub

any chance you can get the tracker to email an email address when a new bug is added or any bug is updated?

Yes! It would be nice If admins could configure vbug to report ne bug-reports.

User with bug-report subscription receiv their own answer... that's not good.

Another thing:

• Line-breaks looks like "\r\n"
• Option to edit bugs
• WYSIWYG Support :nervous: