user.class.php

<?php

class userquery extends CBCategory
{
    var $userid = '';
    var $username = '';
    var $level = '';
    var $permissions = '';
    var $access_type_list = []; //Access list
    var $usr_levels = [];
    var $custom_signup_fields = [];
    var $custom_profile_fields = [];
    var $custom_profile_fields_groups = [];
    var $delete_user_functions = [];
    var $logout_functions = [];
    var $user_account = [];
    var $profileItem = '';
    var $sessions = '';
    var $is_login = false;
    var $custom_subscription_email_vars = [];

    var $dbtbl = [
        'user_permission_type'  => 'user_permission_types',
        'user_permissions'      => 'user_permissions',
        'user_level_permission' => 'user_levels_permissions',
        'user_profile'          => 'user_profile',
        'users'                 => 'users',
        'action_log'            => 'action_log',
        'subtbl'                => 'subscriptions',
        'contacts'              => 'contacts'
    ];

    var $udetails = [];

    private $basic_fields = [];
    private $extra_fields = [];

    function __construct()
    {
        global $cb_columns;

        $this->cat_tbl = 'user_categories';

        $basic_fields = [
            'userid', 'username', 'email', 'avatar', 'sex', 'avatar_url',
            'dob', 'level', 'usr_status', 'user_session_key', 'featured',
            'ban_status', 'total_photos', 'profile_hits', 'total_videos',
            'subscribers', 'total_subscriptions'
        ];

        $cb_columns->object('users')->register_columns($basic_fields);
    }

    /**
     * @throws Exception
     */
    function init()
    {
        global $sess, $Cbucket;

        $this->sess_salt = $sess->get('sess_salt');
        $this->sessions = $this->get_sessions();

        if ($this->sessions['smart_sess']) {
            $this->userid = $this->sessions['smart_sess']['session_user'];
        }

        $udetails = '';

        if ($this->userid) {
            $udetails = $this->get_user_details($this->userid, true);
            $user_profile = $this->get_user_profile($this->userid);
            if ($udetails && $user_profile) {
                $udetails['profile'] = $user_profile;
            }
        }

        if ($udetails) {
            $this->udetails = $udetails;
            $this->username = $udetails['username'];
            $this->level = $this->udetails['level'];
            $this->permission = $this->get_user_level(user_id());

            //Calling Logout Functions
            $funcs = $this->init_login_functions ?? false;
            if (is_array($funcs) && count($funcs) > 0) {
                foreach ($funcs as $func) {
                    if (function_exists($func)) {
                        $func();
                    }
                }
            }

            if ($sess->get('dummy_username') == '') {
                $this->UpdateLastActive(user_id());
            }
        } else {
            $this->permission = $this->get_user_level(4, true);
        }

        //Adding Actions such Report, share,fav etc
        $this->action = new cbactions();
        $this->action->type = 'u';
        $this->action->name = 'user';
        $this->action->obj_class = 'userquery';
        $this->action->check_func = 'user_exists';
        $this->action->type_tbl = $this->dbtbl['users'];
        $this->action->type_id_field = 'userid';

        define('AVATAR_SIZE', config('max_profile_pic_width'));
        define('AVATAR_SMALL_SIZE', 40);
        define('BG_SIZE', config('max_bg_width'));
        define('BACKGROUND_URL', config('background_url'));
        define('BACKGROUND_COLOR', config('background_color'));
        if (isSectionEnabled('channels')) {
            $Cbucket->search_types['channels'] = 'userquery';
        }
    }

    /**
     * Function used to create user session key
     */
    function create_session_key($session, $pass): string
    {
        $newkey = $session . $pass;
        $newkey = md5($newkey);
        return $newkey;
    }

    /**
     * Function used to create user session code
     * just for session authentication incase user wants to login again
     */
    function create_session_code(): int
    {
        return rand(10000, 99999);
    }

    /**
     * @return array
     */
    function get_basic_fields(): array
    {
        return $this->basic_fields;
    }

    function set_basic_fields($fields = [])
    {
        return $this->basic_fields = $fields;
    }

    function basic_fields_setup()
    {
        # Set basic video fields
        $basic_fields = [
            'userid', 'username', 'email', 'avatar', 'sex', 'avatar_url',
            'dob', 'level', 'usr_status', 'user_session_key', 'total_photos', 'profile_hits', 'total_videos', 'total_subscriptions'
        ];

        return $this->set_basic_fields($basic_fields);
    }

    function get_extra_fields(): array
    {
        return $this->extra_fields;
    }

    function set_extra_fields($fields = [])
    {
        return $this->extra_fields = $fields;
    }

    function get_user_db_fields($extra_fields = [])
    {
        $fields = $this->get_basic_fields();
        $extra = $this->get_extra_fields();

        if (empty($fields)) {
            $fields = $this->basic_fields_setup();
        }

        if (!empty($extra)) {
            $fields = array_merge($fields, $extra);
        }

        if (!empty($extra_fields)) {
            if (is_array($extra_fields)) {
                $fields = array_merge($fields, $extra_fields);
            } else {
                $fields[] = $extra_fields;
            }
        }

        # Do make array unique, otherwise we might get duplicate
        # fields
        return array_unique($fields);
    }

    function add_user_field($field)
    {
        $extra_fields = $this->get_extra_fields();

        if (is_array($field)) {
            $extra_fields = array_merge($extra_fields, $field);
        } else {
            $extra_fields[] = $field;
        }

        return $this->set_extra_fields($extra_fields);
    }

    /**
     * Neat and clean function to login user
     * this function was made for v2.x with User Level System
     * param VARCHAR $username
     * param TEXT $password
     *
     * @param      $username
     * @param      $password
     * @param bool $remember
     *
     * @return bool
     * @throws Exception
     */
    function login_user($username, $password, $remember = false): bool
    {
        global $sess, $db;

        //First we will check weather user is already logged in or not
        if ($this->login_check(null, true)) {
            $msg[] = e(lang('you_already_logged'));
        } else {
            $user = $this->get_user_id($username);
            if (!$user) {
                $msg[] = e(lang('usr_login_err'));
            } else {
                $uid = $user['userid'];
                $pass = pass_code($password, $uid);
                $udetails = $this->get_user_with_pass($username, $pass);

                // This code is used to update user password hash, may be deleted someday
                if (!$udetails) // Let's try old password method
                {
                    $oldpass = pass_code_unsecure($password);
                    $udetails = $this->get_user_with_pass($username, $oldpass);

                    if ($udetails) // This account still use old password method, let's update it
                    {
                        $db->update(tbl('users'), ['password'], [$pass], ' userid=\'' . $uid . '\'');
                    }
                }

                if (!$udetails) {
                    $msg[] = e(lang('usr_login_err'));
                } elseif (strtolower($udetails['usr_status']) != 'ok') {
                    $msg[] = e(lang('user_inactive_msg'), 'e', false);
                } elseif ($udetails['ban_status'] == 'yes') {
                    $msg[] = e(lang('usr_ban_err'));
                } else {
                    if ($remember) {
                        $sess->timeout = 86400 * REMBER_DAYS;
                    }

                    //Starting special sessions for security
                    $session_salt = RandomString(5);
                    $sess->set('sess_salt', $session_salt);
                    $sess->set('PHPSESSID', $sess->id);

                    $smart_sess = md5($udetails['user_session_key'] . $session_salt);

                    $db->delete(tbl('sessions'), ['session', 'session_string'], [$sess->id, 'guest']);
                    $sess->add_session($udetails['userid'], 'smart_sess', $smart_sess);

                    //Setting Vars
                    $this->userid = $udetails['userid'];
                    $this->username = $udetails['username'];
                    $this->level = $udetails['level'];

                    //Updating User last login , num of visits and ip
                    $db->update(tbl('users'),
                        ['num_visits', 'last_logged', 'ip'],
                        ['|f|num_visits+1', NOW(), $_SERVER['REMOTE_ADDR']],
                        'userid=\'' . $udetails['userid'] . '\''
                    );

                    $this->init();

                    //Logging Action
                    $log_array = [
                        'username'  => $username,
                        'userid'    => $udetails['userid'],
                        'useremail' => $udetails['email'],
                        'success'   => 'yes',
                        'level'     => $udetails['level']
                    ];
                    insert_log('Login', $log_array);
                    return true;
                }
            }
        }

        //Error Logging
        if (!empty($msg)) {
            //Logging Action
            $log_array['success'] = 'no';
            $log_array['details'] = $msg[0]['val'];
            $log_array['username'] = $username;
            insert_log('Login', $log_array);
        }
        return false;
    }

    /**
     * Function used to check weather user is login or not
     * it will also check weather user has access or not
     *
     * @param $access string access type it can be admin_access, upload_acess etc
     * you can either set it as level id
     * @param bool $check_only
     * @param bool $verify_logged_user
     *
     * @return bool
     * @throws Exception
     */
    function login_check($access = null, $check_only = false, $verify_logged_user = true)
    {
        global $Cbucket;

        if ($verify_logged_user) {
            //First check weather userid is here or not
            if (!user_id()) {
                if (!$check_only) {
                    e(lang('you_not_logged_in'));
                }
                return false;
            }

            //Now Check if logged in user exists or not
            if (!$this->user_exists(user_id(), true)) {
                if (!$check_only) {
                    e(lang('invalid_user'));
                }
                return false;
            }

            //Now Check logged in user is banned or not
            if ($this->is_banned(user_id()) == 'yes') {
                if (!$check_only) {
                    e(lang('usr_ban_err'));
                }
                return false;
            }
        }

        //Now user have passed all the stages, now checking if user has level access or not
        if ($access) {
            $access_details = $this->permission;

            if (is_numeric($access)) {
                if ($access_details['level_id'] == $access) {
                    return true;
                }

                if (!$check_only) {
                    e(lang('insufficient_privileges'));
                }
                $Cbucket->show_page(false);
                return false;
            }

            if ($access_details[$access] == 'yes') {
                return true;
            }

            if (!$check_only) {
                e(lang('insufficient_privileges'));
                $Cbucket->show_page(false);
            }
            return false;
        }
        return true;
    }

    /**
     * This function was used to check
     * user is logged in or not -- for v1.7.x and old
     * it has been replaced by login_check in v2
     * this function is sitll in use so
     * we are just replace the lil code of it
     *
     * @param null $access
     * @param bool $redirect
     *
     * @return bool
     * @throws Exception
     */
    function logincheck($access = null, $redirect = true): bool
    {

        if (!$this->login_check($access)) {
            if ($redirect) {
                redirect_to(cblink(['name' => 'signup'], true));
            }
            return false;
        }
        return true;
    }

    /**
     * Function used to get user details using username and password
     *
     * @param $username
     * @param $pass
     *
     * @return bool|array
     * @throws Exception
     */
    function get_user_with_pass($username, $pass)
    {
        global $db;
        $results = $db->select(tbl('users'),
            'userid,email,level,usr_status,user_session_key,user_session_code,ban_status',
            "(username='$username' OR userid='$username') AND password='$pass'");
        if (count($results) > 0) {
            return $results[0];
        }
        return false;
    }

    /**
     * @throws Exception
     */
    function get_user_id($username)
    {
        global $db;
        $results = $db->select(tbl('users'), 'userid', "(username='$username' OR userid='$username')");
        if (count($results) > 0) {
            return $results[0];
        }
        return false;
    }


    /**
     * Function used to check weather user is banned or not
     *
     * @param $uid
     *
     * @return mixed
     * @throws Exception
     */
    function is_banned($uid)
    {
        if (empty($this->udetails['ban_status']) && user_id()) {
            $this->udetails['ban_status'] = $this->get_user_field($uid, 'ban_status');
        }
        return $this->udetails['ban_status'];
    }

    /**
     * Function used to check user is admin or not
     *
     * @param $check_only bool if true, after checking user will be redirected to login page if needed
     *
     * @return bool
     * @throws Exception
     */
    function admin_login_check($check_only = false): bool
    {
        if (!has_access('admin_access', true)) {
            if (!$check_only) {
                redirect_to('login.php');
            }
            return false;
        }
        return true;
    }

    //This Function Is Used to Logout

    /**
     * @throws Exception
     */
    function logout($page = 'login.php')
    {
        global $sess;

        //Calling Logout Functions
        $funcs = $this->logout_functions;
        if (is_array($funcs) && count($funcs) > 0) {
            foreach ($funcs as $func) {
                if (function_exists($func)) {
                    $func();
                }
            }
        }

        $sess->un_set('sess_salt');
        $sess->destroy();
    }

    /**
     * Function used to delete user
     *
     * @param $uid
     *
     * @throws Exception
     */
    function delete_user($uid)
    {
        global $db;

        if ($this->user_exists($uid)) {
            $udetails = $this->get_user_details($uid);

            if (user_id() != $uid && has_access('admin_access', true) && $uid != 1) {
                //list of functions to perform while deleting a video
                $del_user_funcs = $this->delete_user_functions;
                if (is_array($del_user_funcs)) {
                    foreach ($del_user_funcs as $func) {
                        if (function_exists($func)) {
                            $func($udetails);
                        }
                    }
                }

                //Removing Subscriptions and subscribers
                $this->remove_user_subscriptions($uid);
                $this->remove_user_subscribers($uid);

                //Changing User Videos To Anonymous
                $db->execute('UPDATE ' . tbl('video') . ' SET userid=\'' . $this->get_anonymous_user() . '\' WHERE userid=\'' . $uid . '\'');
                //Changing User Group To Anonymous
                $db->execute('UPDATE ' . tbl('groups') . ' SET userid=\'' . $this->get_anonymous_user() . '\' WHERE userid=\'' . $uid . '\'');
                //Deleting User Contacts
                $this->remove_contacts($uid);

                //Deleting User PMS
                $this->remove_user_pms($uid);
                //Changing From Messages to Anonymous
                $db->execute('UPDATE ' . tbl('messages') . ' SET message_from=\'' . $this->get_anonymous_user() . '\' WHERE message_from=\'' . $uid . '\'');
                //Finally Removing Database entry of user
                $db->execute('DELETE FROM ' . tbl('users') . ' WHERE userid=\'' . $uid . '\'');
                $db->execute('DELETE FROM ' . tbl('user_profile') . ' WHERE userid=\'' . $uid . '\'');

                e(lang('usr_del_msg'), 'm');
            } else {
                e(lang('you_cant_delete_this_user'));
            }
        } else {
            e(lang('user_doesnt_exist'));
        }
    }

    /**
     * Remove all user subscriptions
     *
     * @param $uid
     * @throws Exception
     */
    function remove_user_subscriptions($uid)
    {
        global $db;
        if (!$this->user_exists($uid)) {
            e(lang('user_doesnt_exist'));
        } elseif (!has_access('admin_access')) {
            e(lang('you_dont_hv_perms'));
        } else {
            $db->execute('DELETE FROM ' . tbl($this->dbtbl['subtbl']) . ' WHERE userid=\'' . $uid . '\'');
            e(lang('user_subs_hv_been_removed'), 'm');
        }
    }

    /**
     * Remove all user subscribers
     *
     * @param $uid
     * @throws Exception
     */
    function remove_user_subscribers($uid)
    {
        global $db;
        if (!$this->user_exists($uid)) {
            e(lang('user_doesnt_exist'));
        } elseif (!has_access('admin_access')) {
            e(lang('you_dont_hv_perms'));
        } else {
            $db->execute('DELETE FROM ' . tbl($this->dbtbl['subtbl']) . ' WHERE subscribed_to=\'' . $uid . '\'');
            e(lang('user_subsers_hv_removed'), 'm');
        }
    }

    /**
     * @throws Exception
     */
    function user_exists($id, $global = false): bool
    {
        global $db;

        if (is_numeric($id)) {
            $field = 'userid';
        } else {
            $field = 'username';
        }
        $result = $db->count(tbl($this->dbtbl['users']), 'userid', $field.'=\'' . $id . '\'', '',60);

        if ($result > 0) {
            return true;
        }
        return false;
    }

    /**
     * Function used to get user details using userid
     *
     * @param null $id
     * @param bool $checksess
     * @param bool $email
     *
     * @return bool|STRING
     * @throws Exception
     */
    function get_user_details($id = null, $checksess = false, $email = false)
    {
        global $sess;

        $is_email = strpos($id, '@') !== false;
        $select_field = (!$is_email && !is_numeric($id)) ? 'username' : (!is_numeric($id) ? 'email' : 'userid');
        if (!$email) {
            $fields = table_fields(['users' => ['*']]);
        } else {
            $fields = table_fields(['users' => ['email']]);
        }

        $query = "SELECT $fields FROM " . cb_sql_table('users');
        $query .= " WHERE users.$select_field = '$id'";

        $result = select($query, 60);

        if ($result) {
            $details = $result[0];

            if (!$checksess) {
                return apply_filters($details, 'get_user');
            }

            $session = $this->sessions['smart_sess'];
            $smart_sess = md5($details['user_session_key'] . $sess->get('sess_salt'));

            if ($smart_sess == $session['session_value']) {
                $this->is_login = true;
                return apply_filters($details, 'get_user');
            }
        }

        return false;
    }

    /**
     * @throws Exception
     */
    function activate_user_with_avcode($user, $avcode)
    {
        global $eh;
        $data = $this->get_user_details($user);
        if (!$data || !$user) {
            e(lang("usr_exist_err"));
        } elseif ($data['usr_status'] == 'Ok') {
            e(lang('usr_activation_err'));
        } elseif ($data['ban_status'] == 'yes') {
            e(lang('ban_status'));
        } elseif ($data['avcode'] != $avcode) {
            e(lang('avcode_incorrect'));
        } else {
            $this->action('activate', $data['userid']);
            $eh->flush();
            e(lang("usr_activation_msg"), "m");

            if ($data['welcome_email_sent'] == 'no') {
                $this->send_welcome_email($data, true);
            }
        }
    }

