Ejemplo n.º 1
0
                if ($last_msg == $message) {
                    $this->ajax_die($lang['DOUBLE_POST_ERROR']);
                }
            }
        }
        if ($bb_cfg['max_smilies']) {
            $count_smilies = substr_count(bbcode2html($message), '<img class="smile" src="' . $bb_cfg['smilies_path']);
            if ($count_smilies > $bb_cfg['max_smilies']) {
                $this->ajax_die(sprintf($lang['MAX_SMILIES_PER_POST'], $bb_cfg['max_smilies']));
            }
        }
        DB()->sql_query("INSERT INTO " . BB_POSTS . " (topic_id, forum_id, poster_id, post_time, poster_ip) VALUES ({$topic_id}, " . $post['forum_id'] . ", " . $userdata['user_id'] . ", '" . TIMENOW . "', '" . USER_IP . "')");
        $post_id = DB()->sql_nextid();
        DB()->sql_query("INSERT INTO " . BB_POSTS_TEXT . " (post_id, post_text) VALUES ({$post_id}, '" . DB()->escape($message) . "')");
        update_post_stats('reply', $post, $post['forum_id'], $topic_id, $post_id, $userdata['user_id']);
        $s_message = str_replace('\\n', "\n", $message);
        $s_topic_title = str_replace('\\n', "\n", $post['topic_title']);
        add_search_words($post_id, stripslashes($s_message), stripslashes($s_topic_title));
        update_post_html(array('post_id' => $post_id, 'post_text' => $message));
        if ($bb_cfg['topic_notify_enabled']) {
            $notify = !empty($this->request['notify']);
            user_notification('reply', $post, $post['topic_title'], $post['forum_id'], $topic_id, $notify);
        }
        // Update atom feed
        update_atom('topic', (int) $this->request['topic_id']);
        $this->response['redirect'] = make_url(POST_URL . "{$post_id}#{$post_id}");
        break;
    default:
        $this->ajax_die('empty type');
        break;
}
Ejemplo n.º 2
0
function post_delete($mode_or_post_id, $user_id = null, $exclude_first = true)
{
    global $log_action;
    $del_user_posts = $mode_or_post_id === 'user';
    // Delete all user posts
    // Get required params
    if ($del_user_posts) {
        if (!($user_csv = get_id_csv($user_id))) {
            return false;
        }
    } else {
        if (!($post_csv = get_id_csv($mode_or_post_id))) {
            return false;
        }
        // фильтр заглавных сообщений в теме
        if ($exclude_first) {
            $sql = "SELECT topic_first_post_id FROM " . BB_TOPICS . " WHERE topic_first_post_id IN({$post_csv})";
            if ($first_posts = DB()->fetch_rowset($sql, 'topic_first_post_id')) {
                $posts_without_first = array_diff(explode(',', $post_csv), $first_posts);
                if (!($post_csv = get_id_csv($posts_without_first))) {
                    return false;
                }
            }
        }
    }
    // Collect data for logs, sync..
    $log_topics = $sync_forums = $sync_topics = $sync_users = array();
    if ($del_user_posts) {
        $sync_topics = DB()->fetch_rowset("SELECT DISTINCT topic_id FROM " . BB_POSTS . " WHERE poster_id IN({$user_csv})", 'topic_id');
        if ($topic_csv = get_id_csv($sync_topics)) {
            foreach (DB()->fetch_rowset("SELECT DISTINCT forum_id FROM " . BB_TOPICS . " WHERE topic_id IN({$topic_csv})") as $row) {
                $sync_forums[$row['forum_id']] = true;
            }
        }
        $sync_users = explode(',', $user_csv);
    } else {
        $sql = "\n\t\t\tSELECT p.topic_id, p.forum_id, t.topic_title\n\t\t\tFROM " . BB_POSTS . " p, " . BB_TOPICS . " t\n\t\t\tWHERE p.post_id IN({$post_csv})\n\t\t\t\tAND t.topic_id = p.topic_id\n\t\t\tGROUP BY t.topic_id\n\t\t";
        foreach (DB()->fetch_rowset($sql) as $row) {
            $log_topics[] = $row;
            $sync_topics[] = $row['topic_id'];
            $sync_forums[$row['forum_id']] = true;
        }
        $sync_users = DB()->fetch_rowset("SELECT DISTINCT poster_id FROM " . BB_POSTS . " WHERE post_id IN({$post_csv})", 'poster_id');
    }
    // Get all post_id for deleting
    $tmp_delete_posts = 'tmp_delete_posts';
    DB()->query("\n\t\tCREATE TEMPORARY TABLE {$tmp_delete_posts} (\n\t\t\tpost_id INT UNSIGNED NOT NULL DEFAULT '0',\n\t\t\tPRIMARY KEY (post_id)\n\t\t) ENGINE = MEMORY\n\t");
    DB()->add_shutdown_query("DROP TEMPORARY TABLE IF EXISTS {$tmp_delete_posts}");
    if ($del_user_posts) {
        $where_sql = "poster_id IN({$user_csv})";
        $exclude_posts_ary = array();
        foreach (DB()->fetch_rowset("SELECT topic_first_post_id FROM " . BB_TOPICS . " WHERE topic_poster IN({$user_csv})") as $row) {
            $exclude_posts_ary[] = $row['topic_first_post_id'];
        }
        if ($exclude_posts_csv = get_id_csv($exclude_posts_ary)) {
            $where_sql .= " AND post_id NOT IN({$exclude_posts_csv})";
        }
    } else {
        $where_sql = "post_id IN({$post_csv})";
    }
    DB()->query("INSERT INTO {$tmp_delete_posts} SELECT post_id FROM " . BB_POSTS . " WHERE {$where_sql}");
    // Deleted posts count
    $row = DB()->fetch_row("SELECT COUNT(*) AS posts_count FROM {$tmp_delete_posts}");
    if (!($deleted_posts_count = $row['posts_count'])) {
        DB()->query("DROP TEMPORARY TABLE {$tmp_delete_posts}");
        return 0;
    }
    // Delete attachments (from disk)
    $attach_dir = get_attachments_dir();
    $result = DB()->query("\n\t\tSELECT\n\t\t\td.physical_filename\n\t\tFROM\n\t\t\t" . $tmp_delete_posts . " del,\n\t\t\t" . BB_ATTACHMENTS . " a,\n\t\t\t" . BB_ATTACHMENTS_DESC . " d\n\t\tWHERE\n\t\t\t    a.post_id = del.post_id\n\t\t\tAND d.attach_id = a.attach_id\n\t");
    while ($row = DB()->fetch_next($result)) {
        if ($filename = basename($row['physical_filename'])) {
            @unlink("{$attach_dir}/" . $filename);
            @unlink("{$attach_dir}/" . THUMB_DIR . '/t_' . $filename);
        }
    }
    unset($row, $result);
    // Delete posts, posts_text, attachments (from DB)
    DB()->query("\n\t\tDELETE p, pt, ps, tor, a, d, ph\n\t\tFROM      " . $tmp_delete_posts . " del\n\t\tLEFT JOIN " . BB_POSTS . " p   ON(p.post_id  = del.post_id)\n\t\tLEFT JOIN " . BB_POSTS_TEXT . " pt  ON(pt.post_id  = del.post_id)\n\t\tLEFT JOIN " . BB_POSTS_HTML . " ph  ON(ph.post_id  = del.post_id)\n\t\tLEFT JOIN " . BB_POSTS_SEARCH . " ps  ON(ps.post_id  = del.post_id)\n\t\tLEFT JOIN " . BB_BT_TORRENTS . " tor ON(tor.post_id = del.post_id)\n\t\tLEFT JOIN " . BB_ATTACHMENTS . " a   ON(a.post_id  = del.post_id)\n\t\tLEFT JOIN " . BB_ATTACHMENTS_DESC . " d   ON(d.attach_id = a.attach_id)\n\t");
    // Log action
    if ($del_user_posts) {
        $log_action->admin('mod_post_delete', array('log_msg' => 'user: '******'IN_CRON')) {
            foreach ($log_topics as $row) {
                $log_action->mod('mod_post_delete', array('forum_id' => $row['forum_id'], 'topic_id' => $row['topic_id'], 'topic_title' => $row['topic_title']));
            }
        }
    }
    // Sync
    sync('topic', $sync_topics);
    sync('forum', array_keys($sync_forums));
    sync('user_posts', $sync_users);
    // Update atom feed
    foreach ($sync_topics as $atom_topic) {
        update_atom('topic', $atom_topic);
    }
    foreach ($sync_users as $atom_user) {
        update_atom('user', $atom_user);
    }
    DB()->query("DROP TEMPORARY TABLE {$tmp_delete_posts}");
    return $deleted_posts_count;
}
Ejemplo n.º 3
0
                    $sub_forums[] = $forum_id;
                    $sub_forums = join(',', $sub_forums);
                    // Подсчет проверенных релизов в форумах раздела
                    $count_checked_releases = DB()->fetch_row("\n\t\t\t\t\t\tSELECT COUNT(*) AS checked_releases\n\t\t\t\t\t\tFROM " . BB_BT_TORRENTS . "\n\t\t\t\t\t\tWHERE poster_id  = " . $userdata['user_id'] . "\n\t\t\t\t\t\t  AND forum_id   IN({$sub_forums})\n\t\t\t\t\t\t  AND tor_status IN(" . TOR_APPROVED . "," . TOR_DOUBTFUL . "," . TOR_TMP . ")\n\t\t\t\t\t\tLIMIT 1\n\t\t\t\t\t", 'checked_releases');
                    if ($count_checked_releases || IS_AM) {
                        tracker_register(TORRENT_ATTACH_ID, 'newtopic', TOR_NOT_APPROVED);
                    } else {
                        tracker_register(TORRENT_ATTACH_ID, 'newtopic', TOR_PREMOD);
                    }
                } else {
                    tracker_register(TORRENT_ATTACH_ID, 'newtopic', TOR_NOT_APPROVED);
                }
            }
        }
        // Update atom feed
        update_atom('topic', $topic_id);
        if ($mode == 'reply' && $post_info['topic_status'] == TOPIC_LOCKED) {
            $locked_warn = '
				<div class="warnColor1">
					<b>' . $lang['LOCKED_WARN'] . '</b>
				</div>
				<br /><hr /><br />
			';
            $return_message = $locked_warn . $return_message;
        }
        bb_die($return_message);
    }
}
if ($refresh || $error_msg || $submit && $topic_has_new_posts) {
    $username = !empty($_POST['username']) ? clean_username($_POST['username']) : '';
    $subject = !empty($_POST['subject']) ? clean_title($_POST['subject']) : '';