管理员
- 积分
- 6179
- 金钱
- 1868
- 贡献
- 3808
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:572 s) w) |# x: M( D+ o8 e( S
Any help "You don't have enough playtime dekaron" when after create character and enter to game ? ! i' \6 S) U7 v1 z7 R9 `
The query analyzer must be executed in billing& p( C: o" E5 n; Z9 a: Q
SQL
" U I6 p& r, v9 R4 V% \- CREATE TRIGGER [free] ON [dbo].[user_account]
; |8 N; J: ], i6 U: ~ - after Insert6 @, p5 `' H) @/ j$ }
- as% t: r: I! L2 h1 s) E
- Update [user_account] set
; w5 G$ S% T' D* y+ M& @7 a6 G5 x9 N - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
7 ^- w) v8 m1 Q X. i4 {: C - From Inserted0 {6 C3 }7 }( e/ g9 p
- Where [user_account].user_id=inserted.user_id% e. S C$ F8 I' h
- and [user_account].group_id=inserted.group_id
; a3 N- V5 |1 K' P2 ^' i - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
' X7 E4 B9 D7 u( T7 |4 E - where expire_freetime =2006-1-9
复制代码
1 u7 s+ R, ?- ^8 P$ R% u h+ I( O0 Y7 w, P
|
|