Reverse post order

[fdhealy4]

I'm sure this has been asked before but I can't make heads or tails searching for an answer.

Is there a way to reverse the order of posts (newest on top) for an entire sub-forum?

Thanks,

Dale

[Lynne]

Maintenance > Execute SQL Query > Posts - Newest First > Continue. That changes it for existing users. For new users change the post over in AdminCP > Settings > Options > Registration Options > Defaults

[fdhealy4]

Hi Lynne,

When I clicked the "Execute SQL Query" button it told me I was "not authorized" - Why would that be, I am the administrator.

Dale

[ozzy47]

You need to add your userid in the includes/config.php file to be able to run queries.

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '1';

[fdhealy4]

Hi again,

I'm new to all this. Where, or how, do I find the "includes/config.php" file? I searched the host cp files with no luck and I don't see anything in the V BB control panel to access files.

Help!!!

Dale

[ozzy47]

includes is the folder to look for, then inside that folder find the file, config.php via your FTP or cpanel

Then edit it, and save it back.

Use a editor like notepad++ (http://notepad-plus-plus.org/download/v6.6.8.html) to edit any files, don't use Notepad or Wordpad.

[fdhealy4]

I don't see a "solved" button but consider this issue closed.

Thanks Everyone

Dale

[ozzy47]

Glad to hear it is all sorted now, thanks for reporting back. :)