管理员
- 积分
- 2388
- 金钱
- 857
- 贡献
- 1262
- 注册时间
- 2023-11-3
|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
( A( J0 G6 D1 c$ sAny help "You don't have enough playtime dekaron" when after create character and enter to game ? / j: C% w# K( ~" }% P1 B
The query analyzer must be executed in billing6 ^ S& \. C- o8 m$ j6 ~! J) L7 y
SQL$ W+ N( p, k8 d+ U+ K K
- CREATE TRIGGER [free] ON [dbo].[user_account]
7 c1 t+ P7 d- O5 U5 F; z% A' x - after Insert
' [+ q0 }+ @7 x6 l8 j3 u# o4 }) U - as
% k6 t. x5 \9 O. [/ c1 W- k* u& c - Update [user_account] set* P9 Q0 h$ R3 i: P) ]8 {
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9) J* M- B. B# {: V/ y, z
- From Inserted
; _# H% S6 M* D4 |! k - Where [user_account].user_id=inserted.user_id& f$ X. s/ X: L6 J0 K- _
- and [user_account].group_id=inserted.group_id
9 z; a5 E" ^1 h - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-97 F" I$ \# H7 o# ^- D7 i) c
- where expire_freetime =2006-1-9
复制代码
) [4 U% U9 G3 p1 m* N) Q5 w% h _# Z. \
. _+ |4 r. I( K( @: P |
|