conn; //--------------------------------------------------------------------- // 게시판 ID 목록 //--------------------------------------------------------------------- $BoardID = array( "cimerrnewsletter", "conference", "forum", "free", "hottopics", "iemagazine", "news", "newsclipping", "newsletter", "newtrends", "notice", "post", "postscript", "qna", "research", "seminar", "seminar1", ); //--------------------------------------------------------------------- // 목록의 댓글 길이, 제목 길이 //--------------------------------------------------------------------- $CommentLen = 60; $TitleLen = 60; // 문자열 끊기 (이상의 길이일때는 ... 로 표시) function cut_str($msg,$cut_size) { if($cut_size<=0) return $msg; if(ereg("\[re\]",$msg)) $cut_size=$cut_size+4; for($i=0;$i<$cut_size;$i++) if(ord($msg[$i])>127) $han++; else $eng++; $cut_size=$cut_size+(int)$han*0.6; $point=1; for ($i=0;$i$cut_size) return $pointtmp."..."; if (ord($msg[$i])<=127) { $pointtmp.= $msg[$i]; if ($point%$cut_size==0) return $pointtmp."..."; } else { if ($point%$cut_size==0) return $pointtmp."..."; $pointtmp.=$msg[$i].$msg[++$i]; $point++; } $point++; } return $pointtmp; } ################################################################################ // 엔빌더 게시판 목록 $q = " SELECT ba.ba_boardid, ba.ba_title, ba.ba_perm, ba.ba_adminid, cl.cl_name FROM tb_iboard_admin ba, tb_club_list cl WHERE ba.ba_adminid=cl.cl_id ORDER BY ba.ba_title LIMIT 1000 "; //echo $q . "
"; $db->parseExec($q); $db->fetchStatement(&$ba); $ba_cnt = $db->rowCount(); $db->parseFree(); for( $BC = 0; $BC < sizeof($BoardID); $BC++ ) { if ($BoardID[$BC] == 'conference') { $db_prefix = 'conference'; } else { $db_prefix = 'board'; } // if() $q = "select title from ".$db_prefix.".zetyx_admin_table where name = '" . $BoardID[$BC] ."'"; $BoardTitle[$BC] = db_get_one($q); if ($BoardTitle[$BC] != '') { $BoardTitle[$BC] = str_replace('테크노경영연구정보센터(CIMERR) / ', '', $BoardTitle[$BC]); } else { $BoardTitle[$BC] = $BoardID[$BC]; } // if() } ?>
1 "; $mileage_plus = db_get_one($Query); $Query = " select sum(p_point) from tb_point where mb_id='".$UnameSess."' and p_point < 0 "; $mileage_minus = db_get_one($Query); $query = "SELECT balance FROM " . MEMBER . " WHERE username='$UnameSess'"; $balance = db_get_one($query); $Query = " select sum(p_point) from tb_balance where mb_id='".$UnameSess."' and p_point > 1 "; $balance_plus = db_get_one($Query); $Query = " select sum(p_point) from tb_balance where mb_id='".$UnameSess."' and p_point < 0 "; $balance_minus = db_get_one($Query); ?> 회원님
    가용포인트: point (총적립: point, 총사용: point)

    가용예치금: 원 (총적립: 원, 총사용: 원)
 
 
 
마일리지 제도
   
- 적립내역(최근 5회)
  1 order by p_regdate desc, p_point_total desc limit 5 "; $Member = db_get_rows($Query); for ( $Count = 0; $Count < sizeof($Member); $Count++ ) { ?>
적립내용 적립 포인트 처리날짜
   
- 사용내역(최근 5회)
 
적립내용 차감 포인트 처리날짜
   
   
예치금
 
