/**
* Prints a grid row for use in cms_admin.php?do=grid
*
* @param array Grid array containing gridid, title
*/
function print_grid_row($grid)
{
global $vbulletin, $typeoptions, $vbphrase;
$gridid = $grid['gridid'];
if ($grid['flattened'])
{
$options = array(
'grid_doflatten' => $vbphrase['edit'],
'grid_unflatten' => $vbphrase['unflatten_grid'],
'modifylayout' => $vbphrase['create_layout'],
'grid_delete' => $vbphrase['delete'],
);
}
else
{
$options = array(
'grid_modify' => $vbphrase['edit'],
'grid_flatten' => $vbphrase['flatten_grid'],
'modifylayout' => $vbphrase['create_layout'],
'grid_delete' => $vbphrase['delete'],
);
}
$cell = array();
$cell[] = $grid['title'];
$cell[] = "<span style=\"white-space:nowrap\">
<select name=\"g$grid[gridid]\" onchange=\"js_jump($grid[gridid], this);\" class=\"bginput\">" . construct_select_options($options) . "</select>
<input type=\"button\" value=\"" . $vbphrase['go'] . "\" onclick=\"js_jump($grid[gridid], this.form.g$grid[gridid]);\" class=\"button\" />
</span>";
print_cells_row($cell);
}
function print_image_item_row(&$cell)
{
// returns a row of five cells for use in $do==viewimages
global $img_per_row;
$cells = $img_per_row - sizeof($cell);
for ($i = 0; $i < $cells; $i++) {
$cell[] = '';
}
print_cells_row($cell, 0, 0, 1, 'bottom');
$cell = array();
}
function exec_sql_table_check($table)
{
global $vbulletin, $vbphrase;
$nooptimize = 0;
$error = 0;
if ($vbulletin->GPC['repairtables']) {
$checkmsgs = $vbulletin->db->query_write("CHECK TABLE `{$table}`");
while ($msg = $vbulletin->db->fetch_array($checkmsgs, DBARRAY_NUM)) {
if ($msg[2] == 'error') {
if ($msg[3] == 'The handler for the table doesn\'t support check/repair') {
$msg[2] = 'status';
$msg[3] = $vbphrase['this_table_does_not_support_repair_optimize'];
$nooptimize = 1;
} else {
$error = 1;
}
}
$cells = array($table, ucfirst($msg[1]), iif($error, '<b>' . ucfirst($msg[2]) . '</b>', ucfirst($msg[2])) . ': ' . $msg[3]);
print_cells_row($cells, 0, '', -4);
}
if ($error) {
$repairmsg = $vbulletin->db->query_first("REPAIR TABLE `{$table}`");
if ($repairmsg[3] != 'OK') {
$error2 = 1;
} else {
$error2 = 0;
$error = 0;
}
$cells = array($table, ucfirst($msg[1]), iif($error2, '<b>' . ucfirst($msg[2]) . '</b>', ucfirst($msg[2])));
print_cells_row($cells);
}
}
// end repairing
if ($vbulletin->GPC['optimizetables'] and !$error and !$error2 and !$nooptimize) {
$opimizemsgs = $vbulletin->db->query_write("OPTIMIZE TABLE `{$table}`");
while ($msg = $vbulletin->db->fetch_array($opimizemsgs, DBARRAY_NUM)) {
if ($msg[2] == 'error') {
$error = 1;
}
$cells = array($table, ucfirst($msg[1]), iif($error, '<b>' . ucfirst($msg[2]) . '</b>', ucfirst($msg[2])) . ': ' . $msg[3]);
print_cells_row($cells, 0, '', -4);
}
}
// end optimizing
}
$time_before = microtime();
$result = $db->query_write($query_mod);
$time_taken = fetch_microtime_difference($time_before);
$colcount = $db->num_fields($result);
print_table_header(construct_phrase($vbphrase['results_x_y'], vb_number_format($numrows), vb_number_format($time_taken, 4)) . ', ' . construct_phrase($vbphrase['page_x_of_y'], $vbulletin->GPC['pagenumber'], $numpages), $colcount);
if ($numrows) {
$collist = array();
for ($i = 0; $i < $colcount; $i++) {
$collist[] = $db->field_name($result, $i);
}
print_cells_row($collist, 1);
while ($record = $db->fetch_array($result)) {
foreach ($record as $colname => $value) {
$record["{$colname}"] = htmlspecialchars_uni($value);
}
print_cells_row($record, 0, '', -$colcount);
}
if ($numpages > 1) {
$extras = '<b>' . $vbphrase['page'] . '</b> <select name="page" tabindex="1" onchange="document.queryform.submit();" class="bginput">';
for ($i = 1; $i <= $numpages; $i++) {
$selected = iif($i == $vbulletin->GPC['pagenumber'], 'selected="selected"');
$extras .= "<option value=\"{$i}\" {$selected}>{$i}</option>";
}
$extras .= '</select> <input type="submit" class="button" tabindex="1" value="' . $vbphrase['go'] . '" accesskey="s" />';
} else {
$extras = '';
}
} else {
$extras = '';
}
}
$db->query_write("\n\t\tDELETE FROM " . TABLE_PREFIX . "reputation\n\t\tWHERE reputationid = " . $vbulletin->GPC['reputationid']);
define('CP_REDIRECT', "adminreputation.php?do=list&u={$repinfo['userid']}");
print_stop_message('deleted_reputation_successfully');
}
// *************************************************************************************************
if ($_REQUEST['do'] == 'deletereputation') {
$vbulletin->input->clean_array_gpc('r', array('reputationid' => TYPE_INT));
print_delete_confirmation('reputation', $vbulletin->GPC['reputationid'], 'adminreputation', 'killreputation');
}
if ($_REQUEST['do'] == 'modify') {
$reputationlevels = $db->query_read("\n\t\tSELECT *\n\t\tFROM " . TABLE_PREFIX . "reputationlevel\n\t\tORDER BY minimumreputation\n\t");
print_form_header('adminreputation', 'updateminimums');
print_table_header($vbphrase['user_reputation_manager'], 3);
print_cells_row(array($vbphrase['reputation_level'], $vbphrase['minimum_reputation_level'], $vbphrase['controls']), 1);
while ($reputationlevel = $db->fetch_array($reputationlevels)) {
$reputationlevel['level'] = htmlspecialchars_uni($vbphrase['reputation' . $reputationlevel['reputationlevelid']]);
$cell = array();
$cell[] = "{$vbphrase['user']} <b>{$reputationlevel['level']}</b>";
$cell[] = "<input type=\"text\" class=\"bginput\" tabindex=\"1\" name=\"reputation[{$reputationlevel['reputationlevelid']}]\" value=\"{$reputationlevel['minimumreputation']}\" size=\"5\" />";
$cell[] = construct_link_code($vbphrase['edit'], "adminreputation.php?" . $vbulletin->session->vars['sessionurl'] . "do=edit&reputationlevelid={$reputationlevel['reputationlevelid']}") . construct_link_code($vbphrase['delete'], "adminreputation.php?" . $vbulletin->session->vars['sessionurl'] . "do=remove&minimumreputation={$reputationlevel['minimumreputation']}");
print_cells_row($cell);
}
print_submit_row($vbphrase['update'], $vbphrase['reset'], 3);
}
print_cp_footer();
/*======================================================================*\
|| ####################################################################
|| # Downloaded: 03:13, Sat Sep 7th 2013
|| # CVS: $RCSfile$ - $Revision: 40911 $
|| ####################################################################
\*======================================================================*/
$productcodes = $db->query_read("\r\n\t\t\tSELECT *\r\n\t\t\tFROM " . TABLE_PREFIX . "productcode\r\n\t\t\tWHERE productid = '" . $db->escape_string($vbulletin->GPC['productid']) . "'\r\n\t\t\tORDER BY version\r\n\t\t");
if ($db->num_rows($productcodes)) {
print_table_header($vbphrase['existing_install_uninstall_code'], 4);
print_cells_row(array($vbphrase['version'], $vbphrase['install_code'], $vbphrase['uninstall_code'], $vbphrase['delete']), 1);
$productcodes_grouped = array();
$productcodes_versions = array();
while ($productcode = $db->fetch_array($productcodes)) {
// have to be careful here, as version numbers are not necessarily unique
$productcodes_versions["{$productcode['version']}"] = 1;
$productcodes_grouped["{$productcode['version']}"][] = $productcode;
}
$productcodes_versions = array_keys($productcodes_versions);
usort($productcodes_versions, 'version_sort');
foreach ($productcodes_versions as $version) {
foreach ($productcodes_grouped["{$version}"] as $productcode) {
print_cells_row(array("<input type=\"text\" name=\"productcode[{$productcode['productcodeid']}][version]\" value=\"" . htmlspecialchars_uni($productcode['version']) . "\" style=\"width:100%\" size=\"10\" />", "<textarea name=\"productcode[{$productcode['productcodeid']}][installcode]\" rows=\"5\" cols=\"40\" style=\"width:100%\" wrap=\"virtual\" tabindex=\"1\">" . htmlspecialchars($productcode['installcode']) . "</textarea>", "<textarea name=\"productcode[{$productcode['productcodeid']}][uninstallcode]\" rows=\"5\" cols=\"40\" style=\"width:100%\" wrap=\"virtual\" tabindex=\"1\">" . htmlspecialchars($productcode['uninstallcode']) . "</textarea>", "<input type=\"checkbox\" name=\"productcode[{$productcode['productcodeid']}][delete]\" value=\"1\" />"));
}
}
print_table_break();
}
print_table_header($vbphrase['add_new_install_uninstall_code']);
print_input_row($vbphrase['version'], 'version');
print_textarea_row($vbphrase['install_code'], 'installcode', '', 5, '70" style="width:100%');
print_textarea_row($vbphrase['uninstall_code'], 'uninstallcode', '', 5, '70" style="width:100%');
print_submit_row();
}
}
// #############################################################################
if ($_POST['do'] == 'productsave') {
// Check to see if it is a duplicate.
$vbulletin->input->clean_array_gpc('p', array('productid' => TYPE_STR, 'editing' => TYPE_BOOL, 'title' => TYPE_STR, 'version' => TYPE_STR, 'description' => TYPE_STR, 'url' => TYPE_STR, 'versioncheckurl' => TYPE_STR, 'confirm' => TYPE_BOOL));
construct_hidden_code('oldpermissions', $user['adminpermissions']);
print_table_header(construct_phrase($vbphrase['x_y_id_z'], $vbphrase['administrator_permissions'], $user['username'], $user['userid']));
print_label_row("{$vbphrase['administrator']}: <a href=\"user.php?" . $vbulletin->session->vars['sessionurl'] . "do=edit&u=" . $vbulletin->GPC['userid'] . "\">{$user['username']}</a>", '<div align="' . $stylevar['right'] . '"><input type="button" class="button" value=" ' . $vbphrase['all_yes'] . ' " onclick="js_check_all_option(this.form, 1);" /> <input type="button" class="button" value=" ' . $vbphrase['all_no'] . ' " onclick="js_check_all_option(this.form, 0);" /></div>', 'thead');
foreach (convert_bits_to_array($user['adminpermissions'], $ADMINPERMISSIONS) as $field => $value) {
print_yes_no_row($permsphrase["{$field}"] == '' ? $vbphrase['n_a'] : $permsphrase["{$field}"], "adminpermissions[{$field}]", $value);
}
($hook = vBulletinHook::fetch_hook('admin_permissions_form')) ? eval($hook) : false;
print_select_row($vbphrase['control_panel_style_choice'], 'cssprefs', array_merge(array('' => "({$vbphrase['default']})"), fetch_cpcss_options()), $user['cssprefs']);
print_input_row($vbphrase['dismissed_news_item_ids'], 'dismissednews', $user['dismissednews']);
print_submit_row();
}
// #############################################################################
if ($_REQUEST['do'] == 'modify') {
print_form_header('adminpermissions', 'edit');
print_table_header($vbphrase['administrator_permissions'], 3);
$users = $db->query_read("\n\t\tSELECT user.username, usergroupid, membergroupids, infractiongroupids, administrator.*\n\t\tFROM " . TABLE_PREFIX . "administrator AS administrator\n\t\tINNER JOIN " . TABLE_PREFIX . "user AS user USING(userid)\n\t\tORDER BY user.username\n\t");
while ($user = $db->fetch_array($users)) {
$perms = fetch_permissions(0, $user['userid'], $user);
if ($perms['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel']) {
print_cells_row(array("<a href=\"user.php?" . $vbulletin->session->vars['sessionurl'] . "do=edit&u={$user['userid']}\" name=\"user{$user['userid']}\"><b>{$user['username']}</b></a>", '-', construct_link_code($vbphrase['view_control_panel_log'], "adminlog.php?" . $vbulletin->session->vars['sessionurl'] . "do=view&script=&u={$user['userid']}") . construct_link_code($vbphrase['edit_permissions'], "adminpermissions.php?" . $vbulletin->session->vars['sessionurl'] . "do=edit&u={$user['userid']}")), 0, '', 0);
}
}
print_table_footer();
}
print_cp_footer();
/*======================================================================*\
|| ####################################################################
|| # Downloaded: 12:56, Sat Oct 11th 2008
|| # CVS: $RCSfile$ - $Revision: 25308 $
|| ####################################################################
\*======================================================================*/
/**
* Prints a row containing an input for editing a stylevar
*
* @param string Stylevar title
* @param string Stylevar varname
* @param integer Size of text box
*/
function print_stylevar_row($title, $varname, $size = 30, $validation_regex = '', $failsafe_value = '')
{
global $stylevars, $stylevar_info, $vbulletin;
$color = fetch_inherited_color($stylevar_info["{$varname}"], $vbulletin->GPC['dostyleid']);
$revertcode = construct_revert_code($stylevar_info["{$varname}"], 'stylevar', $varname);
if ($help = construct_table_help_button("stylevar[{$varname}]")) {
$helplink = " {$help}";
}
if ($validation_regex != '') {
construct_hidden_code("stylevar[_validation][{$varname}]", htmlspecialchars_uni($validation_regex));
construct_hidden_code("stylevar[_failsafe][{$varname}]", htmlspecialchars_uni($failsafe_value));
}
print_cells_row(array("<span title=\"\$stylevar[{$varname}]\">{$title}</span>", "<span class=\"smallfont\"><input type=\"text\" class=\"{$color}\" title=\"\$stylevar[{$varname}]\" name=\"stylevar[{$varname}]\" tabindex=\"1\" value=\"" . htmlspecialchars_uni($stylevars["{$varname}"]) . "\" size=\"{$size}\" dir=\"ltr\" /><br />{$revertcode['info']}</span>", "<span class=\"smallfont\">{$revertcode['revertcode']}</span>{$helplink}"));
}
}
}
echo "<tr>\n\t";
echo "<td width='100%' valign='top' class='$class' dir='ltr'>\n";
echo $formatted_text;
echo "\n</td>\n</tr>\n\n";
}
}
else
{
$cells = array(
$vbphrase['your_customized_template'],
$vbphrase['merged_template_conflicts_show_original'],
$vbphrase['new_default_template']
);
print_cells_row($cells, true, false, 1);
foreach ($chunks as $chunk)
{
if ($chunk->is_stable())
{
$col1 = $chunk->get_text_original();
$col2 = $col1;
$col3 = $col1;
$class = "merge-nochange";
}
else
{
$col1 = $chunk->get_text_right();
$col2 = $chunk->get_merged_text();
if ($col2 === false) {
foreach ($crons as $cron) {
$options = array('edit' => $vbphrase['edit'], 'switchactive' => $cron['effective_active'] ? $vbphrase['disable'] : $vbphrase['enable']);
if (!$cron['volatile'] or $vb5_config['Misc']['debug']) {
$options['kill'] = $vbphrase['delete'];
}
$item_title = htmlspecialchars_uni($vbphrase['task_' . $cron['varname'] . '_title']);
if (isset($vbphrase['task_' . $cron['varname'] . '_title'])) {
$item_title = htmlspecialchars_uni($vbphrase['task_' . $cron['varname'] . '_title']);
} else {
$item_title = $cron['varname'];
}
if (!$cron['effective_active']) {
$item_title = "<strike>{$item_title}</strike>";
}
$item_desc = htmlspecialchars_uni($vbphrase['task_' . $cron['varname'] . '_desc']);
$timerule = fetch_cron_timerule($cron);
// this will happen in the future which the yestoday setting doesn't handle when its in the detailed mode
$future = ($cron['nextrun'] > TIMENOW and $vbulletin->options['yestoday'] == 2);
$cell = array("<input type=\"checkbox\" name=\"enabled[{$cron['varname']}]\" value=\"1\" title=\"{$vbphrase['enabled']}\" id=\"cb_enabled_{$cron['varname']}\" tabindex=\"1\"" . ($cron['active'] ? ' checked="checked"' : '') . " />", $timerule['minute'], $timerule['hour'], $timerule['day'], $timerule['month'], $timerule['weekday'], "<label for=\"cb_enabled_{$cron['varname']}\"><strong>{$item_title}</strong><br /><span class=\"smallfont\">{$item_desc}</span></label>", '<div style="white-space:nowrap">' . ($cron['effective_active'] ? vbdate($vbulletin->options['dateformat'], $cron['nextrun'], true and !$future) . (($vbulletin->options['yestoday'] != 2 or $future) ? '<br />' . vbdate($vbulletin->options['timeformat'], $cron['nextrun']) : '') : $vbphrase['n_a']) . '</div>', "\n\t<select name=\"c{$cron['cronid']}\" onchange=\"js_cron_jump({$cron['cronid']});\" class=\"bginput\">\n" . construct_select_options($options) . "\t</select><input type=\"button\" class=\"button\" value=\"{$vbphrase['go']}\" onclick=\"js_cron_jump({$cron['cronid']});\" />\n\t" . "\n\t<input type=\"button\" class=\"button\" value=\"{$vbphrase['run_now']}\" onclick=\"js_run_cron({$cron['cronid']});\" />");
print_cells_row($cell, 0, '', -6);
}
print_description_row("<div class=\"smallfont\" align=\"center\">{$vbphrase['all_times_are_gmt_x_time_now_is_y']}</div>", 0, 9, 'thead');
print_submit_row($vbphrase['save_enabled_status'], 0, 9, '', "<input type=\"button\" class=\"button\" value=\"{$vbphrase['add_new_scheduled_task_gcron']}\" tabindex=\"1\" onclick=\"window.location='cronadmin.php?" . vB::getCurrentSession()->get('sessionurl') . "do=edit'\" />");
}
print_cp_footer();
/*=========================================================================*\
|| #######################################################################
|| # Downloaded: 15:45, Tue Sep 8th 2015
|| # CVS: $RCSfile$ - $Revision: 83432 $
|| #######################################################################
\*=========================================================================*/
while ($bbcode = $db->fetch_array($bbcodes)) {
$class = fetch_row_bgclass();
$altclass = iif($class == 'alt1', 'alt2', 'alt1');
$parsed_code = $parser->do_parse($bbcode['bbcodeexample'], false, false, true, false, true);
$cell = array("<b>{$bbcode['title']}</b>", "<div class=\"{$altclass}\" style=\"padding:2px; border:solid 1px; width:200px; height:75px; overflow:auto\"><span class=\"smallfont\">" . htmlspecialchars_uni($bbcode['bbcodeexample']) . '</span></div>', "<div class=\"{$altclass}\" style=\"padding:2px; border:solid 1px; width:200px; height:75px; overflow:auto\"><span class=\"smallfont\">" . htmlspecialchars_uni($parsed_code) . '</span></div>', '<iframe src="bbcode.php?do=previewbbcode&bbcodeid=' . $bbcode['bbcodeid'] . '" style="width:200px; height:75px;"></iframe>');
if ($bbcode['buttonimage']) {
$src = $bbcode['buttonimage'];
if (!preg_match('#^[a-z]+://#i', $src) and $src[0] != '/') {
$src = "../{$src}";
}
$cell[] = "<img style=\"background:buttonface; border:solid 1px highlight\" src=\"{$src}\" alt=\"\" />";
} else {
$cell[] = $vbphrase['n_a'];
}
$cell[] = construct_link_code($vbphrase['edit'], "bbcode.php?" . $vbulletin->session->vars['sessionurl'] . "do=edit&bbcodeid={$bbcode['bbcodeid']}") . construct_link_code($vbphrase['delete'], "bbcode.php?" . $vbulletin->session->vars['sessionurl'] . "do=remove&bbcodeid={$bbcode['bbcodeid']}");
print_cells_row($cell, 0, $class, -4);
}
print_submit_row($vbphrase['add_new_bb_code'], false, 6);
if (empty($donetest)) {
print_form_header('bbcode', 'test');
print_table_header($vbphrase['test_your_bb_code']);
print_textarea_row($vbphrase['enter_text_with_bb_code'], 'text', '', 15, 60);
print_submit_row($vbphrase['go']);
}
}
// ########################################################################
print_cp_footer();
/*======================================================================*\
|| ####################################################################
|| # Downloaded: 12:39, Wed May 30th 2012
|| # CVS: $RCSfile$ - $Revision: 39862 $
function fetch_reminders_array2()
{
// prints out all reminders for the appropriate control panel
global $vbulletin, $permissions, $vbphrase;
if ($permissions['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel']) {
$condition = '';
} else {
$condition = 'AND allowmodcp = 1';
}
$reminders = $vbulletin->db->query_read("\n\t\tSELECT * FROM " . TABLE_PREFIX . "adminreminder\n\t\tWHERE duedate < " . (TIMENOW + 7 * 86400) . "\n\t\t{$condition} ORDER BY duedate\n\t");
if ($vbulletin->db->num_rows($reminders)) {
print_form_header(iif(VB_AREA == 'AdminCP', '../modcp/reminder', 'reminder'), 'docompleted');
print_table_header($vbphrase['adminfunctions_getreminders2_header'], 4);
print_cells_row(array($vbphrase['adminfunctions_getreminders2_duedate'], $vbphrase['event'], $vbphrase['edit'], $vbphrase['status']), 1, 0, -1);
while ($reminder = $vbulletin->db->fetch_array($reminders)) {
if ($reminder['completed'] == 0) {
if ($reminder['duedate'] < TIMENOW) {
$date = '<b class="col-i">%s</b>';
$status = '<b>' . $vbphrase['adminfunctions_getreminders2_overdue'] . '</b>';
$hint = $vbphrase['adminfunctions_getreminders2_completed'];
$checkbox = '';
} else {
$date = '%s';
$status = 'Pending';
$hint = $vbphrase['adminfunctions_getreminders2_completed'];
$checkbox = '';
}
} else {
$date = '%s';
$status = $vbphrase['adminfunctions_getreminders2_complete'];
$hint = $vbphrase['adminfunctions_getreminders2_delete'];
$checkbox = ' checked="checked" disabled="disabled"';
}
$cell = array();
$cell[] = '<p class="smallfont" style="white-space:nowrap">' . sprintf($date, vbdate("M jS 'y", $reminder['duedate'])) . '</p>';
$cell[] = '<p class="smallfont">' . $reminder['title'] . '</p>';
//$cell[] = '<span class="smallfont">'.construct_link_code($status, $link, 0, $hint) . '</span>';
$cell[] = '<p class="smallfont">' . construct_link_code($vbphrase['edit'], "reminder.php?" . $vbulletin->session->vars['sessionurl'] . "do=edit&id[{$reminder['adminreminderid']}]=1") . '</p>';
$cell[] = '<p class="smallfont" style="text-align:' . vB_Template_Runtime::fetchStyleVar('right') . '">' . $status . '<input type="checkbox" name="id[' . $reminder['adminreminderid'] . ']" value="1" tabindex="1"' . $checkbox . ' /></p>';
print_cells_row($cell, 0, '', -2);
}
print_submit_row($vbphrase['adminfunctions_getreminders2_delcomplete'], 0, 4);
}
unset($reminder);
$vbulletin->db->free_result($reminders);
}
if ($photoplog_category_parentid != $photoplog_original_parentid) {
$photoplog_catids_array = array($photoplog_catid, $photoplog_category_parentid, $photoplog_original_parentid);
// photoplog_regenerate_counts_table_v2($photoplog_catids_array);
}
print_cp_redirect("photoplog_category.php?" . $vbulletin->session->vars['sessionurl'] . "do=modify", 1);
} else {
print_stop_message('generic_error_x', $vbphrase['photoplog_bad_cat_replace']);
}
}
if ($_REQUEST['do'] == 'modify') {
print_form_header('photoplog_category', 'doorder');
construct_hidden_code('s', $vbulletin->session->vars['sessionhash']);
construct_hidden_code('catid', $photoplog_catid);
print_table_header($vbphrase['photoplog_category_manager'], 3);
print_description_row($vbphrase['photoplog_if_you_change_display_order'], 0, 3);
print_cells_row(array($vbphrase['photoplog_title'], '<nobr>' . $vbphrase['photoplog_display_order'] . '</nobr>', $vbphrase['photoplog_controls']), 1, '', -1);
$photoplog_category = array();
foreach ($photoplog_list_categories as $photoplog_key => $photoplog_value) {
if ($photoplog_key > 0) {
$photoplog_catid = $photoplog_key;
$photoplog_dashes = '';
$photoplog_title = htmlspecialchars_uni(trim($photoplog_value));
if (eregi("^([-]+[ ])(.*)", $photoplog_title, $photoplog_regs)) {
$photoplog_dashes = $photoplog_regs[1];
$photoplog_title = $photoplog_regs[2];
}
$photoplog_category['displayorder'] = $photoplog_ds_catopts[$photoplog_catid]['displayorder'];
$bgclass = fetch_row_bgclass();
echo "\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td class=\"{$bgclass}\" width=\"100%\">" . $photoplog_dashes . "<a href=\"photoplog_category.php?" . $vbulletin->session->vars['sessionurl'] . "do=edit&catid=" . $photoplog_catid . "\">" . $photoplog_title . "</a></td>\r\n\t\t\t\t\t<td class=\"{$bgclass}\"><input type=\"text\" class=\"bginput\" name=\"photoplog_category[" . $photoplog_catid . "]\" value=\"" . $photoplog_category['displayorder'] . "\" size=\"5\" /></td>\r\n\t\t\t\t\t<td class=\"{$bgclass}\"><nobr><a href=\"photoplog_category.php?" . $vbulletin->session->vars['sessionurl'] . "do=edit&catid=" . $photoplog_catid . "\">" . $vbphrase['photoplog_edit'] . "</a> <a href=\"photoplog_category.php?" . $vbulletin->session->vars['sessionurl'] . "do=delete&catid=" . $photoplog_catid . "\">" . $vbphrase['photoplog_delete'] . "</a></nobr></td>\r\n\t\t\t\t</tr>\r\n\t\t\t";
}
}
do=removeanswer&answerid=" + aid + "&questionid=" + qid; break;
default: return false; break;
}
}
</script>
<?php
$answers = $db->query_read_slave("\r\n\t\t\tSELECT answer, answerid, questionid\r\n\t\t\tFROM " . TABLE_PREFIX . "hvanswer AS answer\r\n\t\t\tWHERE questionid = " . $vbulletin->GPC['questionid'] . "\r\n\t\t\tORDER BY dateline\r\n\t\t");
print_form_header('verify', 'modifyanswer');
print_table_header($vbphrase['answers'], 2);
construct_hidden_code('questionid', $vbulletin->GPC['questionid']);
if ($db->num_rows($answers)) {
print_cells_row(array($vbphrase['answer'], $vbphrase['controls']), 1);
}
$options = array('modifyanswer' => $vbphrase['edit'], 'killanswer' => $vbphrase['delete']);
while ($answer = $db->fetch_array($answers)) {
print_cells_row(array($answer['answer'], "\n\t<select name=\"a{$answer['answerid']}\" onchange=\"js_jump({$answer['answerid']}, {$answer['questionid']}, this);\" class=\"bginput\">\n" . construct_select_options($options) . "\t</select>\n\t<input type=\"button\" value=\"" . $vbphrase['go'] . "\" onclick=\"js_jump({$answer['answerid']}, {$answer['questionid']}, this.form.a{$answer['answerid']});\" />\n\t"));
}
print_submit_row($vbphrase['add_new_answer'], 0, 2);
}
}
// ###################### Save Question #######################
if ($_POST['do'] == 'updatequestion') {
$vbulletin->input->clean_array_gpc('p', array('question' => TYPE_STR, 'regex' => TYPE_STR));
if (empty($vbulletin->GPC['question'])) {
print_stop_message('please_complete_required_fields');
}
if (empty($vbulletin->GPC['questionid'])) {
$db->query_write("\r\n\t\t\tINSERT INTO " . TABLE_PREFIX . "hvquestion\r\n\t\t\t\t(regex, dateline)\r\n\t\t\tVALUES\r\n\t\t\t\t('" . $vbulletin->db->escape_string($vbulletin->GPC['regex']) . "', " . TIMENOW . ")\r\n\t\t");
$vbulletin->GPC['questionid'] = $db->insert_id();
} else {
$db->query_write("\r\n\t\t\tUPDATE " . TABLE_PREFIX . "hvquestion\r\n\t\t\tSET regex = '" . $db->escape_string($vbulletin->GPC['regex']) . "'\r\n\t\t\tWHERE questionid = " . $vbulletin->GPC['questionid']);
}
}
print_cells_row(array('<input type="checkbox" name="allbox" title="' . $vbphrase['check_all'] . '" onClick="js_check_all(this.form);" checked="checked" />', $vbphrase['title'], $vbphrase['posted_by'], $vbphrase['replies'], $vbphrase['last_post']), 1);
while ($thread = $db->fetch_array($threads)) {
$thread['prefix_plain_html'] = $thread['prefixid'] ? htmlspecialchars_uni($vbphrase["prefix_{$thread['prefixid']}_title_plain"]) : '';
$cells = array();
$cells[] = "<input type=\"checkbox\" name=\"thread[{$thread['threadid']}]\" tabindex=\"1\" checked=\"checked\" />";
$cells[] = $thread['prefix_plain_html'] . ' <a href="../showthread.php?' . $vbulletin->session->vars['sessionurl'] . "t={$thread['threadid']}\" target=\"_blank\">{$thread['title']}</a>";
if ($thread['postuserid']) {
$cells[] = '<span class="smallfont"><a href="../member.php?' . $vbulletin->session->vars['sessionurl'] . "u={$thread['postuserid']}\">{$thread['postusername']}</a></span>";
} else {
$cells[] = '<span class="smallfont">' . $thread['postusername'] . '</span>';
}
$cells[] = "<span class=\"smallfont\">{$thread['replycount']}</span>";
$cells[] = '<span class="smallfont">' . vbdate($vbulletin->options['dateformat'] . ' ' . $vbulletin->options['timeformat'], $thread['lastpost']) . '</span>';
print_cells_row($cells, 0, 0, -1);
}
if ($vbulletin->GPC['type'] == 'prune') {
print_submit_row($vbphrase['prune_threads'], NULL, 5);
} else {
if ($vbulletin->GPC['type'] == 'move') {
print_submit_row($vbphrase['move_threads'], NULL, 5);
}
}
}
// ###################### Start move/prune select - finish! #######################
if ($_POST['do'] == 'dothreadsselfinish') {
$vbulletin->input->clean_array_gpc('p', array('thread' => TYPE_ARRAY, 'destforumid' => TYPE_INT));
if (!empty($vbulletin->GPC['thread'])) {
require_once DIR . '/includes/functions_databuild.php';
if ($vbulletin->GPC['type'] == 'prune') {
if (isset($prefixsets["{$prefix['prefixsetid']}"])) {
$prefixsets["{$prefix['prefixsetid']}"]['prefixes']["{$prefix['prefixid']}"] = $prefix;
}
}
print_form_header('prefix', 'displayorder');
print_table_header($vbphrase['thread_prefixes'], 3);
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(htmlspecialchars_uni($vbphrase["prefixset_{$prefixset['prefixsetid']}_title"]), '<input type="text" size="3" class="bginput" name="prefixset_order[' . $prefixset['prefixsetid'] . ']" value="' . $prefixset['displayorder'] . '" />', '<div align="right" class="smallfont">' . 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(htmlspecialchars_uni($vbphrase["prefix_{$prefix['prefixid']}_title_plain"]), '<input type="text" size="3" class="bginput" name="prefix_order[' . $prefix['prefixid'] . ']" value="' . $prefix['displayorder'] . '" />', '<div align="right" 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']}") . '</div>'));
}
}
}
}
print_submit_row($vbphrase['save_display_order'], false, 3);
echo '<p align="center">' . construct_link_code($vbphrase['add_prefix_set'], 'prefix.php?do=addset') . '</p>';
}
print_cp_footer();
/*======================================================================*\
|| ####################################################################
|| # Downloaded: 12:56, Sat Oct 11th 2008
|| # CVS: $RCSfile$ - $Revision: 27175 $
|| ####################################################################
\*======================================================================*/
print_table_break();
print_table_header($vbphrase['content_type'], 4);
print_cells_row(array($vbphrase['product'], $vbphrase['location'], $vbphrase['new_window'], $vbphrase['enabled']), 1, 'tcat');
$indexed_types = array();
$collection = new vB_Collection_ContentType();
$collection->filterAttachable(true);
foreach ($collection as $type) {
$value['package'] = $type->getPackageClass();
$value['class'] = $type->getClass();
$indexed_types[$type->getID()] = $value;
}
foreach ($indexed_types as $contenttypeid => $content) {
if (!isset($existing["{$contenttypeid}"]['e'])) {
$existing["{$contenttypeid}"]['e'] = true;
}
print_cells_row(array($content['package'], $vbphrase['contenttype_' . strtolower($content['package']) . '_' . strtolower($content['class'])], "<input type=\"hidden\" name=\"default[{$contenttypeid}][n]\" value=\"1\" />" . "<input type=\"checkbox\" tabindex=\"1\" name=\"contenttype[{$contenttypeid}][n]\" value=\"1\"" . ($existing["{$contenttypeid}"]['n'] ? 'checked="checked"' : '') . ' />', "<input type=\"hidden\" name=\"default[{$contenttypeid}][e]\" value=\"1\" />" . "<input type=\"checkbox\" tabindex=\"1\" name=\"contenttype[{$contenttypeid}][e]\" value=\"1\"" . ($existing["{$contenttypeid}"]['e'] ? 'checked="checked"' : '') . ' />'));
}
print_submit_row($vbulletin->GPC['extension'] ? $vbphrase['update'] : $vbphrase['save'], '_default_', 4);
}
// ###################### Update File Type ####################
if ($_POST['do'] == 'doupdatetype') {
$vbulletin->input->clean_array_gpc('p', array('extension' => TYPE_STR, 'type' => TYPE_ARRAY, 'contenttype' => TYPE_ARRAY, 'default' => TYPE_ARRAY));
$vbulletin->GPC['type']['extension'] = preg_replace('#[^a-z0-9_]#i', '', $vbulletin->GPC['type']['extension']);
$vbulletin->GPC['type']['extension'] = strtolower($vbulletin->GPC['type']['extension']);
if (empty($vbulletin->GPC['type']['extension'])) {
print_stop_message('please_complete_required_fields');
}
if ($vbulletin->GPC['extension'] != $vbulletin->GPC['type']['extension'] and $test = $db->query_first("SELECT extension FROM " . TABLE_PREFIX . "attachmenttype WHERE extension = '" . $db->escape_string($vbulletin->GPC['type']['extension']) . "'")) {
print_stop_message('name_exists', $vbphrase['filetype'], htmlspecialchars_uni($vbulletin->GPC['type']['extension']));
}
if ($vbulletin->GPC['type']['mimetype']) {
$result = $db->query_first_slave("SELECT provider FROM " . TABLE_PREFIX . "bbcode_video WHERE providerid = {$id}");
$db->query_write("DELETE FROM " . TABLE_PREFIX . "bbcode_video WHERE providerid={$id}");
}
cachedb();
redirect_to_rebuild();
}
/**
* Display installed definitions for exporting
*/
if ($do == "export") {
$results = $db->query_read_slave("SELECT providerid id, provider title, url description from " . TABLE_PREFIX . "bbcode_video ORDER BY priority, provider ASC");
print_form_header('ame', 'doexport');
badhook_check();
if ($db->num_rows($results)) {
print_table_header($vbphrase['ame_installed_definitions'], 2);
print_cells_row(array($vbphrase['title'], "<label for=\"export_toggle\">{$vbphrase['export']}</label> <input type=\"checkbox\" id=\"export_toggle\" onclick=\"tick_all(this.form, 'items', this.checked)\" checked=\"checked\" />"), true);
while ($result = $db->fetch_array($results)) {
print_checkbox_row("{$result['title']}<dfn>{$result['description']}</dfn>", "items[{$result['id']}]");
}
print_submit_row();
} else {
print_table_header($vbphrase['ame_installed_definitions'], 2);
print_description_row($vbphrase['ame_no_definitions']);
print_table_footer(2, construct_button_code("Add new", "ame.php?do=edit"));
}
}
/**
* Spits out an XML file of the exported items
*/
if ($do == "doexport") {
$items = $vbulletin->input->clean_gpc('p', 'items', TYPE_ARRAY_UINT);
/**
* Prints the page footer, finishes Gzip encoding and terminates execution
*/
function print_cp_footer()
{
global $vbulletin, $level, $vbphrase;
echo "\r\n\r\n<!-- START CONTROL PANEL FOOTER -->\r\n";
if ($vbulletin->debug) {
if (defined('CVS_REVISION')) {
$re = '#^\\$' . 'RCS' . 'file: (.*\\.php),v ' . '\\$ - \\$' . 'Revision: ([0-9\\.]+) \\$$#siU';
$cvsversion = preg_replace($re, '\\1, CVS v\\2', CVS_REVISION);
}
if ($size = sizeof($GLOBALS['DEVDEBUG'])) {
$displayarray = array();
$displayarray[] = "<select id=\"moo\"><option selected=\"selected\">DEBUG MESSAGES ({$size})</option>\n" . construct_select_options($GLOBALS['DEVDEBUG'], -1, 1) . "\t</select>";
if (defined('CVS_REVISION')) {
$displayarray[] = "<p style=\"font: bold 11px tahoma;\">{$cvsversion}</p>";
}
$displayarray[] = "<p style=\"font: bold 11px tahoma;\">SQL Queries (" . $vbulletin->db->querycount . ")</p>";
$buttons = "<input type=\"button\" class=\"button\" value=\"Explain\" onclick=\"window.location = '" . $vbulletin->scriptpath . iif(strpos($vbulletin->scriptpath, '?') > 0, '&', '?') . 'explain=1' . "';\" />" . "\n" . "<input type=\"button\" class=\"button\" value=\"Reload\" onclick=\"window.location = window.location;\" />";
print_form_header('../docs/phrasedev', 'dofindphrase', 0, 1, 'debug', '90%', '_phrasefind');
$displayarray[] =& $buttons;
print_cells_row($displayarray, 0, 'thead');
print_table_footer();
echo '<p align="center" class="smallfont">' . date('r T') . '</p>';
} else {
echo "<p align=\"center\" class=\"smallfont\">SQL Queries (" . $vbulletin->db->querycount . ") | " . (!empty($cvsversion) ? "{$cvsversion} | " : '') . "<a href=\"" . $vbulletin->scriptpath . iif(strpos($vbulletin->scriptpath, '?') > 0, '&', '?') . "explain=1\">Explain</a></p>";
if (function_exists('memory_get_usage')) {
echo "<p align=\"center\" class=\"smallfont\">Memory Usage: " . vb_number_format(round(memory_get_usage() / 1024, 2)) . " KiB</p>";
}
}
$_REQUEST['do'] = htmlspecialchars_uni($_REQUEST['do']);
echo "<script type=\"text/javascript\">window.status = \"" . construct_phrase($vbphrase['logged_in_user_x_executed_y_queries'], $vbulletin->userinfo['username'], $vbulletin->db->querycount) . " \$_REQUEST[do] = '{$_REQUEST['do']}'\";</script>";
}
if (!defined('NO_CP_COPYRIGHT')) {
$output_version = defined('ADMIN_VERSION_VBULLETIN') ? ADMIN_VERSION_VBULLETIN : $vbulletin->options['templateversion'];
echo '<p align="center"><a href="http://www.vbulletin.com/" target="_blank" class="copyright">' . construct_phrase($vbphrase['vbulletin_copyright_orig'], $output_version, date('Y')) . '</a></p>';
}
if (!defined('IS_NAV_PANEL') and !defined('NO_PAGE_TITLE') and VB_AREA != 'Upgrade' and VB_AREA != 'Install') {
echo "\n</div>";
}
echo "\n</body>\n</html>";
($hook = vBulletinHook::fetch_hook('admin_complete')) ? eval($hook) : false;
if ($vbulletin->options['gzipoutput'] and function_exists("ob_start") and function_exists("crc32") and function_exists("gzcompress") and !$vbulletin->nozip) {
$text = ob_get_contents();
while (ob_get_level()) {
@ob_end_clean();
}
if (!(SAPI_NAME == 'apache2handler' and PHP_VERSION <= '4.3.3') and !headers_sent() and SAPI_NAME != 'apache2filter') {
$newtext = fetch_gzipped_text($text, $vbulletin->options['gziplevel']);
} else {
$newtext = $text;
}
@header('Content-Length: ' . strlen($newtext));
echo $newtext;
}
flush();
if (defined('NOSHUTDOWNFUNC')) {
exec_shut_down();
}
// terminate script execution now - DO NOT REMOVE THIS!
exit;
}
function print_usergroup_row($usergroup, $options)
{
global $usergroupleaders, $vbphrase, $promotions, $vbulletin;
if ($promotions["{$usergroup['usergroupid']}"]) {
$options['promote'] .= " ({$promotions[$usergroup[usergroupid]]})";
}
$cell = array();
$cell[] = "<b>{$usergroup['title']}" . iif($usergroup['canoverride'], '*') . "</b>" . iif($usergroup['ispublicgroup'], '<br /><span class="smallfont">' . $usergroup['description'] . '</span>');
$cell[] = iif($usergroup['count'], vb_number_format($usergroup['count']), '-');
$cell[] = iif($usergroup['secondarycount'], vb_number_format($usergroup['secondarycount']), '-');
if ($usergroup['ispublicgroup']) {
$cell[] = iif($usergroup['requests'], vb_number_format($usergroup['requests']), '0');
}
if ($usergroup['ispublicgroup']) {
$cell_out = '<span class="smallfont">';
if (is_array($usergroupleaders["{$usergroup['usergroupid']}"])) {
foreach ($usergroupleaders["{$usergroup['usergroupid']}"] as $usergroupleader) {
$cell_out .= "<a href=\"user.php?" . $vbulletin->session->vars['sessionurl'] . "do=edit&u={$usergroupleader['userid']}\"><b>{$usergroupleader['username']}</b></a>" . construct_link_code($vbphrase['delete'], "usergroup.php?" . $vbulletin->session->vars['sessionurl'] . "do=removeleader&usergroupleaderid={$usergroupleader['usergroupleaderid']}") . '<br />';
}
}
$cell[] = $cell_out . '</span>';
}
$options['edit'] .= " (id: {$usergroup['usergroupid']})";
$cell[] = "\n\t<select name=\"u{$usergroup['usergroupid']}\" onchange=\"js_usergroup_jump({$usergroup['usergroupid']});\" class=\"bginput\">\n" . construct_select_options($options) . "\t</select><input type=\"button\" class=\"button\" value=\"" . $vbphrase['go'] . "\" onclick=\"js_usergroup_jump({$usergroup['usergroupid']});\" />\n\t";
print_cells_row($cell);
}
// generate a diff between two templates (current or historical versions)
if ($_POST['do'] == 'docompare') {
$vbulletin->input->clean_array_gpc('p', array('left_template' => TYPE_STR, 'right_template' => TYPE_STR, 'wrap' => TYPE_BOOL));
list($left_id, $left_type) = explode('|', $vbulletin->GPC['left_template']);
list($right_id, $right_type) = explode('|', $vbulletin->GPC['right_template']);
$left_template = fetch_template_current_historical($left_id, $left_type);
$right_template = fetch_template_current_historical($right_id, $right_type);
if (!$left_template or !$right_template) {
exit;
}
require_once DIR . '/includes/class_diff.php';
$diff =& new vB_Text_Diff($left_template['templatetext'], $right_template['templatetext']);
$entries =& $diff->fetch_diff();
print_form_header('template', 'docompare');
print_table_header(construct_phrase($vbphrase['comparing_versions_of_x'], htmlspecialchars_uni($left_template['title'])));
print_cells_row(array($vbphrase['old_version'], $vbphrase['new_version']), true, false, 1);
foreach ($entries as $diff_entry) {
// possible classes: unchanged, notext, deleted, added, changed
echo "<tr>\n\t";
echo '<td width="50%" valign="top" class="diff-' . $diff_entry->fetch_data_old_class() . '" dir="ltr">' . $diff_entry->prep_diff_text($diff_entry->fetch_data_old(), $vbulletin->GPC['wrap']) . "</td>\n\t";
echo '<td width="50%" valign="top" class="diff-' . $diff_entry->fetch_data_new_class() . '" dir="ltr">' . $diff_entry->prep_diff_text($diff_entry->fetch_data_new(), $vbulletin->GPC['wrap']) . "</td>\n";
echo "</tr>\n\n";
}
construct_hidden_code('left_template', $vbulletin->GPC['left_template']);
construct_hidden_code('right_template', $vbulletin->GPC['right_template']);
construct_hidden_code('wrap', $vbulletin->GPC['wrap'] ? 0 : 1);
print_submit_row($vbulletin->GPC['wrap'] ? $vbphrase['disable_wrapping'] : $vbphrase['enable_wrapping'], '');
print_form_header('', '');
print_table_header($vbphrase['comparison_key']);
echo "<tr><td class=\"diff-deleted\" align=\"center\" width=\"50%\">{$vbphrase['text_removed_from_old_version']}</td><td class=\"diff-notext\"> </td></tr>\n";
echo "<tr><td class=\"diff-changed\" colspan=\"2\" align=\"center\">{$vbphrase['text_changed_between_versions']}</td></tr>\n";
break;
case 'attachment_title':
$celldata .= construct_link_code(htmlspecialchars_uni($log["{$sqlfield}"]), "../attachment.php?" . $vbulletin->session->vars['sessionurl'] . "attachmentid={$log['attachmentid']}&nocache=" . TIMENOW, true);
break;
default:
$handled = false;
($hook = vBulletinHook::fetch_hook('admin_modlogviewer_query_linkfield')) ? eval($hook) : false;
if (!$handled) {
$celldata .= $log["{$sqlfield}"];
}
}
}
}
$cell[] = $celldata;
$cell[] = '<span class="smallfont">' . iif($log['ipaddress'], "<a href=\"usertools.php?" . $vbulletin->session->vars['sessionurl'] . "do=gethost&ip={$log['ipaddress']}\">{$log['ipaddress']}</a>", ' ') . '</span>';
print_cells_row($cell, 0, 0, -4);
}
print_table_footer(6, "{$firstpage} {$prevpage} {$nextpage} {$lastpage}");
} else {
print_stop_message('no_results_matched_your_query');
}
}
// ###################### Start prune log #######################
if ($_REQUEST['do'] == 'prunelog' and can_access_logs($vbulletin->config['SpecialUsers']['canpruneadminlog'], 0, '<p>' . $vbphrase['control_panel_log_pruning_permission_restricted'] . '</p>')) {
$vbulletin->input->clean_array_gpc('r', array('daysprune' => TYPE_UINT, 'userid' => TYPE_UINT, 'modaction' => TYPE_STR, 'product' => TYPE_STR));
$datecut = TIMENOW - 86400 * $vbulletin->GPC['daysprune'];
$sqlconds = array("dateline < {$datecut}");
if ($vbulletin->GPC['userid']) {
$sqlconds[] = "userid = " . $vbulletin->GPC['userid'];
}
if ($vbulletin->GPC['modaction']) {
}
}
// -->
</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 $
|| ####################################################################
\*======================================================================*/
}
}
$userchange["{$fname}"] = $str ? $str : '-';
}
break;
}
// sometimes we need translate the fieldname to show the phrases (database field and phrase have different name)
$fieldnametrans = array('usergroupid' => 'primary_usergroup', 'membergroupids' => 'additional_usergroups');
if ($fieldnametrans["{$userchange['fieldname']}"]) {
$userchange['fieldname'] = $fieldnametrans["{$userchange['fieldname']}"];
}
// print the change
$text = array();
$text[] = $vbphrase["{$userchange['fieldname']}"];
$text[] = $userchange['oldvalue'];
$text[] = $userchange['newvalue'];
print_cells_row($text, 0, false, -10);
}
print_table_footer();
} else {
print_stop_message('no_userchange_history');
}
}
}
print_cp_footer();
/*======================================================================*\
|| ####################################################################
|| # Downloaded: 22:41, Fri Oct 10th 2008
|| # CVS: $RCSfile$ - $Revision: 27484 $
|| ####################################################################
\*======================================================================*/
{
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 print_faq_admin_row($faq, $prefix = '')
{
global $ifaqcache, $vbphrase, $vbulletin;
$cell = array($prefix . '<b></b>' . iif(is_array($ifaqcache["{$faq['faqname']}"]), '<a href="faq.php?' . $vbulletin->session->vars['sessionurl'] . 'faq=' . urlencode($faq['faqname']) . "\" title=\"{$vbphrase['show_child_faq_entries']}\">{$faq['title']}</a>", $faq['title']) . '<b></b>', "<input type=\"text\" class=\"bginput\" size=\"4\" name=\"order[{$faq['faqname']}]\" title=\"{$vbphrase['display_order']}\" tabindex=\"1\" value=\"{$faq['displayorder']}\" />", construct_link_code($vbphrase['edit'], 'faq.php?' . $vbulletin->session->vars['sessionurl'] . 'do=edit&faq=' . urlencode($faq['faqname'])) . construct_link_code($vbphrase['add_child_faq_item'], "faq.php?" . $vbulletin->session->vars['sessionurl'] . 'do=add&faq=' . urlencode($faq['faqname'])) . construct_link_code($vbphrase['delete'], 'faq.php?' . $vbulletin->session->vars['sessionurl'] . 'do=delete&faq=' . urlencode($faq['faqname'])));
print_cells_row($cell);
}
{
$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');
}
else
{
print_stop_message('no_users_banned_from_x_board', '<b>' . $vbulletin->options['bbtitle'] . '</b>');
}
}
}
}
build_channel_permissions();
print_stop_message2('duplicated_permissions_successfully', 'forumpermission', array('do' => 'modify'));
}
// ###################### Start quick edit #######################
if ($_REQUEST['do'] == 'quickedit') {
$vbulletin->input->clean_array_gpc('r', array('orderby' => vB_Cleaner::TYPE_STR));
print_form_header('forumpermission', 'doquickedit');
print_table_header($vbphrase['permissions_quick_editor'], 4);
print_cells_row(array('<input type="checkbox" name="allbox" title="' . $vbphrase['check_all'] . '" onclick="js_check_all(this.form);" />', "<a href=\"forumpermission.php?" . vB::getCurrentSession()->get('sessionurl') . "do=quickedit&orderby=channel\" title=\"" . $vbphrase['order_by_channel'] . "\">" . $vbphrase['channel'] . "</a>", "<a href=\"forumpermission.php?" . vB::getCurrentSession()->get('sessionurl') . "do=quickedit&orderby=usergroup\" title=\"" . $vbphrase['order_by_usergroup'] . "\">" . $vbphrase['usergroup'] . "</a>", $vbphrase['controls']), 1);
$result = vB::getDbAssertor()->assertQuery('fetchperms', array(vB_dB_Query::TYPE_KEY => vB_dB_Query::QUERY_STORED, 'order_first' => $vbulletin->GPC['orderby'] == 'usergroup' ? 'usergroup' : 'node'));
if ($result and $result->valid()) {
while ($result->valid()) {
$perm = $result->current();
print_cells_row(array("<input type=\"checkbox\" name=\"permission[{$perm['permissionid']}]\" value=\"1\" tabindex=\"1\" />", $perm['node_title'], $perm['ug_title'], construct_link_code($vbphrase['edit'], "forumpermission.php?" . vB::getCurrentSession()->get('sessionurl') . "do=edit&np={$perm['permissionid']}")));
$result->next();
}
print_submit_row($vbphrase['delete_selected_permissions'], $vbphrase['reset'], 4);
} else {
print_description_row($vbphrase['nothing_to_do'], 0, 4, '', 'center');
}
print_table_footer();
}
// ###################### Start do quick edit #######################
if ($_POST['do'] == 'doquickedit') {
$vbulletin->input->clean_array_gpc('p', array('permission' => vB_Cleaner::TYPE_ARRAY));
if (sizeof($vbulletin->GPC['permission']) == 0) {
print_stop_message2('nothing_to_do');
}
$removeids = array();
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)
{
for (var i = 0; i < this.form.elements.length; i++)
{
// ***********************
}
// ##########################################################################
if ($_REQUEST['do'] == 'modify') {
/*
$typeoptions = array();
$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();
