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