diff options
| author | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2007-01-21 03:22:45 +0000 |
|---|---|---|
| committer | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2007-01-21 03:22:45 +0000 |
| commit | 5a4fbeffbe12a6013f85d9d30aa29a60db77d9d7 (patch) | |
| tree | b16c62622ccd00b9832342f4b0427e24d1ec83e8 /lib/search.php | |
| parent | 4957be23099939f26aef84954c012488653111d0 (diff) | |
| download | ampache-5a4fbeffbe12a6013f85d9d30aa29a60db77d9d7.tar.gz ampache-5a4fbeffbe12a6013f85d9d30aa29a60db77d9d7.tar.bz2 ampache-5a4fbeffbe12a6013f85d9d30aa29a60db77d9d7.zip | |
few more tweaks for windows dirs and fixed comment searching
Diffstat (limited to 'lib/search.php')
| -rw-r--r-- | lib/search.php | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/lib/search.php b/lib/search.php index 3c6c6b42..99897ec7 100644 --- a/lib/search.php +++ b/lib/search.php @@ -166,7 +166,9 @@ function search_song($data,$operator,$method,$limit) { $where_sql .= " song.file $value_string $operator"; break; case 'comment': - $where_sql .= " song.comment $value_string $operator"; + $join_sql .= 'song.id=song_ext_data.song_id AND '; + $table_sql .= 'song_ext_data,'; + $where_sql .= " song_ext_data.comment $value_string $operator"; break; case 'played': /* This is a 0/1 value so bool it */ @@ -203,7 +205,7 @@ function search_song($data,$operator,$method,$limit) { $base_sql = "SELECT DISTINCT(song.id) $select_sql FROM song"; - $sql = $base_sql . $table_sql . " WHERE " . $join_sql . "(" . $where_sql . ")" . $group_sql . $limit_sql; + $sql = $base_sql . $table_sql . " WHERE " . $join_sql . " (" . $where_sql . ")" . $group_sql . $limit_sql; /** * Because we might need this for Dynamic Playlist Action |