[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]

OK now I see why I didnt get a reply - dang I must have read this entire thread five times and missed what I wanted staring me in the face on the first page

oops

Hello Ed,

I have been getting the error below for quite some time. Any ideas?

Database error in vBulletin: Invalid SQL: SELECT msgid,toid,fromid,title,UNIX_TIMESTAMP(datetime) AS datetime,iconid,text,signature FROM privatercvd WHERE msgid=34768/ AND toid=6679
mysql error: You have an error in your SQL syntax near 'AND toid=6679' at line 1
mysql error number: 1064
Date: Monday 13th of November 2000 08:33:21 PM
Script: /private.php?action=show&msgid=34768/
Referer:

Open private.php. Around line

if ($table=="privatercvd") {

and look for

$message = $DB_site->query_first("SELECT msgid,toid,fromid,title,UNIX_TIMESTAMP(datetime) AS datetime,iconid,text,signature FROM $table WHERE msgid=$msgid AND toid=$userid");

Remove / if you have there something like msgid=$msgid/

Hope this helps.

uhh, no
Someone is coming in via this URL:
.../private.php?action=show&msgid=34768/
The trailing slash is what's killing it. Check your templates to see if you added a slash by accident.

Feeeeeling so dump now... <ahem>...

Hello,

I checked the templates. It does not contain any ' / '

Here is template pmsentmsg

Hello,

You have received a private message at $bbtitle, from $name.
You may view it by going here: $bburl/private.php?action=show&msgid=$theid

Thanks,
$bbtitle Post Manager

I also checked Pef's but the code does not show any ' / '

	if ($table=="privatercvd") {
		$message = $DB_site->query_first("SELECT msgid,toid,fromid,title,UNIX_TIMESTAMP(datetime) AS datetime,iconid,text,signature FROM $table WHERE msgid=$msgid AND toid=$userid");
		if ($getnextnewest=$DB_site->query_first("SELECT msgid FROM privatercvd WHERE msgid>$msgid AND toid=$userid ORDER BY msgid LIMIT 1")) {
  			$nextnewestthreadid=$getnextnewest[msgid];
			eval("\$nextnewest = \"".gettemplate("pm_nextnewest")."\";");
		}

		if ($getnextoldest=$DB_site->query_first("SELECT msgid FROM privatercvd WHERE msgid<$msgid AND toid=$userid ORDER BY msgid DESC LIMIT 1")) {
  			$nextoldestthreadid=$getnextoldest[msgid];
  			eval("\$nextoldest = \"".gettemplate("pm_nextoldest")."\";");
		}
	} else {
		$message = $DB_site->query_first("SELECT msgid,toid,fromid,title,UNIX_TIMESTAMP(datetime) AS datetime,iconid,text,signature FROM $table WHERE msgid=$msgid AND fromid=$userid");
		if ($getnextnewest=$DB_site->query_first("SELECT msgid FROM privatesent WHERE msgid>$msgid AND fromid=$userid ORDER BY msgid LIMIT 1")) {
  			$nextnewestthreadid=$getnextnewest[msgid];
			eval("\$nextnewest = \"".gettemplate("pm_nextnewest")."\";");
		}

		if ($getnextoldest=$DB_site->query_first("SELECT msgid FROM privatesent WHERE msgid<$msgid AND fromid=$userid ORDER BY msgid DESC LIMIT 1")) {
  			$nextoldestthreadid=$getnextoldest[msgid];
  			eval("\$nextoldest = \"".gettemplate("pm_nextoldest")."\";");
		}
	}

Any ideas?

Well, some random user is coming in through that link - I don't know why.

You can fix that by change the query PeF mentioned to look like this
WHERE field='value'

Note the apostrophes.

Ed,
I finally got my permissions straightened out and added the pm hack. This is such a wonderful add on! I just wanted to thank you so much for all of the hard work that went into this- it's fantastic!
TigerLily

When I send a message the other person only receives the topic and no text. What is going on here?

I can't figure out what to replace because it is the newer version of vB and its using templates!