[Help] Ep7 Stats limit

How to set ep7 max stats limit ?

hahaha

why dont search?already been share ep7 maxstat query to set the value you want

I Already Searched. . And I Already Set But .
if i set like this:
Pow:30k Vit:40k
Dex:30k Stm:15k
Int:30k

(PG NAG ADD STATS AQ NG LAMPAS SA 50k Lumalakas pdn ? nd nag bubug ang stats Bqt Gnun Sir ?)

heres the link http://forum.ragezone.com/f528/stats...les-db-829946/

Use your brain to make it work ! Try this

PHP Code:

---

USE [RanGame1]
GO
/****** Object:  Trigger [dbo].[Stats_Limit]    Script Date: 03/20/2012 04:43:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[Stats_Limit] ON [dbo].[ChaInfo]
after update
as
BEGIN

DECLARE @MaxPow bigint, @MaxInt bigint, 
@MaxDex bigint, @MaxVit bigint, @MaxStm bigint

SET @MaxPow = 30000
SET @MaxDex = 30000
SET @MaxInt = 30000
SET @MaxVit = 40000
SET @MaxStm = 15000

UPDATE [rangame1].[dbo].[ChaInfo]
SET [ChaInfo].ChaPower = CASE WHEN inserted.[ChaPower] > @MaxPow THEN @MaxPow ELSE inserted.[ChaPower] END
,[ChaInfo].ChaDex = CASE WHEN inserted.ChaDex > @MaxDex THEN @MaxDex ELSE inserted.ChaDex END
,[ChaInfo].ChaStrong = CASE WHEN inserted.ChaStrong > @MaxVit THEN @MaxVit ELSE inserted.ChaStrong END
,[ChaInfo].ChaStrength = CASE WHEN inserted.ChaStrength > @MaxStm THEN @MaxStm ELSE inserted.ChaStrength END
,[ChaInfo].ChaSpirit = CASE WHEN inserted.ChaSpirit > @MaxInt THEN @MaxInt ELSE inserted.ChaSpirit END
FROM inserted
WHERE inserted.[ChaName] = [ChaInfo].[ChaName] 


---