管理员
- 积分
- 3153
- 金钱
- 1030
- 贡献
- 1819
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
+ S# O" Z! W$ h2 W, PAny help "You don't have enough playtime dekaron" when after create character and enter to game ?
6 o+ W) w1 W) x; AThe query analyzer must be executed in billing' O! O' o& s1 X: m" f( O7 `3 M
SQL
# S' Z, t- b& U6 \4 W2 n- CREATE TRIGGER [free] ON [dbo].[user_account]; M! J7 ^/ |- S) I
- after Insert% q( a5 h4 y9 N; L8 O: B# R) F7 ?
- as" ~ K* v1 d- ^0 n. z; `$ f5 R
- Update [user_account] set4 E1 h- I* O% a0 ~$ F
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9; M) R, ~) {5 p a
- From Inserted
- n7 w" g8 E; X0 I - Where [user_account].user_id=inserted.user_id: P+ m/ o4 x; D
- and [user_account].group_id=inserted.group_id+ K4 n' A! I( f7 \' s, t( B
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
/ M: T" f% R2 c# ]4 \; _* A - where expire_freetime =2006-1-9
复制代码 4 F; x% m; l1 e& n' }& O
$ C2 C4 X) H5 h- q. G, f3 F |
|