db.h

墨香最新私服

//////////////////////////////////////////////////////////////////////
// Coolwater.Fire version 2001.1.15
// Ultimate Database Gasoline Engine
// If it does not work correctly, plz enter www.coolwater.fire.com 
// 
// programed by Park Sung Jun 
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_DB_H__1E9DC62E_BDF3_4845_B9CC_EE225C7914D5__INCLUDED_)
#define AFX_DB_H__1E9DC62E_BDF3_4845_B9CC_EE225C7914D5__INCLUDED_

#pragma once

#include "stdafx.h"
#include <sql.h>
#include <sqlext.h>
#include <initguid.h>

///////////////////////////////////////////////////////////////////////////////////////////////////////
/* 林狼!!!!!!!!!!!!!!!!!!!!!!
	酒贰 define 等 蔼甸篮 捞 蔼阑 官槽促绊 秦辑 角力 官差绰 巴捞 酒凑聪促.
	角力 蔼篮 DLL 郴何俊 沥利栏肺 沥狼登绢 乐扁 嫐巩俊 函版捞 阂啊瓷钦聪促.
	捞绰 孽府 搬苞俊 蝶扼 皋葛府 且寸窍绰 何盒捞 沥利牢 巴苞 悼利牢 巴 滴啊瘤 悼矫俊 器窃窍扁 锭巩涝聪促.
*/

#pragma pack(push, 1)



#define STR_LEN 256
#define MSG_BUF_SIZE 256
#define MAX_LENGTH_QUERY 3072
#define MAX_COL_LENGTH 17	//焊烹狼 漠烦郴侩狼 弥措 辨捞 
#define MAX_COL_NAME_LENGTH 24	//焊烹狼 漠烦捞抚狼 弥措 辨捞 
#define	MAX_NUM_SQL_CONNECTION			5
#define MAX_COL_NUM 60 // 孽府 搬苞狼 弥措 漠烦荐 
#define MAX_ROW_NUM 100 // 茄锅 孽府俊 弥措肺 阂矾坷绰 饭内靛 荐 

#define MAX_LARGECOL_LENGTH 6144	//焊烹狼 漠烦郴侩狼 弥措 辨捞 
#define MAX_LARGECOL_NUM 20 // 孽府 搬苞狼 弥措 漠烦荐 

#define MAX_MIDDLECOL_LENGTH 311	//焊烹狼 漠烦郴侩狼 弥措 辨捞 
#define MAX_MIDDLECOL_NUM 20 // 孽府 搬苞狼 弥措 漠烦荐
#define MAX_MIDDLEROW_NUM 20 // 茄锅 孽府俊 弥措肺 阂矾坷绰 饭内靛 荐 



///////////////////////////////////////////////////////////////////////////////////////////////////////

typedef void (*VOIDFUNC)(void);

// 静饭爹 劝侩困茄 备炼眉
typedef struct {
	DWORD				dwMessageID;		// 皋技瘤 绊蜡酒捞叼, 富窍磊搁 贸府锅龋.
	BOOL				bNotifyOnlyError;	// 捞 蔼捞 曼捞搁 秦寸窃荐 角青饶俊 俊矾啊 惯积且 版快俊父 绊瘤
	LPVOID				pData;				// 贸府甫 盔窍绰 涝仿单捞磐狼 器牢磐
	BYTE				bFNNo;				// 沏记锅龋..搬惫 捞繁 摹凉茄 骸过阑 静霸 登绰焙..-_-;;
	DWORD				dwResult;			// 鞘夸俊 蝶扼 捞 蔼阑 敬促.

	DWORD				dwID;
} DBMESSAGE, *LPDBMESSAGE;

struct DESC_DBTHREAD
{
	BYTE		bUsingThread;
	BYTE		bUsingDLL;
	BYTE		bUsingEventObject;
	HWND		hWndToPostMessage;
    void		(*ReadDBResult)(DWORD ret,  LPDBMESSAGE pMessage);
	void		(*WriteMessage)(char* pmsg);
	
	DWORD		dwMessageMaxSize;		// DBMESSAGE 备炼眉狼 弥措 农扁
	DWORD		dwNumofMessage;			// 弥措 悼矫 孽府 啊瓷 肮荐 
	DWORD		dwResultMaxSize;		// 孽府 搬苞狼 弥措 荤捞令(select巩)
	DWORD		dwNumofResult;			// 孽府 搬苞狼 弥措 肮荐  (select巩)
	DWORD		dwSizeofStack;			// 孽府矫 涝仿茄 牢磊甫 困茄 皋葛府 农扁 
	DWORD		dwDBMessageID;

	char		Default_User_table[128];
	char		Default_User_account[128];
	char		Default_User_pw[128];
	char		Default_User_guid[128];
	char		AdminID[128];
	char		ClientID[128];
	char		AdminPW[128];
	char		ClientPW[128];
	char		DBName[128];
	char		AdminCursor[128];
	char		ClientCursor[128];

};



typedef struct {
	LPDBMESSAGE	lpDBMessage;
	DWORD		Ret;
} DBRESULTMESSAGE, *LPDBRESULTMESSAGE;



