$qs = "SELECT category_id, category_name FROM phph_categories "; if (!empty($ccid)) { $qs .= "WHERE category_parent = {$ccid} "; } else { $qs .= "WHERE category_parent IS NULL "; } $qs .= "ORDER BY category_order"; $q = $db->prepare($qs); $res = $db->execute($q); if (PEAR::isError($res)) { die($res->getMessage()); } while ($res->fetchInto($row)) { $name = ""; if ($level > 0) { for ($i = 0; $i < $level; $i++) { $name .= "---"; } $name .= " "; } $name .= $row['category_name']; $categories[$row['category_id']] = $name; fill_category_tree(&$categories, $row['category_id'], $level + 1); } } $categories = array(); fill_category_tree(&$categories, "", 0); $smarty->assign('categories', $categories); $smarty->display('upload-form.tpl'); HTML::endBODY(); HTML::endHTML();
if ($action == 'view') { action_view(); } elseif ($action == "categories") { action_categories(); } elseif ($action == "category") { action_category(); } elseif ($action == "user") { action_user(); } elseif ($action == "register") { action_register(); } elseif ($action == "activate") { action_activate(); } elseif ($action == "login") { action_login(); } elseif ($action == "postcomment") { action_postcomment(); } elseif ($action == "subscribe") { action_subscribe(); } elseif ($action == "unsubscribe") { action_unsubscribe(); } else { $action = "index"; $template = $action; action_index(); } HTML::startHTML(); HTML::head($smarty->get_template_vars('page_title')); HTML::startBODY(); $smarty->display($templates[$template]); HTML::endBODY(); HTML::endHTML();