여분필드 wr_90 추가후 "글쓰기"번튼 누르면 먹통이 됩니다 > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

여분필드 wr_90 추가후 "글쓰기"번튼 누르면 먹통이 됩니다 정보

여분필드 wr_90 추가후 "글쓰기"번튼 누르면 먹통이 됩니다

본문

write_update.skin.php 요기서 멈춰 버린건지 완료 된건지 에러도 안뜨니 답답 하네요

DB엔 필드 wr_11 ~ wr_90 추가 하였고요

고수님들의 조언 부탁 드립니다.


>>>> write_update.skin.php 내용----------------------------------------

<?
//header("Content-type: text/html; charset=UTF-8");
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
/*
//=========================================================== 지업로더 후처리
if ($w == ''|| $w== "r"){
 $wr_id_code=abs(ip2long($_SERVER['REMOTE_ADDR']));
 if($wr_id_code >= 2147483647)
  $wr_id_code=substr($wr_id_code,-9);
 $sql = "update g4_board_file set wr_id = '$wr_id' where bo_table = '$bo_table' and wr_id = '$wr_id_code'";
 sql_query($sql);
}
*/
if ($w != 'c') {

if($wr_01 == ""){$wr_01 = "Y";} //승인유무("Y"자동승인)
$sql01= "update $write_table set wr_1 = '$wr_01' where wr_id = '$wr_id'";
    sql_query($sql01);

$wr_02 = "$mg010";
$sql02 = "update $write_table set wr_2 = '$wr_02' where wr_id = '$wr_id'";
sql_query($sql02) // ♧ 담당 매니저 코드

$wr_03 = "mg020";
$sql03 = "update $write_table set wr_3 = '$wr_03' where wr_id = '$wr_id'";
sql_query($sql03) // ♧ 담당 매니저

$wr_04 = "$mg03_tel01|$mg03_tel02|$mg03_tel03";
$sql04 = "update $write_table set wr_4 = '$wr_04' where wr_id = '$wr_id'";
sql_query($sql04) //3 ♧ 담당 매니저 연락처

$wr_05 = "$mg040";
$sql05 = "update $write_table set wr_5 = '$wr_05' where wr_id = '$wr_id'";
sql_query($sql05) // ♧ 담당 매니저 이메일

$wr_06 = "$mg050";
$sql06 = "update $write_table set wr_6 = '$wr_06' where wr_id = '$wr_id'";
sql_query($sql06) // ♧ 담당 매니저 한마디 (txt)

$wr_07 = "$mg060";
$sql07 = "update $write_table set wr_7 = '$wr_07' where wr_id = '$wr_id'";
sql_query($sql07) // ♣ 담당 팀장 코드

$wr_08 = "$mg070";
$sql08 = "update $write_table set wr_8 = '$wr_08' where wr_id = '$wr_id'";
sql_query($sql08) // ♣ 당당 팀장

$wr_09 = "$mg08_tel01|$mg08_tel02|$mg08_tel03";
$sql09 = "update $write_table set wr_9 = '$wr_09' where wr_id = '$wr_id'";
sql_query($sql09) //3 ♣ 담당 팀장연락처

$wr_10 = "$mg090";
$sql10 = "update $write_table set wr_10 = '$wr_10' where wr_id = '$wr_id'";
sql_query($sql10) // ♣ 담당 팀장 코치 (txt)

$wr_11 = "$sys010";
$sql11 = "update $write_table set wr_11 = '$wr_11' where wr_id = '$wr_id'";
sql_query($sql11) // ♡ 결혼구분

$wr_12 = "$sys020";
$sql12 = "update $write_table set wr_12 = '$wr_12' where wr_id = '$wr_id'";
sql_query($sql12) // ♡ 회원상태

$wr_13 = "$sys030";
$sql13 = "update $write_table set wr_13 = '$wr_13' where wr_id = '$wr_id'";
sql_query($sql13) // ♡ 회원번호

$wr_14 = "$sys040";
$sql14 = "update $write_table set wr_14 = '$wr_14' where wr_id = '$wr_id'";
sql_query($sql14) // ♡ 가입경로

$wr_15 = "$sys050";
$sql15 = "update $write_table set wr_15 = '$wr_15' where wr_id = '$wr_id'";
sql_query($sql15) // ♡ 연결상태

$wr_16 = "$sys06_fyy|$sys06_fmm|$sys06_fdd";
$sql16 = "update $write_table set wr_16 = '$wr_16' where wr_id = '$wr_id'";
sql_query($sql16) //3 ♡ 최초연결

$wr_17 = "$sys07_lyy|$sys07_lmm|$sys07_ldd";
$sql17 = "update $write_table set wr_17 = '$wr_17' where wr_id = '$wr_id'";
sql_query($sql17) //3 ♡ 최종연결

$wr_18 = "$sys080";
$sql18 = "update $write_table set wr_18 = '$wr_18' where wr_id = '$wr_id'";
sql_query($sql18) // ♡ 상품

$wr_19 = "$sys090";
$sql19 = "update $write_table set wr_19 = '$wr_19' where wr_id = '$wr_id'";
sql_query($sql19) // ♡ 비용

$wr_20 = "$sys100";
$sql20 = "update $write_table set wr_20 = '$wr_20' where wr_id = '$wr_id'";
sql_query($sql20) // ♡ 결재상태

$wr_21 = "$pf010";
$sql21 = "update $write_table set wr_21 = '$wr_21' where wr_id = '$wr_id'";
sql_query($sql21) // · 이름 v

$wr_22 = "$pf020";
$sql22 = "update $write_table set wr_22 = '$wr_22' where wr_id = '$wr_id'";
sql_query($sql22) // · 애칭

$wr_23 = "$pf030";
$sql23 = "update $write_table set wr_23 = '$wr_23' where wr_id = '$wr_id'";
sql_query($sql23) // · 성별 v

$wr_24 = "$pf04_jumin1|$pf04_jumin2";
$sql24 = "update $write_table set wr_24 = '$wr_24' where wr_id = '$wr_id'";
sql_query($sql24) //2 · 주민번호

$wr_25 = "$pf05_birth1|$pf05_birth2|$pf05_birth3|$pf05_birth4";
$sql25 = "update $write_table set wr_25 = '$wr_25' where wr_id = '$wr_id'";
sql_query($sql25) //4 · 생년월일

$wr_26 = "$pf060";
$sql26 = "update $write_table set wr_26 = '$wr_26' where wr_id = '$wr_id'";
sql_query($sql26) // · 나이

$wr_27 = "$pf070";
$sql27 = "update $write_table set wr_27 = '$wr_27' where wr_id = '$wr_id'";
sql_query($sql27) // · 띠

$wr_28 = "$pf080";
$sql28 = "update $write_table set wr_28 = '$wr_28' where wr_id = '$wr_id'";
sql_query($sql28) // · 별자리

$wr_29 = "$pf09_home1|$pf09_home2";
$sql29 = "update $write_table set wr_29 = '$wr_29' where wr_id = '$wr_id'";
sql_query($sql29) //2 · 고향

$wr_30 = "$pf10_tel01|$pf10_tel02|$pf10_tel03";
$sql30 = "update $write_table set wr_30 = '$wr_30' where wr_id = '$wr_id'";
sql_query($sql30) //3 · 전화번호

$wr_31 = "$pf11_hp01|$pf11_hp02|$pf11_hp03";
$sql31 = "update $write_table set wr_31 = '$wr_31' where wr_id = '$wr_id'";
sql_query($sql31) //3 · 휴대폰 v

$wr_32 = "$pf120";
$sql32 = "update $write_table set wr_32 = '$wr_32' where wr_id = '$wr_id'";
sql_query($sql32) // · 이메일 v

$wr_33 = "$pf130";
$sql33 = "update $write_table set wr_33 = '$wr_33' where wr_id = '$wr_id'";
sql_query($sql33) // · 홈페이지

$wr_34 = "$pf14_zip1|$pf14_zip2|$pf14_add1|$pf14_add2";
$sql34 = "update $write_table set wr_34 = '$wr_34' where wr_id = '$wr_id'";
sql_query($sql34) //4 · 주소

$wr_35 = "$pf15_scp1|$pf15_scp2|$pf15_scp3|$pf15_scp4";
$sql35 = "update $write_table set wr_35 = '$wr_35' where wr_id = '$wr_id'";
sql_query($sql35) //4 · 학력(학교명/학교/학년/전공)

$wr_36 = "$pf160";
$sql36 = "update $write_table set wr_36 = '$wr_36' where wr_id = '$wr_id'";
sql_query($sql36) // · 학위

$wr_37 = "$pf170";
$sql37 = "update $write_table set wr_37 = '$wr_37' where wr_id = '$wr_id'";
sql_query($sql37) // · 사회경력

$wr_38 = "$pf180";
$sql38 = "update $write_table set wr_38 = '$wr_38' where wr_id = '$wr_id'";
sql_query($sql38) // · 종교

$wr_39 = "$pf19_job1|$pf19_job2";
$sql39 = "update $write_table set wr_39 = '$wr_39' where wr_id = '$wr_id'";
sql_query($sql39) //2 · 직업

$wr_40 = "$pf200";
$sql40 = "update $write_table set wr_40 = '$wr_40' where wr_id = '$wr_id'";
sql_query($sql40) // · 직위

$wr_41 = "$pf210";
$sql41 = "update $write_table set wr_41 = '$wr_41' where wr_id = '$wr_id'";
sql_query($sql41) // · 년봉

$wr_42 = "$pf220";
$sql42 = "update $write_table set wr_42 = '$wr_42' where wr_id = '$wr_id'";
sql_query($sql42) // · 주거형태

$wr_43 = "$pf230";
$sql43 = "update $write_table set wr_43 = '$wr_43' where wr_id = '$wr_id'";
sql_query($sql43) // · 주거소유

$wr_44 = "$pf240";
$sql44 = "update $write_table set wr_44 = '$wr_44' where wr_id = '$wr_id'";
sql_query($sql44) // · 승용차소유

$wr_45 = "$pf251|$pf252|$pf253|";
$sql45 = "update $write_table set wr_45 = '$wr_45' where wr_id = '$wr_id'";
sql_query($sql45) //3 · 가족관계

$wr_46 = "$pf261|$pf262";
$sql46 = "update $write_table set wr_46 = '$wr_46' where wr_id = '$wr_id'";
sql_query($sql46) //2 · 부모님나이

$wr_47 = "$pf270";
$sql47 = "update $write_table set wr_47 = '$wr_47' where wr_id = '$wr_id'";
sql_query($sql47) // · 부모님동거관계

$wr_48 = "$pf280";
$sql48 = "update $write_table set wr_48 = '$wr_48' where wr_id = '$wr_id'";
sql_query($sql48) // · 재혼의경우(사별/이혼)

$wr_49 = "$pf291|$pf292";
$sql49 = "update $write_table set wr_49 = '$wr_49' where wr_id = '$wr_id'";
sql_query($sql49) //2 · 재혼의경우자녀(남,여)

$wr_50 = "$pf300";
$sql50 = "update $write_table set wr_50 = '$wr_50' where wr_id = '$wr_id'";
sql_query($sql50) // · 본관

$wr_51 = "$pf310";
$sql51 = "update $write_table set wr_51 = '$wr_51' where wr_id = '$wr_id'";
sql_query($sql51) // · 외모

$wr_52 = "$pf320";
$sql52 = "update $write_table set wr_52 = '$wr_52' where wr_id = '$wr_id'";
sql_query($sql52) // · 체형

$wr_53 = "$pf330";
$sql53 = "update $write_table set wr_53 = '$wr_53' where wr_id = '$wr_id'";
sql_query($sql53) // · 신장

$wr_54 = "$pf340";
$sql54 = "update $write_table set wr_54 = '$wr_54' where wr_id = '$wr_id'";
sql_query($sql54) // · 몸무게

$wr_55 = "$pf350";
$sql55 = "update $write_table set wr_55 = '$wr_55' where wr_id = '$wr_id'";
sql_query($sql55) // · 혈액형

$wr_56 = "$pf360";
$sql56 = "update $write_table set wr_56 = '$wr_56' where wr_id = '$wr_id'";
sql_query($sql56) // · 병역

$wr_57 = "$pf370";
$sql57 = "update $write_table set wr_57 = '$wr_57' where wr_id = '$wr_id'";
sql_query($sql57) // · 안경착용

$wr_58 = "$pf380";
$sql58 = "update $write_table set wr_58 = '$wr_58' where wr_id = '$wr_id'";
sql_query($sql58) // · 흡연

$wr_59 = "$pf390";
$sql59 = "update $write_table set wr_59 = '$wr_59' where wr_id = '$wr_id'";
sql_query($sql59) // · 음주

$wr_60 = "$pf400";
$sql60 = "update $write_table set wr_60 = '$wr_60' where wr_id = '$wr_id'";
sql_query($sql60) // · 건강상태

$wr_61 = "$pf410";
$sql61 = "update $write_table set wr_61 = '$wr_61' where wr_id = '$wr_id'";
sql_query($sql61) // · 첫인상

$wr_62 = "$pf420";
$sql62 = "update $write_table set wr_62 = '$wr_62' where wr_id = '$wr_id'";
sql_query($sql62) // · 성격

$wr_63 = "$pf430";
$sql63 = "update $write_table set wr_63 = '$wr_63' where wr_id = '$wr_id'";
sql_query($sql63) // · 취미

$wr_64 = "$pf440";
$sql64 = "update $write_table set wr_64 = '$wr_64' where wr_id = '$wr_id'";
sql_query($sql64) // · 특기

$wr_65 = "$pf450";
$sql65 = "update $write_table set wr_65 = '$wr_65' where wr_id = '$wr_id'";
sql_query($sql65) // · 나의 매력 (txt)

$wr_66 = "$hope010";
$sql66 = "update $write_table set wr_66 = '$wr_66' where wr_id = '$wr_id'";
sql_query($sql66) // ♥ 성별

$wr_67 = "$hope020";
$sql67 = "update $write_table set wr_67 = '$wr_67' where wr_id = '$wr_id'";
sql_query($sql67) // ♥ 연령

$wr_68 = "$hope030";
$sql68 = "update $write_table set wr_68 = '$wr_68' where wr_id = '$wr_id'";
sql_query($sql68) // ♥ 혈액형

$wr_69 = "$hope040";
$sql69 = "update $write_table set wr_69 = '$wr_69' where wr_id = '$wr_id'";
sql_query($sql69) // ♥ 체형

$wr_70 = "$hope050";
$sql70 = "update $write_table set wr_70 = '$wr_70' where wr_id = '$wr_id'";
sql_query($sql70) // ♥ 신장

$wr_71 = "$hope060";
$sql71 = "update $write_table set wr_71 = '$wr_71' where wr_id = '$wr_id'";
sql_query($sql71) // ♥ 몸무게

$wr_72 = "$hope070";
$sql72 = "update $write_table set wr_72 = '$wr_72' where wr_id = '$wr_id'";
sql_query($sql72) // ♥ 안경착용

$wr_73 = "$hope080";
$sql73 = "update $write_table set wr_73 = '$wr_73' where wr_id = '$wr_id'";
sql_query($sql73) // ♥ 흡연

$wr_74 = "$hope090";
$sql74 = "update $write_table set wr_74 = '$wr_74' where wr_id = '$wr_id'";
sql_query($sql74) // ♥ 음주

$wr_75 = "$hope100";
$sql75 = "update $write_table set wr_75 = '$wr_75' where wr_id = '$wr_id'";
sql_query($sql75) // ♥ 종교

$wr_76 = "$hope110";
$sql76 = "update $write_table set wr_76 = '$wr_76' where wr_id = '$wr_id'";
sql_query($sql76) // ♥ 학력

$wr_77 = "$hope121_job1|$hope121_job2";
$sql77 = "update $write_table set wr_77 = '$wr_77' where wr_id = '$wr_id'";
sql_query($sql77) //2 ♥ 직업 1차

$wr_78 = "$hope122_job1|$hope122_job2";
$sql78 = "update $write_table set wr_78 = '$wr_78' where wr_id = '$wr_id'";
sql_query($sql78) //2 ♥ 직업 2차

$wr_79 = "$hope123_job1|$hope123_job2";
$sql79 = "update $write_table set wr_79 = '$wr_79' where wr_id = '$wr_id'";
sql_query($sql79) //2 ♥ 직업 3차

$wr_80 = "$hope130";
$sql80 = "update $write_table set wr_80 = '$wr_80' where wr_id = '$wr_id'";
sql_query($sql80) // ♥ 연소득

$wr_81 = "$hope150";
$sql81 = "update $write_table set wr_81 = '$wr_81' where wr_id = '$wr_id'";
sql_query($sql81) // ♥ 주거형태

$wr_82 = "$hope160";
$sql82 = "update $write_table set wr_82 = '$wr_82' where wr_id = '$wr_id'";
sql_query($sql82) // ♥ 주거소유

$wr_83 = "$hope170";
$sql83 = "update $write_table set wr_83 = '$wr_83' where wr_id = '$wr_id'";
sql_query($sql83) // ♥ 승용차소유

$wr_84 = "$hope180";
$sql84 = "update $write_table set wr_84 = '$wr_84' where wr_id = '$wr_id'";
sql_query($sql84) // ♥ 첫인상

$wr_85 = "$hope190";
$sql85 = "update $write_table set wr_85 = '$wr_85' where wr_id = '$wr_id'";
sql_query($sql85) // ♥ 성격

$wr_86 = "$hope200";
$sql86 = "update $write_table set wr_86 = '$wr_86' where wr_id = '$wr_id'";
sql_query($sql86) // ♥ 특기

$wr_87 = "$hope210";
$sql87 = "update $write_table set wr_87 = '$wr_87' where wr_id = '$wr_id'";
sql_query($sql87) // ♥ 취미

$wr_88 = "$hope220";
$sql88 = "update $write_table set wr_88 = '$wr_88' where wr_id = '$wr_id'";
sql_query($sql88) // ♥ 상대혼인경력

$wr_89 = "$hope230";
$sql89 = "update $write_table set wr_89 = '$wr_89' where wr_id = '$wr_id'";
sql_query($sql89) // ♥ 배우자선택기준 (txt)

$wr_90 = "$hope240";
$sql90 = "update $write_table set wr_90 = '$wr_90' where wr_id = '$wr_id'";
sql_query($sql90) // ♥ 나의이상형 (txt)

}
?>

