Sorry\n";
echo "DVD not in database.
\n";
}
else {
$row = db_fetch_array($con,$query);
$currviews = $row[views];
$currviews++;
db_query($con,"update dvd set views=$currviews where id=$row[id]");
if ($row[year] != 0) {
$TITLE = "DVD ESP - ";
$TITLE .= $row[preferred_title] ? $row[preferred_title] : $row[title];
$TITLE .= " ($row[year])\n";
}
else {
$TITLE = "DVD ESP - ";
$TITLE .= $row[preferred_title] ? $row[preferred_title] : $row[title];
}
include "header.php3";
include "maincontent.php3";
if ($row[verified] == 'U') {
echo "Here is what Livefind found.
\n";
echo "This movie has been submitted for addition to our database.\n";
}
$adquery = db_query($con,"select code from genre_dvd where dvd_id='$row[id]'");
while ($adrow = db_fetch_array($con,$adquery)) {
if ($adrow[code] == "AD") {
echo "Note: This title is an Adult title.\n";
echo "You must be 18 or older to buy it.
\n";
break;
}
}
echo "";
echo $row[preferred_title] ? $row[preferred_title] : $row[title];
echo " ";
if ($row[year] != 0) {
echo "($row[year])";
}
echo "
";
if ($row[photo_url]) {
echo "![\"Cover](\"$row[photo_url]\")
";
}
else {
echo "![\"Cover](\"images/default_cover.gif\")
";
}
echo "
\n";
if ($row[rating]) {
echo "Rated: $row[rating]
\n";
}
if ($row[director]) {
echo "Director: $row[director]
\n";
}
if ($row[stars]) {
echo "Starring: $row[stars]
\n";
}
$gquery = db_query($con,"select gd.code,g.name from genre_dvd as gd, genre as g where gd.dvd_id='$row[id]' and g.code=gd.code");
if (($gnr = db_numrows($con,$gquery)) > 0) {
echo "Genre: ";
$gencount = 0;
while ($gencount < $gnr) {
$gencount++;
$genrow = db_fetch_array($con,$gquery);
echo "$genrow[name]";
if ($gencount < $gnr) {
echo ", ";
}
}
echo "
\n";
}
echo "
";
if ($row[description]) {
echo "$row[description]
\n";
}
if ($row[release]) {
$darray = explode("-", $row[release]);
$inttime = mktime(0,0,0,$darray[1],$darray[2],$darray[0]);
if ($inttime > time()) {
echo "Release Date: ";
echo date("F d, Y", $inttime);
echo "
\n";
}
}
if ($row[details]) {
echo "Details:
\n";
echo "$row[details]
\n";
}
if ($row[imdb_url]) {
echo "![\"IMDB](\"/images/imdblogo.gif\")
Get more details at the Internet Movie Database";
}
echo "
Search for " . $row['title'] . " on Amazon Advanced Search
";
echo "\n";
include "dvdcompare.php3";
}
}
include "db.php3";
$con = db_connect("");
# Make sure DVD_ID is only a number
if (!ereg("^[0-9]+$", $DVD_ID)) {
include "header.php3";
include "maincontent.php3";
echo "DVD not in database.
\n";
}
else if ($DVD_ID) {
$sql = "select * from dvd where id=$DVD_ID and verified in ('Y', 'U')";
$dvdquery = db_query($con,$sql);
lookup_dvd($con,$dvdquery);
}
else {
$TITLE = "DVD ESP";
include "header.php3";
include "maincontent.php3";
echo "DVD not in database.
\n";
}
include "footer.php3";
?>