[GS-Edition] 11 : land of trial entrance max zen

[goehdtjdrnr]

1] open GS-CS with ultraeditor

2] search under codes ^^

- price for entrance 1

0044F3D4 |. /EB 07 jmp short GameServ.0044F3DD
0044F3D6 |> |C745 FC E0930400 mov [local.iMaxTaxRate], 493E0

EB07C745FC E09304

E0 93 04 (this is 300000)

- price for entrance 2 and skip of price

0055A8BD |. C645 F0 01 mov [local.pResult+4], 1
0055A8C1 |. C745 F8 E0930400 mov [local.pResult+C], 493E0
0055A8C8 |. C745 FC 10270000 mov [local.pResult+10], 2710

C645F001C745F8 E09304 00C745FC 1027 0000

E0 93 04 (this is 300000)

10 27 (that is 10000)

[MentaL]

[goehdtjdrnr]

##### This is only a solution ...

I will soon release final solution ...

MuOnline DB ---> WZ_DISCONNECT_MEMB saved procedure

and delete under line

UPDATE [Character] SET MapNumber = 0, MapPosX = 130, MapPosY = 130 WHERE (MapNumber = 30) AND (AccountID = @uid) OR (MapNumber = 31) AND (AccountID = @uid)

finally

MuOnline DB ---> WZ_CONNECT_MEMB saved procedure

original :

--/----------------------------------------------------------------------------------------------------------------
--/ 酷网奇迹1.0M版本 (KW1.0M) 2006.8.5
--/ 版本制作：网络魏少
--/ 独家代理 : 微子数据 (2858168.com)
--/ 官方论坛 : http://www.kw88.com
--/ 销售 QQ: 397799368 188188211
--/ 奇迹私服网:http://www.musfw.com

--/================================================================================================================
--/
CREATE PROCEDURE WZ_CONNECT_MEMB
@uid varchar(10),
@server varchar(20),
@uip varchar(20)
AS

Begin

BEGIN TRANSACTION

SET NOCOUNT ON

IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED) WHERE memb___id = @uid )
Begin
UPDATE MEMB_STAT
SET ip = @uip , connectstat = 1 , servername = @server , ConnectTM = (getdate())
WHERE memb___id = @uid
End
ELSE
Begin
INSERT INTO MEMB_STAT ( memb___id,ip,connectstat,servername)
valueS (@uid,@uip,1,@server )
End
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION

--写入登录记录
IF EXISTS ( SELECT UserID FROM UserLogin WITH (READUNCOMMITTED) WHERE UserID = @uid )
Begin
UPDATE UserLogin
SET LoginIP=@uip,Server=@server,LoginTM = (getdate()),OnlineSec=0,GiveMoney=0,logoutTM=null
WHERE UserID = @uid
End
ELSE
Begin
INSERT INTO UserLogin (UserID,LoginIP,Server,LoginTM,OnlineSec,GiveMoney)
values (@uid,@uip,@server,getdate(),0,0)
End
--自动封服务器不准进入的人物
declare @SmallestZS int
declare @LargestZS int
declare @Type int
select @Type=Type from SetServerList where ServerName=@server

if (@Type>0) begin

select @SmallestZS=Smallest_ZS from SetServerList where ServerName=@server
select @LargestZS=Largest_ZS from SetServerList where ServerName=@server

if not (@SmallestZS is null) begin
update character set ctlcode=(ctlcode | 0x81) where [name] not in
(
SELECT NAME FROM WEB_ZS WHERE (ACC = @uid) AND (ZSCS >= @LargestZS) AND (ZSCS <= @SmallestZS)
) AND (AccountID = @uid)
end
end

SET NOCOUNT OFF
End
GO

edited :
--/----------------------------------------------------------------------------------------------------------------
--/ 酷网奇迹1.0M版本 (KW1.0M) 2006.8.5
--/ 版本制作：网络魏少
--/ 独家代理 : 微子数据 (2858168.com)
--/ 官方论坛 : http://www.kw88.com
--/ 销售 QQ: 397799368 188188211
--/ 奇迹私服网:http://www.musfw.com

--/================================================================================================================
--/
CREATE PROCEDURE WZ_CONNECT_MEMB
@uid varchar(10),
@server varchar(20),
@uip varchar(20)
AS

Begin

BEGIN TRANSACTION

SET NOCOUNT ON

IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED) WHERE memb___id = @uid )
Begin
UPDATE MEMB_STAT
SET ip = @uip , connectstat = 1 , servername = @server , ConnectTM = (getdate())
WHERE memb___id = @uid
End
ELSE
Begin
INSERT INTO MEMB_STAT ( memb___id,ip,connectstat,servername)
valueS (@uid,@uip,1,@server )
End
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION

--写入登录记录
IF EXISTS ( SELECT UserID FROM UserLogin WITH (READUNCOMMITTED) WHERE UserID = @uid )
Begin
UPDATE UserLogin
SET LoginIP=@uip,Server=@server,LoginTM = (getdate()),OnlineSec=0,GiveMoney=0,logoutTM=null
WHERE UserID = @uid
End
ELSE
Begin
INSERT INTO UserLogin (UserID,LoginIP,Server,LoginTM,OnlineSec,GiveMoney)
values (@uid,@uip,@server,getdate(),0,0)
End
--自动封服务器不准进入的人物
declare @SmallestZS int
declare @LargestZS int
declare @Type int
select @Type=Type from SetServerList where ServerName=@server

if (@Type>0) begin

select @SmallestZS=Smallest_ZS from SetServerList where ServerName=@server
select @LargestZS=Largest_ZS from SetServerList where ServerName=@server

if not (@SmallestZS is null) begin
update character set ctlcode=(ctlcode | 0x81) where [name] not in
(
SELECT NAME FROM WEB_ZS WHERE (ACC = @uid) AND (ZSCS >= @LargestZS) AND (ZSCS <= @SmallestZS)
) AND (AccountID = @uid)
end
end

UPDATE [Character] SET MapNumber = 0, MapPosX = 130, MapPosY = 130 WHERE (MapNumber = 30) AND (AccountID = @uid) OR (MapNumber = 31) AND (AccountID = @uid)

SET NOCOUNT OFF
End
GO

[freakmastersx]

where can i get ultraeditor?