管理员
- 积分
- 5508
- 金钱
- 1753
- 贡献
- 3283
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
^2 |! i" ]5 }+ s1 w ^# z) |; wAny help "You don't have enough playtime dekaron" when after create character and enter to game ?
( T% x$ V$ k5 K7 g g6 i& rThe query analyzer must be executed in billing; r8 A3 v a4 y; J" P/ Q3 w' _
SQL
/ M1 b# w$ e! l# @( M- CREATE TRIGGER [free] ON [dbo].[user_account]
2 a+ \# R4 P7 C - after Insert
( f& n$ o& I |+ S) F - as
$ v* i" x% G9 z; r - Update [user_account] set
" Q% ?5 R. _4 ?; a. O, o4 v) s - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
+ C; W# R6 R8 s8 K, q4 u: O - From Inserted
$ M6 H8 i" J# ` - Where [user_account].user_id=inserted.user_id
0 T2 H7 G! F# r1 z - and [user_account].group_id=inserted.group_id
3 T# C( @/ ]2 r$ j: T6 H! [( m2 g - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9) e1 E' p" e( L4 c+ Z) a. {! b
- where expire_freetime =2006-1-9
复制代码
; }: ?" X d; J! h2 M
) a3 |! [4 _; U+ {' D* c& U$ m |
|