Please Give Me !

[TangTangs]

WHO HAVE STAT_LIMIT SCRIPT WITH NO AUTO REBORN
BECAUSE I HAVE REBORN STAGE IN MY CPANEL
I WANT A STAT_LIMIT LIKE
INT = 15K
VIT = 10K
STM = 5K
POW = 15K
DEX = 15K

PLEASE HELP US IM USING THIS CLIENT
>>http://forum.ragezone.com/f528/race-...sassin-942824/<<

[MentaL]

[zHadesVII]

http://forum.ragezone.com/f528/stats...grated-912132/ find sir xhellin comment and try it :)

[Christian1221]

Here:

create trigger [dbo].[statslimit] on [dbo].[chainfo] 
after update as declare @maxpowstats bigint, @maxintstats bigint, 
@maxdexstats bigint, @maxvitstats bigint, @maxstmstats bigint,
@statpenalty bigint

set @maxpowstats  = 25000
set @maxdexstats  = 25000
set @maxintstats  = 25000
set @maxvitstats  = 25000
set @maxstmstats  = 25000
set @statpenalty = 1



update [rangame1].[dbo].[chainfo]
set 
[chainfo].chastremain = [chainfo].chastremain + 
                    (case when inserted.[chapower] >  @maxpowstats then ( case when @statpenalty = 0 then (inserted.[chapower] - @maxpowstats) else 0 end) else 0 end) +
                    (case when inserted.chadex >  @maxdexstats  then  ( case when @statpenalty = 0 then (inserted.chadex - @maxdexstats) else 0 end) else 0 end) + 
                    (case when inserted.chastrong >  @maxvitstats  then ( case when @statpenalty = 0 then (inserted.chastrong - @maxvitstats) else 0 end) else 0 end) + 
                    (case when inserted.chastrength >  @maxstmstats then ( case when @statpenalty = 0 then (inserted.chastrength -  @maxstmstats)  else 0 end) else 0 end) +
                    (case when inserted.chaspirit >  @maxintstats  then ( case when @statpenalty = 0 then (inserted.chaspirit - @maxintstats)  else 0 end) else 0 end)
,[chainfo].chapower = case when inserted.[chapower] >  @maxpowstats  then (case when @statpenalty = 0 then @maxpowstats else (@maxpowstats - @statpenalty) end) else inserted.[chapower] end 
,[chainfo].chadex = case when inserted.chadex >  @maxdexstats  then (case when @statpenalty = 0 then @maxdexstats else (@maxdexstats - @statpenalty) end)  else inserted.chadex end 
,[chainfo].chastrong = case when inserted.chastrong >  @maxvitstats  then (case when @statpenalty = 0 then @maxvitstats else (@maxvitstats - @statpenalty) end)  else inserted.chastrong end 
,[chainfo].chastrength = case when inserted.chastrength >  @maxstmstats  then (case when @statpenalty = 0 then @maxstmstats else (@maxstmstats - @statpenalty) end) else  inserted.chastrength end 
,[chainfo].chaspirit = case when inserted.chaspirit >  @maxintstats  then (case when @statpenalty = 0 then @maxintstats else (@maxintstats - @statpenalty) end) else  inserted.chaspirit end 
from inserted 
where inserted.[chaname] = [chainfo].[chaname] 
and [chainfo].[chaspecial] =0 

[TangTangs]

Here:

create trigger [dbo].[statslimit] on [dbo].[chainfo] 
after update as declare @maxpowstats bigint, @maxintstats bigint, 
@maxdexstats bigint, @maxvitstats bigint, @maxstmstats bigint,
@statpenalty bigint

set @maxpowstats  = 25000
set @maxdexstats  = 25000
set @maxintstats  = 25000
set @maxvitstats  = 25000
set @maxstmstats  = 25000
set @statpenalty = 1



update [rangame1].[dbo].[chainfo]
set 
[chainfo].chastremain = [chainfo].chastremain + 
                    (case when inserted.[chapower] >  @maxpowstats then ( case when @statpenalty = 0 then (inserted.[chapower] - @maxpowstats) else 0 end) else 0 end) +
                    (case when inserted.chadex >  @maxdexstats  then  ( case when @statpenalty = 0 then (inserted.chadex - @maxdexstats) else 0 end) else 0 end) + 
                    (case when inserted.chastrong >  @maxvitstats  then ( case when @statpenalty = 0 then (inserted.chastrong - @maxvitstats) else 0 end) else 0 end) + 
                    (case when inserted.chastrength >  @maxstmstats then ( case when @statpenalty = 0 then (inserted.chastrength -  @maxstmstats)  else 0 end) else 0 end) +
                    (case when inserted.chaspirit >  @maxintstats  then ( case when @statpenalty = 0 then (inserted.chaspirit - @maxintstats)  else 0 end) else 0 end)
,[chainfo].chapower = case when inserted.[chapower] >  @maxpowstats  then (case when @statpenalty = 0 then @maxpowstats else (@maxpowstats - @statpenalty) end) else inserted.[chapower] end 
,[chainfo].chadex = case when inserted.chadex >  @maxdexstats  then (case when @statpenalty = 0 then @maxdexstats else (@maxdexstats - @statpenalty) end)  else inserted.chadex end 
,[chainfo].chastrong = case when inserted.chastrong >  @maxvitstats  then (case when @statpenalty = 0 then @maxvitstats else (@maxvitstats - @statpenalty) end)  else inserted.chastrong end 
,[chainfo].chastrength = case when inserted.chastrength >  @maxstmstats  then (case when @statpenalty = 0 then @maxstmstats else (@maxstmstats - @statpenalty) end) else  inserted.chastrength end 
,[chainfo].chaspirit = case when inserted.chaspirit >  @maxintstats  then (case when @statpenalty = 0 then @maxintstats else (@maxintstats - @statpenalty) end) else  inserted.chaspirit end 
from inserted 
where inserted.[chaname] = [chainfo].[chaname] 
and [chainfo].[chaspecial] =0 

I'LL Try This Wait For My FeedBack Sir :D !