129 lines
4.1 KiB
C
129 lines
4.1 KiB
C
|
|
|
|
#include <stdio.h>
|
|
#include <stdlib.h>
|
|
#include <netinet/in.h>
|
|
#include <arpa/inet.h>
|
|
#include <netdb.h>
|
|
#include <sys/socket.h>
|
|
#include <unistd.h>
|
|
#include <strings.h>
|
|
#include <time.h>
|
|
#include <sys/time.h>
|
|
|
|
#include <errno.h>
|
|
#include <string.h>
|
|
|
|
|
|
#define BOOL int
|
|
#define FALSE 0
|
|
#define TRUE 1
|
|
|
|
void sasql_close( void );
|
|
BOOL sasql_init( void );
|
|
int sasql_query(char *nm, char *pas);
|
|
BOOL sasql_update(char *nm, char *path);
|
|
BOOL sasql_logindate(char *nm);
|
|
BOOL sasql_online( char *ID, char *NM, char *IP,int fame,int vigor, int flag );
|
|
BOOL sasql_register(char *id, char *ps);
|
|
BOOL sasql_craete_userinfo( void );
|
|
BOOL sasql_craete_lock( void );
|
|
BOOL sasql_chehk_lock( char *idip );
|
|
BOOL sasql_add_lock( char *idip );
|
|
BOOL sasql_del_lock( char *idip );
|
|
int sasql_vippoint( char *ID, int point,int flag );
|
|
int sasql_query_safepasswd(char *id, char *safepasswd);
|
|
int sasql_add_safepasswd(char *id, char *safepasswd);
|
|
int sasql_load_query(char *nm, char *pas);
|
|
int sasql_del_query(char *nm, char *pas);
|
|
BOOL sasql_add_card(char *pas, int num);
|
|
void sasql_query_card(char *id, char *cardps,int charaindex);
|
|
#ifdef _ONLINE_SHOP
|
|
int sasql_chehk_shop( char *dataname );
|
|
char* sasql_query_shop( char *dataname, int startrow, int shopnum );
|
|
int sasql_buy_shop( char *dataname, int startrow, int shopnum, int shopno );
|
|
#endif
|
|
#ifdef _ALL_ITEM
|
|
int sasql_allnum( int flag, int num, int flag1 );
|
|
#endif
|
|
char* sasql_query_question(void);
|
|
#ifdef _SQL_BUY_FUNC
|
|
char *sasql_OnlineBuy( char *id, char *costpasswd );
|
|
void sasql_OnlineBuy_add( char *coststr, int type, int num );
|
|
#endif
|
|
#ifdef _PET_RESET
|
|
int sasql_resetpet_point(int petno);
|
|
int sasql_resetbdpet_point(int petno);
|
|
#endif
|
|
#ifdef _ZHIPIAO_SYSTEM
|
|
int sasql_zhipiao_insert(char *petno,char *cdkey,int point);
|
|
int sasql_zhipiao_query(char *piaono);
|
|
int sasql_zhipiao_update(char *cdkey,char *piaono,int checktype);
|
|
#endif
|
|
#ifdef _FMRANK_POINT
|
|
int sasql_fm_query(void);
|
|
int sasql_fmpoint_query(int fmindex);
|
|
int sasql_fmno_query(int fmindex);
|
|
int sasql_fmpoint_add(int fmindex,int point);
|
|
int sasql_fmindex_add(int fmindex,char *fmname,int point);
|
|
int sasql_fmindex_del(int fmindex);
|
|
#endif
|
|
#ifdef _ITEM_RESET
|
|
int sasql_itemreset_query(int itemid);
|
|
int sasql_itemdel_query(int itemid);
|
|
#endif
|
|
int sasql_cdkey_lock(char *cdkey,int locktype);
|
|
int sasql_ampoint( char *ID, int point, int flag );
|
|
int sasql_cdkey_online( char *cdkey );
|
|
int sasql_check_iponline( char *IP );
|
|
#ifdef _EV_NUM
|
|
char* sasql_ev_npcmsg( int npcno );
|
|
char* sasql_ev_item( void );
|
|
char* sasql_ev_pet( void );
|
|
#endif
|
|
#ifdef _RMB_SYSTEM
|
|
int sasql_rmbpoint( char *ID, int point, int flag );
|
|
#endif
|
|
char* sasql_rand_buf( void );
|
|
int sasql_check_lockip( char *IP ,int type);
|
|
int sasql_check_lockmac( char *mac);
|
|
int sasql_check_lockpcid( char *pcid);
|
|
|
|
int sasql_add_lockip(char *IP,int type,int online,int mode);
|
|
int sasql_query_online_ip(char *IP);
|
|
int sasql_online_ip(char *cdkey,char *IP);
|
|
int sasql_offlinenum( char *IP );
|
|
int sasql_offlinejqmnum( char *cdkey );
|
|
char* sasql_ip( char *cdkey );
|
|
BOOL sasql_online_jqm( char *ID, char *jqm, char *IP,int logintype );
|
|
int sasql_onlinejqmnum( char *jqm, int flag );
|
|
char* sasql_query_jqm( char *cdkey );
|
|
|
|
int sasql_getVipPoint( int charaindex );
|
|
int sasql_setVipPoint( int charaindex, int point );
|
|
int sasql_setVipPointForCdkey( char *id, int point );
|
|
int sasql_getVipPointForCdkey( char *id );
|
|
BOOL sasql_ckeckStrint( char *str );
|
|
#ifdef _CARD_PRODUCTION
|
|
void sasql_OnlineCost_add( int cost, int num);
|
|
#endif
|
|
|
|
int sasql_jifenPoint( int charaindex );
|
|
int sasql_setJfPoint( int charaindex, int point );
|
|
int sasql_xjPoint( int charaindex );
|
|
int sasql_setxjPoint( int charaindex, int point );
|
|
|
|
#ifdef _CAX_LNS_MYSQLSUOXU
|
|
void sasql_LUASQLAdv(char* sqlstr,char* filepath,char* function,int npcindex ,int charaindex,char* msg,int flg);
|
|
void sasql_LUASQL(char* sqlstr,int row,char* filepath,char* function,int npcindex ,int charaindex,char* msg);
|
|
|
|
char* sasql_Lua_QueryR(int row,char *sqlstr);
|
|
char* sasql_LuaAdv_QueryR(char *sqlstr,int flg);
|
|
#endif
|
|
|
|
#ifdef _CAX_NEWMAC_LOGIN
|
|
char* sasql_query_mac( char *cdkey );
|
|
BOOL sasql_online_mac( char *ID, char *mac, char *IP,int logintype );
|
|
int sasql_onlinemacnum( char *mac, int flag );
|
|
#endif
|