WelcomePM help wont work!

maddog · New Member Joined: Jul 07, 2005 Posts: 19

Hello i recently attempted to install the WelcomePM capability into my phpnuke site. After i did a temp sign up and loged in as a user the "Your_account" main page says i have a new message. But when i go check my inbox their is nothing their. Any idea where i might have made a flaw in the installing of this very usefull and nice script? I run phpnuke 7.7 as well as autotheme lite .8 and nukeSentinel.

Raven · Posted: Fri Jul 08, 2005 10:54 pm

Check your server error log to see if anything is being recorded.

maddog · New Member Joined: Jul 07, 2005 Posts: 19

ya their is nothing saying anything about error. If you want i can send you the code i changed and see if i did something wrong or paste the code here or you can sign up on site and see for yourself.

Raven · Posted: Sat Jul 09, 2005 12:33 pm

Changed? You shouldn't be changing any code. You just need to add that code to the index.php file.

maddog · New Member Joined: Jul 07, 2005 Posts: 19

Yeah thats what i mean. the code i added.

maddog · New Member Joined: Jul 07, 2005 Posts: 19

Here is the code that i added to the index.php: (whole activate function code):

Code:

far as i can see thats exactly how its suppose to be, i do not know why its not working because the PM utility does function i have successfully cent pm's already.

Raven · Posted: Sun Jul 10, 2005 11:17 am

Please restore the header/comment block to this code. By stripping it out you have removed the credits Sad

. That is specifically stated in the header
License : GNU/GPL - Use it, modify it, but please respect the Credits

Then repost your code.

maddog · New Member Joined: Jul 07, 2005 Posts: 19

Ah, sorry about that didn't mean to take any rights to it.
Here is the code that i added to the index.php: (whole activate function code):

Code:

This is the code that i added to the the bottom of the lang-english.php but right before the ?>:

Code:

// START - Send PM On User Register
/* Change the text 'Raven' in define("_PRIVMSGS_FROM_USERNAME","Raven"); to the name of the user that you want the Welcome message PM to be FROM
*/
global $sitename, $adminmail;
define("_MYSQL_ERROR","Unable to update %s table - MySQL said: ");
define("_PRIVMSGS_FROM_USERNAME","IGL Administration");
define("_REGISTER_PM_SUBJECT","Welcome to $sitename");
define("_REGISTER_PM","Hello! Welcome to $sitename. We hope you enjoy your time at this site! Feel free to join in and share with others or start your own discussion! Before posting please take time to read <a href=\"http://ravenphpscripts.com/postp41533.html\" title=\"Welcome to $sitename - Read Me First\">[b]this welcome message[/b]</a> ~Enjoy! $sitename Staff");
// END - Send PM On User Register

Far as i can see thats exactly how its suppose to be, i do not know why its not working because the PM utility does function i have successfully sent pm's already.

Raven · Posted: Sun Jul 10, 2005 12:43 pm

Let's start debugging Wink

. First off, comment out

Code:

// BEGIN -- The following code is courtesy of Chatserv 2005 -- //
$pmResult = $db->sql_query("SELECT user_id FROM ".$user_prefix."_users WHERE username='$row[username]'");
$pmRow = $db->sql_fetchrow($pmResult);
$guserid = intval($pmRow[user_id]);
$db->sql_query("INSERT INTO ".$prefix."_bbgroups (group_name, group_description, group_single_user, group_moderator) VALUES ('', 'Personal User', '1', '0')");
$group_id = $db->sql_nextid();
$db->sql_query("INSERT INTO ".$prefix."_bbuser_group (user_id, group_id, user_pending) VALUES ('$guserid', '$group_id', '0')");
// END -- The above code is courtesy of Chatserv 2005 -- //

and try it.

maddog · New Member Joined: Jul 07, 2005 Posts: 19

alright i did that, this time it doesnt even say that i got any PM's waiting. It just looks normal like this script was never their.

Raven · Posted: Sun Jul 10, 2005 12:57 pm

My bad

