FUSI0N

Na classe Playerstatus negocio assim voce pode implmentar essa logica !

tem como fazer uma skill para aprecer em cima do player uma logo? soq ue ela teria que ficar ativada em cima do nome

Vou acrecentar ao meu deixo aqui a Diff Subject: [PATCH] Sistema de Buff Time Setting --- Index: aCis_gameserver/config/players.properties IDEA additional info: Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP <+>ISO-8859-1 =================================================================== diff --git a/aCis_gameserver/config/players.properties b/aCis_gameserver/config/players.properties --- a/aCis_gameserver/config/players.properties (revision 85067945c8ce8e3bc2054b479387f891b43d42a2) +++ b/aCis_gameserver/config/players.properties (revision 686e419de54c0879854c677d060a7ed323544a7c) @@ -257,4 +257,19 @@ MaxBuffsAmount = 20 # Store buffs/debuffs on user logout. Default: True -StoreSkillCooltime = True \ No newline at end of file +StoreSkillCooltime = True + +# Buff Time Setting +# Usage format: skill_id, time; skill_id, time; .... +EnableModifySkillDuration = True +SkillDurationList = 1085,7200;1062,7200;1243,7200;1045,7200;1048,7200;\ +1078,7200;1043,7200;1242,7200;1059,7200;1077,7200;1240,7200;1086,7200;\ +1036,7200;1035,7200;1068,7200;1044,7200;1040,7200;1303,7200;1204,7200;\ +1238,7200;364,7200;264,7200;268,7200;349,7200;265,7200;363,7200;305,7200;\ +304,7200;267,7200;266,7200;269,7200;271,7200;276,7200;274,7200;275,7200;\ +272,7200;277,7200;273,7200;310,7200;365,7200;4700,7200;4699,7200;4703,7200;\ +4702,7200;1352,7200;1353,7200;1354,7200;1259,7200;1355,7200;1356,7200;\ +1363,7200;1357,7200;1323,7200;1268,7200;311,7200;309,7200;307,7200;1388,7200;\ +1389,7200;1397,7200;1087,7200;1413,7200;1304,7200;1257,7200;1362,7200;1392,7200;\ +1393,7200;1391,7200;1189,7200;1182,7200;270,7200;308,7200;306,7200;1191,7200;\ +1416,7200;1390,7200;1391,7200 \ No newline at end of file Index: aCis_gameserver/java/net/sf/l2j/Config.java IDEA additional info: Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP <+>UTF-8 =================================================================== diff --git a/aCis_gameserver/java/net/sf/l2j/Config.java b/aCis_gameserver/java/net/sf/l2j/Config.java --- a/aCis_gameserver/java/net/sf/l2j/Config.java (revision 85067945c8ce8e3bc2054b479387f891b43d42a2) +++ b/aCis_gameserver/java/net/sf/l2j/Config.java (revision 686e419de54c0879854c677d060a7ed323544a7c) @@ -43,7 +43,10 @@ private static final String PROTECT_FILE = "./config/l2jz/protect.properties"; public static final String DONATEMODS = "./config/l2jz/vip.properties"; - public static final String AUTOFARM_FILE = "./config/autofarm.properties"; + public static final String AUTOFARM_FILE = "./config/l2jz/autofarm.properties"; + + public static boolean ENABLE_MODIFY_SKILL_DURATION; + public static HashMap<Integer, Integer> SKILL_DURATION_LIST; /** Auto Farm */ public static boolean AUTOFARM_ENABLED; @@ -947,6 +950,28 @@ MAX_BUFFS_AMOUNT = players.getProperty("MaxBuffsAmount", 20); STORE_SKILL_COOLTIME = players.getProperty("StoreSkillCooltime", true); + + ENABLE_MODIFY_SKILL_DURATION = players.getProperty("EnableModifySkillDuration", false); + if (ENABLE_MODIFY_SKILL_DURATION) { + SKILL_DURATION_LIST = new HashMap<>(); + String[] propertySplit = players.getProperty("SkillDurationList", "").split(";"); + + for (String skill : propertySplit) { + String[] skillSplit = skill.split(","); + if (skillSplit.length != 2) + LOGGER.warn("[SkillDurationList]: invalid config property -> SkillDurationList \"" + skill + "\""); + else { + try { + SKILL_DURATION_LIST.put(Integer.parseInt(skillSplit[0]), Integer.parseInt(skillSplit[1])); + } catch (NumberFormatException nfe) { + nfe.printStackTrace(); + + if (!skill.equals("")) + LOGGER.warn("[SkillDurationList]: invalid config property -> SkillList \"" + skillSplit[0] + "\"" + skillSplit[1]); + } + } + } + } } /** Index: aCis_gameserver/java/net/sf/l2j/gameserver/data/DocumentBase.java IDEA additional info: Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP <+>UTF-8 =================================================================== diff --git a/aCis_gameserver/java/net/sf/l2j/gameserver/data/DocumentBase.java b/aCis_gameserver/java/net/sf/l2j/gameserver/data/DocumentBase.java --- a/aCis_gameserver/java/net/sf/l2j/gameserver/data/DocumentBase.java (revision 85067945c8ce8e3bc2054b479387f891b43d42a2) +++ b/aCis_gameserver/java/net/sf/l2j/gameserver/data/DocumentBase.java (revision 686e419de54c0879854c677d060a7ed323544a7c) @@ -11,6 +11,7 @@ import javax.xml.XMLConstants; import javax.xml.parsers.DocumentBuilderFactory; +import net.sf.l2j.Config; import net.sf.l2j.commons.data.StatSet; import net.sf.l2j.commons.logging.CLogger; @@ -209,9 +210,23 @@ if (attrs.getNamedItem("count") != null) count = Integer.decode(getValue(attrs.getNamedItem("count").getNodeValue(), template)); - + if (attrs.getNamedItem("time") != null) + { time = Integer.decode(getValue(attrs.getNamedItem("time").getNodeValue(), template)); + if (Config.ENABLE_MODIFY_SKILL_DURATION) + { + if (Config.SKILL_DURATION_LIST.containsKey(((L2Skill) template).getId())) + { + if (((L2Skill) template).getLevel() < 100) + time = Config.SKILL_DURATION_LIST.get(((L2Skill) template).getId()); + else if ((((L2Skill) template).getLevel() >= 100) && (((L2Skill) template).getLevel() < 140)) + time += Config.SKILL_DURATION_LIST.get(((L2Skill) template).getId()); + else if (((L2Skill) template).getLevel() > 140) + time = Config.SKILL_DURATION_LIST.get(((L2Skill) template).getId()); + } + } + } boolean self = false; if (attrs.getNamedItem("self") != null && Integer.decode(getValue(attrs.getNamedItem("self").getNodeValue(), template)) == 1)

