re: [Release] Ex901 for test
Quote:
Originally Posted by
jhnjohnny
Fixed bug password Free in login!
Run in SQLQuery:
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_AccountLogin] Script Date: 06/25/2015 12:19:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[WZ_AccountLogin]
@memb___id varchar(15), --游戏帐号
@memb__pwd varchar(64), --帐号密码
@return int OUTPUT
AS
DECLARE @pass varbinary(16)
DECLARE @guid int
SET @pass = dbo.UFN_MD5_ENCODEVALUE(@memb__pwd, @memb___id)
SET @return = 1
If NOT EXISTS( SELECT [AccountGuid] FROM [dbo].[T_AccountAgree] WHERE [AccountID] = @memb___id )
BEGIN
Select @guid = memb_guid From MEMB_INFO Where [memb___id] = @memb___id and [memb__pwd]=@pass
INSERT INTO [dbo].[T_AccountAgree]
([AccountGuid]
,[AccountID]
,[AgreeCode]
,[BlockCode]
,[AgreeStat]
,[AgreeDate]
,[CancelDate])
VALUES
@guid
,@memb___id
,0
,0
,0
,NULL
,NULL
)
END
If EXISTS(SELECT [memb___id] From MEMB_INFO Where [memb___id] = @memb___id and [memb__pwd]=@pass)
BEGIN
SET @return = 0
END
Msg 102, Level 15, State 1, Procedure WZ_AccountLogin, Line 26
Incorrect syntax near '@guid'.
re: [Release] Ex901 for test
re: [Release] Ex901 for test
Quote:
Originally Posted by
Nyl Felipe
Msg 102, Level 15, State 1, Procedure WZ_AccountLogin, Line 26
Incorrect syntax near '@guid'.
Lol only add a ( before guid.
re: [Release] Ex901 for test
Msg 207, Level 16, State 1, Procedure WZ_AccountLogin, Line 13
Invalid column name 'Accountguild'.
Msg 207, Level 16, State 1, Procedure WZ_AccountLogin, Line 16
Invalid column name 'memb_guild'.
Msg 207, Level 16, State 1, Procedure WZ_AccountLogin, Line 18
Invalid column name 'Accountguild'.
re: [Release] Ex901 for test
re: [Release] Ex901 for test
Quote:
Originally Posted by
Nyl Felipe
Msg 102, Level 15, State 1, Procedure WZ_AccountLogin, Line 26
Incorrect syntax near @
guid'.
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_AccountLogin] Script Date: 06/25/2015 12:19:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[WZ_AccountLogin]
@memb___id varchar(15), --游戏帐号
@memb__pwd varchar(64), --帐号密码 @return int OUTPUT
AS
DECLARE @pass varbinary(16)
DECLARE @guid int
SET @pass = dbo.UFN_MD5_ENCODEVALUE(@memb__pwd, @memb___id)
SET @return = 1
If NOT EXISTS( SELECT [AccountGuid] FROM [dbo].[T_AccountAgree] WHERE [AccountID] = @memb___id )
BEGIN
Select @guid = memb_guid From MEMB_INFO Where [memb___id] = @memb___id and [memb__pwd]=@pass
INSERT INTO [dbo].[T_AccountAgree]
([AccountGuid]
,[AccountID]
,[AgreeCode]
,[BlockCode]
,[AgreeStat]
,[AgreeDate]
,[CancelDate])
VALUES ( @guid
,@memb___id
,0
,0
,0
,NULL
,NULL
)
END
If EXISTS(SELECT [memb___id] From MEMB_INFO Where [memb___id] = @memb___id and [memb__pwd]=@pass)
BEGIN
SET @return = 0
END
re: [Release] Ex901 for test
who can post cracked GameServer and GameServer CS
complete folders please
thanks
re: [Release] Ex901 for test
Quote:
Originally Posted by
jhnjohnny
Fixed bug password Free in login!
Run in SQLQuery:
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_AccountLogin] Script Date: 06/25/2015 12:19:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[WZ_AccountLogin]
@memb___id varchar(15), --游戏帐号
@memb__pwd varchar(64), --帐号密码
@return int OUTPUT
AS
DECLARE @pass varbinary(16)
DECLARE @guid int
SET @pass = dbo.UFN_MD5_ENCODEVALUE(@memb__pwd, @memb___id)
SET @return = 1
If NOT EXISTS( SELECT [AccountGuid] FROM [dbo].[T_AccountAgree] WHERE [AccountID] = @memb___id )
BEGIN
Select @guid = memb_guid From MEMB_INFO Where [memb___id] = @memb___id and [memb__pwd]=@pass
INSERT INTO [dbo].[T_AccountAgree]
([AccountGuid]
,[AccountID]
,[AgreeCode]
,[BlockCode]
,[AgreeStat]
,[AgreeDate]
,[CancelDate])
VALUES
@guid
,@memb___id
,0
,0
,0
,NULL
,NULL
)
END
If EXISTS(SELECT [memb___id] From MEMB_INFO Where [memb___id] = @memb___id and [memb__pwd]=@pass)
BEGIN
SET @return = 0
END
this giving error in the query could provide DB already corregida this error, please help.
re: [Release] Ex901 for test
Quote:
Originally Posted by
flacleto
this giving error in the query could provide DB already corregida this error, please help.
Theres is no error in the query that @jhnjohnny posted.
VALUES
(
@guid
Now can i access and the password is veryfied.
re: [Release] Ex901 for test
Quote:
Originally Posted by
jhnjohnny
Yes, your need fix in Client (PacketTwist), but in GameServer working 100%
I'm using the same JoinServer "show40", which is MD5. The disconnect happens before or after the Login and Password?
Tkss
shared for Main e GS?
Fix main blue kor?
Main ENg
- - - Updated - - -
Quote:
Originally Posted by
jhnjohnny
Yes, your need fix in Client (PacketTwist), but in GameServer working 100%
I'm using the same JoinServer "show40", which is MD5. The disconnect happens before or after the Login and Password?
Tkss
shared for Main e GS?
Fix main blue kor?
Main ENg
re: [Release] Ex901 for test
There's Another crack of main.exe I mean because this main.exe crack has bug dl, and i nkanturu event, the same like in ex803. We need to fix this :)
re: [Release] Ex901 for test
this query bugou all accounts the data base even putting the correct password is giving error and not logs, tested creating new accounts with the editor and even then the lock remains.
Query that ran posted by jhnjohnny :
Quote:
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_AccountLogin] Script Date: 06/25/2015 12:19:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[WZ_AccountLogin]
@memb___id varchar(15), --游戏帐号
@memb__pwd varchar(64), --帐号密码
@return int OUTPUT
AS
DECLARE @pass varbinary(16)
DECLARE @guid int
SET @pass = dbo.UFN_MD5_ENCODEVALUE(@memb__pwd, @memb___id)
SET @return = 1
If NOT EXISTS( SELECT [AccountGuid] FROM [dbo].[T_AccountAgree] WHERE [AccountID] = @memb___id )
BEGIN
Select @guid = memb_guid From MEMB_INFO Where [memb___id] = @memb___id and [memb__pwd]=@pass
INSERT INTO [dbo].[T_AccountAgree]
([AccountGuid]
,[AccountID]
,[AgreeCode]
,[BlockCode]
,[AgreeStat]
,[AgreeDate]
,[CancelDate])
VALUES
(
@guid
,@memb___id
,0
,0
,0
,NULL
,NULL
)
END
If EXISTS(SELECT [memb___id] From MEMB_INFO Where [memb___id] = @memb___id and [memb__pwd]=@pass)
BEGIN
SET @return = 0
END
re: [Release] Ex901 for test
Error after taking items from shop , that are added or when taking kundun+1,+2,+3 and then drop Appear the same serial for all objects.
That kunduns where dropped by Golden Derkon.
20:25:03 error-L1:CopyItem Id[Test] Char[Test] Item[Çà¿îÀÇ»óÀÚ] InventoryPos[33] serial[-100]
20:25:03 error-L1:CopyItem Id[Test] Char[Test] Item[Çà¿îÀÇ»óÀÚ] InventoryPos[34] serial[-100]
20:25:03 error-L1:CopyItem Id[Test] Char[Test] Item[Çà¿îÀÇ»óÀÚ] InventoryPos[35] serial[-100]
----
FIXED!!!!!
re: [Release] Ex901 for test
Sorry, now code SQL fixed in next post...
Tkss
re: [Release] Ex901 for test
Quote:
Originally Posted by
jhnjohnny
Sorry, now code fixed:
Code:
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_AccountLogin] Script Date: 06/25/2015 22:13:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[WZ_AccountLogin]
@memb___id varchar(15), --游戏帐号
@memb__pwd varchar(64), --帐号密码
@return int OUTPUT
AS
DECLARE @pass varbinary(16)
DECLARE @guid int
SET @pass = dbo.UFN_MD5_ENCODEVALUE(@memb__pwd, @memb___id)
SET @return = 1
If NOT EXISTS( SELECT [AccountGuid] FROM [dbo].[T_AccountAgree] WHERE [AccountID] = @memb___id )
BEGIN
Select @guid = memb_guid From MEMB_INFO Where [memb___id] = @memb___id and [memb__pwd]=@pass
INSERT INTO [dbo].[T_AccountAgree]
([AccountGuid]
,[AccountID]
,[AgreeCode]
,[BlockCode]
,[AgreeStat]
,[AgreeDate]
,[CancelDate])
VALUES
@guid
,@memb___id
,0
,0
,0
,NULL
,NULL
)
END
If EXISTS(SELECT [memb___id] From MEMB_INFO Where [memb___id] = @memb___id and [memb__pwd]=@pass)
BEGIN
SET @return = 0
END
Tkss
erro
Msg 102, Level 15, State 1, Procedure WZ_AccountLogin, Line 26
Incorrect syntax near '@guid'.
