[Release] Ex901 for test

[flacleto]

not can not connect , already I tried everything , use sql 2008 and sql will be that someone can give a help please

[Sam Han]

@walter29 Correct

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

Guys i have erro not connect in game =( help me send me JoinServer/CS and GameServer..
Error

In login... help me

I using Winserver2012 r2/ sql server 2014 / OBDC 32 AND 64 nice

[perez4all]

Cant buy +15 items on shops.

[jhnjohnny]

Fixed and best solution SQL for JoinServer901:

https://mega.co.nz/#!LUhEiaxS!uLt4sg...DpaFAWKKcmJQi4

GoodLuck,

Tkss

[perez4all]

Can someone tell where in commonserver is the config for enable the vault? , i change it , and dont know what option is.

[tranphuoctai]

Fixed and best solution SQL for JoinServer901:

https://mega.co.nz/#!LUhEiaxS!uLt4sg...DpaFAWKKcmJQi4

GoodLuck,

Tkss

@jhnjohnny : can't use item expand iventory? why? help me

[jhnjohnny]

@jhnjohnny : can't use item expand iventory? why? help me

In SQL => Table: AccountCharacter => Col: ExtendedWarehouseCount => Value = 1

And Table: Character => Col: ExtendedInvenCount => Value = 1

GoodLuck

Tkss

[flacleto]

In SQL => Table: AccountCharacter => Col: ExtendedWarehouseCount => Value = 1

GoodLuck

Tkss

jhnjohnny not can still connect you tell me what's wrong

error-L1 : CloseClient INVALID_SOCKET
00:02:19 (9000)logout : [189.102.230.00]
Connection Closed, dwIoSize == 0 (Index:9000)
00:02:19 Response error after connection causes conclusion [9000][][][189.102.230.00]

[jhnjohnny]

jhnjohnny not can still connect you tell me what's wrong

error-L1 : CloseClient INVALID_SOCKET
00:02:19 (9000)logout : [189.102.230.00]
Connection Closed, dwIoSize == 0 (Index:9000)
00:02:19 Response error after connection causes conclusion [9000][][][189.102.230.00]

This can be many things ...
You are using the Repack901(Server/Client) and last DataBase of show40? Correctly applied the MD5 in SQL and ODBC? Applied the SQL my fixs the JoinServer? Created an account with username and password MD5 correctly?

GoodLuck

[Sam Han]

@

jhnjohnny,
hEY Brother help me, send me your cs/join and gameserver i have problem all !

- - - Updated - - -

@

@jhnjohnny,
hEY Brother help me, send me your cs/join and gameserver i have problem all !

- - - Updated - - -

@

@jhnjohnny,
hEY Brother help me, send me your cs/join and gameserver i have problem all !

[jhnjohnny]

@

@jhnjohnny,
hEY Brother help me, send me your cs/join and gameserver i have problem all !

I use CS of Ex803
JS and GS using the Repack the show40

Tkss

[michi28]

sam, use this repack. It is the public shaw40. I had problems to connect. Use this repack and fixed. and brings account created. id: 1 passw: 1

MuOnline_S901

[show40]

My client did not top this icon how to solve?
The problem is what the client file is the problem?

[tranphuoctai]

bug icon effect buff not show!~

[perez4all]

^^