2012-12-07, 08:10
(2012-12-07, 06:09)VanillaXtract Wrote: I had the same warning showing up in my log. The screen was black so I waited about 10min and then everything was fine. My lengths never showed up as 1min despite the warning.
And thanks for the fix. I just thought if the new version was for the Frodo beta then it shouldn't have been looking for that table.
Ok i see only the Database seems to be messed up regarding movie duration in xbmc everything seems fine... strange but ok than i can stop writing a script to convert that stuff
thx for the info
EDIT:
Finished my php script in case someone needs it. It converts the duration format HH:MM to MM its not realy nice written but it does its job.
Code:
<?php
mysql_connect("localhost", "root", "") or
die("Keine Verbindung möglich: " . mysql_error());
mysql_select_db("myvideos60");
$result = mysql_query("SELECT idMovie,c11 FROM movie");
printf($result);
while ($row = mysql_fetch_row($result)) {
$row[1] = preg_replace('/[A-Za-z_]*/', '', $row[1]);
$string = $row[1];
$minuten = substr($string,-2,2);
$stunden = substr($string,0,1);
if($stunden=="1"){$stunden = "60"; }
if($stunden=="2"){$stunden = "120"; }
if($stunden=="3"){$stunden = "180"; }
$gesammt = $minuten + $stunden;
$row[1] = $gesammt;
mysql_query("UPDATE movie SET c11 ='$row[1]' where idMovie = '$row[0]'");
}
?>
EDIT 2:
XBMC then converts the time into seconds so we need an XBNE update