1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
<?php
/*
Copyright (c) 2001 - 2006 Ampache.org
All Rights Reserved
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
This library handles all artist mojo
*/
/*!
@function get_artists
@discussion run a search, takes string,field,type and returns an array
of results of the correct type (song, album, artist)
*/
function get_artists($sql, $action=0) {
$db_results = mysql_query($sql, dbh());
while ($r = mysql_fetch_array($db_results)) {
$artist_info = get_artist_info($r['id']);
if ($action ==='format') { $artist = format_artist($artist_info); }
else { $artist = $artist_info; }
$artists[] = $artist;
} // end while
return $artists;
} // get_artists
/*!
@function format_artist
@discussion this function takes an array of artist
information and reformats the relevent values
so they can be displayed in a table for example
it changes the title into a full link.
*/
function format_artist($artist) {
$web_path = conf('web_path');
$artist['name'] = "<a href=\"$web_path/artists.php?action=show&artist=" . $artist['id'] . "\">" . htmlspecialchars($artist['prefix']) . " " . htmlspecialchars($artist['name']) . "</a>";
return $artist;
} // format_artist
/*!
@function show_artists
@discussion takes a match and accounts for the possiblity of a view
then displays _many_ artists
*/
function show_artists ($match = '') {
global $settings;
$dbh = dbh();
$view = new View();
$view->import_session_view();
// Check for the view object...
if ($_REQUEST['keep_view']) {
$view->initialize();
}
// If there isn't a view object we need to create a new one..
else {
if ( isset($match) && $match != '' ) {
$query = "SELECT id,name FROM artist " .
" WHERE name LIKE '$match%' ";
}
else {
$query = "SELECT id FROM artist ";
}
$db_results = mysql_query($query, $dbh);
$total_items = mysql_num_rows($db_results);
if ($_REQUEST['match'] === "Show_all") {
$offset_limit = 999999;
}
else {
$offset_limit = $_SESSION['userdata']['offset_limit'];
}
$view = new View($query,'artists.php','name',$total_items,$offset_limit);
} // end if creating view object
if (is_array($match)) {
$artists = $match;
$_SESSION['view_script'] = false;
}
$db_results = mysql_query($view->sql, $dbh);
while ($r = @mysql_fetch_array($db_results)) {
//FIXME: This seriously needs to be updated to use the artist object
$artist_info = get_artist_info($r[0]);
$artist = format_artist($artist_info);
// Only Add this artist if there is information to go along with it
if ($artist_info) {
$artists[] = $artist;
}
}
if (count($artists)) {
require ( conf('prefix') . "/templates/show_artists.inc");
}
} // show_artists
?>
|
