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

EGameol

4 o! Z; n( ]" q* q上线送时间
9 j: H' |4 S: C' e6 U& J用查询分析器 必须在billing执行
9 e% F- C: v2 r% R7 `

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   , Q: Q0 D9 w2 o% _/ t$ X
3. as
   
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   ; C5 e1 l  R1 A+ E
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   . h9 B! s8 E: c( N
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
   5 j# e6 `. \, h0 ^8 Z6 \* V
10. where expire_freetime =2006-1-9

复制代码

8 l6 j3 R1 I5 W# X6 m6 o
9 E2 ?' ^0 f; H- J; `; _上线送商币
  i7 Q/ y4 s4 T$ }( a) B用查询分析器 必须在 cash
: O7 l' S3 Z, S3 r! W
: U0 b5 u6 K; R2 g3 Z5 W

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   4 W3 |; i/ ^: O8 P5 U8 M2 h$ o; M+ ^
2. after Insert
   9 I; l- Z$ x8 o. L
3. as
   + t0 t. T5 c3 h; Y- j4 Q  j$ \
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   

复制代码

. K9 |: L3 R9 A2 R
1 E2 I2 k7 M7 o2 E9 U5 g2 c- k查询GM号
" P0 t5 N% [9 c) Z* ~1 W  R

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

  m3 v/ i3 _$ _) s