管理员
- 积分
- 1408
- 金钱
- 621
- 贡献
- 555
- 注册时间
- 2023-11-3
|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
9 M1 Z b4 ?% i) H, C! a% D; bAny help "You don't have enough playtime dekaron" when after create character and enter to game ? * j7 q" E& X+ L" o8 O
The query analyzer must be executed in billing: g) u7 G2 \9 W
SQL
: a" ]% U7 M# @, T6 n- CREATE TRIGGER [free] ON [dbo].[user_account]
# K- W* y; x- s$ ~, ]- |, N$ F - after Insert; b0 }' Z7 |. ?+ K5 x. k6 O( f2 [
- as
; x) e3 M6 v6 d( e9 e3 Q, l% ? - Update [user_account] set/ O) ]- Y: V8 X
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
' ]" g! M: Z! g4 N W! i+ t2 F - From Inserted
2 r8 D9 i4 O1 m% F1 a) [ - Where [user_account].user_id=inserted.user_id
0 I. y2 @2 s; r K5 Y; T% `& c - and [user_account].group_id=inserted.group_id0 w7 {' E% a/ [, C1 K
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9 y. w! q7 b4 u, X7 ~. X9 d/ \. }
- where expire_freetime =2006-1-9
复制代码
* p& i7 [1 T; c D, [0 l% K6 A8 M1 Z9 D0 y% f
|
|