The Arcive of Official vBulletin Modifications Site.

vBug Tracker 1.0.3 · **Released**: 09-17-2004

You asked for it and here it is...a bug tracker that mimics the one at vBulletin.com.
There is no upgrade yet from the other bug trackers listed on this site but if enough people request it I will add it to the installer.

Also, please DO NOT request help, assistance or ask questions via IM as I will ignore you and if your persistent will block you. Your best option for immediate support is at vbwar.com but I will check in here from time to time.

Enjoy!

Please click install if you use this hack. Support is only given to those who click. Thx!

Version 1.0.1:
Fixed missing phrase (here)
Fixed redirect to blank page after edit bug
Fixed assigned to not working after bug edit

Version 1.0.2:
Finally fixed the dropped title and missing phrases.
Plus a few other small bugs you people didn't catch.

New bug found...file updated. Users of version 1.0.2 need to perform these steps found here.

Version 1.0.3:
Fixed all tableprefixes and a small bug. Tested in both tableprefixed db and no tableprefix db...

Pro Version can be seen here!

Additional support can be found here.

Vman · #**142** 01-09-2005, 06:42 PM

I am now getting this error since I upgraded to 3.0.5....

--------------------------------------

Database error in vBulletin 3.0.5:

Invalid SQL:
SELECT usergroupid, (vbugpermissions & CANADMINBUGS) AS CANADMINBUGS
FROM usergroup

mysql error: Unknown column 'CANADMINBUGS' in 'field list'

mysql error number: 1054

Date: Sunday 09th of January 2005 02:40:35 PM
Script: http://www.fitnessgeared.com/forum/vbugs.php

-------------------------------------

what do i need to do to correct this!!!

reteep · #**143** 01-10-2005, 07:42 AM

Quote:

Originally Posted by BBCVman

I am now getting this error since I upgraded to 3.0.5....
--------------------------------------
Database error in vBulletin 3.0.5:

Invalid SQL:
SELECT usergroupid, (vbugpermissions & CANADMINBUGS) AS CANADMINBUGS
FROM usergroup

mysql error: Unknown column 'CANADMINBUGS' in 'field list'

mysql error number: 1054

Date: Sunday 09th of January 2005 02:40:35 PM
Script: http://www.fitnessgeared.com/forum/vbugs.php
-------------------------------------
what do i need to do to correct this!!!

You forgot to reedit the init.php:

Quote:

find:
**************************************************
// ### INSERT PLUGIN USERGROUP PERMISSIONS BITFIELDS HERE ###
**************************************************

add above:
**************************************************
// vBug Tracker Permissions
$_BITFIELD['usergroup']['vbugpermissions'] = array(
'canadminbugs' => 1,
'canaddbugs' => 2,
'canviewbugs' => 4
);

**************************************************
save, close and upload includes/init.php
**************************************************

FASherman · #**144** 01-17-2005, 05:04 PM

When is this hack going to support prefixed tables?

ccunnin71 · #**145** 01-18-2005, 04:55 PM

Speaking of prefixed tables! The install hosed up... Yes, I do have the vb3_ prefixed table setup. How do I get around this? Better yet how do I uninstall this now? I see at the end of the 'vbug_install" is an uninstall option. What do I have to do to make this work?

Big bummer! I was really looking forward to using this mod. :tired: Should have spent more time on the older threads on this (of course I am reading them after the fact).

Thanks for any help in this situation.

PixelFx · #**146** 01-18-2005, 06:46 PM

I'm waiting for the pro version

ccunnin71 · #**147** 01-18-2005, 07:35 PM

I 2nd that

. Ok, restored from backup that I made before installing the mod. Yes, I have tripped up before and learned from my mistakes.

Ok Dark Wizard, look forward to your coding efforts.

FASherman · #**148** 01-20-2005, 12:32 AM

Quote:

Originally Posted by FASherman

When is this hack going to support prefixed tables?

I'll answer my own question: NOW.

Instructions to make this hack work with prefixed tables.

1. EDIT THE INSTALL SCRIPT (admincp/vbug_install.php)
--------------------------------------
FIND:

PHP Code:


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

REPLACE WITH

PHP Code:


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

-------------------------------------
FIND:

PHP Code:


			
        $DB_site->query("INSERT INTO datastore VALUES ('vbugs_version', 's:5:"1.0.2"')");

REPLACE WITH:

PHP Code:


			
        $DB_site->query("INSERT INTO ".TABLE_PREFIX."datastore VALUES ('vbugs_version', 's:5:"1.0.2"')");

SAVE INSTALL SCRIPT
================================================== ========

2. EDIT vbugs.php
---------------------------------
FIND:

PHP Code:


			
    SELECT DISTINCT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname, vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname 

    FROM vbugs

    LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)

    LEFT JOIN " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)

    LEFT JOIN " . TABLE_PREFIX . "user ON (vbugs.userid = user.userid)

REPLACE WITH:

PHP Code:


			
    SELECT DISTINCT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname, vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname 

    FROM vbugs

    LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)

    LEFT JOIN " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)

    LEFT JOIN " . TABLE_PREFIX . "user AS user ON (vbugs.userid = user.userid)

----------------------------------
FIND:

PHP Code:


			
    SELECT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname ,vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname

    FROM vbugs

    LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)

    LEFT JOIN " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)

    LEFT JOIN " . TABLE_PREFIX . "user ON (vbugs.userid = user.userid)

REPLACE WITH:

PHP Code:


			
    SELECT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname ,vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname

    FROM vbugs

    LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)

    LEFT JOIN " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)

    LEFT JOIN " . TABLE_PREFIX . "user AS user ON (vbugs.userid = user.userid)

SAVE vbugs.php
================================================== ========

3. Follow the instructions contained in the install.txt file

ccunnin71 · #**149** 01-25-2005, 03:40 PM

FASHerman Thanks! One small note... Your code change nearly did it. It also brought on "Parse error: parse error, unexpected T_STRING ...."

To correct goto top of you vbugs.php and add an additional line...

FIND

Code:

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'vbugs');

Add this right bellow

Code:

define('TABLE_PREFIX', 'vb3_');  //Your table prefix

That corrected things for me.

Dark_Wizard · #**150** 01-25-2005, 04:00 PM

Quote:

Originally Posted by PixelFx

I'm waiting for the pro version

A beta test of this is coming soon...table prefixes done and alot of extra features not found in this version.

PixelFx · #**151** 02-08-2005, 01:13 PM

can;t wait for it

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05302 seconds Memory Usage 2,362KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (8)bbcode_php (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!