englich :
hey community I have there big problem I have server now now gets open to run and everything, however, if I
char has selected on play start clicks
does come that here what can be him??
I have checked gamelog everything OK
Deutsch :
hey community ich habe da ein großes problem also ich habe den server jetzt zu laufen bekomme und alles aber wenn ich jetzt auf
char ausgewählt hat auf spiel starten klickt
kommst dass hier was kann das den sein ??
ich habe die gamelog nachgeschaut alles ok
USE [PS_UserData] GO /****** Object: StoredProcedure [dbo].[usp_Try_GameLogin3_R] Script Date: 08/15/2010 19:04:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO
/*================================================== @date 2007-09-27 @brief Login Proc( Korea Test Server & Japan Server ) ==================================================*/
SET @CompanyIP = '61.107.81' SET @UserIP = LTRIM( RTRIM(@UserIP) )
SELECT @UserUID=UserUID, @EnPassword=Enpassword, @Status=Status, @Leave=Leave FROM Users_Master WHERE UserID = @UserID
-- NotExist User OR Leave User IF( @UserUID = 0 OR @Leave = 1 ) BEGIN SET @Status = -3 END ELSE BEGIN -- Check Password SET @InEnPassword = master.dbo.fn_md5(@InPassword) IF ( @InEnPassword <> @EnPassword ) BEGIN SET @Status = -1 END END
-- BlockUser Check IF( (@Status >= 2) AND (@Status <= 6) ) BEGIN -- Get Block Limit Date AND Replace date text DECLARE @BlockEndDate datetime SELECT @BlockEndDate = BlockEndDate FROM Users_Block WHERE UserUID = @UserUID IF ( @@ROWCOUNT <> 0 ) BEGIN -- Block Release IF ( @BlockEndDate <= @LoginTime ) BEGIN SET @Status = 0 UPDATE Users_Master SET Status = @Status WHERE UserUID = @UserUID END END END
-- Admin IP Check(2006-02-21) /* IF( @Status = 16 OR @Status = 32 OR @Status = 48 OR @Status = 64 OR @Status = 80 ) BEGIN SET @TempIP = LEFT(@UserIP, 9) IF( @TempIP <> @CompanyIP ) BEGIN SET @Status = -999 END END */
-- Select SELECT @Status AS Status, @UserUID AS UserUID
-- Log Insert IF( @Status = 0 OR @Status = 16 OR @Status = 32 OR @Status = 48 OR @Status = 64 OR @Status = 80 ) BEGIN EXEC usp_Insert_LoginLog_E @SessionID=@SessionID, @UserUID=@UserUID, @UserIP=@UserIP, @LogType=0, @LogTime=@LoginTime, @LoginType=@LoginType END
SET NOCOUNT OFF
usp_Try_GameLogout_R
PHP Code:
USE [PS_UserData] GO /****** Object: StoredProcedure [dbo].[usp_Try_GameLogout_R] Script Date: 08/15/2010 19:04:24 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO
DECLARE @LoginTime datetime DECLARE @LastPlayTime int DECLARE @OldPoint int DECLARE @LoginSession bigint SET @LoginSession=(select LoginSession from PS_userdata.dbo.UserLoginStatus where useruid=@UserUID) SET @LastPlayTime=(select LastPlayTime from PS_userdata.dbo.UserLoginStatus where useruid=@UserUID) SET @LoginTime=(select LoginTime from PS_userdata.dbo.UserLoginStatus where useruid=@UserUID) SET @OldPoint=(select Point from PS_userdata.dbo.Users_Master where useruid=@UserUID) IF (@SessionID=@LoginSession) BEGIN Update PS_userdata.dbo.Users_Master SET point=point+@LastPlayTime/2 WHERE useruid=@UserUID INSERT INTO PS_userdata.dbo.UserOnlineTimeLog(UserUid,OldPoint,Addpoint,LoginTime,LogoutTime,SessionID) values(@UserUID,@OldPoint,@LastPlayTime,@LoginTime,@LogTime,@SessionID) end SET NOCOUNT OFF
And ...
I login.... Success Fully but I selected game server in Server list and press ok .... Server disconnect Error code 0
Where i make error ?
Log Detail : discon client: ( 8, 1236) T=000:00:00:000, RC=1,RCS=0, RB=24,RBS=0, SC=0,SCS=0, SB=0,SBS=0
Note : Sorry guys I got bad english...
i wanna try make 1,but problem come at server patch config.under gamegroups/gamegroups01 - the 'command' is not available/not clickable.how to solve this?
There seems to be a problem with your first .svmap files link. It looks like Mediafire, or the original uploader, has removed it. At least that's the error I'm getting. Is this really important, or did you fix this already with a subsequent link post somewhere, and I just haven't found it yet?
Hi.. i didnt find if some1 els have asked this already.. but my broblem is that SQL Server 2005 Express Edition SP3.. has it got any updates cos mu SQL looks lot diffrent than tha on picture and cant do what i have to do make server work.. any1 knows what i can do`?
hallo I have problem has me with then manager on mssql eingelogt and has new benutzer done with Shaiya Shaiya123 and I get always this fehler I know him did not access is permitted has everything tried agrees always same fehler has already anew done win, however, always same fehler
okey.. I solved that problem by my own.. but now i got another.. i cant download those *svmap files.. says that those are removed.. but where ? any1 know?
Ok im haveing truble geting into the old ep3 sql databass to update it like on your guide i got the server config maniger set up i think and i try to use the server manigment studio express and it opens a defalt page but i dont see any shaiya ep3 files anywhere in it i might not be loging into it right im not shure if i had to log in under shaiya shaiya 123 or what it never works out for me
but I selected game server in Server list and press ok .... Server disconnect Error code 0 
