管理员
- 积分
- 7476
- 金钱
- 2161
- 贡献
- 4765
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
9 l- e ?- F: P# o9 e9 q k1 ~Any help "You don't have enough playtime dekaron" when after create character and enter to game ? 4 j& b9 \) }3 C# E9 A$ X" M
The query analyzer must be executed in billing
: f, n# o# z" C! E7 jSQL
# L7 `- {" U8 R s- CREATE TRIGGER [free] ON [dbo].[user_account]
- A+ T1 @3 p( v% F - after Insert
9 Q! E" p0 e" C) t# K - as$ g0 u* P) \' m
- Update [user_account] set6 Y, w9 T$ U( @' H/ C3 j2 E0 Y1 \
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
; r& U A) o2 z( i9 P) [ - From Inserted
( W0 O3 Q& I; u1 ], A - Where [user_account].user_id=inserted.user_id
9 Q) l$ D( ?: b3 A! q( U - and [user_account].group_id=inserted.group_id
: i: `7 k0 w( C - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
4 D( U7 W. ]; b" S) k V7 O- C - where expire_freetime =2006-1-9
复制代码
1 m" |4 k7 i7 q c, ^9 k& U9 Z) U& C8 V, ^* _
|
|