printError('404'); include "../global/global.inc.php"; include "../global/template.inc.php"; include "../global/main.inc.php"; echo " \n"; return; db_connect(); if (!login_status()) $GLOBAL_VAR[ON_LOAD] = "document.login_form.loginid.focus()"; tp_read(); include "../script/include/index0.inc.php"; include "../script/include/index-common.inc.php"; //검색어 등록 searchlog($search, 1); /* $query = "select * from game_tb where g_name = '$search'"; $result = db_query($query); $game_rows = db_num_rows($result); //if (db_num_rows($result) <= 0) // ErrorMsg("해당 게임정보를 찾을수가 없습니다"); */ // 상단 검색창 부분 tp_set_array(array( "SEARCH" => $search, "SEARCHMODE" => $searchmode, "STARTDATE" => $startdate, "ENDDATE" => $enddate, "TYPE" => $type, "GROUP" => $group, "PAGE" => $page )); if ($type == "" || $type == 0) $type = 1; $type_check[$type] = "checked"; tp_set_array(array( "TYPE_CHECK1" => $type_check[1], "TYPE_CHECK2" => $type_check[2], "TYPE_CHECK3" => $type_check[3], "TYPE_CHECK4" => $type_check[4] )); //게임명 찾기 시작 $query = "select * from game_tb where g_name = '$search' or g_tigkeyword like '%$search%'"; $result = db_query($query); if(db_num_rows($result)) { $row = db_fetch_array($result); $g_data = $row[g_id]; } $template = "guide"; tp_start_dynamic($template); if(!$row[g_usercount]) $starpoint = 0; else $starpoint = sprintf("%.1f", $row[g_starpoint]/$row[g_usercount]); $row[g_homepage] = (ereg("http://", $row[g_homepage])) ? $row[g_homepage] : "http://".$row[g_homepage]; $g_category = explode("|", $row[g_category]); for($i=1;$i 0 && $row[g_servicetype] > 0) { if (is_file("../webdata/gameinfo/$row[g_image1]")) $image = $row[g_image1]; else $image = "space.gif"; tp_set_dynamic_array($template, array( "GID" => $row[g_id], "GAMENAME" => $row[g_name], "GAME_CATEGORY" => $row[g_category], "DEVELOP" => find_vendor($row[g_develop]), "VENDER" => find_vendor($row[g_vender]), "GAME_SERVICETYPE" => $servicetype_array[$row[g_servicetype]], "SERVICE_DATE" => $row[g_servicedate], "HOMEPAGE" => $row[g_homepage], "STARPOINT" => $starpoint, "STARIMG" => mark_star($starpoint), "TOPIMG" => $row[g_image1] )); tp_parse_dynamic($template); } tp_end_dynamic($template); $category_array = array("", "101,2424", "102,702,712,1101,1802,2425,115,711,1101,4002,103,407,712,2426,110,111,112,113,8001,8002,8003,8004,8005,8006,8007,8008,8009,8010,8011,8012,8013,8014,2701", "105,106,203,302,306,308,401,405,406,2439,1906,2502", "403,408,508,5001,307", "104,501,502,503,504,505,506,507", "404,410,305" ); $dateformat_array = array("", "%m.%d %H : %i", "%m.%d", "%m.%d", "%m.%d", "%m.%d"); switch($type) { case 1: break; case 2: $search_query = " and b_firstdeskdate >= '". date("Y-m-d 00:00:00", strtotime("-7 days")) . "'"; break; case 3: $search_query = " and b_firstdeskdate >= '". date("Y-m-d 00:00:00", strtotime("-30 days")) . "'"; break; case 4: $str_startdate = strtotime($startdate); $str_enddate = strtotime($enddate); if ($str_startdate == -1 || $str_enddate == -1) ErrorMsg("입력한 날짜형식이 정확하지 않습니다"); $search_query = " and b_firstdeskdate >= '".date("Y-m-d 00:00:00", $str_startdate)."' and b_firstdeskdate <= '".date("Y-m-d 23:59:59", $str_enddate)."'"; } if(!$searchmode) $searchmode="b_title"; if($searchmode == "b_title") { $tmp_search = explode(" ", $search); for($j=0;$j 0) //{ // $where_query = " b_category in (".$category_array[$j].") and b_status <= $GLOBAL_VAR[status_complete] and b_game = $game_row[g_id] "; //} if($j == 3) $where_query = " b_status = 0 "; else if($j == 4) $where_query = " b_movieflag = 1 and b_status in (0,2) "; else $where_query = " b_category in (".$category_array[$j].") and b_status in (0,2) "; { $query = "select count(*) from board_0 a, boardview_0 b where a.b_id=b.bv_board and $where_query $search_query and ({$search_query1} {$search_query2})"; // echo $query; $result = db_query($query); $total_rows = db_result($result); $query = "select b_id, b_category, b_subcategory, b_title, bv_content, date_format(b_date, '".$dateformat_array[$j]."') as b_date, b_img2 from board_0 a, boardview_0 b where a.b_id = b.bv_board and $where_query $search_query and ({$search_query1} {$search_query2}) order by b_idx, b_main, b_sub LIMIT 5"; // if($_SESSION[login_loginid] == "dapang") echo $query; $result = db_query($query); // if($_SESSION[login_loginid] == "dapang") echo $query."
"; $rows = db_num_rows($result); for($i = 0; $i < $rows; $i++) { $row = db_fetch_array($result); if (is_file("../board/files/thumnail/$row[b_img2]")) $image = $row[b_img2]; else $image = "space.gif"; tp_set_dynamic_array($template, array( "ID" => $row[b_id], "TITLE" => str_cut($row[b_title], 60), "DATE" => $row[b_date], "CATEGORY" => $row[b_category], "IMG" => $image )); tp_parse_dynamic($template); } } tp_end_dynamic($template); tp_set("TOTAL_COUNT$j", $total_rows); } html_header("main"); tp_print(); html_tail(); ?>