function getPublicNavigation($url = ".") { /* intialize page navigation */ $navigation = new Navigation(); $navigation = $navigation::selectNavTable("sitemenu"); $public_menu = $navigation->findAllRecords("ORDER BY Position"); $subnav = $navigation::selectNavTable("submenu"); $subnav_menu = $subnav::findAllRecords("ORDER BY Id"); $index_link = GenerateUrl::buildLink($url, $url, "Home"); if (!empty($public_menu)) { $output = "<ul id=\"navigation\"><li>{$index_link}</li>"; foreach ($public_menu as $pmenu) { $make_link = GenerateUrl::buildLink($url, ".", $pmenu->Nav_name, "action=view,target={$pmenu->Nav_name},cpos={$pmenu->Position},rnd=" . random_chars(20)); $output .= "<li>{$make_link}"; /*list for sub navigation starts here */ if (!empty($subnav_menu)) { $output .= "<ul class=\"subnav\">"; foreach ($subnav_menu as $smenu) { //submenu list hear if ($pmenu->Nav_level === $smenu->Sub_navlevel && $pmenu->Id === $smenu->Nav_id) { $msub_link = GenerateUrl::buildLink($url, ".", $smenu->Sub_navname, "action=view,target={$smenu->Sub_navname},cpos={$pmenu->Position},rndchars=" . random_chars(20)); $output .= "<li>{$msub_link}</li>"; } } $output .= "</ul>"; } } $output .= "</li></ul>"; return $output; } }
$serverPort = $_POST['serverPort']; if (!portIsUsed($serverPort)) { $Password = array('secret' => $_SESSION['password']); $newServer = $MasterServer->newServer(); $newServer = $newServer->ice_context($Password); $newServerID = $newServer->id(); $newServer = $MasterServer->getServer($newServerID)->ice_context($Password); if ($serverName == '') { $serverName = str_replace('{ID}', $newServerID, $LANGUAGE['mumble_server_title']); $newServer->setConf('registername', $serverName); } else { $newServer->setConf('registername', '' . $serverName); } $newServer->setConf('users', $serverSlots); $newServer->setConf('port', '' . $serverPort); $pw = random_chars(8); $newServer->setConf('SuperUserPassword', $pw); $newServer->setSuperuserPassword($pw); header('location: ../index.php?server_id=' . $newServerID . '&display=overview'); } else { header('location: ../'); } } if (isset($_GET['delete-server'])) { $ServerToDelete = $_POST['server_id']; $Server = $MasterServer->getServer(intval($ServerToDelete))->ice_context($Password); if ($Server->isRunning()) { $Server->stop(); } $Server->delete(); header('location: ../');
$errordata[] = "Дубликат HOST"; $key[] = "host"; $ek["host"] = true; } $lS2 = free_ips($_POST['room']); // $_POST['F'] = ($_POST['F']); // $_POST['I'] = ($_POST['I']); // $_POST['O'] = ($_POST['O']); // $_POST['department'] = ($_POST['department']); // $_POST['comment'] = ($_POST['comment']); $content .= cut($_POST, $lS2); } else { $exnet = explode(".", $_POST['ip']); $n = 'net' . $exnet[2]; if (strlen($_POST['host']) < 2) { $host = transliterate($_POST['F']) . "_" . random_chars(2); } else { $host = $_POST['host']; } $ss = explode(".", $_POST['ip']); $IArray = array('active' => '1', 'F' => $_POST['F'], 'I' => $_POST['I'], 'O' => $_POST['O'], 'date' => $_POST['date'], 'host' => $host, 'room' => $_POST['room'], 'mac' => strtolower($_POST['mac']), 'ip' => $_POST['ip'], 'tel' => $_POST['tel'], 'kurs' => $_POST['kurs'], 'department' => $_POST['department'], 'comment' => $_POST['comment'], 's_net' => $ss[2], 's_ip' => $ss[3], 'admin' => ADMINLOGIN); if ((LEVEL == 1 or LEVEL == 2) && defined('ALLOW_users_isrouter') && ALLOW_users_isrouter == true) { $IArray['isrouter'] = $_POST['isrouter'] == 'on' ? 1 : 0; } if (LEVEL == 1 or LEVEL == 2) { $IArray['active'] = $_POST['active']; } if (defined('ALLOW_users_cosmosedit') && ALLOW_users_cosmosedit == true) { $IArray['idc'] = $_POST['idc']; } if (!$dataMySQL->Insert($IArray, DB_PREFIX . "users")) {
$result .= chr(mt_rand(97, 122)); } return $result; } $full_name = ''; $email = ''; $city = ''; $db = new mysqli('localhost', 'root', '', 'chat'); $query = $db->prepare('INSERT INTO `chat`.`users` (`full_name`, `email`, `city`) VALUES (?, ?, ?);'); $query->bind_param('sss', $full_name, $email, $city); $db->begin_transaction(); for ($i = 0; $i < 10000000; $i++) { if ($i !== 0 && !($i % 10000)) { $db->commit(); $db->begin_transaction(); print round($i / 10000000 * 100, 2) . "% \r"; } $full_name = random_chars() . ' ' . random_chars(); $email = random_chars() . '@' . random_chars() . '.' . random_chars(2, 3); $city = random_chars(); $query->execute(); } $db->commit(); $query->close(); print "Creating index\n"; $db->query('ALTER TABLE `chat`.`users` ADD FULLTEXT(`full_name`);'); print "Done\n"; $results = $db->query("SELECT * FROM `chat`.`users` WHERE MATCH(`full_name`) AGAINST('john*' IN BOOLEAN MODE);"); print_r($results->fetch_all(MYSQLI_ASSOC)); $results->close(); $db->close();