自動發歡迎訊息PM, 給新注冊用戶

phpBB 大部分皆是由竹貓星球提供資料!
頭像
yehrussell
忍辱、精進、靜慮、般若波羅密
忍辱、精進、靜慮、般若波羅密
主題中的帖子: 2
文章: 1114
註冊時間: 2006-01-20 , 10:19
個人狀態: 非常忙碌中!
性別: 公仔

自動發歡迎訊息PM, 給新注冊用戶

未閱讀文章 yehrussell » 2006-06-20 , 18:08

自動發歡迎訊息PM, 給新注冊用戶

http://phpbb-tw.net/phpbb/viewtopic.php?t=27740

代碼: 選擇全部

########################################################################################## 
## MOD Title: Send PM On User Registration 
## MOD Author: AbelaJohnB < abela@phpbb.com > (John B. Abela) http://www.JohnAbela.Com/ 
## MOD Author, Secondary: typicalgeek  < me@typicalgeek.com > (N/A)  http://www.typicalgeek.com 
## MOD Author, Secondary: netclectic < adrian@netclectic.com > (Adrian Cockburn) http://www.netclectic.com 
## MOD Description: This MOD will send a PM to all new users when they register. 
## MOD Version: 1.0.2 
## 
## Installation Level: Easy 
## Installation Time: ~3 Minutes 
## Files To Edit: includes/usercp_register.php, language/lang_english/lang_main.php 
## Included Files: n/a 
########################################################################################## 
## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ for the 
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code 
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered 
## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/ 
########################################################################################## 
##Author Notes: 
## 
##  Copyright  ?John B. Abela. 2002 - http://www.JohnAbela.Com/ 
## 
## ** No Placement Of This MOD At Sites Other Than www.phpBB.Com Or www.JohnAbela.Com Without My Permission. 
## 
## If you download this MOD from anywhere other than my own site or phpBB, please do not 
## use it. I do not allow this MOD (or any of mine) to be posted at non-official phpBB Sites, 
## and as such I will not be able to keep this MOD up-to-date at any of these non-official sites 
## which do not respect my request to not place it within their site. If you do find it at a site 
## other than phpBB.com please let me know!  <abela@phpbb.com> 
## 
## If you are an owner of a non-official site and would like to place it within your site, please 
## email me for permission, so I can keep track of who has it and where it's at, to help keep 
## keep your site up-to-date with this MOD. 
## 
## For anybody that likes this MOD, you can always say 'thanks' by signing my guestbook at 
## my web site!   http://www.JohnAbela.Com/   
## 
## This MOD does not take into consideration any user registration methods. 
##  ie: confirm via email, auto register, etc) Any new person that registers will get a PM, 
##  even if they have not confirmed their account. I do not plan on changing this, as I do 
## not really see the point in doing such. 
## 
########################################################################################## 
## History: 
## 
## 1.0.2 - 1/10/2003 - Updated To Work With phpBB2.0.4. Included fix by 'netclectic' to account for instant pop-up of new message. (thanks!) 
## 1.0.1 - 9/19/2002 - Updated Language Section To Include 'typicalgeek's method of site name. 
## 
########################################################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
########################################################################################## 
#
#-----[ OPEN ]------------------------------------------
#
includes/usercp_register.php

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

代碼: 選擇全部

$sql = "INSERT INTO " . GROUPS_TABLE . " (group_name, group_description, group_single_user, group_moderator) 
#
#-----[ BEFORE, ADD ]------------------------------------------
#

