function get_addcategory_assignedcat($page_id, $level)
{
global $ft;
$query = sprintf("\n SELECT \n category_id, \n category_parent_id, \n category_name \n FROM \n %1\$s \n WHERE \n category_parent_id = '%2\$d' \n ORDER BY \n category_id \n ASC", TABLE_CATEGORY, $page_id);
$db = new DB_SQL();
$db->query($query);
$id = isset($_GET['id']) ? intval($_GET['id']) : 0;
while ($db->next_record()) {
$cat_id = $db->f("category_id");
$cat_parent_id = $db->f("category_parent_id");
$cat_name = $db->f("category_name");
$ft->assign(array('C_ID' => $cat_id, 'C_NAME' => $cat_name, 'CURRENT_CAT' => '', 'PAD' => 'style="padding-left:' . 8 * $level . 'px;" '));
$ft->parse('CAT_ROW', ".cat_row");
get_addcategory_assignedcat($cat_id, $level + 2);
}
}
} else {
$monit[] = $i18n['add_note'][3];
foreach ($monit as $error) {
$ft->assign('ERROR_MONIT', $error);
$ft->parse('ROWS', ".error_row");
}
$ft->parse('ROWS', "error_reporting");
}
} else {
if (!empty($preview)) {
$text = $_POST['text'];
$title = trim($_POST['title']);
$ft->assign(array('N_TITLE' => stripslashes($title), 'N_TEXT' => br2nl(stripslashes($text)), 'NT_TEXT' => nl2br(parse_markers(stripslashes($text), 1)), 'NOTE_PREVIEW' => true));
} else {
$ft->assign('NOTE_PREVIEW', false);
}
$query = sprintf("\r\n SELECT \r\n category_id, \r\n category_parent_id,\r\n category_name \r\n FROM \r\n %1\$s \r\n WHERE \r\n category_parent_id = '%2\$d' \r\n ORDER BY \r\n category_id \r\n ASC", TABLE_CATEGORY, 0);
$db->query($query);
$ft->define("form_noteadd", "form_noteadd.tpl");
$ft->define_dynamic("cat_row", "form_noteadd");
while ($db->next_record()) {
$cat_id = $db->f("category_id");
$cat_parent_id = $db->f("category_parent_id");
$cat_name = $db->f("category_name");
$ft->assign(array('C_ID' => $cat_id, 'C_NAME' => $cat_name, 'CURRENT_CAT' => $cat_id == 1 ? 'checked="checked"' : '', 'PAD' => ''));
$ft->parse('CAT_ROW', ".cat_row");
get_addcategory_assignedcat($cat_id, 2);
}
$ft->assign(array('SESSION_LOGIN' => $_SESSION['login'], 'DATE' => date('Y-m-d H:i:s')));
$ft->parse('ROWS', "form_noteadd");
}
