mysql.h

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

extern int EndsetPartyMenberForUpdate( CHARLIST *ch );		// 0218 YGI

extern int CurrentTotalUserInMap( void );

extern int GetTitleBBS( int count, int ct[10], TIMESTAMP_STRUCT date[10], char name[10][ FILENAME_MAX], char title[10][ FILENAME_MAX] );


//////////////////////////////////		0405 YGI /////////////////////////
extern int GetBelieveAndFaith_SQL( int &believe, int &faith, char *name );		// 0316 YGI
extern int UpdateFaith_SQL( short int faith, char *name );						// 0316 YGI

extern int UpdateEvaName( const char *my_name, char *eva_name );		// 傈档茄 荤恩 捞抚阑 叼厚俊 诀单捞飘 茄促.//020725 lsw
extern void SubtractFaith( const char *naem );//020725 lsw




extern int GetEvangelist( char *my_name, char *eva_name );

extern bool CheckIsRealName( char *id, char *charname );

extern int GetCharNew( int &is_new, char *name );		// new char
extern int UpdateCharNew( char *name );




extern int GetGodMeetingTime( TIMESTAMP_STRUCT &day, TIMESTAMP_STRUCT &month, TIMESTAMP_STRUCT &year, int god_index );
extern char *GetMeetingMessage( int god_type, int text_type, int text_num );			// 0407 YGI

extern int UpdateCharStatusByKein( k_char_update_data *ch );		// 0410 YGI
extern int GetCharDataStatusByKein( k_get_char_info *ch, char *name );		// 0410 YGI
extern int UpdateCharStatusByKein( t_connection c[], short int cn );		// 0410 YGI

extern int AccessBoxData( int box_id );			// 0420 YGI

extern int GetMailTitle( char *name, MAIL mail[], int start_mail_id );	// 020808 YGI 
extern int GetMailBody( int type, DWORD  mail_id, char *body );
extern int DeleteMail( DWORD  mail_id );


extern bool UpdateLogintablebyChangeMap( char *user_id, char *map_name );


extern int GetRowLineOfSQL( const char *table, const char *field, int *RowCount, const char *condition, HDBC hdbc = NULL );		// 1004 YGI
extern int GetRecentMapName( char *char_name, char *map_name );


extern void GetPublicBbs( char **text );			// 0725 YGI
extern int InsertHunterList( char *target_name, char *wanted_name, DWORD money, char *profile );		// 0802 YGI
extern int GetHunterList( int id, k_hunter_list *hunterlist, int type );//soto-031006
extern int CheckMail( DWORD  mail_id );			// 0808 YGI
extern int DeleteHunterList( int list_id );

extern int DeleteBox( int box_id );		// 0817 YGI
extern int SearchBoxAndDelete( UCHAR **inv, UCHAR **bank, const char *szName );//020725 lsw
extern void DeleteBoxByDeleteCharacter( const char *szname );		// 某腐磐甫 瘤匡锭 冠胶档 瘤款促.//020725 lsw

extern int UpdateResetJob_SQL( int job, char *name );		// 0909 YGI
extern int get_Skill_BinaryData(UCHAR **skill_exp, UCHAR **script_var, char *name);
extern int Update_Skill_BinaryData(UCHAR **skill, UCHAR **skill_exp, UCHAR **script_var, char *name);
extern int UpdateSelectNation( int nation, char *name );	// 0927 YGI
extern int GetNationById( char *login_id );		// 0927 YGI
extern int GetMapInfo( t_mapinfo aMap[] );
extern int MapPort( char *mapname );
extern bool GetGuildCode(const char* szName, int& rGuildCode); // CSD-030326
extern bool SetGuildCode( char * pName, int iGuildCode);	// 030602 YGI
extern int GetNationByName( char *name, DWORD *nation );		// 1027 YGI 惫啊蔼父 啊瘤绊 坷绰巴捞 酒聪扼 匙烙胶抛捞磐胶 促 啊廉柯促.
extern int GetVoteById_SQL( char *szUID );
extern int SetVote_SQL( char *id, int vote_num );

extern int SetPlusScoreVote( int candidate, int vote_num, int nation );					// 001031_2 YGI // 垫钎甫 歹秦霖促.
extern int GetScoreVote( int candidate, int vote_num, int nation );		// 001031_2 YGI


