포인트랭킹에서 관리자를 제외하고 싶습니다. 채택완료

</p><p><? </p><p>function sh_point_ranking($기간 = "30", $랭킹명수 = "10", $가입얼마이후 = "30") {</p><p>global $g5, $config;</p><p>/*</p><p>필요한 변수 셋팅</p><p>$기간 = 30; // 최근 며칠간 포인트 적립을 구할것이냐.</p><p>$랭킹명수 = 10; // 몇명이나?</p><p>*/</p><p>$회원가입얼마이후 = mktime(0, 0, 0, date("m"), date("d")-$가입얼마이후, date("Y"));</p><p>$회원가입얼마이후 = date("Y-m-d H:i:s",$회원가입얼마이후);</p><p>$선택기간 = mktime(0, 0, 0, date("m")  , date("d")-$기간, date("Y"));</p><p>$선택기간 = date("Y-m-d H:i:s",$선택기간);</p><p>$sql =</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>"SELECT a.s_point, a.mb_id, {$g5['member_table']}.mb_nick </p><p><span class="Apple-tab-span" style="white-space:pre">	</span> FROM (SELECT sum(po_point) as s_point, mb_id  FROM `g5_point` WHERE po_datetime >= '{$선택기간}' GROUP BY mb_id ORDER BY s_point DESC)a</p><p><span class="Apple-tab-span" style="white-space:pre">	</span> LEFT JOIN {$g5['member_table']} using(mb_id) WHERE {$g5['member_table']}.mb_datetime <= '{$회원가입얼마이후}'  and {$g5['member_table']}.mb_id <> 'admin' LIMIT 0, {$랭킹명수}";</p><p>$result = sql_query($sql);</p><p>$temp_config = $config['cf_use_member_icon'];</p><p>unset($config['cf_use_member_icon']);</p><p>for ($i=1; $row=sql_fetch_array($result); $i++) {</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>$랭킹배열[$i]['name'] = get_sideview($row['mb_id'], $row['mb_nick']);</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>$랭킹배열[$i]['point'] = number_format($row['s_point']);</p><p>}</p><p>$config['cf_use_member_icon'] = $temp;</p><p>$랭킹배열[1]['class'] = ' class="best"';</p><p>$랭킹배열[2]['class'] = ' class="best"';</p><p>$랭킹배열[3]['class'] = ' class="best"';</p><p>?></p><p> </p><p><script type="text/javascript" src="<?=$g5['path']?>/js/sideview.js"></script></p><p><style type="text/css"></p><p>/* UI Object */</p><p>.section_ol{position:relative;border:1px solid #ddd;background:#fff;font-size:12px;font-family:Tahoma, Geneva, sans-serif;line-height:normal;*zoom:1}</p><p>.section_ol a{color:#666;text-decoration:none}</p><p>.section_ol a:hover,</p><p>.section_ol a:active,</p><p>.section_ol a:focus{text-decoration:underline}</p><p>.section_ol em{font-style:normal}</p><p>.section_ol h2{margin:0;padding:10px 0 8px 13px;border-bottom:1px solid #ddd;font-size:12px;color:#333}</p><p>.section_ol h2 em{color:#cf3292}</p><p>.section_ol ol{margin:13px;padding:0;list-style:none}</p><p>.section_ol li{position:relative;margin:0 0 10px 0;*zoom:1}</p><p>.section_ol li:after{display:block;clear:both;content:""}</p><p>.section_ol li .ranking{display:inline-block;width:14px;height:11px;margin:0 5px 0 0;border-top:1px solid #fff;border-bottom:1px solid #d1d1d1;background:#d1d1d1;text-align:center;vertical-align:top;font:bold 10px Tahoma;color:#fff}</p><p>.section_ol li.best .ranking{border-bottom:1px solid #6e87a5;background:#6e87a5}</p><p>.section_ol li.best a{color:#7189a7}</p><p>.section_ol li .num{position:absolute;top:0;right:0;font-size:11px;color:#a8a8a8;white-space:nowrap}</p><p>.section_ol li.best .num{font-weight:bold;color:#7189a7}</p><p>.section_ol .more{position:absolute;top:10px;right:13px;font:11px Dotum, 돋움;text-decoration:none !important}</p><p>.section_ol .more span{margin:0 2px 0 0;font-weight:bold;font-size:16px;color:#d76ea9;vertical-align:middle}</p><p>/* //UI Object */</p><p></style></p><p><!-- UI Object --></p><p><div class="section_ol"></p><p><span class="Apple-tab-span" style="white-space:pre">	</span><h2>최근 <?=$기간?>일간 <em>포인트 랭킹</em></h2></p><p><span class="Apple-tab-span" style="white-space:pre">	</span><ol></p><p><? for ($i=1; $i <= $랭킹명수; $i++) { ?></p><p><span class="Apple-tab-span" style="white-space:pre">	</span><li <?=$랭킹배열[$i]['class']?>><span class="ranking"><?=$i?></span><?=$랭킹배열[$i]['name']?><span class="num"><?=$랭킹배열[$i]['point']?>점</span></li></p><p><? } ?></p><p><span class="Apple-tab-span" style="white-space:pre">	</span></ol></p><p><span class="Apple-tab-span" style="white-space:pre">	</span><!--span class="more"><?=$기간?>일간 누적</span--></p><p></div></p><p><!-- //UI Object --></p><p><?</p><p>} // end function</p><p>?></p><p>