. Don't comment this line

Code:

$guserid = intval($pmRow[user_id]);

maddog · New Member Joined: Jul 07, 2005 Posts: 19

ok fixing trying again after i make a quick adjustment for something else.

maddog · New Member Joined: Jul 07, 2005 Posts: 19

Yup tried it i have the same result as before.

Raven · Posted: Sun Jul 10, 2005 1:39 pm

Please post your _bbprivmsgs and _bbprivmsgs_text schema. Also, you say there are no errors in your error log. Make sure that in .htaccess you have the following line

Code:

php_flag display_errors on

Then check your error log.

maddog · New Member Joined: Jul 07, 2005 Posts: 19

Here is the _bbprivmsgs structure:

Code:

Field Type Attributes Null Default Extra Action
privmsgs_id mediumint(8) UNSIGNED No auto_increment
privmsgs_type tinyint(4) No 0
privmsgs_subject varchar(255) No 0
privmsgs_from_userid mediumint(8) No 0
privmsgs_to_userid mediumint(8) No 0
privmsgs_date int(11) No 0
privmsgs_ip varchar(8) No
privmsgs_enable_bbcode tinyint(1) No 1
privmsgs_enable_html tinyint(1) No 0
privmsgs_enable_smilies tinyint(1) No 1
privmsgs_attach_sig tinyint(1) No 1

When i went to go and browse this it did show the welcome messages and the test pm i tried

Here is the _bbprivmsgs_text structure:

Code:

Field Type Attributes Null Default Extra Action
privmsgs_text_id mediumint(8) UNSIGNED No 0
privmsgs_bbcode_uid varchar(10) No 0
privmsgs_text text Yes NULL

This too showed the message the actual text of the pm

This is all i have in my .htaccess file:

Code:

Options All -Indexes
DirectoryIndex index.php index.htm index.html

# -------------------------------------------
# Start of NukeSentinel(tm) admin.php Auth
# -------------------------------------------
<Files .ftaccess>
deny from all
</Files>

<Files .staccess>
deny from all
</Files>

<Files admin.php>
<Limit GET POST PUT>
require valid-user
</Limit>
AuthName "Restricted"
AuthType Basic
AuthUserFile /path/to/your/.staccess
</Files>

# -------------------------------------------
# Start of NukeSentinel(tm) DENY FROM area
# -------------------------------------------

Raven · Posted: Sun Jul 10, 2005 1:59 pm

Well, add that line to .htaccess. So now I'm confused. If the 2 tables are showing the additions, why do you say it isn't there? Check the value of privmsgs_to_userid and verify that it is the user_id of the person you are logged in as.

maddog · New Member Joined: Jul 07, 2005 Posts: 19

the privmsgs_to_userid says 0. while the user_id 13 of the person who signed up. and same with the privmsgs_bbcode_uid is at 0 as well.

maddog · New Member Joined: Jul 07, 2005 Posts: 19

It looks to me like somehow the db isn't getting the new user id when an account is activated and is just using 0 by default when it sends the WelcomePM, so user doesnt ever actually recieve the actually PM.

Raven · Posted: Sun Jul 10, 2005 4:18 pm

I have PM'd you to try some code. Let me know.

maddog · New Member Joined: Jul 07, 2005 Posts: 19

Tried it their is no change if anything it messes up a little when users clicks on the confirmation e-mail. it works like orginal way. which is still not working hehe.

Raven · Posted: Sun Jul 10, 2005 4:45 pm

Well, I'm all out of suggestions at this point because it seems to work here. Actually, I PM'd you the wrong code. This is the code I use

Code:

