2
function songRetrieve($sessid)
6
$query = "SELECT id, name, metadata, composer_id, type_id FROM songs";
7
$result = mysql_query($query);
11
return new xmlrpcresp(0,$xmlrpcerruser+1,"Opvragen van types mislukt: ".mysql_error());
16
while($row = mysql_fetch_assoc($result))
22
foreach($array as $item)
24
$meta = explode("|",$item["metadata"]);
26
foreach($meta as $metaitem)
28
list($field,$value) = explode("=",$metaitem);
29
$metaarray[$field] = $value;
33
"name" => $item["name"],
34
"composer" => $item["composer_id"],
35
"type" => $item["type_id"],
36
"metadata" => $metaarray,
43
function songOne($sessid,$id )
45
global $xmlrpcerruser;
47
$query = "SELECT id, name, metadata, composer_id, type_id FROM songs WHERE id='$id'";
48
$result = mysql_query($query);
52
return new xmlrpcresp(0,$xmlrpcerruser+1,"Opvragen van types mislukt: ".mysql_error());
57
while($row = mysql_fetch_assoc($result))
63
foreach($array as $item)
65
$meta = explode("|",$item["metadata"]);
67
foreach($meta as $metaitem)
69
list($field,$value) = explode("=",$metaitem);
70
$metaarray[$field] = $value;
74
"name" => $item["name"],
75
"composer" => $item["composer_id"],
76
"type" => $item["type_id"],
77
"metadata" => $metaarray,
84
function songFree($sessid)
86
global $xmlrpcerruser;
88
$query = "SELECT id FROM songs";
89
$result = mysql_query($query);
93
return new xmlrpcresp(0,$xmlrpcerruser+1,"Opvragen van types mislukt: ".mysql_error());
97
while($row = mysql_fetch_assoc($result))
104
while($i < count($ids))
119
function songSet($sessid,$data)
122
$name = $data["name"];
123
$composer = $data["composer"];
124
$type = $data["type"];
125
$metadata = $data["metadata"];
126
global $xmlrpcerruser;
127
if(!checkSession($sessid))
128
return new xmlrpcresp(0,$xmlrpcerruser+3,"Ongeldige sessie");
130
if(!checkLevel($sessid,-1))
131
return new xmlrpcresp(0,$xmlrpcerruser+4,"Niet bevoegd of niet ingelogd");
133
$metaarray = array();
134
foreach($metadata as $field => $value)
136
$metaarray[] = "$field=$value";
139
$metastring = join("|",$metaarray);
141
$query = "UPDATE songs SET name='$name', composer_id='$composer', type_id='$type' , metadata='$metastring' WHERE id='$id'";
142
$result = mysql_query($query);
144
return array("id" => $id,
146
"composer" => $composer,
148
"metadata" => $metadata,
152
function songRem($sessid,$data)
155
$name = $data["name"];
156
$metadata = $data["metadata"];
157
global $xmlrpcerruser;
158
if(!checkSession($sessid))
159
return new xmlrpcresp(0,$xmlrpcerruser+3,"Ongeldige sessie");
161
if(!checkLevel($sessid,-1))
162
return new xmlrpcresp(0,$xmlrpcerruser+4,"Niet bevoegd of niet ingelogd");
164
$query = "DELETE FROM songs WHERE id='$id'";
165
$result = mysql_query($query);
167
return array("id" => $id,
169
"composer" => $item["composer_id"],
170
"type" => $item["type_id"],
171
"metadata" => $metadata,
176
function songAdd($sessid,$data)
179
$name = $data["name"];
180
$composer = $data["composer"];
181
$type = $data["type"];
182
$metadata = $data["metadata"];
183
global $xmlrpcerruser;
184
if(!checkSession($sessid))
185
return new xmlrpcresp(0,$xmlrpcerruser+3,"Ongeldige sessie");
187
if(!checkLevel($sessid,-1))
188
return new xmlrpcresp(0,$xmlrpcerruser+4,"Niet bevoegd of niet ingelogd");
190
$metaarray = array();
191
foreach($metadata as $field => $value)
193
$metaarray[] = "$field=$value";
196
$metastring = join("|",$metaarray);
198
$query = "INSERT INTO songs (id,name,composer_id,type_id,metadata) VALUE ('$id','$name','$composer','$type', '$metastring')";
199
$result = mysql_query($query);
201
return array("id" => $id,
203
"composer" => $item["composer_id"],
204
"type" => $item["type_id"],
205
"metadata" => $metadata,
b'\\ No newline at end of file'