管理员
- 积分
- 6843
- 金钱
- 1944
- 贡献
- 4380
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
) m. q9 y3 ]' D/ NAny help "You don't have enough playtime dekaron" when after create character and enter to game ?
3 b' T/ p9 W$ ]The query analyzer must be executed in billing
1 b; u- J) \/ \& Y) xSQL, y" N3 s8 u% S N/ n$ `9 B
- CREATE TRIGGER [free] ON [dbo].[user_account]
; b% p2 F1 p( r3 h - after Insert
' O$ ^' j9 l" R7 l3 n: Q9 v - as
/ I, f& E1 Z, ~0 D3 y6 I! W9 w$ g - Update [user_account] set
, L0 J& \- s% | - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-96 E3 u V6 d: Q% _1 e
- From Inserted) e% J0 N/ _1 M/ J+ A c6 _5 J1 p
- Where [user_account].user_id=inserted.user_id
0 l" H) R6 X: @* ^+ l0 Q. [" v - and [user_account].group_id=inserted.group_id
( J+ i9 O: M8 e( Z - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9( P* F; y5 |, ?& p* z2 n
- where expire_freetime =2006-1-9
复制代码
% u' M: B. D2 e7 i
2 s l: G: }1 q/ s2 [ |
|