/** FOR USE BY review_backend.php (mode INSERT) **/ function reviewAlbum($albumID, $album_name, $album_code, $artist_name, $label, $genre, $general_genreID, $review, $username, $reviewer, $rotation) { if (!is_numeric($albumID)) { return FALSE; } if (!is_numeric($general_genreID)) { return FALSE; } $album_name = mysql_real_escape_string($album_name); $genre = mysql_real_escape_string($genre); $review = mysql_real_escape_string($review); $username = mysql_real_escape_string($username); $reviewer = mysql_real_escape_string($reviewer); $rotation = mysql_real_escape_string($rotation); $artistID = artistCheck($artist_name); if (!$artistID) { $artistID = insertArtist($artist_name); } if (!($labelID = labelCheck($label))) { $labelID = insertLabel($label); } if ($album_code == $albumID) { $album_code = getNewAlbumCode(); $rotation = 7; } $query = sprintf("UPDATE libalbum SET album_name='%s', album_code='%s', artistID='%d', labelID='%d', genre='%s', general_genreID='%d', rotationID='%d' WHERE albumID = '%d'", $album_name, $album_code, $artistID, $labelID, $genre, $general_genreID, $rotation, $albumID); mysql_query($query) or die("reviewAlbum failed : " . mysql_error()); $query = sprintf("REPLACE INTO libreview (albumID, review, username, reviewer) VALUES ('%d', '%s', '%s', '%s')", $albumID, $review, $username, $reviewer); mysql_query($query) or die("reviewAlbumSubmitReview failed : " . mysql_error()); return TRUE; }
$artist = trim($_POST['artist']); $album = trim($_POST['album']); $label = trim($_POST['label']); $genre = trim($_POST['genre']); $general_genreID = $_POST['general_genreID']; $medium = $_POST['medium']; $number_of_discs = sprintf("%d", $_POST['number_of_discs']); if ($artist == "" || $album == "") { die("Please fill in artist and album!"); } if ($label != "") { $lID = labelCheck($label); if ($lID) { echo "Label already exists: {$lID} for {$label}<br>"; } else { $lID = insertLabel($label); echo "New label ID: {$lID} for {$label}<br>"; } } else { $lID = LABEL_DUMMY; } $aID = artistCheck($artist); if ($aID) { echo "Artist already exists: {$aID}<br>"; } else { $aID = insertArtist($artist); echo "New artist ID: {$aID} for {$artist}<br>"; } $cID = albumCheck($album, $aID); if ($cID) { echo "CD already exists: {$cID}<br>";