def getOrderInfo(): '''按照顺序取出''' sql = "SELECT * FROM welfare ORDER BY typeid,top" result = dbto.exeall(sql) data = {} #key:任务类型 ,value:[welfare任务主键id,welfare任务主键id] sql = "SELECT * FROM welfare_type" td = dbto.exeall(sql) for tinfo in td: data[tinfo['id']] = [] for row in result: data[row['typeid']].append(row['id']) return data
def getModulus(): '''获取所有系数''' sql = "SELECT * FROM modulus" data = dbto.exeall(sql) if not data: return {} return data[0]
def getInstanceIdList(): '''获取所有副本id列表''' sql = "SELECT id FROM instance ORDER BY id" data = dbto.exeall(sql) jg = [] for item in data: jg.append(item['id']) return jg
def getAll(): '''获取所有宠物信息''' sql = "SELECT * FROM pet_new_instance" values = dbto.exeall(sql) data = {} for item in values: data[item['instanceid']] = item return data
def getAllTypes(): '''获取所有福利任务类型''' sql = "SELECT * FROM welfare_type" result = dbto.exeall(sql) data = {} for row in result: data[row['id']] = row return data
def getAllLanguage(): '''获取language表所有数据''' sql = "SELECT * FROM language" result = dbto.exeall(sql) data = {} for i in result: data[i['id']] = i['content'] return data
def getAllIntensifyInfo(): '''获取宠物强化成功率和消耗表所有数据''' sql = "SELECT * FROM intensify" result = dbto.exeall(sql) data = {} for i in result: data[i['level']] = i return data
def geConfigs(): '''获取所有宠物成长信息''' sql = "SELECT * FROM configs" configList = dbto.exeall(sql) data = {} for item in configList: data[item['id']] = item['datas'] return data
def getAllIntensifyInfo(): '''获取福利配置表所有数据''' sql = "SELECT * FROM welfare" result = dbto.exeall(sql) data = {} for i in result: data[i['id']] = i return data
def getPetExp(): '''获取宠物升级所需经验 ''' sql = "SELECT * FROM pet_exp" data = dbto.exeall(sql) result = {} for i in data: result[i["levelId"]] = i["exp"] return result
def getAllInstance(): sql = "SELECT * FROM instance ORDER BY id" data = dbto.exeall(sql) jg = {} for item in data: try: item['mlist'] = eval(item['mlist']) jg[item['id']] = item except: log.err("instancedb mlist error id=%d" % item['id']) return jg
def getAllPets(): '''获取所有宠物信息''' sql = "SELECT * FROM pet" data = dbto.exeall(sql) jg = {} for item in data: try: item['skilllist'] = eval(item['skilllist']) jg[item['id']] = item except: log.err("skill table id=%d skilllist is error" % item['id']) return jg
def getAllskill(): '''获取所有技能信息''' sql = "SELECT * FROM skill" data = dbto.exeall(sql) newdata = {} for item in data: # try: # item['script']=eval(item['script']) # except: # log.err("skill table id=%d script is error"%item['id']) newdata[item['id']] = item return newdata
def getAllMonster_Json(): '''获取所有宠物json信息''' sql = "SELECT * FROM monster" data = dbto.exeall(sql) jg = {} for item in data: try: item['skilllist'] = eval(item['skilllist']) jg[item['id']] = item except: log.err("monster skill table id=%d skilllist is error" % item['id']) return jg
def getTypeMonster(tyepid): '''获取某一类型的怪物''' sql = "SELECT * FROM monster WHERE btype=%d" % tyepid data = dbto.exeall(sql) return data
def getByPid(pid): sql = "SELECT * FROM player_welfare WHERE pid=%d ORDER BY typeid" % pid info = dbto.exeall(sql) return info
def getByPid(pid): '''获取角色解锁和未解锁的宠物''' sql="SELECT * FROM player_pet WHERE pid=%d ORDER BY id"%pid; data=dbto.exeall(sql) return data
def getAllGrowing(): '''获取所有宠物成长信息''' sql = "SELECT * FROM growing" data = dbto.exeall(sql) return data