$stmt = $db->prepare("update song set lyrics = :lyrics where id = :id;");
$stmt->bindParam("lyrics", $lyrics, PDO::PARAM_STR);
$stmt->bindParam("id", $song_id, PDO::PARAM_INT);
$stmt->execute();
$stmt->closeCursor();
# ARTWORK
Album::storeArtworkFromAPI($album_id);
# KNOWN
$stmt = $db->prepare("insert into know (user, song, owned, date) values (:user, :song, 0, unix_timestamp());");
$stmt->bindParam("user", $_SESSION['user']->getId(), PDO::PARAM_INT);
$stmt->bindParam("song", $song_id, PDO::PARAM_INT);
$stmt->execute();
$stmt->closeCursor();
$n++;
}
Page::goAlbum($album_id);
}
# Process grade comment
/**
*
* @author Antoine De Gieter
*
*/
if (isset($_SESSION['online']) && (isset($_POST['agree']) || isset($_POST['disagree'])) && isset($_POST['userComment']) && isset($_POST['songComment'])) {
$agreement = isset($_POST['agree']) ? 1 : 0;
$user = $_SESSION['user']->getId();
$userComment = $_POST['userComment'];
$songComment = $_POST['songComment'];
if ($user != $userComment) {
GradeComment::create($user, $userComment, $songComment, $agreement);
}
