<?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(){