管理员
- 积分
- 8422
- 金钱
- 2429
- 贡献
- 5395
- 注册时间
- 2023-11-3

|
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
8 M5 f* [0 _' m- x) f4 BAny help "You don't have enough playtime dekaron" when after create character and enter to game ? " ]) y) d8 i+ h) n
The query analyzer must be executed in billing
# w4 o4 o! M3 GSQL
: z0 E. t# L/ f1 T- CREATE TRIGGER [free] ON [dbo].[user_account]0 c! E+ W' x( M6 L6 H( [0 M2 K
- after Insert
) Z5 W7 D5 j" u! X$ y - as$ `# X, _; t. L% h% f
- Update [user_account] set+ h4 C. B3 U, ~0 z
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
4 ~6 \7 M' {# {0 C5 x - From Inserted& e0 U; e1 _9 U, B/ ]6 f1 E: K* r
- Where [user_account].user_id=inserted.user_id' C) ]4 N5 U9 J' i# ?$ K8 r
- and [user_account].group_id=inserted.group_id
& }; S3 G& L! t. n, A( }1 c - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
3 u+ u$ B! ^* u+ v% | - where expire_freetime =2006-1-9
复制代码 $ v$ S9 l6 G' g! S# Q4 A( D
/ D+ w" m0 v2 L5 Y$ }) Y1 x6 ~ |
|