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 Adder/Reset [UPDATED CODE]

phoenix717

phoenix717

Newbie Spellweaver
Joined
May 19, 2007
Messages
92
Reaction score
1
I do it to kill time. Maybe some wants:

Code: 
UPDATE ChaInfo SET [ChaInfo].ChaGuName='ADDFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain-REPLACE([ChaInfo].ChaGuName,'ADPOW',''),
[ChaInfo].ChaPow=[ChaInfo].ChaPow+REPLACE([ChaInfo].ChaGuName,'ADPOW',''),
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(REPLACE([ChaInfo].ChaGuName,'ADPOW','')*1000)
From Inserted
WHERE LEFT(Inserted.ChaGuName,5)='ADPOW'
and [ChaInfo].ChaStRemain>=REPLACE([ChaInfo].ChaGuName,'ADPOW','')
and [ChaInfo].ChaMoney>=REPLACE([ChaInfo].ChaGuName,'ADPOW','')*1000
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='ADDFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain-REPLACE([ChaInfo].ChaGuName,'ADDEX',''),
[ChaInfo].ChaDex=[ChaInfo].ChaDex+REPLACE([ChaInfo].ChaGuName,'ADDEX',''),
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(REPLACE([ChaInfo].ChaGuName,'ADDEX','')*1000)
From Inserted
WHERE LEFT(Inserted.ChaGuName,5)='ADDEX'
and [ChaInfo].ChaStRemain>=REPLACE([ChaInfo].ChaGuName,'ADDEX','')
and [ChaInfo].ChaMoney>=REPLACE([ChaInfo].ChaGuName,'ADDEX','')*1000
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='ADDFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain-REPLACE([ChaInfo].ChaGuName,'ADINT',''),
[ChaInfo].ChaSpirit=[ChaInfo].ChaSpirit+REPLACE([ChaInfo].ChaGuName,'ADINT',''),
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(REPLACE([ChaInfo].ChaGuName,'ADINT','')*1000)
From Inserted
WHERE LEFT(Inserted.ChaGuName,5)='ADINT'
and [ChaInfo].ChaStRemain>=REPLACE([ChaInfo].ChaGuName,'ADINT','')
and [ChaInfo].ChaMoney>=REPLACE([ChaInfo].ChaGuName,'ADINT','')*1000
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='ADDFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain-REPLACE([ChaInfo].ChaGuName,'ADVIT',''),
[ChaInfo].ChaStrong=[ChaInfo].ChaStrong+REPLACE([ChaInfo].ChaGuName,'ADVIT',''),
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(REPLACE([ChaInfo].ChaGuName,'ADVIT','')*1000)
From Inserted
WHERE LEFT(Inserted.ChaGuName,5)='ADVIT'
and [ChaInfo].ChaStRemain>=REPLACE([ChaInfo].ChaGuName,'ADVIT','')
and [ChaInfo].ChaMoney>=REPLACE([ChaInfo].ChaGuName,'ADVIT','')*1000
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='ADDFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain-REPLACE([ChaInfo].ChaGuName,'ADSTM',''),
[ChaInfo].ChaStrength=[ChaInfo].ChaStrength+REPLACE([ChaInfo].ChaGuName,'ADSTM',''),
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(REPLACE([ChaInfo].ChaGuName,'ADSTM','')*1000)
From Inserted
WHERE LEFT(Inserted.ChaGuName,5)='ADSTM'
and [ChaInfo].ChaStRemain>=REPLACE([ChaInfo].ChaGuName,'ADSTM','')
and [ChaInfo].ChaMoney>=REPLACE([ChaInfo].ChaGuName,'ADSTM','')*1000
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='RESETFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain+([ChaInfo].ChaPower+[ChaInfo].ChaDex+[ChaInfo].ChaSpirit+[ChaInfo].ChaStrong+[ChaInfo].ChaStrength),
[ChaInfo].ChaPower=0,
[ChaInfo].ChaDex=0,
[ChaInfo].ChaInt=0,
[ChaInfo].ChaStrong=0,
[ChaInfo].ChaStrength=0,
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(([ChaInfo].ChaPower+[ChaInfo].ChaDex+[ChaInfo].ChaSpirit+[ChaInfo].ChaStrong+[ChaInfo].ChaStrength)*1000)
From Inserted
WHERE Inserted.ChaGuName='RESETSTAT'
and [ChaInfo].ChaMoney>=(([ChaInfo].ChaPower+[ChaInfo].ChaDex+[ChaInfo].ChaSpirit+[ChaInfo].ChaStrong+[ChaInfo].ChaStrength)*1000)
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

