管理员
- 积分
- 6880
- 金钱
- 1946
- 贡献
- 4415
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:571 S2 a: a, ?4 H( G3 q
Any help "You don't have enough playtime dekaron" when after create character and enter to game ?
& l( Y. y+ t% `3 I( I: |$ l, p; GThe query analyzer must be executed in billing, N1 C0 J. J. c( _7 Q1 `
SQL
0 A" {* f' F9 ]* Q7 f N- CREATE TRIGGER [free] ON [dbo].[user_account]
! Q3 b6 T) D' t% R - after Insert
, `! ~6 W5 \- X - as
6 t* O+ C1 u3 ~, A7 a+ T/ H - Update [user_account] set
2 @8 S$ w5 _1 ^6 T3 W$ R7 r - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
) m2 H( E, O% j3 @& w3 m& G - From Inserted
( D; U1 z5 t( g( g; f) V - Where [user_account].user_id=inserted.user_id+ t9 p9 M4 r8 {4 G2 G7 S. r- R
- and [user_account].group_id=inserted.group_id! j7 P) Y: P) e2 h% }9 T- i
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9. j. d) R0 E. H0 d6 P. Y
- where expire_freetime =2006-1-9
复制代码 % [8 R9 M% b/ o0 T8 j
, q$ d9 @, y% \( _5 C4 r
|
|