    /**
     * Function used to send activation code
     * to user
     *
     * @param : $usenrma,$email or $userid
     *
     * @throws Exception
     */
    function send_activation_code($email)
    {
        global $cbemail;
        $udetails = $this->get_user_details($email);

        if (!$udetails || !$email) {
            e(lang("usr_exist_err"));
        } elseif ($udetails['usr_status'] == 'Ok') {
            e(lang('usr_activation_err'));
        } elseif ($udetails['ban_status'] == 'yes') {
            e(lang('ban_status'));
        } else {
            $tpl = $cbemail->get_template('avcode_request_template');
            $var = [
                '{username}' => $udetails['username'],
                '{email}'    => $udetails['email'],
                '{avcode}'   => $udetails['avcode']
            ];

            $subj = $cbemail->replace($tpl['email_template_subject'], $var);
            $msg = nl2br($cbemail->replace($tpl['email_template'], $var));

            //Now Finally Sending Email
            cbmail(['to' => $udetails['email'], 'from' => SUPPORT_EMAIL, 'subject' => $subj, 'content' => $msg]);
            e(lang('usr_activation_em_msg'), 'm');
        }
    }

    /**
     * Function used to send welcome email
     *
     * @param      $user
     * @param bool $update_email_status
     *
     * @throws Exception
     */
    function send_welcome_email($user, $update_email_status = false)
    {
        global $db, $cbemail;

        if (!is_array($user)) {
            $udetails = $this->get_user_details($user);
        } else {
            $udetails = $user;
        }

        if (!$udetails) {
            e(lang('usr_exist_err'));
        } else {
            $tpl = $cbemail->get_template('welcome_message_template');
            $var = [
                '{username}' => $udetails['username'],
                '{email}'    => $udetails['email']
            ];
            $subj = $cbemail->replace($tpl['email_template_subject'], $var);
            $msg = nl2br($cbemail->replace($tpl['email_template'], $var));

            //Now Finally Sending Email
            cbmail(['to' => $udetails['email'], 'from' => WELCOME_EMAIL, 'subject' => $subj, 'content' => $msg]);

            if ($update_email_status) {
                $db->update(tbl($this->dbtbl['users']), ['welcome_email_sent'], ['yes'], ' userid=\'' . $udetails['userid'] . '\' ');
            }
        }
    }

    /**
     * @throws Exception
     */
    function change_password($array)
    {
        global $db;

        $old_pass = $array['old_pass'];
        $new_pass = $array['new_pass'];
        $c_new_pass = $array['c_new_pass'];

        $uid = $array['userid'];

        if (!$this->get_user_with_pass($uid, pass_code($old_pass, $uid))) {
            e(lang('usr_pass_err'));
        } elseif (empty($new_pass)) {
            e(lang('usr_pass_err2'));
        } elseif ($new_pass != $c_new_pass) {
            e(lang('usr_cpass_err1'));
        } else {
            $db->update(tbl($this->dbtbl['users']), ['password'], [pass_code($array['new_pass'], $uid)], ' userid=\'' . $uid . '\'');
            e(lang('usr_pass_email_msg'), 'm');
        }

        return $msg;
    }

    /**
     * Function used to add contact
     *
     * @param $uid
     * @param $fid
     *
     * @throws Exception
     */
    function add_contact($uid, $fid)
    {
        global $cbemail, $db;

        $friend = $this->get_user_details($fid);
        $sender = $this->get_user_details($uid);

        if (!$friend) {
            e(lang('usr_exist_err'));
        } elseif ($this->is_requested_friend($uid, $fid)) {
            e(lang('you_already_sent_frend_request'));
        } elseif ($this->is_requested_friend($uid, $fid, 'in')) {
            $this->confirm_friend($fid, $uid);
            e(lang('friend_added'));
        } elseif ($uid == $fid) {
            e(lang('friend_add_himself_error'));
        } else {
            $db->insert(tbl($this->dbtbl['contacts']), ['userid', 'contact_userid', 'date_added', 'request_type'],
                [$uid, $fid, now(), 'out']);
            $insert_id = $db->insert_id();

            e(lang('friend_request_sent'), 'm');

            //Sending friendship request email
            $tpl = $cbemail->get_template('friend_request_email');

            $var = [
                '{reciever}'     => $friend['username'],
                '{sender}'       => $sender['username'],
                '{sender_link}'  => $this->profile_link($sender),
                '{request_link}' => '/manage_contacts.php?mode=request&confirm=' . $uid
            ];

            $subj = $cbemail->replace($tpl['email_template_subject'], $var);
            $msg = nl2br($cbemail->replace($tpl['email_template'], $var));

            //Now Finally Sending Email
            #cbmail(['to'=>$friend['email'],'from'=>WEBSITE_EMAIL,'subject'=>$subj,'content'=>$msg]);
        }

    }

    /**
     * Function used to check weather users are confirmed friends or not
     *
     * @param $uid
     * @param $fid
     *
     * @return bool
     * @throws Exception
     */
    function is_confirmed_friend($uid, $fid): bool
    {
        global $db;
        $count = $db->count(tbl($this->dbtbl['contacts']), 'contact_id',
            " (userid='$uid' AND contact_userid='$fid') OR (userid='$fid' AND contact_userid='$uid') AND confirmed='yes'");
        if ($count[0] > 0) {
            return true;
        }
        return false;
    }

    /**
     * function used to check weather users are friends or not
     *
     * @param $uid
     * @param $fid
     *
     * @return bool
     * @throws Exception
     */
    function is_friend($uid, $fid): bool
    {
        global $db;
        $count = $db->count(tbl($this->dbtbl['contacts']), 'contact_id',
            " (userid='$uid' AND contact_userid='$fid') OR (userid='$fid' AND contact_userid='$uid')");
        if ($count[0] > 0) {
            return true;
        }
        return false;
    }

    /**
     * Function used to check weather user has already requested friendship or not
     *
     * @param        $uid
     * @param        $fid
     * @param string $type
     * @param null $confirm
     *
     * @return bool
     * @throws Exception
     */
    function is_requested_friend($uid, $fid, $type = 'out', $confirm = null): bool
    {
        global $db;

        $query = '';
        if ($confirm) {
            $query = " AND confirmed='$confirm' ";
        }

        if ($type == 'out') {
            $count = $db->count(tbl($this->dbtbl['contacts']), 'contact_id', " userid='$uid' AND contact_userid='$fid' $query");
        } else {
            $count = $db->count(tbl($this->dbtbl['contacts']), 'contact_id', " userid='$fid' AND contact_userid='$uid' $query");
        }

        if ($count[0] > 0) {
            return true;
        }
        return false;
    }

    /**
     * Function used to confirm friend
     *
     * @param      $uid
     * @param      $rid
     * @param bool $msg
     *
     * @throws Exception
     */
    function confirm_friend($uid, $rid, $msg = true)
    {
        global $cbemail, $db;
        if (!$this->is_requested_friend($rid, $uid, 'out', 'no')) {
            if ($msg) {
                e(lang('friend_confirm_error'));
            }
        } else {
            addFeed(['action' => 'add_friend', 'object_id' => $rid, 'object' => 'friend', 'uid' => $uid]);
            addFeed(['action' => 'add_friend', 'object_id' => $uid, 'object' => 'friend', 'uid' => $rid]);

            $db->insert(tbl($this->dbtbl['contacts']), ['userid', 'contact_userid', 'date_added', 'request_type', 'confirmed'],
                [$uid, $rid, now(), 'in', 'yes']);
            $db->update(tbl($this->dbtbl['contacts']), ['confirmed'], ['yes'], ' userid=\'' . $rid . '\' AND contact_userid=\'' . $uid . '\' ');
            if ($msg) {
                e(lang('friend_confirmed'), 'm');
            }
            //Sending friendship confirmation email
            $tpl = $cbemail->get_template('friend_confirmation_email');

            $friend = $this->get_user_details($rid);
            $sender = $this->get_user_details($uid);

            $more_var = [
                '{reciever}'    => $friend['username'],
                '{sender}'      => $sender['username'],
                '{sender_link}' => $this->profile_link($sender)
            ];
            if (!isset($var)) {
                $var = [];
            }
            $var = array_merge($more_var, $var);
            $subj = $cbemail->replace($tpl['email_template_subject'], $var);
            $msg = nl2br($cbemail->replace($tpl['email_template'], $var));

            //Now Finally Sending Email
            cbmail(['to' => $friend['email'], 'from' => WEBSITE_EMAIL, 'subject' => $subj, 'content' => $msg]);

            //Logging Friendship

            $log_array = [
                'success'       => 'yes',
                'action_obj_id' => $friend['userid'],
                'details'       => 'friend with ' . $friend['username']
            ];

            insert_log('add_friend', $log_array);

            $log_array = [
                'success'       => 'yes',
                'username'      => $friend['username'],
                'userid'        => $friend['userid'],
                'userlevel'     => $friend['level'],
                'useremail'     => $friend['email'],
                'action_obj_id' => $insert_id,
                'details'       => 'friend with ' . user_id()
            ];

            //Login Upload
            insert_log('add_friend', $log_array);
        }
    }

    /**
     * Function used to confirm request
     *
     * @param      $rid
     * @param null $uid
     *
     * @throws Exception
     */
    function confirm_request($rid, $uid = null)
    {
        global $db;

        if (!$uid) {
            $uid = user_id();
        }

        $result = $db->select(tbl($this->dbtbl['contacts']), '*', " userid='$rid' AND contact_userid='$uid' ");

        if (count($result) == 0) {
            e(lang("friend_request_not_found"));
        } elseif ($uid != $result[0]['contact_userid']) {
            e(lang("you_cant_confirm_this_request"));
        } elseif ($result[0]['confirmed'] == 'yes') {
            e(lang("friend_request_already_confirmed"));
        } else {
            $this->confirm_friend($uid, $result[0]['userid']);
        }
    }

