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

EGameol

/ \% h2 {1 V# b" T" z
8 z7 W% F+ f- ^0 l上线送时间
用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   : ^$ G1 H& I+ J. W) L
2. after Insert
   : g" e* N4 w+ ^% y+ ~8 P" E8 P
3. as
   : h% [3 p9 d3 r% j) o% O& u: r
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
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
   ; _$ M" s2 \( B  K) R. {
10. where expire_freetime =2006-1-9

复制代码

8 q/ s" m5 p6 |7 T: t上线送商币
2 K! t; @; p( N4 z4 L用查询分析器 必须在 cash
+ L* l  d" b$ l1 E  u" d
& A. }' w, m8 m+ n5 i! u; M

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   ! H- L' M8 Q* J. p  F
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   # y  `2 z( O2 g8 B' x6 l
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   - b$ N" S/ }( q" J& O

复制代码

+ u0 s1 c* `1 Z& k查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

5 U( a8 o1 r) q& w' V* q& X
  r' z) S  G6 U' T" [1 y7 }  ]
: V7 W/ w- O+ w% a