C9 - Adding Resurrection Scrolls into the Database.

Joined
Dec 14, 2008
Messages
108
Reaction score
79
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.
 
Re: RELEASE - C9 Adding Resurrection Scrolls into the Database.

How to add Gold to Character:
Code:
USE [C9World]
GO

DECLARE           [USER=850422]return[/USER]_value int,
               [USER=380574]pad[/USER]dMoney int

SELECT           [USER=380574]pad[/USER]dMoney = 10000

EXEC           [USER=850422]return[/USER]_value = [Game].[UspAddPcMoney]
        @pPcNo = 2,
               [USER=380574]pad[/USER]dMoney =        [USER=380574]pad[/USER]dMoney OUTPUT,
        @pMaxMoney = 100000

SELECT           [USER=380574]pad[/USER]dMoney as N        [USER=380574]pad[/USER]dMoney'

SELECT    'Return Value' =        [USER=850422]return[/USER]_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.

Juntoa - C9 - Adding Resurrection Scrolls into the Database. - RaGEZONE Forums


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.



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

Code:
USE [C9World]
GO

DECLARE     [USER=850422]return[/USER]_value int,
	     [USER=380574]pad[/USER]dWB int

SELECT     [USER=380574]pad[/USER]dWB = 100

EXEC     [USER=850422]return[/USER]_value = [Game].[UspAddPcWB]
		@pPcNo = 2,
		@pMaxWB = 10000,
	     [USER=380574]pad[/USER]dWB =     [USER=380574]pad[/USER]dWB OUTPUT

SELECT     [USER=380574]pad[/USER]dWB as N     [USER=380574]pad[/USER]dWB'

SELECT	'Return Value' =     [USER=850422]return[/USER]_value

GO

Juntoa - C9 - Adding Resurrection Scrolls into the Database. - RaGEZONE Forums

Juntoa - C9 - Adding Resurrection Scrolls into the Database. - RaGEZONE Forums

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



Update the Experience of the Character:

Code:
USE [C9World]
GO

DECLARE   [USER=850422]return[/USER]_value int

EXEC   [USER=850422]return[/USER]_value = [Admin].[UspUpdatePcExp]
		@pPcNo = 2,
		@pExp = 4400

SELECT	'Return Value' =   [USER=850422]return[/USER]_value

GO
I'm having issues when posting the code in snippets so verify that code matches the pics.
Juntoa - C9 - Adding Resurrection Scrolls into the Database. - RaGEZONE Forums
 
Last edited:
stats up ^^



this is where you can increase item upgrade success

 
stats up ^^



this is where you can increase item upgrade success


Not work for me, broken at 10 ..
 
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
 
@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:

TblPcInfo - C9 - Adding Resurrection Scrolls into the Database. - RaGEZONE Forums

Ideas? Needs cPaidRsrtCoin?

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

https://forum.ragezone.com/f857/release-chs-c9-server-files-1067307/index15.html#post8527585

Hopefully someone can find a way to do it without a World Server Restart!
 
Last edited:
@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:

View attachment 154468

Ideas? Needs cPaidRsrtCoin?

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

https://forum.ragezone.com/f857/release-chs-c9-server-files-1067307/index15.html#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.
 
@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:

View attachment 154468

Ideas? Needs cPaidRsrtCoin?

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

https://forum.ragezone.com/f857/release-chs-c9-server-files-1067307/index15.html#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
 
Back