管理员
- 积分
- 5277
- 金钱
- 1689
- 贡献
- 3139
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57$ C2 |) c3 N4 u! C8 G0 S8 ~' v
Any help "You don't have enough playtime dekaron" when after create character and enter to game ? " v) z3 G1 p& `8 b
The query analyzer must be executed in billing6 W( ]( j, K6 V
SQL
+ ~. k I8 m C4 v5 ?) K- CREATE TRIGGER [free] ON [dbo].[user_account]
- b! [' f3 ]! f8 j/ w7 C& }( R4 T - after Insert
" i% m& Y- b! i, o - as
) C8 `* U! g9 D - Update [user_account] set
1 J; P" G% Y/ t7 v - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
" ^% d7 R" ~3 }. b: S5 v7 p - From Inserted8 `. h& R0 z/ x' Q
- Where [user_account].user_id=inserted.user_id0 w; ~; t4 e, d3 L* h6 w* p x0 f6 K; p
- and [user_account].group_id=inserted.group_id
* b! @% u8 v2 h& H) q - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
7 Y" k8 c* v9 k5 m+ J/ q- | - where expire_freetime =2006-1-9
复制代码 ; U* Y' \, C: I) U7 d4 n
5 U. R; C. A- X. V i. y |
|