Слияние кода завершено, страница обновится автоматически
<?php
/**
* @package phpBB-WAP
* @copyright (c) phpBB Group
* @Оптимизация под WAP: Гутник Игорь ( чел ).
* @简体中文：中文phpBB-WAP团队
* @license http://opensource.org/licenses/gpl-license.php
**/
/**
* 这是一款自由软件, 您可以在 Free Software Foundation 发布的
* GNU General Public License 的条款下重新发布或修改; 您可以
* 选择目前 version 2 这个版本（亦可以选择任何更新的版本，由
* 你喜欢）作为新的牌照.
**/
define('IN_PHPBB', true);
define('ROOT_PATH', './');
include(ROOT_PATH . 'common.php');
$userdata = $session->start($user_ip, PAGE_CLASS);
init_userprefs($userdata);
$mode = get_var('mode', '');
$forum_id = get_var(POST_FORUM_URL, 0);
if ( !empty($forum_id) )
{
$sql = "SELECT *
FROM " . FORUMS_TABLE . "
WHERE forum_id = $forum_id";
if ( !($result = $db->sql_query($sql)) )
{
trigger_error('无法获取论坛的信息', E_USER_WARNING);
}
}
else
{
trigger_error('论坛不存在', E_USER_ERROR);
}
if ( !($forum_row = $db->sql_fetchrow($result)) )
{
trigger_error('论坛不存在', E_USER_ERROR);
}
$is_auth = array();
$is_auth = auth(AUTH_ALL, $forum_id, $userdata, $forum_row);
if ( !$is_auth['auth_read'] || !$is_auth['auth_view'] )
{
if ( !$userdata['session_logged_in'] )
{
$redirect = POST_FORUM_URL . "=$forum_id" . ( ( isset($start) ) ? "&start=$start" : '' );
login_back("viewclass.php?$redirect");
}
$message = ( !$is_auth['auth_view'] ) ? '论坛不存在' : '对不起，仅 ' . $is_auth['auth_read_type'] . ' 可以阅读主题';
trigger_error($message, E_USER_ERROR);
}
if ( $is_auth['auth_mod'] && $board_config['prune_enable'] )
{
if ( $forum_row['prune_next'] < time() && $forum_row['prune_enable'] )
{
require(ROOT_PATH . 'includes/functions/prune.php');
require(ROOT_PATH . 'includes/functions/admin.php');
auto_prune($forum_id);
}
}
switch ($mode)
{
// 设置专题
case 'select':
if (!$is_auth['auth_mod'])
{
trigger_error('您没有权限设置专题', E_USER_ERROR);
}
$topic_id = get_var(POST_TOPIC_URL, 0);
$topic_class = get_var(POST_CLASS_URL, 0);
if ($topic_class != TOPIC_UNCLASS)
{
$sql = "SELECT class_id
FROM " . CLASS_TABLE . "
WHERE class_id = $topic_class
AND class_forum = $forum_id";
if (!$result = $db->sql_query($sql))
{
trigger_error('无法获取专题信息', E_USER_WARNING);
}
if (!$db->sql_numrows($result))
{
trigger_error('不存在的专题', E_USER_ERROR);
}
}
$sql = 'SELECT topic_id
FROM ' . TOPICS_TABLE . "
WHERE topic_id = $topic_id
AND forum_id = $forum_id";
if (!$result = $db->sql_query($sql))
{
trigger_error('无法获取帖子信息', E_USER_WARNING);
}
if (!$db->sql_numrows($result))
{
trigger_error('不存在该帖子', E_USER_ERROR);
}
$sql = "UPDATE " . TOPICS_TABLE . "
SET topic_class = $topic_class
WHERE topic_id = $topic_id";
if (!$db->sql_query($sql))
{
trigger_error('无法设置专题', E_USER_WARNING);
}
redirect(append_sid('viewtopic.php?' . POST_TOPIC_URL . '=' . $topic_id));
break;
// 创建专题
case 'create':
if (!$is_auth['auth_mod'])
{
trigger_error('您没有权限创建专题', E_USER_ERROR);
}
if(isset($_POST['classname']))
{
$classname = get_var('classname', '');
if (empty($classname))
{
trigger_error('专题名称必须填写', E_USER_ERROR);
}
$sql = 'INSERT INTO ' . CLASS_TABLE . " (class_name, class_forum)
VALUES ('" . $db->sql_escape($classname) . "', $forum_id)";
if ( $db->sql_query($sql) )
{
redirect(append_sid('viewclass.php?mode=list&' . POST_FORUM_URL . '=' . $forum_id));
}
else
{
trigger_error('无法创建专题', E_USER_WARNING);
}
}
redirect(append_sid('viewclass.php?mode=list&' . POST_FORUM_URL . '=' . $forum_id));
break;
// 修改专题
case 'edit':
if (!$is_auth['auth_mod'])
{
trigger_error('你没有权限管理', E_USER_ERROR);
}
$class_id = get_var(POST_CLASS_URL, 0);
if (!$class_id)
{
trigger_error('没有指定专题', E_USER_ERROR);
}
$sql = 'SELECT class_name
FROM ' . CLASS_TABLE . '
WHERE class_id = ' . $class_id;
if ( !$result = $db->sql_query($sql) )
{
trigger_error('无法获取专题信息', E_USER_WARNING);
}
if ( !($class_data = $db->sql_fetchrow($result)) )
{
trigger_error('专题不存在', E_USER_ERROR);
}
if (isset($_POST['classname']))
{
$classname = get_var('classname', '');
if (empty($classname))
{
trigger_error('专题名称不能为空', E_USER_ERROR);
}
$sql = "UPDATE " . CLASS_TABLE . "
SET class_name = '" . $db->sql_escape($classname) . "'
WHERE class_id = $class_id";
if ( $db->sql_query($sql) )
{
redirect(append_sid('viewclass.php?mode=list&' . POST_FORUM_URL . '=' . $forum_id));
}
else
{
trigger_error('无法修改专题信息', E_USER_WARNING);
}
}
$page_title = $class_data['class_name'] . '_修改专题';
page_header($page_title);
page_jump();
$template->set_filenames(array(
'edit' => 'class/class_edit.tpl')
);
$template->assign_vars(array(
'CLASS_NAME' => $class_data['class_name'],
'FORUM_NAME' => $forum_row['forum_name'],
'U_VIEW_FORUM' => append_sid("viewforum.php?" . POST_FORUM_URL ."=$forum_id"),
'U_FORUM' => append_sid('forum.php'),
'U_CLASS' => append_sid('viewclass.php?mode=list&' . POST_FORUM_URL . '=' . $forum_id),
'S_CLASS_ACTION' => append_sid('viewclass.php?mode=edit&' . POST_FORUM_URL . '=' . $forum_id . '&' . POST_CLASS_URL . '=' . $class_id))
);
$template->pparse('edit');
page_footer();
break;
// 删除专题
case 'delete':
if (!$is_auth['auth_mod'])
{
trigger_error('你没有权限删除专题', E_USER_ERROR);
}
$delete_id = get_var(POST_CLASS_URL, 0);
if (!$delete_id)
{
trigger_error('没有指定要删除的专题', E_USER_ERROR);
}
if ( isset($_POST['cancel']) )
{
redirect(append_sid('viewclass.php?mode=list&' . POST_FORUM_URL . '=' . $forum_id, true));
}
$confirm = ( isset($_POST['confirm']) ) ? ( ( $_POST['confirm'] ) ? true : false ) : false;
if( !$confirm )
{
$page_title = '删除专题';
page_header($page_title);
$template->set_filenames(array(
'confirm' => 'confirm_body.tpl')
);
$template->assign_vars(array(
'MESSAGE_TITLE' => '删除',
'MESSAGE_TEXT' => '请确认是否删除该专题',
'L_YES' => '是',
'L_NO' => '否',
'S_CONFIRM_ACTION' => append_sid('viewclass.php?mode=delete&' . POST_FORUM_URL . '=' . $forum_id . '&' . POST_CLASS_URL . '=' . $delete_id))
);
$template->pparse('confirm');
page_footer();
}
$sql = 'DELETE FROM ' . CLASS_TABLE . '
WHERE class_id = ' . $delete_id;
if ( !$db->sql_query($sql) )
{
trigger_error('无法删除专题数据', E_USER_WARNING);
}
redirect(append_sid('viewclass.php?mode=list&' . POST_FORUM_URL . '=' . $forum_id, true));
break;
// 显示专题列表
case 'list':
$page_title = '专题列表';
page_header($page_title);
page_jump();
// 分页管理
$per = $board_config['topics_per_page'];
$start = get_pagination_start($per);
// 找出此论坛的专题
$sql = "SELECT SQL_CALC_FOUND_ROWS class_id, class_name, class_forum
FROM " . CLASS_TABLE . "
WHERE class_forum = $forum_id
LIMIT $start, $per";
if ( !$result = $db->sql_query($sql) )
{
trigger_error('无法获取专题信息', E_USER_WARNING);
}
// 取得专题信息
$classdata = $db->sql_fetchrowset($result);
$template->set_filenames(array(
'body' => 'class/class_list.tpl')
);
$total_class = count($classdata);
for ($i=0; $i < $total_class; $i++)
{
$row_class = (($i % 2) == 0) ? 'row1' : 'row2';
$template->assign_block_vars('class_list', array(
'NUMBER' => $i + $start + 1,
'ROW_CLASS' => $row_class,
'CLASS_NAME' => $classdata[$i]['class_name'],
'U_CLASS' => append_sid('viewclass.php?' . POST_FORUM_URL . '=' . $forum_id . '&' . POST_CLASS_URL . '=' . $classdata[$i]['class_id']))
);
if ($is_auth['auth_mod'])
{
$template->assign_block_vars('class_list.is_mod', array(
'U_EDIT_CLASS' => append_sid('viewclass.php?mode=edit&' . POST_FORUM_URL . '=' . $forum_id . '&' . POST_CLASS_URL . '=' . $classdata[$i]['class_id']),
'U_DELETE_CLASS' => append_sid('viewclass.php?mode=delete&' . POST_FORUM_URL . '=' . $forum_id . '&' . POST_CLASS_URL . '=' . $classdata[$i]['class_id']))
);
}
}
if (!$db->sql_numrows($result))
{
$template->assign_block_vars('not_class', array());
}
$sql = "SELECT found_rows() AS classrow";
if ( !$result = $db->sql_query($sql) )
{
trigger_error('无法查询专题信息！', E_USER_WARNING);
}
if ( !$class = $db->sql_fetchrow($result) )
{
trigger_error('无法取得专题数据', E_USER_ERROR);
}
$class_count = $class['classrow'];
if ($is_auth['auth_mod'])
{
$template->assign_block_vars('create_class', array());
}
$template->assign_vars(array(
'FORUM_NAME' => $forum_row['forum_name'],
'U_VIEW_FORUM' => append_sid("viewforum.php?" . POST_FORUM_URL ."=$forum_id"),
'U_FORUM' => append_sid('forum.php'),
'S_CREATE_ACTION' => append_sid('viewclass.php?mode=create&' . POST_FORUM_URL . '=' . $forum_id),
'PAGINATION' => generate_pagination("viewclass.php?mode=list&" . POST_FORUM_URL . "=$forum_id", $class_count, $per, $start))
);
$template->pparse('body');
page_footer();
break;
// 显示专题帖子
default:
$class_id = get_var(POST_CLASS_URL, 0);
if (!$class_id)
{
trigger_error('没有指定专题', E_USER_ERROR);
}
$per = $board_config['topics_per_page'];
$start = get_pagination_start($per);
$sql = "SELECT SQL_CALC_FOUND_ROWS t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time
FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
WHERE t.forum_id = $forum_id
AND t.topic_poster = u.user_id
AND p.post_id = t.topic_first_post_id
AND p2.post_id = t.topic_last_post_id
AND u2.user_id = p2.poster_id
AND topic_class = $class_id
ORDER BY t.topic_type DESC, t.topic_last_post_id DESC
LIMIT $start, $per";
if ( !($result = $db->sql_query($sql)) )
{
trigger_error('无法获取专题帖子信息', E_USER_WARNING);
}
$orig_word = array();
$replacement_word = array();
obtain_word_list($orig_word, $replacement_word);
if ($total_topics = $db->sql_numrows($result))
{
$i = 0;
while( $topic_class = $db->sql_fetchrow($result) )
{
// 主题标题
$topic_title = ( count($orig_word) ) ? str_replace($orig_word, $replacement_word, $topic_class['topic_title']) : $topic_class['topic_title'];
$topic_type = $topic_class['topic_type'];
$views = $topic_class['topic_views'];
$replies = $topic_class['topic_replies'];
// 公告帖子
if( $topic_type == POST_ANNOUNCE )
{
$topic_type = make_style_image('topic_announcement');
}
// 置顶帖子
else if( $topic_type == POST_STICKY )
{
$topic_type = make_style_image('topic_sticky', '置顶帖子', '【顶】');
}
// 普通贴子
else
{
$topic_type = '';
}
// 投票
if( $topic_class['topic_vote'] )
{
$topic_type = make_style_image('topic_poll', '投票帖子', '【投】');
}
// 从其他论坛移动过来的帖子
if( $topic_class['topic_status'] == TOPIC_MOVED )
{
$topic_type = make_style_image('topic_move', '移动过来的帖子', '【移】');
$topic_id = $topic_class['topic_moved_id'];
}
// 附件图标
if (intval($topic_class['topic_attachment']) == 0 || (!($is_auth['auth_download'] && $is_auth['auth_view'])) || intval($board_config['disable_mod']) || $board_config['topic_icon'] == '')
{
$attachment_image = '';
}
else
{
$attachment_image = '<img src="' . $board_config['topic_icon'] . '" alt="附" title="带有附件的帖子"/>';
}
$topic_id = $topic_class['topic_id'];
$row_class = (($i % 2) == 0) ? 'row1' : 'row2';
$view_topic_url = append_sid("viewtopic.php?" . POST_TOPIC_URL . "=$topic_id");
$last_post_author = ( $topic_class['id2'] == ANONYMOUS ) ? ( ($topic_class['post_username2'] != '' ) ? $topic_class['post_username2'] . ' ' : '匿名用户' . ' ' ) : $topic_class['user2'] ;
$s_last_post = '<a href="' . append_sid("viewtopic.php?" . POST_POST_URL . '=' . $topic_class['topic_last_post_id']) . '#' . $topic_class['topic_last_post_id'] . '">»</a>';
$nomer_posta = $i + $start + 1;
$template->assign_block_vars('topicrow', array(
'ROW_CLASS' => $row_class,
'TOPIC_TITLE' => $topic_title,
'TOPIC_TYPE' => $topic_type,
'REPLIES' => $replies,
'VIEWS' => $views,
'TOPIC_ATTACHMENT_IMG' => $attachment_image,
'NOMER_POSTA' => $nomer_posta,
'LAST_POST_AUTHOR' => $last_post_author,
'S_LAST_POST' => $s_last_post,
'U_VIEW_TOPIC' => $view_topic_url)
);
$i++;
}
}
else
{
$template->assign_block_vars('switch_no_topics', array() );
}
$db->sql_freeresult($result);
$orig_word = array();
$replacement_word = array();
obtain_word_list($orig_word, $replacement_word);
$page_title = $forum_row['forum_name'] . '的精华帖子';
page_header($page_title);
page_jump();
$template->set_filenames(array(
'body' => 'class/viewclass_body.tpl')
);
// 计算出查询的记录总数
$sql = 'SELECT found_rows() AS rowcount';
if ( !$result = $db->sql_query($sql) )
{
trigger_error('无法统计在线用户！', E_USER_WARNING);
}
$total_class = $db->sql_fetchrow($result);
$total_all_class = $total_class['rowcount'];
$template->assign_vars(array(
'FORUM_NAME' => $forum_row['forum_name'],
'U_VIEW_FORUM' => append_sid("viewforum.php?" . POST_FORUM_URL ."=$forum_id"),
'U_FORUM' => append_sid('forum.php'),
'U_CLASS' => append_sid('viewclass.php?mode=list&' . POST_FORUM_URL . '=' . $forum_id),
'PAGINATION' => generate_pagination("viewclass.php?" . POST_FORUM_URL . "=$forum_id&&" . POST_CLASS_URL . "=$class_id&", $total_all_class, $board_config['topics_per_page'], $start))
);
$template->pparse('body');
page_footer();
break;
}
?>
Вы можете оставить комментарий после Вход в систему
Неприемлемый контент может быть отображен здесь и не будет показан на странице. Вы можете проверить и изменить его с помощью соответствующей функции редактирования.
Если вы подтверждаете, что содержание не содержит непристойной лексики/перенаправления на рекламу/насилия/вульгарной порнографии/нарушений/пиратства/ложного/незначительного или незаконного контента, связанного с национальными законами и предписаниями, вы можете нажать «Отправить» для подачи апелляции, и мы обработаем ее как можно скорее.
Опубликовать ( 0 )