Send Welcome PM to New User fix

New Member Joined: Jun 27, 2006 Posts: 8 Location: UK

Hi there,
I don't know if anyone as fix the issue with cnbya, sending welcome pm to new users and having the pm appearing in there mail box as a new unread message.

The following is a working fix for this problem.

Follow the instructions for the mod except for

Code:




#


#-----[ OPEN ]------------------------------------------


#


modules/Your_Account/index.php

Do the following instead:

Code:

#


#-----[ OPEN ]------------------------------------------


#


modules/Your_Account/public/saveactivate.php


#


#-----[ FIND ]------------------------------------------


#


include("header.php");


        title(""._ACTIVATIONYES."");


        OpenTable();

Insert the code as the mod states but change:

Code:

$sql = "INSERT INTO ".$user_prefix."_bbprivmsgs (privmsgs_type, privmsgs_subject, privmsgs_from_userid, privmsgs_to_userid, privmsgs_date, privmsgs_enable_html, privmsgs_enable_bbcode, privmsgs_enable_smilies, privmsgs_attach_sig) VALUES ('0', '" . str_replace("\'", "''", addslashes(sprintf($register_pm_subject,$sitename))) . "', '$privmsgs_from_userid', '$guserid', '$privmsgs_date', '0', '1', '1', '0')";

to

Code:

$sql = "INSERT INTO ".$user_prefix."_bbprivmsgs (privmsgs_type, privmsgs_subject, privmsgs_from_userid, privmsgs_to_userid, privmsgs_date, privmsgs_enable_html, privmsgs_enable_bbcode, privmsgs_enable_smilies, privmsgs_attach_sig) VALUES ('5', '" . str_replace("\'", "''", addslashes(sprintf($register_pm_subject,$username,$sitename))) . "', '3', '$guserid', '$privmsgs_date', '0', '1', '1', '1')";

The above change will make the Welcome pm show up in the new users mail box as a new message.

The follow the rest of the instructions.

This works on my site using phpNuke 7.9 patched with CNB_Your_Account_750_441.

registered · Posted: Thu Apr 19, 2007 5:24 am

Thanks!