def getALlCharacterBaseInfo(): """获取所有的角色的基础信息 """ sql = "SELECT `id`,`level`,`profession`,`nickname` FROM tb_character;"; result = dbpool.fetchAll(sql) return result
def getProfession_Config(): """获取职业配置表信息""" global tb_Profession_Config sql = "select * from tb_profession" result = dbpool.fetchAll(sql) for _item in result: tb_Profession_Config[_item['preId']] = _item
def getALlCharacterBaseInfo(): """获取所有的角色的基础信息 """ sql = "SELECT `id`,`level`,`profession`,`nickname` FROM tb_character;" result = dbpool.fetchAll(sql) return result
def getCharacterBattleLog(characterId): """获取角色战斗日志 """ sql = "SELECT * from tb_arena_log where tiaozhan = %d \ or yingzhan = %d order by recordtime desc limit 0,5;"%(characterId,characterId) result = dbpool.fetchAll(sql) return result
def getFriendTopLevel(characterId,index,limit=20): """获取好友的等级排行 """ sql = "SELECT id,nickname,level,coin \ FROM tb_character WHERE `id`!=%d ORDER BY level LIMIT %d,%d;"%(characterId,index,limit) result = dbpool.fetchAll(sql) return result
def getPetExp(): """获取宠物的经验表""" global PET_EXP sql = "SELECT * FROM tb_pet_experience" result = dbpool.fetchAll(sql) for exp in result: PET_EXP[exp["level"]] = exp["ExpRequired"]
def getPetExp(): """获取宠物的经验表""" global PET_EXP sql = "SELECT * FROM tb_pet_experience" result = dbpool.fetchAll(sql) for exp in result: PET_EXP[exp['level']] = exp['ExpRequired']
def getExperience_Config(): """获取经验配置表信息""" global tb_Experience_config sql = "select * from tb_experience" result = dbpool.fetchAll(sql) for _item in result: tb_Experience_config[_item['level']] = _item
def getAllMonsterInfo(): """获取所有怪物的信息 """ global All_MonsterInfo sql = "SELECT * FROM tb_monster" result = dbpool.fetchAll(sql) for monster in result: All_MonsterInfo[monster['id']] = monster
def getFriendTopLevel(characterId, index, limit=20): """获取好友的等级排行 """ sql = "SELECT id,nickname,level,coin \ FROM tb_character WHERE `id`!=%d ORDER BY level LIMIT %d,%d;" % ( characterId, index, limit) result = dbpool.fetchAll(sql) return result
def getCharacterBattleLog(characterId): """获取角色战斗日志 """ sql = "SELECT * from tb_arena_log where tiaozhan = %d \ or yingzhan = %d order by recordtime desc limit 0,5;" % (characterId, characterId) result = dbpool.fetchAll(sql) return result
def getPetTrainConfig(): """获取宠物培养配置信息""" global PET_TRAIN_CONFIG sql = "SELECT * FROM tb_pet_training " result = dbpool.fetchAll(sql) for train in result: PET_TRAIN_CONFIG[train['quality']] = train return result
def getPetTrainConfig(): """获取宠物培养配置信息""" global PET_TRAIN_CONFIG sql = "SELECT * FROM tb_pet_training " result = dbpool.fetchAll(sql) for train in result: PET_TRAIN_CONFIG[train["quality"]] = train return result
def getAllCharacterTop(index, limit=20): """获取全服的排行信息 """ sql = "SELECT id,nickname,`level`,coin FROM\ tb_character ORDER BY guanqia LIMIT %d,%d;" % (index, limit) result = dbpool.fetchAll(sql) return result
def getFriendTopGuanqia(characterId, index, limit=20): """获取好友的关卡排行 """ sql = "SELECT id,nickname,`level`,coin FROM tb_character WHERE\ `id`!=%d ORDER BY guanqia LIMIT %d,%d;" % (characterId, index, limit) result = dbpool.fetchAll(sql) return result
def getAll_ItemTemplate(): """获取所有的物品信息 """ global all_ItemTemplate sql="select * from `tb_item_template`" result = dbpool.fetchAll(sql) for _item in result: all_ItemTemplate[_item['id']] = _item
def getAllCharacterTop(index,limit=20): """获取全服的排行信息 """ sql = "SELECT id,nickname,`level`,coin FROM\ tb_character ORDER BY guanqia LIMIT %d,%d;"%(index,limit) result = dbpool.fetchAll(sql) return result
def getAll_ItemTemplate(): """获取所有的物品信息 """ global all_ItemTemplate sql = "select * from `tb_item_template`" result = dbpool.fetchAll(sql) for _item in result: all_ItemTemplate[_item['id']] = _item
def getFriendTopGuanqia(characterId,index,limit=20): """获取好友的关卡排行 """ sql = "SELECT id,nickname,`level`,coin FROM tb_character WHERE\ `id`!=%d ORDER BY guanqia LIMIT %d,%d;"%(characterId,index,limit) result = dbpool.fetchAll(sql) return result
def getAllZhanYiInfo(): """获取所有战役的信息 """ global ALL_ZHANYI_INFO sql = "SELECT * FROM tb_zhanyi" result = dbpool.fetchAll(sql) for zhanyi in result: ALL_ZHANYI_INFO[zhanyi['id']] = zhanyi
def getAllsetInfo(): """获取所有的套装信息 """ global ALL_SETINFO sql = "SELECT * from tb_equipmentset;" result = dbpool.fetchAll(sql) for setinfo in result: ALL_SETINFO[setinfo['id']] = setinfo
def getAll(): """获取所有掉落信息""" global DROPOUT_CONFIG sql = "select * from tb_dropout" result = dbpool.fetchAll(sql) if not result: return None for item in result: item['itemid']=eval("["+item['itemid']+"]") DROPOUT_CONFIG[item['id']]=item
def getAllBuffInfo(): """获取所有技能的信息""" global ALL_BUFF_INFO sql = "SELECT * FROM tb_buff_info" result = dbpool.fetchAll(sql) for buff in result: ALL_BUFF_INFO[buff['buffId']] = buff effectInfo = getBuffEffect(buff['buffEffectID']) ALL_BUFF_INFO[buff['buffId']]['buffEffects'] = effectInfo
def getBuffOffsetInfo(): """获取所有buff之间效果的信息配置 """ global BUFF_BUFF sql = "SELECT * FROM tb_buff_buff" result = dbpool.fetchAll(sql) for offset in result: if not BUFF_BUFF.has_key(offset['buffId']): BUFF_BUFF[offset['buffId']] = {} BUFF_BUFF[offset['buffId']][offset['tbuffId']] = offset
def getBuffAddition(): """获取buff对技能的加成 """ global BUFF_SKILL sql = "SELECT * FROM tb_buff_skill" result = dbpool.fetchAll(sql) for addition in result: if not BUFF_SKILL.has_key(addition['buffId']): BUFF_SKILL[addition['buffId']] = {} BUFF_SKILL[addition['buffId']][addition['skillId']] = addition['addition']
def getAll(): """获取所有翻译信息""" sql = "SELECT * FROM tb_language" result = dbpool.fetchAll(sql) if not result: return None data = {} for item in result: data[item['id']] = item['content'] return data
def getAll(): """获取所有翻译信息""" sql="SELECT * FROM tb_language" result = dbpool.fetchAll(sql) if not result: return None data={} for item in result: data[item['id']]=item['content'] return data
def getAllLevelMail(): """获取所有的等级邮件提示 """ global LEVEL_MAIL sql = "SELECT * FROM tb_levelmail" result = dbpool.fetchAll(sql) scenesInfo = {} for scene in result: scenesInfo[scene['level']] = scene LEVEL_MAIL = scenesInfo return scenesInfo
def getAllZhangJieInfo(): """获取章节的信息 """ global ALL_ZHANGJIE_INFO,ALL_ZHANGJIE_GROP sql = "SELECT * FROM tb_zhangjie" result = dbpool.fetchAll(sql) for zhangjie in result: ALL_ZHANGJIE_INFO[zhangjie['id']] = zhangjie if not ALL_ZHANGJIE_GROP.get(zhangjie['yid']): ALL_ZHANGJIE_GROP[zhangjie['yid']] = [] ALL_ZHANGJIE_GROP[zhangjie['yid']].append(zhangjie['id'])
def getAllZhangJieInfo(): """获取章节的信息 """ global ALL_ZHANGJIE_INFO, ALL_ZHANGJIE_GROP sql = "SELECT * FROM tb_zhangjie" result = dbpool.fetchAll(sql) for zhangjie in result: ALL_ZHANGJIE_INFO[zhangjie['id']] = zhangjie if not ALL_ZHANGJIE_GROP.get(zhangjie['yid']): ALL_ZHANGJIE_GROP[zhangjie['yid']] = [] ALL_ZHANGJIE_GROP[zhangjie['yid']].append(zhangjie['id'])
def getCharacterRivalList(ranklist): """获取角色的对手列表 """ orsql = forEachSelectORByList('b.ranking', ranklist) if orsql: sql = "SELECT b.characterId,b.ranking,\ a.nickname,a.level,a.profession from tb_character as a,\ tb_arena as b where a.id=b.characterId and (%s) order by `ranking`;"%(orsql) result = dbpool.fetchAll(sql) return result else: return []
def getFirendListByFlg(pid,flg): """获取角色的所有好友或者黑名单 @param pid: int 角色id @param flg: int 1好友 2黑名单 """ sql = "SELECT playerId FROM tb_friend WHERE characterId=%s AND friendType=%s"%(pid,flg) result = dbpool.fetchAll(sql) if not result: return [] listdata=[] for item in result: listdata.append(item['playerId']) return listdata
def getGuYongList(pid): """获取角色的所有好友或者黑名单 @param pid: int 角色id """ sql="SELECT playerId FROM tb_friend WHERE characterId=%s AND guyong=1"%(pid) result = dbpool.fetchAll(sql) if not result: return [] listdata=[] for item in result: listdata.append(item['playerId']) return listdata
def getCharacterRivalList(ranklist): """获取角色的对手列表 """ orsql = forEachSelectORByList('b.ranking', ranklist) if orsql: sql = "SELECT b.characterId,b.ranking,\ a.nickname,a.level,a.profession from tb_character as a,\ tb_arena as b where a.id=b.characterId and (%s) order by `ranking`;" % ( orsql) result = dbpool.fetchAll(sql) return result else: return []
def getAllPetGrowthConfig(): """获取宠物成长配置 """ global PET_GROWTH sql = "SELECT * FROM tb_pet_growth" result = dbpool.fetchAll(sql) for growthconfig in result: attrType = growthconfig['pettype'] quality = growthconfig['quality'] if not PET_GROWTH.has_key(attrType): PET_GROWTH[attrType] = {} PET_GROWTH[attrType][quality] = growthconfig
def getAllPetGrowthConfig(): """获取宠物成长配置 """ global PET_GROWTH sql = "SELECT * FROM tb_pet_growth" result = dbpool.fetchAll(sql) for growthconfig in result: attrType = growthconfig["pettype"] quality = growthconfig["quality"] if not PET_GROWTH.has_key(attrType): PET_GROWTH[attrType] = {} PET_GROWTH[attrType][quality] = growthconfig
def getGuYongList(pid): """获取角色的所有好友或者黑名单 @param pid: int 角色id """ sql = "SELECT playerId FROM tb_friend WHERE characterId=%s AND guyong=1" % ( pid) result = dbpool.fetchAll(sql) if not result: return [] listdata = [] for item in result: listdata.append(item['playerId']) return listdata
def getFirendListByFlg(pid, flg): """获取角色的所有好友或者黑名单 @param pid: int 角色id @param flg: int 1好友 2黑名单 """ sql = "SELECT playerId FROM tb_friend WHERE characterId=%s AND friendType=%s" % ( pid, flg) result = dbpool.fetchAll(sql) if not result: return [] listdata = [] for item in result: listdata.append(item['playerId']) return listdata
def getPlayerSavMailList(characterId,page,limit): """获取角色邮件列表 @param characterId: int 角色的id """ filedList = ['id','title','type','isReaded','sendTime','content'] sqlstr = '' sqlstr = forEachQueryProps(sqlstr, filedList) sql = "select %s from `tb_mail` where receiverId = %d and `isSaved`=1\ order by isReaded LIMIT %d,%d "%(sqlstr,characterId,(page-1)*limit,limit) result = dbpool.fetchAll(sql) data = [] for mail in result: mailInfo = {} for i in range(len(mail)): mailInfo[filedList[i]] = mail[i] data.append(mailInfo) return data
def getAllPetTemplate(): """获取宠物的模板信息""" global PET_TEMPLATE, shopAll, shopXy, PET_TYPE sql = "SELECT * FROM tb_pet_template ORDER BY `level` , `id`;" result = dbpool.fetchAll(sql) for pet in result: attrType = pet["attrType"] if not PET_TYPE.has_key(attrType): PET_TYPE[attrType] = [] PET_TYPE[attrType].append(pet["id"]) PET_TEMPLATE[pet["id"]] = pet if pet["coin"] > 0: zi = pet["baseQuality"] shopAll[zi].append(pet["id"]) if pet["xy"] > 0: shopXy.append(pet)
def getAllPetTemplate(): """获取宠物的模板信息""" global PET_TEMPLATE, shopAll, shopXy, PET_TYPE sql = "SELECT * FROM tb_pet_template ORDER BY `level` , `id`;" result = dbpool.fetchAll(sql) for pet in result: attrType = pet['attrType'] if not PET_TYPE.has_key(attrType): PET_TYPE[attrType] = [] PET_TYPE[attrType].append(pet['id']) PET_TEMPLATE[pet['id']] = pet if pet['coin'] > 0: zi = pet['baseQuality'] shopAll[zi].append(pet['id']) if pet['xy'] > 0: shopXy.append(pet)
def getPlayerSavMailList(characterId, page, limit): """获取角色邮件列表 @param characterId: int 角色的id """ filedList = ['id', 'title', 'type', 'isReaded', 'sendTime', 'content'] sqlstr = '' sqlstr = forEachQueryProps(sqlstr, filedList) sql = "select %s from `tb_mail` where receiverId = %d and `isSaved`=1\ order by isReaded LIMIT %d,%d " % (sqlstr, characterId, (page - 1) * limit, limit) result = dbpool.fetchAll(sql) data = [] for mail in result: mailInfo = {} for i in range(len(mail)): mailInfo[filedList[i]] = mail[i] data.append(mailInfo) return data
def getPlayerAllMailList(characterId): """获取角色邮件列表 @param characterId: int 角色的id """ filedList = ['id','sender','title','type','isReaded','sendTime'] sqlstr = '' sqlstr = forEachQueryProps(sqlstr, filedList) sql = "select %s from `tb_mail` where receiverId = %d and isSaved = 0\ order by isReaded ,sendTime desc"%(sqlstr,characterId) result = dbpool.fetchAll(sql) data = [] for mail in result: mailInfo = {} for i in range(len(mail)): if filedList[i]=='sendTime': mailInfo['sendTime'] = str(mail[i]) else: mailInfo[filedList[i]] = mail[i] data.append(mailInfo) return data
def getPlayerAllMailList(characterId): """获取角色邮件列表 @param characterId: int 角色的id """ filedList = ['id', 'sender', 'title', 'type', 'isReaded', 'sendTime'] sqlstr = '' sqlstr = forEachQueryProps(sqlstr, filedList) sql = "select %s from `tb_mail` where receiverId = %d and isSaved = 0\ order by isReaded ,sendTime desc" % (sqlstr, characterId) result = dbpool.fetchAll(sql) data = [] for mail in result: mailInfo = {} for i in range(len(mail)): if filedList[i] == 'sendTime': mailInfo['sendTime'] = str(mail[i]) else: mailInfo[filedList[i]] = mail[i] data.append(mailInfo) return data
def getAllSkill(): """初始化技能信息 #职业技能组 #技能池 #技能组 """ global ALL_SKILL_INFO,SKILL_GROUP,PROFESSION_SKILLGROUP sql = "SELECT * FROM tb_skill_info" result = dbpool.fetchAll(sql) for skill in result: effectInfo = getSkillEffectByID(skill['effect']) skill['effect'] = effectInfo ALL_SKILL_INFO[skill['skillId']] = skill if not SKILL_GROUP.has_key(skill['skillGroup']): SKILL_GROUP[skill['skillGroup']] = {} SKILL_GROUP[skill['skillGroup']][skill['level']] = skill #初始化职业技能组ID for groupID in SKILL_GROUP: skillInfo = SKILL_GROUP[groupID].get(1) profession = skillInfo.get('profession',0) if not PROFESSION_SKILLGROUP.has_key(profession): PROFESSION_SKILLGROUP[profession] = [] PROFESSION_SKILLGROUP[profession].append(groupID)
def getAll_ShieldWord(): global SHIELDWORD sql = "SELECT sword FROM tb_shieldword;" result = dbpool.fetchAll(sql) SHIELDWORD = result
def getGuyongRecord(characterId): sql = "SELECT * FROM tb_guyong_record WHERE \ characterId = %d ORDER BY reocrddate DESC LIMIT 0,10;"%(characterId) result = dbpool.fetchAll(sql) return result
def getGuyongRecord(characterId): sql = "SELECT * FROM tb_guyong_record WHERE \ characterId = %d ORDER BY reocrddate DESC LIMIT 0,10;" % (characterId) result = dbpool.fetchAll(sql) return result
def getVIPExp(): global VIPEXP sql = "SELECT * FROM tb_vipexp" result = dbpool.fetchAll(sql) for vipp in result: VIPEXP[vipp['viplevel']] = vipp['maxexp']