[RELEASE] Private Messaging (PM) Hack, v 1.2.0

It's HEREEEEE!

version 1.2.0, with so much increase functionality, including:
* Checkbox deletion/moving
* Lightbulb/last message by on index.php
* Icon for "Send Private Message" in posts
* Multiple folders for organization of PMs
* Designation of replied to messages
* Message quotas (untested, but should work fine)
* Sends email when message box is full
* Message forwarding
* Previous/Next PM when viewing
* Direct link to last message from index.php
* Receive email when PMed
* Usergroup function to turn off PMs
* Individual ability to turn off PMs
* index.php code bugfixed
* VERY simple PM stats (/private.php?action=checkstats)
* Banned IP checking
* and more...

Stats I posted elsewhere too:
* 35+ templates
* 4 new profile fields
* 3 new tables
* 1 new field to usergroup table

I was able to set up a stock 1.1.3b3 test board and the hack installed successfully. Upgrading shouldn't be a problem either, except for the template changes. I HIGHLY suggest you overwrite the templates in upgrade-template.txt and re-edit from there.

All other instructions should be located in the .zip.

<download removed -- see http://www.vbulletin.com/forum/showt...?threadid=4405 >

[Edited by Ed Sullivan on 01-02-2001 at 07:13 PM]

I am having the same problem

In the USer Profile:
Receive Email On PM ON/OFF

this didn't Work! I can check On or Off, when I go back to the Profile it's still off!
also the same with the recieve PM it will not turn on stays in the off postiion

bump

Works fine for me, and to my knowledge, it works fine for others. Me2Be had that problem, but she just reinstalled and it was fixed, IIRC.

can someone confirm for me that the signatures work in the PM hack, they dont seem to show up for me when i check the tick box. issit just me

ok...well looks like i solved the bug myself.
the signature function was not correctly specified in "private.php"

so to help anyone else who comes across this problem...
heres how i fixed it, find:

    if ($message[showsignature]==1 and $allowsignatures==1) {
      $signature= "\n__________________\n$userinfo[signature]";
    } else {
      $signature="";
    }

and change it to look like:

    if ($message[signature]==1 and $allowsignatures==1) {
      $signature= "\n__________________\n$userinfo[signature]";
    } else {
      $signature="";
    }

for those of you who cant see the difference the change is in changing "showsignature" to "signature"

this fixed the bug for me because the old code was instructed to query the "showsignature" field in the messages table, however this field does not exist, it is in fact called "signature"

this became apparent to me when i analysed the database directly and also because the database query did not include showsignature but instead signature which was wrong.

i hope this helps and sorry if i confused anyone. btw thanks for a fantastic hack ed...umm i mean mike

Well I finally upgraded and the users who post above about the "Can send pms" always defaulting to NO even though they set it to yes are correct. That is how mine is behaving. I am about to investigate the problem and fix it - I will post when I am done. It is saying NO but I can clearly see that the field in the database is set to "1" so it must be reading the setting incorrectly.

Also a note, if you upgrade you need to remove the <a href=etc etc link to private.php that you put in the postbit template from the first version and replace it with $pmlink. The notes don't seem to mention this.

[Edited by rangersfan on 08-29-2000 at 05:17 PM]

Ok the problem is this is in the instructions:

Find:
~~~~~~~
$DB_site->query("INSERT INTO user (userid,username,password,email,parentemail,coppauser,homepage,icq,aim,yahoo,biography,signature,adminemail,showemail,invisible,usertitle,joindate,canpost,cookieuser,daysprune,lastvisit,lastactivity,usergroupid,timezoneoffset,emailnotification) VALUES (NULL,'".addslashes($username)."','".addslashes($password)."','".addslashes($email)."','".addslashes($parentemail)."',$coppauser,'".addslashes($homepage)."','".addslashes($icq)."','".addslashes($aim)."','".addslashes($yahoo)."','".addslashes($biography)."','".addslashes($signature)."',$adminemail,$showemail,$invisible,'".addslashes($usertitle)."',".time().",1,$cookieuser,$prunedays,".time().",".time().",$newusergroupid,$timezoneoffset,$emailnotification)");
~~~~~~~

Replace with:
~~~~~~~
  //PM Hack
  //Original: $DB_site->query("INSERT INTO user (userid,username,password,email,parentemail,coppauser,homepage,icq,aim,yahoo,biography,signature,adminemail,showemail,invisible,usertitle,joindate,canpost,cookieuser,daysprune,lastvisit,lastactivity,usergroupid,timezoneoffset,emailnotification) VALUES (NULL,'".addslashes($username)."','".addslashes($password)."','".addslashes($email)."','".addslashes($parentemail)."',$coppauser,'".addslashes($homepage)."','".addslashes($icq)."','".addslashes($aim)."','".addslashes($yahoo)."','".addslashes($biography)."','".addslashes($signature)."',$adminemail,$showemail,$invisible,'".addslashes($usertitle)."',".time().",1,$cookieuser,$prunedays,".time().",".time().",$newusergroupid,$timezoneoffset,$emailnotification)");
  //New:
  $DB_site->query("INSERT INTO user (userid,username,password,email,parentemail,coppauser,homepage,icq,aim,yahoo,biography,signature,adminemail,showemail,invisible,usertitle,joindate,canpost,cookieuser,daysprune,lastvisit,lastactivity,usergroupid,timezoneoffset,emailnotification,receivepm,emailonpm) VALUES (NULL,'".addslashes($username)."','".addslashes($password)."','".addslashes($email)."','".addslashes($parentemail)."',$coppauser,'".addslashes($homepage)."','".addslashes($icq)."','".addslashes($aim)."','".addslashes($yahoo)."','".addslashes($biography)."','".addslashes($signature)."',$adminemail,$showemail,$invisible,'".addslashes($usertitle)."',".time().",1,$cookieuser,$prunedays,".time().",".time().",$newusergroupid,$timezoneoffset,$emailnotification,$receivepm,$emailonpm)");
  //END PM Hack
~~~~~~~

The thing is you will find that line (or lines that look damn near the same) in two places. One in the edit profile section and one in the coppa form section. You need to make sure to change the one in the "Edit Profile" section, it is also the first occurence of the line.

About the "Replied to" graphics

If I reply to a message, I am still getting the same plain old folders, not the replied to folders. Does this work for anyone else, besides Ed and Me2Be, before I investigate the code?

Well, it's not working for me anymore I don't think at least. Have to go verify.

They USED to... when I implemented them, so I'm going to have to make sure I didn't break them when I added other stuff (they were one of the first features I added)

Ok, simple fix. It just wasn't validating to true - I missed an <input>

But that's the alternate fix - this one's easier. Open up private.php and find:

	if ($reply=="true") {
		$DB_site->query("UPDATE privatercvd SET repliedto=1 WHERE msgid=$replyto");
	}

Replace with:

	if ($replyto) {
		$DB_site->query("UPDATE privatercvd SET repliedto=1 WHERE msgid=$replyto");
	}