[Aylwin]

How to check incoming posts for valid forum users

I use this mod as a mailing list gateway. Many of the people on our mailing lists are also forum members. So I thought it would be good to check for valid forum users. No guarantees whatsoever but if anyone's interested, here's how I did it.

In gateway.php, look for:

				//Separate name and email address
				$from_name = from_name($message['from']);
				$from_email = from_email($message['from']);

Below, add:

				//Check if the sender is a user
				$userinfo = $db->query_first("SELECT userid,username FROM " . TABLE_PREFIX . "user WHERE email = '" . $from_email . "'");
				if ($userinfo['userid']) { $userid = $userinfo['userid']; } else { $userid = 0; }
				if ($userinfo['username']) { $from_name = $userinfo['username']; }

Look for both instances of:

					$postid = insert_post($threadid, $forumid, $foruminfo, $subject, $from_name, $from_email, $date, $parentid);

Replace both with:

					$postid = insert_post($threadid, $forumid, $foruminfo, $subject, $from_name, $userid, $from_email, $date, $parentid);

In functions_nntp.php, look for:

function insert_post($threadid, $forumid, $foruminfo, $subject, $from_name, $from_email, $date, $parentid = 0)

Replace with:

function insert_post($threadid, $forumid, $foruminfo, $subject, $from_name, $userid, $from_email, $date, $parentid = 0)

Look for:

		'" . stripslashes($from_name) . "', 0, '" . $date . "',

Replace with:

		'" . stripslashes($from_name) . "', " . $userid . ", '" . $date . "',