Просмотр архива Форум PHPWEB


<?php

if ( !defined('IN_PHPBB') )
{
    die("ERROR!!! THIS FILE PROTECTED. IF YOU SAW THIS REPORT, MEANS HACKERS HERE IS NOTHING TO DO ");
}

function attach_faq_include($lang_file)
{
    global $phpbb_root_path, $board_config, $phpEx, $faq, $attach_config;

    if (intval($attach_config['disable_mod']))
    {
        return;
    }

    if ($lang_file == 'lang_faq')
    {
        $language = attach_mod_get_lang('lang_faq_attach');
        include($phpbb_root_path . 'language/lang_' . $language . '/lang_faq_attach.'.$phpEx);
    }
}

function attach_setup_basic_auth($type, &$auth_fields, &$a_sql)
{
    switch ($type)
    {
        case AUTH_ALL:
            $a_sql .= ', a.auth_attachments, a.auth_download';
            $auth_fields[] = 'auth_attachments';
            $auth_fields[] = 'auth_download';
        break;

        case AUTH_ATTACH:
            $a_sql = 'a.auth_attachments';
            $auth_fields = array('auth_attachments');
        break;
        
        case AUTH_DOWNLOAD:
            $a_sql = 'a.auth_download';
            $auth_fields = array('auth_download');
        break;
        
        default:
            break;
    }
}

function attach_setup_forum_auth(&$simple_auth_ary, &$forum_auth_fields, &$field_names)
{
    global $lang;

    $simple_auth_ary[0][] = AUTH_MOD;
    $simple_auth_ary[1][] = AUTH_MOD;
    $simple_auth_ary[2][] = AUTH_MOD;
    $simple_auth_ary[3][] = AUTH_MOD;
    $simple_auth_ary[4][] = AUTH_MOD;
    $simple_auth_ary[5][] = AUTH_MOD;
    $simple_auth_ary[6][] = AUTH_MOD;
    $simple_auth_ary[0][] = AUTH_ALL;
    $simple_auth_ary[1][] = AUTH_ALL;
    $simple_auth_ary[2][] = AUTH_REG;
    $simple_auth_ary[3][] = AUTH_ACL;
    $simple_auth_ary[4][] = AUTH_ACL;
    $simple_auth_ary[5][] = AUTH_MOD;
    $simple_auth_ary[6][] = AUTH_MOD;

    $forum_auth_fields[] = 'auth_attachments';
    $field_names['auth_attachments'] = $lang['Auth_attach'];

    $forum_auth_fields[] = 'auth_download';
    $field_names['auth_download'] = $lang['Auth_download'];
}

function attach_setup_usergroup_auth(&$forum_auth_fields, &$auth_field_match, &$field_names)
{
    global $lang;

    $forum_auth_fields[] = 'auth_attachments';
    $auth_field_match['auth_attachments'] = AUTH_ATTACH;
    $field_names['auth_attachments'] = $lang['Auth_attach'];
    $forum_auth_fields[] = 'auth_download';
    $auth_field_match['auth_download'] = AUTH_DOWNLOAD;
    $field_names['auth_download'] = $lang['Auth_download'];
}

function attach_setup_viewtopic_auth(&$order_sql, &$sql)
{
    $order_sql = str_replace('f.auth_attachments', 'f.auth_attachments, f.auth_download, t.topic_attachment', $order_sql);
    $sql = str_replace('f.auth_attachments', 'f.auth_attachments, f.auth_download, t.topic_attachment', $sql);
}

function attach_build_auth_levels($is_auth, &$s_auth_can)
{
    global $lang, $attach_config, $phpEx, $forum_id;

    if (intval($attach_config['disable_mod']))
    {
        return;
    }

    $s_auth_can .= (($is_auth['auth_attachments']) ? $lang['Rules_attach_can'] : $lang['Rules_attach_cannot'] ) . '<br />';

    $s_auth_can .= (($is_auth['auth_download']) ? $lang['Rules_download_can'] : $lang['Rules_download_cannot'] ) . '<br />';
}

