def get_user_etc():
data = request.get_json()
DBdata = database.GetInputKeyTBLInfo('TBLetc', 'user_key',
data["user_key"])
res = list()
for i in range(len(DBdata)):
res.append({
"etc_key": DBdata[i][1],
"item_key": DBdata[i][2],
"name": DBdata[i][3],
"price": DBdata[i][4]
})
return json.dumps(res, ensure_ascii=False)
def character_skin_main():
data = request.get_json()
user_key = data["user_key"]
character_select_key = data["character_select_key"]
DBdata = database.GetInputKeyTBLInfo('SkinInfo', 'character_key',
character_select_key)
res = list()
for i in range(len(DBdata)):
res.append({
"skin_key": DBdata[i][1],
"name": DBdata[i][2],
"description": DBdata[i][3],
"term": DBdata[i][4]
})
return json.dumps(res, ensure_ascii=False)
def character_character_main():
data = request.get_json()
DBdata = database.GetInputKeyTBLInfo('TBLcharacter', 'user_key',
data["user_key"])
res = list()
for i in range(len(DBdata)):
res.append({
"character_key": DBdata[i][1],
"name": DBdata[i][2],
"nickname": DBdata[i][3],
"modeling": DBdata[i][4],
"skin": DBdata[i][5],
"skin_key": DBdata[i][6],
"exp": DBdata[i][7],
"rank": DBdata[i][8]
})
return json.dumps(res, ensure_ascii=False)
def get_user_wands():
data = request.get_json()
DBdata = database.GetInputKeyTBLInfo('TBLwand', 'user_key',
data["user_key"])
res = list()
for i in range(len(DBdata)):
res, append({
"wand_key": DBdata[i][1],
"name": DBdata[i][2],
"atk": DBdata[i][3],
"accurate": DBdata[i][4],
"speed": DBdata[i][5],
"resistance": DBdata[i][6],
"cooltime": DBdata[i][7],
"reinforce": DBdata[i][8],
"price": DBdata[i][9]
})
return json.dumps(res, ensure_ascii=False)
def character_pet_main():
data = request.get_json()
user_key = data["user_key"]
DBdata = database.GetInputKeyTBLInfo('TBLpet', 'user_key', user_key)
res = list()
for i in range(len(DBdata)):
res.append({
"pet_key": DBdata[i][1],
"name": DBdata[i][2],
"species": DBdata[i][3],
"rank": DBdata[i][4],
"hp": DBdata[i][5],
"skill1": DBdata[i][6],
"skill2": DBdata[i][7]
})
return json.dumps(res, ensure_ascii=False)
def get_user_family_selected():
data = request.get_json()
DBdata = database.GetInputKeyTBLInfo('TBLuser', 'user_key',
data["user_key"])
res = list()
for i in range(len(DBdata)):
res, append({
"id": DBdata[i][1],
"pw": DBdata[i][2],
"nickname": DBdata[i][3],
"rank": DBdata[i][4],
"story_key": DBdata[i][5],
"character_selected_key": DBdata[i][6],
"servant_key": DBdata[i][7],
"pet_key": DBdata[i][8],
"wand_key": DBdata[i][9],
"sprite_key1": DBdata[i][10],
"sprite_key2": DBdata[i][11],
"sprite_key3": DBdata[i][12],
"gold": DBdata[i][13],
"baron": DBdata[i][14]
})
return json.dumps(res, ensure_ascii=False)