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
