ob_start("ob_gzhandler"); ?>
include("header.html"); ?>
$menu = "search"; ?>
$game_category = array("선택","인물","판타지","메카닉","배경","게임","손그림","강좌","------------","------------","-----------","일상","개그","판타지","액션","드라마","감성","공포");
?>
$top_title_img = "title17.gif";
?>
$category = mysql_real_escape_string($category);
$writer = mysql_real_escape_string($writer);
$tm1 = mysql_real_escape_string($tm1);
$order = mysql_real_escape_string($order);
$searchword = mysql_real_escape_string($searchword);
$TB_NAME = "flashgame_illust";
$today = date("m-d");
$isThumb = false;
if($category > 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);
?>
include("$DOCUMENT_ROOT/ongame/banner/game_top.html"); ?>
|
|
include("$DOCUMENT_ROOT/include/static_html/illust/best_illust.html"); ?>
$h = 48; //3일간
// $Query = "select A.uid,A.name,A.total_hit,A.total_comment,A.reg_date,A.real_vote,A.vote1,A.thumb,B.member_id,B.member_nic,B.writer_icon,B.honor_cnt,B.member_lev,B.guild_name,C.serv from $TB_NAME as A LEFT JOIN myflash_writer B on A.member_id=B.member_id LEFT JOIN alert_member C on A.member_id=C.user_id where A.serv='1' $sqlWhere $limit_str";
$Query = "select A.uid,A.name,A.total_hit,A.total_comment,A.reg_date,A.real_vote,A.vote1,A.thumb,A.category,B.member_id,B.member_nic,B.writer_icon,B.honor_cnt,B.member_lev,B.guild_name from $TB_NAME as A LEFT JOIN myflash_writer B on A.member_id=B.member_id where A.serv='1' $sqlWhere $limit_str";
$res = mysql_query($Query) or die();
$cnt =1;
while($row = mysql_fetch_array($res)) {
$game_subject = stripslashes($row[1]);
$game_thumb = $row[thumb];
$game_subject = str_replace("$searchword","$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);
}
?>
|
|
$cnt++;?>
} ?>
if($cnt == 1) { ?>
if($searchword != "") { ?>=$searchword?>(으)로 검색한 }?>검색 결과가 없습니다.
|
|
|
} else {?>
|
|
$pgsel->Write($tp, $cp, 10, $url, True, True);?>
|
|
} ?>
include("footer.html"); ?>
include("$DOCUMENT_ROOT/ad_new/joins_fadein.html");?>