<?
    
require_once('include/functions/community_banned.php');
    require_once(
'include/functions/community_permissions.php');    

    
$_back = isset($_GET['b']) ? str_replace('@''&'trim(strval($_GET['b']))) : '';
    
$_id = isset($_GET['i']) ? trim($_GET['i']) : '';

    
$community_messages mysql_query("SELECT * FROM community_messages, community_threads, community_forums, community_sections, community WHERE community_messages.message_id = " sq($_id) . " AND community_messages.thread_id = community_threads.thread_id AND community_threads.forum_id = community_forums.forum_id AND community_forums.section_id = community_sections.section_id AND community_sections.community_id = community.community_id");
    if (!
$community_messages_row mysql_fetch_assoc($community_messages))    
    {
        
header('Location: ./?s=communities');
        die;        
    }
    
    
community_banned($community_messages_row['community_id']);
    
community_permissions($community_messages_row['community_id']);
    
    
$forum_id $community_messages_row['forum_id'];
    
$thread_id $community_messages_row['thread_id'];

    if (
$GLOBALS['auth']['community']['delete_message'])
    {
        if (
$community_messages_row['message_id'] != $community_messages_row['thread_first_message_id'])
        {
            
mysql_query("DELETE FROM community_messages_updates WHERE message_id = '" $community_messages_row['message_id'] . "'");
            
mysql_query("DELETE FROM community_messages_rating WHERE message_id = '" $community_messages_row['message_id'] . "'");
            
mysql_query("DELETE FROM community_messages_bodies WHERE message_id = '" $community_messages_row['message_id'] . "'");
            
mysql_query("DELETE FROM community_messages WHERE message_id = '" $community_messages_row['message_id'] . "'");
            
$messages 0;
            
$community_messages mysql_query("SELECT COUNT(*) AS count FROM community_messages WHERE thread_id = '" $thread_id "'");
            if (
$community_messages_row mysql_fetch_assoc($community_messages))
            {
                
$messages $community_messages_row['count'];
            }
            
$community_messages mysql_query("SELECT * FROM community_messages WHERE thread_id = '" $thread_id "' ORDER BY message_id DESC LIMIT 1");
            if (
$community_messages_row mysql_fetch_assoc($community_messages))
            {
                
mysql_query("UPDATE community_threads SET thread_last_user_id = '" $community_messages_row['message_user_id'] . "', thread_last_posted_on = '" $community_messages_row['message_posted_on'] . "', thread_messages = '" $messages "', thread_last_message_id = '" $community_messages_row['message_id'] . "' WHERE thread_id = '" $thread_id "'");
            }
            
$community_threads mysql_query("SELECT SUM(thread_messages) AS sum FROM community_threads WHERE forum_id = '" $forum_id "'");
            if (
$community_threads_row mysql_fetch_assoc($community_threads))
            {
                
mysql_query("UPDATE community_forums SET forum_messages = '" $community_threads_row['sum'] . "' WHERE forum_id = '" $forum_id "'");
            }
        }
    }
    
    
header('Location: ./?' . ($_back $_back 's=community_thread&i=' $thread_id '#l'));
?>