Instructions? Just paste it below your trigger BEFORE THE WORD "END"
Your ChaInfo trigger is located at RanGame1>dbo.ChaInfo>Triggers
To use ::
TO ADD POW:
ADPOW+amount to add to power
example+ ADPOW500
that will add 500 to your power. make sure you have enough stat points
TO ADD OTHER STATS: HERE IS THE COMMAND
ADPOW
ADDEX
ADINT
ADVIT
ADSTM
to reset stat:
RESETSTAT
reconnect to activate
Click to expand...

credits?
me for the code
iwarez for structure
tondofear for idea (even if he requests stat adder for control panel he give me this idea)

Reply if effective.
 
Last edited:
The Best DDoS Protected Servers
volter

volter

Newbie Spellweaver
Joined
Jan 9, 2008
Messages
80
Reaction score
1
Re: [TEST SHARE]Amend Stat Adder

nice share very useful thnx po..^_^
 
eliteskill

eliteskill

Newbie Spellweaver
Joined
Aug 28, 2006
Messages
87
Reaction score
0
Re: [TEST SHARE]Amend Stat Adder

how to solve this....
 

Attachments

You must be registered for see attachments list
phoenix717

phoenix717

Newbie Spellweaver
Joined
May 19, 2007
Messages
92
Reaction score
1
Re: [TEST SHARE]Amend Stat Adder

eliteskill said:
how to solve this....
Click to expand...

do you have your existing trigger?
If not, include this in the top of the code ::
Code: 
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[Amend_AdStat] ON [dbo].[ChaInfo]
after update
as
BEGIN

 <put the code above here>

END
 
I'm Not MentaL

I'm Not MentaL

StoP Callin me MentaL
Loyal Member
Joined
Dec 26, 2008
Messages
3,228
Reaction score
1,017
Re: [SHARE]Amend Stat Adder/Reset [UPDATED CODE]

can this use on SQL2000?
cause i put on SQL2000 cause error said ChaPow ChaVit ChaInt error
 
kooldudez

kooldudez

Experienced Elementalist
Joined
Dec 16, 2007
Messages
227
Reaction score
0
Re: [SHARE]Amend Stat Adder/Reset [UPDATED CODE]

@TS

not effective for me. no error comes up but no luck.
 
zomer143

zomer143

Newbie Spellweaver
Joined
Mar 7, 2009
Messages
21
Reaction score
0
Re: [SHARE]Amend Stat Adder/Reset [UPDATED CODE]

phoenix717 said:
I do it to kill time. Maybe some wants:

Code: 
UPDATE ChaInfo SET [ChaInfo].ChaGuName='ADDFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain-REPLACE([ChaInfo].ChaGuName,'ADPOW',''),
[ChaInfo].ChaPow=[ChaInfo].ChaPow+REPLACE([ChaInfo].ChaGuName,'ADPOW',''),
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(REPLACE([ChaInfo].ChaGuName,'ADPOW','')*1000)
From Inserted
WHERE LEFT(Inserted.ChaGuName,5)='ADPOW'
and [ChaInfo].ChaStRemain>=REPLACE([ChaInfo].ChaGuName,'ADPOW','')
and [ChaInfo].ChaMoney>=REPLACE([ChaInfo].ChaGuName,'ADPOW','')*1000
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='ADDFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain-REPLACE([ChaInfo].ChaGuName,'ADDEX',''),
[ChaInfo].ChaDex=[ChaInfo].ChaDex+REPLACE([ChaInfo].ChaGuName,'ADDEX',''),
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(REPLACE([ChaInfo].ChaGuName,'ADDEX','')*1000)
From Inserted
WHERE LEFT(Inserted.ChaGuName,5)='ADDEX'
and [ChaInfo].ChaStRemain>=REPLACE([ChaInfo].ChaGuName,'ADDEX','')
and [ChaInfo].ChaMoney>=REPLACE([ChaInfo].ChaGuName,'ADDEX','')*1000
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='ADDFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain-REPLACE([ChaInfo].ChaGuName,'ADINT',''),
[ChaInfo].ChaSpirit=[ChaInfo].ChaSpirit+REPLACE([ChaInfo].ChaGuName,'ADINT',''),
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(REPLACE([ChaInfo].ChaGuName,'ADINT','')*1000)
From Inserted
WHERE LEFT(Inserted.ChaGuName,5)='ADINT'
and [ChaInfo].ChaStRemain>=REPLACE([ChaInfo].ChaGuName,'ADINT','')
and [ChaInfo].ChaMoney>=REPLACE([ChaInfo].ChaGuName,'ADINT','')*1000
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='ADDFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain-REPLACE([ChaInfo].ChaGuName,'ADVIT',''),
[ChaInfo].ChaStrong=[ChaInfo].ChaStrong+REPLACE([ChaInfo].ChaGuName,'ADVIT',''),
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(REPLACE([ChaInfo].ChaGuName,'ADVIT','')*1000)
From Inserted
WHERE LEFT(Inserted.ChaGuName,5)='ADVIT'
and [ChaInfo].ChaStRemain>=REPLACE([ChaInfo].ChaGuName,'ADVIT','')
and [ChaInfo].ChaMoney>=REPLACE([ChaInfo].ChaGuName,'ADVIT','')*1000
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='ADDFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain-REPLACE([ChaInfo].ChaGuName,'ADSTM',''),
[ChaInfo].ChaStrength=[ChaInfo].ChaStrength+REPLACE([ChaInfo].ChaGuName,'ADSTM',''),
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(REPLACE([ChaInfo].ChaGuName,'ADSTM','')*1000)
From Inserted
WHERE LEFT(Inserted.ChaGuName,5)='ADSTM'
and [ChaInfo].ChaStRemain>=REPLACE([ChaInfo].ChaGuName,'ADSTM','')
and [ChaInfo].ChaMoney>=REPLACE([ChaInfo].ChaGuName,'ADSTM','')*1000
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='RESETFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain+([ChaInfo].ChaPower+[ChaInfo].ChaDex+[ChaInfo].ChaSpirit+[ChaInfo].ChaStrong+[ChaInfo].ChaStrength),
[ChaInfo].ChaPower=0,
[ChaInfo].ChaDex=0,
[ChaInfo].ChaInt=0,
[ChaInfo].ChaStrong=0,
[ChaInfo].ChaStrength=0,
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(([ChaInfo].ChaPower+[ChaInfo].ChaDex+[ChaInfo].ChaSpirit+[ChaInfo].ChaStrong+[ChaInfo].ChaStrength)*1000)
From Inserted
WHERE Inserted.ChaGuName='RESETSTAT'
and [ChaInfo].ChaMoney>=(([ChaInfo].ChaPower+[ChaInfo].ChaDex+[ChaInfo].ChaSpirit+[ChaInfo].ChaStrong+[ChaInfo].ChaStrength)*1000)
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

