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)))
{
if ( $i % $CONFIG_MUSIQUE['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'); 
 
?>
 

$config_musique = array(
'nbr_column' => retrieve(POST, 'nbr_column', 1),
);

'WIDTH' => floor(100 / (float)$CONFIG_MUSIQUE['nbr_column']),
 

'WIDTH' => floor(100 / (float)$CONFIG_MUSIQUE = array(
'nbr_column' => retrieve(POST, 'nbr_column', 1),
);
 

$nbr_column = ($CONFIG_MUSIQUE['nbr_column'] == 0) ? 1 : $CONFIG_MUSIQUE['nbr_column'];

$nbr_column

$CONFIG_MUSIQUE['nbr_column']