-
Posts
88 -
Credits
0 -
Joined
-
Last visited
-
Feedback
0%
Content Type
Articles
Profiles
Forums
Store
Everything posted by L2shaken
-
now it's ok. :)
-
link off, could someone replay again?
-
Help Error Creating Account !
L2shaken replied to L2shaken's question in Request Server Development Help [L2OFF]
INSERT INTO user_auth (teste, teste123, quiz1, quiz2, answer1, answer2, new_pwd_flag, lastat) VALUES ('mylogin', HashBytes('MD5', 'mypassword'), '1', '1', CAST('' AS VARBINARY), CAST('' AS VARBINARY), 0, NULL); INSERT INTO user_account (teste, pay_stat, login_flag, warn_flag, block_flag, block_flag2, subscription_flag) VALUES ('mylogin', 1, 0, 0, 0, 0, 0); in "mylogin" and "mypassword" do I owe my login/password too? edit; My tables have different rows. CREATE TABLE [dbo].[user_auth]( [account] [varchar](14) NOT NULL, [password] [binary](16) NOT NULL, [quiz1] [varchar](255) NOT NULL, [quiz2] [varchar](255) NOT NULL, [answer1] [binary](32) NOT NULL, [answer2] [binary](32) NOT NULL, [ipcreatefrom] [varchar](50) NULL, [createdate] [varchar](50) NULL, CONSTRAINT [PK_user_auth] PRIMARY KEY CLUSTERED ( [account] ASC ) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[user_account]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE [dbo].[user_account]( [uid] [int] IDENTITY(1,1) NOT NULL, [account] [varchar](14) NOT NULL, [pay_stat] [int] NOT NULL CONSTRAINT [DF_user_account__pay_stat] DEFAULT ((0)), [login_flag] [int] NOT NULL CONSTRAINT [DF_user_account__login_flag] DEFAULT ((0)), [warn_flag] [int] NOT NULL CONSTRAINT [DF_user_account__warn_flag] DEFAULT ((0)), [block_flag] [int] NOT NULL CONSTRAINT [DF_user_account__block_flag] DEFAULT ((0)), [block_flag2] [int] NOT NULL CONSTRAINT [DF_user_account__block_flag2] DEFAULT ((0)), [block_end_date] [datetime] NULL, [last_login] [datetime] NULL, [last_logout] [datetime] NULL, [subscription_flag] [int] NOT NULL CONSTRAINT [DF_user_account_subscription_flag] DEFAULT ((0)), [last_world] [tinyint] NULL, [last_game] [int] NULL, [last_ip] [varchar](15) NULL, [hkey] [varchar](16) NULL, [cheat] [int] NOT NULL DEFAULT ((0)), [mask] [varchar](15) NULL, [lastbanaction] [char](20) NULL, [lastadmin] [char](20) NULL, [lastdate] [char](40) NULL, [reason] [char](20) NULL, [verifystring] [char](24) NULL, CONSTRAINT [PK_user_account_] PRIMARY KEY CLUSTERED ( [account] ASC ) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[ssn]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN -
Help Error Creating Account !
L2shaken replied to L2shaken's question in Request Server Development Help [L2OFF]
[MSSQL] Server = WINDOWS-PC User = sa Password = Pegueivc1602 Database = lin2db SlowQuery = 100 [Tables] server = server [Main] ServerPort = 2104 ServerExPort = 2106 BlowfishKey = 6B60CB5B82CE90B1CC2B6C556C6C6C6C ;For C4: BlowfishKey = 5F3B352E5D39342D33313D3D2D257854215E5B2400 Title = [L2J] IP = Protocol = $103 FixedPorts = 1 [Log] Auth = 1 Guard = 1 All = 0 DB = 0 [Online] Multiplier = 1,0 UserCount = 5 Interval = 30 [Admin] Password = admin IP = * [Adv] EULA = 1 Test = 0 TestServers = C4 = 0 MaxConnectionsPerIP = 3 AntiDOS = 1 AntiBrute = 0 AntiBruteIP = 0 MD5Simple = 0 SHA1 = 0 Proxy = AutoReloadFiles = 0 AutoReloadServers = 0 GameProxyMasterStatus = 1 [Ext] Mask = 0 MD5Password = 0 ExecLogin = 0 Guard = 0 [AntiBrute] Interval = 90 Penalty = 180 MaxAttempts = 5 [AntiBruteIP] Interval = 90 Penalty = 300 MaxAttempts = 10 -
Help Error Creating Account !
L2shaken replied to L2shaken's question in Request Server Development Help [L2OFF]
http://imgur.com/eViRR5U With the other hAuthD that the friend sent there, gives that error, but does not appear wrong password. -
Help Error Creating Account !
L2shaken replied to L2shaken's question in Request Server Development Help [L2OFF]
I just want to know why I can not log in, because of the wrong password error, can you tell me what I should do? -
Help Error Creating Account !
L2shaken replied to L2shaken's question in Request Server Development Help [L2OFF]
I am very lazy in the subject l2off, but I installed the programs correctly and set the password for sa user. -
Help Error Creating Account !
L2shaken replied to L2shaken's question in Request Server Development Help [L2OFF]
up -
Hello, I am configuring a server l2off on my machine, but I have a problem when creating the character, I enter login / password and the wrong password message appears and that's it, what can it be? Pack Vanganth. Print: http://imgur.com/s0tLZKm
-
Buy adrenaline key for Interlude, payment in R$ Skype: danilobn10 or PM
-
WTS 2 Keys Adrenaline Aceito Brl 50R$ Unlimited
L2shaken replied to hyspX's topic in Marketplace [Powerlvl & Support]
Mandei la -
Help Skills Reload Olympiad
L2shaken replied to L2shaken's question in Request Server Development Help [L2J]
aCis -
Hi, I need a code that loads the skills when called for the olympiads, Can someone help me ?
-
Source L2 Acp (Account - Admin Control Panel)
L2shaken replied to Elfo's topic in Server Shares & Files [L2J]
Where is the configuration file? -
WTB Auction House Code Interlude Acis
L2shaken replied to L2shaken's topic in Marketplace [L2Packs & Files]
I'm looking for one like this http://www.maxcheaters.com/topic/159407-l2j-auction-house-interlude-version/ -
I look for code "Auction House" for purchase, or some developer that can implement the code that I have.
-
WTS Auction House For Community Board [H5]
L2shaken replied to Synerge's topic in Marketplace [L2Packs & Files]
Can someone tell me if he still has the code to sell? -
Quest "q234_Fateswhisper" And Noble Reduced.
L2shaken posted a question in Request Server Development Help [L2J]
Hi, I need the Q234_FatesWhisper quest reduced, and also the noble quest. can anybody help me ? -
-
http://imgur.com/a/APPzF I added this MOD on my server, however I have a problem; When clicking where the player wants to go, he is teleported directly, the bar with the "Ok" and "Cancel" buttons only appears after the player has already been teleported. Should any part of the code be absent? Config.java config.properties L2TeleporterInstance.java (In the doTeleport method) ConfirmDlg.java DlgAnswer.java L2PcInstance.java SystemMessageId.java CLIENT: System/systemmsg-e.dat
-
CharacterSelected.java @Override protected void runImpl() { GameClient client = getClient(); +if (Config.SECOND_AUTH_ENABLED && !client.getSecondaryAuth().isAuthed()) +{ + client.getSecondaryAuth().openDialog(); + return; +} if(client.getActiveChar() != null) return; public void openDialog() { if(passwordExist()) _activeClient.sendPacket(new Ex2ndPasswordCheck(Ex2ndPasswordCheck.PASSWORD_PROMPT)); else _activeClient.sendPacket(new Ex2ndPasswordCheck(Ex2ndPasswordCheck.PASSWORD_NEW)); } package net.sf.l2j.gameserver.network.serverpackets; /** * Format (ch)dd * d: window type * d: ban user (1) */ public class Ex2ndPasswordCheck extends L2GameServerPacket { public static final int PASSWORD_NEW = 0x00; public static final int PASSWORD_PROMPT = 0x01; public static final int PASSWORD_OK = 0x02; int _windowType; public Ex2ndPasswordCheck(int windowType) { _windowType = windowType; } @Override protected void writeImpl() { writeEx(0xE5); writeD(_windowType); writeD(0x00); } } I think the "openDialog" method is to open the html in the character selection screen, but in the interlude this is not happening, can anyone help?
-
New Years Eve Lottary Event(2017)
L2shaken replied to Justice's topic in Maxcheaters Competitions & Events
16 -
Index: java/net/sf/l2j/gameserver/GeoEngine.java =================================================================== --- java/net/sf/l2j/gameserver/GeoEngine.java (revision 6) +++ java/net/sf/l2j/gameserver/GeoEngine.java (working copy) @@ -34,6 +34,7 @@ import net.sf.l2j.Config; import net.sf.l2j.gameserver.datatables.DoorTable; +import net.sf.l2j.gameserver.datatables.FenceTable; import net.sf.l2j.gameserver.model.L2Object; import net.sf.l2j.gameserver.model.L2Spawn; import net.sf.l2j.gameserver.model.L2World; @@ -117,6 +118,9 @@ if (DoorTable.getInstance().checkIfDoorsBetween(cha.getX(), cha.getY(), cha.getZ(), target.getX(), target.getY(), target.getZ())) return false; + if (!FenceTable.canSeeTarget(cha, target.getX(), target.getY())) + return false; + if (cha.getZ() >= target.getZ()) return canSeeTarget(cha.getX(), cha.getY(), cha.getZ(), target.getX(), target.getY(), target.getZ()); @@ -166,9 +170,13 @@ @Override public boolean canSeeTargetDebug(L2PcInstance gm, L2Object target) { + if (!FenceTable.canSeeTarget(gm, target.getX(), target.getY())) + return false; + // comments: see above int z = gm.getZ() + 45; int z2 = target.getZ() + 45; + if (target instanceof L2DoorInstance) { gm.sendMessage("door always true"); @@ -207,6 +215,9 @@ if (DoorTable.getInstance().checkIfDoorsBetween(x, y, z, tx, ty, tz)) return startpoint; + if (!FenceTable.canSeeTarget(x,y, tx, ty)) + return startpoint; + Location destiny = new Location(tx, ty, tz); return moveCheck(startpoint, destiny, (x - L2World.MAP_MIN_X) >> 4, (y - L2World.MAP_MIN_Y) >> 4, z, (tx - L2World.MAP_MIN_X) >> 4, (ty - L2World.MAP_MIN_Y) >> 4, tz); } Hi, I'm adding the Phoenix engine event to the aCis 350 and some lines need to be added to the GeoEngine.java file, but that file does not exist, what should I do?
-
Price?
-
:(