Forum

<?php
/*##################################################
 *                               musique.php
 *                            -------------------
 *   begin                : July 27, 2005
 *   copyright            : (C) 2005 Viarre Régis, Sautel Benoit
 *   email                : crowkait@phpboost.com, ben.popeye@phpboost.com
 *
 *
###################################################
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 * 
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program; if not, write to the Free Software
 *  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
###################################################*/
 
require_once('../kernel/begin.php');
require_once('../musique/musique_begin.php');
require_once('../kernel/header.php');
 
if ($file_id > 0) //Contenu
{
    $Template->set_filenames(array('musique'=> 'musique/musique.tpl'));
 
    if ($musique_info['size'] > 1)
        $size_tpl = $musique_info['size'] . ' ' . $LANG['unit_megabytes'];
    elseif ($musique_info['size'] > 0)
        $size_tpl = ($musique_info['size'] * 1024) . ' ' . $LANG['unit_kilobytes'];
    else
        $size_tpl = $MUSIQUE_LANG['unknown_size'];
 
    import('util/date');
     $creation_date = new Date(DATE_TIMESTAMP, TIMEZONE_SYSTEM, $musique_info['timestamp']);
     $release_date = new Date(DATE_TIMESTAMP, TIMEZONE_SYSTEM, $musique_info['release_timestamp']);
 
    //Affichage notation.
    import('content/note');
    $Note = new Note('musique', $file_id, url('musique.php?id=' . $file_id, 'category-' . $category_id . '-' . $file_id . '.php'), $CONFIG_MUSIQUE['note_max'], '', NOTE_NODISPLAY_NBRNOTES);
 
    import('content/comments');
 
    $Template->assign_vars(array(
        'C_DISPLAY_MUSIQUE' => true,
        'C_IMG' => !empty($musique_info['image']),
        'C_EDIT_AUTH' => $auth_write,
        'MODULE_DATA_PATH' => $Template->get_module_data_path('musique'),
        'ID_FILE' => $file_id,
        'NAME' => $musique_info['title'],
        'CONTENTS' => second_parse($musique_info['contents']),
        'CREATION_DATE' => $creation_date->format(DATE_FORMAT_SHORT),
        'RELEASE_DATE' => $release_date->get_timestamp() > 0 ? $release_date->format(DATE_FORMAT_SHORT) : $MUSIQUE_LANG['unknown_date'],
        'SIZE' => $size_tpl,
        'COUNT' => $musique_info['count'],
        'THEME' => get_utheme(),
        'KERNEL_NOTATION' => $Note->display_form(),
        'HITS' => sprintf($MUSIQUE_LANG['n_times'], (int)$musique_info['count']),
        'NUM_NOTES' => sprintf($MUSIQUE_LANG['num_notes'], (int)$musique_info['nbrnote']),
        'U_IMG' => $musique_info['image'],
        'IMAGE_ALT' => str_replace('"', '"', $musique_info['title']),
        'LANG' => get_ulang(),
        'U_COM' => Comments::com_display_link($musique_info['nbr_com'], '../musique/musique' . url('.php?id=' . $file_id . '&com=0', '-' . $file_id . '+' . url_encode_rewrite($musique_info['title']) . '.php?com=0'), $file_id, 'musique'),
        'L_DATE' => $LANG['date'],
        'L_SIZE' => $LANG['size'],
        'L_MUSIQUE' => $MUSIQUE_LANG['musique'],
        'L_MUSIQUE_FILE' => $MUSIQUE_LANG['musique_file'],
        'L_FILE_INFOS' => $MUSIQUE_LANG['file_infos'],
        'L_INSERTION_DATE' => $MUSIQUE_LANG['insertion_date'],
        'L_RELEASE_DATE' => $MUSIQUE_LANG['last_update_date'],
        'L_MUSIQUEED' => $MUSIQUE_LANG['musiqueed'],
        'L_EDIT_FILE' => str_replace('"', '"', $MUSIQUE_LANG['edit_file']),
        'L_CONFIRM_DELETE_FILE' => str_replace(''', '\'', $MUSIQUE_LANG['confirm_delete_file']),
        'L_DELETE_FILE' => str_replace('"', '"', $MUSIQUE_LANG['delete_file']),
        'U_EDIT_FILE' => url('management.php?edit=' . $file_id),
        'U_DELETE_FILE' => url('management.php?del=' . $file_id . '&token=' . $Session->get_token()),
        'U_MUSIQUE_FILE' => url('count.php?id=' . $file_id, 'file-' . $file_id . '+' . url_encode_rewrite($musique_info['title']) . '.php')
    ));
 
    //Affichage commentaires.
    if (isset($_GET['com']))
    {
        $Template->assign_vars(array(
            'COMMENTS' => display_comments('musique', $file_id, url('musique.php?id=' . $file_id . '&com=%s', 'musique-' . $file_id . '.php?com=%s'))
        ));
    }
 
    $Template->pparse('musique');
}
else
{
    $Template->set_filenames(array('musique'=> 'musique/musique.tpl'));
 
    $Template->assign_vars(array(
        'C_ADMIN' => $auth_write,
        'C_MUSIQUE_CAT' => true,
        'C_ADD_FILE' => $auth_write || $auth_contribution,
        'C_DESCRIPTION' => !empty($MUSIQUE_CATS[$category_id]['contents']) || ($category_id == 0 && !empty($CONFIG_MUSIQUE['root_contents'])),
        'IDCAT' => $category_id,
        'TITLE' => sprintf($MUSIQUE_LANG['title_musique'] . ($category_id > 0 ? ' - ' . $MUSIQUE_CATS[$category_id]['name'] : '')),
        'DESCRIPTION' => $category_id > 0 ? second_parse($MUSIQUE_CATS[$category_id]['contents']) : second_parse($CONFIG_MUSIQUE['root_contents']),
        'L_ADD_FILE' => $MUSIQUE_LANG['add_file'],
        'U_ADMIN_CAT' => $category_id > 0 ? url('admin_musique_cat.php?edit=' . $category_id) : url('admin_musique_cat.php'),
        'U_ADD_FILE' => url('management.php?new=1&idcat=' . $category_id)
    ));
 
    //let's check if there are some subcategories
    $num_subcats = 0;
    foreach ($MUSIQUE_CATS as $id => $value)
    {
        if ($id != 0 && $value['id_parent'] == $category_id)
            $num_subcats ++;
    }
 
    //listing of subcategories
    if ($num_subcats > 0)
    {
        $Template->assign_vars(array(
            'C_SUB_CATS' => true
        ));    
 
        $i = 1;
 
        foreach ($MUSIQUE_CATS as $id => $value)
        {
            //List of children categories
            if ($id != 0 && $value['visible'] && $value['id_parent'] == $category_id && (empty($value['auth']) || $User->check_auth($value['auth'], MUSIQUE_READ_CAT_AUTH_BIT)))
            {
            $config_musique = array(
        'nbr_column' => retrieve(POST, 'nbr_column', 1),
    );                    $Template->assign_block_vars('row', array());
                $Template->assign_block_vars('row.list_cats', array(
                    'ID' => $id,
                    'NAME' => $value['name'],
                    'WIDTH' => floor(100 / (float)$CONFIG_MUSIQUE['nbr_column']),
                    'SRC' => $value['icon'],
                    'IMG_NAME' => addslashes($value['name']),
                    'NUM_FILES' => sprintf(((int)$value['num_files'] > 1 ? $MUSIQUE_LANG['num_files_plural'] : $MUSIQUE_LANG['num_files_singular']), (int)$value['num_files']),
                    'U_CAT' => url('musique.php?cat=' . $id, 'category-' . $id . '+' . url_encode_rewrite($value['name']) . '.php'),
                    'U_ADMIN_CAT' => url('admin_musique_cat.php?edit=' . $id),
                    'C_CAT_IMG' => !empty($value['icon'])
                ));
 
                $i++;
            }
        }
    }
 
    //Contenu de la catégorie    
    $nbr_files = (int)$Sql->query("SELECT COUNT(*) FROM " . PREFIX . "musique WHERE visible = 1 AND approved = 1 AND idcat = '" . $category_id . "'", __LINE__, __FILE__);
    if ($nbr_files > 0)
    {
        $get_sort = retrieve(GET, 'sort', '');    
        $get_mode = retrieve(GET, 'mode', '');
        $selected_fields = array(
            'alpha' => '',
            'size' => '',
            'date' => '',
            'hits' => '',
            'note' => '',
            'asc' => '',
            'desc' => ''
            );
 
        switch ($get_sort)
        {
            case 'alpha' : 
            $sort = 'title';
            $selected_fields['alpha'] = ' selected="selected"';
            break;    
            case 'size' : 
            $sort = 'size';
            $selected_fields['size'] = ' selected="selected"';
            break;            
            case 'date' : 
            $sort = 'timestamp';
            $selected_fields['date'] = ' selected="selected"';
            break;        
            case 'hits' : 
            $sort = 'count';
            $selected_fields['hits'] = ' selected="selected"';
            break;        
            case 'note' :
            $sort = 'note';
            $selected_fields['note'] = ' selected="selected"';
            break;
            default :
            $sort = 'timestamp';
            $selected_fields['date'] = ' selected="selected"';
        }
 
        $mode = ($get_mode == 'asc') ? 'ASC' : 'DESC';
        if ($mode == 'ASC')
            $selected_fields['asc'] = ' selected="selected"';
        else
            $selected_fields['desc'] = ' selected="selected"';
 
        $unget = (!empty($get_sort) && !empty($mode)) ? '?sort=' . $get_sort . '&mode=' . $get_mode : '';
 
        $Template->assign_vars(array(
            'L_FILE' => $MUSIQUE_LANG['file'],
            'L_ALPHA' => $MUSIQUE_LANG['sort_alpha'],
            'L_SIZE' => $LANG['size'],
            'L_DATE' => $LANG['date'],
            'L_MUSIQUE' => $MUSIQUE_LANG['musique'],
            'L_POPULARITY' => $MUSIQUE_LANG['popularity'],
            'L_DESC' => $LANG['desc'],
            'L_ASC' => $LANG['asc'],
            'L_NOTE' => $LANG['note'],
            'L_ORDER_BY' => $MUSIQUE_LANG['order_by'],
            'L_CONFIRM_DELETE_FILE' => str_replace(''', '\'', $MUSIQUE_LANG['confirm_delete_file']),
            'SELECTED_ALPHA' => $selected_fields['alpha'],
            'SELECTED_SIZE' => $selected_fields['size'],
            'SELECTED_DATE' => $selected_fields['date'],
            'SELECTED_HITS' => $selected_fields['hits'],
            'SELECTED_NOTE' => $selected_fields['note'],
            'SELECTED_ASC' => $selected_fields['asc'],
            'SELECTED_DESC' => $selected_fields['desc']
        ));
 
        //On crée une pagination si le nombre de fichiers est trop important.
        import('util/pagination'); 
        $Pagination = new Pagination();
 
        //Notes
        import('content/note');
        import('content/comments');
 
        $Template->assign_vars(array(
            'PAGINATION' => $Pagination->display(url('musique.php' . (!empty($unget) ? $unget . '&' : '?') . 'cat=' . $category_id . '&p=%d', 'category-' . $category_id . '-%d.php' . $unget), $nbr_files, 'p', $CONFIG_MUSIQUE['nbr_file_max'], 3),
            'C_FILES' => true,
            'TARGET_ON_CHANGE_ORDER' => $CONFIG['rewrite'] ? 'category-' . $category_id . '.php?' : 'musique.php?cat=' . $category_id . '&'
        ));
 
        $result = $Sql->query_while("SELECT id, title, timestamp, size, count, note, nbrnote, nbr_com, image, short_contents
        FROM " . PREFIX . "musique
        WHERE visible = 1 AND approved = 1 AND idcat = '" . $category_id . "'
        ORDER BY " . $sort . " " . $mode . 
        $Sql->limit($Pagination->get_first_msg($CONFIG_MUSIQUE['nbr_file_max'], 'p'), $CONFIG_MUSIQUE['nbr_file_max']), __LINE__, __FILE__);
        while ($row = $Sql->fetch_assoc($result))
        {
            $Template->assign_block_vars('file', array(            
                'NAME' => $row['title'],
                'IMG_NAME' => str_replace('"', '"', $row['title']),
                'C_DESCRIPTION' => !empty($row['short_contents']),
                'DESCRIPTION' => second_parse($row['short_contents']),
                'DATE' => sprintf($MUSIQUE_LANG['add_on_date'], gmdate_format('date_format_short', $row['timestamp'])),
                'COUNT_DL' => sprintf($MUSIQUE_LANG['musiqueed_n_times'], $row['count']),
                'NOTE' => $row['nbrnote'] > 0 ? Note::display_img((int)$row['note'], $CONFIG_MUSIQUE['note_max'], 5) : '<em>' . $LANG['no_note'] . '</em>',
                'SIZE' => ($row['size'] >= 1) ? number_round($row['size'], 1) . ' ' . $LANG['unit_megabytes'] : (number_round($row['size'], 1) * 1024) . ' ' . $LANG['unit_kilobytes'],
                'C_IMG' => !empty($row['image']),
                'IMG' => $row['image'],
                'U_MUSIQUE_LINK' => url('musique.php?id=' . $row['id'], 'musique-' . $row['id'] . '+' . url_encode_rewrite($row['title']) . '.php'),
                'U_ADMIN_EDIT_FILE' => url('management.php?edit=' . $row['id']),
                'U_ADMIN_DELETE_FILE' => url('management.php?del=' . $row['id'] . '&token=' . $Session->get_token()),
                'U_COM_LINK' => Comments::com_display_link($row['nbr_com'], '../musique/musique' . url('.php?id=' . $row['id'] . '&com=0', '-' . $row['id'] . '+' . url_encode_rewrite($row['title']) . '.php?com=0'), $row['id'], 'musique')
            ));
        }
        $Sql->query_close($result);
    }
    else
    {
        $Template->assign_vars(array(
            'L_NO_FILE_THIS_CATEGORY' => $MUSIQUE_LANG['none_musique'],
            'C_NO_FILE' => true
        ));
    }
 
    $Template->pparse('musique');
}
 
require_once('../kernel/footer.php'); 
 
?>