管理员
- 积分
- 5703
- 金钱
- 1800
- 贡献
- 3416
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:576 n( [ |9 S+ c. N
Any help "You don't have enough playtime dekaron" when after create character and enter to game ? 7 T& Z* j4 u; }+ f
The query analyzer must be executed in billing% e+ e! l+ F, c) X3 M
SQL
% i; r7 [- K/ B" i* z: H* W& \; s- CREATE TRIGGER [free] ON [dbo].[user_account]9 J& S9 o* m. v, Y/ r
- after Insert
+ C" ~4 f: W# N" | - as' d, M; x4 M. d" S( v* b
- Update [user_account] set
, N9 G2 M3 U: }/ g- ~6 x; n( Y% J. s& y - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-99 k, J: b4 c5 d/ j
- From Inserted" n: ~( O2 M' z( e2 u9 U; \4 `& V6 v
- Where [user_account].user_id=inserted.user_id7 l, B0 V! R$ k1 n6 Y, @
- and [user_account].group_id=inserted.group_id
3 T$ W! n8 q O3 `' |6 Y9 S1 @ - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9" D9 p- L4 A; I$ ~; \" l
- where expire_freetime =2006-1-9
复制代码
6 w2 [3 n. G; h0 x7 U
8 G. x; ^& [& A7 n5 K* }8 q |
|