def getMissionInfo(conn, missionID):
cur = conn.cursor()
import externalFunctions.nameAndDisplayName as name
missionData = {}
missionData['MissionStats'] = getMissionStats(cur, missionID, name, conn)
try:
if missionData['MissionStats']['isMission'] == 1:
missionData['NPCComponent'] = getMissionNPCComponent(cur, missionID)
missionData = missionNPCIDsFromComponent(cur, missionData)
try:
missionData['NPCAcceptName'] = name.info(conn, missionData['NPCAcceptID'])
except:
missionData['NPCAcceptName'] = None
try:
missionData['NPCOfferName'] = name.info(conn, missionData['NPCOfferID'])
except:
missionData['NPCOfferName'] = None
missionData['MissionTasks'] = missionTasksInfo(cur, missionID, name, conn, missionData)
missionData = fixReward(missionData)
except TypeError:
pass
return missionData
def packageNamesForItemDrops(data, conn):
# import json
# with open('output/packageLMIs/'+str(data['buyAndDrop']['LootMatrixIndexes'][lmi]['LootTableIndex'])+'.json') as f:
# packageLMIs = json.load(f)
import externalFunctions.nameAndDisplayName as name
import json
with open('work/config.json') as f:
config = json.load(f)
with open(config['path'] + '/search/packageList.json') as f:
packageData = json.load(f)
with open(config['path'] + '/search/activityList.json') as f:
activityData = json.load(f)
for lmi in data['buyAndDrop']['LootMatrixIndexes']:
data['buyAndDrop']['LootMatrixIndexes'][lmi]['PackageComponent'] = {}
data['buyAndDrop']['LootMatrixIndexes'][lmi]['ActivityComponent'] = []
packageLMIs = packageData['LootMatrixIndexes']
activityLMIs = activityData['list']
for lmi in data['buyAndDrop']['LootMatrixIndexes']:
#print(lmi)
if lmi in packageLMIs:
data['buyAndDrop']['LootMatrixIndexes'][lmi]['PackageComponent'][
lmi] = name.info(conn, packageData[str(lmi)])
#print(data['buyAndDrop']['LootMatrixIndexes'][lmi]['LootMatrixIndex'])
if lmi in activityLMIs:
data['buyAndDrop']['LootMatrixIndexes'][lmi][
'ActivityComponent'] = activityData['info'][str(lmi)]
def getInfo(conn, cdgID):
data = {}
data['cooldowngroupID'] = cdgID
data['skillIDs'] = {}
cur = conn.cursor()
cur.execute(
"SELECT skillID, imaginationcost, cooldowngroup, cooldown, imBonusUI, lifeBonusUI, armorBonusUI FROM SkillBehavior"
)
rows = cur.fetchall()
for row in rows:
if row[2] == cdgID:
data['skillIDs'][row[0]] = {
"imaginationCost": row[1],
"cooldownTime": row[3],
"imBonusUI": row[4],
"lifeBonusUI": row[5],
"armorBonusUI": row[6]
}
import externalFunctions.nameAndDisplayName as name
for skillID in data['skillIDs']:
arr = getItemIDsFromSkillID(conn, skillID)
data['skillIDs'][skillID]['items'] = {}
for item in arr:
data['skillIDs'][skillID]['items'][item] = {}
for itemID in data['skillIDs'][skillID]['items']:
#print(data['skillIDs'][skillID]['items'])
#print(itemID)
data['skillIDs'][skillID]['items'][itemID] = name.info(
conn, itemID)
#print(name.info(conn, itemID))
return data
def commendationCurrencyCostName(curr, data):
import externalFunctions.nameAndDisplayName as name
namesObj = name.info(curr,
data['itemComponent']['commendationCurrencyType'])
data['itemComponent']['commendationCurrencyName'] = namesObj["name"]
# data['itemComponent']['commendationCurrencyDisplayName'] = namesObj["displayName"]
data['itemComponent']['commendationCurrencyDisplayName'] = 'Faction Token'
return data
def getInfo(conn, lti):
lootTableIndex = {}
lootTableIndex['itemsList'] = []
cur = conn.cursor()
cur.execute("SELECT * FROM LootTable")
rows = cur.fetchall()
for row in rows:
if row[1] == lti:
##print(row[0])
lootTableIndex['itemsList'].append(row[0])
lootTableIndex = getComps(conn, lootTableIndex)
lootTableIndex = getRarity(conn, lootTableIndex)
lootTableIndex = countRarity(lootTableIndex)
lootTableIndex['byRarity'] = {
"1": [],
"2": [],
"3": [],
"4": [],
"5": []
}
#print(lootTableIndex)
import externalFunctions.nameAndDisplayName as name
for objectID in lootTableIndex['itemsList']:
try:
rarity = lootTableIndex['items'][objectID]['rarity']
except:
continue
pass
lootTableIndex['items'][objectID] = {}
#print(objectID)
nameObj = name.info(conn, objectID)
#nameObj['rarity'] = rarity
#print(nameObj)
lootTableIndex['byRarity'][str(rarity)].append(objectID)
if len(nameObj) != 0 and nameObj['displayName'] is not None:
lootTableIndex['items'][objectID]['name'] = nameObj['name']
lootTableIndex['items'][objectID]['displayName'] = nameObj['displayName']
lootTableIndex['items'][objectID]['rarity'] = rarity
elif len(nameObj) != 0:
lootTableIndex['items'][objectID]['name'] = nameObj['name']
lootTableIndex['items'][objectID]['displayName'] = nameObj['name']
lootTableIndex['items'][objectID]['rarity'] = rarity
# if len(nameObj) != 0 and nameObj['type'] == "Powerup":
# lootTableIndex['items'][objectID]['name'] = nameObj['name']
# lootTableIndex['items'][objectID]['displayName'] = nameObj['name']
return lootTableIndex
def altCurrencyCostName(curr, data):
import externalFunctions.nameAndDisplayName as name
namesObj = name.info(curr, data['itemComponent']['altCurrencyType'])
data['itemComponent']['altCurrencyName'] = namesObj["name"]
data['itemComponent']['altCurrencyDisplayName'] = namesObj["displayName"]
return data