subDays(date('w')); $s=strftime("%Y-%m-%d",$monday); break; case 'm': $s=date('Y').'-'.date('m').'-01'; ;break; default : $s=date('Y').'-01-01'; } //echo $s."<-------------------------"; $sql="SELECT users.`user_id`,`nick`,s.`solved`,t.`submit` FROM `users` right join (select count(distinct problem_id) solved ,user_id from solution where in_date>str_to_date('$s','%Y-%m-%d') and result=4 group by user_id order by solved desc limit " . strval ( $rank ) . ",$page_size) s on users.user_id=s.user_id left join (select count( problem_id) submit ,user_id from solution where in_date>str_to_date('$s','%Y-%m-%d') group by user_id order by submit desc limit " . strval ( $rank ) . ",".($page_size*2).") t on users.user_id=t.user_id ORDER BY s.`solved` DESC,t.submit,reg_time LIMIT 0,50 "; // echo $sql; } // $result = mysql_query ( $sql ); //mysqli_error(); if($OJ_MEMCACHE){ require("./include/memcache.php"); $result = mysql_query_cache($sql) ;//or die("Error! ".mysqli_error()); if($result) $rows_cnt=count($result); else $rows_cnt=0; }else{ $result = mysqli_query($mysqli,$sql) or die("Error! ".mysqli_error()); if($result) $rows_cnt=mysqli_num_rows($result); else $rows_cnt=0; } $view_rank=Array(); $i=0; for ( $i=0;$i<$rows_cnt;$i++ ) { if($OJ_MEMCACHE) $row=$result[$i]; else $row=mysqli_fetch_array($result); $rank ++; $view_rank[$i][0]= $rank; $view_rank[$i][1]= "
"; $view_rank[$i][2]= "