📄 upgrade9.php
字号:
'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 步升级成功<br /><br />";
redirect("?action=upgrade&step=".($step+1));
} elseif($step == 4) {
runquery($upgrade4);
echo "第 $step 步升级成功<br /><br />";
redirect("?action=upgrade&step=".($step+1));
} elseif($step == 5) {
upg_mail();
upg_spaces();
upg_seccode();
echo "第 $step 步升级成功<br /><br />";
redirect("?action=upgrade&step=".($step+1));
} elseif($step == 6) {
$endupg = upg_ec($start);
if($endupg != '-1') {
echo "第 $step 步升级成功<br /><br />";
redirect("?action=upgrade&step=$step&start=$endupg");
} else {
echo "第 $step 步升级成功<br /><br />";
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);
runquery($upgrade7);
echo "第 $step 步升级成功<br /><br />";
redirect("?action=upgrade&step=".($step+1));
} elseif($step == 8) {
$query = $db->query("RENAME TABLE {$tablepre}campaigns TO {$tablepre}campaigns_bak", 'SILENT');
runquery($insenz_upgrade);
$query = $db->query("SELECT * FROM {$tablepre}campaigns_bak", 'SILENT');
while(@$campaign = $db->fetch_array($query)) {
$c_id = $campaign['id'];
$c_type = $campaign['type'];;
$fid = $campaign['fid'];
$tid = $campaign['tid'];
$status = $campaign['status'];
$begintime = $campaign['begintime'];
$endtime = $campaign['endtime'];
$expiration = $campaign['expiration'];
$nextrun = $campaign['nextrun'];
$db->query("INSERT INTO {$tablepre}campaigns (id, type, fid, tid, status, begintime, endtime, expiration,nextrun) VALUES ('$c_id', '$c_type', '$fid', '$tid', '$status', '$begintime', '$endtime', '$expiration', '$nextrun')");
}
$query = $db->query("SELECT value FROM {$tablepre}settings WHERE variable='insenz'");
$insenz = ($insenz = $db->result($query, 0)) ? unserialize($insenz) : array();
if(isset($insenz['version']) && $insenz['version'] == '0.2') {
$query = $db->query("SELECT it.id, it.tid, it.status, it.dateline, tm.expiration, t.fid, t.displayorder
FROM {$tablepre}insenzthreads it
LEFT JOIN {$tablepre}threadsmod tm ON tm.tid=it.tid AND tm.status=it.status
LEFT JOIN {$tablepre}threads t ON t.tid=it.tid", 'SILENT');
while(@$campaign = $db->fetch_array($query)) {
$c_id = $campaign['id'];
$c_type = in_array($campaign['displayorder'], array(1, 2, -121, -122)) ? 2 : 1;
$fid = $campaign['fid'];
$tid = $campaign['tid'];
$status = $campaign['status'] - 120;
$begintime = $campaign['dateline'];
$endtime = $campaign['expiration'];
$expiration = $endtime + 60 * 86400;
$nextrun = $status == 1 ? $begintime : ($status == 2 ? $endtime : $expiration);
$db->query("INSERT INTO {$tablepre}campaigns (id, type, fid, tid, status, begintime, endtime, expiration, nextrun) VALUES ('$c_id', '$c_type', '$fid', '$tid', '$status', '$begintime', '$endtime', '$expiration', '$nextrun')", 'SILENT');
$newdisplayorder = in_array($campaign['displayorder'], array(-120, -121, -122)) ? $campaign['displayorder'] + 110 : $campaign['displayorder'];
$db->query("UPDATE {$tablepre}threads SET digest=-1, displayorder='$newdisplayorder' WHERE tid='$tid'", 'UNBUFFERED');
}
}
if($insenz) {
$insenz['status'] = isset($insenz['status']) ? intval($insenz['status']) : 1;
$insenz['softadstatus'] = isset($insenz['softadstatus']) ? intval($insenz['softadstatus']) : 2;
}
unset($insenz['lastmodified'], $insenz['forums'], $insenz['version']);
$insenz['topicstatus'] = 1;
$insenz['host'] = $insenz['host'] ? $insenz['host'] : 'api.insenz.com';
$db->query("REPLACE INTO {$tablepre}settings (variable, value) VALUES ('insenz', '".addslashes(serialize($insenz))."')");
$db->query("DROP TABLE IF EXISTS {$tablepre}campaigns_bak");
$db->query("DROP TABLE IF EXISTS {$tablepre}insenzthreads");
$db->query("DELETE FROM {$tablepre}crons WHERE filename IN ('insenz_onlinestats.inc.php', 'insenz_pushthreads.inc.php', 'insenz_forumstats.inc.php')");
$settings = array(
'open' => 0,
'bbname' => '',
'url' => '',
'email' => '',
'logo' => '',
'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综合",
'vsiteid' => '',
'vpassword' => '',
'vkey' => '',
'vclasses' => array (
22 => '新闻',
15 => '体育',
27 => '教育',
28 => '明星',
26 => '美色',
1 => '搞笑',
29 => '另类',
18 => '影视',
12 => '音乐',
8 => '动漫',
7 => '游戏',
24 => '综艺',
11 => '广告',
19 => '艺术',
5 => '时尚',
21 => '居家',
23 => '旅游',
25 => '动物',
14 => '汽车',
30 => '军事',
16 => '科技',
31 => '其它'
),
'vclassesable' => array (22, 15, 27, 28, 26, 1, 29, 18, 12, 8, 7, 24, 11, 19, 5, 21, 23, 25, 14, 30, 16, 31),
);
$settings = addslashes(serialize($settings));
$db->query("REPLACE INTO {$tablepre}settings (variable, value) VALUES ('videoinfo', '$settings')");
echo "第 $step 步升级成功<br /><br />";
redirect("?action=upgrade&step=".($step+1));
} elseif($step == 9) {
$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)");
$rewritestatus = intval($db->result($db->query("SELECT value FROM {$tablepre}settings WHERE variable='rewritestatus'"), 0));
if($rewritestatus == 1) {
$rewritestatus = 16;
} elseif($rewritestatus == 2) {
$rewritestatus = 7;
} elseif($rewritestatus == 3) {
$rewritestatus = 23;
}
$query = $db->query("REPLACE INTO {$tablepre}settings (variable, value) VALUES ('rewritestatus', '$rewritestatus')");
echo "第 $step 步升级成功<br /><br />";
redirect("?action=upgrade&step=".($step+1));
} else {
dir_clear('./forumdata/cache');
dir_clear('./forumdata/templates');
$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')");
$query = $db->query("SELECT value FROM {$tablepre}settings WHERE variable='insenz'");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -