管理员
- 积分
- 5195
- 金钱
- 1666
- 贡献
- 3086
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
0 J* ~1 s; \0 k6 t6 ~Any help "You don't have enough playtime dekaron" when after create character and enter to game ? ! b X. v, u; g5 @5 I5 z
The query analyzer must be executed in billing
3 v, |/ {! r. e& o, ]: zSQL
' N2 w% P9 ^4 b; u* h Q$ x4 D- CREATE TRIGGER [free] ON [dbo].[user_account]0 I& y( U* ~' h; A
- after Insert
0 j1 L! P7 Z9 I: J4 ?' S0 ? - as% w) y$ F, G- S7 J! |, Z1 f' A
- Update [user_account] set* _& l- T7 B6 V/ }
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9, k0 w3 a# Z" V2 s2 S4 [3 J: w
- From Inserted
) M6 L" _% X0 z: ]: @ - Where [user_account].user_id=inserted.user_id
$ S, v7 O$ `* h) i2 V% \' l - and [user_account].group_id=inserted.group_id' d3 R6 Z7 x$ i
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
2 Q2 `7 B7 F( J N6 _ - where expire_freetime =2006-1-9
复制代码
b; m4 O; d0 t' j+ v/ _- C) V% w! c* H. W+ q+ S4 r" x
|
|