[Olate]

I have now installed this hack onto 2 forums sucessfully. However, there are a couple of issues you should be aware of:

1. If you have specified a table prefix in includes/config.php of your vB installation, this hack will not install correctly because the table prefixes are not used when creating the tables in the installer. Even if you manage to get it to install, it won't work correctly because the table prefixes are not in every SQL query. But if you are not using table prefixes, you will be fine. This hack will install without any problems through the HTL.
2. I have tried several times to get the manual installation to work. But when it comes to importing the settings, I can't get them to import correctly. The safest way is to use the HTL to install it. If anyone has used the manual installation sucessfully, I'd like to know how they imported the settings from the XML file.

A useful feature I needed was e-mail notification upon the addition of a new bug and a bug not. So I have added this. It is a very simple addition which I intend to improve later this evening (along with some other stuff). It uses a hard coded e-mail address to send the messages to and from. If you wish to add this to your copy, then do the following:

1. Open bugs.php. Locate (around line 463)

PHP Code:

        // Redirect to the bug
        $url = "bugs.php?$session[sessionurl]do=showdetails&id=$bug[id]";
        eval(print_standard_redirect('redirect_postthanks'));
    } else {
        eval(print_standard_error('bugnote_text_missing'));    // i think this is causing an error
    }
} 


Before, add:

PHP Code:

        $message = "A new note has been added to bug ID# " . $bug[id] . ":\n\n" . $text ."\n\nYou can view this bug at http://www.yourdomain.com/directory/bugs.php?do=showdetails&id=".$bug[id];
        
        // E-Mail
        mail('to@email.com', '[Tracker] New Note', $message,
         "From: [email]from@email.com[/email]\r\n" .
         "Reply-To: [email]replyto@email.com[/email]\r\n" .
         "X-Mailer: PHP/" . phpversion()); 


This will send out a simple message when a new bug is added to include the name, description and URL.

2. Open bugs.php. Locate (around line 428)

PHP Code:

        $url = "bugs.php?$session[sessionurl]&do=showdetails&id=$id";
        eval(print_standard_redirect('redirect_postthanks'));    
    } else {    
        $bugpreview = construct_errors($errors);
        $_REQUEST['do'] = "add";    // go back to the "Submit" bug report screen
    }
} 


Before, add:

PHP Code:

        $bug_result = $DB_site->query('SELECT id, name, description FROM ' . TABLE_PREFIX . 'bugs WHERE (id = ' . $id . ')');
        $bug = $DB_site->fetch_array($bug_result);
        
        $message = "A new bug (ID# " . $id . ") has been submitted: \n\nName: " . $bug['name'] . "\nDescription: " . $bug['description'] . "\n\nYou can view this bug at http://www.yourdomain.com/directory/bugs.php?do=showdetails&id=" . $id;
        
        // E-Mail
        mail('to@email.com', '[Tracker] New Entry', $message,
         "From: [email]from@email.com[/email]\r\n" .
         "Reply-To: [email]replyto@email.com[/email]\r\n" .
         "X-Mailer: PHP/" . phpversion()); 


This will send an e-mail when a new note is added to a bug along with the note itself and a link to the bug.

Finally, for those of you who a) use table prefixes and/or b) don't want to add the mail hacks above themselves, I've attached the bugs.php and admincp/bugsadmin.php files with both those changes/fixes in. Just overwrite your copies.

I will not support these changes officially, although I may help out if I get time in this thread. If you want me to help with the installation or bug fixes, I'll happily do this as commercial paid work if you want to PM me.