function getImCount()
{
$db_uch = new dbstuff();
$db_uch->charset = dbcharset;
$db_uch->connect(dbhost, dbuser, dbpw, dbname, pconnect);
$result = $db_uch->result($db_uch->query("SELECT COUNT(*) FROM " . tname("spacefield") . " WHERE qq <> ''"), 0);
return $result;
}
'3' => '按月份存入不同目录',
'4' => '按天存入不同目录',
);
if(!empty($_POST['moveattsubmit']) || $step == 1) {
$rpp = "500"; //每次处理多少条数据
$totalrows = isset($totalrows) ? $totalrows : 0;
$convertedrows = isset($convertedrows) ? $convertedrows : 0;
$start = isset($start) && $start > 0 ? $start : 0;
$end = $start + $rpp - 1;
$converted = 0;
$maxid = isset($maxid) ? $maxid : 0;
$newattachsave = isset($newattachsave) ? $newattachsave : 0;
$step = 1;
if($start <= 1) {
$db->query("UPDATE {$tablepre}settings SET value = '$newattachsave' WHERE variable = 'attachsave'");
$cattachdir = $db->result($db->query("SELECT value FROM {$tablepre}settings WHERE variable = 'attachdir'"), 0);
validid('aid', 'attachments');
}
$attachpath = isset($cattachdir) ? TOOLS_ROOT.$cattachdir : TOOLS_ROOT.'./attachments';
$query = $db->query("SELECT aid, tid, dateline, filename, filetype, attachment, isimage, thumb FROM {$tablepre}attachments WHERE aid >= $start AND aid <= $end");
while ($a = $db->fetch_array($query)) {
$aid = $a['aid'];
$tid = $a['tid'];
$dateline = $a['dateline'];
$filename = $a['filename'];
$filetype = $a['filetype'];
$attachment = $a['attachment'];
$isimage = $a['isimage'];
$thumb = $a['thumb'];
$oldpath = $attachpath.'/'.$attachment;
if(file_exists($oldpath)) {
loginit($yearmonth . 'illegallog');
loginit($yearmonth . 'modslog');
loginit($yearmonth . 'cplog');
loginit($yearmonth . 'errorlog');
loginit($yearmonth . 'banlog');
dir_clear(ROOT_PATH . './data/template');
dir_clear(ROOT_PATH . './data/cache');
dir_clear(ROOT_PATH . './data/threadcache');
dir_clear(ROOT_PATH . './uc_client/data');
dir_clear(ROOT_PATH . './uc_client/data/cache');
foreach ($serialize_sql_setting as $k => $v) {
$v = addslashes(serialize($v));
$db->query("REPLACE INTO {$tablepre}common_setting VALUES ('{$k}', '{$v}')");
}
$query = $db->query("SELECT COUNT(*) FROM {$tablepre}common_member");
$totalmembers = $db->result($query, 0);
$userstats = array('totalmembers' => $totalmembers, 'newsetuser' => $username);
$ctype = 1;
$data = addslashes(serialize($userstats));
$db->query("REPLACE INTO {$tablepre}common_syscache (cname, ctype, dateline, data) VALUES ('userstats', '{$ctype}', '" . time() . "', '{$data}')");
touch($lockfile);
VIEW_OFF && show_msg('initdbresult_succ');
if (!VIEW_OFF) {
echo '<script type="text/javascript">function setlaststep() {document.getElementById("laststep").disabled=false;window.location=\'index.php?method=ext_info\';}</script><script type="text/javascript">setTimeout(function(){window.location=\'index.php?method=ext_info\'}, 30000);</script><iframe src="../misc.php?mod=initsys" style="display:none;" onload="setlaststep()"></iframe>' . "\r\n";
show_footer();
}
}
if (VIEW_OFF) {
show_msg('missing_parameter', '', 0);
} else {
show_form($form_db_init_items, $error_msg);
$curr_os = PHP_OS;
$curr_php_version = PHP_VERSION;
if ($curr_php_version < '4.3.0') {
$msg .= "<font color=\"#FF0000\">{$lang['php_version_430']}</font>\t";
$quit = TRUE;
}
if (@ini_get(file_uploads)) {
$max_size = @ini_get(upload_max_filesize);
$curr_upload_status = $lang['attach_enabled'] . $max_size;
$msg .= $lang['attach_enabled_info'] . $max_size . "\t";
} else {
$curr_upload_status = $lang['attach_disabled'];
$msg .= "<font color=\"#FF0000\">{$lang['attach_disabled_info']}</font>\t";
}
$query = $db->query("SELECT VERSION()");
$curr_mysql_version = $db->result($query, 0);
if ($curr_mysql_version < '3.23') {
$msg .= "<font color=\"#FF0000\">{$lang['mysql_version_323']}</font>\t";
$quit = TRUE;
}
$curr_disk_space = intval(diskfreespace('.') / (1024 * 1024)) . 'M';
if (dir_writeable('./templates')) {
$curr_tpl_writeable = $lang['writeable'];
} else {
$curr_tpl_writeable = $lang['unwriteable'];
$msg .= "<font color=\"#FF0000\">{$lang['unwriteable_template']}</font>\t";
}
if (dir_writeable('./gamedata')) {
$curr_data_writeable = $lang['writeable'];
} else {
$curr_data_writeable = $lang['unwriteable'];
}
$db->query("UPDATE {$tablepre}members SET {$sql} WHERE uid='{$member['uid']}'");
$sql = $comma = '';
foreach ($table_memberfields_columns as $field) {
if (isset($memberfields[$field])) {
$sql .= "{$comma}{$field}='{$memberfields[$field]}'";
$comma = ', ';
}
}
if ($sql) {
$db->query("UPDATE {$tablepre}memberfields SET {$sql} WHERE uid='{$member['uid']}'");
}
} else {
if (empty($memberfields['groupid'])) {
$query = $db->query("SELECT groupid FROM {$tablepre}usergroups WHERE type='member' AND creditshigher='0'");
$memberfields['groupid'] = $db->result($query, 0);
$memberfields['adminid'] = 0;
}
$memberfields['timeoffset'] = !$memberfields['timeoffset'] ? 9999 : $memberfields['timeoffset'];
$memberfields['newsletter'] = !$memberfields['newsletter'] ? 1 : $memberfields['newsletter'];
$sql1 = $sql2 = $comma = '';
foreach ($table_member_columns as $field) {
if (isset($memberfields[$field])) {
$sql1 .= "{$comma}{$field}";
$sql2 .= "{$comma}'{$memberfields[$field]}'";
$comma = ', ';
}
}
$db->query("INSERT INTO {$tablepre}members ({$sql1}) VALUES ({$sql2})");
$table_memberfields_columns[] = 'uid';
$memberfields['uid'] = $member['uid'] = $db->insert_id();
$Id: advcache.php 16698 2008-11-14 07:58:56Z cnteacher $
*/
error_reporting(0);
define('IN_DISCUZ', TRUE);
define('DISCUZ_ROOT', substr(dirname(__FILE__), 0, -3));
$timestamp = time();
@set_time_limit(1000);
@ignore_user_abort(TRUE);
require_once DISCUZ_ROOT . './config.inc.php';
require_once DISCUZ_ROOT . './include/db_' . $database . '.class.php';
require_once DISCUZ_ROOT . './include/insenz.func.php';
$db = new dbstuff();
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect, true, $dbcharset);
unset($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
$query = $db->query("SELECT value FROM {$tablepre}settings WHERE variable='insenz'");
$insenz = ($insenz = $db->result($query, 0)) ? unserialize($insenz) : array();
$insenz['host'] = empty($insenz['host']) ? 'api.insenz.com' : $insenz['host'];
$insenz['url'] = empty($insenz['url']) ? 'api.insenz.com' : $insenz['url'];
$insenz['siteid'] = intval($insenz['siteid']);
if (empty($insenz['authkey'])) {
exit;
}
$type = intval($_GET['type']);
$cid = intval($_GET['cid']);
if (empty($type)) {
if (empty($insenz['hardadstatus']) || !empty($insenz['lastupdated']) && $timestamp - $insenz['lastupdated'] < 600) {
exit;
}
$response = insenz_request('adv.php', '<cmd id="getSiteAdJs"><site_id>' . $insenz['siteid'] . '</site_id></cmd>');
$hash = $response[0]['hash'][0]['VALUE'];
$updateadvcache = FALSE;
}
$return = htmlspecialchars($return);
}
if (!$tid) {
$inajax = 1;
include template('relatekw');
} else {
if ($_DCACHE['settings']['tagstatus'] && $kws) {
require_once DISCUZ_ROOT . '/forumdata/cache/cache_censor.php';
$tagcount = 0;
foreach ($kws as $tagname) {
$tagname = trim(empty($_DCACHE['censor']['filter']) ? $tagname : preg_replace($_DCACHE['censor']['filter']['find'], $_DCACHE['censor']['filter']['replace'], $tagname));
if (preg_match('/^([\\x7f-\\xff_-]|\\w|\\s){3,20}$/', $tagname)) {
$query = $db->query("SELECT closed FROM {$tablepre}tags WHERE tagname='{$tagname}'");
if ($db->num_rows($query)) {
if (!($tagstatus = $db->result($query, 0))) {
$db->query("UPDATE {$tablepre}tags SET total=total+1 WHERE tagname='{$tagname}'", 'UNBUFFERED');
}
} else {
$db->query("INSERT INTO {$tablepre}tags (tagname, closed, total)\r\n\t\t\t\t\t\t\tVALUES ('{$tagname}', 0, 1)", 'UNBUFFERED');
$tagstatus = 0;
}
if (!$tagstatus) {
$db->query("INSERT {$tablepre}threadtags (tagname, tid) VALUES ('{$tagname}', {$tid})", 'UNBUFFERED');
}
$tagcount++;
if ($tagcount > 4) {
break;
}
}
}
if ($adminid == 3) {
$modadd1 = ', m.uid AS ismoderator';
$modadd2 = "LEFT JOIN {$tablepre}moderators m ON m.uid='{$discuz_uid}' AND m.fid=f.fid";
}
}
if ($errorreport == 2 || $errorreport == 1 && $adminid > 0) {
error_reporting(E_ERROR | E_WARNING | E_PARSE);
}
define('FORMHASH', formhash());
$statstatus && !$inajax && (require_once DISCUZ_ROOT . './include/counter.inc.php');
$extra = isset($extra) && @preg_match("/^[&=;a-z0-9]+\$/i", $extra) ? $extra : '';
$rsshead = $navtitle = $navigation = '';
$_DSESSION['groupid'] = $groupid = empty($ipbanned) ? empty($groupid) ? 7 : intval($groupid) : 6;
if (!@(include DISCUZ_ROOT . './forumdata/cache/usergroup_' . $groupid . '.php')) {
$query = $db->query("SELECT type FROM {$tablepre}usergroups WHERE groupid='{$groupid}'");
$grouptype = $db->result($query, 0);
if (!empty($grouptype)) {
$cachelost .= ' usergroup_' . $groupid;
} else {
$grouptype = 'member';
}
}
if ($passport_status && ($passport_status != 'shopex' || !$passport_shopex)) {
$passport_forward = rawurlencode('http://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']);
$link_login = $passport_url . $passport_login_url . (strpos($passport_login_url, '?') === FALSE ? '?' : '&') . 'forward=' . $passport_forward;
$link_logout = $passport_url . $passport_logout_url . (strpos($passport_logout_url, '?') === FALSE ? '?' : '&') . 'forward=' . $passport_forward;
$link_register = $passport_url . $passport_register_url . (strpos($passport_register_url, '?') === FALSE ? '?' : '&') . 'forward=' . $passport_forward;
} else {
$link_login = '******';
$link_logout = 'logging.php?action=logout&formhash=' . FORMHASH;
$link_register = $regname;
