Code Forge

<?php

/**

*

* @package phpBB3

* @version $Id$

* @copyright (c) 2005 phpBB Group

* @license http://opensource.org/licenses/gpl-license.php GNU Public License

*

*/

/**

* @ignore

*/

if (!defined('IN_PHPBB'))

{

        exit;

}

/**

* Fill smiley templates (or just the variables) with smilies, either in a window or inline

*/

function generate_smilies($mode, $forum_id)

{

        global $auth, $db, $user, $config, $template;

        global $phpEx, $phpbb_root_path;

        $start = request_var('start', 0);

        if ($mode == 'window')

        {

                if ($forum_id)

                {

                        $sql = 'SELECT forum_style

                                FROM ' . FORUMS_TABLE . "

                                WHERE forum_id = $forum_id";

                        $result = $db->sql_query_limit($sql, 1);

                        $row = $db->sql_fetchrow($result);

                        $db->sql_freeresult($result);

                        $user->setup('posting', (int) $row['forum_style']);

                }

                else

                {

                        $user->setup('posting');

                }

                page_header($user->lang['SMILIES']);

                $sql = 'SELECT COUNT(smiley_id) AS item_count

                        FROM ' . SMILIES_TABLE . '

                        GROUP BY smiley_url';

                $result = $db->sql_query($sql, 3600);

                $smiley_count = 0;

                while ($row = $db->sql_fetchrow($result))

                {

                        ++$smiley_count;

                }

                $db->sql_freeresult($result);

                $template->set_filenames(array(

                        'body' => 'posting_smilies.html')

                );

                $template->assign_var('PAGINATION',

                        generate_pagination(append_sid("{$phpbb_root_path}posting.$phpEx", 'mode=smilies&f=' . $forum_id),

                                $smiley_count, $config['smilies_per_page'], $start, true)

                );

        }

        $display_link = false;

        if ($mode == 'inline')

        {

                $sql = 'SELECT smiley_id

                        FROM ' . SMILIES_TABLE . '

                        WHERE display_on_posting = 0';

                $result = $db->sql_query_limit($sql, 1, 0, 3600);

                if ($row = $db->sql_fetchrow($result))

                {

                        $display_link = true;

                }

                $db->sql_freeresult($result);

        }

        if ($mode == 'window')

        {

                $sql = 'SELECT smiley_url, MIN(emotion) as emotion, MIN(code) AS code, smiley_width, smiley_height, MIN(smiley_order) AS min_smiley_order

                        FROM ' . SMILIES_TABLE . '

                        GROUP BY smiley_url, smiley_width, smiley_height

                        ORDER BY min_smiley_order';

                $result = $db->sql_query_limit($sql, $config['smilies_per_page'], $start, 3600);

        }

        else

        {

                $sql = 'SELECT *

                        FROM ' . SMILIES_TABLE . '

                        WHERE display_on_posting = 1

                        ORDER BY smiley_order';

                $result = $db->sql_query($sql, 3600);

        }

        $smilies = array();

        while ($row = $db->sql_fetchrow($result))

        {

                if (empty($smilies[$row['smiley_url']]))

                {

                        $smilies[$row['smiley_url']] = $row;

                }

        }

        $db->sql_freeresult($result);

        if (sizeof($smilies))

        {

                $root_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? generate_board_url() . '/' : $phpbb_root_path;

                foreach ($smilies as $row)

                {

                        $template->assign_block_vars('smiley', array(

                                'SMILEY_CODE'        => $row['code'],

                                'A_SMILEY_CODE'        => addslashes($row['code']),

                                'SMILEY_IMG'        => $root_path . $config['smilies_path'] . '/' . $row['smiley_url'],

                                'SMILEY_WIDTH'        => $row['smiley_width'],

                                'SMILEY_HEIGHT'        => $row['smiley_height'],

                                'SMILEY_DESC'        => $row['emotion'])

                        );

                }

        }

        if ($mode == 'inline' && $display_link)

        {

                $template->assign_vars(array(

                        'S_SHOW_SMILEY_LINK'         => true,

                        'U_MORE_SMILIES'                 => append_sid("{$phpbb_root_path}posting.$phpEx", 'mode=smilies&f=' . $forum_id))

                );

        }

        if ($mode == 'window')

        {

                page_footer();

        }

}

/**

* Update last post information

* Should be used instead of sync() if only the last post information are out of sync... faster

*

* @param        string        $type                                Can be forum|topic

* @param        mixed        $ids                                topic/forum ids

* @param        bool        $return_update_sql        true: SQL query shall be returned, false: execute SQL

*/

