0 and $ftype==subj) $email = eregi_replace("($keyword)", "$keyword", $row[email]); else $email=$row[email]; if(strlen($keyword)>0 and $ftype==cont) $title = eregi_replace("($keyword)", "$keyword", $row[title]); else $title=$row[title]; if(strlen($keyword)>0 and $ftype==name) $homeurl = eregi_replace("($keyword)", "$keyword", $row[homeurl]); else $homeurl=$row[homeurl]; //À§ÀÇ ¸ñ·Ï±Û ÀÚ¸£±â¸¦ ÁÖ¼®Ã³¸®ÇÏ°í ´ëȸ¸é ´Þ¸°Àå¼Ò¿¡ ´ëȸ¸íÀÌ, ¾Æ´Ï¸é ´Þ¸°Àå¼Ò°¡ Ãâ·Â if($row[reply_sel]==n and $row[read_only]==g and isset($row[homeurl])) $title="$homeurl"; elseif($row[reply_sel]==n and $row[read_only]==b and isset($row[homeurl])) $title="$homeurl"; elseif($row[reply_sel]==n and $row[read_only]==c and isset($row[homeurl])) $title="$homeurl"; elseif($row[reply_sel]==n and $row[read_only]==d and isset($row[homeurl])) $title="$homeurl"; elseif($row[reply_sel]==n and $row[read_only]==e and isset($row[homeurl])) $title="$homeurl"; elseif($row[reply_sel]==n and $row[read_only]==f and isset($row[homeurl])) $title="$homeurl"; else $title=$title; //¸ñ·Ï±Û¿¡ ¾²·¹µå À̹ÌÁö ³Ö°í ¸µÅ©°É±â include("../../inc_file/list/titlelink.php"); //Àǰߴޱ⠰³¼ö ±¸Çϱâ include("../../inc_file/list/opinion.php"); if($row[read_only]==d and $row[reply_sel]==n and $row[sub1]<=2) $sub_3=""; //±×¸®µ¥ÀÌ¼Ç ±¸ÇöºÎ ½ÃÀÛ if($ag_color=="0x000000") $my_color=$atb_color; else {$my_color=$my_color; $my_color=dechex($my_color-$ag_color);} echo "\n"; //üũ¹Ú½º¸¦ »ç¿ëÇÒ °ÍÀΰ¡ ¸» °ÍÀΰ¡ °áÁ¤ if($check_box==a) echo "\n"; //¸®½ºÆ®¸¦ ¼±Åà Ãâ·ÂÇϱâ(d_main°ú d_depÀº view.html¿¡¼­ ³Ñ¾î¿Â °ª),±Û ¹øÈ£¿Í ¼±Åà À̹ÌÁö Ãâ·Â if($no_no==a && $row[main_no]==$d_main && $row[dep_no]==$d_dep) echo "\n"; elseif($no_no==a) echo "$sub_3 $no\n"; //´Þ±â±âÇÑ ³¯Â¥¸¦ Ãâ·ÂÇÑ´Ù(emailº¯¼ö¿¡ ÀúÀå). echo "$sub_3 $email\n"; //´Þ¸°Àå¼Ò¸¦ Ãâ·ÂÇÑ´Ù.(titleº¯¼ö »ç¿ë) //if($row[homeurl]) $title="$title"; echo "$title $count_opp\n"; //´Þ¸°°Å¸®¸¦ Ãâ·ÂÇÑ´Ù.(º¯¼ö link1¸¦ »ç¿ëÇß´Ù.) echo "$sub_3 $row[link1] km\n"; //´Þ¸°½Ã°£À» Ãâ·ÂÇÑ´Ù.(½Ã-sub1, ºÐ-sub2, ÃÊ-sub3) echo "$sub_3 $row[sub1]:$row[sub2]:$row[sub3]\n"; //³¯¾¾¸¦ Ãâ·ÂÇÑ´Ù.(º¯¼ö link2¸¦ »ç¿ëÇß´Ù.) echo "$sub_3 $row[link2]\n"; //ÄÁµð¼ÇÀ» Ãâ·ÂÇÑ´Ù. (º¯¼ö link3¸¦ »ç¿ëÇß´Ù.) echo "$sub_3 $row[link3]\n"; //´ëȸ¿©ºÎ¸¦ Ãâ·ÂÇÑ´Ù.(reply_selÀÌ yÀ̸é 'ÈÆ·Ã'À», nÀ̸é '$read_only¸¦ Á¶°Ç¿¡ ¸Â°Ô Ãâ·Â if($row[reply_sel]==n) { if($row[read_only]==g) $game="5k"; elseif($row[read_only]==b) $game="10km"; elseif($row[read_only]==c) $game="HALF"; elseif($row[read_only]==d) $game="FULL"; elseif($row[read_only]==e) $game="¿ïÆ®¶ó"; elseif($row[read_only]==f) $game="±âŸ"; } else $game="ÈÆ·Ã"; echo "$sub_3 $game\n"; echo "\n"; //±×¶óµ¥ÀÌ¼Ç ±¸ÇöºÎ ³¡ $my_color=hexdec($my_color); return ($file_type); } // ========================================================ÇÔ¼ö µî·Ï ºÎ //db·ÎºÎÅÍ µ¥ÀÌŸ¸¦ ºÒ·¯¿Í¼­ °¡°øÃ³¸® //³ªÁß Àüü³»¿ë º¸±â¸¦ ÇϱâÀ§ÇØ º¯¼ö·Î ó¸®ÇÑ ºÎºÐ if($id) $id_ex = "and id='$id'"; //ÈÆ·Ã³»¿ë°ú ´ëȸ³»¿ëÀ» ºÐ·ùÇØ¼­ Ãâ·ÂÇϱâÀ§ÇÑ Á¶°Ç¹® if($reply_sel==y) $repl_ex="and reply_sel='y'"; elseif($reply_sel==n) {$repl_ex="and reply_sel='n'"; $arr="read_only,";} //°Ô½Ã¹° ¸ñ·Ï °¡Á®¿À±â if(strlen($keyword) > 0) { switch ($ftype) { case "subj": $colm = email; break; case "cont": $colm = title; break; case "name": $colm = homeurl; break; } $sql="select * from $board where code = '$code' and main_no>0 and add_no =0 $id_ex and $colm like '%$keyword%' order by email desc, main_no desc, dep_no desc"; } else $sql= "select * from $board where code = '$code' and add_no=0 and main_no>0 $id_ex $repl_ex order by $arr email desc, main_no desc, dep_no desc"; //¾Æ·¡ sql¹®Àº °øÁö±ÛÀ» ¼±Åà Ãâ·ÂÇϱâ À§ÇØ ÀÛ¼ºÇÑ °ÍÀÌ´Ù. $sql_notice= "select * from $board where code = '$code' and add_no=0 and main_no<0 $id_ex $repl_ex order by main_no desc, dep_no desc"; $result_notice = mysql_query($sql_notice); $result = mysql_query($sql); //$colm =""; //ÇÑÈ­¸é¿¡ Ãâ·ÂÇÒ ÁÙ ¼ö $rows = $a_rows; //ÇÑ È­¸é¿¡ Ãâ·ÂÇÒ ÆäÀÌÁö ¼ö $page_scale = $a_page; // Àüü±Û ¸ñ·Ï ¼ö $count = mysql_num_rows($result); //=======7ÀÏ,30ÀÏ,Àüü, Á¾¸ñº°´Þ¸®±âÀÇ ÃÑ´Þ¸°°Å¸®¿Í ´Þ¸°½Ã°£ µîÀ» »Ì±âÀ§ÇÑ ÇÔ¼ö====== function reco($check_date,$read_only) { global $code, $id, $board, $id_ex, $repl_ex, $colm, $keyword; if($check_date==100000) { $sql="select * from $board where code = '$code' and main_no>0 and add_no =0 $id_ex and $colm like '%$keyword%' order by email desc, main_no desc, dep_no desc"; } else { if($read_only==h) $read_on=""; //read_only=hÀ̸é ÈÆ·Ã³»¿ë¸¸ else $read_on="and read_only='$read_only'"; //read_only°¡ ±×¿Ü °ªÀ» °¡Áö¸é °ª¿¡ µû¶ó Äõ¸® $sql= "select * from $board where code = '$code' and add_no=0 and main_no>0 $id_ex $repl_ex $read_on and DATE_SUB(CURDATE(),INTERVAL $check_date DAY) <= email order by read_only, sub1 desc, sub2 desc, sub3 desc, main_no desc, dep_no desc"; } $result = mysql_query($sql); $line = 0; $total_distance = 0; $total_time = 0; $count = mysql_num_rows($result); while($rowr = mysql_fetch_array($result)) { $total_distance = $total_distance+$rowr[link1]; $total_time = $total_time+$rowr[sub1]+$rowr[sub2]/60+$rowr[sub3]/3600; if($read_only==h) $best_record="00:00:00"; else $best_record = "$rowr[sub1]:$rowr[sub2]:$rowr[sub3]"; //´ëȸ±â·Ï¿¡¼­ ¸¶Áö¸· ·¹Äڵ尡 ÃÖ°í±â·Ï if(++$line==$count) break; } if($rowr) { $total_hour=floor($total_time); //¼ø¼öÇÑ Àüü½Ã°£À» ±¸ÇÑ´Ù. $total_minute=($total_time-$total_hour)*60; //³ª¸ÓÁö ºÐÀ» ±¸ÇÑ´Ù. $total_minute=floor($total_minute); //¼Ò¼öÁ¡ ÀÌÇÏ´Â ÀÚ¸¥´Ù. $ave_distance=$total_distance/$total_time; //Æò±Õ¼Óµµ¸¦ ±¸ÇÑ´Ù. $ave_distance = number_format($ave_distance,2); //¼Ò¼öÁ¡ 2ÀÚ¸®±îÁö¸¸ Ç¥Çö $total_distance=number_format($total_distance,0); //°Å¸®¸¦ °¡°ø mysql_data_seek($result,0); //À§ ÀÛ¾÷ÀÌ ³¡³µÀ¸¸é Æ÷ÀÎÅ͸¦ óÀ½ÀÇ À§Ä¡·Î º¸³½´Ù. } else { $total_distance=0; $total_hour=0; $total_minute=0; $ave_distance=0; $best_record="00:00:00"; } //ÇÔ¼ö°¡ ºÒ·¯Áø °÷¿¡ Ãâ·Â echo "

  $count  

  $total_distance  

  $total_hour ½Ã $total_minute ºÐ  

  $ave_distance  

  $best_record  