function attachment_quota_settings($admin_mode, $submit = false, $mode)
{
    global $template, $db, $HTTP_POST_VARS, $HTTP_GET_VARS, $lang, $lang, $phpbb_root_path, $phpEx, $attach_config;

    include_once($phpbb_root_path . 'attach_mod/includes/constants.'.$phpEx);

    if (!intval($attach_config['allow_ftp_upload']))
    {
        if ($attach_config['upload_dir'][0] == '/' || ($attach_config['upload_dir'][0] != '/' && $attach_config['upload_dir'][1] == ':'))
        {
            $upload_dir = $attach_config['upload_dir'];
        }
        else
        {
            $upload_dir = $phpbb_root_path . $attach_config['upload_dir'];
        }
    }
    else
    {
        $upload_dir = $attach_config['download_path'];
    }

    include_once($phpbb_root_path . 'attach_mod/includes/functions_selects.' . $phpEx);
    include_once($phpbb_root_path . 'attach_mod/includes/functions_admin.' . $phpEx);

    $user_id = 0;

    if ($admin_mode == 'user')
    {
        $submit = (isset($HTTP_POST_VARS['submit'])) ? true : false;

        if (!$submit && $mode != 'save')
        {
            $user_id = get_var(POST_USERS_URL, 0);
            $u_name = get_var('username', '');

            if (!$user_id && !$u_name)
            {
                message_die(GENERAL_MESSAGE, $lang['No_user_id_specified'] );
            }

            if ($user_id)
            {
                $this_userdata['user_id'] = $user_id;
            }
            else
            {
                $this_userdata = get_userdata($HTTP_POST_VARS['username'], true);
            }

            $user_id = (int) $this_userdata['user_id'];
        }
        else
        {
            $user_id = get_var('id', 0);
            
            if (!$user_id)
            {
                message_die(GENERAL_MESSAGE, $lang['No_user_id_specified'] );
            }
        }
    }
    
    if ($admin_mode == 'user' && !$submit && $mode != 'save')
    {
        $sql = 'SELECT quota_limit_id, quota_type FROM ' . QUOTA_TABLE . ' 
            WHERE user_id = ' . (int) $user_id;

        if( !($result = $db->sql_query($sql)) )
        {
            message_die(GENERAL_ERROR, 'Unable to get Quota Settings', '', __LINE__, __FILE__, $sql);
        }

        $pm_quota = $upload_quota = 0;
        
        if ($row = $db->sql_fetchrow($result))
        {
            do
            {
                if ($row['quota_type'] == QUOTA_UPLOAD_LIMIT)
                {
                    $upload_quota = $row['quota_limit_id'];
                }
                else if ($row['quota_type'] == QUOTA_PM_LIMIT)
                {
                    $pm_quota = $row['quota_limit_id'];
                }
            }
            while ($row = $db->sql_fetchrow($result));
        }
        else
        {
            $upload_quota = $attach_config['default_upload_quota'];
            $pm_quota = $attach_config['default_pm_quota'];
        }
        $db->sql_freeresult($result);

        $template->assign_vars(array(
            'S_SELECT_UPLOAD_QUOTA'        => quota_limit_select('user_upload_quota', $upload_quota),
            'S_SELECT_PM_QUOTA'            => quota_limit_select('user_pm_quota', $pm_quota),
            'L_UPLOAD_QUOTA'            => $lang['Upload_quota'],
            'L_PM_QUOTA'                => $lang['Pm_quota'])
        );
    }

    if ($admin_mode == 'user' && $submit && $HTTP_POST_VARS['deleteuser'])
    {
        process_quota_settings($admin_mode, $user_id, QUOTA_UPLOAD_LIMIT, 0);
        process_quota_settings($admin_mode, $user_id, QUOTA_PM_LIMIT, 0);
    }
    else if ($admin_mode == 'user' && $submit && $mode == 'save')
    {
        $upload_quota = get_var('user_upload_quota', 0);
        $pm_quota = get_var('user_pm_quota', 0);

        process_quota_settings($admin_mode, $user_id, QUOTA_UPLOAD_LIMIT, $upload_quota);
        process_quota_settings($admin_mode, $user_id, QUOTA_PM_LIMIT, $pm_quota);
    }

    if ($admin_mode == 'group' && $mode == 'newgroup')
    {
        return;
    }

    if ($admin_mode == 'group' && !$submit && isset($HTTP_POST_VARS['edit']))
    {
        $group_id = get_var(POST_GROUPS_URL, 0);

        $sql = 'SELECT quota_limit_id, quota_type FROM ' . QUOTA_TABLE . ' 
            WHERE group_id = ' . (int) $group_id;

        if( !($result = $db->sql_query($sql)) )
        {
            message_die(GENERAL_ERROR, 'Unable to get Quota Settings', '', __LINE__, __FILE__, $sql);
        }

        $pm_quota = $upload_quota = 0;
        
        if ($row = $db->sql_fetchrow($result))
        {
            do
            {
                if ($row['quota_type'] == QUOTA_UPLOAD_LIMIT)
                {
                    $upload_quota = $row['quota_limit_id'];
                }
                else if ($row['quota_type'] == QUOTA_PM_LIMIT)
                {
                    $pm_quota = $row['quota_limit_id'];
                }
            }
            while ($row = $db->sql_fetchrow($result));
        }
        else
        {
            $upload_quota = $attach_config['default_upload_quota'];
            $pm_quota = $attach_config['default_pm_quota'];
        }
        $db->sql_freeresult($result);

        $template->assign_vars(array(
            'S_SELECT_UPLOAD_QUOTA'    => quota_limit_select('group_upload_quota', $upload_quota),
            'S_SELECT_PM_QUOTA'        => quota_limit_select('group_pm_quota', $pm_quota),
            'L_UPLOAD_QUOTA'        => $lang['Upload_quota'],
            'L_PM_QUOTA'            => $lang['Pm_quota'])
        );
    }

    if ($admin_mode == 'group' && $submit && isset($HTTP_POST_VARS['group_delete']))
    {
        $group_id = get_var(POST_GROUPS_URL, 0);
    
        process_quota_settings($admin_mode, $group_id, QUOTA_UPLOAD_LIMIT, 0);
        process_quota_settings($admin_mode, $group_id, QUOTA_PM_LIMIT, 0);
    }
    else if ($admin_mode == 'group' && $submit)
    {
        $group_id = get_var(POST_GROUPS_URL, 0);
        $upload_quota = get_var('group_upload_quota', 0);
        $pm_quota = get_var('group_pm_quota', 0);

        process_quota_settings($admin_mode, $group_id, QUOTA_UPLOAD_LIMIT, $upload_quota);
        process_quota_settings($admin_mode, $group_id, QUOTA_PM_LIMIT, $pm_quota);
    }

}

