Exemple #1
0
} 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);
Exemple #2
0
 $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);