Quote:
Hello.
All you have to do, is to setup a 5.4 [Only registered and activated users can see links. Click Here To Register...] ([Only registered and activated users can see links. Click Here To Register...]), and 5[Only registered and activated users can see links. Click Here To Register...]. Then you should change level cap to 60 using [Only registered and activated users can see links. Click Here To Register...], and you should use 4.5 Svmaps & and .Sdata, you can convert them using the lastest [Only registered and activated users can see links. Click Here To Register...]
Quote:
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
Quote:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER Proc [dbo].[usp_Save_User_BuyPointItems2]
@[Only registered and activated users can see links. Click Here To Register...]ID int,
@CharID int, @[Only registered and activated users can see links. Click Here To Register...]oint int,
@ProductCode varchar(20), @[Only registered and activated users can see links. Click Here To Register...]ate datetime
AS
SET NOCOUNT ON
--SET XACT_ABORT ON
DECLARE @[Only registered and activated users can see links. Click Here To Register...]ype int
DECLARE @Ret int
DECLARE @RemainPoint int
DECLARE @OrderNumber int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]Value int
SET @Ret = 0
SET @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]Value = PS_UserData.dbo.usp_Update_UserPoint @[Only registered and activated users can see links. Click Here To Register...]ID, @[Only registered and activated users can see links. Click Here To Register...]oint
IF ( @[Only registered and activated users can see links. Click Here To Register...]Value < 0 )
BEGIN
GOTO ERROR
END
/*IF ( @Ret <> 0 )
BEGIN
INSERT INTO PointErrorLog( UserUID, CharID, ProductCode, Ret) VALUES( @[Only registered and activated users can see links. Click Here To Register...]ID, @CharID, @ProductCode, @Ret )
GOTO ERROR
END
---------------------------------------------
*/
-- 포인트 로그 기록
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCo de,UseDate,RemainPoint,OrderNumber)
VALUES @[Only registered and activated users can see links. Click Here To Register...]ype @[Only registered and activated users can see links. Click Here To Register...]ID,@CharID @[Only registered and activated users can see links. Click Here To Register...]oint,@ProductCode @[Only registered and activated users can see links. Click Here To Register...]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
thanks for the code shenl1Quote:
if you go to help someoneQuote:
- 포인트 로그 기록
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCo de,UseDate,RemainPoint,OrderNumber)
VALUES @[Only registered and activated users can see links. Click Here To Register...]ype @[Only registered and activated users can see links. Click Here To Register...]ID @[Only registered and activated users can see links. Click Here To Register...]D @[Only registered and activated users can see links. Click Here To Register...]oint @[Only registered and activated users can see links. Click Here To Register...]Code
Change first productco de to productcode
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 oneQuote:
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