LGram16
dd97ddec92
Move git root from Client/ to src/ to track all source code: - Client: Game client source (moved to Client/Client/) - Server: Game server source - GameTools: Development tools - CryptoSource: Encryption utilities - database: Database scripts - Script: Game scripts - rylCoder_16.02.2008_src: Legacy coder tools - GMFont, Game: Additional resources 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude <noreply@anthropic.com>
67 lines
1.7 KiB
C++
67 lines
1.7 KiB
C++
#include "stdafx.h"
|
|
|
|
#include "BillingDB.h"
|
|
#include <Log/ServerLog.h>
|
|
|
|
bool CBillingDB::CheckLogin(unsigned long dwServerGroup, unsigned long dwUID)
|
|
{
|
|
// edith 2009.08.14 관심유저 버그수정 (ROW_Activity DB사용)
|
|
char szQuery[MAX_QUERY_LENGTH];
|
|
_snprintf(szQuery, MAX_QUERY_LENGTH,
|
|
"SELECT UID FROM TblCurrentUser WHERE UID = %d AND tinyServerID = %d",
|
|
dwUID, dwServerGroup);
|
|
|
|
unsigned long dwGetUID = 0;
|
|
|
|
if (true == ExecuteQueryGetData(szQuery, &dwGetUID))
|
|
{
|
|
if(0 == dwGetUID)
|
|
{
|
|
// 접속 중이지 않음.
|
|
return false;
|
|
}
|
|
else
|
|
{
|
|
// 접속 중.
|
|
return true;
|
|
}
|
|
}
|
|
|
|
return false;
|
|
}
|
|
|
|
unsigned long CBillingDB::GetUIDFromAccount(char* szAccountName)
|
|
{
|
|
// edith 2009.08.14 관심유저 버그수정 (ROW_Activity DB사용)
|
|
char szQuery[MAX_QUERY_LENGTH];
|
|
_snprintf(szQuery, MAX_QUERY_LENGTH,
|
|
"SELECT TOP 1 UID FROM TblCurrentUser WHERE strClientID = '%s'", szAccountName);
|
|
// "SELECT TOP 1 UID FROM TblCurrentUser_log WHERE strClientID = '%s'", szAccountName);
|
|
|
|
unsigned long dwUID = 0;
|
|
|
|
if (false == ExecuteQueryGetData(szQuery, &dwUID))
|
|
{
|
|
ERRLOG2(g_Log, "UID를 얻는데 실패했습니다. Account: %s, Err: %s", szAccountName, GetErrorString());
|
|
return 0;
|
|
}
|
|
|
|
return dwUID;
|
|
}
|
|
|
|
bool CBillingDB::GetAccountFromUID(unsigned long dwUID, void* lpGetData)
|
|
{
|
|
// edith 2009.08.14 관심유저 버그수정 (ROW_Activity DB사용)
|
|
char szQuery[MAX_QUERY_LENGTH];
|
|
_snprintf(szQuery, MAX_QUERY_LENGTH,
|
|
"SELECT TOP 1 strClientID FROM TblCurrentUser WHERE UID = %u", dwUID);
|
|
// "SELECT TOP 1 strClientID FROM TblCurrentUser_log WHERE UID = %u", dwUID);
|
|
|
|
if (false == ExecuteQueryGetData(szQuery, lpGetData))
|
|
{
|
|
ERRLOG2(g_Log, "Account를 얻는데 실패했습니다. UID: %u, Err: %s", dwUID, GetErrorString());
|
|
return false;
|
|
}
|
|
|
|
return true;
|
|
} |