ip change?Quote:
Originally Posted by ZeroSignal
Printable View
ip change?Quote:
Originally Posted by ZeroSignal
SImple just search for "72.55.177.194" then change it to your IP Address followed by a null terminator (0x00). Make sure the byte order is preserved or u will corrupt the executable.
http://img195.imageshack.us/img195/8650/aee.jpgQuote:
Originally Posted by ZeroSignal
http://img195.imageshack.us/img195/676/aeer.jpg
Make sure local login Server is running as 127.0.0.1.
thx, now workedQuote:
Originally Posted by ZeroSignal
http://img31.imageshack.us/img31/7477/gfge4g.jpg
hello everyone im stuk with something and i hope this tread can solve my problems.
1
I can buy and use but I can't Give Gift to other
"No item located on th at spot"
works well for me (server 2003/mssql 2k5)
tyvm!
Help!
Required, Gift Points Item to database.
I can add in the database?
[QUOTE=Dogo;5081952]hello everyone im stuk with something and i hope this tread can solve my problems.
1
Help me. I want money drop *200 but I don't know how.
plz tell me code sql or code query.
[ Double post sorry ]
why if i buy something on cash shop my client crashes?
people please help me change this ip 192.168.1.007 file.... thanks a lot...PHP Code:http://www.mediafire.com/download.php?thiytkm1tm5
This file is packed (ASProtect 1.23 RC4 - 1.3.08.24-> Alexey Solodovnikov)Quote:
Originally Posted by linjimmy
For unpacking use stripper_v207ht or other new version
At unpacking by should be npkcrypt.dll and npkpdb.dll
Using odbg it is removed GG
Using HEX the editor is changeable 3 IP addresses.
To me this all to make laziness.
If that you are not able, download already opened exe change in it IP (HEX)
Success
@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