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

EGameol

% F9 {/ z) V0 }. o: I) f4 q' e0 n
, D0 x7 g; w: F. k2 d; J9 p( n上线送时间
! I; A" P7 Z, K- m用查询分析器 必须在billing执行
+ Q: m6 U+ E4 S% j0 B: b) l

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   
3. as
   " E# ^. T$ Q( ?* O, v) {
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   % G9 w. w8 ~" ]: b7 d1 \% G  m
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   5 Y% E$ J3 H( D5 ~+ D5 w0 T+ q. A
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
   
10. where expire_freetime =2006-1-9

复制代码

上线送商币
) [9 o' ?) |/ Z! U/ H5 I, p$ \用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   2 G9 T7 e( s. s' c2 o0 f
2. after Insert
   + p+ i* ]' v; M* j$ b
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   8 m' A1 R5 B% J* T) n0 I9 O6 _
6. Where [user_cash].group_id=inserted.group_id
   + s1 s' i; u1 E" U$ k2 G- V
7. and [user_cash].id=inserted.id
   $ {* A$ l- F6 P  y

复制代码

查询GM号
6 s/ Y+ z! e7 `* D1 G4 ~

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

0 s3 S7 r9 I' |4 W  ]) V  i. D( v
0 p9 e  z/ d2 N8 x' j: ~, i