Reply to thread

Message

<blockquote data-quote="Lightning303" data-source="post: 991700" data-attributes="member: 97876">After your post, i felt challenged to try my own luck, if i could get it to work.&nbsp;As i see it, atleast on IMDB Germany, it shows me always the german title. If there is no special german title it shows me the original title. Which as i understand, is the title the film makers gave the movie. Whenever it shows me not the original title, but the german one, the original title is on the releaseinfo page in the section for akas the first one.As i said i wanted to try my own luck, so i made a little php script to get the original title. From my tests, it looks like it is always working. Of course i dont know if it will work for somebody in the us (maybe you can test?) or in other countries.&nbsp;Here my php script[PHP]&lt;?php&nbsp; &nbsp; /*&nbsp; &nbsp; Proof of concept to get original title based on imdb id.&nbsp; &nbsp; Just tested from Germany. Possible that this does not work in other countries.&nbsp; &nbsp; &nbsp; &nbsp; Lightning303, 06 May 2013&nbsp; &nbsp; */&nbsp; &nbsp; $MovingPicturesDB = &quot;H:/movingpictures.db3&quot;;&nbsp; &nbsp; $MovingPicturesDB = &quot;sqlite:&quot;.$MovingPicturesDB;&nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; $dbh = new PDO($MovingPicturesDB);&nbsp; &nbsp; }&nbsp; &nbsp; catch(PDOException $e){&nbsp; &nbsp; &nbsp; &nbsp; echo $e-&gt;getMessage();&nbsp; &nbsp; }&nbsp; &nbsp; $Start = 0;&nbsp; &nbsp; $Limit = 25;&nbsp; &nbsp; $MovPicDB = $dbh-&gt;query(&quot;SELECT id, imdb_id, title FROM movie_info ORDER BY id LIMIT &quot;.$Start.&quot;, &quot;.$Limit.&quot;&quot;);&nbsp; &nbsp; $x = 0;&nbsp; &nbsp; while($MovPicDBData = $MovPicDB-&gt;fetch(PDO::FETCH_ASSOC)) {&nbsp; &nbsp; &nbsp; &nbsp; // Title in MP DB and IMDB ID&nbsp; &nbsp; &nbsp; &nbsp; echo $MovPicDBData[&quot;title&quot;].&quot; -&gt; &quot;.$MovPicDBData[&quot;imdb_id&quot;].&quot; -&gt; &quot;;&nbsp; &nbsp; &nbsp; &nbsp; // Getting information from imdb page&nbsp; &nbsp; &nbsp; &nbsp; $IMDBData = file_get_contents(&quot;http://www.imdb.com/title/&quot;.$MovPicDBData[&quot;imdb_id&quot;]);&nbsp; &nbsp; &nbsp; &nbsp; // Searching for position of the title&nbsp; &nbsp; &nbsp; &nbsp; $TitlePos = strpos($IMDBData, &quot;&lt;span class=\&quot;itemprop\&quot; itemprop=\&quot;name\&quot;&gt;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; // Cutting off everything before the first title&nbsp; &nbsp; &nbsp; &nbsp; $TitleTemp = substr($IMDBData,($TitlePos + 39),500);&nbsp; &nbsp; &nbsp; &nbsp; // Getting position of the end of the title&nbsp; &nbsp; &nbsp; &nbsp; $TitleTempPos = strpos($TitleTemp, &quot;&lt;/span&gt;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; // Seperating the title&nbsp; &nbsp; &nbsp; &nbsp; $TitleToUse = substr($TitleTemp,0,$TitleTempPos);&nbsp; &nbsp; &nbsp; &nbsp; // Searching for original title and its position&nbsp; &nbsp; &nbsp; &nbsp; $OriginalTitlePos = strpos($TitleTemp, &quot;&lt;span class=\&quot;title-extra\&quot; itemprop=\&quot;name\&quot;&gt;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; if ($OriginalTitlePos) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Cutting off everything before the first original title&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $OriginalTitleTemp = substr($TitleTemp,($OriginalTitlePos + 56),250);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Getting position of the end of the original title&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $OriginalTitleTempPos = strpos($OriginalTitleTemp, &quot;&lt;i&gt;(original title)&lt;/i&gt;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Seperating the original title&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $TitleToUse = substr($OriginalTitleTemp,0,($OriginalTitleTempPos-14));&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; echo $TitleToUse.&quot;&lt;br&gt;\n&quot;;&nbsp; &nbsp; &nbsp; &nbsp; $x = $x + 1;&nbsp; &nbsp; &nbsp; &nbsp; if ($x == $Limit) { break; }&nbsp; &nbsp; }?&gt;[/PHP]&nbsp;To test it, you just would have to change the destination of the movingpietures db.&nbsp;Example of the results[code]This Is It -&gt; tt1477715 -&gt; This Is ItThe Hurt Locker -&gt; tt0887912 -&gt; The Hurt LockerThe Girl I: with the Dragon Tattoo -&gt; tt1132620 -&gt; MÃ¤n som hatar kvinnorMinority Report -&gt; tt0181689 -&gt; Minority ReportAvatar -&gt; tt0499549 -&gt; AvatarUp in the Air -&gt; tt1193138 -&gt; Up in the AirSurrogates -&gt; tt0986263 -&gt; SurrogatesThe Stepfather -&gt; tt0814335 -&gt; The StepfatherThe Game -&gt; tt0119174 -&gt; The GameNine Miles Down -&gt; tt0812352 -&gt; Nine Miles DownNine -&gt; tt0875034 -&gt; NineGamer -&gt; tt1034032 -&gt; GamerThe Boondock Saints II: All Saints Day -&gt; tt1300851 -&gt; The Boondock Saints II: All Saints DayArmageddon -&gt; tt0120591 -&gt; ArmageddonGoodfellas -&gt; tt0099685 -&gt; GoodfellasIce Age III: Dawn of the Dinosaurs -&gt; tt1080016 -&gt; Ice Age: Dawn of the DinosaursSchindler's List -&gt; tt0108052 -&gt; Schindler's ListThe Code -&gt; tt1112782 -&gt; Thick as Thieves[/CODE]&nbsp;Note, that the titles in front are from my db, scraped with force english and rename db. Also, &quot;Män som hatar kvinnor&quot; included ;p&nbsp;Hope that helps <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /></blockquote>

[QUOTE="Lightning303, post: 991700, member: 97876"] After your post, i felt challenged to try my own luck, if i could get it to work. As i see it, atleast on IMDB Germany, it shows me always the german title. If there is no special german title it shows me the original title. Which as i understand, is the title the film makers gave the movie. Whenever it shows me not the original title, but the german one, the original title is on the releaseinfo page in the section for akas the first one. As i said i wanted to try my own luck, so i made a little php script to get the original title. From my tests, it looks like it is always working. Of course i dont know if it will work for somebody in the us (maybe you can test?) or in other countries. Here my php script [PHP]<?php /* Proof of concept to get original title based on imdb id. Just tested from Germany. Possible that this does not work in other countries. Lightning303, 06 May 2013 */ $MovingPicturesDB = "H:/movingpictures.db3"; $MovingPicturesDB = "sqlite:".$MovingPicturesDB; try { $dbh = new PDO($MovingPicturesDB); } catch(PDOException $e){ echo $e->getMessage(); } $Start = 0; $Limit = 25; $MovPicDB = $dbh->query("SELECT id, imdb_id, title FROM movie_info ORDER BY id LIMIT ".$Start.", ".$Limit.""); $x = 0; while($MovPicDBData = $MovPicDB->fetch(PDO::FETCH_ASSOC)) { // Title in MP DB and IMDB ID echo $MovPicDBData["title"]." -> ".$MovPicDBData["imdb_id"]." -> "; // Getting information from imdb page $IMDBData = file_get_contents("http://www.imdb.com/title/".$MovPicDBData["imdb_id"]); // Searching for position of the title $TitlePos = strpos($IMDBData, ""); // Cutting off everything before the first title $TitleTemp = substr($IMDBData,($TitlePos + 39),500); // Getting position of the end of the title $TitleTempPos = strpos($TitleTemp, ""); // Seperating the title $TitleToUse = substr($TitleTemp,0,$TitleTempPos); // Searching for original title and its position $OriginalTitlePos = strpos($TitleTemp, ""); if ($OriginalTitlePos) { // Cutting off everything before the first original title $OriginalTitleTemp = substr($TitleTemp,($OriginalTitlePos + 56),250); // Getting position of the end of the original title $OriginalTitleTempPos = strpos($OriginalTitleTemp, "(original title)"); // Seperating the original title $TitleToUse = substr($OriginalTitleTemp,0,($OriginalTitleTempPos-14)); } echo $TitleToUse." \n"; $x = $x + 1; if ($x == $Limit) { break; } } ?>[/PHP] To test it, you just would have to change the destination of the movingpietures db. Example of the results [code]This Is It -> tt1477715 -> This Is It The Hurt Locker -> tt0887912 -> The Hurt Locker The Girl I: with the Dragon Tattoo -> tt1132620 -> MÃ¤n som hatar kvinnor Minority Report -> tt0181689 -> Minority Report Avatar -> tt0499549 -> Avatar Up in the Air -> tt1193138 -> Up in the Air Surrogates -> tt0986263 -> Surrogates The Stepfather -> tt0814335 -> The Stepfather The Game -> tt0119174 -> The Game Nine Miles Down -> tt0812352 -> Nine Miles Down Nine -> tt0875034 -> Nine Gamer -> tt1034032 -> Gamer The Boondock Saints II: All Saints Day -> tt1300851 -> The Boondock Saints II: All Saints Day Armageddon -> tt0120591 -> Armageddon Goodfellas -> tt0099685 -> Goodfellas Ice Age III: Dawn of the Dinosaurs -> tt1080016 -> Ice Age: Dawn of the Dinosaurs Schindler's List -> tt0108052 -> Schindler's List The Code -> tt1112782 -> Thick as Thieves[/CODE] Note, that the titles in front are from my db, scraped with force english and rename db. Also, "Män som hatar kvinnor" included ;p Hope that helps :) [/QUOTE]

Verification