def updateTrainbaseInfo(characterId,props): '''修改玩家训练基地纪录''' sql=util.forEachUpdateProps('tb_character_trainbase',props,{'characterId':characterId}) conn=dbpool.connection() cursor=conn.cursor() count=cursor.execute(sql) conn.commit() cursor.close() conn.close() if count: return True return False
def updateMailInfo(mailId, prop): '''更新邮件信息''' sql = util.forEachUpdateProps('tb_mail', prop, {'id': mailId}) conn = dbpool.connection() cursor = conn.cursor() count = cursor.execute(sql) conn.commit() cursor.close() conn.close() if (count >= 1): return True return False
def UpdateTaskProcess(characterId,taskId,props): '''更新任务进度''' sql=util.forEachUpdateProps('tb_task_process',props,{'characterId':characterId,'taskId':taskId}) conn=dbpool.connection() cursor=conn.cursor() count=cursor.execute(sql) conn.commit() cursor.close() conn.close() if count: return True return False
def updateMailInfo(mailId,prop): '''更新邮件信息''' sql=util.forEachUpdateProps('tb_mail',prop,{'id':mailId}) conn=dbpool.connection() cursor=conn.cursor() count=cursor.execute(sql) conn.commit() cursor.close() conn.close() if(count>=1): return True return False
def UpdatePlayerInfo(playerId,props): '''更新球员信息''' sqlstr=util.forEachUpdateProps('tb_player',props,{'id':playerId}) conn=dbpool.connection() cursor=conn.cursor() count=cursor.execute(sqlstr) conn.commit() cursor.close() conn.close() if count>=1: return True else: return False
def UpdatePlayerInfo(playerId, props): '''更新球员信息''' sqlstr = util.forEachUpdateProps('tb_player', props, {'id': playerId}) conn = dbpool.connection() cursor = conn.cursor() count = cursor.execute(sqlstr) conn.commit() cursor.close() conn.close() if count >= 1: return True else: return False
def updateCharacterArenaInfo(characterId,props): '''更新角色的竞技场信息 ''' sqlstr = util.forEachUpdateProps('tb_arena', props,{'characterId':characterId}) conn = dbpool.connection() cursor = conn.cursor() count = cursor.execute(sqlstr) conn.commit() cursor.close() conn.close() if count >= 1: return True else: return False
def updateGamerInfo(characterId,props): '''''' sqlstr=util.forEachUpdateProps('tb_character',props,{'id':characterId}) conn=dbpool.connection() cursor=conn.cursor() count=cursor.execute(sqlstr) conn.commit() cursor.close() conn.close() if count>=1: return True else: log.err(sqlstr) return False
def updateMailInfo(mailId,prop): '''更新邮件信息''' # 传来了prop,prop包含需要更新的键值 # 在 util.forEachUpdateProps 会格式化 sql 语句 # {'id':mailId} 是 用于 where 判断 sql = util.forEachUpdateProps('tb_mail',prop, {'id':mailId}) conn = dbpool.connection() cursor = conn.cursor() count = cursor.execute(sql) conn.commit() cursor.close() conn.close() if(count >= 1): return True return False
def updatePlayerDB(player): '''更新角色的数据库信息''' characterId = player.baseInfo.id props = {'level':player.level.getLevel(),'coin':player.finance.getCoin(), 'exp':player.level.getExp(),'hp':player.attribute.getHp()} sqlstr = util.forEachUpdateProps('tb_character',props, {'id':characterId}) conn = dbpool.connection() cursor = conn.cursor() count = cursor.execute(sqlstr) conn.commit() cursor.close() conn.close() if count >= 1: return True else: log.err(sqlstr) return False
def updatePlayerDB(player): '''更新角色的数据库信息''' characterId = player.baseInfo.id props = {'level':player.level.getLevel(),'coin':player.finance.getCoin(),'gold':player.finance.getGold(), 'exp':player.level.getExp(),'nickname':player.baseInfo.getNickName()} sqlstr = util.forEachUpdateProps('tb_character',props, {'id':characterId}) conn = dbpool.connection() cursor = conn.cursor() count = cursor.execute(sqlstr) conn.commit() cursor.close() conn.close() if count >= 1: return True else: log.err(sqlstr) return False
def updatePlayerDB(player): '''更新角色的数据库信息''' characterId = player.baseInfo.id props = {'level': 0, 'coin': 0, 'exp': 0, 'hp': 0} sqlstr = util.forEachUpdateProps('tb_character', props, {'id': characterId}) conn = dbpool.connection() cursor = conn.cursor() count = cursor.execute(sqlstr) conn.commit() cursor.close() conn.close() if count >= 1: return True else: log.err(sqlstr) return False
def updatePlayerDB(player): '''更新角色的数据库任务完成信息''' characterId = player.baseInfo.id props = { 'ifcompleted': player.level.getLevel(), 'ifrewarded': player.finance.getCoin() } sqlstr = util.forEachUpdateProps('tb_task_completed', props, {'id': characterId}) conn = dbpool.connection() cursor = conn.cursor() count = cursor.execute(sqlstr) conn.commit() cursor.close() conn.close() if count >= 1: return True else: log.err(sqlstr) return False
def updatePlayerDB(player): '''更新角色的数据库信息''' characterId = player.baseInfo.id # 将角色信息放入字典 level coin exp hp props = { 'level': player.level.getLevel(), 'coin': player.finance.getCoin(), 'exp': player.level.getExp(), 'hp': player.attribute.getHp() } # 更新列表id对应数据库表的属性 这里使用 dbenbust的 util sqlstr = util.forEachUpdateProps('tb_character', props, {'id': characterId}) conn = dbpool.connection() cursor = conn.cursor() count = cursor.execute(sqlstr) conn.commit() cursor.close() conn.close() if count >= 1: return True else: log.err(sqlstr) return False