extern int RegistCandidate_SQL( k_candidate *p );		// 饶焊 殿废
extern int GetCandidate_SQL( const char *name, short int vote_num, k_candidate *p );		// 饶焊 沥焊 啊廉坷扁
extern int GetCandidate_SQL( short int vote_num, short int nation, k_candidate p[] );		// 饶焊 沥焊 啊廉坷扁

extern int GetCurrentVoting( int vote_num, int nation, k_rep_vote_score *target );		// 泅犁 急芭 柳青 惑炔
extern int GetVoteInfo( k_set_value_of_vote *target );	// 急芭 锅龋客 泅犁 急芭 惑怕
extern int SetVoteEndFlag( int count, int type );		// 垫钎甫 歹秦霖促.
extern int GetVoteNumberOne( int nation, int vote_num, char *name );
extern int UpdateYouAreKing( char *name, int king );
extern int SetVoteEndFlag( int count );
extern int CheckDbTable(int nation, char *name );
extern int GetKingOfNation_SQL( int nation, char *name );
extern int InsertGmRegist( k_gm_regist_db *p );		// 1027 YGI

extern int GetSalvation( char * name, DWORD &money );		// 扁何茄 捣 舅酒焊扁// 001214 YGI
extern int PlusMoneyRedClose( double &TotalMoney, DWORD plus_money );

extern int LoadNoName_SQL();		// 010117 YGI
extern int SetChocolateCount( char * name, int &count );		// 010212 YGI
extern int GetTopGivenChocolate( char * name, int &count );		// 穿啊 啊厘 腹捞 啊瘤绊 乐绰啊

//010303 YGI
extern int SaveOpenSchoolItem( char *name, int nation, int item_no, int &number );
extern int SetNationByName( DWORD status, char *name );		// 1027 YGI

// 010310 YGI
extern int GetChocolateEatName( char *name, DWORD total_id );
extern int GetNameByTotalId( char *name, DWORD total_id );
extern int SaveWhiteDayEvent( char *name, char *name2 );

// 010314 KHS
extern int CheckLogInTable( int server_set_num );
extern int CheckWorstDBTable( void );

// 010511 YGI
extern int UpdateLadderScore( DWORD ladderscore, char *name, int nation, int cls, int lv );
extern void RefreshColossus_rank_read_table();
extern int GetLadderScoreRank( int rank, k_db_get_ladder_score_rank *rank_data );
extern int GetRankLadderByName( char *name );

//010530 YGI
extern int SaveNationInfo_SQL( k_save_nation_info *p );


// 010801 YGI
extern int UpdateGuildMark( int guild_code, int size, UCHAR *mark );
extern int GetGuildImageSize( int guild_code );
extern int SaveGuildRegistImsi( int guild_code, k_regist_guild_imsi_db *guild, k_set_guild_info *guild_info );
extern int GetLoginIdByName( char *name, char *login_id );
extern int GetDataBasic2ByName( k_char_data_basic2 *data, char *name );

extern int GetEmptyGuildCode( int &guild_code );
extern int GetGuildExplain( int guild_code, int &len, char *explain );
extern int IncreaseNumberOfGuildList( int guild_code, int type, BYTE &number );
extern int GetGuildMarkImage( int guild_code, char *image, int size, int &mark_num );
extern int SaveGuildRegist( k_guild_regist *guild, int &info_num );
extern int SaveChangeGuildDegree( k_guild_change_degree *guild, int &info_num );
extern int ChangeGuildMemberList( char *char_name, int guild_code, int guild_degree );
extern int GetGuildMakeNumber( int guild_code, int &make );
extern int PutGuildMail( int guild_code, char *title, char *body, char *ch_name, int degree );
extern int GetGuildMailTitle( int guild_code, k_guild_mail mail[] );
extern int GetGuildMailBody( DWORD guild_mail, DWORD mail_id, char *body );

