function selectInput($var, $tablItem, $current) { $tabl = $tablItem->getOpts('table'); $colname = $tablItem->getOpts('name'); if (!$colname) { $colname = $var; } $txtname = $tablItem->getOpts('txt'); if ($txtname) { $vList = $txtname . ',' . $colname; } else { $vList = $colname; } $SQLstmt = "SELECT DISTINCT {$vList} FROM {$tabl} ORDER BY {$vList} ;"; $r = newQuery($SQLstmt, 0); selectFromQuery($r, $var, $colname, $current, $txtname, ''); pg_free_result($r); return 1; }
function qList($var, $dyn) { //echo "<p>SQL:\n"; $sql = $this->fetchQuery($var); //echo "$sql</p>\n"; $xSet = 'XSet' . $dyn; echo "<p id=\"{$xSet}\"><strong>", $this->getVarTitle($var), "</strong>\n"; hiddenInput('VarX' . $dyn, $var); if ($dyn > 1) { radioInput('BoolX' . $dyn, 'AND'); echo "AND\n"; radioInput('BoolX' . $dyn, 'OR'); echo "OR\n"; } if ($sql) { $rX = $this->xQuery($sql, 1); selectFromQuery($rX, 'SelX' . $dyn, $this->getQParmName($var, 'key'), '', $this->getQParmName($var, 'var'), '', '', ''); killResult($rX); } else { $arOpts = $this->getItemOpts($var); if ($arOpts['dated']) { $currTime = time(); $dayOfWeek = date('N', $t); if ($dayOfWeek > 6) { $dayOfWeek = 0; } $Sunday = $currTime - 24 * 3600 * $dayOfWeek; $nextSunday = $currTime + (7 - $dayOfWeek) * 24 * 3600; $Saturday = 6 * 24 * 3600 + $Sunday; $nextSaturday = 6 * 24 * 3600 + $nextSunday; $thisMonth = date('Y-m-01', $currTime) . '_' . date('Y-m-t', $currTime); $thisWeek = date('Y-m-d', $Sunday) . '_' . date('Y-m-d', $Saturday); $nextWeek = date('Y-m-d', $nextSunday) . '_' . date('Y-m-d', $nextSaturday); $today = date('Y-m-d'); selectFromArray('SelX' . $dyn, array("__lt{$today}", "__eq{$today}", "__rg{$thisWeek}", "__rg{$nextWeek}", "__rg{$thisMonth}", "__gt{$today}"), '', array('Before today', 'Today', 'This week', 'Next week', 'This month', 'After today'), '', '', ''); } elseif ($arOpts['specify']) { echo " like <input type=\"text\" id=\"SelX{$dyn}\" name =\"SelX{$dyn}\" size=\"16\" />\n"; } else { selectFromArray('SelX' . $dyn, '', '', explode('\\t', $arOpts['values']), '', '', ''); } } echo "<span style=\"color: #600;\" onClick=\"removeOpt('{$dyn}');\" >Scratch</span>\n"; echo "</p>\n"; }
foreach ($g as $grp) { $groups[$grp["groupid"]] = $grp; } $vsid = -1; if (isset($_GET["vsid"])) { $vsid = $_GET["vsid"]; } if (isset($_GET["osid"]) && $sid != $_GET["osid"] || $vsid == -1) { $vsid = -1; $fields = "`serverid`, `type`, `uid`, `r_view_server`, `r_edit_server`, `r_add_vservers`, `r_remove_vservers`"; $userright = selectFromQuery("select " . $fields . ", `nickname` from `" . $tbl . "_server_rights` join `" . MYSQL_TABLE_PREFIX . "users` on `" . $tbl . "_server_rights`.`uid`=`" . MYSQL_TABLE_PREFIX . "users`.`userid` where `serverid`=" . $sid . " and `type`=1"); $groupright = selectFromQuery("select " . $fields . ", `name` from `" . $tbl . "_server_rights` join `" . MYSQL_TABLE_PREFIX . "groups` on `" . $tbl . "_server_rights`.`uid`=`" . MYSQL_TABLE_PREFIX . "groups`.`groupid` where `serverid`=" . $sid . " and `type`=0"); } else { $fields = "`serverid`, `type`, `uid`, `r_view_vserver`, `r_control_vserver`, `r_edit_vserver`, `r_view_grouprights`, `r_edit_grouprights`, `r_rename_group`, `r_add_group`, `r_remove_group`, " . "`r_view_clients`, `r_msg_client`, `r_kick_client`, `r_ban_client`, `r_change_servergroup`, `r_view_clientdetails`, `r_edit_clientdetails`, `r_view_bans`, " . "`r_remove_bans`, `r_view_complaints`, `r_remove_complaints`, `r_view_log`, `r_view`, `r_edit_channel`, `r_remove_channel`, `r_add_channel`, `r_move_client`, `r_change_channelgroup`"; $userright = selectFromQuery("select " . $fields . ", `nickname` from `" . $tbl . "_vserver_rights` join `" . MYSQL_TABLE_PREFIX . "users` on `" . $tbl . "_vserver_rights`.`uid`=`" . MYSQL_TABLE_PREFIX . "users`.`userid` and `vserverid`=" . $vsid . " where `serverid`=" . $sid . " and `type`=1"); $groupright = selectFromQuery("select " . $fields . ", `name` from `" . $tbl . "_vserver_rights` join `" . MYSQL_TABLE_PREFIX . "groups` on `" . $tbl . "_vserver_rights`.`uid`=`" . MYSQL_TABLE_PREFIX . "groups`.`groupid` and `vserverid`=" . $vsid . " where `serverid`=" . $sid . " and `type`=0"); } foreach ($userright as $ri) { $userrightlist[$ri["uid"]] = $ri; $users[$ri["uid"]]["set"] = 1; $userrightlist[$ri["uid"]]["editurl"] = "ajax_request.php?mod=ts3admin&file=RightOption.ajax&vsid=" . $vsid . "&sid=" . $sid . "&uid=" . $ri["uid"] . "&action=askedit&type=user"; $userrightlist[$ri["uid"]]["removeurl"] = "ajax_request.php?mod=ts3admin&file=RightOption.ajax&vsid=" . $vsid . "&sid=" . $sid . "&uid=" . $ri["uid"] . "&action=askremove&type=user"; } foreach ($groupright as $ri) { $grouprightlist[$ri["uid"]] = $ri; $groups[$ri["uid"]]["set"] = 1; $grouprightlist[$ri["uid"]]["editurl"] = "ajax_request.php?mod=ts3admin&file=RightOption.ajax&vsid=" . $vsid . "&sid=" . $sid . "&uid=" . $ri["uid"] . "&action=askedit&type=group"; $grouprightlist[$ri["uid"]]["removeurl"] = "ajax_request.php?mod=ts3admin&file=RightOption.ajax&vsid=" . $vsid . "&sid=" . $sid . "&uid=" . $ri["uid"] . "&action=askremove&type=group"; } $smarty->assign('userrightlist', $userrightlist); $smarty->assign('grouprightlist', $grouprightlist);