<?php
    function update_community_thread($id, $todo = 'ABC')
    {
        $community_threads = mysqli_query_logged("SELECT * FROM community_threads WHERE id = '" . $id . "'");
        if ($community_threads_row = mysqli_fetch_assoc($community_threads))
        {
            if (strstr($todo, 'A') !== false)
            {
                $community_replies = mysqli_query_logged("SELECT COUNT(*) AS count FROM community_replies WHERE thread_id = '" . $community_threads_row['id'] . "'");
                if ($community_replies_row = mysqli_fetch_assoc($community_replies))
                {
                    mysqli_query_logged("UPDATE community_threads SET thread_replies = '" . $community_replies_row['count'] . "' WHERE id = '" . $id . "'");
                }
            }
            if (strstr($todo, 'B') !== false)
            {
                $community_replies = mysqli_query_logged("SELECT MIN(id) AS min FROM community_replies WHERE thread_id = '" . $community_threads_row['id'] . "'");
                if ($community_replies_row = mysqli_fetch_assoc($community_replies))
                {
                    mysqli_query_logged("UPDATE community_threads SET thread_first_post_id = '" . $community_replies_row['min'] . "' WHERE id = '" . $id . "'");
                }
            }
            if (strstr($todo, 'C') !== false)
            {
                $community_replies = mysqli_query_logged("SELECT MAX(id) AS max FROM community_replies WHERE thread_id = '" . $community_threads_row['id'] . "'");
                if ($community_replies_row = mysqli_fetch_assoc($community_replies))
                {
                    mysqli_query_logged("UPDATE community_threads SET thread_last_post_id = '" . $community_replies_row['max'] . "' WHERE id = '" . $id . "'");
                }
            }
        }
    }
    
    function update_community_section($community, $section, $todo = 'ABCD')
    {
        $community_forums = mysqli_query_logged("SELECT * FROM community_forums WHERE id = '" . $id . "'");
        if ($community_forums_row = mysqli_fetch_assoc($community_forums))
        {
            if (strstr($todo, 'A') !== false)
            {
                $forum_threads = mysqli_query_logged("SELECT COUNT(*) AS count FROM forum_threads WHERE forum_id = '" . $community_forums_row['id'] . "'");
                if ($forum_threads_row = mysqli_fetch_assoc($forum_threads))
                {
                    mysqli_query_logged("UPDATE community_forums SET forum_threads = '" . $forum_threads_row['count'] . "' WHERE id = '" . $id . "'");
                }
            }
            if (strstr($todo, 'B') !== false)
            {
                $forum_replies = mysqli_query_logged("SELECT COUNT(*) AS count FROM forum_replies WHERE forum_id = '" . $community_forums_row['id'] . "'");
                if ($forum_replies_row = mysqli_fetch_assoc($forum_replies))
                {
                    mysqli_query_logged("UPDATE community_forums SET forum_threads = '" . $forum_threads_row['count'] . "' WHERE id = '" . $id . "'");
                }
            }
            if (strstr($todo, 'C') !== false)
            {
                $forum_threads = mysqli_query_logged("SELECT MAX(id) AS max FROM forum_threads WHERE forum_id = '" . $community_forums_row['id'] . "'");
                if ($forum_threads_row = mysqli_fetch_assoc($forum_threads))
                {
                    mysqli_query_logged("UPDATE community_forums SET forum_last_post_id = '" . $forum_threads_row['max'] . "' WHERE id = '" . $id . "'");
                }
            }
            if (strstr($todo, 'D') !== false)
            {
                $forum_replies = mysqli_query_logged("SELECT MAX(id) AS max FROM forum_replies WHERE forum_id = '" . $community_forums_row['id'] . "'");
                if ($forum_replies_row = mysqli_fetch_assoc($forum_replies))
                {
                    mysqli_query_logged("UPDATE community_forums SET forum_last_post_id = '" . $forum_replies_row['max'] . "' WHERE id = '" . $id . "'");
                }
            }
        }
    }
    
    function update_community_forum($id, $todo = 'ABCD')
    {
        $community_forums = mysqli_query_logged("SELECT * FROM community_forums WHERE id = '" . $id . "'");
        if ($community_forums_row = mysqli_fetch_assoc($community_forums))
        {
            if (strstr($todo, 'A') !== false)
            {
                $forum_threads = mysqli_query_logged("SELECT COUNT(*) AS count FROM forum_threads WHERE forum_id = '" . $community_forums_row['id'] . "'");
                if ($forum_threads_row = mysqli_fetch_assoc($forum_threads))
                {
                    mysqli_query_logged("UPDATE community_forums SET forum_threads = '" . $forum_threads_row['count'] . "' WHERE id = '" . $id . "'");
                }
            }
            if (strstr($todo, 'B') !== false)
            {
                $forum_replies = mysqli_query_logged("SELECT COUNT(*) AS count FROM forum_replies WHERE forum_id = '" . $community_forums_row['id'] . "'");
                if ($forum_replies_row = mysqli_fetch_assoc($forum_replies))
                {
                    mysqli_query_logged("UPDATE community_forums SET forum_threads = '" . $forum_threads_row['count'] . "' WHERE id = '" . $id . "'");
                }
            }
            if (strstr($todo, 'C') !== false)
            {
                $forum_threads = mysqli_query_logged("SELECT MAX(id) AS max FROM forum_threads WHERE forum_id = '" . $community_forums_row['id'] . "'");
                if ($forum_threads_row = mysqli_fetch_assoc($forum_threads))
                {
                    mysqli_query_logged("UPDATE community_forums SET forum_last_post_id = '" . $forum_threads_row['max'] . "' WHERE id = '" . $id . "'");
                }
            }
            if (strstr($todo, 'D') !== false)
            {
                $forum_replies = mysqli_query_logged("SELECT MAX(id) AS max FROM forum_replies WHERE forum_id = '" . $community_forums_row['id'] . "'");
                if ($forum_replies_row = mysqli_fetch_assoc($forum_replies))
                {
                    mysqli_query_logged("UPDATE community_forums SET forum_last_post_id = '" . $forum_replies_row['max'] . "' WHERE id = '" . $id . "'");
                }
            }
        }
    }
    
    function update_all_community()
    {
        $community_forums = mysqli_query_logged("SELECT * FROM community_forums ORDER BY id");
        if ($community_forums_row = mysqli_fetch_assoc($community_forums))
        {
            update_community_forum($community_forums_row['id']);
        }
        $community_threads = mysqli_query_logged("SELECT * FROM community_threads WHERE id = '" . $id . "'");
        if ($community_threads_row = mysqli_fetch_assoc($community_threads))
        {
            update_community_thread($community_threads_row['id']);
        }
    }
?>