def stats(param):
nom = param["nom"]
if nom != "None":
nom = sql.nom_ID(nom)
ID = sql.get_SuperID(nom, param["name_pl"])
else:
ID = sql.get_SuperID(param["ID"], param["name_pl"])
lang = param["lang"]
if ID == "Error 404":
msg = [
"WarningMsg",
lang_P.forge_msg(lang, "WarningMsg", None, False, 0)
]
return msg
PlayerID = sql.get_PlayerID(ID, "gems")
msg = []
desc = sql.valueAt(PlayerID, "all", "statgems")
if desc != 0:
msg.append("OK")
msg.append(lang)
for x in desc:
msg.append(str(x))
else:
msg.append("NOK")
msg.append(lang)
return msg
def admin(param):
fct = param["fct"]
arg2 = param["arg2"]
arg3 = param["arg3"]
arg4 = param["arg4"]
msg = []
if fct == "playerid":
if arg2 == "None":
platform = param["name_pl"]
else:
platform = arg2
else:
platform = param["name_pl"]
if param["name_pl"] == "Admin" and fct != "playerid":
PlayerID = int(param["ID"])
lang = "EN"
else:
ID = sql.get_SuperID(int(param["ID"]), platform)
lang = param["lang"]
if ID == "Error 404":
msg = [
"WarningMsg",
lang_P.forge_msg(lang, "WarningMsg", None, False, 0)
]
return msg
PlayerID = sql.get_PlayerID(ID, "gems")
if fct == "init":
sql.init()
elif fct == "update":
# arg2 = nameDB | arg3 = fieldName | arg4 = fieldValue
desc = sql.updateField(PlayerID, arg3, arg4, arg2)
elif fct == "add":
# arg2 = nameDB | arg3 = nameElem | arg4 = nbElem
desc = sql.add(PlayerID, arg3, arg4, arg2)
elif fct == "value":
# arg2 = nameDB | arg3 = nameElem
desc = sql.valueAt(PlayerID, arg3, arg2)
elif fct == "gems":
# arg2 = nb gems
desc = sql.addGems(PlayerID, arg2)
elif fct == "spinelles":
# arg2 = nb spinelles
desc = sql.addSpinelles(PlayerID, arg2)
elif fct == "balance total" or fct == 'balancetotal':
desc = "Balance total"
desc += "\n{}:gem:".format(sql.countTotalGems())
spinelleidmoji = "{idmoji[spinelle]}"
desc += "\n{0}<:spinelle:{1}>".format(sql.countTotalSpinelles(),
spinelleidmoji)
elif fct == "playerid":
desc = "PlayerID: {}".format(PlayerID)
else:
desc = ":regional_indicator_s::regional_indicator_q::regional_indicator_l:"
msg.append("Admin {}".format(fct))
msg.append(lang)
msg.append(str(desc))
return msg
def testInvTaille(ID):
"""Verifie si l'inventaire est plein """
inv = sql.valueAt(ID, "all", "inventory")
tailletot = 0
if inv != 0:
for c in objetOutil:
for x in inv:
if c.nom == str(x[1]):
if int(x[0]) > 0:
tailletot += c.poids * int(int(x[0]))
for c in objetItem:
for x in inv:
if c.nom == str(x[1]):
if int(x[0]) > 0:
tailletot += c.poids * int(int(x[0]))
if tailletot <= invMax:
return True
else:
return False
