kyleAI_13

listMaps.api

Feb 19th, 2017
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 7.72 KB | None | 0 0
  1. <?php header('Content-type: application/json; charset=utf8'); header("Access-Control-Allow-Origin: *");
  2. require_once "../core.php"; error_reporting(E_ALL & ~E_NOTICE);
  3. $filter = ''; $and = ''; $WHERE .= ""; $LIMIT = ''; $_PAGE[] =''; $ORDER = 'ORDER by `date` DESC'; $oBY = '';
  4. if (isset($_GET['o']) && $_GET['o'] != 'views') {
  5.     $oBY = preg_replace('/[^0-9a-zA-Z_-]/', '', $_GET['o']);
  6.     $ORDER = "ORDER BY `{$oBY}` DESC";
  7. }
  8. if (isset($_GET['gtype']) && !empty($_GET['gtype'])) {
  9.     $filter = preg_replace('/[^ \w0-9a-zA-Z_-]/', '', $_GET['gtype']);
  10.     $WHERE .= " AND `gametype` = '{$filter}'";
  11. }
  12. if (isset($_GET['map']) && !empty($_GET['map'])) {
  13.     $filter = preg_replace('/[^ \w0-9a-zA-Z_-]/', '', $_GET['map']);
  14.     $WHERE .= " AND `map` = '{$filter}'";
  15. }
  16. if (isset($_GET['creator']) && !empty($_GET['creator'])) {
  17.     $filter = preg_replace('/[^ \w0-9a-zA-Z_-]/', '', $_GET['creator']);
  18.     $WHERE .= " AND `creator` = '{$filter}'";
  19. }
  20. if (isset($_GET['uid']) && !empty($_GET['uid'])) {
  21.     $filter = preg_replace('/[^ \w0-9a-zA-Z_-]/', '', $_GET['uid']);
  22.     $WHERE .= " AND `uid` = '{$filter}'";
  23. }
  24. if (isset($_GET['p']) && is_numeric($_GET['p']) && isset($_GET['r']) && is_numeric($_GET['r'])) {
  25.     $p = (int) $_GET['p'] -1;
  26.     $r = (int) $_GET['r'];
  27.     $s = ($p) ?  ($p * $r) : 0;
  28.     $LIMIT = "LIMIT {$s}, {$r}";
  29.     $tcount = $_SQL->query("SELECT uid FROM `maps` WHERE public != 'n' {$WHERE}") or die($_SQL->error);
  30.     $total = $tcount->num_rows;
  31.     $page['totalMaps'] = "$total";
  32.     $page['currentPage'] = "".($p+1)."";
  33.     $begResult = $s + 1;
  34.     $endResult = $s + $r; if ($endResult > $total) { $endResult = $total; }
  35.     $page['results'] = "".$begResult."-".$endResult." out of ".$page['totalMaps'];
  36.     $tc = $_SQL->query("SELECT uid FROM `maps` WHERE public != 'n' {$WHERE} {$LIMIT}") or die($_SQL->error);
  37.     $t = $tc->num_rows;
  38.     $page['mapsOnPage'] = "$t";
  39.     if ($page['mapsOnPage'] > 0 && $page['mapsOnPage'] < $r) {$page['pagesPossible'] = $page['currentPage'];}
  40.     else { $page['pagesPossible'] = "".ceil($total / $r).""; }
  41.     $_PAGE[] = $page;
  42. }
  43. if (!isset($_GET['map']) && !isset($_GET['creator']) && !isset($_GET['uid']) && !isset($_GET['gtype']) && isset($_GET['search']) && preg_match('/^[a-z0-9.\-\_]+$/i', $_GET['search'])) {
  44.     $sql = $_SQL->query("SELECT *, NULL as url FROM `maps` WHERE `title` LIKE '%{$_GET['search']}%' OR `creator` LIKE '%{$_GET['search']}%' OR `map` LIKE '%{$_GET['search']}%' OR `gametype` LIKE '%{$_GET['search']}%' AND (public != 'n' {$WHERE}) {$ORDER} {$LIMIT}") or die($_SQL->error);
  45.     if ($sql->num_rows < 1) { $sql = $_SQL->query("SELECT *, NULL as url FROM `maps` WHERE public != 'n' {$WHERE} {$ORDER} {$LIMIT}") or die($_SQL->error); }
  46. } else { $sql = $_SQL->query("SELECT *, NULL as url FROM `maps` WHERE public != 'n' {$WHERE} {$ORDER} {$LIMIT}") or die($_SQL->error); }
  47. if (isset ($_GET['o']) && $_GET['o'] == 'views') {
  48.     $sql = $_SQL->query("SELECT m.*, COUNT(v.id) AS views FROM maps AS m LEFT JOIN views AS v ON v.map_id=m.id WHERE public != 'n' {$WHERE} GROUP BY m.id ORDER BY views DESC {$LIMIT}") or die($_SQL->error);
  49. }
  50. while ($forge = $sql->fetch_assoc()) {
  51.     $submitter = $_SQL->query("SELECT uname FROM users WHERE id = '{$forge['uid']}'");
  52.     $sub = $submitter->fetch_assoc(); $forge['submitter'] = $sub['uname'];
  53.     $forge['url'] = "//halovau.lt/forge.php?dl&id=".$forge['id'].""; $forgeIMG = $forge['img'];
  54.     $map = preg_replace('/[^ \w0-9a-zA-Z_-]/', '', $forge['map']);
  55.     $forgeIMG = $forge['img']; if (empty($forge['img'])) { $forgeIMG = "/css/images/".preg_replace('/\s+/', '', $map).".jpg"; }
  56.     $forgeIMG0 = str_replace('/css/', '//halovau.lt/css/', $forgeIMG);
  57.     $forgeIMG2 = str_replace('http://halovau.lt//halovau.lt/css/', '//halovau.lt/css/', $forgeIMG0);
  58.     if ($forge['img'] != Thumb($forge['img'])) { $forge['thumbnail'] = Thumb($forge['img']); }
  59.     $forge['img'] = str_replace(' ', '', $forgeIMG2);
  60.     $forgePub = removeBB($forge['info']);
  61.     $forgePub = preg_replace('/:[\s\S]+?:/', '', $forgePub);
  62.     $forge['cleanInfo'] = str_replace('Posted on HaloShare', '', $forgePub);
  63.     $forgeI = str_replace("\\\"", '"', $forge['info']);
  64.     $forge['info'] = bb_parse(htmlentities($forgeI));
  65.     if ($forge['map'] == 'diamondback') {
  66.         $forgeQuote = "Hot winds blow over what should be a dead moon. A reminder of the power Forerunners once wielded."; }
  67.     if ($forge['map'] == 'edge') {
  68.         $forgeQuote = "The remote frontier world of Partition has provided this ancient databank with the safety of seclusion."; }
  69.     if ($forge['map'] == 'guardian') {
  70.         $forgeQuote = "Millennia of tending has produced trees as ancient as the Forerunner structures they have grown around."; }
  71.     if ($forge['map'] == 'icebox') {
  72.         $forgeQuote = "Downtown Tyumen's Precinct 13 offers an ideal context for urban combat training."; }
  73.     if ($forge['map'] == 'narrows') {
  74.         $forgeQuote = "Without cooling systems such as these, excess heat from the Ark's forges would render the construct uninhabitable."; }
  75.     if ($forge['map'] == 'reactor') {
  76.         $forgeQuote = "Being constructed just prior to the Invasion, its builders had to evacuate before it was completed."; }
  77.     if ($forge['map'] == 'standoff') {
  78.         $forgeQuote = "Once, nearby telescopes listened for a message from the stars. Now, these silos contain our prepared response."; }
  79.     if ($forge['map'] == 'the pit') {
  80.         $forgeQuote = "Software simulations are held in contempt by the veteran instructors who run these training facilities."; }
  81.     if ($forge['map'] == 'valhalla') {
  82.         $forgeQuote = "The crew of V-398 barely survived their unplanned landing in this gorge, but they know they are not alone."; }
  83.     if ($forge['map'] == 'last resort') {
  84.         $forgeQuote = "Remote industrial sites like this one are routinely requisitioned & used as part of Spartan training exercises."; }
  85.     if ($forge['map'] == 'high ground') {
  86.         $forgeQuote = "A relic of older conflicts, this base was reactivated after the New Mombasa Slipspace Event."; }
  87.     if ($forge['map'] == 'sandtrap') {
  88.         $forgeQuote = "Although the Brute occupiers have been driven from this ancient structure, they left plenty to remember them by."; }
  89.     if ($forge['map'] == 'flatgrass') {
  90.         $forgeQuote = "Modders offering a plain flat map with an extended pallet of items ideal for Forge."; }
  91.     $forge['tdr'] = $forgeQuote;
  92.     $forge['gametype'] = ucwords($forge['gametype']);
  93.     preg_match_all('/https?:\/\/drive.google.com\/open\?id\=([0-9A-Za-z-_]+)/si', $forge['cleanInfo'], $matches);
  94.     $driveLinks = array_map(function($match) {
  95.         return "https://drive.google.com/uc?export=download&id=" .$match[1];
  96.     }, $matches);
  97.     $forge['gtypeURLs'] = $driveLinks;
  98.     $forge['variantName'] = strtok($forge['title'], ':');
  99.     if ($forge['variantName'] == $forge['title']) { $forge['variantName'] = ''; }
  100.     $forge['map'] = ucwords($map);
  101.     $forgeV = $_SQL->query("SELECT * FROM views WHERE map_id = '".$forge['id']."'");
  102.     $forge['views'] = "$forgeV->num_rows";
  103.     $toRemove = substr($forge['title'], 0, strpos($forge['title'], ":")).': ';
  104.     $forge['title'] = str_replace($toRemove, '', $forge['title']);
  105.     if (isset($_USER['name']) && !empty($forge['directURL']) && $forge['public'] != 'r' || $_USER['group'] > 2) { $forge['directURL'] = "//dewsha.re".$forge['directURL']."sandbox.map"; }
  106.     else { $forge['directURL'] = ''; }
  107.     $_FORGE[] = $forge;
  108. }
  109. $pageJson1 = json_encode($_PAGE, JSON_PRETTY_PRINT);
  110. $pageJsonX = str_replace('"",', '
  111. "PAGE_RESULTS":', $pageJson1);
  112. $pageJson2 = str_replace('[
  113. ', '{
  114. ', $pageJsonX);
  115. $pageJson = str_replace(']', ',', $pageJson2);
  116. $mapsJson1 = json_encode($_FORGE, JSON_PRETTY_PRINT);
  117. $mapsJsonX = str_replace("\\/", "/", $mapsJson1);
  118. $mapsJson = str_replace('tdr', 'mapQuote', $mapsJsonX);
  119. if (isset($_GET['p']) AND is_numeric($_GET['p']) OR $_FORGE['mapsOnPage'] > 0) {
  120.     print_r("".$pageJson."
  121.  
  122. \"MAP_RESULTS\":
  123. ".$mapsJson."
  124. }");
  125. } else { print_r(rtrim($mapsJson)); }
  126. ?>
Advertisement
Add Comment
Please, Sign In to add comment