竹貓星球

已裝好 Custom mass PM 1.4.7 這個外掛.

外掛描述:
這個外掛, 可以讓擁有權限的使用者, 發送[大量私人訊息]給所有會員, 或特定群組; 一般使用者, 若要同時 PM 二人以上, 則只要用" ;", 將會員名稱隔開.

我重裝一次.目前用 一般使用者, 若要同時 PM 二人以上, 則只要用" ;", 將會員名稱隔開. 這個是ok
但發送[大量私人訊息]給所有會員, 或特定群組 請問這要怎麼用??

●架設主機作業系統：Windows xp pro sp3
●快速架站程式：Appserv v2.4.1
●免費空間連結：架在本電腦上
●我的上網方式：ADSL 固定 IP ,Hinet 8M/640K
●我安裝的程式：Apache + php + MySql
●我的 phpBB2 版本：phpBB 2.0.15
●我的 phpBB2 連結網址： http://220.135.86.146/phpbb
●我安裝過的外掛：Top5 TopicsVersion: 2.1.0 (加速改良版)Author: OOHOO
easyMod 0.0.7 繁體中文版本 由友誼第一翻譯 beta1 (0.1.13) by Nuttzy
快速砍人 1.4.3 (Prune users by Niels)
留言板shoutbox_1.1.5 (Fully integrated shoutbox by Niels)
跑馬燈公告版本1.0 By: Martinet Oaf
Blog 0.2.3
Last_visit 1.2.8
Cash mode 222
Date_time_last_visited
pay_money_1.0.9
pay_mod_extra_008

●我使用的風格：subsilver

smartpig 寫:
我重裝一次.目前用 一般使用者, 若要同時 PM 二人以上, 則只要用" ;", 將會員名稱隔開. 這個是ok
但發送[大量私人訊息]給所有會員, 或特定群組 請問這要怎麼用??

您必須先在後台的" 群組管理"-> " 管理選項" 當中去設定( 如下圖)

大量 PM 權限:
請選擇, 可對此群組, 發送大量 PM 的會員類型.

預設: 只有系統管理員有此( 發送[大量私人訊息]給所有會員) 權限.

做完相關設定後, 若要對特定群組發送[大量私人訊息],
則只要按下" 私人訊息" 旁邊的" 寄件夾" 圖示, 即可( 如下圖)


稍後, 將把此外掛的相關資料整理後, 發表在" 非官方推薦認證外掛" 版面.

我要去設定,結果跑出錯務訊息:
一般錯誤
Could not insert new group

DEBUG MODE

SQL Error : 1136 Column count doesn't match value count at row 1

INSERT INTO phpbb_groups (group_type, group_name, group_description, group_moderator, group_allow_pm, group_single_user, group_allow_weblogs) VALUES (1, 'friends', 'young and old man', 2, '0', 0)

Line : 389
File : admin_groups.php
.....................................................................................
附上我的admin_groups.php 389行附近

$sql = "UPDATE " . GROUPS_TABLE . "
SET group_type = $group_type, group_name = '" . str_replace("\'", "''", $group_name) . "', group_description = '" . str_replace("\'", "''", $group_description) . "', group_moderator = $group_moderator, group_allow_pm = '$group_allow_pm' , group_allow_weblogs = $group_allow_weblogs

WHERE group_id = $group_id";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not update group', '', __LINE__, __FILE__, $sql);
}

admin_group.php
$message = $lang['Updated_group'] . '<br /><br />' . sprintf($lang['Click_return_groupsadmin'], '<a href="' . append_sid("admin_groups.$phpEx") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>');;

message_die(GENERAL_MESSAGE, $message);
}
else if( $mode == 'newgroup' )
{
$sql = "INSERT INTO " . GROUPS_TABLE . " (group_type, group_name, group_description, group_moderator, group_allow_pm, group_single_user, group_allow_weblogs)
VALUES ($group_type, '" . str_replace("\'", "''", $group_name) . "', '" . str_replace("\'", "''", $group_description) . "', $group_moderator, '0', $group_allow_weblogs)";
if ( !$db->sql_query($sql) )
{
389 行 message_die(GENERAL_ERROR, 'Could not insert new group', '', __LINE__, __FILE__, $sql);
}
$new_group_id = $db->sql_nextid();

$sql = "INSERT INTO " . USER_GROUP_TABLE . " (group_id, user_id, user_pending)
VALUES ($new_group_id, $group_moderator, 0)";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not insert new user-group info', '', __LINE__, __FILE__, $sql);
}

