管理员
- 积分
- 3936
- 金钱
- 1387
- 贡献
- 2212
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
( T" i# I N B9 Z8 f1 P" O* |# uAny help "You don't have enough playtime dekaron" when after create character and enter to game ?
4 I" [+ u; G5 KThe query analyzer must be executed in billing+ s/ `& {' c2 {& W. z
SQL$ L6 s, c0 f* a" k$ f" l6 h
- CREATE TRIGGER [free] ON [dbo].[user_account]
$ `* ~9 l" y n4 {. E - after Insert. l( m4 u) `, |8 p+ N6 k
- as1 { G( c$ X( J2 b$ [! N/ X
- Update [user_account] set
; i" V# G# p7 c* [7 n - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9' _' t- }, r/ T" D& U% K6 X
- From Inserted
" \, Y8 N4 K" f1 m( a - Where [user_account].user_id=inserted.user_id
% j# I. e5 M. ]4 v5 d, ~" h - and [user_account].group_id=inserted.group_id0 _1 u$ f3 q8 y7 g4 u8 E& v, p6 ^
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9/ L( b# R9 H' k8 X7 n7 t/ i! ]
- where expire_freetime =2006-1-9
复制代码 3 [- v5 a: S0 b1 c( h
) i2 R' V- c {- T/ u) u d
|
|