Pages

Add Resurrection Scrolls C9 Online

C9 - Adding Resurrection Scrolls into the Database.
How to add Resurrection Scrolls:
Use the query window and then execute it.
USE [C9World]
GO

DECLARE @return_value int,
@pSetRsrtCoin int

SELECT @pSetRsrtCoin = 6000

EXEC @return_value = [Game].[UspSetRsrtCoin]
@pPcNo = 2,
@pSetRsrtCoin = @pSetRsrtCoin OUTPUT,
@pMaxRsrtCoin = 6000, 
@pIsCheckBound = 1

SELECT @pSetRsrtCoin as N'@pSetRsrtCoin'

SELECT 'Return Value' = @return_value

GO

I was using MSSQL 2008 R2
@pPcNo = 2, This is the account number found in C9Unity Auth.TBLAccount table "cAccNo".

@pSetRsrtCoin, @pMaxRsrtCoin i set those both to the same value and after relogging into the server it is updated.

Juntoa
Ragezone