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