<?php
$route = '/road_map/:road_map_id/';
$app->get($route, function ($road_map_id) use($app) {
$host = $_SERVER['HTTP_HOST'];
$road_map_id = prepareIdIn($road_map_id, $host);
$road_map_id = mysql_real_escape_string($road_map_id);
$ReturnObject = array();
$Query = "SELECT * FROM road_map WHERE road_map_id = " . $road_map_id;
$DatabaseResult = mysql_query($Query) or die('Query failed: ' . mysql_error());
while ($Database = mysql_fetch_assoc($DatabaseResult)) {
$road_map_id = $Database['road_map_id'];
$title = $Database['title'];
$image = $Database['image'];
$header = $Database['header'];
$footer = $Database['footer'];
$KeysQuery = "SELECT * from keys k";
$KeysQuery .= " WHERE road_map_id = " . $road_map_id;
$KeysQuery .= " ORDER BY name ASC";
$KeysResults = mysql_query($KeysQuery) or die('Query failed: ' . mysql_error());
$road_map_id = prepareIdOut($road_map_id, $host);
$F = array();
$F['road_map_id'] = $road_map_id;
$F['title'] = $title;
$F['image'] = $image;
$F['header'] = $header;
$F['footer'] = $footer;
// Keys
$F['keys'] = array();
while ($Keys = mysql_fetch_assoc($KeysResults)) {
$name = $Keys['name'];
<?php
$route = '/authentication/:authentication_id/';
$app->delete($route, function ($authentication_id) use($app) {
$host = $_SERVER['HTTP_HOST'];
$authentication_id = prepareIdIn($authentication_id, $host);
$authentication_id = mysql_real_escape_string($authentication_id);
$Add = 1;
$ReturnObject = array();
$request = $app->request();
$_POST = $request->params();
$query = "DELETE FROM authentication WHERE authentication_id = " . $authentication_id;
//echo $query . "<br />";
mysql_query($query) or die('Query failed: ' . mysql_error());
});
<?php
$route = '/url/:url_id/tags/:tag/';
$app->delete($route, function ($url_id, $tag) use($app) {
$host = $_SERVER['HTTP_HOST'];
$url_id = prepareIdIn($url_id, $host);
$ReturnObject = array();
$request = $app->request();
$param = $request->params();
if ($tag != '') {
$url_id = trim(mysql_real_escape_string($url_id));
$tag = trim(mysql_real_escape_string($tag));
$CheckTagQuery = "SELECT Tag_ID FROM tags where Tag = '" . $tag . "'";
$CheckTagResults = mysql_query($CheckTagQuery) or die('Query failed: ' . mysql_error());
if ($CheckTagResults && mysql_num_rows($CheckTagResults)) {
$Tag = mysql_fetch_assoc($CheckTagResults);
$tag_id = $Tag['Tag_ID'];
$DeleteQuery = "DELETE FROM url_tag_pivot where Tag_ID = " . trim($tag_id) . " AND Blog_ID = " . trim($url_id);
$DeleteResult = mysql_query($DeleteQuery) or die('Query failed: ' . mysql_error());
}
$tag_id = prepareIdOut($tag_id, $host);
$F = array();
$F['tag_id'] = $tag_id;
$F['tag'] = $tag;
$F['url_count'] = 0;
array_push($ReturnObject, $F);
}
$app->response()->header("Content-Type", "application/json");
echo format_json(json_encode($ReturnObject));
});
<?php
$route = '/dictionary/:dictionary_id/';
$app->delete($route, function ($dictionary_id) use($app) {
$host = $_SERVER['HTTP_HOST'];
$dictionary_id = prepareIdIn($dictionary_id, $host);
$Add = 1;
$ReturnObject = array();
$request = $app->request();
$_POST = $request->params();
$query = "DELETE FROM dictionary WHERE ID = " . $dictionary_id;
//echo $query . "<br />";
mysql_query($query) or die('Query failed: ' . mysql_error());
});
<?php
$route = '/report/:report_id/tags/:tag/';
$app->delete($route, function ($report_id, $tag) use($app) {
$host = $_SERVER['HTTP_HOST'];
$report_id = prepareIdIn($report_id, $host);
$ReturnObject = array();
$request = $app->request();
$param = $request->params();
if ($tag != '') {
$report_id = trim(mysql_real_escape_string($report_id));
$tag = trim(mysql_real_escape_string($tag));
$CheckTagQuery = "SELECT Tag_ID FROM tags where Tag = '" . $tag . "'";
$CheckTagResults = mysql_query($CheckTagQuery) or die('Query failed: ' . mysql_error());
if ($CheckTagResults && mysql_num_rows($CheckTagResults)) {
$Tag = mysql_fetch_assoc($CheckTagResults);
$tag_id = $Tag['Tag_ID'];
$DeleteQuery = "DELETE FROM report_tag_pivot where Tag_ID = " . trim($tag_id) . " AND Blog_ID = " . trim($report_id);
$DeleteResult = mysql_query($DeleteQuery) or die('Query failed: ' . mysql_error());
}
$tag_id = prepareIdOut($tag_id, $host);
$F = array();
$F['tag_id'] = $tag_id;
$F['tag'] = $tag;
$F['report_count'] = 0;
array_push($ReturnObject, $F);
}
$app->response()->header("Content-Type", "application/json");
echo format_json(json_encode($ReturnObject));
});
<?php
$route = '/content/:content_id/images/';
$app->get($route, function ($content_id) use($app) {
$host = $_SERVER['HTTP_HOST'];
$content_id = prepareIdIn($content_id, $host);
$ReturnObject = array();
$Query = "SELECT * FROM content_image ls";
$Query .= " WHERE ls.content_id = " . $content_id;
$DatabaseResult = mysql_query($Query) or die('Query failed: ' . mysql_error());
while ($Database = mysql_fetch_assoc($DatabaseResult)) {
$content_image_id = $Database['content_image_id'];
$path = $Database['image_url'];
$name = $Database['image_name'];
$type = $Database['type'];
$width = $Database['width'];
$content_image_id = prepareIdOut($content_image_id, $host);
$F = array();
$F['content_image_id'] = $content_image_id;
$F['name'] = $name;
$F['path'] = $path;
$F['type'] = $type;
$F['width'] = $width;
array_push($ReturnObject, $F);
}
$app->response()->header("Content-Type", "application/json");
echo format_json(json_encode($ReturnObject));
});
<?php
$route = '/link/:link_id/tags/';
$app->get($route, function ($link_id) use($app) {
$host = $_SERVER['HTTP_HOST'];
$link_id = prepareIdIn($link_id, $host);
$ReturnObject = array();
$request = $app->request();
$param = $request->params();
$Query = "SELECT t.tag_id, t.tag FROM tags t";
$Query .= " JOIN link_tag_pivot utp ON t.tag_id = utp.tag_id";
$Query .= " WHERE utp.link_id = " . $link_id;
$DatabaseResult = mysql_query($Query) or die('Query failed: ' . mysql_error());
while ($Database = mysql_fetch_assoc($DatabaseResult)) {
$tag_id = $Database['tag_id'];
$tag = $Database['tag'];
$tag_id = prepareIdOut($tag_id, $host);
$F = array();
$F['tag_id'] = $tag_id;
$F['tag'] = $tag;
array_push($ReturnObject, $F);
}
$app->response()->header("Content-Type", "application/json");
echo format_json(json_encode($ReturnObject));
});
<?php
$route = '/support/:support_id/';
$app->get($route, function ($support_id) use($app) {
$host = $_SERVER['HTTP_HOST'];
$support_id = prepareIdIn($support_id, $host);
$support_id = mysql_real_escape_string($support_id);
$ReturnObject = array();
$Query = "SELECT * FROM support WHERE support_id = " . $support_id;
$DatabaseResult = mysql_query($Query) or die('Query failed: ' . mysql_error());
while ($Database = mysql_fetch_assoc($DatabaseResult)) {
$support_id = $Database['support_id'];
$title = $Database['title'];
$image = $Database['image'];
$header = $Database['header'];
$footer = $Database['footer'];
$resourcesQuery = "SELECT * from resources r";
$resourcesQuery .= " WHERE support_id = " . $support_id;
$resourcesQuery .= " ORDER BY title ASC";
$resourcesResults = mysql_query($resourcesQuery) or die('Query failed: ' . mysql_error());
$support_id = prepareIdOut($support_id, $host);
$F = array();
$F['support_id'] = $support_id;
$F['title'] = $title;
$F['image'] = $image;
$F['header'] = $header;
$F['footer'] = $footer;
// resources
$F['resources'] = array();
while ($resources = mysql_fetch_assoc($resourcesResults)) {
$title = $resources['title'];
