function main($id, $mode)
{
global $db, $user, $auth, $template, $cache, $phpEx;
global $config, $phpbb_root_path, $phpbb_admin_path;
include $phpbb_root_path . 'includes/functions_user.' . $phpEx;
include $phpbb_root_path . 'includes/functions_invite.' . $phpEx;
$user->add_lang(array('ucp', 'mods/info_acp_invite', 'acp/board', 'acp/email'));
$invite = new invite();
$action = request_var('action', '');
$submit = isset($_POST['submit']) ? true : false;
$error = array();
foreach ($invite->config as $k => $v) {
$new_config[$k] = utf8_normalize_nfc(request_var($k, $v, true));
}
$form_key = 'acp_invite';
add_form_key($form_key);
if (request_var('version_check', false)) {
$mode = 'version';
}
if (!$invite->config['enable']) {
$error[] = $user->lang['ACP_IAF_DISABLED'];
}
if ($invite->config['enable'] && !$config['email_enable']) {
$error[] = sprintf($user->lang['ERROR_EMAIL_DISABLED'], append_sid("{$phpbb_admin_path}index.{$phpEx}?i=board&mode=email"));
}
switch ($mode) {
case 'overview':
$this->page_title = 'ACP_INVITE_OVERVIEW';
$this->tpl_name = 'acp_invite_overview';
// Calculate stats
$days_installed = (time() - $invite->config['tracking_time']) / 86400;
$invitations_per_day = sprintf('%.2f', $invite->config['num_invitations'] / $days_installed);
$registrations_per_day = sprintf('%.2f', $invite->config['num_registrations'] / $days_installed);
$referrals_per_day = sprintf('%.2f', $invite->config['num_referrals'] / $days_installed);
$install_date = $user->format_date($invite->config['tracking_time']);
// Version check
$latest_version_info = $update_to_date = false;
if (($latest_version_info = $this->latest_version_info(request_var('versioncheck_force', false))) === false) {
$template->assign_var('S_VERSIONCHECK_FAIL', true);
} else {
$latest_version_info = explode("\n", $latest_version_info);
$up_to_date = phpbb_version_compare($invite->config['version'], trim($latest_version_info[0]), '<') ? false : true;
}
if ($action) {
if (!confirm_box(true)) {
switch ($action) {
case 'sync_referral_data':
$confirm = true;
$confirm_lang = 'ACP_INVITE_CONFIRM_SYNC_REFERRAL_DATA';
break;
default:
$confirm = false;
break;
}
if ($confirm) {
confirm_box(false, $user->lang[$confirm_lang], build_hidden_fields(array('i' => $id, 'mode' => $mode, 'action' => $action)));
}
} else {
switch ($action) {
case 'sync_referral_data':
// Get an idea of which users need to be updated
$sql = 'SELECT invite_user_id, register_user_id, invite_time
FROM ' . INVITE_LOG_TABLE . '
WHERE register_key_used = 1';
$result = $db->sql_query($sql);
$uid_array = $db->sql_fetchrowset($result);
$db->sql_freeresult($result);
for ($i = 0; $i < sizeof($uid_array); $i++) {
if ($invite->config['referral_invitation_bridge']) {
$sql = 'SELECT COUNT(referrer_id) AS is_existent
FROM ' . INVITE_REFERRALS_TABLE . '
WHERE referrer_id = ' . (int) $uid_array[$i]['invite_user_id'] . '
AND referral_id = ' . (int) $uid_array[$i]['register_user_id'];
$result = $db->sql_query($sql);
$exists = $db->sql_fetchfield('is_existent');
$db->sql_freeresult($result);
if (!$exists) {
$sql_ary = array('user_referrer_id' => $uid_array[$i]['invite_user_id'], 'user_referrer_name' => $invite->user_return_data($uid_array[$i]['invite_user_id'], 'user_id', 'username_clean'));
$sql = 'UPDATE ' . USERS_TABLE . '
SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
WHERE user_id = ' . (int) $uid_array[$i]['register_user_id'];
$result = $db->sql_query($sql);
$db->sql_freeresult($result);
$sql_ary = array('referrer_id' => $uid_array[$i]['invite_user_id'], 'referral_id' => $uid_array[$i]['register_user_id'], 'time' => $uid_array[$i]['invite_time']);
$sql = 'INSERT INTO ' . INVITE_REFERRALS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
$db->sql_query($sql);
}
} else {
$sql_ary = array('user_referrer_id' => 0, 'user_referrer_name' => '');
$sql = 'UPDATE ' . USERS_TABLE . '
SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
WHERE user_id = ' . (int) $uid_array[$i]['register_user_id'];
$result = $db->sql_query($sql);
$db->sql_freeresult($result);
$sql = 'DELETE FROM ' . INVITE_REFERRALS_TABLE . '
WHERE referrer_id = ' . (int) $uid_array[$i]['invite_user_id'] . '
AND referral_id = ' . (int) $uid_array[$i]['register_user_id'];
$db->sql_query($sql);
$sql = 'SELECT COUNT(referrer_id) AS total_referrals
FROM ' . INVITE_REFERRALS_TABLE;
$result = $db->sql_query($sql);
$total_referrals = $db->sql_fetchfield('total_referrals');
$db->sql_freeresult($result);
$sql = 'UPDATE ' . INVITE_CONFIG_TABLE . ' SET config_value = ' . (int) $total_referrals . ' WHERE config_name = "num_referrals"';
$result = $db->sql_query($sql);
$db->sql_freeresult($result);
$sql = 'SELECT COUNT(referrer_id) AS user_referrals
FROM ' . INVITE_REFERRALS_TABLE . '
WHERE referrer_id = ' . (int) $uid_array[$i]['invite_user_id'];
$result = $db->sql_query($sql);
$user_referrals = $db->sql_fetchfield('user_referrals');
$db->sql_freeresult($result);
$sql = 'UPDATE ' . USERS_TABLE . '
SET user_referrals = ' . $user_referrals . '
WHERE user_id = ' . (int) $uid_array[$i]['invite_user_id'];
$result = $db->sql_query($sql);
$db->sql_freeresult($result);
}
// Synch stats
$sql = 'SELECT COUNT(referrer_id) AS total_referrals
FROM ' . INVITE_REFERRALS_TABLE;
$result = $db->sql_query($sql);
$total_referrals = $db->sql_fetchfield('total_referrals');
$db->sql_freeresult($result);
$sql = 'UPDATE ' . INVITE_CONFIG_TABLE . ' SET config_value = ' . (int) $total_referrals . ' WHERE config_name = "num_referrals"';
$result = $db->sql_query($sql);
$sql = 'SELECT COUNT(referrer_id) AS user_referrals
FROM ' . INVITE_REFERRALS_TABLE . '
WHERE referrer_id = ' . (int) $uid_array[$i]['invite_user_id'];
$result = $db->sql_query($sql);
$user_referrals = $db->sql_fetchfield('user_referrals');
$db->sql_freeresult($result);
$sql = 'UPDATE ' . USERS_TABLE . '
SET user_referrals = ' . $user_referrals . '
WHERE user_id = ' . (int) $uid_array[$i]['invite_user_id'];
$result = $db->sql_query($sql);
}
break;
default:
trigger_error('NO_MODE', E_USER_ERROR);
break;
}
add_log('admin', 'LOG_INVITE_' . strtoupper($action));
trigger_error($user->lang['ACP_INVITE_' . strtoupper($action) . '_SUCCESS'] . adm_back_link($this->u_action));
}
}
if ($submit) {
if (!check_form_key($form_key)) {
$error[] = $user->lang['FORM_INVALID'];
}
foreach ($new_config as $k => $v) {
$invite->set_config($k, $v);
}
add_log('admin', 'LOG_INVITE_SETTINGS_UPDATED');
trigger_error($user->lang['CONFIG_UPDATED'] . adm_back_link($this->u_action));
// Replace "error" strings with their real, localised form
$error = preg_replace('#^([A-Z_]+)$#e', "(!empty(\$user->lang['\\1'])) ? \$user->lang['\\1'] : '\\1'", $error);
}
foreach ($new_config as $k => $v) {
$template->assign_vars(array('S_' . strtoupper($k) => $v));
}
$template->assign_vars(array('ERROR' => sizeof($error) ? array_pop($error) : '', 'TOTAL_INVITATIONS' => $invite->config['num_invitations'], 'INVITATIONS_PER_DAY' => $invitations_per_day, 'TOTAL_SUCCESSFUL_INVITATIONS' => $invite->config['num_registrations'], 'SUCCESSFUL_INVITATIONS_PER_DAY' => $registrations_per_day, 'TOTAL_REFERRALS' => $invite->config['num_referrals'], 'REFERRALS_PER_DAY' => $referrals_per_day, 'INSTALL_DATE' => $install_date, 'INVITE_VERSION' => $invite->config['version'], 'U_ACTION' => $this->u_action, 'U_VERSIONCHECK' => $this->u_action . '&version_check=1', 'U_VERSIONCHECK_FORCE' => $this->u_action . '&versioncheck_force=1', 'S_VERSION_UP_TO_DATE' => $up_to_date, 'S_SETTINGS_AUTH' => $auth->acl_get('acl_a_invite_settings') ? true : false, 'S_FOUNDER' => $user->data['user_type'] == USER_FOUNDER ? true : false));
break;
case 'version':
$this->page_title = 'ACP_INVITE_OVERVIEW';
$this->tpl_name = 'acp_invite_overview';
$user->add_lang('install');
$errstr = '';
$errno = 0;
$info = $this->latest_version_info(request_var('versioncheck_force', false), true);
if ($info === false) {
trigger_error('VERSIONCHECK_FAIL', E_USER_WARNING);
}
$info = explode("\n", $info);
$latest_version = trim($info[0]);
$announcement_url = trim($info[1]);
$announcement_url = strpos($announcement_url, '&') === false ? str_replace('&', '&', $announcement_url) : $announcement_url;
$update_link = append_sid($phpbb_root_path . 'install/index.' . $phpEx);
$next_feature_version = $next_feature_announcement_url = false;
if (isset($info[2]) && trim($info[2]) !== '') {
$next_feature_version = trim($info[2]);
$next_feature_announcement_url = trim($info[3]);
}
$up_to_date = phpbb_version_compare($invite->config['version'], $latest_version, '<') ? false : true;
$template->assign_vars(array('S_VERSION_CHECK' => true, 'S_UP_TO_DATE' => $up_to_date, 'U_VERSIONCHECK_FORCE' => $this->u_action . '&version_check=1&versioncheck_force=1', 'LATEST_VERSION' => '<strong style="color:#228822">' . $latest_version . '</strong>', 'CURRENT_VERSION' => '<strong style="color:#' . ($up_to_date ? '228822' : 'BC2A4D') . '">' . $invite->config['version'] . '</strong>', 'NEXT_FEATURE_VERSION' => $next_feature_version, 'UPDATE_INSTRUCTIONS' => sprintf($user->lang['ACP_INVITE_UPDATE_INSTRUCTIONS'], $announcement_url, $update_link), 'UPGRADE_INSTRUCTIONS' => $next_feature_version ? $user->lang('INVITE_UPGRADE_INSTRUCTIONS', $next_feature_version, $next_feature_announcement_url) : false));
break;
case 'settings':
case 'referral_settings':
$this->page_title = $mode == 'referral_settings' ? 'ACP_REFERRAL_SETTINGS' : 'ACP_INVITE_SETTINGS';
$this->tpl_name = $mode == 'referral_settings' ? 'acp_invite_referral' : 'acp_invite';
$queue_time_m = request_var('queue_time_m', floor($invite->config['queue_time'] / 60));
$queue_time_s = request_var('queue_time_s', $invite->config['queue_time'] % 60);
if (!$invite->config['enable_invitation'] && $mode == 'settings') {
$error[] = $user->lang['ACP_INVITATION_DISABLED'];
}
if (!$invite->config['enable_referral'] && $mode == 'referral_settings') {
$error[] = $user->lang['ACP_REFERRAL_DISABLED'];
}
if ($submit) {
$new_config['queue_time'] = $queue_time_s + $queue_time_m * 60;
$check_ary = array('queue_time' => array('num', true, 1, 9999999999), 'message_min_chars' => array('num', true, 1, 9999), 'message_max_chars' => array('num', false, 1, 9999), 'subject_min_chars' => array('num', false, 1, 999), 'subject_max_chars' => array('num', false, 1, 999));
$error = validate_data($new_config, $check_ary);
if (!check_form_key($form_key)) {
$error[] = $user->lang['FORM_INVALID'];
}
// No errors.. continue!
if (!sizeof($error)) {
foreach ($new_config as $k => $v) {
$invite->set_config($k, $v);
}
add_log('admin', 'LOG_INVITE_SETTINGS_UPDATED');
trigger_error($user->lang['CONFIG_UPDATED'] . adm_back_link($this->u_action));
}
// Replace "error" strings with their real, localised form
$error = preg_replace('#^([A-Z_]+)$#e', "(!empty(\$user->lang['\\1'])) ? \$user->lang['\\1'] : '\\1'", $error);
}
foreach ($new_config as $k => $v) {
$template->assign_vars(array('S_' . strtoupper($k) => $v));
}
$template->assign_vars(array('ERROR' => sizeof($error) ? array_pop($error) : '', 'S_VALUE_EMAIL' => EMAIL, 'S_VALUE_PM' => PM, 'S_VALUE_OPTIONAL' => OPTIONAL, 'S_GROUP_SELECT' => group_select_options($new_config['key_group'], false, 0), 'S_EMAIL_ENABLE' => $config['email_enable'] ? true : false, 'S_SELECT_LANGUAGE' => $this->build_select('language', '', $new_config['invite_language_select']), 'S_SELECT_PROFILE_LOCATION' => $this->build_select('profile_location'), 'S_SELECT_PROFILE_TYPE' => $this->build_select('profile_type'), 'S_SELECT_REFERRAL_PROFILE_LOCATION' => $this->build_select('referral_profile_location'), 'S_SELECT_REFERRAL_PROFILE_TYPE' => $this->build_select('referral_profile_type'), 'S_PRIORITY_OPTIONS' => $this->build_select('priority', '', $new_config['invite_priority_flag']), 'S_QUEUE_TIME_M' => $queue_time_m, 'S_QUEUE_TIME_S' => $queue_time_s, 'U_ACTION' => $this->u_action));
if ($invite->ultimate_points_installed()) {
$template->assign_vars(array('S_ULTIMATE_POINTS_INSTALLED' => true));
}
if ($invite->cash_installed()) {
global $cash;
$template->assign_vars(array('S_CASH_INSTALLED' => true, 'S_CASH_CURRENCY_INVITE' => $cash->get_currencies($invite->config['cash_id_invite'], true), 'S_CASH_CURRENCY_REGISTER' => $cash->get_currencies($invite->config['cash_id_register'], true)));
}
break;
case 'templates':
$this->page_title = 'ACP_INVITE_TEMPLATES';
$this->tpl_name = 'acp_invite_templates';
$select = isset($_POST['select']) ? true : false;
$tpl_type = request_var('template_type', '', true);
$tpl_lang = request_var('template_language', $user->data['user_lang'], true);
$tpl_subject = $select ? $invite->get_template("{$tpl_type}_subject.txt", $tpl_lang) : '';
$tpl_message = $select ? $invite->get_template("{$tpl_type}_message.txt", $tpl_lang) : '';
if ($submit) {
$tpl_subject = request_var('template_subject', $invite->get_template("{$tpl_type}_subject.txt", $tpl_lang), true);
$tpl_message = request_var('template_message', $invite->get_template("{$tpl_type}_message.txt", $tpl_lang), true);
if (!check_form_key($form_key)) {
$error[] = $user->lang['FORM_INVALID'];
}
// No errors.. continue!
if (!sizeof($error)) {
$invite->set_template($tpl_subject, "{$tpl_type}_subject.txt", $tpl_lang);
$invite->set_template($tpl_message, "{$tpl_type}_message.txt", $tpl_lang);
add_log('admin', 'LOG_INVITE_TEMPLATES_UPDATED');
trigger_error($user->lang['CONFIG_UPDATED'] . adm_back_link($this->u_action));
}
}
// Output wildcard tables
$wildcards['general'] = $this->print_wildcard_array($invite, 'general');
$wildcards['user'] = $this->print_wildcard_array($invite, 'user');
foreach ($wildcards as $type => $data) {
foreach ($data as $wildcard => $example_value) {
$template->assign_block_vars($type . '_wildcards', array('WILDCARD' => $wildcard, 'EXAMPLE_VALUE' => $example_value));
}
}
$template->assign_vars(array('ERROR' => sizeof($error) ? array_pop($error) : '', 'TEMPLATE_SUBJECT' => $tpl_subject, 'TEMPLATE_MESSAGE' => $tpl_message, 'S_EDIT_TEMPLATE' => $select ? true : false, 'S_TEMPLATE_TYPE_SELECT' => $this->build_select('message', $invite->INVITE_MESSAGE_TYPE, $tpl_type), 'S_TEMPLATE_LANGUAGE_SELECT' => language_select($tpl_lang)));
break;
case 'log':
$this->page_title = 'ACP_INVITE_LOG';
$this->tpl_name = 'acp_invite_log';
$this->log_type = LOG_INVITE;
$start = request_var('start', 0);
$show_info = request_var('info', 0);
$marked = request_var('mark', array(0));
$filter = request_var('filter', 'all');
$deletemark = isset($_POST['delmarked']) ? true : false;
$deleteall = isset($_POST['delall']) ? true : false;
$entries_per_page = 25;
// Sort keys
$sort_days = request_var('st', 0);
$sort_key = request_var('sk', 't');
$sort_dir = request_var('sd', 'd');
$sort_user = request_var('ui', '', true);
// Delete entries if requested and able
if (($deletemark || $deleteall) && $auth->acl_get('a_clearlogs')) {
if (confirm_box(true)) {
$where_sql = '';
if ($deletemark && sizeof($marked)) {
$sql_in = array();
foreach ($marked as $mark) {
$sql_in[] = $mark;
}
$where_sql = ' AND ' . $db->sql_in_set('log_id', $sql_in);
unset($sql_in);
}
if ($where_sql || $deleteall) {
$sql = 'DELETE FROM ' . LOG_TABLE . "\n\t\t\t\t\t\t\t\tWHERE log_type = {$this->log_type}\n\t\t\t\t\t\t\t\t{$where_sql}";
$db->sql_query($sql);
}
add_log('admin', 'LOG_INVITE_LOG_CLEARED');
} else {
confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array('start' => $start, 'delmarked' => $deletemark, 'delall' => $deleteall, 'mark' => $marked, 'st' => $sort_days, 'sk' => $sort_key, 'sd' => $sort_dir, 'i' => $id, 'mode' => $mode, 'action' => $action)));
}
}
// Sorting
$limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);
$sort_by_text = array('u' => $user->lang['SORT_USERNAME'], 't' => $user->lang['SORT_DATE'], 'i' => $user->lang['SORT_IP'], 'o' => $user->lang['SORT_ACTION']);
$sort_by_sql = array('u' => 'u.username_clean', 't' => 'l.log_time', 'i' => 'l.log_ip', 'o' => 'l.log_operation');
$s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';
gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);
// Define where and sort sql for use in displaying logs
$sql_where = $sort_days ? time() - $sort_days * 86400 : 0;
$sql_sort = $sort_by_sql[$sort_key] . ' ' . ($sort_dir == 'd' ? 'DESC' : 'ASC');
$sql_user = $invite->user_return_data($db->sql_escape(utf8_clean_string($sort_user)), 'username_clean', 'user_id');
// Grab log data
$log_data = array();
$log_count = 0;
view_log('invite', $log_data, $log_count, $entries_per_page, $start, $sql_user, $filter, $sql_user, $sql_where, $sql_sort);
$u_sort_param .= $sql_user ? "&ui={$sort_user}" : '';
$log_count = $sql_user ? $log_count : ($sort_user ? 0 : $log_count);
$template->assign_vars(array('U_ACTION' => $this->u_action, 'S_FILTER' => $this->build_select('filter', '', $filter), 'S_ON_PAGE' => on_page($log_count, $entries_per_page, $start), 'PAGINATION' => generate_pagination($this->u_action . "&{$u_sort_param}", $log_count, $entries_per_page, $start, true), 'S_LIMIT_DAYS' => $s_limit_days, 'S_SORT_KEY' => $s_sort_key, 'S_SORT_DIR' => $s_sort_dir, 'S_SORT_USER' => $sort_user ? $sort_user : '', 'S_CLEARLOGS' => $auth->acl_get('a_clearlogs'), 'S_USER_ENTRY' => empty($sort_user) ? true : $sql_user));
foreach ($log_data as $row) {
// Remove info to fix the bug 'Invitation log - Details'
$u_sort_param = $show_info ? str_replace("&info={$show_info}", '', $u_sort_param) : $u_sort_param;
$data = array();
$template->assign_block_vars('log', array('USERNAME' => $row['username_full'], 'REPORTEE_USERNAME' => $row['reportee_username'] && $row['user_id'] != $row['reportee_id'] ? $row['reportee_username_full'] : '', 'IP' => $row['ip'], 'DATE' => $user->format_date($row['time']), 'ACTION' => $row['action'], 'DATA' => sizeof($data) ? implode(' | ', $data) : '', 'ID' => $row['id']));
}
break;
}
}
