管理员
- 积分
- 1396
- 金钱
- 621
- 贡献
- 543
- 注册时间
- 2023-11-3
|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:570 S9 D2 r" q: ?% d0 ~$ a
Any help "You don't have enough playtime dekaron" when after create character and enter to game ? * B1 q1 W, ^5 M3 B7 k
The query analyzer must be executed in billing; X$ ~/ O" H, G: U1 H( E
SQL) {& s8 f) s+ L4 ~
- CREATE TRIGGER [free] ON [dbo].[user_account]
/ W" A& w- O+ Z - after Insert# j# E, l/ w2 e0 f$ y, p) ?
- as* o$ j* {" V. t
- Update [user_account] set
1 w4 d+ s ~: v; ?+ v4 N% }/ h - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9" f; f( C% e( C, o: H) {0 i
- From Inserted& n) T% u( \1 [ k
- Where [user_account].user_id=inserted.user_id- m. Q! _7 d9 `2 h% B* Z
- and [user_account].group_id=inserted.group_id
+ Z [$ h4 Q' V$ ^! a. l' j - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9( [$ F9 ], {) j- O
- where expire_freetime =2006-1-9
复制代码
2 o2 e) O& o& w9 K. Q) B
- ?9 _4 A7 ~2 I; j/ W+ ~1 ? |
|