挑战上线自动送点卡.商城币.和查询GM号SQL执行语句

EGameol

) Z( t. U  c# k" V; }: t/ o
# p+ B% W0 \. K/ S1 X  A' o上线送时间
1 {% a) |9 h8 y# d" w1 j用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   $ _2 ?) n- J4 A) C* T9 h( V: O
2. after Insert
   
3. as
   % B  t, \6 O* u* g
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   ; b" q; B- ?3 J/ [4 y7 v) v( }& o
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   
8. and [user_account].group_id=inserted.group_id
   
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   9 b+ }& D, k, E9 Z1 y6 W) C1 n
10. where expire_freetime =2006-1-9

复制代码

2 t0 H. b& Y# W+ A. K
上线送商币
用查询分析器 必须在 cash
2 P, j$ H" ^) F7 A6 s: ^/ c+ w

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   ! e" ]. m' \3 M* k
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   7 |4 W* K7 |( v  E
5. From Inserted
   ) o" f0 \" Y& x
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   

复制代码

+ H' [- |0 U3 J; O, ^" A1 l( d查询GM号
: M1 r, F8 a# r5 X) R

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

' b  y) J8 H1 _; x0 U( o

3 i# y7 `/ r! b$ c! G1 o& ?