View Issue Details Jump to Notes ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0002337SMF 2.0public2008-07-26 05:102009-03-12 20:18
PrioritynormalSeverityminorReproducibilityhave not tried
PlatformOSOS Version
Summary0002337: number of open moderation reports
DescriptionIn the Moderation.php file you have this part of the query in ModBlockReportedPosts():

            WHERE ' . ($user_info['mod_cache']['bq'] == '1=1' || $user_info['mod_cache']['bq'] == '0=1' ? $user_info['mod_cache']['bq'] : 'lr.' . $user_info['mod_cache']['bq']) . '
                AND lr.closed = {int:not_closed}
                AND lr.ignore_all = {int:not_ignored}

Yet in the recountOpenReports() function you have:

        WHERE ' . $user_info['mod_cache']['bq'] . '
            AND closed = {int:not_closed}
            AND ignore_all = {int:not_ignored}',

The where part of this query is slightly different from the $user_info part of the query.

I am not sure 100% if this is causing the issue, but here on, I see that in the header it says "There are currently 2 moderator reports open."
Yet when I go to view them, I see 3 of them actually.
The server admin looked at this as well and it said 5 where open for him and it actually showed 6.
Attached Files

- Relationships

-  Notes
Grudge (SMF Friend)
2008-07-26 06:32

That isn't the cause of the bug. Out of interset, if you log out then back in does the number match?
SleePy (Developer)
2008-07-26 14:12
edited on: 2008-07-26 14:13

I tested here at and a login/out did not change it. Granted this maybe an issue with the cache.

It says there is 3 open, when I view it I see 4...

I thought possible ignored boards where taking effect myself, but the query itself I can see both of them using the ignored board in the same maner. Which is why I thought it was the query.

SleePy (Developer)
2009-03-12 20:18

Unable to reproduce.
MantisBT (Modified for SMF Intergration)[^] Copyright © 2000 - 2010 Mantis Group