Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

C9 - Adding Resurrection Scrolls into the Database.

Junior Spellweaver
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.
 
Junior Spellweaver
Joined
Dec 14, 2008
Messages
108
Reaction score
79
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:
Initiate Mage
Joined
Jan 27, 2015
Messages
46
Reaction score
5
Change your account to GM and type :
/levelup xxx
xxx= number of level

@
 
Initiate Mage
Joined
Apr 8, 2014
Messages
7
Reaction score
3
stats up ^^



this is where you can increase item upgrade success

 
Initiate Mage
Joined
Aug 23, 2015
Messages
16
Reaction score
3
stats up ^^



this is where you can increase item upgrade success


Not work for me, broken at 10 ..
 
Initiate Mage
Joined
Jan 27, 2015
Messages
46
Reaction score
5
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
 
Junior Spellweaver
Joined
Feb 5, 2007
Messages
136
Reaction score
45
@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!
 

Attachments

You must be registered for see attachments list
Last edited:
Junior Spellweaver
Joined
Dec 14, 2008
Messages
108
Reaction score
79
@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.
 
Initiate Mage
Joined
Jan 27, 2015
Messages
46
Reaction score
5
@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
 
Initiate Mage
Joined
Dec 3, 2015
Messages
2
Reaction score
0
How to edit enchantment rates? The one in SQL didn't work. Any solutions?
 
Back
Top