{1}', 'X[sup]2[/sup]', '上标', 1, '请输入上标文字：', '1');
INSERT INTO cdb_bbcodes VALUES ({bbcodeid,2}, '0', 'sub', 'bb_sub.gif', '{1}', 'X[sub]2[/sub]', '下标', 1, '请输入下标文字：', '1');
INSERT INTO cdb_templates (templateid, name, directory, copyright) VALUES ({templateid,1}, '喝彩奥运', './templates/Beijing2008', '康盛创想（北京）科技有限公司');
INSERT INTO cdb_templates (templateid, name, directory, copyright) VALUES ({templateid,2}, '深邃永恒', './templates/Overcast', '康盛创想（北京）科技有限公司');
INSERT INTO cdb_templates (templateid, name, directory, copyright) VALUES ({templateid,3}, '粉妆精灵', './templates/PinkDresser', '康盛创想（北京）科技有限公司');
INSERT INTO cdb_styles (styleid, name, available, templateid) VALUES ({styleid,1}, '喝彩奥运', 1, {templateid,1});
INSERT INTO cdb_stylevars (styleid, variable, substitute) VALUES
({styleid,1}, 'available', ''),
({styleid,1}, 'bgcolor', '#FFF'),
({styleid,1}, 'altbg1', '#FFF'),
({styleid,1}, 'altbg2', '#F7F7F3'),
({styleid,1}, 'link', '#262626'),
({styleid,1}, 'bordercolor', '#C1C1C1'),
({styleid,1}, 'headercolor', '#FFF forumbox_head.gif'),
({styleid,1}, 'headertext', '#D00'),
({styleid,1}, 'catcolor', '#F90 cat_bg.gif'),
({styleid,1}, 'tabletext', '#535353'),
({styleid,1}, 'text', '#535353'),
({styleid,1}, 'borderwidth', '1px'),
({styleid,1}, 'tablespace', '1px'),
({styleid,1}, 'fontsize', '12px'),
({styleid,1}, 'msgfontsize', '14px'),
({styleid,1}, 'msgbigsize', '16px'),
({styleid,1}, 'msgsmallsize', '12px'),
({styleid,1}, 'font', 'Arial,Helvetica,sans-serif'),
({styleid,1}, 'smfontsize', '11px'),
({styleid,1}, 'smfont', 'Arial,Helvetica,sans-serif'),
({styleid,1}, 'boardimg', 'logo.gif'),
({styleid,1}, 'imgdir', './images/Beijing2008'),
({styleid,1}, 'maintablewidth', '98%'),
({styleid,1}, 'bgborder', '#C1C1C1'),
({styleid,1}, 'catborder', '#E2E2E2'),
({styleid,1}, 'inputborder', '#D7D7D7'),
({styleid,1}, 'lighttext', '#535353'),
({styleid,1}, 'headermenu', '#FFF menu_bg.gif'),
({styleid,1}, 'headermenutext', '#54564C'),
({styleid,1}, 'framebgcolor', ''),
({styleid,1}, 'noticebg', ''),
({styleid,1}, 'commonboxborder', '#F0F0ED'),
({styleid,1}, 'tablebg', '#FFF'),
({styleid,1}, 'highlightlink', '#535353'),
({styleid,1}, 'commonboxbg', '#F5F5F0'),
({styleid,1}, 'boxspace', '8px'),
({styleid,1}, 'portalboxbgcode', '#FFF portalbox_bg.gif'),
({styleid,1}, 'noticeborder', ''),
({styleid,1}, 'noticetext', '#DD0000'),
({styleid,1}, 'stypeid', '1');
INSERT INTO cdb_styles (styleid, name, available, templateid) VALUES ({styleid,2}, '深邃永恒', 1, {templateid,2});
INSERT INTO cdb_stylevars (styleid, variable, substitute) VALUES
({styleid,2}, 'available', ''),
({styleid,2}, 'bgcolor', '#222D2D'),
({styleid,2}, 'altbg1', '#3E4F4F'),
({styleid,2}, 'altbg2', '#384747'),
({styleid,2}, 'link', '#CEEBEB'),
({styleid,2}, 'bordercolor', '#1B2424'),
({styleid,2}, 'headercolor', '#1B2424'),
({styleid,2}, 'headertext', '#94B3C5'),
({styleid,2}, 'catcolor', '#293838'),
({styleid,2}, 'tabletext', '#CEEBEB'),
({styleid,2}, 'text', '#999'),
({styleid,2}, 'borderwidth', '6px'),
({styleid,2}, 'tablespace', '0'),
({styleid,2}, 'fontsize', '12px'),
({styleid,2}, 'msgfontsize', '14px'),
({styleid,2}, 'msgbigsize', '16px'),
({styleid,2}, 'msgsmallsize', '12px'),
({styleid,2}, 'font', 'Arial'),
({styleid,2}, 'smfontsize', '11px'),
({styleid,2}, 'smfont', 'Arial,sans-serif'),
({styleid,2}, 'boardimg', 'logo.gif'),
({styleid,2}, 'imgdir', './images/Overcast'),
({styleid,2}, 'maintablewidth', '98%'),
({styleid,2}, 'bgborder', '#384747'),
({styleid,2}, 'catborder', '#1B2424'),
({styleid,2}, 'inputborder', '#EEE'),
({styleid,2}, 'lighttext', '#74898E'),
({styleid,2}, 'headermenu', '#3E4F4F'),
({styleid,2}, 'headermenutext', '#CEEBEB'),
({styleid,2}, 'framebgcolor', '#222D2D'),
({styleid,2}, 'noticebg', '#3E4F4F'),
({styleid,2}, 'commonboxborder', '#384747'),
({styleid,2}, 'tablebg', '#3E4F4F'),
({styleid,2}, 'highlightlink', '#9CB2A0'),
({styleid,2}, 'commonboxbg', '#384747'),
({styleid,2}, 'boxspace', '6px'),
({styleid,2}, 'portalboxbgcode', '#293838'),
({styleid,2}, 'noticeborder', '#384747'),
({styleid,2}, 'noticetext', '#C7E001'),
({styleid,2}, 'stypeid', '1');
INSERT INTO cdb_styles (styleid, name, available, templateid) VALUES ({styleid,3}, '粉妆精灵', 1, {templateid,3});
INSERT INTO cdb_stylevars (styleid, variable, substitute) VALUES
({styleid,3}, 'noticetext', '#C44D4D'),
({styleid,3}, 'noticeborder', '#D6D6D6'),
({styleid,3}, 'portalboxbgcode', '#FFF portalbox_bg.gif'),
({styleid,3}, 'boxspace', '6px'),
({styleid,3}, 'commonboxbg', '#FAFAFA'),
({styleid,3}, 'highlightlink', '#C44D4D'),
({styleid,3}, 'tablebg', '#FFF'),
({styleid,3}, 'commonboxborder', '#DEDEDE'),
({styleid,3}, 'noticebg', '#FAFAFA'),
({styleid,3}, 'framebgcolor', '#FFECF9'),
({styleid,3}, 'headermenu', 'transparent'),
({styleid,3}, 'headermenutext', ''),
({styleid,3}, 'lighttext', '#999'),
({styleid,3}, 'catborder', '#D7D7D7'),
({styleid,3}, 'inputborder', ''),
({styleid,3}, 'bgborder', '#CECECE'),
({styleid,3}, 'stypeid', '1'),
({styleid,3}, 'maintablewidth', '920px'),
({styleid,3}, 'imgdir', 'images/PinkDresser'),
({styleid,3}, 'boardimg', 'logo.gif'),
({styleid,3}, 'smfont', 'Arial,Helvetica,sans-serif'),
({styleid,3}, 'smfontsize', '12px'),
({styleid,3}, 'font', 'Arial,Helvetica,sans-serif'),
({styleid,3}, 'msgsmallsize', '12px'),
({styleid,3}, 'msgbigsize', '16px'),
({styleid,3}, 'msgfontsize', '14px'),
({styleid,3}, 'fontsize', '12px'),
({styleid,3}, 'tablespace', '0'),
({styleid,3}, 'borderwidth', '1px'),
({styleid,3}, 'text', '#666'),
({styleid,3}, 'tabletext', '#666'),
({styleid,3}, 'catcolor', '#FAFAFA category_bg.gif'),
({styleid,3}, 'headertext', '#FFF'),
({styleid,3}, 'headercolor', '#E7BFC9 forumbox_head.gif'),
({styleid,3}, 'bordercolor', '#D88E9D'),
({styleid,3}, 'link', '#C44D4D'),
({styleid,3}, 'altbg2', '#F1F1F1'),
({styleid,3}, 'available', ''),
({styleid,3}, 'altbg1', '#FBFBFB'),
({styleid,3}, 'bgcolor', '#FBF4F5 bg.gif');
INSERT INTO cdb_styles (styleid, name, available, templateid) VALUES ({styleid,4}, '诗意田园', 1, 1);
INSERT INTO cdb_stylevars (styleid, variable, substitute) VALUES
({styleid,4}, 'available', ''),
({styleid,4}, 'bgcolor', '#FFF'),
({styleid,4}, 'altbg1', '#FFFBF8'),
({styleid,4}, 'altbg2', '#FBF6F1'),
({styleid,4}, 'link', '#54564C'),
({styleid,4}, 'bordercolor', '#D7B094'),
({styleid,4}, 'headercolor', '#BE6A2D forumbox_head.gif'),
({styleid,4}, 'headertext', '#FFF'),
({styleid,4}, 'catcolor', '#E9E9E9 cat_bg.gif'),
({styleid,4}, 'tabletext', '#7B7D72'),
({styleid,4}, 'text', '#535353'),
({styleid,4}, 'borderwidth', '1px'),
({styleid,4}, 'tablespace', '1px'),
({styleid,4}, 'fontsize', '12px'),
({styleid,4}, 'msgfontsize', '14px'),
({styleid,4}, 'msgbigsize', '16px'),
({styleid,4}, 'msgsmallsize', '12px'),
({styleid,4}, 'font', 'Arial, sans-serif'),
({styleid,4}, 'smfontsize', '11px'),
({styleid,4}, 'smfont', 'Arial, sans-serif'),
({styleid,4}, 'boardimg', 'logo.gif'),
({styleid,4}, 'imgdir', './images/Picnicker'),
({styleid,4}, 'maintablewidth', '98%'),
({styleid,4}, 'bgborder', '#E8C9B7'),
({styleid,4}, 'catborder', '#E6E6E2'),
({styleid,4}, 'inputborder', ''),
({styleid,4}, 'lighttext', '#878787'),
({styleid,4}, 'headermenu', '#FFF menu_bg.gif'),
({styleid,4}, 'headermenutext', '#54564C'),
({styleid,4}, 'framebgcolor', 'frame_bg.gif'),
({styleid,4}, 'noticebg', '#FAFAF7'),
({styleid,4}, 'commonboxborder', '#E6E6E2'),
({styleid,4}, 'tablebg', '#FFF'),
({styleid,4}, 'highlightlink', ''),
({styleid,4}, 'commonboxbg', '#F5F5F0'),
({styleid,4}, 'boxspace', '6px'),
({styleid,4}, 'portalboxbgcode', '#FFF portalbox_bg.gif'),
({styleid,4}, 'noticeborder', '#E6E6E2'),
({styleid,4}, 'noticetext', '#FF3A00'),
({styleid,4}, 'stypeid', '1');
INSERT INTO cdb_styles (styleid, name, available, templateid) VALUES ({styleid,5}, '春意盎然', 1, 1);
INSERT INTO cdb_stylevars (styleid, variable, substitute) VALUES
({styleid,5}, 'available', ''),
({styleid,5}, 'bgcolor', '#FFF'),
({styleid,5}, 'altbg1', '#F5F5F0'),
({styleid,5}, 'altbg2', '#F9F9F9'),
({styleid,5}, 'link', '#54564C'),
({styleid,5}, 'bordercolor', '#D9D9D4'),
({styleid,5}, 'headercolor', '#80A400 forumbox_head.gif'),
({styleid,5}, 'headertext', '#FFF'),
({styleid,5}, 'catcolor', '#F5F5F0 cat_bg.gif'),
({styleid,5}, 'tabletext', '#7B7D72'),
({styleid,5}, 'text', '#535353'),
({styleid,5}, 'borderwidth', '1px'),
({styleid,5}, 'tablespace', '1px'),
({styleid,5}, 'fontsize', '12px'),
({styleid,5}, 'msgfontsize', '14px'),
({styleid,5}, 'msgbigsize', '16px'),
({styleid,5}, 'msgsmallsize', '12px'),
({styleid,5}, 'font', 'Arial,sans-serif'),
({styleid,5}, 'smfontsize', '11px'),
({styleid,5}, 'smfont', 'Arial,sans-serif'),
({styleid,5}, 'boardimg', 'logo.gif'),
({styleid,5}, 'imgdir', './images/GreenPark'),
({styleid,5}, 'maintablewidth', '98%'),
({styleid,5}, 'bgborder', '#D9D9D4'),
({styleid,5}, 'catborder', '#D9D9D4'),
({styleid,5}, 'inputborder', '#D9D9D4'),
({styleid,5}, 'lighttext', '#878787'),
({styleid,5}, 'headermenu', '#FFF menu_bg.gif'),
({styleid,5}, 'headermenutext', '#262626'),
({styleid,5}, 'framebgcolor', ''),
({styleid,5}, 'noticebg', '#FAFAF7'),
({styleid,5}, 'commonboxborder', '#E6E6E2'),
({styleid,5}, 'tablebg', '#FFF'),
({styleid,5}, 'highlightlink', '#535353'),
({styleid,5}, 'commonboxbg', '#F9F9F9'),
({styleid,5}, 'boxspace', '6px'),
({styleid,5}, 'portalboxbgcode', '#FFF portalbox_bg.gif'),
({styleid,5}, 'noticeborder', '#E6E6E2'),
({styleid,5}, 'noticetext', '#FF3A00'),
({styleid,5}, 'stypeid', '1');
EOT;
$insenz_upgrade = << '论坛升级第 1 步: 增加基本设置
',
2 => '论坛升级第 2 步: 调整论坛数据表结构
',
3 => '论坛升级第 3 步: 新增数据表
',
4 => '论坛升级第 4 步: 更新部分数据
',
5 => '论坛升级第 5 步: 升级邮件设置
',
6 => '论坛升级第 6 步: 升级电子商务设置
',
7 => '论坛升级第 7 步: 升级论坛风格
',
8 => '论坛升级第 8 步: Insenz相关数据升级
',
9 => '论坛升级第 9 步: 其他相关数据升级
',
10 => '论坛升级第 10 步: 升级全部完毕
',
);
$errormsg = '';
if(!isset($dbhost)) {
showerror("没有找到 config.inc.php 文件!
请确认您已经上传了所有 $version_new 文件");
} elseif(!isset($cookiepre)) {
showerror("config.inc.php 版本错误!
请上传 $version_new 的 config.inc.php，并调整好数据库设置然后重新进行升级");
} elseif(!$dblink = @mysql_connect($dbhost, $dbuser, $dbpw)) {
showerror("config.inc.php 配置错误!
请修改 config.inc.php 当中关于数据库的设置，然后上传到论坛目录，重新开始升级");
}
@mysql_close($dblink);
$db = new dbstuff;
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
if(!$action) {
if(!$tableinfo = loadtable('threads')) {
showerror("无法找到 Discuz! 论坛数据表!
请修改 config.inc.php 当中关于数据库的设置，然后上传到论坛目录，重新开始升级");
} elseif($db->version() > '4.1') {
$old_dbcharset = substr($tableinfo['subject']['Collation'], 0, strpos($tableinfo['subject']['Collation'], '_'));
if($old_dbcharset <> $dbcharset) {
showerror("config.inc.php 数据库字符集设置错误!
".
"原来的字符集设置为：$old_dbcharset".
"当前使用的字符集为：$dbcharset".
"建议：修改 config.inc.php， 将其中的 \$dbcharset = '' 或者 \$dbcharset = '$dbcharset' 修改为： \$dbcharset = '$old_dbcharset'".
"修改完毕后上传 config.inc.php，然后重新进行升级"
);
}
}
echo <<< EOT
升级前请打开浏览器 JavaScript 支持,整个过程是自动完成的,不需人工点击和干预.
升级之前务必备份数据库资料，否则升级失败无法恢复
正确的升级方法为:
- 关闭原有论坛,上传 $version_new 的全部文件和目录, 覆盖服务器上的 $version_old
- 上传升级程序到论坛目录中，重新配置好 config.inc.php
- 运行本程序,直到出现升级完成的提示
- 如果中途失败，请使用Discuz!工具箱（./utilities/tools.php）里面的数据恢复工具恢复备份, 去除错误后重新运行本程序
>> 如果您已确认完成上面的步骤,请点这里升级
EOT;
showfooter();
} else {
$step = intval($step);
echo '>>'.$upgrademsg[$step];
flush();
if($step == 1) {
dir_clear('./forumdata/cache');
dir_clear('./forumdata/templates');
runquery($upgrade1);
$authkey = substr(md5($_SERVER['SERVER_ADDR'].$_SERVER['HTTP_USER_AGENT'].$dbhost.$dbuser.$dbpw.$dbname.$username.$password.$pconnect.substr($timestamp, 0, 6)), 8, 6).random(10);
$chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz';
$siteuniqueid = $chars[date('y')%60].$chars[date('n')].$chars[date('j')].$chars[date('G')].$chars[date('i')].$chars[date('s')].substr(md5($onlineip.$timestamp), 0, 4).random(6);
$db->query("REPLACE INTO {$tablepre}settings (variable, value) VALUES ('authkey', '$authkey')");
$db->query("REPLACE INTO {$tablepre}settings (variable, value) VALUES ('siteuniqueid', '$siteuniqueid')");
echo "第 $step 步升级成功
";
redirect("?action=upgrade&step=".($step+1));
} elseif($step == 2) {
if(isset($upgradetable[$start]) && $upgradetable[$start][0]) {
echo "升级数据表 [ $start ] {$tablepre}{$upgradetable[$start][0]} {$upgradetable[$start][3]}:";
$successed = upgradetable($upgradetable[$start]);
if($successed === TRUE) {
echo ' OK
';
} elseif($successed === FALSE) {
//echo ' ERROR
';
} elseif($successed == 'TABLE NOT EXISTS') {
showerror('数据表不存在升级无法继续，请确认您的论坛版本是否正确!
');
}
}
$start ++;
if(isset($upgradetable[$start]) && $upgradetable[$start][0]) {
redirect("?action=upgrade&step=$step&start=$start");
}
echo "第 $step 步升级成功
";
redirect("?action=upgrade&step=".($step+1));
} elseif($step == 3) {
runquery($upgrade3);
$optionlist = array (
8 => array (
'classid' => '1',
'displayorder' => '2',
'title' => '性别',
'identifier' => 'gender',
'type' => 'radio',
'rules' => array (
'required' => '0',
'unchangeable' => '0',
'choices' => "1=男\r\n2=女",
),
),
16 => array (
'classid' => '2',
'displayorder' => '0',
'title' => '房屋类型',
'identifier' => 'property',
'type' => 'select',
'rules' => array (
'choices' => "1=写字楼\r\n2=公寓\r\n3=小区\r\n4=平房\r\n5=别墅\r\n6=地下室",
),
),
17 => array (
'classid' => '2',
'displayorder' => '0',
'title' => '座向',
'identifier' => 'face',
'type' => 'radio',
'rules' => array (
'required' => '0',
'unchangeable' => '0',
'choices' => "1=南向\r\n2=北向\r\n3=西向\r\n4=东向",
),
),
18 => array (
'classid' => '2',
'displayorder' => '0',
'title' => '装修情况',
'identifier' => 'makes',
'type' => 'radio',
'rules' => array (
'required' => '0',
'unchangeable' => '0',
'choices' => "1=无装修\r\n2=简单装修\r\n3=精装修",
),
),
19 => array (
'classid' => '2',
'displayorder' => '0',
'title' => '居室',
'identifier' => 'mode',
'type' => 'select',
'rules' => array (
'choices' => "1=独居\r\n2=两居室\r\n3=三居室\r\n4=四居室\r\n5=别墅",
),
),
23 => array (
'classid' => '2',
'displayorder' => '0',
'title' => '屋内设施',
'identifier' => 'equipment',
'type' => 'checkbox',
'rules' => array (
'required' => '0',
'unchangeable' => '0',
'choices' => "1=水电\r\n2=宽带\r\n3=管道气\r\n4=有线电视\r\n5=电梯\r\n6=电话\r\n7=冰箱\r\n8=洗衣机\r\n9=热水器\r\n10=空调\r\n11=暖气\r\n12=微波炉\r\n13=油烟机\r\n14=饮水机",
),
),
25 => array (
'classid' => '2',
'displayorder' => '0',
'title' => '是否中介',
'identifier' => 'bool',
'type' => 'radio',
'rules' => array (
'required' => '0',
'unchangeable' => '0',
'choices' => "1=是\r\n2=否",
),
),
27 => array (
'classid' => '3',
'displayorder' => '0',
'title' => '星座',
'identifier' => 'Horoscope',
'type' => 'select',
'rules' => array (
'choices' => "1=白羊座\r\n2=金牛座\r\n3=双子座\r\n4=巨蟹座\r\n5=狮子座\r\n6=处女座\r\n7=天秤座\r\n8=天蝎座\r\n9=射手座\r\n10=摩羯座\r\n11=水瓶座\r\n12=双鱼座",
),
),
30 => array (
'classid' => '3',
'displayorder' => '0',
'title' => '婚姻状况',
'identifier' => 'marrige',
'type' => 'radio',
'rules' => array (
'choices' => "1=已婚\r\n2=未婚",
),
),
31 => array (
'classid' => '3',
'displayorder' => '0',
'title' => '爱好',
'identifier' => 'hobby',
'type' => 'checkbox',
'rules' => array (
'choices' => "1=美食\r\n2=唱歌\r\n3=跳舞\r\n4=电影\r\n5=音乐\r\n6=戏剧\r\n7=聊天\r\n8=拍托\r\n9=电脑\r\n10=网络\r\n11=游戏\r\n12=绘画\r\n13=书法\r\n14=雕塑\r\n15=异性\r\n16=阅读\r\n17=运动\r\n18=旅游\r\n19=八卦\r\n20=购物\r\n21=赚钱\r\n22=汽车\r\n23=摄影",
),
),
32 => array (
'classid' => '3',
'displayorder' => '0',
'title' => '收入范围',
'identifier' => 'salary',
'type' => 'select',
'rules' => array (
'required' => '0',
'unchangeable' => '0',
'choices' => "1=保密\r\n2=800元以上\r\n3=1500元以上\r\n4=2000元以上\r\n5=3000元以上\r\n6=5000元以上\r\n7=8000元以上",
),
),
34 => array (
'classid' => '1',
'displayorder' => '0',
'title' => '学历',
'identifier' => 'education',
'type' => 'radio',
'rules' => array (
'required' => '0',
'unchangeable' => '0',
'choices' => "1=文盲\r\n2=小学\r\n3=初中\r\n4=高中\r\n5=中专\r\n6=大专\r\n7=本科\r\n8=研究生\r\n9=博士",
),
),
38 => array (
'classid' => '5',
'displayorder' => '0',
'title' => '席别',
'identifier' => 'seats',
'type' => 'select',
'rules' => array (
'choices' => "1=站票\r\n2=硬座\r\n3=软座\r\n4=硬卧\r\n5=软卧",
),
),
44 => array (
'classid' => '4',
'displayorder' => '0',
'title' => '是否应届',
'identifier' => 'recr_term',
'type' => 'radio',
'rules' => array (
'required' => '0',
'unchangeable' => '0',
'choices' => "1=应届\r\n2=非应届",
),
),
48 => array (
'classid' => '4',
'displayorder' => '0',
'title' => '薪金',
'identifier' => 'recr_salary',
'type' => 'select',
'rules' => array (
'choices' => "1=面议\r\n2=1000以下\r\n3=1000~1500\r\n4=1500~2000\r\n5=2000~3000\r\n6=3000~4000\r\n7=4000~6000\r\n8=6000~8000\r\n9=8000以上",
),
),
50 => array (
'classid' => '4',
'displayorder' => '0',
'title' => '工作性质',
'identifier' => 'recr_work',
'type' => 'radio',
'rules' => array (
'required' => '0',
'unchangeable' => '0',
'choices' => "1=全职\r\n2=兼职",
),
),
53 => array (
'classid' => '4',
'displayorder' => '0',
'title' => '性别要求',
'identifier' => 'recr_sex',
'type' => 'checkbox',
'rules' => array (
'required' => '0',
'unchangeable' => '0',
'choices' => "1=男\r\n2=女",
),
),
62 => array (
'classid' => '5',
'displayorder' => '0',
'title' => '付款方式',
'identifier' => 'pay_type',
'type' => 'checkbox',
'rules' => array (
'required' => '0',
'unchangeable' => '0',
'choices' => "1=电汇\r\n2=支付宝\r\n3=现金\r\n4=其他",
),
),
);
foreach($optionlist as $optionid => $option) {
$db->query("REPLACE INTO {$tablepre}typeoptions VALUES ('$optionid', '$option[classid]', '$option[displayorder]', '$option[title]', '', '$option[identifier]', '$option[type]', '".addslashes(serialize($option['rules']))."');");
}
$db->query("ALTER TABLE {$tablepre}typeoptions AUTO_INCREMENT=3001");
echo "第 $step 步升级成功
";
redirect("?action=upgrade&step=".($step+1));
} elseif($step == 4) {
runquery($upgrade4);
echo "第 $step 步升级成功
";
redirect("?action=upgrade&step=".($step+1));
} elseif($step == 5) {
echo "第 $step 步升级成功
";
redirect("?action=upgrade&step=".($step+1));
} elseif($step == 6) {
echo "第 $step 步升级成功
";
redirect("?action=upgrade&step=".($step+1));
} elseif($step == 7) {
$lastid = $db->result($db->query("SELECT id FROM {$tablepre}bbcodes ORDER BY id DESC"), 0);
$upgrade7 = preg_replace('/\{bbcodeid,(\d)\}/e', "\$lastid + \\1", $upgrade7);
$lastid = $db->result($db->query("SELECT templateid FROM {$tablepre}templates ORDER BY templateid DESC"), 0);
$upgrade7 = preg_replace('/\{templateid,(\d)\}/e', "\$lastid + \\1", $upgrade7);
$lastid = $db->result($db->query("SELECT styleid FROM {$tablepre}styles ORDER BY styleid DESC"), 0);
$upgrade7 = preg_replace('/\{styleid,(\d)\}/e', "\$lastid + \\1", $upgrade7);
runquery($upgrade7);
echo "第 $step 步升级成功
";
redirect("?action=upgrade&step=".($step+1));
} elseif($step == 8) {
$query = $db->query("SELECT value FROM {$tablepre}settings WHERE variable='insenz'");
$insenz = ($insenz = $db->result($query, 0)) ? unserialize($insenz) : array();
if(is_array($insenz['member_masks'])) {
foreach($insenz['member_masks'] AS $uid => $username) {
$db->query("UPDATE {$tablepre}members m, {$tablepre}usergroups u SET m.adminid=0, m.groupid=u.groupid WHERE m.uid='$uid' AND m.groupid='$insenz[groupid]' AND m.credits>u.creditshigher AND m.credits <=u.creditslower");
}
}
$db->query("DELETE FROM {$tablepre}usergroups WHERE groupid='$insenz[groupid]' AND type='special'");
unset($insenz['groupid'], $insenz['lastmodified'], $insenz['forums']);
$insenz['jsurl'] = !empty($insenz['jsurl']) ? preg_replace("/http:\/\/a0(\d{1})\.insenz\.com\/adv\?sid=(\d+)/e", "'http://a0'.('\\2' % 8 + 1).'.insenz.com/adv?sid=\\2'", $insenz['jsurl']) : '';
$insenz['topicstatus'] = 1;
$db->query("REPLACE INTO {$tablepre}settings (variable, value) VALUES ('insenz', '".addslashes(serialize($insenz))."')");
$query = $db->query("SELECT value FROM {$tablepre}settings WHERE variable='videoinfo'");
$settings = unserialize($db->result($query, 0));
$settings['vpassword'] = $settings['vsitecode'];
$settings['vkey'] = $settings['vauthcode'];
$settings['sitetype'] = "新闻\t军事\t音乐\t影视\t动漫\t游戏\t美女\t娱乐\t交友\t教育\t艺术\t学术\t技术\t动物\t旅游\t生活\t时尚\t电脑\t汽车\t手机\t摄影\t戏曲\t外语\t公益\t校园\t数码\t电脑\t历史\t天文\t地理\t财经\t地区\t人物\t体育\t健康\t综合";
$settings['vclasses'] = array (
22 => '新闻',
15 => '体育',
27 => '教育',
28 => '明星',
26 => '美色',
1 => '搞笑',
29 => '另类',
18 => '影视',
12 => '音乐',
8 => '动漫',
7 => '游戏',
24 => '综艺',
11 => '广告',
19 => '艺术',
5 => '时尚',
21 => '居家',
23 => '旅游',
25 => '动物',
14 => '汽车',
30 => '军事',
16 => '科技',
31 => '其它'
);
$settings['vclassesable'] = array (22, 15, 27, 28, 26, 1, 29, 18, 12, 8, 7, 24, 11, 19, 5, 21, 23, 25, 14, 30, 16, 31);
unset($settings['vsitecode']);
unset($settings['vauthcode']);
$settings = addslashes(serialize($settings));
$db->query("UPDATE {$tablepre}settings SET value='$settings' WHERE variable='videoinfo'");
echo "第 $step 步升级成功
";
redirect("?action=upgrade&step=".($step+1));
} elseif($step == 9) {
echo "第 $step 步升级成功
";
redirect("?action=upgrade&step=".($step+1));
} else {
dir_clear('./forumdata/cache');
dir_clear('./forumdata/templates');
$qihoo_items = "'qihoo_adminemail', 'qihoo_jammer', 'qihoo_keywords', 'qihoo_location', 'qihoo_maxtopics', 'qihoo_relatedthreads', 'qihoo_relatedsort', 'qihoo_searchbox', 'qihoo_status', 'qihoo_summary', 'qihoo_topics', 'qihoo_validity'";
$qihoo = $settings = array();
$query = $db->query("SELECT variable, value FROM {$tablepre}settings WHERE variable IN ($qihoo_items)");
while($setting = $db->fetch_array($query)) {
$settings[$setting['variable']] = $setting['value'];
}
$settings['qihoo_topics'] = !empty($settings['qihoo_topics']) ? unserialize($settings['qihoo_topics']) : array();
$settings['qihoo_relatedthreads'] = !empty($settings['qihoo_relatedthreads']) ? unserialize($settings['qihoo_relatedthreads']) : array();
foreach($settings AS $variable => $value) {
$qihoo[substr($variable, 6)] = $value;
}
unset($qihoo['validity']);
$db->query("REPLACE INTO {$tablepre}settings (variable, value) VALUES ('qihoo', '".addslashes(serialize($qihoo))."')");
$db->query("DELETE FROM {$tablepre}settings WHERE variable IN ($qihoo_items)");
$query = $db->query("SELECT value FROM {$tablepre}settings WHERE variable='insenz'");
$insenz = unserialize($db->result($query, 0));
$insenz_message = '';
if(empty($insenz['authkey'])) {
$insenz_message = ''.$version_new.' 为您提供了 Insenz 社区营销服务，帮助站长创造收益，提升社区价值，登录论坛后台点击“社区营销”菜单即可注册';
} elseif($insenz['softadstatus'] != 2) {
$insenz_message = '您的社区营销尚未开启自动接受活动功能，为了保障您的利益，更快更多的接到广告活动，并且得到更高的广告费用，建议您立即登录论坛后台，在“社区营销 -- 营销设置 -- 基本设置”中设置自动接受活动';
}
echo '
恭喜您论坛数据升级成功，接下来请您：- 必删除本程序'.$insenz_message.
'
- 使用管理员身份登录论坛，进入后台，更新缓存'.
'
- 进行论坛注册、登录、发贴等常规测试，看看运行是否正常'.
'
- 如果您希望启用 '.$version_new.' 提供的新功能，你还需要对于论坛基本设置、栏目、会员组等等进行重新设置
'.
'感谢您选用我们的产品！您现在可以访问论坛，查看升级情况';
showfooter();
}
}
instfooter();
function createtable($sql, $dbcharset) {
$type = strtoupper(preg_replace("/^\s*CREATE TABLE\s+.+\s+\(.+?\).*(ENGINE|TYPE)\s*=\s*([a-z]+?).*$/isU", "\\2", $sql));
$type = in_array($type, array('MYISAM', 'HEAP')) ? $type : 'MYISAM';
return preg_replace("/^\s*(CREATE TABLE\s+.+\s+\(.+?\)).*$/isU", "\\1", $sql).
(mysql_get_server_info() > '4.1' ? " ENGINE=$type default CHARSET=$dbcharset" : " TYPE=$type");
}
function dir_clear($dir) {
$directory = dir($dir);
while($entry = $directory->read()) {
$filename = $dir.'/'.$entry;
if(is_file($filename)) {
@unlink($filename);
}
}
@touch($dir.'/index.htm');
$directory->close();
}
function dir_writeable($dir) {
if(!is_dir($dir)) {
@mkdir($dir, 0777);
}
if(is_dir($dir)) {
if($fp = @fopen("$dir/test.txt", 'w')) {
@fclose($fp);
@unlink("$dir/test.txt");
$writeable = 1;
} else {
$writeable = 0;
}
}
return $writeable;
}
function daddslashes($string) {
if(is_array($string)) {
foreach($string as $key => $val) {
$string[$key] = daddslashes($val, $force);
}
} else {
$string = addslashes($string);
}
return $string;
}
function instfooter() {
echo '