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

Ed:

One thing too. Do you have it written for 1.1.3 yet? I used the version that you have but noticed today that in the faq and bbcode pages you get a database error like:

Database error in vBulletin: Invalid SQL: SELECT announcementid,userid,startdate,title FROM announcement WHERE startdate<=963412951 AND enddate>=963412951 AND (forumid= OR forumid=-1) ORDER BY startdate DESC LIMIT 1
mysql error: You have an error in your SQL syntax near 'OR forumid=-1) ORDER BY startdate DESC LIMIT 1' at line 1
mysql error number: 1064
Date: Wednesday 12th of July 2000 09:42:31 AM
Script: /htforum/index.php?action=bbcode
Referer: http://www.hometheaterforum.com/htfo...php?action=faq

so it is probably where I am putting the code that have in the index.php file.

Could you look at 1.1.3 and see what changes need to be made in the placement of your code?

BTW, when I put the original code from 1.1.3 back in it took care of the problem.

Thanks,
Parker

Parker-

One other thing. I think you should make it to where the member can turn this option off. I know you have control as an admin to turn it off or on to the whole board but a lot our members don't like the private messging and don't want anyone sending them anything. This should also remove the icon that you put in the forumdisplay pages too so that they can't send a private message from there either.

See my list, it's "Coming...", as in I'm programming it right now.

You know looking at what you have done already it would nice if you put all the member selection in an options section.

Maybe if I feel like writing another template. I really hate making templates, and I'm already up to about 30 (!!!)

One thing too. Do you have it written for 1.1.3 yet?

Yes, works fine on 1.1.3. Look at my board.

I used the version that you have but noticed today that in the faq and bbcode pages you get a database error like: {SNIP}

Umm... I don't get them.

Doron-

all we need now are polls in a pm...

LOL, that's coming in version v80.1

Ed:

Since it is the index.php file that is causing the trouble
this is what I have.

Just below:
if ($action=="showforums") {

I have:

//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

and this is just above:

$numbersmembers=$DB_site->query_first("SELECT COUNT(userid) AS users FROM user");
$numbermembers=$numbersmembers[users];

Does this look right?

Parker

Parker - that code is fine, although the new version makes some changes.

Now, the weird thing: I just downloaded the new beta 3, and did some searches, both in global.php and index.php. And that SQL isn't even in either! So, it's not my hack that's causing them to die

That IS weird. If I put the orginal index.php file back in I don't get the error. If I put the one with the code added in I get the database error.

What I was wanting in the previous message was to know if I was putting it in right or not.

Maybe the new version will take care of this problem. Who knows.

Parker

[Edited by Parker Clack on 07-12-2000 at 01:18 PM]

Maybe I'm missing the point, or didn't catch the sarcasm, but...

What's the point with polls in a private message?

There would be two votes MAX...so it seems rather, pointless.

you could mass mail them and have a central poll..nah, that was a joke.

This is sweet! Goodbye mass e-mails hello personal messages!

Ed:

I sent you an email back with the file you requested.

Did you get it?

Parker

Yeah, I haven't looked at it extensively yet though. Can you do a quick search in your global.php for something in that SQL error (like, announcement) or something - I really have no clue what would cause that.

When forumid=-1 in an announcement, that means it's going to any forum. So what the script is trying to grab looks like a forumdisplay.php routine: grab announcements for any forum (-1) or this forum (the blank space, since you're not in a forum). But, w(why)tf would it be doing that in index.php?!

*shrug* Not sure yet...

And, to everyone, I'm very close to the new release. Tonight if I rush to document all the changes, most likely tomorrow though.

Some misc. stuff now:
- Yes, there is an upgrade route to the new version, but some of the templates have significant changes. I suggest using the default versions, and just rehacking (Besides, I'm not even sure of everything I've changed)
- 95% of the suggestions have been implemented, including a few that weren't "Done!" before.
- Unfortunately, with new features, comes more editing to vB's standard files--much more.

Now, some bragging rights:
- 4 new profile fields, 2 customizable via "modifyprofile", other 2 from PM hack itself
- one new field to "usergroup" table
- (Get ready) 35 new templates (!!)
- 3 new tables:
* privatercvd, now with 10 fields
* privatesent, with 8 fields
* and pmstats, with 4 (new feature, still lacking though)

Anyway, get ready