$tbl->Width = "100%";
$tbl->DataMYSQL("messages");
$tbl->FilterMYSQL("creator_id='u" . $_SESSION["user"]["data"]["id"] . "'");
$tbl->Pager(CGUI_PAGER_FLAG_SEL | CGUI_PAGER_FLAG_RR | CGUI_PAGER_FLAG_R | CGUI_PAGER_FLAG_FF | CGUI_PAGER_FLAG_F, 10, array(10, 20, 50, 100, 0));
global $n;
if (Roles::isActionAllowed($GUI->mmenu->selected->id, $GUI->mmenu->selected->selected->id, $_SESSION["user"]["data"]["group_id"], "Просмотр сообщения")) {
$tbl->RowEvent2 = "document.location.href=\"?section=mls&subsection=2&type=o&read=%var%\"";
}
$columns_resource = Roles::getColumns($GUI->mmenu->selected->id, $GUI->mmenu->selected->selected->id, $_SESSION["user"]["data"]["group_id"]);
if (!is_resource($columns_resource)) {
$GUI->ERR($columns_resource);
page_reload();
}
$new_columns = array();
$column_group_name = array();
while ($row = db::fetch_array($columns_resource)) {
if ($row['group_internal_name'] != "") {
$column_group_name[] = $row['group_internal_name'];
$new_columns[$row['group_internal_name']]['custom'][] = $row;
} else {
$new_columns[] = $row;
}
}
foreach ($new_columns as $column) {
if (isset($column['internal_name']) && in_array($column['internal_name'], $column_group_name)) {
continue;
}
if (isset($column['custom']) && count($column['custom'])) {
$r = $tbl->NewColumn();
foreach ($column['custom'] as $custom_column) {
$r1 = new CGUI_TableColumn();
function get_role_subsections($role_id, $parent_module_name)
{
global $db;
$modules = array();
if ($role_id == 0 || $role_id == 1) {
$db->query("\n SELECT s.name, s.order, s.default\n FROM " . TBL_PREF . "submodules s\n JOIN " . TBL_PREF . "modules m ON m.id = s.module_id\n WHERE m.internal_name = '" . $parent_module_name . "'\n ORDER BY s.order ASC\n ");
} else {
$db->query("\n SELECT s.name, s.order, s.default\n FROM " . TBL_PREF . "submodules s\n JOIN " . TBL_PREF . "modules m ON m.id = s.module_id\n JOIN " . TBL_PREF . "roles_to_submodules rts ON s.id = rts.submodule_id\n WHERE rts.role_id = " . $role_id . "\n AND m.internal_name = '" . $parent_module_name . "'\n ORDER BY s.order ASC\n ");
}
if ($db->Error) {
return $db->Error;
}
while ($row = db::fetch_array($db->_res)) {
$modules[] = $row;
}
return $modules;
}
