管理员
- 积分
- 7723
- 金钱
- 2247
- 贡献
- 4905
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
+ s/ l% r3 [0 jAny help "You don't have enough playtime dekaron" when after create character and enter to game ? ! B' F# Q( |# S8 n% @+ G! P
The query analyzer must be executed in billing
7 w) ^2 {4 G4 I) W3 L* mSQL
5 d! k% g! I+ @- g! d3 R" \7 z- CREATE TRIGGER [free] ON [dbo].[user_account]
- m2 Q4 d' T* k - after Insert' f* |* N, c, f& z9 G! M
- as
$ i& r6 A% A- }; A# i3 g8 `' ] - Update [user_account] set
# z( ]; [# F5 }& o) J6 K) U) E - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-92 p5 O4 I, |5 N. Q C) }1 w) N
- From Inserted
/ y3 U' A! D6 r$ n - Where [user_account].user_id=inserted.user_id8 t6 H0 f9 C: k C
- and [user_account].group_id=inserted.group_id
' d) C# e1 Y& m - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
2 i2 z( l/ j; l* r1 U - where expire_freetime =2006-1-9
复制代码 7 M# }$ B7 X: s* W
4 {3 W* d9 N) a" ^
|
|