<?php

    #function used to convert bytes into kb or mb or gb. To be used later, you can make your own if you want, or even take it out, but you'll need to modify the php later on to remove the function call.
    function bytesize(&#36;bytes){

       &#36;size = &#36;bytes / 1024;
        if(&#36;size < 1024){
       
            &#36;size = number_format(&#36;size, 2);
            &#36;size .= ' KB';
          
        }else{
       
            if(&#36;size / 1024 < 1024){
          
                &#36;size = number_format(&#36;size / 1024, 2);
                &#36;size .= ' MB';
             
            }elseif(&#36;size / 1024 / 1024 < 1024){
          
                &#36;size = number_format(&#36;size / 1024 / 1024, 2);
                &#36;size .= ' GB';
             
            }
          
        }
        return &#36;size;
       
    }

    /*
    * @param String &#36;sort_order Has 13 options: (Default is s'ticky_recent_desc')
    * Options:
    1. 'recent_asc' Gives oldest to newest topics
    2. 'recent_desc' Vice versa
    3. 'sticky_recent_desc' Gives newest to oldest topics, however it retains announcements and stickies on top
    4. 'active_asc' Gives the early replied to recently replied
    5. 'active_desc' Vice versa
    6. 'subject_asc' Gives it in alphabetical order
    7. 'subject_desc' Vice versa
    8. 'author_asc' Gives authors in alphabetical order
    9. 'author_desc' Vice versa
    10. 'views_asc' Gives the least views to most views
    11. 'views_desc' Vice versa
    12. 'replies_asc' Gives the least replies to the most replies
    13. 'replies_desc' Vice versa
    * @return String &#36;sort_order_query The mysql coding to be used in the get_news function
    */
    function sort_order_query(&#36;sort_order){

       #switches for sort_order
       switch (&#36;sort_order){
          
          case 'recent_asc':
             &#36;sort_order_query = 't.topic_time ASC';
             break;
          case 'recent_desc':
             &#36;sort_order_query = 't.topic_time DESC';
             break;
            case 'sticky_recent_desc':
                &#36;sort_order_query = 't.topic_type DESC, t.topic_time DESC';
                break;
          case 'active_asc':
             &#36;sort_order_query = 't.topic_last_post_id ASC';
             break;
          case 'active_desc':
             &#36;sort_order_query = 't.topic_last_post_id DESC';
             break;
          case 'subject_asc':
             &#36;sort_order_query = 't.topic_title ASC';
             break;
          case 'subject_desc':
             &#36;sort_order_query = 't.topic_title DESC';
             break;
          case 'author_asc':
             &#36;sort_order_query = 't.topic_first_poster_name ASC';
             break;
          case 'author_desc':
             &#36;sort_order_query = 't.topic_first_poster_name DESC';
             break;
          case 'views_asc':
             &#36;sort_order_query = 't.topic_views ASC';
             break;
          case 'views_desc':
             &#36;sort_order_query = 't.topic_views DESC';
             break;
          case 'replies_asc':
             &#36;sort_order_query = 't.topic_replies_real ASC';
             break;
          case 'replies_desc':
             &#36;sort_order_query = 't.topic_replies_real DESC';
             break;
          default:
             &#36;sort_order_query = 't.topic_type DESC, t.topic_time DESC';
          
       }
       
       return(&#36;sort_order_query);

    }

    /** VERSION 4.09
    * Retrieve the first post of each topic in a given forum
    *
    * @param Array &#36;forum_ids  An array containing all the forum ids of the forums that must be included
    * @param Array &#36;parent_only_ids An array containg the forum ids that will only give you the topics inside that forum, and not any children. It is used to mix up with &#36;forum_ids. However if &#36;include_children is false, this will do nothing. If you do not want to use it, declare false on it when calling the function
    * @param Integer &#36;limit The maximum number of topics to be returned
    * @param Boolean &#36;include_children This variable specifies whether we should include the "child forums" of the given &#36;forum_ids in the results
    * @param Integer &#36;offset Set this variable if you don't want the result set begin on the first entry
    * @param String &#36;sort_order It is mysql coding of the query order. This is given by the sort_order_query function (Default is t.topic_time DESC)
    * @param Boolean &#36;allow_attachments (Default is true) Displays attachments (NOT INLINE IT WILL SHOW ALL ATTACHMENTS BUT INLINE WILL NOT BE PROCESSED)
    * @param Boolean &#36;allow_ranks (Default is true) Display ranks
    * @param Boolean &#36;allow_sigs (Default is true) Display signatures
    * @param Boolean &#36;allow_avatar (Default is true) Display avatars
    * @return Array &#36;posts An array holding all the posts and their data
    * NOTES: If you want forum posts + children (subforum) posts. Check include_children as true and check false for &#36;parent_only_ids.
    * If you want forum posts + children (subforum) posts + forum posts not including children posts. Check include_children as true, and input values for &#36;forum_ids and &#36;parent_only_ids
    * If you only want forum posts, DO NOT check &#36;forum_ids as false and use &#36;parent_only_ids. You must check &#36;include_children as false, and simply input values for &#36;forum_ids, and check &#36;parent_only_ids as false.
    * Remember that &#36;parent_only_ids only work when &#36;forum_ids are working regardless of &#36;include_children. So &#36;forum_ids is always the first one you have to use.
    * The function will not output topics which are not approved.
    */
    function get_news(&#36;forum_ids = array(), &#36;parent_only_ids = array(), &#36;limit = 10, &#36;offset = 0, &#36;include_children = false, &#36;sort_order = 't.topic_type DESC, t.topic_time DESC', &#36;allow_attachments = true, &#36;allow_ranks = true, &#36;allow_sigs = true, &#36;allow_avatar = true){

       global &#36;db, &#36;phpbb_root_path, &#36;phpEx;
       
       if (!is_array(&#36;forum_ids)){
       
          &#36;forum_ids = array(&#36;forum_ids);
          
       }
       if (!is_array(&#36;parent_only_ids)){
       
          &#36;parent_only_ids = array(&#36;parent_only_ids);   
          
       }
       
       #If required merge the children into the &#36;forum_ids
       if (&#36;include_children){
       
          #This can get very heavy when specifing a big array &#36;forum_ids
          &#36;child_forums = array();
          foreach (&#36;forum_ids as &#36;parent){
          
             &#36;children = get_forum_branch(&#36;parent, 'children');
             foreach (&#36;children as &#36;child){
             
                &#36;child_forums[] = &#36;child['forum_id'];
                
             }
             
          }
          #Merge
          &#36;forum_ids = array_merge(&#36;forum_ids, &#36;child_forums, &#36;parent_only_ids);
          
       }

       #Remove duplicates and filter out negatives
       &#36;forum_ids = array_unique(&#36;forum_ids);
       
       &#36;post_query = 'p.post_id, p.post_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, t.topic_id, t.forum_id, t.topic_title, t.topic_views, t.topic_replies_real, t.topic_type, t.topic_first_poster_name, t.topic_first_post_id, t.topic_last_post_time, u.user_id, u.user_colour';
       if(&#36;allow_ranks){
       
          &#36;post_query .= ',u.user_rank, u.user_posts';
       
       }
       if(&#36;allow_sigs){
       
          &#36;post_query .= ',u.user_sig, u.user_sig_bbcode_uid, u.user_sig_bbcode_bitfield';
       
       }
       if(&#36;allow_avatar){
       
          &#36;post_query .= ',u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height';
       
       }

       #Now select the post data
       &#36;post_sql_ary = array(
          'SELECT'   => &#36;post_query,
          'FROM'      => array(
             POSTS_TABLE      => 'p',
             TOPICS_TABLE   => 't',
          ),
          'LEFT_JOIN'    => array(
             array(
                'FROM'    => array(USERS_TABLE => 'u'),
                'ON'    => 'u.user_id = p.poster_id',
             ),
          ),
          'WHERE'        => '(' . &#36;db->sql_in_set('t.forum_id', &#36;forum_ids) . ' AND p.post_id = t.topic_first_post_id AND t.topic_approved = 1)',
          'ORDER_BY'    => &#36;sort_order,
       );
       &#36;sql   = &#36;db->sql_build_query('SELECT', &#36;post_sql_ary);
       &#36;result   = &#36;db->sql_query_limit(&#36;sql, &#36;limit, &#36;offset);
       
       #Set an array with the posts
       &#36;posts   = array();
       while (&#36;post = &#36;db->sql_fetchrow(&#36;result)){
          
          #Getting the Attachments
          if(&#36;allow_attachments && &#36;post['post_attachment']){
             
             unset(&#36;attachment_urls, &#36;attachment_ids, &#36;attachment_names,&#36;attachment_downloads, &#36;attachment_comments, &#36;attachment_filesize, &#36;num_of_attachment_ids);
             
             &#36;attachments_sql_ary = array(
                'SELECT'   => 'a.attach_id, a.real_filename, a.download_count, a.attach_comment, a.filesize',
                'FROM'      => array(
                   ATTACHMENTS_TABLE      => 'a',
                ),
                'WHERE'        => '(a.post_msg_id = ' . &#36;post['post_id'] . ' AND a.in_message = 0)',
                'ORDER_BY'    => 'a.attach_id DESC',
             );
             &#36;attachments_sql   = &#36;db->sql_build_query('SELECT', &#36;attachments_sql_ary);
             &#36;attachments_result = &#36;db->sql_query(&#36;attachments_sql);
             
             while (&#36;row = &#36;db->sql_fetchrow(&#36;attachments_result)){
             
                   &#36;attachment_ids[] = &#36;row['attach_id'];
                   &#36;attachment_names[] = &#36;row['real_filename'];
                   &#36;attachment_downloads[] = &#36;row['download_count'];
                   &#36;attachment_comments[] = &#36;row['attach_comment'];
                   &#36;attachment_filesize[] = &#36;row['filesize'];
                   
             }
             &#36;db->sql_freeresult(&#36;attachments_result);
             
             &#36;num_of_attachment_ids = count(&#36;attachment_ids);
             for(&#36;i=key(&#36;attachment_ids);&#36;i<&#36;num_of_attachment_ids;&#36;i++){
             
                &#36;attachment_urls[&#36;i] = &#36;phpbb_root_path . 'download/file.' . &#36;phpEx . '?id=' . &#36;attachment_ids[&#36;i];
             
             }
             
          }
          
          #Getting the Breadcrumbs
          unset(&#36;breadcrumb_ids);
          if(&#36;post['forum_id'] > 0){
             
             &#36;breadcrumb_ids_sql_ary = array(
                'SELECT'   => 'f.forum_id, f.forum_name',
                'FROM'      => array(
                   FORUMS_TABLE      => 'f',
                ),
                'WHERE'    => '(f.left_id <= (SELECT left_id FROM ' . FORUMS_TABLE . ' WHERE forum_id = ' . &#36;post['forum_id'] . ') AND f.right_id >= (SELECT right_id FROM ' . FORUMS_TABLE . ' WHERE forum_id = ' . &#36;post['forum_id'] . '))',
             );
             &#36;bread_crumb_ids_sql   = &#36;db->sql_build_query('SELECT', &#36;breadcrumb_ids_sql_ary);
             &#36;bread_crumb_ids_result = &#36;db->sql_query(&#36;bread_crumb_ids_sql);
             while (&#36;row = &#36;db->sql_fetchrow(&#36;bread_crumb_ids_result)){
             
                   &#36;breadcrumb_ids[&#36;row['forum_name']] = &#36;row['forum_id'];
                   
             }
             &#36;db->sql_freeresult(&#36;bread_crumb_ids_result);
          
          }
       
          &#36;posts[] = array(
             # FOR POSTS
             'forum_id'            => &#36;post['forum_id'],
             'post_id'            => &#36;post['post_id'],
             'post_time'            => &#36;post['post_time'],
             'post_text'            => &#36;post['post_text'],
                #PARSING
             'bbcode_bitfield'      => &#36;post['bbcode_bitfield'],
             'bbcode_uid'         => &#36;post['bbcode_uid'],
             'enable_bbcode'         => &#36;post['enable_bbcode'],
             'enable_smilies'      => &#36;post['enable_smilies'],
             'enable_magic_url'      => &#36;post['enable_magic_url'],
                #TOPIC DETAILS
             'topic_id'            => &#36;post['topic_id'],
             'topic_title'         => &#36;post['topic_title'],
             'topic_views'         => &#36;post['topic_views'],
             'topic_replies_real'   => &#36;post['topic_replies_real'],
             'topic_type'            => &#36;post['topic_type'],
             'topic_first_post_id'    => &#36;post['topic_first_post_id'],
             'topic_last_post_time'    => &#36;post['topic_last_post_time'],
                #ATTACHMENTS
             'allow_attachments'      => &#36;allow_attachments,
             'is_there_attachments'   => &#36;post['post_attachment'],
             'attachments'          => &#36;attachment_urls,
             'attachment_names'       => &#36;attachment_names,
             'attachment_downloads'    => &#36;attachment_downloads,
             'attachment_comments'    => &#36;attachment_comments,
             'attachment_filesize'    => &#36;attachment_filesize,
             'num_of_attachments'    => &#36;num_of_attachment_ids,
                #BREADCRUMBS
             'breadcrumb_ids'       => &#36;breadcrumb_ids,
             
             #FOR USER
             'user_id'            => &#36;post['user_id'],
             'topic_first_poster_name'   => &#36;post['topic_first_poster_name'],
             'user_colour'         => &#36;post['user_colour'],
                #AVATAR
             'allow_avatar'          => &#36;allow_avatar,
             'user_avatar'         => &#36;post['user_avatar'],
             'user_avatar_type'      => &#36;post['user_avatar_type'],
             'user_avatar_width'      => &#36;post['user_avatar_width'],
             'user_avatar_height'   => &#36;post['user_avatar_height'],
                #RANKS
             'allow_ranks'          => &#36;allow_ranks,
             'user_rank_id'          => &#36;post['user_rank'],
             'user_posts'          => &#36;post['user_posts'],
                #SIGNATURES
             'allow_sigs'         => &#36;allow_sigs,
             'user_sig'             => &#36;post['user_sig'],
             'user_sig_bbcode_uid'    => &#36;post['user_sig_bbcode_uid'],
             'user_sig_bbcode_bitfield'    => &#36;post['user_sig_bbcode_bitfield'],
             
             #FOR PAGINATION
             'total_forum_ids'      => &#36;forum_ids,
          );
          
       }
       
       &#36;db->sql_freeresult(&#36;result);
       
       // Return it
       return &#36;posts;
       
    }

    ?>