Add-On Releases - vBug Tracker Lite

I'm back again and with an updated version of vBug Tracker. This add-on if you are not familiar with it is a mimic of the one used back a while ago on vbulletin.com. This is currently in beta just to make sure I caught all the bugs.

There is no upgrade yet from version 3.7 but I am working on it.

There will be a Pro version coming soon but will not be posted here and will contain many features and enhancements.

Support is only provided to those who click install! Finally, if you really like this addon please nominate this for MOTM.

Thanks and enjoy!

I have removed this from the Beta stage and consider this stable.

4.0.1 Release:

• * Fixed a query problem with table prefixes.
  * Fixed/Added phrase issues.
  * Fixed group by issue.
  * Added permissions to the navtab so that users who cannot view bugs won't see the tab.

To upgrade all you need to do is "Import Product" and select "Allow Overwrite" then upload all the files overwriting the older ones.

[Dark_Wizard]

Originally Posted by Spikeman

Yep thats done

Something is strange for sure as the table prefix doesn't work for you on that specific table. Can you provide me phpMyAdmin access? PM me if you will...

Thx,
Bob

[Dark_Wizard]

Spikeman,

Check your PM's...

Bob

[Spikeman]

Originally Posted by Dark_Wizard

Spikeman,

Check your PM's...

Bob

Yep done it, Well the Dark Wizard did weave his magic and all is now working perfect, this is a critical mod for my site and as a result of the support Bob has just given me and this mod I shall without a doubt be going for the Pro version.. Thanks Bob

5*
Installed

[Spikeman]

Can I request that the Bug Tracker nav tab be viewable by usergroup? Right now I have setup permissions for only one usergroup to have access to the Bug Tracker however all users can se the tab in the navbar, I just want to declutter the navbar and stop users getting the message - You do not have permission to access this area.

thanks in advance.

[Dark_Wizard]

Originally Posted by Spikeman

Can I request that the Bug Tracker nav tab be viewable by usergroup? Right now I have setup permissions for only one usergroup to have access to the Bug Tracker however all users can se the tab in the navbar, I just want to declutter the navbar and stop users getting the message - You do not have permission to access this area.

thanks in advance.

No problem. You need to go into "Plugin Manager" and edit the "vBug Tracker Nav Tab" and replace the code with this:

PHP Code:

if ($vbulletin->userinfo['permissions']['vbugpermissions'] & $vbulletin->bf_ugp['vbugpermissions']['canviewbugs'])
{
    $tabselected = '';
    $tablinks = '';

    if (THIS_SCRIPT == 'vbugs')
    {
        $vbulletin->options['selectednavtab']='vBug';
        $tabselected = ' class="selected"';
        $tablinks = '                <ul class="floatcontainer">
                            <li><a href="vbugs.php?do=new">Submit Bug</a></li>
                            <li><a href="vbugs.php">View Bugs</a></li>
                    </ul> ';
    }

    $template_hook['navtab_end'] .= '<li'.$tabselected.'><a class="navtab" href="vbugs.php">vBug Tracker</a>'.$tablinks.'</li>';
} 


Bob

[Spikeman]

Thanks for the quick response, works great, thanks Bob

[Dark_Wizard]

Originally Posted by Spikeman

Thanks for the quick response, works great, thanks Bob

Your welcome. There is an update coming soon as I did find a few minor bugs i.e. missing phrases...and also the code above isn't phrased either.

Bob

[Cadellin]

It's great to see you've done a vB 4 version Dark Wizard - I was a great fan of your previous releases. I look forward to installing it later today.

We use bug tracking a lot so a well supported premium mod would be something we might be interested in provided it wasn't excessively expensive and it had free patches/updates

[Dark_Wizard]

Originally Posted by Cadellin

It's great to see you've done a vB 4 version Dark Wizard - I was a great fan of your previous releases. I look forward to installing it later today.

We use bug tracking a lot so a well supported premium mod would be something we might be interested in provided it wasn't excessively expensive and it had free patches/updates

It won't be expensive and never has been plus updates have been free as well.

[balu84]

When you call up the page in the forum, I have the following errors:
Datenbankfehler in vBulletin 4.0.1:

Invalid SQL:

SELECT count(*) AS status, vbug.*
FROM vbug AS vbug
WHERE vbug_statusid = 1;

MySQL-Fehler : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Fehler-Nr. : 1140
Fehler-Zeit : Tuesday, 16.02.2010 @ 16:36:45
Datum : Tuesday, 16.02.2010 @ 16:36:46
Skript : http://************/web/vbugs.php
Referrer : http://***********/web/forum.php
IP-Adresse : *******
Benutzername : ****
Klassenname : vB_Database
MySQL-Version : 5.0.51a-24+lenny2+spu1


edit:
i took in $statuscount = $db->query_first("
SELECT count(*) AS status, vbug.*
FROM " . TABLE_PREFIX . "vbug AS vbug
WHERE vbug_statusid = $key
$perms GROUP BY lastedit
");



after this it works without errors
but i dont know if it is correct this way