vB Warning system

This allows you to warn a user for bad posts. The warning is sent via private message, you can specify who the pm is from so it can be done without them knowing who sent the warning.

When users report a post you get a private message! something vb always lacked.

A user now can choose a reason instead of typing a message. though, they can still type a message if they want.

The moderators of the forum will receive the pm.
follow the instructions, there is a large code edit in report.php

[edbri871]

I've been using this hack, and it works fine now. Removed the email part of the code.

For some reason the popups saying you have a new PM don't come up with reported posts. Anyone know how to fix that?

[coldpride]

Originally Posted by coldpride

I got this error

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT post.postid, post.threadid, post.userid, thread.title AS threadtitle, user.username AS username
FROM vb3_post
LEFT JOIN thread ON (thread.threadid=post.threadid)
LEFT JOIN user ON (user.userid=post.userid)
WHERE post.postid = '3588'

mysql error: Table 'anicomm_forums.thread' doesn't exist

mysql error number: 1146


someone please help

anyone would like to help me out? when I click the warn button it displays that message.

[Marco van Herwaarden]

In your warnuser.php, find:

PHP Code:

$getinfo = $DB_site->query_first("
SELECT post.postid, post.threadid, post.userid, thread.title AS threadtitle, user.username AS username 
FROM " . TABLE_PREFIX . "post 
   LEFT JOIN thread ON (thread.threadid=post.threadid)
   LEFT JOIN user ON (user.userid=post.userid) 
   WHERE post.postid = '" . $postid . "'
   "); 


and replace with:

PHP Code:

$getinfo = $DB_site->query_first("
SELECT post.postid, post.threadid, post.userid, thread.title AS threadtitle, user.username AS username 
FROM " . TABLE_PREFIX . "post 
   LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid=post.threadid)
   LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid=post.userid) 
   WHERE post.postid = '" . $postid . "'
   "); 


[JsnakeJ]

Will this work on 3.0.7?