管理员
- 积分
- 8040
- 金钱
- 2357
- 贡献
- 5094
- 注册时间
- 2023-11-3

|
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57; A; | \& m' Y- X% h7 P
Any help "You don't have enough playtime dekaron" when after create character and enter to game ? * c) e; e8 R* [
The query analyzer must be executed in billing' A& Y- D3 w/ k; q. f
SQL
0 e6 n* ] |/ S+ X" J) ?2 Q) M- CREATE TRIGGER [free] ON [dbo].[user_account]
2 g, }4 y$ V( Z% N - after Insert* D! `2 N: T: o1 B" h
- as
1 `0 J3 Y; r" Q - Update [user_account] set
, O; _1 S: H- t* I - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
* [6 x. H! t" s! ]6 K% X. u- ^ - From Inserted
6 d0 w2 n; I d* q3 u - Where [user_account].user_id=inserted.user_id! _- z' t- y# X4 u* X
- and [user_account].group_id=inserted.group_id
5 f& {1 `# O" k+ t; I - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9- @9 M( X8 H r; J" @$ E
- where expire_freetime =2006-1-9
复制代码
X. G6 U N) V/ t1 B3 H L+ b# s1 U# F" [" x3 v5 Q1 S
|
|