$message = $lang['Added_new_group'] . '<br /><br />' . sprintf($lang['Click_return_groupsadmin'], '<a href="' . append_sid("admin_groups.$phpEx") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>');;

message_die(GENERAL_MESSAGE, $message);

}
else
{
message_die(GENERAL_MESSAGE, $lang['No_group_action']);
...................................................................................................
請問是那邊問題??

問題已解決.重新由原始檔再把mod加進去.

將該檔案有修改過的地方將安裝步驟反過來還原再安裝一次試試

smartpig 寫:我要去設定,結果跑出錯務訊息:
一般錯誤
Could not insert new group

DEBUG MODE

SQL Error : 1136 Column count doesn't match value count at row 1

INSERT INTO phpbb_groups (group_type, group_name, group_description, group_moderator, group_allow_pm, group_single_user, group_allow_weblogs) VALUES (1, 'friends', 'young and old man', 2, '0', 0)

Line : 389
File : admin_groups.php
.....................................................................................

您這個部份語法有個" 值( VALUES)" 沒有對應到, 試試看以下的修改:

#
#-----[ Find ]-----
#
$sql = "INSERT INTO " . GROUPS_TABLE . " (group_type, group_name, group_description, group_moderator, group_allow_pm, group_single_user, group_allow_weblogs)
VALUES ($group_type, '" . str_replace("\'", "''", $group_name) . "', '" . str_replace("\'", "''", $group_description) . "', $group_moderator, '0', $group_allow_weblogs)";

#
#-----[ Replace With ]-----
#
$sql = "INSERT INTO " . GROUPS_TABLE . " (group_type, group_name, group_description, group_moderator, group_allow_pm, group_single_user, group_allow_weblogs)
VALUES ($group_type, '" . str_replace("\'", "''", $group_name) . "', '" . str_replace("\'", "''", $group_description) . "', $group_moderator, '$group_allow_pm', '0', $group_allow_weblogs)";

JORDAN 寫:將該檔案有修改過的地方將安裝步驟反過來還原再安裝一次試試

thanks la..還好只動到兩個mod..改一下就ok la..

心靈捕手 寫:

smartpig 寫:我要去設定,結果跑出錯務訊息:
一般錯誤
Could not insert new group

DEBUG MODE

SQL Error : 1136 Column count doesn't match value count at row 1

INSERT INTO phpbb_groups (group_type, group_name, group_description, group_moderator, group_allow_pm, group_single_user, group_allow_weblogs) VALUES (1, 'friends', 'young and old man', 2, '0', 0)

Line : 389
File : admin_groups.php
.....................................................................................

您這個部份語法有個" 值( VALUES)" 沒有對應到, 試試看以下的修改:

#
#-----[ Find ]-----
#
$sql = "INSERT INTO " . GROUPS_TABLE . " (group_type, group_name, group_description, group_moderator, group_allow_pm, group_single_user, group_allow_weblogs)
VALUES ($group_type, '" . str_replace("\'", "''", $group_name) . "', '" . str_replace("\'", "''", $group_description) . "', $group_moderator, '0', $group_allow_weblogs)";

#
#-----[ Replace With ]-----
#
$sql = "INSERT INTO " . GROUPS_TABLE . " (group_type, group_name, group_description, group_moderator, group_allow_pm, group_single_user, group_allow_weblogs)
VALUES ($group_type, '" . str_replace("\'", "''", $group_name) . "', '" . str_replace("\'", "''", $group_description) . "', $group_moderator, '$group_allow_pm', '0', $group_allow_weblogs)";

太強啦..應該就是那個有無括號.我還特別看一下.可能就是沒加括號才會跑不出來.
,高手在有差啦...謝謝.