extern int UpdateGuildMailId( char *name, DWORD mail_id );
extern int GetGuildMailId( char *name, int &mail_id );
extern int CheckGuildMail( int guild_code, int &mail_id );
extern int GetGuildMailInfo( DWORD mail_id, int &conv_guild_code, int &conv_degree );
extern int DeleteGuildMail( DWORD mail_id );
extern int GetGuildMasterAndsubMaster( int guild_code, char *master, char *sub_master );
extern int IsExistGiuildMember( char *name );		// 辨靛糕滚俊 郴啊 加秦 乐绰啊?
extern int CheckGuildMemberForRegistGuild( int nGuildCode );
extern int DeleteGuild( int guild_code );
extern int DeleteGuildMemberList( int guild_code );
extern int DeleteImsiGuild( int *guild_code, int &guild_code_count );
extern int GetEventItemNumber( int *item_no, char *szID);
extern int DeleteEventItemNumber( char *szID, int count );
extern int GetCharOfGuildMemberList( int guild_code, k_get_guild_memeber_list *data );
extern int GetGuildNotice( int guild_code, char *text );
//extern int SetGuildNotice( int guild_code, char *text );
extern int RegistFriend_SQL( char *name1, char *name2 );
extern int GetFriend_SQL( char *name, char data_name[][20] );
extern int SaveEventItem( char *name, int item_no, int count );

extern int GetGuildItemIndexAndCount( int guild_code, int &max, DWORD *index );
extern int GetGuildItem( int guild_code, int cn, ItemAttr *item, int &count, DWORD *index );
extern int InsertGuildItem( int guild_code, ItemAttr *pItem, char *name );
extern int GetGuildItemOne( int guild_code, DWORD index, ItemAttr *pItem );		// 角力 酒捞袍 窍唱 啊廉坷扁
extern int GetGuildItemOne( int guild_code, int item_no, ItemAttr *pItem, char *name );
extern int GetGuildItemPay( int guild_code, DWORD &box_money );
extern int GetLastGuildCode( int &last_guild_code ); // CSD-030324
extern int GetActiveByGuildList( int guild_code, int &active );
extern int CheckGuildMasterLastConnect( int guild_code );
extern int GetGuildHouseInfo( k_guild_house_info *data, int &count, int nation );
extern int GetGuildHouseInfoById( k_change_guild_house_info_db2map *data, int house_id );
extern int GetCheckGuildHouse( char *pHouseId, int &count );
extern bool IsExitRecordOfDB( char *table, char *condition );
extern void displaySQLError(SQLHSTMT hStmt, char *szQuery = NULL);
//< CSD-020724
extern int GetSkillPoint(const char* pName);
extern int ClearSkillPoint(const char* pName);
//> CSD-020724
#define SQLOK( x ) ( (x) == SQL_SUCCESS_WITH_INFO || (x) == SQL_SUCCESS )		//1027 YGI
// 020808 YGI
extern int SaveItemLog( k_item_log *pData );

//021030 YGI
#ifndef __k_startitem_basic__
#define __k_startitem_basic__
struct k_startitem_basic
{
	int m_nEventNo;
	int m_bAll;
	int m_nSex;
	int m_nClass;
	int m_nNation;
	int m_nItem1No;
	int m_nItem1Mutant;
	int m_nItem1Grade;
	int m_nItem2No;
	int m_nItem2Mutant;
	int m_nItem2Grade;
	int m_bAble;		// 促 犬牢饶俊 力傍且瘤 救且 瘤 魄窜侩
	char m_szTable[20]; // 030616 YGI

	k_startitem_basic()
	{
		m_nEventNo = 0;
		m_bAble = 0;
		m_szTable[0] = 0; // 030616 YGI
	}
};
#endif


extern int AddEventItem( CHARLIST *ch, k_startitem_basic* pData );
extern int MakeAndSetItem( CHARLIST *ch, int item_no, int item_mutant, int item_grade );
extern int CheckEventITem( CHARLIST *ch );
extern int CheckEventObject( char *map_name, k_event_object_sound *data );
extern int CheckEventSound( char *map_name, k_event_object_sound *data );
//021107 YGI
extern int GetEventMoveMapName( k_event_move_map_req *pData, k_event_move_map_rep *pMapData );
extern int LoadNPCLevTable(); // CSD-030306
// 040105 YGI
extern int GetMapNameByNumber( char *name );
extern int GetTreasureAttr( int &mapnumber, int &x, int &y );

extern HENV  hEnv;
extern HDBC  hDBC;
extern HENV  hEnv_TotalDB;
extern HDBC  hDBC_TotalDB;
extern HENV  hEnv_ChrLogDB;
extern HDBC  hDBC_ChrLogDB;

extern HENV  hEnv_NGCDB;
extern HDBC  hDBC_NGCDB;

extern int FREE_LEVEL_; // CSD-040127

#endif // !defined(AFX_MYSQL_H__65C7ED7E_9020_467F_AB76_8528EE975EC8__INCLUDED_)