管理员
- 积分
- 6179
- 金钱
- 1868
- 贡献
- 3808
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
0 T$ `5 [4 ~8 v6 h& w F! F* bAny help "You don't have enough playtime dekaron" when after create character and enter to game ?
$ Y& V4 r$ E' n9 eThe query analyzer must be executed in billing% Z* t1 C7 C4 R
SQL/ r. `) t$ N) V! a7 k; {0 U4 h2 V
- CREATE TRIGGER [free] ON [dbo].[user_account]& z J' x: l h5 D
- after Insert" E p/ x2 Y+ P9 g
- as* A' f0 a6 }; |8 \3 a. W/ @6 C
- Update [user_account] set o) H! P- [# c8 n
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9/ k! T' P: p C
- From Inserted
8 i* G% Y9 B: W/ [" E% u0 R) P* L! D - Where [user_account].user_id=inserted.user_id
/ f9 G6 \( L5 P$ {! X% {% C$ G - and [user_account].group_id=inserted.group_id
3 v5 |' K& n6 I* n3 @ }1 g - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
- }8 Y ~: `6 X/ D9 r7 w - where expire_freetime =2006-1-9
复制代码 ; P6 c- a: q5 f' J9 r7 t+ Z
& J) U" F; U% k& Y# u7 A5 D |
|