管理员
- 积分
- 3156
- 金钱
- 1032
- 贡献
- 1820
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
2 h, r# T2 N( r0 J1 p) l1 P# `Any help "You don't have enough playtime dekaron" when after create character and enter to game ?
6 }8 r% ?9 F3 `+ A' g+ e) bThe query analyzer must be executed in billing
$ v6 ~, X2 s/ u8 R5 f; [: ^SQL
0 n% _8 b& }6 F9 S. z+ j! X- CREATE TRIGGER [free] ON [dbo].[user_account]
/ A# X: o6 x; ?+ w% Z( o - after Insert
1 B" y$ i; H P7 N Z/ M; R0 W - as
^& k& `# D! z6 w' u) z - Update [user_account] set8 g! S; W/ C8 B& i. y
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
7 v% _* g/ I6 N1 Q - From Inserted6 S- _& Y/ Z" w4 N u: ?
- Where [user_account].user_id=inserted.user_id* F: S) T: c5 k, z% P' m- i' J
- and [user_account].group_id=inserted.group_id
$ R) s, V4 M$ x2 U( u- D5 x& c: l - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-91 w$ D+ o) w T3 j
- where expire_freetime =2006-1-9
复制代码 5 j- ?% U% k+ i4 I! T0 Q* t
4 U0 N4 M6 \6 w! ~ |
|