[Nirjonadda]

My Reports Link error and report.php (Full Form)
Database error in vBulletin 4.1.10:

Invalid SQL:
SELECT report.*, rextra.dateline, rextra.reason, thread.title as posttitle FROM vbvfc_ars_report as report
LEFT JOIN vbpost ON post.postid = report.contentid
LEFT JOIN vbthread ON thread.threadid = post.threadid
LEFT JOIN vbvfc_ars_report_extra as rextra ON (rextra.reportid = report.reportid)
where report.type = 'post' AND rextra.ruserid = 1 order by rextra.dateline desc LIMIT 0, 25;

MySQL Error : Unknown column 'thread.title' in 'field list'
Error Number : 1054

[Badshah93]

Originally Posted by Nirjonadda

My Reports Link error and report.php (Full Form)
Database error in vBulletin 4.1.10:

Invalid SQL:
SELECT report.*, rextra.dateline, rextra.reason, thread.title as posttitle FROM vbvfc_ars_report as report
LEFT JOIN vbpost ON post.postid = report.contentid
LEFT JOIN vbthread ON thread.threadid = post.threadid
LEFT JOIN vbvfc_ars_report_extra as rextra ON (rextra.reportid = report.reportid)
where report.type = 'post' AND rextra.ruserid = 1 order by rextra.dateline desc LIMIT 0, 25;

MySQL Error : Unknown column 'thread.title' in 'field list'
Error Number : 1054

Fixed.. download zip from first post or xml file from this post.

[Nirjonadda]

Yes it now work but have a option for My Reports Link on/off from navbar?

[Badshah93]

Originally Posted by Nirjonadda

Yes it now work but have a option for My Reports Link on/off from navbar?

i developed this mod in vb 4.2 and in that version admin can control position of "my reports" nav link through navigation manager.
if you want to turn off my reports link

open plugin manager and disabled this plugin

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[Deathjam]

i don't seem to be getting notifications of new reports

[Badshah93]

Originally Posted by Deathjam

i don't seem to be getting notifications of new reports

Admins and Super Mod's will not get notification if report email notification is set to Moderators / None

Settings -> User Infractions & Post Reporting Options

[rafiul]

Ajax Report Popup to report post from showthread. is not working in vb 4.2. When i click its send me to send page. How to fix this? I want the small pop up box to be appeared.

Thanks for nice mod.

[Badshah93]

Originally Posted by rafiul

Ajax Report Popup to report post from showthread. is not working in vb 4.2. When i click its send me to send page. How to fix this? I want the small pop up box to be appeared.

Thanks for nice mod.

can u see popup box when you click report button and test the mod in default skin.

[tareqbd]

Is there any chance to have options like, the posters get a notification on report. When a post is reported, the poster or thread creator will get a notification.

[Badshah93]

Originally Posted by tareqbd

Is there any chance to have options like, the posters get a notification on report. When a post is reported, the poster or thread creator will get a notification.

i don't see any point of having that option
Reason:

Suppose i am a member of your forum and advertising some sites in my signature which is not allowed and someone reports that. If i get the notification that someone has reported about my signature, then i will immediately change it and save myself from receiving infraction. Then after few days i will again start advertising, so no point of having that option.

[RobbieZ]

Nice!

Would you consider an optional positionable button?

Ive always thought the new warning symbol isnt that notice-able after vb3, maybe postbit at the bottom somewhere!

[[email protected]]

Tested and works on 4.2. Very good job
Guess this mod will be my next candidate for a German translation



EDIT:

I'd like to suggest to add the option "Warn User" to the "Useful Links" in ACP/MCP

EDIT 2:

I'd like to make another suggestion. At the moment in ACP/MCP in the category "Reason Given" there is no visible separation between the custom reasons and the additional comments by the reporter. Maybe you can improve this to make it more apparent.

[Hornstar]

If someone reports a post in section B will all mods see the notification of the report, or only mods in Section B see the notification? (Hoping the second)

[trackpads]

Awesome idea adn thanks.

I am having a style issue, something I have screwed up I am sure. But can you tell me what might be wrong? When I click the report icon the box is a small 2 pixel high box.

Thanks again,

-Jason