include_once("./_common.php");
#######################################
#bbs ¹æÀÇ new.php¸¦ ¾à°£ ¼öÁ¤Çß½À´Ï´Ù.
#ÀÏÁ¤¼öÀÇ °Ô½Ã¹°ÀÌ ¾øÀ»¶§³ª ¾È »ÌÈ÷´Â ¹®Á¦..ư ¾à°£..¼öÁ¤µÊ.
#######################################
#Àϳâ¾È¿¡ ¾´±Û¿¡¼ ÃßÃâÇÕ´Ï´Ù.
#¸¸¾à ¿©±â¸¦ 7·Î ¹Ù²Ù¸é ÀÏÁÖÀϾȿ¡ µî·ÏµÈ ½Ä´çÀÌ´Ï ½Å±Ô
#½Ä´çÀ̳ª..¹¹..±×¸® ¹Ù²Ù¸é µÇÁö¾ÊÀ»±î..
#¹«Á¶°Ç »Ì¾Æ³»´Â..ÃÖ½Å±Û ½ºÅ¸ÀÏ ¸»°í...¹°·Ð Äõ¸®Çϸé¼
#Á¶°ÇÀ» Á൵ µÇ°ÚÁö¸¸..
//³¯Â¥¸¦ ¾Ë¾Æ³»±â À§ÇÔ.
$today = getdate();
$gong = "0";
$a_year = $today['year'];
$before_day =365; #µÚ·Î ¸çÄ¥ÀüºÎÅÍ ¾´±Û...¼öÁ¤é©:1;
$before_time = date("Y-m-d H:i:s", $g4[server_time] - (86400 * $before_day));
$start_day = "$a_year-01-01 00:00:00";
$end_day = "$a_year-12-31 23:59:59";
#######################################
#¼öÁ¤é©2:ÃßÃâÇÒ ±×·ì¸í......!!!
$gr_id = "club";
$NotSelectTable="'club_notice','club_qa','club_ad'";//Æ÷ÇÔ½ÃŰÁö ¾ÊÀ» °Ô½ÃÆÇ
#¼öÁ¤é©3:Ãßõ¼ö ºñÃßõ¼ö·Î ÇÏ³Ä È÷Æ®¼ö ¸®Çüö·Î ÇÏ³Ä ???
$hit_ro_ha_ja='YES';
?>
####################################### È÷Æ®¼øÀ̸é...!!!
if ($hit_ro_ha_ja=='YES'):
#######################################
############ 5°³¸¸ ÃßÃâÇÕ´Ï´Ù. ##############
$top1 = $top2 = 6; #¼öÁ¤é©2:ÃßÃâ ÇÒ ¼ýÀÚº¸´Ù 1°³´õ........!!!
$list1 = array(); reset($list1);
$list2 = array();reset($list2);
$list3 = array(); reset($list3);
$list4 = array();reset($list4);
#bo_table bo_notics ¸¦ º¸µåÁ¤º¸Å×À̺í ÇØ´ç±×·ì¸¸ ÃßÃâ
$sql = " select bo_table, bo_subject ,bo_notice from $g4[board_table]
where gr_id = '$gr_id'
and bo_table not in ($NotSelectTable)
";
$result = sql_query($sql);
while ($row = sql_fetch_array($result))
{ //°í³ð¿¡¼ ÀÏÁ¤±â°£³»¿¡ ¾´±ÛÀε¥ ÄÚ¸àÆ®¿Í È÷Æ®¿¡¼
//ÄÚ¸àÆ®°Å³ª È÷Æ®¿¡¼ ÀÏÁ¤±â°£³»ÀÇ ±Û·Î ÇÔ...2005.10.25
$sql2 = " select * from $g4[write_prefix]$row[bo_table]
where ((wr_comment > -1 or wr_datetime) and (wr_datetime >= '$start_day' or wr_datetime <= '$end_day')) ";
$result2 = sql_query($sql2);
while ($row2 = sql_fetch_array($result2))
{ $key = $row2[wr_datetime]. '-' . $row2[wr_id];
if($row2[wr_subject]){
$list1[$key][bo_subject] = conv_subject($row[bo_subject],20,'¡¦' );
$list1[$key][subject] = conv_subject($row2[wr_subject],26,'¡¦');
$list1[$key][ca_name] = $row2[ca_name];
// $list1[$key][href] = "../new/print_list2.php?bo_table=$row[bo_table]&wr_id=$row2[wr_id]&sca=$row2[ca_name]";
$list1[$key][href] = "../club/club_main.php?botable=1&cb_id=$row[bo_table]&wr_id=$row2[wr_id]&sca=$row2[ca_name]";
$list1[$key][bo_table] = $row[bo_table];
$list1[$key][wr_id] = $row2[wr_id];
$list1[$key][is_notice] = preg_match("/[^0-9]{0,1}{$row2[wr_id]}[\r]{0,1}/",$row[bo_notice]);
$list1[$key][wr_datetime] = $row2[wr_datetime];
$list1[$key][datetime] = "($row2[wr_datetime])";
$list1[$key][mb_id] = "$row2[mb_id]";
$list1[$key][wr_name] = "$row2[wr_name]";
######################################
$key = substr('00000'.$row2[wr_hit],-5) . '-' . $row2[wr_id];
$list2[$key][bo_subject] = conv_subject($row[bo_subject],20,'¡¦' );
$list2[$key][subject] = conv_subject($row2[wr_subject],30,'¡¦');
$list2[$key][ca_name] = $row2[ca_name];
// $list2[$key][href] = "../new/print_list2.php?bo_table=$row[bo_table]&wr_id=$row2[wr_id]&sca=$row2[ca_name]";
$list1[$key][href] = "../club/club_main.php?botable=1&cb_id=$row[bo_table]&wr_id=$row2[wr_id]&sca=$row2[ca_name]";
$list2[$key][bo_table] = $row[bo_table];
$list2[$key][wr_id] = $row2[wr_id];
$list2[$key][is_notice] = preg_match("/[^0-9]{0,1}{$row2[wr_id]}[\r]{0,1}/",$row[bo_notice]);
$list2[$key][wr_hit] = $row2[wr_hit];
$list2[$key][hit] = "($row2[wr_hit])";
$list2[$key][mb_id] = "$row2[mb_id]";
$list2[$key][wr_name] = "$row2[wr_name]";
}//if
} //while
}
$list3 = $list1;
$list4 = $list2;
@krsort($list1);
@krsort($list2);
@ksort($list3);
@ksort($list4);
$latest_skin_path = "$g4[path]/skin/latest/basic";
?>
|
|
/skin/latest/club_latest/img/board_icon1.gif width=16 height=9> Ŭ·´ÃÖ½Å±Û |
|
|
|
|
endif; ?>
|