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);