function update_post_information($type, $ids, $return_update_sql = false)

{

        global $db;

        if (empty($ids))

        {

                return;

        }

        if (!is_array($ids))

        {

                $ids = array($ids);

        }

        $update_sql = $empty_forums = $not_empty_forums = array();

        if ($type != 'topic')

        {

                $topic_join = ', ' . TOPICS_TABLE . ' t';

                $topic_condition = 'AND t.topic_id = p.topic_id AND t.topic_approved = 1';

        }

        else

        {

                $topic_join = '';

                $topic_condition = '';

        }

        if (sizeof($ids) == 1)

        {

                $sql = 'SELECT MAX(p.post_id) as last_post_id

                        FROM ' . POSTS_TABLE . " p $topic_join

                        WHERE " . $db->sql_in_set('p.' . $type . '_id', $ids) . "

                                $topic_condition

                                AND p.post_approved = 1";

        }

        else

        {

                $sql = 'SELECT p.' . $type . '_id, MAX(p.post_id) as last_post_id

                        FROM ' . POSTS_TABLE . " p $topic_join

                        WHERE " . $db->sql_in_set('p.' . $type . '_id', $ids) . "

                                $topic_condition

                                AND p.post_approved = 1

                        GROUP BY p.{$type}_id";

        }

        $result = $db->sql_query($sql);

        $last_post_ids = array();

        while ($row = $db->sql_fetchrow($result))

        {

                if (sizeof($ids) == 1)

                {

                        $row[$type . '_id'] = $ids[0];

                }

                if ($type == 'forum')

                {

                        $not_empty_forums[] = $row['forum_id'];

                        if (empty($row['last_post_id']))

                        {

                                $empty_forums[] = $row['forum_id'];

                        }

                }

                $last_post_ids[] = $row['last_post_id'];

        }

        $db->sql_freeresult($result);

        if ($type == 'forum')

        {

                $empty_forums = array_merge($empty_forums, array_diff($ids, $not_empty_forums));

                foreach ($empty_forums as $void => $forum_id)

                {

                        $update_sql[$forum_id][] = 'forum_last_post_id = 0';

                        $update_sql[$forum_id][] = "forum_last_post_subject = ''";

                        $update_sql[$forum_id][] = 'forum_last_post_time = 0';

                        $update_sql[$forum_id][] = 'forum_last_poster_id = 0';

                        $update_sql[$forum_id][] = "forum_last_poster_name = ''";

                        $update_sql[$forum_id][] = "forum_last_poster_colour = ''";

                }

        }

        if (sizeof($last_post_ids))

        {

                $sql = 'SELECT p.' . $type . '_id, p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.user_id, u.username, u.user_colour

                        FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

                        WHERE p.poster_id = u.user_id

                                AND ' . $db->sql_in_set('p.post_id', $last_post_ids);

                $result = $db->sql_query($sql);

                while ($row = $db->sql_fetchrow($result))

                {

                        $update_sql[$row["{$type}_id"]][] = $type . '_last_post_id = ' . (int) $row['post_id'];

                        $update_sql[$row["{$type}_id"]][] = "{$type}_last_post_subject = '" . $db->sql_escape($row['post_subject']) . "'";

                        $update_sql[$row["{$type}_id"]][] = $type . '_last_post_time = ' . (int) $row['post_time'];

                        $update_sql[$row["{$type}_id"]][] = $type . '_last_poster_id = ' . (int) $row['poster_id'];

                        $update_sql[$row["{$type}_id"]][] = "{$type}_last_poster_colour = '" . $db->sql_escape($row['user_colour']) . "'";

                        $update_sql[$row["{$type}_id"]][] = "{$type}_last_poster_name = '" . (($row['poster_id'] == ANONYMOUS) ? $db->sql_escape($row['post_username']) : $db->sql_escape($row['username'])) . "'";

                }

                $db->sql_freeresult($result);

        }

        unset($empty_forums, $ids, $last_post_ids);

        if ($return_update_sql || !sizeof($update_sql))

        {

                return $update_sql;

        }

        $table = ($type == 'forum') ? FORUMS_TABLE : TOPICS_TABLE;

        foreach ($update_sql as $update_id => $update_sql_ary)

        {

                $sql = "UPDATE $table

                        SET " . implode(', ', $update_sql_ary) . "

                        WHERE {$type}_id = $update_id";

                $db->sql_query($sql);

        }

        return;

}

