function _retrieveAll($orderSQL, $direction = true, $full = false)
{
$direction = $direction ? ' ASC' : ' DESC';
$sql = 'SELECT ' . DB_PREXIX . 'forums.idforum, ' . DB_PREXIX . 'forums.nameforum, ' . DB_PREXIX . 'forums.order' . ' FROM ' . DB_PREXIX . 'forums ' . $orderSQL . $direction;
$dbForums = $this->db->getRecords($sql);
$forums = array();
foreach ($dbForums as $i => $item) {
$forum = new ForumObject($item['nameforum'], $item['order'], $item['idforum']);
if ($full) {
$forum->loadSubjects();
} else {
$forum->loadNumbers();
}
$forum->parity = $i % 2 ? 'odd' : 'even';
$forums["" . $forum->id] = $forum;
}
return $forums;
}
function actionManageForums()
{
// Create the addForum form
$form = new YDForm('forumForm');
$form->addElement('text', 'forumTitle', t('admin.newforumtitle'), array("size" => 40));
$form->addElement('text', 'forumPoids', t('admin.forumweightorder'), array());
$form->addElement('submit', 'cmdSubmit', t('admin.forumcreate'));
// Add rules
$form->addFormRule(array(&$this, 'checkNewForum'));
$form->addRule('forumPoids', 'numeric', t('admin.forumweightinteger'));
// Process the form
if ($form->validate()) {
// get and show results
$forum = new ForumObject($form->getValue('forumTitle'), $form->getValue('forumPoids'));
$forum->insert();
}
// Future defaults values
$form->setDefaults(array('forumTitle' => ''));
$form->setDefaults(array('forumPoids' => ''));
// retrieve existing forums
$forumLogic = new ForumsLogic();
$forums = $forumLogic->retrieveAllByOrderSimple();
// Assign variables to the template
$this->actionTpl->assign('form', $form->toArray());
$this->actionTpl->assign('forums', $forums);
$content = new Page($this->actionTpl->fetch('templates/admin.forums.list.tpl'), t('admin.manageforums'), $this->menusAdmin);
// Display the action template into the master template
$this->display($content);
}
