User-to-User Log

[filburt1]

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]

Screenshot:

[Xyphen]

Nice piece of work filburt, I'll use it..

[filburt1]

50--no 20--no 10% of the credit goes to Xenon for the query help ;)

[TheComputerGuy]

will install later

[joeboo]

Good work filburt. I may install this :)

[Boofo]

Here's the line to look for in the member.php for 2.2.9

mail($destuserinfo[email],$subject,$sendmessage,"From: \"$bbuserinfo[username]\" <$bbuserinfo[email]>");

[matthepepe]

works like a charm.

[assassingod]

A hack by filburt?! Somethings wrong:p

Great hack! I know i'll be using this:)

[Xenon]

hehe, filburt was assimilated ;)

[Dan]

I'll install this after school, may prove useful....

/me clicks installl

[Dean C]

Have you converted to a hacker now :o?!

- miSt

[filburt1]

I just had the idea :p

[gameplanetz]

very nice
i`m gonna install this,Filbie :D :D

edit: have already installed this,and works like a charm.thanks alot,Filbie :D :D :D

[afterlab]

Hmm.. I like the idea behind this. I'll work on installing this later this week. Thanks for the release! :D

[lalo landa]

cool.. thanXS!

can you add the option to see the pms in this hack?

[filburt1]

No, because that violates privacy.`

[Steve123]

5. Find in private.php

$DB_site->query("INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title

There is 3-4 Lines that start with this.. What one is it?

/Steve

[Steve123]

Another Error..

when i click on next 50...

It just adds one to the bottom... it dosent display the next 50.. just the next 1...

[lalo landa]

03-19-03 at 12:48 PM filburt1 said this in Post #17 (https://vborg.vbsupport.ru/showthread.php?postid=369165#post369165)
No, because that violates privacy.`


I have another privacy statments and.. allready exist one hack to do that... but i need the integration with this...

[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/showthread.php?postid=257569#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 (https://vborg.vbsupport.ru/showthread.php?postid=364526#post364526)
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>");

[Oblivion Knight]

Working like a dream on 2.3.0 RC3. :)
Very effective against the fight of "PM abuse", now when the accused claim that they never sent a PM to the victim, it can be checked..

Not that I've had this problem as of yet but.. *shrugs*

Thankyou filburt :)
* Oblivion Knight clicks install.

[SpeedStreet]

The PM side of this thing is working perfect. However, for some reason, when someone uses the vbmail system, it does not propgate the database with any information.

I now have a perfect list of PM activity, but I absolutely need the Email abuse list....can anyone tell me what is wrong?

[-Sidekick-]

03-21-03 at 04:05 AM Steve123 said this in Post #18 (https://vborg.vbsupport.ru/showthread.php?postid=370457#post370457)
5. Find in private.php

$DB_site->query("INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title

There is 3-4 Lines that start with this.. What one is it?

/Steve

[Erwin]

Great idea. :)

[Bison]

I recently upgraded to 2.30 and now the vbmail part works. But the board email system sends out a email notification but the "From:" column is blank.

Does anyone know how to get this to fill in properly?

[Oblivion Knight]

03-21-03 at 10:05 AM Steve123 said this in Post #18 (https://vborg.vbsupport.ru/showthread.php?postid=370457#post370457)
5. Find in private.php

$DB_site->query("INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title

There is 3-4 Lines that start with this.. What one is it?

/Steve I inserted it under the first instance of that line, and all seems to be running well.. :smoke: