管理员
- 积分
- 1408
- 金钱
- 621
- 贡献
- 555
- 注册时间
- 2023-11-3
|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
# K( e" @5 I1 U6 F5 C [9 i% {5 {Any help "You don't have enough playtime dekaron" when after create character and enter to game ?
! m/ E1 H7 m: s) X0 hThe query analyzer must be executed in billing* G1 Y* [3 e+ _; m f7 g5 G& W
SQL! L; _ L V9 l- E) H1 l; t4 c* O9 Q
- CREATE TRIGGER [free] ON [dbo].[user_account]
. w; n7 d% t1 n! r9 ~ - after Insert
3 ]4 F: j/ |* ~3 m I - as1 X* g8 p- z) q: t; p
- Update [user_account] set
% y M5 z; k# s( r; c2 Q; L - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
. p X) h! G/ o3 N - From Inserted. Q# E! j c+ u0 k
- Where [user_account].user_id=inserted.user_id
6 J, O3 g) I! a6 I( X0 M - and [user_account].group_id=inserted.group_id
. z+ P R1 j* B$ } - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9+ E2 S: c( S+ f+ P7 F
- where expire_freetime =2006-1-9
复制代码 6 N- ~7 f6 e$ n# h/ c, C
/ k4 ?- I1 F: W4 x- m
|
|