ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / keebchat.com / core / apps / cpanel / account_reports

<?php
# @*************************************************************************@
# @ @author Mansur Altamirov (Mansur_TL)									@
# @ @author_url 1: https://www.instagram.com/mansur_tl                      @
# @ @author_url 2: http://codecanyon.net/user/mansur_tl                     @
# @ @author_email: highexpresstore@gmail.com                                @
# @*************************************************************************@
# @ ColibriSM - The Ultimate Modern Social Media Sharing Platform           @
# @ Copyright (c) 21.03.2020 ColibriSM. All rights reserved.                @
# @*************************************************************************@

function cl_admin_get_profile_reports($args = array()) {
	global $db;

$args           = (is_array($args)) ? $args : array();
    $options        = array(
        "offset"    => false,
        "limit"     => 7,
        "offset_to" => false,
        "order"     => 'DESC'
    );

$args           = array_merge($options, $args);
    $offset         = $args['offset'];
    $limit          = $args['limit'];
    $order          = $args['order'];
    $offset_to      = $args['offset_to'];
    $data           = array();
    $t_users        = T_USERS;
    $t_reports      = T_PROF_REPORTS;
    $sql            = cl_sqltepmlate('apps/cpanel/account_reports/sql/fetch_reports',array(
        'offset'    => $offset,
        't_users'   => $t_users,
        't_reports' => $t_reports,
        'limit'     => $limit,
        'offset_to' => $offset_to,
        'order'     => $order
    ));

$data    = array();
    $reports = $db->rawQuery($sql);

if (cl_queryset($reports)) {
        foreach ($reports as $row) {
            $row['u1_url']    = cl_link(cl_strf('@%s', $row['u1_username']));
            $row['u2_url']    = cl_link(cl_strf('@%s', $row['u2_username']));
            $row['u1_avatar'] = cl_get_media($row['u1_avatar']);
            $row['u2_avatar'] = cl_get_media($row['u2_avatar']);
            $row['time']      = date('d F, Y h:m', $row['time']);
            $data[]           = $row;
        }
    }

return $data;
}

function cl_admin_get_total_profile_reports() {
	global $db;

$qr = $db->getValue(T_PROF_REPORTS, 'COUNT(*)');

if (is_posnum($qr)) {
		return $qr;
	}

return 0;
}

function cl_admin_get_account_report_data($report_id = false) {
	global $db;

if (not_num($report_id)) {
		return array();
	}

$data         = array();
    $t_users      = T_USERS;
    $t_reps       = T_PROF_REPORTS;
    $sql          = cl_sqltepmlate('apps/cpanel/account_reports/sql/fetch_report_data',array(
        't_users' => $t_users,
        't_reps'  => $t_reps,
        'rep_id'  => $report_id,
    ));

$data   = array();
    $report = $db->rawQueryOne($sql);

if (cl_queryset($report)) {
        $report['url']     = cl_link(cl_strf('@%s', $report['username']));
        $report['avatar']  = cl_get_media($report['avatar']);
        $report['time']    = date('d M, Y h:m', $report['time']);
        $report['comment'] = cl_linkify_urls($report['comment']);
        $report['comment'] = cl_rn2br($report['comment']);
        $report['comment'] = cl_strip_brs($report['comment']);
        $data              = $report;
    
        if ($report['seen'] == '0') {
        	$db = $db->where('id', $report_id);
        	$qr = $db->update(T_PROF_REPORTS, array(
        		'seen' => '1'
        	));
        }
    }

return $data;
}

[+] ..
[+] sql
[-] app_ctrl.php [edit]