function getChatMsg($id, $user, $msg, $con)
{
$msg_len = strlen($msg);
$file = "../chatt/rooms/{$id}.dat";
if ($msg_len > 0) {
$u = users($con, "`fname`", $user);
$out_name = "{$u['0']}";
$time = intval($_POST["time"]) / 1000;
$h = date("h");
$m = date("m");
$time = date("h<b>:</b>m a");
//"$h<b>:</b>$m";
$fullmsg = "\n<tr><td><b>{$out_name}</b>: <span>{$msg}</span> <span class='tt'>{$time}</span></tr></td>";
if (is_file($file)) {
$cfile = fopen($file, "a");
} else {
$cfile = fopen($file, "w");
}
fwrite($cfile, $fullmsg);
fclose($cfile);
}
if (is_file($file)) {
$cfile = fopen($file, "r");
while ($cont = fread($cfile, 1024)) {
$result .= $cont;
}
fclose($cfile);
$result = str_replace("<tr>", "", $result);
$result = str_replace("<td>", "", $result);
$result = str_replace("</td>", "", $result);
$result = str_replace("</tr>", "", $result);
$result = str_replace("</b>", "", $result);
$result = str_replace("<b>", "", $result);
$result = str_replace("&", "&", $result);
$result = str_replace("</span>", "", $result);
$result = str_replace("<span>", "", $result);
$result = str_replace("<span class='tt'>", "", $result);
$result = html_entity_decode($result);
echo "<msg>{$result}</msg>";
} else {
echo "<msg>No chat History {$id}</msg>";
}
}
exit;
}
if (isset($_POST["aliases-import-perform"])) {
aliases_import_perform();
exit;
}
if (isset($_POST["aliase-delete-perform"])) {
aliases_delete_perform();
exit;
}
if (isset($_POST["aliase-empty-perform"])) {
aliases_empty_perform();
exit;
}
if (isset($_GET["users"])) {
users();
exit;
}
if (isset($_GET["users-database"])) {
users_database();
exit;
}
if (isset($_GET["users-import"])) {
users_import_form();
exit;
}
if (isset($_POST["users-import-perform"])) {
users_import_perform();
exit;
}
if (isset($_POST["users-delete-perform"])) {
</div>
<div class="row mailinglist">
<table class="table table-striped table-hover ">
<thead>
<tr>
<th>ID</th>
<th>Email</th>
<th>Date d'inscription</th>
<th>Inscrit ?</th>
<th>Modifier</th>
<th>Supprimer</th>
</tr>
</thead>
<tbody>
<?php
$users = users($connexion);
foreach ($users as $user) {
?>
<tr>
<td><?php
echo $user['id'];
?>
</td>
<td><?php
echo $user['mail'];
?>
</td>
<td><?php
echo $user['registration_date'];
?>
</td>
function content()
{
global $pagenum, $selected, $message, $menu, $set, $langmessage, $LNEversion, $out, $prefix;
if ($message != "") {
$out .= "<div class=\"LNE_message\">" . $message . "</div>\n";
}
if ($_SESSION['adminlevel'] > 3) {
$out .= adminmenu();
}
switch ($_GET['do']) {
case "search":
$out .= "<h2 class=\"LNE_title\">{$langmessage['66']}</h2>\n";
$out .= search();
break;
case "register":
if ($set['gzip']) {
$out .= register();
}
break;
case "addons":
$out .= addons();
break;
case "create":
$out .= create_page();
break;
case "database":
$out .= query();
break;
case "delete":
delete_page();
break;
case "edit":
print $out;
$out = "";
editpage();
break;
case "editextra":
print $out;
$out = "";
extras();
break;
case "editmenu":
$out .= editmenu();
break;
case "login":
$out .= loginform();
break;
case "plugins":
$out .= plugins();
break;
case "profile":
if ($_SESSION[$set['password']] == "1") {
$out .= profile();
}
break;
case "query":
$out .= query();
break;
case "settings":
$out .= settings();
break;
case "setup":
$out .= setup();
break;
case "sitemap":
$out .= showsitemap($langmessage, 0);
break;
case "users":
$out .= users();
break;
default:
$addons = fetch_all(dbquery("SELECT * FROM " . $prefix . "addons WHERE active=1"));
$found = false;
foreach ($addons as $addon) {
if ($_GET['do'] == $addon['name'] && $_SESSION['adminlevel'] >= $addon['adminlevel']) {
require_once "addons/" . $addon['name'] . "/admin.php";
$out .= $addon['aname']();
$found = true;
break;
}
}
if (!$found) {
$result = dbquery("SELECT * FROM " . $prefix . "paginas WHERE page=\"" . $pagenum . "\"");
if ($row = fetch_array($result)) {
if ($row['restricted'] != 0 && $row['restricted'] > $_SESSION['adminlevel']) {
$out .= restrictedpage($row['restricted']);
} else {
$contnt = html_entity_decode(stripslashes($row['content']));
showcontent($contnt);
}
} else {
$result = dbquery("SELECT * FROM " . $prefix . "paginas WHERE page=\"index\"");
if ($row = fetch_array($result)) {
$contnt = html_entity_decode(stripslashes($row['content']));
showcontent($contnt);
} else {
$out .= "<h2>{$langmessage['116']}</h2>\n";
}
}
foreach ($addons as $addon) {
if (strpos($contnt, "%!\$" . $addon['name']) && $addon['header'] == 1) {
require_once "addons/" . $addon['name'] . "/header.php";
}
}
}
}
}
<?php
require 'db_connect.php';
require 'neo_connect.php';
// Create Users in Neo4j from database records
$users = users();
foreach ($users as $user) {
create_user_node($user);
}
// Create friendships in Neo4j from database records
$friendships = friendships();
foreach ($friendships as $friendship) {
$user = user_by_id($friendship['user_id']);
$friend = user_by_id($friendship['friend_id']);
create_neo_friendship($user, $friend);
}
// Create place nodes
$places = places();
foreach ($places as $place) {
create_place_node($place);
}
$user_db = user_by_id(64);
$place_db = place_by_id(5);
create_neo_list_entry($user_db, $place_db);
$user_db = user_by_id(65);
$place_db = place_by_id(6);
create_neo_list_entry($user_db, $place_db);
function create_user_node($properties)
{
global $client, $user_name_index, $user_id_index;
// only insert this node if we have not already seen it
if(isset($_GET["duplicate-delete"])){duplicate_delete();exit;}
if(isset($_GET["aliases"])){aliases();exit;}
if(isset($_GET["aliases-database"])){aliases_database();exit;}
if(isset($_GET["aliases-import"])){aliases_import_form();exit;}
if(isset($_POST["aliases-import-perform"])){aliases_import_perform();exit;}
if(isset($_POST["aliase-delete-perform"])){aliases_delete_perform();exit;}
if(isset($_POST["aliase-empty-perform"])){aliases_empty_perform();exit;}
if(isset($_GET["users"])){users();exit;}
if(isset($_GET["users-database"])){users_database();exit;}
if(isset($_GET["users-import"])){users_import_form();exit;}
if(isset($_POST["users-import-perform"])){users_import_perform();exit;}
if(isset($_POST["users-delete-perform"])){users_delete_perform();exit;}
if(isset($_POST["users-empty-perform"])){users_empty_perform();exit;}
js();
function js(){
$domain=$_GET["domain"];
$_GET["ou"]=urlencode($_GET["ou"]);
$message = 'Ungültige Abfrage: ' . mysql_error() . "\n";
$message .= 'Gesamte Abfrage: ' . $query;
die($message);
}
return $result;
}
function userdetailslink($mac)
{
return '<a href="http://172.16.1.3/daloradius/mng-edit.php?username='******'">' . $mac . '</a>';
}
echo "<table><tr><th>Username</th><th>Group</th><th>Name</th><th>Email</th><th>Primary device</th><th>Organization</th><th>Computername</th><th>Vendor</th><th>Notes</th><th>Creation date</th></tr>";
function users()
{
return 'SELECT distinct(radcheck.username) as username,radusergroup.groupname as groupname, userinfo.lastname as name, userinfo.email as email, userinfo.mobilephone as primarydev, userinfo.company as org, userinfo.address as hostname, userinfo.city as vendor, userinfo.notes as notes, userinfo.creationdate as creationdate FROM radcheck LEFT JOIN radusergroup ON radcheck.username=radusergroup.username LEFT JOIN userinfo ON radcheck.username=userinfo.username GROUP by radcheck.Username order by creationdate;';
}
$all_users = query(users());
while ($row = mysql_fetch_assoc($all_users)) {
echo "<tr>";
echo '<td>' . userdetailslink($row['username']) . '</a></td>';
echo '<td>' . $row['groupname'] . '</td>';
echo '<td>' . $row['name'] . '</td>';
echo '<td>' . $row['email'] . '</td>';
echo '<td>' . $row['primarydev'] . '</td>';
echo '<td>' . $row['org'] . '</td>';
echo '<td>' . $row['hostname'] . '</td>';
echo '<td>' . $row['vendor'] . '</td>';
echo '<td>' . $row['notes'] . '</td>';
echo '<td>' . $row['creationdate'] . '</td>';
echo "</tr>";
}
mysql_free_result($all_users);
return $result;
}
function userdetailslink($mac)
{
return '<a href="http://172.16.1.3/daloradius/mng-edit.php?username='******'">' . $mac . '</a>';
}
$today = date('Y-m-d', strtotime('-0 day'));
$yesterday = date('Y-m-d', strtotime('-1 day'));
$daysago7 = date('Y-m-d', strtotime('-6 days'));
$daysago30 = date('Y-m-d', strtotime('-29 days'));
echo "<table><tr><th>Username</th><th>Group</th><th>Name</th><th>Email</th><th>Organization</th><th>Computername</th><th>Vendor</th><th>Down last 7 days</th><th>Up last 7 days</th></tr>";
function users($startday, $endday)
{
return 'select * from ( (SELECT distinct(radacct.UserName) as username, radusergroup.groupname as groupname, userinfo.lastname as name, userinfo.email as email, userinfo.company as company, userinfo.address as address, userinfo.city as city, ROUND((sum(radacct.AcctOutputOctets)/1000000)) as download, ROUND((sum(radacct.AcctInputOctets)/1000000)) as upload FROM radacct LEFT JOIN radusergroup ON radacct.username=radusergroup.username LEFT OUTER JOIN userinfo ON radacct.username=userinfo.username WHERE (AcctStopTime > "0000-00-00 00:00:01" AND AcctStartTime> "' . $startday . '" AND AcctStartTime<date(date_add("' . $endday . '", INTERVAL +1 DAY))) OR ((radacct.AcctStopTime IS NULL OR radacct.AcctStopTime = "0000-00-00 00:00:00") AND AcctStartTime<date(date_add("' . $endday . '", INTERVAL +1 DAY))) group by UserName) union (select ui.username, "", "", "", "", "", "", "0" as download, "0" as upload from userinfo ui) ) as t1 group by username;';
}
$all_users = query(users($daysago7, $today));
while ($row = mysql_fetch_assoc($all_users)) {
echo "<tr>";
echo '<td>' . userdetailslink($row['username']) . '</a></td>';
echo '<td>' . $row['groupname'] . '</td>';
echo '<td>' . $row['name'] . '</td>';
echo '<td>' . $row['email'] . '</td>';
echo '<td>' . $row['company'] . '</td>';
echo '<td>' . $row['address'] . '</td>';
echo '<td>' . $row['city'] . '</td>';
echo '<td>' . $row['download'] . '</td>';
echo '<td>' . $row['upload'] . '</td>';
echo "</tr>";
}
mysql_free_result($all_users);
?>
public function createFeed($con, $user, $num)
{
$p_r = _pals($user, $con);
/*
email==0 femail==1 href1==2 href2==3 time==4 img_1==5 img_2==6 img_3==7 fname==8 lname==9 sex==10 type = 11
*/
$num = $num ? $num : 20;
$n = 0;
$months = array("Null", "January", "Febuary", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
$feed = "<table>";
$res = mysqli_query($con, "SELECT `mhistory`.`email`,`mhistory`.`femail`,`mhistory`.`href1`,`mhistory`.`href2`,`mhistory`.`time`,`mhistory`.`img_1`,`mhistory`.`img_2`,`mhistory`.`img_3`,`users`.`fname`,`users`.`lname`,`users`.`sex`,`mhistory`.`type` FROM `mhistory` inner join `users` on (`users`.`em` = `mhistory`.`email`) ORDER BY `mhistory`.`time` DESC");
while ($rarray = mysqli_fetch_array($res)) {
$em1 = $rarray[0];
$em2 = $rarray[1];
if (in_array($em1, $p_r) || in_array($em2, $p_r) || $em1 == $user || $em2 == $user) {
} else {
continue;
}
$n++;
if ($n == $num + 1) {
break;
}
$time = new vartime($rarray[4]);
$pid = $rarray[2];
$tt = $time->ttime();
$uu = array($rarray[8], $rarray[9], $rarray[10]);
if (strlen($em2) > 1) {
$uy = users($con, "`fname`,`lname`,`sex`", $em2);
}
if ($em1 == $em2) {
$owner = $uu[2] == "Male" ? "his" : "her";
$ss = "";
} else {
$owner = "{$uy['0']} {$uy['1']}";
$ss = "'s";
}
$pwn = $uu[2] == "Male" ? "himself" : "herself";
$email = "{$uu['0']} {$uu['1']}";
if ($rarray[11] == 1) {
$feed .= "<tr><td><img src='../img/mg/not.png'/></td><td valign='center'><a href='../home/?ref={$em1}#divprof' onclick = 'return _go(event,\"../prof/\",\"{$em1}\")' onmouseover = '_pop(event,\"{$em1}\")'>{$email}</a> added a comment on <a onmouseover = '_pop(event,\"{$em2}\")' href='../home/?ref={$em2}#divprof' onclick = 'return _go(event,\"../prof/\",\"{$em2}\")'>" . $owner . "{$ss}</a> <a href='../home/?ref={$em2}&ccc={$pid}#divwall' onclick='return get_only_d({$pid},\"{$em2}\")'>post</a> <span class='tt'>" . $tt . "</span></td></tr>";
} else {
if ($rarray[11] == 2) {
$feed .= "<tr><td><img src='../img/mg/not.png'/></td><td valign='center'><a href='../home/?ref={$em1}#divprof' onclick = 'return _go(event,\"../prof/\",\"{$em1}\")' onmouseover = '_pop(event,\"{$em1}\")'>{$email}</a> created a post on <a href='../home/?ref={$em2}#divprof' onclick = 'return _go(event,\"../prof/\",\"{$em2}\")' onmouseover = '_pop(event,\"{$em2}\")'>" . $owner . "{$ss}</a> <a href='../home/?ref={$em2}&ccc={$pid}#divwall' onclick = 'return get_only_d({$pid},\"{$em2}\")'>wall</a> <span class='tt'>" . $tt . "</span></td></tr>";
} else {
if ($rarray[11] == 3) {
$feed .= "<tr><td><img src='../img/mg/not.png'/></td><td valign='center'><a href='../home/?ref={$em1}#divprof' onclick = 'return _go(event,\"../prof/\",\"{$em1}\")' onmouseover = '_pop(event,\"{$em1}\")'>{$email}</a> and <a href='../home/?ref={$em2}#divprof' onclick='return _go(event,\"../prof/\",\"{$em2}\")' onmouseover = '_pop(event,\"{$em2}\")'>" . $owner . "</a> became friends <span class='tt'>" . $tt . "</span></td></tr>";
} else {
if ($rarray[11] == 4) {
$img1 = $rarray[5] != "" ? "<img src='" . $rarray[5] . "' />" : "";
$img2 = $rarray[6] != "" ? "<img src='" . $rarray[6] . "' />" : "";
$img3 = $rarray[7] != "" ? "<img src='" . $rarray[7] . "' />" : "";
list($r1, $r2, $r3) = explode("_", $rarray[2]);
$feed .= "<tr><td></td><td valign='center'><a onmouseover='_pop(event,\"{$em1}\")' href='../home/?ref={$em1}#divprof' onclick ='return _gp(\"../prof/\",\"{$em1}\")'>{$email}</a> Uploaded new photos <span class='tt'>" . $tt . "</span><br/><table><tr><td><a href='../home/?ref={$em1}&pid={$r1}#divalb' onclick='return get_only_p(event,\"{$r1}\");'>{$img1}</a></td><td><a onclick='return get_only_p(event,\"{$r2}\");' href='../home/?ref={$em1}&pid={$r2}#divalb'>{$img2}</a></td><td><a href='../home/?ref={$em1}&pid={$r3}#divalb' onclick='return get_only_p(event,\"{$r3}\");'>{$img3}</a></td></tr></table></td></tr>";
} else {
if ($rarray[11] == 5) {
$feed .= "<tr><td><img src='../img/mg/not.png'/></td><td valign='center'><a href='../home/?ref={$em2}#divprof' onclick='return _go(event,\"../prof/\",\"{$em2}\")' onmouseover = '_pop(event,\"{$em2}\")'>{$owner}</a> received a request from <a href='../home/?ref={$em1}#divprof' onclick='return _go(event,\"../prof/\",\"{$em1}\")' onmouseover = '_pop(event,\"{$em1}\")'>{$email}</a> <span class='tt'>" . $tt . "</span></td></tr>";
} else {
if ($rarray[11] == 6) {
list($did, $ty) = explode("__", $pid);
if ($ty == 0) {
$addy = "<a href='../home/?ref={$em2}&aid={$did}#divalb' onclick='return get_only_p(event,{$did});'>";
} else {
$addy = "<a href='../home/?ref={$em2}&pid={$did}#divalb' onclick='return get_only_p(event,{$did});'>";
}
$feed .= "<tr><td><img src='../img/mg/not.png'/></td><td valign='center'><a href='../home/?ref={$em1}#divprof' onclick='return _go(event,\"../prof/\",\"{$em1}\")' onmouseover = '_pop(event,\"{$em1}\")'>" . $email . "</a> added a comment on <a href='../home/?ref={$em2}#divprof' onclick='return _go(event,\"../prof/\",\"{$em2}\")' onmouseover = '_pop(event,\"{$em2}\")'>" . $owner . "{$ss}</a> photo {$addy} album</a> <span class='tt'>" . $tt . "</span></td></tr>";
} else {
if ($rarray[11] == 7) {
$id = $rarray[6];
$tag = $rarray[5];
$u = users($con, "`fname`,`lname`", $tag);
$ttt = $tag == $em1 ? $pwn : "{$u['0']} {$u['1']}";
$getpic = mysqli_query($con, "SELECT `img_m` FROM `pics` WHERE `id` = {$id};");
$pr = mysqli_fetch_array($getpic);
$feed .= "<tr><td valign='top'><img src='../img/mg/not.png'/></td><td valign='center'><a href='../home/?ref={$em1}#divprof' onclick='return _go(event,\"../prof/\",\"{$em1}\")' onmouseover = '_pop(event,\"{$em1}\")'>{$email}</a> tagged <a href='../home/?ref={$tag}#divprof' onclick='return _go(event,\"../prof/\",\"{$tag}\")' onmouseover = '_pop(event,\"{$tag}\")'>{$ttt}</a> in <a href='../home/?ref={$em2}#divprof' onclick='return _go(event,\"../prof/\",\"{$em2}\")' onmouseover = '_pop(event,\"{$em2}\")'>" . $owner . "{$ss}</a> photo <a href='../home/?ref={$em2}&pid={$id}#divalb' onclick='return get_only_p(event,{$id});'>album</a> <span class='tt'>" . $tt . "</span><br/><a href='../home/?ref={$em2}&pid={$id}#divalb' onclick='return get_only_p(event,{$id});'><img src='" . $pr[0] . "'/></a></td></tr>";
} else {
if ($rarray[11] == 8) {
$day = $rarray[5];
$mon = $rarray[6];
$mont = $months[$mon];
$daydiff = $day > date("d") ? time() + ($day - date("d")) * 24 * 60 * 60 : date("U") - (date("d") - $day) * 24 * 60 * 60;
$exDay = date("D", $daydiff);
$tense = date("d") > $day ? "was" : "is";
$msgg = $day == abs(date("d")) ? "is today" : ($day - date("d") == 1 ? "is tomorrow" : (date("d") - $day == 1 ? "was yesterday" : "{$tense} on {$exDay} {$day} {$mont}"));
$feed .= "<tr><td><img src='../img/mg/not.png'/></td><td valign='top'><a href='../home/?ref={$em1}#divwall' onclick='return _go(event,\"../prof/\",\"{$em1}\")' onmouseover = '_pop(event,\"{$em1}\")' title='Click and write on wall'>{$email}</a>{$ss} birthday {$msgg} announced<span class='tt'>" . $tt . "</span></td></tr>";
} else {
if ($rarray[11] == 9) {
$img = _gp($con, "`img_1`,`gp`", $em2);
$feed .= "<tr><td valign='top'><img src='../img/mg/not.png'/></td><td><a href='./?ref={$em1}#divprof' onclick='return _go(event,\"../prof/\",\"{$em1}\");' onmouseover='_pop(event,\"{$em1}\");' >{$uu['0']} {$uu['1']}</a> joined group <a href='../home/?gpid={$em2}#gpcent' onclick=' _go(event,\"../gp/\",\"{$user}\");return _gpwall(\"{$em2}\")' >{$img['1']}</a><br/><span class='tt'>{$tt}</a><br/><img src='{$img['0']}' /></td></tr>";
} else {
if ($rarray[11] == 10) {
$img = _gp($con, "`img_1`,`gp`", $em2);
$feed .= "<tr><td valign='top'><img src='../img/mg/not.png' /></td><td><a href='../home/?ref={$em1}#divprof' onclick='return _go(event,\"../prof/\",\"{$em1}\");' >{$uu['0']} {$uu['1']}</a> is now a group Admin <a href='../home/?gpid={$em2}#gpcent' onclick=' _go(event,\"../gp/\",\"{$user}\");return _gpwall(\"{$em2}\")' >{$img['1']}</a><br/><span class='tt'>{$tt}</a><br/><img src='{$img['0']}' /></td></tr>";
} else {
if ($rarray[11] == 11) {
$img = _gp($con, "`img_1`,`gp`", $em2);
$feed .= "<tr><td valign='top'><img src='../img/mg/not.png' /></td><td><a href='../home/?ref={$em1}#divprof' onclick='return _go(event,\"../prof/\",\"{$em1}\");' >{$uu['0']} {$uu['1']}</a> created <a href='../home/?gpid={$em2}#gpcent' onclick=' _go(event,\"../gp/\",\"{$user}\");return _gpwall(\"{$em2}\")' >{$img['1']}</a> group<br/><span class='tt'>{$tt}</a><br/><img src='{$img['0']}' /></td></tr>";
}
}
}
}
}
}
}
}
}
}
}
}
$feed .= "</table>";
return $feed;
}
/**
* Attempt to find the user id of the currently logged in user.
**/
public function getUserId()
{
try {
return users('id', $this->getGuard());
} catch (\Exception $e) {
return;
}
}
}
function deluser($userid)
{
global $USER_TB;
$query = "delete from " . $USER_TB . " where user_id='" . $userid . "'";
echo "<h4>" . translate("Deleting user") . " ...</h4>";
mysql_query($query);
echo "<meta http-equiv=\"refresh\" content=\"0; url=cal_user.php?op=users\">";
}
switch ($op) {
// overview of admin-users
case "users":
users($timeout);
break;
// add new user
// add new user
case "adduser":
adduser($logn, $passwd, $usertype, $userdesc);
break;
//
//
case "userdel":
deluser($userid);
break;
// default: bar, and show new submissions
// default: bar, and show new submissions
default:
users($timeout);
break;
}
include 'cal_footer.inc.php';
function users_action($mysqli)
{
$data = users($mysqli);
require "templates/users.php";
}
if ($user) {
$sql = 'UPDATE user SET subscribded = :subscribded, confirmed = :confirmed WHERE secret = :secret';
$preparedStatement = $connexion->prepare($sql);
$preparedStatement->bindValue('subscribded', 1);
$preparedStatement->bindValue('confirmed', 1);
$preparedStatement->bindValue('secret', $user["secret"]);
$preparedStatement->execute();
$message = "Vous êtes maitenant inscrit à la newsletter.";
$info = "Désormais, vous allez être tenu informé de l'avancée de ce projet formidable et révolutionnaire. N'hésitez pas à consulter régulièrement votre boîte mail.";
$success = true;
} else {
$message = "Le lien ne correspond pas à votre compte utilisateur.";
$info = "Vérifiez bien le lien qui vous a été envoyé, il se peut qu'il contient une erreur.";
$succes = false;
}
$users = users($connexion, $secret);
}
?>
<!DOCTYPE html>
<html lang="fr">
<head>
<title>Examen PHP</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no, maximum-scale=1">
<link rel="stylesheet" href="https://bootswatch.com/cosmo/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body id="gradient">
<div class="container">
<h1 class="title-intro"><?php
echo $message;
delete($_GET);
break;
case (isset($_GET['deldoc']) || isset($_GET['item'])) && !empty($_COOKIE[md5("role")]):
deleteDoc($_GET);
break;
case isset($_GET['chgdoc']) || isset($_POST['chgdoc']):
changeDoc($_POST, $_GET);
break;
case isset($_GET['chid']) || isset($_POST['chid']):
change($_POST, $_GET, $_FILES);
break;
case isset($_GET['ins']) || isset($_POST['ins']):
insert($_GET, $_POST, $_FILES);
break;
case isset($_GET['users']) || isset($_POST['users']):
users($_GET, $_POST);
break;
case isset($_GET['delusr']) && !empty($_COOKIE[md5("role")]):
deleteUsr($_GET);
break;
case isset($_GET['chgusr']) || isset($_POST['chgusr']):
changeUsr($_POST, $_GET);
break;
case isset($_GET['admin']):
admin();
break;
case isset($_GET['logs']):
logs($_GET);
break;
case isset($_GET['upmenu']) || isset($_POST['insmenu']):
upmenu($_POST, $_GET);
function get_user_list($db)
{
users($db, 'callback_user_html');
}
return false;
}
//початкова провірка полів
$mysqli = mysqli_connect(DB_HOST, DB_LOGIN, DB_PASSWORD, DB_NAME);
$result_set = mysqli_query($mysqli, "SELECT password FROM registered_users WHERE login = '******'");
$user = mysqli_fetch_assoc($result_set);
//получаємо результат запиту у вигляді масиву
$real_password = $user['password'];
//пароль з БД
mysqli_close($mysqli);
return $real_password == $password;
//якщо паролі співпадають, то вернеться true
}
/*Приймаємо дані*/
if (isset($_POST['auth'])) {
/*Получаємо дані*/
$log = $_POST['log'];
$pass = md5($_POST['pass']);
if (empty($log) || empty($_POST['pass'])) {
$_SESSION['empty_auth'] = 1;
} else {
if (users($log) && checkUser($log, $pass)) {
//якщо введені правильні дані записуємо і-ю
$_SESSION['login'] = $log;
$_SESSION['password'] = $pass;
} else {
//якщо користувач помилився
$_SESSION['error_auth'] = 1;
}
}
}
