game.exe clock, 4.5

[GkRock]

someone can do something with this Game.exe 4.5 that has a clock.
Selecting a bug, disconnect from the server.
eh what caught the last Shaiya.
when he was in his decrypting epi 4.5 Game.exe

to download the game.exe send pm

[Arby]

#moved…

[Trayne01]

Hello.
All you have to do, is to setup a 5.4 (), and 5. Then you should change level cap to 60 using , and you should use 4.5 Svmaps & and .Sdata, you can convert them using the lastest

[GkRock]

Originally Posted by Trayne01

Hello.
All you have to do, is to setup a 5.4 (), and 5. Then you should change level cap to 60 using , and you should use 4.5 Svmaps & and .Sdata, you can convert them using the lastest

I'm trying to restrict the level limit to file ps_game.exe



but I have not got

you have no idea if possible limit it to level 60?

I followed this guide but it has not turned me




how can I do it?

[shen1l]

i have added clock for ep3 and ep4.5
it was a really sick job,here are the tips,but require some programming knowledge

1.prepare the object for words at the beginning of game
(i used the class what use for draw player's name)

2.prepare the object for background at the beginning of game
(i used the class what radar uses)

3.draw them under the radar

4.send time to player after he have logined, just send ones enough
realtime= getticount()+servertime

[GkRock]

Originally Posted by shen1l

i have added clock for ep3 and ep4.5
it was a really sick job,here are the tips,but require some programming knowledge

1.prepare the object for words at the beginning of game
(i used the class what use for draw player's name)

2.prepare the object for background at the beginning of game
(i used the class what radar uses)

3.draw them under the radar

4.send time to player after he have logined, just send ones enough
realtime= getticount()+servertime

It is an excellent way shen1l
but voted to follow the advice of Trayne01
and modify the file episode 5
as it gives me the ability to have enough material to work
but I'm having trouble changing the limit level in your ps_game.exe


I am also dealing with the ugly mistake 0 when buying an item
I am using Windows Server 2008 R2
SQL Server 2008 r2

if you have any advice to solve this error (0) when purchasing items

Thank you

[shen1l]

use ps_gamedata

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER Proc [dbo].[usp_Save_User_BuyPointItems2]
@ID int,
@CharID int, @oint int,
@ProductCode varchar(20), @ate datetime

AS

SET NOCOUNT ON
--SET XACT_ABORT ON

DECLARE @ype int
DECLARE @Ret int
DECLARE @RemainPoint int
DECLARE @OrderNumber int
DECLARE @Value int

SET @Ret = 0

SET @ype = 1 -- 구매

BEGIN DISTRIBUTED TRANSACTION

/*========================================
아이템 구매
구매일 경우 구매 유저 UID 와 받는 유저 UID를 똑같이 입력하면 됩니다.
procRequestOrderProductByGame

구매유저 UID @buyClientUserNumber BIGINT
받는유저 UID @receiveClientUserNumber BIGINT
아이템코드 @itemCode VARCHAR(50)
결과 코드 @resultCode SMALLINT OUTPUT
결제 후 잔액 @cashBalanceAfterOrder INT OUTPUT
구매번호 @orderNumber INT OUTPUT

resultCode
0 성공
1 잔액부족
2 해당 사용자 존재하지 않음
3 해당 아이템이 존재하지 않음
5 DB오류
6 기타오류
=========================================*/
EXEC @Value = PS_UserData.dbo.usp_Update_UserPoint @ID, @oint
IF ( @Value < 0 )
BEGIN
GOTO ERROR
END

/*IF ( @Ret <> 0 )
BEGIN
INSERT INTO PointErrorLog( UserUID, CharID, ProductCode, Ret) VALUES( @ID, @CharID, @ProductCode, @Ret )
GOTO ERROR
END
---------------------------------------------
*/

-- 포인트 로그 기록
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCo de,UseDate,RemainPoint,OrderNumber)
VALUES @ype @ID,@CharID @oint,@ProductCode @ate,@RemainPoint,@OrderNumber)
IF( @@ERROR<>0)
BEGIN
GOTO ERROR
END

