<?php
include "includes/application-top.php";
$dbObj = new DB();
$dbObj->fun_db_connect();
$objAdmin = new Admins();
$objAdmin->fun_authenticate_admin();
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= " . $_SESSION['session_admin_userid'] . ")";
}
$rsResult_post = $dbObj->fun_db_query($sqlSel_post);
$total_Post = $dbObj->fun_db_get_num_rows($rsResult_post);
$total_pages = ceil($total_Post / limit);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html xml:lang="en">
<head>
<title><?php
echo prefix . " | Comment List";
?>
</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(){
if (count($_POST) > 0) {
$arr = $_POST;
$arr['add_date'] = date("Y-m-d H:i:s");
$lastID1 = $dbObj->insert_data(TABLE_COMMENT, $arr);
/* mail for new comment*/
if ($_SESSION['session_admin_userid'] == '') {
if ($lastID1) {
$_SESSION['msg'] = '<span style=" color:green;font-size:13px;">Your comment is successfully posted. Will display after approval.</span>';
}
$user_name = 'jwasser.com';
//site url
$mail = new PHPMailer();
$mail->From = "*****@*****.**";
$mail->FromName = $user_name;
$mail->AddReplyTo($_POST['email']);
$mail->AddAddress("*****@*****.**");
$mail->Subject = "Comment Posted On Post";
$mail->IsHTML(true);
$mail->Body = "<b><font style='font-size:14px;'>Below comment posted on post for approvel</font></b><br><br>\n\t\t <br>" . $arr['comment'] . "<br>";
$mail->send();
//if(!$mail->send()){echo "Not Send";die;}else{echo "Mail Send";die;}
}
$sqlSel_com1 = "SELECT * FROM " . TABLE_COMMENT . " where post_id=" . $arr['post_id'];
$rsResult_com1 = $dbObj->fun_db_query($sqlSel_com1);
$total_comment = $dbObj->fun_db_get_num_rows($rsResult_com1);
$arr['total_comment'] = $total_comment;
$lastID = $dbObj->update_data(TABLE_POST, 'id', $arr, md5($arr['post_id']));
if ($lastID) {
redirectURL("show-post.php?id=" . $arr['post_id']);
}
}
<?php
require_once "includes/application-top.php";
$dbObj = new DB();
$dbObj->fun_db_connect();
?>
<?php
$sql_like = "SELECT * FROM " . TABLE_LIKE . " where post_id=" . $_REQUEST['post_id'] . " and user_id=" . $_REQUEST['user_id'];
$rsResult_like = $dbObj->fun_db_query($sql_like);
$like = $dbObj->fun_db_get_num_rows($rsResult_like);
if ($like == '') {
$arr['post_id'] = $_REQUEST['post_id'];
$arr['user_id'] = $_REQUEST['user_id'];
$lastID = $dbObj->insert_data(TABLE_LIKE, $arr);
$sql_like1 = "SELECT * FROM " . TABLE_LIKE . " where post_id=" . $_REQUEST['post_id'];
$rsResult_like1 = $dbObj->fun_db_query($sql_like1);
$like1 = $dbObj->fun_db_get_num_rows($rsResult_like1);
$arr['total_like'] = $like1;
$lastID = $dbObj->update_data(TABLE_POST, 'id', $arr, md5($_REQUEST['post_id']));
echo $like1;
} else {
$sql_like1 = "SELECT * FROM " . TABLE_LIKE . " where post_id=" . $_REQUEST['post_id'];
$rsResult_like1 = $dbObj->fun_db_query($sql_like1);
$like1 = $dbObj->fun_db_get_num_rows($rsResult_like1);
echo $like1;
}
?>
<?php
require_once "includes/application-top.php";
$objAdmin = new Admins();
$objAdmin->fun_authenticate_admin();
$dbObj = new DB();
$dbObj->fun_db_connect();
//print_r($_POST);
if (count($_POST) > 0) {
$sql_pwd = "SELECT * FROM " . TABLE_USERS . " where password='******'o_password']) . "' and id=" . $_POST['user_id'];
$rsResult_pwd = $dbObj->fun_db_query($sql_pwd);
$total = $dbObj->fun_db_get_num_rows($rsResult_pwd);
if ($total) {
if (@$_POST['n_password'] == @$_POST['c_password']) {
$arr['password'] = md5($_POST['n_password']);
$lastID = $dbObj->update_data(TABLE_USERS, 'id', $arr, md5($_POST['user_id']));
$_SESSION['msg'] = '<span style=" color:green;font-size:13px;">Password changed</span>';
redirectURL(SITE_ADMIN_URL . "logout.php");
} else {
$_SESSION['msg'] = "New password and Comform password are not matching";
redirectURL(SITE_ADMIN_URL . "reset-password.php");
}
} else {
$_SESSION['msg'] = "old password incorrect";
redirectURL(SITE_ADMIN_URL . "reset-password.php");
}
}
<?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(){
