mysql.h

国内著名网络游戏dragon的服务端完整源码 内附完整数据库结构

#if !defined(AFX_MYSQL_H__65C7ED7E_9020_467F_AB76_8528EE975EC8__INCLUDED_)
#define AFX_MYSQL_H__65C7ED7E_9020_467F_AB76_8528EE975EC8__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000


#define MAIL_BUF		2048			// 0507

#define MAX_SKILLMAIN 106


typedef struct t_skillmain{
int NO;
char Skill_Minute[31];
int Class_Warrior;
int Class_Thief;
int Class_Archery;
int Class_Wizard;
int Class_Priest;
int Select_Farmer;
int Select_miner;
int Select_fisher;
int Select_Lumberjack;
int Select_Butcher;
int Select_Herbdigger;
int Select_herdman;
int Select_Carpenter;
int Select_Blacksmith;
int Select_Cooking	;
int Select_Tailoring	;
int Select_Bowcraft_Fletcher;
int Select_Alchemy	;
int Select_Candlemaker	;
int Select_Merchant	;
int Howto	;
int mouse_change	;
int Interface1	;
int Interface2	;
int Success_interface	;
int Fail_Interface	;
int Work_target_self	;
int Work_target_othercharacter	;
int Work_target_object	;
int Work_target_Item	;
int Work_target_earth	;
int Work_target_water	;
int Work_target_forest	;
int Work_target_interface	;
int Tool;
int Object_Workshop	;
int Object_target	;
int Obj_Attribute	;
int Resource1	;
int Resource1_quantity	;
int Resourece2	;
int Resource2_quantity	;
int Resource3	;
int Resource3_quantity	;
int Produce_type	;
int Produce_Fix	;
int Ability_Fix	;
int Time_judge	;
int Time_Maintain	;
int Ability_min	;
int Ability_max	;
int Plus_element	;
int Plus_type	;
int Plus_Rate	;
int Plus_min	;
int SP_demand	;
int Success	;
int effectCharobj_status	;
int Change_enermy_status	;
int Change_enermy_status2	;
int charvisible	;
int Effectobj_status	;
int Changeobj_attribute	;
int changeobj_visible	;
int Skill2job	;
int effectChar_hide	;
int Increase_mov	;
int Increse_Life	;
int Increse_mana	;
int Increse_health	;
int Change_mor	;
int Obj_attribute1	;
int ChangeObj_attribute1	;
int Display_LV	;
int DisPlay_Wis	;
int Display_Int	;
int DisPlay_Life	;
int DisPlay_Health	;
int DisPlay_Damage	;
int DisPlay_AC	;
int DisPlay_inventory	;
int Display_Foot	;
int DisPlay_Item_Changeall	;
int DisPlay_royalty	;
int DisPlay_Item_Status	;
int DisPlay_name	;
int DisPlay_item_Price	;
int effect	;
int effect_wave	;
int effect_race	;
int Success_range	;
int Damage	;
int Status_self	;
int Effect1	;
int Effect_wave1	;
int Enemy_status	;
int Range	;
int Enermy_alram	;
int map	;
int Curser1	;
int Curser2	;
int Curser3	;
int point	;
int inclusive;
int money;
int need_exp;
int MotherSkillType;
int MotherSkillExp;

}SkillMain;



extern SkillMain SkillTbl[ MAX_SKILLMAIN];






extern int Init_SQL(LPSTR szDSN, LPSTR szUID, LPSTR szUPW);
extern int Release_SQL(void);
extern int Init_TotalDB_SQL(LPSTR szDSN, LPSTR szUID, LPSTR szUPW);
extern int Release_TotalDB_SQL(void);
extern int Init_ChrLogDB_SQL(LPSTR szDSN, LPSTR szUID, LPSTR szUPW );
extern int Release_ChrLogDB_SQL(void);
extern int Init_NGCDB_SQL(LPSTR szDSN, LPSTR szUID, LPSTR szUPW );//030207 lsw
extern int Release_NGCDB_SQL(void);//030207 lsw

extern int Querry_SQL(LPSTR szQuerry, HDBC hdbc = NULL);
extern int Insert_SQL(LPSTR szUID, LPSTR szUPW);
extern int GetCharInfo_SQL(LPSTR szUID, t_packet *packet);
extern int GetCharDB_SQL(t_connection c[], int cn);
extern int GetCharGameDB_SQL(t_connection c[], int cn);
extern int GetNameCount_SQL(LPSTR szUID);
extern int CheckName_SQL(LPSTR szUNM);
extern int CreateChar_SQL(t_connection c[], int cn, t_packet *packet);
extern int CreateChar2_SQL(t_connection c[], int cn );
extern int DeleteChar_SQL( const char *id, const char *name,const char *szSecretKeyCode);//020725 lsw

