[mtha]

Originally Posted by Kentaurus

What can I say? I am really sorry. I was hoping there was a cache for moderator permissions... there is not. 12293 queries is not acceptable. In my defense 12293 queries in only 3.6 seconds? Those must be light-speed queries.

Please use the modified version in this post (reupload it in your includes/ directory), I wrote a custom fetch_permissions and it uses A LOT less queries. Please let me know if it helped, I know it will.

I feel much better now: Page generated in 1.09987 seconds with 11 queries

However, the sorting by lastvisit still doesnt work very well:

here's the order I get with modmanagement.php?sortby=lastvisit

22-10-2004 03:34 PM
22-10-2004 01:26 PM
22-10-2004 03:51 PM

...
22-10-2004 02:34 AM
21-10-2004 10:52 PM
22-10-2004 03:46 AM
22-10-2004 12:11 PM
21-10-2004 09:45 PM
....

Only the admin can see it. Other people get a nopermission screen.

If you want to allow some other group to access the code too, you can just modify the condition in modmanagement.php, right?
says

PHP Code:

// only administrators can see this page
if (($bbuserinfo['usergroupid'] != 6) AND ($bbuserinfo['usergroupid'] != 5))
{
    print_no_permission();
}