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);
}
 if ($sendto == '') {
     SimplyBox('请填写收件人');
 }
 if (IsSameName($sendto, $udata['u_name'])) {
     SimplyBox('不能给自己发消息');
 }
 if ($action == 'invite2') {
     $pm_stand = 4;
     $message = '[url=m_view.php?name=' . urlencode($udata['u_name']) . "]{$udata['u_name']}[/url] 邀请您下棋,点击[url=room_new.php?byname={$udata['u_name']}]这里[/url]查看.";
 } else {
     $pm_stand = $udata['u_stand'];
 }
 //收件人是否存在
 $sql = "SELECT blacklist,have_new_pm FROM {$cfg['tb_members']} WHERE u_name='{$sendto}'";
 $result = RenDB_Query($sql);
 if (!($meminfo = RenDB_Fetch_Array($result))) {
     SimplyBox('用户不存在');
 }
 //检查是否拒收
 if (In_Names($udata['u_name'], $meminfo['blacklist'])) {
     SimplyBox('用户拒收您的消息');
 }
 //存好友名单
 /*if( isset( $_COOKIE['my_contacts']) )
 	{
 		$my_contacts = explode(',', $_COOKIE['my_contacts']);
 	}
 	else $my_contacts = array();
 	$key = array_search( $sendto, $my_contacts);
 	if( $key!==false ) unset( $my_contacts[$key] );
 	elseif( count($my_contacts) > 6 )array_pop($my_contacts);
Exemple #3
0
	if(empty($tname)) ErrorBox('名字不能为空');
	if(strlen($tname)>12) ErrorBox('无效的名字');
}

//只有会员能改资料
if( !$udata['is_member']) ErrorBox( $str["act_noguest"] );

switch( $action )
{
case 'view':
	$onlines=array();
	if(!empty($udata['friends'])||!empty($udata['blacklist']) )
	{
		$sql ="SELECT * FROM $cfg[tb_onlines] WHERE o_time>'$o_deadline'";
		$result = RenDB_Query($sql);
		while($row=RenDB_Fetch_Array( $result ) )
		{
			$onlines[]=$row['fake_name'];
		}
	}

	if(!empty($udata['friends']))
	{
		$friends=explode('|',$udata['friends']);
		asort($friends);
		$f_list='';
		foreach($friends as $n)
		{
			$this_name=MemberLink($n);
			foreach($onlines as $n2)
				if(IsSameName($n,$n2))
<?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 = '保密';
}
}
//$roombar=MakeRoomBar(1);
if (!isset($page)) {
    $page = 1;
}
$page = intval($page);
$ngblock = '';
//未开始的
$sql = "SELECT * FROM {$cfg['tb_newgames']} WHERE host_name='{$udata['u_name']}' LIMIT {$cfg['maxnewgame']}";
//$sql = "SELECT * FROM {$cfg['tb_newgames']} WHERE host_name='{$udata['u_name']}'";
$result = RenDB_Query($sql);
$nglist = '';
$gnum = 0;
if (RenDB_Num_Rows($result) > 0) {
    $game_cell = LoadTemplate('g_cell_mynew');
    while ($gdata = RenDB_Fetch_Array($result)) {
        if ($gdata['app_count'] > 0) {
            //超时检测
            $gtremain = GetNewGameTimeOutInfo();
            if ($gtremain == 0) {
                continue;
            }
            $gtremain = Time2HMS($gtremain) . HLTxt('*');
            $applist = explode('|', $gdata['app_list']);
            //array_shift( $applist );
            $gchallenge = "<select name=\"tarname\" onChange=\"document.mn_{$gnum}.submit()\"><option>====== ({$gdata['app_count']}) ======</option>";
            foreach ($applist as $k => $v) {
                $v = explode(',', $v);
                if (In_Names($v[0], $udata['friends'])) {
                    $sty = 'style="background:#9999ff"';
                } else {
}
SetNoUseCache();
if (!isset($action)) {
    $action = 'show';
}
if (!in_array($action, array('show', 'update'))) {
    ACP_MessageBox($str['act_err']);
}
switch ($action) {
    case 'show':
        $slist = '';
        //读出setting中的数据
        $sql = "SELECT * FROM {$cfg['tb_settings']} ORDER BY set_order,set_id";
        $result = RenDB_Query($sql);
        $crsfix = 1;
        while ($set = RenDB_Fetch_Array($result)) {
            //$slist.='<form action="index.php" method="post">';
            $slist .= '<form action="index.php?mode=all_set&action=update&set_id=' . $set['set_id'] . '" method="post">';
            $crsfix = 3 - $crsfix;
            $cr = $color["cell{$crsfix}"];
            $slist .= "<tr bgcolor=\"{$cr}\">";
            $slist .= "<td><a name=\"set_{$set['set_id']}\">{$set['set_note']}</a></td>";
            $slist .= "<td><input type=\"text\" size=\"50\" maxlength=\"1024\" name=\"set_value\" value=\"{$set['set_value']}\"></td>";
            $slist .= "<td><input type=\"submit\" value=\"更改\"></td>";
            $slist .= '</tr>';
            //$slist.='<input type="hidden" name="mode" value="all_set">';
            //$slist.='<input type="hidden" name="action" value="update">';
            //$slist.='<input type="hidden" name="set_id" value="'.$set['set_id'].'">';
            $slist .= "</form>\n";
        }
        ACP_ShowHeader('参数设置');
Exemple #7
0
    ErrorBox($str['act_noguest']);
}
if (!isset($checkcode) || $checkcode != $udata['act_check']) {
    MessageBox('验证码不对,请返回刷新页面重试');
}
if (!isset($gid) || !isset($action) || !in_array($action, array('go', 'swap', 'undo1', 'undo2', 'draw', 'resign'))) {
    ErrorBox($str['act_err']);
}
//读棋局
$gid = intval($gid);
$sql = "SELECT * FROM {$cfg['tb_games']} WHERE `gid`='{$gid}' LIMIT 1";
$result = RenDB_Query($sql);
if (RenDB_Num_Rows($result) < 1) {
    ErrorBox('棋局不存在');
}
if (!($gdata = RenDB_Fetch_Array($result))) {
    ErrorBox('棋局不存在');
}
if ($gdata['startdate'] > $nowtime) {
    MessageBox('这盘棋还没开始');
}
if ($gdata['status']) {
    MessageBox('这盘棋已经结束');
}
$mcount = $gdata['mcount'];
$gdata['moves'] = substr($gdata['moves'], 0, $mcount);
$curside = ($mcount + 1) % 2;
$names[0] = $gdata['w_name'];
$names[1] = $gdata['b_name'];
$draws[0] = $gdata['w_draw'];
$draws[1] = $gdata['b_draw'];
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);
}
if (!isset($gid, $message)) {
    ErrorBox($str['act_err']);
}
$gid = intval($gid);
require_once './include/txt_func.php';
$message = BBInputFilter($message, 1);
$message = CSubStr($message, 0, 253);
if ($message == '') {
    MessageBox($str['req_content']);
}
$sql = "SELECT COUNT(*) FROM `{$cfg['tb_games']}` WHERE gid='{$gid}' LIMIT 1";
$result = RenDB_Query($sql);
$row = RenDB_Fetch_Row($result);
if (!$row[0]) {
    MessageBox($str['g_not_found']);
}
$sql = "SELECT COUNT(*) FROM `{$cfg['tb_chats']}` WHERE gid='{$gid}'";
$result = RenDB_Query($sql);
$row = RenDB_Fetch_Row($result);
if ($row[0] > 25) {
    $sql = "SELECT * FROM `{$cfg['tb_chats']}` WHERE gid='{$gid}' ORDER BY chat_id LIMIT 3,1";
    $result = RenDB_Query($sql);
    if ($chatdata = RenDB_Fetch_Array($result)) {
        $sql = "DELETE FROM `{$cfg['tb_chats']}` WHERE gid='{$gid}' AND chat_id<'{$chatdata['chat_id']}'";
        RenDB_Query($sql, true);
    }
}
//$author=$udata['is_member']?$udata['u_name']:'Guest';
$sql = "INSERT INTO `{$cfg['tb_chats']}` SET gid='{$gid}', chat_message='{$message}', chat_author='{$udata['u_name']}', chat_date='{$nowtime}'";
RenDB_Query($sql, true);
header("Location: g_view.php?gid={$gid}");