function print_move_prune_rows($permcheck = '')
{
global $vbphrase;
print_description_row($vbphrase['date_options'], 0, 2, 'thead', 'center');
print_input_row($vbphrase['original_post_date_is_at_least_xx_days_ago'], 'thread[originaldaysolder]', 0, 1, 5);
print_input_row($vbphrase['original_post_date_is_at_most_xx_days_ago'] . '<dfn>' . construct_phrase($vbphrase['note_leave_x_specify_no_limit'], '0') . '</dfn>', 'thread[originaldaysnewer]', 0, 1, 5);
print_input_row($vbphrase['last_post_date_is_at_least_xx_days_ago'], 'thread[lastdaysolder]', 0, 1, 5);
print_input_row($vbphrase['last_post_date_is_at_most_xx_days_ago'] . '<dfn>' . construct_phrase($vbphrase['note_leave_x_specify_no_limit'], '0') . '</dfn>', 'thread[lastdaysnewer]', 0, 1, 5);
print_description_row($vbphrase['view_options'], 0, 2, 'thead', 'center');
print_input_row($vbphrase['thread_has_at_least_xx_replies'], 'thread[repliesleast]', 0, 1, 5);
print_input_row($vbphrase['thread_has_at_most_xx_replies'] . '<dfn>' . construct_phrase($vbphrase['note_leave_x_specify_no_limit'], '-1') . '</dfn>', 'thread[repliesmost]', -1, 1, 5);
print_input_row($vbphrase['thread_has_at_least_xx_views'], 'thread[viewsleast]', 0, 1, 5);
print_input_row($vbphrase['thread_has_at_most_xx_views'] . '<dfn>' . construct_phrase($vbphrase['note_leave_x_specify_no_limit'], '-1') . '</dfn>', 'thread[viewsmost]', -1, 1, 5);
print_description_row($vbphrase['status_options'], 0, 2, 'thead', 'center');
print_yes_no_other_row($vbphrase['thread_is_sticky'], 'thread[issticky]', $vbphrase['either'], 0);
$state = array('visible' => $vbphrase['visible'], 'moderation' => $vbphrase['awaiting_moderation'], 'deleted' => $vbphrase['deleted'], 'any' => $vbphrase['any']);
print_radio_row($vbphrase['thread_state'], 'thread[state]', $state, 'any');
$status = array('open' => $vbphrase['open'], 'closed' => $vbphrase['closed'], 'redirect' => $vbphrase['redirect'], 'not_redirect' => $vbphrase['not_redirect'], 'any' => $vbphrase['any']);
print_radio_row($vbphrase['thread_status'], 'thread[status]', $status, 'not_redirect');
print_description_row($vbphrase['other_options'], 0, 2, 'thead', 'center');
print_input_row($vbphrase['username'], 'thread[posteduser]');
print_input_row($vbphrase['title'], 'thread[titlecontains]');
print_moderator_forum_chooser('thread[forumid]', -1, $vbphrase['all_forums'], $vbphrase['forum'], true, false, true, $permcheck);
print_yes_no_row($vbphrase['include_child_forums'], 'thread[subforums]');
if ($prefix_options = construct_prefix_options(0, '', true, true)) {
print_label_row($vbphrase['prefix'], '<select name="thread[prefixid]" class="bginput">' . $prefix_options . '</select>', '', 'top', 'prefixid');
}
}
function print_diagnostic_test_result($status, $reasons = array(), $exit = 1)
{
// $status values = -1: indeterminate; 0: failed; 1: passed
// $reasons a list of reasons why the test passed/failed
// $exit values = 0: continue execution; 1: stop here
global $vbphrase;
print_form_header('', '');
print_table_header($vbphrase['results']);
if (is_array($reasons))
{
foreach ($reasons AS $reason)
{
print_description_row($reason);
}
}
else if (!empty($reasons))
{
print_description_row($reasons);
}
print_table_footer();
if ($exit == 1)
{
print_cp_footer();
}
}
public function print_editor($masterstyleid)
{
global $vbulletin, $vbphrase;
$addon = $masterstyleid == -2 ? '_mobile' : '';
$header = $vbphrase["stylevar_{$this->stylevarid}_name{$addon}"] ? $vbphrase["stylevar_{$this->stylevarid}_name{$addon}"] : $this->stylevarid;
$addbit = false;
if ($vbulletin->GPC['dostyleid'] == -1 or $vbulletin->GPC['dostyleid'] == -2) {
$header .= ' - <span class="smallfont">' . construct_link_code($vbphrase['edit'], "stylevar.php?" . $vbulletin->session->vars['sessionurl'] . "do=dfnedit&stylevarid=" . $this->stylevarid . "&dostyleid=" . $vbulletin->GPC['dostyleid']);
$addbit = true;
}
if ($this->inherited == -1 or $this->inherited == -2) {
if (!$addbit) {
$header .= ' - <span class="smallfont">';
} else {
$header .= ' - ';
}
$header .= (count($header) == 1 ? '<span class="smallfont">' : '') . construct_link_code($vbphrase['revert'], "stylevar.php?" . $vbulletin->session->vars['sessionurl'] . "do=confirmrevert&dostyleid=" . $vbulletin->GPC['dostyleid'] . "&stylevarid=" . $this->stylevarid . "&rootstyle=" . $this->inherited);
}
if ($addbit) {
$header .= '</span>';
}
print_table_header($header);
if ($vbphrase["stylevar_{$this->stylevarid}_description{$addon}"]) {
print_description_row($vbphrase["stylevar_{$this->stylevarid}_description{$addon}"], false, 2);
}
// once we have LSB change this to self::
$this->print_editor_form();
}
public function print_editor()
{
global $vbulletin, $vbphrase;
$vb5_config =& vB::getConfig();
$header = $vbphrase["stylevar_{$this->stylevarid}_name"] ? $vbphrase["stylevar_{$this->stylevarid}_name"] : $this->stylevarid;
$addbit = false;
if ($vbulletin->GPC['dostyleid'] == -1) {
$header .= ' - <span class="smallfont">' . construct_link_code($vbphrase['edit'], "stylevar.php?" . vB::getCurrentSession()->get('sessionurl') . "do=dfnedit&stylevarid=" . $this->stylevarid);
$addbit = true;
}
if ($this->inherited == -1) {
if (!$addbit) {
$header .= ' - <span class="smallfont">';
$addbit = true;
} else {
$header .= ' - ';
}
$header .= construct_link_code($vbphrase['revert_gcpglobal'], "stylevar.php?" . vB::getCurrentSession()->get('sessionurl') . "do=confirmrevert&dostyleid=" . $vbulletin->GPC['dostyleid'] . "&stylevarid=" . $this->stylevarid . "&rootstyle=-1");
}
if ($addbit) {
$header .= '</span>';
}
print_table_header($header);
if ($vbphrase["stylevar_{$this->stylevarid}_description"]) {
print_description_row($vbphrase["stylevar_{$this->stylevarid}_description"], false, 2);
}
if ($vb5_config['Misc']['debug']) {
print_label_row($vbphrase['stylevarid'], $this->stylevarid);
}
// output this stylevar's inheritance level (inherited or customized)
// so that we can update the stylevar list and show inherited status
// immediately
echo '<script type="text/javascript">
window.vBulletinStylevarInheritance = window.vBulletinStylevarInheritance ? window.vBulletinStylevarInheritance : {};
window.vBulletinStylevarInheritance["' . $this->stylevarid . '"] = ' . $this->inherited . ';
</script>';
// once we have LSB change this to self::
$this->print_editor_form();
}
construct_hidden_code('query', $query);
construct_hidden_code('perpage', $vbulletin->GPC['perpage']);
construct_hidden_code('confirmquery', 1);
print_table_header($vbphrase['confirm_query_execution']);
print_description_row($vbphrase['query_may_modify_database']);
print_submit_row($vbphrase['continue'], false, 2, $vbphrase['go_back']);
} else {
$time_before = microtime();
$db->query_write($query);
$time_taken = fetch_microtime_difference($time_before);
print_form_header('queries', 'doquery');
print_table_header($vbphrase['vbulletin_message']);
if ($errornum = $db->errno()) {
print_description_row(construct_phrase($vbphrase['an_error_occured_while_attempting_to_run_your_query'], $errornum, nl2br(htmlspecialchars_uni($db->error()))));
} else {
print_description_row(construct_phrase($vbphrase['affected_rows'], vb_number_format($db->affected_rows()), vb_number_format($time_taken, 4)));
}
print_table_footer();
}
break;
}
}
// ##################### START MODIFY #####################
if ($_REQUEST['do'] == 'modify') {
print_form_header('queries', 'doquery');
print_table_header($vbphrase['execute_sql_query']);
print_select_row($vbphrase['auto_query'], 'autoquery', $queryoptions, -1);
print_textarea_row($vbphrase['manual_query'], 'query', '', 10, 55);
print_input_row($vbphrase['results_to_show_per_page'], 'perpage', 20);
print_submit_row($vbphrase['continue']);
}
}
$db->query_write("\n\t\t\tREPLACE INTO " . TABLE_PREFIX . "phrase\n\t\t\t\t(languageid, fieldname, varname, text, product, username, dateline, version)\n\t\t\tVALUES\n\t\t\t\t(0,\n\t\t\t\t'reputationlevel',\n\t\t\t\t'reputation" . $vbulletin->GPC['reputationlevelid'] . "',\n\t\t\t\t'" . $db->escape_string($vbulletin->GPC['level']) . "',\n\t\t\t\t'vbulletin',\n\t\t\t\t'" . $db->escape_string($vbulletin->userinfo['username']) . "',\n\t\t\t\t" . TIMENOW . ",\n\t\t\t\t'" . $db->escape_string($vbulletin->options['templateversion']) . "')\n\t\t");
require_once DIR . '/includes/adminfunctions_language.php';
build_language();
print_stop_message('saved_reputation_level_x_successfully', htmlspecialchars_uni($vbulletin->GPC['level']));
} else {
print_stop_message('no_permission_duplicate_reputation');
}
}
// *************************************************************************************************
if ($_REQUEST['do'] == 'remove') {
$vbulletin->input->clean_array_gpc('r', array('minimumreputation' => TYPE_INT));
print_form_header('adminreputation', 'kill');
construct_hidden_code('minimumreputation', $vbulletin->GPC['minimumreputation']);
print_table_header($vbphrase['confirm_deletion']);
print_description_row(construct_phrase($vbphrase['are_you_sure_you_want_to_delete_the_reputation_level_x'], '<i>' . $vbulletin->GPC['minimumreputation'] . '</i>'));
print_submit_row($vbphrase['yes'], '', 2, $vbphrase['no']);
}
// *************************************************************************************************
if ($_POST['do'] == 'kill') {
$vbulletin->input->clean_array_gpc('p', array('minimumreputation' => TYPE_INT));
$reputationlevel = $db->query_first("\n\t\tSELECT reputationlevelid\n\t\tFROM " . TABLE_PREFIX . "reputationlevel\n\t\tWHERE minimumreputation = " . $vbulletin->GPC['minimumreputation']);
$db->query_write("\n\t\tDELETE FROM " . TABLE_PREFIX . "phrase\n\t\tWHERE fieldname = 'reputationlevel' AND\n\t\t\t\tvarname IN ('reputation{$reputationlevel['reputationlevelid']}')\n\t");
require_once DIR . '/includes/adminfunctions_language.php';
build_language();
$db->query_write("\n\t\tDELETE FROM " . TABLE_PREFIX . "reputationlevel\n\t\tWHERE minimumreputation = " . $vbulletin->GPC['minimumreputation']);
build_reputationids();
define('CP_REDIRECT', 'adminreputation.php?do=modify');
print_stop_message('deleted_reputation_level_successfully');
}
// *************************************************************************************************
print_stop_message('please_complete_required_fields');
}
if (empty($vbulletin->GPC['infractionbanid'])) {
$db->query_write("INSERT INTO " . TABLE_PREFIX . "infractionban (amount) VALUES (0)");
$vbulletin->GPC['infractionbanid'] = $db->insert_id();
}
$db->query_write("\n\t\tUPDATE " . TABLE_PREFIX . "infractionban\n\t\tSET amount = " . $vbulletin->GPC['amount'] . ",\n\t\t\tmethod = '" . $db->escape_string($vbulletin->GPC['method']) . "',\n\t\t\tusergroupid = " . $vbulletin->GPC['usergroupid'] . ",\n\t\t\tbanusergroupid = " . $vbulletin->GPC['banusergroupid'] . ",\n\t\t\tperiod = '" . $db->escape_string($vbulletin->GPC['period']) . "'\n\t\tWHERE infractionbanid = " . $vbulletin->GPC['infractionbanid'] . "\n\t");
define('CP_REDIRECT', 'admininfraction.php?do=modify');
print_stop_message('saved_automatic_ban_successfully');
}
// ###################### Start Remove #######################
if ($_REQUEST['do'] == 'removebangroup') {
print_form_header('admininfraction', 'killbangroup');
construct_hidden_code('infractionbanid', $vbulletin->GPC['infractionbanid']);
print_table_header(construct_phrase($vbphrase['confirm_deletion_x'], $vbphrase['automatic_ban']));
print_description_row($vbphrase['are_you_sure_you_want_to_delete_this_automatic_ban']);
print_submit_row($vbphrase['yes'], '', 2, $vbphrase['no']);
}
// ###################### Start Kill #######################
if ($_POST['do'] == 'killbangroup') {
$db->query_write("DELETE FROM " . TABLE_PREFIX . "infractionban WHERE infractionbanid = " . $vbulletin->GPC['infractionbanid']);
define('CP_REDIRECT', 'admininfraction.php?do=modify');
print_stop_message('deleted_automatic_ban_successfully');
}
print_cp_footer();
/*======================================================================*\
|| ####################################################################
|| # Downloaded: 12:39, Wed May 30th 2012
|| # CVS: $RCSfile$ - $Revision: 39862 $
|| ####################################################################
\*======================================================================*/
if ($vbulletin->GPC['editing']) {
$db->query_write("\r\n\t\t\tUPDATE " . TABLE_PREFIX . "product SET\r\n\t\t\t\ttitle = '" . $db->escape_string($vbulletin->GPC['title']) . "',\r\n\t\t\t\tdescription = '" . $db->escape_string($vbulletin->GPC['description']) . "',\r\n\t\t\t\tversion = '" . $db->escape_string($vbulletin->GPC['version']) . "',\r\n\t\t\t\turl = '" . $db->escape_string($vbulletin->GPC['url']) . "',\r\n\t\t\t\tversioncheckurl = '" . $db->escape_string($vbulletin->GPC['versioncheckurl']) . "'\r\n\t\t\tWHERE productid = '" . $db->escape_string($vbulletin->GPC['productid']) . "'\r\n\t\t");
} else {
// product IDs must match #^[a-z0-9_]+$# and must be max 25 chars
if (!preg_match('#^[a-z0-9_]+$#s', $vbulletin->GPC['productid']) or strlen($vbulletin->GPC['productid']) > 25) {
$sugg = preg_replace('#\\s+#s', '_', strtolower($vbulletin->GPC['productid']));
$sugg = preg_replace('#[^\\w]#s', '', $sugg);
$sugg = str_replace('__', '_', $sugg);
$sugg = substr($sugg, 0, 25);
print_stop_message('product_id_invalid', htmlspecialchars_uni($vbulletin->GPC['productid']), $sugg);
}
// reserve 'vb' prefix for official vBulletin products
if (!$vbulletin->GPC['confirm'] and strtolower(substr($vbulletin->GPC['productid'], 0, 2)) == 'vb') {
print_form_header('plugin', 'productsave');
print_table_header($vbphrase['vbulletin_message']);
print_description_row(htmlspecialchars_uni($vbulletin->GPC['title']) . ' ' . htmlspecialchars_uni($vbulletin->GPC['version']) . '<dfn>' . htmlspecialchars_uni($vbulletin->GPC['description']) . '</dfn>');
print_input_row($vbphrase['vb_prefix_reserved'], 'productid', $vbulletin->GPC['productid'], true, 35, 25);
construct_hidden_code('title', $vbulletin->GPC['title']);
construct_hidden_code('description', $vbulletin->GPC['description']);
construct_hidden_code('version', $vbulletin->GPC['version']);
construct_hidden_code('confirm', 1);
print_submit_row();
print_cp_footer();
// execution terminates here
}
/* insert query */
$db->query_write("\r\n\t\t\tINSERT INTO " . TABLE_PREFIX . "product\r\n\t\t\t\t(productid, title, description, version, active, url, versioncheckurl)\r\n\t\t\tVALUES\r\n\t\t\t\t('" . $db->escape_string($vbulletin->GPC['productid']) . "',\r\n\t\t\t\t'" . $db->escape_string($vbulletin->GPC['title']) . "',\r\n\t\t\t\t'" . $db->escape_string($vbulletin->GPC['description']) . "',\r\n\t\t\t\t'" . $db->escape_string($vbulletin->GPC['version']) . "',\r\n\t\t\t\t1,\r\n\t\t\t\t'" . $db->escape_string($vbulletin->GPC['url']) . "',\r\n\t\t\t\t'" . $db->escape_string($vbulletin->GPC['versioncheckurl']) . "')\r\n\t\t");
}
// update the products datastore
build_product_datastore();
// reload block types
if (!empty($modlist)) {
print_table_footer(1, $vbphrase['total'] . ": <b>" . count($modlist) . "</b>");
} else {
print_table_footer();
}
}
// ###################### Start Remove moderator from all forums #######################
if ($_REQUEST['do'] == 'removeall') {
$modinfo = $db->query_first("\n\t\tSELECT username FROM " . TABLE_PREFIX . "moderator AS moderator\n\t\tLEFT JOIN " . TABLE_PREFIX . "user AS user USING(userid)\n\t\tWHERE moderator.userid = " . $vbulletin->GPC['userid'] . "\n\t");
if (!$modinfo) {
print_stop_message('user_no_longer_moderator');
}
print_form_header('moderator', 'killall', 0, 1, '', '75%');
construct_hidden_code('userid', $vbulletin->GPC['userid']);
print_table_header($vbphrase['confirm_deletion']);
print_description_row('<blockquote><br />' . $vbphrase['are_you_sure_you_want_to_delete_this_moderator'] . "<br /></blockquote>\n\t");
print_submit_row($vbphrase['yes'], 0, 2, $vbphrase['no']);
}
// ###################### Start Kill moderator from all forums #######################
if ($_POST['do'] == 'killall') {
if (empty($vbulletin->GPC['userid'])) {
print_stop_message('invalid_users_specified');
}
$getuserid = $db->query_first("\n\t\tSELECT user.*,\n\t\tIF (user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid\n\t\tFROM " . TABLE_PREFIX . "moderator AS moderator\n\t\tLEFT JOIN " . TABLE_PREFIX . "user AS user USING(userid)\n\t\tWHERE moderator.userid = " . $vbulletin->GPC['userid'] . "\n\t\t\tAND forumid <> -1\n\t");
if (!$getuserid) {
print_stop_message('user_no_longer_moderator');
} else {
($hook = vBulletinHook::fetch_hook('admin_moderator_killall')) ? eval($hook) : false;
$db->query_write("DELETE FROM " . TABLE_PREFIX . "moderator WHERE userid = " . $vbulletin->GPC['userid'] . " AND forumid <> -1");
// if the user is in the moderators usergroup, then move them to registered users usergroup
if ($getuserid['usergroupid'] == 7) {
/**
* Prints a block of controls for editing a CSS item on css.php?do=edit
*
* @param string Item title
* @param string Item description
* @param array Item info array
* @param boolean Print links edit section
* @param boolean Print table break
*/
function print_css_row($title, $description, $item, $dolinks = false, $restarttable = true)
{
global $bgcounter, $css, $css_info, $color, $vbphrase, $stylevar, $vbulletin;
static $item_js;
++$item_js;
$color = fetch_inherited_color($css_info["{$item}"], $vbulletin->GPC['dostyleid']);
$title = htmlspecialchars_uni($title);
switch ($css_info["{$item}"]) {
case -1:
$tblhead_title = $title;
$revertlink = '';
$revertctrl = '';
break;
case $vbulletin->GPC['dostyleid']:
$tblhead_title = "{$title} <span class=\"normal\">(" . $vbphrase['customized_in_this_style'] . ")</span>";
$revertlink = 'title=' . urlencode($title) . '&item=' . urlencode($item);
$revertctrl = "<label for=\"rvcss_{$item}\">{$vbphrase['revert_this_group_of_settings']}<input type=\"checkbox\" id=\"rvcss_{$item}\" name=\"delete[css][{$item}]\" value=\"1\" tabindex=\"1\" title=\"{$vbphrase['revert']}\" /></label>";
break;
default:
$tblhead_title = "{$title} <span class=\"normal\">(" . construct_phrase($vbphrase['customized_in_a_parent_style_x'], $css_info["{$item}"]) . ")</span>";
$revertlink = 'title=' . urlencode($title) . '&item=' . urlencode($item);
$revertctrl = '';
break;
}
echo "\n\n<!-- START {$title} CSS -->\n\n";
print_column_style_code(array('width: 50%', 'width: 50%'));
print_table_header($tblhead_title, 2);
print_label_row("\n\t<fieldset title=\"{$vbphrase['standard_css']}\">\n\t\t<legend>{$vbphrase['standard_css']}</legend>\n\t\t<table cellpadding=\"0\" cellspacing=\"2\" border=\"0\" width=\"100%\">\n\t\t<col width=\"50%\"></col>\n" . construct_css_input_row($vbphrase['background'], "['{$item}']['background']", $color, true) . construct_css_input_row($vbphrase['font_color'], "['{$item}']['color']", $color, true) . construct_css_input_row($vbphrase['font_style'], "['{$item}']['font']['style']", $color) . construct_css_input_row($vbphrase['font_size'], "['{$item}']['font']['size']", $color) . construct_css_input_row($vbphrase['font_family'], "['{$item}']['font']['family']", $color) . construct_text_align_code($vbphrase['alignment'], "['{$item}']['text-align']", $color) . "\n\t\t</table>\n\t\t</fieldset>\n\t", "\n\t\t<fieldset id=\"extra_a_{$item_js}\" title=\"{$vbphrase['extra_css']}\">\n\t\t<legend>{$vbphrase['extra_css']}</legend>\n\t\t<div align=\"center\" style=\"padding: 2px\">\n\t\t<textarea name=\"css[{$item}][EXTRA]\" rows=\"4\" cols=\"50\" class=\"{$color}\" style=\"padding: 2px; width: 90%\" tabindex=\"1\" dir=\"ltr\">" . htmlspecialchars_uni($css["{$item}"]['EXTRA']) . "</textarea>\n\t\t</div>\n\t\t</fieldset>\n\t\t" . iif($description != '', "<fieldset id=\"desc_a_{$item_js}\" title=\"{$vbphrase['description']}\" style=\"margin-bottom:4px;\">\n\t\t<legend>{$vbphrase['description']}</legend>\n\t\t<div class=\"smallfont\" style=\"margin:4px 4px 0px 4px\">\n\t\t\t<img src=\"../cpstyles/" . $vbulletin->options['cpstylefolder'] . "/cp_help.gif\" alt=\"{$title}\" align=\"{$stylevar['right']}\" style=\"padding:0px 0px 0px 2px\" />\n\t\t\t{$description}\n\t\t</div>\n\t\t</fieldset>") . "\n", 'alt2');
if (is_browser('mozilla')) {
echo "<script type=\"text/javascript\">reflow_fieldset('a_{$item_js}', true);</script>\n";
}
if ($dolinks) {
print_description_row('
<table cellpadding="4" cellspacing="0" border="0" width="100%">
<tr>
' . construct_link_css_input_row($vbphrase['normal_link'], $item, 'N', $color) . '
' . construct_link_css_input_row($vbphrase['visited_link'], $item, 'V', $color) . '
' . construct_link_css_input_row($vbphrase['hover_link'], $item, 'M', $color) . '
</tr>
</table>
', 0, 2, 'alt2" style="padding: 0px');
}
if ($revertctrl != '') {
print_description_row('<div class="smallfont" style="text-align: center">' . $revertctrl . '</div>', 0, 2, 'thead');
}
print_description_row("\n\t\t<div class=\"alt1\" style=\"border:inset 1px; padding:2px 10px 2px 10px; float:{$stylevar['left']}\">" . construct_phrase($vbphrase['css_selector_x'], "<code>{$item}</code>") . "</div>\n\t\t<!--" . iif($revertlink != '', "<input type=\"button\" class=\"button\" style=\"font-weight:normal\" value=\"{$vbphrase['show_default']}\" tabindex=\"1\" onclick=\"js_show_default_item('{$revertlink}', {$dolinks});\" />") . "-->\n\t\t<input type=\"submit\" class=\"button\" style=\"font-weight:normal\" value=\" " . $vbphrase['save_css'] . " \" tabindex=\"1\" />\n\t", 0, 2, 'tfoot" align="right');
echo "\n\n<!-- END {$title} CSS -->\n\n";
if ($restarttable) {
print_table_break(' ');
}
}
} else {
return '';
}
}
// ###################### Start modify #######################
if ($_REQUEST['do'] == 'modify') {
print_form_header('', '');
print_table_header($vbphrase['additional_functions_gcppermission']);
print_description_row("<b><a href=\"forumpermission.php?" . vB::getCurrentSession()->get('sessionurl') . "do=duplicate\">" . $vbphrase['permission_duplication_tools'] . "</a> | <a href=\"forumpermission.php?" . vB::getCurrentSession()->get('sessionurl') . "do=quickedit\">" . $vbphrase['permissions_quick_editor'] . "</a> | <a href=\"forumpermission.php?" . vB::getCurrentSession()->get('sessionurl') . "do=quickforum\">" . $vbphrase['quick_channel_permission_setup'] . "</a></b>", 0, 2, '', 'center');
print_table_footer();
print_form_header('', '');
print_table_header($vbphrase['view_channel_permissions_gcppermission']);
print_description_row('
<div class="darkbg" style="border: 2px inset"><ul class="darkbg">
<li><b>' . $vbphrase['color_key'] . '</b></li>
<li class="col-g">' . $vbphrase['standard_using_default_channel_permissions'] . '</li>
<li class="col-c">' . $vbphrase['customized_using_custom_permissions_for_this_usergroup_gcppermission'] . '</li>
<li class="col-i">' . $vbphrase['inherited_using_custom_permissions_inherited_channel_a_parent_channel'] . '</li>
</ul></div>
');
print_table_footer();
require_once DIR . '/includes/functions_forumlist.php';
// get moderators
cache_moderators();
//query channel permissions
$result = vB::getDbAssertor()->assertQuery('vBForum:permission', array(vB_dB_Query::TYPE_KEY => vB_dB_Query::QUERY_SELECT));
$npermscache = array();
foreach ($result as $permission) {
$npermscache[$permission['nodeid']][$permission['groupid']] = $permission;
}
// get usergroup default permissions
$permissions = array();
print_description_row('<table width="100%" border="0"><tr><td width="22%"><font color="' . $color . '">' . $template_phrases[$template['id'] . "_" . $template['varname'] . "_subject"] . '</font></td><td width="29%">' . date("m-d-Y h:i:s A", $campaign['send_when']) . '</td><td width="8%">' . $sent . '</td><td width="8%">' . $failed . '</td><td width="15%">' . $unique_reads . '</td><td width="12%"><a href="qhvbmailer.php?do=manage_campaigns&act=2&campaign_id=' . $campaign['id'] . '">Full Stats</a></td><td width="8%"><a href="qhvbmailer.php?do=manage_campaigns&act=3&campaign_id=' . $campaign['id'] . '">Delete</a></tr></table>');
}
print_submit_row('Refresh', '');
} elseif ($_GET['act'] == 2) {
$vbulletin->input->clean_array_gpc('g', array('campaign_id' => TYPE_UINT));
$campaign_id = $vbulletin->GPC['campaign_id'];
if ($campaign_id > 0) {
$sent = countTracks($campaign_id, 'sent');
$failed = countTracks($campaign_id, 'failed');
$unqread = countTracks($campaign_id, 'unique_read');
$read = countTracks($campaign_id, 'read');
$links = countTracks($campaign_id, 'link');
print_form_header('qhvbmailer', 'manage_campaigns');
print_table_header('Campaign Statistics');
if (file_exists(DIR . '/includes/charts/chart.php')) {
print_description_row('<center>' . InsertChart('../includes/charts/charts.swf', '../includes/charts/charts_library', '../includes/charts/chart.php?sent=' . $sent . '&failed=' . $failed . '&unqread=' . $unqread . '&read=' . $read . '&links=' . $links, 400, 320, 'FFFFFF', true) . '</center>');
} else {
print_cp_message('No charts file!', 'qhvbmailer.php?do=manage_campaigns', 2);
}
print_submit_row('Back', '');
} else {
print_cp_message('Campaign ID must be greater than zero!', 'qhvbmailer.php?do=manage_campaigns', 2);
}
} elseif ($_GET['act'] == 3) {
$vbulletin->input->clean_array_gpc('g', array('campaign_id' => TYPE_UINT));
if ($vbulletin->GPC['campaign_id'] > 0) {
$db->query_write("DELETE FROM " . TABLE_PREFIX . "qhvbmailer_campaigns WHERE id='" . $vbulletin->GPC['campaign_id'] . "'");
print_cp_message('Campaign deleted!', 'qhvbmailer.php?do=manage_campaigns', 1);
} else {
print_cp_message('Campaign ID must be greater than zero!', 'qhvbmailer.php?do=manage_campaigns', 2);
}
print_submit_row($vbphrase['go'], $vbphrase['check_all'], 7);
echo '<p>' . $vbphrase['this_action_is_not_reversible'] . '</p>';
} else {
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 ($vbulletin->GPC['product']) {
if ($vbulletin->GPC['product'] == 'vbulletin') {
$sqlconds[] = "product IN ('', 'vbulletin')";
} else {
$sqlconds[] = "product = '" . $db->escape_string($vbulletin->GPC['product']) . "'";
}
}
$logs = $db->query_first("\n\t\tSELECT COUNT(*) AS total\n\t\tFROM " . TABLE_PREFIX . "moderatorlog\n\t\tWHERE " . (!empty($sqlconds) ? implode("\r\n\tAND ", $sqlconds) : "") . "\n\t");
if ($logs['total']) {
print_form_header('modlog', 'doprunelog');
construct_hidden_code('datecut', $datecut);
construct_hidden_code('modaction', $vbulletin->GPC['modaction']);
construct_hidden_code('userid', $vbulletin->GPC['userid']);
construct_hidden_code('product', $vbulletin->GPC['product']);
print_table_header($vbphrase['prune_moderator_log']);
print_description_row(construct_phrase($vbphrase['are_you_sure_you_want_to_prune_x_log_entries_from_moderator_log'], vb_number_format($logs['total'])));
print_submit_row($vbphrase['yes'], 0, 0, $vbphrase['no']);
} else {
print_stop_message('no_logs_matched_your_query');
}
}
// ###################### Start do prune log #######################
if ($_POST['do'] == 'doprunelog' and can_access_logs($vbulletin->config['SpecialUsers']['canpruneadminlog'], 0, '<p>' . $vbphrase['control_panel_log_pruning_permission_restricted'] . '</p>')) {
$vbulletin->input->clean_array_gpc('p', array('datecut' => TYPE_UINT, 'modaction' => TYPE_STR, 'userid' => TYPE_UINT, 'product' => TYPE_STR));
$sqlconds = array("dateline < " . $vbulletin->GPC['datecut']);
if (!empty($vbulletin->GPC['modaction'])) {
$sqlconds[] = "action LIKE '%" . $db->escape_string_like($vbulletin->GPC['modaction']) . "%'";
}
if (!empty($vbulletin->GPC['userid'])) {
$sqlconds[] = "userid = " . $vbulletin->GPC['userid'];
}
} else {
header("Content-disposition: attachment; filename=\"vbulletin.sql\"");
$result = $db->query_write("SHOW tables");
while ($currow = $db->fetch_row($result)) {
echo fetch_table_dump_sql($currow[0]) . "\n\n\n";
}
}
echo "\r\n\r\n\r\n### {$upgradecore_phrases['vb_db_dump_completed']} ###";
exit;
}
if ($_REQUEST['do'] == 'choose') {
print_upgrade_header();
echo '</div>';
print_form_header('', '');
print_table_header($upgradecode_phrases['vb_database_backup_system']);
print_description_row($upgradecore_phrases['dump_database_desc']);
print_table_footer();
$sqltable = array('all tables' => $upgradecore_phrases['dump_all_tables']);
$tables = $db->query_write("SHOW TABLES");
while ($table = $db->fetch_array($tables, DBARRAY_NUM)) {
$sqltable["{$table['0']}"] = $table[0];
}
print_form_header('upgrade_300b3', 'sqltable');
print_table_header($upgradecore_phrases['dump_data_to_sql']);
construct_hidden_code('step', 'backup');
print_label_row($upgradecore_phrases['choose_table_to_dump'], '<select name="table" class="bginput">' . construct_select_options($sqltable) . '</select>');
print_submit_row($upgradecore_phrases['dump_tables'], 0);
unset($sqltable['all tables']);
print_form_header('upgrade_300b3', 'csvtable');
print_table_header($upgradecore_phrases['dump_data_to_csv']);
construct_hidden_code('step', 'backup');
function print_user_search_rows($email = false)
{
global $vbulletin, $vbphrase, $stylevar;
print_label_row($vbphrase['username'], "\n\t\t<input type=\"text\" class=\"bginput\" name=\"user[username]\" tabindex=\"1\" size=\"35\"\n\t\t/><input type=\"image\" src=\"../" . $vbulletin->options['cleargifurl'] . "\" width=\"1\" height=\"1\"\n\t\t/><input type=\"submit\" class=\"button\" value=\"{$vbphrase['exact_match']}\" tabindex=\"1\" name=\"user[exact]\" />\n\t", '', 'top', 'user[username]');
if ($email) {
global $iusergroupcache;
$userarray = array('usergroupid' => 0, 'membergroupids' => '');
$iusergroupcache = array();
$usergroups = $vbulletin->db->query_read("SELECT usergroupid, title, (forumpermissions & " . $vbulletin->bf_ugp_forumpermissions['canview'] . ") AS CANVIEW FROM " . TABLE_PREFIX . "usergroup ORDER BY title");
while ($usergroup = $vbulletin->db->fetch_array($usergroups)) {
if ($usergroup['CANVIEW']) {
$userarray['membergroupids'] .= "{$usergroup['usergroupid']},";
}
$iusergroupcache["{$usergroup['usergroupid']}"] = $usergroup['title'];
}
unset($usergroup);
$vbulletin->db->free_result($usergroups);
print_checkbox_row($vbphrase['all_usergroups'], 'usergroup_all', 0, -1, $vbphrase['all_usergroups'], 'check_all_usergroups(this.form, this.checked);');
print_membergroup_row($vbphrase['primary_usergroup'], 'user[usergroupid]', 2, $userarray);
print_membergroup_row($vbphrase['additional_usergroups'], 'user[membergroup]', 2);
print_yes_no_row($vbphrase['include_users_that_have_declined_email'], 'user[adminemail]', 0);
} else {
print_chooser_row($vbphrase['primary_usergroup'], 'user[usergroupid]', 'usergroup', -1, '-- ' . $vbphrase['all_usergroups'] . ' --');
print_membergroup_row($vbphrase['additional_usergroups'], 'user[membergroup]', 2);
}
print_description_row('<div align="' . $stylevar['right'] . '"><input type="submit" class="button" value=" ' . iif($email, $vbphrase['submit'], $vbphrase['find']) . ' " tabindex="1" /></div>');
print_input_row($vbphrase['email'], 'user[email]');
print_input_row($vbphrase['parent_email_address'], 'user[parentemail]');
print_yes_no_other_row($vbphrase['coppa_user'], 'user[coppauser]', $vbphrase['either'], -1);
print_input_row($vbphrase['home_page'], 'user[homepage]');
print_input_row($vbphrase['icq_uin'], 'user[icq]');
print_input_row($vbphrase['aim_screen_name'], 'user[aim]');
print_input_row($vbphrase['yahoo_id'], 'user[yahoo]');
print_input_row($vbphrase['msn_id'], 'user[msn]');
print_input_row($vbphrase['skype_name'], 'user[skype]');
print_input_row($vbphrase['signature'], 'user[signature]');
print_input_row($vbphrase['user_title'], 'user[usertitle]');
print_input_row($vbphrase['join_date_is_after'] . '<dfn>(yyyy-mm-dd)</dfn>', 'user[joindateafter]');
print_input_row($vbphrase['join_date_is_before'] . '<dfn>(yyyy-mm-dd)</dfn>', 'user[joindatebefore]');
print_input_row($vbphrase['last_activity_is_after'] . '<dfn>(yyyy-mm-dd hh:mm:ss)</dfn>', 'user[lastactivityafter]');
print_input_row($vbphrase['last_activity_is_before'] . '<dfn>(yyyy-mm-dd hh:mm:ss)</dfn>', 'user[lastactivitybefore]');
print_input_row($vbphrase['last_post_is_after'] . '<dfn>(yyyy-mm-dd hh:mm:ss)</dfn>', 'user[lastpostafter]');
print_input_row($vbphrase['last_post_is_before'] . '<dfn>(yyyy-mm-dd hh:mm:ss)</dfn>', 'user[lastpostbefore]');
print_input_row($vbphrase['birthday_is_after'] . '<dfn>(yyyy-mm-dd)</dfn>', 'user[birthdayafter]');
print_input_row($vbphrase['birthday_is_before'] . '<dfn>(yyyy-mm-dd)</dfn>', 'user[birthdaybefore]');
print_input_row($vbphrase['posts_are_greater_than'], 'user[postslower]', '', 1, 7);
print_input_row($vbphrase['posts_are_less_than'], 'user[postsupper]', '', 1, 7);
print_input_row($vbphrase['reputation_is_greater_than'], 'user[reputationlower]', '', 1, 7);
print_input_row($vbphrase['reputation_is_less_than'], 'user[reputationupper]', '', 1, 7);
print_input_row($vbphrase['warnings_are_greater_than'], 'user[warningslower]', '', 1, 7);
print_input_row($vbphrase['warnings_are_less_than'], 'user[warningsupper]', '', 1, 7);
print_input_row($vbphrase['infractions_are_greater_than'], 'user[infractionslower]', '', 1, 7);
print_input_row($vbphrase['infractions_are_less_than'], 'user[infractionsupper]', '', 1, 7);
print_input_row($vbphrase['infraction_points_are_greater_than'], 'user[pointslower]', '', 1, 7);
print_input_row($vbphrase['infraction_points_are_less_than'], 'user[pointsupper]', '', 1, 7);
print_input_row($vbphrase['userid_is_greater_than'], 'user[useridlower]', '', 1, 7);
print_input_row($vbphrase['userid_is_less_than'], 'user[useridupper]', '', 1, 7);
print_input_row($vbphrase['registration_ip_address'], 'user[ipaddress]');
print_description_row('<div align="' . $stylevar['right'] . '"><input type="submit" class="button" value=" ' . iif($email, $vbphrase['submit'], $vbphrase['find']) . ' " tabindex="1" /></div>');
$forms = array(0 => $vbphrase['edit_your_details'], 1 => "{$vbphrase['options']}: {$vbphrase['log_in']} / {$vbphrase['privacy']}", 2 => "{$vbphrase['options']}: {$vbphrase['messaging']} / {$vbphrase['notification']}", 3 => "{$vbphrase['options']}: {$vbphrase['thread_viewing']}", 4 => "{$vbphrase['options']}: {$vbphrase['date']} / {$vbphrase['time']}", 5 => "{$vbphrase['options']}: {$vbphrase['other']}");
$currentform = -1;
print_table_header($vbphrase['user_profile_fields']);
$profilefields = $vbulletin->db->query_read("\n\t\tSELECT *\n\t\tFROM " . TABLE_PREFIX . "profilefield AS profilefield\n\t\tLEFT JOIN " . TABLE_PREFIX . "profilefieldcategory AS profilefieldcategory ON\n\t\t\t(profilefield.profilefieldcategoryid = profilefieldcategory.profilefieldcategoryid)\n\t\tORDER BY profilefield.form, profilefieldcategory.displayorder, profilefield.displayorder\n\t");
while ($profilefield = $vbulletin->db->fetch_array($profilefields)) {
if ($profilefield['form'] != $currentform) {
print_description_row(construct_phrase($vbphrase['fields_from_form_x'], $forms["{$profilefield['form']}"]), false, 2, 'optiontitle');
$currentform = $profilefield['form'];
}
$profilefield['def'] = 0;
print_profilefield_row('profile', $profilefield);
}
print_description_row('<div align="' . $stylevar['right'] . '"><input type="submit" class="button" value=" ' . iif($email, $vbphrase['submit'], $vbphrase['find']) . ' " tabindex="1" /></div>');
}
function print_ad_criterion($criteria_option_id, &$criteria_options, $criteria_cache)
{
global $vbphrase;
$criteria_option = $criteria_options["{$criteria_option_id}"];
print_description_row("<label><input type=\"checkbox\" id=\"cb_{$criteria_option_id}\" tabindex=\"1\" name=\"criteria[{$criteria_option_id}][active]\" title=\"{$vbphrase['criterion_is_active']}\" value=\"1\"" . (empty($criteria_cache["{$criteria_option_id}"]) ? '' : ' checked="checked"') . " />" . "<span id=\"span_{$criteria_option_id}\">" . construct_phrase($vbphrase[$criteria_option_id . '_criteria'], $criteria_option[0], $criteria_option[1], $criteria_option[2]) . '</span></label>');
unset($criteria_options["{$criteria_option_id}"]);
}
$phrasetypes = fetch_phrasetypes_array();
foreach($phrasetypes AS $fieldname => $type)
{
$typeoptions["$fieldname"] = construct_phrase($vbphrase['x_phrases'], $type['title']);
}
*/
print_form_header('language', 'add');
construct_hidden_code('goto', "language.php?" . $vbulletin->session->vars['sessionurl']);
print_table_header($vbphrase['language_manager'], 4);
print_cells_row(array($vbphrase['language'], '', '', $vbphrase['default']), 1);
if ($vbulletin->debug) {
print_language_row(array('languageid' => -1, 'title' => "<i>{$vbphrase['master_language']}</i>"));
}
$languages = fetch_languages_array();
foreach ($languages as $_languageid => $language) {
print_language_row($language);
}
print_description_row(construct_link_code($vbphrase['search_phrases'], "phrase.php?" . $vbulletin->session->vars['sessionurl'] . "do=search") . construct_link_code($vbphrase['view_quickref'], "javascript:js_open_phrase_ref(0,0);") . construct_link_code($vbphrase['rebuild_all_languages'], "language.php?" . $vbulletin->session->vars['sessionurl'] . "do=rebuild&goto=language.php?" . $vbulletin->session->vars['sessionurl']), 0, 4, 'thead" style="text-align:center; font-weight:normal');
print_table_footer(4, '
<input type="submit" class="button" value="' . $vbphrase['add_new_language'] . '" tabindex="1" />
<input type="button" class="button" value="' . $vbphrase['download_upload_language'] . '" tabindex="1" onclick="window.location=\'language.php?do=files\';" />
');
print_phrase_ref_popup_javascript();
}
print_cp_footer();
/*======================================================================*\
|| ####################################################################
|| # Downloaded: 12:56, Sat Oct 11th 2008
|| # CVS: $RCSfile$ - $Revision: 26900 $
|| ####################################################################
\*======================================================================*/
<?php
echo implode(",\r\n\t", $JS_PHRASES) . "\r\n";
?>
};
// -->
</script>
<?php
if (!FORMTYPE) {
print_form_header('', '');
print_table_header("{$vbphrase['styles']} & {$vbphrase['templates']}");
print_description_row('
<div class="darkbg" style="border: 2px inset"><ul class="darkbg">
<li><b>' . $vbphrase['color_key'] . '</b></li>
<li class="col-g">' . $vbphrase['template_is_unchanged_from_the_default_style'] . '</li>
<li class="col-i">' . $vbphrase['template_is_inherited_from_a_parent_style'] . '</li>
<li class="col-c">' . $vbphrase['template_is_customized_in_this_style'] . '</li>
</ul></div>
');
print_table_footer();
} else {
echo "<br />\n";
}
if ($help = construct_help_button('', NULL, '', 1)) {
$pagehelplink = "<div style=\"float:{$stylevar['right']}\">{$help}</div>";
} else {
$pagehelplink = '';
}
?>
<form action="template.php?do=displayorder" method="post" tabindex="1" name="tform">
verify_upload_folder($vbulletin->GPC['avatarpath']);
verify_upload_folder($vbulletin->GPC['profilepicpath']);
verify_upload_folder($vbulletin->GPC['sigpicpath']);
// update $vboptions
$db->query_write("\n\t\t\t\tUPDATE " . TABLE_PREFIX . "setting SET value =\n\t\t\t\tCASE varname\n\t\t\t\t\tWHEN 'avatarpath' THEN '" . $db->escape_string($vbulletin->GPC['avatarpath']) . "'\n\t\t\t\t\tWHEN 'avatarurl' THEN '" . $db->escape_string($vbulletin->GPC['avatarurl']) . "'\n\t\t\t\t\tWHEN 'profilepicpath' THEN '" . $db->escape_string($vbulletin->GPC['profilepicpath']) . "'\n\t\t\t\t\tWHEN 'profilepicurl' THEN '" . $db->escape_string($vbulletin->GPC['profilepicurl']) . "'\n\t\t\t\t\tWHEN 'sigpicpath' THEN '" . $db->escape_string($vbulletin->GPC['sigpicpath']) . "'\n\t\t\t\t\tWHEN 'sigpicurl' THEN '" . $db->escape_string($vbulletin->GPC['sigpicurl']) . "'\n\t\t\t\tELSE value END\n\t\t\t\tWHERE varname IN('avatarpath', 'avatarurl', 'profilepicurl', 'profilepicpath', 'sigpicurl', 'sigpicpath')\n\t\t\t");
build_options();
break;
}
// #############################################################################
print_form_header('avatar', 'domoveavatar');
print_table_header(construct_phrase($vbphrase['edit_storage_type'], "<span class=\"normal\">" . $vbphrase['user_pictures'] . "</span>"));
construct_hidden_code('dowhat', $vbulletin->GPC['dowhat']);
if ($vbulletin->GPC['dowhat'] == 'DB_to_FS') {
print_description_row($vbphrase['we_are_ready_to_attempt_to_move_your_images_from_database_to_filesystem']);
} else {
print_description_row($vbphrase['we_are_ready_to_attempt_to_move_your_images_from_filesystem_to_database']);
}
print_input_row($vbphrase['number_of_users_to_process_per_cycle'], 'perpage', 300, 1, 5);
print_submit_row($vbphrase['go']);
}
// ################### Move avatars ######################################
if ($_REQUEST['do'] == 'domoveavatar') {
$vbulletin->input->clean_array_gpc('r', array('perpage' => TYPE_INT, 'startat' => TYPE_INT));
if (is_demo_mode()) {
print_cp_message('This function is disabled within demo mode');
}
if ($vbulletin->GPC['perpage'] < 1) {
$vbulletin->GPC['perpage'] = 10;
}
if ($vbulletin->GPC['startat'] < 0) {
$vbulletin->GPC['startat'] = 0;
{
els[i].checked = toggle.checked;
}
}
// -->
</script>
<?php
if (!$prefixsets) {
print_description_row($vbphrase['no_prefix_sets_defined_click_create'], false, 3, '', 'center');
} else {
// display existing sets
foreach ($prefixsets as $prefixset) {
print_cells_row(array('<input id="' . $prefixset['prefixsetid'] . '" type="checkbox" onclick="selectprefixes(\'' . $prefixset['prefixsetid'] . '\')" />' . '<label for="' . $prefixset['prefixsetid'] . '">' . htmlspecialchars_uni($vbphrase["prefixset_{$prefixset['prefixsetid']}_title"]) . '</label>', '<input type="text" size="3" class="bginput" name="prefixset_order[' . $prefixset['prefixsetid'] . ']" value="' . $prefixset['displayorder'] . '" />', '<div class="normal">' . construct_link_code($vbphrase['add_prefix'], "prefix.php?do=addprefix&prefixsetid={$prefixset['prefixsetid']}") . construct_link_code($vbphrase['edit'], "prefix.php?do=editset&prefixsetid={$prefixset['prefixsetid']}") . construct_link_code($vbphrase['delete'], "prefix.php?do=deleteset&prefixsetid={$prefixset['prefixsetid']}") . '</div>'), 1);
if (!$prefixset['prefixes']) {
print_description_row(construct_phrase($vbphrase['no_prefixes_defined_click_create'], $prefixset['prefixsetid']), false, 3, '', 'center');
} else {
foreach ($prefixset['prefixes'] as $prefix) {
print_cells_row(array('<label for="' . $prefixset['prefixsetid'] . '_' . $prefix['prefixid'] . '">' . '<input type="checkbox" name="prefixids[' . $prefix["prefixid"] . ']" id="' . $prefixset['prefixsetid'] . '_' . $prefix['prefixid'] . '" class="' . $prefixset['prefixsetid'] . '" />' . htmlspecialchars_uni($vbphrase["prefix_{$prefix['prefixid']}_title_plain"]) . '</label>', '<input type="text" size="3" class="bginput" name="prefix_order[' . $prefix['prefixid'] . ']" value="' . $prefix['displayorder'] . '" />', '<div class="smallfont">' . construct_link_code($vbphrase['edit'], "prefix.php?do=editprefix&prefixid={$prefix['prefixid']}") . construct_link_code($vbphrase['delete'], "prefix.php?do=deleteprefix&prefixid={$prefix['prefixid']}") . construct_link_code($vbphrase['edit_permissions'], "prefix.php?do=permissions&prefixid={$prefix['prefixid']}") . '</div>'));
}
}
}
}
print_cells_row(array('<input type="image" style="width: 1px; height: 1px;" src="' . $vbulletin->options['cleargifurl'] . '" />' . '<input class="button" type="submit" name="dopermissionsmultiple" value="' . $vbphrase['edit_selected_prefix_permissions'] . '" />', '<input class="button" type="submit" value="' . $vbphrase['save_display_order'] . '" />', '<input class="button" type="button" onclick="window.location = \'prefix.php?do=addset\';" value="' . $vbphrase['add_prefix_set'] . '" />'), false, 'tfoot');
print_table_footer();
}
print_cp_footer();
/*======================================================================*\
|| ####################################################################
|| # Downloaded: 23:48, Wed Mar 24th 2010
|| # CVS: $RCSfile$ - $Revision: 32878 $
$db->query_write(fetch_query_sql($vbulletin->GPC['type'], 'attachmenttype', 'WHERE extension = \'' . $db->escape_string($vbulletin->GPC['extension']) . '\''));
build_attachment_permissions();
} else {
/*insert query*/
$db->query_write("\n\t\t\tINSERT INTO " . TABLE_PREFIX . "attachmenttype\n\t\t\t(\n\t\t\t\textension,\n\t\t\t\tsize,\n\t\t\t\theight,\n\t\t\t\twidth,\n\t\t\t\tmimetype,\n\t\t\t\tcontenttypes\n\t\t\t)\n\t\t\tVALUES\n\t\t\t(\n\t\t\t\t'" . $db->escape_string($vbulletin->GPC['type']['extension']) . "',\n\t\t\t\t" . intval($vbulletin->GPC['type']['size']) . ",\n\t\t\t\t" . intval($vbulletin->GPC['type']['height']) . ",\n\t\t\t\t" . intval($vbulletin->GPC['type']['width']) . ",\n\t\t\t\t'" . $db->escape_string($vbulletin->GPC['type']['mimetype']) . "',\n\t\t\t\t'" . $db->escape_string($vbulletin->GPC['type']['contenttype']) . "'\n\t\t\t)\n\t\t");
build_attachment_permissions();
}
print_stop_message('saved_attachment_type_x_successfully', $vbulletin->GPC['type']['extension']);
}
// ###################### Remove File Type ####################
if ($_REQUEST['do'] == 'removetype') {
$vbulletin->input->clean_array_gpc('r', array('extension' => TYPE_STR));
print_form_header('attachment', 'killtype', 0, 1, '', '75%');
construct_hidden_code('extension', $vbulletin->GPC['extension']);
print_table_header(construct_phrase($vbphrase['confirm_deletion_of_attachment_type_x'], $vbulletin->GPC['extension']));
print_description_row("\n\t\t<blockquote><br />" . construct_phrase($vbphrase['are_you_sure_you_want_to_delete_the_attachment_type_x'], $vbulletin->GPC['extension']) . "\n\t\t<br /></blockquote>\n\t");
print_submit_row($vbphrase['yes'], 0, 2, $vbphrase['no']);
}
// ###################### Kill File Type ####################
if ($_POST['do'] == 'killtype') {
$vbulletin->input->clean_array_gpc('r', array('extension' => TYPE_STR));
$db->query_write("\n\t\tDELETE FROM " . TABLE_PREFIX . "attachmenttype\n\t\tWHERE extension = '" . $db->escape_string($vbulletin->GPC['extension']) . "'\n\t");
$db->query_write("\n\t\tDELETE FROM " . TABLE_PREFIX . "attachmentpermission\n\t\tWHERE extension = '" . $db->escape_string($vbulletin->GPC['extension']) . "'\n\t");
build_attachment_permissions();
define('CP_REDIRECT', 'attachment.php?do=types');
print_stop_message('deleted_attachment_type_successfully');
}
print_cp_footer();
/*======================================================================*\
|| ####################################################################
|| # Downloaded: 03:13, Sat Sep 7th 2013
print_form_header('', '');
if ($resultcount != 1) {
print_table_header($vbphrase['action_specific_topics'], 1);
}
foreach ($specific as $topic) {
print_description_row("<a name=\"help{$topic['adminhelpid']}\">" . $helpphrase[fetch_help_phrase_short_name($topic, '_title')] . "</a>", 0, 1, 'thead');
print_description_row($helpphrase[fetch_help_phrase_short_name($topic, '_text')]);
}
print_table_footer();
}
if (sizeof($general)) {
reset($general);
print_form_header('', '');
if ($resultcount != 1) {
print_table_header($vbphrase['general_topics'], 1);
}
foreach ($general as $topic) {
print_description_row("<a name=\"help{$topic['adminhelpid']}\">" . $helpphrase[fetch_help_phrase_short_name($topic, '_title')] . "</a>", 0, 1, 'thead');
print_description_row($helpphrase[fetch_help_phrase_short_name($topic, '_text')]);
}
print_table_footer();
}
}
}
print_cp_footer();
/*======================================================================*\
|| ####################################################################
|| # Downloaded: 08:19, Wed Nov 5th 2008
|| # CVS: $RCSfile$ - $Revision: 13945 $
|| ####################################################################
\*======================================================================*/
echo "<blockquote><p> </p>";
echo "{$vbphrase['upgrade_wrong_version']}";
echo "<p> </p></blockquote>";
print_upgrade_footer();
}
}
// #############################################################################
// FINAL step (notice the SCRIPTCOMPLETE define)
if ($vbulletin->GPC['step'] == 1) {
$db->query_write("\r\n\t\tDELETE FROM " . TABLE_PREFIX . "phrase\r\n\t\tWHERE varname LIKE 'notice\\_%\\_title'\r\n\t\t\tAND fieldname = 'global'\r\n\t");
$db->query_write("\r\n\t\tALTER TABLE " . TABLE_PREFIX . "event CHANGE utc utc DECIMAL(4,2) NOT NULL DEFAULT '0.0'\r\n\t");
$rows = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "adminmessage WHERE varname = 'after_upgrade_password_check'");
if ($rows['count'] == 0) {
$db->query_write("\r\n\t\t\tINSERT INTO " . TABLE_PREFIX . "adminmessage\r\n\t\t\t\t(varname, dismissable, script, action, execurl, method, dateline, status)\r\n\t\t\tVALUES\r\n\t\t\t\t('after_upgrade_password_check', 1, 'passwordcheck.php', 'check', 'passwordcheck.php?do=check', 'get', " . TIMENOW . ", 'undone')\r\n\t\t\t\r\n\t\t");
}
print_form_header('', '');
print_table_header($upgrade_phrases['upgrade_373.php']['weak_password_notice']);
print_description_row($upgrade_phrases['upgrade_373.php']['weak_password_description']);
print_table_footer();
// tell log_upgrade_step() that the script is done
define('SCRIPTCOMPLETE', true);
}
// #############################################################################
print_next_step();
print_upgrade_footer();
/*======================================================================*\
|| ####################################################################
|| # Downloaded: 12:56, Sat Oct 11th 2008
|| # CVS: $RCSfile$ - $Revision: 13568 $
|| ####################################################################
\*======================================================================*/
{
case 'edit': window.location = "usertitle.php?<?php
echo vB::getCurrentSession()->get('sessionurl_js');
?>
do=edit&usertitleid=" + usertitleid; break;
case 'kill': window.location = "usertitle.php?<?php
echo vB::getCurrentSession()->get('sessionurl_js');
?>
do=remove&usertitleid=" + usertitleid; break;
default: return false; break;
}
}
</script>
<?php
$options = array('edit' => $vbphrase['edit'], 'kill' => $vbphrase['delete']);
print_form_header('usertitle', 'add');
print_table_header($vbphrase['user_title_manager_gcpuser'], 3);
print_description_row('<p>' . construct_phrase($vbphrase['it_is_recommended_that_you_update_user_titles'], vB::getCurrentSession()->get('sessionurl')) . '</p>', 0, 3);
print_cells_row(array($vbphrase['user_title_guser'], $vbphrase['minimum_posts'], $vbphrase['controls']), 1);
foreach ($usertitles as $usertitle) {
print_cells_row(array('<b>' . $usertitle['title'] . '</b>', $usertitle['minposts'], "\n\t<select name=\"u{$usertitle['usertitleid']}\" onchange=\"js_usergroup_jump({$usertitle['usertitleid']}, this);\" class=\"bginput\">\n" . construct_select_options($options) . "\t</select>\n\t<input type=\"button\" value=\"" . $vbphrase['go'] . "\" onclick=\"js_usergroup_jump({$usertitle['usertitleid']}, this.form.u{$usertitle['usertitleid']});\" />\n\t"));
}
print_submit_row($vbphrase['add_new_user_title_gcpuser'], 0, 3);
}
print_cp_footer();
/*=========================================================================*\
|| #######################################################################
|| # Downloaded: 15:45, Tue Sep 8th 2015
|| # CVS: $RCSfile$ - $Revision: 83432 $
|| #######################################################################
\*=========================================================================*/
function updatetemplate_print_error_page($template_un, $error)
{
global $vbulletin, $vbphrase;
print_form_header('template', 'updatetemplate', 0, 1, '', '75%');
construct_hidden_code('confirmerrors', 1);
construct_hidden_code('title', $vbulletin->GPC['title']);
construct_hidden_code('template', $template_un);
construct_hidden_code('templateid', $vbulletin->GPC['templateid']);
construct_hidden_code('group', $vbulletin->GPC['group']);
construct_hidden_code('searchstring', $vbulletin->GPC['searchstring']);
construct_hidden_code('dostyleid', $vbulletin->GPC['dostyleid']);
construct_hidden_code('product', $vbulletin->GPC['product']);
construct_hidden_code('savehistory', intval($vbulletin->GPC['savehistory']));
construct_hidden_code('histcomment', $vbulletin->GPC['histcomment']);
print_table_header($vbphrase['vbulletin_message']);
print_description_row($error);
print_submit_row($vbphrase['continue'], 0, 2, $vbphrase['go_back']);
print_cp_footer();
}
if ($pagecount > 1)
{
$pagenav = "<strong>$vbphrase[go_to_page]</strong>";
for ($thispage = 1; $thispage <= $pagecount; $thispage++)
{
if ($thispage == $vbulletin->GPC['pagenumber'])
{
$pagenav .= " <strong>[$thispage]</strong> ";
}
else
{
$pagenav .= " <a href=\"banning.php?$session[sessionurl]do=modify&page=$thispage\" class=\"normal\">$thispage</a> ";
}
}
print_description_row($pagenav, false, 8, '', 'right');
}
print_cells_row($headercell, 1);
while ($user = $db->fetch_array($permusers))
{
print_cells_row(construct_banned_user_row($user));
}
print_submit_row($vbphrase['ban_user'], 0, 8);
}
if (!$havebanned)
{
if ($canbanuser)
{
print_stop_message('no_users_banned_from_x_board_click_here', '<b>' . $vbulletin->options['bbtitle'] . '</b>', 'banning.php?' . $vbulletin->session->vars['sessionurl'] . 'do=banuser');
($hook = vBulletinHook::fetch_hook('nntp_gate_group_settings')) ? eval($hook) : false;
$is_active = $nntp_group->get_is_active();
if (is_null($is_active) || $is_active) {
$is_active = 'yes';
}
print_yes_no_row($vbphrase['nntp_group_is_active'], 'is_active', 'yes' == $is_active);
print_submit_row($vbphrase['save'], '', 2, $vbphrase['no']);
}
// ###################### Start Remove ###################################
if ($_REQUEST['do'] == 'remove_group') {
// check for there is no groups mapped to this one
// admincp_check_for_mapped_groups( $vbulletin->GPC['group_id'] );
print_form_header($this_script, 'kill_group');
construct_hidden_code('group_id', $vbulletin->GPC['group_id']);
print_table_header($vbphrase['confirm_deletion']);
print_description_row($vbphrase['nntp_are_you_sure_you_want_to_delete_this_group']);
print_submit_row($vbphrase['yes'], '', 2, $vbphrase['no']);
}
// ###################### Start Kill #####################################
if ($_REQUEST['do'] == 'kill_group') {
$group_id = $vbulletin->GPC['group_id'];
define('CP_REDIRECT', $this_script . '.php?do=list');
if ($nntp_group->delete_group($group_id)) {
print_stop_message('nntp_group_deleted_successfully');
} else {
print_stop_message('nntp_group_deleted_defeated');
}
}
// ###################### Start clean #####################################
if ($_REQUEST['do'] == 'group_clean') {
$group_id = $vbulletin->GPC['group_id'];
}
// ########################################################################
// we want to display the bookmark list - this is the default action
if ($_REQUEST['do'] == 'modify') {
if (!$vbulletin->options['socialbookmarks']) {
print_table_start();
print_description_row(fetch_error('social_bookmarks_disabled'));
print_table_footer(2, '', '', false);
}
// display the form and table header
print_form_header('bookmarksite', 'quickupdate');
print_table_header($vbphrase['social_bookmarking_manager'], 3);
$bookmarksites_result = $db->query_read("\n\t\tSELECT * FROM " . TABLE_PREFIX . "bookmarksite AS bookmarksite\n\t\tORDER BY displayorder, title\n\t");
$bookmarksite_count = $db->num_rows($bookmarksites_result);
if ($bookmarksite_count) {
print_description_row('<label><input type="checkbox" id="allbox" checked="checked" />' . $vbphrase['toggle_active_status_for_all'] . '</label><input type="image" src="../' . $vbulletin->options['cleargifurl'] . '" name="normalsubmit" />', false, 3, 'thead" style="font-weight:normal; padding:0px 4px 0px 4px');
print_column_style_code(array('width:20%; white-space:nowrap', 'width:60%', "width:20%; white-space:nowrap; text-align:{$stylevar['right']}"));
while ($bookmarksite = $db->fetch_array($bookmarksites_result)) {
print_cells_row(array('<label class="smallfont"><input type="checkbox" name="active[' . $bookmarksite['bookmarksiteid'] . ']" value="1"' . ($bookmarksite['active'] ? ' checked="checked"' : '') . ' />' . $vbphrase['active'] . '</label> ' . '<input type="image" src="../cpstyles/' . $vbulletin->options['cpstylefolder'] . '/move_down.gif" name="displayorderswap[' . $bookmarksite['bookmarksiteid'] . ',higher]" />' . '<input type="text" name="displayorder[' . $bookmarksite['bookmarksiteid'] . ']" value="' . $bookmarksite['displayorder'] . '" class="bginput" size="4" title="' . $vbphrase['display_order'] . '" style="text-align:' . $stylevar['right'] . '" />' . '<input type="image" src="../cpstyles/' . $vbulletin->options['cpstylefolder'] . '/move_up.gif" name="displayorderswap[' . $bookmarksite['bookmarksiteid'] . ',lower]" />', '<a href="bookmarksite.php?' . $vbulletin->session->vars['sessionurl'] . 'do=edit&bookmarksiteid=' . $bookmarksite['bookmarksiteid'] . '" title="' . $vbphrase['edit'] . '">' . $bookmarksite['title'] . '</a>', construct_link_code($vbphrase['edit'], 'bookmarksite.php?' . $vbulletin->session->vars['sessionurl'] . 'do=edit&bookmarksiteid=' . $bookmarksite['bookmarksiteid']) . construct_link_code($vbphrase['delete'], 'bookmarksite.php?' . $vbulletin->session->vars['sessionurl'] . 'do=delete&bookmarksiteid=' . $bookmarksite['bookmarksiteid'])), false, '', -1);
}
$db->free_result($bookmarksites_result);
}
echo '<tr>
<td class="tfoot">' . ($bookmarksite_count ? '<input type="submit" class="button" accesskey="s" value="' . $vbphrase['save'] . '" /> <input type="reset" class="button" accesskey="r" value="' . $vbphrase['reset'] . '" />' : ' ') . '</td>
<td class="tfoot" align="' . $stylevar['right'] . '" colspan="2"><input type="button" class="button" value="' . $vbphrase['add_new_social_bookmarking_site'] . '" onclick="window.location=\'bookmarksite.php?' . $vbulletin->session->vars['sessionurl'] . 'do=add\';" /></td>
</tr>';
print_table_footer();
?>
<script type="text/javascript">
<!--
function toggle_all_active(e)
/**
* Halts execution and shows the specified message
*
* @param string Message to display
* @param mixed If specified, a redirect will be performed to the URL in this parameter
* @param integer If redirect is specified, this is the time in seconds to delay before redirect
* @param string If specified, will provide a specific URL for "Go Back". If empty, no button will be displayed!
* @param bool If true along with redirect, 'CONTINUE' button will be used instead of automatic redirect
*/
function print_cp_message($text = '', $redirect = NULL, $delay = 1, $backurl = NULL, $continue = false)
{
global $vbulletin, $vbphrase;
if ($redirect and $vbulletin->session->vars['sessionurl']) {
if (strpos($redirect, '?') === false) {
$redirect .= '?';
}
$redirect .= '&' . $vbulletin->session->vars['sessionurl'];
}
if (!defined('DONE_CPHEADER')) {
print_cp_header($vbphrase['vbulletin_message']);
}
echo '<p> </p><p> </p>';
print_form_header('', '', 0, 1, 'messageform', '65%');
print_table_header($vbphrase['vbulletin_message']);
print_description_row("<blockquote><br />{$text}<br /><br /></blockquote>");
if ($redirect and $redirect !== NULL) {
// redirect to the new page
if ($continue) {
$continueurl = str_replace('&', '&', $redirect);
print_table_footer(2, construct_button_code($vbphrase['continue'], create_full_url($continueurl)));
} else {
print_table_footer();
$redirect_click = create_full_url($redirect);
$redirect_click = str_replace('"', '', $redirect_click);
echo '<p align="center" class="smallfont">' . construct_phrase($vbphrase['if_you_are_not_automatically_redirected_click_here_x'], $redirect_click) . "</p>\n";
print_cp_redirect($redirect, $delay);
}
} else {
// end the table and halt
if ($backurl === NULL) {
$backurl = 'javascript:history.back(1)';
}
if (strpos($backurl, 'history.back(') !== false) {
//if we are attempting to run a history.back(1), check we have a history to go back to, otherwise attempt to close the window.
$back_button = '
<input type="button" id="backbutton" class="button" value="' . $vbphrase['go_back'] . '" title="" tabindex="1" onclick="if (history.length) { history.back(1); } else { self.close(); }"/>
<script type="text/javascript">
<!--
if (history.length < 1 || ((is_saf || is_moz) && history.length <= 1)) // safari + gecko start at 1
{
document.getElementById("backbutton").parentNode.removeChild(document.getElementById("backbutton"));
}
//-->
</script>';
} else {
if ($backurl !== '') {
// regular window.location=url call
$backurl = create_full_url($backurl);
$backurl = str_replace(array('"', "'"), '', $backurl);
$back_button = '<input type="button" class="button" value="' . $vbphrase['go_back'] . '" title="" tabindex="1" onclick="window.location=\'' . $backurl . '\';"/>';
} else {
$back_button = '';
}
}
print_table_footer(2, $back_button);
}
// and now terminate the script
print_cp_footer();
}
