<?php
require_once "includes/application-top.php";
error_reporting(0);
$dbObj = new DB();
$dbObj->fun_db_connect();
$page = $_REQUEST['page_no'];
$start = ($page - 1) * limit;
$end = limit;
if (@$_SESSION['session_admin_type'] == "1") {
$sqlSel_post = "SELECT * FROM " . TABLE_COMMENT;
} else {
$sqlSel_post = "SELECT * FROM " . TABLE_COMMENT . " WHERE post_id in (SELECT GROUP_CONCAT(id) as ids FROM " . TABLE_POST . " GROUP BY user_id HAVING user_id= " . $_REQUEST['userid'] . ")";
}
$sqlSel_post .= " order by `id` DESC limit {$start},{$end}";
$rsResult_post = $dbObj->fun_db_query($sqlSel_post);
while ($user = $dbObj->fun_db_fetch_rs_object($rsResult_post)) {
?>
<tr>
<td><?php
echo $user->comment;
?>
</td>
<td><?php
if ($user->approved_by != '0') {
$user1 = $dbObj->get_row(TABLE_USERS, "id=" . $user->approved_by);
echo $user1['name'];
} else {
}
?>
</td>
<?php require_once "includes/application-top.php"; $dbObj = new DB(); $dbObj->fun_db_connect(); $sqlSel_post1 = "SELECT * FROM " . TABLE_POST . " where id=" . $_REQUEST['post_id']; $rsResult_post1 = $dbObj->fun_db_query($sqlSel_post1); $post1 = $dbObj->fun_db_fetch_rs_object($rsResult_post1); $arr['total_view'] = $post1->total_view + 1; $lastID = $dbObj->update_data(TABLE_POST, 'id', $arr, md5($_REQUEST['post_id'])); ?>
<div class="pright">
<div class="brdb pad5">
<div class="prt-panel">
<a href="#">
<span class="value">
<?php
echo $total_Post;
?>
</span>
<span class="label">My Posts</span>
</a>
</div>
<?php
$sql = "SELECT sum(`total_like`) as total_likes,sum(`total_view`) as total_view,sum(`total_comment`) as total_comment\t FROM `post` WHERE `user_id`=" . $_SESSION['session_admin_userid'] . " group by user_id";
$rsResult_like = $dbObj->fun_db_query($sql);
$like = $dbObj->fun_db_fetch_rs_object($rsResult_like);
?>
<div class="prt-panel">
<a href="#">
<span class="value"><?php
if (@$like->total_comment == '') {
echo "0";
} else {
echo @$like->total_comment;
}
?>
</span>
<span class="label">Comments</span>
</a>
</div>
<div class="prt-panel">
<?php
require "PHPMailer/class.phpmailer.php";
require_once "includes/application-top.php";
$dbObj = new DB();
$dbObj->fun_db_connect();
$sqlSel_post = "SELECT * FROM " . TABLE_POST . " where id=" . $_REQUEST['id'];
$rsResult_post = $dbObj->fun_db_query($sqlSel_post);
$post = $dbObj->fun_db_fetch_rs_object($rsResult_post);
$sqlSel_post_like = "SELECT * FROM " . TABLE_LIKE . " where post_id=" . $post->id;
$rsResult_post_like = $dbObj->fun_db_query($sqlSel_post_like);
$like = $dbObj->fun_db_get_num_rows($rsResult_post_like);
$sqlSel_post_comment = "SELECT * FROM " . TABLE_COMMENT . " where post_id=" . $post->id . " and status=1 order by id desc";
$rsResult_post_comment = $dbObj->fun_db_query($sqlSel_post_comment);
$comment = $dbObj->fun_db_get_num_rows($rsResult_post_comment);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html xml:lang="en">
<head>
<title><?php
echo prefix . " | Post Details";
?>
</title>
<meta name="viewport" content="width=device-width; initial-scale=1; maximum-scale=1">
<link rel="stylesheet" href="css/style.css" type="text/css" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(
function(){
$(".menu-icon").click(function(){
