4
global $data,$meta_name;
5
$query = "SELECT name,metadata,composer_id,type_id FROM songs WHERE id={$_GET['id']}";
6
$result = mysql_query($query);
10
echo('<div class="error">error in query ' . $query . ' ' . mysql_error()."</div>");
15
for($i = 0;$row = mysql_fetch_array($result);$i ++)
17
$metadata = explode("|",$row['metadata']);
18
foreach($metadata as $meta)
20
list($data[$i]["field"],$data[$i]["value"]) = explode("=",$meta);
23
$data[$i]["field"] = "composer";
24
$data[$i]["value"] = $row["composer_id"];
26
$data[$i]["field"] = "type";
27
$data[$i]["value"] = $row["type_id"];
29
$meta_name = $row["name"];
34
function do_action($action,$id,$field,$value)
36
$query = "SELECT metadata,composer_id,type_id FROM songs WHERE id='{$_GET['id']}'";
37
$result = mysql_query($query);
41
echo('<div class="error">error in query ' . $query . ' ' . mysql_error()."</div>");
46
for($i = 0;$row = mysql_fetch_array($result);$i ++)
48
$metadata = explode("|",$row['metadata']);
49
foreach($metadata as $meta)
51
list($data[$i]["field"],$data[$i]["value"]) = explode("=",$meta);
54
$data[$i]["field"] = "composer";
55
$data[$i]["value"] = $row["composer_id"];
57
$data[$i]["field"] = "type";
58
$data[$i]["value"] = $row["type_id"];
62
$query = "UPDATE songs SET metadata='";
63
if($action == "delete")
65
foreach($data as $meta)
67
if($meta["field"] != "composer" && $meta["field"] != "type")
68
if($meta["field"] != $_GET["field"] && $meta["value"] != "")
70
$metadata[] = $meta["field"]."=".$meta["value"];
76
foreach($data as $meta)
78
if($meta["field"] != "composer" && $meta["field"] != "type")
79
if($meta["field"] != $_GET["field"] && $meta["value"] != "")
81
$metadata[] = $meta["field"]."=".$meta["value"];
84
if($_GET["field"] != "composer" && $_GET["field"] != "type")
85
$metadata[] = $_GET["field"]."=".$_GET["value"];
87
$query .= join("|",$metadata);
89
if($field == "composer")
90
$query .= ",composer_id='$value' ";
92
$query .= ",type_id='$value' ";
93
$query .= "WHERE id='{$_GET['id']}'";
95
if($action == "delete" || $action == "add")
96
if(!mysql_query($query))
97
$error[] = "provider-composer -- Cannot execute query: ".mysql_error();
b'\\ No newline at end of file'