accept($fields)) { if ($fields["id"]) { $fields["post_date"]=$fields["year"]."-".$fields["month"]."-".$fields["day"]; print $fields["post_date"]; $query = new CUpdateFAQ(); $query->accept_form_fields($fields); $query->set_params( array("id" => $fields["id"]) ); $query->execute(); } else { $query = new CNewFAQ(); $query->accept_form_fields($fields); $query->execute(); // print "ID: ".$query->get_last_insert_id(); } } else { $mode = "edit"; $id = $fields["id"]; } break; case "delete": if (count($pid)) { $query = new CDeleteFAQ(); $query->set_params( array("id" => $pid) ); $query->execute(); } break; case "changefilter": $_SESSION[pcl][category_filter] = $_POST[ref_category]; $_SESSION[pcl][question_filter] = $_POST[name]; break; } switch ($_GET[mode]) { case "new": case "edit": $page->init("admin_news_editor.tpl", $_page); if ($_GET[id]) { $data->set_params( array("id" => $_GET[id]) ); $data->get_row(); } $editor->controls["page"]["value"] = $_page; // print ($editor->read_template()); $page->assign( array("EDITOR" => $editor->fill($data->row)) ); break; default: $page->init("faq.tpl", $_page); $cat_data = new CFAQCategoriesTable(); if (isset($_GET[id])) { $cat_data->set_params( array("id" => $_GET[id]) ); } $cat_data->get_all(); foreach($cat_data->rows as $cat) { $menu = new CForm(); $menu->template="faq_category.grid"; $menu->controls = array("category" => array("field" => "name", "type" => CONTROL_HTML)); $menu_fields["name"]=$cat["name"]; $faq_html.=$menu->fill($menu_fields); $faq_links = new CFAQLinks(); $faq_data = new CFAQsTable(); if ($_GET[action]="search") { // $_SESSION[pcl][category_filter] = $_POST[ref_category]; $faq_data->set_params( array("ref_category" => $cat["id"], "search" => $_POST[name]) ); // $search_filter = $_POST[name]; } else { $faq_data->set_params( array("ref_category" => $cat["id"]) ); } $faq_html.=$faq_links->fill($faq_data); } // $pager = new CFAQsPager(); // Set search options $search = new CFAQsSearch(); $search->accept($fields); // print ($search->read_template()); $grid = new CFAQsGrid(); $data = new CFAQsTable(); $counter_data = new CFAQsCountTable(); $counter_data->set_params( array("ref_category" => $_SESSION[pcl][category_filter], "question" => $_SESSION[pcl][question_filter]) ); $counter_data->get_row(); $counter=$counter_data->row[counter]; $data->set_params( array("ref_category" => $_SESSION[pcl][category_filter], "question" => $_SESSION[pcl][question_filter]) ); // $filter->controls["pix_filter"]["value"] = $pcl["pix_filter"]; $page->assign( array( "SEARCH" => $search->fill($fields), "FAQ" => $faq_html, "DATA" => $grid->fill($data, $_page), "SCRIPT" => $script_name, "COUNTER" => $counter )); break; } // $_SESSION[pcl]=$pcl; $page->page_title="OH Web Hosting FAQ/Knowledge Base: Pre-Sales, Domain Registration, Billing & Payments, CGI Scripts and Databases"; $page->print_page(); // print $debug_info; $_time2=getmicrotime(); $_time=$_time2-$_time1; // printf("Execution time: %f
",$_time); ?>