/**
*
* 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'));
}
