www.gusucode.com > 迪恩育儿亲子4商城商家+手机版【整站带测试数据】源码程序 > web/source/admincp/admincp_threadtypes.php
<?php
/**
* [Discuz!] (C)2001-2099 Comsenz Inc.
* This is NOT a freeware, use is subject to license terms
*
* $Id: admincp_threadtypes.php 36345 2017-01-12 01:55:04Z nemohou $
*/
if(!defined('IN_DISCUZ') || !defined('IN_ADMINCP')) {
exit('Access Denied');
}
cpheader();
$classoptionmenu = array();
$curclassname = '';
foreach(C::t('forum_typeoption')->fetch_all_by_classid(0) as $option) {
if($_GET['classid'] == $option['optionid']) {
$curclassname = $option['title'];
}
$classoptionmenu[] = array($option['title'], "threadtypes&operation=typeoption&classid=$option[optionid]", $_GET['classid'] == $option['optionid']);
}
$mysql_keywords = array( 'ADD', 'ALL', 'ALTER', 'ANALYZE', 'AND', 'AS', 'ASC', 'ASENSITIVE', 'BEFORE', 'BETWEEN', 'BIGINT', 'BINARY', 'BLOB', 'BOTH', 'BY', 'CALL', 'CASCADE', 'CASE', 'CHANGE', 'CHAR', 'CHARACTER', 'CHECK', 'COLLATE', 'COLUMN', 'CONDITION', 'CONNECTION', 'CONSTRAINT', 'CONTINUE', 'CONVERT', 'CREATE', 'CROSS', 'CURRENT_DATE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'CURRENT_USER', 'CURSOR', 'DATABASE', 'DATABASES', 'DAY_HOUR', 'DAY_MICROSECOND', 'DAY_MINUTE', 'DAY_SECOND', 'DEC', 'DECIMAL', 'DECLARE', 'DEFAULT', 'DELAYED', 'DELETE', 'DESC', 'DESCRIBE', 'DETERMINISTIC', 'DISTINCT', 'DISTINCTROW', 'DIV', 'DOUBLE', 'DROP', 'DUAL', 'EACH', 'ELSE', 'ELSEIF', 'ENCLOSED', 'ESCAPED', 'EXISTS', 'EXIT', 'EXPLAIN', 'FALSE', 'FETCH', 'FLOAT', 'FLOAT4', 'FLOAT8', 'FOR', 'FORCE', 'FOREIGN', 'FROM', 'FULLTEXT', 'GOTO', 'GRANT', 'GROUP', 'HAVING', 'HIGH_PRIORITY', 'HOUR_MICROSECOND', 'HOUR_MINUTE', 'HOUR_SECOND', 'IF', 'IGNORE', 'IN', 'INDEX', 'INFILE', 'INNER', 'INOUT', 'INSENSITIVE', 'INSERT', 'INT', 'INT1', 'INT2', 'INT3', 'INT4', 'INT8', 'INTEGER', 'INTERVAL', 'INTO', 'IS', 'ITERATE', 'JOIN', 'KEY', 'KEYS', 'KILL', 'LABEL', 'LEADING', 'LEAVE', 'LEFT', 'LIKE', 'LIMIT', 'LINEAR', 'LINES', 'LOAD', 'LOCALTIME', 'LOCALTIMESTAMP', 'LOCK', 'LONG', 'LONGBLOB', 'LONGTEXT', 'LOOP', 'LOW_PRIORITY', 'MATCH', 'MEDIUMBLOB', 'MEDIUMINT', 'MEDIUMTEXT', 'MIDDLEINT', 'MINUTE_MICROSECOND', 'MINUTE_SECOND', 'MOD', 'MODIFIES', 'NATURAL', 'NOT', 'NO_WRITE_TO_BINLOG', 'NULL', 'NUMERIC', 'ON', 'OPTIMIZE', 'OPTION', 'OPTIONALLY', 'OR', 'ORDER', 'OUT', 'OUTER', 'OUTFILE', 'PRECISION', 'PRIMARY', 'PROCEDURE', 'PURGE', 'RAID0', 'RANGE', 'READ', 'READS', 'REAL', 'REFERENCES', 'REGEXP', 'RELEASE', 'RENAME', 'REPEAT', 'REPLACE', 'REQUIRE', 'RESTRICT', 'RETURN', 'REVOKE', 'RIGHT', 'RLIKE', 'SCHEMA', 'SCHEMAS', 'SECOND_MICROSECOND', 'SELECT', 'SENSITIVE', 'SEPARATOR', 'SET', 'SHOW', 'SMALLINT', 'SPATIAL', 'SPECIFIC', 'SQL', 'SQLEXCEPTION', 'SQLSTATE', 'SQLWARNING', 'SQL_BIG_RESULT', 'SQL_CALC_FOUND_ROWS', 'SQL_SMALL_RESULT', 'SSL', 'STARTING', 'STRAIGHT_JOIN', 'TABLE', 'TERMINATED', 'THEN', 'TINYBLOB', 'TINYINT', 'TINYTEXT', 'TO', 'TRAILING', 'TRIGGER', 'TRUE', 'UNDO', 'UNION', 'UNIQUE', 'UNLOCK', 'UNSIGNED', 'UPDATE', 'USAGE', 'USE', 'USING', 'UTC_DATE', 'UTC_TIME', 'UTC_TIMESTAMP', 'VALUES', 'VARBINARY', 'VARCHAR', 'VARCHARACTER', 'VARYING', 'WHEN', 'WHERE', 'WHILE', 'WITH', 'WRITE', 'X509', 'XOR', 'YEAR_MONTH', 'ZEROFILL', 'ACTION', 'BIT', 'DATE', 'ENUM', 'NO', 'TEXT', 'TIME');
if(!$operation) {
$navlang = 'threadtype_infotypes';
$operation = 'type';
$changetype = 'threadsorts';
if(!submitcheck('typesubmit')) {
$forumsarray = $fidsarray = array();
$query = C::t('forum_forum')->fetch_all_for_threadsorts();
foreach($query as $forum) {
$forum[$changetype] = dunserialize($forum[$changetype]);
if(is_array($forum[$changetype]['types'])) {
foreach($forum[$changetype]['types'] as $typeid => $name) {
$forumsarray[$typeid][] = '<a href="'.ADMINSCRIPT.'?action=forums&operation=edit&fid='.$forum['fid'].'&anchor=threadtypes">'.$forum['name'].'</a>';
$fidsarray[$typeid][] = $forum['fid'];
}
}
}
$threadtypes = '';
$query = C::t('forum_threadtype')->fetch_all_for_order();
foreach($query as $type) {
$tmpstr = "<a href=\"".ADMINSCRIPT."?action=threadtypes&operation=export&sortid=$type[typeid]\" class=\"act nowrap\">$lang[export]</a>";
$threadtypes .= showtablerow('', array('class="td25"', 'class="td28"', 'class="td29"', 'class="td29"', 'title="'.cplang('forums_threadtypes_forums_comment').'"'), array(
"<input class=\"checkbox\" type=\"checkbox\" name=\"delete[]\" value=\"$type[typeid]\">",
"<input type=\"text\" class=\"txt\" size=\"2\" name=\"displayordernew[$type[typeid]]\" value=\"$type[displayorder]\">",
"<input type=\"text\" class=\"txt\" size=\"15\" name=\"namenew[$type[typeid]]\" value=\"".dhtmlspecialchars($type['name'])."\">",
"<input type=\"text\" class=\"txt\" size=\"30\" name=\"descriptionnew[$type[typeid]]\" value=\"$type[description]\">",
is_array($forumsarray[$type['typeid']]) ? '<ul class="lineheight"><li class="left">'.implode(', </li><li class="left"> ', $forumsarray[$type['typeid']])."</li></ul><input type=\"hidden\" name=\"fids[$type[typeid]]\" value=\"".implode(', ', $fidsarray[$type['typeid']])."\">" : '',
"<a href=\"".ADMINSCRIPT."?action=threadtypes&operation=sortdetail&sortid=$type[typeid]\" class=\"act nowrap\">$lang[detail]</a>
<a href=\"".ADMINSCRIPT."?action=threadtypes&operation=sorttemplate&sortid=$type[typeid]\" class=\"act nowrap\">$lang[threadtype_template]</a>",
$tmpstr,
), TRUE);
}
?>
<script type="text/JavaScript">
var rowtypedata = [
[
[1, '', 'td25'],
[1, '<input type="text" class="txt" name="newdisplayorder[]" size="2" value="">', 'td28'],
[1, '<input type="text" class="txt" name="newname[]" size="15">', 'td29'],
[1, '<input type="text" class="txt" name="newdescription[]" size="30" value="">', 'td29'],
[2, '']
],
];
</script>
<?php
shownav('forum', 'threadtype_infotypes');
showsubmenu('threadtype_infotypes', array(
array('threadtype_infotypes_type', 'threadtypes', 1),
array('threadtype_infotypes_content', 'threadtypes&operation=content', 0),
array(array('menu' => ($curclassname ? $curclassname : 'threadtype_infotypes_option'), 'submenu' => $classoptionmenu), '', 0)
));
showformheader("threadtypes&", 'enctype', 'threadtypeform');
showtableheader('');
showsubtitle(array('', 'display_order', cplang('name').' '.cplang('tiny_bbcode_support'), 'description', 'forums_relation', '', ''), 'header', array('', 'width="60"', 'width="110"', 'width="210"', '', 'width="90"', 'width="60"'));
echo $threadtypes;
echo '<tr><td class="td25"></td><td colspan="5"><div>'.'<span class="filebtn"><input type="hidden" name="importtype" value="file" /><input type="file" name="importfile" class="pf" size="1" onchange="uploadthreadtypexml($(\'threadtypeform\'), \''.ADMINSCRIPT.'?action=threadtypes&operation=import\');" /><a class="addtr" href="JavaScript:;">'.$lang['import'].'</a></span>'.'<a href="###" onclick="addrow(this, 0)" class="addtr">'.$lang['threadtype_infotypes_add'].'</a></div></td>';
showsubmit('typesubmit', 'submit', 'del');
showtablefooter();
showformfooter();
} else {
$updatefids = $modifiedtypes = array();
if(is_array($_GET['delete'])) {
if($_GET['delete']) {
C::t('forum_typeoptionvar')->delete_by_sortid($_GET['delete']);
C::t('forum_typevar')->delete($_GET['delete']);
$affected_rows = C::t('forum_threadtype')->delete($_GET['delete']);
}
foreach($_GET['delete'] as $_GET['sortid']) {
C::t('forum_optionvalue')->drop($_GET['sortid']);
}
if($_GET['delete'] && $affected_rows) {
C::t('forum_thread')->update_sortid_by_sortid(0, $_GET['delete']);
foreach($_GET['delete'] as $id) {
if(is_array($_GET['namenew']) && isset($_GET['namenew'][$id])) {
unset($_GET['namenew'][$id]);
}
if(!empty($_GET['fids'][$id])) {
foreach(explode(',', $_GET['fids'][$id]) as $fid) {
if($fid = intval($fid)) {
$updatefids[$fid]['deletedids'][] = intval($id);
}
}
}
}
}
}
if(is_array($_GET['namenew']) && $_GET['namenew']) {
foreach($_GET['namenew'] as $typeid => $val) {
$_GET['descriptionnew'] = is_array($_GET['descriptionnew']) ? $_GET['descriptionnew'] : array();
$data = array(
'name' => trim($_GET['namenew'][$typeid]),
'description' => dhtmlspecialchars(trim($_GET['descriptionnew'][$typeid])),
'displayorder' => intval($_GET['displayordernew'][$typeid]),
'special' => 1,
);
$affected_rows = C::t('forum_threadtype')->update($typeid, $data);
if($affected_rows) {
$modifiedtypes[] = $typeid;
}
}
if($modifiedtypes = array_unique($modifiedtypes)) {
foreach($modifiedtypes as $id) {
if(!empty($_GET['fids'][$id])) {
foreach(explode(',', $_GET['fids'][$id]) as $fid) {
if($fid = intval($fid)) {
$updatefids[$fid]['modifiedids'][] = $id;
}
}
}
}
}
}
if($updatefids) {
$query = C::t('forum_forum')->fetch_all_info_by_fids(array_keys($updatefids));
foreach($query as $forum) {
if($forum[$changetype] == '') continue;
$fid = $forum['fid'];
$forum[$changetype] = dunserialize($forum[$changetype]);
if($updatefids[$fid]['deletedids']) {
foreach($updatefids[$fid]['deletedids'] as $id) {
unset($forum[$changetype]['types'][$id], $forum[$changetype]['flat'][$id], $forum[$changetype]['selectbox'][$id]);
}
}
if($updatefids[$fid]['modifiedids']) {
foreach($updatefids[$fid]['modifiedids'] as $id) {
if(isset($forum[$changetype]['types'][$id])) {
$_GET['namenew'][$id] = trim(strip_tags($_GET['namenew'][$id]));
$forum[$changetype]['types'][$id] = $_GET['namenew'][$id];
if(isset($forum[$changetype]['selectbox'][$id])) {
$forum[$changetype]['selectbox'][$id] = $_GET['namenew'][$id];
} else {
$forum[$changetype]['flat'][$id] = $_GET['namenew'][$id];
}
}
}
}
C::t('forum_forumfield')->update($fid, array($changetype => serialize($forum[$changetype])));
}
}
if(is_array($_GET['newname'])) {
foreach($_GET['newname'] as $key => $value) {
if($newname1 = trim(strip_tags($value))) {
if(C::t('forum_threadtype')->checkname($newname1)) {
cpmsg('forums_threadtypes_duplicate', '', 'error');
}
$data = array(
'name' => $newname1,
'description' => dhtmlspecialchars(trim($_GET['newdescription'][$key])),
'displayorder' => $_GET['newdisplayorder'][$key],
'special' => 1,
);
C::t('forum_threadtype')->insert($data);
}
}
}
cpmsg('forums_threadtypes_succeed', 'action=threadtypes', 'succeed');
}
} elseif($operation == 'typeoption') {
if(!submitcheck('typeoptionsubmit')) {
if($_GET['classid']) {
$typetitle = C::t('forum_typeoption')->fetch($_GET['classid']);
if(!$typetitle['title']) {
cpmsg('threadtype_infotypes_noexist', 'action=threadtypes', 'error');
}
$typeoptions = '';
foreach(C::t('forum_typeoption')->fetch_all_by_classid($_GET['classid']) as $option) {
$option['type'] = $lang['threadtype_edit_vars_type_'. $option['type']];
$typeoptions .= showtablerow('', array('class="td25"', 'class="td28"'), array(
"<input class=\"checkbox\" type=\"checkbox\" name=\"delete[]\" value=\"$option[optionid]\">",
"<input type=\"text\" class=\"txt\" size=\"2\" name=\"displayorder[$option[optionid]]\" value=\"$option[displayorder]\">",
"<input type=\"text\" class=\"txt\" size=\"15\" name=\"title[$option[optionid]]\" value=\"".dhtmlspecialchars($option['title'])."\">",
"$option[identifier]<input type=\"hidden\" name=\"identifier[$option[optionid]]\" value=\"$option[identifier]\">",
$option['type'],
"<a href=\"".ADMINSCRIPT."?action=threadtypes&operation=optiondetail&optionid=$option[optionid]\" class=\"act\">$lang[detail]</a>"
), TRUE);
}
}
echo <<<EOT
<script type="text/JavaScript">
var rowtypedata = [
[
[1, '', 'td25'],
[1, '<input type="text" class="txt" size="2" name="newdisplayorder[]" value="0">', 'td28'],
[1, '<input type="text" class="txt" size="15" name="newtitle[]">'],
[1, '<input type="text" class="txt" size="15" name="newidentifier[]">'],
[1, '<select name="newtype[]"><option value="number">$lang[threadtype_edit_vars_type_number]</option><option value="text" selected>$lang[threadtype_edit_vars_type_text]</option><option value="textarea">$lang[threadtype_edit_vars_type_textarea]</option><option value="radio">$lang[threadtype_edit_vars_type_radio]</option><option value="checkbox">$lang[threadtype_edit_vars_type_checkbox]</option><option value="select">$lang[threadtype_edit_vars_type_select]</option><option value="calendar">$lang[threadtype_edit_vars_type_calendar]</option><option value="email">$lang[threadtype_edit_vars_type_email]</option><option value="image">$lang[threadtype_edit_vars_type_image]</option><option value="url">$lang[threadtype_edit_vars_type_url]</option><option value="range">$lang[threadtype_edit_vars_type_range]</option></select>'],
[1, '']
],
];
</script>
EOT;
shownav('forum', 'threadtype_infotypes');
showsubmenu('threadtype_infotypes', array(
array('threadtype_infotypes_type', 'threadtypes', 0),
array('threadtype_infotypes_content', 'threadtypes&operation=content', 0),
array(array('menu' => ($curclassname ? $curclassname : 'threadtype_infotypes_option'), 'submenu' => $classoptionmenu), 1)
));
showformheader("threadtypes&operation=typeoption&typeid={$_GET['typeid']}");
showhiddenfields(array('classid' => $_GET['classid']));
showtableheader();
showsubtitle(array('', 'display_order', 'name', 'threadtype_variable', 'threadtype_type', ''));
echo $typeoptions;
echo '<tr><td></td><td colspan="5"><div><a href="###" onclick="addrow(this, 0)" class="addtr">'.$lang['threadtype_infotypes_add_option'].'</a></div></td></tr>';
showsubmit('typeoptionsubmit', 'submit', 'del');
showtablefooter();
showformfooter();
} else {
if($ids = dimplode($_GET['delete'])) {
C::t('forum_typeoption')->delete($_GET['delete']);
C::t('forum_typevar')->delete(null, $_GET['delete']);
}
if(is_array($_GET['title'])) {
foreach($_GET['title'] as $id => $val) {
if(in_array(strtoupper($_GET['identifier'][$id]), $mysql_keywords)) {
continue;
}
C::t('forum_typeoption')->update($id, array(
'displayorder' => $_GET['displayorder'][$id],
'title' => $_GET['title'][$id],
'identifier' => $_GET['identifier'][$id],
));
}
}
if(is_array($_GET['newtitle'])) {
foreach($_GET['newtitle'] as $key => $value) {
$newtitle1 = dhtmlspecialchars(trim($value));
$newidentifier1 = trim($_GET['newidentifier'][$key]);
if($newtitle1 && $newidentifier1) {
if(in_array(strtoupper($newidentifier1), $mysql_keywords)) {
cpmsg('threadtype_infotypes_optionvariable_iskeyword', '', 'error');
}
if(C::t('forum_typeoption')->fetch_all_by_identifier($newidentifier1, 0, 1) || strlen($newidentifier1) > 40 || !ispluginkey($newidentifier1)) {
cpmsg('threadtype_infotypes_optionvariable_invalid', '', 'error');
}
$data = array(
'classid' => $_GET['classid'],
'displayorder' => $_GET['newdisplayorder'][$key],
'title' => $newtitle1,
'identifier' => $newidentifier1,
'type' => $_GET['newtype'][$key],
);
C::t('forum_typeoption')->insert($data);
} elseif($newtitle1 && !$newidentifier1) {
cpmsg('threadtype_infotypes_option_invalid', 'action=threadtypes&operation=typeoption&classid='.$_GET['classid'], 'error');
}
}
}
updatecache('threadsorts');
cpmsg('threadtype_infotypes_succeed', 'action=threadtypes&operation=typeoption&classid='.$_GET['classid'], 'succeed');
}
} elseif($operation == 'optiondetail') {
$option = C::t('forum_typeoption')->fetch($_GET['optionid']);
if(!$option) {
cpmsg('typeoption_not_found', '', 'error');
}
if(!submitcheck('editsubmit')) {
shownav('forum', 'threadtype_infotypes');
showsubmenu('threadtype_infotypes', array(
array('threadtype_infotypes_type', 'threadtypes', 0),
array('threadtype_infotypes_content', 'threadtypes&operation=content', 0),
array(array('menu' => ($curclassname ? $curclassname : 'threadtype_infotypes_option'), 'submenu' => $classoptionmenu), '', 1)
));
$typeselect = '<select name="typenew" onchange="var styles, key;styles=new Array(\'number\',\'text\',\'radio\', \'checkbox\', \'textarea\', \'select\', \'image\', \'calendar\', \'range\', \'info\'); for(key in styles) {var obj=$(\'style_\'+styles[key]); if(obj) { obj.style.display=styles[key]==this.options[this.selectedIndex].value?\'\':\'none\';}}">';
foreach(array('number', 'text', 'radio', 'checkbox', 'textarea', 'select', 'calendar', 'email', 'url', 'image', 'range') as $type) {
$typeselect .= '<option value="'.$type.'" '.($option['type'] == $type ? 'selected' : '').'>'.$lang['threadtype_edit_vars_type_'.$type].'</option>';
}
$typeselect .= '</select>';
$option['rules'] = dunserialize($option['rules']);
$option['protect'] = dunserialize($option['protect']);
$groups = $forums = array();
foreach(C::t('common_usergroup')->range() as $group) {
$groups[] = array($group['groupid'], $group['grouptitle']);
}
$verifys = array();
if($_G['setting']['verify']['enabled']) {
foreach($_G['setting']['verify'] as $key => $verify) {
if($verify['available'] == 1) {
$verifys[] = array($key, $verify['title']);
}
}
}
foreach(C::t('common_member_profile_setting')->fetch_all_by_available_formtype(1, 'text') as $result) {
$threadtype_profile = !$threadtype_profile ? "<select id='rules[text][profile]' name='rules[text][profile]'><option value=''></option>" : $threadtype_profile."<option value='{$result[fieldid]}' ".($option['rules']['profile'] == $result['fieldid'] ? "selected='selected'" : '').">{$result[title]}</option>";
}
$threadtype_profile .= "</select>";
showformheader("threadtypes&operation=optiondetail&optionid=$_GET[optionid]");
showtableheader();
showtitle('threadtype_infotypes_option_config');
showsetting('name', 'titlenew', $option['title'], 'text');
showsetting('threadtype_variable', 'identifiernew', $option['identifier'], 'text');
showsetting('type', '', '', $typeselect);
showsetting('threadtype_edit_desc', 'descriptionnew', $option['description'], 'textarea');
showsetting('threadtype_unit', 'unitnew', $option['unit'], 'text');
showsetting('threadtype_expiration', 'expirationnew', $option['expiration'], 'radio');
if(in_array($option['type'], array('calendar', 'number', 'text', 'email', 'textarea'))) {
showsetting('threadtype_protect', 'protectnew[status]', $option['protect']['status'], 'radio', 0, 1);
showsetting('threadtype_protect_mode', array('protectnew[mode]', array(
array(1, $lang['threadtype_protect_mode_pic']),
array(2, $lang['threadtype_protect_mode_html'])
)), $option['protect']['mode'], 'mradio');
showsetting('threadtype_protect_usergroup', array('protectnew[usergroup][]', $groups), explode("\t", $option['protect']['usergroup']), 'mselect');
$verifys && showsetting('threadtype_protect_verify', array('protectnew[verify][]', $verifys), explode("\t", $option['protect']['verify']), 'mselect');
showsetting('threadtype_protect_permprompt', 'permpromptnew', $option['permprompt'], 'textarea');
}
showtagheader('tbody', "style_calendar", $option['type'] == 'calendar');
showtitle('threadtype_edit_vars_type_calendar');
showsetting('threadtype_edit_inputsize', 'rules[calendar][inputsize]', $option['rules']['inputsize'], 'text');
showtagfooter('tbody');
showtagheader('tbody', "style_number", $option['type'] == 'number');
showtitle('threadtype_edit_vars_type_number');
showsetting('threadtype_edit_maxnum', 'rules[number][maxnum]', $option['rules']['maxnum'], 'text');
showsetting('threadtype_edit_minnum', 'rules[number][minnum]', $option['rules']['minnum'], 'text');
showsetting('threadtype_edit_inputsize', 'rules[number][inputsize]', $option['rules']['inputsize'], 'text');
showsetting('threadtype_defaultvalue', 'rules[number][defaultvalue]', $option['rules']['defaultvalue'], 'text');
showtagfooter('tbody');
showtagheader('tbody', "style_text", $option['type'] == 'text');
showtitle('threadtype_edit_vars_type_text');
showsetting('threadtype_edit_textmax', 'rules[text][maxlength]', $option['rules']['maxlength'], 'text');
showsetting('threadtype_edit_inputsize', 'rules[text][inputsize]', $option['rules']['inputsize'], 'text');
showsetting('threadtype_edit_profile', '', '', $threadtype_profile);
showsetting('threadtype_defaultvalue', 'rules[text][defaultvalue]', $option['rules']['defaultvalue'], 'text');
showtagfooter('tbody');
showtagheader('tbody', "style_textarea", $option['type'] == 'textarea');
showtitle('threadtype_edit_vars_type_textarea');
showsetting('threadtype_edit_textmax', 'rules[textarea][maxlength]', $option['rules']['maxlength'], 'text');
showsetting('threadtype_edit_colsize', 'rules[textarea][colsize]', $option['rules']['colsize'], 'text');
showsetting('threadtype_edit_rowsize', 'rules[textarea][rowsize]', $option['rules']['rowsize'], 'text');
showsetting('threadtype_defaultvalue', 'rules[textarea][defaultvalue]', $option['rules']['defaultvalue'], 'text');
showtagfooter('tbody');
showtagheader('tbody', "style_select", $option['type'] == 'select');
showtitle('threadtype_edit_vars_type_select');
showsetting('threadtype_edit_select_choices', 'rules[select][choices]', $option['rules']['choices'], 'textarea');
showsetting('threadtype_edit_inputsize', 'rules[select][inputsize]', $option['rules']['inputsize'], 'text');
showtagfooter('tbody');
showtagheader('tbody', "style_radio", $option['type'] == 'radio');
showtitle('threadtype_edit_vars_type_radio');
showsetting('threadtype_edit_choices', 'rules[radio][choices]', $option['rules']['choices'], 'textarea');
showtagfooter('tbody');
showtagheader('tbody', "style_checkbox", $option['type'] == 'checkbox');
showtitle('threadtype_edit_vars_type_checkbox');
showsetting('threadtype_edit_choices', 'rules[checkbox][choices]', $option['rules']['choices'], 'textarea');
showtagfooter('tbody');
showtagheader('tbody', "style_image", $option['type'] == 'image');
showtitle('threadtype_edit_vars_type_image');
showsetting('threadtype_edit_images_weight', 'rules[image][maxwidth]', $option['rules']['maxwidth'], 'text');
showsetting('threadtype_edit_images_height', 'rules[image][maxheight]', $option['rules']['maxheight'], 'text');
showsetting('threadtype_edit_inputsize', 'rules[image][inputsize]', $option['rules']['inputsize'], 'text');
showtagfooter('tbody');
showtagheader('tbody', "style_range", $option['type'] == 'range');
showtitle('threadtype_edit_vars_type_range');
showsetting('threadtype_edit_maxnum', 'rules[range][maxnum]', $option['rules']['maxnum'], 'text');
showsetting('threadtype_edit_minnum', 'rules[range][minnum]', $option['rules']['minnum'], 'text');
showsetting('threadtype_edit_inputsize', 'rules[range][inputsize]', $option['rules']['inputsize'], 'text');
showsetting('threadtype_edit_searchtxt', 'rules[range][searchtxt]', $option['rules']['searchtxt'], 'text');
showtagfooter('tbody');
showsubmit('editsubmit');
showtablefooter();
showformfooter();
} else {
$titlenew = trim($_GET['titlenew']);
$_GET['identifiernew'] = trim($_GET['identifiernew']);
if(!$titlenew || !$_GET['identifiernew']) {
cpmsg('threadtype_infotypes_option_invalid', '', 'error');
}
if(in_array(strtoupper($_GET['identifiernew']), $mysql_keywords)) {
cpmsg('threadtype_infotypes_optionvariable_iskeyword', '', 'error');
}
if(C::t('forum_typeoption')->fetch_all_by_identifier($_GET['identifiernew'], 0, 1, $_GET['optionid']) || strlen($_GET['identifiernew']) > 40 || !ispluginkey($_GET['identifiernew'])) {
cpmsg('threadtype_infotypes_optionvariable_invalid', '', 'error');
}
$_GET['protectnew']['usergroup'] = $_GET['protectnew']['usergroup'] ? implode("\t", $_GET['protectnew']['usergroup']) : '';
$_GET['protectnew']['verify'] = $_GET['protectnew']['verify'] ? implode("\t", $_GET['protectnew']['verify']) : '';
C::t('forum_typeoption')->update($_GET['optionid'], array(
'title' => $titlenew,
'description' => $_GET['descriptionnew'],
'identifier' => $_GET['identifiernew'],
'type' => $_GET['typenew'],
'unit' => $_GET['unitnew'],
'expiration' => $_GET['expirationnew'],
'protect' => serialize($_GET['protectnew']),
'rules' => serialize($_GET['rules'][$_GET['typenew']]),
'permprompt' => $_GET['permpromptnew'],
));
updatecache('threadsorts');
cpmsg('threadtype_infotypes_option_succeed', 'action=threadtypes&operation=typeoption&classid='.$option['classid'], 'succeed');
}
} elseif($operation == 'sortdetail') {
if(!submitcheck('sortdetailsubmit')) {
$threadtype = C::t('forum_threadtype')->fetch($_GET['sortid']);
$threadtype['modelid'] = isset($_GET['modelid']) ? intval($_GET['modelid']) : $threadtype['modelid'];
$sortoptions = $jsoptionids = '';
$showoption = array();
$typevararr = C::t('forum_typevar')->fetch_all_by_sortid($_GET['sortid'], 'ASC');
$typeoptionarr = C::t('forum_typeoption')->fetch_all(array_keys($typevararr));
foreach($typevararr as $option) {
$option['title'] = $typeoptionarr[$option['optionid']]['title'];
$option['type'] = $typeoptionarr[$option['optionid']]['type'];
$option['identifier'] = $typeoptionarr[$option['optionid']]['identifier'];
$jsoptionids .= "optionids.push($option[optionid]);\r\n";
$optiontitle[$option['identifier']] = $option['title'];
$showoption[$option['optionid']]['optionid'] = $option['optionid'];
$showoption[$option['optionid']]['title'] = $option['title'];
$showoption[$option['optionid']]['type'] = $lang['threadtype_edit_vars_type_'. $option['type']];
$showoption[$option['optionid']]['identifier'] = $option['identifier'];
$showoption[$option['optionid']]['displayorder'] = $option['displayorder'];
$showoption[$option['optionid']]['available'] = $option['available'];
$showoption[$option['optionid']]['required'] = $option['required'];
$showoption[$option['optionid']]['unchangeable'] = $option['unchangeable'];
$showoption[$option['optionid']]['search'] = $option['search'];
$showoption[$option['optionid']]['subjectshow'] = $option['subjectshow'];
}
unset($typevararr, $typeoptionarr);
if($existoption && is_array($existoption)) {
$optionids = array();
foreach($existoption as $optionid => $val) {
$optionids[] = $optionid;
}
foreach(C::t('forum_typeoption')->fetch_all($optionids) as $option) {
$showoption[$option['optionid']]['optionid'] = $option['optionid'];
$showoption[$option['optionid']]['title'] = $option['title'];
$showoption[$option['optionid']]['type'] = $lang['threadtype_edit_vars_type_'. $option['type']];
$showoption[$option['optionid']]['identifier'] = $option['identifier'];
$showoption[$option['optionid']]['required'] = $existoption[$option['optionid']];
$showoption[$option['optionid']]['available'] = 1;
$showoption[$option['optionid']]['unchangeable'] = 0;
$showoption[$option['optionid']]['model'] = 1;
}
}
$searchtitle = $searchvalue = $searchunit = array();
foreach($showoption as $optionid => $option) {
$sortoptions .= showtablerow('id="optionid'.$optionid.'"', array('class="td25"', 'class="td28 td23"'), array(
"<input class=\"checkbox\" type=\"checkbox\" name=\"delete[]\" value=\"$option[optionid]\">",
"<input type=\"text\" class=\"txt\" size=\"2\" name=\"displayorder[$option[optionid]]\" value=\"$option[displayorder]\">",
"<input class=\"checkbox\" type=\"checkbox\" name=\"available[$option[optionid]]\" value=\"1\" ".($option['available'] ? 'checked' : '')." ".($option['model'] ? 'disabled' : '').">",
dhtmlspecialchars($option['title']),
$option['type'],
"<input class=\"checkbox\" type=\"checkbox\" name=\"required[$option[optionid]]\" value=\"1\" ".($option['required'] ? 'checked' : '')." ".($option['model'] ? 'disabled' : '').">",
"<input class=\"checkbox\" type=\"checkbox\" name=\"unchangeable[$option[optionid]]\" value=\"1\" ".($option['unchangeable'] ? 'checked' : '').">",
"<input class=\"checkbox\" type=\"checkbox\" name=\"search[$option[optionid]][form]\" value=\"1\" ".(getstatus($option['search'], 1) == 1 ? 'checked' : '').">",
"<input class=\"checkbox\" type=\"checkbox\" name=\"search[$option[optionid]][font]\" value=\"1\" ".(getstatus($option['search'], 2) == 1 ? 'checked' : '').">",
"<input class=\"checkbox\" type=\"checkbox\" name=\"subjectshow[$option[optionid]]\" value=\"1\" ".($option['subjectshow'] ? 'checked' : '').">",
"<a href=\"".ADMINSCRIPT."?action=threadtypes&operation=optiondetail&optionid=$option[optionid]\" class=\"act\" target=\"_blank\">".$lang['edit']."</a>"
), TRUE);
$searchtitle[] = '/{('.$option['identifier'].')}/e';
$searchvalue[] = '/\[('.$option['identifier'].')value\]/e';
$searchunit[] = '/\[('.$option['identifier'].')unit\]/e';
}
shownav('forum', 'threadtype_infotypes');
showsubmenu('threadtype_infotypes', array(
array('threadtype_infotypes_type', 'threadtypes', 1),
array('threadtype_infotypes_content', 'threadtypes&operation=content', 0),
array(array('menu' => ($curclassname ? $curclassname : 'threadtype_infotypes_option'), 'submenu' => $classoptionmenu), '', 0)
));
showsubmenu('forums_edit_threadsorts');
showtips('forums_edit_threadsorts_tips');
showformheader("threadtypes&operation=sortdetail&sortid={$_GET['sortid']}");
showtableheader('threadtype_infotypes_validity', 'nobottom');
showsetting('threadtype_infotypes_validity', 'typeexpiration', $threadtype['expiration'], 'radio');
showtablefooter();
showtableheader("$threadtype[name] - $lang[threadtype_infotypes_add_option]", 'noborder fixpadding');
showtablerow('', 'id="classlist"', '');
showtablerow('', 'id="optionlist"', '');
showtablefooter();
showtableheader("$threadtype[name] - $lang[threadtype_infotypes_exist_option]", 'noborder fixpadding', 'id="sortlist"');
showsubtitle(array('<input type="checkbox" name="chkall" id="chkall" class="checkbox" onclick="checkAll(\'prefix\', this.form,\'delete\')" /><label for="chkall">'.cplang('del').'</label>', 'display_order', 'available', 'name', 'type', 'required', 'unchangeable', 'threadtype_infotypes_formsearch', 'threadtype_infotypes_fontsearch', 'threadtype_infotypes_show', ''));
echo $sortoptions;
showtablefooter();
?>
<input type="submit" class="btn" name="sortdetailsubmit" value="<?php echo $lang['submit'];?>">
</form>
<script type="text/JavaScript">
var optionids = new Array();
<?php echo $jsoptionids;?>
function checkedbox() {
var tags = $('optionlist').getElementsByTagName('input');
for(var i=0; i<tags.length; i++) {
if(in_array(tags[i].value, optionids)) {
tags[i].checked = true;
}
}
}
function insertoption(optionid) {
var x = new Ajax();
x.optionid = optionid;
x.get('<?php echo ADMINSCRIPT;?>?action=threadtypes&operation=sortlist&inajax=1&optionid=' + optionid, function(s, x) {
if(!in_array(x.optionid, optionids)) {
var div = document.createElement('div');
div.style.display = 'none';
$('append_parent').appendChild(div);
div.innerHTML = '<table>' + s + '</table>';
var tr = div.getElementsByTagName('tr');
var trs = $('sortlist').getElementsByTagName('tr');
tr[0].id = 'optionid' + optionid;
trs[trs.length - 1].parentNode.appendChild(tr[0]);
$('append_parent').removeChild(div);
optionids.push(x.optionid);
} else {
$('optionid' + x.optionid).parentNode.removeChild($('optionid' + x.optionid));
for(var i=0; i<optionids.length; i++) {
if(optionids[i] == x.optionid) {
optionids[i] = 0;
}
}
}
});
}
</script>
<script type="text/JavaScript">ajaxget('<?php echo ADMINSCRIPT;?>?action=threadtypes&operation=classlist', 'classlist');</script>
<script type="text/JavaScript">ajaxget('<?php echo ADMINSCRIPT;?>?action=threadtypes&operation=optionlist&sortid=<?php echo $_GET['sortid'];?>', 'optionlist', '', '', '', checkedbox);</script>
<?php
} else {
$threadtype = C::t('forum_threadtype')->fetch($_GET['sortid']);
if($_GET['typeexpiration'] != $threadtype['expiration']) {
$query = C::t('forum_forum')->fetch_all_for_threadsorts();
$fidsarray = array();
foreach($query as $forum) {
$forum['threadsorts'] = dunserialize($forum['threadsorts']);
if(is_array($forum['threadsorts']['types'])) {
foreach($forum['threadsorts']['types'] as $typeid => $name) {
$typeid == $_GET['sortid'] && $fidsarray[$forum['fid']] = $forum['threadsorts'];
}
}
}
if($fidsarray) {
foreach($fidsarray as $changefid => $forumthreadsorts) {
$forumthreadsorts['expiration'][$_GET['sortid']] = $_GET['typeexpiration'];
C::t('forum_forumfield')->update($changefid, array('threadsorts' => serialize($forumthreadsorts)));
}
}
}
C::t('forum_threadtype')->update($_GET['sortid'], array('special' => 1, 'modelid' => $_GET['modelid'], 'expiration' => $_GET['typeexpiration']));
if(submitcheck('sortdetailsubmit')) {
$orgoption = $orgoptions = $addoption = array();
foreach(C::t('forum_typevar')->fetch_all_by_sortid($_GET['sortid']) as $orgoption) {
$orgoptions[] = $orgoption['optionid'];
}
$addoption = $addoption ? (array)$addoption + (array)$_GET['displayorder'] : (array)$_GET['displayorder'];
@$newoptions = array_keys($addoption);
if(empty($addoption)) {
cpmsg('threadtype_infotypes_invalid', '', 'error');
}
@$delete = array_merge((array)$_GET['delete'], array_diff($orgoptions, $newoptions));
if($delete) {
if($ids = dimplode($delete)) {
C::t('forum_typevar')->delete($_GET['sortid'], $delete);
}
foreach($delete as $id) {
unset($addoption[$id]);
}
}
$insertoptionid = $indexoption = array();
$create_table_sql = $separator = $create_tableoption_sql = '';
if(is_array($addoption) && !empty($addoption)) {
foreach(C::t('forum_typeoption')->fetch_all(array_keys($addoption)) as $option) {
$insertoptionid[$option['optionid']]['type'] = $option['type'];
$insertoptionid[$option['optionid']]['identifier'] = $option['identifier'];
}
if(!C::t('forum_optionvalue')->showcolumns($_GET['sortid'])) {
$fields = '';
foreach($addoption as $optionid => $option) {
$identifier = $insertoptionid[$optionid]['identifier'];
if($identifier) {
if(in_array($insertoptionid[$optionid]['type'], array('radio'))) {
$create_tableoption_sql .= "$separator$identifier smallint(6) UNSIGNED NOT NULL DEFAULT '0'";
} elseif(in_array($insertoptionid[$optionid]['type'], array('number', 'range'))) {
$create_tableoption_sql .= "$separator$identifier int(10) UNSIGNED NOT NULL DEFAULT '0'";
} elseif($insertoptionid[$optionid]['type'] == 'select') {
$create_tableoption_sql .= "$separator$identifier varchar(50) NOT NULL";
} else {
$create_tableoption_sql .= "$separator$identifier mediumtext NOT NULL";
}
$separator = ' ,';
if(in_array($insertoptionid[$optionid]['type'], array('radio', 'select', 'number'))) {
$indexoption[] = $identifier;
}
}
}
$fields .= ($create_tableoption_sql ? $create_tableoption_sql.',' : '')."tid mediumint(8) UNSIGNED NOT NULL DEFAULT '0',fid smallint(6) UNSIGNED NOT NULL DEFAULT '0',dateline int(10) UNSIGNED NOT NULL DEFAULT '0',expiration int(10) UNSIGNED NOT NULL DEFAULT '0',";
$fields .= "KEY (fid), KEY(dateline)";
if($indexoption) {
foreach($indexoption as $index) {
$fields .= "$separator KEY $index ($index)";
$separator = ' ,';
}
}
$dbcharset = $_G['config']['db'][1]['dbcharset'];
$dbcharset = empty($dbcharset) ? str_replace('-','',CHARSET) : $dbcharset;
C::t('forum_optionvalue')->create($_GET['sortid'], $fields, $dbcharset);
} else {
$tables = C::t('forum_optionvalue')->showcolumns($_GET['sortid']);
foreach($addoption as $optionid => $option) {
$identifier = $insertoptionid[$optionid]['identifier'];
if(!$tables[$identifier]) {
$fieldname = $identifier;
if(in_array($insertoptionid[$optionid]['type'], array('radio'))) {
$fieldtype = 'smallint(6) UNSIGNED NOT NULL DEFAULT \'0\'';
} elseif(in_array($insertoptionid[$optionid]['type'], array('number', 'range'))) {
$fieldtype = 'int(10) UNSIGNED NOT NULL DEFAULT \'0\'';
} elseif($insertoptionid[$optionid]['type'] == 'select') {
$fieldtype = 'varchar(50) NOT NULL';
} else {
$fieldtype = 'mediumtext NOT NULL';
}
C::t('forum_optionvalue')->alter($_GET['sortid'], "ADD $fieldname $fieldtype");
if(in_array($insertoptionid[$optionid]['type'], array('radio', 'select', 'number'))) {
C::t('forum_optionvalue')->alter($_GET['sortid'], "ADD INDEX ($fieldname)");
}
}
}
}
foreach($addoption as $id => $val) {
$optionid = C::t('forum_typeoption')->fetch($id);
if($optionid) {
$data = array(
'sortid' => $_GET['sortid'],
'optionid' => $id,
'available' => 1,
'required' => intval($val),
);
C::t('forum_typevar')->insert($data, 0, 0, 1);
$search_bit = 0;
foreach($_GET['search'][$id] AS $key => $val) {
if($val == 1) {
if($key == 'font') {
$search_bit = setstatus(2, 1, $search_bit);
} elseif($key == 'form') {
$search_bit = setstatus(1, 1, $search_bit);
}
}
}
C::t('forum_typevar')->update($_GET['sortid'], $id, array(
'displayorder' => $_GET['displayorder'][$id],
'available' => $_GET['available'][$id],
'required' => $_GET['required'][$id],
'unchangeable' => $_GET['unchangeable'][$id],
'search' => $search_bit,
'subjectshow' => $_GET['subjectshow'][$id],
));
} else {
C::t('forum_typevar')->delete($_GET['sortid'], $id);
}
}
}
updatecache('threadsorts');
cpmsg('threadtype_infotypes_succeed', 'action=threadtypes&operation=sortdetail&sortid='.$_GET['sortid'], 'succeed');
}
}
} elseif($operation == 'sorttemplate') {
if(!submitcheck('sorttemplatesubmit')) {
$threadtype = C::t('forum_threadtype')->fetch($_GET['sortid']);
$showoption = '';
$typevararr = C::t('forum_typevar')->fetch_all_by_sortid($_GET['sortid'], 'ASC');
$typeoptionarr = C::t('forum_typeoption')->fetch_all(array_keys($typevararr));
foreach($typevararr as $option) {
$option['title'] = $typeoptionarr[$option['optionid']]['title'];
$option['type'] = $typeoptionarr[$option['optionid']]['type'];
$option['identifier'] = $typeoptionarr[$option['optionid']]['identifier'];
$showoption .= '<button onclick="settip(this, \''.$option['identifier'].'\')" type="button">'.$option['title'].'</button> ';
}
unset($typevararr, $typeoptionarr);
showsubmenu('threadtype_infotypes', array(
array('threadtype_infotypes_type', 'threadtypes', 1),
array('threadtype_infotypes_content', 'threadtypes&operation=content', 0),
array(array('menu' => ($curclassname ? $curclassname : 'threadtype_infotypes_option'), 'submenu' => $classoptionmenu), '', 0)
));
showformheader("threadtypes&operation=sorttemplate&sortid={$_GET['sortid']}");
echo '<script type="text/JavaScript">var currentAnchor = \'ltype\';</script>'.
'<div class="itemtitle" style="width:100%;margin-bottom:5px;"><ul class="tab1" id="submenu">'.
'<li id="nav_ttype" onclick="showanchor(this)" class="current"><a href="#"><span>'.$lang['threadtype_template_viewthread'].'</span></a></li>'.
'<li id="nav_stype" onclick="showanchor(this)"><a href="#"><span>'.$lang['threadtype_template_forumdisplay'].'</span></a></li>'.
'<li id="nav_ptype" onclick="showanchor(this)"><a href="#"><span>'.$lang['threadtype_template_post'].'</span></a></li>'.
'<li id="nav_btype" onclick="showanchor(this)"><a href="#"><span>'.$lang['threadtype_template_diy'].'</span></a></li>'.
'</ul></div>';
echo '<div id="ttype">'.
$showoption.
'<div id="ttype_tip"></div>'.
'<br /><textarea cols="100" rows="15" id="ttypetemplate" name="typetemplate" style="width: 95%;" onkeyup="textareasize(this)" onkeydown="textareakey(this, event)">'.dhtmlspecialchars($threadtype['template']).'</textarea>'.
'</div>';
echo '<div id="stype" style="display:none">'.
'<button onclick="settip(this, \'subject\', \'subject/'.$lang['threadtype_template_threadtitle'].'|subject_url/'.$lang['threadtype_template_threadurl'].'|tid/'.$lang['threadtype_template_threadid'].'\')" type="button">'.$lang['threadtype_template_threadtitle'].'</button> '.
'<textarea id="subject_sample" style="display:none" onkeyup="textareasize(this)" onkeydown="textareakey(this, event)"><a href="{subject_url}">{subject}</a></textarea>'.
'<button onclick="settip(this, \'\', \'dateline/'.$lang['threadtype_template_dateline'].'\')" type="button">'.$lang['threadtype_template_dateline'].'</button> '.
'<button onclick="settip(this, \'author\', \'author/'.$lang['threadtype_template_author'].'|authorid/'.$lang['threadtype_template_authorid'].'|author_url/'.$lang['threadtype_template_authorurl'].'|avatar_small/'.$lang['threadtype_template_authoravatar'].'|author_verify/'.$lang['threadtype_template_authorverify'].'\')" type="button">'.$lang['threadtype_template_threadauthor'].'</button> '.
'<textarea id="author_sample" style="display:none" onkeyup="textareasize(this)" onkeydown="textareakey(this, event)"><a href="{author_url}">{author}</a></textarea>'.
'<button onclick="settip(this, \'\', \'views/'.$lang['threadtype_template_threadviews'].'\')" type="button">'.$lang['threadtype_template_threadviews'].'</button> '.
'<button onclick="settip(this, \'\', \'replies/'.$lang['threadtype_template_threadreplies'].'\')" type="button">'.$lang['threadtype_template_threadreplies'].'</button> '.
'<button onclick="settip(this, \'lastpost\', \'lastpost/'.$lang['threadtype_template_lastpostdateline'].'|lastpost_url/'.$lang['threadtype_template_lastposturl'].'|lastposter/'.$lang['threadtype_template_lastpostuser'].'|lastposter_url/'.$lang['threadtype_template_lastpostuserurl'].'\')" type="button">'.$lang['threadtype_template_lastpost'].'</button> '.
'<textarea id="lastpost_sample" style="display:none" onkeyup="textareasize(this)" onkeydown="textareakey(this, event)"><a href="{lastpost_url}">{lastpost}</a> by <a href="{lastposter_url}">{lastposter}</a></textarea>'.
'<button onclick="settip(this, \'typename\', \'typename/'.$lang['threadtype_template_threadtypename'].'|typename_url/'.$lang['threadtype_template_threadtypeurl'].'\')" type="button">'.$lang['threadtype_template_threadtype'].'</button> '.
'<textarea id="typename_sample" style="display:none" onkeyup="textareasize(this)" onkeydown="textareakey(this, event)"><a href="{typename_url}">{typename}</a></textarea>'.
'<button onclick="settip(this, \'\', \'attachment/'.$lang['threadtype_template_attachmentexist'].'\')" type="button">'.$lang['threadtype_template_attachment'].'</button>  '.
'<button onclick="settip(this, \'\', \'modcheck/'.$lang['threadtype_template_modcheck'].'\')" type="button">'.$lang['threadtype_template_threadmod'].'</button>  '.
'<button onclick="settip(this, \'loop\', \'/'.$lang['threadtype_template_loop'].'\')" type="button">[loop]...[/loop]</button> '.
'<textarea id="loop_sample" style="display:none" onkeyup="textareasize(this)" onkeydown="textareakey(this, event)">
<table><tr><td>'.$lang['threadtype_template_title'].'</td></tr>
[loop]<tr><td><a href="{subject_url}">{subject}</a></td></tr>[/loop]
</table>
</textarea>'.
'<br />'.
$showoption.
'<div id="stype_tip"></div>'.
'<br /><textarea cols="100" rows="15" id="stypetemplate" name="stypetemplate" style="width: 95%;" onkeyup="textareasize(this)" onkeydown="textareakey(this, event)">'.dhtmlspecialchars($threadtype['stemplate']).'</textarea>'.
'</div>';
echo '<div id="ptype" style="display:none">'.
$showoption.
'<div id="ptype_tip"></div>'.
'<br /><textarea cols="100" rows="15" id="ptypetemplate" name="ptypetemplate" style="width: 95%;" onkeyup="textareasize(this)" onkeydown="textareakey(this, event)">'.dhtmlspecialchars($threadtype['ptemplate']).'</textarea>'.
'</div>';
echo '<div id="btype" style="display:none">'.
'<button onclick="settip(this, \'subject\', \'subject/'.$lang['threadtype_template_threadtitle'].'|subject_url/'.$lang['threadtype_template_threadurl'].'|tid/'.$lang['threadtype_template_threadid'].'\')" type="button">'.$lang['threadtype_template_threadtitle'].'</button> '.
'<button onclick="settip(this, \'\', \'dateline/'.$lang['threadtype_template_dateline'].'\')" type="button">'.$lang['threadtype_template_dateline'].'</button> '.
'<button onclick="settip(this, \'author\', \'author/'.$lang['threadtype_template_author'].'|authorid/'.$lang['threadtype_template_authorid'].'|author_url/'.$lang['threadtype_template_authorurl'].'|avatar_small/'.$lang['threadtype_template_authoravatar'].'|author_verify/'.$lang['threadtype_template_authorverify'].'\')" type="button">'.$lang['threadtype_template_threadauthor'].'</button> '.
'<button onclick="settip(this, \'\', \'views/'.$lang['threadtype_template_threadviews'].'\')" type="button">'.$lang['threadtype_template_threadviews'].'</button> '.
'<button onclick="settip(this, \'\', \'replies/'.$lang['threadtype_template_threadreplies'].'\')" type="button">'.$lang['threadtype_template_threadreplies'].'</button> '.
'<button onclick="settip(this, \'lastpost\', \'lastpost/'.$lang['threadtype_template_lastpostdateline'].'|lastpost_url/'.$lang['threadtype_template_lastposturl'].'|lastposter/'.$lang['threadtype_template_lastpostuser'].'|lastposter_url/'.$lang['threadtype_template_lastpostuserurl'].'\')" type="button">'.$lang['threadtype_template_lastpost'].'</button> '.
'<button onclick="settip(this, \'typename\', \'typename/'.$lang['threadtype_template_threadtypename'].'|typename_url/'.$lang['threadtype_template_threadtypeurl'].'\')" type="button">'.$lang['threadtype_template_threadtype'].'</button> '.
'<button onclick="settip(this, \'\', \'attachment/'.$lang['threadtype_template_attachmentexist'].'\')" type="button">'.$lang['threadtype_template_attachment'].'</button>  '.
'<button onclick="settip(this, \'loop\', \'/'.$lang['threadtype_template_loop'].'\')" type="button">[loop]...[/loop]</button> '.
'<br />'.
$showoption.
'<div id="btype_tip"></div>'.
'<br /><textarea cols="100" rows="15" id="btypetemplate" name="btypetemplate" style="width: 95%;" onkeyup="textareasize(this)" onkeydown="textareakey(this, event)">'.dhtmlspecialchars($threadtype['btemplate']).'</textarea>'.
'</div>'.
'<input type="submit" class="btn" name="sorttemplatesubmit" value="'.$lang['submit'].'"></form>';
echo '<script>
function settip(obj, id, tips) {
var tips = !tips ? 0 : tips.split(\'|\');
var tipid = obj.parentNode.id + \'_tip\', s1 = \'\', s2 = \'\', s3 = \'\';
if(!tips) {
s1 += \'<td>{\' + id + \'}</td>\';
s2 += \'<td>'.$lang['threadtype_template_varname'].'(\' + obj.innerHTML + \')</td>\';
s1 += \'<td>{\' + id + \'_value}</td>\';
s2 += \'<td>'.$lang['threadtype_template_varvalue'].'</td>\';
s1 += \'<td>{\' + id + \'_unit}</td>\';
s2 += \'<td>'.$lang['threadtype_template_varunit'].'</td>\';
if(obj.parentNode.id == \'ptype\') {
s1 += \'<td>{\' + id + \'_required}</td>\';
s2 += \'<td>'.$lang['threadtype_template_requiredflag'].'</td>\';
s1 += \'<td>{\' + id + \'_tips}</td>\';
s2 += \'<td>'.$lang['threadtype_template_tipflag'].'</td>\';
s1 += \'<td>{\' + id + \'_description}</td>\';
s2 += \'<td>'.$lang['threadtype_template_briefdes'].'</td>\';
}
if(obj.parentNode.id == \'ptype\') {
s3 = \'<dt><strong class="rq">{\' + id + \'_required}</strong>{\' + id + \'}</dt><dd>{\' + id + \'_value} {\' + id + \'_unit} {\' + id + \'_tips} {\' + id + \'_description}</dd>\r\n\';
} else {
s3 = obj.parentNode.id == \'ttype\' ? \'<dt>{\' + id + \'}:</dt><dd>{\' + id + \'_value} {\' + id + \'_unit}</dd>\r\n\' : \'<p><em>{\' + id + \'}:</em>{\' + id + \'_value} {\' + id + \'_unit}</p>\r\n\';
}
} else {
for(i = 0;i < tips.length;i++) {
var i0 = tips[i].substr(0, tips[i].indexOf(\'/\'));
var i1 = tips[i].substr(tips[i].indexOf(\'/\') + 1);
if(i0) {
s1 += \'<td>{\' + i0 + \'}</td>\';
}
s2 += \'<td>\' + i1 + \'</td>\';
}
if($(id + \'_sample\')) {
s3 = $(id + \'_sample\').innerHTML;
}
}
$(tipid).innerHTML = \'<table class="tb tb2">\' +
(s1 ? \'<tr><td class="bold" width="50">'.$lang['threadtype_template_tag'].'</td>\' + s1 + \'</tr>\' : \'\') +
\'<tr><td class="bold" width="50">'.$lang['threadtype_template_intro'].'</td>\' + s2 + \'</tr></table>\';
if(s3) {
$(tipid).innerHTML += \'<table class="tb tb2"><tr><td class="bold" width="50">'.$lang['threadtype_template_example'].'</td><td colspan="6"><textarea style="width: 95%;" rows="2" readonly onclick="this.select()" id="\' + obj.parentNode.id + \'_sample">\' + s3 + \'</textarea></td></tr></table>\';
}
}
</script>';
} else {
C::t('forum_threadtype')->update($_GET['sortid'], array(
'special' => 1,
'template' => $_GET['typetemplate'],
'stemplate' => $_GET['stypetemplate'],
'ptemplate' => $_GET['ptypetemplate'],
'btemplate' => $_GET['btypetemplate'],
'expiration' => $_GET['typeexpiration'],
));
updatecache('threadsorts');
cpmsg('threadtype_infotypes_succeed', 'action=threadtypes&operation=sorttemplate&sortid='.$_GET['sortid'], 'succeed');
}
} elseif($operation == 'content') {
if(!submitcheck('searchsortsubmit', 1) && !submitcheck('delsortsubmit') && !submitcheck('sendpmsubmit')) {
shownav('forum', 'threadtype_infotypes');
showsubmenu('threadtype_infotypes', array(
array('threadtype_infotypes_type', 'threadtypes', 0),
array('threadtype_infotypes_content', 'threadtypes&operation=content', 1),
array(array('menu' => ($curclassname ? $curclassname : 'threadtype_infotypes_option'), 'submenu' => $classoptionmenu))
));
$_GET['sortid'] = intval($_GET['sortid']);
$threadtypes = '<select name="sortid" onchange="window.location.href = \'?action=threadtypes&operation=content&sortid=\'+ this.options[this.selectedIndex].value"><option value="0">'.cplang('none').'</option>';
$query = C::t('forum_threadtype')->fetch_all_for_order();
foreach($query as $type) {
$threadtypes .= '<option value="'.$type['typeid'].'" '.($_GET['sortid'] == $type['typeid'] ? 'selected="selected"' : '').'>'.dhtmlspecialchars($type['name']).'</option>';
}
$threadtypes .= '</select>';
showformheader('threadtypes&operation=content');
showtableheader('threadtype_content_choose');
showsetting('threadtype_content_name', '', '', $threadtypes);
if($_GET['sortid']) {
showtableheader('threadtype_content_sort_by_conditions');
loadcache(array('threadsort_option_'.$_GET['sortid']));
$sortoptionarray = $_G['cache']['threadsort_option_'.$_GET['sortid']];
if(is_array($sortoptionarray)) foreach($sortoptionarray as $optionid => $option) {
$optionshow = '';
if($option['search']) {
if(in_array($option['type'], array('radio', 'checkbox', 'select'))){
if($option['type'] == 'select') {
$optionshow .= '<select name="searchoption['.$optionid.'][value]"><option value="0">'.cplang('unlimited').'</option>';
foreach($option['choices'] as $id => $value) {
$optionshow .= '<option value="'.$id.'" '.($_GET['searchoption'][$optionid]['value'] == $id ? 'selected="selected"' : '').'>'.$value.'</option>';
}
$optionshow .= '</select><input type="hidden" name="searchoption['.$optionid.'][type]" value="select">';
} elseif($option['type'] == 'radio') {
$optionshow .= '<input type="radio" class="radio" name="searchoption['.$optionid.'][value]" value="0" checked="checked"]>'.cplang('unlimited').' ';
foreach($option['choices'] as $id => $value) {
$optionshow .= '<input type="radio" class="radio" name="searchoption['.$optionid.'][value]" value="'.$id.'" '.($_GET['searchoption'][$optionid]['value'] == $id ? 'checked="checked"' : '').'> '.$value.' ';
}
$optionshow .= '<input type="hidden" name="searchoption['.$optionid.'][type]" value="radio">';
} elseif($option['type'] == 'checkbox') {
foreach($option['choices'] as $id => $value) {
$optionshow .= '<input type="checkbox" class="checkbox" name="searchoption['.$optionid.'][value]['.$id.']" value="'.$id.'" '.($_GET['searchoption'][$optionid]['value'] == $id ? 'checked="checked"' : '').'> '.$value.'';
}
$optionshow .= '<input type="hidden" name="searchoption['.$optionid.'][type]" value="checkbox">';
}
} elseif(in_array($option['type'], array('number', 'text', 'email', 'calendar', 'image', 'url', 'textarea', 'upload', 'range'))) {
if ($option['type'] == 'calendar') {
$optionshow .= '<script type="text/javascript" src="'.$_G['setting']['jspath'].'calendar.js?'.VERHASH.'"></script><input type="text" name="searchoption['.$optionid.'][value]" class="txt" value="'.$_GET['searchoption'][$optionid]['value'].'" onclick="showcalendar(event, this, false)" />';
} elseif($option['type'] == 'number') {
$optionshow .= '<select name="searchoption['.$optionid.'][condition]">
<option value="0" '.($_GET['searchoption'][$optionid]['condition'] == 0 ? 'selected="selected"' : '').'>'.cplang('equal_to').'</option>
<option value="1" '.($_GET['searchoption'][$optionid]['condition'] == 1 ? 'selected="selected"' : '').'>'.cplang('more_than').'</option>
<option value="2" '.($_GET['searchoption'][$optionid]['condition'] == 2 ? 'selected="selected"' : '').'>'.cplang('lower_than').'</option>
</select>
<input type="text" class="txt" name="searchoption['.$optionid.'][value]" value="'.$_GET['searchoption'][$optionid]['value'].'" />
<input type="hidden" name="searchoption['.$optionid.'][type]" value="number">';
} elseif($option['type'] == 'range') {
$optionshow .= '<input type="text" name="searchoption['.$optionid.'][value][min]" size="16" value="'.$_GET['searchoption'][$optionid]['value']['min'].'" /> -
<input type="text" name="searchoption['.$optionid.'][value][max]" size="16" value="'.$_GET['searchoption'][$optionid]['value']['max'].'" />
<input type="hidden" name="searchoption['.$optionid.'][type]" value="range">';
} else {
$optionshow .= '<input type="text" name="searchoption['.$optionid.'][value]" class="txt" value="'.$_GET['searchoption'][$optionid]['value'].'" />';
}
}
$optionshow .= ' '.$option['unit'];
showsetting($option['title'], '', '', $optionshow);
}
}
}
showsubmit('searchsortsubmit', 'submit');
showtablefooter();
showformfooter();
} else {
if(submitcheck('searchsortsubmit', 1)) {
if(empty($_GET['searchoption']) && !$_GET['sortid']) {
cpmsg('threadtype_content_no_choice', 'action=threadtypes&operation=content', 'error');
}
$mpurl = ADMINSCRIPT.'?action=threadtypes&operation=content&sortid='.$_GET['sortid'].'&searchsortsubmit=true';
if(!is_array($_GET['searchoption'])) {
$mpurl .= '&searchoption='.$_GET['searchoption'];
$_GET['searchoption'] = dunserialize(base64_decode($_GET['searchoption']));
} else {
$mpurl .= '&searchoption='.base64_encode(serialize($_GET['searchoption']));
}
shownav('forum', 'threadtype_infotypes');
showsubmenu('threadtype_infotypes', array(
array('threadtype_infotypes_type', 'threadtypes', 0),
array('threadtype_infotypes_content', 'threadtypes&operation=content', 1),
array(array('menu' => ($curclassname ? $curclassname : 'threadtype_infotypes_option'), 'submenu' => $classoptionmenu))
));
loadcache('forums');
loadcache(array('threadsort_option_'.$_GET['sortid']));
require_once libfile('function/threadsort');
sortthreadsortselectoption($_GET['sortid']);
$sortoptionarray = $_G['cache']['threadsort_option_'.$_GET['sortid']];
$selectsql = '';
if($_GET['searchoption']) {
foreach($_GET['searchoption'] as $optionid => $option) {
$fieldname = $sortoptionarray[$optionid]['identifier'] ? $sortoptionarray[$optionid]['identifier'] : 1;
if($option['value']) {
if(in_array($option['type'], array('number', 'radio'))) {
$option['value'] = intval($option['value']);
$exp = '=';
if($option['condition']) {
$exp = $option['condition'] == 1 ? '>' : '<';
}
$sql = "$fieldname$exp'$option[value]'";
} elseif($option['type'] == 'select') {
$subvalues = $currentchoices = array();
if(!empty($sortoptionarray)) {
foreach($sortoptionarray as $subkey => $subvalue) {
if($subvalue['identifier'] == $fieldname) {
$currentchoices = $subvalue['choices'];
break;
}
}
}
if(!empty($currentchoices)) {
foreach($currentchoices as $subkey => $subvalue) {
if(preg_match('/^'.$option['value'].'/i', $subkey)) {
$subvalues[] = $subkey;
}
}
}
$sql = "$fieldname IN (".dimplode($subvalues).")";
} elseif($option['type'] == 'checkbox') {
$sql = "$fieldname LIKE '%".(implode("%", $option['value']))."%'";
} elseif($option['type'] == 'range') {
$sql = $option['value']['min'] || $option['value']['max'] ? "$fieldname BETWEEN ".intval($option['value']['min'])." AND ".intval($option['value']['max'])."" : '';
} else {
$sql = "$fieldname LIKE '%$option[value]%'";
}
$selectsql .= $and."$sql ";
$and = 'AND ';
}
}
$selectsql = trim($selectsql);
$searchtids = C::t('forum_optionvalue')->fetch_all_tid($_GET['sortid'], $selectsql ? 'WHERE '.$selectsql : '');
}
if($searchtids) {
$lpp = max(5, empty($_GET['lpp']) ? 50 : intval($_GET['lpp']));
$start_limit = ($page - 1) * $lpp;
$threadcount = C::t('forum_thread')->count_by_tid_fid($searchtids);
if($threadcount) {
foreach(C::t('forum_thread')->fetch_all_by_tid($searchtids, $start_limit, $lpp) as $thread) {
$threads .= showtablerow('', array('class="td25"', '', '', 'class="td28"', 'class="td28"'), array(
"<input class=\"checkbox\" type=\"checkbox\" name=\"tidsarray[]\" value=\"$thread[tid]\"/>".
"<input type=\"hidden\" name=\"fidsarray[]\" value=\"$thread[fid]\"/>",
"<a href=\"forum.php?mod=viewthread&tid=$thread[tid]\" target=\"_blank\">$thread[subject]</a>",
"<a href=\"forum.php?mod=forumdisplay&fid=$thread[fid]\" target=\"_blank\">{$_G['cache'][forums][$thread[fid]][name]}</a>",
"<a href=\"home.php?mod=space&uid=$thread[authorid]\" target=\"_blank\">$thread[author]</a>",
$thread['replies'],
$thread['views'],
dgmdate($thread['lastpost'], 'd'),
), TRUE);
}
$multipage = multi($threadcount, $lpp, $page, $mpurl, 0, 3);
}
}
showformheader('threadtypes&operation=content');
showtableheader('admin', 'fixpadding');
showsubtitle(array('', 'subject', 'forum', 'author', 'threads_replies', 'threads_views', 'threads_lastpost'));
echo $threads;
echo $multipage;
showsubmit('', '', '', "<input type=\"submit\" class=\"btn\" name=\"delsortsubmit\" value=\"{$lang[threadtype_content_delete]}\"/>");
showtablefooter();
showformfooter();
} elseif(submitcheck('delsortsubmit')) {
require_once libfile('function/post');
if($_GET['tidsarray']) {
require_once libfile('function/delete');
deletethread($_GET['tidsarray']);
if($_G['setting']['globalstick']) {
updatecache('globalstick');
}
if($_GET['fidsarray']) {
foreach(explode(',', $_GET['fidsarray']) as $fid) {
updateforumcount(intval($fid));
}
}
}
cpmsg('threadtype_content_delete_succeed', 'action=threadtypes&operation=content', 'succeed');
}
}
} elseif($operation == 'classlist') {
$classoptions = '';
$classidarray = array();
$classid = $_GET['classid'] ? $_GET['classid'] : 0;
foreach(C::t('forum_typeoption')->fetch_all_by_classid($classid) as $option) {
$classidarray[] = $option['optionid'];
$classoptions .= "<a href=\"#ol\" onclick=\"ajaxget('".ADMINSCRIPT."?action=threadtypes&operation=optionlist&typeid={$_GET['typeid']}&classid=$option[optionid]', 'optionlist', 'optionlist', 'Loading...', '', checkedbox)\">$option[title]</a> ";
}
include template('common/header');
echo $classoptions;
include template('common/footer');
exit;
} elseif($operation == 'optionlist') {
$classid = $_GET['classid'];
if(!$classid) {
$classid = C::t('forum_typeoption')->fetch_all_by_classid(0, 0, 1);
$classid = $classid[0]['optionid'];
}
$option = $options = array();
foreach(C::t('forum_typevar')->fetch_all_by_sortid($_GET['typeid']) as $option) {
$options[] = $option['optionid'];
}
$optionlist = '';
foreach(C::t('forum_typeoption')->fetch_all_by_classid($classid) as $option) {
$optionlist .= "<input ".(in_array($option['optionid'], $options) ? ' checked="checked" ' : '')."class=\"checkbox\" type=\"checkbox\" name=\"typeselect[]\" id=\"typeselect_$option[optionid]\" value=\"$option[optionid]\" onclick=\"insertoption(this.value);\" /><label for=\"typeselect_$option[optionid]\">".dhtmlspecialchars($option['title'])."</label> ";
}
include template('common/header');
echo $optionlist;
include template('common/footer');
exit;
} elseif($operation == 'sortlist') {
$optionid = $_GET['optionid'];
$option = C::t('forum_typeoption')->fetch($optionid);
include template('common/header');
$option['type'] = $lang['threadtype_edit_vars_type_'. $option['type']];
$option['available'] = 1;
showtablerow('', array('class="td25"', 'class="td28 td23"'), array(
"<input class=\"checkbox\" type=\"checkbox\" name=\"delete[]\" value=\"$option[optionid]\" ".($option['model'] ? 'disabled' : '').">",
"<input type=\"text\" class=\"txt\" size=\"2\" name=\"displayorder[$option[optionid]]\" value=\"$option[displayorder]\">",
"<input class=\"checkbox\" type=\"checkbox\" name=\"available[$option[optionid]]\" value=\"1\" ".($option['available'] ? 'checked' : '')." ".($option['model'] ? 'disabled' : '').">",
dhtmlspecialchars($option['title']),
$option[type],
"<input class=\"checkbox\" type=\"checkbox\" name=\"required[$option[optionid]]\" value=\"1\" ".($option['required'] ? 'checked' : '')." ".($option['model'] ? 'disabled' : '').">",
"<input class=\"checkbox\" type=\"checkbox\" name=\"unchangeable[$option[optionid]]\" value=\"1\" ".($option['unchangeable'] ? 'checked' : '').">",
"<input class=\"checkbox\" type=\"checkbox\" name=\"search[$option[optionid]][form]\" value=\"1\" ".(getstatus($option['search'], 1) == 1 ? 'checked' : '').">",
"<input class=\"checkbox\" type=\"checkbox\" name=\"search[$option[optionid]][font]\" value=\"1\" ".(getstatus($option['search'], 2) == 1 ? 'checked' : '').">",
"<input class=\"checkbox\" type=\"checkbox\" name=\"subjectshow[$option[optionid]]\" value=\"1\" ".($option['subjectshow'] ? 'checked' : '').">",
"<a href=\"".ADMINSCRIPT."?action=threadtypes&operation=optiondetail&optionid=$option[optionid]\" class=\"act\">".$lang['edit']."</a>"
));
include template('common/footer');
exit;
} elseif($operation == 'import') {
$sortid = 0;
$newthreadtype = getimportdata('Discuz! Threadtypes');
if($newthreadtype) {
$idcmp = $searcharr = $replacearr = $indexoption = array();
$create_tableoption_sql = $separator = '';
$i = 0;
foreach($newthreadtype as $key => $value) {
if(!$i) {
if($newname1 = trim(strip_tags($value['name']))) {
$findname = 0;
$tmpnewname1 = $newname1;
$decline = '_';
while(!$findname) {
if(C::t('forum_threadtype')->checkname($tmpnewname1)) {
$tmpnewname1 = $newname1.$decline;
$decline .= '_';
} else {
$findname = 1;
}
}
$newname1 = $tmpnewname1;
$data = array(
'name' => $newname1,
'description' => dhtmlspecialchars(trim($value['ttdescription'])),
'special' => 1,
);
$sortid = C::t('forum_threadtype')->insert($data, 1);
}
$i = 1;
if(empty($value['identifier'])) {
cpmsg('threadtype_import_succeed', 'action=threadtypes', 'succeed');
}
}
$typeoption = array(
'classid' => $value['classid'],
'expiration' => $value['tpexpiration'],
'protect' => $value['protect'],
'title' => $value['title'],
'description' => $value['tpdescription'],
'type' => $value['type'],
'unit' => $value['unit'],
'rules' => $value['rules'],
'permprompt' => $value['permprompt'],
);
if(strlen($value['identifier']) > 34) {
cpmsg('threadtype_infotypes_optionvariable_invalid', 'action=threadtypes', 'error');
}
$findidentifier = 0;
$tmpidentifier = $value['identifier'];
$decline = '_';
while(!$findidentifier) {
if(C::t('forum_typeoption')->fetch_all_by_identifier($tmpidentifier, 0, 1) || !ispluginkey($tmpidentifier) || in_array(strtoupper($tmpidentifier), $mysql_keywords)) {
$tmpidentifier = $value['identifier'].$decline.$sortid;
$decline .= '_';
} else {
$findidentifier = 1;
}
}
$typeoption['identifier'] = $tmpidentifier;
$idcmp[$value['identifier']] = $tmpidentifier;
$newoptionid = C::t('forum_typeoption')->insert($typeoption, true);
$typevar = array(
'sortid' => $sortid,
'optionid' => $newoptionid,
'available' => $value['available'],
'required' => $value['required'],
'unchangeable' => $value['unchangeable'],
'search' => $value['search'],
'displayorder' => $value['displayorder'],
'subjectshow' => $value['subjectshow'],
);
C::t('forum_typevar')->insert($typevar);
if($tmpidentifier) {
if(in_array($value['type'], array('radio'))) {
$create_tableoption_sql .= "$separator$tmpidentifier smallint(6) UNSIGNED NOT NULL DEFAULT '0'";
} elseif(in_array($value['type'], array('number', 'range'))) {
$create_tableoption_sql .= "$separator$tmpidentifier int(10) UNSIGNED NOT NULL DEFAULT '0'";
} elseif($value['type'] == 'select') {
$create_tableoption_sql .= "$separator$tmpidentifier varchar(50) NOT NULL";
} else {
$create_tableoption_sql .= "$separator$tmpidentifier mediumtext NOT NULL";
}
$separator = ' ,';
if(in_array($value['type'], array('radio', 'select', 'number'))) {
$indexoption[] = $tmpidentifier;
}
}
}
foreach($idcmp as $k => $v) {
if($k != $v) {
$searcharr[] = '{'.$k;
$searcharr[] = '['.$k;
$replacearr[] = '{'.$v;
$replacearr[] = '['.$v;
}
}
$threadtype = array(
'icon' => $value['icon'],
'special' => $value['special'],
'modelid' => $value['modelid'],
'expiration' => $value['ttexpiration'],
'template' => str_replace($searcharr, $replacearr, $value['template']),
'stemplate' => str_replace($searcharr, $replacearr, $value['stemplate']),
'ptemplate' => str_replace($searcharr, $replacearr, $value['ptemplate']),
'btemplate' => str_replace($searcharr, $replacearr, $value['btemplate']),
);
DB::update('forum_threadtype', $threadtype, array('typeid' => $sortid));
$fields = ($create_tableoption_sql ? $create_tableoption_sql.',' : '')."tid mediumint(8) UNSIGNED NOT NULL DEFAULT '0',fid smallint(6) UNSIGNED NOT NULL DEFAULT '0',dateline int(10) UNSIGNED NOT NULL DEFAULT '0',expiration int(10) UNSIGNED NOT NULL DEFAULT '0',";
$fields .= "KEY (fid), KEY(dateline)";
if($indexoption) {
foreach($indexoption as $index) {
$fields .= "$separator KEY $index ($index)";
$separator = ' ,';
}
}
$dbcharset = $_G['config']['db'][1]['dbcharset'];
$dbcharset = empty($dbcharset) ? str_replace('-','',CHARSET) : $dbcharset;
C::t('forum_optionvalue')->create($sortid, $fields, $dbcharset);
updatecache('threadsorts');
}
cpmsg('threadtype_import_succeed', 'action=threadtypes', 'succeed');
} elseif($operation == 'export') {
$sortid = intval($_GET['sortid']);
$typevarlist = array();
$typevararr = C::t('forum_typevar')->fetch_all_by_sortid($sortid);
$typeoptionarr = C::t('forum_typeoption')->fetch_all(array_keys($typevararr));
$threadtypearr = C::t('forum_threadtype')->fetch($sortid);
foreach($typevararr as $typevar) {
$typeoption = $typeoptionarr[$typevar['optionid']];
$typevar = array_merge($threadtypearr, $typevar);
$typevar = array_merge($typeoption, $typevar);
$typevar['tpdescription'] = $typeoption['description'];
$typevar['ttdescription'] = $threadtypearr['description'];
$typevar['tpexpiration'] = $typeoption['expiration'];
$typevar['ttexpiration'] = $threadtypearr['expiration'];
unset($typevar['fid']);
$typevarlist[] = $typevar;
}
if(empty($typevarlist)) {
$threadtype = C::t('forum_threadtype')->fetch($sortid);
$threadtype['ttdescription'] = $threadtype['description'];
unset($threadtype['fid']);
$typevarlist[] = $threadtype;
}
if(empty($typevarlist)) {
cpmsg('threadtype_export_error');
}
exportdata('Discuz! Threadtypes', $typevarlist[0]['typeid'], $typevarlist);
}
?>