=30 and A.subject=B.no and B.comix_type!='W' order by A.score desc, A.number_comment desc limit ".(($page-1)*$comix_per_page).", $comix_per_page"; $page_title="다수가 인정하는 만화 TOP 100"; $page_description="30명 이상 참여한 만화 중 평점 베스트"; $print_type="score"; break; case 'minor' : $query="SELECT A.subject, A.score, A.number_comment FROM zetyx_board_score as A, comics as B where A.number_comment>=15 and A.number_comment<30 and A.subject=B.no and B.comix_type!='W' order by A.score desc, A.number_comment desc limit ".(($page-1)*$comix_per_page).", $comix_per_page"; $page_title="소수가 권하는 만화 TOP 100"; $page_description="15명 이상, 30명 미만이 참여한 만화 중 평점 베스트"; $print_type="score"; break; case 'sale1' : $query="select comicno, count(no) as number_cnt, sum(cnt) as sum from sojanglist where comicno>0 group by comicno order by sum desc limit ".(($page-1)*$comix_per_page).", $comix_per_page"; $page_title="많이 판매된 만화 TOP 100"; $page_description="소장만화에 등록된 만화 중 판매량 베스트"; $print_type="sale"; break; case 'sale2' : $query="select comicno, count(no) as number_cnt, sum(cnt) as sum from sojanglist where comicno>0 group by comicno order by number_cnt desc limit ".(($page-1)*$comix_per_page).", $comix_per_page"; $page_title="많은 사람에게 판매된 만화 TOP 100"; $page_description="많은 회원이 소장한 베스트"; $print_type="sale"; break; } if($type=='web') $query="SELECT A.subject, A.score, A.number_comment FROM zetyx_board_score as A, comics as B where A.number_comment>=5 and A.subject=B.no and B.comix_type!='D' order by A.score desc, A.number_comment desc limit ".(($page-1)*$comix_per_page).", $comix_per_page"; else if($type=='hit') $query="SELECT comic_no,count(no) as cnt FROM hit_comics WHERE UNIX_TIMESTAMP(now())-register_time<604800 group by comic_no order by cnt desc limit ".(($page-1)*$comix_per_page).", $comix_per_page"; else if($type=='iphone') $query="SELECT comic_no,count(no) as cnt FROM hit_comics WHERE UNIX_TIMESTAMP(now())-register_time<604800 and mobileID!='' group by comic_no order by cnt desc limit ".(($page-1)*$comix_per_page).", $comix_per_page"; printHeader("desktop",$page_title,$page_description,"","","rank.php?type=$type"); printHeader("mobile",$page_title,$page_description,"","","rank.php?type=$type"); ?>