[The Realist]

Thanks for the below all done but when I remove the test applications it gives me a DB error:

Database error in vBulletin 3.0.6:

Invalid SQL:
DELETE *
FROM maf_application
WHERE userid = 1

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 '*
FROM maf_application
WHERE userid = 1' at line 1

mysql error number: 1064

Date: Friday 04th of March 2005 09:20:59 AM
Script: http://www.xxxxxxxx.com/forums/admincp/maf_delapp.php
Referer: http://www.xxxxxxxx.com/forums/admincp/maf_delapp.php

Originally Posted by sabret00the

ok these are the file edits you need to make

in admincp/index.php find

PHP Code:

    $printhr = false;
    if (can_administer('canadminstyles'))
    {
        $printhr = true;
        construct_nav_option($vbphrase['style_manager'], 'template.php?do=modify', '<br />'); 


and add above that

PHP Code:

    // +++ MAF 
    construct_nav_option("Automated Thread Settings", 'options.php?dogroup=maf', '<br />');
    construct_nav_option("Rate Applications", '../' . $modcpdir . 'maf_rateapp.php?do=list', '<br />');
    construct_nav_option("Delete Applications", 'maf_delapp.php?do=del', '<br />');
    construct_nav_group("Moderator Applicants", '<hr />');
    // --- MAF 


now in the modcp/index.php find

PHP Code:

    // *************************************************
    if (can_moderate(0, 'canannounce'))
    {
        construct_nav_option($vbphrase['add_new_announcement'], 'announcement.php?do=add\'); 


and add above that

PHP Code:

    // +++ MAF 
    construct_nav_option("Rate Applications", '../' . $modcpdir . '/maf_rateapp.php?do=list', '<br />');
    construct_nav_group("Moderator Applicants", '<hr />');
    // --- MAF 


that's it