= 5 and A.reg_date > date_add(now(),interval -30 day) and A.category < 3 order by uid desc"; $order_ft6 = "_1"; } else if($order == "tothit") { //조회수 $sqlWhere .= "order by A.total_hit DESC"; $order_ft2 = "_1"; } else if($order == "todayhit") { //조회수 $sqlWhere .= "order by A.today_hit DESC"; $order_ft3 = "_1"; } else if($order == "random") { //무작위 $sqlWhere .= "order by rand()"; $order_ft4 = "_1"; } else { //등록일 $sqlWhere .= "order by A.reg_date DESC"; $order_ft5 = "_1"; } if($searchword != "") { $searchword = str_replace("'","''",$searchword); //검색어 공백없이 검색할 수 있게함 $searchword = str_replace(' ','',$searchword); if($search_what ==2) { //작가명 검색 $sqlWhere = "and replace(A.member_nic,' ','') like '%$searchword%' "; } else if($search_what ==3) { //아이디 검색 $sqlWhere = "and replace(A.member_id,' ','') like '%$searchword%' "; } else { $sqlWhere = "and replace(A.name,' ','') like '%$searchword%' "; } $sqlWhere .= "and category < 3 "; $sqlWhere .= "order by reg_date desc "; } $Query = "select count(*) from $TB_NAME as A where A.serv='1' $sqlWhere"; $res = mysql_query($Query) or die(); $row = mysql_fetch_row($res) or die(); mysql_free_result($res); if ($cp == 0) $cp = 1; $ti = $row[0]; $lc = 35; //리스트 갯수 $url = $PHP_SELF."?category=$category&y_category=$y_category&tm1=$tm1&order=$order&writer=$writer&from=$from&AdminGood=$AdminGood&category_name=$category_name&searchword=$searchword&search_what=$search_what&y=$y&"; //== 페이징 URL $pgsel = new PageSelector(); $tp =$pgsel->GetTotalPages($ti, $lc, $cp, $limit_str); ?>
$searchword",$game_subject); $gameUrl = "/myflash/game_detail.html?game_id=$row[uid]&category=$category&y_category=$y_category&tm1=$tm1&order=$order&writer=$row[writer]&from=$from&searchword=$searchword&search_what=$search_what&ml=$row[member_lev]&wi=$row[writer_icon]&hc=$row[honor_cnt]&cp=$cp&p=$p"; $Gamehitnum = number_format($row[total_hit]); $Votenum = number_format($row[real_vote]); //실제추천수 $Votenum2 = $row[vote1]; //추천점수 $CommentCnt = $row[total_comment]; if($CommentCnt > 0) { $CommentCnt = "[".number_format($CommentCnt)."]"; } else { $CommentCnt = ""; } //작가 길드 표시 if($row[guild_name] != "") { $guild_name = "[".str_cutting($row[guild_name],16)."]"; } else { $guild_name = ""; } //작가 아이콘 표시 if($row[writer_icon] != "") { $game_writer = ""; //$game_writer = ""; } else { $game_writer = "".str_cutting($row[member_nic],14).""; } //작가 레벨 구하기 if($row[member_lev] > 0) { $writer_level = ""; } else { $writer_level = ""; } //명예의 전당 등록수 $star_icon = ""; if($row[honor_cnt] > 0) { //몫 구하기 //$division = (int)($row[honor_cnt]/10); //나머지구하기 //$remainder = $row[honor_cnt]%10; for($i =1 ; $i<=$row[honor_cnt]; $i++) { //$star_icon .= ""; $star_icon .= "\"명예의전당등록수"; if(!($i%10)) $star_icon .= "
"; } $star_icon .= "
"; } $cat = $row[category]; $d = $row[reg_date]; if( ( mktime()- strtotime($d) ) < $h*60*60 ){ $new = "  "; }else{ $new = ""; } $reg_date = substr($row[reg_date],5,5); if($today == $reg_date) { $reg_date = substr($row[reg_date],10,6); } else { $reg_date = substr($row[reg_date],2,8); } ?>
()
(으)로 검색한 검색 결과가 없습니다.

 
 
Write($tp, $cp, 10, $url, True, True);?>