芝麻web文件管理V1.00
编辑当前文件:/home/digitalh/network.digitalhubbd.com/fns/load/blocked.php
['site_users' => 'block_users']])) { $user_id = Registry::load('current_user')->id; $columns = [ 'site_users.user_id', 'site_users.display_name', 'site_users.email_address', 'site_users.username', 'site_users_blacklist.user_blacklist_id', 'site_users.profile_picture' ]; $join["[>]site_users"] = ["site_users_blacklist.blacklisted_user_id" => "user_id"]; $where["site_users_blacklist.user_id"] = $user_id; $where["site_users_blacklist.block"] = 1; if (!empty($data["offset"])) { $data["offset"] = array_map('intval', explode(',', $data["offset"])); $where["site_users_blacklist.user_blacklist_id[!]"] = $data["offset"]; } if (!empty($data["search"])) { $where["AND #search_query"]["OR"] = ["site_users.display_name[~]" => $data["search"], "site_users.username[~]" => $data["search"]]; } $where["LIMIT"] = Registry::load('settings')->records_per_call; if ($data["sortby"] === 'name_asc') { $where["ORDER"] = ["site_users.display_name" => "ASC"]; } else if ($data["sortby"] === 'name_desc') { $where["ORDER"] = ["site_users.display_name" => "DESC"]; } else { $where["ORDER"] = ["site_users.user_id" => "DESC"]; } $site_users = DB::connect()->select('site_users_blacklist', $join, $columns, $where); $i = 1; $output = array(); $output['loaded'] = new stdClass(); $output['loaded']->title = Registry::load('strings')->blocked; $output['loaded']->offset = array(); if (!empty($data["offset"])) { $output['loaded']->offset = $data["offset"]; } $output['sortby'][1] = new stdClass(); $output['sortby'][1]->sortby = Registry::load('strings')->sort_by_default; $output['sortby'][1]->class = 'load_aside'; $output['sortby'][1]->attributes['load'] = 'blocked'; $output['sortby'][2] = new stdClass(); $output['sortby'][2]->sortby = Registry::load('strings')->name; $output['sortby'][2]->class = 'load_aside sort_asc'; $output['sortby'][2]->attributes['load'] = 'blocked'; $output['sortby'][2]->attributes['sort'] = 'name_asc'; $output['sortby'][3] = new stdClass(); $output['sortby'][3]->sortby = Registry::load('strings')->name; $output['sortby'][3]->class = 'load_aside sort_desc'; $output['sortby'][3]->attributes['load'] = 'blocked'; $output['sortby'][3]->attributes['sort'] = 'name_desc'; foreach ($site_users as $user) { $output['loaded']->offset[] = $user['user_blacklist_id']; $output['content'][$i] = new stdClass(); $output['content'][$i]->image = get_img_url(['from' => 'site_users/profile_pics', 'image' => $user['profile_picture'], 'gravatar' => $user['email_address']]); $output['content'][$i]->title = $user['display_name']; $output['content'][$i]->class = "blocked_user"; $output['content'][$i]->icon = 0; $output['content'][$i]->unread = 0; $output['content'][$i]->subtitle = $user['username']; $output['options'][$i][1] = new stdClass(); $output['options'][$i][1]->option = Registry::load('strings')->unblock; $output['options'][$i][1]->class = 'ask_confirmation'; $output['options'][$i][1]->attributes['data-update'] = 'site_user_blacklist'; $output['options'][$i][1]->attributes['data-unblock_user_id'] = $user['user_id']; $output['options'][$i][1]->attributes['confirmation'] = Registry::load('strings')->unblock_user_confirmation; $output['options'][$i][1]->attributes['submit_button'] = Registry::load('strings')->yes; $output['options'][$i][1]->attributes['cancel_button'] = Registry::load('strings')->no; $output['options'][$i][2] = new stdClass(); $output['options'][$i][2]->option = Registry::load('strings')->profile; $output['options'][$i][2]->class = 'get_info'; $output['options'][$i][2]->attributes['user_id'] = $user['user_id']; $i++; } } ?>