typedef struct
{
	char Data1[MAX_COL_LENGTH];
} DBDATA1, *LPDATA1;
typedef struct
{
	char Data1[MAX_COL_LENGTH];
	char Data2[MAX_COL_LENGTH];
} DBDATA2, *LPDATA2;
typedef struct
{
	char Data1[MAX_COL_LENGTH];
	char Data2[MAX_COL_LENGTH];
	char Data3[MAX_COL_LENGTH];
} DBDATA3, *LPDATA3;
typedef struct
{
	char Data1[MAX_COL_LENGTH];
	char Data2[MAX_COL_LENGTH];
	char Data3[MAX_COL_LENGTH];
	char Data4[MAX_COL_LENGTH];
} DBDATA4, *LPDATA4;
typedef struct
{
	char Data1[MAX_COL_LENGTH];
	char Data2[MAX_COL_LENGTH];
	char Data3[MAX_COL_LENGTH];
	char Data4[MAX_COL_LENGTH];
	char Data5[MAX_COL_LENGTH];
} DBDATA5, *LPDATA5;
typedef struct
{
	char Data1[MAX_COL_LENGTH];
	char Data2[MAX_COL_LENGTH];
	char Data3[MAX_COL_LENGTH];
	char Data4[MAX_COL_LENGTH];
	char Data5[MAX_COL_LENGTH];
	char Data6[MAX_COL_LENGTH];
} DBDATA6, *LPDATA6;
typedef struct
{
	char Data1[MAX_COL_LENGTH];
	char Data2[MAX_COL_LENGTH];
	char Data3[MAX_COL_LENGTH];
	char Data4[MAX_COL_LENGTH];
	char Data5[MAX_COL_LENGTH];
	char Data6[MAX_COL_LENGTH];
	char Data7[MAX_COL_LENGTH];
} DBDATA7, *LPDATA7;
typedef struct
{
	char Data1[MAX_COL_LENGTH];
	char Data2[MAX_COL_LENGTH];
	char Data3[MAX_COL_LENGTH];
	char Data4[MAX_COL_LENGTH];
	char Data5[MAX_COL_LENGTH];
	char Data6[MAX_COL_LENGTH];
	char Data7[MAX_COL_LENGTH];
	char Data8[MAX_COL_LENGTH];
} DBDATA8, *LPDATA8;
typedef struct
{
	char Data1[MAX_COL_LENGTH];
	char Data2[MAX_COL_LENGTH];
	char Data3[MAX_COL_LENGTH];
	char Data4[MAX_COL_LENGTH];
	char Data5[MAX_COL_LENGTH];
	char Data6[MAX_COL_LENGTH];
	char Data7[MAX_COL_LENGTH];
	char Data8[MAX_COL_LENGTH];
	char Data9[MAX_COL_LENGTH];
} DBDATA9, *LPDATA9;
typedef struct
{
	char Data1[MAX_COL_LENGTH];
	char Data2[MAX_COL_LENGTH];
	char Data3[MAX_COL_LENGTH];
	char Data4[MAX_COL_LENGTH];
	char Data5[MAX_COL_LENGTH];
	char Data6[MAX_COL_LENGTH];
	char Data7[MAX_COL_LENGTH];
	char Data8[MAX_COL_LENGTH];
	char Data9[MAX_COL_LENGTH];
	char Data10[MAX_COL_LENGTH];
} DBDATA10, *LPDATA10;

typedef struct
{
	TCHAR	szDBName[STR_LEN];			// data source name, configured through control panel
	TCHAR	szID[STR_LEN];				// Login user name
	TCHAR	szPW[STR_LEN];				// Login user password
	SQLHDBC	hDBC;						// handle to an ODBC database connection
	HSTMT	hStmt;						// an ODBC statement handle, for use with SQLExecDirect
	TCHAR	szCursorName[STR_LEN];		// 目辑 捞抚 
	int		nCursorNum;					// 泅犁 目辑狼 困摹
	HSTMT	hScrollStmt;
} DBCON, *LPDBCON;

// 磊蜡 孽府巩 角青矫俊 府畔登绰 器牢磐 备炼眉 
typedef struct
{
	UCHAR   Data[MAX_COL_NUM][MAX_COL_LENGTH];  // Results Data Array
	SDWORD  Length[MAX_COL_NUM];			// Results Data Length Array
	int		nNum;							// 漠烦狼 肮荐 
} QUERYST, *LPQUERY;
// 磊蜡 孽府巩 角青矫俊 府畔登绰 器牢磐 备炼眉 
typedef struct
{
	UCHAR   Data[MAX_LARGECOL_NUM][MAX_LARGECOL_LENGTH];  // Results Data Array
	SDWORD  Length[MAX_LARGECOL_NUM];			// Results Data Length Array
	int		nNum;							// 漠烦狼 肮荐 
} LARGEQUERYST, *LPLARGEQUERY;
// 磊蜡 孽府巩 角青矫俊 府畔登绰 器牢磐 备炼眉 
typedef struct
{
	UCHAR   Data[MAX_MIDDLECOL_NUM][MAX_MIDDLECOL_LENGTH];  // Results Data Array
	SDWORD  Length[MAX_MIDDLECOL_NUM];			// Results Data Length Array
	int		nNum;							// 漠烦狼 肮荐 
} MIDDLEQUERYST, *LPMIDDLEQUERY;
// 皋葛府 悼利且寸阑 困茄 孽府 备炼眉
typedef struct
{
	int		nNum;							// 漠烦狼 肮荐 
	LPVOID	pData;
	LPVOID	pLength;
} QUERYDA, *LPQUERYDA;

