Warning: Undefined array key "UserLoggedIn" in /home/timenjxh/public_html/tardis/include.php on line 33

Warning: Undefined variable $diag in /home/timenjxh/public_html/tardis/include.php on line 83
";die();} $result = mysqli_query($db,$SQL); $row=mysqli_fetch_assoc($result); if (empty($row["titleid"])){ header('Location: edition.php?'.$row["editionid"]); die(); } $key=$row["titleid"]; } $SQL="SELECT title, count(*) AS reviewcount FROM (SELECT title from dw_reviews WHERE review IS NOT NULL AND titleid=".$key." order by RAND())x LIMIT 1"; $result = mysqli_query($db,$SQL); if ($debug){echo "$SQL
";} //if (mysqli_num_rows($result)==1){ if ($result){ $row=mysqli_fetch_assoc($result); $reviewcount=$row["reviewcount"]; $review=$row["title"]; } $SQL="SELECT dw_titles.categoryid, categorytitle, dw_editions.editionid, dw_titles.titleid, dw_titles.redirect, dw_itemranges.rangeid, dw_itemranges.rangeorder, dw_titles.prefix, REPLACE(CONCAT_WS(' ',dw_titles.prefix,dw_titles.title,dw_titles.suffix),' : ',': ') AS itemtitle, dw_titles.title, dw_titles.suffix, dw_titles.author, dw_titles.starring, dw_titles.doctor, dw_titles.votes, dw_titles.users, dw_titles.editioncount, dw_titles.itemdescription, dw_images.imageid, dw_editions.date, dw_editions.isbn1, dw_editions.country, dw_countries.countryname, dw_editions.blurb, dw_editions.desc, dw_editions.notes, dw_publishers.publishername, dw_editions.buyurl, dw_editions.buyname, dw_editions.numdisks, dw_editions.format, dw_formats.formattitle, dw_editions.numdisks2, dw_editions.format2, f2.formattitle AS formattitle2, dw_editions.dateconfirmed, dw_editions.datedesc,dw_editions.date2,dw_editions.date2desc, dw_ranges.type, dw_ranges.itemcount, dw_ranges.rangetitle, dw_formats.itemtype, showisbn, showauthor, showstarring, p2.publishername AS rangepublisher, dw_editions.isbn2, dw_images.filename, issmallitem, dw_images.imgwidth, dw_images.imgheight, REPLACE(CONCAT_WS(' ',dw_editions.editionprefix,dw_editions.editiontitle,dw_editions.editionsuffix),' : ',': ') AS editiontitle, hasamazon"; if ($uid>0) {$SQL.=", i.status";} $SQL.=" FROM ((((dw_titles LEFT JOIN dw_itemranges ON dw_titles.titleid=dw_itemranges.titleid"; $SQL.=") LEFT JOIN dw_editions ON dw_editions.titleid=dw_titles.titleid) LEFT JOIN dw_ranges on dw_itemranges.rangeid=dw_ranges.rangeid)"; if ($uid>0) {$SQL.=" LEFT JOIN (SELECT * from dw_items where userid=".$uid.") AS i ON dw_editions.editionID=i.editionid";} $SQL.=") LEFT JOIN dw_countries ON dw_editions.country=dw_countries.country"; //LEFT JOIN dw_images ON (sharedimage AND sharedimage=dw_images.editionid) $SQL.=" LEFT JOIN dw_editionimages ON (dw_editions.editionid=dw_editionimages.editionid AND dw_editionimages.isprimaryimage) LEFT JOIN dw_images ON dw_editionimages.imageid=dw_images.imageid"; $SQL.=" LEFT JOIN dw_formats ON (dw_editions.format=dw_formats.format)"; $SQL.=" LEFT JOIN dw_formats AS f2 ON (dw_editions.format2=f2.format)"; $SQL.=" LEFT JOIN dw_publishers ON (dw_editions.publisherid=dw_publishers.publisherid)"; $SQL.=" LEFT JOIN dw_publishers AS p2 ON (dw_ranges.publisherid=p2.publisherid)"; $SQL.=" LEFT JOIN dw_categories ON dw_titles.categoryid=dw_categories.categoryid"; $SQL.=" WHERE (dw_editions.active=1 OR dw_editions.active IS NULL) AND dw_itemranges.editionid IS NULL AND dw_titles.titleid=".$key; //$SQL.=" UNION ".str_replace("dw_editions.editionid) WHERE sharedimage IS NULL","dw_editions.sharedimage) WHERE sharedimage IS NOT NULL",$SQL); $SQL.=" ORDER BY date,editionid"; if ($debug){echo "$SQL
";} $result = mysqli_query($db,$SQL); if ($result){ $row=mysqli_fetch_assoc($result); if (!empty($row["redirect"])){ header("Location: display.php?".$row["redirect"]); die(); } $isblank=False; $range=$row["rangeid"]; //$itemtype=$row["itemtype"]; $rangetitle=$row["rangetitle"]; $itemcount=$row["itemcount"]; $pagetitle=$row["itemtitle"]; $id=$row["rangeorder"]; $editioncount=$row["editioncount"]; } if (!$isblank) { $showauthor=$row["showauthor"]; //if ($range=="mythdvd" || $range=="mythmakers") {$showauthor=False;} $showstarring=$row["showstarring"]; //if ($itemtype=="book" || $range=="music") {$showstarring=False;} $showisbn=$row["showisbn"]; //if ($itemtype=="video" || $range=="music" || $range=="kaldorcity" || $range=="factionparadoxaudio") {$showisbn=False;} $showbuy=True; $showpublisher=True; //if ($range=="sarahjane" || $range=="torchwoodaudio" || $range=="mythmakers" || $range=="laserdisc" || $range=="bbcnewdvd" || $range=="bbcdvd" || $range=="sarahjaneaudio" || $range=="graphicnovels" || $range=="factionparadoxaudio" || $range=="factionparadox" || $range=="activity" || $range=="miscbooks" || $range=="scripts" || $range=="biography" || $range=="shortstories" || $range=="miscdvd" || $range=="miscvideo" || $range=="music" || $range=="miscaudio" || $range=="annual" || ($range=="bbcnewseries" && $editioncount>1) || ($range=="na" && $editioncount>1) || ($range=="target" && $editioncount>1) || ($range=="torchwood" && $editioncount>1) || $key==1220) {$showpublisher=True;} } include "doctype.php"; echo ''; ?> "; if ($isblank) { echo "Error: No such item!

"; } else { $itemtype=$row["itemtype"]; $typetitle=ucfirst($itemtype); if ($itemtype=="book"){$typetitle.="s";} echo ''; echo '
'; $fontsize=2; $temptitle=htmlentities(preg_replace(array('/\b"/','/"/',"/\B'\b/","/'/"), array('”','“',"’","‘"), $row["itemtitle"])); $tempsuffix=htmlentities(preg_replace(array('/\b"/','/"/',"/\B'\b/","/'/"), array('”','“',"’","‘"), $row["suffix"])); writebar2(str_replace($tempsuffix,''.$tempsuffix."",$temptitle)); echo " "; $nowrap=True; $fontsize=2; $navbar="No. ".$id." of ".$itemcount.' in the '.$rangetitle.' series
<< Previous     Next >>'; writebar($navbar); echo "

"; if ($editioncount>1) { echo "
"; echo ""; writeheader($row); echo ""; if (!empty($row["itemdescription"])) { echo ""; } echo "
Editions:  "; for ($x=1; $x<=$editioncount; $x++) { echo ''; //if ($itemtype=="video" || $range=="target" || $range=="bbcnewseries" || $range=="torchwood") {echo flag($row["country"])." ";} if ($itemtype=="video" || $range=="target" || $range=="bbcnewseries" || $range=="torchwood") {echo flag($row["country"])." ";} echo writeedition($row["countryname"], $row["desc"], $row["formattitle"], $range, $itemtype, $editioncount, False).""; if ($x<$editioncount) { echo " | "; $row=mysqli_fetch_assoc($result); } } echo "
Description:  ".blurbformat($row["itemdescription"]); if ($key=="773" && date("Y-m-d")<="2024-07-14"){ //text advertising code from Chloe Miller chloe57@yahoo.com 3/3/22, renewed 28/07/23 for 1 year echo '

From VHS and DVD, to Blu-Ray and virtual reality, Dr. Who has evolved over the decades and kept up with current technologies. The first Dr. Who VR video game, The Edge of Time, was released in 2020. Any custom VR world creator or VR game designer would love the challenge of adapting the world of Dr. Who.'; } if ($key=="879" && date("Y-m-d")<="2021-07-20"){ //text advertising code from Chloe Miller chloe57@yahoo.com 20/7/20 for 1 year echo '

There are so many releases of Doctor Who episodes available you may need a database to keep track of them all. The TARDIS Library contains as much information as any case management database software in a lawyer\'s office.'; } if ($key=="990" && date("Y-m-d")<="2024-07-14"){ //text advertising code from Chloe Miller chloe57@yahoo.com 8/9/20 for 1 year, renewed 24/2/22 for 1 year, renewed 28/07/23 for 1 year echo '

You can only imagine the strange plants and flowers that grow on other planets. No doubt any Avas Flowers bouquet made from alien flowers would be very strange compared to an ordinary Avas Flowers arrangement.'; } echo "

"; echo "
"; } mysqli_data_seek($result, 0); while ($row=mysqli_fetch_assoc($result)){ echo '

1) {echo 'class="black" ';} echo "border=0 cellpadding=4 cellspacing=0>"; echo "
"; echo showimage($row, "medium", True, "Cover image for ".(empty($row["editiontitle"]) ? $row["itemtitle"] : $row["editiontitle"]), True, "align=right hspace=4"); echo ""; if ($editioncount==1) {writeheader($row);} if (($editioncount>1) || ($itemtype=="video" && $range!="mythdvd" && $range!="mythmakers" && !empty($row["country"]) && $editioncount==1)) { echo '"; } if ($editioncount>1 && !empty($row["editiontitle"])){ echo ""; } echo ""; echo ""; if ($showpublisher && (($range!="target" && $range!="bbcdvd" && $range!="bbcnewdvd") || (($range=="target" || $range!="bbcdvd" || $range!="bbcnewdvd") && !empty($row["publishername"])))) { echo ""; echo ""; } $varisbn="Unknown"; if (!empty($row["isbn1"])) {$varisbn=$row["isbn1"];} if ($showisbn) { echo ""; echo ""; } echo ""; echo ""; $itemstatus=0; //if ($uid>0) { if (!empty($row["status"])){$itemstatus=$row["status"];} //} echo ""; $varbuy=printbuy($key, $row["isbn1"], $row["isbn2"], $row["itemtitle"], $range, $row["country"], $row["date"], "", $row["buyurl"], $row["buyname"], $row["format"], "display", $row["hasamazon"]); echo '"; if ($showbuy && !empty($varbuy)) {echo "";} echo ""; //End If echo "
Edition: '; if ($itemtype=="video" || $range=="target" || $range=="bbcnewseries" || $range=="torchwood") {echo flag($row["country"])." ";} echo writeedition($row["countryname"], $row["desc"], $row["formattitle"], $range, $itemtype, $editioncount, False)."
Title:  ".$row["editiontitle"]."
Released:  "; dateprocess($row["date"],$row["datedesc"],$row["dateconfirmed"]); if (!empty($row["date2"])){echo "
";dateprocess($row["date2"],$row["date2desc"]);} //If alldata(RS_date, rowcounter)<=DateAdd("M",3,Date) And /*if (strtotime($row["date"])>=strtotime("-6 months") && $row["dateconfirmed"]) { echo date("j F Y", strtotime($row["date"]))." "; }else { echo date("F Y", strtotime($row["date"])); if (!empty($row["datedesc"])) {echo " (".$row["datedesc"].")";} if (!$row["dateconfirmed"]) {echo " (Exact date unconfirmed)";} } if (!empty($row["date2"])) { echo "
"; if (strtotime($row["date2"])>=strtotime("-6 months") && $row["dateconfirmed2"]) { echo date("j F Y", strtotime($row["date2"]))." "; }else { echo date("F Y", strtotime($row["date2"])); } if (!empty($row["datedesc2"])) {echo " (".$row["datedesc2"].")";} if (!$row["dateconfirmed2"]) {echo " (Exact date unconfirmed)";} } */ echo "
Publisher:  ".htmlentities($row["publishername"]); if (empty($row["publishername"])) {echo $row["rangepublisher"];} if (empty($row["publishername"]) && empty($row["rangepublisher"])) {echo "Unknown";} echo "
ISBN:"; if (substr($varisbn,0,1)=="B") { echo "None"; } else { echo $varisbn; } echo "
Format: "; //if ($itemtype=="book") { //if (!empty($row["format"])) { //echo $row["format"]; //} else { //echo "Unknown"; //} //} else { if ($row["numdisks"]>0) {echo $row["numdisks"]." x ";} //if (empty($row["format"])) { //if ($itemtype=="audio") { //echo "CD"; //} elseif ($range=="laserdisc"){ //echo "Laserdisc"; //} elseif (substr($range,-3)=="dvd"){ //echo "DVD"; //} else { echo "VHS"; echo $row["formattitle"]; if(substr($row["formattitle"],0,3)=="VHS"){ switch ($row["country"]){ Case "uk": Case "au": Case "fi": Case "se": Case "de": Case "no": Case "dk": echo " PAL"; break; Case "us": Case "jp": echo " NTSC"; } } //} //} else { echo str_replace("picture disc ", "",$row["format"]); //} //} if (!empty($row["format2"])&&!empty($row["numdisks2"])) {echo ", ".$row["numdisks2"]." x ".$row["formattitle2"];} echo "
Owned:"; ownedbox($row["editionid"],$itemstatus); echo "

