管理员
- 积分
- 1408
- 金钱
- 621
- 贡献
- 555
- 注册时间
- 2023-11-3
|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
7 P* j5 t- `4 w$ b4 I1 HAny help "You don't have enough playtime dekaron" when after create character and enter to game ? : s7 d# k* H0 J# y
The query analyzer must be executed in billing
+ H1 s6 |: g! t3 [- V! iSQL* Y4 m- S0 j. i# @$ Z% d) X
- CREATE TRIGGER [free] ON [dbo].[user_account]
& g' e5 g8 _! w5 b8 Y0 ]9 w - after Insert% P; t1 Y P5 c4 j
- as0 k/ Q- r7 _+ B0 y+ [
- Update [user_account] set
; S; a6 B% i% s' X) Z/ a4 G - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9- C% n* v$ n" f
- From Inserted( U3 g8 v# W, [; B( N/ ]2 s
- Where [user_account].user_id=inserted.user_id: I( l6 i2 l: A1 q2 T/ q, T- K
- and [user_account].group_id=inserted.group_id
" G- Y& K, o- k7 v - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
2 H Q8 s4 x( o - where expire_freetime =2006-1-9
复制代码 6 f! {' @ n+ k) q
6 M- p9 R0 I6 p }# ` |
|