$freetag_options = array('db_user' => 'root', 'db_pass' => '', 'db_host' => 'localhost', 'db_name' => 'tunequeue');
$freetag = new freetag($freetag_options);
$userid = 1;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print "<tr align='center'><td>\n";
print $line['title'] . "</td><td>\n";
print $line['fullpath'] . "</td><td>\n";
$artist_name = get_artist_name($line['artistid']);
print $artist_name . "</td><td>\n";
print $line['album'] . "</td><td>\n";
print $line['time'] . "</td>\n";
/*Only tag by the super musician/user*/
print "<td><a href='edit-song.php?edit=1&showid=-1&id=" . $line['ID'] . "'>Edit</a> /\n";
print "<a href='edit-song.php?remove=1&showid=-1&id=" . $line['ID'] . "'>Remove</a></td>\n";
print "<td>\n";
$tagArray = $freetag->get_tags_on_object($line['ID'], 0, 0, $userid);
if (count($tagArray) > 0) {
foreach ($tagArray as $tag) {
if ($tag['tagger_id'] == $userid) {
print htmlspecialchars($tag['raw_tag']);
} else {
print htmlspecialchars($tag['tag']);
}
print " ";
}
}
print "</td>\n";
print "</tr>";
}
}
?>
