function get_editnews_assignedcat($c_id, $level) { global $ft, $category, $sql; $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\$s' \n ORDER BY \n category_id \n ASC", TABLE_CATEGORY, $c_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"); $query = sprintf("\n SELECT * FROM \n %1\$s \n WHERE \n category_id = '%2\$d' \n AND \n news_id = '%3\$d'", TABLE_ASSIGN2CAT, $cat_id, $_GET['id']); $sql->query($query); $sql->next_record(); $ft->assign(array('C_ID' => $cat_id, 'PAD' => 'style="padding-left:' . 8 * $level . 'px;" ', 'C_NAME' => $cat_name, 'CURRENT_CAT' => $cat_id == ($assigned = $sql->f("category_id")) ? 'checked="checked"' : '')); $ft->parse('CAT_ROW', ".cat_row"); get_editnews_assignedcat($cat_id, $level + 2); } }
} $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'", TABLE_CATEGORY, 0); $sql = new DB_SQL(); $db->query($query); while ($db->next_record()) { $c_id = $db->f("category_id"); $c_name = $db->f("category_name"); $query = sprintf("\r\n SELECT * FROM \r\n %1\$s \r\n WHERE \r\n category_id = '%2\$d' \r\n AND \r\n news_id = '%3\$d'", TABLE_ASSIGN2CAT, $c_id, $_GET['id']); $sql->query($query); $sql->next_record(); $assigned = $sql->f("category_id"); $ft->assign(array('C_ID' => $c_id, 'C_NAME' => $c_name, 'PAD' => '', 'CURRENT_CAT' => $c_id == $assigned ? 'checked="checked"' : '')); $ft->define("form_noteedit", "form_noteedit.tpl"); $ft->define_dynamic("cat_row", "form_noteedit"); $ft->parse('CAT_ROW', ".cat_row"); get_editnews_assignedcat($c_id, 2); } $ft->parse('ROWS', "form_noteedit"); } break; case "delete": // usuwanie wybranego wpisu // potwierdzenie usuniecia wpisu $confirm = empty($_POST['confirm']) ? '' : $_POST['confirm']; switch ($confirm) { case $i18n['confirm'][0]: $post_id = empty($_POST['post_id']) ? '' : $_POST['post_id']; if ($permarr['moderator']) { $query = sprintf("\r\n DELETE FROM \r\n %1\$s \r\n WHERE \r\n id = '%2\$d'", TABLE_MAIN, $post_id); $db->query($query); $ft->assign('CONFIRM', $i18n['edit_note'][1]);