UPDATE xf_user AS user SET message_count = ( SELECT COUNT(*) FROM xf_post AS post LEFT JOIN xf_thread AS thread ON (thread.thread_id = post.thread_id) WHERE post.user_id = user.user_id AND post.message_state = 'visible' AND thread.discussion_state = 'visible' GROUP BY post.user_id );UPDATE xf_user AS user SET message_count = ( SELECT COUNT(*) FROM xf_post AS post LEFT JOIN xf_thread AS thread ON (thread.thread_id = post.thread_id) WHERE post.user_id = user.user_id AND thread.node_id NOT IN (1,2,3) AND post.message_state = 'visible' AND thread.discussion_state = 'visible' GROUP BY post.user_id );
UPDATE xf_user U
INNER JOIN (
SELECT
SUM(post_count) AS user_post_count,
TUP.user_id
FROM xf_thread_user_post TUP
INNER JOIN xf_thread T USING (thread_id)
INNER JOIN xf_forum F USING (node_id)
WHERE count_messages AND discussion_state = 'visible'
GROUP BY TUP.user_id) AS PC ON U.user_id = PC.user_id
SET message_count = user_post_countUPDATE xf_user AS user
SET message_count = (
SELECT COUNT(*)
FROM xf_post AS post
LEFT JOIN xf_thread AS thread ON (thread.thread_id = post.thread_id)
LEFT JOIN xf_forum AS forum ON (forum.node_id = thread.node_id)
WHERE post.user_id = user.user_id
AND post.message_state = 'visible' AND thread.discussion_state = 'visible'
AND forum.count_messages = 1
GROUP BY post.user_id
);Т.е. этот код просто сократит чисто постов, не учитывая разделы, где счётчик отключен?
Отлично, мне именно это и нужно.
Не работает он у меня. На 40 останавливается и показывает чистую пустую страницу.
Когда-то пробовал читать логи сервера. Так особо и не понял. Куча строчек с кучей данных. Ничего не поймёшь.
Сюда эти непонятные строчки выложите, авось другие в них разберутся.
