showsetting('threads_search_sourcetable', '', '', $tableselect);
showsetting('threads_search_forum', '', '', $forumselect);
showsetting('threadsplit_move_tidrange', array('tidmin', 'tidmax'), array($_GET['tidmin'], $_GET['tidmax']), 'range');
showsetting('threads_search_noreplyday', 'noreplydays', isset($_GET['noreplydays']) ? $_GET['noreplydays'] : 365, 'text');
showtagheader('tbody', 'advanceoption');
showsetting('threads_search_time', array('starttime', 'endtime'), array($_GET['starttime'], $_GET['endtime']), 'daterange');
showsetting('threads_search_type', '', '', '<select name="intype"><option value="all"> > ' . $lang['all'] . '</option><option value=""> </option><option value="0"> > ' . $lang['threads_search_type_none'] . '</option>' . $typeselect . '</select>');
showsetting('threads_search_sort', '', '', '<select name="insort"><option value="all"> > ' . $lang['all'] . '</option><option value=""> </option><option value="0"> > ' . $lang['threads_search_type_none'] . '</option>' . $sortselect . '</select>');
showsetting('threads_search_viewrange', array('viewsmore', 'viewsless'), array($_GET['viewsmore'], $_GET['viewsless']), 'range');
showsetting('threads_search_replyrange', array('repliesmore', 'repliesless'), array($_GET['repliesmore'], $_GET['repliesless']), 'range');
showsetting('threads_search_readpermmore', 'readpermmore', $_GET['readpermmore'], 'text');
showsetting('threads_search_pricemore', 'pricemore', $_GET['pricemore'], 'text');
showsetting('threads_search_keyword', 'keywords', $_GET['keywords'], 'text');
showsetting('threads_search_user', 'users', $_GET['users'], 'text');
showsetting('threads_search_type', array('specialthread', array(array(0, cplang('unlimited'), array('showspecial' => 'none')), array(1, cplang('threads_search_include_yes'), array('showspecial' => '')), array(2, cplang('threads_search_include_no'), array('showspecial' => ''))), TRUE), isset($_GET['specialthread']) ? $_GET['specialthread'] : 2, 'mradio');
showtablerow('id="showspecial" style="display:' . ($_GET['specialthread'] || !isset($_GET['specialthread']) ? '' : 'none') . '"', 'class="sub" colspan="2"', mcheckbox('special', array(1 => cplang('thread_poll'), 2 => cplang('thread_trade'), 3 => cplang('thread_reward'), 4 => cplang('thread_activity'), 5 => cplang('thread_debate')), $_GET['special'] ? $_GET['special'] : array(1, 2, 3, 4, 5)));
showsetting('threads_search_sticky', array('sticky', array(array(0, cplang('unlimited')), array(1, cplang('threads_search_include_yes')), array(2, cplang('threads_search_include_no'))), TRUE), isset($_GET['sticky']) ? $_GET['sticky'] : 2, 'mradio');
showsetting('threads_search_digest', array('digest', array(array(0, cplang('unlimited')), array(1, cplang('threads_search_include_yes')), array(2, cplang('threads_search_include_no'))), TRUE), isset($_GET['digest']) ? $_GET['digest'] : 2, 'mradio');
showsetting('threads_search_attach', array('attach', array(array(0, cplang('unlimited')), array(1, cplang('threads_search_include_yes')), array(2, cplang('threads_search_include_no'))), TRUE), isset($_GET['attach']) ? $_GET['attach'] : 0, 'mradio');
showsetting('threads_rate', array('rate', array(array(0, cplang('unlimited')), array(1, cplang('threads_search_include_yes')), array(2, cplang('threads_search_include_no'))), TRUE), isset($_GET['rate']) ? $_GET['rate'] : 2, 'mradio');
showsetting('threads_highlight', array('highlight', array(array(0, cplang('unlimited')), array(1, cplang('threads_search_include_yes')), array(2, cplang('threads_search_include_no'))), TRUE), isset($_GET['highlight']) ? $_GET['highlight'] : 2, 'mradio');
showtagfooter('tbody');
showsubmit('threadsplit_move_search', 'submit', '', 'more_options');
showtablefooter();
showformfooter();
showtagfooter('div');
if (submitcheck('threadsplit_move_search')) {
$searchurladd = array();
$conditions = array('sourcetableid' => $_GET['sourcetableid'], 'inforum' => $_GET['inforum'], 'tidmin' => $_GET['tidmin'], 'tidmax' => $_GET['tidmax'], 'starttime' => $_GET['starttime'], 'endtime' => $_GET['endtime'], 'keywords' => $_GET['keywords'], 'users' => $_GET['users'], 'intype' => $_GET['intype'], 'insort' => $_GET['insort'], 'viewsmore' => $_GET['viewsmore'], 'viewsless' => $_GET['viewsless'], 'repliesmore' => $_GET['repliesmore'], 'repliesless' => $_GET['repliesless'], 'readpermmore' => $_GET['readpermmore'], 'pricemore' => $_GET['pricemore'], 'noreplydays' => $_GET['noreplydays'], 'specialthread' => $_GET['specialthread'], 'special' => $_GET['special'], 'sticky' => $_GET['sticky'], 'digest' => $_GET['digest'], 'attach' => $_GET['attach'], 'rate' => $_GET['rate'], 'highlight' => $_GET['highlight']);
if ($_GET['detail']) {
$pagetmp = $page;
} else {
$db_export = 'db_export_discuz';
$db_export_key = 'discuz';
$uc_backup_url = UC_API . '/admin.php?m=db&a=ls&iframe=1';
$db_export_tips = cplang('db_export_tips_nouc', array('uc_backup_url' => $uc_backup_url)) . cplang('db_export_tips');
$db_export_discuz_table = cplang('db_export_discuz_table');
}
shownav('founder', 'nav_db', 'nav_db_export');
showsubmenu('nav_db', array(array('nav_db_export', 'db&operation=export', 1), array('nav_db_import', 'db&operation=import', 0), array('nav_db_runquery', 'db&operation=runquery', 0), array('nav_db_optimize', 'db&operation=optimize', 0), array('nav_db_dbcheck', 'db&operation=dbcheck', 0)));
showtips($db_export_tips);
showformheader('db&operation=export&setup=1');
showtableheader();
showsetting('db_export_type', array('type', array(array($db_export_key, $lang[$db_export], array('showtables' => 'none')), array('custom', $lang['db_export_custom'], array('showtables' => '')))), $db_export_key, 'mradio');
showtagheader('tbody', 'showtables');
showtablerow('', '', '<input class="checkbox" name="chkall" onclick="checkAll(\'prefix\', this.form, \'customtables\', \'chkall\', true)" checked="checked" type="checkbox" id="chkalltables" /><label for="chkalltables"> ' . cplang('db_export_custom_select_all') . ' - ' . $db_export_discuz_table) . '</label>';
showtablerow('', 'colspan="2"', mcheckbox('customtables', $dztables));
showtagfooter('tbody');
showtagheader('tbody', 'advanceoption');
showsetting('db_export_method', '', '', '<ul class="nofloat"><li><input class="radio" type="radio" name="method" value="shell" ' . $shelldisabled . ' onclick="if(\'' . intval($db->version() < '4.1') . '\') {if(this.form.sqlcompat[2].checked==true) this.form.sqlcompat[0].checked=true; this.form.sqlcompat[2].disabled=true; this.form.sizelimit.disabled=true;} else {this.form.sqlcharset[0].checked=true; for(var i=1; i<=5; i++) {if(this.form.sqlcharset[i]) this.form.sqlcharset[i].disabled=true;}}" id="method_shell" /><label="method_shell"> ' . $lang['db_export_shell'] . '</label></li><li><input class="radio" type="radio" name="method" value="multivol" checked="checked" onclick="this.form.sqlcompat[2].disabled=false; this.form.sizelimit.disabled=false; for(var i=1; i<=5; i++) {if(this.form.sqlcharset[i]) this.form.sqlcharset[i].disabled=false;}" id="method_multivol" /><label for="method_multivol"> ' . $lang['db_export_multivol'] . '</label> <input type="text" class="txt" size="40" name="sizelimit" value="2048" /></li></ul>');
showtitle('db_export_options');
showsetting('db_export_options_extended_insert', 'extendins', 0, 'radio');
showsetting('db_export_options_sql_compatible', array('sqlcompat', array(array('', $lang['default']), array('MYSQL40', 'MySQL 3.23/4.0.x'), array('MYSQL41', 'MySQL 4.1.x/5.x'))), '', 'mradio');
showsetting('db_export_options_charset', array('sqlcharset', array(array('', cplang('default')), $dbcharset ? array($dbcharset, strtoupper($dbcharset)) : array(), $db->version() > '4.1' && $dbcharset != 'utf8' ? array('utf8', 'UTF-8') : array()), TRUE), 0, 'mradio');
showsetting('db_export_usehex', 'usehex', 1, 'radio');
if (function_exists('gzcompress')) {
showsetting('db_export_usezip', array('usezip', array(array('1', $lang['db_export_zip_1']), array('2', $lang['db_export_zip_2']), array('0', $lang['db_export_zip_3']))), 0, 'mradio');
}
showsetting('db_export_filename', '', '', '<input type="text" class="txt" name="filename" value="' . $defaultfilename . '" />.sql');
showtagfooter('tbody');
showsubmit('exportsubmit', 'submit', '', 'more_options');
showtablefooter();
showsetting('magics_edit_num', 'numnew', $magic['num'], 'text');
showsetting('magics_edit_weight', 'weightnew', $magic['weight'], 'text');
showsetting('magics_edit_supplytype', array('supplytypenew', array(array(0, $lang['magics_goods_stack_none']), array(1, $lang['magics_goods_stack_day']), array(2, $lang['magics_goods_stack_week']), array(3, $lang['magics_goods_stack_month']))), $magic['supplytype'], 'mradio');
showsetting('magics_edit_supplynum', 'supplynumnew', $magic['supplynum'], 'text');
showsetting('magics_edit_filename', 'filenamenew', $magic['filename'], 'text');
showsetting('magics_edit_description', 'descriptionnew', $magic['description'], 'textarea');
showtitle('magics_edit_perm');
showtablerow('', 'class="td27"', $lang['magics_edit_usergroupperm'] . ':<input class="checkbox" type="checkbox" name="chkall1" onclick="checkAll(\'prefix\', this.form, \'usergroupsperm\', \'chkall1\', true)" id="chkall1" /><label for="chkall1"> ' . lang('select_all') . '</label>');
showtablerow('', 'colspan="2"', mcheckbox('usergroupsperm', $groups, explode("\t", $magicperm['usergroups'])));
if ($magic['type'] == 2 || $magic['type'] == 3) {
showtablerow('', 'class="td27"', $lang['magics_edit_targetgroupperm'] . ':<input class="checkbox" type="checkbox" name="chkall2" onclick="checkAll(\'prefix\', this.form, \'targetgroupsperm\', \'chkall2\', true)" id="chkall2" /><label for="chkall2"> ' . lang('select_all') . '</label>');
showtablerow('', 'colspan="2"', mcheckbox('targetgroupsperm', $groups, explode("\t", $magicperm['targetgroups'])));
}
if ($magic['type'] == 1) {
showtablerow('', 'class="td27"', $lang['magics_edit_forumperm'] . ':<input class="checkbox" type="checkbox" name="chkall3" onclick="checkAll(\'prefix\', this.form, \'forumperm\', \'chkall3\', true)" id="chkall3" /><label for="chkall3"> ' . lang('select_all') . '</label>');
showtablerow('', 'colspan="2"', mcheckbox('forumperm', $forums, explode("\t", $magicperm['forum'])));
}
showsubmit('magiceditsubmit');
showtablefooter();
showformfooter();
} else {
$namenew = dhtmlspecialchars(trim($namenew));
$identifiernew = dhtmlspecialchars(trim(strtoupper($identifiernew)));
$descriptionnew = dhtmlspecialchars($descriptionnew);
$filenamenew = dhtmlspecialchars($filenamenew);
$typenew = $typenew > 0 && $typenew <= 3 ? $typenew : 1;
$availablenew = !$identifiernew || !$filenamenew ? 0 : 1;
$magicperm['usergroups'] = is_array($usergroupsperm) && !empty($usergroupsperm) ? "\t" . implode("\t", $usergroupsperm) . "\t" : '';
$magicperm['targetgroups'] = is_array($targetgroupsperm) && !empty($targetgroupsperm) ? "\t" . implode("\t", $targetgroupsperm) . "\t" : '';
$magicperm['forum'] = is_array($forumperm) && !empty($forumperm) ? "\t" . implode("\t", $forumperm) . "\t" : '';
$magicpermnew = addslashes(serialize($magicperm));
$setting['value'][$k][1] = lang('magic/' . $magic['identifier'], $setting['value'][$k][1]);
}
}
$varname = in_array($setting['type'], array('mradio', 'mcheckbox', 'select', 'mselect')) ? $setting['type'] == 'mselect' ? array('perm[' . $settingvar . '][]', $setting['value']) : array('perm[' . $settingvar . ']', $setting['value']) : 'perm[' . $settingvar . ']';
$value = $magicperm[$settingvar] != '' ? $magicperm[$settingvar] : $setting['default'];
$comment = lang('magic/' . $magic['identifier'], $setting['title'] . '_comment');
$comment = $comment != $setting['title'] . '_comment' ? $comment : '';
showsetting(lang('magic/' . $magic['identifier'], $setting['title']) . ':', $varname, $value, $setting['type'], '', 0, $comment);
}
}
showtitle('magics_edit_perm');
showtablerow('', 'colspan="2" class="td27"', $lang['magics_edit_usergroupperm'] . ':<input class="checkbox" type="checkbox" name="chkall1" onclick="checkAll(\'prefix\', this.form, \'usergroupsperm\', \'chkall1\', true)" id="chkall1" /><label for="chkall1"> ' . cplang('select_all') . '</label>');
showtablerow('', 'colspan="2"', mcheckbox('usergroupsperm', $groups, explode("\t", $magicperm['usergroups'])));
if (!empty($magicclass->targetgroupperm)) {
showtablerow('', 'colspan="2" class="td27"', $lang['magics_edit_targetgroupperm'] . ':<input class="checkbox" type="checkbox" name="chkall2" onclick="checkAll(\'prefix\', this.form, \'targetgroupsperm\', \'chkall2\', true)" id="chkall2" /><label for="chkall2"> ' . cplang('select_all') . '</label>');
showtablerow('', 'colspan="2"', mcheckbox('targetgroupsperm', $groups, explode("\t", $magicperm['targetgroups'])));
}
showsubmit('magiceditsubmit');
showtablefooter();
showformfooter();
} else {
$namenew = dhtmlspecialchars(trim($_GET['namenew']));
$identifiernew = dhtmlspecialchars(trim(strtoupper($_GET['identifiernew'])));
$descriptionnew = dhtmlspecialchars($_GET['descriptionnew']);
$availablenew = !$identifiernew ? 0 : 1;
$magicperm['usergroups'] = is_array($_GET['usergroupsperm']) && !empty($_GET['usergroupsperm']) ? "\t" . implode("\t", $_GET['usergroupsperm']) . "\t" : '';
$magicperm['targetgroups'] = is_array($_GET['targetgroupsperm']) && !empty($_GET['targetgroupsperm']) ? "\t" . implode("\t", $_GET['targetgroupsperm']) . "\t" : '';
require_once libfile('magic/' . $magic['identifier'], 'class');
$magicclass = 'magic_' . $magic['identifier'];
$magicclass = new $magicclass();
$magicclass->setsetting($magicperm, $_GET['perm']);
showtableheader();
showsetting('threads_search_detail', 'detail', $detail, 'radio');
showsetting('threads_search_forum', '', '', $forumselect);
showsetting('threads_search_time', array('starttime', 'endtime'), array($starttime, $endtime), 'daterange');
showsetting('threads_search_user', 'users', $users, 'text');
showsetting('threads_search_keyword', 'keywords', $keywords, 'text');
showtagheader('tbody', 'advanceoption');
showsetting('threads_search_type', '', '', '<select name="intype"><option value="all"> > ' . $lang['all'] . '</option><option value=""> </option><option value="0"> > ' . $lang['threads_search_type_none'] . '</option>' . $typeselect . '</select>');
showsetting('threads_search_sort', '', '', '<select name="insort"><option value="all"> > ' . $lang['all'] . '</option><option value=""> </option><option value="0"> > ' . $lang['threads_search_type_none'] . '</option>' . $sortselect . '</select>');
showsetting('threads_search_viewrange', array('viewsmore', 'viewsless'), array($viewsmore, $viewsless), 'range');
showsetting('threads_search_replyrange', array('repliesmore', 'repliesless'), array($repliesmore, $repliesless), 'range');
showsetting('threads_search_readpermmore', 'readpermmore', $readpermmore, 'text');
showsetting('threads_search_pricemore', 'pricemore', $pricemore, 'text');
showsetting('threads_search_noreplyday', 'noreplydays', $noreplydays, 'text');
showsetting('threads_search_type', array('specialthread', array(array(0, lang('unlimited'), array('showspecial' => 'none')), array(1, lang('threads_search_include_yes'), array('showspecial' => '')), array(2, lang('threads_search_include_no'), array('showspecial' => ''))), TRUE), $specialthread, 'mradio');
showtablerow('id="showspecial" style="display:' . ($specialthread ? '' : 'none') . '"', 'class="sub" colspan="2"', mcheckbox('special', array(1 => lang('thread_poll'), 2 => lang('thread_trade'), 3 => lang('thread_reward'), 4 => lang('thread_activity'), 5 => lang('thread_debate')), $special ? $special : array(0)));
showsetting('threads_search_sticky', array('sticky', array(array(0, lang('unlimited')), array(1, lang('threads_search_include_yes')), array(2, lang('threads_search_include_no'))), TRUE), $sticky, 'mradio');
showsetting('threads_search_digest', array('digest', array(array(0, lang('unlimited')), array(1, lang('threads_search_include_yes')), array(2, lang('threads_search_include_no'))), TRUE), $digest, 'mradio');
showsetting('threads_search_attach', array('attach', array(array(0, lang('unlimited')), array(1, lang('threads_search_include_yes')), array(2, lang('threads_search_include_no'))), TRUE), $attach, 'mradio');
showsetting('threads_rate', array('rate', array(array(0, lang('unlimited')), array(1, lang('threads_search_include_yes')), array(2, lang('threads_search_include_no'))), TRUE), $rate, 'mradio');
showsetting('threads_highlight', array('highlight', array(array(0, lang('unlimited')), array(1, lang('threads_search_include_yes')), array(2, lang('threads_search_include_no'))), TRUE), $highlight, 'mradio');
showtagfooter('tbody');
showsubmit('searchsubmit', 'submit', '', 'more_options');
showtablefooter();
showformfooter();
showtagfooter('div');
if (submitcheck('searchsubmit')) {
$sql = '';
$sql .= $inforum != '' && $inforum != 'all' ? " AND fid='{$inforum}'" : '';
$sql .= $intype != '' && $intype != 'all' ? " AND typeid='{$intype}'" : '';
$sql .= $insort != '' && $insort != 'all' ? " AND sortid='{$insort}'" : '';
