Server : LiteSpeed
System : Linux premium84.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
User : claqxcrl ( 523)
PHP Version : 8.1.32
Disable Function : NONE
Directory : /home/claqxcrl/www/ondjoweb/admin/
|
Server : LiteSpeed System : Linux premium84.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64 User : claqxcrl ( 523) PHP Version : 8.1.32 Disable Function : NONE Directory : /home/claqxcrl/www/ondjoweb/admin/ |
<?php
session_start();
include('includes/config.php');
error_reporting(0);
if(strlen($_SESSION['login'])==0)
{
header('location:index.php');
}
else{
if( $_GET['descom'])
{
#Code for unapprove
$id=intval($_GET['descom']);
$query=mysqli_query($con,"update tblcomments set status='0' where id='$id'");
$msg="Comentário desaprovado ";
}
// Code for deletion
if($_GET['delcom'])
{
$id=intval($_GET['delcom']);
$query=mysqli_query($con,"delete from tblcomments where id='$id'");
$delmsg="Comentário apagado definitivamente";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title> OndjoWEB| Comentários Activos</title>
<link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/core.css" rel="stylesheet" type="text/css" />
<link href="assets/css/components.css" rel="stylesheet" type="text/css" />
<link href="assets/css/icons.css" rel="stylesheet" type="text/css" />
<link href="assets/css/pages.css" rel="stylesheet" type="text/css" />
<link href="assets/css/menu.css" rel="stylesheet" type="text/css" />
<link href="assets/css/responsive.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="../plugins/switchery/switchery.min.css">
<script src="assets/js/modernizr.min.js"></script>
</head>
<body class="fixed-left">
<!-- Begin page -->
<div id="wrapper">
<!-- Top Bar Start -->
<?php include('includes/topheader.php');?>
<!-- ========== Left Sidebar Start ========== -->
<?php include('includes/leftsidebar.php');?>
<!-- Left Sidebar End -->
<!-- ============================================================== -->
<!-- Start right Content here -->
<!-- ============================================================== -->
<div class="content-page">
<!-- Start content -->
<div class="content">
<div class="container">
<div class="row">
<div class="col-xs-12">
<div class="page-title-box">
<h4 class="page-title">Gerir Comentários Aprovados</h4>
<ol class="breadcrumb p-0 m-0">
<li>
<a href="#">Admin</a>
</li>
<li>
<a href="#">Comentários </a>
</li>
<li class="active">
Comentários Aprovados
</li>
</ol>
<div class="clearfix"></div>
</div>
</div>
</div>
<!-- end row -->
<div class="row">
<div class="col-sm-6">
<?php if($msg){ ?>
<div class="alert alert-success" role="alert">
<strong>Sucesso!</strong> <?php echo htmlentities($msg);?>
</div>
<?php } ?>
<?php if($delmsg){ ?>
<div class="alert alert-danger" role="alert">
<strong>Oh pá</strong> <?php echo htmlentities($delmsg);?></div>
<?php } ?>
</div>
<div class="row">
<div class="col-md-12">
<div class="demo-box m-t-20">
<div class="table-responsive">
<table class="table m-0 table-colored-bordered table-bordered-primary">
<thead>
<tr>
<th>#</th>
<th> Nome</th>
<th>Email</th>
<th width="300">Comentário</th>
<th>Status</th>
<th>Post / Notícia</th>
<th>Data da postagem</th>
<th>Acção</th>
</tr>
</thead>
<tbody>
<?php
$query=mysqli_query($con,"Select tblcomments.id, tblcomments.name,tblcomments.email,tblcomments.postingDate,tblcomments.comment,tblposts.id as postid,tblposts.PostTitulo from tblcomments join tblposts on tblposts.id=tblcomments.postId where tblcomments.status=1");
$cnt=1;
while($row=mysqli_fetch_array($query))
{
?>
<tr>
<th scope="row"><?php echo htmlentities($cnt);?></th>
<td><?php echo htmlentities($row['name']);?></td>
<td><?php echo htmlentities($row['email']);?></td>
<td><?php echo htmlentities($row['comment']);?></td>
<td><?php $st=$row['status'];
if ($st == 1) :
echo "<span style='color: red'>Pendente</span>";
else :
echo "<span style='color: blue'>Activo</span>";
endif;
?></td>
<td><a href="https://claquemagazine.dev/noticia-singular.php?postId=<?php echo htmlentities($row['postid']);?>"><?php echo htmlentities($row['PostTitulo']);?></a> </td>
<td><?php echo htmlentities($row['postingDate']);?></td>
<td>
<a href="manage-comments.php?descom=<?php echo htmlentities($row['id']);?>" title="Desaprovar"><i class="ion-arrow-return-right" style="color: #29b6f6;"></i></a>
<a href="manage-comments.php?delcom=<?php echo htmlentities($row['id']);?>&&action=del" title="Apagar"> <i class="fa fa-trash-o" style="color: #f05050"></i></a>
</td>
</tr>
<?php
$cnt++;
} ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!--- end row -->
<div class="row">
<div class="col-md-12">
<div class="demo-box m-t-20">
<div class="m-b-30">
</div>
</div>
</div>
</div>
</div> <!-- container -->
</div> <!-- content -->
<?php include('includes/footer.php');?>
</div>
</div>
<!-- END wrapper -->
<script>
var resizefunc = [];
</script>
<!-- jQuery -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>
<script src="assets/js/detect.js"></script>
<script src="assets/js/fastclick.js"></script>
<script src="assets/js/jquery.blockUI.js"></script>
<script src="assets/js/waves.js"></script>
<script src="assets/js/jquery.slimscroll.js"></script>
<script src="assets/js/jquery.scrollTo.min.js"></script>
<script src="../plugins/switchery/switchery.min.js"></script>
<!-- App js -->
<script src="assets/js/jquery.core.js"></script>
<script src="assets/js/jquery.app.js"></script>
</body>
</html>
<?php } ?>