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

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57# a' a, U) d6 o* l( J/ H8 @
Any help "You don't have enough playtime dekaron" when after create character and enter to game ? & e8 q( M8 l- O4 Y
The query analyzer must be executed in billing: O: R4 t6 d! D# h- n6 F$ c
SQL
6 J3 U9 ~0 e8 v1 C- O- CREATE TRIGGER [free] ON [dbo].[user_account] h; h1 n1 K8 [& @
- after Insert4 m1 l, }0 u; h+ U& U. d2 o
- as7 }" L) P6 K, _1 z8 g4 d0 a
- Update [user_account] set
$ h5 C8 d7 H3 v( r - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
# e4 k6 m d% r( J6 g) V, v - From Inserted! e0 M5 L& j9 @( u" V- D0 e+ j
- Where [user_account].user_id=inserted.user_id
+ Q |. k" p! }4 ]8 u* S- y - and [user_account].group_id=inserted.group_id
. Z) m0 j, M3 y9 d) [; s; N8 W - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
4 n2 r9 e4 X) s: A2 U - where expire_freetime =2006-1-9
复制代码
- K1 C# ~; C7 e( i9 u8 g: A8 @& \/ W6 N
|
|