<?php
}
?>
<th class="cel_action essential"><?php
echo T_('Actions');
?>
</th>
</tr>
</thead>
<tbody>
<?php
if (AmpConfig::get('ratings')) {
Rating::build_cache('podcast', $object_ids);
}
if (AmpConfig::get('userflags')) {
Userflag::build_cache('podcast', $object_ids);
}
foreach ($object_ids as $podcast_id) {
$libitem = new Podcast($podcast_id);
$libitem->format();
?>
<tr id="podcast_<?php
echo $libitem->id;
?>
" class="<?php
echo UI::flip_class();
?>
">
<?php
require AmpConfig::get('prefix') . UI::find_template('show_podcast_row.inc.php');
?>
if (User::is_registered()) {
?>
<?php
if (AmpConfig::get('ratings')) {
Rating::build_cache('song', array_map(create_function('$i', '$i=(array) $i; return $i[\'object_id\'];'), $object_ids));
?>
<th class="cel_rating"><?php
echo T_('Rating');
?>
</th>
<?php
}
?>
<?php
if (AmpConfig::get('userflags')) {
Userflag::build_cache('song', array_map(create_function('$i', '$i=(array) $i; return $i[\'object_id\'];'), $object_ids));
?>
<?php
}
?>
<th class="cel_userflag essential"><?php
echo T_('Fav.');
?>
</th>
<?php
}
?>
<th class="cel_action essential"><?php
echo T_('Action');
?>
</th>
<?php
if (AmpConfig::get('ratings')) {
++$thcount;
Rating::build_cache('song', $object_ids);
?>
<th class="cel_rating optional"><?php
echo T_('Rating');
?>
</th>
<?php
}
?>
<?php
if (AmpConfig::get('userflags')) {
++$thcount;
Userflag::build_cache('song', $object_ids);
?>
<th class="cel_userflag optional"><?php
echo T_('Fav.');
?>
</th>
<?php
}
?>
<th class="cel_action essential"><?php
echo T_('Action');
?>
</th>
<?php
if (isset($argument) && $argument) {
++$thcount;
}
?>
<th class="cel_action essential"><?php
echo T_('Action');
?>
</th>
</tr>
</thead>
<tbody>
<?php
// Cache the ratings we are going to use
if (AmpConfig::get('ratings')) {
Rating::build_cache('tvshow', $object_ids);
}
if (AmpConfig::get('userflags')) {
Userflag::build_cache('tvshow', $object_ids);
}
/* Foreach through every tv show that has been passed to us */
foreach ($object_ids as $tvshow_id) {
$libitem = new TVShow($tvshow_id);
$libitem->format();
?>
<tr id="tvshow_<?php
echo $libitem->id;
?>
" class="<?php
echo UI::flip_class();
?>
">
<?php
require AmpConfig::get('prefix') . UI::find_template('show_tvshow_row.inc.php');
}
?>
<th class="cel_action essential"><?php
echo T_('Action');
?>
</th>
</tr>
</thead>
<tbody>
<?php
// Cache the ratings we are going to use
if (AmpConfig::get('ratings')) {
Rating::build_cache('artist', $object_ids);
}
if (AmpConfig::get('userflags')) {
Userflag::build_cache('artist', $object_ids);
}
/* Foreach through every artist that has been passed to us */
foreach ($object_ids as $artist_id) {
$artist = new Artist($artist_id, $_SESSION['catalog']);
$artist->format();
?>
<tr id="artist_<?php
echo $artist->id;
?>
" class="<?php
echo UI::flip_class();
?>
">
<?php
require AmpConfig::get('prefix') . '/templates/show_artist_row.inc.php';
<?php
}
?>
<th class="cel_action essential"><?php
echo T_('Actions');
?>
</th>
</tr>
</thead>
<tbody>
<?php
if (AmpConfig::get('ratings')) {
Rating::build_cache('album', $object_ids);
}
if (AmpConfig::get('userflags')) {
Userflag::build_cache('album', $object_ids);
}
/* Foreach through the albums */
foreach ($object_ids as $album_id) {
$album = new Album($album_id);
$album->allow_group_disks = $allow_group_disks;
$album->format();
?>
<tr id="album_<?php
echo $album->id;
?>
" class="<?php
echo UI::flip_class();
?>
">
<?php
<?php
}
?>
<th class="cel_action essential"><?php
echo T_('Actions');
?>
</th>
</tr>
</thead>
<tbody>
<?php
if (AmpConfig::get('ratings')) {
Rating::build_cache('podcast_episode', $object_ids);
}
if (AmpConfig::get('userflags')) {
Userflag::build_cache('podcast_episode', $object_ids);
}
foreach ($object_ids as $episode_id) {
$libitem = new Podcast_Episode($episode_id);
$libitem->format();
?>
<tr id="podcast_episode_<?php
echo $libitem->id;
?>
" class="<?php
echo UI::flip_class();
?>
">
<?php
require AmpConfig::get('prefix') . UI::find_template('show_podcast_episode_row.inc.php');
?>
/**
* build_cache
*
* This attempts to reduce queries by asking for everything in the
* browse all at once and storing it in the cache, this can help if the
* db connection is the slow point.
* @param int[] $song_ids
* @return boolean
*/
public static function build_cache($song_ids, $limit_threshold = '')
{
if (!is_array($song_ids) || !count($song_ids)) {
return false;
}
$idlist = '(' . implode(',', $song_ids) . ')';
// Callers might have passed array(false) because they are dumb
if ($idlist == '()') {
return false;
}
// Song data cache
$sql = 'SELECT `song`.`id`, `file`, `catalog`, `album`, ' . '`year`, `artist`, `title`, `bitrate`, `rate`, ' . '`mode`, `size`, `time`, `track`, `played`, ' . '`song`.`enabled`, `update_time`, `tag_map`.`tag_id`, ' . '`mbid`, `addition_time`, `license`, `composer`, `user_upload` ' . 'FROM `song` LEFT JOIN `tag_map` ' . 'ON `tag_map`.`object_id`=`song`.`id` ' . "AND `tag_map`.`object_type`='song' ";
if (AmpConfig::get('catalog_disable')) {
$sql .= "LEFT JOIN `catalog` ON `catalog`.`id` = `song`.`catalog` ";
}
$sql .= "WHERE `song`.`id` IN {$idlist} ";
if (AmpConfig::get('catalog_disable')) {
$sql .= "AND `catalog`.`enabled` = '1' ";
}
$db_results = Dba::read($sql);
$artists = array();
$albums = array();
$tags = array();
while ($row = Dba::fetch_assoc($db_results)) {
if (AmpConfig::get('show_played_times')) {
$row['object_cnt'] = Stats::get_object_count('song', $row['id'], $limit_threshold);
}
parent::add_to_cache('song', $row['id'], $row);
$artists[$row['artist']] = $row['artist'];
$albums[$row['album']] = $row['album'];
if ($row['tag_id']) {
$tags[$row['tag_id']] = $row['tag_id'];
}
}
Artist::build_cache($artists);
Album::build_cache($albums);
Tag::build_cache($tags);
Tag::build_map_cache('song', $song_ids);
Art::build_cache($albums);
// If we're rating this then cache them as well
if (AmpConfig::get('ratings')) {
Rating::build_cache('song', $song_ids);
}
if (AmpConfig::get('userflags')) {
Userflag::build_cache('song', $song_ids);
}
// Build a cache for the song's extended table
$sql = "SELECT * FROM `song_data` WHERE `song_id` IN {$idlist}";
$db_results = Dba::read($sql);
while ($row = Dba::fetch_assoc($db_results)) {
parent::add_to_cache('song_data', $row['song_id'], $row);
}
return true;
}