function display_upload_attach_box_limits($user_id, $group_id = 0)
{
    global $attach_config, $board_config, $phpbb_root_path, $lang, $db, $template, $phpEx, $userdata, $profiledata;
    
    if (intval($attach_config['disable_mod']))
    {
        return;
    }
    
    if ($userdata['user_level'] != ADMIN && $userdata['user_id'] != $user_id)
    {
        return;
    }

    if (!$user_id)
    {
        return;
    }

    if ($group_id)
    {
        if (!user_in_group($user_id, $group_id))
        {
            return;
        }
    }
    
    $user_id = (int) $user_id;
    $group_id = (int) $group_id;

    $attachments = new attach_posting();
    $attachments->page = PAGE_INDEX;

    if ($group_id)
    {
        $sql = 'SELECT l.quota_limit 
            FROM ' . QUOTA_TABLE . ' q, ' . QUOTA_LIMITS_TABLE . ' l
            WHERE q.group_id = ' . (int) $group_id . ' 
                AND q.quota_type = ' . QUOTA_UPLOAD_LIMIT . ' 
                AND q.quota_limit_id = l.quota_limit_id 
            LIMIT 1';

        if ( !($result = $db->sql_query($sql)) )
        {
            message_die(GENERAL_ERROR, 'Could not get Group Quota', '', __LINE__, __FILE__, $sql);
        }

        if ($db->sql_numrows($result) > 0)
        {
            $row = $db->sql_fetchrow($result);
            $attach_config['upload_filesize_limit'] = intval($row['quota_limit']);
            $db->sql_freeresult($result);
        }
        else
        {
            $db->sql_freeresult($result);
            $quota_id = intval($attach_config['default_upload_quota']);

            if ($quota_id == 0)
            {
                $attach_config['upload_filesize_limit'] = $attach_config['attachment_quota'];
            }
            else
            {
                $sql = 'SELECT quota_limit 
                    FROM ' . QUOTA_LIMITS_TABLE . '
                    WHERE quota_limit_id = ' . (int) $quota_id . '
                    LIMIT 1';

                if ( !($result = $db->sql_query($sql)) )
                {
                    message_die(GENERAL_ERROR, 'Could not get Quota Limit', '', __LINE__, __FILE__, $sql);
                }
    
                if ($db->sql_numrows($result) > 0)
                {
                    $row = $db->sql_fetchrow($result);
                    $attach_config['upload_filesize_limit'] = $row['quota_limit'];
                }
                else
                {
                    $attach_config['upload_filesize_limit'] = $attach_config['attachment_quota'];
                }
                $db->sql_freeresult($result);
            }
        }
    }
    else
    {
        if (is_array($profiledata))
        {
            $attachments->get_quota_limits($profiledata, $user_id);
        }
        else
        {
            $attachments->get_quota_limits($userdata, $user_id);
        }
    }

    if (!$attach_config['upload_filesize_limit'])
    {
        $upload_filesize_limit = $attach_config['attachment_quota'];
    }
    else
    {
        $upload_filesize_limit = $attach_config['upload_filesize_limit'];
    }

    if ($upload_filesize_limit == 0)
    {
        $user_quota = $lang['Unlimited'];
    }
    else
    {
        $size_lang = ($upload_filesize_limit >= 1048576) ? $lang['MB'] : ( ($upload_filesize_limit >= 1024) ? $lang['KB'] : $lang['Bytes'] );

        if ($upload_filesize_limit >= 1048576)
        {
            $user_quota = (round($upload_filesize_limit / 1048576 * 100) / 100) . ' ' . $size_lang;
        }
        else if ($upload_filesize_limit >= 1024)
        {
            $user_quota = (round($upload_filesize_limit / 1024 * 100) / 100) . ' ' . $size_lang;
        }
        else
        {
            $user_quota = ($upload_filesize_limit) . ' ' . $size_lang;
        }
    }

    $sql = 'SELECT attach_id 
        FROM ' . ATTACHMENTS_TABLE . '
        WHERE user_id_1 = ' . (int) $user_id . '
            AND privmsgs_id = 0
        GROUP BY attach_id';
        
    if ( !($result = $db->sql_query($sql)) )
    {
        message_die(GENERAL_ERROR, 'Couldn't query attachments', '', __LINE__, __FILE__, $sql);
    }
        
    $attach_ids = $db->sql_fetchrowset($result);
    $num_attach_ids = $db->sql_numrows($result);
    $db->sql_freeresult($result);
    $attach_id = array();

    for ($j = 0; $j < $num_attach_ids; $j++)
    {
        $attach_id[] = intval($attach_ids[$j]['attach_id']);
    }

    $upload_filesize = (sizeof($attach_id) > 0) ? get_total_attach_filesize($attach_id) : 0;

    $size_lang = ($upload_filesize >= 1048576) ? $lang['MB'] : ( ($upload_filesize >= 1024) ? $lang['KB'] : $lang['Bytes'] );

    if ($upload_filesize >= 1048576)
    {
        $user_uploaded = (round($upload_filesize / 1048576 * 100) / 100) . ' ' . $size_lang;
    }
    else if ($upload_filesize >= 1024)
    {
        $user_uploaded = (round($upload_filesize / 1024 * 100) / 100) . ' ' . $size_lang;
    }
    else
    {
        $user_uploaded = ($upload_filesize) . ' ' . $size_lang;
    }

    $upload_limit_pct = ( $upload_filesize_limit > 0 ) ? round(( $upload_filesize / $upload_filesize_limit ) * 100) : 0;
    $upload_limit_img_length = ( $upload_filesize_limit > 0 ) ? round(( $upload_filesize / $upload_filesize_limit ) * $board_config['privmsg_graphic_length']) : 0;
    if ($upload_limit_pct > 100)
    {
        $upload_limit_img_length = $board_config['privmsg_graphic_length'];
    }
    $upload_limit_remain = ( $upload_filesize_limit > 0 ) ? $upload_filesize_limit - $upload_filesize : 100;

    $l_box_size_status = sprintf($lang['Upload_percent_profile'], $upload_limit_pct);

    $template->assign_block_vars('switch_upload_limits', array());

    $template->assign_vars(array(
        'L_UACP'            => $lang['UACP'],
        'L_UPLOAD_QUOTA'    => $lang['Upload_quota'],
        'U_UACP'            => $phpbb_root_path . 'uacp.' . $phpEx . '?' . POST_USERS_URL . '=' . $user_id . '&amp;sid=' . $userdata['session_id'],
        'UPLOADED'            => sprintf($lang['User_uploaded_profile'], $user_uploaded),
        'QUOTA'                => sprintf($lang['User_quota_profile'], $user_quota),
        'UPLOAD_LIMIT_IMG_WIDTH'    => $upload_limit_img_length, 
        'UPLOAD_LIMIT_PERCENT'        => $upload_limit_pct, 
        'PERCENT_FULL'                => $l_box_size_status)
    );
}

function prune_attachments($sql_post)
{
    delete_attachment($sql_post);
}

function perform_attach_pageregister($session_page, $in_admin = false)
{
    global $location, $location_url, $lang;

    switch ($session_page)
    {
        case (PAGE_UACP):
            $location = $lang['User_acp_title'];
            $location_url = ($in_admin) ? "index.$phpEx?pane=right" : "index.$phpEx";
        break;

        case (PAGE_RULES):
            $location = $lang['Rules_page'];
            $location_url = ($in_admin) ? "index.$phpEx?pane=right" : "index.$phpEx";
        break;
    }
}

?>