summaryrefslogtreecommitdiffstats
path: root/modules
diff options
context:
space:
mode:
authorKarl 'vollmerk' Vollmer <vollmer@ampache.org>2005-09-08 18:02:12 +0000
committerKarl 'vollmerk' Vollmer <vollmer@ampache.org>2005-09-08 18:02:12 +0000
commitbacb5b9a62c475d6583dd3cec87b169859a27335 (patch)
treec689672b42bd18d3ff344b1321158ed547fb563e /modules
parent23fdc1659cf38e895e76a4f0b4767221db464bfa (diff)
downloadampache-bacb5b9a62c475d6583dd3cec87b169859a27335.tar.gz
ampache-bacb5b9a62c475d6583dd3cec87b169859a27335.tar.bz2
ampache-bacb5b9a62c475d6583dd3cec87b169859a27335.zip
new search mojo, only song object type current works...
Diffstat (limited to 'modules')
-rw-r--r--modules/lib.php111
1 files changed, 2 insertions, 109 deletions
diff --git a/modules/lib.php b/modules/lib.php
index 32ebe0bf..42206e3a 100644
--- a/modules/lib.php
+++ b/modules/lib.php
@@ -466,6 +466,7 @@ function get_songs_from_type ($type, $results, $artist_id = 0) {
was really handy in getting added functionality at no cost.
/* Lets tie it to album too, so we can show art ;) */
/*********************************************************/
+/* One symbol, m(__)m */
function show_songs ($song_ids, $playlist_id=0, $album=0) {
$dbh = dbh();
@@ -487,7 +488,7 @@ function show_songs ($song_ids, $playlist_id=0, $album=0) {
require (conf('prefix') . "/templates/show_songs.inc");
- return TRUE;
+ return true;
}// function show_songs
@@ -1037,44 +1038,6 @@ function show_confirm_action ($text, $script, $arg) {
} // show_confirm_action
-// search functions
-function search_by_type ($type, $search) {
-
- $dbh = dbh();
-
- // supported types are album, artist and song
- if ( $type == 'Album' ) {
- $query = "SELECT id FROM album WHERE name LIKE '%$search%'";
- }
- elseif ( $type == 'Artist' ) {
- $query = "SELECT id FROM artist WHERE name LIKE '%$search%'";
- }
- elseif ( $type == 'Song title' ) {
- $query = "SELECT id FROM song WHERE title LIKE '%$search%'";
- }
- elseif ( $type == 'Genre' ) {
- $query = "SELECT song.id as id FROM song, genre" .
- " WHERE song.genre = genre.id" .
- " AND genre.name LIKE '%$search%'";
- }
-
- $db_result = mysql_query($query, $dbh);
-
- $search_result = array();
-
- while ( $r = mysql_fetch_array($db_result) ) {
- $search_result[] = $r;
- }
-
- return ($search_result);
-}
-
-function scrub_out($str) {
-
- return stripslashes($str);
-}
-
-
function unhtmlentities ($string) {
$trans_tbl = get_html_translation_table (HTML_ENTITIES);
@@ -1083,74 +1046,4 @@ function unhtmlentities ($string) {
return preg_replace('/&#(\d+);/me', "chr('\\1')",$ret);
}
-
-function insert_album($album) {
-
- global $settings;
- $dbh = dbh();
-
- preg_match("/^(A |An |The ){0,1}(.*?)$/i",$album, $matches);
- $album = sql_escape($matches[2]);
-
- switch($matches[1]) {
- case 'The ':
- case 'the ':
- $prefix = 'The';
- break;
- case 'A ':
- case 'a ':
- $prefix = 'A';
- break;
- case 'An ':
- case 'an ':
- $prefix = 'An';
- break;
- default:
- $prefix = '';
- }
-
- $sql = "INSERT INTO album (name, prefix)" .
- " VALUES ( '$album', '$prefix' )";
- $db_result = mysql_query($sql, $dbh);
-
- return (mysql_insert_id($dbh));
-} // insert_album
-
-
-/*
- * insert_artist()
- *
- */
-
-function insert_artist($artist) {
-
- global $settings;
- $dbh = dbh();
-
- $matches = array();
- $var = preg_match('/^(A |An |The ){0,1}(.*?)$/i',$artist, $matches);
- $artist = sql_escape($matches[2]);
-
- switch($matches[1]) {
- case 'The ':
- case 'the ':
- $prefix = 'The';
- break;
- case 'A ':
- case 'a ':
- $prefix = 'A';
- break;
- case 'An ':
- case 'an ':
- $prefix = 'An';
- break;
- default:
- $prefix = '';
- }
-
- $sql = "INSERT INTO artist (name, prefix)" .
- " VALUES ( '$artist', '$prefix' )";
- $db_result = mysql_query($sql, $dbh);
- return (mysql_insert_id($dbh));
-} // insert_artist
?>