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