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";