代碼: 選擇全部

        // START - SEND PM ON REGISTER MOD - AbelaJohnB 
   // 
   // According to 'netclectic' we need to set the datastamp to '9999999999' in order to 
   // insure the pop-up notification about a new message existing. I concur with 'netclectic' 
   // and have thus made the change to his suggestion. Thanks netclectic! 
        // 
   $sql = "UPDATE " . USERS_TABLE . " 
      SET user_new_privmsg = '1', user_last_privmsg = '9999999999' 
            WHERE user_id = $user_id"; 
      if ( !($result = $db->sql_query($sql)) ) 
        { 
          message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql); 
        } 

        $register_pm_subject = $lang['register_pm_subject']; 
        $register_pm = $lang['register_pm']; 
        $privmsgs_date = date("U"); 
        $sql = "INSERT INTO " . PRIVMSGS_TABLE . " (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,$board_config['sitename']))) . "', '2', " . $user_id . ", " . $privmsgs_date . ", '0', '1', '1', '0')"; 
        if ( !$db->sql_query($sql) ) 
      { 
         message_die(GENERAL_ERROR, 'Could not insert private message sent info', '', __LINE__, __FILE__, $sql); 
      } 

      $privmsg_sent_id = $db->sql_nextid(); 
      $privmsgs_text = $lang['register_pm_subject']; 
        // 
        $sql = "INSERT INTO " . PRIVMSGS_TEXT_TABLE . " (privmsgs_text_id, privmsgs_text) VALUES ($privmsg_sent_id, '" . str_replace("'", "''", addslashes(sprintf($register_pm,$board_config['sitename'],$board_config['sitename']))) . "')"; 
        if ( !$db->sql_query($sql) ) 
      { 
         message_die(GENERAL_ERROR, 'Could not insert private message sent text', '', __LINE__, __FILE__, $sql); 
      } 
        // END - SEND PM ON REGISTER MOD - AbelaJohnB 
#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_main.php

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

代碼: 選擇全部

$lang['Click_view_privmsg'] = '點選 %s這裡%s 進入私人訊息收件夾';
#
#-----[ AFTER, ADD ]------------------------------------------
#

代碼: 選擇全部

 // START - SEND PM ON REGISTER MOD - AbelaJohnB 
$lang['register_pm_subject'] = '歡迎來到 %s'; 
$lang['register_pm'] = '您好!<br /><br />歡迎來到 %s. <br /><br />我們誠摯邀請您加入中醫世界! <br /><br />您有好的心得,請分享於大家!^_^ 感恩您!<br /><br />~Enjoy!<br />%s 管理團隊 '; 
// END - SEND PM ON REGISTER MOD - AbelaJohnB 
#
\n#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM


使用版本:2.0.10
狀況描述:

這個外掛會自動發歡迎訊息PM, 給新注冊用戶。
而那PM 的寄件人是系統管理員。

但小弟想將寄件人改成某個特定用戶,請問我可以從那入手呢?



頭像
yehrussell
忍辱、精進、靜慮、般若波羅密
忍辱、精進、靜慮、般若波羅密
主題中的帖子: 2
文章: 1114
註冊時間: 2006-01-20 , 10:19
個人狀態: 非常忙碌中!
性別: 公仔

Re: 自動發歡迎訊息PM, 給新注冊用戶

未閱讀文章 yehrussell » 2006-06-20 , 18:10

shihchieh

VALUES ('0', '" . str_replace("'", "''", addslashes(sprintf($register_pm_subject,$board_config['sitename']))) . "', '2'

把那個2改成你要指定的user_id



頭像
懸壺子
系統管理員
系統管理員
主題中的帖子: 1
文章: 31252
註冊時間: 2001-10-05 , 10:10
個人狀態: 道骨學習佛心..^^..
貼心留言: 氣候不穩
性別: 公仔
來自: 黃金故鄉
聯繫:

Re: 自動發歡迎訊息PM, 給新注冊用戶

未閱讀文章 懸壺子 » 2006-12-29 , 21:05

搬移至自家主機升級2.022版後,會員註冊發現問題,無法寄出伊妹兒!

錯誤如下:

代碼: 選擇全部

 Message   一般錯誤 
  
Could not update users table

DEBUG MODE

SQL Error : 1264 Out of range value adjusted for column 'user_last_privmsg' at row 1

UPDATE phpbb_users SET user_new_privmsg = '1', user_last_privmsg = '9999999999' WHERE user_id = 181

Line : 668
File : usercp_register.php 
把本外掛 Send PM On User Registration 拆掉,就可以註冊囉!  ab:


圖檔

版面已鎖定 主題已鎖定

回到「phpBB2」