|
楼主 |
发表于 2006-5-6 21:19:51
|
显示全部楼层
一、OnUserLogin()中增加相关语句如下:- strCmd.Format( "insert into %s(%s,%s)values(%ld,%ld)",
- DB_TB_JOIN, DB_FD_UIN, DB_FD_ITEM, pUserInfo->m_nUin, pVarInfo->m_nItem );
- db.ExecuteSQL( strCmd ); //记录参加的游戏
复制代码
二、OnUserExit(0中增加相关语句如下:- strCmd.Format( "delete from %s where %s=%ld and %s=%ld",
- DB_TB_JOIN, DB_FD_UIN, pUserInfo->m_nUin, DB_FD_ITEM, pVarInfo->m_nItem );
- db.ExecuteSQL( strCmd ); //删除参加的游戏信息
复制代码
三、增加数据表 game_join , 字段 uin、nItem,索引 uin。 |
|