/**
*get PHPlib variables for a song
*
*
*/
function dok_song_format($data, $pager_infos = '')
{
global $THEME_DATE, $THEME_SONG_LABEL;
$label = dok_song_label_vars($data['label']);
$ret = $label;
$ret['SONG_NAME'] = $data['name'];
$ret['SONG_ID'] = $data['id'];
$ret['SONG_HITS'] = $data['hits'];
$ret['SONG_LINK'] = $_SERVER['PHP_SELF'] . '?display=view_song&id=' . $data['id'];
if (is_array($pager_infos)) {
$ret['SONG_LINK'] .= '&pager_related=' . $pager_infos['related'] . '&pager_related_id=' . $pager_infos['related_id'];
}
$ret['SONG_ARTIST'] = dok_get_artists_string($data['id'], $data['ignore_artist']);
$ret['SONG_LENGTH'] = dok_sec2str($data['length']);
$ret['SONG_RELEASE'] = dok_year2str($data['release']);
$ret['SONG_COMMENT'] = $data['comment'];
$ret['SONG_DB_CREATION'] = date($THEME_DATE, $data['creation']);
$ret['SONG_GENRE'] = dok_genre_name($data['genre']);
if ($data['label'] > 0) {
$t = new template(getcwd());
$t->set_var('song_label', $THEME_SONG_LABEL);
$t->set_var($label);
$ret['SONG_LABEL_LINE'] = $t->finish($t->parse('out', 'song_label'));
} else {
$ret['SONG_LABEL_LINE'] = '';
}
//print_r($ret);
return $ret;
}
function dok_ask_dup_song($VARS, $update, $theme_path)
{
global $SONGS_LABELS;
if (!is_array($VARS['duplicates']) || !sizeof($VARS['duplicates'])) {
$t = dok_error_template(MSG_ERR_NO_DUP_SONG);
return array($t, sprintf(MSG_TITLE_DUP_SONG, ''));
}
if (!$VARS['label'] || $VARS['label'] == 0) {
$new_song_label = MSG_LABEL_NONE;
} else {
$new_song_label = $SONGS_LABELS[$VARS['label']]['label'];
}
if (!$VARS['track'] || $VARS['track'] == 0) {
$new_song_track = MSG_ALBUM_NEXT_TRACK;
} else {
$new_song_track = $VARS['track'];
}
/*
*find related songs
*
*/
//$res = dok_oquery('select * from '.dok_tn('rel_songs').' where song_id1 =
$t = new template($theme_path);
$t->set_file('page', 'song_dup.tpl');
$t->set_block('page', 'duplicate', 'dup_block');
$query = 'select * from ' . dok_tn('song') . ' where id in(' . implode(',', $VARS['duplicates']) . ')';
$res = mysql_query($query);
$relations = dok_songs_links_array();
while ($row = mysql_fetch_array($res)) {
$t->set_var(dok_song_format($row));
$relations_select = '<select name="link[' . $row['id'] . ']"><option value="" SELECTED>' . MSG_RELATION_NONE . '</option>' . "\n";
foreach ($relations as $key => $val) {
$relations_select .= '<option value="' . $key . '">' . $val . '</option>' . "\n";
}
$relations_select .= '</select>';
$t->set_var('SONG_RELATION_SELECT', $relations_select);
$t->parse('dup_block', 'duplicate', 'true');
}
if ($update == 'create_song') {
$res = mysql_query('select name from ' . dok_tn('album') . ' where id = ' . $VARS['album']);
if (!mysql_numrows($res)) {
$album = MSG_UNKNOWN;
} else {
$album = mysql_result($res, 0, 'name');
}
$res = mysql_query('select name from ' . dok_tn('artist') . ' where id = ' . $VARS['artist']);
if (!mysql_numrows($res)) {
$artist = MSG_UNKNOWN;
} else {
$artist = mysql_result($res, 0, 'name');
}
$t->set_var(array('NEW_SONG_NAME' => $VARS['name'], 'NEW_SONG_COMMENT' => dok_textarea_2_db($VARS['comment']), 'NEW_SONG_TRACK' => $new_song_track, 'NEW_SONG_LENGTH' => $VARS['length'], 'NEW_SONG_LABEL' => $new_song_label, 'NEW_SONG_ARTIST' => $artist, 'NEW_SONG_ALBUM' => $album, 'NEW_SONG_GENRE' => dok_genre_name($VARS['genre']), 'NEW_SONG_RELEASE' => dok_year2str($VARS['release'])));
} else {
$t->set_var(array('NEW_SONG_NAME' => $VARS['name'], 'NEW_SONG_COMMENT' => dok_textarea_2_db($VARS['comment']), 'NEW_SONG_TRACK' => $new_song_track, 'NEW_SONG_LENGTH' => dok_sec2str($VARS['length']), 'NEW_SONG_GENRE' => dok_genre_name($VARS['genre']), 'NEW_SONG_LABEL' => $new_song_label, 'NEW_SONG_ARTIST' => '', 'NEW_SONG_ALBUM' => '', 'NEW_SONG_RELEASE' => dok_year2str($VARS['release'])));
}
$yes_form = '<form method="post" action="' . $_SERVER['PHP_SELF'] . '"><input type=hidden name="update" value="' . $update . '">';
$yes_form .= '<input type=hidden name="dup_checked" value="1">';
if ($update == 'update_song') {
$yes_form .= '<input type=hidden name="id" value="' . $VARS['id'] . '">';
}
$yes_form .= '<input type=hidden name="artist" value="' . $VARS['artist'] . '">';
$yes_form .= '<input type=hidden name="album" value="' . $VARS['album'] . '">';
$yes_form .= '<input type=hidden name="track" value="' . str_replace('"', '"', $VARS['track']) . '">';
$yes_form .= '<input type=hidden name="name" value="' . str_replace('"', '"', $VARS['name']) . '">';
$yes_form .= '<input type=hidden name="length" value="' . str_replace('"', '"', $VARS['length']) . '">';
$yes_form .= '<input type=hidden name="release" value="' . str_replace('"', '"', $VARS['release']) . '">';
$yes_form .= '<input type=hidden name="comment" value="' . str_replace('"', '"', $VARS['comment']) . '">';
$yes_form .= '<input type=hidden name="label" value="' . str_replace('"', '"', $VARS['label']) . '">';
$yes_form .= '<input type=hidden name="genre" value="' . $VARS['genre'] . '">';
$t->set_var('SONG_RECORD_FORM', $yes_form);
return array($t, MSG_TITLE_DUP_SONG);
}