- 적립내역(최근 5회)
  "입금", "REFUND" => "환불", "COPY" => "원문복사", ); $Query = " select * from tb_balance where mb_id='".$UnameSess."' and p_point > 1 order by p_regdate desc, p_point_total desc limit 5 "; $Member = db_get_rows($Query); for ( $Count = 0; $Count < sizeof($Member); $Count++ ) { ?>
적립내용 적립 포인트 처리날짜
   
- 사용내역(최근 5회)
 
적립내용 차감 포인트 처리날짜
   
   
내가 쓴 글
  검색기간 : ~
   
- 본글
  '', 'total_comment'=>'', 'no'=>'', 'hit'=>'', 'date'=>'', 'name'=>'', 'type'=>'', 'board'=>'', 'cl_id'=>'', 'table'=>'', 'mileage'=>'', 'subject'=>'', 'user_id'=>'', 'ismember'=>'' ); for( $BC = 0; $BC < sizeof($BoardID); $BC++ ) { if ($BoardID[$BC] == 'conference') { $db_prefix = 'conference'; } else { $db_prefix = 'board'; } // if() $Query = "select no,name,reg_date,subject,ismember,hit,total_comment from ".$db_prefix.".zetyx_board". "_" . $BoardID[$BC] . " where ismember='".$zboard_member_no."' AND reg_date >= " . $b1_Cut_StartTime . " AND reg_date < " . $b2_Cut_EndTime . " and father = 0 order by hit desc LIMIT 10"; $Result = mysql_query($Query, $connect) or die(mysql_error()); while ( $Data = mysql_fetch_array($Result) ) { $Board[$Count] = $_default; $Board[$Count][type] = 'zboard'; $Board[$Count][cl_id] = ''; $Board[$Count][table] = ''; $Board[$Count][board] = $BoardID[$BC]; $Board[$Count][board_title] = $BoardTitle[$BC]; $Board[$Count][no] = $Data[no]; $Board[$Count][name] = stripslashes($Data[name]); #$Board[$Count][date] = date("H:i:s", $Data[reg_date]); $Board[$Count][date] = date("Y-m-d H:i:s", $Data[reg_date]); $Board[$Count][ismember] = $Data[ismember]; $Board[$Count][hit] = $Data[hit]; $Board[$Count][total_comment] = $Data[total_comment]; $Board[$Count][user_id] = ''; $Board[$Count][mileage] = 0; if ($Data[ismember] > 0) { $q = "SELECT user_id FROM board.zetyx_member_table WHERE no='".$Data[ismember]."'"; $Board[$Count][user_id] = db_get_one($q); if ($Board[$Count][user_id] != '') { $q = "SELECT mileage FROM tb_member WHERE username='".$Board[$Count][user_id]."'"; $Board[$Count][mileage] = db_get_one($q); } // if() } // if() $Board[$Count][subject] = cut_str(str_replace(" ","",stripslashes(strip_tags($Data[subject]))), $TitleLen); $TotalWrite++; $Count++; } } // 엔빌더 for ($i=0; $i<$ba_cnt; $i++) { $table = strtolower("tb_ib_" . $ba[ba_boardid][$i]); $q = " SELECT b_bno, b_writer, b_name, b_title, b_writedate, b_readnum FROM `$table` WHERE b_writer = '".$UnameSess."' AND b_writedate >= '" . date('Y-m-d H:i:s', $b1_Cut_StartTime) . "' AND b_writedate < '" . date('Y-m-d H:i:s', $b2_Cut_EndTime) . "' and b_re_level = 0 ORDER BY b_readnum DESC LIMIT 10 "; $b = db_get_rows($q); $b_cnt = (is_array($b)) ? sizeof($b) : 0; if ($b_cnt > 0) { for ($j=0; $j<$b_cnt; $j++) { $Board[$Count] = $_default; $Board[$Count][type] = 'nbuilder'; $Board[$Count][cl_id] = $ba[ba_adminid][$i]; $Board[$Count][table] = $table; $Board[$Count][board] = $ba[ba_boardid][$i]; $Board[$Count][board_title] = $ba[ba_boardid][$i]; $Board[$Count][no] = $b[$j][b_bno]; $Board[$Count][user_id] = ''; $Board[$Count][mileage] = 0; $Board[$Count][is_member] = 0; if ($b[$j][b_writer]) // 회원일때 { $q = "SELECT name, mileage FROM tb_member WHERE username='".$b[$j][b_writer]."'"; $_row = db_get_row($q); $b[$j][b_name] = $_row['name']; $Board[$Count][mileage] = $_row['mileage']; $Board[$Count][user_id] = $b[$j][b_writer]; } // if() $Board[$Count][name] = $b[$j][b_name]; #$Board[$Count][date] = substr($b[$j][b_writedate], 11); $Board[$Count][date] = $b[$j][b_writedate]; $Board[$Count][hit] = $b[$j][b_readnum]; $q = "SELECT count(*) FROM tb_iboard_comment WHERE ba_boardid='".$ba[ba_boardid][$i]."' AND bc_parent='".$b[$j][b_bno]."'"; $Board[$Count][total_comment] = db_get_one($q); $Board[$Count][subject] = cut_str(str_replace(" ","",stripslashes(strip_tags($b[$j][b_title]))), $TitleLen); $TotalWrite++; $Count++; } // for() } // if() } // for() // 구인정보 $q = " SELECT * FROM tb_recruit_com WHERE rc_writer = '".$UnameSess."' AND rc_date >= '" . date('Y-m-d H:i:s', $b1_Cut_StartTime) . "' AND rc_date < '" . date('Y-m-d H:i:s', $b2_Cut_EndTime) . "' ORDER BY rc_no DESC "; $b = db_get_rows($q); $b_cnt = (is_array($b)) ? sizeof($b) : 0; if ($b_cnt > 0) { for ($j=0; $j<$b_cnt; $j++) { $Board[$Count] = $_default; $Board[$Count][type] = 'recruit_com'; $Board[$Count][no] = $b[$j][rc_no]; if ($b[$j][rc_writer]) // 회원일때 { $q = "SELECT name, mileage FROM tb_member WHERE username='".$b[$j][rc_writer]."'"; $_row = db_get_row($q); $b[$j][b_name] = $_row['name']; $Board[$Count][mileage] = $_row['mileage']; $Board[$Count][user_id] = $b[$j][rc_writer]; } // if() $Board[$Count][name] = $b[$j][b_name]; $Board[$Count][date] = $b[$j][rc_date]; $Board[$Count][hit] = $b[$j][rc_readnum]; $Board[$Count][subject] = cut_str(str_replace(" ","",stripslashes(strip_tags($b[$j][rc_info_pr]))), $TitleLen); $TotalWrite++; $Count++; } // for() } // if() // 구직정보 $q = " SELECT * FROM tb_recruit_per WHERE rp_writer = '".$UnameSess."' AND rp_date >= '" . date('Y-m-d H:i:s', $b1_Cut_StartTime) . "' AND rp_date < '" . date('Y-m-d H:i:s', $b2_Cut_EndTime) . "' ORDER BY rp_no DESC "; $b = db_get_rows($q); $b_cnt = (is_array($b)) ? sizeof($b) : 0; if ($b_cnt > 0) { for ($j=0; $j<$b_cnt; $j++) { $Board[$Count] = $_default; $Board[$Count][type] = 'recruit_per'; $Board[$Count][no] = $b[$j][rp_no]; if ($b[$j][rp_writer]) // 회원일때 { $q = "SELECT name, mileage FROM tb_member WHERE username='".$b[$j][rp_writer]."'"; $_row = db_get_row($q); $b[$j][b_name] = $_row['name']; $Board[$Count][mileage] = $_row['mileage']; $Board[$Count][user_id] = $b[$j][rp_writer]; } // if() $Board[$Count][name] = $b[$j][b_name]; $Board[$Count][date] = $b[$j][rp_date]; $Board[$Count][hit] = $b[$j][rp_readnum]; $Board[$Count][subject] = cut_str(str_replace(" ","",stripslashes(strip_tags($b[$j][rp_info_name]))), $TitleLen); $TotalWrite++; $Count++; } // for() } // if() // 정렬 if (is_array($Board) && sizeof($Board) > 0) { $_data = db_rows_fieldtokey($Board); array_multisort( $_data['date'], SORT_DESC, $_data['board_title'], $_data['total_comment'], $_data['no'], $_data['hit'], $_data['name'], $_data['type'], $_data['board'], $_data['cl_id'], $_data['table'], $_data['mileage'], $_data['subject'], $_data['user_id'], $_data['ismember'] ); $Board = array(); foreach ($_data as $key=>$val) { for ($i=0; $i= 10) continue; $Board[$i][$key] = $val[$i]; } // for() } // foreach() } // if() ?>
메뉴명 제목 HIT 등록일
( ) 구인정보 구직정보 - ( )
   
- 답글
  '', 'total_comment'=>'', 'no'=>'', 'hit'=>'', 'date'=>'', 'name'=>'', 'type'=>'', 'board'=>'', 'cl_id'=>'', 'table'=>'', 'mileage'=>'', 'subject'=>'', 'user_id'=>'', 'ismember'=>'' ); for( $BC = 0; $BC < sizeof($BoardID); $BC++ ) { if ($BoardID[$BC] == 'conference') { $db_prefix = 'conference'; } else { $db_prefix = 'board'; } // if() $Query = "select no,name,reg_date,subject,ismember,hit,total_comment from ".$db_prefix.".zetyx_board". "_" . $BoardID[$BC] . " where ismember='".$zboard_member_no."' AND reg_date >= " . $b1_Cut_StartTime . " AND reg_date < " . $b2_Cut_EndTime . " and father != 0 order by hit desc LIMIT 10"; $Result = mysql_query($Query, $connect) or die(mysql_error()); while ( $Data = mysql_fetch_array($Result) ) { $Board[$Count] = $_default; $Board[$Count][type] = 'zboard'; $Board[$Count][cl_id] = ''; $Board[$Count][table] = ''; $Board[$Count][board] = $BoardID[$BC]; $Board[$Count][board_title] = $BoardTitle[$BC]; $Board[$Count][no] = $Data[no]; $Board[$Count][name] = stripslashes($Data[name]); #$Board[$Count][date] = date("H:i:s", $Data[reg_date]); $Board[$Count][date] = date("Y-m-d H:i:s", $Data[reg_date]); $Board[$Count][ismember] = $Data[ismember]; $Board[$Count][hit] = $Data[hit]; $Board[$Count][total_comment] = $Data[total_comment]; $Board[$Count][user_id] = ''; $Board[$Count][mileage] = 0; if ($Data[ismember] > 0) { $q = "SELECT user_id FROM board.zetyx_member_table WHERE no='".$Data[ismember]."'"; $Board[$Count][user_id] = db_get_one($q); if ($Board[$Count][user_id] != '') { $q = "SELECT mileage FROM tb_member WHERE username='".$Board[$Count][user_id]."'"; $Board[$Count][mileage] = db_get_one($q); } // if() } // if() $Board[$Count][subject] = cut_str(str_replace(" ","",stripslashes(strip_tags($Data[subject]))), $TitleLen); $TotalWrite++; $Count++; } } // 엔빌더 for ($i=0; $i<$ba_cnt; $i++) { $table = strtolower("tb_ib_" . $ba[ba_boardid][$i]); $q = " SELECT b_bno, b_writer, b_name, b_title, b_writedate, b_readnum FROM `$table` WHERE b_writer = '".$UnameSess."' AND b_writedate >= '" . date('Y-m-d H:i:s', $b1_Cut_StartTime) . "' AND b_writedate < '" . date('Y-m-d H:i:s', $b2_Cut_EndTime) . "' and b_re_level != 0 ORDER BY b_readnum DESC LIMIT 10 "; $b = db_get_rows($q); $b_cnt = (is_array($b)) ? sizeof($b) : 0; if ($b_cnt > 0) { for ($j=0; $j<$b_cnt; $j++) { $Board[$Count] = $_default; $Board[$Count][type] = 'nbuilder'; $Board[$Count][cl_id] = $ba[ba_adminid][$i]; $Board[$Count][table] = $table; $Board[$Count][board] = $ba[ba_boardid][$i]; $Board[$Count][board_title] = $ba[ba_boardid][$i]; $Board[$Count][no] = $b[$j][b_bno]; $Board[$Count][user_id] = ''; $Board[$Count][mileage] = 0; $Board[$Count][is_member] = 0; if ($b[$j][b_writer]) // 회원일때 { $q = "SELECT name, mileage FROM tb_member WHERE username='".$b[$j][b_writer]."'"; $_row = db_get_row($q); $b[$j][b_name] = $_row['name']; $Board[$Count][mileage] = $_row['mileage']; $Board[$Count][user_id] = $b[$j][b_writer]; } // if() $Board[$Count][name] = $b[$j][b_name]; #$Board[$Count][date] = substr($b[$j][b_writedate], 11); $Board[$Count][date] = $b[$j][b_writedate]; $Board[$Count][hit] = $b[$j][b_readnum]; $q = "SELECT count(*) FROM tb_iboard_comment WHERE ba_boardid='".$ba[ba_boardid][$i]."' AND bc_parent='".$b[$j][b_bno]."'"; $Board[$Count][total_comment] = db_get_one($q); $Board[$Count][subject] = cut_str(str_replace(" ","",stripslashes(strip_tags($b[$j][b_title]))), $TitleLen); $TotalWrite++; $Count++; } // for() } // if() } // for() // 정렬 if (is_array($Board) && sizeof($Board) > 0) { $_data = db_rows_fieldtokey($Board); array_multisort( $_data['date'], SORT_DESC, $_data['board_title'], $_data['total_comment'], $_data['no'], $_data['hit'], $_data['name'], $_data['type'], $_data['board'], $_data['cl_id'], $_data['table'], $_data['mileage'], $_data['subject'], $_data['user_id'], $_data['ismember'] ); $Board = array(); foreach ($_data as $key=>$val) { for ($i=0; $i= 10) continue; $Board[$i][$key] = $val[$i]; } // for() } // foreach() } // if() ?>
메뉴명 제목 HIT 등록일
( ) - ( )
   
- 댓글
  '', 'board_title'=>'', 'no'=>'', 'c_no'=>'', 'memo'=>'', 'name'=>'', 'type'=>'', 'board'=>'', 'cl_id'=>'', 'table'=>'', 'mileage'=>'', 'user_id'=>'', 'ismember'=>'' ); // 제로보드 for( $BC = 0; $BC < sizeof($BoardID); $BC++ ) { if ($BoardID[$BC] == 'conference') { $db_prefix = 'conference'; } else { $db_prefix = 'board'; } // if() $Query = "select no,parent,name,reg_date,memo,ismember from ".$db_prefix.".zetyx_board_comment" . "_" . $BoardID[$BC] . " where ismember='".$zboard_member_no."' AND reg_date >= " . $b1_Cut_StartTime . " AND reg_date < " . $b2_Cut_EndTime . " order by no desc LIMIT 10"; $Result = mysql_query($Query, $connect) or die(mysql_error()); while ( $Data = mysql_fetch_array($Result) ) { $Comment[$Count] = $_default; $Comment[$Count][type] = 'zboard'; $Comment[$Count][board] = $BoardID[$BC]; $Comment[$Count][board_title] = $BoardTitle[$BC]; $Comment[$Count][no] = $Data[parent]; $Comment[$Count][c_no] = $Data[no]; $Comment[$Count][name] = stripslashes($Data[name]); $Comment[$Count][date] = date("Y-m-d H:i:s", $Data[reg_date]); $Comment[$Count][ismember] = $Data[ismember]; if ($Data[ismember] > 0) { $q = "SELECT user_id FROM board.zetyx_member_table WHERE no='".$Data[ismember]."'"; $Comment[$Count][user_id] = db_get_one($q); if ($Comment[$Count][user_id] != '') { $q = "SELECT mileage FROM tb_member WHERE username='".$Comment[$Count][user_id]."'"; $Comment[$Count][mileage] = db_get_one($q); } // if() } // if() $Comment[$Count][memo] = cut_str(str_replace(" ","",stripslashes(strip_tags($Data[memo]))), $CommentLen); $TotalComment++; $Count++; } } // 엔빌더 $q = " SELECT * FROM tb_iboard_comment WHERE bc_writer = '".$UnameSess."' AND bc_writedate >= '" . date('Y-m-d H:i:s', $b1_Cut_StartTime) . "' AND bc_writedate < '" . date('Y-m-d H:i:s', $b2_Cut_EndTime) . "' ORDER BY bc_no DESC LIMIT 10 "; $b = db_get_rows($q); $b_cnt = (is_array($b)) ? sizeof($b) : 0; if ($b_cnt > 0) { for ($j=0; $j<$b_cnt; $j++) { $Comment[$Count] = $_default; $Comment[$Count][type] = 'nbuilder'; $q = "SELECT ba_adminid FROM tb_iboard_admin WHERE ba_boardid='".$b[$j][ba_boardid]."'"; $Comment[$Count][cl_id] = db_get_one($q); $table = strtolower("tb_ib_" . $b[$j][ba_boardid]); $Comment[$Count][table] = $table; $Comment[$Count][board] = $b[$j][ba_boardid]; $Comment[$Count][no] = $b[$j][bc_parent]; $Comment[$Count][c_no] = $b[$j][bc_no]; if ($b[$j][bc_writer]) // 회원일때 { $q = "SELECT name, mileage FROM tb_member WHERE username='".$b[$j][bc_writer]."'"; $_row = db_get_row($q); $b[$j][bc_name] = $_row['name']; $Comment[$Count][mileage] = $_row['mileage']; $Comment[$Count][user_id] = $b[$j][bc_writer]; } // if() $Comment[$Count][name] = $b[$j][bc_name]; $Comment[$Count][date] = $b[$j][bc_writedate]; $Comment[$Count][memo] = cut_str(str_replace(" ","",stripslashes(strip_tags($b[$j][bc_comment]))), $CommentLen); $TotalComment++; $Count++; } // for() } // if() // 정렬 #vd(array_keys(db_rows_fieldtokey($Comment))); if (is_array($Comment) && sizeof($Comment) > 0) { $_data = db_rows_fieldtokey($Comment); array_multisort( $_data['date'], SORT_DESC, $_data['board_title'], $_data['no'], $_data['c_no'], $_data['memo'], $_data['name'], $_data['type'], $_data['board'], $_data['cl_id'], $_data['table'], $_data['mileage'], $_data['user_id'], $_data['ismember'] ); $Comment = array(); foreach ($_data as $key=>$val) { for ($i=0; $i= 10) continue; $Comment[$i][$key] = $val[$i]; } // for() } // foreach() } // if() ?>
메뉴명 내용 등록일
-
   
 
내가 가입한 Club
   
 
Club 가입일
   
 
최근 접속일시
   
 
시간 IP