管理员
- 积分
- 5316
- 金钱
- 1706
- 贡献
- 3150
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
6 d% A/ o' N# ZAny help "You don't have enough playtime dekaron" when after create character and enter to game ? . l3 ]) z4 N: O1 K8 l* |
The query analyzer must be executed in billing$ R) S$ p6 J' w9 @2 E$ x) p
SQL
$ K% T A1 o9 T; C3 ^) A, N- CREATE TRIGGER [free] ON [dbo].[user_account]) u8 U- q* r" Y. v( G3 c
- after Insert
. D/ z, Z& v" R/ q" j5 n7 k( `7 D - as
( ~( O% v. p0 N( O8 W8 \( C9 c - Update [user_account] set% h W4 b3 B( t1 y- X3 }
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
/ Z7 M% q# u/ e: E3 n - From Inserted
2 U4 F7 ^( T5 Q$ b - Where [user_account].user_id=inserted.user_id* m6 C- E. Z: n1 H* A, D
- and [user_account].group_id=inserted.group_id% ?3 R/ S3 ~& U, l# k3 x
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9 `, S1 ^0 i6 \: M& w
- where expire_freetime =2006-1-9
复制代码 + ^" Q2 Z7 U1 k) d
" v, g+ M" _+ p$ ]4 |3 C8 i
|
|