header('Content-type: text/html; charset=utf-8');
}
if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_METHOD'])) {
header("Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS");
}
if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS'])) {
header("Access-Control-Allow-Headers: {$_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']}");
}
}
include "mysql.class.php";
$database = new MySQL();
global $database;
if (!isset($_GET["parametro"])) {
if ($database->Query("SELECT\n kiiconnect_setting.nombre,\n kiiconnect_setting.tag,\n kiiconnect_setting.descripcion,\n kiiconnect_setting.icono,\n kiiconnect_setting.link,\n kiiconnect_categoria.nombre AS categoria,\n kiiconnect_categoria.id AS id_categoria,\n kiiconnect_categoria.filecategoria,\n kiiconnect_categoria.filecategoria2,\n kiiconnect_categoria.icono AS categoria_icono\n FROM\n kiiconnect_setting\n INNER JOIN kiiconnect_categoria ON kiiconnect_setting.id_categoria = kiiconnect_categoria.id\n WHERE\n activo = 1\n ORDER BY\n orden ASC")) {
echo $database->GetJSON();
} else {
echo "<p>Query Failed</p>";
}
} else {
$temp = $database->QueryArray("SELECT\n kiiconnect_categoria.nombre AS categoria,\n kiiconnect_categoria.id AS id_categoria,\n kiiconnect_categoria.iconodev AS categoria_icono,\n kiiconnect_categoria.filecategoriadev AS filecategoria\n FROM\n kiiconnect_categoria\n WHERE\n activo = 1\n ORDER BY orden2", MYSQL_ASSOC);
$temp2 = array();
foreach ($temp as $index => $categoria) {
$categoria_id = $categoria['id_categoria'];
// CONCAT('" . '<span style="font-weight:bold">' ." ', kiiconnect_setting.nombre, '</span>') AS nombre,
$itemsCategoria = $database->QueryArray("SELECT\n kiiconnect_setting.nombre,\n kiiconnect_setting.tag,\n kiiconnect_setting.descripcion,\n kiiconnect_setting.icono,\n kiiconnect_setting.file,\n kiiconnect_setting.link\n FROM\n kiiconnect_setting\n WHERE\n activo = 1 AND id_categoria = {$categoria_id}\n ORDER BY\n orden ASC", MYSQL_ASSOC);
if ($itemsCategoria != false) {
$categoria['items'] = $itemsCategoria;
$temp2[] = $categoria;
}
}
<?php
include "mysql.class.php";
$databaseXmltv = new MySQL();
if ($databaseXmltv->Query("SELECT xmltv_canal.id,\n xmltv_canal.nombre as title\n FROM xmltv_canal WHERE activo = 1 ORDER BY orden")) {
$canales = $databaseXmltv->GetJSON();
$data = $databaseXmltv->RecordsArray();
} else {
$canales = "''";
}
//////////////////////////
?>
{
"calendars": <?php
echo $canales;
?>
}
header('Access-Control-Allow-Methods: POST, GET, OPTIONS');
header('Content-type: text/html; charset=utf-8');
}
if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_METHOD'])) {
header("Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS");
}
if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS'])) {
header("Access-Control-Allow-Headers: {$_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']}");
}
}
//////////////////////////
include "mysql.class.php";
$databaseXmltv = new MySQL();
if ($databaseXmltv->Query("SELECT xmltv_canal.id,\n xmltv_canal.nombre,\n xmltv_canal.file\n FROM xmltv_canal WHERE activo = 1 ORDER BY orden")) {
$canales = $databaseXmltv->GetJSON();
} else {
$canales = "''";
}
//CONCAT(UNIX_TIMESTAMP (fecha_inicio), '000') as inicio,
//CONCAT(UNIX_TIMESTAMP (fecha_fin), '000') as fin,
// consulta que me devuelve los programas segun la fecha (ejemplo en fecha actual )
$programas = programacion($fecha);
if ($databaseXmltv->Query("SELECT xmltv_programacion.id,\n xmltv_programacion.id_canal,\n xmltv_programacion.id_programa,\n xmltv_programa.titulo,\n IF(length(xmltv_programacion.descripcion) > 0, CONCAT(xmltv_programa.descripcion, ', ' , xmltv_programacion.descripcion) , xmltv_programa.descripcion ) AS descripcion,\n xmltv_programa.tipo,\nDAYOFWEEK(xmltv_programacion.creado),\n CONCAT(CAST(UNIX_TIMESTAMP (CONCAT(CURDATE(), ' ', horario)) AS INT), '000') as inicio,\n CONCAT(CAST(UNIX_TIMESTAMP (CONCAT(CURDATE(), ' ', horario)) AS INT) + xmltv_programacion.duracion * 60, '000') as fin,\n xmltv_programacion.duracion,\n xmltv_programa.file\n FROM xmltv_programacion INNER JOIN xmltv_programa ON xmltv_programacion.id_programa = xmltv_programa.id\n\t\t\t\t\t\t\tWHERE IF(xmltv_programacion.fecha_fin IS NOT NULL, xmltv_programacion.fecha_inicio < CURDATE() AND CURDATE() < xmltv_programacion.fecha_fin , xmltv_programacion.fecha_inicio < CURDATE()) AND\n\t\t\t\t\t\t\txmltv_programa.activo = 1;\n\t\t\t\t\t\t\t")) {
$programas = $databaseXmltv->GetJSON();
} else {
$programas = "''";
}
//////////////////////////
$json = '[{
"categoria": "canal",
header("Access-Control-Allow-Origin: {$_SERVER['HTTP_ORIGIN']}");
header('Access-Control-Allow-Credentials: true');
header('Access-Control-Max-Age: 86400');
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: POST, GET, OPTIONS');
header('Content-type: text/html; charset=utf-8');
}
if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_METHOD'])) {
header("Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS");
}
if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS'])) {
header("Access-Control-Allow-Headers: {$_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']}");
}
}
include "mysql.class.php";
$databaseKiiconnect = new MySQL();
global $databaseKiiconnect;
//
if (isset($_GET["tags"])) {
$tags = $_GET["tags"];
$bodytag = '"' . str_replace(",", '","', $tags) . '"';
$consultaTag = "AND tag in ({$bodytag})";
} else {
$consultaTag = "";
}
if ($databaseKiiconnect->Query("SELECT *\n FROM\n kiiconnect_mensajes\n WHERE activo = 1 {$consultaTag}\n ORDER BY creado DESC ")) {
echo $databaseKiiconnect->GetJSON();
} else {
echo "<p>Query Failed</p>";
}
