function sh_point_ranking($기간 = "30", $랭킹명수 = "10", $가입얼마이후 = "30") { global $g4, $config; /* 필요한 변수 셋팅 $기간 = 30; // 최근 며칠간 포인트 적립을 구할것이냐. $랭킹명수 = 10; // 몇명이나? */ $회원가입얼마이후 = mktime(0, 0, 0, date("m"), date("d")-$가입얼마이후, date("Y")); $회원가입얼마이후 = date("Y-m-d H:i:s",$회원가입얼마이후); $선택기간 = mktime(0, 0, 0, date("m") , date("d")-$기간, date("Y")); $선택기간 = date("Y-m-d H:i:s",$선택기간); $sql = "SELECT a.s_point, a.mb_id, {$g4['member_table']}.mb_nick FROM (SELECT sum(po_point) as s_point, mb_id FROM `g4_point` WHERE po_datetime >= '{$선택기간}' GROUP BY mb_id ORDER BY s_point DESC)a LEFT JOIN {$g4['member_table']} using(mb_id) WHERE {$g4['member_table']}.mb_datetime <= '{$회원가입얼마이후}' and {$g4['member_table']}.mb_id <> 'admin' LIMIT 0, {$랭킹명수}"; $result = sql_query($sql); $temp_config = $config['cf_use_member_icon']; unset($config['cf_use_member_icon']); for ($i=1; $row=sql_fetch_array($result); $i++) { $랭킹배열[$i]['name'] = get_sideview($row['mb_id'], $row['mb_nick']); $랭킹배열[$i]['point'] = number_format($row['s_point']); } $config['cf_use_member_icon'] = $temp; $랭킹배열[1]['class'] = ' class="best"'; $랭킹배열[2]['class'] = ' class="best"'; $랭킹배열[3]['class'] = ' class="best"'; ?>