\n"; } //========ÇÔ¼ö ³¡============= // ÇöÀç º¸¿©ÁÖ´Â ÆäÀÌÁö¹øÈ£ if (empty($page)) $page = 1; // ÇöÀç ÆäÀÌÁö¿¡ µû¸¥ º¸¿©ÁÙ °Ô½Ã¹°ÀÇ Ã¹ À§Ä¡ $start=($page-1)*$rows; // °á°ú Áß¿¡¼­ ÇöÀç ÆäÀÌÁöÀÇ Ã¹¹øÂ° ·¹ÄÚµå¼ÂÀ¸·Î À̵¿ÇÑ´Ù. if ($start > 1) mysql_data_seek($result,$start); // ÃÑ ÆäÀÌÁö¼ö $total = ceil(($count)/$rows); //°Ô½ÃÆÇ Á¦¸ñ°ú Ä«¿îÅ͸¦ ´ã°í ÀÖÀ½--htmlÀ̹ǷΠº»ÀÎÀÇ ±¸¹Ì¿¡ ¸Â°Ô ¼öÁ¤ °¡´É ?>
0 and $count>0) $special_condi="    Æ¯Á¤Á¶°Ç : $keyword"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; ?>
color=>
0 and $count>0) {?>
| Àüü³»¿ë | ÈÆ·Ã³»¿ë | ´ëȸ³»¿ë |                    ¢Æ ´ëȸ³»¿ëº¸±â"; elseif($reply_sel==y) echo "ÈÆ·Ã³»¿ëº¸±â"; else echo "Àüü³»¿ëº¸±â";?> ¢Æ
 ´Þ¸²È½¼öÃѰŸ®(km)Ãѽð£(h)Æò±Õ¼Óµµ(km/h)ÃÖ°í±â·Ï
5Km
10Km
HALF
FULL
¿ïÆ®¶ó
±â Ÿ
Àü ü
7Àϰ£
30Àϰ£
Àü ü
ƯÁ¤Á¶°Ç
 
$special_condi ÃÑ °Ô½Ã¹°: $count, ÆäÀÌÁö: $page/$total  "; if($a_ccode==a) { echo "¿À´Ã: $counter->count_today, Àüü:$counter->count_total"; } echo "  
CELLSPACING=0 CELLPADDING=>
cellpadding=2 border=0 width=100% class=outline> height=25>  \n"; if($no_no==a) echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; ?>
¹øÈ£´Þ¸°³¯Â¥´Þ¸°Àå¼Ò °Å ¸®½Ã °£³¯ ¾¾ÄÁµð¼Ç´ëȸ¿©ºÎ
";} ?>

>