管理员
- 积分
- 7427
- 金钱
- 2133
- 贡献
- 4749
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57# E6 L% I8 o! h* e0 k4 m
Any help "You don't have enough playtime dekaron" when after create character and enter to game ?
; M3 G; L V4 [! B7 I6 d5 NThe query analyzer must be executed in billing2 J% c5 q7 w3 [& t
SQL
* }1 }0 d' z5 Y( {3 x/ v+ |5 X- CREATE TRIGGER [free] ON [dbo].[user_account]
* B3 J4 q. i8 \# c. {. y$ u+ p Z - after Insert
! e7 c) o& R' U- @, ^% x - as
: W* v }3 ]' T8 ~ D' A - Update [user_account] set+ p- n6 `9 [; f% b' n
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
/ J: ]7 k: S1 E. x" d( v - From Inserted Y8 M; F- ]1 `/ {7 U8 [0 \! C
- Where [user_account].user_id=inserted.user_id8 s1 n3 F* I' H, Q* `
- and [user_account].group_id=inserted.group_id4 A3 e3 a+ f0 a+ H* I* p
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
1 @& t, @' u# M6 F( [) A - where expire_freetime =2006-1-9
复制代码
' G% F* R. T) P3 l8 Q7 C
6 X2 s# ]. x# C |
|