/** * @desc Muestra la lista de categorías existentes */ function showCategories() { global $xoopsModuleConfig, $xoopsConfig, $xoopsModule, $xoopsSecurity; $db = XoopsDatabaseFactory::getDatabaseConnection(); $result = $db->query("SELECT * FROM " . $db->prefix("bxpress_categories") . " ORDER BY `order`, title"); $categos = array(); while ($row = $db->fetchArray($result)) { $catego = new bXCategory(); $catego->assignVars($row); $categos[] = array('id' => $catego->id(), 'title' => $catego->title(), 'desc' => $catego->description(), 'status' => $catego->status()); } bXFunctions::menu_bar(); $form = new RMForm('', '', ''); $groups = new RMFormGroups('', 'groups', 1, 1, 2, array(0)); xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » " . __('Categories', 'bxpress')); xoops_cp_header(); RMTemplate::get()->add_local_script('jquery.checkboxes.js', 'rmcommon', 'include'); RMTemplate::get()->add_local_script('admin.js', 'bxpress'); RMTemplate::get()->set_help('http://www.redmexico.com.mx/docs/bxpress-forums/categorias/standalone/1/'); RMTemplate::get()->add_head('<script type="text/javascript"> var bx_select_message = "' . __('You must select a category at least in order to run this action!', 'bxpress') . '"; var bx_message = "' . __('Do you really want to delete selected categories?\\n\\nAll forums under this category will be deleted also!', 'bxpress') . '"; </script>'); include RMTemplate::get()->get_template('admin/forums_categos.php', 'module', 'bxpress'); xoops_cp_footer(); }
/** * @desc Muestra la lista de categorías existentes */ function showCategories() { global $xoopsModuleConfig, $xoopsConfig, $xoopsModule, $xoopsSecurity; $db = XoopsDatabaseFactory::getDatabaseConnection(); $result = $db->query("SELECT * FROM " . $db->prefix("mod_bxpress_categories") . " ORDER BY `order`, title"); $categos = array(); while ($row = $db->fetchArray($result)) { $catego = new bXCategory(); $catego->assignVars($row); $categos[] = array('id' => $catego->id(), 'title' => $catego->title(), 'desc' => $catego->description(), 'status' => $catego->status()); } $form = new RMForm('', '', ''); $groups = new RMFormGroups('', 'groups', 1, 1, 2, array(0)); $bc = RMBreadCrumb::get(); $bc->add_crumb(__('Categories', 'bxpress')); xoops_cp_header(); RMTemplate::get()->add_script('admin.js', 'bxpress'); RMTemplate::get()->add_help(__('Categories', 'bxpress'), 'http://www.redmexico.com.mx/docs/bxpress-forums/categorias/standalone/1/'); RMTemplate::get()->add_head_script('var bx_select_message = "' . __('You must select a category at least in order to run this action!', 'bxpress') . '"; var bx_message = "' . __('Do you really want to delete selected categories?\\n\\nAll forums under this category will be deleted also!', 'bxpress') . '";'); include RMTemplate::get()->get_template('admin/forums-categories.php', 'module', 'bxpress'); xoops_cp_footer(); }
/** * @desc Obtiene las categorías especificadas * @param int $active Categorías activas o inactivas (1 o 0, 2 Todas); */ public function getObjects($active = 1) { $db = XoopsDatabaseFactory::getDatabaseConnection(); $sql = "SELECT * FROM " . $db->prefix("bxpress_categories"); if ($active == 1 || $active == 0) { $sql .= " WHERE status='{$active}'"; } $sql .= " ORDER BY `order`"; $result = $db->query($sql); $categos = array(); while ($row = $db->fetchArray($result)) { $catego = new bXCategory(); $catego->assignVars($row); $categos[] = $catego; } return $categos; }