管理员
- 积分
- 5195
- 金钱
- 1666
- 贡献
- 3086
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
% G) g3 r# J- F$ v6 b( hAny help "You don't have enough playtime dekaron" when after create character and enter to game ?
5 R# {2 X" x. N% gThe query analyzer must be executed in billing! C1 a' ~6 L" K- Z
SQL
9 O0 w. s5 T5 e( A. `( d3 e- CREATE TRIGGER [free] ON [dbo].[user_account]
R+ K! o8 M/ ^* B1 }/ `% Z - after Insert2 S! V" J* T. B" F2 `: w
- as& a. c# F5 c. h# v$ D& G" G& i! \
- Update [user_account] set
9 H. Z. p ]9 x* T* P/ L- f1 r! F9 s - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9' ~- \6 u9 s6 B
- From Inserted) X9 [8 s' E* i+ x0 A) o
- Where [user_account].user_id=inserted.user_id
0 O7 J: n( C: a3 n) R - and [user_account].group_id=inserted.group_id E" s1 v* N) w( u1 d
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
$ K/ p0 |) t, A- h - where expire_freetime =2006-1-9
复制代码 }- d0 v8 c; r: N: a2 g7 ?
% l1 A+ q: K: T" |$ D+ U" k |
|