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