How to: Shaiya Server with EP4

Page 19 of 32 « First 91718 19 202129 Last »
08/06/2010 05:04 killernos#271
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


[Only registered and activated users can see links. Click Here To Register...]


hier mal die log

Quote:
2010-08-07 15:02:39 PS_GAME__system log start (Game) [KR]

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/sorp1

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/croco1

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/croco2

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/Troll1

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/Spink1

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/GoldenPig

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/Sorp3

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/SorpNamed1

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/SorpNamed2

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/Sorp2

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/CrocoNamed1

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/CrocoNamed2

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/CrocoNamed3

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/OrcNamed1

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/OrcNamed2

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/OrcNamed3

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/TrollNamed1

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/Deinos

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/Parridalis

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/Alcarian

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/ZinAlcaria

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/Belizabeth

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/Kirhiross

2010-08-07 15:02:39 Loaded Behavior In Factory : data/ai/CrypticOne

2010-08-07 15:02:42 connect mgr 952

2010-08-07 15:02:42 connect dbagent 948

2010-08-07 15:02:42 connect dbagent2 956

2010-08-07 15:02:42 connect gamelog 972

2010-08-07 15:02:42 Market End -----------------------

2010-08-07 15:02:43 Load Shaiya.SData 0

2010-08-07 15:16:28 <Console input> /nprotectoff

2010-08-07 15:16:28 <Console output> cmd NProtect off ok

2010-08-07 15:16:38 <Console input> /help

2010-08-07 15:16:38 <Console output> /h /help /quit /exit /shutdown/CrashDump

/mem(0) /si(0) /quitt(1) /allout(0) /uc(0) /nt(1) /cstop(0) /cstart(0) /setmaxuser(1) /kickun(1) /kickuid(1) /kickcn(1) /kickcid(1) /nprotecton(0) /nprotectoff(0) /chktimeout(0) /exp2xdisable(0) /exp2xenable(1) /enableshop(0) /disableshop(0) /disablenshop(0) /enablekill(0) /disablekill(0) /ticktime(0) /inszonecnt(0) /viewmap(1) /aiset(2) /remob(1) /remobitem(1) /reitem(1) /reskill(2) /remobskill(1) /reseqitem(0) /reitemenh(0) /reitemcre(0)

2010-08-07 15:16:58 <Console input> /exp2xenable 200

2010-08-07 15:16:58 <Console output> cmd exp2x enable ok(byadmin=1,bysys=0,current ExpX=200.000)

2010-08-07 16:02:52 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)
08/09/2010 19:16 aboldijar2#272
Hmm, well nice tutorial that really helped.But some friends wanted to join up my server how can i make it public guys?
08/12/2010 16:03 coma123#273
How launch the server ... ?
08/15/2010 18:22 blackboard#274
Hi guys Shaiya EP3 it is work np but EP4 not work :(

My First Error : Account not exist;

I fixed 2 SQL Procedures :

This errors case sensitive.

Fixed Codes

usp_Try_GameLogin3_R

PHP Code:
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

/****** Object:  Stored Procedure dbo.usp_Try_GameLogin3_R    Script Date: 2008-6-7 18:34:05 ******/




/*==================================================
@date    2007-09-27
@brief    Login Proc( Korea Test Server & Japan Server )
==================================================*/

ALTER  Proc [dbo].[usp_Try_GameLogin3_R]

@UserID     varchar(18),
@InPassword    varchar(18),

@SessionID     bigint,
@UserIP     varchar(15),

-- &#50668;기까지 필요한 인자, 나머지는 내부 변수

@UserUID     int = 0,
@LoginType     smallint = 1, 
@LoginTime     datetime = null

AS

SET NOCOUNT ON

DECLARE 
@EnPassword    varchar(32),
@InEnPassword    varchar(32),

@Leave         tinyint,
@Status     smallint,

@CompanyIP     varchar(15),
@TempIP     varchar(15)

SET @Status =         -1
SET @LoginTime =     GETDATE()

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

/****** Object:  Stored Procedure dbo.usp_Try_GameLogout_R    Script Date: 2008-6-7 18:34:05 ******/
ALTER        Proc [dbo].[usp_Try_GameLogout_R]

/* 
Created by humanws, 2005-10-18
???? ?? ??
*/

@UserUID int,
@SessionID bigint,
@LogoutType smallint = 0,
@ErrType int = 0

AS

SET NOCOUNT ON

DECLARE @LogTime datetime
DECLARE @Sql nvarchar(4000)
DECLARE @yyyy varchar(4)
DECLARE @mm varchar(2)
DECLARE @dd varchar(2)
DECLARE @LogType bit    -- Login:0, Logout:1

SET @LogType = 1
SET @LogTime = GETDATE()
SET @yyyy = DATEPART(yyyy, @LogTime)
SET @mm = DATEPART(mm, @LogTime)
SET @dd = DATEPART(dd, @LogTime)

IF( LEN(@mm) = 1 )
BEGIN
    SET @mm = '0' + @mm
END

IF( LEN(@dd) = 1 )
BEGIN
    SET @dd = '0' + @dd
END

SET @Sql = N'
INSERT INTO PS_GameLog.dbo.UserLog
(SessionID, UserUID, LogType, LogTime, LogoutType, ErrType)
VALUES(@SessionID, @UserUID, @LogType, @LogTime, @LogoutType, @ErrType)'

EXEC sp_executesql @Sql, 
N'@SessionID bigint, @UserUID int, @LogType bit, @LogTime datetime, @LogoutType smallint, @ErrType int',
@SessionID, @UserUID, @LogType, @LogTime, @LogoutType, @ErrType
update PS_userdata.dbo.UserLoginStatus
set loginstatus=0,LogoutTime=@LogTime,LogoutSession=@SessionID,LastPlayTime=datediff(minute,LoginTime,@LogTime)
where useruid=@UserUID

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...

Thanks.
08/18/2010 13:23 Ex-Convict#275
a quick question, is there a way to disable setting up shops in apulune or iris and just make black market the only legit place you can set up shops?
08/22/2010 11:55 gengkey02#276
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?
08/22/2010 18:50 chrissiho#277
wtf ... i cant good english ... a website with "1" Download ?!
08/22/2010 18:51 jrensik#278
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?
08/23/2010 15:19 litinge#279
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`?

(and sorry about my horrible english :S )
08/24/2010 00:20 vampie#280
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
08/24/2010 14:56 litinge#281
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? :)
08/27/2010 02:52 elitefox1819#282
does it specifically need sql server 2005, can i use higher versions :D
08/27/2010 17:36 killernos#283
hallo liebe community ich habe da mal eine frage weiß einer was das sein kann wen ich auf mein server will game lorde error kommt

Hello dear community, I sometimes wonder when one knows what may be the one who I want to come to my game server error lorde

?????
08/28/2010 00:18 pizzabat#284
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
08/28/2010 19:50 killernos#285
hallo liebe community ich habe da mal eine frage weiß einer was das sein kann wen ich auf mein server will game lorde error kommt

Hello dear community, I sometimes wonder when one knows what may be the one who I want to come to my game server error lorde

?????

2010-08-28 18:17:08 PS_LOGIN__system log start (Login01)

2010-08-28 18:30:50 <Console input> /vchkoff

2010-08-28 18:30:50 <Console output> cmd version chk off ok

2010-08-28 19:17:19 cmd_auto server info log

user = 0 (0/200)

2010-08-28 19:17:19 T=001:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0

2010-08-28 19:17:19 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(0/0)
Page 19 of 32 « First 91718 19 202129 Last »