/** * * Get transaction id by its hash * * @param $tablename name of the table to extract last id * @return string * */ function osmp_getIdByHash($hash) { $hash = mysql_real_escape_string($hash); $query = "SELECT `id` from `op_transactions` WHERE `hash`='" . $hash . "'"; $result = simple_query($query); return $result['id']; }
private function sendRequest($var = null) { if (!is_object($this->_sendRequest)) { $query = "\r\n SELECT\r\n `rbs_requests`.`id`,\r\n `rbs_requests`.`code`,\r\n `rbs_requests`.`requestStatus`,\r\n `rbs_requests`.`requestComment`\r\n FROM `rbs_requests` \r\n JOIN `rbs_results` ON `rbs_results`.`requestID` = `rbs_requests`.`id`\r\n WHERE `rbs_results`.`resultStatusCode` = '0'\r\n "; $result = simple_query($query); if (!empty($result)) { // Если в БД есть запрос со статусом ответа = '0' вносим в // переменную запроса `code`, `result` и `resultComment` этого запроса $this->_sendRequest = (object) array('code' => $result['code'], 'result' => $result['requestStatus'], 'resultComment' => $result['requestComment']); // Запоминаем индекс для дальнейшей связи с результатом $this->_requestPK = $result['id']; } else { // Иначе, генерируем новый xml-файл запроса, подписываем его и делаем // запрос в Роскомнадзор на получение новой выгрузки $request = $this->generateRequestXml(); $this->_sendRequest = $this->_soap->sendRequest(array('requestFile' => new SoapVar($request['xml'], XSD_BASE64BINARY, 'xsd:base64Binary'), 'signatureFile' => new SoapVar($request['sig'], XSD_BASE64BINARY, 'xsd:base64Binary'), 'dumpFormatVersion' => '2.0')); // Пишем результат в лог и запоминаем индекс для дальнейшей связи с // результатом $this->_requestPK = $this->logRequest(); } } // Если не запрошена конкретная переменная результата запроса - возвращаем // все, иначе возвращаем конкретную переменную. return is_null($var) ? $this->_sendRequest : @$this->_sendRequest->{$var}; }
/** * * Get transaction datetime by its hash * * @param $tablename name of the table to extract last id * @return string * */ function ibox_getDateByHash($hash) { $hash = mysql_real_escape_string($hash); $query = "SELECT `date` from `op_transactions` WHERE `hash`='" . $hash . "'"; $result = simple_query($query); return $result['date']; }
/** * Returns tickets data by its ID * * @param int $ticketid * @return array */ function zb_TicketGetData($ticketid) { $ticketid = vf($ticketid, 3); $query = "SELECT * from `ticketing` WHERE `id`='" . $ticketid . "'"; $result = simple_query($query); return $result; }
function zbs_ContrAhentGetData($id) { $id = vf($id); $query = "SELECT * from `contrahens` WHERE `id`='" . $id . "'"; $result = simple_query($query); return $result; }
function web_TstatsShow() { $allclasses = zb_DirectionsGetAll(); $classtraff = array(); $traffCells = wf_TableCell(__('Traffic classes'), '20%'); $traffCells .= wf_TableCell(__('Traffic'), '20%'); $traffCells .= wf_TableCell(__('Traffic classes')); $traffRows = wf_TableRow($traffCells, 'row1'); if (!empty($allclasses)) { foreach ($allclasses as $eachclass) { $d_name = 'D' . $eachclass['rulenumber']; $u_name = 'U' . $eachclass['rulenumber']; $query_d = "SELECT SUM(`" . $d_name . "`) FROM `users`"; $query_u = "SELECT SUM(`" . $u_name . "`) FROM `users`"; $classdown = simple_query($query_d); $classdown = $classdown['SUM(`' . $d_name . '`)']; $classup = simple_query($query_u); $classup = $classup['SUM(`' . $u_name . '`)']; $classtraff[$eachclass['rulename']] = $classdown + $classup; } if (!empty($classtraff)) { $total = max($classtraff); foreach ($classtraff as $name => $count) { $traffCells = wf_TableCell($name); $traffCells .= wf_TableCell(stg_convert_size($count), '', '', 'sorttable_customkey="' . $count . '"'); $traffCells .= wf_TableCell(web_bar($count, $total), '', '', 'sorttable_customkey="' . $count . '"'); $traffRows .= wf_TableRow($traffCells, 'row3'); } } } $result = wf_TableBody($traffRows, '100%', 0, 'sortable'); show_window(__('Traffic report'), $result); }
function show_wahlen($row) { extract($row); $listen_gueltig = $stimmen_gesamt - $stimmzettel_ungueltig - $listen_ungueltig; $listen_summe = $listen_gueltig - $listen_enthaltungen; $kandidaten_gueltig = $stimmen_gesamt - $stimmzettel_ungueltig - $kandidaten_ungueltig; $kandidaten_summe = $kandidaten_gueltig - $kandidaten_enthaltungen; print "\\section{Wahl zum {$wahl_name}}\n"; if (simple_query("SELECT count(*) FROM liste " . "WHERE wahl = {$wahl_id}") > 1) { print "\\subsection*{Listenstimmen}\n"; // Gesamt-Informationen print "Wahlberechtigte: {$wahlberechtigt}, " . "abgegebene Stimmzettel: {$stimmen_gesamt}, " . "Wahlbeteiligung: " . percent($stimmen_gesamt, $wahlberechtigt) . "\\%" . "\n\n" . "ungültige Stimmzettel: {$stimmzettel_ungueltig}, " . "ungültige Stimmen: {$listen_ungueltig} " . "gültige Stimmen: {$listen_gueltig}, " . "\n\n" . "Enthaltungen: {$listen_enthaltungen} " . "\n\n"; print "\\begin{tabular}{lrrrrl}\n" . "Liste & Stimmen & Anteil & Quote & Sitze & \\\\\\hline\n"; // Listen-Tabelle do_query("SELECT liste.name_kurz, liste.name_lang, " . "anzeige_red as r, anzeige_green as g, " . "anzeige_blue as b, " . "hoechstzahl, sitze, los, " . "sum(liste_urne.stimmen) AS stimmen, " . "{$listen_summe} AS summe " . "FROM liste, urne, liste_urne " . "WHERE liste.id = liste_urne.liste " . "AND urne.id = liste_urne.urne " . "AND urne.status = " . $GLOBALS["ok_status"] . " " . "AND wahl = {$wahl_id} " . "GROUP BY liste.id " . "ORDER by liste.nummer", show_listen); print "\\hline\\end{tabular}\n\n"; $num_los = simple_query("SELECT los FROM liste " . "WHERE wahl = {$wahl_id} " . "AND los > 0"); if ($num_los > 0) { print "(+1): ggf. +1 von {$num_los} Restsitzen " . "per Los\n\n"; } } // Kandidaten print "\\subsection*{Kandidierendenstimmen}\n"; // Gesamt-Daten print "Wahlberechtigte: {$wahlberechtigt}, " . "abgegebene Stimmzettel: {$stimmen_gesamt}, " . "Wahlbeteiligung: " . percent($stimmen_gesamt, $wahlberechtigt) . "\\%" . "\n\n" . "ungültige Stimmzettel: {$stimmzettel_ungueltig}, " . "ungültige Stimmen: {$kandidaten_ungueltig}, " . "gültig: {$kandidaten_gueltig} " . "\n\n"; if ($max_stimmen_wert == 1) { print "Enthaltungen: {$kandidaten_enthaltungen} " . "\n\n"; } // Kandidaten do_query("SELECT liste.id AS liste_id, " . "liste.name_kurz AS liste_name_kurz, " . "liste.name_lang AS liste_name_lang, " . "anzeige_red AS r, " . "anzeige_green AS g, " . "anzeige_blue AS b, " . "kandidat.typ AS kandidat_typ, " . "kandidat.status AS status, " . "kandidat.vorname AS kandidat_vorname, " . "kandidat.nachname AS kandidat_nachname, " . "sum(kandidat_urne.stimmen) AS stimmen " . "FROM liste, kandidat, urne, kandidat_urne " . "WHERE kandidat.id = kandidat_urne.kandidat " . "AND urne.id = kandidat_urne.urne " . "AND liste.id = kandidat.liste " . "AND urne.status = " . $GLOBALS["ok_status"] . " " . "AND liste.wahl = {$wahl_id} " . "GROUP BY kandidat.id " . "ORDER BY liste.nummer, liste.id, status, stimmen DESC, " . "kandidat.listenplatz", show_kandidaten); if ($num_los != 0) { print "\\footnotemark{(*)} {$num_los} Restsitze werden per " . "Los auf die gekennzeichneten Listen verteilt.\n\n"; } }
function ds_GetCashSumm($login, $day) { global $tablename; $login = vf($login); $day = vf($day); $query = "SELECT SUM(`cash`) from `" . $tablename . "` WHERE `login`='" . $login . "' AND `day`='" . $day . "'"; $summ = simple_query($query); return $summ['SUM(`cash`)']; }
function sber_getTransactionDate($hash) { $hash = mysql_real_escape_string($hash); $query = "SELECT `date` from `op_transactions` WHERE `hash`='" . $hash . "'"; $data = simple_query($query); $rawDate = $data['date']; $timestamp = strtotime($rawDate); $result = date("Y-m-d\\TH:i:s", $timestamp); return $result; }
function zbs_CatvGetAssociatedUser($login) { $query = "SELECT * from `catv_users` WHERE `inetlink`='" . $login . "'"; $userdata = simple_query($query); if (!empty($userdata)) { return $userdata; } else { return false; } }
/** * Returns next free transaction ID * * @return int */ function pltz_GetFreeId() { $query = "SELECT `id` from `op_transactions` ORDER BY `id` DESC LIMIT 1"; $result = simple_query($query); if (!empty($result)) { $result = $result['id'] + 1; } else { $result = 1; } return $result; }
function nvp_CheckTransaction($hash) { $hash = mysql_real_escape_string($hash); $query = "SELECT `id` from `op_transactions` WHERE `hash`='" . $hash . "'"; $data = simple_query($query); if (!empty($data)) { return $data['id']; } else { return false; } }
function ep_GetTransactionTime($id) { $id = vf($id, 3); $query = "SELECT `date` from `op_transactions` WHERE `id`='" . $id . "'"; $data = simple_query($query); if (!empty($data)) { return $data['date']; } else { return false; } }
function ra_NasGetTemplate($nasid) { $nasid = vf($nasid, 3); $query = "SELECT `template` from `nastemplates` WHERE `nasid`='" . $nasid . "'"; $result = simple_query($query); if (!empty($result)) { $result = $result['template']; } else { $result = ''; } return $result; }
/** * Returns value or empty data from ubstorage if key not exists * * @param string $key * @return string */ function zb_StorageGet($key) { $key = mysql_real_escape_string($key); $query = "SELECT `value` from `ubstorage` WHERE `key`='" . $key . "'"; $fetchdata = simple_query($query); if (!empty($fetchdata)) { $result = $fetchdata['value']; } else { $result = ''; } return $result; }
function get_user_count() { global $system; if (defined('USERS_MYSQL') && USERS_MYSQL) { $query = 'SELECT COUNT(`username`) from `users`'; $result = simple_query($query); return $result['COUNT(`username`)']; } else { $userlist = $system->getUserList('*', 'username'); } return count($userlist); }
/** * Checks is some ticket accessible by login * * @param int $ticketid * @param string $login * @return bool */ function zbs_TicketIsMy($ticketid, $login) { $ticketid = vf($ticketid, 3); $login = mysql_real_escape_string($login); $query = "SELECT `id` from `ticketing` WHERE `id`='" . $ticketid . "' AND `from`='" . $login . "'"; $result = simple_query($query); if (!empty($result)) { return true; } else { return false; } }
/** * checks is user current month use SC module and returns false if used or true if feature available * * @param string $login existing users login * * @return bool */ function zbs_CreditLogCheckMonth($login) { $login = mysql_real_escape_string($login); $pattern = date("Y-m"); $query = "SELECT `id` from `zbssclog` WHERE `login` LIKE '" . $login . "' AND `date` LIKE '" . $pattern . "%';"; $data = simple_query($query); if (empty($data)) { return true; } else { return false; } }
function head($title, $file = "") { if ($file != "") { print "\n<NEWFILE {$file} {$title}>\n"; } $urnen_total = simple_query("SELECT count(*) FROM urne"); $urnen_done = simple_query("SELECT count(*) FROM urne WHERE status=" . $GLOBALS["ok_status"]); $stimmen_total = simple_query("SELECT sum(stimmen) FROM urne"); $stimmen_done = simple_query("SELECT sum(stimmen) FROM urne WHERE status=" . $GLOBALS["ok_status"]); ?> <html> <head><title>Unabhängige Wahlen KIT - <?php echo $title; ?> </title> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15"> <link rel="stylesheet" href="style.css"> <link rel="stylesheet" href="http://www.usta.de/sites/www.usta.de/themes/usta/font.css"> </head> <body> <div id="content"> <div id="header"> <h2>Wahlen zum Unabhängigen Modell am Karlsruher Institut für Technologie (KIT)</h2> <h1><?php echo $title; ?> </h1> <div class="orange-border"> Zwischenstand <?php echo date("j.n.Y H:i"); ?> , <?php echo $urnen_done; ?> von <?php echo $urnen_total; ?> Urnen, ca. <?php echo percent($stimmen_done, $stimmen_total); ?> % der Stimmzettel, <a href="index.html?cache_dummy=<?php echo time(); ?> ">Übersicht</a> </div> </div> <?php }
function show_wahlen($row) { extract($row); $wahl_file = str_replace(" ", "_", $wahl_name_kurz); $listen_gueltig = $stimmen_gesamt - $stimmzettel_ungueltig - $listen_ungueltig; $listen_summe = $listen_gueltig - $listen_enthaltungen; $kandidaten_gueltig = $stimmen_gesamt - $stimmzettel_ungueltig - $kandidaten_ungueltig; $kandidaten_summe = $kandidaten_gueltig - $kandidaten_enthaltungen; if (simple_query("SELECT count(*) FROM liste " . "WHERE wahl = {$wahl_id}") > 1) { head($wahl_name_kurz . " (Listen)", "{$wahl_file}-listen.html"); // Gesamt-Informationen print "Wahlberechtigte: {$wahlberechtigt}, " . "abgegebene Stimmzettel: {$stimmen_gesamt}, " . "Wahlbeteiligung: " . percent($stimmen_gesamt, $wahlberechtigt) . "%" . "<BR>\n" . "ungültige Stimmzettel: {$stimmzettel_ungueltig}, " . "ungültige Stimmen: {$listen_ungueltig} " . "gültige Stimmen: {$listen_gueltig}, " . "<BR>\n" . "Enthaltungen: {$listen_enthaltungen} " . "<BR>\n"; // Listen-Tabelle print "<TABLE><TR valign=top>" . "<TD><TABLE cellpadding=2>" . "<TR>" . "<TD>Liste</TD>" . "<TD colspan=2>Stimmen</TD>" . "<TD>Sitze</TD>" . "</TR>\n"; do_query("SELECT liste.name_kurz, anzeige_red as r, " . "anzeige_green as g, anzeige_blue as b, " . "sitze, los, " . "sum(liste_urne.stimmen) AS stimmen, " . "{$listen_summe} AS summe " . "FROM liste, urne, liste_urne " . "WHERE liste.id = liste_urne.liste " . "AND urne.id = liste_urne.urne " . "AND urne.status = " . $GLOBALS["ok_status"] . " " . "AND wahl = {$wahl_id} " . "GROUP BY liste.id " . "ORDER by liste.nummer", show_listen); print "</TABLE>"; $num_los = simple_query("SELECT los FROM liste " . "WHERE wahl = {$wahl_id} " . "AND los > 0"); if ($num_los > 0) { print "(+1): ggf. +1 von {$num_los} Restsitzen " . "per Los\n"; } print "</TD>\n" . "<TD width=20></TD>\n"; // Listen-Graph $chart = array(); do_query_pass("SELECT sitze, " . "anzeige_red, anzeige_green, anzeige_blue " . "FROM liste " . "WHERE wahl = {$wahl_id} " . "ORDER by liste.anzeige_nummer", set_listen_chart, $chart); if ($num_los > 0) { array_push($chart, $num_los, 0.5, 0.5, 0.5); } print "<TD>"; piechart(400, 200, $chart, "{$wahl_file}-liste.png"); image("{$wahl_file}-liste.png"); print "</TD></TR>\n" . "</TABLE>\n" . "<BR>\n"; foot(); } // Kandidaten head($wahl_name_kurz, "{$wahl_file}-kandi.html"); // Gesamt-Daten print "Wahlberechtigte: {$wahlberechtigt}, " . "abgegebene Stimmzettel: {$stimmen_gesamt}, " . "Wahlbeteiligung: " . percent($stimmen_gesamt, $wahlberechtigt) . "%" . "<BR>\n" . "ungültige Stimmzettel: {$stimmzettel_ungueltig}, " . "ungültige Stimmen: {$kandidaten_ungueltig}, " . "gültig: {$kandidaten_gueltig} " . "<BR>\n"; if ($max_stimmen_wert == 1) { print "Enthaltungen: {$kandidaten_enthaltungen} " . "<BR>\n"; } // Kandidaten print "<p><div class=\"auswert_tab\"><TABLE><TR valign=top>\n"; do_query("SELECT liste.id AS liste_id, " . "liste.name_kurz AS liste_name_kurz, " . "anzeige_red AS r, " . "anzeige_green AS g, " . "anzeige_blue AS b, " . "kandidat.status AS status, " . "kandidat.vorname AS kandidat_vorname, " . "kandidat.nachname AS kandidat_nachname, " . "sum(kandidat_urne.stimmen) AS stimmen " . "FROM liste, kandidat, urne, kandidat_urne " . "WHERE kandidat.id = kandidat_urne.kandidat " . "AND urne.id = kandidat_urne.urne " . "AND liste.id = kandidat.liste " . "AND urne.status = " . $GLOBALS["ok_status"] . " " . "AND liste.wahl = {$wahl_id} " . "GROUP BY kandidat.id " . "ORDER BY liste.nummer, status, stimmen DESC, " . "kandidat.listenplatz", show_kandidaten); print "</TR></TABLE></div></p>\n"; if ($num_los != 0) { print "(*): {$num_los} Restsitze werden per Los auf " . "die gekennzeichneten Listen verteilt.<BR>"; } foot(); }
/** * Returns array of all parent users * * @return array */ function cu_GetAllParentUsers() { $alterconf = rcms_parse_ini_file(CONFIG_PATH . "alter.ini"); $linkfield = $alterconf['USER_LINKING_FIELD']; $linkcfid = $alterconf['USER_LINKING_CFID']; $result = array(); $query_cfs = "SELECT DISTINCT `content` FROM `cfitems` WHERE `typeid`='" . $linkcfid . "'"; $allcfs = simple_queryall($query_cfs); if (!empty($allcfs)) { foreach ($allcfs as $io => $eachcf) { $query_user = "******" . $linkfield . "`='" . $eachcf['content'] . "' "; $userlogin = simple_query($query_user); $result[$userlogin['login']] = $eachcf['content']; } } return $result; }
function checkTask($login, $action, $param) { $query = "SELECT `id` FROM `dealwithit` WHERE login='******' AND action='" . $action . "' AND param='" . $param . "'"; $check = simple_query($query); if (empty($check)) { return true; } else { return false; } }
/** * Deletes document from database and filesystem and redirects back to * documents list of the node * * @param type $document_id ID of the deleting document * @return type */ public function document_delete($id, $redirect = true) { // Get info about deleting file: $query = "SELECT * FROM `" . self::TABLE_DOCS . "` WHERE `id` = '" . $id . "'"; $result = simple_query($query); // Delete from database if deleted from filesystem: if (unlink($result['path'])) { $query = "DELETE FROM `" . self::TABLE_DOCS . "` WHERE `id` = '" . $id . "'"; nr_query($query); if ($redirect) { $item = empty($result['mark_id']) ? 'line' : 'mark'; $item_id = empty($result['mark_id']) ? $result['line_id'] : $result['mark_id']; rcms_redirect('?module=vols&item=' . $item . '&action=documents&id=' . $item_id); } } }
/** * Returns full data of tariff by its name * * @param string $tariff * @return array */ function zb_TariffGetData($tariff) { $tariff = mysql_real_escape_string($tariff); $query = "SELECT * from `tariffs` WHERE `name`='" . $tariff . "'"; $result = simple_query($query); return $result; }
function create_version() { simple_query("CREATE TABLE IF NOT EXISTS `version` (`id` INT AUTO_INCREMENT PRIMARY KEY, `applied_script` VARCHAR(127) UNIQUE)"); }
/** * returns last generated ID from documents registry * * @return int */ protected function getDocumentLastId() { $query = "SELECT `id` from `docxdocuments` ORDER BY `id` DESC LIMIT 1"; $data = simple_query($query); if (!empty($data)) { $result = $data['id']; } else { $result = 0; } return $result; }
/** * renders finance report * * @return void */ public function reportFinance() { $show_year = !wf_CheckPost(array('yearsel')) ? curyear() : $_POST['yearsel']; $dateSelectorPreset = wf_CheckPost(array('showdatepayments')) ? $_POST['showdatepayments'] : curdate(); $dateinputs = wf_DatePickerPreset('showdatepayments', $dateSelectorPreset); $dateinputs .= wf_Submit(__('Show')); $dateform = wf_Form(self::URL_REPORTS_MGMT . 'reportFinance', 'POST', $dateinputs, 'glamour'); $yearinputs = wf_YearSelector('yearsel'); $yearinputs .= wf_Submit(__('Show')); $yearform = wf_Form(self::URL_REPORTS_MGMT . 'reportFinance', 'POST', $yearinputs, 'glamour'); $controlcells = wf_TableCell(wf_tag('h3', false, 'title') . __('Year') . wf_tag('h3', true)); $controlcells .= wf_TableCell(wf_tag('h3', false, 'title') . __('Payments by date') . wf_tag('h3', true)); $controlcells .= wf_TableCell(wf_tag('h3', false, 'title') . __('Debt') . wf_tag('h3', true)); $controlrows = wf_TableRow($controlcells); $controlcells = wf_TableCell($yearform); $controlcells .= wf_TableCell($dateform); //extract total debt summ $debt_q = "SELECT SUM(`cash`) as `totaldebt`, COUNT(`id`) as `debtcount` from `ukv_users` WHERE `cash`<0"; $totalDebt = simple_query($debt_q); $debtData = __('Cash') . ': ' . wf_tag('b') . $totalDebt['totaldebt'] . wf_tag('b', true) . wf_tag('br'); $debtData .= __('Count') . ': ' . wf_tag('b') . $totalDebt['debtcount'] . wf_tag('b', true); $controlcells .= wf_TableCell($debtData); $controlrows .= wf_TableRow($controlcells); $controlgrid = wf_TableBody($controlrows, '100%', 0, ''); show_window('', $controlgrid); //show per month report $this->paymentsShowGraph($show_year); if (!isset($_GET['month'])) { // payments by somedate if (isset($_POST['showdatepayments'])) { $paydate = mysql_real_escape_string($_POST['showdatepayments']); $paydate = !empty($paydate) ? $paydate : curdate(); show_window(__('Payments by date') . ' ' . $paydate, $this->paymentsShow("SELECT * from `ukv_payments` WHERE `date` LIKE '" . $paydate . "%' AND `visible`='1' ORDER by `date` DESC;")); } else { // today payments $today = curdate(); show_window(__('Today payments'), $this->paymentsShow("SELECT * from `ukv_payments` WHERE `date` LIKE '" . $today . "%' AND `visible`='1' ORDER by `date` DESC;")); } } else { // show monthly payments $paymonth = mysql_real_escape_string($_GET['month']); show_window(__('Month payments'), $this->paymentsShow("SELECT * from `ukv_payments` WHERE `date` LIKE '" . $paymonth . "%' AND `visible`='1' ORDER by `date` DESC;")); } }
and username='******'username'])."' "; simple_query($sql); } else { //bad login or failure delay from bad login attempts. $sql=" update users set linedate_failed=NOW(), failed_logins=(failed_logins + 1) where username='******'username'])."' "; simple_query($sql); $error = $lang['login_error0']; $invalid_password = $_POST['pword']; $use_userid = 0; $use_location=0; unset($_COOKIE['uuid']); setcookie("uuid", 'novalue', $mrr_cookie_bake); //reset the cookie with 60 seconds unset($_COOKIE['user']); setcookie("user", '0', $mrr_cookie_bake); //reset the cookie with 60 seconds } mrr_add_login_attempt($use_userid,$_POST['username'],$invalid_password);
/** * Returns street creation form * * @return string */ function web_StreetCreateForm() { $cities = simple_query("SELECT `id` from `city`"); if (!empty($cities)) { $inputs = web_CitySelector() . ' ' . __('City') . wf_delimiter(); $inputs .= wf_TextInput('newstreetname', __('New Street name') . wf_tag('sup') . '*' . wf_tag('sup', true), '', true, '20'); $inputs .= wf_TextInput('newstreetalias', __('New Street alias'), '', true, '20'); $inputs .= wf_Submit(__('Create')); $form = wf_Form('', 'POST', $inputs, 'glamour'); } else { $form = __('No added cities - they will need to create a street'); } return $form; }
$content .= $form->checkbox('add[login]', '*', __('Foreach'), ''); $form->addrow(__('Service'), $content); // - Атрибут $content = $form->text_box('add[Attribute]', ''); $form->addrow(__('Attribute'), $content); // - Оператор $content = $form->select_tag('add[op]', $operators, ''); $form->addrow(__('op'), $content); // - Значение $content = $form->text_box('add[Value]', ''); $form->addrow(__('Value'), $content); /* Кнопка модального окна с формой добавления нового атрибута */ $html .= wf_modal(__('Append'), __('Adding of RADIUS-attribute'), $form->show(1), 'ubButton', 450, 275); // Форма переопределения атрибута 'User-Name' $query = "SELECT `value` FROM `radius_reassigns` WHERE `netid` = '{$netid}'"; $result = simple_query($query); $result['value'] = !empty($result['value']) ? $result['value'] : ''; $form = new InputForm('', 'POST', __('Save'), '', '', '', 'reassignment'); // - Значение $content = $form->radio_button('reassignment[value]', array('' => __('Login'), 'ip' => __('IP'), 'mac' => __('MAC')), $result['value']); $form->addrow(__('Value'), $content); /* Кнопка модального окна с формой переназначения атрибута 'User-Name' */ $html .= wf_modal(__('Reassign User-Name'), __('Reassignment of User-Name'), $form->show(1), 'ubButton', 450, 155); /* Атрибуты сети */ $html .= wf_TableBody($rows, '100%', '0', 'sortable'); } /* Показываем содержимое модуля */ show_window($title, $html); } else { show_window(__('Error'), __('This module is disabled')); }