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

[Yui_Ichigo]

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..

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

Just type
RESETPOW
RESETDEX
RESETINT
RESETVIT
then recon..

This requires 0 gold to execute...

Credits:
phoenix717
My player F3ng for the idea

[MentaL]

[starstrokers]

let's make this alive...!

where can i put this trigger?
i know it's in database...
but, the question where in
the database...?

[hectic]

let's make this alive...!

where can i put this trigger?
i know it's in database...
but, the question where in
the database...?

include that in ur Reborn script.. ^^

[starstrokers]

ah ok i'll try this...!

[kooldudez]

What if the players dont have guild? are they also included?

[jodanny]

hey i alreay using this scripts and its working well ^_^

thanks

me i require 200m gold to reset ahahaha

[tondofear]

I just had a try, still monitoring of side effects or bugs, i hope none.

[jodanny]

you had a point huh....

[russhimi]

im use ran to rb,how to use this?

[starstrokers]

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?

[Edison]

If oyu have a new items where do i extract it heheheh like the korea new armors......

http://i15.servimg.com/u/f15/13/45/52/24/a10.jpg

[brightlight777]

Just paste that trigger in the bottom of the reborn trigger at press execute.

[neversofter]

Where Can i Execute this Triger?...

[ProJ]

can u tell me where in database please !!!

[dart66]

ok thanks i get it :))