安裝後出現問題，亦己 search old posts
希望大家能夠解答
代碼: 選擇全部
########################################################
## Mod Title: ModCP Merge Hack
## Mod Version: 1.0.1
## Author: sickb0y < http://www.p2pitalia.com >
## Description: This mod adds topics merge function
## in moderator control panel.
##
## Installation Level: (intermediate)
## Installation Time: 5-10 Minutes
## Files To Edit: 4
## Included Files: modcp_merge.tpl
########################################################
##
## Installation Notes:
##
##
## Put modcp_merge.tpl in templates/xxx/
##
########################################################
#
#-----[ OPEN includes/functions_admin.php ]-------------------
#
#
#-----[ FIND ]----------------------------------
#
function make_forum_select($box_name, $ignore_forum = false, $select_forum = '')
{
global $db, $userdata;
$is_auth_ary = auth(AUTH_READ, AUTH_LIST_ALL, $userdata);
$sql = "SELECT forum_id, forum_name
FROM " . FORUMS_TABLE . "
ORDER BY cat_id, forum_order";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Couldn not obtain forums information', '', __LINE__, __FILE__, $sql);
}
$forum_list = '';
while( $row = $db->sql_fetchrow($result) )
{
if ( $is_auth_ary[$row['forum_id']]['auth_read'] && $ignore_forum != $row['forum_id'] )
{
$selected = ( $select_forum == $row['forum_id'] ) ? ' selected="selected"' : '';
$forum_list .= '<option value="' . $row['forum_id'] . '"' . $selected .'>' . $row['forum_name'] . '</option>';
}
}
$forum_list = ( $forum_list == '' ) ? '<option value="-1">-- ! No Forums ! --</option>' : '<select name="' . $box_name . '">' . $forum_list . '</select>';
return $forum_list;
}
#
#-----[ AFTER, ADD ]------------------------------------------
#
function make_topic_select($box_name, $forum_id)
{
global $db, $userdata;
$is_auth_ary = auth(AUTH_READ, AUTH_LIST_ALL, $userdata);
$sql = "SELECT topic_id, topic_title
FROM " . TOPICS_TABLE . "
WHERE forum_id = $forum_id
ORDER BY topic_title";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Couldn not obtain topics information', '', __LINE__, __FILE__, $sql);
}
$topic_list = '';
while( $row = $db->sql_fetchrow($result) )
{
$topic_list .= '<option value="' . $row['topic_id'] . '">' . $row['topic_title'] . '</option>';
}
$topic_list = ( $topic_list == '' ) ? '<option value="-1">-- ! No Topics ! --</option>' : '<select name="' . $box_name . '">' . $topic_list . '</select>';
return $topic_list;
}
#
#-----[ CLOSE ]----------------------------------
#
#
#-----[ OPEN modcp.php ]-------------------
#
#
#-----[ FIND ]----------------------------------
#
else if ( $unlock )
{
$mode = 'unlock';
}
#
#-----[ AFTER, ADD ]------------------------------------------
#
else if ( $merge )
{
$mode = 'merge';
}
#
#-----[ FIND ]----------------------------------
#
message_die(GENERAL_MESSAGE, $lang['Topics_Unlocked'] . '<br /><br />' . $message);
break;
#
#-----[ AFTER, ADD ]------------------------------------------
#
case 'merge':
$page_title = $lang['Mod_CP'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
if ( $confirm )
{
if ( empty($HTTP_POST_VARS['topic_id_list']) && empty($topic_id) )
{
message_die(GENERAL_MESSAGE, $lang['None_selected']);
}
$new_topic_id = $HTTP_POST_VARS['new_topic'];
for ($i=0; $i < count($topic_id_list); $i++) {
$old_topic_id = $topic_id_list[$i];
if ( $new_topic_id != $old_topic_id )
{
$sql = "UPDATE " . POSTS_TABLE . "
SET topic_id = $new_topic_id
WHERE topic_id = $topic_id_list[$i]";
if ( !($result = $db->sql_query($sql, BEGIN_TRANSACTION)) )
{
message_die(GENERAL_ERROR, 'Could not update posts', '', __LINE__, __FILE__, $sql);
}
$sql = "DELETE FROM " . TOPICS_TABLE . "
WHERE topic_id = $topic_id_list[$i]";
if ( !($result = $db->sql_query($sql, BEGIN_TRANSACTION)) )
{
message_die(GENERAL_ERROR, 'Could not update posts', '', __LINE__, __FILE__, $sql);
}
$sql = "DELETE FROM " . TOPICS_WATCH_TABLE . "
WHERE topic_id = $topic_id_list[$i]";
if ( !($result = $db->sql_query($sql, BEGIN_TRANSACTION)) )
{
message_die(GENERAL_ERROR, 'Could not update posts', '', __LINE__, __FILE__, $sql);
}
// Sync the forum indexes
sync('forum', $forum_id);
sync('topic', $new_topic_id);
$message = $lang['Topics_Moved'] . '<br /><br />';
}
else
{
$message = $lang['No_Topics_Moved'] . '<br /><br />';
}
}
if ( !empty($topic_id) )
{
$redirect_page = append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id");
$message .= sprintf($lang['Click_return_topic'], '<a href="' . $redirect_page . '">', '</a>');
}
else
{
$redirect_page = append_sid("modcp.$phpEx?" . POST_FORUM_URL . "=$forum_id");
$message .= sprintf($lang['Click_return_modcp'], '<a href="' . $redirect_page . '">', '</a>');
}
$message = $message . '<br \><br \>' . sprintf($lang['Click_return_forum'], '<a href="' . append_sid("viewforum.$phpEx?" . POST_FORUM_URL . "=$old_forum_id") . '">', '</a>');
$template->assign_vars(array(
'META' => '<meta http-equiv="refresh" content="3;url=' . $redirect_page . '">')
);
message_die(GENERAL_MESSAGE, $message);
}
else
{
if ( empty($HTTP_POST_VARS['topic_id_list']) && empty($topic_id) )
{
message_die(GENERAL_MESSAGE, $lang['None_selected']);
}
$hidden_fields = '<input type="hidden" name="mode" value="' . $mode . '" /><input type="hidden" name="' . POST_FORUM_URL . '" value="' . $forum_id . '" />';
if ( isset($HTTP_POST_VARS['topic_id_list']) )
{
$topics = $HTTP_POST_VARS['topic_id_list'];
for($i = 0; $i < count($topics); $i++)
{
$hidden_fields .= '<input type="hidden" name="topic_id_list[]" value="' . intval($topics[$i]) . '" />';
}
}
else
{
$hidden_fields .= '<input type="hidden" name="' . POST_TOPIC_URL . '" value="' . $topic_id . '" />';
}
//
// Set template files
//
$template->set_filenames(array(
'mergetopic' => 'modcp_merge.tpl')
);
$template->assign_vars(array(
'MESSAGE_TITLE' => $lang['Confirm'],
'MESSAGE_TEXT' => $lang['Confirm_move_topic'],
'L_MERGE_TOPIC' => $lang['Merge_topic'],
'L_YES' => $lang['Yes'],
'L_NO' => $lang['No'],
'S_TOPIC_SELECT' => make_topic_select('new_topic', $forum_id),
'S_MODCP_ACTION' => append_sid("modcp.$phpEx"),
'S_HIDDEN_FIELDS' => $hidden_fields)
);
$template->pparse('mergetopic');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
}
break;
#
#-----[ FIND ]----------------------------------
#
'L_UNLOCK' => $lang['Unlock'],
#
#-----[ AFTER, ADD ]------------------------------------------
#
'L_MERGE' => $lang['Merge'],
#
#-----[ CLOSE ]----------------------------------
#
#
#-----[ OPEN language/lang_xxx/lang_main.php ]-------------------
#
#
#-----[ FIND ]----------------------------------
#
$lang['Unlock'] = "Unlock";
#
#-----[ AFTER, ADD ]------------------------------------------
#
$lang['Merge'] = "Merge";
$lang['Merge_topic'] = "Merge to topic";
#
#-----[ CLOSE ]----------------------------------
#
#
#-----[ OPEN templates/xxx/modcp_body.tpl ]-------------------
#
#
#-----[ FIND ]----------------------------------
#
<input type="submit" name="unlock" class="liteoption" value="{L_UNLOCK}" />
#
#-----[ AFTER, ADD ]------------------------------------------
#
<input type="submit" name="merge" class="liteoption" value="{L_MERGE}" />
#
#-----[ CLOSE ]----------------------------------
#
#
#-----------------------------------------------
#
http://forum.tvbdramas.net/modcp.php
PS: This forum is not owned by forumscity now
