vb.org Archive - [RELEASE] Private Messaging (PM) Hack, v 1.2.0

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - [RELEASE] Private Messaging (PM) Hack, v 1.2.0 (https://vborg.vbsupport.ru/showthread.php?t=1772)

My problem is using HTML, VB code, or smilies does not work with my PM hack! Everything else seems to be fine!

I toggled settings in the admin panel to turn on and off these features, but it seems to be stuck in the off state.

Can someone point me in the right direction of the problem can may be?

Thanks Ed, I installed it sucessfully on my board! It's great!

Rangersfan - I finally got alter permissions on my Vbulletin, so I can finally install the avatar hack!

Okay, small problem:

Almost everyone is catagorized as "Unable to recieve Private Messages".

The reason for this is this: When you edit your profile, you have to choose the radio button that says "Receive Private Messages". Well, that's all fine and dandy. But then, if you edit your profile again, the radio buttons' position isn't saved (they're both unselected) and you HAVE to click on yes, even if you are doing something unrelated like changing your Biography. If you leave it unchecked, it assumes that you do NOT want to recieve PMs.

Also, everyone who was registered BEFORE the hack was installed has it turned off by default.

How do I fix these 2 problems?

Cid look at my posts on this page:

http://www.vbulletin.com/forum/showt...2&pagenumber=4

Quote:

Originally posted by rangersfan
Ok the problem is this is in the instructions:

Code:

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.

Okay, I know this is the problem that I have, and the solution, but I have no idea what you're saying here. Can you explain?

Well Cid I did explain. I will try to log in later and fix it for you.

Nevermind Rangersfan. I removed all the private messaging stuff from member.php and started again. Sure enough, its working now.

Thanks.

This is an absolutely great hack, I love the results!

If I may add, there should be warnings especially to those who have installed other hacks already, I have almost overwritten my Poll Hacks, good thing I paid more attention than usual.

Best of all, this hack works, and wonderfully at that! Great JOB!

Ed you do need to put a check in the hack because if someone deletes a message then goes back I get tons of tech errors emailed to me :)

Question about templates - what template contains the information on reply and that sort of things. I am looking for the actually text and links so I can change the color from white so it will show up on the white background.

I have been through all of them that I can find and cant seem to find it.

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?

Quote:

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

Code:

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

Code:

        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!

I patch those mentioned file in vb 1.1.4 except one
, I cannot found the search string mentioned in showthread.php

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (21)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02184 seconds Memory Usage 1,773KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (21)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: