<tr>
<td bgcolor="#EEEEEE" width="100%" valign="top" class="form_title" colspan="2">
Itens de Menu
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="30%" valign="center" align="right">
Id:
</td>
<td bgcolor="#FFFFFF" width="70%" valign="center" align="left">
<select name="p_mnit_id">
<option value="">Selecione</option>
<?php
$menu_items = new MenuItem();
$menu_items->SetDatabase($database);
$result = $menu_items->SelectOrderBy();
while ($data = $database->FetchArray($result)) {
$mnit_id = $data["mnit_id"];
$menu = new Menu();
$menu->SetId($data["mnit_menu_id"]);
$menu->SetDatabase($database);
$menu->SelectById();
$module = new Module();
$module->SetId($data["mnit_modu_id"]);
$module->SetDatabase($database);
$module->SelectById();
echo "<option value=\"" . $mnit_id . "\">" . $menu->GetName() . " - " . $module->GetName() . "</option>";
}
?>
function DropTables()
{
$moderator = new Moderator();
$moderator->SetDatabase($this);
$moderator->Drop();
$message = new Message();
$message->SetDatabase($this);
$message->Drop();
$topic = new Topic();
$topic->SetDatabase($this);
$topic->Drop();
$user_info = new UserInfo();
$user_info->SetDatabase($this);
$user_info->Drop();
$session = new Session();
$session->SetDatabase($this);
$session->Drop();
$new = new News();
$new->SetDatabase($this);
$new->Drop();
$shout = new Shout();
$shout->SetDatabase($this);
$shout->Drop();
$paragraph = new Paragraph();
$paragraph->SetDatabase($this);
$paragraph->Drop();
$privilege = new Privilege();
$privilege->SetDatabase($this);
$privilege->Drop();
$role = new Role();
$role->SetDatabase($this);
$role->Drop();
$menu_item = new MenuItem();
$menu_item->SetDatabase($this);
$menu_item->Drop();
$module = new Module();
$module->SetDatabase($this);
$module->Drop();
$page = new Page();
$page->SetDatabase($this);
$page->Drop();
$article = new Article();
$article->SetDatabase($this);
$article->Drop();
$subject = new Subject();
$subject->SetDatabase($this);
$subject->Drop();
$menu = new Menu();
$menu->SetDatabase($this);
$menu->Drop();
$profile = new Profile();
$profile->SetDatabase($this);
$profile->Drop();
$user = new User();
$user->SetDatabase($this);
$user->Drop();
}
