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

EGameol

7 D5 L5 x6 I$ E' J2 C: j
4 \1 z; A2 v9 R: G2 O5 k上线送时间
用查询分析器 必须在billing执行
% a) ^: U# J$ }

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   ! {2 o" S# m* [# o& G7 E
3. as
   
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   : o. h2 X/ k: c. b. l1 k
7. Where [user_account].user_id=inserted.user_id
     D  t2 \7 E5 L/ L; e1 B5 d, m
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

复制代码

上线送商币
用查询分析器 必须在 cash
" h  G- q5 q! P* a

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   # x! I9 \4 E5 e, t5 A3 B
5. From Inserted
   " o. C8 Q/ ~9 W  i% w
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   * u! l- e. j( m+ _; e' v: Q. t4 ~

复制代码

查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码