function Build()
{
if ($this->name != "") {
$menu = new Menu();
$menu->SetDatabase($this->database);
$menu->SetName($this->name);
$order = "c.modu_name";
if ($this->order == ORDER_BY_ORDER) {
$order = "a.mnit_order";
} else {
$order = "c.modu_name";
}
if ($menu->SelectByName()) {
$select = "select c.modu_name, c.modu_url " . "from menu_itens a, menus b , modules c " . "where a.mnit_menu_id = b.menu_id " . "and b.menu_name = \"" . $this->name . "\" " . "and c.modu_id = a.mnit_modu_id " . "order by " . $order;
$result = $this->database->Execute($select);
return $result;
}
}
return false;
}
<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>";
}
?>
</select>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="100%" valign="center" align="center" colspan="2">
<a href="javascript:Select();">Selecionar</a>
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();
}