"; $blurb=$row["blurb"]; $notes=$row["notes"]; if (!empty($notes)) { echo "

Note:  ".blurbformat($notes)."

"; } elseif($editioncount==1 && !empty($row["itemdescription"])) { echo "

Description:  ".blurbformat($row["itemdescription"])."

"; if ($key=="379" && date("Y-m-d")<="2023-03-08"){ //text advertising code from Chloe Miller chloe57@yahoo.com 8/3/21 for 1 year (renewed 2022) echo '

Reading or listening to audio books at home requires a quiet room and a little privacy. Portable room dividers can section off a space in your home which can be perfect for reading and quiet time.

'; } if ($key=="963" && date("Y-m-d")<="2022-02-24"){ //text advertising code from Chloe Miller chloe57@yahoo.com 8/3/21 for 1 year echo '

Tej Kohli uses his non-profit foundation to fight the war against poverty-driven corneal blindness. The Tej Kohli Foundation has plans to eliminate corneal blindness by 2035.

'; } } echo "

Cover blurb:"; if (empty($blurb)) { $blurb="No cover information available yet."; if (strtotime($row["date"])<> Do you own this item? Please help make this site more complete by emailing me details of the back cover blurb. Thanks!';} $blurb=$blurb."
"; } echo "
".blurbformat($blurb); if ($key=="1091" && date("Y-m-d")<="2023-02-24"){ //text advertising code from Chloe Miller chloe57@yahoo.com 24/2/21 for 1 year (renewed 2022) echo '

If you are missing some of these DVDs from your Dr. Who video collection, you may be able to print out the covers if you own a good photo printer. Most collectors would prefer to own the actual DVDs, but printing out copies of the covers may suffice if the item is no longer available to buy.'; } if ($key=="1183" && date("Y-m-d")<="2025-07-13"){ //text advertising code from Chloe Miller chloe57@yahoo.com 13/7/24 for 1 year echo '


Downtime may be a great spin-off of Dr. Who, but website downtime is never a good thing. An effective load balancing strategy and proper use of load testing tools can help prevent website downtime.'; } echo "

"; } } $fontsize=2; if ($isblank || empty($range)) { writebar2('Go back'); } else { writebar2('Go back'); } echo "
"; include "../footer.php"; ?>