drakoo
-
Posts
54 -
Credits
0 -
Joined
-
Last visited
Never -
Feedback
0%
Content Type
Articles
Profiles
Forums
Store
Posts posted by drakoo
-
-
-
85099 already deleted the line ...
After he asks for 85098 ... 85097 ... 85096 ... until arriving at line 1
And the error continues.
-
Greetings friends MXC
I come to you to bring a new problem.
My server made automatic restart, but after the restart it does not get online.
I get the following error in Game Server.
BitSet ID Factory could not be initialized correctly
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu
mn 'object_id' at row 85099
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3489)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStat
ement.java:64)
at net.sf.l2j.gameserver.idfactory.IdFactory.extractUsedObjectIDTable(Id
Factory.java:198)
at net.sf.l2j.gameserver.idfactory.BitSetIDFactory.initialize(BitSetIDFa
ctory.java:76)
at net.sf.l2j.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFactor
y.java:65)
at net.sf.l2j.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:68)
at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:180)
at net.sf.l2j.gameserver.GameServer.main(GameServer.java:563)
IDFactory: 102912 id's available.
=====================================================================-[ World ]
L2World: Setting up World Regions
L2World: (87 by 128) World Region Grid set up.
Initializing Script Engine Manager
Script Engine: jython 2.2.1 - Language: python - Language Version: 2.2.1
Script Engine: Mozilla Rhino 1.6 release 2 - Language: ECMAScript - Language Ver
sion: 1.6
Script Engine: java 1.6 - Language: java - Language Version: 1.6
Script Engine: BeanShell Engine 1.1 - Language: BeanShell - Language Version: 2.
0b5
================================================================-[ ID Factory ]
Could not read object IDs from DB. Please Check Your Data.
Exception in thread "main" java.lang.Exception: Could not initialize the ID fact
ory
at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:195)
at net.sf.l2j.gameserver.GameServer.main(GameServer.java:563)
-
Bug fixed for my.
Closed topic.
-
Tested in:
L2JSERVER, L2JFREE AND L2JTEON!
-
Hello everybody!
I inform my the new "Bug Target ".
I need the fix urgently;
As the bug is done?
VERY EASY!
In the Character Selection screen, PRESS ENTER FOR START AND Click on RE-LOGIN THE SAME TIME!
ENTER NOW LOGIN AND PASSWORD AND START.
Ready target buggy!
I need a QUICK FIX please.
Thank you.
INTERLUDE
Excuse-me my bad english
-
report: extreme, fix multisell icon black dont work :)
-
-
i go work to interlude
-
I want to make a voiced command for this feature, so you can use the button or the voice command. Anyone can help me do that?
x2
-
html was too long =/
-
version? Working interlude? :)
-
-
-
-
nice man! very thx
-
-
-
And the number of sets to enchant? 25 +10 +?
The query would need to update.
But still I do not have this knowledge in SQL.
-
Greetings folks.
I come here asking for something that I could not create with my basic knowledge in SQL.
Let me explain my case before.
Currently I have my server in the Set Vesper that everyone already knows.
(Interlude Version).
But I do not want it more like the "Top Set" from the server.
I want to change the Set Top Grad S Vesper for the retail Interlude (Draconic, Major and Imperial).
With my basic knowledge in sql I could do
I created a query, replacing for example:
Replace all Vesper Gloves Heavy for Imperial Heavy Gloves
Managed successfully.
So I came here two errors.
Error Number 01: The Set Vesper has only one Helmo
This Helmo is the same as in Set: Heavy / Light / Robe.
But the Draconic has a Helmo.
The Imperial has one another.
And Major is another.
Here comes my problem:
How to distinguish the query if the Player Helmo Vesper is using is: Set a Vesper Heavy / Vesper Robe / Heavy?.
Now Doubts Number 02: How to change the query SET BREAST From Epic (For he is pants and chest in just one part) in breast and pants Dynasty (which are two separate parts?)
Well I look forward to your help on this problem.
Thanks.
Excuse-me for my bad english
-
Gma99 aqui é o Drako usuario banido injustamente pelo ADMIN do seu forum SW
Vou te ajudar ...
Para mostrar que sou melhor doque gente duente que se acha o fodao*
No coments.
Segue abaixo o mod que voce necessita.
BR Mod Off:
English on:
Here's the mod that you need.
Index: data/scripts/handlers/chathandlers/ChatTell.java =================================================================== --- data/scripts/handlers/chathandlers/ChatTell.java (revision 5944) +++ data/scripts/handlers/chathandlers/ChatTell.java (working copy) @@ -76,6 +76,11 @@ activeChar.sendMessage("Player is chat banned."); return; } + if (receiver.getClient().isDetached()) + { + activeChar.sendMessage("Player is in offline mode."); + return; + } if (!receiver.getMessageRefusal()) { Index: java/config/l2jmods.properties =================================================================== --- java/config/l2jmods.properties (revision 2917) +++ java/config/l2jmods.properties (working copy) @@ -197,6 +197,24 @@ # --------------------------------------------------------------------------- +# Offline trade/craft +# --------------------------------------------------------------------------- +# Option to enable or disable offline trade feature. +# Enable -> true, Disable -> false +OfflineTradeEnable = False + +# Option to enable or disable offline craft feature. +# Enable -> true, Disable -> false +OfflineCraftEnable = False + +# If set to True, name color will be changed then entering offline mode +OfflineSetNameColor = False + +# Color of the name in offline mode (if OfflineSetNameColor = True) +OfflineNameColor = 808080 + + +# --------------------------------------------------------------------------- # Mana Drugs/Potions # --------------------------------------------------------------------------- # This option will enable core support for: Index: java/net/sf/l2j/Config.java =================================================================== --- java/net/sf/l2j/Config.java (revision 2917) +++ java/net/sf/l2j/Config.java (working copy) @@ -538,6 +538,10 @@ public static boolean L2JMOD_ENABLE_WAREHOUSESORTING_CLAN; public static boolean L2JMOD_ENABLE_WAREHOUSESORTING_PRIVATE; public static boolean L2JMOD_ENABLE_WAREHOUSESORTING_FREIGHT; + public static boolean OFFLINE_TRADE_ENABLE; + public static boolean OFFLINE_CRAFT_ENABLE; + public static boolean OFFLINE_SET_NAME_COLOR; + public static int OFFLINE_NAME_COLOR; public static boolean L2JMOD_ENABLE_MANA_POTIONS_SUPPORT; @@ -1716,6 +1720,11 @@ BANKING_SYSTEM_GOLDBARS = Integer.parseInt(L2JModSettings.getProperty("BankingGoldbarCount", "1")); BANKING_SYSTEM_ADENA = Integer.parseInt(L2JModSettings.getProperty("BankingAdenaCount", "500000000")); + OFFLINE_TRADE_ENABLE = Boolean.parseBoolean(L2JModSettings.getProperty("OfflineTradeEnable", "false")); + OFFLINE_CRAFT_ENABLE = Boolean.parseBoolean(L2JModSettings.getProperty("OfflineCraftEnable", "false")); + OFFLINE_SET_NAME_COLOR = Boolean.parseBoolean(L2JModSettings.getProperty("OfflineSetNameColor", "false")); + OFFLINE_NAME_COLOR = Integer.decode("0x" + L2JModSettings.getProperty("OfflineNameColor", "808080")); + L2JMOD_ENABLE_MANA_POTIONS_SUPPORT = Boolean.parseBoolean(L2JModSettings.getProperty("EnableManaPotionSupport", "false")); } catch (Exception e) Index: java/net/sf/l2j/gameserver/network/L2GameClient.java =================================================================== --- java/net/sf/l2j/gameserver/network/L2GameClient.java (revision 2917) +++ java/net/sf/l2j/gameserver/network/L2GameClient.java (working copy) @@ -39,6 +39,7 @@ import net.sf.l2j.gameserver.model.L2World; import net.sf.l2j.gameserver.model.actor.instance.L2PcInstance; import net.sf.l2j.gameserver.model.entity.L2Event; +import net.sf.l2j.gameserver.model.entity.TvTEvent; import net.sf.l2j.gameserver.network.serverpackets.L2GameServerPacket; import net.sf.l2j.util.EventData; @@ -580,9 +581,25 @@ { isDetached(true); L2PcInstance player = L2GameClient.this.getActiveChar(); - if (player != null && player.isInCombat()) + if (player != null) { - fast = false; + if (!player.isInOlympiadMode() && !player.isFestivalParticipant() && !TvTEvent.isPlayerParticipant(player.getObjectId()) && !player.isInJail()) + { + if ((player.isInStoreMode() && Config.OFFLINE_TRADE_ENABLE) || (player.isInCraftMode() && Config.OFFLINE_CRAFT_ENABLE)) + { + player.leaveParty(); + if (Config.OFFLINE_SET_NAME_COLOR) + { + player.getAppearance().setNameColor(Config.OFFLINE_NAME_COLOR); + player.broadcastUserInfo(); + } + return; + } + } + if (player.isInCombat()) + { + fast = false; + } } cleanMe(fast); } Index: java/net/sf/l2j/gameserver/network/clientpackets/Logout.java =================================================================== --- java/net/sf/l2j/gameserver/network/clientpackets/Logout.java (revision 2917) +++ java/net/sf/l2j/gameserver/network/clientpackets/Logout.java (working copy) @@ -103,6 +103,13 @@ } TvTEvent.onLogout(player); + + if ((player.isInStoreMode() && Config.OFFLINE_TRADE_ENABLE) || (player.isInCraftMode() && Config.OFFLINE_CRAFT_ENABLE)) + { + player.closeNetConnection(); + return; + } + RegionBBSManager.getInstance().changeCommunityBoard(); player.deleteMe(); Index: java/net/sf/l2j/gameserver/network/clientpackets/RequestJoinParty.java =================================================================== --- java/net/sf/l2j/gameserver/network/clientpackets/RequestJoinParty.java (revision 2917) +++ java/net/sf/l2j/gameserver/network/clientpackets/RequestJoinParty.java (working copy) @@ -105,6 +105,12 @@ requestor.sendMessage("Player is in Jail"); return; } + + if (target.getClient().isDetached()) + { + requestor.sendMessage("Player is in offline mode."); + return; + } if (target.isInOlympiadMode() || requestor.isInOlympiadMode()) return; Index: java/net/sf/l2j/gameserver/model/L2ClanMember.java =================================================================== --- java/net/sf/l2j/gameserver/model/L2ClanMember.java (revision 2917) +++ java/net/sf/l2j/gameserver/model/L2ClanMember.java (working copy) @@ -143,7 +143,14 @@ public boolean isOnline() { - return _player != null; + if (_player == null) + return false; + if (_player.getClient() == null) + return false; + if (_player.getClient().isDetached()) + return false; + + return true; } /** -
When this error happens the lagg all Server
See the error:
-
Versus the problem continues.
View Code:
// player chat banned? if (activeChar.isChatBanned()) { activeChar.checkBanChat(true); return; } + // Block \n + if (_text.contains("\n")) + _text.replace("\n", "N"); // player jailed? if (activeChar.isInJail() && Config.JAIL_DISABLE_CHAT) { if (_type == TELL || _type == SHOUT || _type == TRADE || _type == HERO_VOICE) { activeChar.sendMessage("You Have been Chat Banned"); return; } } -
excuse-me for my bad english
view print
Game Server New Error
in Request Server Development Help [L2J]
Posted
The error is related to Characters table .
but do not know how to solve it.
Deleted all the characters of the table "characters" and the error disappeared ..
but is not a viable solution.
anyone have any suggestions?