0 && $category < 7) { $isThumb = true; $sqlWhere .= "and A.category = '$category' and A.thumb != ''"; } else if($category == 7) { $sqlWhere .= "and (A.category = 7)"; } else { $sqlWhere .= "and (A.category < 8)"; } if($writer) { $sqlWhere .= "and A.member_id = '$writer' "; } if($order == "ranking") { //별점순 //$sqlWhere .= "order by assess_score/assess_applicant desc"; $sqlWhere .= "order by A.real_vote desc,A.total_hit desc"; $order_ft1 = "_1"; } else if($order == "week") { //주간베스트 //$sqlWhere .= "and A.reg_date > date_add(now(),interval -7 day) order by A.real_vote desc ,A.total_hit desc"; $sqlWhere .= "and real_vote >= 5 and A.reg_date > date_add(now(),interval -30 day) order by uid desc"; $order_ft6 = "_1"; } else if($order == "best") { //추천 //$sqlWhere .= "and A.reg_date > date_add(now(),interval -7 day) order by A.real_vote desc ,A.total_hit desc"; $sqlWhere .= "and A.thumb != '' 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 A.category < 10 "; $sqlWhere .= "order by reg_date desc "; } $Query = "select count(uid) from flashgame_illust 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 = 30; //리스트 갯수 $url = $PHP_SELF."?category=$category&tm1=$tm1&order=$order&writer=$writer&from=$from&AdminGood=$AdminGood&category_name=$category_name&searchword=$searchword&search_what=$search_what&"; //== 페이징 URL $pgsel = new PageSelector(); $tp =$pgsel->GetTotalPages($ti, $lc, $cp, $limit_str); ?>
$searchword",$game_subject); $gameUrl = "/illust/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 = ""; } else { $game_writer = "".str_cutting($row[member_nic],14).""; } //작가 레벨 구하기 if($row[member_lev] > 0) { $writer_level = ""; } else { $writer_level = ""; } if(isSheriff($row[member_id])) { $game_writer = "".$game_writer; } //명예의 전당 등록수 $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 = "  "; $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);?>