que bom mano fico feliz

me manda o seu discord

me manda seu discord para que eu possa te manda o arquivo completo para voce examinar corretamente

from apps.lineage.server.database import LineageDB from apps.lineage.server.utils.cache import cache_lineage_result import time import base64 import hashlib class LineageStats: @staticmethod def _run_query(sql, params=None, use_cache=True): return LineageDB().select(sql, params=params, use_cache=use_cache) @staticmethod @cache_lineage_result(timeout=300) def get_crests(ids, type='clan'): # Verifique se os IDs foram fornecidos if not ids: return [] # Defina a tabela e a coluna do emblema com base no tipo (clan ou ally) if type == 'ally': table = 'ally_data' id_column = 'ally_id' crest_column = 'crest' # Mantido, aguardando ally_data.sql else: table = 'clan_data' id_column = 'clan_id' crest_column = 'crest_id' # Alterado de 'crest' para 'crest_id' # Construção da consulta SQL para obter as crests dos clãs ou alianças sql = f""" SELECT {id_column}, {crest_column} FROM {table} WHERE {id_column} IN :ids """ # Chama a função _run_query para executar a consulta return LineageStats._run_query(sql, {"ids": tuple(ids)}) @staticmethod @cache_lineage_result(timeout=300) def players_online(): sql = "SELECT COUNT(*) AS quant FROM characters WHERE online > 0 AND accesslevel = '0'" return LineageStats._run_query(sql) @staticmethod @cache_lineage_result(timeout=300) def top_pvp(limit=10): sql = """ SELECT C.char_name, C.pvpkills, C.pkkills, C.online, C.onlinetime, D.name AS clan_name, C.clanid AS clan_id, CD.ally_id AS ally_id FROM characters C LEFT JOIN clan_subpledges D ON D.clan_id = C.clanid AND D.sub_pledge_id = 0 LEFT JOIN clan_data CD ON CD.clan_id = C.clanid WHERE C.accesslevel = '0' ORDER BY pvpkills DESC, pkkills DESC, onlinetime DESC, char_name ASC LIMIT :limit """ return LineageStats._run_query(sql, {"limit": limit}) @staticmethod @cache_lineage_result(timeout=300) def top_pk(limit=10): sql = """ SELECT C.char_name, C.pvpkills, C.pkkills, C.online, C.onlinetime, D.name AS clan_name, C.clanid AS clan_id, CD.ally_id AS ally_id FROM characters C LEFT JOIN clan_subpledges D ON D.clan_id = C.clanid AND D.sub_pledge_id = 0 LEFT JOIN clan_data CD ON CD.clan_id = C.clanid WHERE C.accesslevel = '0' ORDER BY pkkills DESC, pvpkills DESC, onlinetime DESC, char_name ASC LIMIT :limit """ return LineageStats._run_query(sql, {"limit": limit}) @staticmethod @cache_lineage_result(timeout=300) def top_online(limit=10): sql = """ SELECT C.char_name, C.pvpkills, C.pkkills, C.online, C.onlinetime, D.name AS clan_name, C.clanid AS clan_id, CD.ally_id AS ally_id FROM characters C LEFT JOIN clan_subpledges D ON D.clan_id = C.clanid AND D.sub_pledge_id = 0 LEFT JOIN clan_data CD ON CD.clan_id = C.clanid WHERE C.accesslevel = '0' ORDER BY onlinetime DESC, pvpkills DESC, pkkills DESC, char_name ASC LIMIT :limit """ return LineageStats._run_query(sql, {"limit": limit}) @staticmethod @cache_lineage_result(timeout=300) def top_level(limit=10): sql = """ SELECT C.char_name, C.pvpkills, C.pkkills, C.online, C.onlinetime, CS.level, D.name AS clan_name, C.clanid AS clan_id, CD.ally_id AS ally_id FROM characters C LEFT JOIN character_subclasses CS ON CS.char_obj_id = C.obj_Id AND CS.isBase = '1' LEFT JOIN clan_subpledges D ON D.clan_id = C.clanid AND D.sub_pledge_id = 0 LEFT JOIN clan_data CD ON CD.clan_id = C.clanid WHERE C.accesslevel = '0' ORDER BY level DESC, exp DESC, onlinetime DESC, char_name ASC LIMIT :limit """ return LineageStats._run_query(sql, {"limit": limit}) @staticmethod @cache_lineage_result(timeout=300) def top_adena(limit=10, adn_billion_item=0, value_item=1000000): item_bonus_sql = "" if adn_billion_item != 0: item_bonus_sql = f""" IFNULL((SELECT SUM(I2.amount) * :value_item FROM items I2 WHERE I2.owner_id = C.obj_Id AND I2.item_type = :adn_billion_item GROUP BY I2.owner_id), 0) + """ sql = f""" SELECT C.char_name, C.online, C.onlinetime, CS.level, D.name AS clan_name, C.clanid AS clan_id, CD.ally_id AS ally_id, ( {item_bonus_sql} IFNULL((SELECT SUM(I1.amount) FROM items I1 WHERE I1.owner_id = C.obj_Id AND I1.item_type = '57' GROUP BY I1.owner_id), 0) ) AS adenas FROM characters C LEFT JOIN character_subclasses CS ON CS.char_obj_id = C.obj_Id AND CS.isBase = '1' LEFT JOIN clan_subpledges D ON D.clan_id = C.clanid AND D.sub_pledge_id = 0 LEFT JOIN clan_data CD ON CD.clan_id = C.clanid WHERE C.accesslevel = '0' ORDER BY adenas DESC, onlinetime DESC, char_name ASC LIMIT :limit """ return LineageStats._run_query(sql, { "limit": limit, "adn_billion_item": adn_billion_item, "value_item": value_item }) @staticmethod @cache_lineage_result(timeout=300) def top_clans(limit=10): sql = """ SELECT C.clan_id, D.name AS clan_name, C.clan_level, C.reputation_score, A.ally_name, A.ally_id, P.char_name, (SELECT COUNT(*) FROM characters WHERE clanid = C.clan_id) AS membros FROM clan_data C LEFT JOIN clan_subpledges D ON D.clan_id = C.clan_id AND D.sub_pledge_id = 0 LEFT JOIN ally_data A ON A.ally_id = C.ally_id LEFT JOIN characters P ON P.obj_Id = D.leader_id ORDER BY C.clan_level DESC, C.reputation_score DESC, membros DESC LIMIT :limit """ return LineageStats._run_query(sql, {"limit": limit}) @staticmethod @cache_lineage_result(timeout=300) def olympiad_ranking(): sql = """ SELECT C.char_name, C.online, D.name AS clan_name, C.clanid AS clan_id, CD.ally_id AS ally_id, CS.class_id AS base, O.points_current AS olympiad_points FROM oly_nobles O LEFT JOIN characters C ON C.obj_Id = O.char_id LEFT JOIN character_subclasses CS ON CS.char_obj_id = C.obj_Id AND CS.isBase = '1' LEFT JOIN clan_subpledges D ON D.clan_id = C.clanid AND D.sub_pledge_id = 0 LEFT JOIN clan_data CD ON CD.clan_id = C.clanid ORDER BY olympiad_points DESC, base ASC, char_name ASC """ return LineageStats._run_query(sql) @staticmethod @cache_lineage_result(timeout=300) def olympiad_all_heroes(): sql = """ SELECT C.char_name, C.online, D.name AS clan_name, C.clanid AS clan_id, CLAN.ally_id AS ally_id, CS.class_id AS base, H.count FROM oly_heroes H LEFT JOIN characters C ON C.obj_Id = H.char_id LEFT JOIN character_subclasses CS ON CS.char_obj_id = C.obj_Id AND CS.isBase = '1' LEFT JOIN clan_subpledges D ON D.clan_id = C.clanid AND D.sub_pledge_id = 0 LEFT JOIN clan_data CLAN ON CLAN.clan_id = C.clanid WHERE H.played > 0 AND H.count > 0 ORDER BY H.count DESC, base ASC, char_name ASC """ return LineageStats._run_query(sql) @staticmethod @cache_lineage_result(timeout=300) def olympiad_current_heroes(): sql = """ SELECT C.char_name, C.online, D.name AS clan_name, C.clanid AS clan_id, CLAN.ally_id AS ally_id, CS.class_id AS base FROM oly_heroes H LEFT JOIN characters C ON C.obj_Id = H.char_id LEFT JOIN character_subclasses CS ON CS.char_obj_id = C.obj_Id AND CS.isBase = '1' LEFT JOIN clan_subpledges D ON D.clan_id = C.clanid AND D.sub_pledge_id = 0 LEFT JOIN clan_data CLAN ON CLAN.clan_id = C.clanid WHERE H.played > 0 AND H.count > 0 ORDER BY base ASC """ return LineageStats._run_query(sql) @staticmethod @cache_lineage_result(timeout=300) def grandboss_status(): sql = """ SELECT bossId AS boss_id, respawnDate AS respawn FROM epic_boss_spawn ORDER BY respawnDate DESC """ return LineageStats._run_query(sql) @staticmethod @cache_lineage_result(timeout=300) def siege(): sql = """ SELECT W.id, W.name, W.siege_date AS sdate, W.treasury AS stax, P.char_name, CS.name AS clan_name, C.clan_id, C.ally_id, A.ally_name FROM castle W LEFT JOIN clan_data C ON C.hasCastle = W.id LEFT JOIN clan_subpledges CS ON CS.clan_id = C.clan_id AND CS.sub_pledge_id = 0 LEFT JOIN ally_data A ON A.ally_id = C.ally_id LEFT JOIN characters P ON P.obj_Id = CS.leader_id """ return LineageStats._run_query(sql) @staticmethod @cache_lineage_result(timeout=300) def siege_participants(castle_id): sql = """ SELECT S.type, C.name AS clan_name, C.clan_id FROM siege_clans S LEFT JOIN clan_subpledges C ON C.clan_id = S.clan_id AND C.sub_pledge_id = 0 WHERE S.residence_id = :castle_id """ return LineageStats._run_query(sql, {"castle_id": castle_id}) @staticmethod @cache_lineage_result(timeout=300) def boss_jewel_locations(boss_jewel_ids): # Gera bind dinâmico para IN bind_ids = [f":id{i}" for i in range(len(boss_jewel_ids))] placeholders = ", ".join(bind_ids) sql = f""" SELECT I.owner_id, I.item_type AS item_id, SUM(I.amount) AS count, C.char_name, P.name AS clan_name, C.clanid AS clan_id, CD.ally_id FROM items I INNER JOIN characters C ON C.obj_Id = I.owner_id LEFT JOIN clan_subpledges P ON P.clan_id = C.clanid AND P.sub_pledge_id = 0 LEFT JOIN clan_data CD ON CD.clan_id = C.clanid WHERE I.item_type IN ({placeholders}) GROUP BY I.owner_id, C.char_name, P.name, I.item_type, C.clanid, CD.ally_id ORDER BY count DESC, C.char_name ASC """ params = {f"id{i}": item_id for i, item_id in enumerate(boss_jewel_ids)} return LineageStats._run_query(sql, params) class LineageServices: @staticmethod @cache_lineage_result(timeout=300) def find_chars(login): sql = """ SELECT C.*, -- Base class e level (SELECT S0.class_id FROM character_subclasses AS S0 WHERE S0.char_obj_id = C.obj_Id AND S0.isBase = '1' LIMIT 1) AS base_class, (SELECT S0.level FROM character_subclasses AS S0 WHERE S0.char_obj_id = C.obj_Id AND S0.isBase = '1' LIMIT 1) AS base_level, -- Subclass 1 (SELECT S1.class_id FROM character_subclasses AS S1 WHERE S1.char_obj_id = C.obj_Id AND S1.isBase = '0' LIMIT 0,1) AS subclass1, (SELECT S1.level FROM character_subclasses AS S1 WHERE S1.char_obj_id = C.obj_Id AND S1.isBase = '0' LIMIT 0,1) AS subclass1_level, -- Subclass 2 (SELECT S2.class_id FROM character_subclasses AS S2 WHERE S2.char_obj_id = C.obj_Id AND S2.isBase = '0' LIMIT 1,1) AS subclass2, (SELECT S2.level FROM character_subclasses AS S2 WHERE S2.char_obj_id = C.obj_Id AND S2.isBase = '0' LIMIT 1,1) AS subclass2_level, -- Subclass 3 (SELECT S3.class_id FROM character_subclasses AS S3 WHERE S3.char_obj_id = C.obj_Id AND S3.isBase = '0' LIMIT 2,1) AS subclass3, (SELECT S3.level FROM character_subclasses AS S3 WHERE S3.char_obj_id = C.obj_Id AND S3.isBase = '0' LIMIT 2,1) AS subclass3_level, -- Clan e Ally CS.name AS clan_name, A.ally_name FROM characters AS C LEFT JOIN clan_data AS CLAN ON CLAN.clan_id = C.clanid LEFT JOIN clan_subpledges AS CS ON CS.clan_id = CLAN.clan_id AND CS.sub_pledge_id = 0 -- Adicionado CS.sub_pledge_id = 0 LEFT JOIN ally_data AS A ON A.ally_id = CLAN.ally_id WHERE C.account_name = :login LIMIT 7 """ try: return LineageDB().select(sql, {"login": login}) except: return None @staticmethod @cache_lineage_result(timeout=300) def check_char(acc, cid): sql = "SELECT * FROM characters WHERE obj_id = :cid AND account_name = :acc LIMIT 1" try: return LineageDB().select(sql, {"acc": acc, "cid": cid}) except: return None @staticmethod @cache_lineage_result(timeout=300) def check_name_exists(name): sql = "SELECT * FROM characters WHERE char_name = :name LIMIT 1" try: return LineageDB().select(sql, {"name": name}) except: return None @staticmethod @cache_lineage_result(timeout=300) def change_nickname(acc, cid, name): try: sql = """ UPDATE characters SET char_name = :name WHERE obj_id = :cid AND account_name = :acc LIMIT 1 """ return LineageDB().update(sql, {"name": name, "cid": cid, "acc": acc}) except Exception as e: print(f"Erro ao trocar nickname: {e}") return None @staticmethod @cache_lineage_result(timeout=300) def change_sex(acc, cid, sex): try: sql = """ UPDATE characters SET sex = :sex WHERE obj_Id = :cid AND account_name = :acc LIMIT 1 """ return LineageDB().update(sql, {"sex": sex, "cid": cid, "acc": acc}) except Exception as e: print(f"Erro ao trocar s***: {e}") return None @staticmethod @cache_lineage_result(timeout=300) def unstuck(acc, cid, x, y, z): try: sql = """ UPDATE characters SET x = :x, y = :y, z = :z WHERE obj_id = :cid AND account_name = :acc LIMIT 1 """ return LineageDB().update(sql, {"x": x, "y": y, "z": z, "cid": cid, "acc": acc}) except Exception as e: print(f"Erro ao desbugar personagem: {e}") return None class LineageAccount: _checked_columns = False @staticmethod @cache_lineage_result(timeout=300) def ensure_columns(): if LineageAccount._checked_columns: return lineage_db = LineageDB() columns = lineage_db.get_table_columns("accounts") try: if "email" not in columns: sql = """ ALTER TABLE accounts ADD COLUMN email VARCHAR(100) NOT NULL DEFAULT ''; """ lineage_db.execute_raw(sql) print(" Coluna 'email' adicionada com sucesso.") if "created_time" not in columns: sql = """ ALTER TABLE accounts ADD COLUMN created_time INT(11) NULL DEFAULT NULL; """ lineage_db.execute_raw(sql) print(" Coluna 'created_time' adicionada com sucesso.") LineageAccount._checked_columns = True except Exception as e: print(f" Erro ao alterar tabela 'accounts': {e}") @staticmethod @cache_lineage_result(timeout=300, use_cache=False) def check_login_exists(login): sql = "SELECT * FROM accounts WHERE login = :login LIMIT 1" return LineageDB().select(sql, {"login": login}) @staticmethod @cache_lineage_result(timeout=300) def check_email_exists(email): sql = "SELECT login, email FROM accounts WHERE email = :email" return LineageDB().select(sql, {"email": email}) @staticmethod @cache_lineage_result(timeout=300) def register(login, password, access_level, email): try: LineageAccount.ensure_columns() hashed = base64.b64encode(hashlib.sha1(password.encode()).digest()).decode() sql = """ INSERT INTO accounts (login, password, accessLevel, email, created_time) VALUES (:login, :password, :access_level, :email, :created_time) """ params = { "login": login, "password": hashed, "access_level": access_level, "email": email, "created_time": int(time.time()) } LineageDB().insert(sql, params) return True except Exception as e: print(f"Erro ao registrar conta: {e}") return None @staticmethod @cache_lineage_result(timeout=300) def update_password(password, login): try: hashed = base64.b64encode(hashlib.sha1(password.encode()).digest()).decode() sql = """ UPDATE accounts SET password = :password WHERE login = :login LIMIT 1 """ params = { "password": hashed, "login": login } LineageDB().update(sql, params) return True except Exception as e: print(f"Erro ao atualizar senha: {e}") return None @staticmethod @cache_lineage_result(timeout=300) def update_password_group(password, logins_list): if not logins_list: return None try: hashed = base64.b64encode(hashlib.sha1(password.encode()).digest()).decode() sql = "UPDATE accounts SET password = :password WHERE login IN :logins" params = { "password": hashed, "logins": logins_list } LineageDB().update(sql, params) return True except Exception as e: print(f"Erro ao atualizar senhas em grupo: {e}") return None @staticmethod @cache_lineage_result(timeout=300) def update_access_level(access, login): try: sql = """ UPDATE accounts SET accessLevel = :access WHERE login = :login LIMIT 1 """ params = { "access": access, "login": login } return LineageDB().update(sql, params) except Exception as e: print(f"Erro ao atualizar accessLevel: {e}") return None class TransferFromWalletToChar: @staticmethod @cache_lineage_result(timeout=300, use_cache=False) def find_char(account: str, char_name: str): query = """ SELECT * FROM characters WHERE account_name = :account AND char_name = :char_name LIMIT 1 """ try: return LineageDB().select(query, {"account": account, "char_name": char_name}) except: return None @staticmethod @cache_lineage_result(timeout=300, use_cache=False) def search_coin(char_name: str, coin_id: int): query = """ SELECT i.* FROM items i JOIN characters c ON i.owner_id = c.obj_Id WHERE c.char_name = :char_name AND i.item_id = :coin_id """ return LineageDB().select(query, {"char_name": char_name, "coin_id": coin_id}) @staticmethod @cache_lineage_result(timeout=300, use_cache=False) def insert_coin(char_name: str, coin_id: int, amount: int, enchant: int = 0): db = LineageDB() # Buscar owner_id do personagem char_query = "SELECT obj_Id FROM characters WHERE char_name = :char_name" char_result = db.select(char_query, {"char_name": char_name}) if not char_result: return None owner_id = char_result[0]["obj_Id"] # Inserir na tabela `items_delayed` como na lógica do PHP insert_query = """ INSERT INTO items_delayed ( payment_id, owner_id, item_id, count, enchant_level, variationId1, variationId2, flags, payment_status, description ) SELECT COALESCE(MAX(payment_id), 0) + 1, :owner_id, :coin_id, :amount, :enchant, 0, 0, 0, 0, 'DONATE WEB' FROM items_delayed """ result = db.insert(insert_query, { "owner_id": owner_id, "coin_id": coin_id, "amount": amount, "enchant": enchant }) return result is not None class TransferFromCharToWallet: @staticmethod @cache_lineage_result(timeout=300, use_cache=False) def find_char(account, char_id): query = """ SELECT online, char_name FROM characters WHERE account_name = :account AND obj_Id = :char_id """ params = {"account": account, "char_id": char_id} return LineageDB().select(query, params) @staticmethod @cache_lineage_result(timeout=300, use_cache=False) def list_items(char_id): query = """ SELECT item_id, item_type, amount, location, enchant FROM items WHERE owner_id = :char_id AND location IN ('INVENTORY', 'WAREHOUSE') ORDER BY location, item_type """ params = {"char_id": char_id} results = LineageDB().select(query, params) return results @staticmethod @cache_lineage_result(timeout=300, use_cache=False) def check_ingame_coin(coin_id, char_id): db = LineageDB() # Buscar no INVENTORY query_inve = """ SELECT amount, enchant FROM items WHERE owner_id = :char_id AND item_type = :coin_id AND location = 'INVENTORY' LIMIT 1 """ result_inve = db.select(query_inve, {"char_id": char_id, "coin_id": coin_id}) inINVE = result_inve[0]["amount"] if result_inve else 0 enchant = result_inve[0]["enchant"] if result_inve else 0 # Buscar no WAREHOUSE query_ware = """ SELECT amount FROM items WHERE owner_id = :char_id AND item_type = :coin_id AND location = 'WAREHOUSE' LIMIT 1 """ result_ware = db.select(query_ware, {"char_id": char_id, "coin_id": coin_id}) inWARE = result_ware[0]["amount"] if result_ware else 0 total = inINVE + inWARE return {"total": total, "inventory": inINVE, "warehouse": inWARE, "enchant": enchant} @staticmethod @cache_lineage_result(timeout=300, use_cache=False) def remove_ingame_coin(coin_id, count, char_id): try: db = LineageDB() # Função auxiliar para deletar itens não stackables def delete_non_stackable(items, amount_to_remove): removed = 0 for item in items: if removed >= amount_to_remove: break db.update("DELETE FROM items WHERE item_id = :item_id", {"item_id": item["item_id"]}) removed += 1 return removed # INVENTORY query_inve = """ SELECT * FROM items WHERE owner_id = :char_id AND item_type = :item_type AND location = 'INVENTORY' """ items_inve = db.select(query_inve, {"char_id": char_id, "item_type": coin_id}) # WAREHOUSE query_ware = """ SELECT * FROM items WHERE owner_id = :char_id AND item_type = :item_type AND location = 'WAREHOUSE' """ items_ware = db.select(query_ware, {"char_id": char_id, "item_type": coin_id}) total_amount = sum(item["amount"] for item in items_inve + items_ware) if total_amount < count: return False # Não tem quantidade suficiente # Identifica se é stackable ou não is_stackable = len(items_inve + items_ware) == 1 and (items_inve + items_ware)[0]["amount"] > 1 if is_stackable: # Remove do INVENTORY primeiro if items_inve: item = items_inve[0] if item["amount"] <= count: db.update("DELETE FROM items WHERE item_id = :item_id", {"item_id": item["item_id"]}) count -= item["amount"] else: db.update( "UPDATE items SET amount = amount - :count WHERE item_id = :item_id", {"count": count, "item_id": item["item_id"]} ) count = 0 # Se ainda faltar, remove do WAREHOUSE if count > 0 and items_ware: item = items_ware[0] if item["amount"] <= count: db.update("DELETE FROM items WHERE item_id = :item_id", {"item_id": item["item_id"]}) else: db.update( "UPDATE items SET amount = amount - :count WHERE item_id = :item_id", {"count": count, "item_id": item["item_id"]} ) else: # Não stackável – remover 1 a 1, primeiro INVENTORY depois WAREHOUSE removed = delete_non_stackable(items_inve, count) if removed < count: delete_non_stackable(items_ware, count - removed) return True except Exception as e: print(f"Erro ao remover coin do inventário/warehouse: {e}") return False tentei fazer para Acis 382 nao consigo testa por que to sem um servidor aqui , se alguem poder testar

Sites descontinuado onde trabalham com php5.4 podendo conter erros ,recomendo voces começar a usar o PDL que te aqui free e painel evan pires, esses sites da atual sao sites descontinuado sem atuaização saiam do padrao mudem um pouco ....

entendi fico no aguardo ,caso alguem consiga te ajuda eu mesmo nem entendo muito

Uma dúvida na config .env tem a opção onde está l2dreamv2 pode mudar pra qual versão?

Estao me procurando tambe pra resolver erros ...

maioria das Hospedagem tem que abrir um ticket reportando esse erro para que eles liberem a conexao!

pelo que eu entendi voce quer a source que alguem ja pegou ne ,caso consiga me interesso tambem por favor!

voce acertou e o mais um obrigado deu tudo certo agradeço a ajuda !

Erro ao entra em contato com outro player ou ate mesmo chegar perto de players tomo critical ,se os player ficarem longe ao ponto de nao aparecer blz se chegar perto ao ponto de aparecer toma critico os dois que tiver perto um do outro !!!! caso nao de o critico fica desta forma!