管理员
- 积分
- 2388
- 金钱
- 857
- 贡献
- 1262
- 注册时间
- 2023-11-3
|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:576 ~7 a/ m; I3 e$ j4 P
Any help "You don't have enough playtime dekaron" when after create character and enter to game ?
5 Z) A" E# k0 w$ d" jThe query analyzer must be executed in billing+ {- y/ A3 Y8 R9 m5 G; ~9 V* {
SQL3 l4 Z$ r% p, N
- CREATE TRIGGER [free] ON [dbo].[user_account]+ E% \, o& ~# L8 a% ~8 f
- after Insert
4 e5 s' g, \) `4 j, B - as
+ }' I* D/ ^% a( J4 g4 E - Update [user_account] set8 t$ F7 m5 m/ @) d8 D8 p
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
8 H- W6 L* @) { - From Inserted+ C" W( T1 Q/ ~* O% r$ s3 h
- Where [user_account].user_id=inserted.user_id6 i0 F1 @& W% p: b6 J V
- and [user_account].group_id=inserted.group_id
7 Q! |- Y- V+ L" i' ~1 W - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9* Q# f! C* G7 {' c0 ?. z! I
- where expire_freetime =2006-1-9
复制代码
# v( e) c0 J9 g& O" A# X
! ^" v t/ @& B: M$ w- W/ R |
|