Example #1
0
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
Example #2
0
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
Example #3
0
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
Example #4
0
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
Example #5
0
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
Example #6
0
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
Example #7
0
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
Example #8
0
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
Example #9
0
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
Example #10
0
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
Example #11
0
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
Example #12
0
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
Example #13
0
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
Example #14
0
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
Example #15
0
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