page_number = (!empty($_GET['page-id'])) ? $_GET['page-id'] : 1; $filter_keyword = (!empty($_GET['query'])) ? PT_Secure($_GET['query']) : ''; $filter_type = ''; $db->pageLimit = 50; $type = 'all'; $link = ""; if (!empty($filter_keyword)) { $link .= "&query=".$filter_keyword; $sql = " (text LIKE '%$filter_keyword%') "; $comments = $db->where($sql); } if (!empty($_GET['range']) && in_array($_GET['range'], array('Today','Yesterday','This Week','This Month','Last Month','This Year'))) { if ($_GET['range'] == 'Today' || $_GET['range'] == 'Yesterday') { $this_start = strtotime(date('M')." ".date('d').", ".date('Y')." 12:00am"); $this_end = strtotime(date('M')." ".date('d').", ".date('Y')." 11:59pm"); if ($_GET['range'] == 'Yesterday') { $this_start = strtotime(date('M')." ".date('d',strtotime("-1 days")).", ".date('Y')." 12:00am"); $this_end = strtotime(date('M')." ".date('d',strtotime("-1 days")).", ".date('Y')." 11:59pm"); } $main_range = 'Today'; $title = "Daily"; } elseif ($_GET['range'] == 'This Week') { $time = strtotime(date('l').", ".date('M')." ".date('d').", ".date('Y')); if (date('l') == 'Saturday') { $this_start = strtotime(date('M')." ".date('d').", ".date('Y')." 12:00am"); } else{ $this_start = strtotime('last saturday, 12:00am', $time); } if (date('l') == 'Friday') { $this_end = strtotime(date('M')." ".date('d').", ".date('Y')." 11:59pm"); } else{ $this_end = strtotime('next Friday, 11:59pm', $time); } $main_range = 'This Week'; $title = "Weekly"; } elseif ($_GET['range'] == 'This Month' ||$_GET['range'] == 'Last Month') { $this_start = strtotime("1 ".date('M')." ".date('Y')." 12:00am"); $this_end = strtotime(cal_days_in_month(CAL_GREGORIAN, date('m'), date('Y'))." ".date('M')." ".date('Y')." 11:59pm"); if ($_GET['range'] == 'Last Month') { $this_start = strtotime("1 ".date('M',strtotime("-1 month"))." ".date('Y')." 12:00am"); $this_end = strtotime(cal_days_in_month(CAL_GREGORIAN, date('m',strtotime("-1 month")), date('Y'))." ".date('M',strtotime("-1 month"))." ".date('Y')." 11:59pm"); } $main_range = 'This Month'; $title = "Monthly"; } elseif ($_GET['range'] == 'This Year') { $this_start = strtotime("1 January ".date('Y')." 12:00am"); $this_end = strtotime("31 December ".date('Y')." 11:59pm"); $main_range = 'This Year'; $title = "Yearly"; } } $start = ''; $end = ''; $first_code = ''; $second_code = ''; if (!empty($_GET['range']) && !in_array($_GET['range'], array('Today','Yesterday','This Week','This Month','Last Month','This Year'))) { $arr = explode('-', $_GET['range']); if (preg_match('~(0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])[- /.](19|20)\d\d~m', $arr[0]) && preg_match('~(0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])[- /.](19|20)\d\d~m', $arr[1])) { $start = PT_Secure($arr[0]); $end = PT_Secure($arr[1]); $this_start = strtotime($start); $this_end = strtotime($end); $month_days = cal_days_in_month(CAL_GREGORIAN, date('m',strtotime($start)), date('Y',strtotime($start))); $diff = abs(strtotime($end) - strtotime($start)); $years = floor($diff / (365*60*60*24)); $months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24)); $days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24)); if ($years >= 1) { $array = array(); for ($i=date('Y',strtotime($start)); $i <= date('Y',strtotime($end)); $i++) { $array["'".$i."'"] = 0; } $main_range = 'Custom'; $code = 'Y'; $title = "Yearly"; } elseif ($months >= 1) { $array = array('01' => 0 ,'02' => 0 ,'03' => 0 ,'04' => 0 ,'05' => 0 ,'06' => 0 ,'07' => 0 ,'08' => 0 ,'09' => 0 ,'10' => 0 ,'11' => 0 ,'12' => 0); $code = 'm'; $main_range = 'This Year'; $title = "Monthly"; if (date('Y',strtotime($start)) == date('Y',strtotime($end))) { $array = array(); for ($i=date('m',strtotime($start)); $i <= date('m',strtotime($end)); $i++) { $array["'".(int)$i."'"] = 0; } $code = 'm'; $main_range = 'Custom'; } else{ $month = cal_days_in_month(CAL_GREGORIAN, date('m',strtotime($start)), date('Y',strtotime($start))); $array = array(); for ($i=(int)date('m',strtotime($start)); $i <= 12; $i++) { $array["'".(int)$i.'-'.date('Y',strtotime($start))."'"] = 0; } for ($i=1; $i <= (int)date('m',strtotime($end)); $i++) { $array["'".(int)$i.'-'.date('Y',strtotime($end))."'"] = 0; } $first_code = 'm'; $second_code = 'Y'; $main_range = 'Custom'; } } elseif ($days > 7) { if (date('m',strtotime($start)) == date('m',strtotime($end))) { $array = array(); for ($i=date('d',strtotime($start)); $i <= date('d',strtotime($end)); $i++) { $array["'".(int)$i."'"] = 0; } $code = 'd'; $main_range = 'Custom'; } else{ $month = cal_days_in_month(CAL_GREGORIAN, date('m',strtotime($start)), date('Y',strtotime($start))); $array = array(); for ($i=(int)date('d',strtotime($start)); $i <= $month; $i++) { $array["'".(int)$i.'-'.date('m',strtotime($start))."'"] = 0; } for ($i=1; $i <= (int)date('d',strtotime($end)); $i++) { $array["'".(int)$i.'-'.date('m',strtotime($end))."'"] = 0; } $first_code = 'd'; $second_code = 'm'; $main_range = 'Custom'; } $title = "Daily"; } elseif ($days >= 1 && $days < 8) { $title = "Daily"; $code = 'l'; $array = array('Saturday' => 0 , 'Sunday' => 0 , 'Monday' => 0 , 'Tuesday' => 0 , 'Wednesday' => 0 , 'Thursday' => 0 , 'Friday' => 0); if (date('m',strtotime($start)) == date('m',strtotime($end))) { $array = array(); for ($i=date('d',strtotime($start)); $i <= date('d',strtotime($end)); $i++) { $array["'".(int)$i."'"] = 0; } $code = 'd'; $main_range = 'Custom'; } else{ $month = cal_days_in_month(CAL_GREGORIAN, date('m',strtotime($start)), date('Y',strtotime($start))); $array = array(); for ($i=(int)date('d',strtotime($start)); $i <= $month; $i++) { $array["'".(int)$i.'-'.date('m',strtotime($start))."'"] = 0; } for ($i=1; $i <= (int)date('d',strtotime($end)); $i++) { $array["'".(int)$i.'-'.date('m',strtotime($end))."'"] = 0; } $first_code = 'd'; $second_code = 'm'; $main_range = 'Custom'; } } } } $rang_link = $link; if (!empty($this_start) && !empty($this_end)) { $link .= "&range=".PT_Secure($_GET['range']); $db->where('time',$this_start,'>=')->where('time',$this_end,'<='); } $sort_link = $link; $sort_array = array('DESC_i' => array('id' , 'DESC'), 'ASC_i' => array('id' , 'ASC'), 'DESC_te' => array('text' , 'DESC'), 'ASC_te' => array('text' , 'ASC'), 'DESC_v' => array('video_id' , 'DESC'), 'ASC_v' => array('video_id' , 'ASC'), 'DESC_p' => array('post_id' , 'DESC'), 'ASC_p' => array('post_id' , 'ASC'), 'DESC_t' => array('time' , 'DESC'), 'ASC_t' => array('time' , 'ASC')); if (!empty($_GET['sort']) && in_array($_GET['sort'], array_keys($sort_array))) { $db->orderBy($sort_array[$_GET['sort']][0],$sort_array[$_GET['sort']][1]); $link .= "&sort=".PT_Secure($_GET['sort']); $rang_link .= "&sort=".PT_Secure($_GET['sort']); } else{ $_GET['sort'] = 'DESC_i'; $db->orderBy('id', 'DESC'); } $comments = $db->objectbuilder()->paginate(T_COMMENTS, $pt->page_number); $get_online_users = $db->where('last_active', time() - 60, '>')->getValue(T_USERS, 'COUNT(*)'); if (($pt->page_number > $db->totalPages) && !empty($_GET['page-id'])) { header("Location: " . PT_LoadAdminLinkSettings('manage-comments')); exit(); } ?>

