} elseif ($i >= 1536 and $i < 1792) { $tbid = "56"; } elseif ($i >= 1792 and $i < 2048) { $tbid = "57"; } elseif ($i >= 2048 and $i < 2304) { $tbid = "58"; } elseif ($i >= 2304 and $i < 2560) { $tbid = "59"; } elseif ($i >= 2560 and $i < 2816) { $tbid = "5A"; } elseif ($i >= 2816 and $i < 3072) { $tbid = "5B"; } elseif ($i >= 3072 and $i < 3328) { $tbid = "5C"; } elseif ($i >= 3328 and $i < 3584) { $tbid = "5D"; } elseif ($i >= 3548 and $i < 3840) { $tbid = "5E"; } elseif ($i >= 3840 and $i < 4096) { $tbid = "5F"; } echo tableid(2), " --*- \n"; for ($i = 0; $i < 6; $i++) { echo $i . "\n"; } $feit = fopen('eit_01.ts', "r"); while (ftell($feit) < filesize('eit_01.ts')) { echo fread($feit, 2) . "\n"; fseek($feit, 186, SEEK_CUR); } fclose($feit);
$versijj = $vers + 193; //buvo 193 $sek_nr_all = 0; //------------------- Ishrenka existing sid rows all pid'us ------------- $sql2 = 'SELECT ext_pid AS pidas, esid AS sidas, pid FROM `epg_kan` WHERE esid = ' . $row1['esid'] . ' ORDER BY pidas;'; $result2 = mysqli_query($conn, $sql2); while ($row2 = mysqli_fetch_assoc($result2)) { $sek_nr = 0; $sek_nr_cont = 0; //--------- 165 hours. = 7 days ahead ---- unset($eit); $ivy_nr = 0; for ($i = 0; $i < 168; $i = $i + 3) { //***** Sections after 3 hours $pip = $i + 3; $ltabid = tableid($sek_nr_cont); // finds tableID $sek_nr_arr = passeknr($row2[pidas], $row1[esid], $conn, $sek_nr_cont); // calculates the last section number $pasksecnr = $sek_nr_arr[0]; $lastabid = $sek_nr_arr[1]; if ($sek_nr == 256) { $sek_nr = 0; } //---------------------------------------- segment ---------------------------- //--------------- Selects each pid information for 3 hours. time (segment) ------------------------- $sql3 = "SELECT\n epg_sched.ext_pid AS pidas,\n epg_kan.esid,\n DATE_FORMAT(epg_sched.estart, '%Y%m%d%H%i%S') AS startas,\n TIME_FORMAT(epg_sched.estop, '%H%i%s') AS stopas,\n TRIM(epg_sched.title) AS title,\n LTRIM(epg_sched.edesc) AS edesc,\n epg_sched.edesc_lang,\n epg_sched.title_lang\n FROM epg_sched,\n epg_kan\n WHERE epg_kan.ext_pid = epg_sched.ext_pid\n AND epg_sched.estart >= (SELECT TIMESTAMPADD(HOUR, '" . $i . "', CURDATE()))\n AND epg_sched.estart < (SELECT TIMESTAMPADD(HOUR, '" . $pip . "', CURDATE()))\n AND epg_sched.pid = " . $row2['pidas'] . "\n ORDER BY startas;"; $result3 = mysqli_query($conn, $sql3); unset($eventall); unset($descall); unset($ben_sek_il);