Может кто-нибудь помочь ?
читать дальше
<? $page_title = 'Удаление учеников';
include('header.php');
setlocale (LC_ALL, 'ru_RU.cp1251');
session_start();
if (!$_SESSION[login]) {
echo "Нужно <a href='login.php'>Войти</a>";
include ('footer.php');
} elseif(!in_array($_SESSION['userdata']['stat'], array("Директор", "Декан")))
{
echo "<a href='./login.php'>Доступ запрещен</a>";
}
else
{
include ('connection.php');
if ($_GET['action'] = "delete") {
if($delete){
$checkbox=$_POST[checkbox];
for($i=0;$i<count($checkbox);$i++){
$id = $checkbox[$i];
$querysub = "SELECT email, nick, faculty FROM test WHERE id='$id'";
$resultsub = mysql_query($querysub) or die("ERROR: $query.".mysql_error());
$row2 = mysql_fetch_assoc($resultsub);
$name = $row2['nick'];
$faculta = $row2['faculty'];
$email = $row2['email'];
include('emails/sending_details5.php');
mail($email, $subject, $message, $headers);
mysql_query("DELETE FROM test WHERE id=$id LIMIT 1");
if ($faculta == 'Элквуд') {
mysql_query("DELETE FROM ElwUsers WHERE `Name`='$name'");
} elseif ($faculta == 'Аквилмар') {
mysql_query("DELETE FROM AqmUsers WHERE `Name`='$name'");
} elseif ($faculta == 'Фокстейн') {
mysql_query("DELETE FROM FxtUsers WHERE `Name`='$name'");
}
$result = mysql_query($sql);
}
// Redirect to page if deleted ok.
if($result){
header("location: /delete.php");
}
}
}
else {
include ('connection.php');
$query = "SELECT stat FROM test WHERE nick = '".addslashes($_SESSION[login])."'";
$result = mysql_query($query) or die("ERROR: $query.".mysql_error());
$row = mysql_fetch_assoc($result);
switch($row[stat])
{
case 'Директор':
$query2 = "SELECT * FROM test WHERE (stat = 'Ученик' OR stat = 'Префект') AND points = '0' ORDER by faculty";
$result2 = mysql_query($query2) or die ("ERROR: $query2.".mysql_error());
if (mysql_num_rows($result2) > 0) {
// yes
// print them one after another
echo "<p><b>Списки учеников </b><br>
<form action='?action=delete' method='post' />
<table id=\"journal\">
<tr>
<td><b>Имя</b></td>
<td><b>Факультет</b></td>
<td><b>Курс</b></td>
<td><b>Баллы</b></td>
<td><b>Дата регистрации</b></td>
<td><b>Удалить? <input type='checkbox' name='sAll' 'selectAll(this)' /> (Отметить все)</b></td>
</tr>";
$num = $start;
$classnames = array(
"Префект" => "prf",
"Ученик" => "stu",
);
while($row2 = mysql_fetch_assoc($result2)) {
echo "<tr class='" . $classnames[$row2['stat']] . "'>";
echo " <td><a href=\"javasсript:void(0);\" \"openwin('inform.php?id=".$row2['id']."');return false\">".$row2['nick']."</a></td>";
echo " <td>".$row2['faculty']."</td>";
echo " <td>".$row2['course']."</td>";
echo " <td>".$row2['points']."</td>";
echo " <td>".$row2['date']."</td>";
echo " <td><input name='checkbox[]' type='checkbox' id='checkbox[]' value=\"".$row2['id']."\" /></td>";
echo "</tr>";
}
echo "</table>";
echo "<input name='delete' type='submit' id='delete' value='Delete' class='submit'>
Вернуться в <a href=\"menu.php\">главное меню</a></div>";
echo "</form></p>";
}
else {
echo '<div id="contenido"><center>Учеников с количеством баллов > 0 нет!<br>Вернуться в <a href=menu.php>глваное меню</a></center></div>';
}
break;
case 'Декан':
$query2 = "SELECT * FROM test WHERE faculty = '" . mysql_escape_string($_SESSION['userdata']['faculty']) . "' AND (stat = 'Ученик' OR stat = 'Префект') AND points = '0' ORDER by date";
$result2 = mysql_query($query2) or die ("ERROR: $query2.".mysql_error());
if (mysql_num_rows($result2) > 0) {
// yes
// print them one after another
echo "<p><b>Списки учеников </b><br>
<form action='?action=delete' method='post' />
<table id=\"journal\">
<tr>
<td><b>Имя</b></td>
<td><b>Факультет</b></td>
<td><b>Курс</b></td>
<td><b>Баллы</b></td>
<td><b>Дата регистрации</b></td>
<td><b>Удалить? <input type='checkbox' name='sAll' 'selectAll(this)' /> (Отметить все)</b></td>>
</tr>";
$num = $start;
$classnames = array(
"Префект" => "prf",
"Ученик" => "stu",
);
while($row2 = mysql_fetch_assoc($result2)) {
echo "<tr class='" . $classnames[$row2['stat']] . "'>";
echo " <td><a href=\"javasсript:void(0);\" \"openwin('inform.php?id=".$row2['id']."');return false\">".$row2['nick']."</a></td>";
echo " <td>".$row2['faculty']."</td>";
echo " <td>".$row2['course']."</td>";
echo " <td>".$row2['points']."</td>";
echo " <td>".$row2['date']."</td>";
echo " <td><input name='checkbox[]' type='checkbox' id='checkbox[]' value=\"".$row2['id']."\" /></td>";
echo "</tr>";
}
echo "</table>";
echo "<input name='delete' type='submit' id='delete' value='Delete' class='submit'>
Вернуться в <a href=\"menu.php\">главное меню</a></div>";
echo "</form></p>";
}
else {
echo '<div id="contenido"><center>Учеников с количеством баллов > 0 нет!<br>Вернуться в <a href=menu.php>глваное меню</a></center></div>';
}
break;
}
}
include('footer.php');
}
?>
include('header.php');
setlocale (LC_ALL, 'ru_RU.cp1251');
session_start();
if (!$_SESSION[login]) {
echo "Нужно <a href='login.php'>Войти</a>";
include ('footer.php');
} elseif(!in_array($_SESSION['userdata']['stat'], array("Директор", "Декан")))
{
echo "<a href='./login.php'>Доступ запрещен</a>";
}
else
{
include ('connection.php');
if ($_GET['action'] = "delete") {
if($delete){
$checkbox=$_POST[checkbox];
for($i=0;$i<count($checkbox);$i++){
$id = $checkbox[$i];
$querysub = "SELECT email, nick, faculty FROM test WHERE id='$id'";
$resultsub = mysql_query($querysub) or die("ERROR: $query.".mysql_error());
$row2 = mysql_fetch_assoc($resultsub);
$name = $row2['nick'];
$faculta = $row2['faculty'];
$email = $row2['email'];
include('emails/sending_details5.php');
mail($email, $subject, $message, $headers);
mysql_query("DELETE FROM test WHERE id=$id LIMIT 1");
if ($faculta == 'Элквуд') {
mysql_query("DELETE FROM ElwUsers WHERE `Name`='$name'");
} elseif ($faculta == 'Аквилмар') {
mysql_query("DELETE FROM AqmUsers WHERE `Name`='$name'");
} elseif ($faculta == 'Фокстейн') {
mysql_query("DELETE FROM FxtUsers WHERE `Name`='$name'");
}
$result = mysql_query($sql);
}
// Redirect to page if deleted ok.
if($result){
header("location: /delete.php");
}
}
}
else {
include ('connection.php');
$query = "SELECT stat FROM test WHERE nick = '".addslashes($_SESSION[login])."'";
$result = mysql_query($query) or die("ERROR: $query.".mysql_error());
$row = mysql_fetch_assoc($result);
switch($row[stat])
{
case 'Директор':
$query2 = "SELECT * FROM test WHERE (stat = 'Ученик' OR stat = 'Префект') AND points = '0' ORDER by faculty";
$result2 = mysql_query($query2) or die ("ERROR: $query2.".mysql_error());
if (mysql_num_rows($result2) > 0) {
// yes
// print them one after another
echo "<p><b>Списки учеников </b><br>
<form action='?action=delete' method='post' />
<table id=\"journal\">
<tr>
<td><b>Имя</b></td>
<td><b>Факультет</b></td>
<td><b>Курс</b></td>
<td><b>Баллы</b></td>
<td><b>Дата регистрации</b></td>
<td><b>Удалить? <input type='checkbox' name='sAll' 'selectAll(this)' /> (Отметить все)</b></td>
</tr>";
$num = $start;
$classnames = array(
"Префект" => "prf",
"Ученик" => "stu",
);
while($row2 = mysql_fetch_assoc($result2)) {
echo "<tr class='" . $classnames[$row2['stat']] . "'>";
echo " <td><a href=\"javasсript:void(0);\" \"openwin('inform.php?id=".$row2['id']."');return false\">".$row2['nick']."</a></td>";
echo " <td>".$row2['faculty']."</td>";
echo " <td>".$row2['course']."</td>";
echo " <td>".$row2['points']."</td>";
echo " <td>".$row2['date']."</td>";
echo " <td><input name='checkbox[]' type='checkbox' id='checkbox[]' value=\"".$row2['id']."\" /></td>";
echo "</tr>";
}
echo "</table>";
echo "<input name='delete' type='submit' id='delete' value='Delete' class='submit'>
Вернуться в <a href=\"menu.php\">главное меню</a></div>";
echo "</form></p>";
}
else {
echo '<div id="contenido"><center>Учеников с количеством баллов > 0 нет!<br>Вернуться в <a href=menu.php>глваное меню</a></center></div>';
}
break;
case 'Декан':
$query2 = "SELECT * FROM test WHERE faculty = '" . mysql_escape_string($_SESSION['userdata']['faculty']) . "' AND (stat = 'Ученик' OR stat = 'Префект') AND points = '0' ORDER by date";
$result2 = mysql_query($query2) or die ("ERROR: $query2.".mysql_error());
if (mysql_num_rows($result2) > 0) {
// yes
// print them one after another
echo "<p><b>Списки учеников </b><br>
<form action='?action=delete' method='post' />
<table id=\"journal\">
<tr>
<td><b>Имя</b></td>
<td><b>Факультет</b></td>
<td><b>Курс</b></td>
<td><b>Баллы</b></td>
<td><b>Дата регистрации</b></td>
<td><b>Удалить? <input type='checkbox' name='sAll' 'selectAll(this)' /> (Отметить все)</b></td>>
</tr>";
$num = $start;
$classnames = array(
"Префект" => "prf",
"Ученик" => "stu",
);
while($row2 = mysql_fetch_assoc($result2)) {
echo "<tr class='" . $classnames[$row2['stat']] . "'>";
echo " <td><a href=\"javasсript:void(0);\" \"openwin('inform.php?id=".$row2['id']."');return false\">".$row2['nick']."</a></td>";
echo " <td>".$row2['faculty']."</td>";
echo " <td>".$row2['course']."</td>";
echo " <td>".$row2['points']."</td>";
echo " <td>".$row2['date']."</td>";
echo " <td><input name='checkbox[]' type='checkbox' id='checkbox[]' value=\"".$row2['id']."\" /></td>";
echo "</tr>";
}
echo "</table>";
echo "<input name='delete' type='submit' id='delete' value='Delete' class='submit'>
Вернуться в <a href=\"menu.php\">главное меню</a></div>";
echo "</form></p>";
}
else {
echo '<div id="contenido"><center>Учеников с количеством баллов > 0 нет!<br>Вернуться в <a href=menu.php>глваное меню</a></center></div>';
}
break;
}
}
include('footer.php');
}
?>