    /**
     * Function used to get user contacts
     *
     * @param      $uid
     * @param int $group
     * @param null $confirmed
     * @param bool $count_only
     * @param null $type
     *
     * @return array|bool
     * @throws Exception
     */
    function get_contacts($uid, $group = 0, $confirmed = null, $count_only = false, $type = null)
    {
        global $db;

        $query = '';
        if ($confirmed) {
            $query .= ' AND ' . tbl('contacts') . ".confirmed='$confirmed' ";
        }

        if ($type) {
            $query .= ' AND ' . tbl('contacts') . ".request_type='$type' ";
        }

        if (!$count_only) {
            $result = $db->select(tbl('contacts,users'),
                tbl('contacts.contact_userid,contacts.confirmed,contacts.request_type ,users.*'),
                tbl('contacts.userid') . "='$uid' AND " . tbl('users.userid') . '=' . tbl('contacts.contact_userid') . $query . '
             AND ' . tbl('contacts') . ".contact_group_id='$group' ");

            if (count($result) > 0) {
                return $result;
            }
            return false;
        }

        return $db->count(tbl('contacts'),
            tbl('contacts.contact_userid'),
            tbl('contacts.userid') . "='$uid'
        $query AND " . tbl('contacts') . ".contact_group_id='$group' ");
    }

    /**
     * Function used to get pending contacts
     *
     * @param      $uid
     * @param int $group
     * @param bool $count_only
     *
     * @return array|bool
     * @throws Exception
     */
    function get_pending_contacts($uid, $group = 0, $count_only = false)
    {
        global $db;

        if (!$count_only) {
            $result = $db->select(tbl('contacts,users'),
                tbl('contacts.userid,contacts.confirmed,contacts.request_type ,users.*'),
                tbl('contacts.contact_userid') . "='$uid' AND " . tbl('users.userid') . '=' . tbl('contacts.userid') . "
            AND " . tbl('contacts.confirmed') . "='no' AND " . tbl('contacts') . ".contact_group_id='$group' ");
            if (count($result) > 0) {
                return $result;
            }
            return false;
        }

        $count = $db->count(tbl('contacts'),
            tbl('contacts.contact_userid'),
            tbl('contacts.contact_userid') . "='$uid' AND " . tbl('contacts.confirmed') . "='no' AND " . tbl('contacts') . ".contact_group_id='$group' ");
        return $count;
    }

    /**
     * Function used to remove user from contact list
     * @param $fid {id of friend that user wants to remove}
     * @param $uid {id of user who is removing other from friendlist}
     * @throws Exception
     */
    function remove_contact($fid, $uid = null)
    {
        global $db;
        if (!$uid) {
            $uid = user_id();
        }

        if (!$this->is_friend($fid, $uid)) {
            e(lang('user_no_in_contact_list'));
        } else {
            $db->execute('DELETE FROM ' . tbl($this->dbtbl['contacts']) . " WHERE
                        (userid='$uid' AND contact_userid='$fid') OR (userid='$fid' AND contact_userid='$uid')");
            e(lang('user_removed_from_contact_list'), 'm');
        }
    }

    /**
     * Function used to increas user total_watched field
     *
     * @param $userid
     * @throws Exception
     */
    function increment_watched_vides($userid)
    {
        global $db;
        $db->update(tbl($this->dbtbl['users']), ['total_watched'], ['|f|total_watched+1'], ' userid=\'' . $userid . '\'');
    }

    /**
     * Function used to subscribe user
     *
     * @param      $to
     * @param null $user
     * @throws Exception
     */
    function subscribe_user($to, $user = null)
    {
        if (!$user) {
            $user = user_id();
        }
        global $db;

        $to_user = $this->get_user_details($to);

        if (!$this->user_exists($to)) {
            e(lang('usr_exist_err'));
        } elseif (!$user) {
            e(sprintf(lang('please_login_subscribe'), $to_user['username']));
        } elseif ($this->is_subscribed($to, $user)) {
            e(sprintf(lang('usr_sub_err'), '<strong>' . $to_user['username'] . '</strong>'));
        } elseif ($to_user['userid'] == $user) {
            e(lang('you_cant_sub_yourself'));
        } else {
            $db->insert(tbl($this->dbtbl['subtbl']), ['userid', 'subscribed_to', 'date_added'],
                [$user, $to, NOW()]);
            $db->update(tbl($this->dbtbl['users']), ['subscribers'],
                [$this->get_user_subscribers($to, true)], " userid='$to' ");
            $db->update(tbl($this->dbtbl['users']), ['total_subscriptions'],
                [$this->get_user_subscriptions($user, 'count')], " userid='$user' ");
            //Logging Comment
            $log_array = [
                'success'        => 'yes',
                'details'        => 'subsribed to ' . $to_user['username'],
                'action_obj_id'  => $to_user['userid'],
                'action_done_id' => $db->insert_id()
            ];
            insert_log('subscribe', $log_array);

            e(sprintf(lang('usr_sub_msg'), $to_user['username']), 'm');
        }
    }

    /**
     * Function used to check weather user is already subscribed or not
     *
     * @param      $to
     * @param null $user
     *
     * @return array|bool
     * @throws Exception
     */
    function is_subscribed($to, $user = null)
    {
        if (!$user) {
            $user = user_id();
        }
        global $db;

        if (!$user) {
            return false;
        }

        $result = $db->select(tbl($this->dbtbl['subtbl']), '*', " subscribed_to='$to' AND userid='$user'");
        if (count($result) > 0) {
            return $result;
        }
        return false;
    }

    /**
     * Function used to remove user subscription
     *
     * @param      $subid
     * @param null $uid
     *
     * @return bool
     * @throws Exception
     */
    function remove_subscription($subid, $uid = null): bool
    {
        global $db;
        if (!$uid) {
            $uid = user_id();
        }

        if ($this->is_subscribed($subid, $uid)) {
            $db->execute('DELETE FROM ' . tbl($this->dbtbl['subtbl']) . " WHERE userid='$uid' AND subscribed_to='$subid'");
            e(lang('class_unsub_msg'), 'm');

            $db->update(tbl($this->dbtbl['users']), ['subscribers'],
                [$this->get_user_subscribers($subid, true)], " userid='$subid' ");
            $db->update(tbl($this->dbtbl['users']), ['total_subscriptions'],
                [$this->get_user_subscriptions($uid, 'count')], " userid='$uid' ");
            return true;
        }

        e(lang('you_not_subscribed'));
        return false;
    }

    /**
     * @throws Exception
     */
    function unsubscribe_user($subid, $uid = null)
    {
        return $this->remove_subscription($subid, $uid);
    }

    /**
     * Function used to get user subscribers
     *
     * @param $id
     * @param bool $count
     *
     * @return array|bool
     * @throws Exception
     */
    function get_user_subscribers($id, $count = false)
    {
        global $db;
        if (!$count) {
            $result = $db->select(tbl('subscriptions'), '*',
                " subscribed_to='$id' ");
            if (count($result) > 0) {
                return $result;
            }
            return false;
        }
        return $db->count(tbl($this->dbtbl['subtbl']), 'subscription_id', " subscribed_to='$id' ");
    }

    /**
     * function used to get user subscribers with details
     *
     * @param      $id
     * @param null $limit
     *
     * @return array|bool
     * @throws Exception
     */
    function get_user_subscribers_detail($id, $limit = null)
    {
        global $db;
        $result = $db->select(tbl('users,' . $this->dbtbl['subtbl']), '*', ' ' . tbl('subscriptions.subscribed_to') . " = '$id' AND " . tbl('subscriptions.userid') . '=' . tbl('users.userid'), $limit);
        if (count($result) > 0) {
            return $result;
        }
        return false;
    }

    /**
     * Function used to get user subscriptions
     *
     * @param      $id
     * @param null $limit
     *
     * @return array|bool
     * @throws Exception
     */
    function get_user_subscriptions($id, $limit = null)
    {
        global $db;
        if ($limit != 'count') {
            $result = $db->select(tbl('users,' . $this->dbtbl['subtbl']), '*', ' ' . tbl('subscriptions.userid') . " = '$id' AND " . tbl('subscriptions.subscribed_to') . '=' . tbl('users.userid'), $limit);

            if (count($result) > 0) {
                return $result;
            }
            return false;
        }

        return $db->count(tbl($this->dbtbl['subtbl']), 'subscription_id', " userid = '$id'");
    }

    /**
     * Function used to reset user password
     * it has two steps
     * 1 to send confirmation
     * 2 to reset the password
     *
     * @param      $step
     * @param      $input
     * @param null $code
     *
     * @return bool
     * @throws \PHPMailer\PHPMailer\Exception
     */

    function reset_password($step, $input, $code = null)
    {
        global $cbemail, $db;
        switch ($step) {
            case 1:
                $udetails = $this->get_user_details($input);
                if (!$udetails) {
                    e(lang('usr_exist_err'));
                } elseif (!verify_captcha()) {
                    e(lang('recap_verify_failed'));
                } else {
                    //Sending confirmation email
                    $tpl = $cbemail->get_template('password_reset_request');
                    $avcode = $udetails['avcode'];
                    if (!$udetails['avcode']) {
                        $avcode = RandomString(10);
                        $db->update(tbl($this->dbtbl['users']), ['avcode'], [$avcode], " userid='" . $udetails['userid'] . "'");
                    }

                    $more_var = [
                        '{username}' => $udetails['username'],
                        '{email}'    => $udetails['email'],
                        '{avcode}'   => $avcode,
                        '{userid}'   => $udetails['userid']
                    ];
                    if (!is_array($var)) {
                        $var = [];
                    }
                    $var = array_merge($more_var, $var);
                    $subj = $cbemail->replace($tpl['email_template_subject'], $var);
                    $msg = nl2br($cbemail->replace($tpl['email_template'], $var));

                    //Now Finally Sending Email
                    cbmail(['to' => $udetails['email'], 'from' => WEBSITE_EMAIL, 'subject' => $subj, 'content' => $msg]);

                    e(lang('usr_rpass_email_msg'), 'm');
                    return true;
                }
                break;

            case 2:
                $udetails = $this->get_user_details($input);
                if (!$udetails) {
                    e(lang('usr_exist_err'));
                } elseif ($udetails['avcode'] != $code) {
                    e(lang('recap_verify_failed'));
                } else {
                    $newpass = RandomString(6);
                    $pass = pass_code($newpass, $udetails['userid']);
                    $avcode = RandomString(10);
                    $db->update(tbl($this->dbtbl['users']), ['password', 'avcode'], [$pass, $avcode], " userid='" . $udetails['userid'] . "'");
                    //sending new password email...
                    //Sending confirmation email
                    $tpl = $cbemail->get_template('password_reset_details');
                    $more_var = [
                        '{username}' => $udetails['username'],
                        '{email}'    => $udetails['email'],
                        '{avcode}'   => $udetails['avcode'],
                        '{userid}'   => $udetails['userid'],
                        '{password}' => $newpass
                    ];
                    if (!is_array($var)) {
                        $var = [];
                    }
                    $var = array_merge($more_var, $var);
                    $subj = $cbemail->replace($tpl['email_template_subject'], $var);
                    $msg = nl2br($cbemail->replace($tpl['email_template'], $var));

                    //Now Finally Sending Email
                    cbmail(['to' => $udetails['email'], 'from' => WEBSITE_EMAIL, 'subject' => $subj, 'content' => $msg]);
                    e(lang('usr_pass_email_msg'), 'm');
                    return true;
                }
                break;
        }
    }

    /**
     * Function used to recover username
     */
    function recover_username($email): string
    {
        global $cbemail;
        $udetails = $this->get_user_details($email);
        if (!$udetails) {
            e(lang('no_user_associated_with_email'));
        } elseif (!verify_captcha()) {
            e(lang('recap_verify_failed'));
        } else {
            $tpl = $cbemail->get_template('forgot_username_request');
            $more_var = [
                '{username}' => $udetails['username']
            ];
            if (!is_array($var)) {
                $var = [];
            }
            $var = array_merge($more_var, $var);
            $subj = $cbemail->replace($tpl['email_template_subject'], $var);
            $msg = nl2br($cbemail->replace($tpl['email_template'], $var));

            //Now Finally Sending Email
            cbmail(['to' => $udetails['email'], 'from' => SUPPORT_EMAIL, 'subject' => $subj, 'content' => $msg]);
            e(lang("usr_uname_email_msg"), 'm');
        }
        return $msg;
    }

    //FUNCTION USED TO UPDATE LAST ACTIVE FOR OF USER
    // @ Param : username
    /**
     * @throws Exception
     */
    function UpdateLastActive($username)
    {
        global $db;

        $sql = 'UPDATE ' . tbl("users") . " SET last_active = '" . NOW() . "' WHERE username='" . $username . "' OR userid='" . $username . "' ";
        $db->execute($sql);
    }

    /**
     * FUNCTION USED TO GE USER THUMBNAIL
     *
     * @param array $udetails
     * @param string $size
     * @param null $uid
     *
     * @return string
     * @throws Exception
     */
    function getUserThumb($udetails, $size = '', $uid = null): string
    {
        if (empty($udetails['userid']) && $uid) {
            $udetails = $this->get_user_details($uid);
        }

        $avatar = $avatar_path = '';
        if (!empty($udetails)) {
            $avatar = $udetails['avatar'];
            $avatar_path = AVATARS_DIR . DIRECTORY_SEPARATOR . $avatar;
        }
        if (!empty($avatar) && file_exists($avatar_path)) {
            return AVATARS_URL . DIRECTORY_SEPARATOR . $avatar;
        }

        if (!empty($udetails['avatar_url'])) {
            return display_clean($udetails['avatar_url']);
        }

        $thesize = AVATAR_SIZE;
        $default = $this->get_default_thumb();
        if ($size == 'small') {
            $thesize = AVATAR_SMALL_SIZE;
            $default = $this->get_default_thumb('small');
        }

        if (config('gravatars') == 'yes' && (!empty($udetails['email']) || !empty($udetails['anonym_email']))) {
            $email = $udetails['email'] ? $udetails['email'] : $udetails['anonym_email'];
            $gravatar = new Gravatar($email, BASEURL . $default);
            $gravatar->size = $thesize;
            $gravatar->rating = 'G';
            $gravatar->border = 'FF0000';

            return $gravatar->getSrc();
        }

        return $default;
    }

    function avatar($udetails, $size = '', $uid = null): string
    {
        return $this->getUserThumb($udetails, $size, $uid);
    }

    /**
     * Function used to get default user thumb
     *
     * @param null $size
     *
     * @return string
     */
    function get_default_thumb($size = null): string
    {
        if ($size == 'small' && file_exists(TEMPLATEDIR . '/images/avatars/no_avatar-small.png')) {
            return '/images/avatars/no_avatar-small.png';
        }

        if (file_exists(TEMPLATEDIR . '/images/avatars/no_avatar.png') && !$size) {
            return '/images/avatars/no_avatar.png';
        }

        if ($size == 'small') {
            return '/images/avatars/no_avatar-small.png';
        }
        return '/images/avatars/no_avatar.png';
    }

    /**
     * Function used to get user Background
     *
     * @param : bg file
     * @param bool $check
     *
     * @return bool|string
     */
    function getUserBg($udetails, $check = false)
    {
        $file = $udetails['background'];
        $bgfile = USER_BG_DIR . DIRECTORY_SEPARATOR . $file;

        if (file_exists($bgfile) && $file) {
            return USER_BG_URL . '/' . $file;
        }

        if (!empty($udetails['background_url']) && BACKGROUND_URL == 'yes') {
            return $udetails['background_url'];
        }

        if (!empty($udetails['background_color']) && BACKGROUND_COLOR == 'yes' && $check) {
            return true;
        }

        return false;
    }

    /**
     * Function used to get user field
     * @ param INT userid
     * @ param FIELD name
     *
     * @param $uid
     * @param $field
     *
     * @return bool|array
     * @throws Exception
     */
    function get_user_field($uid, $field)
    {
        global $db;

        if (is_numeric($uid)) {
            $results = $db->select(tbl('users'), $field, "userid='$uid'");
        } else {
            $results = $db->select(tbl('users'), $field, "username='$uid'");
        }

        if (count($results) > 0) {
            return $results[0];
        }
        return false;
    }

    function get_user_fields($uid, $field)
    {
        return $this->get_user_field($uid, $field);
    }

    /**
     * This function will return
     * user field without array
     */
    function get_user_field_only($uid, $field)
    {
        $fields = $this->get_user_field($uid, $field);
        return $fields[$field];
    }

    /**
     * Function used to get user level and its details
     *
     * @param INT userid
     * @param bool $is_level
     *
     * @return bool|mixed
     * @throws Exception
     */
    function get_user_level($uid, $is_level = false)
    {
        global $db;

        if ($is_level) {
            $level = $uid;
        } else {
            $level = $this->udetails['level'] ?? false;
        }

        if ($level == user_id() or $level == $this->udetails['level']) {
            if (isset($this->permission)) {
                return $this->permission;
            }
        }

        $result = $db->select(tbl('user_levels,user_levels_permissions'), '*',
            tbl('user_levels_permissions.user_level_id') . "='" . $level . "'
                              AND " . tbl('user_levels_permissions.user_level_id') . ' = ' . tbl('user_levels.user_level_id'), false, false, false, 600);

        //Now Merging the two arrays
        return $result[0] ?? false;
    }

    /**
     * Function used to get all levels
     *
     * @param : filter
     *
     * @return array|bool
     * @throws Exception
     */
    function get_levels($filter = null)
    {
        global $db;
        $results = $db->select(tbl('user_levels'), '*', null, null, ' user_level_id ASC');

        if (count($results) > 0) {
            return $results;
        }
        return false;
    }

    /**
     * Function used to get level details
     *
     * @param : level_id INT
     *
     * @return bool|int
     * @throws Exception
     */
    function get_level_details($lid)
    {
        global $db;
        $results = $db->select(tbl('user_levels'), '*', " user_level_id='$lid' ");
        if (count($results) > 0) {
            return $results[0];
        }

        e(lang('cant_find_level'));
        return false;
    }

    /**
     * Function used to get users of particular level
     *
     * @param : level_id
     * @param bool $count
     * @param string $fields
     *
     * @return array|int
     * @throws Exception
     */
    function get_level_users($id, $count = false, $fields = 'level')
    {
        global $db;
        if ($fields == 'all') {
            $fields = '*';
        }

        $results = $db->select(tbl('users'), $fields, " level='$id'");
        if (count($results) > 0) {
            if ($count) {
                return count($results);
            }
            return $results;
        }

        return 0;
    }

    /**
     * Function used to add user level
     * @throws Exception
     */
    function add_user_level($array)
    {
        global $db;
        if (!is_array($array)) {
            $array = $_POST;
        }
        $level_name = mysql_clean($array['level_name']);
        if (empty($level_name)) {
            e(lang('please_enter_level_name'));
        } else {
            $db->insert(tbl('user_levels'), ['user_level_name'], [$level_name]);
            $iid = $db->insert_id();

            $fields_array[] = 'user_level_id';
            $value_array[] = $iid;
            foreach ($this->get_access_type_list() as $access => $name) {
                $fields_array[] = $access;
                $value_array[] = $array[$access] ? $array[$access] : 'no';
            }
            $db->insert(tbl('user_levels_permissions'), $fields_array, $value_array);
            return true;
        }
    }

    /**
     * Function usewd to get level permissions
     *
     * @param $id
     *
     * @return bool|array
     * @throws Exception
     */
    function get_level_permissions($id)
    {
        global $db;
        $results = $db->select(tbl('user_levels_permissions'), '*', " user_level_id = '$id'");
        if (count($results) > 0) {
            return $results[0];
        }
        return false;
    }

    /**
     * Function used to get custom permissions
     */
    function get_access_type_list(): array
    {
        if (!$this->access_type_list) {
            $perms = $this->get_permissions();
            foreach ($perms as $perm) {
                $this->add_access_type($perm['permission_code'], $perm['permission_name']);
            }
        }
        return $this->access_type_list;
    }

    /**
     * Function used to add new custom permission
     */
    function add_access_type($access, $name)
    {
        if (!empty($access) && !empty($name)) {
            $this->access_type_list[$access] = $name;
        }
    }

    /**
     * Function used to update user level
     * @param INT level_id
     * @param ARRAY perm_level
     * @throws Exception
     */
    function update_user_level($id, $array): bool
    {
        global $db;
        if (!is_array($array)) {
            $array = $_POST;
        }

        //First Checking Level
        $level = $this->get_level_details($id);

        if ($level) {
            foreach ($this->get_access_type_list() as $access => $name) {
                $fields_array[] = $access;
                $value_array[] = $array[$access];
            }

            //Checking level Name
            if (!empty($array['level_name'])) {
                $level_name = mysql_clean($array['level_name']);
                //Updating Now
                $db->update(tbl('user_levels'), ['user_level_name'], [$level_name], " user_level_id = '$id'");
            }

            if (isset($_POST['plugin_perm'])) {
                $fields_array[] = 'plugins_perms';
                $value_array[] = '|no_mc|' . json_encode($_POST['plugin_perm']);
            }

            //Updating Permissions
            $db->update(tbl('user_levels_permissions'), $fields_array, $value_array, " user_level_id = '$id'");

            e(lang('level_updated'), 'm');
            return true;
        }

        return false;
    }

    /**
     * Function used to delete user levels
     * @param INT level_id
     * @throws Exception
     */
    function delete_user_level($id): bool
    {
        global $db;
        $level_details = $this->get_level_details($id);
        $de_level = $this->get_level_details(3);
        if ($level_details) {
            //CHeck if leve is deleteable or not
            if ($level_details['user_level_is_default'] == 'no') {
                $db->delete(tbl('user_levels'), ['user_level_id'], [$id]);
                $db->delete(tbl('user_levels_permissions'), ['user_level_id'], [$id]);
                e(sprintf(lang('level_del_sucess'), $de_level['user_level_name']));

                $db->update(tbl('users'), ['level'], [3], " level='$id'");
                return true;
            }

            e(lang("level_not_deleteable"));
            return false;
        }
    }

    /**
     * Function used to count total video comments
     * @throws Exception
     */
    function count_profile_comments($id)
    {
        global $db;
        return $db->count(tbl('comments'), 'comment_id', "type='c' AND type_id='$id' AND parent_id='0'");
    }

    /**
     * Function used to update user comments count
     * @throws Exception
     */
    function update_comments_count($id)
    {
        global $db;
        $total_comments = $this->count_profile_comments($id);
        $db->update(tbl('users'), ['comments_count', 'last_commented'], [$total_comments, now()], " userid='$id'");
    }

    /**
     * Function used to add comment on users profile
     * @throws Exception
     */
    function add_comment($comment, $obj_id, $reply_to = null, $type = 'c')
    {
        global $myquery;
        if (!$this->user_exists($obj_id)) {
            e(lang('usr_exist_err'));
        } else {
            $add_comment = $myquery->add_comment($comment, $obj_id, $reply_to, $type, $obj_id);
        }

        if ($add_comment) {
            //Logging Comment
            $log_array = [
                'success'        => 'yes',
                'details'        => 'comment on a profile',
                'action_obj_id'  => $obj_id,
                'action_done_id' => $add_comment
            ];
            insert_log('profile_comment', $log_array);

            //Updating Number of comments of user if comment is not a reply
            if ($reply_to < 1) {
                $this->update_comments_count($obj_id);
            }
        }
        return $add_comment;
    }

    /**
     * Function used to remove video comment
     * @throws Exception
     */
    function delete_comment($cid, $is_reply = false)
    {
        global $myquery;
        $remove_comment = $myquery->delete_comment($cid, 'c', $is_reply);
        if ($remove_comment) {
            //Updating Number of comments of video
            $this->update_comments_count($obj_id);
        }
        return $remove_comment;
    }

    /**
     * Function used to get number of videos uploaded by user
     *
     * @param      $uid
     * @param null $cond
     * @param bool $count_only
     * @param bool $myacc
     *
     * @return array|bool|int
     * @throws Exception
     */
    function get_user_vids($uid, $cond = null, $count_only = false, $myacc = false)
    {
        global $db;
        if ($cond != null) {
            $cond = " AND $cond ";
        }

        $limit = '';
        $order = '';
        if ($myacc) {
            $limit = ' 0,15 ';
            $order = ' videoid DESC';
        }

        $results = $db->select(tbl('video'), '*', " userid = '$uid' $cond", "$limit", "$order");
        if (count($results) > 0) {
            if ($myacc) {
                return $results;
            }

            if ($count_only) {
                return count($results);
            }
            return $results[0];
        }
        return false;
    }

    /**
     * Function used to get logged in username
     */
    function get_logged_username()
    {
        return $this->get_user_field_only(user_id(), 'username');
    }

    /**
     * FUnction used to get username from userid
     */
    function get_username($uid)
    {
        return $this->get_user_field_only($uid, 'username');
    }

    /**
     * Function used to create profile link
     *
     * @param $udetails
     *
     * @return string
     * @throws Exception
     */
    function profile_link($udetails): string
    {
        if (!is_array($udetails) && is_numeric($udetails)) {
            $udetails = $this->get_user_details($udetails);
        }

        $username = display_clean($udetails['username']);
        if (SEO != 'yes') {
            return '/view_channel.php?user=' . $username;
        }

        return '/user/' . $username;
    }

    /**
     * Function used to get permission types
     */
    function get_level_types(): array
    {
        global $db;
        return $db->select(tbl($this->dbtbl['user_permission_type']), '*');
    }
    /**
     * Function used to get permissions
     *
     * @param null $type
     *
     * @return array|bool
     * @throws Exception
     */
    function get_permissions($type = null)
    {
        global $db;
        $cond = '';
        if ($type) {
            $cond = " permission_type ='$type'";
        }
        $result = $db->select(tbl($this->dbtbl['user_permissions']), '*', $cond);
        if (count($result) > 0) {
            return $result;
        }

        return false;
    }

    /**
     * Function used to check weather current user has permission
     * to view page or not
     * it will also check weather current page requires login
     * if login is required, user will be redirected to signup page
     *
     * @param string $access
     * @param bool $check_login
     * @param bool $control_page
     *
     * @param bool $silent
     *
     * @return bool
     * @throws Exception
     */
    function perm_check($access = '', $check_login = false, $control_page = true, $silent = false): bool
    {
        global $Cbucket;
        $access_details = $this->permission;
        if (is_numeric($access)) {
            if ($access_details['level_id'] == $access) {
                return true;
            }

            if (!$check_only && !$silent) {
                e(lang('insufficient_privileges'));
            }

            if ($control_page) {
                $Cbucket->show_page(false);
            }
            return false;
        }

        if ($access_details[$access] == 'yes') {
            return true;
        }

        if (!$silent) {
            if (!$check_login || user_id()) {
                e(lang('insufficient_privileges'));
            } else {
                e(sprintf(lang('insufficient_privileges_loggin'), cblink(['name' => 'signup']), cblink(['name' => 'signup'])));
            }
        }

        if ($control_page) {
            $Cbucket->show_page(false);
        }
        return false;
    }

    /**
     * Function used to get user profile details
     *
     * @param $uid
     *
     * @return bool|array
     * @throws Exception
     */
    function get_user_profile($uid)
    {
        global $db;
        $select = '';
        $join = '';
        $group = '';
        $version = get_current_version();
        if ($version['version'] > '5.5.0' || ($version['version'] == '5.5.0' && $version['revision'] >= 264)) {
            $select = ', GROUP_CONCAT(T.name SEPARATOR \',\') as profile_tags';
            $join = ' LEFT JOIN ' . tbl('user_tags') . ' UT ON UP.userid = UT.id_user
                    LEFT JOIN ' . tbl('tags') . ' T ON T.id_tag = UT.id_tag';
            $group = ' GROUP BY UP.userid';
        }
        $query = 'SELECT UP.* ' . $select . '
                    FROM ' . tbl($this->dbtbl['user_profile']) . ' UP
                   ' . $join . '
                    WHERE UP.userid = ' . mysql_clean($uid) . '
                   ' . $group;
        $result = $db->_select($query, 60);

        if (count($result) > 0) {
            return $result[0];
        }
        return false;
    }

    /**
     * User Profile Fields
     *
     * @param $default
     *
     * @return array
     * @throws Exception
     */
    function load_profile_fields($default): array
    {
        if (!$default) {
            $default = $_POST;
        }

        $profile_fields = $this->load_personal_details($default);
        $other_details = $this->load_location_fields($default);
        $more_details = $this->load_education_interests($default);
        $channel = $this->load_channel_settings($default);
        $privacy_field = $this->load_privacy_field($default);
        return array_merge($profile_fields, $other_details, $more_details, $channel, $privacy_field);
    }

    /**
     * Function used to update use details
     *
     * @param $array
     * @throws Exception
     */
    function update_user($array)
    {
        global $db, $Upload;
        if (is_null($array)) {
            $array = $_POST;
        }

        if (is_array($_FILES)) {
            $array = array_merge($array, $_FILES);
        }

        $userfields = $this->load_profile_fields($array);
        $custom_signup_fields = $this->load_custom_signup_fields($array);

        //Adding Custom Form Fields
        if (count($this->custom_profile_fields) > 0) {
            $userfields = array_merge($userfields, $this->custom_profile_fields);
        }

        //Adding custom fields from group
        if (count($this->custom_profile_fields_groups) > 0) {
            $custom_fields_from_group_fields = [];
            $custom_fields_from_group = $this->custom_profile_fields_groups;
            foreach ($custom_fields_from_group as $cffg) {
                $custom_fields_from_group_fields = array_merge($custom_fields_from_group_fields, $cffg['fields']);
            }

            $userfields = array_merge($userfields, $custom_fields_from_group_fields);
        }

        validate_cb_form($custom_signup_fields, $array);
        validate_cb_form($userfields, $array);

        foreach ($userfields as $field) {
            $name = formObj::rmBrackets($field['name']);
            $val = $array[$name];

            if ($field['use_func_val']) {
                $val = $field['validate_function']($val);
            }

            if (!empty($field['db_field'])) {
                $query_field[] = $field['db_field'];
            }

            if (is_array($val)) {
                $new_val = '';
                foreach ($val as $v) {
                    $new_val .= '#' . $v . '# ';
                }
                $val = $new_val;
            }
            if ($field['clean_func'] && (function_exists($field['clean_func']) || is_array($field['clean_func']))) {
                $val = apply_func($field['clean_func'], $val);
            }

            if (!empty($field['db_field'])) {
                $query_val[] = $val;
            }
        }

        //Category
        if ($cat_field) {
            $field = $cat_field;
            $name = formObj::rmBrackets($field['name']);
            $val = $array[$name];

            if ($field['use_func_val']) {
                $val = $field['validate_function']($val);
            }

            if (!empty($field['db_field'])) {
                $uquery_field[] = $field['db_field'];
            }

            if (is_array($val)) {
                $new_val = '';
                foreach ($val as $v) {
                    $new_val .= '#' . $v . '# ';
                }
                $val = $new_val;
            }
            if ($field['clean_func'] && (function_exists($field['clean_func']) || is_array($field['clean_func']))) {
                $val = apply_func($field['clean_func'], $val);
            }

            if (!empty($field['db_field'])) {
                $uquery_val[] = $val;
            }
        }

        //updating user detail
        if (has_access('admin_access', true) && isset($array['admin_manager'])) {
            //Checking Username
            if (empty($array['username'])) {
                e(lang('usr_uname_err'));
            } elseif (!username_check($array['username'])) {
                e(lang('usr_uname_err3'));
            } else {
                $username = $array['username'];
            }

            //Checking Email
            if (empty($array['email'])) {
                e(lang('usr_email_err1'));
            } elseif (!is_valid_syntax('email', $array['email'])) {
                e(lang('usr_email_err2'));
            } elseif (email_exists($array['email']) && $array['email'] != $array['demail']) {
                e(lang('usr_email_err3'));
            } else {
                $email = $array['email'];
            }

            $uquery_field[] = 'username';
            $uquery_val[] = $username;

            $uquery_field[] = 'email';
            $uquery_val[] = $email;

            //Changning Password
            if (!empty($array['pass'])) {
                if ($array['pass'] != $array['cpass']) {
                    e(lang('pass_mismatched'));
                } else {
                    $pass = pass_code($array['pass'], $array['userid']);
                }
                $uquery_field[] = 'password';
                $uquery_val[] = $pass;
            }

            //Changing User Level
            $uquery_field[] = 'level';
            $uquery_val[] = $array['level'];

            //Checking for user stats
            $uquery_field[] = 'profile_hits';
            $uquery_val[] = $array['profile_hits'];
            $uquery_field[] = 'total_watched';
            $uquery_val[] = $array['total_watched'];
            $uquery_field[] = 'total_videos';
            $uquery_val[] = $array['total_videos'];
            $uquery_field[] = 'total_comments';
            $uquery_val[] = $array['total_comments'];
            $uquery_field[] = 'subscribers';
            $uquery_val[] = $array['subscribers'];
            $uquery_field[] = 'comments_count';
            $uquery_val[] = $array['comments_count'];
            $query_field[] = 'rating';

            $rating = $array['rating'];
            if ($rating < 1 || $rating > 10) {
                $rating = 1;
            }
            $query_val[] = $rating;
            $query_field[] = 'rated_by';
            $query_val[] = $array['rated_by'];

            //Changing Joined Date
            if (isset($array['doj'])) {
                $uquery_field[] = 'doj';
                $uquery_val[] = $array['doj'];
            }
        }

        //Changing Gender
        if ($array['sex']) {
            $uquery_field[] = 'sex';
            $uquery_val[] = $array['sex'];
        }

        //Changing Country
        if ($array['country']) {
            $uquery_field[] = 'country';
            $uquery_val[] = $array['country'];
        }

        //Changing Date of birth
        if (isset($array['dob']) && $array['dob'] != '0000-00-00') {
            $uquery_field[] = 'dob';

            // Converting date from custom format to MySQL
            $dob_datetime = DateTime::createFromFormat(DATE_FORMAT, $array['dob']);
            if ($dob_datetime) {
                $uquery_val[] = $dob_datetime->format('Y-m-d');
            } else {
                $uquery_val[] = $array['dob'];
            }
        }

        //Changing category
        if (isset($array['category'])) {
            $uquery_field[] = 'category';
            $uquery_val[] = $array['category'];
        }

        //Updating User Avatar
        if ($array['avatar_url']) {
            $uquery_field[] = 'avatar_url';
            $uquery_val[] = $array['avatar_url'];
        }

        if ($array['remove_avatar_url'] == 'yes') {
            $uquery_field[] = 'avatar_url';
            $uquery_val[] = '';
        }

        //Deleting User Avatar
        if ($array['delete_avatar'] == 'yes') {
            $udetails = $this->get_user_details($array['userid']);

            $file = AVATARS_DIR . '/' . $udetails['avatar'];
            if (file_exists($file) && $udetails['avatar'] != '') {
                unlink($file);
            }

            $uquery_field[] = 'avatar';
            $uquery_val[] = '';
        } else {
            if (isset($_FILES['avatar_file']['name']) && !empty($_FILES['avatar_file']['name'])) {
                $file = $Upload->upload_user_file('a', $_FILES['avatar_file'], $array['userid']);
                if ($file) {
                    $uquery_field[] = 'avatar';
                    $uquery_val[] = $file;
                }
            }
        }

        //Deleting User Bg
        if ($array['delete_bg'] == 'yes') {
            $file = USER_BG_DIR . DIRECTORY_SEPARATOR . $array['bg_file_name'];
            if (file_exists($file) && $array['bg_file_name']) {
                unlink($file);
            }
        }

        //Updating User Background
        if ($array['background_url']) {
            $uquery_field[] = 'background_url';
            $uquery_val[] = $array['background_url'];
        }

        if ($array['background_color']) {
            $uquery_field[] = 'background_color';
            $uquery_val[] = $array['background_color'];
        }

        if ($array['background_repeat']) {
            $uquery_field[] = 'background_repeat';
            $uquery_val[] = $array['background_repeat'];
        }

        if (isset($_FILES['background_file']['name']) && !empty($_FILES['background_file']['name'])) {
            $file = $Upload->upload_user_file('b', $_FILES['background_file'], $array['userid']);
            if ($file) {
                $uquery_field[] = 'background';
                $uquery_val[] = $file;
            }
        }

        //Adding Custom Field
        if (is_array($custom_signup_fields)) {
            foreach ($custom_signup_fields as $field) {
                $name = formObj::rmBrackets($field['name']);
                $val = $array[$name];

                if ($field['use_func_val']) {
                    $val = $field['validate_function']($val);
                }

                if (!empty($field['db_field'])) {
                    $uquery_field[] = $field['db_field'];
                }

                if (is_array($val)) {
                    $new_val = '';
                    foreach ($val as $v) {
                        $new_val .= '#' . $v . '# ';
                    }
                    $val = $new_val;
                }
                if ($field['clean_func'] && (function_exists($field['clean_func']) || is_array($field['clean_func']))) {
                    $val = apply_func($field['clean_func'], $val);
                }

                if (!empty($field['db_field'])) {
                    $uquery_val[] = $val;
                }
            }
        }

        if (!error() && is_array($uquery_field)) {
            $db->update(tbl($this->dbtbl['users']), $uquery_field, $uquery_val, " userid='" . mysql_clean($array['userid']) . "'");
            e(lang('usr_upd_succ_msg'), 'm');
        }

        //updating user profile
        if (!error()) {
            $log_array = [
                'success' => 'yes',
                'details' => 'updated profile'
            ];
            //Login Upload
            insert_log('profile_update', $log_array);

            $db->update(tbl($this->dbtbl['user_profile']), $query_field, $query_val, " userid='" . mysql_clean($array['userid']) . "'");

            Tags::saveTags($array['profile_tags'], 'profile', $array['userid']);
            e(lang('usr_pof_upd_msg'), 'm');
        }
    }

    /**
     * Function used to update user avatar and background only
     *
     * @param $array
     * @throws Exception
     */
    function update_user_avatar_bg($array)
    {
        global $db, $Upload;

        //Deleting User Avatar
        if ($array['delete_avatar'] == 'yes') {
            $udetails = $this->get_user_details(user_id());

            $file = AVATARS_DIR . DIRECTORY_SEPARATOR . $udetails['avatar_url'];
            if (file_exists($file) && $udetails['avatar_url'] != '') {
                unlink($file);
            }

            $uquery_field[] = 'avatar';
            $uquery_val[] = '';

            $uquery_field[] = 'avatar_url';
            $uquery_val[] = '';
        } else {
            if (config('picture_url') == 'yes') {
                //Updating User Avatar
                $uquery_field[] = 'avatar_url';
                $uquery_val[] = $array['avatar_url'];
            }

            if (isset($_FILES['avatar_file']['name'])) {
                $file = $Upload->upload_user_file('a', $_FILES['avatar_file'], user_id());
                if ($file) {
                    $uquery_field[] = 'avatar';
                    $uquery_val[] = $file;
                }
            }
        }

        //Deleting User Bg
        if ($array['delete_bg'] == 'yes') {
            $file = USER_BG_DIR . DIRECTORY_SEPARATOR . $array['bg_file_name'];
            if (file_exists($file) && $array['bg_file_name'] != '') {
                unlink($file);
            }
        }

        if (config('background_url') == 'yes') {
            //Updating User Background
            $uquery_field[] = 'background_url';
            $uquery_val[] = $array['background_url'];
        }

        $uquery_field[] = 'background_color';
        $uquery_val[] = $array['background_color'];

        if ($array['background_repeat']) {
            $uquery_field[] = 'background_repeat';
            $uquery_val[] = $array['background_repeat'];
        }

        if (isset($_FILES['background_file']['name'])) {
            $file = $Upload->upload_user_file('b', $_FILES['background_file'], user_id());
            if ($file) {
                $uquery_field[] = 'background';
                $uquery_val[] = $file;
            }
        }

        $log_array = [
            'success' => 'yes',
            'details' => 'updated profile'
        ];

        //Login Upload
        insert_log('profile_update', $log_array);

        $db->update(tbl($this->dbtbl['users']), $uquery_field, $uquery_val, ' userid=\'' . user_id() . '\'');
        e(lang('usr_avatar_bg_update'), 'm');
    }

    public function updateBackground($file = []): array
    {
        if (empty($file)) {
            return [
                'status' => false,
                'msg'    => 'no data was sent'
            ];
        }

        if ($file['size'] / 1024 > config('max_bg_size')) {
            return [
                'status' => false,
                'msg'    => sprintf(lang('file_size_exceeds'), config('max_bg_size'))
            ];
        }

        $av_details = getimagesize($file['tmp_name']);
        if ($av_details[0] > config('max_bg_width')) {
            return [
                'status' => false,
                'msg'    => lang('File width exeeds') . ' ' . config('max_bg_width') . 'px'
            ];
        }

        if (!file_exists($file['tmp_name'])) {
            return [
                'status' => false,
                'msg'    => lang('class_error_occured')
            ];
        }

        $ext = getext($file['name']);
        $file_name = $file['userid'] . '.' . $ext;
        $file_path = USER_BG_DIR . DIRECTORY_SEPARATOR . $file_name;
        if (move_uploaded_file($file['tmp_name'], $file_path)) {
            $imgObj = new ResizeImage();
            if (!$imgObj->ValidateImage($file_path, $ext)) {
                @unlink($file_path);
                return [
                    'status' => false,
                    'msg'    => 'Invalid file type'
                ];
            }
            return [
                'status' => true,
                'msg'    => 'Succesfully Uploaded'
            ];
        }
        return [
            'status' => false,
            'msg'    => lang('class_error_occured')
        ];
    }

    public function getBackground($userId = false)
    {
        if (!$userId) {
            $userId = user_id();
        }

        global $userquery;
        return $userquery->getUserBg($userquery->get_user_details($userId));
    }

    public function getImageExt($imageName = false)
    {
        if ($imageName) {
            $nameParts = explode('.', $imageName);
            return array_pop($nameParts);
        }
    }

    /**
     * Function used to check weather username exists or not
     *
     * @param $i
     *
     * @return bool
     * @throws Exception
     */
    function username_exists($i)
    {
        global $db;
        return $db->count(tbl($this->dbtbl['users']), 'username', " username='$i'");
    }

    /**
     * function used to check weather email exists or not
     *
     * @param $i
     *
     * @return bool
     * @throws Exception
     */
    function email_exists($i): bool
    {
        global $db;
        $result = $db->select(tbl($this->dbtbl['users']), 'email', " email='$i'");
        if (count($result) > 0) {
            return true;
        }
        return false;
    }

    public function check_email_domain($email): bool
    {
        $email_domain_restriction = config('email_domain_restriction');
        if ($email_domain_restriction != '') {
            $list_domains = explode(',', $email_domain_restriction);
            foreach ($list_domains as $domain) {
                if (strpos($email, '@' . $domain) !== false) {
                    return true;
                }
            }
            return false;
        }
        return true;
    }

    /**
     * Function used to get user access log
     *
     * @param      $uid
     * @param null $limit
     *
     * @return array|bool
     * @throws Exception
     */
    function get_user_action_log($uid, $limit = null)
    {
        global $db;
        $result = $db->select(tbl($this->dbtbl['action_log']), '*', " action_userid='$uid'", $limit, ' date_added DESC');
        if (count($result) > 0) {
            return $result;
        }
        return false;
    }

    /**
     * Load Custom Profile Field
     *
     * @param      $data
     * @param bool $group_based
     *
     * @return array
     */
    function load_custom_profile_fields($data, $group_based = false): array
    {
        if (!$group_based) {
            $new_array = [];
            $array = $this->custom_profile_fields;
            foreach ($array as $key => $fields) {
                if ($data[$fields['db_field']]) {
                    $value = $data[$fields['db_field']];
                } else {
                    if ($data[$fields['name']]) {
                        $value = $data[$fields['name']];
                    }
                }

                if ($fields['type'] == 'radiobutton' ||
                    $fields['type'] == 'checkbox' ||
                    $fields['type'] == 'dropdown') {
                    $fields['checked'] = $value;
                } else {
                    $fields['value'] = $value;
                }

                $new_array[$key] = $fields;
            }
            return $new_array;
        }

        $groups = $this->custom_profile_fields_groups;

        $new_grp = [];
        if ($groups) {
            foreach ($groups as $grp) {
                $fields = [];
                foreach ($grp['fields'] as $key => $fields) {
                    if ($data[$fields['db_field']]) {
                        $value = $data[$fields['db_field']];
                    } elseif ($data[$fields['name']]) {
                        $value = $data[$fields['name']];
                    }

                    if ($fields['type'] == 'radiobutton' ||
                        $fields['type'] == 'checkbox' ||
                        $fields['type'] == 'dropdown') {
                        $fields['checked'] = $value;
                    } else {
                        $fields['value'] = $value;
                    }
                }
                $grp['fields'][$key] = $fields;
                $new_grp[] = $grp;
            }
        }
        return $new_grp;
    }

    /**
     * Load Custom Signup Field
     *
     * @param      $data
     * @param bool $ck_display_admin
     * @param bool $ck_display_user
     *
     * @return mixed
     */
    function load_custom_signup_fields($data, $ck_display_admin = false, $ck_display_user = false)
    {
        $array = $this->custom_signup_fields;
        foreach ($array as $key => $fields) {
            $ok = 'yes';
            if ($ck_display_admin) {
                if ($fields['display_admin'] == 'no_display') {
                    $ok = 'no';
                }
            }

            if ($ck_display_user) {
                if ($fields['display_user'] == 'no_display') {
                    $ok = 'no';
                }
            }

            if ($ok == 'yes') {
                if (!$fields['value']) {
                    $fields['value'] = $data[$fields['db_field']];
                }
                $new_array[$key] = $fields;
            }
        }

        return $new_array;
    }

    /**
     * Function used to get user videos link
     */
    function get_user_videos_link($u)
    {
        return cblink(['name' => 'user_videos']) . $u['username'];
    }

    /*
    * Get number of all unread messages of a user using his userid
    */
    /**
     * @throws Exception
     */
    function get_unread_msgs($userid, $label = false)
    {
        global $db;
        $userid = '#' . $userid . '#';
        $results = $db->select(tbl('messages'), '*', "message_to='$userid' AND message_status='unread'");
        $count = count($results);

        if ($label) {
            echo '<span class="label label-default">' . $count . '</span></h3>';
        }

        return $count;
    }

    /**
     * My Account links Edited on 12 march 2014 for user account links
     */
    function my_account_links()
    {
        $array[lang('account')] = [
            lang('my_account')        => 'myaccount.php',
            lang('block_users')       => 'edit_account.php?mode=block_users',
            lang('user_change_pass')  => 'edit_account.php?mode=change_password',
            lang('user_change_email') => 'edit_account.php?mode=change_email',
            lang('com_manage_subs')   => 'edit_account.php?mode=subscriptions',
            lang('account_settings')  => 'edit_account.php?mode=account'
        ];

        $udetails = $this->get_user_details(user_id());
        if (config('picture_upload') == 'yes' || config('picture_url') == 'yes' || !empty($udetails['avatar_url']) || !empty($udetails['avatar'])) {
            $array[lang('account')][lang('change_avatar')] = 'edit_account.php?mode=avatar_bg';
        }

        if (isSectionEnabled('channels')) {
            $array[lang('user_channel_profiles')] = [
                lang('user_profile_settings') => 'edit_account.php?mode=profile',
                lang('contacts_manager')      => 'manage_contacts.php'
            ];
        }

        if (isSectionEnabled('videos')) {
            $array[lang('videos')] = [
                lang('uploaded_videos') => 'manage_videos.php',
                lang('user_fav_videos') => 'manage_videos.php?mode=favorites',
            ];
        }

        if (isSectionEnabled('playlists')) {
            $array[lang('playlists')] = [
                lang('manage_playlists') => 'manage_playlists.php',
            ];
        }

        $array[lang('messages')] = [
            lang('inbox') . '(' . $this->get_unread_msgs($this->userid) . ')' => 'private_message.php?mode=inbox',
            lang('notifications')                                             => 'private_message.php?mode=notification',
            lang('sent')                                                      => 'private_message.php?mode=sent',
            lang('title_crt_new_msg')                                         => cblink(['name' => 'compose_new']),
        ];

        if (count($this->user_account) > 0) {
            foreach ($this->user_account as $key => $acc) {
                if (array_key_exists($key, $array)) {
                    foreach ($acc as $title => $link)
                        $array[$key][$title] = $link;
                } else {
                    $array[$key] = $acc;
                }
            }
        }
        return $array;
    }


    /**
     * Function used to change email
     *
     * @param $array
     * @throws Exception
     */
    function change_email($array)
    {
        global $db;
        //function used to change user email
        if (!isValidEmail($array['new_email']) || $array['new_email'] == '') {
            e(lang("usr_email_err2"));
        } elseif ($array['new_email'] != $array['cnew_email']) {
            e(lang('user_email_confirm_email_err'));
        } elseif (!$this->user_exists($array['userid'])) {
            e(lang('usr_exist_err'));
        } elseif ($this->email_exists($array['new_email'])) {
            e(lang('usr_email_err3'));
        } else {
            $db->update(tbl($this->dbtbl['users']), ['email'], [$array['new_email']], " userid='" . $array['userid'] . "'");
            e(lang('email_change_msg'), 'm');
        }
    }

    /**
     * Function used to ban users
     *
     * @param      $users
     * @param null $uid
     *
     * @return void
     * @throws Exception
     */
    function block_users($users, $uid = null)
    {
        $this->ban_users($users, $uid);
    }

    /**
     * @throws Exception
     */
    function ban_users($users, $uid = null)
    {
        global $db;
        if (!$uid) {
            $uid = user_id();
        }
        $users_array = explode(',', $users);
        $new_users = [];
        foreach ($users_array as $user) {
            if ($user != user_name() && !is_numeric($user) && $this->user_exists($user)) {
                $new_users[] = $user;
            }
        }
        if (count($new_users) > 0) {
            $new_users = array_unique($new_users);
            $banned_users = implode(',', $new_users);
            $db->update(tbl($this->dbtbl['users']), ['banned_users'], [$banned_users], " userid='$uid'");
            e(lang('user_ban_msg'), 'm');
        } else {
            if (!$users) {
                $db->update(tbl($this->dbtbl['users']), ['banned_users'], [$users], " userid='$uid'");
                e(lang('no_user_ban_msg'), 'm');
            }
        }
    }

    /**
     * Function used to ban single user
     *
     * @param $user
     * @throws Exception
     */
    function ban_user($user)
    {
        global $db;
        $uid = user_id();

        if (!$uid) {
            e(lang('you_not_logged_in'));
        } else {
            if ($user != user_name() && !is_numeric($user) && $this->user_exists($user)) {
                $banned_users = $this->udetails['banned_users'];
                if ($banned_users) {
                    $banned_users .= ",$user";
                } else {
                    $banned_users = "$user";
                }

                if (!$this->is_user_banned($user)) {
                    $db->update(tbl($this->dbtbl['users']), ['banned_users'], [$banned_users], " userid='$uid'");
                    e(lang('user_blocked'), 'm');
                } else {
                    e(lang('user_already_blocked'));
                }
            } else {
                e(lang('you_cant_del_user'));
            }
        }
    }

    /**
     * Function used to check weather user is banned or not
     *
     * @param      $ban
     * @param null $user
     * @param null $banned_users
     *
     * @return bool
     * @throws Exception
     */
    function is_user_banned($ban, $user = null, $banned_users = null): bool
    {
        global $db;
        if (!$user) {
            $user = user_id();
        }

        if (!$banned_users) {
            if (is_numeric($user)) {
                $result = $db->select(tbl($this->dbtbl['users']), 'banned_users', " userid='$user' ");
            } else {
                $result = $db->select(tbl($this->dbtbl['users']), 'banned_users', " username='$user' ");
            }
            $banned_users = $result[0]['banned_users'];
        }

        $ban_user = explode(',', $banned_users);
        if (in_array($ban, $ban_user)) {
            return true;
        }
        return false;
    }

    /**
     * function used to get user details with profile
     *
     * @param null $uid
     *
     * @return array
     * @throws Exception
     */
    function get_user_details_with_profile($uid = null): array
    {
        global $db;
        if (!$uid) {
            $uid = user_id();
        }
        $result = $db->select(tbl($this->dbtbl['users'] . ',' . $this->dbtbl['user_profile']), '*', tbl($this->dbtbl['users']) . ".userid ='$uid' AND " . tbl($this->dbtbl['users']) . '.userid = ' . tbl($this->dbtbl['user_profile']) . '.userid');
        return $result[0];
    }

    /**
     * @throws \PHPMailer\PHPMailer\Exception
     * @throws Exception
     */
    function load_signup_fields($input = null): array
    {
        global $Cbucket;

        $default = [];

        if (isset($input)) {
            $default = $input;
        }
        /**
         * this function will create initial array for user fields
         * this will tell
         * array(
         *       title [text that will represents the field]
         *       type [type of field, either radio button, textfield or text area]
         *       name [name of the fields, input NAME attribute]
         *       id [id of the fields, input ID attribute]
         *       value [value of the fields, input VALUE attribute]
         *       size
         *       class
         *       label
         *       extra_params
         *       hint_1 [hint before field]
         *       hint_2 [hint after field]
         *       anchor_before [anchor before field]
         *       anchor_after [anchor after field]
         *      )
         */

        if (empty($default)) {
            $default = $_POST;
        }

        if (empty($default)) {
            $default = $_POST;
        }

        $username = $default['username'] ?? '';
        $email = $default['email'] ?? '';
        $dob = $default['dob'] ?? '';

        if ($dob != '' && $dob != '0000-00-00') {
            $dob_datetime = DateTime::createFromFormat('Y-m-d', $dob);
            if ($dob_datetime) {
                $dob = $dob_datetime->format(DATE_FORMAT);
            }
        }

        $user_signup_fields = [
            'username'  => [
                'title'               => lang('username'),
                'type'                => 'textfield',
                'placehoder'          => lang('username'),
                'name'                => 'username',
                'id'                  => 'username',
                'value'               => $username,
                'hint_2'              => lang('user_allowed_format'),
                'db_field'            => 'username',
                'required'            => 'yes',
                'validate_function'   => 'username_check',
                'function_error_msg'  => lang('user_contains_disallow_err'),
                'db_value_check_func' => 'user_exists',
                'db_value_exists'     => false,
                'db_value_err'        => lang('usr_uname_err2'),
                'min_length'          => config('min_username'),
                'max_length'          => config('max_username')
            ],
            'email'     => [
                'title'               => lang('email'),
                'type'                => 'textfield',
                'placehoder'          => 'Email',
                'name'                => 'email',
                'id'                  => 'email',
                'value'               => $email,
                'db_field'            => 'email',
                'required'            => 'yes',
                'syntax_type'         => 'email',
                'db_value_check_func' => 'email_exists',
                'db_value_exists'     => false,
                'db_value_err'        => lang('usr_email_err3'),
                'validate_function'   => 'isValidEmail',
                'constraint_func'     => 'check_email_domain',
                'constraint_err'      => lang('signup_error_email_unauthorized')
            ],
            'password'  => [
                'title'         => lang('password'),
                'type'          => 'password',
                'placehoder'    => lang('password'),
                'name'          => 'password',
                'id'            => 'password',
                'required'      => 'yes',
                'invalid_err'   => lang('usr_pass_err2'),
                'relative_to'   => 'cpassword',
                'relative_type' => 'exact',
                'relative_err'  => lang('usr_pass_err3'),
            ],
            'cpassword' => [
                'title'       => lang('user_confirm_pass'),
                'type'        => 'password',
                'placehoder'  => lang('user_confirm_pass'),
                'name'        => 'cpassword',
                'id'          => 'cpassword',
                'required'    => 'no',
                'invalid_err' => lang('usr_cpass_err')
            ],
            'dob'       => [
                'title'             => lang('user_date_of_birth'),
                'type'              => 'textfield',
                'name'              => 'dob',
                'readonly'          => 'true',
                'id'                => 'dob',
                'anchor_after'      => 'date_picker',
                'value'             => $dob,
                'validate_function' => 'verify_age',
                'db_field'          => 'dob',
                'required'          => 'yes',
                'placehoder'        => lang('user_date_of_birth'),
                'invalid_err'       => sprintf(lang('register_min_age_request'), config('min_age_reg'))
            ]
        ];

        if( config('enable_country') == 'yes' ){
            $countries = $Cbucket->get_countries();
            $selected_cont = null;
            $pick_geo_country = config('pick_geo_country');
            if ($pick_geo_country == 'yes') {
                $user_ip = $_SERVER['REMOTE_ADDR']; // getting user's ip
                $user_country = ip_info($user_ip, 'country'); // get country using IP
                foreach ($countries as $code => $name) {
                    $name = strtolower($name);
                    $user_country = strtolower($user_country);
                    if ($name == $user_country) {
                        $selected_cont = $code;
                        break;
                    }
                }
            } else {
                $selected_cont = config('default_country_iso2');
            }

            if (strlen($selected_cont) != 2) {
                $selected_cont = 'PK';
            }

            $user_signup_fields['country'] = [
                'title'    => lang('country'),
                'type'     => 'dropdown',
                'value'    => $countries,
                'id'       => 'country',
                'name'     => 'country',
                'checked'  => $selected_cont,
                'db_field' => 'country',
                'required' => 'yes'
            ];
        }

        if( config('enable_gender') == 'yes' ) {
            $user_signup_fields['gender'] = [
                'title'    => lang('gender'),
                'type'     => 'radiobutton',
                'name'     => 'gender',
                'class'    => 'radio',
                'id'       => 'gender',
                'value'    => ['Male' => lang('male'), 'Female' => lang('female')],
                'sep'      => '&nbsp;',
                'checked'  => 'Male',
                'db_field' => 'sex',
                'required' => 'yes'
            ];
        }

        if( config('enable_user_category') == 'yes' ) {
            $user_signup_fields['cat'] = [
                'title'            => lang('category'),
                'type'             => 'dropdown',
                'name'             => 'category',
                'id'               => 'category',
                'value'            => ['category', ($default['category'] ?? '')],
                'db_field'         => 'category',
                'checked'          => ($default['category'] ?? ''),
                'required'         => 'yes',
                'invalid_err'      => lang('select_category'),
                'display_function' => 'convert_to_categories',
                'category_type'    => 'user'
            ];
        }

        $new_array = [];
        foreach ($user_signup_fields as $id => $fields) {
            $the_array = $fields;
            if (isset($the_array['hint_1'])) {
                $the_array['hint_before'] = $the_array['hint_1'];
            }

            if (isset($the_array['hint_2'])) {
                $the_array['hint_after'] = $the_array['hint_2'];
            }

            $new_array[$id] = $the_array;
        }

        $new_array[] = $this->load_custom_profile_fields($default, false);

        return $new_array;
    }

    /**
     * Function used to validate Signup Form
     *
     * @param null $array
     * @throws \PHPMailer\PHPMailer\Exception
     */
    function validate_form_fields($array = null)
    {
        $fields = $this->load_signup_fields($array);

        if ($array == null) {
            $array = $_POST;
        }

        if (is_array($_FILES)) {
            $array = array_merge($array, $_FILES);
        }

        //Merging Array
        $signup_fields = array_merge($fields, $this->custom_signup_fields);

        validate_cb_form($signup_fields, $array);
    }

    /**
     * Function used to validate signup form
     *
     * @param null $array
     * @param bool $send_signup_email
     *
     * @return bool|mixed
     * @throws Exception
     */
    function signup_user($array = null, $send_signup_email = true)
    {
        global $db, $userquery;

        $isSocial = false;
        if (isset($array['social_account_id'])) {
            $isSocial = true;
        }
        if ($array == null) {
            $array = $_POST;
        }

        if (is_array($_FILES)) {
            $array = array_merge($array, $_FILES);
        }
        $this->validate_form_fields($array);
        //checking terms and policy agreement
        if ($array['agree'] != 'yes' && !has_access('admin_access', true)) {
            e(lang('usr_ament_err'));
        }

        // first checking if captcha plugin is enabled
        // do not trust the form cb_captcha_enabled value
        if (get_captcha() && !$userquery->admin_login_check(true) && !$isSocial) {
            // now checking if the user posted captcha value is not empty and cb_captcha_enabled == yes
            if (!isset($array['cb_captcha_enabled']) || $array['cb_captcha_enabled'] == 'no') {
                e(lang('recap_verify_failed'));
            }
            if (!verify_captcha()) {
                e(lang('recap_verify_failed'));
            }
        }
        if (!error()) {
            $signup_fields = $this->load_signup_fields($array);

            //Adding Custom Signup Fields
            if (count($this->custom_signup_fields) > 0) {
                $signup_fields = array_merge($signup_fields, $this->custom_signup_fields);
            }

            foreach ($signup_fields as $field) {
                $name = formObj::rmBrackets($field['name']);
                $val = $array[$name];

                if ($name == 'dob') {
                    $dob_datetime = DateTime::createFromFormat(DATE_FORMAT, $val);
                    if ($dob_datetime) {
                        $val = $dob_datetime->format('Y-m-d');
                    }
                }

                if ($field['use_func_val']) {
                    $val = $field['validate_function']($val);
                }

                if (!empty($field['db_field'])) {
                    $query_field[] = $field['db_field'];
                }

                if (is_array($val)) {
                    $new_val = '';
                    foreach ($val as $v) {
                        $new_val .= '#' . $v . '# ';
                    }
                    $val = $new_val;
                }
                if (!$field['clean_func'] || (!function_exists($field['clean_func']) && !is_array($field['clean_func']))) {
                    $val = mysql_clean($val);
                } else {
                    $val = apply_func($field['clean_func'], mysql_clean('|no_mc|' . $val));
                }

                if (!empty($field['db_field'])) {
                    $query_val[] = $val;
                }
            }

            // Setting Verification type
            if (EMAIL_VERIFICATION == '1') {
                $usr_status = 'ToActivate';
                $welcome_email = 'no';
            } else {
                $usr_status = 'Ok';
                $welcome_email = 'yes';
            }

            if (has_access('admin_access', true)) {
                if ($array['active'] == 'Ok') {
                    $usr_status = 'Ok';
                    $welcome_email = 'yes';
                } else {
                    $usr_status = 'ToActivate';
                    $welcome_email = 'no';
                }

                $query_field[] = 'level';
                $query_val[] = $array['level'];
            }
            global $Upload;
            $custom_fields_array = $Upload->load_custom_form_fields(false, false, false, true);
            foreach ($custom_fields_array as $cfield) {
                $db_field = $cfield['db_field'];
                $query_field[] = $db_field;
                $query_val[] = $array[$db_field];
            }

            $query_field[] = 'usr_status';
            $query_val[] = $usr_status;

            $query_field[] = 'welcome_email_sent';
            $query_val[] = $welcome_email;

            //Creating AV Code
            $avcode = RandomString(10);
            $query_field[] = 'avcode';
            $query_val[] = $avcode;

            //Signup IP
            $signup_ip = $_SERVER['REMOTE_ADDR'];
            $query_field[] = 'signup_ip';
            $query_val[] = $signup_ip;

            //Date Joined
            $now = NOW();
            $query_field[] = 'doj';
            $query_val[] = $now;

            // Featured video
            $query_field[] = 'featured_video';
            $query_val[] = '';

            /**
             * A VERY IMPORTANT PART OF
             * OUR SIGNUP SYSTEM IS
             * SESSION KEY AND CODE
             * WHEN A USER IS LOGGED IN
             * IT IS ONLY VALIDATED BY
             * ITS SIGNUP KEY AND CODE
             */
            $sess_key = $this->create_session_key($_COOKIE['PHPSESSID'], $array['password']);
            $sess_code = $this->create_session_code();

            $query_field[] = 'user_session_key';
            $query_val[] = $sess_key;

            $query_field[] = 'user_session_code';
            $query_val[] = $sess_code;

            $query = 'INSERT INTO ' . tbl('users') . ' (';
            $total_fields = count($query_field);

            //Adding Fields to query
            $i = 0;
            foreach ($query_field as $qfield) {
                $i++;
                $query .= $qfield;
                if ($i < $total_fields) {
                    $query .= ',';
                }
            }

            $query .= ') VALUES (';

            $i = 0;
            //Adding Fields Values to query
            foreach ($query_val as $qval) {
                $i++;
                $query .= '\'' . $qval . '\'';
                if ($i < $total_fields) {
                    $query .= ',';
                }
            }

            //Finalizing Query
            $query .= ')';
            $db->execute($query);
            $insert_id = $db->insert_id();

            $db->update(tbl($this->dbtbl['users']), ['password'], [pass_code($array['password'], $insert_id)], ' userid=\'' . $insert_id . '\'');

            $fields_list = [];
            $fields_data = [];

            $fields_list[] = 'userid';
            $fields_data[] = $insert_id;

            // Specify default values for user_profile fields without one
            $fields_list[] = 'profile_title';
            $fields_data[] = '';
            $fields_list[] = 'profile_desc';
            $fields_data[] = '';
            $fields_list[] = 'featured_video';
            $fields_data[] = '';
            $fields_list[] = 'about_me';
            $fields_data[] = '';
            $fields_list[] = 'schools';
            $fields_data[] = '';
            $fields_list[] = 'occupation';
            $fields_data[] = '';
            $fields_list[] = 'companies';
            $fields_data[] = '';
            $fields_list[] = 'hobbies';
            $fields_data[] = '';
            $fields_list[] = 'fav_movies';
            $fields_data[] = '';
            $fields_list[] = 'fav_music';
            $fields_data[] = '';
            $fields_list[] = 'fav_books';
            $fields_data[] = '';
            $fields_list[] = 'background';
            $fields_data[] = '';
            $fields_list[] = 'voters';
            $fields_data[] = '';

            $db->insert(tbl($userquery->dbtbl['user_profile']), $fields_list, $fields_data);

            if (!has_access('admin_access', true) && EMAIL_VERIFICATION && $send_signup_email) {
                global $cbemail;
                $tpl = $cbemail->get_template('email_verify_template');
                $more_var = [
                    '{username}' => post('username'),
                    '{password}' => post('password'),
                    '{email}'    => post('email'),
                    '{avcode}'   => $avcode
                ];

                $var = [];
                $var = array_merge($more_var, $var);
                $subj = $cbemail->replace($tpl['email_template_subject'], $var);
                $msg = nl2br($cbemail->replace($tpl['email_template'], $var));

                //Now Finally Sending Email
                cbmail(['to' => post('email'), 'from' => WEBSITE_EMAIL, 'subject' => $subj, 'content' => $msg]);
            } elseif (!has_access('admin_access', true) && $send_signup_email) {
                $this->send_welcome_email($insert_id);
            }

            $log_array = [
                'username'  => $array['username'],
                'userid'    => $insert_id,
                'userlevel' => $array['level'],
                'useremail' => $array['email'],
                'success'   => 'yes',
                'details'   => sprintf('%s signed up', $array['username'])
            ];

            //Login Signup
            insert_log('signup', $log_array);

            //Adding User has Signup Feed
            addFeed(['action' => 'signup', 'object_id' => $insert_id, 'object' => 'signup', 'uid' => $insert_id]);

            return $insert_id;
        }
        return false;
    }

    function duplicate_email($name): bool
    {
        $myquery = new myquery();
        if ($myquery->check_email($name)) {
            return true;
        }
        return false;
    }

    /**
     * Function used to get users
     *
     * @param null $params
     * @param bool $force_admin
     *
     * @return array|bool|int|void
     * @throws Exception
     */
    function get_users($params = null, $force_admin = false)
    {
        global $db;

        $limit = $params['limit'];
        $order = $params['order'];

        $cond = '';
        if (!has_access('admin_access', true) && !$force_admin) {
            $cond .= " users.usr_status='Ok' AND users.ban_status ='no' ";
        } else {
            if (!empty($params['ban'])) {
                $cond .= " users.ban_status ='" . $params['ban'] . "'";
            }

            if (!empty($params['status'])) {
                if ($cond != '') {
                    $cond .= ' AND';
                }
                $cond .= " users.usr_status='" . $params['status'] . "'";
            }
        }

        //Setting Category Condition
        if (!empty($params['category']) && !is_array($params['category'])) {
            $is_all = strtolower($params['category']);
        }

        if (isset($params['category']) && $params['category'] != '' && $is_all != lang('all')) {
            if ($cond != '') {
                $cond .= ' AND';
            }

            $cond .= ' (';

            if (!empty($params['category']) && !is_array($params['category'])) {
                $cats = explode(',', $params['category']);
            } else {
                $cats = $params['category'];
            }

            $count = 0;
            foreach ($cats as $cat_params) {
                $count++;
                if ($count > 1) {
                    $cond .= ' OR ';
                }
                $cond .= " users.category LIKE '%$cat_params%' ";
            }

            $cond .= ')';
        }

        //date span
        if (!empty($params['date_span'])) {
            if ($cond != '') {
                $cond .= ' AND';
            }
            $cond .= ' ' . cbsearch::date_margin('users.doj', $params['date_span']);
        }

        //FEATURED
        if (!empty($params['featured'])) {
            if ($cond != '') {
                $cond .= ' AND';
            }
            $cond .= " users.featured = '" . $params['featured'] . "' ";
        }

        if (!empty($params['search_username'])) {
            if ($cond != '') {
                $cond .= ' AND ';
            }
            $cond .= " users.username LIKE '%" . $params['search_username'] . "%'";
        }

        //Username
        if (isset($params['username']) && $params['username'] != '') {
            if ($cond != '') {
                $cond .= ' AND';
            }
            $cond .= " users.username = '" . $params['username'] . "' ";
        }

        //Email
        if (isset($params['email']) && $params['email'] != '') {
            if ($cond != '') {
                $cond .= ' AND';
            }
            $cond .= " users.email = '" . $params['email'] . "' ";
        }

        //Exclude Users
        if (!empty($params['exclude'])) {
            if ($cond != '') {
                $cond .= ' AND';
            }
            $cond .= " users.userid <> '" . $params['exclude'] . "' ";
        }

        //Getting specific User
        if (isset($params['userid']) && $params['userid'] != '') {
            if ($cond != '') {
                $cond .= ' AND';
            }
            $cond .= " users.userid = '" . $params['userid'] . "' ";
        }

        //Sex
        if (!empty($params['gender'])) {
            if ($cond != '') {
                $cond .= ' AND';
            }
            $cond .= " users.sex = '" . $params['gender'] . "' ";
        }

        //Level
        if (isset($params['level']) && $params['level'] != '') {
            if ($cond != '') {
                $cond .= ' AND';
            }
            $cond .= " users.level = '" . $params['level'] . "' ";
        }

        if (!empty($params['cond'])) {
            if ($cond != '') {
                $cond .= ' AND';
            }
            $cond .= ' ' . $params['cond'] . ' ';
        }

        if (empty($params['count_only'])) {
            $fields = [
                'users'   => get_user_fields(),
                'profile' => ['rating', 'rated_by', 'voters', 'first_name', 'last_name', 'profile_title', 'profile_desc', 'city', 'hometown']
            ];
            $fields['users'][] = 'last_active';
            $fields['users'][] = 'total_collections';
            $fields['users'][] = 'total_groups';
            $query = ' SELECT ' . table_fields($fields) . ' FROM ' . tbl('users') . ' AS users ';
            $query .= ' LEFT JOIN ' . cb_sql_table('user_profile', 'profile') . ' ON users.userid = profile.userid ';

            if ($cond) {
                $query .= ' WHERE ' . $cond;
            }

            if ($order) {
                $query .= ' ORDER BY ' . $order;
            }

            if ($limit) {
                $query .= ' LIMIT ' . $limit;
            }

            $result = select($query);
        } else {
            $result = $db->count(tbl('users') . ' AS users ', 'userid', $cond);
        }

        if (isset($params['assign']) && $params['assign'] != '') {
            assign($params['assign'], $result);
        } else {
            return $result ?? false;
        }
    }

    /**
     * Function used to perform several actions with a video
     */
    function action($case, $uid)
    {
        global $db;
        $udetails = $this->get_user_details(user_id());
        $logged_user_level = $udetails['level'];
        if ($logged_user_level > 1) {
            $data = $this->get_user_details($uid);
            if ($data['level'] == 1) {
                e('You do not have sufficient permissions to edit an Admininstrator');
                return false;
            }
        }

        if (!$this->user_exists($uid)) {
            return false;
        }
        //Lets just check weathter user exists or not
        $tbl = tbl($this->dbtbl['users']);
        switch ($case) {
            //Activating a user
            case 'activate':
            case 'av':
            case 'a':
                $avcode = RandomString(10);
                $db->update($tbl, ['usr_status', 'avcode'], ['Ok', $avcode], " userid='$uid' ");
                e(lang('usr_ac_msg'), 'm');
                break;

            //Deactivating a user
            case 'deactivate':
            case 'dav':
            case 'd':
                $avcode = RandomString(10);
                $db->update($tbl, ['usr_status', 'avcode'], ['ToActivate', $avcode], " userid='$uid' ");
                e(lang('usr_dac_msg'), 'm');
                break;

            //Featuring user
            case 'feature':
            case 'featured':
            case 'f':
                $db->update($tbl, ['featured', 'featured_date'], ['yes', now()], " userid='$uid' ");
                e(lang('User has been set as featured'), 'm');
                break;

            //Unfeatured user
            case 'unfeature':
            case 'unfeatured':
            case 'uf':
                $db->update($tbl, ['featured'], ['no'], " userid='$uid' ");
                e(lang('User has been removed from featured users'), 'm');
                break;

            //Ban User
            case 'ban':
            case 'banned':
                $db->update($tbl, ['ban_status'], ['yes'], " userid='$uid' ");
                e(lang('usr_uban_msg'), 'm');
                break;

            //Ban User
            case 'unban':
            case 'unbanned':
                $db->update($tbl, ['ban_status'], ['no'], " userid='$uid' ");
                e(lang('usr_uuban_msg'), 'm');
                break;
        }
    }

    /**
     * Function used to use to initialize search object for video section
     * op=>operator (AND OR)
     */
    function init_search()
    {
        $this->search = new cbsearch;
        $this->search->db_tbl = 'users';
        // added more conditions usr_status='Ok' and ban_status='no'
        /*
        array('field'=>'usr_status','type'=>'=','var'=>'Ok','op'=>'AND','value'=>'static'),
            array('field'=>'ban_status','type'=>'=','var'=>'no','op'=>'AND','value'=>'static'),
        */
        if (!has_access('admin_access', true)) {
            $this->search->columns = [
                ['field' => 'username', 'type' => 'LIKE', 'var' => '%{KEY}%'],
                ['field' => 'usr_status', 'type' => '=', 'var' => 'Ok', 'op' => 'AND', 'value' => 'static'],
                ['field' => 'ban_status', 'type' => '=', 'var' => 'no', 'op' => 'AND', 'value' => 'static']
            ];
        } else {
            $this->search->columns = [
                ['field' => 'username', 'type' => 'LIKE', 'var' => '%{KEY}%'],
            ];
        }
        $version = get_current_version();
        if ($version['version'] > '5.5.0' || ($version['version'] == '5.5.0' && $version['revision'] >= 264)) {
            $this->search->columns[] = ['field' => 'name', 'type' => 'LIKE', 'var' => '%{KEY}%', 'op' => 'OR', 'db'=>'tags'];
        }

        $this->search->cat_tbl = $this->cat_tbl;

        $this->search->display_template = LAYOUT . '/blocks/user.html';
        $this->search->template_var = 'user';
        $this->search->multi_cat = false;
        $this->search->date_added_colum = 'doj';
        $this->search->results_per_page = config('users_items_search_page');

        /**
         * Setting up the sorting thing
         */

        $sorting = [
            'doj'            => lang('date_added'),
            'profile_hits'   => lang('views'),
            'total_comments' => lang('comments'),
            'total_videos'   => lang('videos')
        ];

        $this->search->sorting = [
            'doj'            => ' doj DESC',
            'profile_hits'   => ' profile_hits DESC',
            'total_comments' => ' total_comments DESC',
            'total_videos'   => ' total_videos DESC'
        ];

        /**
         * Setting Up The Search Fields
         */
        $default = $_GET;
        if (is_array($default['category'])) {
            $cat_array = [$default['category']];
        }
        $uploaded = $default['datemargin'];
        $sort = $default['sort'];

        $this->search->search_type['channels'] = ['title' => lang('users')];

        $fields = [
            'query'       => [
                'title' => lang('keywords'),
                'type'  => 'textfield',
                'name'  => 'query',
                'id'    => 'query',
                'value' => mysql_clean($default['query'])
            ],
            'category'    => [
                'title'         => lang('category'),
                'type'          => 'checkbox',
                'name'          => 'category[]',
                'id'            => 'category',
                'value'         => ['category', $cat_array],
                'category_type' => 'user'
            ],
            'date_margin' => [
                'title'   => lang('joined'),
                'type'    => 'dropdown',
                'name'    => 'datemargin',
                'id'      => 'datemargin',
                'value'   => $this->search->date_margins(),
                'checked' => $uploaded
            ],
            'sort'        => [
                'title'   => lang('sort_by'),
                'type'    => 'dropdown',
                'name'    => 'sort',
                'value'   => $sorting,
                'checked' => $sort
            ]
        ];

        $this->search->search_type['users']['fields'] = $fields;
    }

    /**
     * Function used to get number of users online
     *
     * @param bool $group
     * @param bool $count
     *
     * @return array|bool
     * @throws Exception
     */
    function get_online_users($group = true, $count = false)
    {
        global $db;

        if ($group) {
            $results = $db->select(tbl('sessions') . ' LEFT JOIN (' . tbl('users') . ") ON
             (" . tbl('sessions.session_user=') . tbl('users') . '.userid)',
                tbl('sessions.*,users.username,users.userid,users.email') . ',count(' . tbl('sessions.session_user') . ') AS logins'
                , ' TIMESTAMPDIFF(MINUTE,' . tbl('sessions.last_active') . ",'" . NOW() . "')  < 6 GROUP BY " . tbl('users.userid'));
        } else {
            if ($count) {
                $results = $db->count(tbl('sessions') . ' LEFT JOIN (' . tbl('users') . ') ON
                 (' . tbl('sessions.session_user=') . tbl('users') . '.userid)',
                    tbl('sessions.session_id')
                    , ' TIMESTAMPDIFF(MINUTE,' . tbl('sessions.last_active') . ",'" . NOW() . "')  < 6 ");
            } else {
                $results = $db->select(tbl('sessions') . ' LEFT JOIN (' . tbl('users') . ') ON
                 (' . tbl('sessions.session_user=') . tbl('users') . '.userid)',
                    tbl('sessions.*,users.username,users.userid,users.email')
                    , ' TIMESTAMPDIFF(MINUTE,' . tbl('sessions.last_active') . ",'" . NOW() . "')  < 6 ");
            }
        }

        return $results;
    }

    /**
     * Function will let admin to login as user
     *
     * @param      $id
     * @param bool $realtime
     *
     * @return bool
     * @throws Exception
     */
    function login_as_user($id, $realtime = false): bool
    {
        global $sess, $db;
        $udetails = $this->get_user_details($id);
        if ($udetails) {
            if (!$realtime) {
                $sess->set('dummy_sess_salt', $sess->get('sess_salt'));
                $sess->set('dummy_PHPSESSID', $sess->get('PHPSESSID'));
                $sess->set('dummy_userid', user_id());
                $sess->set('dummy_user_session_key', $this->udetails['user_session_key']);

                $userid = $udetails['userid'];
                $session_salt = RandomString(5);
                $sess->set('sess_salt', $session_salt);
                $sess->set('PHPSESSID', $sess->id);

                $smart_sess = md5($udetails['user_session_key'] . $session_salt);

                $db->delete(tbl('sessions'), ['session'], [$sess->id]);
                $sess->add_session($userid, 'smart_sess', $smart_sess);
            } else {
                if ($this->login_check(null, true)) {
                    $msg[] = e(lang('you_already_logged'));
                } elseif (!$this->user_exists($udetails['username'])) {
                    $msg[] = e(lang('user_doesnt_exist'));
                } elseif (strtolower($udetails['usr_status']) != 'ok') {
                    $msg[] = e(lang('user_inactive_msg'), 'e', false);
                } elseif ($udetails['ban_status'] == 'yes') {
                    $msg[] = e(lang('usr_ban_err'));
                } else {
                    $userid = $udetails['userid'];
                    $log_array['userid'] = $userid;
                    $log_array['useremail'] = $udetails['email'];
                    $log_array['success'] = 'yes';
                    $log_array['level'] = $udetails['level'];

                    //Starting special sessions for security
                    $session_salt = RandomString(5);
                    $sess->set('sess_salt', $session_salt);
                    $sess->set('PHPSESSID', $sess->id);

                    $smart_sess = md5($udetails['user_session_key'] . $session_salt);

                    $db->delete(tbl('sessions'), ['session', 'session_string'], [$sess->id, 'guest']);
                    $sess->add_session($userid, 'smart_sess', $smart_sess);

                    //Setting Vars
                    $this->userid = $udetails['userid'];
                    $this->username = $udetails['username'];
                    $this->level = $udetails['level'];

                    //Updating User last login , num of visits and ip
                    $db->update(tbl('users'),
                        ['num_visits', 'last_logged', 'ip'],
                        ['|f|num_visits+1', NOW(), $_SERVER['REMOTE_ADDR']],
                        'userid=\'' . $userid . '\''
                    );

                    $this->init();
                    //Logging Action
                    insert_log('Login as', $log_array);
                    return true;
                }

                //Error Logging
                if (!empty($msg)) {
                    //Logging Action
                    $log_array['success'] = 'no';
                    $log_array['details'] = $msg[0]['val'];
                    insert_log('Login as', $log_array);
                }
            }

            return true;
        }

        e(lang('usr_exist_err'));
        return false;
    }

    /**
     * Function used to revert back to admin
     */
    function revert_from_user()
    {
        global $sess, $db;
        if ($this->is_admin_logged_as_user()) {
            $userid = $sess->get('dummy_userid');
            $session_salt = $sess->get('dummy_sess_salt');
            $user_session_key = $sess->get('dummy_user_session_key');
            $smart_sess = md5($user_session_key . $session_salt);

            $sess->set('sess_salt', $session_salt);
            $sess->set('PHPSESSID', $sess->get('dummy_PHPSESSID'));

            $db->delete(tbl('sessions'), ['session'], [$sess->get('dummy_PHPSESSID')]);
            $sess->add_session($userid, 'smart_sess', $smart_sess);

            $sess->set('dummy_sess_salt', '');
            $sess->set('dummy_PHPSESSID', '');
            $sess->set('dummy_userid', '');
            $sess->set('dummy_user_session_key', '');
        }
    }

    /**
     * Function used to check weather user is logged in as admin or not
     */
    function is_admin_logged_as_user(): bool
    {
        global $sess;
        if ($sess->get('dummy_sess_salt') != '') {
            return true;
        }
        return false;
    }

    /**
     * Function used to get anonymous user
     */
    function get_anonymous_user()
    {
        global $db;
        /*Added to resolve bug 222*/
        $result = $db->select(tbl('users'), 'userid', " username='anonymous%' AND email='anonymous%'", '1');
        if ($result[0]['userid']) {
            return $result[0]['userid'];
        }

        $result = $db->select(tbl('users'), 'userid', " level='6' AND usr_status='ToActivate' ", '1');
        if ($result[0]['userid']) {
            return $result[0]['userid'];
        }

        $pass = RandomString(10);

        if ($_SERVER['HTTP_HOST'] != 'localhost' && $_SERVER['HTTP_HOST'] != '127.0.0.1') {
            $email = 'anonymous' . RandomString(5) . '@' . $_SERVER['HTTP_HOST'];
        } else {
            $email = 'anonymous' . RandomString(5) . '@' . $_SERVER['HTTP_HOST'] . '.tld';
        }

        //Create Anonymous user
        return $this->signup_user(
            [
                'username'  => 'anonymous' . RandomString(5),
                'email'     => $email,
                'password'  => $pass,
                'cpassword' => $pass,
                'country'   => config('default_country_iso2'),
                'gender'    => 'Male',
                'dob'       => '2000-10-10',
                'category'  => '1',
                'level'     => '6',
                'active'    => 'yes',
                'agree'     => 'yes'
            ], false);
    }

    /**
     * Function used to delete user videos
     *
     * @param $uid
     * @throws Exception
     */
    function delete_user_vids($uid)
    {
        global $cbvid, $eh;
        $vids = get_videos(['user' => $uid]);
        if (is_array($vids)) {
            foreach ($vids as $vid) {
                $cbvid->delete_video($vid['videoid']);
            }
        }
        $eh->flush_msg();
        e(lang('user_vids_hv_deleted'), 'm');
    }

    /**
     * Function used to remove user contacts
     *
     * @param $uid
     * @throws Exception
     */
    function remove_contacts($uid)
    {
        global $eh;
        $contacts = $this->get_contacts($uid);
        if (is_array($contacts)) {
            foreach ($contacts as $contact) {
                $this->remove_contact($contact['userid'], $contact['contact_userid']);
            }
        }
        $eh->flush_msg();
        e(lang('user_contacts_hv_removed'), 'm');
    }

    /**
     * Function used to remove user private messages
     *
     * @param        $uid
     * @param string $box
     * @throws Exception
     */
    function remove_user_pms($uid, $box = 'both')
    {
        global $cbpm, $eh;

        if ($box == 'inbox' || $box == 'both') {
            $inboxs = $cbpm->get_user_inbox_messages($uid);
            if (is_array($inboxs)) {
                foreach ($inboxs as $inbox) {
                    $cbpm->delete_msg($inbox['message_id'], $uid);
                }
            }
            $eh->flush_msg();
            e(lang('all_user_inbox_deleted'), 'm');
        }

        if ($box == 'sent' || $box == 'both') {
            $outs = $cbpm->get_user_outbox_messages($uid);
            if (is_array($outs)) {
                foreach ($outs as $out) {
                    $cbpm->delete_msg($out['message_id'], $uid, 'out');
                }
            }
            $eh->flush_msg();
            e(lang('all_user_sent_messages_deleted'), 'm');
        }
    }

    /**
     * This will get user subscriptions
     * uploaded videos and photos
     * This is a test function
     *
     * @param        $uid
     * @param int $limit
     * @param string $uploadsType
     * @param string $uploadsTimeSpan
     *
     * @return bool|array
     * @throws Exception
     */
    function getSubscriptionsUploadsWeek($uid, $limit = 20, $uploadsType = 'both', $uploadsTimeSpan = 'this_week')
    {
        $user_cond = "";
        $users = $this->get_user_subscriptions($uid);
        if ($users) {
            foreach ($users as $user) {
                if ($user_cond) {
                    $user_cond .= ' OR ';
                }
                $user_cond .= tbl('users.userid') . "='" . $user[0] . "' ";
            }
            $user_cond = ' (' . $user_cond . ') ';
            global $cbphoto, $cbvideo;
            $photoCount = 1;
            $videoCount = 1;
            switch ($uploadsType) {
                case 'both':
                default:
                    $photos = $cbphoto->get_photos(['limit' => $limit, 'extra_cond' => $user_cond, 'order' => ' date_added DESC', 'date_span' => $uploadsTimeSpan]);
                    $videos = $cbvideo->get_videos(['limit' => $limit, 'cond' => ' AND' . $user_cond, 'order' => ' date_added DESC', 'date_span' => $uploadsTimeSpan]);
                    if (!empty($photos) && !empty($videos)) {
                        $finalResult = array_merge($videos, $photos);
                    } elseif (empty($photos) && !empty($videos)) {
                        $finalResult = array_merge($videos, []);
                    } elseif (!empty($photos) && empty($videos)) {
                        $finalResult = array_merge($photos, []);
                    }

                    if (!empty($finalResult)) {
                        foreach ($finalResult as $result) {
                            if ($result['videoid']) {
                                $videoArr[] = $result;
                                $return['videos'] = [
                                    'title' => lang('videos'),
                                    'total' => $videoCount++,
                                    'items' => $videoArr
                                ];
                            }

                            if ($result['photo_id']) {
                                $photosArr[] = $result;
                                $return['photos'] = [
                                    'title' => lang('photos'),
                                    'total' => $photoCount++,
                                    'items' => $photosArr
                                ];
                            }
                        }
                        return $return;
                    }
                    return false;


                case 'photos':
                case 'photo' :
                case 'p':
                    $photos = $cbphoto->get_photos(['limit' => $limit, 'extra_cond' => $user_cond, 'order' => ' date_added DESC', 'date_span' => $uploadsTimeSpan]);
                    if ($photos) {
                        foreach ($photos as $photo) {
                            $photosArr[] = $photo;
                            $return['photos'] = [
                                'title' => lang('photos'),
                                'total' => $photoCount++,
                                'items' => $photosArr
                            ];
                        }
                    } else {
                        return false;
                    }
                    break;

                case 'videos':
                case 'video':
                case 'v':
                    $videos = $cbvideo->get_videos(['limit' => $limit, 'cond' => ' AND' . $user_cond, 'order' => ' date_added DESC', 'date_span' => $uploadsTimeSpan]);
                    if ($videos) {
                        foreach ($videos as $video) {
                            $videoArr[] = $video;
                            $return['videos'] = [
                                'title' => lang('videos'),
                                'total' => $videoCount++,
                                'items' => $videoArr
                            ];
                        }
                    } else {
                        return false;
                    }
                    break;
            }
            return $return;
        }
    }

    /**
     * Function used to set item as profile item
     *
     * @param        $id
     * @param string $type
     * @param null $uid
     *
     * @return bool|void
     * @throws Exception
     */
    function setProfileItem($id, $type = 'v', $uid = null)
    {
        global $cbvid, $db, $cbphoto;
        if (!$uid) {
            $uid = user_id();
        }

        if (!$uid) {
            e('user_doesnt_exist');
            return false;
        }

        switch ($type) {
            case 'v':
                if ($cbvid->video_exists($id)) {
                    $array['type'] = 'v';
                    $array['id'] = $id;
                    $db->update(tbl('user_profile'), ['profile_item'], ['|no_mc|' . json_encode($array)]
                        , " userid='$uid' ");

                    e(sprintf(lang('this_has_set_profile_item'), lang('video')), 'm');
                } else {
                    e('class_vdo_del_err');
                }
                break;

            case 'p':
                if ($cbphoto->photo_exists($id)) {
                    $array['type'] = 'p';
                    $array['id'] = $id;
                    $db->update(tbl('user_profile'), ['profile_item'], ['|no_mc|' . json_encode($array)]
                        , " userid='$uid' ");

                    e(sprintf(lang('this_has_set_profile_item'), lang('photo')), 'm');
                } else {
                    e('photo_not_exist');
                }
                break;
        }
    }

    /**
     * Remove Profile item
     *
     * @param null $uid
     *
     * @return bool|void
     * @throws Exception
     */
    function removeProfileItem($uid = null)
    {
        global $db;
        if (!$uid) {
            $uid = user_id();
        }

        if (!$uid) {
            e('user_doesnt_exist');
            return false;
        }

        $db->update(tbl('user_profile'), ['profile_item'], [""]
            , " userid='$uid' ");

        e(lang('profile_item_removed'), 'm');
    }

    /**
     * function used to get profile item
     *
     * @param null $uid
     * @param bool $withDetails
     *
     * @return bool|mixed|STRING
     * @throws Exception
     */
    function getProfileItem($uid = null, $withDetails = false)
    {
        global $db, $cbvid, $cbphoto;
        if (!$uid) {
            $uid = user_id();
        }

        if (!$uid) {
            e('user_doesnt_exist');
            return false;
        }

        if ($uid == user_id() && $this->profileItem && !$withDetails) {
            return $this->profileItem;
        }

        $profileItem = $db->select(tbl('user_profile'), 'profile_item', " userid='$uid'");
        $profileItem = $profileItem[0]['profile_item'];

        $profileItem = json_decode($profileItem, true);

        if ($withDetails) {
            switch ($profileItem['type']) {
                case 'p':
                    $photo = $cbphoto->get_photo($profileItem['id']);
                    $photo['type'] = 'p';
                    if ($photo) {
                        return $photo;
                    }
                    break;

                case 'v':
                    $video = $cbvid->get_video($profileItem['id']);
                    $video['type'] = 'v';
                    if ($video) {
                        return $video;
                    }
                    break;
            }
        }
        return $this->profileItem = $profileItem;
    }

    /**
     * Function used to check weather input given item
     * is profile item or not
     *
     * @param        $id
     * @param string $type
     * @param null $uid
     *
     * @return bool
     * @throws Exception
     */
    function isProfileItem($id, $type = 'v', $uid = null): bool
    {
        $profileItem = $this->getProfileItem($uid);

        if ($profileItem['type'] == $type && $profileItem['id'] == $id) {
            return true;
        }
        return false;
    }

    /**
     * FUnction loading personal details
     *
     * @param $default
     *
     * @return array
     * @throws Exception
     */
    function load_personal_details($default): array
    {
        if (!$default) {
            $default = $_POST;
        }

        return [
            'first_name'      => [
                'title'       => lang('user_fname'),
                'type'        => 'textfield',
                'name'        => 'first_name',
                'id'          => 'first_name',
                'value'       => $default['first_name'],
                'db_field'    => 'first_name',
                'required'    => 'no',
                'syntax_type' => 'name',
                'auto_view'   => 'yes'
            ],
            'last_name'       => [
                'title'       => lang('user_lname'),
                'type'        => 'textfield',
                'name'        => 'last_name',
                'id'          => 'last_name',
                'value'       => $default['last_name'],
                'db_field'    => 'last_name',
                'syntax_type' => 'name',
                'auto_view'   => 'yes'
            ],
            'relation_status' => [
                'title'     => lang('user_relat_status'),
                'type'      => 'dropdown',
                'name'      => 'relation_status',
                'id'        => 'last_name',
                'value'     => [
                    lang('usr_arr_no_ans'),
                    lang('usr_arr_single'),
                    lang('usr_arr_married'),
                    lang('usr_arr_comitted'),
                    lang('usr_arr_open_relate')
                ],
                'checked'   => $default['relation_status'],
                'db_field'  => 'relation_status',
                'auto_view' => 'yes'
            ],
            'show_dob'        => [
                'title'       => lang('show_dob'),
                'type'        => 'radiobutton',
                'name'        => 'show_dob',
                'id'          => 'show_dob',
                'value'       => ['yes' => lang('yes'), 'no' => lang('no')],
                'checked'     => $default['show_dob'],
                'db_field'    => 'show_dob',
                'syntax_type' => 'name',
                'auto_view'   => 'no',
                'sep'         => '&nbsp;'
            ],
            'about_me'        => [
                'title'      => lang('user_about_me'),
                'type'       => 'textarea',
                'name'       => 'about_me',
                'id'         => 'about_me',
                'value'      => mysql_clean($default['about_me']),
                'db_field'   => 'about_me',
                'auto_view'  => 'no',
                'clean_func' => 'Replacer'
            ],
            'profile_tags'    => [
                'title'     => lang('profile_tags'),
                'type'      => 'hidden',
                'name'      => 'profile_tags',
                'id'        => 'profile_tags',
                'value'     => genTags($default['profile_tags']),
                'auto_view' => 'no'
            ],
            'web_url'         => [
                'title'            => lang('website'),
                'type'             => 'textfield',
                'name'             => 'web_url',
                'id'               => 'web_url',
                'value'            => $default['web_url'],
                'db_field'         => 'web_url',
                'auto_view'        => 'yes',
                'display_function' => 'outgoing_link'
            ]
        ];
    }

    /**
     * function used to load location fields
     *
     * @param $default
     *
     * @return array
     * @throws Exception
     */
    function load_location_fields($default): array
    {
        if (!$default) {
            $default = $_POST;
        }
        return [
            'postal_code' => [
                'title'     => lang('postal_code'),
                'type'      => 'textfield',
                'name'      => 'postal_code',
                'id'        => 'postal_code',
                'value'     => $default['postal_code'],
                'db_field'  => 'postal_code',
                'auto_view' => 'yes'
            ],
            'hometown'    => [
                'title'     => lang('hometown'),
                'type'      => 'textfield',
                'name'      => 'hometown',
                'id'        => 'hometown',
                'value'     => $default['hometown'],
                'db_field'  => 'hometown',
                'auto_view' => 'yes'
            ],
            'city'        => [
                'title'     => lang('city'),
                'type'      => 'textfield',
                'name'      => 'city',
                'id'        => 'city',
                'value'     => $default['city'],
                'db_field'  => 'city',
                'auto_view' => 'yes'
            ]
        ];
    }

    /**
     * Function used to load experice fields
     *
     * @param $default
     *
     * @return array
     * @throws Exception
     */
    function load_education_interests($default): array
    {
        if (!$default) {
            $default = $_POST;
        }

        return [
            'education'  => [
                'title'     => lang('education'),
                'type'      => 'dropdown',
                'name'      => 'education',
                'id'        => 'education',
                'value'     => [
                    lang('usr_arr_no_ans'),
                    lang('usr_arr_elementary'),
                    lang('usr_arr_hi_school'),
                    lang('usr_arr_some_colg'),
                    lang('usr_arr_assoc_deg'),
                    lang('usr_arr_bach_deg'),
                    lang('usr_arr_mast_deg'),
                    lang('usr_arr_phd'),
                    lang('usr_arr_post_doc')
                ],
                'checked'   => $default['education'],
                'db_field'  => 'education',
                'auto_view' => 'yes'
            ],
            'schools'    => [
                'title'      => lang('schools'),
                'type'       => 'textarea',
                'name'       => 'schools',
                'id'         => 'schools',
                'value'      => mysql_clean($default['schools']),
                'db_field'   => 'schools',
                'clean_func' => 'Replacer',
                'auto_view'  => 'yes'
            ],
            'occupation' => [
                'title'      => lang('occupation'),
                'type'       => 'textarea',
                'name'       => 'occupation',
                'id'         => 'occupation',
                'value'      => mysql_clean($default['occupation']),
                'db_field'   => 'occupation',
                'clean_func' => 'Replacer',
                'auto_view'  => 'yes'
            ],
            'companies'  => [
                'title'      => lang('companies'),
                'type'       => 'textarea',
                'name'       => 'companies',
                'id'         => 'companies',
                'value'      => mysql_clean($default['companies']),
                'db_field'   => 'companies',
                'clean_func' => 'Replacer',
                'auto_view'  => 'yes'
            ],
            'hobbies'    => [
                'title'      => lang('hobbies'),
                'type'       => 'textarea',
                'name'       => 'hobbies',
                'id'         => 'hobbies',
                'value'      => mysql_clean($default['hobbies']),
                'db_field'   => 'hobbies',
                'clean_func' => 'Replacer',
                'auto_view'  => 'yes'
            ],
            'fav_movies' => [
                'title'      => lang('user_fav_movs_shows'),
                'type'       => 'textarea',
                'name'       => 'fav_movies',
                'id'         => 'fav_movies',
                'value'      => mysql_clean($default['fav_movies']),
                'db_field'   => 'fav_movies',
                'clean_func' => 'Replacer',
                'auto_view'  => 'yes'
            ],
            'fav_music'  => [
                'title'      => lang('user_fav_music'),
                'type'       => 'textarea',
                'name'       => 'fav_music',
                'id'         => 'fav_music',
                'value'      => mysql_clean($default['fav_music']),
                'db_field'   => 'fav_music',
                'clean_func' => 'Replacer',
                'auto_view'  => 'yes'
            ],
            'fav_books'  => [
                'title'      => lang('user_fav_books'),
                'type'       => 'textarea',
                'name'       => 'fav_books',
                'id'         => 'fav_books',
                'value'      => mysql_clean($default['fav_books']),
                'db_field'   => 'fav_books',
                'clean_func' => 'Replacer',
                'auto_view'  => 'yes'
            ]
        ];
    }


    /**
     * Function used to load privacy fields
     *
     * @param $default
     *
     * @return array
     * @throws Exception
     */
    function load_privacy_field($default): array
    {
        if (!$default) {
            $default = $_POST;
        }

        return [
            'online_status'      => [
                'title'    => lang('online_status'),
                'type'     => 'dropdown',
                'name'     => 'privacy',
                'id'       => 'privacy',
                'value'    => ['online' => lang('online'), 'offline' => lang('offline'), 'custom' => lang('custom')],
                'checked'  => $default['online_status'],
                'db_field' => 'online_status'
            ],
            'show_profile'       => [
                'title'    => lang('show_profile'),
                'type'     => 'dropdown',
                'name'     => 'show_profile',
                'id'       => 'show_profile',
                'value'    => ['all' => lang('all'), 'members' => lang('members'), 'friends' => lang('friends')],
                'checked'  => $default['show_profile'],
                'db_field' => 'show_profile',
                'sep'      => '&nbsp;'
            ],
            'allow_comments'     => [
                'title'    => lang('vdo_allow_comm'),
                'type'     => 'radiobutton',
                'name'     => 'allow_comments',
                'id'       => 'allow_comments',
                'value'    => ['yes' => lang('yes'), 'no' => lang('no')],
                'checked'  => strtolower($default['allow_comments']),
                'db_field' => 'allow_comments',
                'sep'      => '&nbsp;'
            ],
            'allow_ratings'      => [
                'title'    => lang('allow_ratings'),
                'type'     => 'radiobutton',
                'name'     => 'allow_ratings',
                'id'       => 'allow_ratings',
                'value'    => ['yes' => lang('yes'), 'no' => lang('no')],
                'checked'  => strtolower($default['allow_ratings']),
                'db_field' => 'allow_ratings',
                'sep'      => '&nbsp;'
            ],
            'allow_subscription' => [
                'title'    => lang('allow_subscription'),
                'type'     => 'radiobutton',
                'name'     => 'allow_subscription',
                'id'       => 'allow_subscription',
                'hint_1'   => lang('allow_subscription_hint'),
                'value'    => ['yes' => lang('yes'), 'no' => lang('no')],
                'checked'  => strtolower($default['allow_subscription']),
                'db_field' => 'allow_subscription',
                'sep'      => '&nbsp;'
            ]
        ];
    }

    /**
     * load_channel_settings
     *
     * @param $default array values for channel settings
     * @return array of channel info fields
     * @throws Exception
     */
    function load_channel_settings($default): array
    {
        if (!$default) {
            $default = $_POST;
        }

        return [
            'profile_title'         => [
                'title'     => lang('channel_title'),
                'type'      => 'textfield',
                'name'      => 'profile_title',
                'id'        => 'profile_title',
                'value'     => $default['profile_title'],
                'db_field'  => 'profile_title',
                'auto_view' => 'no'
            ],
            'profile_desc'          => [
                'title'      => lang('channel_desc'),
                'type'       => 'textarea',
                'name'       => 'profile_desc',
                'id'         => 'profile_desc',
                'value'      => $default['profile_desc'],
                'db_field'   => 'profile_desc',
                'auto_view'  => 'yes',
                'clean_func' => 'Replacer'
            ],
            'show_my_friends'       => [
                'title'    => lang('show_my_friends'),
                'type'     => 'radiobutton',
                'name'     => 'show_my_friends',
                'id'       => 'show_my_friends',
                'value'    => ['yes' => lang('yes'), 'no' => lang('no')],
                'checked'  => strtolower($default['show_my_friends']),
                'db_field' => 'show_my_friends',
                'sep'      => '&nbsp;'
            ],
            'show_my_videos'        => [
                'title'    => lang('show_my_videos'),
                'type'     => 'radiobutton',
                'name'     => 'show_my_videos',
                'id'       => 'show_my_videos',
                'value'    => ['yes' => lang('yes'), 'no' => lang('no')],
                'checked'  => strtolower($default['show_my_videos']),
                'db_field' => 'show_my_videos',
                'sep'      => '&nbsp;'
            ],
            'show_my_photos'        => [
                'title'    => lang('show_my_photos'),
                'type'     => 'radiobutton',
                'name'     => 'show_my_photos',
                'id'       => 'show_my_photos',
                'value'    => ['yes' => lang('yes'), 'no' => lang('no')],
                'checked'  => strtolower($default['show_my_photos']),
                'db_field' => 'show_my_photos',
                'sep'      => '&nbsp;'
            ],
            'show_my_subscriptions' => [
                'title'    => lang('show_my_subscriptions'),
                'type'     => 'radiobutton',
                'name'     => 'show_my_subscriptions',
                'id'       => 'show_my_subscriptions',
                'value'    => ['yes' => lang('yes'), 'no' => lang('no')],
                'checked'  => strtolower($default['show_my_subscriptions']),
                'db_field' => 'show_my_subscriptions',
                'sep'      => '&nbsp;'
            ],
            'show_my_subscribers'   => [
                'title'    => lang('show_my_subscribers'),
                'type'     => 'radiobutton',
                'name'     => 'show_my_subscribers',
                'id'       => 'show_my_subscribers',
                'value'    => ['yes' => lang('yes'), 'no' => lang('no')],
                'checked'  => strtolower($default['show_my_subscribers']),
                'db_field' => 'show_my_subscribers',
                'sep'      => '&nbsp;'
            ],
            'show_my_collections'   => [
                'title'    => lang('show_my_collections'),
                'type'     => 'radiobutton',
                'name'     => 'show_my_collections',
                'id'       => 'show_my_collections',
                'value'    => ['yes' => lang('yes'), 'no' => lang('no')],
                'checked'  => strtolower($default['show_my_collections']),
                'db_field' => 'show_my_collections',
                'sep'      => '&nbsp;'
            ]
        ];
    }

    /**
     * load_user_fields
     *
     * @param        $default array values for user profile fields
     * @param string $type
     *
     * @return array of user fields
     *
     * Function used to load Video fields
     * in Clipbucket v2.1 , video fields are loaded in form of groups arrays
     * each group has it name and fields wrapped in array
     * and that array will be part of video fields
     * @throws Exception
     */
    function load_user_fields($default, $type = 'all')
    {
        $getChannelSettings = false;
        $getProfileSettings = false;
        $fields = [];

        switch ($type) {
            case 'all':
                $getChannelSettings = true;
                $getProfileSettings = true;
                break;

            case 'channel':
            case 'channels':
                $getChannelSettings = true;
                break;

            case 'profile':
            case 'profile_settings':
                $getProfileSettings = true;
                break;
        }

        if ($getChannelSettings) {
            $channel_settings = [
                [
                    'group_name' => lang('channel_settings'),
                    'group_id'   => 'channel_settings',
                    'fields'     => array_merge($this->load_channel_settings($default)
                        , $this->load_privacy_field($default)),
                ]
            ];
        }

        if ($getProfileSettings) {
            $profile_settings = [
                [
                    'group_name' => lang('profile_basic_info'),
                    'group_id'   => 'profile_basic_info',
                    'fields'     => $this->load_personal_details($default),
                ],
                [
                    'group_name' => lang('location'),
                    'group_id'   => 'profile_location',
                    'fields'     => $this->load_location_fields($default)
                ],
                [
                    'group_name' => lang('profile_education_interests'),
                    'group_id'   => 'profile_education_interests',
                    'fields'     => $this->load_education_interests($default)
                ]
            ];

            //Adding Custom Fields
            $custom_fields = $this->load_custom_profile_fields($default, false);
            if ($custom_fields) {
                $more_fields_group = [
                    'group_name' => lang('more_fields'),
                    'group_id'   => 'custom_fields',
                    'fields'     => $custom_fields
                ];
            }

            //Loading Custom Profile Forms
            $custom_fields_with_group = $this->load_custom_profile_fields($default, true);

            //Finally putting them together in their main array called $fields
            if ($custom_fields_with_group) {
                $custFieldGroups = $custom_fields_with_group;

                foreach ($custFieldGroups as $gKey => $fieldGroup) {
                    $group_id = $fieldGroup['group_id'];

                    foreach ($profile_settings as $key => $field) {
                        if ($field['group_id'] == $group_id) {
                            $inputFields = $field['fields'];
                            //Setting field values
                            $newFields = $fieldGroup['fields'];
                            $mergeField = array_merge($inputFields, $newFields);

                            //Finally Updating array
                            $newGroupArray = [
                                'group_name' => $field['group_name'],
                                'group_id'   => $field['group_id'],
                                'fields'     => $mergeField
                            ];

                            $fields[$key] = $newGroupArray;
                            $matched = true;
                            break;
                        } else {
                            $matched = false;
                        }
                    }
                    if (!$matched) {
                        $profile_settings[] = $fieldGroup;
                    }
                }
            }

        }

        if ($channel_settings) {
            $fields = array_merge($fields, $channel_settings);
        }
        if ($profile_settings) {
            $fields = array_merge($fields, $profile_settings);
        }
        if ($more_fields_group) {
            $fields[] = $more_fields_group;
        }
        return $fields;
    }

    /**
     * Used to rate photo
     *
     * @param $id
     * @param $rating
     *
     * @return array
     * @throws Exception
     */
    function rate_user($id, $rating): array
    {
        global $db;

        if (!is_numeric($rating) || $rating <= 9) {
            $rating = 0;
        }
        if ($rating >= 10) {
            $rating = 10;
        }

        $c_rating = $this->current_rating($id);
        $voters = $c_rating['voters'];
        $new_rate = $c_rating['rating'];
        $rated_by = $c_rating['rated_by'];

        $voters = json_decode($voters, true);

        if (!empty($voters)) {
            $already_voted = array_key_exists(user_id(), $voters);
        }

        if (!user_id()) {
            e(lang('please_login_to_rate'));
        } elseif (user_id() == $c_rating['userid'] && !config('own_channel_rating')) {
            e(lang('you_cant_rate_own_channel'));
        } elseif (!empty($already_voted)) {
            e(lang('you_have_already_voted_channel'));
        } elseif ($c_rating['allow_ratings'] == 'no' || !config('channel_rating')) {
            e(lang('channel_rating_disabled'));
        } else {
            $voters[user_id()] = [
                'userid'   => user_id(),
                'username' => user_name(),
                'time'     => now(),
                'rating'   => $rating
            ];
            $voters = json_encode($voters);

            $t = $c_rating['rated_by'] * $c_rating['rating'];
            $rated_by = $c_rating['rated_by'] + 1;
            $new_rate = ($t + $rating) / $rated_by;
            $db->update(tbl('user_profile'), ['rating', 'rated_by', 'voters'], ["$new_rate", "$rated_by", "|no_mc|$voters"], ' userid = ' . $id . '');
            $userDetails = [
                'object_id' => $id,
                'type'      => 'user',
                'time'      => now(),
                'rating'    => $rating,
                'userid'    => user_id(),
                'username'  => user_name()
            ];
            /* Updating user details */
            update_user_voted($userDetails);
            e(lang('thnx_for_voting'), 'm');
        }

        return ['rating' => $new_rate, 'rated_by' => $rated_by, 'total' => 10, 'id' => $id, 'type' => 'user', 'disable' => 'disabled'];
    }

    /**
     * Used to get current rating
     *
     * @param $id
     *
     * @return bool|array
     * @throws Exception
     */
    function current_rating($id)
    {
        global $db;
        $result = $db->select(tbl('user_profile'), 'userid,allow_ratings,rating,rated_by,voters', ' userid = ' . mysql_clean($id) );
        if ($result) {
            return $result[0];
        }
        return false;
    }

    /**
     * function used to check weather user is  online or not
     *
     * @param      $last_active
     * @param null $status
     *
     * @return bool
     */
    function isOnline($last_active, $status = null): bool
    {
        $time = strtotime($last_active);
        $timeDiff = time() - $time;
        if ($timeDiff > 60 || $status == 'offline') {
            return false;
        }
        return true;
    }

    /**
     * Function used to get list of subscribed users and then
     * send subscription email
     *
     * @param      $vidDetails
     * @param bool $updateStatus
     *
     * @return bool
     * @throws Exception
     */
    function sendSubscriptionEmail($vidDetails, bool $updateStatus = true): bool
    {
        global $cbemail, $db;
        if (!$vidDetails['videoid']) {
            e(lang('invalid_videoid'));
            return false;
        }

        if (!$vidDetails['userid']) {
            e(lang('invalid_userid'));
            return false;
        }

        //Lets get the list of subscribers
        $subscribers = $this->get_user_subscribers_detail($vidDetails['userid'], false);
        //Now lets get details of our uploader bhai saab
        $uploader = $this->get_user_details($vidDetails['userid']);
        //Loading subscription email template
        $tpl = $cbemail->get_template('video_subscription_email');

        if ($subscribers) {
            foreach ($subscribers as $subscriber) {
                $var = [
                    '{username}'          => $subscriber['username'],
                    '{uploader}'          => $uploader['username'],
                    '{video_title}'       => $vidDetails['title'],
                    '{video_description}' => $vidDetails['description'],
                    '{video_link}'        => video_link($vidDetails),
                    '{video_thumb}'       => get_thumb($vidDetails)
                ];

                $more_var = $this->custom_subscription_email_vars;
                if( !empty($more_var) && is_array($more_var) ){
                    $var = array_merge($var, $more_var);
                }

                $subj = $cbemail->replace($tpl['email_template_subject'], $var);
                $msg = nl2br($cbemail->replace($tpl['email_template'], $var));

                //Now Finally Sending Email
                cbmail(['to' => $subscriber['email'], 'from' => WELCOME_EMAIL, 'subject' => $subj, 'content' => $msg]);
            }

            $total_subscribers = count($subscribers);
            $s = '';
            if ($total_subscribers > 1) {
                $s = 's';
            }
            e(sprintf(lang('subs_email_sent_to_users'), $total_subscribers, $s), 'm');
        }

        //Updating video subscription email status to sent
        if ($updateStatus) {
            $db->update(tbl('video'), ['subscription_email'], ['sent'], " videoid='" . $vidDetails['videoid'] . "'");
        }

        return true;
    }

    /**
     * function used to get user sessions
     * @throws Exception
     */
    function get_sessions(): array
    {
        global $sess;
        $sessions = $sess->get_sessions();
        $new_sessions = [];
        if ($sessions) {
            foreach ($sessions as $session) {
                $new_sessions[$session['session_string']] = $session;
            }
        } else {
            $sess->add_session(0, 'guest', 'guest');
        }

        return $new_sessions;
    }

    /**
     * @throws Exception
     */
    function update_user_voted($array, $userid = null)
    {
        global $db;
        if (!$userid) {
            $userid = user_id();
        }

        if (is_array($array)) {
            $voted = '';
            $votedDetails = $db->select(tbl('users'), 'voted', " userid = '$userid'");
            if (!empty($votedDetails)) {
                if (!empty($js)) {
                    $voted = $js->json_decode($votedDetails[0]['voted'], true);
                } else {
                    $voted = json_decode($votedDetails[0]['voted'], true);
                }
            }

            if (!empty($js)) {
                $votedEncode = $js->json_encode($voted);
            } else {
                $votedEncode = json_encode($voted);
            }

            if (!empty($votedEncode)) {
                $db->update(tbl('users'), ['voted'], ["|no_mc|$votedEncode"], " userid='$userid'");
            }
        }
    }

    /**
     * Function used to display user manger link
     *
     * @param $link
     * @param $vid
     *
     * @return string
     */
    function user_manager_link($link, $vid): string
    {
        if (function_exists($link) && !is_array($link)) {
            return $link($vid);
        }

        if (!empty($link['title']) && !empty($link['link'])) {
            return '<a href="' . $link['link'] . '">' . display_clean($link['title']) . '</a>';
        }
    }

    /**
     * Fetches all friend requests sent by given user
     *
     * @param : { integer } { $user } { id of user to fetch requests against }
     *
     * @return array : { array } { $data } { array with all sent requests details }
     * @throws Exception
     * @author : Saqib Razzaq
     * @since : 15th April, 2016, ClipBucket 2.8.1
     */
    function sent_contact_requests($user): array
    {
        global $db;
        return $db->select(tbl('contacts'), '*', "userid = $user AND confirmed = 'no'");
    }

    /**
     * Fetches all friend requests recieved by given user
     *
     * @param : { integer } { $user } { id of user to fetch requests against }
     *
     * @return array : { array } { $data } { array with all recieved requests details }
     * @throws Exception
     * @author : Saqib Razzaq
     * @since : 15th April, 2016, ClipBucket 2.8.1
     */
    function recieved_contact_requests($user): array
    {
        global $db;
        return $db->select(tbl('contacts'), '*', "contact_userid = $user AND confirmed = 'no'");
    }

    /**
     * Fetches all friends of given user
     *
     * @param : { integer } { $user } { id of user to fetch friends against }
     *
     * @return array : { array } { $data } { array with all friends details }
     * @throws Exception
     * @author : Saqib Razzaq
     * @since : 15th April, 2016, ClipBucket 2.8.1
     */
    function added_contacts($user): array
    {
        global $db;
        return $db->select(tbl('contacts'), '*', "(contact_userid = $user OR userid = $user) AND confirmed = 'yes'");
    }

    /**
     * Fetches friendship status of two users
     *
     * @param $logged_in_user
     * @param $channel_user
     *
     * @return string : { string } { s = sent, r = recieved, f = friends }
     * @throws Exception
     */
    function friendship_status($logged_in_user, $channel_user): string
    {
        if (!user_id()) {
            return '';
        }
        $sent = $this->sent_contact_requests($logged_in_user);
        $pending = $this->recieved_contact_requests($logged_in_user);
        $friends = $this->added_contacts($logged_in_user);

        foreach ($sent as $key => $data) {
            if ($data['contact_userid'] == $channel_user) {
                return 's'; // sent
            }
        }

        foreach ($pending as $key => $data) {
            if ($data['userid'] == $channel_user) {
                return 'r'; // received
            }
        }

        foreach ($friends as $key => $data) {
            if ($data['contact_userid'] == $channel_user) {
                return 'f'; // friends
            }
        }
        return '';
    }

    function updateUser2FAcheckboxstate($inputUserId, $inputUser2FACheckboxState){
        global $db;
        $db->updateUser2FACheckBoxState(tbl('users'), $inputUserId, $inputUser2FACheckboxState);
    }

    function getStateOf2FAUserCheckbox($inputUserId):bool{
        global $db;
        return $db->getStatusOfUser2FACheckBox(tbl('users'), $inputUserId);
    }

}