typedef struct
{
	UCHAR	 szData[MAX_COL_LENGTH];
} DBSTRING, *LPDBSTRING;

typedef struct
{
	SDWORD	 pLeng;
} DBSDWORD, *LPDBSDWORD;

typedef struct
{
	int			nNumData;
	int			nColNum;
	LPVOID		pData[MAX_ROW_NUM];
	SQLSMALLINT QueryType[MAX_COL_NUM];
} BINDST, *LPBIND;

typedef struct
{
	UCHAR		Data[MAX_COL_NUM][MAX_COL_LENGTH];  // Results Data Array
	SDWORD		Length[MAX_COL_NUM];				// Results Data Length Array
	SDWORD		LengthRead[MAX_COL_NUM];			// Results Data Length Array
} ROWWISEBIND, *LPROWWISEBIND;


// 静饭爹侩 牢磊 备炼眉 
typedef struct
{
	LPDBCON pCon;
	char	szBuffer[MAX_LENGTH_QUERY];
	DWORD	dwNumRow;
} DBFreeQuery, *LPDBFreeQuery;
typedef struct
{
	LPDBCON pCon;
	char	szTable[MAX_COL_NAME_LENGTH];
	DWORD	dwValue;
	char	lpCol[MAX_COL_NAME_LENGTH];
	SQLSMALLINT	sqltype;
} DBSingleQuery, *LPDBSingleQuery;
typedef struct
{
	LPDBCON pCon;
	char	szBuffer[MAX_LENGTH_QUERY];
	LPBIND	lpBind;
	int		StSize;
	SQLSMALLINT	sqlType;
	int		rowset;
} DBGenerateResultSet, *LPDBGenerateResultSet;
typedef struct
{
	LPDBCON pCon;
	char	szQuery[MAX_LENGTH_QUERY];
} DBExcuteIUD, *LPDBExcuteIUD;
typedef struct
{
	LPDBCON pCon;
	char	szTableName[MAX_COL_NAME_LENGTH];
	char	lpCol[MAX_COL_NAME_LENGTH];
	char	lpValue[MAX_COL_LENGTH];
	char	DestCol[MAX_COL_NAME_LENGTH];
	char	DestValue[MAX_COL_LENGTH];
} DBUpdateRecord, *LPDBUpdateRecord;
typedef struct
{
	LPDBCON pCon;
	char	szTableName[MAX_COL_NAME_LENGTH];
	char	lpCol[MAX_COL_NAME_LENGTH];
	char	lpValue[MAX_COL_LENGTH];
} DBDeleteRecord, *LPDBDeleteRecord;
typedef struct
{
	LPDBCON pCon;
	char	szTableName[MAX_COL_NAME_LENGTH];
	LPVOID	lpCol;
	LPVOID	lpValue;
	BYTE	bNumData;
} DBInsertRecord, *LPDBInsertRecord;
typedef struct
{
	LPDBCON pCon;
	char	szTableName[MAX_COL_NAME_LENGTH];
	char	pColID[MAX_COL_NAME_LENGTH];
	char	pColPW[MAX_COL_NAME_LENGTH];
	char	pID[MAX_COL_NAME_LENGTH];
	char	pPW[MAX_COL_NAME_LENGTH];
	char	pRetCol[MAX_COL_NAME_LENGTH];
	LPVOID	pRetValue;
	int		iLength;
	SQLSMALLINT sqlType;
} DBLogin, *LPDBLogin;
typedef struct
{
	LPDBCON pCon;
	char	pID[MAX_COL_NAME_LENGTH];
	char	pPW[MAX_COL_NAME_LENGTH];
	LPVOID	pRetValue;
} DBSimpleLogin, *LPDBSimpleLogin;

typedef struct
{
	LPDBCON pCon;
	char	szQuery[MAX_LENGTH_QUERY];
	int		nSize;
	LPVOID	pPara;
	long	nBuffersize;
	LPVOID	pSettingData;
} DBSaveDataByPtr, *LPDBSaveDataByPtr;

typedef struct
{
	LPDBCON pCon;
	char	szQuery[MAX_LENGTH_QUERY];
	int		nSize;
	LPVOID	pData;
} DBLoadDataByPtr, *LPDBLoadDataByPtr;

#pragma pack(pop)


#endif // !defined(AFX_DB_H__1E9DC62E_BDF3_4845_B9CC_EE225C7914D5__INCLUDED_)