User Reminder 1.0.5
Forumsregeln
phpBB 3.0 hat das Ende seiner Lebenszeit überschritten
phpBB 3.0 wird nicht mehr aktiv unterstützt. Insbesondere werden - auch bei Sicherheitslücken - keine Patches mehr bereitgestellt. Der Einsatz von phpBB 3.0 erfolgt daher auf eigene Gefahr. Wir empfehlen einen Umstieg auf die neuste phpBB-Version, welches aktiv weiterentwickelt wird und für welches regelmäßig Updates zur Verfügung gestellt werden.
phpBB 3.0 hat das Ende seiner Lebenszeit überschritten
phpBB 3.0 wird nicht mehr aktiv unterstützt. Insbesondere werden - auch bei Sicherheitslücken - keine Patches mehr bereitgestellt. Der Einsatz von phpBB 3.0 erfolgt daher auf eigene Gefahr. Wir empfehlen einen Umstieg auf die neuste phpBB-Version, welches aktiv weiterentwickelt wird und für welches regelmäßig Updates zur Verfügung gestellt werden.
Re: User Reminder 1.0.5
ja genau sobald ich auf submit drücke werd ich weitergeleitet
Re: User Reminder 1.0.5
kannst du mir mal bitte die includes/acp/acp_user_reminder.php schicken? oder mir zugriff zu deinem board geben?
edit: mal einfach zum testen, hast das bei jedem browser?
edit: mal einfach zum testen, hast das bei jedem browser?
Re: User Reminder 1.0.5
Funktioniert der Mod mittlerweile auch bei phpbb 3.0.5 oder nur bei 3.0.4?
Re: User Reminder 1.0.5
funktioniert bei 305Lunanight hat geschrieben:Funktioniert der Mod mittlerweile auch bei phpbb 3.0.5 oder nur bei 3.0.4?
Re: User Reminder 1.0.5
Code: Alles auswählen
<?php
/**
*
* @package phpBB3
* @version $Id: acp_user_reminder.php 229 2009-05-21 16:25:26Z lefty74 $
* @copyright (c) 2008 lefty74
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/
/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
exit;
}
class acp_user_reminder
{
var $u_action;
function main($id, $mode)
{
global $user, $db, $config, $template;
$user->add_lang(array('mods/acp_user_reminder','acp/users', 'ucp'));
$this->tpl_name = 'acp_user_reminder_userrow';
add_form_key('user_reminder');
$action = request_var('action', '');
$mark = request_var('mark', array(0));
$start = request_var('start', 0);
$excl_user_id_ary = $excl_user_type_ary = $protect_grp_user_ids = array();
//lets exclude the ones the admins have spared
$excl_user_id_ary = explode(',', $config['user_reminder_protected_users']);
if ($config['user_reminder_protected_group'])
{
$sql = 'SELECT user_id
FROM ' . USER_GROUP_TABLE . '
WHERE ' . $db->sql_in_set('group_id', explode(",", $config['user_reminder_protected_group']));
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$protect_grp_user_ids[] = $row['user_id'];
}
$db->sql_freeresult($result);
$excl_user_id_ary = array_unique(array_merge($excl_user_id_ary, $protect_grp_user_ids));
}
//lets exclude the banned users
$sql = 'SELECT ban_userid
FROM ' . BANLIST_TABLE . '
WHERE ban_userid <> 0';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$excl_user_id_ary[] = $row['ban_userid'];
}
$db->sql_freeresult($result);
//lets also exclude the guest user
$excl_user_id_ary[] = ANONYMOUS;
//lets exclude also some user types
$excl_user_type_ary = array(USER_IGNORE, USER_INACTIVE);
switch ($mode)
{
case 'zero_poster':
$title = 'ACP_USER_REMINDER_ZERO_POSTER';
$this->page_title = $user->lang[$title];
$this->zero_poster($excl_user_id_ary, $excl_user_type_ary);
$this->dropdown_action($action, $mark, 'user_reminder_zero_poster');
$this->build_dropdown('user_reminder_zero_poster');
break;
case 'inactive':
$title = 'ACP_USER_REMINDER_INACTIVE';
$this->page_title = $user->lang[$title];
$this->dropdown_action($action, $mark, 'user_reminder_inactive');
$this->build_dropdown('user_reminder_inactive');
$this->inactive($excl_user_id_ary, $excl_user_type_ary);
break;
case 'inactive_still':
$title = 'ACP_USER_REMINDER_INACTIVE_STILL';
$this->page_title = $user->lang[$title];
$this->dropdown_action($action, $mark, 'user_reminder_inactive_still');
$this->build_dropdown('user_reminder_inactive_still');
$this->inactive_still($excl_user_id_ary, $excl_user_type_ary);
break;
case 'not_logged_in':
$title = 'ACP_USER_REMINDER_NOT_LOGGED_IN';
$this->page_title = $user->lang[$title];
$this->dropdown_action($action, $mark, 'user_reminder_not_logged_in');
$this->build_dropdown('user_reminder_not_logged_in');
$this->not_logged_in($excl_user_id_ary, $excl_user_type_ary);
break;
case 'protected_users':
$title = 'ACP_USER_REMINDER_PROTECTED_USERS';
$this->page_title = $user->lang[$title];
$this->dropdown_action($action, $mark, 'user_reminder_protected_users', $protect_grp_user_ids);
$this->build_dropdown('user_reminder_protected_users');
$this->protected_users();
break;
default:
$title = 'ACP_USER_REMINDER_CONFIGURATION';
$this->page_title = $user->lang[$title];
$this->tpl_name = 'acp_user_reminder';
$this->configuration();
break;
}
$template->assign_vars(array(
'USER_REMINDER_VERSION' => $config['urmod_version'],
));
}
function configuration()
{
global $template, $user, $auth, $phpbb_root_path, $phpEx, $config;
$submit = (isset($_POST['submit'])) ? true : false;
$config_user_reminder_row = array(
'user_reminder_enable' => request_var('user_reminder_enable', 0),
'user_reminder_zero_poster_enable' => request_var('user_reminder_zero_poster_enable', 0),
'user_reminder_ignore_no_email' => request_var('user_reminder_ignore_no_email', 0),
'user_reminder_delete_choice' => request_var('user_reminder_delete_choice', 0),
'user_reminder_zero_poster_days' => request_var('user_reminder_zero_poster_days', 0),
'user_reminder_inactive_enable' => request_var('user_reminder_inactive_enable', 0),
'user_reminder_inactive_days' => request_var('user_reminder_inactive_days', 0),
'user_reminder_inactive_still_enable' => request_var('user_reminder_inactive_still_enable', 0),
'user_reminder_inactive_still_days' => request_var('user_reminder_inactive_still_days', 0),
'user_reminder_not_logged_in_enable' => request_var('user_reminder_not_logged_in_enable', 0),
'user_reminder_not_logged_in_days' => request_var('user_reminder_not_logged_in_days', 0),
'user_reminder_inactive_still_opt_zero' => request_var('user_reminder_inactive_still_opt_zero', 0),
'user_reminder_inactive_still_opt_inactive' => request_var('user_reminder_inactive_still_opt_inactive', 0),
'user_reminder_inactive_still_opt_not_logged_in' => request_var('user_reminder_inactive_still_opt_not_logged_in', 0),
'user_reminder_log_opt_script' => request_var('user_reminder_log_opt_script', 0),
'user_reminder_log_opt_users_react' => request_var('user_reminder_log_opt_users_react', 0),
'user_reminder_log_opt_auto_emails' => request_var('user_reminder_log_opt_auto_emails', 0),
'user_reminder_users_per_page' => request_var('user_reminder_users_per_page', 0),
);
$user_reminder_protected_users = request_var('user_reminder_protected_users', '');
$user_reminder_protected_group = request_var('user_reminder_protected_group', array(0));
$user_reminder_bcc_email = strtolower(request_var('user_reminder_bcc_email', ''));
if ($submit)
{
if (!check_form_key('user_reminder'))
{
trigger_error('FORM_INVALID');
}
if ( !function_exists('validate_email'))
{
include($phpbb_root_path . 'includes/functions_user.' . $phpEx);
}
$error = validate_email($user_reminder_bcc_email);
if ($error && $user_reminder_bcc_email)
{
trigger_error($user->lang[$error . '_EMAIL'] . adm_back_link($this->u_action), E_USER_WARNING);
}
else
{
set_config('user_reminder_bcc_email', (string) $user_reminder_bcc_email);
}
foreach ($config_user_reminder_row as $config_name => $config_value)
{
set_config($config_name, (int) $config_value);
}
// ok, in case people put too many spaces after the comma, lets make it simple and remove them all before storage
$user_reminder_protected_users = str_replace(' ', '', $user_reminder_protected_users);
if( strlen(trim($user_reminder_protected_users, ',')) <= 255)
{
set_config('user_reminder_protected_users', (string) trim($user_reminder_protected_users, ','));
}
else
{
trigger_error(sprintf($user->lang['UR_TOO_MANY_CHARS'], strlen(trim($user_reminder_protected_users, ','))) . adm_back_link($this->u_action));
}
set_config('user_reminder_protected_group', (string) implode(",", $user_reminder_protected_group));
add_log('admin', 'LOG_USER_REMINDER_CONFIG_UPDATED');
trigger_error($user->lang['USER_REMINDER_CONFIG_UPDATED'] . adm_back_link($this->u_action));
}
//lets just make the id's look pretty and sort them numerical
$temp_sort_ids = $selected_groups = '';
if ($config['user_reminder_protected_users'])
{
$temp_sort_ids_ary = explode(',', $config['user_reminder_protected_users']);
sort($temp_sort_ids_ary);
$temp_sort_ids = implode(',', $temp_sort_ids_ary);
$temp_sort_ids = ltrim($temp_sort_ids, ',');
}
$selected_groups = explode(",", $config['user_reminder_protected_group']);
$template->assign_vars(array(
'U_ACTION' => $this->u_action,
'USER_REMINDER_ENABLE' => $config['user_reminder_enable'],
'USER_REMINDER_ZERO_POSTER_ENABLE' => $config['user_reminder_zero_poster_enable'],
'USER_REMINDER_IGNORE_NO_EMAIL' => $config['user_reminder_ignore_no_email'],
'USER_REMINDER_PROTECTED_USERS' => str_replace(',', ', ', $temp_sort_ids),
'USER_REMINDER_DELETE_CHOICE' => $config['user_reminder_delete_choice'],
'USER_REMINDER_ZERO_POSTER_DAYS' => $config['user_reminder_zero_poster_days'],
'USER_REMINDER_INACTIVE_ENABLE' => $config['user_reminder_inactive_enable'],
'USER_REMINDER_INACTIVE_DAYS' => $config['user_reminder_inactive_days'],
'USER_REMINDER_INACTIVE_STILL_ENABLE' => $config['user_reminder_inactive_still_enable'],
'USER_REMINDER_INACTIVE_STILL_DAYS' => $config['user_reminder_inactive_still_days'],
'USER_REMINDER_NOT_LOGGED_IN_ENABLE' => $config['user_reminder_not_logged_in_enable'],
'USER_REMINDER_NOT_LOGGED_IN_DAYS' => $config['user_reminder_not_logged_in_days'],
'USER_REMINDER_INACTIVE_STILL_OPT_ZERO' => $config['user_reminder_inactive_still_opt_zero'],
'USER_REMINDER_INACTIVE_STILL_OPT_INACTIVE' => $config['user_reminder_inactive_still_opt_inactive'],
'USER_REMINDER_INACTIVE_STILL_OPT_NOT_LOGGED_IN'=> $config['user_reminder_inactive_still_opt_not_logged_in'],
'USER_REMINDER_LOG_OPT_SCRIPT' => $config['user_reminder_log_opt_script'],
'USER_REMINDER_LOG_OPT_USERS_REACT' => $config['user_reminder_log_opt_users_react'],
'USER_REMINDER_LOG_OPT_AUTO_EMAILS' => $config['user_reminder_log_opt_auto_emails'],
'USER_REMINDER_BCC_EMAIL' => $config['user_reminder_bcc_email'],
'USER_REMINDER_USERS_PER_PAGE' => $config['user_reminder_users_per_page'],
'USER_REMINDER_USERS_PER_PAGE_EXPLAIN' => sprintf($user->lang['USER_REMINDER_USERS_PER_PAGE_EXPLAIN'],$config['topics_per_page']),
'U_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&form=acp_user_reminder&field=user_reminder_protected_users'),
'S_USER_REMINDER_PROTECTED_GROUP' => $this->group_protect_select_options_selected($selected_groups),
'S_CAN_DELETE_USER' => ($auth->acl_get('a_userdel')) ? true : false,
)
);
}
function zero_poster($excl_user_id_ary, $excl_user_type_ary)
{
global $db, $template, $config, $user;
$time = (int) (time() - ($config['user_reminder_zero_poster_days'] * 86400));
$u_sort_param = $sql_choice = $sql_sort = '';
$this->build_choice('user_reminder_zero_poster', $u_sort_param, $sql_choice, $sql_sort);
$no_email_arry = array();
$start = request_var('start', 0);
$sql = 'SELECT COUNT(user_id) AS user_count
FROM ' . USERS_TABLE . '
WHERE ' . $db->sql_in_set('user_id', $excl_user_id_ary, true) . '
AND ' . $db->sql_in_set('user_type', $excl_user_type_ary, true) . "
AND user_posts = 0
AND user_regdate <= {$time}
{$sql_choice}";
$result = $db->sql_query($sql);
$user_count = (int) $db->sql_fetchfield('user_count');
$db->sql_freeresult($result);
$sql = 'SELECT user_id, user_type, user_posts, user_regdate, user_allow_massemail, username, user_colour, user_reminder_zero_poster, user_reminder_inactive, user_reminder_not_logged_in, user_reminder_inactive_still
FROM ' . USERS_TABLE . '
WHERE ' . $db->sql_in_set('user_id', $excl_user_id_ary, true) . '
AND ' . $db->sql_in_set('user_type', $excl_user_type_ary, true) . "
AND user_posts = 0
AND user_regdate <= {$time}
{$sql_choice}
ORDER BY {$sql_sort}";
$result = $db->sql_query_limit($sql, ($config['user_reminder_users_per_page']) ? $config['user_reminder_users_per_page'] : $config['topics_per_page'], $start);
while ($row = $db->sql_fetchrow($result))
{
$registered = (int) (floor((time() - $row['user_regdate']) / 86400));
// $month = floor($registered / 30);
// $day = floor($registered- ($month * 30));
if (!$row['user_allow_massemail'])
{
$no_email_arry[] = $row['user_id'];
}
$template->assign_block_vars('userrow', array(
'USERNAME' => (!$row['user_allow_massemail']) ? get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']) . '<span style="color: red;"> (x)</span>' : get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),
'USER_ID' => $row['user_id'],
// 'USER_ROW' => ( $row['user_regdate'] ) ? sprintf($user->lang['TIME_SPENT'],$month, $day) : '-',
'USER_ROW' => ( $row['user_regdate'] ) ? sprintf($user->lang['TIME_SPENT'],$registered) : '-',
'USER_POSTS' => $row['user_posts'],
'S_IS_ZERO_POSTS' => true,
'USER_REMINDER_ZERO_POSTER' => ($row['user_reminder_zero_poster']) ? $user->format_date(($row['user_reminder_zero_poster']), 'd M Y') : '-',
'USER_REMINDER_INACTIVE' => ($row['user_reminder_inactive']) ? $user->format_date(($row['user_reminder_inactive']), 'd M Y') : '-',
'USER_REMINDER_NOT_LOGGED_IN' => ($row['user_reminder_not_logged_in']) ? $user->format_date(($row['user_reminder_not_logged_in']), 'd M Y') : '-',
'USER_REMINDER_INACTIVE_STILL' => ($row['user_reminder_inactive_still']) ? $user->format_date(($row['user_reminder_inactive_still']), 'd M Y') : '-',
));
}
$db->sql_freeresult($result);
$template->assign_vars(array(
'PAGINATION' => generate_pagination($this->u_action . "&$u_sort_param", $user_count, ($config['user_reminder_users_per_page']) ? $config['user_reminder_users_per_page'] : $config['topics_per_page'], $start, true),
'S_ON_PAGE' => on_page($user_count, ($config['user_reminder_users_per_page']) ? $config['user_reminder_users_per_page'] : $config['topics_per_page'], $start),
'TOTAL_USERS' => ($user_count == 0) ? '' : sprintf($user->lang['TOTAL_USERS'], $user_count, $config['num_users']),
'PERCENTAGE' => ($user_count == 0) ? '' : sprintf($user->lang['TOTAL_USERS_PCT'], (min(100, ($user_count / $config['num_users']) * 100))),
'S_IS_ZERO_POSTS' => true,
'S_IS_RECEIVE_NO_MAILS' => sizeof($no_email_arry) ? true : false,
'L_USER_ROW' => $user->lang['USER_REGDATE'],
'L_SUBTITLE' => $user->lang['ZERO_POSTS_TITLE'],
'L_SUBTITLE_EXPLAIN' => sprintf($user->lang['ZERO_POSTS_TITLE_EXPLAIN'],$config['user_reminder_zero_poster_days']),
));
}
function inactive($excl_user_id_ary, $excl_user_type_ary)
{
global $db, $template, $config, $user;
$time = (int) (time() - ($config['user_reminder_inactive_days'] * 86400));
$u_sort_param = $sql_choice = $sql_sort = '';
$this->build_choice('user_reminder_inactive',$u_sort_param, $sql_choice, $sql_sort);
$no_email_arry = $user_list_ary = array();
$start = request_var('start', 0);
$sql_array = array(
'SELECT' => 'u.user_id, u.user_lastvisit, MAX(s.session_time) AS session_time',
'FROM' => array(
USERS_TABLE => 'u'
),
'LEFT_JOIN' => array(
array(
'FROM' => array(SESSIONS_TABLE => 's'),
'ON' => 's.session_user_id = u.user_id'
)
),
'WHERE' => $db->sql_in_set('u.user_id', $excl_user_id_ary, true) . '
AND ' . $db->sql_in_set('u.user_type', $excl_user_type_ary, true) . "
AND (u.user_lastvisit < $time OR session_time < $time )
$sql_choice",
'GROUP_BY' => 'u.user_id, u.user_lastvisit'
);
$sql = $db->sql_build_query('SELECT', $sql_array);
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
if( max($row['session_time'], $row['user_lastvisit']) < (int) $time && ($row['user_lastvisit'] <> 0 && !$row['session_time']))
{
$user_list_ary[] = $row['user_id'];
}
}
$db->sql_freeresult($result);
$user_count = sizeof($user_list_ary);
if($user_count)
{
$sql_array = array(
'SELECT' => 'u.user_id, u.user_posts, u.user_type, u.user_lastvisit, u.user_allow_massemail, u.username, u.user_colour, u.user_reminder_zero_poster, u.user_reminder_inactive, u.user_reminder_not_logged_in, u.user_reminder_inactive_still, MAX(s.session_time) AS session_time',
'FROM' => array(
USERS_TABLE => 'u'
),
'LEFT_JOIN' => array(
array(
'FROM' => array(SESSIONS_TABLE => 's'),
'ON' => 's.session_user_id = u.user_id'
)
),
'WHERE' => $db->sql_in_set('u.user_id', $user_list_ary, false),
'GROUP_BY' => 'u.user_id, u.user_posts, u.user_type, u.user_lastvisit, u.user_allow_massemail, u.username, u.user_colour, u.user_reminder_zero_poster, u.user_reminder_inactive, u.user_reminder_not_logged_in, u.user_reminder_inactive_still',
'ORDER_BY' => "u.{$sql_sort}"
);
$sql = $db->sql_build_query('SELECT', $sql_array);
$result = $db->sql_query_limit($sql, ($config['user_reminder_users_per_page']) ? $config['user_reminder_users_per_page'] : $config['topics_per_page'], $start);
while ($row = $db->sql_fetchrow($result))
{
$lastvisit = (int) (floor((time() - max($row['session_time'], $row['user_lastvisit'])) / 86400));
if (!$row['user_allow_massemail'])
{
$no_email_arry[] = $row['user_id'];
}
$user_name_row = get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']);
// lets add the users post count to the name
$user_name_row .= ' (' . $row['user_posts'] . ')';
// user does not want admins to send emails to them, lets mark that user
$user_name_row .= (!$row['user_allow_massemail']) ? '<span style="color: red;"> (x)</span>' : '';
$template->assign_block_vars('userrow', array(
'USERNAME' => $user_name_row,
'USER_ID' => $row['user_id'],
'USER_ROW' => ( $row['user_lastvisit'] ) ? sprintf($user->lang['TIME_SPENT'],$lastvisit) : '-',
'USER_REMINDER_ZERO_POSTER' => ($row['user_reminder_zero_poster']) ? $user->format_date(($row['user_reminder_zero_poster']), 'd M Y') : '-',
'USER_REMINDER_INACTIVE' => ($row['user_reminder_inactive']) ? $user->format_date(($row['user_reminder_inactive']), 'd M Y') : '-',
'USER_REMINDER_NOT_LOGGED_IN' => ($row['user_reminder_not_logged_in']) ? $user->format_date(($row['user_reminder_not_logged_in']), 'd M Y') : '-',
'USER_REMINDER_INACTIVE_STILL' => ($row['user_reminder_inactive_still']) ? $user->format_date(($row['user_reminder_inactive_still']), 'd M Y') : '-',
));
}
$db->sql_freeresult($result);
}
$template->assign_vars(array(
'PAGINATION' => generate_pagination($this->u_action . "&$u_sort_param", $user_count, ($config['user_reminder_users_per_page']) ? $config['user_reminder_users_per_page'] : $config['topics_per_page'], $start, true),
'S_ON_PAGE' => on_page($user_count, ($config['user_reminder_users_per_page']) ? $config['user_reminder_users_per_page'] : $config['topics_per_page'], $start),
'TOTAL_USERS' => ($user_count == 0) ? '' : sprintf($user->lang['TOTAL_USERS'], $user_count, $config['num_users']),
'PERCENTAGE' => ($user_count == 0) ? '' : sprintf($user->lang['TOTAL_USERS_PCT'], (min(100, ($user_count / $config['num_users']) * 100))),
'S_IS_RECEIVE_NO_MAILS' => sizeof($no_email_arry) ? true : false,
'L_USER_ROW' => $user->lang['USER_LASTVISIT'],
'L_SUBTITLE' => $user->lang['INACTIVE_TITLE'],
'L_SUBTITLE_EXPLAIN' => sprintf($user->lang['INACTIVE_TITLE_EXPLAIN'],$config['user_reminder_inactive_days']),
)
);
}
function not_logged_in($excl_user_id_ary, $excl_user_type_ary)
{
global $db, $template, $user, $config;
$time = (int) (time() - ($config['user_reminder_not_logged_in_days'] * 86400));
$u_sort_param = $sql_choice = $sql_sort = '';
$this->build_choice('user_reminder_not_logged_in',$u_sort_param, $sql_choice, $sql_sort);
$no_email_arry = $user_list_ary = array();
$start = request_var('start', 0);
$sql_array = array(
'SELECT' => 'u.user_id, MAX(s.session_time) AS session_time',
'FROM' => array(
USERS_TABLE => 'u'
),
'LEFT_JOIN' => array(
array(
'FROM' => array(SESSIONS_TABLE => 's'),
'ON' => 's.session_user_id = u.user_id'
)
),
'WHERE' => $db->sql_in_set('u.user_id', $excl_user_id_ary, true) . '
AND ' . $db->sql_in_set('u.user_type', $excl_user_type_ary, true) . "
AND u.user_lastvisit = 0
AND u.user_regdate <= $time
$sql_choice",
'GROUP_BY' => 'u.user_id'
);
$sql = $db->sql_build_query('SELECT', $sql_array);
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$user_list_ary[] = $row['user_id'];
}
$db->sql_freeresult($result);
$user_count = sizeof($user_list_ary);
if($user_count)
{
$sql_array = array(
'SELECT' => 'u.user_id, u.user_type, u.user_lastvisit, u.user_regdate, u.user_allow_massemail, u.username, u.user_colour, u.user_reminder_zero_poster, u.user_reminder_inactive, u.user_reminder_not_logged_in, u.user_reminder_inactive_still, MAX(s.session_time) AS session_time',
'FROM' => array(
USERS_TABLE => 'u'
),
'LEFT_JOIN' => array(
array(
'FROM' => array(SESSIONS_TABLE => 's'),
'ON' => 's.session_user_id = u.user_id'
)
),
'WHERE' => $db->sql_in_set('u.user_id', $user_list_ary),
'GROUP_BY' => 'u.user_id, u.user_type, u.user_lastvisit, u.user_regdate, u.user_allow_massemail, u.username, u.user_colour, u.user_reminder_zero_poster, u.user_reminder_inactive, u.user_reminder_not_logged_in, u.user_reminder_inactive_still',
'ORDER_BY' => "u.{$sql_sort}"
);
$sql = $db->sql_build_query('SELECT', $sql_array);
$result = $db->sql_query_limit($sql, ($config['user_reminder_users_per_page']) ? $config['user_reminder_users_per_page'] : $config['topics_per_page'], $start);
while ($row = $db->sql_fetchrow($result))
{
if (!$row['session_time'])
{
$lastvisit = (int) (floor((time() - $row['user_regdate']) / 86400));
if (!$row['user_allow_massemail'])
{
$no_email_arry[] = $row['user_id'];
}
$template->assign_block_vars('userrow', array(
'USERNAME' => (!$row['user_allow_massemail']) ? get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']) . '<span style="color: red;"> (x)</span>' : get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),
'USER_ID' => $row['user_id'],
'USER_ROW' => ( $row['user_regdate'] ) ? sprintf($user->lang['TIME_SPENT'], $lastvisit) : '-',
'USER_REMINDER_ZERO_POSTER' => ($row['user_reminder_zero_poster']) ? $user->format_date(($row['user_reminder_zero_poster']), 'd M Y') : '-',
'USER_REMINDER_INACTIVE' => ($row['user_reminder_inactive']) ? $user->format_date(($row['user_reminder_inactive']), 'd M Y') : '-',
'USER_REMINDER_NOT_LOGGED_IN' => ($row['user_reminder_not_logged_in']) ? $user->format_date(($row['user_reminder_not_logged_in']), 'd M Y') : '-',
'USER_REMINDER_INACTIVE_STILL' => ($row['user_reminder_inactive_still']) ? $user->format_date(($row['user_reminder_inactive_still']), 'd M Y') : '-',
));
}
}
$db->sql_freeresult($result);
}
$template->assign_vars(array(
'PAGINATION' => generate_pagination($this->u_action . "&$u_sort_param", $user_count, ($config['user_reminder_users_per_page']) ? $config['user_reminder_users_per_page'] : $config['topics_per_page'], $start, true),
'S_ON_PAGE' => on_page($user_count, ($config['user_reminder_users_per_page']) ? $config['user_reminder_users_per_page'] : $config['topics_per_page'], $start),
'TOTAL_USERS' => ($user_count == 0) ? '' : sprintf($user->lang['TOTAL_USERS'], $user_count, $config['num_users']),
'PERCENTAGE' => ($user_count == 0) ? '' : sprintf($user->lang['TOTAL_USERS_PCT'], (min(100, ($user_count / $config['num_users']) * 100))),
'S_IS_RECEIVE_NO_MAILS' => sizeof($no_email_arry) ? true : false,
'L_USER_ROW' => $user->lang['USER_REGDATE'],
'L_SUBTITLE' => $user->lang['NOT_LOGGED_IN_TITLE'],
'L_SUBTITLE_EXPLAIN' => $user->lang['NOT_LOGGED_IN_TITLE_EXPLAIN'],
)
);
}
function inactive_still($excl_user_id_ary, $excl_user_type_ary)
{
global $db, $template, $config, $user;
$time = (int) (time() - ($config['user_reminder_inactive_still_days'] * 86400));
$u_sort_param = $sql_choice = $sql_sort = '';
$this->build_choice('user_reminder_inactive_still',$u_sort_param, $sql_choice, $sql_sort);
$no_email_arry = $user_list_ary = array();
$and_choice = '';
if ( ($config['user_reminder_inactive_still_opt_zero'] && $config['user_reminder_inactive_still_opt_inactive'] && $config['user_reminder_inactive_still_opt_not_logged_in']) || (!$config['user_reminder_inactive_still_opt_zero'] && !$config['user_reminder_inactive_still_opt_inactive'] && !$config['user_reminder_inactive_still_opt_not_logged_in']) )
{
$and_choice = '(user_reminder_zero_poster < ' . $time . ' AND user_reminder_zero_poster > 0) OR (user_reminder_inactive > 0 AND user_reminder_inactive < ' . (int)$time . ') OR (user_reminder_not_logged_in > 0 AND user_reminder_not_logged_in < ' . $time . ')';
}
else
{
$and_choice = ($config['user_reminder_inactive_still_opt_zero']) ? '(user_reminder_zero_poster < ' . $time . ' AND user_reminder_zero_poster > 0)' : '';
$and_choice .= ($config['user_reminder_inactive_still_opt_inactive']) ? (($and_choice != '') ? ' OR ' : '') . '(user_reminder_inactive > 0 AND user_reminder_inactive < ' . $time . ')' : '';
$and_choice .= ($config['user_reminder_inactive_still_opt_not_logged_in']) ? (($and_choice != '') ? ' OR ' : '') . '(user_reminder_not_logged_in > 0 AND user_reminder_not_logged_in < ' . $time . ')' : '';
}
$start = request_var('start', 0);
$sql = 'SELECT user_id
FROM ' . USERS_TABLE . '
WHERE ' . $db->sql_in_set('user_id', $excl_user_id_ary, true) . '
AND ' . $db->sql_in_set('user_type', $excl_user_type_ary, true) .
$sql_choice . "
AND ( $and_choice )
ORDER BY {$sql_sort}";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$user_list_ary[] = $row['user_id'];
}
$db->sql_freeresult($result);
$user_count = sizeof($user_list_ary);
if($user_count)
{
$sql = 'SELECT user_id, user_posts, user_reminder_zero_poster, user_reminder_inactive, user_reminder_not_logged_in, user_id, user_type, user_lastvisit, user_allow_massemail, username, user_colour, user_reminder_inactive_still
FROM ' . USERS_TABLE . '
WHERE ' . $db->sql_in_set('user_id', $user_list_ary) . "
ORDER BY {$sql_sort}";
$result = $db->sql_query_limit($sql, ($config['user_reminder_users_per_page']) ? $config['user_reminder_users_per_page'] : $config['topics_per_page'], $start);
while ($row = $db->sql_fetchrow($result))
{
$lastvisit = (int) (floor(( time() - $row['user_lastvisit']) / 86400));
if (!$row['user_allow_massemail'])
{
$no_email_arry[] = $row['user_id'];
}
$user_name_row = get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']);
// lets add the users post count to the name
$user_name_row .= ' (' . $row['user_posts'] . ')';
// user does not want admins to send emails to them, lets mark that user
$user_name_row .= (!$row['user_allow_massemail']) ? '<span style="color: red;"> (x)</span>' : '';
$template->assign_block_vars('userrow', array(
'USERNAME' => $user_name_row,
'USER_ROW' => ( $row['user_lastvisit'] ) ? sprintf($user->lang['TIME_SPENT'],$lastvisit) : '-',
'USER_ID' => $row['user_id'],
'USER_REMINDER_ZERO_POSTER' => ($row['user_reminder_zero_poster']) ? $user->format_date(($row['user_reminder_zero_poster']), 'd M Y') : '-',
'USER_REMINDER_INACTIVE' => ($row['user_reminder_inactive']) ? $user->format_date(($row['user_reminder_inactive']), 'd M Y') : '-',
'USER_REMINDER_NOT_LOGGED_IN' => ($row['user_reminder_not_logged_in']) ? $user->format_date(($row['user_reminder_not_logged_in']), 'd M Y') : '-',
'USER_REMINDER_INACTIVE_STILL' => ($row['user_reminder_inactive_still']) ? $user->format_date(($row['user_reminder_inactive_still']), 'd M Y') : '-',
));
}
$db->sql_freeresult($result);
}
$template->assign_vars(array(
'PAGINATION' => generate_pagination($this->u_action . "&$u_sort_param", $user_count, ($config['user_reminder_users_per_page']) ? $config['user_reminder_users_per_page'] : $config['topics_per_page'], $start, true),
'S_ON_PAGE' => on_page($user_count, ($config['user_reminder_users_per_page']) ? $config['user_reminder_users_per_page'] : $config['topics_per_page'], $start),
'TOTAL_USERS' => ($user_count == 0) ? '' : sprintf($user->lang['TOTAL_USERS'], $user_count, $config['num_users']),
'PERCENTAGE' => ($user_count == 0) ? '' : sprintf($user->lang['TOTAL_USERS_PCT'], (min(100, ($user_count / $config['num_users']) * 100))),
'S_IS_RECEIVE_NO_MAILS' => sizeof($no_email_arry) ? true : false,
'L_USER_ROW' => $user->lang['USER_LASTVISIT'],
'L_SUBTITLE' => $user->lang['INACTIVE_STILL_TITLE'],
'L_SUBTITLE_EXPLAIN' => sprintf($user->lang['INACTIVE_STILL_TITLE_EXPLAIN'], $config['user_reminder_inactive_still_days']),
)
);
}
function protected_users()
{
global $db, $template, $config, $user;
$user_name_row = '';
$protected_in_group_ary = $protected_users_ids = $protected_grp_ids = $protected_grp_user_ids = $no_email_arry = array();
$protected_users_ids = ($config['user_reminder_protected_users']) ? explode(",", $config['user_reminder_protected_users']) : array();
$start = request_var('start', 0);
if ($config['user_reminder_protected_group'])
{
$sql = 'SELECT user_id
FROM ' . USER_GROUP_TABLE . '
WHERE ' . $db->sql_in_set('group_id', explode(",", $config['user_reminder_protected_group']));
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$protected_grp_user_ids[] = $row['user_id'];
}
$db->sql_freeresult($result);
$protected_users_ids = array_unique(array_merge($protected_users_ids, $protected_grp_user_ids));
}
$user_count = sizeof($protected_users_ids);
if ($user_count)
{
// lets flip the array to find values instead of using in_array
$protected_grp_user_ids = array_flip($protected_grp_user_ids);
$sql = 'SELECT user_id, user_lastvisit, user_allow_massemail, username, user_colour ,user_reminder_zero_poster, user_reminder_inactive, user_reminder_not_logged_in, user_reminder_inactive_still
FROM ' . USERS_TABLE . '
WHERE ' . $db->sql_in_set('user_id', $protected_users_ids) . '
ORDER BY username ASC';
$result = $db->sql_query_limit($sql, ($config['user_reminder_users_per_page']) ? $config['user_reminder_users_per_page'] : $config['topics_per_page'], $start);
while ($row = $db->sql_fetchrow($result))
{
$lastvisit = (int) (floor((time() - $row['user_lastvisit']) / 86400));
if (!$row['user_allow_massemail'])
{
$no_email_arry[] = $row['user_id'];
}
$user_name_row = get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']);
// user does not want admins to send emails to them, lets mark that user
$user_name_row .= (!$row['user_allow_massemail']) ? '<span style="color: red;"> (x)</span>' : '';
// user is in a protected user group, lets mark that too
if(isset($protected_grp_user_ids[$row['user_id']]))
{
$user_name_row .= '<span style="color: purple;"> [x]</span>';
// lets just store the id in an array so that we know if any users are in protected groups
$protected_in_group_ary[] = $row['user_id'];
}
$template->assign_block_vars('userrow', array(
'USERNAME' => $user_name_row,
'USER_ROW' => ( $row['user_lastvisit'] ) ? sprintf($user->lang['TIME_SPENT'],$lastvisit) : '-',
'USER_ID' => $row['user_id'],
'USER_REMINDER_ZERO_POSTER' => ($row['user_reminder_zero_poster']) ? $user->format_date(($row['user_reminder_zero_poster']), 'd M Y') : '-',
'USER_REMINDER_INACTIVE' => ($row['user_reminder_inactive']) ? $user->format_date(($row['user_reminder_inactive']), 'd M Y') : '-',
'USER_REMINDER_NOT_LOGGED_IN' => ($row['user_reminder_not_logged_in']) ? $user->format_date(($row['user_reminder_not_logged_in']), 'd M Y') : '-',
'USER_REMINDER_INACTIVE_STILL' => ($row['user_reminder_inactive_still']) ? $user->format_date(($row['user_reminder_inactive_still']), 'd M Y') : '-',
));
}
$db->sql_freeresult($result);
}
$template->assign_vars(array(
'PAGINATION' => generate_pagination($this->u_action, $user_count, ($config['user_reminder_users_per_page']) ? $config['user_reminder_users_per_page'] : $config['topics_per_page'], $start, true),
'S_ON_PAGE' => on_page($user_count, ($config['user_reminder_users_per_page']) ? $config['user_reminder_users_per_page'] : $config['topics_per_page'], $start),
'TOTAL_USERS' => ($user_count == 0) ? '' : sprintf($user->lang['TOTAL_USERS'], $user_count, $config['num_users']),
'PERCENTAGE' => ($user_count == 0) ? '' : sprintf($user->lang['TOTAL_USERS_PCT'], (min(100, ($user_count / $config['num_users']) * 100))),
'S_IS_RECEIVE_NO_MAILS' => sizeof($no_email_arry) ? true : false,
'S_IS_USERS_IN_GROUP' => sizeof($protected_in_group_ary) ? true : false,
'S_IS_PROTECTED_USERS' => true,
'L_USER_ROW' => $user->lang['USER_LASTVISIT'],
'L_SUBTITLE' => $user->lang['PROTECTED_USERS_TITLE'],
'L_SUBTITLE_EXPLAIN' => $user->lang['PROTECTED_USERS_TITLE_EXPLAIN'],
)
);
}
function dropdown_action($action, $mark, $case, $protect_grp_user_ids = false)
{
global $user, $auth, $phpbb_root_path, $db, $phpEx, $config;
if ($case == 'user_reminder_protected_users')
{
switch ($action)
{
case $case:
if (sizeof($mark))
{
if (confirm_box(true))
{
$protected_user_ids = $new_protected_user_ids_ary = $new_mark = array();
$new_protected_user_ids = '';
//before we start, lets take out the users that are in a protected group
$new_mark = array_diff($mark, $protect_grp_user_ids);
//here we do a bit of putting current protected users in an array, take out the ones from the $new_mark array and save it
$protected_user_ids = explode(',', $config['user_reminder_protected_users']);
$new_protected_user_ids_ary = array_diff($protected_user_ids, $new_mark);
$new_protected_user_ids = implode(',', $new_protected_user_ids_ary);
set_config('user_reminder_protected_users', (string) ltrim($new_protected_user_ids, ','));
if (sizeof($new_mark))
{
$sql_id = ' IN (' . implode(', ', $new_mark) . ')';
$sql = 'SELECT user_id, username_clean
FROM ' . USERS_TABLE . "
WHERE user_id $sql_id";
$result = $db->sql_query($sql);
$user_id_ary = $username_ary = $user_list_ary = array();
while ($row = $db->sql_fetchrow($result))
{
$user_id_ary[] = (int) $row['user_id'];
$username_ary[] = (string) $row['username_clean'];
}
$db->sql_freeresult($result);
add_log('admin', 'LOG_USER_UNPROTECTED', implode(', ', $username_ary));
trigger_error($user->lang['USER_UPDATED'] . adm_back_link($this->u_action));
}
else
{
trigger_error($user->lang['NO_USER_UNPROTECTED'] . adm_back_link($this->u_action), E_USER_WARNING);
}
}
else
{
confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(
'mark' => $mark,
'action' => $action))
);
}
}
break;
case 'user_delete':
// lets just be sure that only an admin with user delete rights is here
if ( !$auth->acl_get('a_userdel'))
{
trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
}
if ( !function_exists('user_delete'))
{
include($phpbb_root_path . 'includes/functions_user.' . $phpEx);
}
if (sizeof($mark))
{
if (confirm_box(true))
{
$email_delete = request_var('email_delete', 0);
$sql_id = ' IN (' . implode(', ', $mark) . ')';
$sql = 'SELECT user_id, user_type, username_clean, username, user_allow_massemail, user_email, user_notify_type, user_jabber, user_lang
FROM ' . USERS_TABLE . "
WHERE user_id $sql_id";
$result = $db->sql_query($sql);
$username_ary = $username_neg_ary = $user_list_ary = array();
$delete_type = ($config['user_reminder_delete_choice'] == RETAIN_POSTS) ? 'retain' : 'remove';
while ($row = $db->sql_fetchrow($result))
{
// Some basic rules, you can't delete a founder, the guest user(should not happen anyway but better be sure) or yourself ;P
if ($row['user_type'] != USER_FOUNDER || ($row['user_id'] != (ANONYMOUS || $user->data['user_id'])) )
{
$username_ary[] = (string) $row['username_clean'];
user_delete($delete_type, $row['user_id'], $row['username']);
if ($email_delete && ($row['user_allow_massemail'] || $config['user_reminder_ignore_no_email'] == OVERRIDE) && trim($row['user_email']))
{
$user_list_ary[] = array(
'method' => $row['user_notify_type'],
'email' => $row['user_email'],
'jabber' => $row['user_jabber'],
'name' => $row['username'],
'lang' => $row['user_lang']
);
}
}
else
{
$username_neg_ary[] = (string) $row['username_clean'];
}
}
$db->sql_freeresult($result);
if (sizeof($username_ary))
{
if(!function_exists('send_reminder_emails'))
{
include($phpbb_root_path . 'includes/functions_user_reminder.' . $phpEx);
}
send_reminder_emails($user_list_ary, 'user_reminder_delete_notify');
$message = $user->lang['USERS_DELETED'];
$message .= sizeof($username_neg_ary) ? '<br />' . sprintf($user->lang['ERROR_USERS_DELETED'], implode(', ', $username_neg_ary)) : '';
add_log('admin', 'LOG_USER_DELETED', implode(', ', $username_ary));
trigger_error($message . adm_back_link($this->u_action));
}
else
{
trigger_error((sprintf($user->lang['ERROR_USERS_DELETED'], implode(', ', $username_neg_ary))) . adm_back_link($this->u_action), E_USER_WARNING);
}
}
else
{
$message = $user->lang['DELETE_USER_CONFIRM_OPERATION'];
$message .= $user->lang['CONFIRM_OPERATION'];
confirm_box(false, $message, build_hidden_fields(array(
'mark' => $mark,
'action' => $action)), 'confirm_body_user_reminder_delete.html'
);
}
}
break;
case 'clear_reminders':
if (sizeof($mark))
{
if (confirm_box(true))
{
$sql_id = ' IN (' . implode(', ', $mark) . ')';
$sql = 'SELECT user_id, username_clean
FROM ' . USERS_TABLE . "
WHERE user_id $sql_id";
$result = $db->sql_query($sql);
$user_id_ary = array();
while ($row = $db->sql_fetchrow($result))
{
$user_id_ary[] = (int) $row['user_id'];
$username_ary[] = (string) $row['username_clean'];
}
$db->sql_freeresult($result);
$db->sql_transaction('begin');
$sql_ary = array(
'user_reminder_inactive' => 0,
'user_reminder_zero_poster' => 0,
'user_reminder_not_logged_in' => 0,
'user_reminder_inactive_still' => 0,
);
$sql = 'UPDATE ' . USERS_TABLE . '
SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "
WHERE user_id $sql_id";
$db->sql_query($sql);
$db->sql_transaction('commit');
add_log('admin', 'LOG_USER_REMINDER_CLEARED', implode(', ', $username_ary));
trigger_error($user->lang['USER_UPDATED'] . adm_back_link($this->u_action));
}
else
{
confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(
'mark' => $mark,
'action' => $action))
);
}
}
break;
}
}
else
{
switch ($action)
{
case (string) $case:
if (sizeof($mark))
{
if (confirm_box(true))
{
$sql_id = ' IN (' . implode(', ', $mark) . ')';
$sql = 'SELECT user_id, user_allow_massemail, username_clean, user_notify_type, user_email, user_jabber, username, user_lang
FROM ' . USERS_TABLE . "
WHERE user_id $sql_id";
$result = $db->sql_query($sql);
$user_id_ary = $username_ary = $user_list_ary = array();
while ($row = $db->sql_fetchrow($result))
{
if($row['user_allow_massemail'] || $config['user_reminder_ignore_no_email'] == OVERRIDE)
{
$user_id_ary[] = (int) $row['user_id'];
$username_ary[] = (string) $row['username_clean'];
if (trim($row['user_email']))
{
$user_list_ary[] = array(
'method' => $row['user_notify_type'],
'email' => $row['user_email'],
'jabber' => $row['user_jabber'],
'name' => $row['username'],
'lang' => $row['user_lang']
);
}
}
}
$db->sql_freeresult($result);
$db->sql_transaction('begin');
if (sizeof($user_list_ary))
{
$sql_id = ' IN (' . implode(', ', $user_id_ary) . ')';
$sql_ary = array(
(string) $case => (int) time(),
);
$sql = 'UPDATE ' . USERS_TABLE . '
SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "
WHERE user_id $sql_id";
$db->sql_query($sql);
$db->sql_transaction('commit');
if(!function_exists('send_reminder_emails'))
{
include($phpbb_root_path . 'includes/functions_user_reminder.' . $phpEx);
}
send_reminder_emails($user_list_ary, (string) $case);
add_log('admin', 'LOG_' . strtoupper($case), implode(', ', $username_ary));
trigger_error($user->lang['USER_UPDATED'] . adm_back_link($this->u_action));
}
else
{
trigger_error($user->lang['ERROR_USER_UPDATED'] . adm_back_link($this->u_action), E_USER_WARNING);
}
}
else
{
// lets check if we want to carry out an action that has previously been done already and make sure the admin is aware of this
$sql_id = ' IN (' . implode(', ', $mark) . ')';
$sql = 'SELECT user_id, username, user_allow_massemail, ' . (string) $case . '
FROM ' . USERS_TABLE . "
WHERE user_id $sql_id
AND ($case > 0 OR user_allow_massemail = 0)";
$result = $db->sql_query($sql);
$no_emails_ary = $already_emailed_ary = array();
while ($row = $db->sql_fetchrow($result))
{
if(!$row['user_allow_massemail'] && $config['user_reminder_ignore_no_email'] != OVERRIDE)
{
$no_emails_ary[] = $row['username'];
}
elseif($row['' . (string) $case . ''])
{
$already_emailed_ary[] = $row['user_id'];
}
}
$db->sql_freeresult($result);
$lang_confirm = (sizeof($already_emailed_ary)) ? $user->lang['ERROR_EMAIL_CONFIRM_OPERATION'] : '';
$lang_confirm .= (sizeof($no_emails_ary)) ? $user->lang['ERROR_NOEMAIL_CONFIRM_OPERATION'] : '';
$lang_confirm .= $user->lang['CONFIRM_OPERATION'];
confirm_box(false, $lang_confirm, build_hidden_fields(array(
'mark' => $mark,
'action' => $action))
);
}
}
break;
case $case . '_clear':
if (sizeof($mark))
{
if (confirm_box(true))
{
$sql_id = ' IN (' . implode(', ', $mark) . ')';
$sql = 'SELECT user_id, username_clean
FROM ' . USERS_TABLE . "
WHERE user_id $sql_id";
$result = $db->sql_query($sql);
$user_id_ary = array();
while ($row = $db->sql_fetchrow($result))
{
$user_id_ary[] = (int) $row['user_id'];
$username_ary[] = (string) $row['username_clean'];
}
$db->sql_freeresult($result);
$db->sql_transaction('begin');
$sql_ary = array(
$case => 0,
);
$sql = 'UPDATE ' . USERS_TABLE . '
SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "
WHERE user_id $sql_id";
$db->sql_query($sql);
$db->sql_transaction('commit');
add_log('admin', 'LOG_' . strtoupper($case) . '_CLEAR', implode(', ', $username_ary));
trigger_error($user->lang['USER_UPDATED'] . adm_back_link($this->u_action));
}
else
{
confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(
'mark' => $mark,
'action' => $action))
);
}
}
break;
case 'user_delete':
// lets just be sure that only an admin with user delete rights is here
if ( !$auth->acl_get('a_userdel'))
{
trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
}
if ( !function_exists('user_delete'))
{
include($phpbb_root_path . 'includes/functions_user.' . $phpEx);
}
if (sizeof($mark))
{
if (confirm_box(true))
{
$email_delete = request_var('email_delete', 0);
$sql_id = ' IN (' . implode(', ', $mark) . ')';
$sql = 'SELECT user_id, user_type, username_clean, username, user_allow_massemail, user_notify_type, user_jabber, user_lang, user_email
FROM ' . USERS_TABLE . "
WHERE user_id $sql_id";
$result = $db->sql_query($sql);
$username_ary = $username_neg_ary = $user_list_ary = array();
$delete_type = ($config['user_reminder_delete_choice'] == RETAIN_POSTS) ? 'retain' : 'remove';
while ($row = $db->sql_fetchrow($result))
{
// Some basic rules, you can't delete a founder, the guest user(should not happen anyway but better be sure) or yourself ;P
if ($row['user_type'] != USER_FOUNDER || ($row['user_id'] != (ANONYMOUS || $user->data['user_id'])) )
{
$username_ary[] = (string) $row['username_clean'];
user_delete($delete_type, $row['user_id'], $row['username']);
if ($email_delete && ($row['user_allow_massemail'] || $config['user_reminder_ignore_no_email'] == OVERRIDE) && trim($row['user_email']))
{
$user_list_ary[] = array(
'method' => $row['user_notify_type'],
'email' => $row['user_email'],
'jabber' => $row['user_jabber'],
'name' => $row['username'],
'lang' => $row['user_lang']
);
}
}
else
{
$username_neg_ary[] = (string) $row['username_clean'];
}
}
$db->sql_freeresult($result);
if (sizeof($username_ary))
{
if(!function_exists('send_reminder_emails'))
{
include($phpbb_root_path . 'includes/functions_user_reminder.' . $phpEx);
}
send_reminder_emails($user_list_ary, 'user_reminder_delete_notify');
$message = $user->lang['USERS_DELETED'];
$message .= sizeof($username_neg_ary) ? '<br />' . sprintf($user->lang['ERROR_USERS_DELETED'], implode(', ', $username_neg_ary)) : '';
add_log('admin', 'LOG_USER_DELETED', implode(', ', $username_ary));
trigger_error($message . adm_back_link($this->u_action));
}
else
{
trigger_error((sprintf($user->lang['ERROR_USERS_DELETED'], implode(', ', $username_neg_ary))) . adm_back_link($this->u_action), E_USER_WARNING);
}
}
else
{
$message = $user->lang['DELETE_USER_CONFIRM_OPERATION'];
$message .= $user->lang['CONFIRM_OPERATION'];
confirm_box(false, $message, build_hidden_fields(array(
'mark' => $mark,
'action' => $action)), 'confirm_body_user_reminder_delete.html'
);
}
}
break;
case 'user_protect':
if (sizeof($mark))
{
if (confirm_box(true))
{
$protected_user_ids = $new_protected_user_ids_ary = array();
$new_protected_user_ids = '';
//here we do a bit of putting current protectd users in an array, merge the new protected users in it and save it
$protected_user_ids = explode(',', $config['user_reminder_protected_users']);
$new_protected_user_ids_ary = array_merge($protected_user_ids, $mark);
$new_protected_user_ids = implode(',', $new_protected_user_ids_ary);
if( strlen(trim($new_protected_user_ids, ',')) <= 255)
{
set_config('user_reminder_protected_users', (string) trim($new_protected_user_ids, ','));
}
else
{
trigger_error(sprintf($user->lang['UR_TOO_MANY_CHARS'], strlen($new_protected_user_ids)) . adm_back_link($this->u_action));
}
$sql_id = ' IN (' . implode(', ', $mark) . ')';
$sql = 'SELECT user_id, username_clean
FROM ' . USERS_TABLE . "
WHERE user_id $sql_id";
$result = $db->sql_query($sql);
$user_id_ary = array();
while ($row = $db->sql_fetchrow($result))
{
$user_id_ary[] = (int) $row['user_id'];
$username_ary[] = (string) $row['username_clean'];
}
$db->sql_freeresult($result);
add_log('admin', 'LOG_USER_PROTECTED', implode(', ', $username_ary));
trigger_error($user->lang['USER_UPDATED'] . adm_back_link($this->u_action));
}
else
{
$message = $user->lang['CONFIRM_OPERATION'];
confirm_box(false, $message, build_hidden_fields(array(
'mark' => $mark,
'action' => $action))
);
}
}
break;
}
}
}
function build_dropdown($case)
{
global $template, $auth, $user;
$s_options = '';
if ($case == 'user_reminder_protected_users' )
{
$_options = $auth->acl_get('a_userdel') ? array($case => 'UNPROTECT_USER', 'clear_reminders' => 'CLEAR_ALL', 'user_delete' => 'DELETE_USER') : array($case => 'DESELECT_USER', 'clear_reminders' => 'CLEAR_ALL');
}
else
{
$_options = $auth->acl_get('a_userdel') ? array($case => 'REMINDER', $case . '_clear' => 'CLEAR', 'user_protect' => 'PROTECT_USER', 'user_delete' => 'DELETE_USER') : array($case => 'REMINDER', $case . '_clear' => 'CLEAR', 'user_protect' => 'PROTECT_USER');
}
foreach ($_options as $value => $lang)
{
$s_options .= '<option value="' . $value . '">' . $user->lang[$lang] . '</option>';
}
$template->assign_vars(array(
'U_ACTION' => $this->u_action,
'S_USER_REMINDER_OPTIONS' => $s_options)
);
}
function build_choice($choice_option, &$u_sort_param, &$sql_choice, &$sql_sort)
{
global $template, $user;
// Sort keys
$sort_choice = request_var('st', 'i');
$sort_key = request_var('sk', 'i');
$sort_dir = request_var('sd', 'd');
// Sorting
$limit_choice = array('i' => $user->lang['ALL'], 'j' => $user->lang['REMINDED'], 'l' => $user->lang['NOT_REMINDED']);
$sort_by_text = array('i' => ($choice_option == 'user_reminder_zero_poster' || $choice_option == 'user_reminder_not_logged_in') ? $user->lang['SORT_REG_DATE'] : $user->lang['SORT_LAST_VISIT'], 'j' => $user->lang['SORT_USERNAME'], 'l' => $user->lang['REMINDER_DATE']);
$sort_by_sql = array('i' => ($choice_option == 'user_reminder_zero_poster' || $choice_option == 'user_reminder_not_logged_in') ? 'user_regdate' : 'user_lastvisit' , 'j' => 'username_clean', 'l' => $choice_option);
$s_limit_choice = $s_sort_key = $s_sort_dir = $u_sort_param = '';
//lets make use of the existing function, we used the sort_choice for the days select, might as utilise existing functions ;)
gen_sort_selects($limit_choice, $sort_by_text, $sort_choice, $sort_key, $sort_dir, $s_limit_choice, $s_sort_key, $s_sort_dir, $u_sort_param);
// Define sort sql for use in displaying reminder rows
$sql_sort = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');
if ( $sort_choice == 'j' )
{
$sql_choice = ' AND ' . $choice_option . ' > 0';
}
elseif ( $sort_choice == 'l' )
{
$sql_choice = ' AND ' . $choice_option . ' = 0';
}
$template->assign_vars(array(
'S_LIMIT_CHOICE' => $s_limit_choice,
'S_SORT_KEY' => $s_sort_key,
'S_SORT_DIR' => $s_sort_dir,
));
return;
}
/**
* Generate list of groups (option fields with select)
* note: This is a modified function from functions_admin.php
* @param int $group_ids The groupids to mark as selected
*
* @return string The list of options.
*/
function group_protect_select_options_selected($group_ids)
{
global $db, $auth, $user, $template;
global $phpbb_root_path, $phpEx, $config;
//lets not show the guests and bots by default
$exclude_sql = "WHERE group_name <> 'GUESTS' AND group_name <> 'BOTS'";
$sql_and = (!$config['coppa_enable']) ? (($exclude_sql) ? ' AND ' : ' WHERE ') . "group_name <> 'REGISTERED_COPPA'" : '';
$sql = 'SELECT group_id, group_name, group_type
FROM ' . GROUPS_TABLE . "
$exclude_sql
$sql_and
ORDER BY group_type DESC, group_name ASC";
$result = $db->sql_query($sql);
$s_group_options = '';
$s_group_options .= '<option style="color:red; font-weight:bold;" value="0"' . (($config['user_reminder_protected_group'] == 0) ? ' selected="selected"' : '') . '>' . $user->lang['UR_NONE_SELECTED'] . '</option>';
while ($row = $db->sql_fetchrow($result))
{
$selected = (in_array($row['group_id'], $group_ids, true)) ? ' selected="selected"' : '';
$s_group_options .= '<option' . (($row['group_type'] == GROUP_SPECIAL) ? ' class="sep"' : '') . ' value="' . $row['group_id'] . '"' . $selected . '>' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';
}
$db->sql_freeresult($result);
return $s_group_options;
}
}
?>
Re: User Reminder 1.0.5
@lefty74: Tausend Dank!
Dein guter Tipp zu meinem defekten cron.php hat zumindest schon einmal etliche andere Macken des Boards behoben, die ganze Geschichte steht auch bei meiner erledigten diesbezüglichen allgemeinen Supportanfrage.
Ich gehe davon aus, dass sich damit auch die Macken beim User Reminder erledigt haben, jedenfalls wird für meinen Muster-User Australicus inzwischen ein aktuelles Aktivitätsdatum verzeichnet.
Also: Nicht nur für die Mod., sondern auch für den guten Support ein dickes Dankeschön!
Sepp
Dein guter Tipp zu meinem defekten cron.php hat zumindest schon einmal etliche andere Macken des Boards behoben, die ganze Geschichte steht auch bei meiner erledigten diesbezüglichen allgemeinen Supportanfrage.
Ich gehe davon aus, dass sich damit auch die Macken beim User Reminder erledigt haben, jedenfalls wird für meinen Muster-User Australicus inzwischen ein aktuelles Aktivitätsdatum verzeichnet.
Also: Nicht nur für die Mod., sondern auch für den guten Support ein dickes Dankeschön!
Sepp
Re: User Reminder 1.0.5
mir faellt echt nicht mehr viel ein, browser cache schon geloescht etc?Gismo110 hat geschrieben:snip
super, freut mich dass wir den uebeltaeter gefunden habensepp71 hat geschrieben:@lefty74: Tausend Dank!
Dein guter Tipp zu meinem defekten cron.php hat zumindest schon einmal etliche andere Macken des Boards behoben, die ganze Geschichte steht auch bei meiner erledigten diesbezüglichen allgemeinen Supportanfrage.
Ich gehe davon aus, dass sich damit auch die Macken beim User Reminder erledigt haben, jedenfalls wird für meinen Muster-User Australicus inzwischen ein aktuelles Aktivitätsdatum verzeichnet.
Also: Nicht nur für die Mod., sondern auch für den guten Support ein dickes Dankeschön!
Sepp
Re: User Reminder 1.0.5
nachm cache leeren funzt jetzt alles - danke!!
Re: User Reminder 1.0.5
Ich habe hierzu folgende Frage:
Kann man hiermit auch auf einem mehrere registrierte Benutzer auf einmal löschen, bzw. eine Benutzergruppe mitsammt all ihren Mitgliedern?
Gruß
S.
Kann man hiermit auch auf einem mehrere registrierte Benutzer auf einmal löschen, bzw. eine Benutzergruppe mitsammt all ihren Mitgliedern?
Gruß
S.
-
oxpus
- Ehemaliges Teammitglied
- Beiträge: 5394
- Registriert: 03.02.2003 12:33
- Wohnort: Bad Wildungen
- Kontaktdaten:
Re: User Reminder 1.0.5
Hallo,
also man kann mehrere User auf einmal damit löschen, aber man sieht so erst mal nicht, welcher User welcher Gruppe angehört.
Vielleicht mal ein neues Gimmick für die MOD
also man kann mehrere User auf einmal damit löschen, aber man sieht so erst mal nicht, welcher User welcher Gruppe angehört.
Vielleicht mal ein neues Gimmick für die MOD
Grüße
OXPUS
Kein Support bei unaufgeforderten PNs, E-Mails oder auf anderem Weg!!
OXPUS
Kein Support bei unaufgeforderten PNs, E-Mails oder auf anderem Weg!!
