function print_statistic_code($title, $name, $start, $end, $nullvalue = true, $scope = 'daily', $sort = 'date_desc')
{
global $vbphrase;
print_form_header('stats', $name);
print_table_header($title);
print_time_row($vbphrase['start_date'], 'start', $start, false);
print_time_row($vbphrase['end_date'], 'end', $end, false);
if ($name != 'activity')
{
print_select_row($vbphrase['scope'], 'scope', array('daily' => $vbphrase['daily'], 'weekly' => $vbphrase['weekly'], 'monthly' => $vbphrase['monthly']), $scope);
}
else
{
construct_hidden_code('scope', 'daily');
}
print_select_row($vbphrase['order_by'], 'sort', array(
'date_asc' => $vbphrase['date_ascending'],
'date_desc' => $vbphrase['date_descending'],
'total_asc' => $vbphrase['total_ascending'],
'total_desc' => $vbphrase['total_descending'],
), $sort);
print_yes_no_row($vbphrase['include_empty_results'], 'nullvalue', $nullvalue);
print_submit_row($vbphrase['go']);
}
} else {
$vbulletin->GPC['userid'] = 0;
}
// Default View Values
if (!$vbulletin->GPC['start']) {
$vbulletin->GPC['start'] = TIMENOW - 3600 * 24 * 30;
}
if (!$vbulletin->GPC['end']) {
$vbulletin->GPC['end'] = TIMENOW;
}
print_form_header('adminreputation', 'dolist');
print_table_header($vbphrase['view_reputation_comments']);
print_input_row($vbphrase['leftfor'], 'leftfor', $vbulletin->GPC['leftfor'], 0);
print_input_row($vbphrase['leftby'], 'leftby', $vbulletin->GPC['leftby'], 0);
print_time_row($vbphrase['start_date'], 'start', $vbulletin->GPC['start'], false);
print_time_row($vbphrase['end_date'], 'end', $vbulletin->GPC['end'], false);
print_submit_row($vbphrase['go']);
}
// *************************************************************************************************
if ($_REQUEST['do'] == 'dolist') {
require_once DIR . '/includes/functions_misc.php';
if ($vbulletin->GPC['startstamp']) {
$vbulletin->GPC['start'] = $vbulletin->GPC['startstamp'];
} else {
$vbulletin->GPC['start'] = vbmktime(0, 0, 0, $vbulletin->GPC['start']['month'], $vbulletin->GPC['start']['day'], $vbulletin->GPC['start']['year']);
}
if ($vbulletin->GPC['endstamp']) {
$vbulletin->GPC['end'] = $vbulletin->GPC['endstamp'];
} else {
$vbulletin->GPC['end'] = vbmktime(23, 59, 59, $vbulletin->GPC['end']['month'], $vbulletin->GPC['end']['day'], $vbulletin->GPC['end']['year']);
}
print_form_header('qhvbmailer', 'compose_email');
print_table_header('Compose Email');
construct_hidden_code('act', '2');
$sql = "SELECT * FROM " . TABLE_PREFIX . "qhvbmailer_templates WHERE orderr < 1 ORDER BY created DESC";
$templates = $db->query_read_slave($sql);
while ($template = $db->fetch_array($templates)) {
$select_options_templates[$template['id']] = $template_phrases[$template['id'] . "_" . $template['varname'] . "_subject"];
}
$select_options_usergroups[0] = 'All Users';
$sql = "SELECT * FROM " . TABLE_PREFIX . "usergroup";
$usergroups = $db->query_read_slave($sql);
while ($usergroup = $db->fetch_array($usergroups)) {
$select_options_usergroups[$usergroup['usergroupid']] = $usergroup['title'];
}
print_select_row('What to send', 'template_id', $select_options_templates);
print_time_row('When to send', 'date', TIMENOW);
print_select_row('Who to send to', 'send_to', $select_options_usergroups);
print_submit_row('Continue', '');
} elseif ($_GET['act'] == 2) {
$vbulletin->input->clean_array_gpc('p', array('template_id' => TYPE_UINT, 'date' => TYPE_ARRAY, 'send_to' => TYPE_UINT));
if ($vbulletin->GPC['template_id'] > 0) {
$send_when = mktime($vbulletin->GPC['date'][hour], $vbulletin->GPC['date'][minute], '00', $vbulletin->GPC['date'][month], $vbulletin->GPC['date'][day], $vbulletin->GPC['date'][year]);
if ($db->query_write("INSERT INTO " . TABLE_PREFIX . "qhvbmailer_campaigns(created, send_when, send_to, template_id) VALUES('" . TIMENOW . "', '" . $send_when . "', '" . $vbulletin->GPC['send_to'] . "', '" . $vbulletin->GPC['template_id'] . "')")) {
print_cp_message('Campaign scheduled!', 'qhvbmailer.php?do=manage_campaigns', 1);
} else {
print_cp_message('Error scheduling campaign!', 'qhvbmailer.php?do=compose_email', 2);
}
} else {
print_cp_message('Template ID must be greater than zero!', 'qhvbmailer.php?do=compose_email', 2);
}
}
define('CP_REDIRECT', "user.php?do=prune" . "&usergroupid=" . $vbulletin->GPC['usergroupid'] . "&daysprune=" . $vbulletin->GPC['daysprune'] . "&joindateunix={$joindateunix}" . "&minposts=" . $vbulletin->GPC['minposts']);
print_stop_message('no_users_matched_your_query');
}
} else {
print_stop_message('please_complete_required_fields');
}
}
// ############################# start prune users #########################
if ($_REQUEST['do'] == 'prune') {
$vbulletin->input->clean_array_gpc('r', array('usergroupid' => TYPE_UINT, 'daysprune' => TYPE_INT, 'joindateunix' => TYPE_INT, 'minposts' => TYPE_INT));
print_form_header('user', 'pruneusers');
print_table_header($vbphrase['user_moving_pruning_system']);
print_description_row('<blockquote>' . $vbphrase['this_system_allows_you_to_mass_move_delete_users'] . '</blockquote>');
print_chooser_row($vbphrase['usergroup'], 'usergroupid', 'usergroup', iif($vbulletin->GPC['usergroupid'], $vbulletin->GPC['usergroupid'], -1), $vbphrase['all_usergroups']);
print_input_row($vbphrase['has_not_logged_on_for_xx_days'], 'daysprune', iif($vbulletin->GPC['daysprune'], $vbulletin->GPC['daysprune'], 365));
print_time_row($vbphrase['join_date_is_before'], 'joindate', $vbulletin->GPC['joindateunix'], false, false, 'middle');
print_input_row($vbphrase['posts_is_less_than'], 'minposts', iif($vbulletin->GPC['minposts'], $vbulletin->GPC['minposts'], '0'));
print_label_row($vbphrase['order_by'], '<select name="order" tabindex="1" class="bginput">
<option value="username">' . $vbphrase['username'] . '</option>
<option value="email">' . $vbphrase['email'] . '</option>
<option value="usergroup">' . $vbphrase['usergroup'] . '</option>
<option value="posts">' . $vbphrase['post_count'] . '</option>
<option value="lastactivity">' . $vbphrase['last_activity'] . '</option>
<option value="joindate">' . $vbphrase['join_date'] . '</option>
</select>', '', 'top', 'order');
print_submit_row($vbphrase['find']);
}
// ############################# user change history #########################
if ($_REQUEST['do'] == 'changehistory') {
require_once DIR . '/includes/class_userchangelog.php';
require_once DIR . '/includes/functions_misc.php';
define('CP_REDIRECT', 'modlog.php?do=choose');
print_stop_message('pruned_moderator_log_successfully');
}
// ###################### Start modify #######################
if ($_REQUEST['do'] == 'choose') {
$users = $db->query_read("\n\t\tSELECT DISTINCT moderatorlog.userid, user.username\n\t\tFROM " . TABLE_PREFIX . "moderatorlog AS moderatorlog\n\t\tINNER JOIN " . TABLE_PREFIX . "user AS user USING(userid)\n\t\tORDER BY username\n\t");
$userlist = array('no_value' => $vbphrase['all_log_entries']);
while ($user = $db->fetch_array($users)) {
$userlist["{$user['userid']}"] = $user['username'];
}
print_form_header('modlog', 'view');
print_table_header($vbphrase['moderator_log_viewer']);
print_input_row($vbphrase['log_entries_to_show_per_page'], 'perpage', 15);
print_select_row($vbphrase['show_only_entries_generated_by'], 'userid', $userlist);
print_time_row($vbphrase['start_date'], 'startdate', 0, 0);
print_time_row($vbphrase['end_date'], 'enddate', 0, 0);
if (count($products = fetch_product_list()) > 1) {
print_select_row($vbphrase['product'], 'product', array('' => $vbphrase['all_products']) + $products);
}
print_select_row($vbphrase['order_by'], 'orderby', array('date' => $vbphrase['date'], 'user' => $vbphrase['username']), 'date');
print_submit_row($vbphrase['view'], 0);
if (can_access_logs($vbulletin->config['SpecialUsers']['canpruneadminlog'], 0, '')) {
print_form_header('modlog', 'prunelog');
print_table_header($vbphrase['prune_moderator_log']);
print_select_row($vbphrase['remove_entries_logged_by_user'], 'userid', $userlist);
if (count($products) > 1) {
print_select_row($vbphrase['product'], 'product', array('' => $vbphrase['all_products']) + $products);
}
print_input_row($vbphrase['remove_entries_older_than_days'], 'daysprune', 30);
print_submit_row($vbphrase['prune_log_entries'], 0);
}
$resolvedip = @gethostbyaddr($vbulletin->GPC['ip']);
if ($resolvedip == $vbulletin->GPC['ip']) {
print_label_row($vbphrase['host_name'], '<i>' . $vbphrase['n_a'] . '</i>');
} else {
print_label_row($vbphrase['host_name'], "<b>{$resolvedip}</b>");
}
// Legacy Hook 'useradmin_gethost' Removed //
print_table_footer();
}
// ############################# start referrers #########################
if ($_REQUEST['do'] == 'referrers') {
print_form_header('usertools', 'showreferrers');
print_table_header($vbphrase['referrals_guser']);
print_description_row($vbphrase['please_input_referral_dates']);
print_time_row($vbphrase['start_date'], 'startdate', TIMENOW - 24 * 60 * 60 * 31, 1, 0, 'middle');
print_time_row($vbphrase['end_date'], 'enddate', TIMENOW, 1, 0, 'middle');
print_submit_row($vbphrase['find']);
}
// ############################# start show referrers #########################
if ($_POST['do'] == 'showreferrers') {
$vbulletin->input->clean_array_gpc('p', array('startdate' => vB_Cleaner::TYPE_ARRAY_INT, 'enddate' => vB_Cleaner::TYPE_ARRAY_INT));
require_once DIR . '/includes/functions_misc.php';
$datequery = '';
if ($vbulletin->GPC['startdate']['month']) {
$datestartText = vbmktime(intval($vbulletin->GPC['startdate']['hour']), intval($vbulletin->GPC['startdate']['minute']), 0, intval($vbulletin->GPC['startdate']['month']), intval($vbulletin->GPC['startdate']['day']), intval($vbulletin->GPC['startdate']['year']));
$datestart = vbdate($vbulletin->options['dateformat'] . ' ' . $vbulletin->options['timeformat'], $datestartText);
} else {
$vbulletin->GPC['startdate'] = 0;
}
if ($vbulletin->GPC['enddate']['month']) {
$dateendText = vbmktime(intval($vbulletin->GPC['enddate']['hour']), intval($vbulletin->GPC['enddate']['minute']), 0, intval($vbulletin->GPC['enddate']['month']), intval($vbulletin->GPC['enddate']['day']), intval($vbulletin->GPC['enddate']['year']));
print_yes_no_row($vbphrase['display_avatars'], 'options[showavatars]', $user['showavatars']);
print_yes_no_row($vbphrase['display_images'], 'options[showimages]', $user['showimages']);
//print_yes_no_row($vbphrase['use_email_notification_by_default'], 'options[emailnotification]', $user['emailnotification']);
print_radio_row($vbphrase['auto_subscription_mode'], 'user[autosubscribe]', array(-1 => $vbphrase['subscribe_choice_none'], 0 => $vbphrase['subscribe_choice_0'], 1 => $vbphrase['subscribe_choice_1'], 2 => $vbphrase['subscribe_choice_2'], 3 => $vbphrase['subscribe_choice_3']), $user['autosubscribe'], 'smallfont');
print_radio_row($vbphrase['thread_display_mode'], 'threaddisplaymode', array(0 => "{$vbphrase['linear']} - {$vbphrase['oldest_first']}", 3 => "{$vbphrase['linear']} - {$vbphrase['newest_first']}", 2 => $vbphrase['hybrid'], 1 => $vbphrase['threaded']), $threaddisplaymode, 'smallfont');
print_radio_row($vbphrase['message_editor_interface'], 'user[showvbcode]', array(0 => $vbphrase['do_not_show_editor_toolbar'], 1 => $vbphrase['show_standard_editor_toolbar'], 2 => $vbphrase['show_enhanced_editor_toolbar']), $user['showvbcode'], 'smallfont');
construct_style_chooser($vbphrase['style'], 'user[styleid]', $user['styleid']);
print_table_break('', $INNERTABLEWIDTH);
// TIME FIELDS SECTION
print_table_header($vbphrase['time_options']);
print_description_row($vbphrase['timezone'] . ' <select name="user[timezoneoffset]" class="bginput" tabindex="1">' . construct_select_options(fetch_timezones_array(), $user['timezoneoffset']) . '</select>');
print_label_row($vbphrase['default_view_age'], '<select name="user[daysprune]" class="bginput" tabindex="1">' . construct_select_options($pruneoptions, $user['daysprune']) . '</select>');
print_time_row($vbphrase['join_date'], 'joindate', $user['joindate'], 0);
print_time_row($vbphrase['last_visit'], 'lastvisit', $user['lastvisit']);
print_time_row($vbphrase['last_activity'], 'lastactivity', $user['lastactivity']);
print_time_row($vbphrase['last_post'], 'lastpost', $user['lastpost']);
($hook = vBulletinHook::fetch_hook('useradmin_edit_column2')) ? eval($hook) : false;
?>
</table>
</tr>
<?php
print_table_break('', $OUTERTABLEWIDTH);
$tableadded = 1;
print_table_footer();
}
// ###################### Start editsig #######################
if ($_REQUEST['do'] == 'editsig') {
if (!can_moderate(0, 'caneditsigs')) {
print_stop_message('no_permission_signatures');
}
if (empty($vbulletin->GPC['userid'])) {
else if ($announcement['forumid'] != -1 AND !can_moderate($announcement['forumid'], 'canannounce'))
{
print_table_header($vbphrase['no_permission_announcement']);
print_table_break();
}
}
construct_hidden_code('announcementid', $vbulletin->GPC['announcementid']);
print_table_header(construct_phrase($vbphrase['x_y_id_z'], $vbphrase['announcement'], htmlspecialchars_uni($announcement['title']), $announcement['announcementid']));
}
print_forum_chooser($vbphrase['forum_and_children'], 'forumid', $announcement['forumid'], $vbphrase['all_forums']);
print_input_row($vbphrase['title'], 'title', $announcement['title']);
print_time_row($vbphrase['start_date'], 'startdate', $announcement['startdate'], 0);
print_time_row($vbphrase['end_date'], 'enddate', $announcement['enddate'], 0);
print_textarea_row($vbphrase['text'], 'pagetext', $announcement['pagetext'], 20, '75" style="width:100%');
if ($vbulletin->GPC['announcementid'])
{
print_yes_no_row($vbphrase['reset_views_counter'], 'reset_views', 0);
}
print_yes_no_row($vbphrase['allow_bbcode'], 'announcementoptions[allowbbcode]', ($announcement['announcementoptions'] & $vbulletin->bf_misc_announcementoptions['allowbbcode'] ? 1 : 0));
print_yes_no_row($vbphrase['allow_smilies'], 'announcementoptions[allowsmilies]', ($announcement['announcementoptions'] & $vbulletin->bf_misc_announcementoptions['allowsmilies'] ? 1 : 0));
print_yes_no_row($vbphrase['allow_html'], 'announcementoptions[allowhtml]', ($announcement['announcementoptions'] & $vbulletin->bf_misc_announcementoptions['allowhtml'] ? 1 : 0));
print_yes_no_row($vbphrase['automatically_parse_links_in_text'], 'announcementoptions[parseurl]', ($announcement['announcementoptions'] & $vbulletin->bf_misc_announcementoptions['parseurl'] ? 1 : 0));
print_yes_no_row($vbphrase['show_your_signature'], 'announcementoptions[signature]', ($announcement['announcementoptions'] & $vbulletin->bf_misc_announcementoptions['signature'] ? 1 : 0));
print_submit_row($vbphrase['save']);
if ($_REQUEST['do'] == 'search') {
print_form_header('socialgroups', 'dosearch');
print_table_header($vbphrase['search_social_groups']);
print_input_row($vbphrase['key_words'], 'filtertext');
// get category options
$category_options = array();
$categories = fetch_socialgroup_category_options(false, true);
foreach ($categories as $category) {
$category_options[$category['socialgroupcategoryid']] = $category['title'];
}
unset($categories);
print_select_row($vbphrase['category_is'], 'category', $category_options, 0);
print_input_row($vbphrase['members_greater_than'], 'members_gteq', '', true, 5);
print_input_row($vbphrase['members_less_than'], 'members_lteq', '', true, 5);
print_time_row($vbphrase['creation_date_is_before'], 'date_lteq', '', false);
print_time_row($vbphrase['creation_date_is_after'], 'date_gteq', '', false);
print_input_row($vbphrase['group_created_by'], 'creator');
print_select_row($vbphrase['group_type'], 'type', array('' => '', 'public' => $vbphrase['group_type_public'], 'moderated' => $vbphrase['group_type_moderated'], 'inviteonly' => $vbphrase['group_type_inviteonly']));
print_submit_row($vbphrase['search']);
print_cp_footer();
}
// #######################################################################
if ($_REQUEST['do'] == 'groupsby' and !empty($vbulletin->GPC['userid'])) {
if (verify_id('user', $vbulletin->GPC['userid'], false)) {
$vbulletin->GPC['creatoruserid'] = $vbulletin->GPC['userid'];
$_REQUEST['do'] = 'dosearch';
} else {
print_cp_message($vbphrase['invalid_username']);
}
}
// #######################################################################
$cell = array();
$cell[] = $modpoints['username'];
$cell[] = vb_number_format($modpoints['forums'], 2) . iif($modpoints['forums'], '<br/>' . '<span class="smallfont">' . iif($modpoints['reply_new'], '<span title="Point for new post">' . vb_number_format($modpoints['reply_new'], 2) . '</span> ') . iif($modpoints['thread_new'], '<span title="Point for new thread">' . vb_number_format($modpoints['thread_new'], 2) . '</span> ') . iif($modpoints['chars_new'], '<span title="Point for Character/Post">' . vb_number_format($modpoints['chars_new'], 2) . '</span> ') . iif($modpoints['modlog'], '<span title="Point for mod-action">' . vb_number_format($modpoints['modlog'], 2) . '</span>') . '</span>');
$cell[] = vb_number_format($modpoints['posting'], 2) . iif($modpoints['posting'], '<br/>' . '<span class="smallfont">' . iif($modpoints['reply_post'] + $modpoints['reply_post_other'], '<span title="Point for posting reply">' . vb_number_format($modpoints['reply_post'] + $modpoints['reply_post_other'], 2) . '</span> ') . iif($modpoints['thread_post'] + $modpoints['threadreply_post'] + $modpoints['threadview_post'] + $modpoints['thread_post_other'] + $modpoints['threadreply_post_other'] + $modpoints['threadview_post_other'], '<span title="Point for posting thread">' . vb_number_format($modpoints['thread_post'] + $modpoints['threadreply_post'] + $modpoints['threadview_post'] + $modpoints['thread_post_other'] + $modpoints['threadreply_post_other'] + $modpoints['threadview_post_other'], 2) . '</span>') . '</span>');
$cell[] = vb_number_format($modpoints['thanks'], 2) . iif($modpoints['thanks'], '<br/>' . '<span class="smallfont">' . iif($modpoints['thanksendtime'] + $modpoints['thanksendamount'] + $modpoints['thanksendtime_other'] + $modpoints['thanksendamount_other'], '<span title="Point for sending thank">' . vb_number_format($modpoints['thanksendtime'] + $modpoints['thanksendamount'] + $modpoints['thanksendtime_other'] + $modpoints['thanksendamount_other'], 2) . '</span> ') . iif($modpoints['thankreceivetime'] + $modpoints['thankreceiveamount'] + $modpoints['thankreceivetime_other'] + $modpoints['thankreceiveamount_other'], '<span title="Point for receiving thank">' . vb_number_format($modpoints['thankreceivetime'] + $modpoints['thankreceiveamount'] + $modpoints['thankreceivetime_other'] + $modpoints['thankreceiveamount_other'], 2) . '</span> ') . '</span>');
$cell[] = vb_number_format($modpoints['awards'], 2);
$cell[] = vb_number_format($modpoints['total'], 2);
print_cells_row($cell);
}
print_table_footer(6);
}
print_form_header('kbankadmin', 'salary');
construct_hidden_code('calculate', $vbphrase['kbank_banklogs_forum_stat_calculate']);
print_table_header($vbphrase['kbank_banklogs_forum_stat_calculate']);
print_time_row('Please select start time', 'from', iif(is_numeric($vbulletin->GPC['from']), intval($vbulletin->GPC['from']), TIMENOW - 30 * 24 * 60 * 60));
print_time_row('Please select end time', 'to', iif(is_numeric($vbulletin->GPC['to']), intval($vbulletin->GPC['to']), TIMENOW));
print_description_row('Point for forums\' stuff', 0, 2, 'optiontitle');
print_input_row('Point for 1 new post', 'points[reply_new]', $points['reply_new']);
print_input_row('Point for 1 new thread', 'points[thread_new]', $points['thread_new']);
print_input_row('Point for 1 character/post', 'points[chars_new]', $points['chars_new']);
print_input_row('Point for 1 mod-action', 'points[modlog]', $points['modlog']);
print_description_row('Point for posting', 0, 2, 'optiontitle');
print_input_row('Point for posting 1 post in moderating forums', 'points[reply_post]', $points['reply_post']);
print_input_row('Point for posting 1 thread in moderating forums', 'points[thread_post]', $points['thread_post']);
print_input_row('Point for 1 reply in thread posted in moderating forums', 'points[threadreply_post]', $points['threadreply_post']);
print_input_row('Point for 1 view in thread posted in moderating forums', 'points[threadview_post]', $points['threadview_post']);
print_input_row('Point for posting 1 post in other forums', 'points[reply_post_other]', $points['reply_post_other']);
print_input_row('Point for posting 1 thread in other forums', 'points[thread_post_other]', $points['thread_post_other']);
print_input_row('Point for 1 reply in thread posted in other forums', 'points[threadreply_post_other]', $points['threadreply_post_other']);
print_input_row('Point for 1 view in thread posted in other forums', 'points[threadview_post_other]', $points['threadview_post_other']);
print_description_row('Point for thanks', 0, 2, 'optiontitle');
$milestone = array('milestoneid' => 0, 'title' => '', 'description' => '', 'targetdate' => 0, 'completeddate' => 0);
}
$project = fetch_project_info($vbulletin->GPC['projectid'], false);
if (!$project) {
print_stop_message('invalid_action_specified');
}
print_form_header('project', 'projectmilestoneupdate');
if ($milestone['milestoneid']) {
print_table_header($vbphrase['edit_milestone']);
} else {
print_table_header($vbphrase['add_milestone']);
}
print_input_row("{$vbphrase['title']}<dfn>{$vbphrase['html_is_allowed']}</dfn>", 'title', $milestone['title']);
print_textarea_row("{$vbphrase['description']}<dfn>{$vbphrase['html_is_allowed']}</dfn>", 'description', $milestone['description']);
print_time_row("{$vbphrase['target_date']}<dfn>{$vbphrase['target_date_desc']}</dfn>", 'targetdate', $milestone['targetdate'], false);
print_time_row("{$vbphrase['completed_date']}<dfn>{$vbphrase['completed_date_desc']}</dfn>", 'completeddate', $milestone['completeddate'], false);
construct_hidden_code('projectid', $project['projectid']);
construct_hidden_code('milestoneid', $milestone['milestoneid']);
print_submit_row();
}
// ########################################################################
if ($_POST['do'] == 'projectmilestonekill') {
$vbulletin->input->clean_array_gpc('p', array('milestoneid' => TYPE_UINT, 'destmilestoneid' => TYPE_UINT));
$milestone = $db->query_first("\r\n\t\tSELECT *\r\n\t\tFROM " . TABLE_PREFIX . "pt_milestone\r\n\t\tWHERE milestoneid = " . $vbulletin->GPC['milestoneid']);
$project = fetch_project_info($milestone['projectid'], false);
if (!$project) {
print_stop_message('invalid_action_specified');
}
$db->query_write("\r\n\t\tUPDATE " . TABLE_PREFIX . "pt_issue SET\r\n\t\t\tmilestoneid = " . $vbulletin->GPC['destmilestoneid'] . "\r\n\t\tWHERE milestoneid = {$milestone['milestoneid']}\r\n\t");
$milestonedata =& datamanager_init('Pt_Milestone', $vbulletin, ERRTYPE_CP);
$milestonedata->set_existing($milestone);
print_time_row($vbphrase['photoplog_last_comment_after'], 'photoplog_last_comment_after');
print_time_row($vbphrase['photoplog_last_comment_before'], 'photoplog_last_comment_before');
print_input_row($vbphrase['photoplog_number_comments_at_least'], 'photoplog_number_comments_at_least');
print_input_row($vbphrase['photoplog_number_comments_at_most'], 'photoplog_number_comments_at_most');
print_input_row($vbphrase['photoplog_number_ratings_at_least'], 'photoplog_number_ratings_at_least');
print_input_row($vbphrase['photoplog_number_ratings_at_most'], 'photoplog_number_ratings_at_most');
$photoplog_rating_array = array("-1" => $vbphrase['photoplog_ignore'], "1" => $vbphrase['photoplog_terrible'], "2" => $vbphrase['photoplog_bad'], "3" => $vbphrase['photoplog_average'], "4" => $vbphrase['photoplog_good'], "5" => $vbphrase['photoplog_excellent']);
print_select_row($vbphrase['photoplog_average_rating_at_least'], 'photoplog_average_rating_ge', $photoplog_rating_array, "-1");
print_select_row($vbphrase['photoplog_average_rating_at_most'], 'photoplog_average_rating_le', $photoplog_rating_array, "-1");
print_table_header($vbphrase['photoplog_move_destination']);
$photoplog_destination_list_categories = array();
photoplog_list_categories($photoplog_destination_list_categories);
print_select_row($vbphrase['photoplog_category'], 'photoplog_destination_category', $photoplog_destination_list_categories, "-1", true, 0, false);
print_yes_no_row($vbphrase['photoplog_make_subcategories'], 'photoplog_make_subcategories', "0");
print_input_row($vbphrase['photoplog_destination_posted_by_id'], 'photoplog_destination_posted_by');
print_time_row($vbphrase['photoplog_destination_posted_on'], 'photoplog_destination_posted_on');
print_submit_row($vbphrase['photoplog_preview']);
}
if ($_REQUEST['do'] == 'domassmove' || $_REQUEST['do'] == 'preview') {
$photoplog_input_names = array('photoplog_md' => TYPE_INT, 'photoplog_source_category' => TYPE_INT, 'photoplog_include_subcategories' => TYPE_UINT, 'photoplog_posted_by' => TYPE_STR, 'photoplog_title' => TYPE_STR, 'photoplog_description' => TYPE_STR, 'photoplog_posted_after' => TYPE_ARRAY_UINT, 'photoplog_posted_before' => TYPE_ARRAY_UINT, 'photoplog_filesize_at_least' => TYPE_UINT, 'photoplog_filesize_at_most' => TYPE_UINT, 'photoplog_width_at_least' => TYPE_UINT, 'photoplog_width_at_most' => TYPE_UINT, 'photoplog_height_at_least' => TYPE_UINT, 'photoplog_height_at_most' => TYPE_UINT, 'photoplog_number_views_at_least' => TYPE_UINT, 'photoplog_number_views_at_most' => TYPE_UINT, 'photoplog_last_comment_after' => TYPE_ARRAY_UINT, 'photoplog_last_comment_before' => TYPE_ARRAY_UINT, 'photoplog_number_comments_at_least' => TYPE_UINT, 'photoplog_number_comments_at_most' => TYPE_UINT, 'photoplog_number_ratings_at_least' => TYPE_UINT, 'photoplog_number_ratings_at_most' => TYPE_UINT, 'photoplog_average_rating_ge' => TYPE_INT, 'photoplog_average_rating_le' => TYPE_INT, 'photoplog_destination_category' => TYPE_INT, 'photoplog_make_subcategories' => TYPE_UINT, 'photoplog_destination_posted_by' => TYPE_UINT, 'photoplog_destination_posted_on' => TYPE_ARRAY_UINT);
$photoplog_input_okay_info = array('photoplog_md' => array('photoplog_bad_input', 1, 2), 'photoplog_source_category' => array('photoplog_bad_source_category', 1, 2), 'photoplog_include_subcategories' => array('photoplog_bad_input', 1, 2), 'photoplog_posted_by' => array('photoplog_bad_posted_by_id', 1, 2), 'photoplog_title' => array('photoplog_bad_input', 1, 2), 'photoplog_description' => array('photoplog_bad_input', 1, 2), 'photoplog_posted_after' => array('photoplog_bad_date', 1, 2), 'photoplog_posted_before' => array('photoplog_bad_date', 1, 2), 'photoplog_filesize_at_least' => array('photoplog_bad_filesize', 1, 2), 'photoplog_filesize_at_most' => array('photoplog_bad_filesize', 1, 2), 'photoplog_width_at_least' => array('photoplog_bad_width', 1, 2), 'photoplog_width_at_most' => array('photoplog_bad_width', 1, 2), 'photoplog_height_at_least' => array('photoplog_bad_height', 1, 2), 'photoplog_height_at_most' => array('photoplog_bad_height', 1, 2), 'photoplog_number_views_at_least' => array('photoplog_bad_number_views', 1, 2), 'photoplog_number_views_at_most' => array('photoplog_bad_number_views', 1, 2), 'photoplog_last_comment_after' => array('photoplog_bad_date', 1, 2), 'photoplog_last_comment_before' => array('photoplog_bad_date', 1, 2), 'photoplog_number_comments_at_least' => array('photoplog_bad_number_comments', 1, 2), 'photoplog_number_comments_at_most' => array('photoplog_bad_number_comments', 1, 2), 'photoplog_number_ratings_at_least' => array('photoplog_bad_number_ratings', 1, 2), 'photoplog_number_ratings_at_most' => array('photoplog_bad_number_ratings', 1, 2), 'photoplog_average_rating_ge' => array('photoplog_bad_average_rating', 1, 2), 'photoplog_average_rating_le' => array('photoplog_bad_average_rating', 1, 2), 'photoplog_destination_category' => array('photoplog_bad_destination_category', 1), 'photoplog_make_subcategories' => array('photoplog_bad_input', 1), 'photoplog_destination_posted_by' => array('photoplog_bad_posted_by_id', 1), 'photoplog_destination_posted_on' => array('photoplog_bad_date', 1));
$vbulletin->input->clean_array_gpc('p', $photoplog_input_names);
$photoplog_blank_to_minus_one = array('photoplog_filesize_at_most', 'photoplog_filesize_at_least', 'photoplog_width_at_most', 'photoplog_width_at_least', 'photoplog_height_at_most', 'photoplog_height_at_least', 'photoplog_number_views_at_most', 'photoplog_number_views_at_least', 'photoplog_number_comments_at_most', 'photoplog_number_comments_at_least', 'photoplog_number_ratings_at_most', 'photoplog_number_ratings_at_least', 'photoplog_destination_posted_by');
$photoplog_input_okay = array();
foreach ($photoplog_input_names as $photoplog_key => $photoplog_value) {
${$photoplog_key} = $vbulletin->GPC[$photoplog_key];
$photoplog_input_okay[$photoplog_key] = true;
if (($photoplog_value == TYPE_INT || $photoplog_value == TYPE_UINT) && isset($_REQUEST[$photoplog_key]) && trim($_REQUEST[$photoplog_key]) != '' && strval(${$photoplog_key}) != trim($_REQUEST[$photoplog_key])) {
$photoplog_input_okay[$photoplog_key] = false;
}
if ($photoplog_value == TYPE_ARRAY_INT || $photoplog_value == TYPE_ARRAY_UINT) {
}
$award = $db->query_first("\n\t\tSELECT au.*, aw.* \n\t\tFROM " . TABLE_PREFIX . "award_user AS au\n\t\tLEFT JOIN " . TABLE_PREFIX . "award AS aw ON (aw.award_id = au.award_id)\n\t\tWHERE au.issue_id = " . $vbulletin->GPC['issue_id'] . "\n\t");
print_form_header();
print_table_header(construct_phrase($vbphrase['x_y_id_z'], $vbphrase['award_name'], $award['award_name'], $award['award_id']), 4, 0);
echo "\n <col align=\"center\" style=\"white-space:nowrap\"></col>\n <col width=\"50%\" align=\"{$stylevar['left']}\"></col>\n <col align=\"center\" style=\"white-space:nowrap\"></col>\n <col align=\"center\" style=\"white-space:nowrap\"></col>\n ";
print_cells_row(array($vbphrase['award_name'], $vbphrase['award_description'], $vbphrase['award_icon'], $vbphrase['award_image']), 1, '', -1);
echo "\n <tr>\n\t\t<td class=\"{$bgclass}\"><strong>{$award['award_name']}</strong></td>\n\t\t<td class=\"{$bgclass}\"><dfn>{$award[award_desc]}</dfn></td>\n\t\t<td class=\"{$bgclass}\" align=\"center\"><img src=\"" . iif(substr($award[award_icon_url], 0, 7) != 'http://' and substr($award[award_icon_url], 0, 1) != '/', '../', '') . "{$award['award_icon_url']}\" border=\"0\"></td>\n\t\t<td class=\"{$bgclass}\" align=\"center\"><img src=\"" . iif(substr($award[award_img_url], 0, 7) != 'http://' and substr($award[award_img_url], 0, 1) != '/', '../', '') . "{$award['award_img_url']}\" border=\"0\"></td>\n </tr>";
print_table_footer();
print_form_header('award', 'doeditissuedaward');
construct_hidden_code('issue_id', $vbulletin->GPC['issue_id']);
construct_hidden_code('award_id', $award['award_id']);
print_table_header("{$vbphrase['edit']} {$vbphrase['user_awards']}", 2, 0);
print_input_row($vbphrase['userid'], 'awarduserid', $award['userid']);
print_input_row($vbphrase['username'], 'awardusername', $award['username']);
print_textarea_row($vbphrase['award_reason'], 'issue_reason', $award['issue_reason'], 3, 33);
print_time_row($vbphrase['award_time'], 'issue_time', $award['issue_time']);
print_submit_row($vbphrase['save']);
}
// ###################### Start do give award #######################
if ($_POST['do'] == 'dogiveaward') {
$vbulletin->input->clean_array_gpc('p', array('award_id' => TYPE_INT, 'award_name' => TYPE_STR, 'award_img_url' => TYPE_STR, 'awarduserid' => TYPE_INT, 'awardusername' => TYPE_STR, 'issue_reason' => TYPE_STR, 'award_sendpm' => TYPE_INT, 'award_sendemail' => TYPE_INT));
if (!empty($vbulletin->GPC['awarduserid'])) {
$user = $db->query_first("\n\t\t\tSELECT userid, username, email\n\t\t\tFROM " . TABLE_PREFIX . "user\n\t\t\tWHERE userid = " . $vbulletin->GPC['awarduserid'] . "\n\t\t");
} else {
if (!empty($vbulletin->GPC['awardusername'])) {
$user = $db->query_first("\n\t\t\tSELECT userid, username\n\t\t\tFROM " . TABLE_PREFIX . "user\n\t\t\tWHERE username = '******'awardusername'] . "'\n\t\t");
} else {
print_stop_message('please_complete_required_fields');
}
}
if (empty($user)) {
