管理员
- 积分
- 8040
- 金钱
- 2357
- 贡献
- 5094
- 注册时间
- 2023-11-3

|
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
' v3 { a. H3 O/ U4 QAny help "You don't have enough playtime dekaron" when after create character and enter to game ? $ X# q, s' V+ Q9 l: I9 w
The query analyzer must be executed in billing
8 h. `1 K n5 f" aSQL
6 p& U4 Z5 F K! v- CREATE TRIGGER [free] ON [dbo].[user_account]. ~8 S6 _& Q0 ^4 `2 A! A4 Q" r
- after Insert
" p# j, c* y7 g; J9 v - as. `/ u, e+ ]2 ]( i) e
- Update [user_account] set" |6 X a E6 e0 p8 R
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9% f7 X4 f% _9 D1 U( `# Q$ q# A
- From Inserted
: L7 W7 Q. b- c/ h, ~0 v - Where [user_account].user_id=inserted.user_id; v* ]* n H- T0 f/ j c R
- and [user_account].group_id=inserted.group_id
6 j9 R$ O. J5 o" B5 I - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
2 b3 h6 I6 X+ V6 k - where expire_freetime =2006-1-9
复制代码 " b3 [; d" E; L% r
7 D+ N: V- ?0 T# y- e7 T. c7 P
|
|