묻고답하기
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>
---------------------------
확인
---------------------------
이러한 에러메시지가 발생합니다 무엇이 문제일까요?