管理员
- 积分
- 5508
- 金钱
- 1753
- 贡献
- 3283
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
7 e0 j, M9 q* }: X9 n) YAny help "You don't have enough playtime dekaron" when after create character and enter to game ? 0 h9 ~0 h( _: Z! d4 s0 F
The query analyzer must be executed in billing# `) L4 c B/ V! }
SQL
3 n$ q b# d' R7 o& o( {- CREATE TRIGGER [free] ON [dbo].[user_account]
5 T& F9 `- ?, ~' _% R5 Y1 V2 x& N - after Insert. V$ }9 _0 x4 q! P7 l$ {6 t# y
- as9 I0 T1 y% R4 Y6 U
- Update [user_account] set
+ q: s2 e9 U9 R! t7 l$ y# f5 h' w - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9- z1 f$ k M; E/ v3 r1 [- b
- From Inserted
* g0 G# P, O! ^, R- `/ I: Y$ Q - Where [user_account].user_id=inserted.user_id
1 E, d7 W) n& F3 C" l - and [user_account].group_id=inserted.group_id
5 u8 F0 U! @2 Z - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
7 L* n- v. F8 G- ?0 K1 H - where expire_freetime =2006-1-9
复制代码
% e% |. \$ Z& Z9 f+ c
( b$ n ]; l4 y9 S2 M+ {- d |
|