管理员
- 积分
- 5125
- 金钱
- 1637
- 贡献
- 3060
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
/ S+ J2 l2 O# w3 Q% h9 V) ~1 R! w2 kAny help "You don't have enough playtime dekaron" when after create character and enter to game ? - V3 Q7 g& _- a6 u1 i# q8 \
The query analyzer must be executed in billing8 @' V7 u$ s0 q, S5 a4 |" N
SQL$ e4 O+ ]1 V2 Z# L6 r
- CREATE TRIGGER [free] ON [dbo].[user_account]# u: V$ i# }' S' r" {3 o
- after Insert; g* @1 G0 C$ g$ _6 V
- as
8 g |8 t% e! v; G - Update [user_account] set
8 M( I8 a$ y! ] - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9 C& \+ |5 @7 ]7 j5 |# ?
- From Inserted
. d# q% t/ ` p+ F6 A5 j& O - Where [user_account].user_id=inserted.user_id3 s- v8 K: A- k! H* v
- and [user_account].group_id=inserted.group_id
+ x5 }. j5 b: o( x# {: \3 S - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
! r- O: J: w. f4 F; y, k8 }, u - where expire_freetime =2006-1-9
复制代码 . K; _6 J t5 _; O E! A& Q
2 z" k' O) C8 f- b. g7 P' @
|
|