/**

* Generate Topic Icons for display

*/

function posting_gen_topic_icons($mode, $icon_id)

{

        global $phpbb_root_path, $config, $template, $cache;

        // Grab icons

        $icons = $cache->obtain_icons();

        if (!$icon_id)

        {

                $template->assign_var('S_NO_ICON_CHECKED', ' checked="checked"');

        }

        if (sizeof($icons))

        {

                foreach ($icons as $id => $data)

                {

                        if ($data['display'])

                        {

                                $template->assign_block_vars('topic_icon', array(

                                        'ICON_ID'                => $id,

                                        'ICON_IMG'                => $phpbb_root_path . $config['icons_path'] . '/' . $data['img'],

                                        'ICON_WIDTH'        => $data['width'],

                                        'ICON_HEIGHT'        => $data['height'],

                                        'S_CHECKED'                        => ($id == $icon_id) ? true : false,

                                        'S_ICON_CHECKED'        => ($id == $icon_id) ? ' checked="checked"' : '')

                                );

                        }

                }

                return true;

        }

        return false;

}

/**

* Build topic types able to be selected

*/

function posting_gen_topic_types($forum_id, $cur_topic_type = POST_NORMAL)

{

        global $auth, $user, $template, $topic_type;

        $toggle = false;

        $topic_types = array(

                'sticky'        => array('const' => POST_STICKY, 'lang' => 'POST_STICKY'),

                'announce'        => array('const' => POST_ANNOUNCE, 'lang' => 'POST_ANNOUNCEMENT'),

                'global'        => array('const' => POST_GLOBAL, 'lang' => 'POST_GLOBAL')

        );

        $topic_type_array = array();

        foreach ($topic_types as $auth_key => $topic_value)

        {

                // We do not have a special post global announcement permission

                $auth_key = ($auth_key == 'global') ? 'announce' : $auth_key;

                if ($auth->acl_get('f_' . $auth_key, $forum_id))

                {

                        $toggle = true;

                        $topic_type_array[] = array(

                                'VALUE'                        => $topic_value['const'],

                                'S_CHECKED'                => ($cur_topic_type == $topic_value['const'] || ($forum_id == 0 && $topic_value['const'] == POST_GLOBAL)) ? ' checked="checked"' : '',

                                'L_TOPIC_TYPE'        => $user->lang[$topic_value['lang']]

                        );

                }

        }

        if ($toggle)

        {

                $topic_type_array = array_merge(array(0 => array(

                        'VALUE'                        => POST_NORMAL,

                        'S_CHECKED'                => ($cur_topic_type == POST_NORMAL) ? ' checked="checked"' : '',

                        'L_TOPIC_TYPE'        => $user->lang['POST_NORMAL'])),

                        $topic_type_array

                );

                foreach ($topic_type_array as $array)

                {

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

                }

                $template->assign_vars(array(

                        'S_TOPIC_TYPE_STICKY'        => ($auth->acl_get('f_sticky', $forum_id)),

                        'S_TOPIC_TYPE_ANNOUNCE'        => ($auth->acl_get('f_announce', $forum_id)))

                );

        }

        return $toggle;

}

//

// Attachment related functions

//

/**

* Upload Attachment - filedata is generated here

* Uses upload class

*/

function upload_attachment($form_name, $forum_id, $local = false, $local_storage = '', $is_message = false, $local_filedata = false)

