管理员
- 积分
- 6846
- 金钱
- 1946
- 贡献
- 4381
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
3 B A7 f4 R$ v wAny help "You don't have enough playtime dekaron" when after create character and enter to game ?
& b# K2 i @" q7 z' G& ]! EThe query analyzer must be executed in billing, L5 m' B" {% b1 _; E$ a
SQL# G. U1 [/ n+ h% @, u% X
- CREATE TRIGGER [free] ON [dbo].[user_account]
/ b: E# Y6 q: |! }9 b - after Insert
7 D% L) I7 t; J2 X - as/ n5 a3 X0 ~ i V2 A! I
- Update [user_account] set
! {$ v! w+ u- e \ - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-91 J1 i/ D$ d# M8 U% [0 A
- From Inserted. T- {# i0 N! M g4 _
- Where [user_account].user_id=inserted.user_id
; ~0 ?3 @, D3 ]: S. _ - and [user_account].group_id=inserted.group_id
: K1 j$ z: A; ]; x u- `4 Y( U U - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-99 N! @2 M7 `% P6 b l0 ]
- where expire_freetime =2006-1-9
复制代码 ) D/ z5 |/ }6 y5 f
2 _ W$ z% F# c% n
|
|