C9 - Adding Resurrection Scrolls into the Database.

[Juntoa]

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.

[MentaL]

[Juntoa]

How to add Gold to Character:

USE [C9World]
GO

DECLARE           @return_value int,
               @paddMoney int

SELECT           @paddMoney = 10000

EXEC           @return_value = [Game].[UspAddPcMoney]
        @pPcNo = 2,
               @paddMoney =        @paddMoney OUTPUT,
        @pMaxMoney = 100000

SELECT           @paddMoney as N        @paddMoney'

SELECT    'Return Value' =        @return_value

GO

I was using MSSQL 2008 R2
@paddMoney sets how much will be added and @pMaxMoney set the maximal per transaction so @paddMoney needs to be slightly smaller or less than @pMaxMoney.



This adds gold to the character again must log out for it to update. @paddMoney needs to say pAdd but the post keeps getting edited.

- - - Updated - - -

Add Points "Maybe Wcoins" I used it to buy cash shop items.

USE [C9World]
GO

DECLARE     @return_value int,
	     @paddWB int

SELECT     @paddWB = 100

EXEC     @return_value = [Game].[UspAddPcWB]
		@pPcNo = 2,
		@pMaxWB = 10000,
	     @paddWB =     @paddWB OUTPUT

SELECT     @paddWB as N     @paddWB'

SELECT	'Return Value' =     @return_value

GO

@paddWB = 100 this is the quantity adding, @pMaxWB = 10000, Max value, @pPcNo = 2, account number again.

- - - Updated - - -

Update the Experience of the Character:

USE [C9World]
GO

DECLARE   @return_value int

EXEC   @return_value = [Admin].[UspUpdatePcExp]
		@pPcNo = 2,
		@pExp = 4400

SELECT	'Return Value' =   @return_value

GO

I'm having issues when posting the code in snippets so verify that code matches the pics.

[WildWild]

Change your account to GM and type :
/levelup xxx
xxx= number of level

@

[bas2000]

stats up ^^

- - - Updated - - -

this is where you can increase item upgrade success

[Juntoa]

It very well looks that way but i have not played with it yet to confirm.

[Sun12]

stats up ^^

- - - Updated - - -

this is where you can increase item upgrade success

Not work for me, broken at 10 ..

[WildWild]

Enchant +10 by Gm command

/enchant 10

The First Item in your Inventory will be enchant to 10.

/enchant 10 2 meant The Second Item in your Inventory will be enchant to 10
@bas2000 your should change your status, i dont think change item stats is wise

[st-m4il]

@Juntoa using using MSSQL 2008 R2. Typed (did not copy paste) from screenshots exact query. Got good Results (100) Return value (0) Query executed successfully. No points or coins added to a level 1 (non GM) account :( Log out, log in, even restart the server. Run query again and result increments (ie now 200 coins) but still no luck in game :(
Verified account number cAccNo=3. No luck.

Pic of SQL Game.TblPcInfo click to make larger:



Ideas? Needs cPaidRsrtCoin?

Ahh according to this must restart World Server!?! PAIN!

https://forum.ragezone.com/f857/rele...ml#post8527585

Hopefully someone can find a way to do it without a World Server Restart!

[Juntoa]

@Juntoa using using MSSQL 2008 R2. Typed (did not copy paste) from screenshots exact query. Got good Results (100) Return value (0) Query executed successfully. No points or coins added to a level 1 (non GM) account :( Log out, log in, even restart the server. Run query again and result increments (ie now 200 coins) but still no luck in game :(
Verified account number cAccNo=3. No luck.

Pic of SQL Game.TblPcInfo click to make larger:



Ideas? Needs cPaidRsrtCoin?

Ahh according to this must restart World Server!?! PAIN!

https://forum.ragezone.com/f857/rele...ml#post8527585

Hopefully someone can find a way to do it without a World Server Restart!

stored procedure : game.UspAddPcMoney run when your logged off not while your on server locks the database transactions. go to character select screen and run it select character go back in game and it should be there. Also the max need to be larger than what your adding or is does not add it.
But i would use server stored procedures to add to games all field will properly be updated.

[Sun12]

Thanks.
Where i can see all Gm comman ?

[WildWild]

@Juntoa using using MSSQL 2008 R2. Typed (did not copy paste) from screenshots exact query. Got good Results (100) Return value (0) Query executed successfully. No points or coins added to a level 1 (non GM) account :( Log out, log in, even restart the server. Run query again and result increments (ie now 200 coins) but still no luck in game :(
Verified account number cAccNo=3. No luck.

Pic of SQL Game.TblPcInfo click to make larger:



Ideas? Needs cPaidRsrtCoin?

Ahh according to this must restart World Server!?! PAIN!

https://forum.ragezone.com/f857/rele...ml#post8527585

Hopefully someone can find a way to do it without a World Server Restart!

I use Navicat Premium connect to database and change many thing without restart server.
Must be loggoff

[harlem321]

stats up ^^

- - - Updated - - -

this is where you can increase item upgrade success

how did u upgrade ur stats using gm commands?

[zapuxas098]

How to edit enchantment rates? The one in SQL didn't work. Any solutions?

[klugor]

Good evening
How to add items to cashshop?
thank you beforehand

[Juntoa]

Good evening
How to add items to cashshop?
thank you beforehand

https://forum.ragezone.com/f859/c9-h...1/index16.html