管理员
- 积分
- 5277
- 金钱
- 1689
- 贡献
- 3139
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:572 J* r9 B7 c: H
Any help "You don't have enough playtime dekaron" when after create character and enter to game ? 0 _9 E2 l! o6 ^% z) I) e9 E
The query analyzer must be executed in billing" f% l$ W, k0 C `# [
SQL; Q1 x8 X" E; y6 l q% g6 i+ K
- CREATE TRIGGER [free] ON [dbo].[user_account]4 W! v+ @: q' x4 T$ q5 ]4 T: R
- after Insert- J$ k; u9 x$ m$ O+ u2 m4 Z
- as
; |; |0 n4 P0 U - Update [user_account] set. | z) ^' C4 J) g* [
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
" T' s& Z$ n* |2 e- k+ S - From Inserted
) {3 S% _. F, J3 i8 ~, V" X) K8 f( w - Where [user_account].user_id=inserted.user_id0 V, k# n6 v" f- q5 O
- and [user_account].group_id=inserted.group_id
# r7 w* w. k# W! t. U7 K* c - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
5 H) E! r) R" ?* |- j - where expire_freetime =2006-1-9
复制代码 6 \/ _/ |. u+ b* G, c
$ H) V7 E# l8 q
|
|