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);
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('参数设置');
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}");