/* ====================================================================
 * ÆÄ    ÀÏ :	sqlAccountStmt.h
 * ¸ñ    Àû :	
 * ÀÛ ¼º ÀÚ :	°ûöÁß
 * ÀÛ ¼º ÀÏ :	07/01/12/
 * ÁÖÀÇ»çÇ× :	
 * =================================================================== */
#ifndef __SQL_ACCOUNT_STATEMENT_H__
#define __SQL_ACCOUNT_STATEMENT_H__

//#ifndef WINVER
//#define WINVER          0x0500
//#endif
//
//#ifndef _WIN32_WINNT
//#define _WIN32_WINNT    0x0500
//#endif

#pragma once

#include "odbcsql.h"
#include "CommonDefines.h"


struct SHUTDOWN_ACCOUNT
{
	long serverNum;
	long channelNum;
};

struct CHANNEL_CHECK
{
	long    serverNum;
	wchar_t serverName[51];
	char    serverDesc[201];
	long    channelNum;
	char    inetnum[21];
	long    ipv4;
	short   port;
	long    retvalue;
};

struct MEMBER_CHECK
{
	long loginIdx;
	long memberIdx;
	int  serverNum;
	int  channelNum;
	int  lastChannel;
	long characterIdx;
	BYTE instantDungeon;
	BYTE slevel;
	long pc;
//	BYTE cbtUser;
//	BYTE obtUser;
//	BYTE fourGamer;

	long retvalue;
};

struct MEMBER_OBT_EVENT_COMPLETE
{
	long memberIdx;
	BYTE cbtUser;
	BYTE obtUser;
	BYTE fourGamer;

	long retvalue;
};

struct MEMBER_LOGOUT
{
	long loginIdx;
	long memberIdx;
//	BYTE cbtUser;
//	BYTE obtUser;
//	BYTE fourGamer;
	long retvalue;
};

struct MEMBER_OUT
{
	long loginIdx;
	long memberIdx;
	long error;
};

struct LOGIN_UPDATE
{
	long loginIdx;
};

struct GAME_TO_GAME
{
	long  loginIdx;
	long  serverNum;
	long  channelNum;
	long  lastChannel;
	long  characterIdx;
	BYTE  instantDungeon;
	long  ipv4;
	short port;
	long  retvalue;
};

struct MEMBER_TWITTER
{
	long memberIdx;
	char twitterUid[101];
	char twitterPwd[101];
};

/*      ÀÚµ¿»ç³É ½Å°í
*/
struct TRIAL_SELECT
{
	long    memberIdx;
    long    trialTime;
    long    trialRejectTime;
};

// ½Å°í Àç»ç¿ë ½Ã°£
struct MEMBER_TRIAL
{
	long    memberIdx;
    long    autoCharacterIdx;
    long    trialTime;
	long    retvalue;
};

// ½Å°í °ÅºÎ ½Ã°£
struct TRIAL_REJECT
{
	long    memberIdx;
    long    rejectTime;
	long    retvalue;
};

struct CAPTCHA_OFFSET
{
    unsigned long offset;
};

// captcha À̹ÌÁö SELECT
struct CAPTCHA_SELECT
{
	wchar_t         captchaName[MAX_TRIAL_ANSWER_LEN+1];    // Á¤´ä
	BYTE            captcha[MAX_CAPTCHA_SIZE];              // captcha À̹ÌÁö
    unsigned short  captchaSize;                            // À̹ÌÁö »çÀÌÁî
    unsigned long   captchaOffset;                          // À̹ÌÁö offset
    long            tiralMemberIdx;                         // ½Å°íÀÚ memberIdx
    long            autoCharacterIdx;                       // ¿ÀÅä Ç÷¹À̾î characterIdx
    long            retvalue;
};

// captcha À̹ÌÁö »õ·Î°íħ
struct CAPTCHA_RELOAD
{
	BYTE            captcha[MAX_CAPTCHA_SIZE];
	wchar_t         captchaName[MAX_TRIAL_ANSWER_LEN+1];    // Á¤´ä
    unsigned short  captchaSize;                            // À̹ÌÁö »çÀÌÁî
    unsigned long   captchaOffset;                          // À̹ÌÁö offset
};

// ·Î±×ÀÎ Á¦ÇÑ
struct LOGIN_LIMIT
{
    unsigned char   count;
	long            memberIdx;
	long            retvalue;
};

class cSQLAccountStmt :
	public cSQLStatement
{
public:
// Ŭ·¡½º »ý¼º ¹× °ø¿ë ¸Þ¼Òµå.
	cSQLAccountStmt(void);

	SQLRETURN Shutdown            ( SHUTDOWN_ACCOUNT* shutdownAccount );
	SQLRETURN ChannelCheck        ( CHANNEL_CHECK* channelCheck );

	SQLRETURN MemberCheck         ( MEMBER_CHECK* memberCheck );
	SQLRETURN MemberLogout        ( MEMBER_LOGOUT* memberLogout );
	SQLRETURN MemberOut           ( MEMBER_OUT* memberOut );

	SQLRETURN LoginUpdate         ( LOGIN_UPDATE* loginUpdate );
	SQLRETURN GameToGame          ( GAME_TO_GAME* gameToGame );

	SQLRETURN MemberTwitter       ( MEMBER_TWITTER* memberTwitter );

	// ÀÚµ¿»ç³É ½Å°í
	SQLRETURN CaptchaOffset       ( CAPTCHA_OFFSET* captchaOffset   );
	SQLRETURN CaptchaSelect	      ( CAPTCHA_SELECT* captchaSelect   );
	SQLRETURN CaptchaReload	      ( CAPTCHA_RELOAD* captchaReload   );

    SQLRETURN TrialSelect         ( TRIAL_SELECT* trialSelect       );
    SQLRETURN TrialCheck          ( MEMBER_TRIAL* trialCheck        );
	SQLRETURN TrialUpdate         ( MEMBER_TRIAL* trialUpdate       );
	SQLRETURN TrialRejectUpdate   ( TRIAL_REJECT* rejectUpdate      );

    // ·Î±×ÀÎ Á¦ÇÑ
	SQLRETURN LoginLimit          ( LOGIN_LIMIT* loginLimit         );

	// OBT À̺¥Æ® ¿Ï·á
	SQLRETURN ObtEventComplete    ( MEMBER_OBT_EVENT_COMPLETE* obtEvent );
    
public:
// Ŭ·¡½º Æı« ¸Þ¼Òµå.
	virtual ~cSQLAccountStmt(void);
};

#endif // __SQL_ACCOUNT_STATEMENT_H__