$ft->parse('ROWS', ".error_row"); } $ft->parse('ROWS', "error_reporting"); } } else { $monit[] = $i18n['transfer_note'][3]; foreach ($monit as $error) { $ft->assign('ERROR_MONIT', $error); $ft->parse('ROWS', ".error_row"); } $ft->parse('ROWS', "error_reporting"); } break; default: $ft->define("form_notetransfer", "form_notetransfer.tpl"); $ft->define_dynamic("current_row", "form_notetransfer"); $ft->define_dynamic("target_row", "form_notetransfer"); $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); $db->query($query); while ($db->next_record()) { $c_id = $db->f("category_id"); $c_name = $db->f("category_name"); $ft->assign(array('CURRENT_CID' => $c_id, 'TARGET_CID' => $c_id, 'CURRENT_CNAME' => $c_name, 'TARGET_CNAME' => $c_name)); $ft->parse('CURRENT_ROW', ".current_row"); $ft->parse('TARGET_ROW', ".target_row"); // rekurencyjnie pobieramy kategorie wpisów get_transfercategory_cat($c_id, 2); } $ft->assign(array('SESSION_LOGIN' => $_SESSION['login'], 'DATE' => date('Y-m-d H:i:s'))); $ft->parse('ROWS', "form_notetransfer"); }
function get_transfercategory_cat($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); 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('CURRENT_CID' => $cat_id, 'TARGET_CID' => $cat_id, 'CURRENT_CNAME' => str_repeat(' ', $level) . "- " . $cat_name, 'TARGET_CNAME' => str_repeat(' ', $level) . "- " . $cat_name)); $ft->parse('CURRENT_ROW', ".current_row"); $ft->parse('TARGET_ROW', ".target_row"); get_transfercategory_cat($cat_id, $level + 2); } }