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

EGameol

1 e& O& i6 m' |3 d, @4 |
% A: G# l! S" C5 |上线送时间
3 W  F, |' e1 \2 k用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   ( W; k1 A8 Z& \! K* e8 H5 a) s: A
2. after Insert
   6 h: z7 F7 Z( J
3. as
   2 c/ N9 R* T; R8 ?9 f& `
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   & ^' I9 o. Q. o/ O
6. From Inserted
   ' d9 F1 I6 Q- k" o% u
7. Where [user_account].user_id=inserted.user_id
   9 E, @( }* G* U% E7 _
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

复制代码

% R! C6 [  w" T8 x- T
上线送商币
用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   : ?" d0 x; {& O8 g6 q! C
3. as
   ' d: {, W8 `2 K9 y
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   3 x3 w& Y  n1 ^! Z) {0 f! r
5. From Inserted
   . h. w2 A( n; e* {% r: z& t! ~( Z  e
6. Where [user_cash].group_id=inserted.group_id
   ) J/ k+ a) g: K+ E" |( Q; C
7. and [user_cash].id=inserted.id
   

复制代码

& v, h" t/ q7 e0 n) u
, {! i* [4 S  K  k$ N查询GM号
# w% D4 u% i7 [% |& B8 Z4 ?

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

( @+ Y+ ?5 b) R4 ?/ G