");
$c_name = 'usertbl_results';
$default_selected = ['user_joined', 'user_lastvisit', 'user_groups'];
$default_status_selected = ['0'];
$s_name = 'usertbl_status';
$selected_status = [];
$statuses = [];
if (isset($_POST['apply_filter'])) {
// Display Cookie
if (isset($_POST['display']) && is_array($_POST['display'])) {
$selected_display_keys = \defender::sanitize_array(array_keys($_POST['display']));
$cookie_selected = implode(',', $selected_display_keys);
setcookie($c_name, $cookie_selected, time() + (86400 * 30), "/");
} else {
// Prevent cookie tampering and reverted to default result
$cookie_selected = implode(',', $default_selected);
setcookie($c_name, $cookie_selected, time() + (86400 * 30), "/");
}
if (isset($_POST['user_status']) && is_array($_POST['user_status'])) {
$selected_display_keys = \defender::sanitize_array(array_keys($_POST['user_status']));
$status_cookie_selected = implode(',', $selected_display_keys);
setcookie($s_name, $status_cookie_selected, time() + (86400 * 30), "/");
} else {
// Prevent cookie tampering and reverted to default result
$status_cookie_selected = implode(',', $default_status_selected);
setcookie($s_name, $status_cookie_selected, time() + (86400 * 30), "/");
}
} else {
if (!isset($_COOKIE[$c_name])) {
$cookie_selected = implode(',', $default_selected);
setcookie($c_name, $cookie_selected, time() + (86400 * 30), "/");
} else {
$cookie_selected = stripinput($_COOKIE[$c_name]);
}
if (isset($_GET['status']) && isnum($_GET['status']) && $_GET['status'] <= 7) {
$status_cookie_selected = $_GET['status'];
setcookie($s_name, $status_cookie_selected, time() + (86400 * 30), "/");
} else {
if (!isset($_COOKIE[$s_name])) {
$status_cookie_selected = implode(',', $default_status_selected);
setcookie($s_name, $status_cookie_selected, time() + (86400 * 30), "/");
} else {
$status_cookie_selected = stripinput($_COOKIE[$s_name]);
}
}
}
/*
* Sanitize Cookie Input - Select
*/
$usertable_column = array_flip(fieldgenerator(DB_USERS));
unset($usertable_column['user_password']);
unset($usertable_column['user_admin_password']);
unset($usertable_column['user_salt']);
unset($usertable_column['user_algo']);
unset($usertable_column['user_admin_algo']);
unset($usertable_column['user_admin_salt']);
unset($usertable_column['user_status']);
$user_fields = array_map('trim', explode(',', $cookie_selected));
// Sanitize fields
$selected_fields = [];
if (!empty($user_fields)) {
foreach ($user_fields as $field_name) {
if (isset($usertable_column[$field_name])) {
// there we have a verified one.
$selected_fields[$field_name] = $field_name;
}
}
}
/*
* Sanitize Cookie Input - Condition
*/
$user_status = array_map('trim', explode(',', $status_cookie_selected));
if (!empty($user_status)) {
foreach ($user_status as $status) {
if (isnum($status)) {
$selected_status[$status] = $status;
}
}
}
$tLocale = [
'user_hide_email' => self::$locale['ME_420'],
'user_joined' => self::$locale['ME_421'],
'user_lastvisit' => self::$locale['ME_422'],
'user_ip' => self::$locale['ME_423'],
'user_ip_type' => self::$locale['ME_424'],
'user_groups' => self::$locale['ME_425'],
'user_status' => self::$locale['ME_427']
];
$field_checkboxes = [
'user_hide_email' => form_checkbox('display[user_hide_email]', $tLocale['user_hide_email'], (isset($selected_fields['user_hide_email']) ? 1 : 0), ['reverse_label' => TRUE]),
'user_joined' => form_checkbox('display[user_joined]', $tLocale['user_joined'], (isset($selected_fields['user_joined']) ? 1 : 0), ['reverse_label' => TRUE]),
'user_lastvisit' => form_checkbox('display[user_lastvisit]', $tLocale['user_lastvisit'], (isset($selected_fields['user_lastvisit']) ? 1 : 0), ['reverse_label' => TRUE]),
'user_ip' => form_checkbox('display[user_ip]', $tLocale['user_ip'], (isset($selected_fields['user_ip']) ? 1 : 0), ['reverse_label' => TRUE]),
'user_ip_type' => form_checkbox('display[user_ip_type]', $tLocale['user_ip_type'], (isset($selected_fields['user_ip_type']) ? 1 : 0), ['reverse_label' => TRUE]),
'user_groups' => form_checkbox('display[user_groups]', $tLocale['user_groups'], (isset($selected_fields['user_groups']) ? 1 : 0), ['reverse_label' => TRUE]),
];
$extra_checkboxes = [];
$result = dbquery("SELECT field_id, field_name, field_title FROM ".DB_USER_FIELDS." ORDER BY field_cat, field_order ASC");
if (dbrows($result) > 0) {
$data = dbarray($result);
$name = $data['field_name'];
$title = (QuantumFields::is_serialized($data['field_title']) ? QuantumFields::parse_label($data['field_title']) : $data['field_title']);
$tLocale[$name] = $title;
$extra_checkboxes[$name] = form_checkbox("display[".$name."]", $title, (isset($selected_fields[$name]) ? 1 : 0), ['input_id' => 'custom_'.$data['field_id'], 'reverse_label' => TRUE]);
}
$field_status = [];
for ($i = 0; $i < 9; $i++) {
if ($i < 8 || self::$settings['enable_deactivation'] == 1) {
$field_status[$i] = form_checkbox('user_status['.$i.']', getsuspension($i), (isset($selected_status[$i]) ? 1 : 0), ['input_id' => 'user_status_'.$i, 'reverse_label' => TRUE]);
}
}
$search_bind = [];
$search_cond = '';
$field_to_search = array_merge(array_values(['user_name', 'user_id', 'user_email']), array_keys($extra_checkboxes));
if (!empty($_POST['search_text'])) {
$search_text = form_sanitizer($_POST['search_text'], '', 'search_text');
if (!empty($search_text)) {
$search_cond = 'AND (';
$i = 0;
foreach (array_values($field_to_search) as $key) {
$search_cond .= "$key LIKE :text_$i".($i == count($field_to_search) - 1 ? '' : ' OR ');
$search_bind[':text_'.$i] = '%'.$search_text.'%';
$i++;
}
$search_cond .= ')';
}
}
if (!empty($selected_status)) {
$status_cond = " WHERE user_status IN (".implode(',', $selected_status).") ";
$status_bind = [];
foreach ($selected_status as $susp_i) {
$statuses[$susp_i] = $susp_i;//''.getsuspension($susp_i).'';
}
} else {
$status_cond = ' WHERE user_status=:status';
$status_bind = [
':status' => 0,
];
$statuses = [0 => 0];
}
$query_bind = array_merge($status_bind, $search_bind);
$rowCount = dbcount('(user_id)', DB_USERS, ltrim($status_cond, 'WHERE ').$search_cond, $query_bind);
$rowstart = isset($_GET['rowstart']) && isnum($_GET['rowstart']) && $_GET['rowstart'] <= $rowCount ? intval($_GET['rowstart']) : 0;
$limit = 16;
$newrows = 0;
$newrowsCount = 0;
if (in_array(2, $selected_status)) {
$newrowsCount = dbcount('(user_name)', DB_NEW_USERS, '');
$nquery = "SELECT * FROM ".DB_NEW_USERS;
$nresult = dbquery($nquery);
$i = 999999;
while ($data = dbarray($nresult)) {
$newrows++;
$list[$data['user_name']] = [
'user_id' => $i,
'checkbox' => '',
'user_name' => "\n
".display_avatar($data, '35px', '', FALSE, '')."
".$data['user_name']."
".getsuspension(2)."
",
'user_joined' => showdate('longdate', $data['user_datestamp']),
];
$i++;
}
}
$query = "SELECT user_id, user_name, user_avatar, user_email, user_level, user_status ".($cookie_selected ? ', '.$cookie_selected : '')."
FROM ".DB_USERS.$status_cond.$search_cond." LIMIT $rowstart, $limit
";
$result = dbquery($query, $query_bind);
$rows = dbrows($result);
$page_nav = $rowCount > $limit ? makepagenav($rowstart, $limit, $rowCount, 5, FUSION_SELF.fusion_get_aidlink().'&') : '';
$interface = new static();
$list_sum = sprintf(self::$locale['ME_407'], implode(', ', array_map([$interface, 'list_uri'], $statuses)), $rows + $newrows, $rowCount + $newrowsCount);
if ($rows != '0') {
while ($data = dbarray($result)) {
// the key which to be excluded should be unset
$key = array_keys($data);
foreach ($key as $data_key) {
switch ($data_key) {
case 'user_joined':
case 'user_lastvisit':
$data[$data_key] = showdate('shortdate', $data[$data_key]);
break;
case 'user_groups':
if (!empty($data[$data_key])) {
$group = array_filter(explode('.', $data[$data_key]));
$groups = "\n";
$data[$data_key] = $groups;
}
break;
case 'user_hide_email':
$data[$data_key] = $data[$data_key] ? self::$locale['ME_415'] : self::$locale['ME_416'];
break;
}
// custom ones
$list[$data['user_id']][$data_key] = $data[$data_key];
}
$list[$data['user_id']]['checkbox'] = ($data['user_level'] > USER_LEVEL_SUPER_ADMIN) ? form_checkbox('user_id[]', '', '', ['input_id' => 'user_id_'.$data['user_id'], 'value' => $data['user_id']]) : '';
$list[$data['user_id']]['user_name'] = "\n
".display_avatar($data, '35px', '', FALSE, '')."
\n
| ".self::$locale['ME_408']." | ".self::$locale['ME_409']." |
|---|
";
$table_subheader = " | ".self::$locale['ME_410']." | ".self::$locale['ME_411']." | \n".self::$locale['ME_427']." | \n".self::$locale['ME_412']." | ";
foreach ($selected_fields as $column) {
if (!empty($tLocale[$column])) {
$table_subheader .= "".$tLocale[$column]." | \n";
}
}
$table_subheader = "$table_subheader
\n";
$table_footer = "| ".form_checkbox('check_all', self::$locale['ME_414'], '', ['class' => 'm-b-0', 'reverse_label' => TRUE])." | $page_nav |
|---|
\n";
$list_result = "\n| ".self::$locale['ME_405']." | \n
\n";
if (!empty($list)) {
$list_result = '';
foreach ($list as $user_id => $prop) {
$list_result .= call_user_func_array([$interface, 'list_func'], [$user_id, $list, $selected_fields]);
}
}
/*
* User Actions Button
*/
$user_actions = form_button('action', self::$locale['ME_501'], self::USER_REINSTATE, ['class' => 'btn-success m-r-10']).
form_button('action', self::$locale['ME_500'], self::USER_BAN, ['class' => ' btn-default m-r-10']).
form_button('action', self::$locale['ME_502'], self::USER_DEACTIVATE, ['class' => ' btn-default m-r-10']).
form_button('action', self::$locale['ME_503'], self::USER_SUSPEND, ['class' => ' btn-default m-r-10']).
form_button('action', self::$locale['ME_504'], self::USER_SECURITY_BAN, ['class' => ' btn-default m-r-10']).
form_button('action', self::$locale['ME_505'], self::USER_CANCEL, ['class' => ' btn-default m-r-10']).
form_button('action', self::$locale['ME_506'], self::USER_ANON, ['class' => ' btn-default m-r-10']);
$html = openform('member_frm', 'post', FUSION_SELF.fusion_get_aidlink(), ['class' => 'form-inline']);
$html .= form_hidden('aid', '', iAUTH);
$tpl = Template::getInstance('member_listing');
$tpl->set_locale(self::$locale);
$tpl->set_tag('filter_text', form_text('search_text', '', '', [
'placeholder' => self::$locale['ME_401'],
'append' => TRUE,
'append_button' => TRUE,
'append_value' => self::$locale['search'],
'append_form_value' => 'search_member',
'append_button_name' => 'search_member',
'class' => 'm-b-0'
]));
$tpl->set_tag('filter_button', form_button('filter_btn', self::$locale['ME_402'], 'filter_btn', ['icon' => 'caret']));
$tpl->set_tag('action_button', "".self::$locale['ME_403']."");
$tpl->set_tag('filter_status', "".implode("", array_values($field_status))."");
$tpl->set_tag('filter_options', "".implode("", array_values($field_checkboxes))."");
$tpl->set_tag('filter_extras', "".implode("", array_values($extra_checkboxes))."");
$tpl->set_tag('filter_apply_button', form_button('apply_filter', self::$locale['ME_404'], 'apply_filter', ['class' => 'btn-primary']));
$tpl->set_tag('page_count', $list_sum);
$tpl->set_tag('list_head', $table_head);
$tpl->set_tag('list_column', $table_subheader);
$tpl->set_tag('list_result', $list_result);
$tpl->set_tag('list_footer', $table_footer);
$tpl->set_tag('page_nav', $page_nav);
$tpl->set_tag('user_actions', $user_actions);
$tpl->set_text(Members_View::display_members());
$html .= $tpl->get_output();
$html .= closeform();
return (string)$html;
}
/**
* List member link
*
* @param $value
*
* @return string
*/
protected function list_uri($value) {
return !empty(self::$status_uri[$value]) ? "".getsuspension($value)."\n" : '';
}
/**
* Listing formatter for user results
*
* @param $user_id
* @param $list
* @param $selected_fields
*
* @return string
*/
protected static function list_func($user_id, $list, $selected_fields) {
$html = "\n
| \n".$list[$user_id]['checkbox']." | \n
".$list[$user_id]['user_name']." | \n
".$list[$user_id]['user_actions']." | \n
\n".$list[$user_id]['user_level']." | \n
\n".$list[$user_id]['user_status']." | \n
\n".$list[$user_id]['user_email']." | \n";
add_to_jquery('$("#user_id_'.$user_id.'").click(function() {
if ($(this).prop("checked")) {
$("#user-'.$user_id.'").addClass("active");
} else {
$("#user-'.$user_id.'").removeClass("active");
}
});');
foreach ($selected_fields as $column) {
$html .= "".(!empty($list[$user_id][$column]) ? $list[$user_id][$column] : "-")." | \n";
}
$html .= "
\n";
return $html;
}
}