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();
?>