/**************************************************************************************************/
/* Mod Name : Your_Account Mod to Send PM On User Register */
/* Author : Raven http://ravenphpscripts.com -- http://ravenwebhosting.com */
/* Version : 1.0.0 */
/* Release Date : July 6, 2005 */
/* License : GNU/GPL - Use it, modify it, but please respect the Credits */
/* Usage Notes : Be sure that you have added the language text to the language file and that you */
/* have modified it for your site. */
/**************************************************************************************************/
/* Other Credits: */
/* -- Inspired by and Adapted from John B. Abela's © Forum Send PM On User Register Mod © */
/* http://www.phpbb2mods.com */
/* */
/* -- Contributed by Chatserv 2005 */
/* Assign a group_id to new users to get rid of user and group permission errors in forums. */
/* http://www.nukefixes.com -- http://www.nukeresources.com */
/**************************************************************************************************/

   // BEGIN -- The following code is courtesy of Chatserv 2005 -- //
   $pmResult = $db->sql_query("SELECT user_id FROM ".$user_prefix."_users WHERE username='$row[username]'");
   $pmRow = $db->sql_fetchrow($pmResult);
   $guserid = intval($pmRow[user_id]);
   $db->sql_query("INSERT INTO ".$prefix."_bbgroups (group_name, group_description, group_single_user, group_moderator) VALUES ('', 'Personal User', '1', '0')");
   $group_id = $db->sql_nextid();
   $db->sql_query("INSERT INTO ".$prefix."_bbuser_group (user_id, group_id, user_pending) VALUES ('$guserid', '$group_id', '0')");
   // END -- The above code is courtesy of Chatserv 2005 -- //

   $pmResult = $db->sql_query("SELECT user_id FROM ".$user_prefix."_users WHERE username='"._PRIVMSGS_FROM_USERNAME."'");
   $pmRow = $db->sql_fetchrow($pmResult);
   $privmsgs_from_userid = intval($pmRow[user_id]);

   $register_pm_subject = _REGISTER_PM_SUBJECT;
   $register_pm = _REGISTER_PM;
   $privmsgs_date = date("U");

   $sql = "UPDATE ".$user_prefix."_users SET user_new_privmsg='1', user_last_privmsg='65534', user_unread_privmsg='1', user_popup_pm='1', user_notify='1', user_notify_pm='1' WHERE user_id='$guserid'";
   if (!$db->sql_query($sql)) {
      echo sprintf(_MYSQL_ERROR,'USERS').mysql_error();
      CloseTable();
      include('footer.php');
   }
   $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,$sitename))) . "', '$privmsgs_from_userid', '$guserid', '$privmsgs_date', '0', '1', '1', '0')";
   if (!$db->sql_query($sql)) {
      echo sprintf(_MYSQL_ERROR,'_BBPRIVMSGS').mysql_error();
      CloseTable();
      include('footer.php');
   }
   $privmsgs_text = $register_pm_subject;
   $privmsg_sent_id = $db->sql_nextid();
   $sql = "INSERT INTO ".$user_prefix."_bbprivmsgs_text (privmsgs_text_id, privmsgs_text) VALUES ($privmsg_sent_id, '" . str_replace("\'", "''", addslashes(sprintf($register_pm,$username,$sitename,$sitename))) . "')";
   if (!$db->sql_query($sql)) {
      echo sprintf(_MYSQL_ERROR,'_BBPRIVMSGS_TEXT').mysql_error();
      CloseTable();
      include('footer.php');
   }
/**************************************************************************************************/
/**************************************************************************************************/

maddog · New Member Joined: Jul 07, 2005 Posts: 19

Yeah still no change. Do you or can u recommend another program maybe even a module that does the same type or sort of thing, either within pm or here. Either way thanks for your support and assistance.

Raven · Posted: Sun Jul 10, 2005 6:10 pm

I just saw that you are using this define

Code:

define("_PRIVMSGS_FROM_USERNAME","IGL Administration");

Is "IGL Administration" a regsistered user on your site?

maddog · New Member Joined: Jul 07, 2005 Posts: 19

No it is not. I didnt know it had to be lol

Raven · Posted: Sun Jul 10, 2005 6:19 pm

Quote:

/* Change the text 'Raven' in define("_PRIVMSGS_FROM_USERNAME","Raven"); to the name of the user that you want the Welcome message PM to be FROM
*/

Only registered users can send PM's Smile