'' ". " GROUP BY title"; if ($search_type=="artist_title"||$search_type=="artist_album_title") $sql = $sql.",artist"; if ($search_type=="artist_album_title") $sql = $sql.",album"; $sql = $sql." HAVING count(title) > 1"; $sql = $sql." ORDER BY ctitle"; //echo $sql."
"; $result = mysql_query($sql, dbh()); $arr = array(); while ($flag = mysql_fetch_array($result)) { $arr[] = $flag; } // end while return $arr; } // get_duplicate_songs /*! @function get_duplicate_info @discussion */ function get_duplicate_info($song,$search_type) { $artist = get_artist_name($song->artist); $sql = "SELECT song.id as songid,song.title as song,file,bitrate,size,time,album.name AS album,album.id as albumid, artist.name AS artist,artist.id as artistid". " FROM song,artist,album ". " WHERE song.artist=artist.id AND song.album=album.id ". " AND song.title= '".str_replace("'","''",$song->title)."'"; if ($search_type=="artist_title"||$search_type=="artist_album_title") $sql = $sql." AND artist.id = '".$song->artist."'"; if ($search_type=="artist_album_title") $sql = $sql." AND album.id = '".$song->album."'"; $result = mysql_query($sql, dbh()); $arr = array(); while ($flag = mysql_fetch_array($result)) { $arr[] = $flag; } // end while return $arr; } // get_duplicate_info /*! @function show_duplicate_songs @discussion */ function show_duplicate_songs($flags,$search_type) { require_once(conf('prefix').'/templates/list_duplicates.inc'); } // show_duplicate_songs /*! @function show_duplicate_searchbox @discussion */ function show_duplicate_searchbox($search_type) { ?>

:	" . _("Title") . " "; if ($search_type=="artist_title") $checked = "checked=\"checked\""; else $checked = ""; echo "" . _("Artist and Title") . " "; if ($search_type=="artist_album_title"OR $search_type=="") $checked = "checked=\"checked\""; else $checked = ""; echo "" . _("Artist, Album and Title") . " "; ?>
	" />