<?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'];