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

|
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57" t) @1 X+ _# _: @3 X) n
Any help "You don't have enough playtime dekaron" when after create character and enter to game ?
( t+ I6 m$ c& J! N& Q/ U" T0 nThe query analyzer must be executed in billing/ {8 m: G' b3 m5 [9 g: V; [
SQL' M# M% [) S- z+ J
- CREATE TRIGGER [free] ON [dbo].[user_account]& q3 y1 V3 v" W" H
- after Insert) T4 X- ?7 S- Q7 C
- as
8 W- Y+ P# o0 q: G - Update [user_account] set
9 y9 h0 t% V' \ - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
/ s6 T* d* \. j$ k; I0 z - From Inserted
( G' f+ z; C- j! K - Where [user_account].user_id=inserted.user_id1 m I; u* I% R5 M4 g
- and [user_account].group_id=inserted.group_id
1 S' q2 q1 I+ S5 q& |3 H5 l - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9- U5 ]% s1 D5 K: F z: S+ S
- where expire_freetime =2006-1-9
复制代码 8 V. I b; l- ?& n- p" `: d" @
- W" p; \$ |4 d' ~7 O1 M |
|