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);
