//////////////////////////////////////////////////////////////////////////////
// 이 패킷은 클라이언트가 아이디와 패스워드를 암호화해서
// 로그인 서버로 전송한다. 로그인 서버는 이 패킷을 받아서
// 플레이어의 아이디와 패스워드가 정확한지 DB로부터 읽어서
// 비교한 후, 로그인의 성공 여부를 전송한다.
//////////////////////////////////////////////////////////////////////////////
void CLAgreementHandler::execute (CLAgreement* pPacket , Player* pPlayer)
throw(ProtocolException , Error)
{
__BEGIN_TRY __BEGIN_DEBUG_EX
#ifdef __LOGIN_SERVER__
#ifdef __NETMARBLE_SERVER__
Assert(pPacket != NULL);
Assert(pPlayer != NULL);
LoginPlayer* pLoginPlayer = dynamic_cast<LoginPlayer*>(pPlayer);
Assert(pLoginPlayer != NULL);
if (pPacket->isAgree() )
{
Statement* pStmt = NULL;
BEGIN_DB
{
//----------------------------------------------------------------------
// 넷마블 약관 미동의 리스트에서 삭제
//----------------------------------------------------------------------
pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
pStmt->executeQuery("DELETE FROM PrivateAgreementRemain WHERE PlayerID = '%s'", pLoginPlayer->getID().c_str());
// 다음 단계로 진행할 수 있게 설정
pLoginPlayer->setAgree(true);
SAFE_DELETE(pStmt);
}
END_DB(pStmt)
}
void CLCreatePCHandler::execute (CLCreatePC* pPacket , Player* pPlayer)
throw(ProtocolException , Error)
{
__BEGIN_TRY __BEGIN_DEBUG_EX
#ifdef __LOGIN_SERVER__
Assert(pPacket != NULL);
Assert(pPlayer != NULL);
LoginPlayer* pLoginPlayer = dynamic_cast<LoginPlayer*>(pPlayer);
Statement* pStmt = NULL;
Result* pResult = NULL;
LCCreatePCError lcCreatePCError;
WorldID_t WorldID = pLoginPlayer->getWorldID();
#ifdef __CONNECT_CBILLING_SYSTEM__
if (pLoginPlayer->isCBillingVerified() )
{
if (!pLoginPlayer->isPayPlayer() )
{
lcCreatePCError.setErrorID(CANNOT_CREATE_PC_BILLING);
pLoginPlayer->sendPacket(&lcCreatePCError);
return;
}
}
else
{
lcCreatePCError.setErrorID(CANNOT_AUTHORIZE_BILLING);
pLoginPlayer->sendPacket(&lcCreatePCError);
return;
}
#endif
try
{
pStmt = g_pDatabaseManager->getConnection((TID)WorldID )->createStatement();
// 시스템에서 사용하거나, 금지된 이름은 아닌기 검증한다.
// NONE, ZONE***, INV***, QUICK...
//string text = pPacket->getName();
if (!isAvailableID(pPacket->getName().c_str() ))
{
lcCreatePCError.setErrorID(ALREADY_REGISTER_ID);
throw DuplicatedException("이미 존재하는 아이디입니다.");
}
/*
list<string>::const_iterator itr = InvalidTokenList.begin();
for (; itr != InvalidTokenList.end(); itr++)
{
if (text.find(*itr) != string::npos)
{
lcCreatePCError.setErrorID(ALREADY_REGISTER_ID);
throw DuplicatedException("이미 존재하는 아이디입니다.");
}
}
*/
#if defined(__THAILAND_SERVER__) || defined(__CHINA_SERVER__)
/*
* 태국어 문자셋 tis620 thailand charset 에서 허용하는 문자만을 케릭터 이름으로
* 쓸 수 있도록 제어한다.
*
* */
/*
* 중국어 문자코드셋 gb2312-simple chinese 에서 허용하는 문자만을 케릭터 이름으로
* 쓸 수 있도록 제어한다.
*
* */
string tmpStr = pPacket->getName();
bool isAllowStr = isAllowString(tmpStr);
if(isAllowStr == false)
{
lcCreatePCError.setErrorID(ETC_ERROR);
throw DuplicatedException("허용하지 않는 문자가 포함되어 있음");
}
#endif
// 이미 존재하는 캐릭터 이름이 아닌지 검증한다.
///*
pResult = pStmt->executeQuery("SELECT Name FROM Slayer WHERE Name = '%s'", pPacket->getName().c_str());
if (pResult->getRowCount() != 0)
{
lcCreatePCError.setErrorID(ALREADY_REGISTER_ID);
throw DuplicatedException("이미 존재하는 아이디입니다.");
}
// 해당 슬랏에 캐릭터가 이미 있지는 않은지 검증한다.
pResult = pStmt->executeQuery("SELECT Name FROM Slayer WHERE PlayerID ='%s' and Slot ='%s' AND Active='ACTIVE'", pLoginPlayer->getID().c_str(), Slot2String[pPacket->getSlot()].c_str());
if (pResult->getRowCount() != 0)
{
lcCreatePCError.setErrorID(ALREADY_REGISTER_ID);
throw DuplicatedException("이미 존재하는 아이디입니다.");
}
//*/
// 두 쿼리를 하나로. 2002. 7. 13 by sigi. 이거 안좋다. - -;
/*
pResult = pStmt->executeQuery("SELECT Name FROM Slayer WHERE Name='%s' OR PlayerID='%s' AND Slot='%s'",
pPacket->getName().c_str(),
pLoginPlayer->getID().c_str(),
Slot2String[pPacket->getSlot()].c_str());
if (pResult->getRowCount() != 0)
{
lcCreatePCError.setErrorID(ALREADY_REGISTER_ID);
throw DuplicatedException("이미 존재하는 아이디입니다.");
}
*/
// 잘못된 능력치를 가지고 캐릭터를 생성하려 하는 것은 아닌지 검증한다.
bool bInvalidAttr = false;
int nSTR = pPacket->getSTR();
int nSTRExp = 0;
int nSTRGoalExp = 0;
int nDEX = pPacket->getDEX();
int nDEXExp = 0;
int nDEXGoalExp = 0;
int nINT = pPacket->getINT();
int nINTExp = 0;
int nINTGoalExp = 0;
//int Rank = 1;
//int RankExp = 0;
//
static int RankGoalExpSlayer = -1;
static int GoalExpVampire = -1; // by sigi. 2002.12.20
static int RankGoalExpVampire = -1;
static int GoalExpOusters = -1;
static int RankGoalExpOusters = -1;
if (RankGoalExpSlayer==-1)
{
pResult = pStmt->executeQuery("SELECT GoalExp FROM RankEXPInfo WHERE Level=1 AND RankType=0");
if (pResult->next()) RankGoalExpSlayer = pResult->getInt(1);
}
if (GoalExpVampire==-1) // by sigi. 2002.12.20
{
pResult = pStmt->executeQuery("SELECT GoalExp FROM VampEXPBalanceInfo WHERE Level=1");
if (pResult->next()) GoalExpVampire = pResult->getInt(1);
}
if (GoalExpOusters==-1)
{
pResult = pStmt->executeQuery("SELECT GoalExp FROM OustersEXPBalanceInfo WHERE Level=1");
if (pResult->next()) GoalExpOusters = pResult->getInt(1);
}
if (RankGoalExpVampire==-1)
{
pResult = pStmt->executeQuery("SELECT GoalExp FROM RankEXPInfo WHERE Level=1 AND RankType=1");
if (pResult->next()) RankGoalExpVampire = pResult->getInt(1);
}
if (RankGoalExpOusters==-1)
{
pResult = pStmt->executeQuery("SELECT GoalExp FROM RankEXPInfo WHERE Level=1 AND RankType=2");
if (pResult->next()) RankGoalExpOusters = pResult->getInt(1);
}
if (pPacket->getRace() == RACE_SLAYER)
{
if (nSTR < 5 || nSTR > 20) bInvalidAttr = true;
if (nDEX < 5 || nDEX > 20) bInvalidAttr = true;
if (nINT < 5 || nINT > 20) bInvalidAttr = true;
if (nSTR + nDEX + nINT > 30) bInvalidAttr = true;
//cout << "Slayer: " << nSTR << ", " << nDEX << ", " << nINT << endl;
}
else if (pPacket->getRace() == RACE_VAMPIRE ) // vampire인 경우. 무조건 20. by sigi. 2002.10.31
{
if (nSTR != 20
|| nDEX != 20
|| nINT != 20)
{
bInvalidAttr = true;
}
else
{
// 정상적인 vampire인 경우
// Slayer의 능력치를 다시 설정해줘야 한다. -_-;
// by sigi. 2002.11.7
nSTR = 5 + rand()%16; // 5~20
nDEX = 5 + rand()%(21-nSTR);
nINT = 30 - nSTR - nDEX;
pPacket->setSTR(nSTR);
pPacket->setDEX(nDEX);
pPacket->setINT(nINT);
}
//
//cout << "Vampire: " << nSTR << ", " << nDEX << ", " << nINT << endl;
}
else if (pPacket->getRace() == RACE_OUSTERS )
{
/* if (nSTR < 10 ) bInvalidAttr = true;
if (nDEX < 10 ) bInvalidAttr = true;
if (nINT < 10 ) bInvalidAttr = true;*/
if (nSTR < 10 || nDEX < 10 || nINT < 10 )
{
filelog("CreatePC.log", "Illegal PC Create [%s:%s] : %u/%u/%u", pPlayer->getID().c_str(), pPacket->getName().c_str(), nSTR, nDEX, nINT);
}
if (nSTR + nDEX + nINT != 45 )
bInvalidAttr = true;
}
if (bInvalidAttr)
{
SAFE_DELETE(pStmt);
throw InvalidProtocolException("CLCreatePCHandler::too large character attribute");
}
// 모든 검사를 만족했다면 이제 캐릭터를 생성한다.
ServerGroupID_t CurrentServerGroupID = pPlayer->getServerGroupID();
// 우헤헤.. 일단 쿼리를 줄일려고 static으로 삽질을 했다.
// 나중에 아예 로그인 서버 뜰때에 경험치 table들을 loading해 두도록해야할 것이다. 2002.7.13 by sigi
static int STRGoalExp[100] = { 0, };
static int STRAccumExp[100] = { 0, };
static int DEXGoalExp[100] = { 0, };
static int DEXAccumExp[100] = { 0, };
static int INTGoalExp[100] = { 0, };
static int INTAccumExp[100] = { 0, };
nSTRGoalExp = STRGoalExp[nSTR];
if (nSTRGoalExp==0)
{
pResult = pStmt->executeQuery("SELECT GoalExp FROM STRBalanceInfo WHERE Level = %d", nSTR);
if (pResult->next()) nSTRGoalExp = STRGoalExp[nSTR] = pResult->getInt(1);
}
nSTRExp = STRAccumExp[nSTR-1];
if (nSTRExp==0)
{
pResult = pStmt->executeQuery("SELECT AccumExp FROM STRBalanceInfo WHERE Level = %d", nSTR - 1);
if (pResult->next()) nSTRExp = STRAccumExp[nSTR-1] = pResult->getInt(1);
}
nDEXGoalExp = DEXGoalExp[nDEX];
if (nDEXGoalExp==0)
{
pResult = pStmt->executeQuery("SELECT GoalExp FROM DEXBalanceInfo WHERE Level = %d", nDEX);
if (pResult->next()) nDEXGoalExp = DEXGoalExp[nDEX] = pResult->getInt(1);
}
nDEXExp = DEXAccumExp[nDEX-1];
if (nDEXExp==0)
{
pResult = pStmt->executeQuery("SELECT AccumExp FROM DEXBalanceInfo WHERE Level = %d", nDEX - 1);
if (pResult->next()) nDEXExp = DEXAccumExp[nDEX-1] = pResult->getInt(1);
}
nINTGoalExp = INTGoalExp[nINT];
if (nINTGoalExp==0)
{
pResult = pStmt->executeQuery("SELECT GoalExp FROM INTBalanceInfo WHERE Level = %d", nINT);
if (pResult->next()) nINTGoalExp = INTGoalExp[nINT] = pResult->getInt(1);
}
nINTExp = INTAccumExp[nINT-1];
if (nINTExp==0)
{
pResult = pStmt->executeQuery("SELECT AccumExp FROM INTBalanceInfo WHERE Level = %d", nINT - 1);
if (pResult->next()) nINTExp = INTAccumExp[nINT-1] = pResult->getInt(1);
}
// 일단 복장은 없고.. 남/녀 구분만..
DWORD slayerShape = (pPacket->getSex()==1? 1 : 0);
DWORD vampireShape = slayerShape;
slayerShape |= (pPacket->getHairStyle() << PCSlayerInfo::SLAYER_BIT_HAIRSTYLE1);
Color_t HelmetColor = 0;
Color_t JacketColor = 0;
Color_t PantsColor = 0;
Color_t WeaponColor = 0;
Color_t ShieldColor = 0;
/*
StringStream slayerSQL;
slayerSQL << "INSERT INTO Slayer ("
<< " Race, Name, PlayerID, Slot, ServerGroupID, Active,"
<< " Sex, HairStyle, HairColor, SkinColor, Phone, "
<< " STR, STRExp, STRGoalExp, DEX, DEXExp, DEXGoalExp, INTE, INTExp, INTGoalExp, HP, CurrentHP, MP, CurrentMP,"
<< " ZoneID, XCoord, YCoord, Sight, Gold, Alignment,"
<< " Shape, HelmetColor, JacketColor, PantsColor, WeaponColor, ShieldColor,"
<< " creation_date) VALUES ('"
<< "SLAYER" << "', '"
<< pPacket->getName() << "', '"
<< pLoginPlayer->getID() << "', '"
<< Slot2String[pPacket->getSlot()] << "', "
<< (int)CurrentServerGroupID << " , "
<< "'ACTIVE', '"
<< Sex2String[pPacket->getSex()] << "', '"
<< HairStyle2String[pPacket->getHairStyle()] << "', "
<< (int)pPacket->getHairColor() << ", "
<< (int)pPacket->getSkinColor() << ", '"
<< (int)0 << "', "
<< (int)pPacket->getSTR() << ", "
<< nSTRExp << ", "
<< nSTRGoalExp << ", "
<< (int)pPacket->getDEX() << ", "
<< nDEXExp << ", "
<< nDEXGoalExp << ", "
<< (int)pPacket->getINT() << ", "
<< nINTExp << ", "
<< nINTGoalExp << ", "
<< (int)pPacket->getSTR()*2 << ","
<< (int)pPacket->getSTR()*2 << ","
<< (int)pPacket->getINT()*2 << ","
<< (int)pPacket->getINT()*2 << ","
<< "2101, 65, 45, 13, 0, 7500, "
<< slayerShape << ", "
<< (int)HelmetColor << ", "
<< (int)JacketColor << ", "
<< (int)PantsColor << ", "
<< (int)WeaponColor << ", "
<< (int)ShieldColor << ", "
<< "now() "
<< ")";
StringStream vampireSQL;
vampireSQL << "INSERT INTO Vampire ("
<< " Name, PlayerID, Slot, ServerGroupID, Active,"
<< " Sex, HairColor, SkinColor,"
<< " STR, DEX, INTE, HP, CurrentHP,"
<< " ZoneID, XCoord, YCoord, Sight, Alignment, Exp, GoalExp, Shape) VALUES ('"
<< pPacket->getName() << "', '"
<< pLoginPlayer->getID() << "', '"
<< Slot2String[pPacket->getSlot()] << "', "
<< (int)CurrentServerGroupID << " , "
<< "'ACTIVE', '"
<< Sex2String[pPacket->getSex()] << "', "
<< (int)pPacket->getHairColor() << ", "
<< (int)pPacket->getSkinColor() << ", "
<< "20, 20, 20, 50, 50, "
<< "2020, 233, 55, 13, 7500, 0, 125, "
<< vampireShape
<< ")";
pStmt->executeQuery(slayerSQL.toString());
pStmt->executeQuery(vampireSQL.toString());
*/
// 캐릭터 생성시에 뱀파이어를 선택할 수 있다.
// by sigi. 2002.10.31
string race;
switch (pPacket->getRace() )
{
case RACE_SLAYER:
race = "SLAYER";
break;
case RACE_VAMPIRE:
race = "VAMPIRE";
break;
case RACE_OUSTERS:
race = "OUSTERS";
break;
default:
lcCreatePCError.setErrorID(ETC_ERROR);
pLoginPlayer->sendPacket(&lcCreatePCError); // 클라이언트에게 PC 생성 실패 패킷을 날린다.
return;
}
pStmt->executeQuery(
"INSERT INTO Slayer (Race, Name, PlayerID, Slot, ServerGroupID, Active, Sex, HairStyle, HairColor, SkinColor, Phone, STR, STRExp, STRGoalExp, DEX, DEXExp, DEXGoalExp, INTE, INTExp, INTGoalExp, Rank, RankExp, RankGoalExp, HP, CurrentHP, MP, CurrentMP, ZoneID, XCoord, YCoord, Sight, Gold, Alignment, Shape, HelmetColor, JacketColor, PantsColor, WeaponColor, ShieldColor, creation_date) VALUES ('%s', '%s', '%s', '%s', %d, 'ACTIVE', '%s', '%s', %d, %d, 0, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, 12, 237, 138, 13, 0, 7500, %d, %d, %d, %d, %d, %d, now())",
race.c_str(),
pPacket->getName().c_str(),
pLoginPlayer->getID().c_str(),
Slot2String[pPacket->getSlot()].c_str(),
(int)CurrentServerGroupID,
Sex2String[pPacket->getSex()].c_str(),
HairStyle2String[pPacket->getHairStyle()].c_str(),
(int)pPacket->getHairColor(),
(int)pPacket->getSkinColor(),
(int)pPacket->getSTR(), nSTRExp, nSTRGoalExp,
(int)pPacket->getDEX(), nDEXExp, nDEXGoalExp,
(int)pPacket->getINT(), nINTExp, nINTGoalExp,
1, 0, RankGoalExpSlayer,
(int)pPacket->getSTR()*2,
(int)pPacket->getSTR()*2,
(int)pPacket->getINT()*2,
(int)pPacket->getINT()*2,
slayerShape,
(int)HelmetColor,
(int)JacketColor,
(int)PantsColor,
(int)WeaponColor,
(int)ShieldColor);
// 생성 위치 변경. by sigi. 2002.10.31
// 아우스터스로의 종족간 변신이 없으므로 둘중에 하나만 만든다.
// 근데 왠지 종족간 변신이 들어갈지도 모른다는 불길한 예간이 들고
// 항상 그런 예감들은 맞아 왔기때문에 언젠가 이 주석을 보고 둘다 풀어주는게....으아~~
if ( pPacket->getRace() != RACE_OUSTERS )
{
pStmt->executeQuery(
"INSERT INTO Vampire (Name, PlayerID, Slot, ServerGroupID, Active, Sex, SkinColor, STR, DEX, INTE, HP, CurrentHP, ZoneID, XCoord, YCoord, Sight, Alignment, Exp, GoalExp, Rank, RankExp, RankGoalExp, Shape, CoatColor) VALUES ('%s', '%s', '%s', %d, 'ACTIVE', '%s', %d, 20, 20, 20, 50, 50, 1003, 62, 64, 13, 7500, 0, %d, 1, 0, %d, %d, 377 )",
pPacket->getName().c_str(),
pLoginPlayer->getID().c_str(),
Slot2String[pPacket->getSlot()].c_str(),
(int)CurrentServerGroupID,
Sex2String[pPacket->getSex()].c_str(),
(int)pPacket->getSkinColor(),
GoalExpVampire, // by sigi. 2002.12.20
RankGoalExpVampire,
vampireShape);
} else
{
pStmt->executeQuery(
"INSERT INTO Ousters (Name, PlayerID, Slot, ServerGroupID, Active, Sex, STR, DEX, INTE, BONUS, HP, CurrentHP, MP, CurrentMP, ZoneID, XCoord, YCoord, Sight, Alignment, Exp, GoalExp, Rank, RankExp, RankGoalExp, CoatColor, HairColor, ArmColor, BootsColor ) Values ('%s', '%s', '%s', %d, 'ACTIVE', 'FEMALE', %d, %d, %d, 0, 50, 50, 50, 50, 1311, 24, 73, 13, 7500, 0, %d, 1, 0, %d, 377, %d, 377, 377 )",
pPacket->getName().c_str(),
pLoginPlayer->getID().c_str(),
Slot2String[pPacket->getSlot()].c_str(),
(int)CurrentServerGroupID,
(int)pPacket->getSTR(),
(int)pPacket->getDEX(),
(int)pPacket->getINT(),
GoalExpOusters,
RankGoalExpOusters,
(int)pPacket->getHairColor());
}
if (pPacket->getRace()==RACE_SLAYER)
{
pStmt->executeQuery("INSERT IGNORE INTO FlagSet (OwnerID, FlagData) VALUES ('%s','11110010001')", pPacket->getName().c_str());
}
else
{
pStmt->executeQuery("INSERT IGNORE INTO FlagSet (OwnerID, FlagData) VALUES ('%s','00000000001')", pPacket->getName().c_str());
}
// 클라이언트에게 PC 생성 성공 패킷을 날린다.
LCCreatePCOK lcCreatePCOK;
pLoginPlayer->sendPacket(&lcCreatePCOK);
pLoginPlayer->setPlayerStatus(LPS_WAITING_FOR_CL_GET_PC_LIST);
SAFE_DELETE(pStmt);
}
catch (DuplicatedException & de)
{
SAFE_DELETE(pStmt);
pLoginPlayer->sendPacket(&lcCreatePCError); // 클라이언트에게 PC 생성 실패 패킷을 날린다.
}
catch (SQLQueryException & sqe)
{
SAFE_DELETE(pStmt);
lcCreatePCError.setErrorID(ETC_ERROR);
pLoginPlayer->sendPacket(&lcCreatePCError); // 클라이언트에게 PC 생성 실패 패킷을 날린다.
}
#endif
__END_DEBUG_EX __END_CATCH
}
//////////////////////////////////////////////////////////////////////////////
// 클라이언트가 서버의 리스트를 달라고 요청해오면, 로그인 서버는 DB로부터
// 서버들의 정보를 로딩해서 LCServerList 패킷에 담아서 전송한다.
//////////////////////////////////////////////////////////////////////////////
void CLGetServerListHandler::execute (CLGetServerList* pPacket , Player* pPlayer)
throw(ProtocolException , Error)
{
__BEGIN_TRY __BEGIN_DEBUG_EX
#ifdef __LOGIN_SERVER__
Assert(pPacket != NULL);
Assert(pPlayer != NULL);
//cout << "Start execute" << endl;
LoginPlayer* pLoginPlayer = dynamic_cast<LoginPlayer*>(pPlayer);
WorldID_t WorldID = pLoginPlayer->getWorldID();
try
{
int GroupNum = g_pGameServerGroupInfoManager->getSize(WorldID);
//cout << "ServerNum : " << GroupNum << endl;
ServerGroupInfo* aServerGroupInfo[GroupNum];
for(int i = 0 ; i < GroupNum; i++)
{
ServerGroupInfo* pServerGroupInfo = new ServerGroupInfo();
GameServerGroupInfo* pGameServerGroupInfo = g_pGameServerGroupInfoManager->getGameServerGroupInfo(i, WorldID);
pServerGroupInfo->setGroupID(pGameServerGroupInfo->getGroupID());
pServerGroupInfo->setGroupName(pGameServerGroupInfo->getGroupName());
pServerGroupInfo->setStat(SERVER_FREE);
UserInfo * pUserInfo = g_pUserInfoManager->getUserInfo(pGameServerGroupInfo->getGroupID(), WorldID);
WORD UserModify = 800;
WORD UserMax = 1500;
if (pUserInfo->getUserNum() < 100 + UserModify )
{
pServerGroupInfo->setStat(SERVER_FREE);
}
else if (pUserInfo->getUserNum() < 250 + UserModify )
{
pServerGroupInfo->setStat(SERVER_NORMAL);
}
else if (pUserInfo->getUserNum() < 400 + UserModify )
{
pServerGroupInfo->setStat(SERVER_BUSY);
}
else if (pUserInfo->getUserNum() < 500 + UserModify )
{
pServerGroupInfo->setStat(SERVER_VERY_BUSY);
}
else //if (pUserInfo->getUserNum() >= 500 + UserModify )
{
pServerGroupInfo->setStat(SERVER_FULL);
}
//else
{
//pServerGroupInfo->setStat(SERVER_DOWN);
}
if (pUserInfo->getUserNum() >= UserMax)
{
pServerGroupInfo->setStat(SERVER_FULL);
}
if (pGameServerGroupInfo->getStat() == SERVER_DOWN )
{
pServerGroupInfo->setStat(SERVER_DOWN);
}
aServerGroupInfo[i] = pServerGroupInfo;
//cout << "AddServer : " << pServerGroupInfo->getGroupName() << endl;
}
LCServerList lcServerList;
Statement * pStmt = NULL;
BEGIN_DB
{
pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
Result * pResult = pStmt->executeQuery("SELECT CurrentWorldID, CurrentServerGroupID FROM Player where PlayerID='%s'" , pLoginPlayer->getID().c_str());
if(pResult->next() ) {
lcServerList.setCurrentServerGroupID(pResult->getInt(1));
lcServerList.setCurrentServerGroupID(pResult->getInt(2));
}
SAFE_DELETE(pStmt); // by sigi
}
END_DB(pStmt) // by sigi
for(int k = 0; k < GroupNum; k++)
{
lcServerList.addListElement(aServerGroupInfo[k]);
}
pLoginPlayer->sendPacket(&lcServerList);
pLoginPlayer->setPlayerStatus(LPS_PC_MANAGEMENT);
}
catch (Throwable & t)
{
//cout << t.toString() << endl;
}
//cout << "End execute" << endl;
#endif
__END_DEBUG_EX __END_CATCH
}
//////////////////////////////////////////////////////////////////////////////
// 클라이언트가 PC 의 리스트를 달라고 요청해오면, 로그인 서버는 DB로부터
// PC들의 정보를 로딩해서 LCPCList 패킷에 담아서 전송한다.
//////////////////////////////////////////////////////////////////////////////
void CLChangeServerHandler::execute (CLChangeServer* pPacket , Player* pPlayer)
throw(ProtocolException , Error)
{
__BEGIN_TRY __BEGIN_DEBUG_EX
#ifdef __LOGIN_SERVER__
Assert(pPacket != NULL);
Assert(pPlayer != NULL);
LoginPlayer* pLoginPlayer = dynamic_cast<LoginPlayer*>(pPlayer);
ServerGroupID_t CurrentServerGroupID = pPacket->getServerGroupID();
pLoginPlayer->setServerGroupID(CurrentServerGroupID);
Statement* pStmt = NULL;
try
{
pStmt = g_pDatabaseManager->getConnection("DARKEDEN" )->createStatement();
//----------------------------------------------------------------------
// 이제 LCPCList 패킷을 만들어서 보내자
//----------------------------------------------------------------------
LCPCList lcPCList;
pLoginPlayer->makePCList(lcPCList);
pLoginPlayer->sendPacket(&lcPCList);
pLoginPlayer->setPlayerStatus(LPS_PC_MANAGEMENT);
pStmt->executeQuery("UPDATE Player set CurrentServerGroupID = %d WHERE PlayerID = '%s'", (int)pPacket->getServerGroupID(), pLoginPlayer->getID().c_str());
// 쿼리 결과 및 쿼리문 객체를 삭제한다.
SAFE_DELETE(pStmt);
}
catch (SQLQueryException & sce)
{
//cout << sce.toString() << endl;
// 쿼리 결과 및 쿼리문 객체를 삭제한다.
SAFE_DELETE(pStmt);
throw DisconnectException(sce.toString());
}
#endif
__END_DEBUG_EX __END_CATCH
}
//////////////////////////////////////////////////////////////////////////////
// 클라이언트가 서버의 리스트를 달라고 요청해오면, 로그인 서버는 DB로부터
// 서버들의 정보를 로딩해서 LCWorldList 패킷에 담아서 전송한다.
//////////////////////////////////////////////////////////////////////////////
void CLGetWorldListHandler::execute (CLGetWorldList* pPacket , Player* pPlayer)
throw(ProtocolException , Error)
{
__BEGIN_TRY __BEGIN_DEBUG_EX
#ifdef __LOGIN_SERVER__
Assert(pPacket != NULL);
Assert(pPlayer != NULL);
//cout << "Start execute" << endl;
LoginPlayer* pLoginPlayer = dynamic_cast<LoginPlayer*>(pPlayer);
try
{
int Num = g_pGameWorldInfoManager->getSize();
//cout << "WorldNum : " << Num << endl;
WorldInfo* aWorldInfo[Num];
for(int i = 1 ; i < Num + 1; i++)
{
WorldInfo* pWorldInfo = new WorldInfo();
GameWorldInfo* pGameWorldInfo = g_pGameWorldInfoManager->getGameWorldInfo(i);
pWorldInfo->setID(pGameWorldInfo->getID());
pWorldInfo->setName(pGameWorldInfo->getName());
// by bezz. 2002.12.20
pWorldInfo->setStat(pGameWorldInfo->getStatus());
aWorldInfo[i] = pWorldInfo;
// 트랜실(2) 빼기
//if (i==2) pWorldInfo->setStat(WORLD_CLOSE);
//cout << "AddWorld : " << pWorldInfo->getName() << endl;
}
LCWorldList lcWorldList;
Statement * pStmt = NULL;
BEGIN_DB
{
pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
Result * pResult = pStmt->executeQuery("SELECT CurrentWorldID FROM Player where PlayerID='%s'" , pLoginPlayer->getID().c_str());
if(pResult->next() ) {
lcWorldList.setCurrentWorldID(pResult->getInt(1));
}
SAFE_DELETE(pStmt); // by sigi
}
END_DB(pStmt) // by sigi
for(int k = 1; k < Num + 1; k++)
{
lcWorldList.addListElement(aWorldInfo[k]);
}
pLoginPlayer->sendPacket(&lcWorldList);
// pLoginPlayer->setPlayerStatus(LPS_PC_MANAGEMENT);
}
catch (Throwable & t)
{
//cout << t.toString() << endl;
}
//cout << "End execute" << endl;
#endif
__END_DEBUG_EX __END_CATCH
}
//////////////////////////////////////////////////////////////////////////////
// CLSelectPCHandler::execute()
//
// ·Î±×ÀÎ ¼¹ö´Â ÀÌ ÆÐŶÀ» ¹ÞÀ¸¸é, ÁöÁ¤µÈ Name + PCType ¸¦ °¡Áø PC ¸¦ ·ÎµùÇÑ´Ù.°
// ÀÌ PC°¡ Ç÷¹À̾îÀÇ Ä³¸¯ÅͶó¸é ÀÌ PC°¡ ±âÁ¸¿¡ ÀÖ´ø Á¸À» ¾Ë¾Æ³»¼
// ±× Á¸À» ´ã´çÇÑ °ÔÀÓ ¼¹ö¿¡°Ô LGIncomingConnection À» Àü¼ÛÇÑ´Ù.
// Á÷ÈÄ Å¬¶óÀ̾ðÆ®¿¡°Ô LCReconnect ÆÐŶÀ» º¸³»¼, °ÔÀÓ ¼¹ö·Î ¿¬°áÇϵµ·Ï
// ÇØÁØ´Ù.
//////////////////////////////////////////////////////////////////////////////
void CLSelectPCHandler::execute (CLSelectPC* pPacket , Player* pPlayer)
throw(ProtocolException , Error)
{
__BEGIN_TRY __BEGIN_DEBUG_EX
#ifdef __LOGIN_SERVER__
Assert(pPacket != NULL);
Assert(pPlayer != NULL);
LoginPlayer* pLoginPlayer = dynamic_cast<LoginPlayer*>(pPlayer);
bool bCheckATTR = false;
// ·Î±×ÀÎ ¼¹ö¿¡¼ billing ¿¬°á ºÎºÐÀ» »©±â·Î ÇÑ´Ù.
// ¾Öµåºô ¿äû »çÇ×. by bezz 2003.04.22
/*#ifdef __CONNECT_BILLING_SYSTEM__
// ºô¸µ ½Ã½ºÅÛÀ¸·ÎºÎÅÍ Ã¼Å©¸¦ ¹Þ´Â °æ¿ì
// by sigi. 2002.11.21
if (pLoginPlayer->isBillingLoginVerified())
{
if (pLoginPlayer->isBillingPlayAvaiable()
&& pLoginPlayer->getBillingUserStatus()!="XX")
{
cout << "isBillingPlay: " << pLoginPlayer->getID().c_str() << endl;
}
else if (pLoginPlayer->isPayPlaying())
{
// °Á Åë°ú~
cout << "isPayPlaying: " << pLoginPlayer->getID().c_str() << endl;
// ±×·¯³ª.. ¹Ø¿¡¼ ´É·ÂÄ¡ üũ¸¦ ÇؾßÇÑ´Ù.
if (pLoginPlayer->getPayType()!=PAY_TYPE_FREE)
{
bCheckATTR = true;
}
}
else
{
cout << "CannotPlay: " << pLoginPlayer->getID().c_str() << endl;
// °ÔÀÓ ÇÒ ¼ö ¾ø´Â ij¸¯ÅÍ(ºô¸µ °ü·Ã)
LCSelectPCError lcSelectPCError;
lcSelectPCError.setCode(SELECT_PC_CANNOT_PLAY);
pLoginPlayer->sendPacket(&lcSelectPCError);
//throw DisconnectException("cannot playing");
return;
}
}
else
{
// ¾ÆÁ÷ ºô¸µ½Ã½ºÅÛÀ¸·ÎºÎÅÍ °ËÁõÀÌ µÇÁö ¾ÊÀº »óÅÂ
// Ŭ¶óÀ̾ðÆ®¿¡¼ ´õ ±â´Ù¸®µµ·Ï ÇؾßÇÑ´Ù.
// ¾Æ´Ï¸é, ÀÏ´Ü ±×³É ³Ñ¾î°¡°í.. °× ¼¹ö¿¡¼ ©¸®µµ·Ï ÇÒ±î?
// ¾ÆÁ÷ °áÁ¦ Á¤º¸°¡ üũµÇÁö ¾Ê¾Ò´Ù.
cout << "NotBillingChecked: " << pLoginPlayer->getID().c_str();
if (pLoginPlayer->isPayPlaying()
&& pLoginPlayer->getPayType()==PAY_TYPE_FREE)
{
// ¿ÏÀü ¹«·á »ç¿ëÀÚ´Â ±×³É Åë°úÇÑ´Ù.
cout << "But PAY_TYPE_FREE" << endl;
}
else
{
cout << endl;
LCSelectPCError lcSelectPCError;
lcSelectPCError.setCode(SELECT_PC_NOT_BILLING_CHECK);
pLoginPlayer->sendPacket(&lcSelectPCError);
//throw DisconnectException("cannot playing");
return;
}
}
*/
#ifdef __NETMARBLE_SERVER__
if (!pLoginPlayer->isAgree() )
{
LCSelectPCError lcSelectPCError;
lcSelectPCError.setCode(SELECT_PC_DIDNOT_AGREE);
pLoginPlayer->sendPacket(&lcSelectPCError);
return;
}
#endif
#ifdef __CONNECT_CBILLING_SYSTEM__
if (pLoginPlayer->isCBillingVerified() )
{
if (!pLoginPlayer->isPayPlayer() )
{
LCSelectPCError lcSelectPCError;
lcSelectPCError.setCode(SELECT_PC_CANNOT_PLAY);
pLoginPlayer->sendPacket(&lcSelectPCError);
return;
}
}
else
{
LCSelectPCError lcSelectPCError;
lcSelectPCError.setCode(SELECT_PC_NOT_BILLING_CHECK);
pLoginPlayer->sendPacket(&lcSelectPCError);
return;
}
#endif
// ¾Öµåºô ºô¸µÀº »ç¿ëÇÏÁö ¾Ê¾Æµµ..
// ´É·ÂÄ¡ Á¦ÇÑ Ã¼Å©´Â ÇؾßÇÏ´Â °æ¿ì
#ifdef __PAY_SYSTEM_FREE_LIMIT__
// À¯·á »ç¿ëÀÚ°¡ ¾Æ´Ñ °æ¿ì´Â ... ´É·ÂÄ¡ üũÇÑ´Ù.
if (!pLoginPlayer->isPayPlaying())
{
bCheckATTR = true;
}
#endif
if (pLoginPlayer->getPlayerStatus() != LPS_PC_MANAGEMENT)
throw DisconnectException("invalid player status");
// PC ÀÇ Á¤º¸¸¦ µ¥ÀÌŸº£À̽º·ÎºÎÅÍ °¡Á® ¿Â´Ù.
Statement* pStmt = NULL;
Statement* pStmt1 = NULL; // (!)
Result* pResult;
WorldID_t WorldID = pLoginPlayer->getWorldID();
try
{
pStmt1 = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement(); // (!)
pStmt = g_pDatabaseManager->getConnection((TID)WorldID )->createStatement();
//----------------------------------------------------------------------
// PC °¡ ¸¶Áö¸·À¸·Î Ç÷¹ÀÌÇÑ Á¸ÀÇ ¾ÆÀ̵𸦠°¡Á®¿Â´Ù.
//----------------------------------------------------------------------
// ½½·¹À̾î ȤÀº ¹ìÆÄÀ̾î Å×ÀÌºí¿¡¼ ³»°¡ ¼ÒÀ¯ÇÑ ¾×Ƽºê ij¸¯Å͸¦ ã´Â´Ù.
/*
pResult = pStmt->executeQuery(
"SELECT ZoneID, Slot FROM %s WHERE Name = '%s' AND PlayerID = '%s' AND Active = 'ACTIVE'",
pPacket->getPCType() == PC_SLAYER ? "Slayer" : "Vampire" ,
pPacket->getPCName().c_str() ,
pLoginPlayer->getID().c_str()
);
*/
bool isSlayer = (pPacket->getPCType() == PC_SLAYER);
bool isVampire = (pPacket->getPCType() == PC_VAMPIRE);
if (isSlayer)
{
pResult = pStmt->executeQuery(
"SELECT ZoneID, Slot, GREATEST(SwordLevel,BladeLevel,GunLevel,EnchantLevel,HealLevel), Competence FROM Slayer WHERE Name = '%s' AND PlayerID = '%s' AND Active = 'ACTIVE'",
pPacket->getPCName().c_str() ,
pLoginPlayer->getID().c_str()
);
}
else if (isVampire)
{
pResult = pStmt->executeQuery(
"SELECT ZoneID, Slot, Level, Competence FROM Vampire WHERE Name = '%s' AND PlayerID = '%s' AND Active = 'ACTIVE'",
pPacket->getPCName().c_str() ,
pLoginPlayer->getID().c_str()
);
}
else
{
pResult = pStmt->executeQuery(
"SELECT ZoneID, Slot, Level, Competence FROM Ousters WHERE Name = '%s' AND PlayerID = '%s' AND Active = 'ACTIVE'",
pPacket->getPCName().c_str() ,
pLoginPlayer->getID().c_str()
);
}
// ±×·± PC°¡ ¾øÀ» °æ¿ì
if (pResult->getRowCount() != 1)
{
SAFE_DELETE(pStmt);
throw InvalidProtocolException("no such PC exist.");
}
pResult->next();
ZoneID_t zoneID = pResult->getWORD(1);
string slotStr = pResult->getString(2);
// ´É·ÂÄ¡ üũ. by sigi. 2002.11.22
if (bCheckATTR)
{
#ifdef __PAY_SYSTEM_FREE_LIMIT__
if (isSlayer)
{
static int slayerSum = g_pConfig->getPropertyInt("FreePlaySlayerDomainSum");
int DomainSUM = pResult->getInt(3);
if (DomainSUM > slayerSum)
{
LCSelectPCError lcSelectPCError;
lcSelectPCError.setCode(SELECT_PC_CANNOT_PLAY_BY_ATTR);
pLoginPlayer->sendPacket(&lcSelectPCError);
SAFE_DELETE(pStmt);
return;
}
}
else
{
static int vampireLevel = g_pConfig->getPropertyInt("FreePlayVampireLevel");
int Level = pResult->getInt(3);
if (Level > vampireLevel)
{
LCSelectPCError lcSelectPCError;
lcSelectPCError.setCode(SELECT_PC_CANNOT_PLAY_BY_ATTR);
pLoginPlayer->sendPacket(&lcSelectPCError);
SAFE_DELETE(pStmt);
return;
}
}
#endif
}
//////////////////////////////////////////////////////////////////////////////////////
// PK Server üũ
//////////////////////////////////////////////////////////////////////////////////////
bool bNonPKServer = g_pGameServerInfoManager->getGameServerInfo(1, pLoginPlayer->getServerGroupID(), pLoginPlayer->getWorldID() )->isNonPKServer();
if (bNonPKServer )
{
cout << "WorldID:" << (int)(pLoginPlayer->getWorldID()) << " ServerGroupID:" << (int)(pLoginPlayer->getServerGroupID()) << endl;
int playerLevel = pResult->getInt(3);
int competence = pResult->getInt(4);
// 40 ·¹º§ º¸´Ù ³ôÀº Ç÷¹À̾î´Â µé¾î°¥ ¼ö ¾ø´Ù.
// ¿î¿µÀÚ´Â µé¾î°¡¾ßÇÑ´Ù.
if (playerLevel > 80 && competence == 3 )
{
LCSelectPCError lcSelectPCError;
lcSelectPCError.setCode(SELECT_PC_CANNOT_PLAY_BY_ATTR);
pLoginPlayer->sendPacket(&lcSelectPCError);
SAFE_DELETE(pStmt);
return;
}
}
//////////////////////////////////////////////////////////////////////////////////////
if (slotStr.size()!=5)
{
SAFE_DELETE(pStmt);
throw InvalidProtocolException("no slot exist.");
}
int slot = slotStr.at(4) - '0';
//----------------------------------------------------------------------
// ÀÌ Á¸À» °ü¸®ÇÏ´Â °ÔÀÓ ¼¹ö Á¤º¸¸¦ °¡Á®¿Â´Ù.
//----------------------------------------------------------------------
GameServerInfo* pGameServerInfo;
if (zoneID > 10000 && zoneID < 30000 )
{
// ij¸¯ÅÍ°¡ ±æµå ¾ÆÁöÆ®¿¡ ÀÖ´Ù. ±æµå ¾ÆÁöÆ® Á¸ÀÇ Á¤º¸´Â login server¿¡ ¾øÀ¸¹Ç·Î ´ëÃæ ¶«»§ÇÑ´Ù.
pGameServerInfo = g_pGameServerInfoManager->getGameServerInfo(1, pLoginPlayer->getServerGroupID(), WorldID);
}
else
{
ZoneInfo* pZoneInfo = g_pZoneInfoManager->getZoneInfo(zoneID);
ZoneGroupInfo* pZoneGroupInfo = g_pZoneGroupInfoManager->getZoneGroupInfo(pZoneInfo->getZoneGroupID());
//cout << "ConnctServerGroup: " << (int)pLoginPlayer->getServerGroupID() << ", ServerID: " << (int)pZoneGroupInfo->getServerID();
cout << "WorldID " << (int)WorldID << ", ServerGroupID : " << (int)pLoginPlayer->getServerGroupID() << ", ServerID : " << (int)pZoneGroupInfo->getServerID() << endl;
pGameServerInfo = g_pGameServerInfoManager->getGameServerInfo(pZoneGroupInfo->getServerID(), pLoginPlayer->getServerGroupID(), WorldID);
}
//----------------------------------------------------------------------
// ÀÌ »ç¿ëÀÚÀÇ ÇöÀç Á¢¼Ó ¼¹ö Á¤º¸¸¦ °¡Á®¿Â´Ù.
//----------------------------------------------------------------------
// GameServerInfo* pGameServerInfo = g_pGameServerInfoManager->getGameServerInfo(pPlayer->getServerID());
//----------------------------------------------------------------------
// °ÔÀÓ¼¹ö¿¡°Ô incoming connection ÀÌ ¿Ã °Å¶ó°í ¾Ë·ÁÁØ´Ù.
//----------------------------------------------------------------------
LGIncomingConnection lgIncomingConnection;
lgIncomingConnection.setClientIP(pLoginPlayer->getSocket()->getHost());
lgIncomingConnection.setPlayerID(pLoginPlayer->getID());
lgIncomingConnection.setPCName(pPacket->getPCName());
//--------------------------------------------------------------------------------
//
// *CAUTION*
//
// LoginPlayer::setPlayerStatus()¿Í GameServerManager::sendPacket()ÀÇ ¼ø¼¿¡ ÁÖÀÇÇ϶ó.
// ´Ü¼øÇÏ°Ô »ý°¢Çϸé sendPacket()ÈÄ¿¡ setPlayerStatus()¸¦ È£ÃâÇÏ´Â °ÍÀÌ ³í¸®¿¡ ÇÕ´ç
// ÇÏÁö¸¸, ½ÇÁ¦·Î ±×·¸°Ô Çϸé setPlayerStatus()¸¦ È£ÃâÇϱâ Àü¿¡ °ÔÀÓ ¼¹ö·ÎºÎÅÍ
// GLIncomingConnectionXXX ÆÐŶÀÌ ³¯¾Æ¿Í¼ ±× Çڵ鷯°¡ ½ÇÇàµÈ´Ù. - -;
// µû¶ó¼, ¾Æ·¡¿Í °°ÀÌ »óŸ¦ ¸ÕÀú ÁöÁ¤ÇÑ ÈÄ¿¡ UDP ÆÐŶÀ» Àü¼ÛÇØ¾ß ÇÑ´Ù.
//
//--------------------------------------------------------------------------------
pLoginPlayer->setPlayerStatus(LPS_AFTER_SENDING_LG_INCOMING_CONNECTION);
/*
// ¾î¿ ¼ö ¾øÀÌ user name À» »ç¿ëÇؼ ÇϵåÄÚµùÇÑ´Ù. -_-;
g_pGameServerManager->sendPacket(pGameServerInfo->getIP() , pGameServerInfo->getUDPPort() , &lgIncomingConnection);
*/
if (g_pConfig->getProperty("User") == "excel96")
//g_pGameServerManager->sendPacket(pGameServerInfo->getIP() , g_pConfig->getPropertyInt("GameServerUDPPort"), &lgIncomingConnection);
g_pGameServerManager->sendPacket(pGameServerInfo->getIP() , pGameServerInfo->getUDPPort(), &lgIncomingConnection);
else if (g_pConfig->getProperty("User") == "beowulf")
g_pGameServerManager->sendPacket(pGameServerInfo->getIP() , g_pConfig->getPropertyInt("GameServerUDPPort"), &lgIncomingConnection);
// g_pGameServerManager->sendPacket(pGameServerInfo->getIP() , 8886 , &lgIncomingConnection);
else if (g_pConfig->getProperty("User") == "crazydog")
g_pGameServerManager->sendPacket(pGameServerInfo->getIP() , g_pConfig->getPropertyInt("GameServerUDPPort"), &lgIncomingConnection);
// g_pGameServerManager->sendPacket(pGameServerInfo->getIP() , 6665, &lgIncomingConnection);
else if (g_pConfig->getProperty("User") == "elcastle")
g_pGameServerManager->sendPacket(pGameServerInfo->getIP() , g_pConfig->getPropertyInt("GameServerUDPPort"), &lgIncomingConnection);
// g_pGameServerManager->sendPacket(pGameServerInfo->getIP() , 8885 , &lgIncomingConnection);
else if (g_pConfig->getProperty("User") == "elca")
g_pGameServerManager->sendPacket(pGameServerInfo->getIP() , g_pConfig->getPropertyInt("GameServerUDPPort"), &lgIncomingConnection);
// g_pGameServerManager->sendPacket(pGameServerInfo->getIP() , 3335 , &lgIncomingConnection);
// ¸¶Áö¸·À¸·Î Á¢¼ÓÇÑ slot ±â¾ï. by sigi. 2002.5.6
pStmt1->executeQuery( // (!)
//pStmt->executeQuery(
"UPDATE Player Set CurrentWorldID = %d, CurrentServerGroupID = %d, LastSlot = %d WHERE PlayerID = '%s'",
WorldID,
pLoginPlayer->getServerGroupID(),
slot,
pLoginPlayer->getID().c_str()
);
pStmt->executeQuery("UPDATE Slayer Set ServerGroupID = %d WHERE Name='%s'", pLoginPlayer->getServerGroupID(), pPacket->getPCName().c_str());
pStmt->executeQuery("UPDATE Vampire Set ServerGroupID = %d WHERE Name='%s'", pLoginPlayer->getServerGroupID(), pPacket->getPCName().c_str());
pStmt->executeQuery("UPDATE Ousters Set ServerGroupID = %d WHERE Name='%s'", pLoginPlayer->getServerGroupID(), pPacket->getPCName().c_str());
SAFE_DELETE(pStmt);
SAFE_DELETE(pStmt1); //(!)
//cout << "CLSelectPC SendPacket to Server IP : " << pGameServerInfo->getIP() << endl;
}
catch (SQLQueryException & sqe)
{
//cout << sqe.toString() << endl;
SAFE_DELETE(pStmt);
SAFE_DELETE(pStmt1); //(!)
throw DisconnectException(sqe.toString());
}
catch (NoSuchElementException & nsee)
{
StringStream msg;
msg << "Critical Error : data intergrity broken at ZoneInfo - ZoneGroupInfo - GameServerInfo : " << nsee.toString();
SAFE_DELETE(pStmt);
SAFE_DELETE(pStmt1); //(!)
throw Error(msg.toString());
}
#endif
__END_DEBUG_EX __END_CATCH
}