コード例 #1
0
            break;
        default:
            $query = $db->simple_select("threads", "COUNT(tid) as threads", "fid = '{$fid}' AND (lastpost >= '" . intval($thread['lastpost']) . "'{$stickybit}) {$visibleonly} {$uid_only}", array('order_by' => 'lastpost', 'order_dir' => 'desc'));
    }
    $thread_position = $db->fetch_field($query, "threads");
    $thread_page = ceil($thread_position / $mybb->settings['threadsperpage']);
    $breadcrumb_multipage = array("num_threads" => $threadcount, "current_page" => $thread_page);
}
// Build the navigation.
build_forum_breadcrumb($fid, $breadcrumb_multipage);
add_breadcrumb($thread['displayprefix'] . $thread['subject'], get_thread_link($thread['tid']));
$plugins->run_hooks("showthread_start");
// Show the entire thread (taking into account pagination).
if ($mybb->input['action'] == "thread") {
    if ($thread['firstpost'] == 0) {
        update_first_post($tid);
    }
    // Does this thread have a poll?
    if ($thread['poll']) {
        $options = array("limit" => 1);
        $query = $db->simple_select("polls", "*", "pid='" . $thread['poll'] . "'", $options);
        $poll = $db->fetch_array($query);
        $poll['timeout'] = $poll['timeout'] * 60 * 60 * 24;
        $expiretime = $poll['dateline'] + $poll['timeout'];
        $now = TIME_NOW;
        // If the poll or the thread is closed or if the poll is expired, show the results.
        if ($poll['closed'] == 1 || $thread['closed'] == 1 || $expiretime < $now && $poll['timeout'] > 0) {
            $showresults = 1;
        }
        // If the user is not a guest, check if he already voted.
        if ($mybb->user['uid'] != 0) {
コード例 #2
0
ファイル: upgrade5.php プロジェクト: Nidrax/ppm-1.6
function upgrade5_lastposts()
{
    global $db, $output;
    $output->print_header("Przebudowywanie informacji o ostatnich postach");
    if (!$_POST['tpp']) {
        echo "<p>Nastęnym krokiem w aktualizacji jest przebudowanie informacji o ostatnim poście w każdym wątku na Twoim forum. Wpisz w poniższe pole ilość wpisów, które mają zostać przetworzone na stronę.</p>";
        echo "<p><strong>Wpisów na stronę:</strong> <input type=\"text\" size=\"3\" value=\"200\" name=\"tpp\" /></p>";
        echo "<p>Jeżeli wszystko gotowe, naciśnij przycisk Dalej, aby rozpocząć proces przebudowy.</p>";
        $output->print_footer("5_lastposts");
    } else {
        require_once MYBB_ROOT . "inc/functions_rebuild.php";
        $query = $db->simple_select("threads", "COUNT(*) as num_threads", "closed NOT LIKE 'moved|%'");
        $num_threads = $db->fetch_field($query, 'num_threads');
        $tpp = intval($_POST['tpp']);
        $start = intval($_POST['start']);
        $end = $start + $tpp;
        if ($end > $num_threads) {
            $end = $num_threads;
        }
        echo "<p>Aktualizacja {$start} do {$end} z {$num_threads}...</p>";
        $query = $db->simple_select("threads", "tid, firstpost", "closed NOT LIKE 'moved|%'", array("order_by" => "tid", "order_dir" => "asc", "limit" => $tpp, "limit_start" => $start));
        while ($thread = $db->fetch_array($query)) {
            rebuild_thread_counters($thread['tid']);
            if ($thread['firstpost'] == 0) {
                update_first_post($thread['tid']);
            }
        }
        echo "<p>Zakończono</p>";
        if ($end >= $num_threads) {
            echo "<p>Proces przebudowy został pomyślnie zakończony. Naciśnij przycisk Dalej, aby kontynuować proces aktualizacji.";
            $output->print_footer("5_forumlastposts");
        } else {
            echo "<p>Naciśnij przycisk Dalej, aby kontynuować proces przebudowy.</p>";
            echo "<input type=\"hidden\" name=\"tpp\" value=\"{$tpp}\" />";
            echo "<input type=\"hidden\" name=\"start\" value=\"{$end}\" />";
            $output->print_footer("5_lastposts");
        }
    }
}
コード例 #3
0
ファイル: upgrade5.php プロジェクト: GeorgeLVP/mybb
function upgrade5_lastposts()
{
    global $db, $output;
    $output->print_header("Rebuilding Last Post Columns");
    if (!$_POST['tpp']) {
        echo "<p>The next step in the upgrade process involves rebuilding the last post information for every thread in your forum. Below, please enter the number of threads to process per page.</p>";
        echo "<p><strong>Threads Per Page:</strong> <input type=\"text\" size=\"3\" value=\"200\" name=\"tpp\" /></p>";
        echo "<p>Once you're ready, press next to begin the rebuild process.</p>";
        $output->print_footer("5_lastposts");
    } else {
        require_once MYBB_ROOT . "inc/functions_rebuild.php";
        $query = $db->simple_select("threads", "COUNT(*) as num_threads", "closed NOT LIKE 'moved|%'");
        $num_threads = $db->fetch_field($query, 'num_threads');
        $tpp = intval($_POST['tpp']);
        $start = intval($_POST['start']);
        $end = $start + $tpp;
        if ($end > $num_threads) {
            $end = $num_threads;
        }
        echo "<p>Updating {$start} to {$end} of {$num_threads}...</p>";
        $query = $db->simple_select("threads", "tid, firstpost", "closed NOT LIKE 'moved|%'", array("order_by" => "tid", "order_dir" => "asc", "limit" => $tpp, "limit_start" => $start));
        while ($thread = $db->fetch_array($query)) {
            rebuild_thread_counters($thread['tid']);
            if ($thread['firstpost'] == 0) {
                update_first_post($thread['tid']);
            }
        }
        echo "<p>Done</p>";
        if ($end >= $num_threads) {
            echo "<p>The rebuild process has completed successfully. Click next to continue with the upgrade.";
            $output->print_footer("5_forumlastposts");
        } else {
            echo "<p>Click Next to continue with the build process.</p>";
            echo "<input type=\"hidden\" name=\"tpp\" value=\"{$tpp}\" />";
            echo "<input type=\"hidden\" name=\"start\" value=\"{$end}\" />";
            $output->print_footer("5_lastposts");
        }
    }
}
コード例 #4
0
ファイル: get_thread.php プロジェクト: dthiago/tapatalk-mybb
function get_thread_func($xmlrpc_params)
{
    global $db, $lang, $mybb, $position, $plugins, $pids;
    global $pforumcache, $currentitem, $forum_cache, $navbits, $base_url, $archiveurl;
    $input = Tapatalk_Input::filterXmlInput(array('topic_id' => Tapatalk_Input::STRING, 'start_num' => Tapatalk_Input::INT, 'last_num' => Tapatalk_Input::INT, 'return_html' => Tapatalk_Input::INT), $xmlrpc_params);
    if (preg_match('/^ann_/', $input['topic_id'])) {
        $_GET["aid"] = intval(str_replace('ann_', '', $input['topic_id']));
        return get_announcement_func($xmlrpc_params);
    }
    $lang->load("showthread");
    global $parser;
    $parser = new Tapatalk_Parser();
    // Get the thread details from the database.
    $thread = get_thread($input['topic_id']);
    if (!empty($thread['closed'])) {
        $moved = explode("|", $thread['closed']);
        if ($moved[0] == "moved") {
            $thread = get_thread($moved[1]);
        }
    }
    // Get thread prefix if there is one.
    $thread['threadprefix'] = '';
    $thread['displayprefix'] = '';
    if ($thread['prefix'] != 0) {
        $threadprefix = build_prefixes($thread['prefix']);
        if ($threadprefix['prefix']) {
            $thread['threadprefix'] = $threadprefix['prefix'] . '&nbsp;';
            $thread['displayprefix'] = $threadprefix['displaystyle'] . '&nbsp;';
        }
    }
    $thread['subject'] = $parser->parse_badwords($thread['subject']);
    $tid = $thread['tid'];
    $fid = $thread['fid'];
    if (!$thread['username']) {
        $thread['username'] = $lang->guest;
    }
    $visibleonly = "AND visible='1'";
    // Is the currently logged in user a moderator of this forum?
    if (is_moderator($fid)) {
        $visibleonly = " AND (visible='1' OR visible='0')";
        $ismod = true;
    } else {
        $ismod = false;
    }
    $forumpermissions = forum_permissions($thread['fid']);
    // Does the user have permission to view this thread?
    if ($forumpermissions['canview'] != 1 || $forumpermissions['canviewthreads'] != 1) {
        error_no_permission();
    }
    if ($forumpermissions['canonlyviewownthreads'] == 1 && $thread['uid'] != $mybb->user['uid']) {
        error_no_permission();
    }
    // Make sure we are looking at a real thread here.
    if (!$thread['tid'] || $thread['visible'] == 0 && $ismod == false || $thread['visible'] > 1 && $ismod == true) {
        return xmlrespfalse($lang->error_invalidthread);
    }
    // Does the thread belong to a valid forum?
    $forum = get_forum($fid);
    if (!$forum || $forum['type'] != "f") {
        return xmlrespfalse($lang->error_invalidforum);
    }
    tt_check_forum_password($forum['fid']);
    if ($thread['firstpost'] == 0) {
        update_first_post($tid);
    }
    // Mark this thread as read
    mark_thread_read($tid, $fid);
    // Increment the thread view.
    if ($mybb->settings['delayedthreadviews'] == 1) {
        $db->shutdown_query("INSERT INTO " . TABLE_PREFIX . "threadviews (tid) VALUES('{$tid}')");
    } else {
        $db->shutdown_query("UPDATE " . TABLE_PREFIX . "threads SET views=views+1 WHERE tid='{$tid}'");
    }
    ++$thread['views'];
    // Work out if we are showing unapproved posts as well (if the user is a moderator etc.)
    if ($ismod) {
        $visible = "AND (p.visible='0' OR p.visible='1')";
    } else {
        $visible = "AND p.visible='1'";
    }
    // Fetch the ignore list for the current user if they have one
    $ignored_users = array();
    if ($mybb->user['uid'] > 0 && $mybb->user['ignorelist'] != "") {
        $ignore_list = explode(',', $mybb->user['ignorelist']);
        foreach ($ignore_list as $uid) {
            $ignored_users[$uid] = 1;
        }
    }
    list($start, $limit) = process_page($input['start_num'], $input['last_num']);
    // Recount replies if user is a moderator to take into account unapproved posts.
    if ($ismod) {
        $query = $db->simple_select("posts p", "COUNT(*) AS replies", "p.tid='{$tid}' {$visible}");
        $thread['replies'] = $db->fetch_field($query, 'replies') - 1;
    }
    $postcount = intval($thread['replies']) + 1;
    $pids = "";
    $comma = '';
    $query = $db->simple_select("posts p", "p.pid", "p.tid='{$tid}' {$visible}", array('order_by' => 'p.dateline', 'limit_start' => $start, 'limit' => $limit));
    while ($getid = $db->fetch_array($query)) {
        // Set the ID of the first post on page to $pid if it doesn't hold any value
        // to allow this value to be used for Thread Mode/Linear Mode links
        // and ensure the user lands on the correct page after changing view mode
        if (!$pid) {
            $pid = $getid['pid'];
        }
        // Gather a comma separated list of post IDs
        $pids .= "{$comma}'{$getid['pid']}'";
        $comma = ",";
    }
    if ($pids) {
        $pids = "pid IN({$pids})";
        global $attachcache;
        $attachcache = array();
        if ($thread['attachmentcount'] > 0) {
            // Now lets fetch all of the attachments for these posts.
            $query = $db->simple_select("attachments", "*", $pids);
            while ($attachment = $db->fetch_array($query)) {
                $attachcache[$attachment['pid']][$attachment['aid']] = $attachment;
            }
        }
    } else {
        // If there are no pid's the thread is probably awaiting approval.
        return xmlrespfalse($lang->error_invalidthread);
    }
    $post_list = array();
    // Get the actual posts from the database here.
    $posts = '';
    $query = $db->query("\n        SELECT u.*, u.username AS userusername, p.*, f.*, eu.username AS editusername, IF(b.lifted > UNIX_TIMESTAMP() OR b.lifted = 0, 1, 0) as isbanned\n        FROM " . TABLE_PREFIX . "posts p\n        LEFT JOIN " . TABLE_PREFIX . "users u ON (u.uid=p.uid)\n        LEFT JOIN " . TABLE_PREFIX . "userfields f ON (f.ufid=u.uid)\n        LEFT JOIN " . TABLE_PREFIX . "users eu ON (eu.uid=p.edituid)\n        LEFT JOIN " . TABLE_PREFIX . "banned b ON (b.uid = p.uid)\n        WHERE {$pids}\n        ORDER BY p.dateline\n    ");
    //can_rename topic
    $can_rename = (is_moderator($fid, "caneditposts") || $forumpermissions['caneditposts'] == 1 && $mybb->user['uid'] == $thread['uid']) && $mybb->user['uid'] != 0;
    while ($post = $db->fetch_array($query)) {
        if ($thread['firstpost'] == $post['pid'] && $thread['visible'] == 0) {
            $post['visible'] = 0;
        }
        //$posts .= build_postbit($post);
        $parser_options = array();
        $parser_options['allow_html'] = false;
        $parser_options['allow_mycode'] = true;
        $parser_options['allow_smilies'] = false;
        $parser_options['allow_imgcode'] = true;
        $parser_options['allow_videocode'] = true;
        $parser_options['nl2br'] = (bool) $input['return_html'];
        $parser_options['filter_badwords'] = 1;
        if (!$post['username']) {
            $post['username'] = $lang->guest;
        }
        if ($post['userusername']) {
            $parser_options['me_username'] = $post['userusername'];
        } else {
            $parser_options['me_username'] = $post['username'];
        }
        $post['subject'] = $parser->parse_badwords($post['subject']);
        $post['author'] = $post['uid'];
        if ($post['userusername']) {
            // This post was made by a registered user
            $post['username'] = $post['userusername'];
        }
        // Eidt Option
        $can_edit = (is_moderator($fid, "caneditposts") || $forumpermissions['caneditposts'] == 1 && $mybb->user['uid'] == $post['uid']) && $mybb->user['uid'] != 0;
        // Quick Delete Option
        $can_delete = 0;
        if ($mybb->user['uid'] == $post['uid']) {
            if ($forumpermissions['candeletethreads'] == 1 && $postcounter == 1) {
                $can_delete = 1;
            } else {
                if ($forumpermissions['candeleteposts'] == 1 && $postcounter != 1) {
                    $can_delete = 1;
                }
            }
        }
        $can_delete = (is_moderator($fid, "candeleteposts") || $can_delete == 1) && $mybb->user['uid'] != 0;
        // User Online status
        $is_online = false;
        $timecut = TIME_NOW - $mybb->settings['wolcutoff'];
        if ($post['lastactive'] > $timecut && ($post['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1) && $post['lastvisit'] != $post['lastactive']) {
            $is_online = true;
        }
        $post['message'] = post_bbcode_clean($post['message']);
        $plugins->remove_hook('parse_message', 'mybbirckeditor_parser');
        // Post content and attachments
        $post['message'] = $parser->parse_message($post['message'], $parser_options);
        $attachment_list = process_post_attachments($post['pid'], $post);
        // add for thank/like support
        $post = $plugins->run_hooks("postbit", $post);
        if (is_array($ignored_users) && $post['uid'] != 0 && $ignored_users[$post['uid']] == 1) {
            $show_spoiler = "[spoiler]" . $post['message'] . "[/spoiler]";
            $post['message'] = $lang->sprintf($lang->postbit_currently_ignoring_user, $post['username']) . $show_spoiler;
        }
        $post_xmlrpc = array('post_id' => new xmlrpcval($post['pid'], 'string'), 'post_title' => new xmlrpcval(basic_clean($post['subject']), 'base64'), 'post_content' => new xmlrpcval(process_post($post['message'], $input['return_html']), 'base64'), 'post_author_id' => new xmlrpcval($post['uid'], 'string'), 'post_author_name' => new xmlrpcval(basic_clean($post['username']), 'base64'), 'icon_url' => new xmlrpcval(absolute_url($post['avatar']), 'string'), 'post_time' => new xmlrpcval(mobiquo_iso8601_encode($post['dateline']), 'dateTime.iso8601'), 'timestamp' => new xmlrpcval($post['dateline'], 'string'), 'attachments' => new xmlrpcval($attachment_list, 'array'));
        if (!$post['visible']) {
            $post_xmlrpc['is_approved'] = new xmlrpcval(false, 'boolean');
        }
        // default as true
        if ($post['smilieoff']) {
            $post_xmlrpc['allow_smilies'] = new xmlrpcval(false, 'boolean');
        }
        // default as true
        if ($post['isbanned']) {
            $post_xmlrpc['is_ban'] = new xmlrpcval(true, 'boolean');
        }
        if ($is_online) {
            $post_xmlrpc['is_online'] = new xmlrpcval(true, 'boolean');
        }
        if ($can_edit) {
            $post_xmlrpc['can_edit'] = new xmlrpcval(true, 'boolean');
        }
        if ($can_delete) {
            $post_xmlrpc['can_delete'] = new xmlrpcval(true, 'boolean');
        }
        if (is_moderator($fid, 'canmanagethreads')) {
            $post_xmlrpc['can_approve'] = new xmlrpcval(true, 'boolean');
        }
        if (is_moderator($fid, 'canmanagethreads')) {
            $post_xmlrpc['can_move'] = new xmlrpcval(true, 'boolean');
        }
        if ($mybb->usergroup['canmodcp'] == 1) {
            $post_xmlrpc['can_ban'] = new xmlrpcval(true, 'boolean');
        }
        if ($post['edituid']) {
            //add edit info
            $edit_info = array('editor_id' => new xmlrpcval($post['edituid'], 'string'), 'editor_name' => new xmlrpcval($post['editusername'], 'base64'), 'edit_time' => new xmlrpcval($post['edittime'], 'string'));
            if (!empty($post['editreason'])) {
                $edit_info['edit_reason'] = new xmlrpcval($post['editreason'], 'base64');
            }
            $post_xmlrpc = array_merge($post_xmlrpc, $edit_info);
        }
        // add for thank/like support
        if (isset($post['button_tyl']) && $mybb->user['uid']) {
            global $mobiquo_config, $g33k_pcache;
            $thlprefix = $mobiquo_config['thlprefix'];
            $tyled = false;
            $tyl_list = array();
            if ($mybb->settings[$thlprefix . 'enabled'] == "1") {
                if ($post['thankyoulike'] && isset($g33k_pcache[$post['pid']])) {
                    foreach ($g33k_pcache[$post['pid']] as $tyl) {
                        if ($tyl['uid'] == $mybb->user['uid']) {
                            $tyled = true;
                        }
                        $tyl_list[] = new xmlrpcval(array('userid' => new xmlrpcval($tyl['uid'], 'string'), 'username' => new xmlrpcval(basic_clean($tyl['username']), 'base64')), 'struct');
                    }
                }
                if ($mybb->settings[$thlprefix . 'thankslike'] == "like") {
                    if ($post['button_tyl']) {
                        $post_xmlrpc['can_like'] = new xmlrpcval(true, 'boolean');
                    }
                    if ($tyled) {
                        $post_xmlrpc['is_liked'] = new xmlrpcval(true, 'boolean');
                    }
                    if ($tyl_list) {
                        $post_xmlrpc['likes_info'] = new xmlrpcval($tyl_list, 'array');
                    }
                } else {
                    if ($mybb->settings[$thlprefix . 'thankslike'] == "thanks") {
                        if ($post['button_tyl']) {
                            $post_xmlrpc['can_thank'] = new xmlrpcval(true, 'boolean');
                        }
                        if ($mybb->settings[$thlprefix . 'removing'] == 1) {
                            $post_xmlrpc['can_remove_thank'] = new xmlrpcval(true, 'boolean');
                        }
                        if ($tyled) {
                            $post_xmlrpc['is_thanked'] = new xmlrpcval(true, 'boolean');
                        }
                        if ($tyl_list) {
                            $post_xmlrpc['thanks_info'] = new xmlrpcval($tyl_list, 'array');
                        }
                    }
                }
            }
        }
        $post_list[] = new xmlrpcval($post_xmlrpc, 'struct');
    }
    $query = $db->simple_select("threadsubscriptions", "tid", "tid='" . intval($tid) . "' AND uid='" . intval($mybb->user['uid']) . "'", array('limit' => 1));
    $subscribed = (bool) $db->fetch_field($query, 'tid');
    $query = $db->simple_select("banned", "uid", "uid='{$thread['uid']}'");
    $isbanned = !!$db->fetch_field($query, "uid");
    $can_reply = $forumpermissions['canpostreplys'] != 0 && $mybb->user['suspendposting'] != 1 && ($thread['closed'] != 1 || is_moderator($fid)) && $forum['open'] != 0;
    build_tt_breadcrumb($fid);
    $navgation_arr = $navbits;
    if (is_array($navgation_arr) && count($navgation_arr) > 1) {
        unset($navgation_arr[0]);
        foreach ($navgation_arr as $navigation) {
            $forum_id = $navigation['fid'];
            $sub_only = false;
            if ($navigation['type'] != 'f') {
                $sub_only = true;
            }
            $breadcrumb[] = new xmlrpcval(array('forum_id' => new xmlrpcval($forum_id, 'string'), 'forum_name' => new xmlrpcval($navigation['name'], 'base64'), 'sub_only' => new xmlrpcval($sub_only, 'boolean')), 'struct');
        }
    }
    $is_poll = !empty($thread['poll']) ? true : false;
    $result = array('total_post_num' => new xmlrpcval($postcount, 'int'), 'forum_id' => new xmlrpcval($thread['fid'], 'string'), 'forum_name' => new xmlrpcval(basic_clean($forum['name']), 'base64'), 'topic_id' => new xmlrpcval($thread['tid'], 'string'), 'topic_title' => new xmlrpcval(basic_clean($thread['subject']), 'base64'), 'can_upload' => new xmlrpcval($forumpermissions['canpostattachments'] != 0, 'boolean'), 'can_report' => new xmlrpcval(true, 'boolean'), 'can_reply' => new xmlrpcval($can_reply, 'boolean'), 'is_poll' => new xmlrpcval($is_poll, 'boolean'), 'view_number' => new xmlrpcval(intval($thread['views']), 'int'));
    if ($forumpermissions['canview'] == 0 || $forumpermissions['canviewthreads'] == 0) {
        $new_topic['can_subscribe'] = new xmlrpcval(false, 'boolean');
    } else {
        $new_topic['can_subscribe'] = new xmlrpcval(true, 'boolean');
    }
    if ($thread['prefix']) {
        $result['prefix'] = new xmlrpcval(basic_clean($thread['displayprefix']), 'base64');
    }
    if (!$thread['visible']) {
        $result['is_approved'] = new xmlrpcval(false, 'boolean');
    }
    // default as true
    if ($thread['closed']) {
        $result['is_closed'] = new xmlrpcval(true, 'boolean');
    }
    if ($thread['sticky']) {
        $result['is_sticky'] = new xmlrpcval(true, 'boolean');
    }
    if ($subscribed) {
        $result['is_subscribed'] = new xmlrpcval(true, 'boolean');
    } else {
        $result['is_subscribed'] = new xmlrpcval(false, 'boolean');
    }
    if ($isbanned) {
        $result['is_ban'] = new xmlrpcval(true, 'boolean');
    }
    if ($position) {
        $result['position'] = new xmlrpcval(intval($position), 'int');
    }
    if (is_moderator($fid, "canopenclosethreads")) {
        $result['can_close'] = new xmlrpcval(true, 'boolean');
    }
    if (is_moderator($fid, "candeleteposts")) {
        $result['can_delete'] = new xmlrpcval(true, 'boolean');
    }
    if (is_moderator($fid, "canmanagethreads")) {
        $result['can_stick'] = new xmlrpcval(true, 'boolean');
    }
    if (is_moderator($fid, "canmanagethreads")) {
        $result['can_move'] = new xmlrpcval(true, 'boolean');
        $result['can_merge'] = new xmlrpcval(true, 'boolean');
        $result['can_merge_post'] = new xmlrpcval(true, 'boolean');
    }
    if (is_moderator($fid, "canopenclosethreads")) {
        $result['can_approve'] = new xmlrpcval(true, 'boolean');
    }
    if ($can_rename) {
        $result['can_rename'] = new xmlrpcval(true, 'boolean');
    }
    if ($mybb->usergroup['canmodcp'] == 1) {
        $result['can_ban'] = new xmlrpcval(true, 'boolean');
    }
    if (!empty($breadcrumb)) {
        $result['breadcrumb'] = new xmlrpcval($breadcrumb, 'array');
    }
    $result['posts'] = new xmlrpcval($post_list, 'array');
    return new xmlrpcresp(new xmlrpcval($result, 'struct'));
}
コード例 #5
0
 /**
  * Split posts into a new/existing thread
  *
  * @param array $pids PIDs of posts to split
  * @param int $tid Original thread ID (this is only used as a base for the new
  * thread; it can be set to 0 when the posts specified are coming from more
  * than 1 thread)
  * @param int $moveto Destination forum
  * @param string $newsubject New thread subject
  * @param int $destination_tid TID if moving into existing thread
  * @return int|bool New thread ID or false on failure
  */
 function split_posts($pids, $tid, $moveto, $newsubject, $destination_tid = 0)
 {
     global $db, $thread, $plugins, $cache;
     $tid = (int) $tid;
     $moveto = (int) $moveto;
     $newtid = (int) $destination_tid;
     // Make sure we only have valid values
     $pids = array_map('intval', $pids);
     $pids_list = implode(',', $pids);
     // Get forum infos
     $forum_cache = $cache->read('forums');
     if (empty($pids) || !$forum_cache[$moveto]) {
         return false;
     }
     // Get the first split post
     $query = $db->simple_select('posts', 'pid,uid,visible,icon,username,dateline', 'pid IN (' . $pids_list . ')', array('order_by' => 'dateline', 'order_dir' => 'asc', 'limit' => 1));
     $post_info = $db->fetch_array($query);
     $visible = $post_info['visible'];
     $forum_counters[$moveto] = array('threads' => 0, 'deletedthreads' => 0, 'unapprovedthreads' => 0, 'posts' => 0, 'unapprovedposts' => 0, 'deletedposts' => 0);
     if ($destination_tid == 0) {
         // Splitting into a new thread
         // Create the new thread
         $newsubject = $db->escape_string($newsubject);
         $newthread = array("fid" => $moveto, "subject" => $newsubject, "icon" => (int) $post_info['icon'], "uid" => (int) $post_info['uid'], "username" => $db->escape_string($post_info['username']), "dateline" => (int) $post_info['dateline'], "firstpost" => $post_info['pid'], "lastpost" => 0, "lastposter" => '', "visible" => (int) $visible, "notes" => '');
         $newtid = $db->insert_query("threads", $newthread);
         if ($visible == 1) {
             ++$forum_counters[$moveto]['threads'];
             if (!isset($user_counters[$newthread['uid']])) {
                 $user_counters[$newthread['uid']] = array('postnum' => 0, 'threadnum' => 0);
             }
             // Subtract thread from old thread opener
             --$user_counters[$newthread['uid']]['threadnum'];
         } elseif ($visible == -1) {
             ++$forum_counters[$moveto]['deletedthreads'];
         } else {
             // Unapproved thread?
             ++$forum_counters[$moveto]['unapprovedthreads'];
         }
     } else {
         $newthread = get_thread($newtid);
         if (!$newthread) {
             return false;
         }
         $moveto = $newthread['fid'];
     }
     // Get selected posts before moving forums to keep old fid
     $original_posts_query = $db->query("\n\t\t\tSELECT p.pid, p.tid, p.fid, p.visible, p.uid, p.dateline, t.visible as threadvisible, t.firstpost, COUNT(a.aid) as postattachmentcount\n\t\t\tFROM " . TABLE_PREFIX . "posts p\n\t\t\tLEFT JOIN " . TABLE_PREFIX . "threads t ON (p.tid=t.tid)\n\t\t\tLEFT JOIN " . TABLE_PREFIX . "attachments a ON (a.pid=p.pid AND a.visible=1)\n\t\t\tWHERE p.pid IN ({$pids_list})\n\t\t\tGROUP BY p.pid\n\t\t");
     // Move the selected posts over
     $sqlarray = array("tid" => $newtid, "fid" => $moveto, "replyto" => 0);
     $db->update_query("posts", $sqlarray, "pid IN ({$pids_list})");
     $thread_counters[$newtid] = array('replies' => 0, 'unapprovedposts' => 0, 'deletedposts' => 0, 'attachmentcount' => 0);
     // Get posts being merged
     while ($post = $db->fetch_array($original_posts_query)) {
         if (!isset($thread_counters[$post['tid']])) {
             $thread_counters[$post['tid']] = array('replies' => 0, 'unapprovedposts' => 0, 'deletedposts' => 0, 'attachmentcount' => 0);
         }
         if (!isset($forum_counters[$post['fid']])) {
             $forum_counters[$post['fid']] = array('posts' => 0, 'unapprovedposts' => 0, 'deletedposts' => 0);
         }
         if (!isset($user_counters[$post['uid']])) {
             $user_counters[$post['uid']] = array('postnum' => 0, 'threadnum' => 0);
         }
         if ($post['visible'] == 1) {
             // Modify users' post counts
             if ($post['threadvisible'] == 1 && $forum_cache[$post['fid']]['usepostcounts'] == 1 && ($forum_cache[$moveto]['usepostcounts'] == 0 || $newthread['visible'] != 1)) {
                 // Moving into a forum that doesn't count post counts
                 --$user_counters[$post['uid']]['postnum'];
             }
             // Subtract 1 from the old thread's replies
             --$thread_counters[$post['tid']]['replies'];
         } elseif ($post['visible'] == 0) {
             // Unapproved post
             // Subtract 1 from the old thread's unapproved posts
             --$thread_counters[$post['tid']]['unapprovedposts'];
         } elseif ($post['visible'] == -1) {
             // Soft deleted post
             // Subtract 1 from the old thread's deleted posts
             --$thread_counters[$post['tid']]['deletedposts'];
         }
         // Subtract 1 from the old forum's posts
         if ($post['threadvisible'] == 1 && $post['visible'] == 1) {
             --$forum_counters[$post['fid']]['posts'];
         } elseif ($post['threadvisible'] == 0 || $post['visible'] == 0 && $post['threadvisible'] == 1) {
             --$forum_counters[$post['fid']]['unapprovedposts'];
         } else {
             --$forum_counters[$post['fid']]['deletedposts'];
         }
         // Subtract attachment counts from old thread and add to new thread (which are counted regardless of post or attachment unapproval at time of coding)
         $thread_counters[$post['tid']]['attachmentcount'] -= $post['postattachmentcount'];
         $thread_counters[$newtid]['attachmentcount'] += $post['postattachmentcount'];
         if ($post['firstpost'] == $post['pid']) {
             // In some cases the first post of a thread changes
             // Therefore resync the visible field to make sure they're the same if they're not
             $query = $db->simple_select("posts", "pid, visible, uid", "tid='{$post['tid']}'", array('order_by' => 'dateline', 'order_dir' => 'asc', 'limit' => 1));
             $new_firstpost = $db->fetch_array($query);
             if (!isset($user_counters[$new_firstpost['uid']])) {
                 $user_counters[$new_firstpost['uid']] = array('postnum' => 0, 'threadnum' => 0);
             }
             // Update post counters if visibility changes
             if ($post['threadvisible'] != $new_firstpost['visible']) {
                 $db->update_query("posts", array('visible' => $post['threadvisible']), "pid='{$new_firstpost['pid']}'");
                 // Subtract new first post
                 if ($new_firstpost['visible'] == 1) {
                     --$thread_counters[$post['tid']]['replies'];
                     if ($post['threadvisible'] == 1 && $forum_cache[$post['fid']]['usepostcounts'] == 1) {
                         --$user_counters[$new_firstpost['uid']]['postnum'];
                     }
                 } elseif ($new_firstpost['visible'] == -1) {
                     --$thread_counters[$post['tid']]['deletedposts'];
                 } else {
                     --$thread_counters[$post['tid']]['unapprovedposts'];
                 }
                 if ($post['threadvisible'] == 0 || $new_firstpost['visible'] == 0 && $post['threadvisible'] == 1) {
                     --$forum_counters[$post['fid']]['unapprovedposts'];
                 } else {
                     --$forum_counters[$post['fid']]['deletedposts'];
                 }
                 // Add old first post
                 if ($post['threadvisible'] == 1) {
                     ++$thread_counters[$post['tid']]['replies'];
                     ++$forum_counters[$post['fid']]['posts'];
                     if ($forum_cache[$post['fid']]['usepostcounts'] == 1) {
                         ++$user_counters[$new_firstpost['uid']]['postnum'];
                     }
                 } elseif ($post['threadvisible'] == -1) {
                     ++$thread_counters[$post['tid']]['deletedposts'];
                     ++$forum_counters[$post['fid']]['deletedposts'];
                 } else {
                     ++$thread_counters[$post['tid']]['unapprovedposts'];
                     ++$forum_counters[$post['fid']]['unapprovedposts'];
                 }
             }
             // Update user thread counter if thread opener changes
             if ($post['threadvisible'] == 1 && $forum_cache[$post['fid']]['usethreadcounts'] == 1 && $post['uid'] != $new_firstpost['uid']) {
                 // Subtract thread from old thread opener
                 --$user_counters[$post['uid']]['threadnum'];
                 // Add thread to new thread opener
                 ++$user_counters[$new_firstpost['uid']]['threadnum'];
             }
             update_first_post($post['tid']);
         }
         // This is the new first post of an existing thread?
         if ($post['pid'] == $post_info['pid'] && $post['dateline'] < $newthread['dateline']) {
             // Update post counters if visibility changes
             if ($post['visible'] != $newthread['visible']) {
                 $db->update_query("posts", array('visible' => $newthread['visible']), "pid='{$post['pid']}'");
                 // This is needed to update the forum counters correctly
                 $post['visible'] = $newthread['visible'];
             }
             // Update user thread counter if thread opener changes
             if ($newthread['visible'] == 1 && $forum_cache[$newthread['fid']]['usethreadcounts'] == 1 && $post['uid'] != $newthread['uid']) {
                 // Add thread to new thread opener
                 ++$user_counters[$post['uid']]['threadnum'];
                 if (!isset($user_counters[$newthread['uid']])) {
                     $user_counters[$newthread['uid']] = array('postnum' => 0, 'threadnum' => 0);
                 }
                 // Subtract thread from old thread opener
                 --$user_counters[$newthread['uid']]['threadnum'];
             }
             update_first_post($newtid);
         }
         if ($post['visible'] == 1) {
             // Modify users' post counts
             if ($newthread['visible'] == 1 && ($forum_cache[$post['fid']]['usepostcounts'] == 0 || $post['threadvisible'] != 1) && $forum_cache[$moveto]['usepostcounts'] == 1) {
                 // Moving into a forum that does count post counts
                 ++$user_counters[$post['uid']]['postnum'];
             }
             // Add 1 to the new thread's replies
             ++$thread_counters[$newtid]['replies'];
         } elseif ($post['visible'] == 0) {
             // Unapproved post
             // Add 1 to the new thread's unapproved posts
             ++$thread_counters[$newtid]['unapprovedposts'];
         } elseif ($post['visible'] == -1) {
             // Soft deleted post
             // Add 1 to the new thread's deleted posts
             ++$thread_counters[$newtid]['deletedposts'];
         }
         // Add 1 to the new forum's posts
         if ($newthread['visible'] == 1 && $post['visible'] == 1) {
             ++$forum_counters[$moveto]['posts'];
         } elseif ($newthread['visible'] == 0 || $post['visible'] == 0 && $newthread['visible'] == 1) {
             ++$forum_counters[$moveto]['unapprovedposts'];
         } else {
             ++$forum_counters[$moveto]['deletedposts'];
         }
     }
     if ($destination_tid == 0 && $newthread['visible'] == 1) {
         // If splitting into a new thread, subtract one from the thread's reply count to compensate for the original post
         --$thread_counters[$newtid]['replies'];
     } elseif ($destination_tid == 0 && $newthread['visible'] == 0) {
         // If splitting into a new thread, subtract one from the thread's reply count to compensate for the original post
         --$thread_counters[$newtid]['unapprovedposts'];
     } elseif ($destination_tid == 0 && $newthread['visible'] == -1) {
         // If splitting into a new thread, subtract one from the thread's reply count to compensate for the original post
         --$thread_counters[$newtid]['deletedposts'];
     }
     $arguments = array("pids" => $pids, "tid" => $tid, "moveto" => $moveto, "newsubject" => $newsubject, "destination_tid" => $destination_tid);
     $plugins->run_hooks("class_moderation_split_posts", $arguments);
     // Update user post counts
     if (!empty($user_counters)) {
         foreach ($user_counters as $uid => $counters) {
             foreach ($counters as $key => $counter) {
                 if ($counter >= 0) {
                     $counters[$key] = "+{$counter}";
                     // add the addition operator for query
                 }
             }
             update_user_counters($uid, $counters);
         }
     }
     // Update thread counters
     if (is_array($thread_counters)) {
         foreach ($thread_counters as $tid => $counters) {
             if ($tid == $newtid) {
                 // Update the subject of the first post in the new thread
                 $query = $db->simple_select("posts", "pid", "tid='{$newtid}'", array('order_by' => 'dateline', 'limit' => 1));
                 $newthread = $db->fetch_array($query);
                 $sqlarray = array("subject" => $newsubject, "replyto" => 0);
                 $db->update_query("posts", $sqlarray, "pid='{$newthread['pid']}'");
             } else {
                 // Update the subject of the first post in the old thread
                 $query = $db->query("\n\t\t\t\t\t\tSELECT p.pid, t.subject\n\t\t\t\t\t\tFROM " . TABLE_PREFIX . "posts p\n\t\t\t\t\t\tLEFT JOIN " . TABLE_PREFIX . "threads t ON (p.tid=t.tid)\n\t\t\t\t\t\tWHERE p.tid='{$tid}'\n\t\t\t\t\t\tORDER BY p.dateline ASC\n\t\t\t\t\t\tLIMIT 1\n\t\t\t\t\t");
                 $oldthread = $db->fetch_array($query);
                 $sqlarray = array("subject" => $db->escape_string($oldthread['subject']), "replyto" => 0);
                 $db->update_query("posts", $sqlarray, "pid='{$oldthread['pid']}'");
             }
             foreach ($counters as $key => $counter) {
                 if ($counter >= 0) {
                     $counters[$key] = "+{$counter}";
                 }
             }
             update_thread_counters($tid, $counters);
             update_last_post($tid);
         }
     }
     // Update forum counters
     if (!empty($forum_counters)) {
         foreach ($forum_counters as $fid => $counters) {
             foreach ($counters as $key => $counter) {
                 if ($counter >= 0) {
                     $counters[$key] = "+{$counter}";
                 }
             }
             update_forum_counters($fid, $counters);
             update_forum_lastpost($fid);
         }
     }
     return $newtid;
 }
コード例 #6
0
ファイル: class_moderation.php プロジェクト: GeorgeLVP/mybb
 /**
  * Split posts into a new/existing thread
  *
  * @param array PIDs of posts to split
  * @param int Original thread ID (this is only used as a base for the new
  * thread; it can be set to 0 when the posts specified are coming from more
  * than 1 thread)
  * @param int Destination forum
  * @param string New thread subject
  * @param int TID if moving into existing thread
  * @return int New thread ID
  */
 function split_posts($pids, $tid, $moveto, $newsubject, $destination_tid = 0)
 {
     global $db, $thread, $plugins;
     $tid = intval($tid);
     $moveto = intval($moveto);
     $newtid = intval($destination_tid);
     // Get forum infos
     $query = $db->simple_select("forums", "fid, usepostcounts, posts, threads, unapprovedposts, unapprovedthreads");
     while ($forum = $db->fetch_array($query)) {
         $forum_cache[$forum['fid']] = $forum;
     }
     // Make sure we only have valid values
     $pids = array_map('intval', $pids);
     $pids_list = implode(',', $pids);
     // Get the icon for the first split post
     $query = $db->simple_select("posts", "icon, visible", "pid=" . intval($pids[0]));
     $post_info = $db->fetch_array($query);
     $icon = $post_info['icon'];
     $visible = $post_info['visible'];
     if ($destination_tid == 0) {
         // Splitting into a new thread
         $thread = get_thread($tid);
         // Create the new thread
         $newsubject = $db->escape_string($newsubject);
         $query = array("fid" => $moveto, "subject" => $newsubject, "icon" => intval($icon), "uid" => intval($thread['uid']), "username" => $db->escape_string($thread['username']), "dateline" => intval($thread['dateline']), "lastpost" => intval($thread['lastpost']), "lastposter" => $db->escape_string($thread['lastposter']), "replies" => count($pids) - 1, "visible" => intval($visible), "notes" => '');
         $newtid = $db->insert_query("threads", $query);
         $forum_counters[$moveto]['threads'] = $forum_cache[$moveto]['threads'];
         $forum_counters[$moveto]['unapprovedthreads'] = $forum_cache[$moveto]['unapprovedthreads'];
         if ($visible) {
             ++$forum_counters[$moveto]['threads'];
         } else {
             // Unapproved thread?
             ++$forum_counters[$moveto]['unapprovedthreads'];
         }
     }
     // Get attachment counts for each post
     /*$query = $db->simple_select("attachments", "COUNT(aid) as count, pid", "pid IN ($pids_list)");
     		$query = $db->query("
     			SELECT COUNT(aid) as count, p.pid,
     			");
     		$attachment_sum = 0;
     		while($attachment = $db->fetch_array($query))
     		{
     			$attachments[$attachment['pid']] = $attachment['count'];
     			$attachment_sum += $attachment['count'];
     		}
     		$thread_counters[$newtid]['attachmentcount'] = '+'.$attachment_sum;*/
     // Get selected posts before moving forums to keep old fid
     //$original_posts_query = $db->simple_select("posts", "fid, visible, pid", "pid IN ($pids_list)");
     $original_posts_query = $db->query("\n\t\t\tSELECT p.pid, p.tid, p.fid, p.visible, p.uid, t.visible as threadvisible, t.replies as threadreplies, t.unapprovedposts as threadunapprovedposts, t.attachmentcount as threadattachmentcount, COUNT(a.aid) as postattachmentcount\n\t\t\tFROM " . TABLE_PREFIX . "posts p\n\t\t\tLEFT JOIN " . TABLE_PREFIX . "threads t ON (p.tid=t.tid)\n\t\t\tLEFT JOIN " . TABLE_PREFIX . "attachments a ON (a.pid=p.pid)\n\t\t\tWHERE p.pid IN ({$pids_list})\n\t\t\tGROUP BY p.pid, p.tid, p.fid, p.visible, p.uid, t.visible, t.replies, t.unapprovedposts,t.attachmentcount\n\t\t");
     // Move the selected posts over
     $sqlarray = array("tid" => $newtid, "fid" => $moveto, "replyto" => 0);
     $db->update_query("posts", $sqlarray, "pid IN ({$pids_list})");
     $db->update_query("reportedposts", array('tid' => $newtid), "pid IN ({$pids_list})");
     // Get posts being merged
     while ($post = $db->fetch_array($original_posts_query)) {
         if ($post['visible'] == 1) {
             // Modify users' post counts
             if ($forum_cache[$post['fid']]['usepostcounts'] == 1 && $forum_cache[$moveto]['usepostcounts'] == 0) {
                 // Moving into a forum that doesn't count post counts
                 if (!isset($user_counters[$post['uid']])) {
                     $user_counters[$post['uid']] = 0;
                 }
                 --$user_counters[$post['uid']];
             } elseif ($forum_cache[$post['fid']]['usepostcounts'] == 0 && $forum_cache[$moveto]['usepostcounts'] == 1) {
                 // Moving into a forum that does count post counts
                 if (!isset($user_counters[$post['uid']])) {
                     $user_counters[$post['uid']] = 0;
                 }
                 ++$user_counters[$post['uid']];
             }
             // Subtract 1 from the old thread's replies
             if (!isset($thread_counters[$post['tid']]['replies'])) {
                 $thread_counters[$post['tid']]['replies'] = $post['threadreplies'];
             }
             --$thread_counters[$post['tid']]['replies'];
             // Add 1 to the new thread's replies
             ++$thread_counters[$newtid]['replies'];
             if ($moveto != $post['fid']) {
                 // Only need to change forum info if the old forum is different from new forum
                 // Subtract 1 from the old forum's posts
                 if (!isset($forum_counters[$post['fid']]['posts'])) {
                     $forum_counters[$post['fid']]['posts'] = $forum_cache[$post['fid']]['posts'];
                 }
                 --$forum_counters[$post['fid']]['posts'];
                 // Add 1 to the new forum's posts
                 if (!isset($forum_counters[$moveto]['posts'])) {
                     $forum_counters[$moveto]['posts'] = $forum_cache[$moveto]['posts'];
                 }
                 ++$forum_counters[$moveto]['posts'];
             }
         } elseif ($post['visible'] == 0) {
             // Unapproved post
             // Subtract 1 from the old thread's unapproved posts
             if (!isset($thread_counters[$post['tid']]['unapprovedposts'])) {
                 $thread_counters[$post['tid']]['unapprovedposts'] = $post['threadunapprovedposts'];
             }
             --$thread_counters[$post['tid']]['unapprovedposts'];
             // Add 1 to the new thread's unapproved posts
             ++$thread_counters[$newtid]['unapprovedposts'];
             if ($moveto != $post['fid']) {
                 // Only need to change forum info if the old forum is different from new forum
                 // Subtract 1 from the old forum's unapproved posts
                 if (!isset($forum_counters[$post['fid']]['unapprovedposts'])) {
                     $forum_counters[$post['fid']]['unapprovedposts'] = $forum_cache[$post['fid']]['unapprovedposts'];
                 }
                 --$forum_counters[$post['fid']]['unapprovedposts'];
                 // Add 1 to the new forum's unapproved posts
                 if (!isset($forum_counters[$moveto]['unapprovedposts'])) {
                     $forum_counters[$moveto]['unapprovedposts'] = $forum_cache[$moveto]['unapprovedposts'];
                 }
                 ++$forum_counters[$moveto]['unapprovedposts'];
             }
         }
         // Subtract attachment counts from old thread and add to new thread (which are counted regardless of post or attachment unapproval at time of coding)
         if (!isset($thread_counters[$post['tid']]['attachmentcount'])) {
             $thread_counters[$post['tid']]['attachmentcount'] = $post['threadattachmentcount'];
         }
         $thread_counters[$post['tid']]['attachmentcount'] -= $post['postattachmentcount'];
         $thread_counters[$newtid]['attachmentcount'] += $post['postattachmentcount'];
     }
     if ($destination_tid == 0 && $thread_counters[$newtid]['replies'] > 0) {
         // If splitting into a new thread, subtract one from the thread's reply count to compensate for the original post
         --$thread_counters[$newtid]['replies'];
     }
     $arguments = array("pids" => $pids, "tid" => $tid, "moveto" => $moveto, "newsubject" => $newsubject, "destination_tid" => $destination_tid);
     $plugins->run_hooks("class_moderation_split_posts", $arguments);
     // Update user post counts
     if (is_array($user_counters)) {
         foreach ($user_counters as $uid => $change) {
             if ($change >= 0) {
                 $change = '+' . $change;
                 // add the addition operator for query
             }
             $db->update_query("users", array("postnum" => "postnum{$change}"), "uid='{$uid}'", 1, true);
         }
     }
     // Update thread counters
     if (is_array($thread_counters)) {
         foreach ($thread_counters as $tid => $counters) {
             if ($tid == $newtid) {
                 // Update the subject of the first post in the new thread
                 $query = $db->simple_select("posts", "pid", "tid='{$newtid}'", array('order_by' => 'dateline', 'limit' => 1));
                 $newthread = $db->fetch_array($query);
                 $sqlarray = array("subject" => $newsubject, "replyto" => 0);
                 $db->update_query("posts", $sqlarray, "pid='{$newthread['pid']}'");
             } else {
                 // Update the subject of the first post in the old thread
                 $query = $db->query("\n\t\t\t\t\t\tSELECT p.pid, t.subject\n\t\t\t\t\t\tFROM " . TABLE_PREFIX . "posts p\n\t\t\t\t\t\tLEFT JOIN " . TABLE_PREFIX . "threads t ON (p.tid=t.tid)\n\t\t\t\t\t\tWHERE p.tid='{$tid}'\n\t\t\t\t\t\tORDER BY p.dateline ASC\n\t\t\t\t\t\tLIMIT 1\n\t\t\t\t\t");
                 $oldthread = $db->fetch_array($query);
                 $sqlarray = array("subject" => $db->escape_string($oldthread['subject']), "replyto" => 0);
                 $db->update_query("posts", $sqlarray, "pid='{$oldthread['pid']}'");
             }
             $db->update_query("threads", $counters, "tid='{$tid}'");
             update_thread_data($tid);
             // Update first post columns
             update_first_post($tid);
         }
     }
     update_thread_data($newtid);
     update_first_post($newtid);
     // Update forum counters
     if (is_array($forum_counters)) {
         foreach ($forum_counters as $fid => $counters) {
             update_forum_counters($fid, $counters);
         }
     }
     return $newtid;
 }