[RELEASE] Private Messaging Hack (v0.9) !!!!!!!

Woo-freaking-hoo!

Here it is, the vB PM hack! NEWLY CHANGED TO VERSION 1.2.0 - please reference this thread now: http://www.vbulletin.com/forum/showt...?threadid=1772

It can be downloaded from here: http://www.enter.net/~rmsullivan/pmhack1.2.zip . The instructions are included within that.

Demo at: http://www.magic-singles.com/cpa/forums/ . If you MUST register to test it, ok, I guess. I'll be adding screenshots so you know what it's like soon.

Now UPDATED to version 0.9.15 !!!! Several bug fixes, additional support for linking to posts and nicer delete methods (thanks bira!)

Please note that the UBB import script has NOT been done yet - sorry. Soon though.

Enjoy! Post and questions/comments/bug reports here!

[Edited by Ed Sullivan on 07-16-2000 at 11:31 PM]

Thanks everyone!! This is a great hack and it was great to see such creative minds at work!!

RE: The Date Problem

Quite a simple fix actually, in private.php, find: (line 146)

$userinfo=$DB_site->query_first("SELECT userid,email,username,usertitle,signature,showemail,homepage,icq,aim,yahoo,UNIX_TIMESTAMP(joindate) AS  joindate,posts FROM user WHERE userid=$userid2");

Replace with:

$userinfo=$DB_site->query_first("SELECT userid,email,username,usertitle,signature,showemail,homepage,icq,aim,yahoo,joindate,posts FROM user WHERE userid=$userid2");

Can anyone else tell me if I'm the only person still running v1.1.1? Because if I am, there's no use in me adding a "version" switch...

RE: Profile Problem

Another REALLY simple fix, in private.php, (line 143) Find:

$userid2=$fromid;

Under it, add (for simplicity's sake):

$userid=$fromid;

Ok, another release - most (if not all) of the fixes included in v0.9.3 have been posted here, either by me or someone else.

However, there are a few things I want to address.

1. The index.php code has changed significantly:

  //PM HACK
  if ($bbusername) {
  	$username = $bbusername;
  	$pmcounta = $DB_site->query_first("SELECT COUNT(msgid) AS msgid FROM privatercvd WHERE toid=$bbuserid");
  	$pmcount = $pmcounta[msgid];
  	$newpmcounta = $DB_site->query_first("SELECT COUNT(msgid) AS msgid FROM privatercvd WHERE toid=$bbuserid AND UNIX_TIMESTAMP(datetime)>$bblastvisit");
  	$newpmcount = $newpmcounta[msgid];
	if ($newpmcount == 0) { 
		$lightbulb = 'images/off.gif';
	} else { 
		$lightbulb = 'images/on.gif'; 
	}
	$lastsent = $DB_site->query_first("SELECT fromid,UNIX_TIMESTAMP(datetime) AS datetime FROM privatercvd WHERE toid=$bbuserid ORDER BY msgid DESC");
	if ($lastsent) {
		$lastid = trim($lastsent[fromid]);
		$lastdate=date($dateformat,$lastsent[datetime]+(($timeoffset+$bbtimezoneoffset)*3600));
		$lasttime=date($timeformat,$lastsent[datetime]+(($timeoffset+$bbtimezoneoffset)*3600));
		$lastsentuser = $DB_site->query_first("SELECT username FROM user WHERE userid=$lastid");
		$lastuser = htmlspecialchars($lastsentuser[username]);
	}
  	eval("\$pminfo .= \"".gettemplate("pmloggedin")."\";");
  } else {
  	eval("\$pminfo .= \"".gettemplate("pmloggedout")."\";");
  }
  //END PM HACK

2. pmloggedin changed pretty significantly too:

<TR bgcolor="{categorybackcolor}" id=cat><TD colspan=6>
<font color="{categoryfontcolor}" size=2><B>Private Messaging:</B></font></td>
</tr>

<tr bgcolor="{firstaltcolor}">
<td><img src="$lightbulb"></td>
<td colspan=5>
<smallfont><a href="private.php">Read them!</a>
<BR>$username - You have $pmcount private message(s) ($newpmcount new) -  Latest Message from <a href="member.php?action=getinfo&userid=$lastid">$lastuser</a></smallfont></td>
</tr>

Also, I suggest EVERYONE!! snag the newest private.php, since it contains all the bugfixes I know of

~~~Current Version: v0.9.3

BTW, Me2Be, yes that's better... Women...

2 more bugs...

When you go to delete a post and hit cancel the post still gets deleted.

Even if you don't check the "delete" check box you can hit delete and the post is removed.

I updated to the new version and i'm now unable to log in with the username 'Craig Antill' but I am able to with the username 'Administrator' - I presume it's because it's a single word with no spaces ? This has only happened since I updated - here is the error I get:

Database error in vBulletin: Invalid SQL: SELECT username FROM user WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
Date: Thursday 15th of June 2000 09:32:41 AM
Script: /forum/index.php
Referer:

I have just been and double checked that I followed the instructions correctly - I did - does anyone else have this problem ? If not, what could it be ?

OK, found the problem - the instructions in the latest .zip don't seem to match the code you give above. I've added the above code in place of that in the zip and all is fine and dandy.

You do like to panic me, don't you ?!

Hey! Just noticed the time and date features - excellent! I've now setup pmloggedin exactly like forumbit with full details of the last post - time, date & who made it - as well as the lightbulbs - great work fellas

I was curious to see what icon people were choosing.. and of those I checked, they were quite varied in their selection. Our poor hack author Ed has a dark (black?) background and you couldn't read the icon text. So here for our esteemed hack are the icons with white text...





[Edited by Wake America on 06-15-2000 at 07:10 AM]

Craig - Sorry about that, I knew I had that typo at one time, but I thought I fixed it

Rick - Fixed both bugs you mentioned (one was just a typo in makeprivtables.php)

I suggest everyone re-update their private.php

WakeAmerica - Thanks! I never got around to making the white text version.