Permalink
Cannot retrieve contributors at this time
Name already in use
A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Watersys/delete_category.php
Go to fileThis commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
90 lines (89 sloc)
3.52 KB
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
//This page let delete a category | |
include('config.php'); | |
if(isset($_GET['id'])) | |
{ | |
$id = intval($_GET['id']); | |
$dn1 = mysqli_fetch_array(mysqli_query($var,'select count(id) as nb1, name, position from categories where id="'.$id.'" group by id')); | |
if($dn1['nb1']>0) | |
{ | |
if(isset($_SESSION['username']) and $_SESSION['username']==$admin) | |
{ | |
?> | |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> | |
<html xmlns="http://www.w3.org/1999/xhtml"> | |
<head> | |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> | |
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous"> | |
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js" integrity="sha384-wfSDF2E50Y2D1uUdj0O3uMBJnjuUD4Ih7YwaYd1iqfktj0Uod8GCExl3Og8ifwB6" crossorigin="anonymous"></script> | |
<link href="<?php echo $design; ?>/style.css" rel="stylesheet" title="Style" /> | |
<title>Delete a category - <?php echo htmlentities($dn1['name'], ENT_QUOTES, 'UTF-8'); ?> - Forum</title> | |
</head> | |
<body> | |
<div align="center"> | |
<div class="header"> | |
<a href="<?php echo $url_home; ?>"><img width="80%" src="<?php echo $design; ?>/images/logo.png" alt="Forum" /></a> | |
</div></div> | |
<div class="contentdeletecategory"> | |
<?php | |
$nb_new_pm = mysqli_fetch_array(mysqli_query($var,'select count(*) as nb_new_pm from pm where ((user1="'.$_SESSION['userid'].'" and user1read="no") or (user2="'.$_SESSION['userid'].'" and user2read="no")) and id2="1"')); | |
$nb_new_pm = $nb_new_pm['nb_new_pm']; | |
?> | |
<div class="box"> | |
<div class="box_left"> | |
<a href="<?php echo $url_home; ?>">WCSF Index</a> > <?php echo htmlentities($dn1['name'], ENT_QUOTES, 'UTF-8'); ?> > Delete the category | |
</div> | |
<div class="box_right"> | |
<a href="list_pm.php">Your messages(<?php echo $nb_new_pm; ?>)</a> - <a href="profile.php?id=<?php echo $_SESSION['userid']; ?>"><?php echo htmlentities($_SESSION['username'], ENT_QUOTES, 'UTF-8'); ?></a> (<a href="login.php">Logout</a>) | |
</div> | |
<div class="clean"></div> | |
</div> | |
<?php | |
if(isset($_POST['confirm'])) | |
{ | |
if(mysqli_query($var,'delete from categories where id="'.$id.'"') and mysqli_query($var,'delete from topics where parent="'.$id.'"') and mysqli_query($var,'update categories set position=position-1 where position>"'.$dn1['position'].'"')) | |
{ | |
?> | |
<div class="message">The category and it topics have successfully been deleted.<br /> | |
<a href="<?php echo $url_home; ?>">Go to the WCSF index</a></div> | |
<?php | |
} | |
else | |
{ | |
echo 'An error occured while deleting the category and it topics.'; | |
} | |
} | |
else | |
{ | |
?> | |
<form action="delete_category.php?id=<?php echo $id; ?>" method="post"> | |
Are you sure you want to delete this category and all it topics? | |
<input type="hidden" name="confirm" value="true" /> | |
<input type="submit" value="Yes" /> <input type="button" value="No" onclick="javascript:history.go(-1);" /> | |
</form> | |
<?php | |
} | |
?> | |
</div> | |
<!-- <div class="foot"> | |
<p><b>Water Control System and Discussion Portal for Farmers</b></p> | |
</div> --> | |
</body> | |
</html> | |
<?php | |
} | |
else | |
{ | |
echo '<h2>You must be logged as an administrator to access this page: <a href="login.php">Login</a> - <a href="signup.php">Sign Up</a></h2>'; | |
} | |
} | |
else | |
{ | |
echo '<h2>The category you want to delete doesn\'t exist.</h2>'; | |
} | |
} | |
else | |
{ | |
echo '<h2>The ID of the category you want to delete is not defined.</h2>'; | |
} | |
?> |