98 lines
2.2 KiB
PHP
98 lines
2.2 KiB
PHP
<?php
|
|
#Datenbank Verbindung einbinden
|
|
require 'Connections/Connections.php';
|
|
include "Includes/Session.php";
|
|
if($_SESSION["UserLevel"] < 1 )
|
|
{
|
|
header('Location: Login.php');
|
|
exit;
|
|
}
|
|
#Header und Menü einbinden
|
|
$webpagetitle = "Accounts Aktivieren";
|
|
include "Includes/Header.php";
|
|
include "Includes/Menu.php";
|
|
#html Content ausgeben
|
|
|
|
|
|
#Auslesen der nicht aktivierten User
|
|
function print_user()
|
|
{
|
|
global $con;
|
|
$lesen= $con->query("SELECT UserID,CONCAT(Lname, ' ',Fname) as 'Name' FROM user where isactive = 0 order by UserID ASC");
|
|
echo '<select class="CMField" name="Users[]" size="10" multiple>';
|
|
while($row = mysqli_fetch_array($lesen))
|
|
{
|
|
echo "<option value=".$row['UserID'].">".$row['Name']."</option>";
|
|
}
|
|
echo '</select>';
|
|
}
|
|
|
|
function activate_user()
|
|
{
|
|
global $con;
|
|
echo '<br/><br/><br/><br/>';
|
|
$post = $_POST;
|
|
unset($post['Enable']);
|
|
foreach($post as $key => $value)
|
|
{
|
|
if($key == "Users"){
|
|
$userids = $value;
|
|
}
|
|
}
|
|
$elemente = sizeof($userids);
|
|
for($x=0;$x<$elemente;$x++){
|
|
$result = $con->query("UPDATE user SET isactive='1' WHERE UserID='{$userids[$x]}';") or die(mysql_error());
|
|
}
|
|
header('Location: '.$_SERVER['REQUEST_URI']);
|
|
}
|
|
|
|
function delete_account()
|
|
{
|
|
global $con;
|
|
echo '<br/><br/><br/><br/>';
|
|
$post = $_POST;
|
|
unset($post['Enable']);
|
|
foreach($post as $key => $value)
|
|
{
|
|
if($key == "Users"){
|
|
$userids = $value;
|
|
}
|
|
}
|
|
$elemente = sizeof($userids);
|
|
for($x=0;$x<$elemente;$x++){
|
|
$result = $con->query("delete from user WHERE UserID='{$userids[$x]}';") or die(mysql_error());
|
|
}
|
|
header('Location: '.$_SERVER['REQUEST_URI']);
|
|
}
|
|
|
|
if(isset($_POST['Enable'])){
|
|
activate_user();
|
|
}
|
|
if(isset($_POST['Delete'])){
|
|
delete_account();
|
|
}
|
|
|
|
|
|
?>
|
|
<div class="content">
|
|
<div class="Rahmen">
|
|
<div class="center">
|
|
<form name="Enable" action="" method="post">
|
|
<?php print_user();?>
|
|
<div class="FormElement">
|
|
<input name="Enable" class="button" type="submit" value="Aktivieren"/>
|
|
</div>
|
|
<div class="FormElement">
|
|
<input name="Delete" class="button" type="submit" value="löschen"/>
|
|
</div>
|
|
</form>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<?php
|
|
|
|
#Footer einbinden
|
|
|
|
include "Includes/Footer.php";
|
|
?>
|