管理员
- 积分
- 3845
- 金钱
- 1345
- 贡献
- 2175
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
' u5 }6 J% {/ F/ S# pAny help "You don't have enough playtime dekaron" when after create character and enter to game ?
6 r3 C$ b7 y2 k5 \, ^The query analyzer must be executed in billing: m. }: E5 }/ h5 M$ d
SQL* o8 y4 J7 E" k+ n! s+ N' Q2 z1 y
- CREATE TRIGGER [free] ON [dbo].[user_account]
; A5 `9 N9 Z& g) t" i - after Insert7 P* p& ? ]5 \2 Z1 H
- as
- A( w2 A- p8 m0 p. G. x+ R - Update [user_account] set
% k: ?) R/ u m' J: o9 l/ J9 F$ Y - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-94 k- P3 q2 C1 }6 m; G! E" T
- From Inserted
$ c% i, x2 X U( m! t1 u - Where [user_account].user_id=inserted.user_id8 C" y' p4 O: v" p+ U) p' I
- and [user_account].group_id=inserted.group_id8 l4 i6 s+ {1 [9 u; f$ L& O
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
# t3 P/ u, [, C2 [/ v - where expire_freetime =2006-1-9
复制代码 , I3 i# F( u/ `$ z! B
/ u \( S5 R' |1 j- d |
|