Instructions? Just paste it below your trigger BEFORE THE WORD "END"
Your ChaInfo trigger is located at RanGame1>dbo.ChaInfo>Triggers
To use ::


credits?
me for the code
iwarez for structure
tondofear for idea (even if he requests stat adder for control panel he give me this idea)

Reply if effective.
Click to expand...

that updated XD
 
kooldudez

kooldudez

Experienced Elementalist
Joined
Dec 16, 2007
Messages
227
Reaction score
0
Re: [SHARE]Amend Stat Adder/Reset [UPDATED CODE]

@zomer143

how would you manage to run that?

mine, when i use that nothing happens nothing error.

and this is applicable only for the newly created character?
 
kooldudez

kooldudez

Experienced Elementalist
Joined
Dec 16, 2007
Messages
227
Reaction score
0
Re: [SHARE]Amend Stat Adder/Reset [UPDATED CODE]

Update Pls.
 
AnyaAlstreim17

AnyaAlstreim17

Newbie Spellweaver
Joined
Sep 4, 2009
Messages
10
Reaction score
1
Re: [SHARE]Amend Stat Adder/Reset [UPDATED CODE]

Here`s The New And Updated Add Stats

Just Paste It And Execute This !

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[Amend_AddStats] ON [dbo].[ChaInfo]
after update
as
BEGIN

UPDATE ChaInfo SET [ChaInfo].ChaGuName='ADDFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain-REPLACE([ChaInfo].ChaGuName,'ADPOW',''),
[ChaInfo].ChaPower=[ChaInfo].ChaPower+REPLACE([ChaInfo].ChaGuName,'ADPOW',''),
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(REPLACE([ChaInfo].ChaGuName,'ADPOW','')*1000)
From Inserted
WHERE LEFT(Inserted.ChaGuName,5)='ADPOW'
and [ChaInfo].ChaStRemain>=REPLACE([ChaInfo].ChaGuName,'ADPOW','')
and [ChaInfo].ChaMoney>=REPLACE([ChaInfo].ChaGuName,'ADPOW','')*1000
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='ADDFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain-REPLACE([ChaInfo].ChaGuName,'ADDEX',''),
[ChaInfo].ChaDex=[ChaInfo].ChaDex+REPLACE([ChaInfo].ChaGuName,'ADDEX',''),
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(REPLACE([ChaInfo].ChaGuName,'ADDEX','')*1000)
From Inserted
WHERE LEFT(Inserted.ChaGuName,5)='ADDEX'
and [ChaInfo].ChaStRemain>=REPLACE([ChaInfo].ChaGuName,'ADDEX','')
and [ChaInfo].ChaMoney>=REPLACE([ChaInfo].ChaGuName,'ADDEX','')*1000
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='ADDFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain-REPLACE([ChaInfo].ChaGuName,'ADINT',''),
[ChaInfo].ChaSpirit=[ChaInfo].ChaSpirit+REPLACE([ChaInfo].ChaGuName,'ADINT',''),
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(REPLACE([ChaInfo].ChaGuName,'ADINT','')*1000)
From Inserted
WHERE LEFT(Inserted.ChaGuName,5)='ADINT'
and [ChaInfo].ChaStRemain>=REPLACE([ChaInfo].ChaGuName,'ADINT','')
and [ChaInfo].ChaMoney>=REPLACE([ChaInfo].ChaGuName,'ADINT','')*1000
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='ADDFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain-REPLACE([ChaInfo].ChaGuName,'ADVIT',''),
[ChaInfo].ChaStrong=[ChaInfo].ChaStrong+REPLACE([ChaInfo].ChaGuName,'ADVIT',''),
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(REPLACE([ChaInfo].ChaGuName,'ADVIT','')*1000)
From Inserted
WHERE LEFT(Inserted.ChaGuName,5)='ADVIT'
and [ChaInfo].ChaStRemain>=REPLACE([ChaInfo].ChaGuName,'ADVIT','')
and [ChaInfo].ChaMoney>=REPLACE([ChaInfo].ChaGuName,'ADVIT','')*1000
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='ADDFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain-REPLACE([ChaInfo].ChaGuName,'ADSTM',''),
[ChaInfo].ChaStrength=[ChaInfo].ChaStrength+REPLACE([ChaInfo].ChaGuName,'ADSTM',''),
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(REPLACE([ChaInfo].ChaGuName,'ADSTM','')*1000)
From Inserted
WHERE LEFT(Inserted.ChaGuName,5)='ADSTM'
and [ChaInfo].ChaStRemain>=REPLACE([ChaInfo].ChaGuName,'ADSTM','')
and [ChaInfo].ChaMoney>=REPLACE([ChaInfo].ChaGuName,'ADSTM','')*1000
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum

UPDATE ChaInfo SET [ChaInfo].ChaGuName='RESETFINISH',
[ChaInfo].ChaStRemain=[ChaInfo].ChaStRemain+([ChaInfo].ChaPower+[ChaInfo].ChaDex+[ChaInfo].ChaSpirit+[ChaInfo].ChaStrong+[ChaInfo].ChaStrength),
[ChaInfo].ChaPower=0,
[ChaInfo].ChaDex=0,
[ChaInfo].ChaSpirit=0,
[ChaInfo].ChaStrong=0,
[ChaInfo].ChaStrength=0,
[ChaInfo].ChaMoney=[ChaInfo].ChaMoney-(([ChaInfo].ChaPower+[ChaInfo].ChaDex+[ChaInfo].ChaSpirit+[ChaInfo].ChaStrong+[ChaInfo].ChaStrength)*1000)
From Inserted
WHERE Inserted.ChaGuName='RESETSTAT'
and [ChaInfo].ChaMoney>=(([ChaInfo].ChaPower+[ChaInfo].ChaDex+[ChaInfo].ChaSpirit+[ChaInfo].ChaStrong+[ChaInfo].ChaStrength)*1000)
and Inserted.ChaName=[ChaInfo].ChaName
and Inserted.UserNum=[ChaInfo].UserNum


END
Click to expand...
 
B

bheybhee2008

Junior Spellweaver
Joined
Jan 6, 2009
Messages
158
Reaction score
17
Re: [SHARE]Amend Stat Adder/Reset [UPDATED CODE]

thnx it really help....
 
SeiferXIII

SeiferXIII

Legend
Legend
10 Happy Years
Joined
Sep 16, 2007
Messages
1,206
Reaction score
541
Re: [SHARE]Amend Stat Adder/Reset [UPDATED CODE]

@earl
yes. and you really must. because if you have 2 triggers in one database, you might experience some rollback issues..

---------- Post added at 10:54 PM ---------- Previous post was at 10:54 PM ----------

@earl
yes. and you really must. because if you have 2 triggers in one database, you might experience some rollback issues..
 
N

noscire

Newbie Spellweaver
Joined
Dec 21, 2008
Messages
51
Reaction score
12
Re: [SHARE]Amend Stat Adder/Reset [UPDATED CODE]

how do i make the command like /addpow+ ?
 
You must log in or register to reply here.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
414
Guests online
13,539
Total visitors
13,953
Totals may include hidden visitors.

Forum statistics

Threads
429,528
Messages
4,592,708
Members
282,907
Latest member
dawiner1991
Most visitors online was 17251 , on 24 May 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top