void CLLoginHandler::execute (CLLogin* pPacket , Player* pPlayer)
throw(ProtocolException , Error)
{
__BEGIN_TRY __BEGIN_DEBUG_EX
#ifdef __LOGIN_SERVER__
Assert(pPacket != NULL);
Assert(pPlayer != NULL);
//cout << pPacket->toString().c_str() << endl;
LoginPlayer* pLoginPlayer = dynamic_cast<LoginPlayer*>(pPlayer);
Statement* pStmt = NULL;
// 좌우 공백 제거. by sigi. 2002.12.6
pPacket->setID(trim(pPacket->getID()));
string connectIP = pLoginPlayer->getSocket()->getHost();
string connectMAC = pPacket->getMacAddress();
string ID = pPacket->getID();
// MAC address setting
pLoginPlayer->setMacAddress(pPacket->getRareMacAddress());
bool bFreePass = false; //by sigi. 2002.10.23j
// web login
bool bWebLogin = pPacket->isWebLogin();
// static bool bWebLogin = g_pConfig->getPropertyInt("WebLogin") != 0;
// set web login player
if (bWebLogin )
pLoginPlayer->setWebLogin();
// cout << pPacket->toString() << endl;
if (isBlockIP(connectIP) )
{
LCLoginError lcLoginError;
lcLoginError.setErrorID(IP_DENYED);
pLoginPlayer->sendPacket(&lcLoginError);
filelog("loginfail.txt", "Error Code: IP_DENYED, 1, PlayerID : %s", pPacket->getID().c_str());
return;
}
// 사내테스트 버전에서는 '#sigi' <-- 이런 식으로 계정이 들어온다.
if (ID[0]==SYMBOL_TEST_CLIENT)
{
ID = ID.c_str()+1;
pPacket->setID(ID);
// 웹 로그인 체크
if (bWebLogin )
{
//cout << "WebLogin" << endl;
if (!checkWebLogin(pPacket, pPlayer ) )
{
return;
}
//else
//cout << "Web Login OK" << endl;
}
else
{
//cout << "not WebLogin" << endl;
// 넷마블에서 접속하는 경우
// by sigi. 2002.10.23
if (!checkNetMarbleClient(pPacket, pPlayer ))
{
return;
}
}
bFreePass = pLoginPlayer->isFreePass();
if (!bWebLogin && bFreePass)
{
// 웹로그인이 아닌 FreePass 는 넷마블 사용자로 ID 앞에 예약문자가 하나더 있다.
ID = ID.c_str()+1;
pPacket->setID(ID);
}
// cout << "테스트 클라이언트" << endl;
BEGIN_DB
{
// 증거를 남긴다.
pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
pStmt->executeQuery(
"INSERT INTO TestClientUser (PlayerID, IP, LoginDate) VALUES ('%s', '%s', now())",
ID.c_str(), connectIP.c_str());
SAFE_DELETE(pStmt);
}
END_DB(pStmt)
}
//////////////////////////////////////////////////////////////////////////////
// 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
}