function ReCountForum($fid)
{
global $cfg;
$sql = "SELECT COUNT(*) FROM $cfg[tb_topics] WHERE fid='$fid'";
$result = RenDB_Query($sql);
if($row = RenDB_Fetch_Row($result))
$topics=$row[0];
else $topics=0;
$sql = "SELECT COUNT(*) FROM $cfg[tb_posts] WHERE fid='$fid'";
$result = RenDB_Query($sql);
if($row = RenDB_Fetch_Row($result))
$posts=$row[0];
else $posts=0;
$sql = "SELECT author,postdate FROM $cfg[tb_posts] WHERE fid='$fid' ORDER BY pid DESC LIMIT 1";
$result = RenDB_Query($sql);
if($row = RenDB_Fetch_Array($result))
{
$lastpost=$row['postdate'];
$lastposter=$row['author'];
}
else
{
$lastpost=0;
$lastposter='';
}
$sql = "UPDATE $cfg[tb_forums] SET topics='$topics',posts='$posts',lastpost='$lastpost',lastposter='$lastposter' WHERE fid='$fid' LIMIT 1";
RenDB_Query($sql,true);
}
function IsMember( $name )
{
global $cfg;
$sql ="SELECT COUNT(*) FROM $cfg[tb_members] WHERE u_name='$name' LIMIT 1";
$result = RenDB_Query($sql);
if( RenDB_Num_Rows($result) != 0 )
{
$row = RenDB_Fetch_Row( $result );
return $row[0];
}
return 0;
}
function DeleteMember($u_name)
{
global $cfg;
//$sql="UPDATE `$cfg[tb_topics]` SET author='' WHERE author='$u_name'";
//RenDB_Query($sql,true);
//$sql="UPDATE `$cfg[tb_posts]` SET author='' WHERE author='$u_name'";
//RenDB_Query($sql,true);
$sql = "UPDATE `{$cfg['tb_chats']}` SET author='' WHERE author='{$u_name}'";
RenDB_Query($sql, true);
$sql = "DELETE FROM `{$cfg['tb_newgames']}` WHERE host_name='{$u_name}'";
RenDB_Query($sql, true);
$sql = "DELETE FROM `{$cfg['tb_pms']}` WHERE sendto='{$u_name}' OR comefrom='{$u_name}'";
RenDB_Query($sql, true);
$sql = "DELETE FROM `{$cfg['tb_games']}` WHERE w_name='{$u_name}' OR b_name='{$u_name}' ";
RenDB_Query($sql, true);
$sql = "DELETE FROM `{$cfg['tb_members']}` WHERE u_name='{$u_name}'";
RenDB_Query($sql, true);
}
if (!In_Names($sendto, $cfg['admins'])) {
//检查消息是否已满
// $sql ="SELECT COUNT(*) FROM $cfg[tb_pms] WHERE sendto='$sendto' OR comefrom='$sendto' LIMIT $cfg[maxpm]";
$sql = "SELECT COUNT(*) FROM {$cfg['tb_pms']} WHERE sendto='{$sendto}' LIMIT {$cfg['maxpm']}";
$result = RenDB_Query($sql);
if ($row = RenDB_Fetch_Row($result)) {
if ($row[0] >= $cfg['maxpm']) {
SimplyBox('对方消息已经满了');
}
}
}
//var_dump($meminfo);
//写入数据库
$sql = "INSERT INTO `{$cfg['tb_pms']}` SET ";
$sql .= "sendto='{$sendto}',";
$sql .= "comefrom='{$udata['u_name']}',";
$sql .= "sendtime='{$nowtime}',";
$sql .= "message='{$message}',";
$sql .= "u_stand='{$pm_stand}'";
$result = RenDB_Query($sql);
if ($row = RenDB_Insert_ID()) {
//通知用户有新消息
if (!$meminfo['have_new_pm']) {
$sql = "UPDATE {$cfg['tb_members']} SET have_new_pm=1 WHERE u_name='{$sendto}' LIMIT 1";
RenDB_Query($sql, true);
}
SimplyBox('消息发送成功', true);
}
break;
}
SimplyBox($str['act_fail']);
<?php
require_once './include/common.php';
include_once './include/txt_func.php';
SetNoUseCache();
if (!isset($name)) {
ErrorBox($str['act_err']);
}
$sql = "SELECT * FROM {$cfg['tb_members']} WHERE u_name='{$name}' LIMIT 1";
$result = RenDB_Query($sql);
unset($mdata);
if (RenDB_Num_Rows($result) == 1) {
$mdata = RenDB_Fetch_Array($result);
}
if (empty($mdata)) {
MessageBox("{$name} 不是会员");
}
$baninfo = '';
if ($mdata['ban_before'] > $nowtime || $mdata['ban_before'] == -1) {
MessageBox("{$name} 账号已被冻结");
}
switch ($mdata['u_gender']) {
case 1:
$m_gender = '男';
break;
case 2:
$m_gender = '女';
break;
default:
$m_gender = '保密';
}
}
else
{
MessageBox('发送失败');
}
break;
case 'confirm_pass':
SetNoUseCache();
if( !isset( $u_id,$passcheck,$newpass ))
ErrorBox( $str['act_err'] );
if($passcheck==''||$newpass=='') ErrorBox( $str['act_err'] );
$sql="UPDATE `$cfg[tb_members]` SET u_pass=MD5(new_pass), new_pass='',new_pass_check='' WHERE u_id='$u_id' AND new_pass='******' AND new_pass_check='$passcheck' LIMIT 1";
RenDB_Query($sql);
if( RenDB_Affected_Rows())
{
$lks[0]=array('登陆','index');
MessageBox('新密码已经激活，请用新密码登陆',$lks);
}
else
{
$lks[0]=array('登陆','index');
WriteBBLog("验证码错误(找回密码) u_id='$u_id' ", 'wrongpass');
ErrorBox('验证码不对，可能是已经过期，请重新发送密码',$lks);
}
break;
}
ErrorBox( $str['act_fail'] );
function Rebuild_Global_Cache($insubdir = false)
{
global $cfg;
$buf = "<?php\n";
//缓存banip
$sql = "SELECT * FROM `{$cfg['tb_banips']}` ";
$result = RenDB_Query($sql);
$banip_S = array();
$banip_D = array();
if (RenDB_Num_Rows($result) > 0) {
while ($row = RenDB_Fetch_Array($result)) {
$cell = explode('.', $row['ban_ip']);
if ($cell[3] == '*') {
unset($cell[3]);
$banip_D[] = '\'' . implode('.', $cell) . '\'';
} else {
$banip_S[] = "'{$row['ban_ip']}'";
}
}
}
$banip_S = implode(', ', $banip_S);
$banip_D = implode(', ', $banip_D);
$buf .= "\$RBB_CACHE['banip_S'] = array({$banip_S});\n";
$buf .= "\$RBB_CACHE['banip_D'] = array({$banip_D});\n";
/*
//缓存论坛数据
$buf .="\n";
$sql ="SELECT * FROM $cfg[tb_forums] ORDER BY displayorder";
$result = RenDB_Query($sql);
$num=0;
while( $row=RenDB_Fetch_Array( $result ) )
{
//$displayorder=$row['displayorder'];
unset($row['topics']);
unset($row['posts']);
unset($row['lastpost']);
unset($row['lastposter']);
unset($row['displayorder']);
//unset($row['fid']);
unset($row['description']);
$fd=array();
foreach( $row as $k=>$v )
$fd[]='"'.addslashes($k).'"=>"'.addslashes($v).'"';
$fd=implode(', ',$fd);
$buf .="\$RBB_CACHE['forums'][$num] = array($fd);\n";
$num++;
}
if($num==0) $buf .="\$RBB_CACHE['forums']=array();\n";
*/
//缓存设置
$buf .= "\n";
$sql = "SELECT * FROM {$cfg['tb_settings']}";
$result = RenDB_Query($sql);
while ($row = RenDB_Fetch_Array($result)) {
/*
if(strpos($row['set_value'],'||')!==false)
{
$row['set_value']=explode('||',$row['set_value']);
foreach($row['set_value'] as $k=>$v)
{
$row['set_value'][$k]=str_replace('=>','"=>"',$v);
}
$buf .="\$cfg['$row[set_name]']=array(\"".implode('","',$row['set_value'])."\");\n";
}
else */
$row['set_value'] = addslashes($row['set_value']);
$buf .= "\$cfg['{$row['set_name']}']=\"{$row['set_value']}\";\n";
}
$buf .= "?>";
$gc_file = $insubdir ? '../cache/global.php' : './cache/global.php';
$fr = @fopen($gc_file, 'w');
@flock($fr, LOCK_EX);
@fwrite($fr, $buf);
@fclose($fr);
}
function UpdateOnline()
{
global $cfg, $udata, $nowtime, $fakename;
if (empty($udata['o_time'])) {
$udata['u_stand'] = $udata['is_member'] ? 1 : 0;
$udata['o_time'] = $nowtime;
$udata['fake_name'] = $udata['is_member'] ? $udata['u_name'] : $fakename;
$sql = "REPLACE {$cfg['tb_onlines']} SET fake_name='{$udata['fake_name']}', u_stand='{$udata['u_stand']}',o_time='{$nowtime}', last_action='{$nowtime}'";
RenDB_Query($sql, true);
} elseif ($udata['o_time'] < $nowtime - $cfg['span_renew']) {
$sql = "UPDATE {$cfg['tb_onlines']} SET o_time='{$nowtime}' WHERE fake_name='{$udata['fake_name']}' LIMIT 1";
RenDB_Query($sql, true);
if ($udata['is_member']) {
if ($udata['o_time'] < $nowtime - 3600) {
$udata['act_check'] = md5(uniqid(rand()));
}
$sql = "UPDATE {$cfg['tb_members']} SET last_visit='{$nowtime}', act_check='{$udata['act_check']}' WHERE u_id='{$udata['u_id']}' LIMIT 1";
RenDB_Query($sql, true);
}
}
}
