void ARENA::writeArenaRank2DB()
{
for (auto it:mapRoleIDRank)
{
//logwm("id=%d rank=%d\n",it.first,it.second);
if ( ! EXEC_SQL( "insert into " TABLE_RANK " (roleid, arenarank) values('%d', '%d') ", it.first, it.second) )//要改
{
return ;
}
}
}
int do_register(int sockfd,sqlite3 *pdb,char *_username,char *_password)
{
MSG msg;
char *errmsg;
char **dbresult;
int nrow,ncolumn;
char sql[1024] = {0};
sprintf(sql,"select * from user_table where NAME='%s';",_username);
if(sqlite3_get_table(pdb,sql,&dbresult,&nrow,&ncolumn,&errmsg) != 0)
{
fprintf(stderr,"sqlite3 get table error : %s.\n",errmsg);
exit(EXIT_FAILURE);
}
//没有这样的用户名
if(nrow == 0)
{
//录入数据库
bzero(sql,sizeof(sql));
sprintf(sql,"insert into user_table values('%s','%s');",_username,_password);
EXEC_SQL(pdb,sql,errmsg);
msg.type = REGISTER;
msg._errno = OK;
strcpy(msg.mtext,"Register success !");
send(sockfd,&msg,sizeof(msg),0);
//注册失败,用户名存在
}else{
msg.type = REGISTER;
msg._errno = EXIST;
strcpy(msg.mtext,"Register fail,The username is EEXIST.");
send(sockfd,&msg,sizeof(msg),0);
}
sqlite3_free_table(dbresult);
return 0;
}