{

        global $auth, $user, $config, $db, $cache;

        global $phpbb_root_path, $phpEx;

        $filedata = array(

                'error'        => array()

        );

        include_once($phpbb_root_path . 'includes/functions_upload.' . $phpEx);

        $upload = new fileupload();

        if ($config['check_attachment_content'] && isset($config['mime_triggers']))

        {

                $upload->set_disallowed_content(explode('|', $config['mime_triggers']));

        }

        if (!$local)

        {

                $filedata['post_attach'] = ($upload->is_valid($form_name)) ? true : false;

        }

        else

        {

                $filedata['post_attach'] = true;

        }

        if (!$filedata['post_attach'])

        {

                $filedata['error'][] = $user->lang['NO_UPLOAD_FORM_FOUND'];

                return $filedata;

        }

        $extensions = $cache->obtain_attach_extensions((($is_message) ? false : (int) $forum_id));

        $upload->set_allowed_extensions(array_keys($extensions['_allowed_']));

        $file = ($local) ? $upload->local_upload($local_storage, $local_filedata) : $upload->form_upload($form_name);

        if ($file->init_error)

        {

                $filedata['post_attach'] = false;

                return $filedata;

        }

        $cat_id = (isset($extensions[$file->get('extension')]['display_cat'])) ? $extensions[$file->get('extension')]['display_cat'] : ATTACHMENT_CATEGORY_NONE;

        // Make sure the image category only holds valid images...

        if ($cat_id == ATTACHMENT_CATEGORY_IMAGE && !$file->is_image())

        {

                $file->remove();

                // If this error occurs a user tried to exploit an IE Bug by renaming extensions

                // Since the image category is displaying content inline we need to catch this.

                trigger_error($user->lang['ATTACHED_IMAGE_NOT_IMAGE']);

        }

        // Do we have to create a thumbnail?

        $filedata['thumbnail'] = ($cat_id == ATTACHMENT_CATEGORY_IMAGE && $config['img_create_thumbnail']) ? 1 : 0;

        // Check Image Size, if it is an image

        if (!$auth->acl_get('a_') && !$auth->acl_get('m_', $forum_id) && $cat_id == ATTACHMENT_CATEGORY_IMAGE)

        {

                $file->upload->set_allowed_dimensions(0, 0, $config['img_max_width'], $config['img_max_height']);

        }

        // Admins and mods are allowed to exceed the allowed filesize

        if (!$auth->acl_get('a_') && !$auth->acl_get('m_', $forum_id))

        {

                if (!empty($extensions[$file->get('extension')]['max_filesize']))

                {

                        $allowed_filesize = $extensions[$file->get('extension')]['max_filesize'];

                }

                else

                {

                        $allowed_filesize = ($is_message) ? $config['max_filesize_pm'] : $config['max_filesize'];

                }

                $file->upload->set_max_filesize($allowed_filesize);

        }

        $file->clean_filename('unique', $user->data['user_id'] . '_');

        // Are we uploading an image *and* this image being within the image category? Only then perform additional image checks.

        $no_image = ($cat_id == ATTACHMENT_CATEGORY_IMAGE) ? false : true;

        $file->move_file($config['upload_path'], false, $no_image);

        if (sizeof($file->error))

        {

                $file->remove();

                $filedata['error'] = array_merge($filedata['error'], $file->error);

                $filedata['post_attach'] = false;

                return $filedata;

        }

        $filedata['filesize'] = $file->get('filesize');

        $filedata['mimetype'] = $file->get('mimetype');

        $filedata['extension'] = $file->get('extension');

        $filedata['physical_filename'] = $file->get('realname');

        $filedata['real_filename'] = $file->get('uploadname');

        $filedata['filetime'] = time();

        // Check our complete quota

        if ($config['attachment_quota'])

        {

                if ($config['upload_dir_size'] + $file->get('filesize') > $config['attachment_quota'])

                {

                        $filedata['error'][] = $user->lang['ATTACH_QUOTA_REACHED'];

                        $filedata['post_attach'] = false;

                        $file->remove();

                        return $filedata;

                }

        }

        // Check free disk space

        if ($free_space = @disk_free_space($phpbb_root_path . $config['upload_path']))

        {

                if ($free_space <= $file->get('filesize'))

                {

                        $filedata['error'][] = $user->lang['ATTACH_QUOTA_REACHED'];

                        $filedata['post_attach'] = false;

                        $file->remove();

                        return $filedata;

                }

        }

        // Create Thumbnail

        if ($filedata['thumbnail'])

        {

                $source = $file->get('destination_file');

                $destination = $file->get('destination_path') . '/thumb_' . $file->get('realname');

                if (!create_thumbnail($source, $destination, $file->get('mimetype')))

                {

                        $filedata['thumbnail'] = 0;

                }

        }

        return $filedata;

}

/**

* Calculate the needed size for Thumbnail

*/

function get_img_size_format($width, $height)

{

        global $config;

        // Maximum Width the Image can take

        $max_width = ($config['img_max_thumb_width']) ? $config['img_max_thumb_width'] : 400;

        if ($width > $height)

        {

                return array(

                        round($width * ($max_width / $width)),

                        round($height * ($max_width / $width))

                );

        }

        else

        {

                return array(

                        round($width * ($max_width / $height)),

                        round($height * ($max_width / $height))

                );

        }

}

/**

* Return supported image types

*/

