管理员
- 积分
- 3845
- 金钱
- 1345
- 贡献
- 2175
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
$ K% S: ?* E NAny help "You don't have enough playtime dekaron" when after create character and enter to game ? , L5 a, A' |7 G, ]4 ]7 Y" L
The query analyzer must be executed in billing i4 y# I% `; n% M- x
SQL- N2 ^5 o( x8 {" i# F
- CREATE TRIGGER [free] ON [dbo].[user_account]
4 o& \) o3 H/ [4 l5 {1 g - after Insert
2 n/ D. c0 Y/ p: R% z3 u& t - as
7 V0 c& d% U4 | - Update [user_account] set# P, f" ?7 D1 W
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-94 g+ K* }3 J* a0 \
- From Inserted: E1 e! {$ H7 f1 w
- Where [user_account].user_id=inserted.user_id
: d& C; x6 Z! p5 }& M$ @* W- K5 o% Q/ u - and [user_account].group_id=inserted.group_id+ Q# ~5 ]3 @0 |+ S. G' \3 ~' w
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
1 l8 F5 [" X: T: A8 n9 Z - where expire_freetime =2006-1-9
复制代码 4 T- t- p5 B; M0 n- M# n
/ x! @# H5 J+ [% a6 h4 c% p: D
|
|