參考連結：
快速回覆PLUS進階版
黃牌系統官方討論版
使用版本：PBPBB206
網站位置：建構中
狀況描述：
快速回覆PLUS進階版安裝後,無法使用快速回覆或引用文章
會出現網頁出現錯誤
連預覽也出現一樣的錯誤訊息\r
其他黃牌功能沒有問題
一般錯誤
No action specified
DEBUG MODE
mode=""
Line : 87
File : c:\appserv\www\phpbb\card.php
card.php小弟並未做任何修改\r
附上
代碼: 選擇全部
define('IN_PHPBB', true);
//
// Load default header
//
$phpbb_root_path = "./";
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
// Find what we are to do
$mode = ( isset($HTTP_POST_VARS['report_x']) ) ? 'report' :
((isset($HTTP_POST_VARS['report_reset_x']) ) ? 'report_reset' :
((isset($HTTP_POST_VARS['ban_x']) ) ? 'ban' :
((isset($HTTP_POST_VARS['unban_x']) ) ? 'unban' :
((isset($HTTP_POST_VARS['warn_x']) ) ? 'warn' :
((isset($HTTP_POST_VARS['block_x']) ) ? 'block' : ''
)
)
)
)
);
$post_id = ( isset($HTTP_POST_VARS['post_id']) ) ? intval ($HTTP_POST_VARS['post_id']) : '';
$user_id = ( isset($HTTP_POST_VARS[POST_USERS_URL]) ) ? intval ($HTTP_POST_VARS[POST_USERS_URL]) : '';
// check that we have all what is needed to know
if ( !( $post_id + $user_id ) )
message_die(GENERAL_ERROR, "No user/post specified", "", __LINE__, __FILE__,'post_id="'.$post_id.'", user_id="'.$user_id.'"');
if ( empty($mode) )
message_die(GENERAL_ERROR, "No action specified", "", __LINE__, __FILE__,'mode="'.$mode.'"');
$sql = 'SELECT DISTINCT forum_id, poster_id, post_bluecard FROM ' . POSTS_TABLE . ' WHERE post_id = "'.$post_id.'"';
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't obtain forums information.", "", __LINE__, __FILE__, $sql);
$result = $db->sql_fetchrow($result);
$blue_card = $result['post_bluecard'];
if ( $post_id )
{
// post mode
$forum_id = $result['forum_id'];
$poster_id = $result['poster_id'];
} else
if ( $user_id )
{
//user mode
//forum_id will control witch permission, when no post_id is given, and a user_id is given instead
//disable the frum_id line will give no default access when no post_id is given
// installe extra permission mod, in order to enable this feature
// $forum_id = PAGE_CARD;
$poster_id = $user_id;
}
$userdata = session_pagestart($user_ip, PAGE_CARD);
init_userprefs($userdata);
//
// Start auth check
//
$is_auth = array();
$is_auth = auth(AUTH_ALL, $forum_id, $userdata);
if ($mode=="report_reset")
{
if (! $is_auth['auth_mod'])
message_die(GENERAL_ERROR, $lang['Not_Authorised']);
$sql = 'SELECT pt.post_subject, f.forum_name FROM '.POSTS_TEXT_TABLE.' pt, '.POSTS_TABLE.' p, '.FORUMS_TABLE.' f WHERE pt.post_id="'.$post_id.'" AND p.post_id=pt.post_id AND p.forum_id=f.forum_id';
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't get post subject information".$sql);
$subject = $db->sql_fetchrow($result);
$post_subject=$subject['post_subject'];
$forum_name=$subject['forum_name'];
$sql = 'UPDATE ' . POSTS_TABLE . ' SET post_bluecard="0" WHERE post_id="'.$post_id.'"';
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't update blue card information");
message_die(GENERAL_MESSAGE, $lang['Post_reset']."<br /><br />".
sprintf($lang['Click_return_viewtopic'], "<a href=\"" . append_sid("viewtopic.$phpEx?p=".$post_id."#".$post_id). "\">", "</a>"));
} else
if ($mode=="report")
{
if (!$is_auth['auth_bluecard'])
{
message_die(GENERAL_ERROR, $lang['Not_Authorised']);
}
$sql = 'SELECT f.forum_name, p.topic_id FROM '.POSTS_TABLE.' p, '.FORUMS_TABLE.' f WHERE p.post_id="'.$post_id.'" AND p.forum_id=f.forum_id';
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't get post subject information");
$post_details = $db->sql_fetchrow($result);
$forum_name=$post_details['forum_name'];
$topic_id=$post_details['topic_id'];
$sql = 'SELECT pt.post_subject FROM '.POSTS_TEXT_TABLE.' pt, '.TOPICS_TABLE.' t WHERE t.topic_id="'.$topic_id.'" AND pt.post_id=t.topic_first_post_id';
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't get topic subject information".$sql);
$post_details = $db->sql_fetchrow($result);
$post_subject=$post_details['post_subject'];
$sql = 'SELECT p.topic_id FROM '.POSTS_TEXT_TABLE.' pt, '.POSTS_TABLE.' p WHERE pt.post_subject="('.$post_id.')'.$post_subject.'" AND pt.post_id=p.post_id';
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't get topic subject information".$sql);
$post_details = $db->sql_fetchrow($result);
$allready_reported= ($blue_card) ? $post_details['topic_id'] : '';
$blue_card++;
$sql = 'UPDATE ' . POSTS_TABLE . ' SET post_bluecard="'.$blue_card.'" WHERE post_id="'.$post_id.'"';
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't update blue card information");
//
// Obtain list of moderators of this forum
$sql = "SELECT g.group_name, u.username, u.user_email, u.user_lang
FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g, " . USERS_TABLE . " u
WHERE aa.forum_id = $forum_id AND aa.auth_mod = " . TRUE . "
AND ug.group_id = aa.group_id AND g.group_id = aa.group_id AND u.user_id = ug.user_id";
if( !$result_mods = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't obtain moderators information.", "", __LINE__, __FILE__, $sql);
$total_mods = $db->sql_numrows($result_mods);
$i=0;
if (!$total_mods)
message_die(GENERAL_MESSAGE, $lang['No_moderators']."<br /><br />".
(($board_config['report_forum'])? sprintf($lang['Send_message'], "<a href=\"" . append_sid("posting.$phpEx?mode=".(($allready_reported)?"reply&t=".$allready_reported:"newtopic&f=".$board_config['report_forum'])."&postreport=".$post_id). "\">", "</a>"):"").
sprintf($lang['Click_return_viewtopic'], "<a href=\"" . append_sid("viewtopic.$phpEx?p=".$post_id."#".$post_id). "\">", "</a>"));
if (( $blue_card>=$board_config['bluecard_limit_2'] && (!(($blue_card-$board_config['bluecard_limit_2'])%$board_config['bluecard_limit']))) || $blue_card==$board_config['bluecard_limit_2'])
{
$mods_rowset = $db->sql_fetchrowset($result_mods);
include($phpbb_root_path . 'includes/emailer.'.$phpEx);
while ($i<$total_mods)
{
$script_name = preg_replace('/^\/?(.*?)\/?$/', '\1', trim($board_config['script_path'])). '/viewtopic.'.$phpEx;
$server_name = trim($board_config['server_name']);
$server_protocol = ( $board_config['cookie_secure'] ) ? 'https://' : 'http://';
$server_port = ( $board_config['server_port'] <> 80 ) ? ':' . trim($board_config['server_port']) . '/' : '/';
$emailer = new emailer($board_config['smtp_delivery']);
$emailer->email_address($mods_rowset[$i]['user_email']);
$email_headers = "To: \"".$mods_rowset[$i]['username']."\" <".$mods_rowset[$i]['user_email']. ">
";
$email_headers .= "From: \"".$board_config['sitename']."\" <".$board_config['board_email'].">
";
$email_headers .= "Return-Path: " . (($userdata['user_email']&&$userdata['user_viewemail'])? $userdata['user_email']."
":"
");
$email_headers .= "X-AntiAbuse: Board servername - " . $server_name . "
";
$email_headers .= "X-AntiAbuse: User_id - " . $userdata['user_id'] . "
";
$email_headers .= "X-AntiAbuse: Username - " . $userdata['username'] . "
";
$email_headers .= "X-AntiAbuse: User IP - " . decode_ip($user_ip) . "
";
$emailer->use_template("repport_post",(file_exists($phpbb_root_path . "language/lang_" . $mods_rowset[$i]['user_lang'] . "/email/repport_post.tpl"))?$mods_rowset[$i]['user_lang'] : "");
$i++;
// $emailer->set_subject($lang['Post_repport']);
$emailer->extra_headers($email_headers);
$emailer->assign_vars(array(
'POST_URL' => $server_protocol . $server_name . $server_port . $script_name . '?' . POST_POST_URL . "=$post_id#$post_id",
'POST_SUBJECT' => $post_subject,
'FORUM_NAME' => $forum_name,
'USER' => '"'.$userdata['username'].'"',
'NUMBER_OF_REPPORTS' => $blue_card,
'SITENAME' => $board_config['sitename'],
'BOARD_EMAIL' => $board_config['board_email']));
$emailer->send();
$emailer->reset();
}
}
message_die(GENERAL_MESSAGE, (($total_mods)?sprintf($lang['Post_repported'],$total_mods):$lang['Post_repported_1'])."<br /><br />".
(($board_config['report_forum'])? sprintf($lang['Send_message'], "<a href=\"" . append_sid("posting.$phpEx?mode=".(($allready_reported)?"reply&t=".$allready_reported:"newtopic&f=".$board_config['report_forum'])."&postreport=".$post_id). "\">", "</a>"):"").
sprintf($lang['Click_return_viewtopic'], "<a href=\"" . append_sid("viewtopic.$phpEx?p=".$post_id."#".$post_id). "\">", "</a>"));
} else
if ( $mode == 'unban' )
{
$no_error_ban=FALSE;
if (! $is_auth['auth_greencard'] )
message_die(GENERAL_ERROR, $lang['Not_Authorised']);
// look up the user
$sql = 'SELECT user_active, user_warnings FROM ' . USERS_TABLE . ' WHERE user_id="'.$poster_id.'"';
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't obtain judge information.", "", __LINE__, __FILE__, $sql);
$the_user = $db->sql_fetchrow($result);
// remove the user from ban list
$sql = 'DELETE FROM ' . BANLIST_TABLE . ' WHERE ban_userid="'.$poster_id.'"';
if (! $result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't remove ban_userid info into database", "", __LINE__, __FILE__, $sql);
// update the user table with new status
$sql = 'UPDATE ' . USERS_TABLE . ' SET user_warnings="0" WHERE user_id="'.$poster_id.'"';
if(! $result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't update user status information", "", __LINE__, __FILE__, $sql);
$message = $lang['Ban_update_green']."<br /><br />".
sprintf($lang['Send_PM_user'], "<a href=\"" . append_sid("privmsg.$phpEx?mode=post&u=$poster_id"). "\">", "</a>");
$e_temp="ban_reactivated";
// $e_subj=$lang['Ban_reactivate'];
$no_error_ban=true;
} else
if ( $mode == 'ban' )
{
$no_error_ban=FALSE;
if (! $is_auth['auth_ban'] )
message_die(GENERAL_ERROR, $lang['Not_Authorised']);
// look up the user
$sql = 'SELECT user_active, user_level FROM ' . USERS_TABLE . ' WHERE user_id="'.$poster_id.'"';
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't obtain judge information.", "", __LINE__, __FILE__, $sql);
$the_user = $db->sql_fetchrow($result);
if ($the_user['user_level']== ADMIN )
message_die(GENERAL_ERROR, $lang['Ban_no_admin']);
// insert the user in the ban list
$sql = 'SELECT ban_userid FROM ' . BANLIST_TABLE . ' WHERE ban_userid="'.$poster_id.'"';
if( $result = $db->sql_query($sql) )
{
if (!$db->sql_fetchrowset($result))
{
// insert the user in the ban list
$sql = "INSERT INTO " . BANLIST_TABLE . " (ban_userid) VALUES ($poster_id)";
if (!$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't insert ban_userid info into database", "", __LINE__, __FILE__, $sql);
// update the user table with new status
$sql = 'UPDATE ' . USERS_TABLE . ' SET user_warnings="'.$board_config['max_user_bancard'].'" WHERE user_id="'.$poster_id.'"';
if(! $result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't update user status information", "", __LINE__, __FILE__, $sql);
$sql = 'UPDATE ' . SESSIONS_TABLE . ' SET session_logged_in="0" WHERE session_user_id="'.$poster_id.'"';
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't update banned sessions from database", "", __LINE__, __FILE__, $sql);
}
$no_error_ban=true;
$message = $lang['Ban_update_red'];
$e_temp="ban_block";
// $e_subj=$lang['Card_banned'];
} else
{
$no_error_ban = true;
$message = $lang['user_already_banned'];
}
} else message_die(GENERAL_ERROR, "Couldn't obtain banlist information", "", __LINE__, __FILE__, $sql);
} else
if ( $mode == 'block' )
{
if (empty($board_config['block_time']) )
message_die(GENERAL_ERROR, "Protect user account mod not installed, this is required for this operation");
$no_error_ban=FALSE;
if (! $is_auth['auth_ban'] )
message_die(GENERAL_ERROR, $lang['Not_Authorised']);
// look up the user
$sql = 'SELECT user_active, user_level FROM ' . USERS_TABLE . ' WHERE user_id="'.$poster_id.'"';
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't obtain judge information.", "", __LINE__, __FILE__, $sql);
$the_user = $db->sql_fetchrow($result);
if ($the_user['user_level']== ADMIN )
message_die(GENERAL_ERROR, $lang['Block_no_admin']);
// update the user table with new status
$sql = 'UPDATE ' . USERS_TABLE . ' SET user_block_by="'.$user_ip.'", user_blocktime="'.(time()+$board_config['RY_block_time']*60).'" WHERE user_id="'.$poster_id.'"';
if(! $result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't update user status information", "", __LINE__, __FILE__, $sql);
$sql = 'UPDATE ' . SESSIONS_TABLE . ' SET session_logged_in="0", session_user_id=".ANONYMOUS." WHERE session_user_id="'.$poster_id.'"';
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't update blocked sessions from database", "", __LINE__, __FILE__, $sql);
}
$no_error_ban=true;
$block_time = make_time_text ($board_config['RY_block_time']);
$message = sprintf($lang['Block_update'],$block_time) . "<br /><br />".
sprintf($lang['Send_PM_user'], "<a href=\"" . append_sid("privmsg.$phpEx?mode=post&u=$poster_id"). "\">", "</a>");
$e_temp="card_block";
// $e_subj=sprintf($lang['Card_blocked'],$block_time);
} else
if ( $mode == 'warn' )
{
$no_error_ban=FALSE;
if (! $is_auth['auth_ban'] )
message_die(GENERAL_ERROR, $lang['Not_Authorised']);
// look up the user
$sql = 'SELECT user_active, user_warnings, user_level FROM ' . USERS_TABLE . ' WHERE user_id="'.$poster_id.'"';
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't obtain judge information.", "", __LINE__, __FILE__, $sql);
$the_user = $db->sql_fetchrow($result);
if ($the_user['user_level']== ADMIN )
message_die(GENERAL_ERROR, $lang['Ban_no_admin']);
//update the warning counter
$sql = 'UPDATE ' . USERS_TABLE . ' SET user_warnings=user_warnings+1 WHERE user_id="'.$poster_id.'"';
if(! $result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't update user status information", "", __LINE__, __FILE__, $sql);
// se if the user are to be banned, if so do it ...
if ($the_user['user_warnings']+1>=$board_config['max_user_bancard'])
{
$sql = 'SELECT ban_userid FROM ' . BANLIST_TABLE . ' WHERE ban_userid="'.$poster_id.'"';
if( $result = $db->sql_query($sql) )
{
if (!$db->sql_fetchrowset($result))
{
// insert the user in the ban list
$sql = "INSERT INTO " . BANLIST_TABLE . " (ban_userid) VALUES ($poster_id)";
if (!$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't insert ban_userid info into database", "", __LINE__, __FILE__, $sql);
// update the user table with new status
$sql = 'UPDATE ' . SESSIONS_TABLE . ' SET session_logged_in="0" WHERE session_user_id="'.$poster_id.'"';
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't update banned sessions from database", "", __LINE__, __FILE__, $sql);
}
$no_error_ban=true;
$message = $lang['Ban_update_red'];
$e_temp="ban_block";
// $e_subj=$lang['Ban_blocked'];
} else
{
$no_error_ban = true;
$message = $lang['user_already_banned'];
}
} else message_die(GENERAL_ERROR, "Couldn't obtain banlist information", "", __LINE__, __FILE__, $sql);
} else
{
// the user shall not be baned this time, update the counter
$message = sprintf($lang['Ban_update_yellow'],$the_user['user_warnings']+1,$board_config['max_user_bancard'])."<br /><br />".
sprintf($lang['Send_PM_user'], "<a href=\"" . append_sid("privmsg.$phpEx?mode=post&u=$poster_id"). "\">", "</a>"); $no_error_ban=true;
$e_temp="ban_warning";
// $e_subj=$lang['Ban_warning'];
}
}
if ($no_error_ban)
{
$sql = 'SELECT username, user_warnings, user_email, user_lang FROM ' . USERS_TABLE . ' WHERE user_id="'.$poster_id.'"';
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, "Couldn't find the users personal information", "", __LINE__, __FILE__, $sql);
$warning_data=$db->sql_fetchrow($result);
if (!empty($warning_data['user_email']))
{
include($phpbb_root_path . 'includes/emailer.'.$phpEx);
$script_name = preg_replace('/^\/?(.*?)\/?$/', '\1', trim($board_config['script_path'])). '/viewtopic.'.$phpEx;
$server_name = trim($board_config['server_name']);
$server_protocol = ( $board_config['cookie_secure'] ) ? 'https://' : 'http://';
$server_port = ( $board_config['server_port'] <> 80 ) ? ':' . trim($board_config['server_port']) . '/' : '/';
$emailer = new emailer($board_config['smtp_delivery']);
$email_headers = "TO: '".$warning_data['username']."' <".$warning_data['user_email']. ">
";
$email_headers .= ($userdata['user_email'] && $userdata['user_viewemail']) ?
"FROM: \"".$userdata['username']."\" <".$userdata['user_email'].">
" :
"FROM: \"".$board_config['sitename']."\" <" .$board_config['board_email'] . ">
";
$emailer->use_template($e_temp, stripslashes($warning_data['user_lang']));
$emailer->email_address($warning_data['user_email']);
// $emailer->set_subject($e_subj);
$emailer->extra_headers($email_headers);
$emailer->assign_vars(array(
'SITENAME' => $board_config['sitename'],
'WARNINGS' => $warning_data['user_warnings'],
'TOTAL_WARN' => $board_config['max_user_bancard'],
'POST_URL' => $server_protocol . $server_name . $server_port . $script_name . '?' . POST_POST_URL . "=$post_id#$post_id",
'EMAIL_SIG' => str_replace("<br />", "
", "--
" . $board_config['board_email_sig']),
'WARNER' => $userdata['username'],
'BLOCK_TIME' => $block_time,
'WARNED_POSTER' => $warning_data['username'])
);
// if ($e_subj)
// {
$emailer->send();
// }
$emailer->reset();
}
else
{
$message .= "<br/><br/>".$lang['user_no_email'];
}
}
else
{
$message = 'Error card.php file';
}\r
$message .= ( $post_id != '-1' ) ? "<br /><br />". sprintf($lang['Click_return_viewtopic'], "<a href=\"" . append_sid("viewtopic.$phpEx?p=".$post_id."#".$post_id). "\">", "</a>"):"<br /><br />". sprintf($lang['Click_return_index'], "<a href=\"" . append_sid("index.".$phpEx). "\">", "</a>");
message_die(GENERAL_MESSAGE, $message);
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>重新安裝數次結果依然相同,檢查了一整天無法解決,請教各位前輩有無解答,謝謝~
補充：
CASH MOD
黃卡\r
快速回覆PLUS進階版