댓글 전체

와 진짜 어렵게 쓰셨네요.

등록폼이 너무 많아 테스트 안해봤는데 우선 소스정리부터 하셔야 될꺼 같습니다.
위처럼 적으시면 sql_query 를 너무 많이 부르니까

if($wr_01 == ""){$wr_01 = "Y";} //승인유무("Y"자동승인)
$sql01= "update $write_table set wr_1 = '$wr_01' where wr_id = '$wr_id'";
    sql_query($sql01);

$wr_02 = "$mg010";
$sql02 = "update $write_table set wr_2 = '$wr_02' where wr_id = '$wr_id'";
sql_query($sql02) // ♧ 담당 매니저 코드

$wr_03 = "mg020";
$sql03 = "update $write_table set wr_3 = '$wr_03' where wr_id = '$wr_id'";
sql_query($sql03) // ♧ 담당 매니저


이런식으로 된것을

if($wr_01 == ""){$wr_01 = "Y";} //승인유무("Y"자동승인)
$wr_02 = "$mg010";
$wr_03 = "mg020";

$sql = "update $write_table set wr_1 = '$wr_01' ,wr_2 = '$wr_02' ,wr_3 = '$wr_03' where wr_id = '$wr_id'";
sql_query($sql) ;

이런식으로 바꾸세요..
진작에 바꿀걸....
설마설마 했었는데 다시수정할 노가다 귀찮아서 머뭇거리고 있었는데..
알고 나니 역시 기초의 중요함이 느껴 집니다.
전체 66,554 |RSS
그누4 질문답변 내용 검색

회원로그인

(주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1402호 / E-Mail: admin@sir.kr
사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
© SIRSOFT