mysqli_free_result($result); } # Getting our files if (SHOW_FILES && $files_limit > 0) { $query = "\tSELECT \n\t\t\t\t\t`f`.`created`,\n\t\t\t\t\t`f`.`filesize`,\n\t\t\t\t\t0 AS `is_dir`,\n\t\t\t\t\t`f`.`meta_mime_type`,\n \t\t\t\t\t`f`.`modified`,\n \t\t\t\t\t`f`.`name`,\n \t\t\t\t\tCONCAT(SUBSTRING(`d`.`path`,2),`d`.`name`,'/') AS `path`,\n \t\t\t\t\tCONCAT('" . NQ_DOMAIN_ROOT . '/' . $G_APP_DATA['id'] . '/view' . "',SUBSTRING(`d`.`path`,2),`d`.`name`,'/',`f`.`name`,'" . ($G_APP_ENVIRONMENT == 'prod' ? "" : "?env=" . $G_APP_ENVIRONMENT) . "') AS `url`,\n \t\t\t\t\t`f`.`version`\n\t\t\t\tFROM\n\t\t\t\t\t" . NQ_FILE_TABLE . " `f`\n\t\t\t\tLEFT JOIN\n\t\t\t\t\t" . NQ_DIRECTORY_TABLE . " `d`\n\t\t\t\t\t\tON\n\t\t\t\t\t\t\t`d`.`id`=`f`.`directory_id`\n\t\t\t\tWHERE\n\t\t\t\t\t`f`.`app_id`\t\t=" . (int) $G_APP_DATA['id'] . " AND\n\t\t\t\t\t`f`.`environment`\t='" . mysqli_escape_string($G_STORAGE_CONTROLLER_DBLINK, $G_APP_ENVIRONMENT) . "' AND\n\t\t\t\t\t`f`.`directory_id`\t=" . (int) $directory_data['id'] . "\n\t\t\t\tORDER BY\n\t\t\t\t\t`f`.`name`\n\t\t\t\tLIMIT " . $files_start . "," . $files_limit; $result = mysqli_multi_result_query($G_STORAGE_CONTROLLER_DBLINK, $query); $content_results = array_merge($content_results, mysqli_fetch_all($result, MYSQLI_ASSOC)); mysqli_free_result($result); } # Preping our content if (isset($_CGET['resultset']) && in_array($_CGET['resultset'], ['obj', 'object'])) { $ids = []; $content = (object) PostParser::xml_array(array_prefix_keys(array_merge($content_results, (array) $content), $ids, isset($_CGET['resultprefix']) && $_CGET['resultprefix'] != '' ? $_CGET['resultprefix'] : 'nqitem'), 'nqitems'); $content->ids = PostParser::xml_array($ids, 'id'); } else { $content = (object) ['results' => PostParser::xml_array(array_merge($content_results, (array) $content), 'nq-item')]; } $content->success = true; $content->children_filesize = PostParser::create_attribute($directory_data['children_filesize']); $content->created = PostParser::create_attribute($directory_data['created']); $content->directories = PostParser::create_attribute($directory_data['directories']); $content->env = PostParser::create_attribute($G_APP_ENVIRONMENT); $content->files = PostParser::create_attribute($directory_data['files']); $content->filesize = PostParser::create_attribute($directory_data['filesize']); $content->modified = PostParser::create_attribute($directory_data['modified']); $content->page = PostParser::create_attribute($page); $content->pages = PostParser::create_attribute($pages); $content->path = PostParser::create_attribute(substr($directory_data['path'], 1) . $directory_data['name'] == '' ? '/' : substr($directory_data['path'], 1) . $directory_data['name']); # Copying over our get variables and next page if ($page < $pages && !isset($_CGET['nopagination'])) { $cgets = array();
require_once __DIR__ . '/_includes/validate-app.php'; # Getting our template(s) if (isset($_CGET['tag']) && $_CGET['tag'] != '') { $query = "\tSELECT\n\t\t\t\t\t`name`,\n\t\t\t\t\t`tag`,\n\t\t\t\t\t`text`\n\t\t\t\tFROM\n\t\t\t\t\t" . NQ_CONSTANT_TABLE . "\n\t\t\t\tWHERE\n\t\t\t\t\t`app_id`\t=" . (int) $G_APP_DATA['id'] . " AND\n\t\t\t\t\t`environment` \tIN ('*','" . mysqli_escape_string($G_STORAGE_CONTROLLER_DBLINK, $G_APP_ENVIRONMENT) . "') AND\n\t\t\t\t\t`tag`\t\t='" . mysqli_escape_string($G_STORAGE_CONTROLLER_DBLINK, $_CGET['tag']) . "'\n\t\t\t\t\tLIMIT 1"; } else { $query = "\tSELECT\n\t\t\t\t\t`name`,\n\t\t\t\t\t`tag`,\n\t\t\t\t\t`text`\n\t\t\t\tFROM\n\t\t\t\t\t" . NQ_CONSTANT_TABLE . "\n\t\t\t\tWHERE\n\t\t\t\t\t`app_id`\t=" . (int) $G_APP_DATA['id'] . " AND\n\t\t\t\t\t`environment` \tIN ('*','" . mysqli_escape_string($G_STORAGE_CONTROLLER_DBLINK, $G_APP_ENVIRONMENT) . "')\n\t\t\t\tORDER BY\n\t\t\t\t\t`tag`"; } $result = mysqli_multi_result_query($G_STORAGE_CONTROLLER_DBLINK, $query); # Fetching our email constants $content = mysqli_fetch_all($result, MYSQLI_ASSOC); # Creating our content to return if (isset($_CGET['resultset']) && in_array($_CGET['resultset'], ['obj', 'object'])) { $ids = []; $content = (object) PostParser::xml_array(array_prefix_keys($content, $ids, isset($_CGET['resultprefix']) && $_CGET['resultprefix'] != '' ? $_CGET['resultprefix'] : 'nqitem'), 'nqitems'); $content->ids = PostParser::xml_array($ids, 'id'); } else { $content = (object) ['results' => PostParser::xml_array($content, 'nq-item')]; } $content->success = true; $content->env = PostParser::create_attribute($G_APP_ENVIRONMENT); # Sending our content PostParser::send($content); /* --- Connection closed wit PostParser::send --- Below this point things need to be tracked and cleaned up --- */ # Closing the storage connection mysqli_shared_close($G_STORAGE_CONTROLLER_DBLINK, $G_SHARED_DBLINKS); # Closing controller if tracking is different if (NQ_CONTROLLER_HOST != NQ_TRACKING_HOST) { mysqli_shared_close($G_CONTROLLER_DBLINK, $G_SHARED_DBLINKS); } # Adding our usage track_endpoint($G_SHARED_DBLINKS, $G_APP_DATA['id'], $G_APP_ENVIRONMENT, $_ENDPOINT);