Reply to thread

Guide + Details

Since my friend (this is his Account) wanted the webinterface to work on his playstation 3

we changed the code of it a bit, discovering the error in the guide + details mentioned a few sites before...

It happens that certain TV-Show-Names contain chars that kill the layout of the guide...

However, here's a quick and i suppose dirty fix:

sql.php

[CODE]

function sqlquery($sql, $type="multi")

// A general SQL-Query returning multiple rows.

{

[...]

// Check if there is something returned, if not, set to 0.

if ($result > 0)

    //return $result;

    //Skip:FIX for false Names

    return CheckForFalseNames($result);

    //=>Skip:FIX for false Names 

else       

    return 0;       

}

[...]

function genreSearch ($idGenre)

    // Search the epg-data by genre.

    // Returns multiple arrays.

    {

    return sqlquery("SELECT * FROM TblPrograms WHERE idGenre = ".$idGenre." AND iStartTime >= ".date("Ymdhis")." ORDER BY iStartTime,idChannel","multi");

    }

//Skip:FIX for false Names   

function CheckForFalseNames ($temp)

{

 $filter = array("","\"");

 for($count = 0; $count < count($temp); $count++)

          {

          if($temp[$count]!="")

            $temp[$count] = str_replace($filter," ",$temp[$count]);

          }

  return $temp;

}

//=>Skip:FIX for false Names

?>[/CODE]

that's it

Skip