[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 getting this error:

Database error in vBulletin: Invalid SQL: SELECT msgid,toid,fromid,title,UNIX_TIMESTAMP(datetime) AS datetime,iconid,text,signature FROM privatercvd WHERE msgid= AND toid=5053
mysql error: You have an error in your SQL syntax near 'AND toid=5053' at line 1
mysql error number: 1064
Date: Monday 11th of September 2000 12:28:03 PM
Script: /private.php?action=show
Referer: http://forums.paintballcity.com/private.php?action=show

Please help. Thanks.

any final release ?

I just had the most horrible time trying to install this hack, even though it probably should have been fairly easy. I'm using vBulletin v 1.1.3 B3 and followed the "first time installation" instructions which were included in the zip file.

I edited all of the files, then uploaded the makeprivtables.php file to my server. When I ran it, I got a database error, and the following message was sent to me:

Database error in vBulletin: Invalid SQL: ALTER TABLE usergroup ADD canusepm TINYINT (4) DEFAULT '1' not null
mysql error: Lost connection to MySQL server during query
mysql error number: 2013
Script: /forums/makeprivtables.php

I clicked 'refresh' and tried to run makeprivtables.php again. This time I got a new error:

Database error in vBulletin: Invalid SQL: ALTER TABLE usergroup ADD canusepm TINYINT (4) DEFAULT '1' not null
mysql error: Duplicate column name 'canusepm'
mysql error number: 1060
Script: /forums/makeprivtables.php

I went ahead and uploaded the modified files, changed the PM settings in options.php, and tried to access my board. When I tried to load my forums, I got a parse error:

Parse error: parse error in global.php on line 199

About an hour later, I gave up and restored my backup copies of the files which were edited. Everything appears to be working like before now, thankfully. I'm not sure if the problems were because of the Database errors, or maybe the instructions for modifying the code (I noticed that in the instructions for global.php it mentioned versions 1.1.2 and 1.1.1, but not 1.1.3).

I don't know a whole lot about MySQL, and vBulletin is the first PHP program I've used with my site. I have used plenty of Perl and CGI scripts before though, and have never really had a problem. Does anyone have an idea of what I might be doing wrong here, or what could be causing all of the problems? Any help is appreciated... thanks.

-Tom

Tom -

in makeprivtables.php uncomment this line:
//$DB_site->query("ALTER TABLE usergroup DROP canusepm"); (remove the //)

Then rerun it. If you get an error with it finding a duplicate column, uncomment the corresponding line. (look in the file - you'll see)

As for your parse error, then you messed up in editing the file.

This thing just doesn't want to work... I tried what you said, and still received an error:

Database error in vBulletin: Invalid SQL: ALTER TABLE usergroup DROP canusepm
mysql error: Lost connection to MySQL server during query
mysql error number: 2013
Date: Saturday 16th of September 2000 12:01:52 PM
Script: /forums/makeprivtables.php

I ran it again after that, and got a new error:

Database error in vBulletin: Invalid SQL: ALTER TABLE usergroup DROP canusepm
mysql error: Can't DROP 'canusepm'. Check that column/key exists
mysql error number: 1091
Date: Saturday 16th of September 2000 12:03:44 PM
Script: /forums/makeprivtables.php

According to that error, it can't find 'canusepm' so it can drop it... so I commented out the command in makeprivtables.php that drops that table and tried again...

Database error in vBulletin: Invalid SQL: ALTER TABLE usergroup ADD canusepm TINYINT (4) DEFAULT '1' not null
mysql error: Lost connection to MySQL server during query
mysql error number: 2013
Date: Saturday 16th of September 2000 12:04:52 PM
Script: /forums/makeprivtables.php

Just to clear up a few little things that could be causing this... lemme make sure I've done everything right here....

I uploaded makeprivtables.php to my /forums/ directory, and that's the ONLY file I have uploaded for this hack. In the php file it includes "global.php", which would mean it's including the global.php from the /forums/ directory and not the /forums/admin/ directory... is all of this correct? If so, I have NO clue why it's having so much trouble modifying the tables. It seems like it loses the MySQL connection ever time it's creating "canusepm", then runs into an error if I try again because it's trying to add a duplicate column... and this happens over and over. I hope somebody can help, I'd really like to get this hack working Thanks.

-Tom

[Edited by Tomeeboy on 09-16-2000 at 12:29 PM]

Being that that's the first ALTER command, I think your host isn't giving you full permissions. Talk to them about letting you have ALTER table permissions.

(Anyone else have any other ideas?)

No ALTER permission will clearly state "Access Denied" so it isn't that.

Man.. this is really bugging me now... hehe. I can usually figure out why stuff like this is happening, but this just doesn't make any sense at all. I have full permissions to everything, and I haven't had any other problems with MySQL or PHP on my server (except for the magic_quotes thing, but that was easy to fix). If anyone else has any more suggestions, keep 'em coming... I apprecitate the help.

-Tom

Okay... apparently, since I'm hosted by VServers, user authenticated access to the database via http is not possible... go figure... "virtual server" my rear.

Is there some way around this? perhaps through telnet or something? If not... can somebody recommend a good hosting company? lol.

-Tom

Another update!

Okay, I figured the ALTER command was the cause of the problem (thinking that I didn't have permission to use that command via HTTP), so I attempted to send the first few commands to MySQL while logged in through telnet. BAM! Same errors that I got while trying via HTTP. So I emailed tech support at VServers and asked what the deal was, and they responded saying that there are segmentation faults in the MySQL daemon! (the plot thickens...) So I guess that is what was causing the problem all along... not permissions. They're having a "senior programmer" work on it now... and hopefully it will get fixed sometime soon.

All of this trouble, just to add a hack to the message board. This private messaging thing better be damn good Ed! Hehehe.

Anyway.. just thought I'd let everyone know so you're not thinking up workarounds and stuff for me. I'll let everyone know how it turns out

-Tom