extern int MoveDeleteChar_SQL( const char *szName);//020725 lsw

extern int delete_char_create_fail( LPSTR name );

extern int GetCharactersBasicInfoInID_SQL( LPSTR id, t_packet *packet );


extern int get_BinaryData_from_Chr_Info  (UCHAR *ws, UCHAR *ps, UCHAR *skill, UCHAR *skill_exp, UCHAR *tac_skillEXP, UCHAR *script_var, UCHAR *inv, UCHAR *equip, UCHAR *quick,UCHAR *party,UCHAR *relation,UCHAR *employment,UCHAR *itemindex, char *login_id, char *name);
extern int get_BinaryData_from_Chr_Info2 (UCHAR *bankitem,	 char *login_id, char *name);
extern int update_BinaryData_to_Chr_Info (UCHAR *ws, UCHAR *pa,  UCHAR *akill, UCHAR *skill_exp, UCHAR *tac_skill_exp, UCHAR *script_var, UCHAR *inv,  UCHAR *equip, UCHAR *quick, UCHAR *party,UCHAR *relation,UCHAR *employment,UCHAR *itemindex,char *, char *) ;	//1219 YGI
extern int update_BinaryData_to_Chr_Info2(UCHAR *bankitem, char *, char *) ;


extern int  updateCharacterStatus(t_connection [], int) ;

extern void updateCharacterVeryImportantStatusToLoginServer( t_connection c[], int char_id );
extern void updateCharacterVeryImportant_TacticsSkillExp_ToLoginServer( t_connection c[], int char_id );
extern int RecvUpdateCharacterVeryImportantStatus( t_update_very_important_status *tp );
extern void updateCharacterStatusToLoginServer( t_connection c[], int char_id);
extern void updateBinaryDataToLoaginServer( t_connection c[], int id );



extern int GetMapName_SQL(t_connection c[], int cn);
extern int GetConnectInfo_SQL(t_connection c[], int cn, t_packet *packet, char *mapname);
extern int GetChangeMapInfo_SQL(t_connection c[], int cn, t_packet *packet);

extern int CheckUsedID_SQL( LPSTR szUID, WORD *wPort, DWORD *dwID, DWORD *dwServerSetNum );

extern void SendDeleteUsedID( int server_id );
extern int  IsThereLoginTable_SQL( LPSTR szUID );


extern int AddBoxItem_SQL(int id);
extern int DeleteBoxItem_SQL(int id);
extern int PutBoxItem_SQL(int id, int pos, ItemAttr *I);
extern int GetBoxItem_SQL(int id, int pos, ItemAttr *I);


// Party/ Relation/ Employment俊 措茄 Data釜 DB俊辑 啊廉柯促. 
extern int GetPartyChar_SQL( char *name, int *Level, int *Face, int *Str, int *Class, int *Gender );	// 0115

extern int UpdateTotalMapConnections( char *mapname, int no );
extern int TotalConnections( void );

extern void RecvIsThereCharName( int cn, char *name );
extern int get_BinaryData_Party( UCHAR **party, const char *name);		// 0116 YGI

extern int CheckBetaId_SQL(LPSTR szUNM);		// 0130 YGI
extern void CheckBetaIdTest( int cn, char *id );			// YGI 0130
extern int CheckNoName_SQL(LPSTR szUNM);			// 0131 YGI
extern bool SearchStrStr( const char *szSource, const char *szWhite );		// 0208 YGI
extern bool SearchStrWord( const char *szSource );		// 0209 YGI
extern void LoadNoNameString();

extern int InitSkillTable( void );








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

//1029 zhh
extern int RecvUpdateSpecial( t_server_special_item *p);

extern int RecvUpdateCharDB( t_update_char_db *p );
extern int RecvUpdateBinaryData( t_server_update_binary_data0 *p );
extern int RecvUpdateTacticSkillExpData( t_update_very_important_tactics *p );
extern int  RecvUpdateScriptData( t_server_update_script_data *p );
extern int RecvUpdateBinaryData1( t_server_update_binary_data1 *p );
extern int RecvUpdateInvData( t_server_update_inv_data *p );
extern int RecvUpdateItemData( t_server_update_item_data *p );
extern int RecvUpdateBankItemData( t_connection c[], int cn, t_server_update_bankitem_data  *p  );