[magnus]

v1.1 -> v1.2 UPGRADE INSTRUCTIONS

1. Download quoteit1.2.zip from the first post and uncompress it.

2. Upload quotes.php to your forum ROOT directory, overwriting the existing one.

3. Upload quoteadmin.php to your ADMINCP directory.

4. Run the following SQL queries:
[SQL]
INSERT INTO `setting` (`varname` , `grouptitle` , `value` , `defaultvalue` , `optioncode` , `displayorder` , `advanced` , `volatile` ) VALUES ( 'moderatequotes', 'forumhome', '0', '0', 'yesno', '6', '0', '1');
[/SQL]
[SQL]
INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'setting_moderatequotes_title', 'Disable Quote Moderation?', '5000');
[/SQL]
[SQL]
INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'setting_moderatequotes_desc', 'Selecting "No" will require all quotes to be approved before being displayed.', '5000' );
[/SQL]
[SQL]
INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'quote_x_has_been_approved', 'Quote ({1}) has been approved.', '9000' );
[/SQL]
[SQL]
INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'quote_x_has_been_deleted', 'Quote ({1}) has been deleted.', '9000' );
[/SQL]
[SQL]
INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'moderate_quotes', 'Moderate Quotes', '9' );
[/SQL]
[SQL]
INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'no_quotes_awaiting_moderation', 'No Quotes awaiting moderation', '2' );
[/SQL]

5. Make the following FILE edits:

5a. In INDEX.PHP:

Find:

PHP Code:

    $result_quote = $DB_site->query("
        SELECT * FROM quotes ORDER BY rand() LIMIT 1
    "); 


REPLACE with:

PHP Code:

    $result_quote = $DB_site->query("
        SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1
    "); 


5b. In ADMINCP/INDEX.PHP:

Find:

PHP Code:

        construct_nav_group($vbphrase['moderation'], '<hr />', "$df"); 


Add ABOVE:

PHP Code:

        construct_nav_option($vbphrase['moderate_quotes'], "quoteadmin.php?do=moderate"); 


Done !!

You will now have a new option under the "Moderation" category in the AdminCP, titled "Moderate Quotes". Quote moderating can be toggled via vBulletin Options -> Forums Home Page Options -> Disable Quote Moderation?