alert('$str');$url;"; }
else { echo ""; }
exit;
}
//################################################################################
// 페이지 이동 스크립트
//################################################################################
function move_page($url,$second = 0) {
global $connect;
if($connect) morning_close($connect);
echo"";
exit;
}
################################################################################
// 환경 설정 파일 불러오기
################################################################################
if(!file_exists("config_basic.php")) { error_msg("config BASIC file open error");}
if(!file_exists("config_db.php")) { error_msg("config DB file open error","install.php");}
if(!file_exists("license.txt")) { error_msg("license file open error","http://www.morningspecial.com/user/main.html"); }
$settings = parse_ini_file('config_basic.php');
@extract($settings);
$cf_mall_name = settings_re($cf_mall_name);
$cf_mall_url = settings_re($cf_mall_url);
$cf_mall_install_dir = settings_re($cf_mall_install_dir);
$cf_mall_address = settings_re($cf_mall_address);
$cf_mall_title = settings_re($cf_mall_title);
$cf_company_num = settings_re($cf_company_num);
$cf_sale_num = settings_re($cf_sale_num);
$cf_business_name = settings_re($cf_business_name);
$cf_business_conditions = settings_re($cf_business_conditions);
$cf_business_item = settings_re($cf_business_item);
$cf_ceo_name = settings_re($cf_ceo_name);
$cf_charge_name = settings_re($cf_charge_name);
$cf_ceo_phone = settings_re($cf_ceo_phone);
$cf_ceo_fax = settings_re($cf_ceo_fax);
$cf_client_phone1 = settings_re($cf_client_phone1);
$cf_client_phone2 = settings_re($cf_client_phone2);
$cf_client_phone3 = settings_re($cf_client_phone3);
$cf_client_phone4 = settings_re($cf_client_phone4);
$cf_client_fax = settings_re($cf_client_fax);
$cf_client_email = settings_re($cf_client_email);
$cf_client_msn = settings_re($cf_client_msn);
$cf_client_time = settings_re($cf_client_time);
$cf_mall_form = settings_re($cf_mall_form);
$cf_language_method = settings_re($cf_language_method);
$cf_skin_name = settings_re($cf_skin_name);
$cf_account_method = settings_re($cf_account_method);
$cf_card_system = settings_re($cf_card_system);
$cf_card_id = settings_re($cf_card_id);
$cf_terminal_id = settings_re($cf_terminal_id);
$cf_card_url = settings_re($cf_card_url);
$cf_card_money = settings_re($cf_card_money);
$cf_bank_account = settings_re($cf_bank_account);
$cf_member_agreement = settings_re($cf_member_agreement);
$cf_jumin_check = settings_re($cf_jumin_check);
$cf_point_use = settings_re($cf_point_use);
$cf_point_member = settings_re($cf_point_member);
$cf_point_add = settings_re($cf_point_add);
$cf_point_recommend = settings_re($cf_point_recommend);
$cf_point_money = settings_re($cf_point_money);
$cf_delivery_free = settings_re($cf_delivery_free);
$cf_delivery_money = settings_re($cf_delivery_money);
$cf_mail_method = settings_re($cf_mail_method);
$cf_mail_member = settings_re($cf_mail_member);
$cf_mail_order = settings_re($cf_mail_order);
$cf_mail_account = settings_re($cf_mail_account);
$cf_mail_delivery = settings_re($cf_mail_delivery);
$cf_mail_name = settings_re($cf_mail_name);
$cf_stock_use = settings_re($cf_stock_use);
$cf_stock_method = settings_re($cf_stock_method);
$cf_stock_time = settings_re($cf_stock_time);
$cf_limit_list = settings_re($cf_limit_list);
// 은행 계좌명 구별하기
$cf_bank_bit = explode("\n",$cf_bank_account);
// 언어 팩 불어오기
if($cf_language_method == "korea") {
include "language_korea.php";
} elseif($cf_language_method == "english") {
include "language_korea.php";
} elseif($cf_language_method == "japen") {
include "language_korea.php";
} elseif($cf_language_method == "china") {
include "language_korea.php";
} else {
include "language_korea.php";
}
//################################################################################
// 변수 선언
//################################################################################
$g_salt = "mo";
// 모닝몰 타이틀 값과 .. 버젼 안내
$g_header_title = "Morning Mall 2003 (Version : 20030912_Beta)";
$g_header_version = "Version 20030912_Beta";
$g_main_html = "index.php";
$g_mall_skin_dir = "skin";
$g_mall_image_dir = "shop_image";
$g_member_image_dir = "member_image";
$g_board_data_dir = "board_data";
$g_board_skin_dir = "board_skin";
$g_page_file = "config_page.txt";
$g_session_dir = "session";
$g_skin_link = "./$g_mall_skin_dir/$cf_skin_name";
$g_all_link_dir = "$cf_mall_url/$cf_mall_install_dir/$g_mall_skin_dir/$cf_skin_name/";
$g_all_slink_dir = "$cf_mall_url/$cf_mall_install_dir/";
$g_division_num = "1000";
// 파일 관련 설정 변수
$g_file_okext = array("jpg","jpeg","gif","bmp","png","psd","swf","tar","gz","tgz","alz","zip","rar","ace","arj");
$g_file_okimage = array("jpg","jpeg","gif","bmp","png");
$g_max_file_size = "2097152";
$cf_morning_copyright = "Copyright 1999 - 2003 Morning Special";
$cf_help_copyright = "Copyright 1999 - 2003 Morning Special";
$cf_help_copyright .= " / help : An Ju Hyun";
//################################################################################
// 테이블 명칭 선언
//################################################################################
// 카테고리 테이블
$morning_category_table = "morning_category_table";
$morning_goods_table = "morning_goods_table";
$morning_gcomment_table = "morning_gcomment_table";
$morning_member_table = "morning_member_table";
$morning_point_table = "morning_point_table";
$morning_popup_table = "morning_popup_table";
$morning_poll_table = "morning_poll_table";
$morning_pcomment_table = "morning_pcomment_table";
// 상품 구입 관련 테이블
$morning_cart_table = "morning_cart_table";
$morning_purchase_table = "morning_purchase_table";
$morning_buyer_table = "morning_buyer_table";
// 카운터 관련 테이블
$morning_counter_table = "morning_counter_table";
$morning_time_table = "morning_time_table";
$morning_referer_table = "morning_referer_table";
// 게시판 관리 테이블
$morning_badmin_table = "morning_badmin_table";
// 게시판 본체 테이블
if($ps_db) $board_code = $ps_db;
$morning_bmain_table = "morning_bmain_$board_code";
$morning_bcomment_table = "morning_bcomment_$board_code";
$morning_bcategory_table = "morning_bcategory_$board_code";
$cct = $cf_morning_copyright.$cf_help_copyright;
################################################################################
// 환경 설정 파일 방해 문자 제거
################################################################################
function settings_del($str) {
$str = eregi_replace("\r\n", "
", $str);
$str = eregi_replace("\n", "
", $str);
$str = eregi_replace("\"", """, $str);
return $str;
}
################################################################################
// 환경 설정 파일 복원
################################################################################
function settings_re($str) {
$str = stripslashes($str);
$str = eregi_replace("
", "\n", $str);
$str = eregi_replace(""", "\"", $str);
return $str;
}
//################################################################################
// 모닝몰 배열 입력 항목들
//################################################################################
// 한국어 배열 항목
$g_point_array = array("","관리자입력","회원가입","회원추천","상품구입","포인트사용");
$g_class_array = array("손님","탈퇴회원","임시회원","일반회원","우수회원","최우수회원","딜러","상품관리자","주문관리자","중간관리자","최고관리자","관리자모드");
$g_goods_status_array = array("","MD추천상품(메인)","새상품(메인)","해당 카테고리(상단)","일반상품");
$g_interest_array = array("관심분야","컴퓨터/인터넷","과학/기술","생활/건강","정치/사회/종교","연예/오락","쇼핑","벤처창업/경영",
"재테크/증권","구인/구직","교육/학술/외국어","레저/여행","스포츠","시사/뉴스","이성교제/친목","음악/공연",
"영화/비디오","문화/예술","기타");
$g_hobby_array = array("취미","독서","음악감상","수다떨기","쇼핑","요리","당구","술마시기","잠자기","컴퓨터게임","낚시",
"등산","바둑","사진","수집","여행","악기연주","그림그리기","글쓰기","노래/춤추기","웹서핑",
"컴퓨터통신","자동차","텔레비젼","영화/비디오","만화/애니메이션","스포츠","무취미","기타");
$g_religion_array = array("종교","기독교","불교","천주교","증산도","원불교","성공회","힌두교","회교","천도교","대종교","통일교","무교(無敎)","기타");
$g_bloodtype_array = array("혈액형","A","B","O","AB","기타");
$g_jobtype_array = array("중학교이하","고등학생","대학생","대학원생","사무직","기술직","서비스/판매직","생산직","정보통신 관련직","의료인",
"방송/언론인","법조인","종교인","예능/예술인","주부","농/축/수산","교사/교수","비영리단체","무직","군인","기타");
$g_order_array = array("","주문접수완료","입금확인","출고준비","출고완료","발송(배송)중","배송완료","구입완료","반품신청","반품완료");
$g_star_array = array("","★","★★","★★★","★★★★","★★★★★");
// 게시판 초기 입력 값 관련 항목들
$g_board_header_text = "";
$g_board_tailer_text = "
";
$g_filter_text = "개새끼,씨발,좆,엄창,개쇳기,호로새끼,호로싀키,쓰벌놈,8억,추천인,병신,빙신,병삼,뒈진다,죽을래,개새,씹새,몰카,니미럴,니미,씨붕,쓰뎅,씨발놈,븅신";
if($ps_mango == "ok") echo $ps_mango." ===== ".$cct;
//################################################################################
// 마이크로 타임 구함
//################################################################################
function getmicrotime() {
$microtimestmp = split(" ",microtime());
return $microtimestmp[0]+$microtimestmp[1];
}
//################################################################################
// 빈문자가 아니면서 숫자 일경우 1 리턴
//################################################################################
function isnumblank($str) {
$temp=str_replace("\r\n","",$temp);
$temp=str_replace("\n","",$temp);
$temp=str_replace(" ","",$str);
$temp=str_replace(" ","",$temp);
if(eregi("[^[:space:]]",$temp)) { if(is_numeric($str)) { return 1; } else { return 0; } }
return 0;
}
//################################################################################
// 빈문자열 경우 1을 리턴
//################################################################################
function isblank($str) {
$temp=str_replace("\r\n","",$temp);
$temp=str_replace("\n","",$temp);
$temp=str_replace(" ","",$str);
$temp=str_replace(" ","",$temp);
if(eregi("[^[:space:]]",$temp)) { return 0; } else { return 1; }
return 0;
}
//################################################################################
// 숫자일 경우 1을 리턴
//################################################################################
function isnum($str) {
if(is_numeric($str)) { return 1; } else { return 0; }
}
//################################################################################
// 숫자, 영문자 일경우 1을 리턴
//################################################################################
function isalnum($str) {
if(eregi("[^0-9a-zA-Z\_]",$str)) { return 0; } else { return 1; }
}
//################################################################################
// E-mail 주소가 올바른지 검사
//################################################################################
function ismail($str, $check_dns = "0") {
if((preg_match('/(@.*@)|(..)|(@.)|(.@)|(^.)/', $str)) || (preg_match('/^.+@([?)[a-zA-Z0-9-.]+.([a-zA-Z]{2,3}|[0-9]{1,3})(]?)$/', $str))) {
if($check_dns) {
$host = explode('@', $email);
if( checkdnsrr($host[1], 'MX') ) return 1;
if( checkdnsrr($host[1], 'A') ) return 1;
if( checkdnsrr($host[1], 'CNAME') ) return 1;
} else {
return 1;
}
}
return 0;
}
//################################################################################
// URL, Mail을 자동으로 체크하여 링크만듬
//################################################################################
function autolink($str) {
$homepage_pattern = "(http://|ftp://|telnet:)[[:alnum:]-]+(\.[[:alnum:]-]+)+(:[[:digit:]]+)?(/[^\/:*\"<>|&?]+)*(\?[^\/:*\"<>|&?]+(&[^\/:*\"<>|&?]+)*)?";
$str =ereg_replace("$homepage_pattern", "\\0", $str);
$email_pattern = "[[:alnum:]._-]+@[[:alnum:]-]+(\.[[:alnum:]-]+)+";
$str =ereg_replace("$email_pattern", "\\0", $str);
return $str;
}
//################################################################################
// MYSQL용 함수
//################################################################################
// 데이터 베이스 연결
$g_connect_start = getmicrotime();
$connect = dbconn();
$g_connect_end = getmicrotime();
function dbconn() {
if(!file_exists("config_db.php")) { error_msg("$ERROR_FUNCTION_OPEN_DBFILE","install.php");}
$db_settings = parse_ini_file('config_db.php');
@extract($db_settings);
if(!$connect) $connect = @mysql_connect($con_db_host,$con_db_id,$con_db_pass) or die(" Mysql_Query : ".$query."
Mysql_Error : ".mysql_error()."
Mysql Error Num : ".mysql_errno()."");
@mysql_select_db($con_db_name, $connect) or die(" Mysql_Query : ".$query."
Mysql_Error : ".mysql_error()."
Mysql Error Num : ".mysql_errno()."");
return $connect;
}
function morning_query($query) {
global $connect;
$result = @mysql_query($query,$connect);
return $result;
}
function morning_query_error($query) {
global $connect;
$result = mysql_query($query, $connect) or die(" Mysql_Query : ".$query."
Mysql_Error : ".mysql_error()."
Mysql Error Num : ".mysql_errno()."");
return $result;
}
function morning_fetch_array($result) {
return @mysql_fetch_array($result);
}
function morning_free_result($result) {
@mysql_free_result($result);
}
function morning_num_rows($result) {
return @mysql_num_rows($result);
}
function morning_fetch_row($result) {
return @mysql_fetch_row($result);
}
function morning_close($connect) {
@mysql_close($connect);
}
function morning_counter($table_name, $where_str="", $field_name="*") {
global $connect;
if(!eregi("where",$where_str) and $where_str) $where_str = "where ".$where_str;
$result = @mysql_query("select count($field_name) from $table_name $where_str", $connect);
$fetch_row = @mysql_fetch_row($result);
return $fetch_row[0];
}
##################################################################################
//
태그 생성
##################################################################################
function make_br($str) {
$str = str_replace("\r\n", "
", $str);
$str = str_replace("\n", "
", $str);
return $str;
}
##################################################################################
// html tag를 제거하는 함수
##################################################################################
function del_teg($str) {
$str = str_replace( ">", ">",$str );
$str = str_replace( "<", "<",$str );
return $str;
}
//################################################################################
// HTML 중에 공격 태그 삭제
//################################################################################
function avoid_crack($str) {
$str = eregi_replace("<\?","<?",$str);
$str = eregi_replace("\?>","?>",$str);
$str = eregi_replace("","",$str);
$str = eregi_replace("","",$str);
$str = eregi_replace("","",$str);
$str = eregi_replace("","",$str);
$str = eregi_replace("","",$str);
$str = eregi_replace("","",$str);
$str = eregi_replace("","",$str);
$str = eregi_replace("","",$str);
$str = eregi_replace("","",$str);
$str = eregi_replace("c\|/con/con/","",$str);
return $str;
}
##################################################################################
// 뻔한 숨김 이야기
##################################################################################
function mango_encode($str) {
$str = base64_encode($str);
$str = urlencode($str);
return $str;
}
##################################################################################
// 숨겼으면 풀어 야지 ..
##################################################################################
function mango_decode($str) {
$str = urldecode($str);
$str = base64_decode($str);
return $str;
}
################################################################################
// 욕 기타 광고글 필터링
################################################################################
function bad_check($badword,$str,$divide = ",") {
$badword = preg_replace('/'.$divide.'/','|',&$badword);
if(preg_match('/'.$badword.'/',&$str,$match)) { return $match[0]; }
return 0;
}
##################################################################################
// 주민등록번호 검사 맞을경우 1 리턴
##################################################################################
function check_jumin($jumin) {
$weight = '234567892345'; // 자리수 weight 지정
$len = strlen($jumin);
$sum = 0;
if($len <> 13) return false;
for ($i = 0; $i < 12; $i++) {
$sum = $sum + (substr($jumin,$i,1)*substr($weight,$i,1));
}
$rst = $sum%11;
$result = 11 - $rst;
if($result == 10) $result = 0;
elseif($result == 11) $result = 1;
$ju13 = substr($jumin,12,1);
if ($result <> $ju13) return 0;
return 1;
}
##################################################################################
// 미성년자 판별 맞을경우 1 리턴
##################################################################################
function adult_check($jumin) {
$jumin = chop($jumin);
$jumin = trim($jumin);
$len = strlen($jumin);
if($len <> 13) return 0;
$birth = substr($jumin, 0, 6);
$checkyear = substr($jumin, 6, 1);
if($checkyear == 3 or $checkyear == 4) $fyear = "20".$birth; else $fyear = "19".$birth;
$agecheck = date(Ymd) - $fyear; // 현재 날짜를 구해서 태어날 날자 빼기
if($agecheck < 190000) return 0;
return 1;
}
##################################################################################
// 나이 체크
##################################################################################
function age_check($jumin1, $jumin2="", $mode="") {
if(!$jumin2) {
$jumin1 = eregi_replace("-","", $jumin1);
$stype = substr($jumin1, 6, 1);
$year = substr($jumin1, 0, 2);
}
else {
$stype = substr($jumin2, 0, 1);
$year = substr($jumin1, 0, 2);
}
$old = date("Y", time()) - (1900+(intval($stype/3)*100)+$year);
if(!$mode) $old++;
return $old;
}
################################################################################
// 파일 사이즈를 kb, mb에 맞추어서 변환해서 리턴
################################################################################
function getfilesize($size) {
if(!$size) return "0 Byte";
if($size<1024) {
return ($size." Byte");
} elseif($size >1024 && $size< 1024 *1024) {
return sprintf("%0.1f KB",$size / 1024);
} else {
return sprintf("%0.2f MB",$size / (1024*1024));
}
}
################################################################################
// 문자열 끊기 (이상의 길이일때는 ... 로 표시)
################################################################################
function cut_str($str,$maxlen, $suffix = "..") {
if($maxlen<=0) return $str;
if(ereg("\[re\]",$str)) $len=$len+4;
if($maxlen >= strlen($str)) return $str;
$klen = $maxlen - 1;
while(ord($str[$klen]) & 0x80) $klen--;
return substr($str, 0, $maxlen - (($maxlen + $klen + 1) % 2)).$suffix;
}
################################################################################
// 페이지 URL
################################################################################
function page_list($current_page="1", $total_page="0", $list_num="15", $page_num="10", $url, $first_page="[1]", $post_page="..", $post_start="[Previous 10Pages]", $next_page="..", $last_page="", $next_start="[Next 10Pages]", $link_color="#EF5900") {
$str .= "";
$start_page = @(((int)(($current_page-1)/$page_num))*$page_num)+1;
$temp_pnum = $page_num - 1 ;
$end_page = $start_page + $temp_pnum;
if ($end_page >= $total_page) $end_page = $total_page;
if ($start_page > 1) {
$str .= " ".$post_start."";
}
if ($current_page > 1) {
$str .= " ".$first_page."";
$str .= " ".$post_page."";
}
if ($total_page > 1) {
for ($i=$start_page;$i<=$end_page;$i++) {
if ($current_page != $i) {
$str .= " [$i]";
} else {
$str .= " $i";
}
}
}
if ($current_page < $total_page) {
$str .= " ".$next_page."";
if(!$last_page) {
$last_page = "[".$total_page."]";
$str .= " ".$last_page." ";
}
}
if ($total_page > $end_page) {
$str .= " ".$next_start."";
}
$str .= "";
return $str;
}
################################################################################
// 페이지 URL
################################################################################
function page_rist($current_page="1", $total_page="0", $list_num="15", $page_num="10", $url, $first_page="[1]", $post_page="..", $post_start="[Previous 10Pages]", $next_page="..", $last_page="", $next_start="[Next 10Pages]", $link_color="#EF5900") {
$start_page=@(((int)(($current_page-1)/$page_num))*$page_num)+1;
$temp_pnum=$page_num-1;
$end_page=$start_page+$temp_pnum;
if ($end_page>=$total_page)$end_page=$total_page;
if ($total_page > 1) {
for ($i=$start_page;$i<=$end_page;$i++) {
if ($current_page!=$i){}
else{$str.="$i";}
}
}
return $str;
}
################################################################################
// Next Page
################################################################################
function goto_next($j, $i) {{
$j = $i+1;
if ($$ps_goid!=""){echo ""; }
else{$str.="$j";}
}
return $str;
}
function ct($t) {{
if ($$ps_ctid!=""){}
else{$str.="$t";}
}
return $str;
}
################################################################################
// 파일을 삭제하는 함수
################################################################################
function file_unlink($filename) {
if(file_exists($filename)) {
@chmod($filename,0777);
$handle = @unlink($filename);
}
if(file_exists($filename)) {
@chmod($filename,0775);
$handle = @unlink($filename);
}
if(file_exists($filename)) {
$handle = @unlink($filename);
}
return $handle;
}
################################################################################
// 지정된 디렉토리의 파일 정보를 구함
################################################################################
function get_dirinfo($path) {
$handle=@opendir($path);
while($info = readdir($handle)) {
if($info != "." && $info != "..") {
$dir[] = $info;
}
}
closedir($handle);
return $dir;
}
################################################################################
// 기본 메일 보내기
################################################################################
function basic_sendmail($to_email,$from_email,$form_name,$subject,$morningbody,$type) {
$header .= "From: $form_name <$from_email>\n";
//$header .= "X-Sender: <$from_email>\n";
//$header .= "X-Mailer: PHP ".phpversion()."\n";
$header .= "X-Priority: 1\n";
//$header .= "Return-Path: <$from_email>\n";
$header .= "Content-Type: text/$type;";
$header .= "charset=euc-kr\n";
$morningbody = stripslashes($morningbody);
//echo "$to_email
$subject
$morningbody
$header";
//exit;
@mail($to_email,$subject,$morningbody,$header);
}
################################################################################
// 메일 보내기 직접
################################################################################
function nmail($to_email, $from_email, $from_name, $subject, $morningbody, $type) {
$header = "From: $from_name <$from_email>\n";
//$header .= "X-Sender: <$from_email>\n";
//$header .= "X-Mailer: PHP ".phpversion()."\n";
$header .= "X-Priority: 1\n";
//$header .= "Return-Path: <$from_email>\n";
$header .= "Content-Type: text/$type; charset=EUC-KR\n";
$header .= "\n\n";
$morningbody = stripslashes($morningbody);
@$fp = popen('/usr/sbin/sendmail -t -f '.$from_email.' '.$to_email,"w");
if(!$fp) return 0;
fputs($fp,"From:".$from_name."<".$from_email.">"."\n");
//fputs($fp, "To: $to_email\n");
fputs($fp, "Subject: ".$subject."\n");
fputs($fp, $header."\n");
fputs($fp, $morningbody);
fputs($fp, "\n\n\n");
pclose($fp);
return 1;
}
################################################################################
// 갯수가 구매가능 한지 알아 보기 위해 구입가능 하면 1
################################################################################
function goods_stock_check($table, $ps_goid, $goods_num) {
global $connect;
$list = @morning_fetch_array(morning_query_error("select * from $table where uid = '$ps_goid'"));
if($list[goods_stock] >= $goods_num) { return 1; } else { return 0; }
}
################################################################################
// 카테고리 네비게이션
################################################################################
function category_navigation($str) {
global $connect,$morning_category_table;
$tmp_level = category_level($str);
$original_len = strlen($str);
// 네비게이션이 필요한 경우
if($tmp_level > 1) {
for($i=1 ; $i<$tmp_level ; $i++) {
// 그 레벨의 가장 큰 번호의 카테고리 부터 차례 대로 불러오기
$next_num = ($i*2);
$parent_str = substr($str, 0, $next_num);
$now_str = substr($parent_str."00000000", 0, $original_len);
//echo " $tmp_level === $next_num =========== $parent_str ======== $now_str ===
";
$query = " select * from $morning_category_table where category_id = '$now_str' ";
$result = morning_query_error($query);
$list = morning_fetch_array($result);
morning_free_result($result);
$navi_str .= "$list[category_name] > ";
}
}
return $navi_str;
}
################################################################################
// 하위카테고리 네비게이션
################################################################################
function tree_navigation($str) {
global $connect,$morning_category_table;
$tmp_level = category_level($str);
$now_level = $tmp_level;
$original_len = strlen($str);
$next_num = (($tmp_level)*2);
$parent_str = substr($str, 0, $next_num);
//echo " ============= $tmp_level === $next_num =========== $parent_str ======== $now_str ===
";
if($tmp_level < 4) {
$now_level++;
$now_sub_level = $now_level;
$now_sub_level++;
$query = " select * from $morning_category_table where substring(category_id,1,$next_num) = '$parent_str' and category_depth = $now_level order by category_rank asc";
//echo " $query ===================== ".$parent_str = substr($str, 0, $next_num);
//echo "
$query ===
";
$result = morning_query_error($query);
while($list = morning_fetch_array($result)) {
if($now_level != "4") $tree_str .="
";
$tree_str .=" $list[category_name] ";
if($now_level == "4") $tree_str .="|";
if($now_level < 4) {
$tree_str .=" >> ";
$next_num = (($now_level)*2);
$parent_str = substr($list[category_id], 0, $next_num);
$sub_query = " select * from $morning_category_table where substring(category_id,1,$next_num) = '$parent_str' and category_depth = $now_sub_level order by category_rank asc";
$sub_result = morning_query_error($sub_query);
// echo "
$sub_query
";
while($sub_list = morning_fetch_array($sub_result)) {
$tree_str .="$sub_list[category_name] |";
}
}
}
}
return $tree_str;
}
################################################################################
// 카테고리 레벨
################################################################################
function category_level($str) {
$level = 0;
for ($i=0; $i1; $i-=2) {
$j = $i-2;
$temp_sub = substr($str,$j,2);
if($temp_sub != "00") { break; }
$str = substr($str,0,$j);
}
return $str;
}
################################################################################
// 하위 분류 레벨 구하기
################################################################################
function category_next($str) {
global $connect,$morning_category_table;
$parent_str = category_status($str);
$len = strlen($parent_str);
$original_len = strlen($str);
$next_len = $len + 1;
//echo " $str ==== $parent_str ==== $len ===== $original_len ==
";
// 4단계 지원 에 따른 4단 계 이상이면 리턴 해줘야징
if ($len > 8) { return "1"; }
// 그 레벨의 가장 큰 번호를 구한다.
$query = " select max(substring(category_id,$next_len,2)) from $morning_category_table where substring(category_id,1,$len) = '$parent_str' ";
$result = morning_query_error($query);
$max_num = morning_fetch_array($result);
morning_free_result($result);
$num = $max_num[0];
if ($num == 99) {
// 99 개 중에 빠진 거 있나 찾아서 해결 하기. 찾다가 없으면 어쩔수 없구..
// 이렇게 무식한 방법 말구 뭐 있을까 ??
$num = 0;
for($i=99 ; $i > 0 ; $i--) {
$temp_num = sprintf("%02d",$i);
$query = " select * from $morning_category_table where substring(category_id,1,$len) = '$parent_str' and substring(category_id,$next_len,2) = '$temp_num'";
$result = morning_query_error($query);
$list = morning_fetch_array($result);
morning_free_result($result);
if(!$list[category_id]) {
$num = $i;
//$count++;
}
}
if ($num == "0") { return "2"; }
} else {
$num++;
}
$num = sprintf("%02d",$num);
$next_num = substr($parent_str.$num."00000000", 0, $original_len);
return $next_num;
}
################################################################################
// 파일 업로드
################################################################################
function upload_file($file, $file_name, $file_size, $file_dir, $file_okext, $max_file_size) {
if($file_name == "") return ;
$file_name = str_replace(" ","_",$file_name); // 이름이 중간에 비어 있으면 바꾸기
$file_name = str_replace("-","_",$file_name); // 이름이 중간에 - 을 _이걸루 바꾸기
if ($file_size > $max_file_size) error_msg("업로드 용량은 ".getfilesize($max_file_size)." 이하만 가능합니다.");
$file_ex = substr(strrchr($file_name,"."),1);
$file_ex = strtolower($file_ex);
if(!in_array($file_ex,$file_okext)) $file_name .= "_bad";
// 같은 파일이 있다면 () 에 숫자를 더하여 다른 이름을 만든다.
$copy_index = 0;
$str = $file_name;
while(file_exists("$file_dir/$str")) {
$str_bit = explode(".", $file_name);
$copy_index++;
$str_bit[0] .= "(".$copy_index.")";
$str = implode(".", $str_bit);
$str = trim($str);
}
$temp_filename = $file_dir."/".$str;
@move_uploaded_file($file, $temp_filename);
return $temp_filename;
}
################################################################################
// 선택 화면 만들기
################################################################################
function make_select($name,$codename,$data){
$data_bit = explode("/",$data);
$str .= "\n\n";
return $str;
}
################################################################################
// DOT 이미지 .. 생성
################################################################################
function make_dot($image_link){
$str = "\n";
return $str;
}
################################################################################
// 게시판 내용 간단 하게 보여주기
################################################################################
function show_board_list($ps_db="notice",$board_name="morning_bmain_notice",$list_num="5",$lan_cut="30",$mini_image=">",$where_sql="",$order_sql="order by headnum asc"){
global $connect;
$query = "select * from $board_name $where_sql $order_sql limit 0, $list_num";
$mi_result = morning_query_error("$query");
while($mi_list = morning_fetch_array($mi_result)) {
$mi_list[board_subject] = cut_str($mi_list[board_subject],"$lan_cut","..");
$str .= $mini_image." $mi_list[board_subject]
";
}
return $str;
}
?>