Manage Comments

Manage Comments
$comment) { $video_link = ''; $video_id = ''; $articles_link = ''; $articles_title = ''; if (!empty($comment->video_id)) { $get_video = PT_GetVideoByID($comment->video_id, 1, 1,2); $video_link = $get_video->url; $video_id = $get_video->video_id; } if (!empty($comment->post_id)) { $article = $db->where('id',$comment->post_id)->getOne(T_POSTS); $art_id = $article->id; $articles_link = PT_Link("articles/read/$art_id"); $articles_title = PT_ShortText($article->title,50); } echo PT_LoadAdminPage('manage-comments/list', array('TIME' => date('F-d-Y',$comment->time) ,'ARTICLES_LINK' => $articles_link ,'ARTICLES_TITLE' => $articles_title ,'VIDEO_LINK' => $video_link ,'VIDEO_ID' => $video_id ,'ID' => $comment->id ,'TEXT' => PT_Markup($comment->text))); } ?>
ID '" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="#000000" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-arrow-up cursor-p"> '" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="#000000" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-arrow-down cursor-p"> Text '" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="#000000" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-arrow-up cursor-p"> '" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="#000000" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-arrow-down cursor-p"> Video '" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="#000000" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-arrow-up cursor-p"> '" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="#000000" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-arrow-down cursor-p"> Articles '" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="#000000" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-arrow-up cursor-p"> '" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="#000000" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-arrow-down cursor-p"> Posted On '" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="#000000" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-arrow-up cursor-p"> '" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="#000000" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-arrow-down cursor-p"> Action
page_number out of " . $db->totalPages; ?>