How can PHP forum administrators prevent the reduction of total posting points when deleting posts?

When a PHP forum administrator deletes a post, the total posting points of the user who made the post are typically reduced by the number of points earned for that post. To prevent this reduction, administrators can store the points earned for each post in a separate table and update the total points separately. By doing this, the total posting points will remain unaffected when a post is deleted. 

// Sample PHP code snippet to prevent reduction of total posting points when deleting posts

// Store points earned for each post in a separate table
// Assuming $pointsEarned is the variable that holds the points earned for a post
// Assuming $postId is the variable that holds the ID of the post being deleted
// Assuming $userId is the variable that holds the ID of the user who made the post

// Retrieve points earned for the post being deleted
$query = "SELECT points_earned FROM posts WHERE post_id = $postId";
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($result);
$pointsEarned = $row['points_earned'];

// Update total points of the user separately
$query = "UPDATE users SET total_points = total_points - $pointsEarned WHERE user_id = $userId";
mysqli_query($conn, $query);

// Delete the post
$query = "DELETE FROM posts WHERE post_id = $postId";
mysqli_query($conn, $query);

Keywords

PHP forum administrators prevent deletion

Related Questions