超级版主
- 积分
- 926
- 金钱
- 228
- 贡献
- 599
- 注册时间
- 2023-11-3
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑
. s% K7 a" O0 l( s
' `8 V( |/ Z4 _ U+ E/ \上线送时间
8 j5 H( D& @4 N" P! w2 ?; z用查询分析器 必须在billing执行& s% M; e& I4 F. i" @- d' I' w
- CREATE TRIGGER [free] ON [dbo].[user_account]
/ h. N7 a7 V7 O, r7 b- N K7 a - after Insert
% @& e; _$ `! D2 c - as
( X3 D# a4 t) I5 p - Update [user_account] set
% h% Z: z, l; M. v9 F0 R7 }) }0 Y - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-98 n7 K4 r4 ^" q2 R1 B6 d
- From Inserted
* `9 ~8 v) N w+ J - Where [user_account].user_id=inserted.user_id0 e' R# G3 o2 v3 v
- and [user_account].group_id=inserted.group_id
. B& x- R6 G+ w3 D - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9& Y: a# d" i8 A$ ?( j. U
- where expire_freetime =2006-1-9
复制代码 N, t8 X+ |. |* J
/ M( m0 e: S$ }6 s上线送商币
F3 H; p- K) k( L1 D2 z" h# |用查询分析器 必须在 cash
# B. {4 m9 `4 ^7 I! K
. c% D9 _+ v0 S0 T' P& t" w- CREATE TRIGGER [free] ON [dbo].[user_cash]
3 }7 t2 x u1 y - after Insert
$ N7 w0 f- Z' |% m, j9 l - as
3 s; s- `! v1 r3 C5 G - Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
8 n) [" C) [0 Y/ t2 A - From Inserted
|8 z' h# O8 m( G - Where [user_cash].group_id=inserted.group_id * m+ O4 u9 H+ }4 Z1 f
- and [user_cash].id=inserted.id
7 T+ u7 O* `' e: K" s% x
复制代码
. v9 `0 k4 b0 a$ T
+ u6 a1 n: @/ o查询GM号
^8 U ]& x e1 v$ c0 ~* S4 p- G- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
复制代码
" E' ]" {" D7 k/ y( \4 T
4 x' I# {8 C3 _6 d' Y
+ M x* {4 w! r! y$ Q2 o' W& P
' U; k+ z# }+ h } |
|