管理员
- 积分
- 3153
- 金钱
- 1030
- 贡献
- 1819
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
7 g" m5 z, b# N2 W dAny help "You don't have enough playtime dekaron" when after create character and enter to game ?
9 U% \7 N( i5 D% h- M M" wThe query analyzer must be executed in billing
& w' m2 D9 T# ]SQL( Y6 M& l- f; R3 P2 t# R
- CREATE TRIGGER [free] ON [dbo].[user_account]
6 f& J6 @3 m& i. B- {) ` - after Insert
3 i% r5 |6 t" k! i/ X, ?9 {3 l - as
7 A+ P+ P. }4 |1 M- ^1 X8 s - Update [user_account] set9 I/ Y4 O2 j+ |$ n1 z
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
$ y% f- ?: |' x - From Inserted% p' M' z; t y$ B5 a. T: G
- Where [user_account].user_id=inserted.user_id
& Z6 j- X' U: q% s7 Y, P - and [user_account].group_id=inserted.group_id, i$ r, L; i. F% { ?$ k& @
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9 m" S2 Q5 p' M% U
- where expire_freetime =2006-1-9
复制代码
9 N- G5 P# ~3 x$ B/ L( ^0 e
) P' v. r- s$ ] |
|