묻고답하기
page_full_width" class="col-xs-12" |cond="$__Context->page_full_width">
XE와 타게임서버 연동 부분에서 문제
2009.04.11 21:57
안녕하세요?
XE 회원가입시 게임 회원가입도 되게 제작중입니다만...
문제가 발생하였습니다.
파일:xe\modules\member\member.controller.php
insertMember함수내에서
// 금지 아이디인지 체크
if($oMemberModel->isDeniedID($args->user_id)) return new Object(-1,'denied_user_id');
// 아이디, 닉네임, email address 의 중복 체크
$member_srl = $oMemberModel->getMemberSrlByUserID($args->user_id);
if($member_srl) return new Object(-1,'msg_exists_user_id');
$member_srl = $oMemberModel->getMemberSrlByNickName($args->nick_name);
if($member_srl) return new Object(-1,'msg_exists_nick_name');
$member_srl = $oMemberModel->getMemberSrlByEmailAddress($args->email_address);
if($member_srl) return new Object(-1,'msg_exists_email_address');
// 베틀넷 가입
$pvpgndb = mysql_connect("localhost","비공개","비공개");
mysql_select_db("공개", $pvpgndb);
$pvpgndata=mysql_fetch_row(mysql_query("SELECT * FROM `pvpgn2_BNET` WHERE `acct_username` = '$args->user_id' or `acct_email` = '$args->email_address'",$pvpgndb));
if($pvpgndata[0]!=NULL){
echo "에러:베틀넷에 가입중입니다. 게시판에 비밀글로 기존의 아이디 비밀번호를 남겨주시면 수동 회원가입 시켜드리겠습니다.";
exit();
}
$pvpgndata = mysql_fetch_row(mysql_query("SELECT count(*) FROM pvpgn2_BNET",$pvpgndb));
$pvpgn_uid = $pvpgndata[0];
include("/data/website/shlee322/aram.lecl.net/battlenet/pvpgn_hash.inc.php");
$pvpgn_pass = pvpgn_hash($args->password);
$pvpgndb_query = "INSERT INTO pvpgn2_BNET(uid,acct_username,username,acct_userid,acct_passhash1,acct_email) VALUES ('$pvpgn_uid','$args->user_id','$args->user_id','$pvpgn_uid','$pvpgn_pass','$args->email_address');";
mysql_query($pvpgndb_query,$pvpgndb);
mysql_close($pvpgndb);
$oDB = &DB::getInstance();
$oDB->begin();
// DB에 입력
$args->member_srl = getNextSequence();
if($args->password && !$password_is_hashed) $args->password = md5($args->password);
elseif(!$args->password) unset($args->password);
회원가입요청시 창이뜨면서
---------------------------
Microsoft Internet Explorer
---------------------------
<br />
<b>Warning</b>: mysql_insert_id() [<a href='function.mysql-insert-id'>function.mysql-insert-id</a>]: A link to the server could not be established in <b>XE경로/classes/db/DBMysql.class.php</b> on line <b>186</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>346</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>356</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>357</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>358</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>359</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>360</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>361</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>125</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>125</b><br />
<response>
<error>1062</error>
<message>Duplicate entry '0' for key 1</message>
</response>
---------------------------
확인
---------------------------
이러한 에러메시지가 발생합니다 무엇이 문제일까요?
XE 회원가입시 게임 회원가입도 되게 제작중입니다만...
문제가 발생하였습니다.
파일:xe\modules\member\member.controller.php
insertMember함수내에서
// 금지 아이디인지 체크
if($oMemberModel->isDeniedID($args->user_id)) return new Object(-1,'denied_user_id');
// 아이디, 닉네임, email address 의 중복 체크
$member_srl = $oMemberModel->getMemberSrlByUserID($args->user_id);
if($member_srl) return new Object(-1,'msg_exists_user_id');
$member_srl = $oMemberModel->getMemberSrlByNickName($args->nick_name);
if($member_srl) return new Object(-1,'msg_exists_nick_name');
$member_srl = $oMemberModel->getMemberSrlByEmailAddress($args->email_address);
if($member_srl) return new Object(-1,'msg_exists_email_address');
// 베틀넷 가입
$pvpgndb = mysql_connect("localhost","비공개","비공개");
mysql_select_db("공개", $pvpgndb);
$pvpgndata=mysql_fetch_row(mysql_query("SELECT * FROM `pvpgn2_BNET` WHERE `acct_username` = '$args->user_id' or `acct_email` = '$args->email_address'",$pvpgndb));
if($pvpgndata[0]!=NULL){
echo "에러:베틀넷에 가입중입니다. 게시판에 비밀글로 기존의 아이디 비밀번호를 남겨주시면 수동 회원가입 시켜드리겠습니다.";
exit();
}
$pvpgndata = mysql_fetch_row(mysql_query("SELECT count(*) FROM pvpgn2_BNET",$pvpgndb));
$pvpgn_uid = $pvpgndata[0];
include("/data/website/shlee322/aram.lecl.net/battlenet/pvpgn_hash.inc.php");
$pvpgn_pass = pvpgn_hash($args->password);
$pvpgndb_query = "INSERT INTO pvpgn2_BNET(uid,acct_username,username,acct_userid,acct_passhash1,acct_email) VALUES ('$pvpgn_uid','$args->user_id','$args->user_id','$pvpgn_uid','$pvpgn_pass','$args->email_address');";
mysql_query($pvpgndb_query,$pvpgndb);
mysql_close($pvpgndb);
$oDB = &DB::getInstance();
$oDB->begin();
// DB에 입력
$args->member_srl = getNextSequence();
if($args->password && !$password_is_hashed) $args->password = md5($args->password);
elseif(!$args->password) unset($args->password);
회원가입요청시 창이뜨면서
---------------------------
Microsoft Internet Explorer
---------------------------
<br />
<b>Warning</b>: mysql_insert_id() [<a href='function.mysql-insert-id'>function.mysql-insert-id</a>]: A link to the server could not be established in <b>XE경로/classes/db/DBMysql.class.php</b> on line <b>186</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>346</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>356</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>357</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>358</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>359</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>360</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>361</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>125</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at XE경로/classes/db/DBMysql.class.php:186) in <b>XE경로/classes/display/DisplayHandler.class.php</b> on line <b>125</b><br />
<response>
<error>1062</error>
<message>Duplicate entry '0' for key 1</message>
</response>
---------------------------
확인
---------------------------
이러한 에러메시지가 발생합니다 무엇이 문제일까요?
댓글 0
글쓴이 | 제목 | 최종 글 |
---|---|---|
XE | 공지 글 쓰기,삭제 운영방식 변경 공지 [16] | 2019.03.05 by 남기남 |
CutyME | 서버이전후 이상한 현상에 질문드립니다 [1] | 2011.04.15 by fsfsdas |
ksdwm72 | XE 다시 설치에 대해 궁금합니다. [1] | 2011.04.15 by 카르마 |
등대602 | 페이지 수정에 관해 여쭙니다 | |
Yosida | 게시판 하나로 모든 게시판의 글을 가져올수있나요? [1] | 2011.04.15 by 레디오빠 |
ruka332 | 로그인 불가능문제.. [5] | 2011.04.15 by ruka332 |
아기둘 | 쪽지 일괄삭제건 문의입니다. | |
나비웹 | 일반 회사 홈페이지 제작 [1] | 2011.04.15 by 용이132 |
racer69 | 관리자 페이지 댓글 목록수 조정하는 소스수정은 어떻게 하나요? [4] | 2011.04.15 by 레디오빠 |
DaKi | 모바일에서 파일 첨부 문제/이미지 축소 배율 문제.. | |
themarkers | XE의 쇼케이스 모듈스킨은 없나요? | |
IronEagle | 메뉴설정에서 리스트가 안보이네요. | |
무비클립 | jQuery 팁 좀 부탁드립니다.. [1] | 2011.04.15 by ForHanbi |
이승용924 | 게시판 글을 트위터로 보내는 방법 [1] | 2011.04.15 by 레디오빠 |
샐리가든 | 링크게시판 뭘로 사용하시는지...??? [1] | 2011.04.15 by 레디오빠 |
네울 | 문자열줄이기 문의합니다. (xe문법) [1] | 2011.04.15 by 용이132 |
필승의전세 | livexe RSS수집 문의 | |
Spes | 텍스타일 주소 어떻게 방법이 없을까요? | |
Huckleberry Finn | 탭 형태 최근 문서 출력 [2] | 2011.04.15 by 오르막 |
artspace | 설치 도와주세요~ [1] | 2011.04.15 |
무비클립 | 구글 크롬에 부가기능 설정방법좀 알려주세요 |