function get_supported_image_types($type = false)

{

        if (@extension_loaded('gd'))

        {

                $format = imagetypes();

                $new_type = 0;

                if ($type !== false)

                {

                        // Type is one of the IMAGETYPE constants - it is fetched from getimagesize()

                        // We do not use the constants here, because some were not available in PHP 4.3.x

                        switch ($type)

                        {

                                // GIF

                                case 1:

                                        $new_type = ($format & IMG_GIF) ? IMG_GIF : false;

                                break;

                                // JPG, JPC, JP2

                                case 2:

                                case 9:

                                case 10:

                                case 11:

                                case 12:

                                        $new_type = ($format & IMG_JPG) ? IMG_JPG : false;

                                break;

                                // PNG

                                case 3:

                                        $new_type = ($format & IMG_PNG) ? IMG_PNG : false;

                                break;

                                // WBMP

                                case 15:

                                        $new_type = ($format & IMG_WBMP) ? IMG_WBMP : false;

                                break;

                        }

                }

                else

                {

                        $new_type = array();

                        $go_through_types = array(IMG_GIF, IMG_JPG, IMG_PNG, IMG_WBMP);

                        foreach ($go_through_types as $check_type)

                        {

                                if ($format & $check_type)

                                {

                                        $new_type[] = $check_type;

                                }

                        }

                }

                return array(

                        'gd'                => ($new_type) ? true : false,

                        'format'        => $new_type,

                        'version'        => (function_exists('imagecreatetruecolor')) ? 2 : 1

                );

        }

        return array('gd' => false);

}

/**

* Create Thumbnail

*/

function create_thumbnail($source, $destination, $mimetype)

{

        global $config;

        $min_filesize = (int) $config['img_min_thumb_filesize'];

        $img_filesize = (file_exists($source)) ? @filesize($source) : false;

        if (!$img_filesize || $img_filesize <= $min_filesize)

        {

                return false;

        }

        $dimension = @getimagesize($source);

        if ($dimension === false)

        {

                return false;

        }

        list($width, $height, $type, ) = $dimension;

        if (empty($width) || empty($height))

        {

                return false;

        }

        list($new_width, $new_height) = get_img_size_format($width, $height);

        // Do not create a thumbnail if the resulting width/height is bigger than the original one

        if ($new_width >= $width && $new_height >= $height)

        {

                return false;

        }

        $used_imagick = false;

        // Only use imagemagick if defined and the passthru function not disabled

        if ($config['img_imagick'] && function_exists('passthru'))

        {

                if (substr($config['img_imagick'], -1) !== '/')

                {

                        $config['img_imagick'] .= '/';

                }

                @passthru(escapeshellcmd($config['img_imagick']) . 'convert' . ((defined('PHP_OS') && preg_match('#^win#i', PHP_OS)) ? '.exe' : '') . ' -quality 85 -geometry ' . $new_width . 'x' . $new_height . ' "' . str_replace('\\', '/', $source) . '" "' . str_replace('\\', '/', $destination) . '"');

                if (file_exists($destination))

                {

                        $used_imagick = true;

                }

        }

        if (!$used_imagick)

        {

                $type = get_supported_image_types($type);

                if ($type['gd'])

                {

                        // If the type is not supported, we are not able to create a thumbnail

                        if ($type['format'] === false)

                        {

                                return false;

                        }

                        switch ($type['format'])

                        {

                                case IMG_GIF:

                                        $image = @imagecreatefromgif($source);

                                break;

                                case IMG_JPG:

                                        @ini_set('gd.jpeg_ignore_warning', 1);

                                        $image = @imagecreatefromjpeg($source);

                                break;

                                case IMG_PNG:

                                        $image = @imagecreatefrompng($source);

                                break;

                                case IMG_WBMP:

                                        $image = @imagecreatefromwbmp($source);

                                break;

                        }

                        if (empty($image))

                        {

                                return false;

                        }

                        if ($type['version'] == 1)

                        {

                                $new_image = imagecreate($new_width, $new_height);

                                if ($new_image === false)

                                {

                                        return false;

                                }

                                imagecopyresized($new_image, $image, 0, 0, 0, 0, $new_width, $new_height, $width, $height);

                        }

                        else

                        {

                                $new_image = imagecreatetruecolor($new_width, $new_height);

                                if ($new_image === false)

                                {

                                        return false;

                                }

                                // Preserve alpha transparency (png for example)

                                @imagealphablending($new_image, false);