User-to-User Log

This hack logs all private messages that are sent and received on your forums, as well as all e-mails sent via the e-mail form. To protect privacy, you can only view the source and destination users and the date/time the message was sent, nothing more. In addition, there are instructions included for editing the registration templates so users are warned when they sign up that they can be somewhat monitored.

Existing PMs can be imported into the log and the log can be flushed from the admin CP or a cron job with a simple DELETE query.

The instructions refer to specific functions only present in 2.3.0 (RC3) and later. Earlier versions will still function with this hack but require some creativity on one of the steps.

[filburt1]

Sorry but you'll have to write it yourself (or have somebody else write it) because not everybody's in the same situation as you.

[lalo landa]

Ready..

https://vborg.vbsupport.ru/showthrea...569#post257569

ThnXs anyway

[Bison]

I Got a little problem with this hack:

Invalid SQL: INSERT INTO usertouserlog (entrytype, fromuserid, touserid, dateline) VALUES ("email", 0, ,
UNIX_TIMESTAMP())
mysql error: You have an error in your SQL syntax near ' UNIX_TIMESTAMP())' at line 1

In the member.php file ... the $touserid isn't returning a value.

[filburt1]

Make sure you're running a late version of vB and at least PHP 4.2.0.

[Bison]

I am ... 2.2.9 and my PHP is 4.3....

[filburt1]

Make sure you followed the instructions again; I don't know what else to tell you, I'm running 2.3.0 on PHP 4.3.0 and it works fine. It could be a hack interacting badly with this one.

[Bison]

No dude ... that line you refferd in your hack code for $vbmail is the problem...

In 2.2.9, the only code that resembles this is:

eval("\$message = \"".gettemplate("email_lostpw",1,0)."\";");
eval("\$subject = \"".gettemplate("emailsubject_lostpw",1,0)."\"; ");

HERE: mail ($user[email],$subject,$message,"From: \"$bbtitle Mailer\" <$webmasteremail>");[/b]

// User to User Log Hack
$DB_site->query("INSERT INTO usertouserlog (entrytype, fromuserid, touserid, dateline) VALUES (\"email\", ". $bbuserinfo['userid'] .", $userid, UNIX_TIMESTAMP())");
// User to User Log Hack (End)

[filburt1]

Well like I said:

03-11-03 at 10:37 PM filburt1 said this in Post #1
The instructions refer to specific functions only present in 2.3.0 (RC3) and later. Earlier versions will still function with this hack but require some creativity on one of the steps.

[Bison]

[Rolodex hurrys to uninstall this hack!]

Will make a "user friendly" one myself...

[Bison]

For users who are still using v2.29, and want to install this hack, I modified a few lines that works for your version of vB.

Changes were made in the member.php, where this line wasn't found in 2.29:

vbmail($destuserinfo['email'], $subject, $sendmessage, $bbuserinfo['email'], '', $bbuserinfo['username']);

Instead of inserting this:

$DB_site->query("INSERT INTO usertouserlog (entrytype, fromuserid, touserid, dateline)
  	VALUES (\"email\", " . $bbuserinfo['userid'] . ", $userid, UNIX_TIMESTAMP())");

Insert this:

$DB_site->query("INSERT INTO usertouserlog (entrytype, fromuserid, touserid, dateline) 
VALUES (\"email\", ". $bbuserinfo['userid'] .", ".$user['userid'].", UNIX_TIMESTAMP())");

After This:

mail ($user[email],$subject,$message,"From: \"$bbtitle Mailer\" <$webmasteremail>");