session_start();
include("inc/db.php");
include("inc/login.php");
include("inc/datediff.php");
$db = new dbconn();
$db->connect();
?>
  DVD Collection - Edit DVD
  
if ($logged_in) {
  if ($_REQUEST['Action'] == "edit") {
  $ures = mysql_fetch_assoc(mysql_query("SELECT ID FROM users WHERE username='".$_SESSION['username']."'"));
  $userID = $ures['ID'];
  
  $strSQL = mysql_query("SELECT * FROM DVDcollection WHERE DVDID=".$_REQUEST['DVD']." AND UserID=".$userID);
  while ($rsDVD = mysql_fetch_assoc($strSQL)) {
  $Title = trim($rsDVD['Title']);
  $IMDBURL = trim($_REQUEST['IMDBURL']);
  $PictureURL = trim($_REQUEST['PictureURL']);
  $CoverURL = trim($_REQUEST['CoverURL']);
  $Audio = trim($_REQUEST['Audio']);
  $Subtitles = trim($_REQUEST['Subtitles']);
  $AspectRatio = trim($_REQUEST['AspectRatio']);
  $Extras = trim($_REQUEST['Extras']);
?>
  
  }
  } else {
  $ures = mysql_fetch_assoc(mysql_query("SELECT ID FROM users WHERE username='".$_SESSION['username']."'"));
  $userID = $ures['ID'];
  $Title = $_REQUEST['Title'];
  $IMDBURL = $_REQUEST['IMDBURL'];
  $PictureURL = $_REQUEST['PictureURL'];
  $CoverExt = $_REQUEST['CoverExt'];
  $Audio = $_REQUEST['Audio'];
  $Subtitles = $_REQUEST['Subtitles'];
  $AspectRatio = $_REQUEST['AspectRatio'];
  $Extras = $_REQUEST['Extras'];
  $IMDBRating = $_REQUEST['IMDBRating'];
  $strSQL = "UPDATE DVDcollection SET Title='".$Title."', IMDBURL='".$IMDBURL."', PictureURL='".$PictureURL."', CoverExt='".$CoverExt."', Audio='".$Audio."', Subtitles='".$Subtitles."', AspectRatio='".$AspectRatio."', Extras='".$Extras."', IMDBRating='".$IMDBRating."' WHERE DVDID=".$_REQUEST['DVD']." AND UserID=".$userID;
  mysql_query($strSQL);
  echo "DVD \"".$Title."\" successfully updated
";
  echo "Add a DVD
";
  echo "Return to listing";
  }
}
?>