function loadMenu($xmen, $issub = "")
{
global $data;
$data .= '<ul ' . (!$issub ? 'id="menu_principal"' : '') . '>';
$dt = 0;
foreach ($xmen as $key => $val) {
$opt = $val->ventana ? ' server-frm="' . $val->ventana . '"' : '';
$opt .= $val->icono ? ' server-icon="' . $val->icono . '"' : '';
$opt .= $val->ventana_datos ? ' server-data="' . $val->ventana_datos . '"' : '';
$opt .= $val->ventana_titulo ? ' server-titulo="' . $val->ventana_titulo . '"' : '';
$opt .= $val->ventana_alto ? ' server-alto="' . $val->ventana_alto . '"' : '';
$opt .= $val->ventana_ancho ? ' server-ancho="' . $val->ventana_ancho . '"' : '';
/*
if($val->server_modulo){
$opt.=' server-modulo="'.$val->server_modulo.'"';
if($_SESSION['server-lite-user']['SUPERVISOR']!="1"){
$sqlgru=mssql_query("SELECT GRUPO_UGR FROM TBUSUARIOSGRU WHERE USUARIO_UGR='".$_SESSION['server-lite-user']['Codigo_Usuarios']."'");
if(mssql_num_rows($sqlgru)>0){
$sqlp=mssql_query("select top(1) CHK1,CHK2,CHK3,CHK4,CHK5,CHK6,CHK7,CHK8,CHK9,CHK10,CHK11,CHK12,CHK13 from tbusuarios1 WHERE LOGIN IN (SELECT GRUPO_UGR FROM TBUSUARIOSGRU WHERE USUARIO_UGR='".$_SESSION['server-lite-user']['LOGIN']."') and modulo='".$val->server_modulo."'");
} else {
$sqlp=mssql_query("select top(1) CHK1,CHK2,CHK3,CHK4,CHK5,CHK6,CHK7,CHK8,CHK9,CHK10,CHK11,CHK12,CHK13 from tbusuarios1 WHERE LOGIN='******'server-lite-user']['Codigo_Usuarios']."' and modulo='".$val->server_modulo."'");
}
if(mssql_num_rows($sqlp)>0){
$permiso=implode(mssql_fetch_array($sqlp,MSSQL_ASSOC));
$opt.=' server-inmate="'.dechex(substr($permiso,0,6))."_".dechex(substr($permiso,6)).'"';
if(substr($permiso,0,1)=="0"){ $opt.=' style="color:#999"'; }
} else {
$opt.=' server-inmate="0_0" style="color:#999"';
}
} else {*/
$permiso = "1111111111111";
$opt .= ' server-inmate="' . dechex(substr($permiso, 0, 6)) . "_" . dechex(substr($permiso, 6)) . '"';
/*
}
}*/
//aqui se establecen los permisos con la tabla tbusuarios2
$data .= '<li class="' . ($issub ? 'sub' : 'top') . (!$dt ? 'first' : ($dt == count($xmen) ? 'last' : 'item')) . '">' . ($val->icono ? '<img src="../img/icon/16/' . $val->icono . '.png" class="ui-icon-menu">' : '') . '<a class="prewidget" href="' . ($val->link ? $val->link : '#') . '" ' . $opt . '>' . ($val->submenu ? '<span>' : '') . $val->nombre . ($val->submenu ? '</span>' : '') . '</a>';
if ($val->submenu) {
loadMenu($val->submenu, "true");
}
$data .= '</li>';
$dt++;
}
$data .= '</ul>';
}
<a href="" class="dropdown-toggle" data-toggle="dropdown">
Logged in as <?php
echo SessionGet('UID');
?>
<b class="caret"></b>
</a>
<ul class="dropdown-menu">
<li><a href="?st2logout=1">Logout</a></li>
</ul>
</li>
</ul>
<?php
}
?>
<?php
echo loadMenu();
?>
</div>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row-fluid">
<?php
if (mosCountModules('left')) {
$left = mosLoadModules('left', -2);
if (is_null($left)) {
$left = false;
}
if ($left) {
echo '<div class="span3" style="clear:both;">';
if (!(empty($newOpt) || empty($newCont))) {
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
if ($stmt = $conn->prepare("UPDATE pw_users.menulist SET opt = ?, content = ? WHERE opt = ?;")) {
$stmt->bind_param("sss", $newOpt, $newCont, $oldOpt);
$stmt->execute();
$stmt->close();
$conn->close();
} else {
echo "err prepare";
$conn->close();
}
}
loadMenu();
}
function loadMenu()
{
global $servername, $password, $dbname, $username;
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "<table ><tr><th>Option</th><th>Content</th></tr>";
$sql = "SELECT * FROM pw_users.menulist";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$op = $row["opt"];
$cont = $row["content"];
require_once _base_ . '/lib/lib.form.php';
$user_manager = new UserManager();
$user_manager->setRegisterTo('link', 'index.php?modname=login&op=register');
$user_manager->setLostPwdTo('link', 'index.php?modname=login&op=lostpwd');
$extra = false;
if (isset($GLOBALS['logout'])) {
$extra = array('style' => 'logout_action', 'content' => Lang::t('_UNLOGGED', 'login'));
}
if (isset($GLOBALS['access_fail'])) {
$extra = array('style' => 'noaccess', 'content' => Lang::t('_NOACCESS', 'login'));
}
return Form::openForm('login_confirm', 'index.php?modname=login&op=confirm') . $user_manager->getLoginMask('index.php?modname=login&op=login', $extra) . Form::closeForm();
}
function loadNewsBlock()
{
$lang = DoceboLanguage::createInstance('login');
$textQuery = "\r\n\tSELECT idNews, publish_date, title, short_desc \r\n\tFROM " . $GLOBALS['prefix_lms'] . "_news \r\n\tWHERE language = '" . getLanguage() . "'\r\n\tORDER BY important DESC, publish_date DESC";
$result = sql_query($textQuery);
$html = '<div class="home_news_block">' . '<h1>' . $lang->def('_NEWS') . '</h1>';
while (list($idNews, $publish_date, $title, $short_desc) = sql_fetch_row($result)) {
$html .= '<h2>' . '<a href="index.php?modname=login&op=readnews&idNews=' . $idNews . '">' . $title . '</a></h2>' . '<p><span class="news_data">' . $lang->def('_DATE') . ' ' . Format::date($publish_date, 'date') . ': </span>' . $short_desc . '</p>';
}
if (mysql_num_rows($result) == 0) {
$html .= $lang->def('_NO_CONTENT');
}
$html .= '</div>';
return $html;
}
// XXX: compose menu
$GLOBALS['page']->add(loadMenu() . loadLogin() . (Get::sett('activeNews') == 'block' ? loadNewsBlock() : ''), 'menu');
function loadMenu($xmen, $issub = "")
{
global $data, $imenu;
$data .= '<ul ' . (!$issub ? 'class="treeview"' : '') . '>';
$dt = 0;
foreach ($xmen as $key => $val) {
$imenu++;
if ($val->nombre != "Salir") {
$data .= '<li><a id="treeview_usuarios_' . $imenu . '" tvu-modulo="' . $val->octa_modulo . '" href="javascript:select_treeview(\'treeview_usuarios_' . $imenu . '\');">' . $val->nombre . '</a>';
if ($val->submenu) {
loadMenu($val->submenu, "true");
}
$data .= '</li>';
$dt++;
}
}
$data .= '</ul>';
}
