@Twilight: How to check version of the client join in the server ?
Printable View
@Twilight: How to check version of the client join in the server ?
any one can answer me?
why when i buy something on de cash shop i get: Error 0 ?
see logs... mb error store proc... or wrong itemsQuote:
Originally Posted by metalknuxx
the log says:
now , the procedure usp_Save_User_BuyPointItems_PayLetterTQuote:
2009-06-19 15:57:11 SaveBuyPointItem 260 [AE]-Kelly qerr=-1, {?=call usp_Save_User_BuyPointItems_PayLetterT(393,260,200,'B1_Mycha0001','2009-06-19 15:57:11',1)}
and the procedure usp_Update_UserPointQuote:
/****** Object: Stored Procedure dbo.usp_Save_User_BuyPointItems_PayLetterT Script Date: 2008-6-7 18:31:58 ******/
/****** Object: Stored Procedure dbo.usp_Save_User_BuyPointItems Script Date: 2008/3/15 下午 05:25:51 ******/
CREATE Proc usp_Save_User_BuyPointItems_PayLetterT
@UserUID int,
@CharID int,
@UsePoint int,
@ProductCode varchar(20),
@UseDate datetime,
@ServerID int
AS
SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @UseType int
DECLARE @ReturnValue int
SET @UseType = 1 -- 掘衙
BEGIN DISTRIBUTED TRANSACTION
EXEC @ReturnValue = game.PS_UserData.dbo.usp_Update_UserPoint @UserUID, @UsePoint
IF ( @ReturnValue < 0 )
BEGIN
GOTO ERROR
END
-- 檣 離馬(Old, 夥煎 UPDATE僥 陳塒唳辦 醴憮纂陛 號檜 橾橫陴)
--UPDATE game.PS_UserData.dbo.Users_Master SET Point=Point-@UsePoint WHERE UserUID=@UserUID
--IF( @@ERROR<>0 OR @@ROWCOUNT=0)
--BEGIN
-- GOTO ERROR
--END
-- 檣 煎斜 晦煙
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCode,UseDate)
VALUES(@UseType,@UserUID,@CharID,@UsePoint,@ProductCode,@UseDate)
IF( @@ERROR<>0)
BEGIN
GOTO ERROR
END
COMMIT TRAN
RETURN 1
ERROR:
ROLLBACK TRAN
RETURN -1
SET XACT_ABORT OFF
SET NOCOUNT OFF
GO
help plzzz :xQuote:
/****** Object: Stored Procedure dbo.usp_Update_UserPoint Script Date: 2008-6-7 18:34:05 ******/
CREATE Proc usp_Update_UserPoint
@UserUID int,
@UsePoint int
AS
SET NOCOUNT ON
DECLARE
@UserPoint int
SELECT @UserPoint= ISNULL(Point,0) FROM Users_Master WHERE UserUID=@UserUID
IF ( @@ROWCOUNT=0 OR @UserPoint-@UsePoint < 0 )
BEGIN
UPDATE Users_Master SET Point=0 WHERE UserUID=@UserUID
RETURN -1
END
UPDATE Users_Master SET Point=ISNULL(Point,0)-@UsePoint WHERE UserUID=@UserUID
IF( @@ERROR<>0 )
BEGIN
RETURN -1
END
RETURN 1
SET NOCOUNT OFF
GO
For ex check errors store proc:Quote:
Originally Posted by metalknuxx
1. Run Query Analyzer and select db PS_GameData.
2. In SQL query window:
exec usp_Save_User_BuyPointItems_PayLetterT(393,260,200 ,'B1_Mycha0001','2009-06-19 15:57:11',1)
and press button green arrow (RUN)... see error?
i think problem in row
EXEC @ReturnValue = game.PS_UserData.dbo.usp_Update_UserPoint @UserUID, @UsePoint
change
EXEC @ReturnValue = PS_UserData.dbo.usp_Update_UserPoint @UserUID, @UsePoint
PS: Query Analyzer error log?
query analyzer error
man i love you :3Quote:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '393'.
problem fixed
one more thing Twilight
can you post the product list and Cash.SData of RunUp client?
Before to execute a script, it is necessary to remove all old records from table ProductListQuote:
Originally Posted by metalknuxx
well, you have the item list and the item.SData of runup too? :D
repack error in last rowQuote:
Originally Posted by metalknuxx
well, you have the item list and the item.SData of runup too? :D
[quote=metalknuxx;5091651]well, you have the item list and the item.SData of runup too? :D
Any one help me run SData Extractor in Python ?
I put the Skill.SData in the SData folder, Right click at the SData.py -> Edit with IDLE and then...
http://c.uploadanh.com/upload/0/348/...1245476414.bmp
create bat file.. and runQuote:
Originally Posted by LightRitual
inside:
SData.py Skill -o sql_update_lang
Example bat.. extract All
i have this error using Item.Py, of ZeroSignal
http://img291.imageshack.us/img291/2479/semttulocbm.png