function autologin($usr = "", $pwd = "") { if (empty($_COOKIE['user_al']) && empty($usr) && empty($pwd)) { return false; } else { if (!empty($usr) && !empty($pwd)) { $dump = query("SELECT * FROM `" . LOGIN_TABLE . "` WHERE email LIKE " . escapesql($usr) . ""); if (empty($dump[0]["password"])) { return -1; } if (md5($pwd) == $dump[0]["password"]) { $login = true; } } else { $dump = query("SELECT * FROM " . LOGIN_TABLE . " WHERE MD5(CONCAT(email,password)) = " . escapesql($_COOKIE['user_al']) . ""); if (!empty($dump[0]["password"])) { $login = true; $autologin = true; } } if (isset($login)) { $_SESSION['loggedin'] = true; $_SESSION['name'] = $dump[0]["name"]; $_SESSION['email'] = $dump[0]["email"]; if ($_SERVER['SERVER_PROTOCOL'] == 'HTTP/1.1') { if (php_sapi_name() == 'cgi') { header('Status: 303 See Other'); } else { header('HTTP/1.1 303 See Other'); } } return 1; } return -1; } }
foreach ($v_array as $v => $kk) { if (!is_array($kk)) { ${$v} = utf8_decode($kk); } else { ${$v} = utf8_decode(json_encode($kk)); } } if ($epgData) { $epgData_yes = 1; } else { $epgData_yes = 0; } if (!$showTitle) { $showTitle = $name; } query(" INSERT IGNORE INTO `videos` (\n`videotitle` ,\n`vtype` \n)\nVALUES (\n" . trim(escapesql(trim($showTitle))) . ",\n'tvshow'\n )"); $getvideoid = query("SELECT videos_id FROM videos WHERE `videotitle` LIKE " . trim(escapesql(trim($showTitle))) . ""); $videos_id = $getvideoid[0]["videos_id"]; if (!$broadcastTime) { $broadcastTime = $publicationTime; } if (!$broadcastTime) { $broadcastTime = time(); } query("INSERT IGNORE INTO `tvevent` (\n`videotitle` ,\n`imageurl` ,\n`videosid` ,\n`watchurl` ,\n`description` ,\n`duration` ,\n`showtitle` ,\n`episode` ,\n`videos_id` ,\n`type` ,\n`magnetId` ,\n`publicationTime` ,\n`fullVideo` ,\n`season` ,\n`episodeTitle` ,\n`preview` ,\n`premium` ,\n`price` ,\n`fileLocations` ,\n`broadcaster` ,\n`broadcastId` ,\n`mobileLicense` ,\n`ageRestriction` ,\n`sources_id`,\nepgData,\nepgData_yes,\nbroadcastTime\n)\nVALUES (\n" . escapesql($name) . ",\n" . escapesql($image) . ",\n" . escapesql($entityId) . ",\n" . escapesql($url) . ",\n" . escapesql($description) . ",\n" . escapesql($duration) . ",\n" . escapesql($showTitle) . ",\n" . escapesql($episode) . ",\n" . escapesql($videos_id) . ",\n" . escapesql($type) . ",\n" . escapesql($magnetId) . ",\n" . escapesql($publicationTime) . ",\n" . escapesql($fullVideo) . ",\n" . escapesql($season) . ",\n" . escapesql($episodeTitle) . ",\n" . escapesql($preview) . ",\n" . escapesql($premium) . ",\n" . escapesql($price) . ",\n" . escapesql($fileLocations) . ",\n" . escapesql($broadcaster) . ",\n" . escapesql($broadcastId) . ",\n" . escapesql($mobileLicense) . ",\n" . escapesql($ageRestriction) . ", \n" . escapesql($row_array["sources_id"]) . ",\n" . escapesql($epgData) . ",\n" . escapesql($epgData_yes) . ",\n" . escapesql(date("Y-m-d H:i:s", $broadcastTime)) . ")"); } } // $jsonbc=file_get_contents("http://tvhackday.mixd.tv/video-list/".$row_array["entityid"]."/?api_key=e9ec497a-553c-11c8-abf2-82462f16f1f8"); } } require dirname(__FILE__) . "/incl/_footer.php";
} $date = date('d. ', strtotime($V)); $date .= $tmonth; $date .= date(' Y, H:i \\U\\h\\r', strtotime($V)); $V = $date; } if (empty($V)) { $V = ''; } $jsondata[$list][$K] = $V; } } } $genre_array = array(); if (!empty($getdata[0]["entityId"])) { $getgenres = query("SELECT genres.genre FROM genres INNER JOIN videos_genres ON genres.genres_id=videos_genres.genres_id\n WHERE `videos_id` = " . escapesql($getdata[0]["item"]) . " ORDER BY gtype LIMIT 1"); if (is_array($getgenres)) { foreach ($getgenres as $genre_array) { if (!empty($genre_array["genre"])) { $genre_array[] = $genre_array["genre"]; } } } } $jsondata[$list]['genre'] = implode(", ", array_unique($genre_array)); } if (!empty($_REQUEST["debug"])) { print_r($jsondata); exit; } echo json_encode($jsondata);
<?php define("checkaccess", true); require dirname(__FILE__) . "/incl/init.php"; require dirname(__FILE__) . "/incl/_header.php"; $getdata = query("SELECT\n*\nFROM tvevent\nWHERE epgData_yes=1\n LIMIT 10000"); foreach ($getdata as $part_array) { $meta = json_decode($part_array["epgData"], true); // print_r($meta); $genres = search_in_array("genre", $meta); if (!empty($genres)) { print_r($genres); foreach ($genres as $genre) { query("INSERT IGNORE INTO genres (genre,gtype) VALUES (" . escapesql(utf8_decode($genre)) . ",'')"); $getgenre = query("SELECT genres_id FROM genres WHERE `genre` =" . escapesql(utf8_decode($genre)) . ""); if (!empty($getgenre[0]["genres_id"])) { query("INSERT IGNORE INTO videos_genres (videos_id,genres_id) VALUES (" . escapesql($part_array["videos_id"]) . "," . escapesql($getgenre[0]["genres_id"]) . ")"); } } echo '<br>'; } } require dirname(__FILE__) . "/incl/_footer.php";