Home

$sql_query
" . mysql_error() . "

\n"; exit(); } return mysql_fetch_array($result); } // Used to sort playlists first function _fid_search_sort($a, $b) { $a_playlist = is_playlist($a); $b_playlist = is_playlist($b); if ($a_playlist == $b_playlist) return 0; if ($a_playlist) return -1; if ($b_playlist) return 1; return 0; } // Find a FID by artist/title/source function fid_search($search_query) { global $sql_tablename; $sql_query = "SELECT fid FROM $sql_tablename WHERE "; $sql_query .= "((artist LIKE '%" . $search_query . "%') OR "; $sql_query .= "(title LIKE '%" . $search_query . "%') OR "; $sql_query .= "(source LIKE '%" . $search_query . "%'))"; if (($result = mysql_query($sql_query)) == FALSE) { echo "Unable to retrieve playlist $fid
$sql_query
" . mysql_error() . "

\n"; exit(); } $found_fids = array(); while (($row = mysql_fetch_array($result)) != NULL) { $found_fids[] = $row['fid']; } usort($found_fids, "_fid_search_sort"); return $found_fids; } // Get the contents of a playlist by FID function get_playlist_contents_by_fid($fid) { $result = get_fid($fid); return explode(",", $result['contents']); } // Is this FID a playlist? function is_playlist($fid) { $result = get_fid($fid); if ($result['type'] == "playlist") return true; else return false; } // Display playlist by array of FIDs function display_playlist($contents) { foreach ($contents as $sub_fid) { // Hide unattached items if ($sub_fid == 17) continue; $result = get_fid($sub_fid); if (($i++ % 2) == 0) { echo " \n"; } else { echo " \n"; } if (is_playlist($sub_fid)) { echo " "; echo " "; echo " "; echo " "; echo " "; } else { echo " "; echo " "; echo " "; echo " "; echo " "; } echo " \n"; } } $sql = mysql_pconnect($sql_server, $sql_username, $sql_password); if (mysql_select_db($sql_database, $sql) == FALSE) { print("Unable to select database.\n"); exit(); } if ($search) { display_playlist(fid_search($search)); } else { display_playlist(get_playlist_contents_by_fid($fid)); } mysql_close($sql); ?>
Artist Source Title Length Type
" . $result['artist'] . "" . $result['source'] . "" . $result['title'] . "" . $result['length'] / 4 . "" . $result['type'] . "" . $result['artist'] . "" . $result['source'] . "" . $result['title'] . "" . strftime("%M:%S", ($result['duration'] / 1000)) . "" . $result['type'] . "