管理员
- 积分
- 5593
- 金钱
- 1773
- 贡献
- 3343
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
" J1 M- C9 _6 s Q0 @+ k j7 DAny help "You don't have enough playtime dekaron" when after create character and enter to game ? T3 T4 @' w* E' T! R3 J
The query analyzer must be executed in billing0 l; J% j+ ?4 m, J! Y( |
SQL! W/ ]1 b0 {: \8 ~; X. {
- CREATE TRIGGER [free] ON [dbo].[user_account]
9 t. s, S" d) r H2 W& } - after Insert: y% u& P) \3 z \4 H6 _2 G- g# ~
- as
+ I- m' g$ p; ~ - Update [user_account] set. z2 u8 E1 V" x$ g4 B2 p
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
+ B' [) G4 y$ b: L0 |( \7 [: p, F - From Inserted
5 h! N! g# E! {% b5 j2 w - Where [user_account].user_id=inserted.user_id
& R! i/ g% ^; [6 a# l: p/ b - and [user_account].group_id=inserted.group_id6 @9 b) x6 K9 z4 Q
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
8 Q& J4 r2 J$ T8 H - where expire_freetime =2006-1-9
复制代码 7 w6 t, ~% Y1 o% \
* H! D# U. b( D |
|