COMMIT TRAN
RETURN 1

ERROR:
ROLLBACK TRAN
RETURN -1


SET XACT_ABORT OFF
SET NOCOUNT OFF

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

[GkRock]

Originally Posted by shen1l

use ps_gamedata

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER Proc [dbo].[usp_Save_User_BuyPointItems2]
@ID int,
@CharID int, @oint int,
@ProductCode varchar(20), @ate datetime

AS

SET NOCOUNT ON
--SET XACT_ABORT ON

DECLARE @ype int
DECLARE @Ret int
DECLARE @RemainPoint int
DECLARE @OrderNumber int
DECLARE @Value int

SET @Ret = 0

SET @ype = 1 -- 구매

BEGIN DISTRIBUTED TRANSACTION

/*========================================
아이템 구매
구매일 경우 구매 유저 UID 와 받는 유저 UID를 똑같이 입력하면 됩니다.
procRequestOrderProductByGame

구매유저 UID @buyClientUserNumber BIGINT
받는유저 UID @receiveClientUserNumber BIGINT
아이템코드 @itemCode VARCHAR(50)
결과 코드 @resultCode SMALLINT OUTPUT
결제 후 잔액 @cashBalanceAfterOrder INT OUTPUT
구매번호 @orderNumber INT OUTPUT

resultCode
0 성공
1 잔액부족
2 해당 사용자 존재하지 않음
3 해당 아이템이 존재하지 않음
5 DB오류
6 기타오류
=========================================*/
EXEC @Value = PS_UserData.dbo.usp_Update_UserPoint @ID, @oint
IF ( @Value < 0 )
BEGIN
GOTO ERROR
END

/*IF ( @Ret <> 0 )
BEGIN
INSERT INTO PointErrorLog( UserUID, CharID, ProductCode, Ret) VALUES( @ID, @CharID, @ProductCode, @Ret )
GOTO ERROR
END
---------------------------------------------
*/

-- 포인트 로그 기록
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCo de,UseDate,RemainPoint,OrderNumber)
VALUES @ype @ID,@CharID @oint,@ProductCode @ate,@RemainPoint,@OrderNumber)
IF( @@ERROR<>0)
BEGIN
GOTO ERROR
END

COMMIT TRAN
RETURN 1

ERROR:
ROLLBACK TRAN
RETURN -1


SET XACT_ABORT OFF
SET NOCOUNT OFF

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

excellent, but the following error when wanting to run the scrips

Msg 102, Level 15, State 1, Procedure usp_Save_User_BuyPointItems2, Line 59
Incorrect syntax near 'de'.

[shen1l]

space

[[GM]Bondax]

Do you really ask this even the problem is front of your eyes ? Have u checked the error line ?

- 포인트 로그 기록
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCo de,UseDate,RemainPoint,OrderNumber)
VALUES @ype @ID @D @oint @Code

Change first productco de to productcode

[GkRock]

Originally Posted by shen1l

space

thanks for the code shenl1
error(0) corrected
add a (,,,) in the script
and now it works correctly

Originally Posted by [GM]Bondax

Do you really ask this even the problem is front of your eyes ? Have u checked the error line ?

- 포인트 로그 기록
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCo de,UseDate,RemainPoint,OrderNumber)
VALUES @ype @ID @D @oint @Code

Change first productco de to productcode

if you go to help someone
do so without the need to highlight a silly mistake the person
We not all born knowing programming like you

[[GM]Bondax]

Originally Posted by GkRock

thanks for the code shenl1
error(0) corrected
add a (,,,) in the script
and now it works correctly



if you go to help someone
do so without the need to highlight a silly mistake the person
We not all born knowing programming like you

lol i dont have a good knowledge and i am not going to highlight. What i do that i always trying and solve problems by working, in that one you just have to double click to error line in sql and u can see your problem without asking. That i see you dont want help you just want someone makes for you even if u can not check simple things ? what would you do with biggest one ? Try to learn without asking i am sure you will find some solution yourself. Shen is always helping me if i stuck on something but if there is little mistakes i do myself by checking one by one