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!

[Share]Amend Stat Reset Manually not All stat reset...

Initiate Mage
Joined
Dec 8, 2008
Messages
81
Reaction score
8
I dont know if this has been shared before..
I just want to share it maybe sum1 doesnt have this..

This is very usefull for those who have High Reborn already,
We all know that the max StatRemain is 65k
Beyond that the stats will be lost when Reset..

So it came up to my mind to have manually reset stat not all..
For Example ResetPow, ResetDex, ResetInt, ResetVit..

Original Code by: sir phoenix717
Recode by me

Heres the code
Paste this to your Trigger where you have pasted Amend Add stats by sir phoenix717
Paste the code before the word "end" w/o quotations..
Code:
UPDATE ChaInfo SET [ChaInfo].ChaGuName='RESETPOWFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain+([ChaInfo].ChaPower),
[ChaInfo].ChaPower=0,
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(([ChaInfo].ChaPower)*0)
From Inserted
WHERE Inserted.ChaGuName='RESETPOW'
and [ChaInfo].ChaMoney>=(([ChaInfo].ChaPower)*0)
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='RESETVITFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain+([ChaInfo].ChaStrong),
[ChaInfo].ChaStrong=0,
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(([ChaInfo].ChaStrong)*0)
From Inserted
WHERE Inserted.ChaGuName='RESETVIT'
and [ChaInfo].ChaMoney>=(([ChaInfo].ChaStrong)*0)
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='RESETDEXFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain+([ChaInfo].ChaDex),
[ChaInfo].ChaDex=0,
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(([ChaInfo].ChaDex)*0)
From Inserted
WHERE Inserted.ChaGuName='RESETDEX'
and [ChaInfo].ChaMoney>=(([ChaInfo].ChaDex)*0)
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='RESETINTFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain+([ChaInfo].ChaSpirit),
[ChaInfo].ChaSpirit=0,
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(([ChaInfo].ChaSpirit)*0)
From Inserted
WHERE Inserted.ChaGuName='RESETINT'
and [ChaInfo].ChaMoney>=(([ChaInfo].ChaSpirit)*0)
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

The Amendd Commands for Reseting manually
Code:
Just type
RESETPOW
RESETDEX
RESETINT
RESETVIT
then recon..

This requires 0 gold to execute...

Credits:
phoenix717
My player F3ng for the idea
 
Custom Title Activated
Member
Joined
Jun 16, 2009
Messages
1,146
Reaction score
258
let's make this alive...!

where can i put this trigger?
i know it's in database...
but, the question where in
the database...?
 
Experienced Elementalist
Joined
Dec 16, 2007
Messages
227
Reaction score
0
What if the players dont have guild? are they also included?
 
Initiate Mage
Joined
Nov 7, 2009
Messages
85
Reaction score
2
hey i alreay using this scripts and its working well ^_^

thanks

me i require 200m gold to reset ahahaha
 
Initiate Mage
Joined
Aug 30, 2007
Messages
90
Reaction score
2
I just had a try, still monitoring of side effects or bugs, i hope none.
 
Custom Title Activated
Member
Joined
Jun 16, 2009
Messages
1,146
Reaction score
258
im use ran to rb,how to use this?

yes...!
how to use...!
although we are bumping
but, we want to know to to use
this..?
i think we should put
this into reborn trigger...
but, we use rancp/manual reborn,,,
can this be useful in manual reborn?
 
Junior Spellweaver
Joined
Feb 1, 2009
Messages
124
Reaction score
0
If oyu have a new items where do i extract it heheheh like the korea new armors......

 
Back
Top