管理员
- 积分
- 7560
- 金钱
- 2182
- 贡献
- 4823
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
( V* a4 Y% p+ yAny help "You don't have enough playtime dekaron" when after create character and enter to game ? ! R& p6 a9 u$ T- s
The query analyzer must be executed in billing
' l W+ L$ {8 rSQL
( K. l6 I% `& O$ Z, N5 s$ s- CREATE TRIGGER [free] ON [dbo].[user_account]4 c; e7 |$ m* {) z
- after Insert$ ~" N9 d' r' i' @/ S9 b; B
- as
8 v' M3 D$ g+ D3 N; I+ G }6 U$ @2 u - Update [user_account] set
' c# K h0 z& n% u; [) g/ a1 } - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9, l. p. }5 u: B
- From Inserted% g* Y1 K7 V, Q& z8 a
- Where [user_account].user_id=inserted.user_id
+ M" x; m7 e4 X' X" c - and [user_account].group_id=inserted.group_id2 c6 {* F# G; S# t+ \
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
* O+ X/ q6 a' U4 q7 L. M: P - where expire_freetime =2006-1-9
复制代码 8 e& M: S- E; w4 f8 _# d a
& N/ f1 h* [- i) [1 \ |
|