Reply to thread

Message

<blockquote data-quote="MikaXS" data-source="post: 184435" data-attributes="member: 56891">Guide + DetailsSince my friend (this is his Account) wanted the webinterface to work on his playstation 3we 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=&quot;multi&quot;)// A general SQL-Query returning multiple rows.{[...]// Check if there is something returned, if not, set to 0.if ($result &gt; 0)&nbsp; &nbsp; //return $result;&nbsp; &nbsp; //Skip:FIX for false Names&nbsp; &nbsp; return CheckForFalseNames($result);&nbsp; &nbsp; //=&gt;Skip:FIX for false Names&nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return 0;&nbsp; &nbsp; &nbsp; &nbsp; }[...]function genreSearch ($idGenre)&nbsp; &nbsp; // Search the epg-data by genre.&nbsp; &nbsp; // Returns multiple arrays.&nbsp; &nbsp; {&nbsp; &nbsp; return sqlquery(&quot;SELECT * FROM TblPrograms WHERE idGenre = &quot;.$idGenre.&quot; AND iStartTime &gt;= &quot;.date(&quot;Ymdhis&quot;).&quot; ORDER BY iStartTime,idChannel&quot;,&quot;multi&quot;);&nbsp; &nbsp; }//Skip:FIX for false Names&nbsp; &nbsp; function CheckForFalseNames ($temp){&nbsp;$filter = array(&quot;&quot;,&quot;\&quot;&quot;);&nbsp;for($count = 0; $count &lt; count($temp); $count++)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($temp[$count]!=&quot;&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $temp[$count] = str_replace($filter,&quot; &quot;,$temp[$count]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; return $temp;}//=&gt;Skip:FIX for false Names?&gt;[/CODE]that's it <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin&nbsp; &nbsp; :D" loading="lazy" data-shortname=":D" /> Skip</blockquote>

[QUOTE="MikaXS, post: 184435, member: 56891"] [b]Guide + Details[/b] 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: [B][CENTER][SIZE="5"]sql.php[/SIZE][/CENTER][/B] [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 :D Skip [/QUOTE]

Verification