phpBB.de

Code: Alles auswählen

######################################################## 
## 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 ]----------------------------------
# 
&nbsp; 
		<input type="submit" name="unlock" class="liteoption" value="{L_UNLOCK}" />
# 
#-----[ AFTER, ADD ]------------------------------------------ 
#
&nbsp; 
		<input type="submit" name="merge" class="liteoption" value="{L_MERGE}" />
# 
#-----[ CLOSE ]----------------------------------
# 

# 
#----------------------------------------------- 
#