<div class='nc_admin_form_menu_hr'></div>
</div>
<div class='nc_admin_form_body nc-admin'>
<div style="padding-right: 15px;">
<?php
echo CONTROL_CONTENT_SUBDIVISION_FUNCS_SELECT_ROOT_SECTION;
?>
</div>
<br>
<select name="ParentSubID" style="width: 270px;">
<option value="0"><?php
echo CONTROL_CONTENT_SUBDIVISION_FUNCS_LINEADD_ROOT;
?>
</option>
<?php
echo nc_print_root_subdivisions($CatalogueID);
?>
</select>
</div>
<div class='nc_admin_form_buttons'>
<button type='button' class='nc_admin_metro_button nc-btn nc--blue' onclick='nc_load_add_subdivision_form();'><?php
echo CONTROL_CONTENT_SUBDIVISION_FUNCS_CONTINUE;
?>
</button>
<button type='button' class='nc_admin_metro_button_cancel nc-btn nc--red nc--bordered nc--right' onclick='$nc.modal.close();'><?php
echo CONTROL_BUTTON_CANCEL;
?>
</button>
</div>
function nc_print_root_subdivisions($CatalogueID, $ParentSubID = 0, $level = 0)
{
global $db, $nc_core;
global $perm;
$CatalogueID = intval($CatalogueID);
$ParentSubID = intval($ParentSubID);
static $security_limit, $initialized;
if (!$initialized) {
$initialized = true;
$allow_id = $perm->GetAllowSub($CatalogueID, MASK_ADMIN | MASK_MODERATE);
$security_limit = is_array($allow_id) && !$perm->isGuest() ? " Subdivision_ID IN (" . join(', ', (array) $allow_id) . ")" : " 1";
}
$result = $db->get_results("SELECT a.Subdivision_ID,a.Subdivision_Name,a.Priority,a.Checked,a.Hidden_URL,b.Domain,a.Catalogue_ID,a.ExternalURL FROM Subdivision AS a, Catalogue AS b\n WHERE a.Catalogue_ID=b.Catalogue_ID AND a.Catalogue_ID = {$CatalogueID} AND a.Parent_Sub_ID = {$ParentSubID} AND {$security_limit} ORDER BY a.Priority", ARRAY_A);
if (!$result) {
return false;
}
$spacer = ' ';
for ($i = 0; $i < $level; $i++) {
$spacer .= ' ';
}
foreach ($result as $row) {
echo "<option value='{$row['Subdivision_ID']}'>{$spacer}{$row['Subdivision_ID']}. {$row['Subdivision_Name']}</option>";
nc_print_root_subdivisions($CatalogueID, $row['Subdivision_ID'], $level + 1);
}
return true;
}
